Category Archives: VBA

Lateral pile analyis with PY curves …

Posted on 17/07/2010 by dougaj4

… and non-linear pile properties. In previous posts I have presented Excel User Defined Functions (UDFs) to analyse a laterally loaded pile, generate soil PY Curves based on the recommendations in the COM624 Manual, and determine the flexural stiffness of cracked … Continue reading →

Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 17 Comments

The hole through the middle of the Earth – revised transit time

Posted on 08/07/2010 by dougaj4

In the previous post in this series I produced a table of acceleration due to gravity against depth from surface, based on the four layers of the Earth (Crust, Mantle, Outer Core, Inner Core), assuming a constant density for each layer.  … Continue reading →

Posted in Differential Equations, Excel, Newton, UDFs, VBA | Tagged , , , , | 3 Comments

Update to CHSplineA Function

Posted on 07/07/2010 by dougaj4

I have recently corrected the CHSplineA function included in the CSpline2 spreadsheet.  The earlier version was returning incorrect values for the slope and curvature of the spline (with output option 2), if the spacing of the points defining the spline … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

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