Tag Archives: UDF

Beam on Elastic Foundations Analysis

Posted on 06/07/2010 by dougaj4

A previous post on laterally loaded piles used a finite difference analysis to analyse the deflections and forces in a vertical pile subject to a lateral load at the top.  An alternative approach to the same problem is presented in “Programming the Finite … Continue reading →

Posted in Excel, Finite Element Analysis, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , | 6 Comments

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