Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Intersections, interpolations, and rotations
- Continuous beam animations with VBA and Python
- ULS Design Functions 2.13
- Buckling of columns with varying cross section
- Using Excel's shortest functions
- Frame Analysis with Excel - 3, Continuous beam or frame
- Biaxial bending update
Recent Comments
Category Archives: Concrete
Solving the 4 point lift problem …
… with Excel, Python and pyxll. The problem involves the lifting of a precast concrete panel (or any other long thin object) with lifting points at four sections along the length of the panel, and with the load connected to … Continue reading
Posted in Concrete, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 4 point lifting, Excel, Non-linear solvers, precast lifting, Python, PyXLL, SciPy, UDFs
Leave a comment
ULS Concrete design with Python
The py_UMom and py_ULS Design Functions have now been updated and can be downloaded from: py_UMom.zip py_ULS Design Functions More details of the two spreadsheets can be found at Python Code Updates – py_UMom and ULS Design Functions – Python version. The … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Python, PyXLL, py_ULS Design Functions, py_ULSMom, UDFs, ULS bending capacity, ULS concrete design, ULS shear capacity
Leave a comment
Scipy Functions with Excel and pyxll 4 – Solvers 2
Following the previous post I will continue to look at the py_Solvers spreadsheet included in the download file: py_SciPy.zip Details of the required pyxll package (including download, free trial, and full documentation) can be found at: pyxll For those installing a new copy … Continue reading
Posted in Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Find Neutral Axis, Find roots, Numpy, Optimize, Python, PyXLL, SciPy, solvers, UDFs
1 Comment
Python Code Updates – py_UMom
Further to the previous post the py_UMom spreadsheet has now been updated for the latest Python and Numpy versions. The latest version can be downloaded from: py_UMom.zip In addition to the Python code changes, the example of the OptShearCap3600 function … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete, UDF
1 Comment
SectionProperties Release 3
Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Python, PyXLL, sectionproperties
Leave a comment