Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- About Newton Excel Bach
- Stereograms
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Contour plots with Excel and Matplotlib
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving non-linear equations with two or more unknowns – 5
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
Recent Comments
Tag Archives: UDFs
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
Extracting and counting factors with Python and Numba
This post features code using the pyxll add-in to call Python code from Excel. See pyxll for more details and downlod. A recent issue of New Scientist had a series of puzzles finishing with: how many integers between 1 and … Continue reading
Posted in Excel, Link to Python, Maths, Newton, PyXLL, UDFs
Tagged Code speed-up, Count Factors, Excel, Factors, Numba, Python, PyXLL, 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