Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Time in hours and minutes between two dates
- ULS design of circular reinforced concrete columns
- Cubic Splines
- Deflections and Moments in Rectangular Plates
- Making Finite Element Analysis go faster - Update and PyPardiso
- Reinforced Concrete Design for Circular Sections to Eurocode 2
- Making non-linear FEA with Excel go (much) faster
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Regular Expressions in Excel
Recent Comments
Category Archives: Concrete
SLS Concrete design with Python
I am in the process of converting the SLS design related functions in the RC Design Functions spreadsheet to Python code. The current version can be downloaded from: py_RC Elastic.zip For details of the pyxll app required to conect the … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Circular sections, Excel, moment curvature, Python FEA code, PyXLL, Reinforced Concrete, SLS design functions, UDFs
Leave a comment
RC Design Functions 9.06; Momcurve functions update
The RC Design Functions spreadsheet has now been updated to Version 9.06, and is available for free download from: RC Design Functions9.zip The new version fixes a problem with the MomcurveTS function, which was returning an error for any input … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Excel, MomCurve function, RC Design Functions, RC moment-curvature, Reinforced Concrete, UDFs, VBA
Leave a comment
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
Leave a comment