Category Archives: Newton

Analysis of RC circular sections – theory and code

Posted on 25/04/2010 by dougaj4

The basic tasks involved in analysing the stresses and strains in a reinforced concrete section under combined bending and axial load are: Assuming a horizontal beam with the top of the beam in compression and the bottom in tension Find … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

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