Tag Archives: UDF

AlgLib Spline function update

Posted on 30/06/2010 by dougaj4

Following a question at the AlgLib Forum I have added the Hermite spline fit function to the AL-Spline-Matrix collection. The revised spreadsheet, with full open source code is available for download in 2007/20010 version and pre-2007 version. Typical output of the … Continue reading →

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

More on buckling columns

Posted on 27/06/2010 by dougaj4

Coincidentally, at about the same time as I wrote about column buckling for a column with a point load on the end, Autar Kaw at The Numerical Methods Guy was writing about buckling of columns under self weight, using the theory of … Continue reading →

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

SplineBeam update

Posted on 20/06/2010 by dougaj4

Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths.  This … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

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

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