Category Archives: Maths

Numerical solutions with CSpline

Posted on 05/05/2010 by dougaj4

The CSpline function presented in a previous post  fits a series of cubic polynomial curves to a specified series of points, returning the Y values for listed intermediate X values.  I was recently asked if this could be reversed to … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

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