Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 5: Frame Analysis
- Linking Excel to C - 2
Recent Comments
Author Archives: dougaj4
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
1 Comment
Solving non-linear equations with two or more unknowns – 3
For the next stage of the non-linear solver saga I am looking at the same problem as in the previous post (finding the curvature or a reinforced concrete section under specified bending moment and axial load), but with more realistic … Continue reading
Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, moment curvature, Newton's Method, solving non-linear equations, tension stiffening, two or more unknowns, UDF, VBA
1 Comment
Solving non-linear equations with two or more unknowns – 2
The previous post presented a simple but slow procedure for solving non-linear equations with two unknowns. In this post I will describe a much faster method, that also has the advantage that it can simply be extended to work with … Continue reading
Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged Exce, moment curvature, Newton's Method, solving non-linear equations, two or more unknowns, UDF, VBA
5 Comments
Solving non-linear equations with two or more unknowns – 1
Newton’s Method is a well known iterative solution for non-linear equations with one unknown. That is, if some value Y depends on a variable X, then we can use Newton’s Method to find X for any given value of Y. … Continue reading
Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Excel, moment curvature, Newton's Method, non-linear equations, two or more unknowns, UDF, VBA
2 Comments
Last chance for Second Chance – 1919 on iView
On line until 19 September 2015 only. But after that listen to the music by Damien Lane