Tag Archives: two or more unknowns

Solving non-linear equations with two or more unknowns – 5

Posted on 20/10/2015 by dougaj4

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 , , , , , , , , , , , , | 3 Comments

Solving non-linear equations with two or more unknowns – 4

Posted on 13/10/2015 by dougaj4

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 , , , , , , , , | 1 Comment

Solving non-linear equations with two or more unknowns – 3

Posted on 08/10/2015 by dougaj4

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 , , , , , , , | 1 Comment

Solving non-linear equations with two or more unknowns – 2

Posted on 03/10/2015 by dougaj4

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 , , , , , , | 5 Comments

Solving non-linear equations with two or more unknowns – 1

Posted on 30/09/2015 by dougaj4

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 , , , , , , , | 2 Comments