Tag Archives: Cubic splines

Cubic splines with horizontal data

Posted on February 16, 2014 by dougaj4

Following a request here I have modified my cubic spline functions to accept input arranged  in rows as well as columns.  By default the output arrays will have the same orientation as the range of interpolation X values, but I have also added … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 1 Comment

Daily Download 13: The ALGLIB maths library and Excel

Posted on September 30, 2012 by dougaj4

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip   http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading →

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 7 Comments

Daily Download 4: Continuous Beam Analysis

Posted on September 20, 2012 by dougaj4

Today’s download files contain several alternative functions for analysing continuous beams. The most flexible is the ConBeamU spreadsheet, which in addition to the continuous beam function also contains functions for single span beams and cantilevers, and for fixed end moments and … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 15 Comments

Spline Interpolation Alternatives

Posted on September 4, 2011 by dougaj4

A recent post at Jon Peltier’s Blog looks at an “on-sheet” method of performing linear interpolation on a set of tabular data, and the following comments include a number of alternative ways of carrying out the same process, and also some … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 7 Comments