Category Archives: Geotechnical Engineering

Lateral pile analyis with PY curves …

… 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

Beam on Elastic Foundations Analysis

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

P-Y Curve function

The pile lateral load analysis program presented in a previous post used linear elastic spring supports to model the restraint provided by the soil.  Soil stress/strain behaviour is of course highly non-linear, and this post presents an Excel User Defined Function … Continue reading

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

Update to Publications

I have (at long last) updated my list of publications (all downloadable). Click on the link below to visit the site, or download direct from the list here. My Publications Here is the current list:     Predicting the Deflection … Continue reading

Posted in Arch structures, Concrete, Geotechnical Engineering, Newton | Tagged , , , , | Leave a comment

LatPile – Analysis of Lateral Loads on Piles

This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles subject to horizontal loads, using the same approach as employed in the DOS program COM624. A spreadsheet including the UDF and an on-spreadsheet … Continue reading

Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 11 Comments