Category Archives: Maths

Using the AlgLib ODE (Runge-Kutta) Solver with Excel

Posted on 18/06/2010 by dougaj4

Or to be more correct, the AlgLib Cash-Karp Solver, Cash-Karp being a refinement of the Runge-Kutta method of solving ordinary differential equations. Solution of differential equations is an iterative process requiring the repeated application of the solver routine followed by evaluation of … Continue reading →

Posted in AlgLib, Beam Bending, Differential Equations, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 8 Comments

Elegant solutions, Simple Harmonic Motion, and the hole through the middle of the Earth

Posted on 14/06/2010 by dougaj4

No, not the hole (beloved of conspiracy theorists everywhere) where our alien overlords keep their UFO’s, but rather the equally imaginary hole from Pole to Pole (beloved of physics teachers everywhere) where we can drop in objects and watch them travel … Continue reading →

Posted in Differential Equations, Maths, Newton | Tagged , , , | 5 Comments

AlgLib Spline Functions

Posted on 07/06/2010 by dougaj4

Following earlier posts on cubic splines I have collected the Alglib interpolation routines, and the necessary supporting routines, and written interface functions to allow most of the 1Dspline routines to be called from the spreadsheet.  Since there is a large measure … Continue reading →

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

New Links

Posted on 30/05/2010 by dougaj4

I have added some new links to Excel Blogs that are regularly updated with new and different content, plus one new maths blog. Bacon Bits: Delicious pieces of Excel and Access training brought to you by DataPigTechnologies.com Contextures Blog: The Contextures … Continue reading →

Posted in Excel, Maths | Tagged , , , | Leave a comment

Compiled AlgLib Matrix Functions for Excel

Posted on 27/05/2010 by dougaj4

This post describes a series of matrix functions compiled from the AlgLib library code (covered in previous posts) as a dll that can be called from Excel VBA, and used as User Defined Functions (UDFs).  A spreadsheet containing the necessary VBA … Continue reading →

Posted in Arrays, Excel, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 18 Comments