Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- AS 3600 public comment draft and py_RC Design
- The history of the theory of beam bending - Part 1
- Downloads
- Reinforced concrete elastic analysis; Circular section
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- Reinforced Concrete Section Analysis - 5; Ultimate Limit State
- Reinforced Concrete Section Analysis - 1
- Monte Carlo simulation with Excel and Python
- The history of the theory of beam bending - Part 3
Recent Comments
Tag Archives: Python
Running Fortran from Python with F2PY
The last post looking at using the Python F2Py package said: It is also necessary to install a Fortran compiler. After some trial and error I found that the MinGW (Minimalist GNU for Windows) package worked well. Trying some simple examples … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy
Tagged Anaconda, F2Py, Fortran, MinGW, Python
Leave a comment
xlSciPy – Python SciPy for Excel; Update with new functions
The xlSciPy spreadsheet, previously described here, has been updated with new functions for integration, finding equation roots and maxima and minima, solving systems of non-linear equations, and evaluation of equations entered as text. The new version (including full open-source VBA … Continue reading
Posted in Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Integration, minimization, Python, root finding, SciPy, SciPy.optimize, solvers, UDF, VBA
Leave a comment
Solving non-linear equations with two or more unknowns – 5
This will be the last of the series on solving non-linear equations (for now). Up until now all the examples have had two unknown values, and two target values. This can be extended by making three changes to the code: … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, moment curvature, Newton's Method, Python, SciPy, SciPy optimize function, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
3 Comments
IP2 and IP2_py
The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading
A mystery curve links to Jupyter
Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading
Posted in Charts, Charts, Excel, Maths, Newton
Tagged curve generator, Excel, Jupyter, Maths, parametric curve, Python, Scatter chart
2 Comments