Category Archives: Newton

Reinforced concrete elastic analysis; Circular section

Posted on 24/04/2010 by dougaj4

Previous posts have presented the theoretical background to finding stresses and strains in a reinforced concrete section built up of trapezoidal layers and subject to combined bending and axial loads.  A spreadsheet with User Defined Functions (UDFs) and open source code … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

Calling a function as a variable – another example

Posted on 22/04/2010 by dougaj4

The recent posts on the Inverse Quadratic Method and Brent’s Method, and on calling a function as a variable, are leading towards a user defined function (UDF) to analyse circular reinforced concrete sections under combined bending and axial load, but since … Continue reading →

Posted in Concrete, Excel, Maths, UDFs, VBA | Tagged , , , , , | 3 Comments

The Inverse Quadratic Method 3 – Brent’s Method

Posted on 13/04/2010 by dougaj4

The previous post in this series presented iterative methods to solve polynomial equations using direct or inverse quadratic interpolation.  These methods have two disadvantages: In some circumstances the function may converge very slowly, or not at all. The name of … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , , | 12 Comments

Calling a function as a variable

Posted on 08/04/2010 by dougaj4

The functions described in recent posts provide iterative solutions to polynomial equations, but the same method can be used for any equations that can be evaluated numerically and have a single variable.  The question then is, how can we call a … Continue reading →

Posted in Arrays, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 6 Comments

The Inverse Quadratic Method – 2

Posted on 04/04/2010 by dougaj4

Firstly a clarification from the previous post in this series.  The method presented in that post was a direct application of quadratic interpolation, rather than the inverse quadratic method, as implied by the post title.  The inverse quadratic method will be … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 3 Comments