Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- The history of the theory of beam bending - Part 1
- Frame Analysis with Excel 1 - Single beam
- Function roots with the Inverse Quadratic Method
- Frame Analysis with Excel - 4, 2D frame analysis
- Contour plots with Excel and Matplotlib
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Latex Maths Text in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
Tag Archives: two or more objectives
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
Solving non-linear equations with two or more unknowns – 4
As promised in the previous post, the spreadsheet including the new functions to calculate reinforced (or prestressed) concrete moment-curvature with a revised concrete tension stress-block is now available for download from: RC design functions7.zip The spreadsheet includes full open source … Continue reading
Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, moment curvature, Newton's Method, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
Leave a comment