Category Archives: Geotechnical Engineering

LatPilePY 1.03

The LatPilePY spreadsheet has been updated with detailed corrections to the function for generating PY curves.  The updated version can be downloaded from LatPilePY.zip. See LatPilePY 1.02 for more details of the spreadsheet content and background.

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

LatPilePY 1.02

Following some discussion at Eng-Tips and elsewhere I have updated the LatPilePY spreadsheet, previously presented at Lateral pile analysis with PY curves …  This spreadsheet provides User Defined Functions (UDFs) to carry out the analysis of vertical piles under lateral loading, … Continue reading

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

Using LatPilePY

LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles.  It was presented in this post: LatPilePY.  In response to an e-mail request, this post will give step by step instructions for … Continue reading

Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Laterally Loaded Piles and a Safety Device for Walking on Icy Pavements

What do laterally loaded piles: and a safety device for walking on icy pavements: have in common? Apart from their obvious utility, both are the subject of learned papers, freely available at the Virginia Tech Digital Library and Archives, along … Continue reading

Posted in Geotechnical Engineering, Newton | Tagged , | Leave a comment

LatPile update

I have just posted an update to the LatpilePY spreadsheet, fixing a bug in the way in which it read the first row of data from input PY curves, which was resulting in the program failing to run if there were … Continue reading

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