Category Archives: Newton

Installing AlgLib with Excel VBA

Posted on 20/05/2010 by dougaj4

In a previous post I linked to the AlgLib site which has an extensive range of mathematical routines available in VBA, c/c++ and pascal.  I have recently been experimenting with these (in reponse to a thread at the Eng-Tips forum), and will … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 13 Comments

Cubic Hermitic and Cardinal Splines

Posted on 14/05/2010 by dougaj4

In my previous post on splines I described a quick and dirty approach to adjusting a cubic spline to fit monotonic data, which did not meet with universal approval, so I have followed up Mike Woodhouse’s link: (http://en.wikipedia.org/wiki/Monotone_cubic_interpolation) which gives a … Continue reading →

Posted in Charts, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 8 Comments

Using Cubic Splines in Practice

Posted on 06/05/2010 by dougaj4

I recently had an interesting query from Georg,  a geography student in Germany regarding the use of cubic splines to fit a smooth curve to experimental data.  The graph he sent me is shown below: The cubic spline has produced … Continue reading →

Posted in Charts, Excel, Maths, Newton, UDFs | Tagged , | 9 Comments

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

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