Tag Archives: Excel

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

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

Automating chart scale limits

Posted on 28/04/2010 by dougaj4

Edit 22 Mar 2014:  Also see https://newtonexcelbach.wordpress.com/2012/11/25/automating-chart-scale-limits-update/ for improved version with download link, and example of plotting a chart from a formula entered as text. One of the more annoying things about Excel charts is that if you want to … Continue reading →

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

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