Tag Archives: COM624

Daily Download 7: Lateraly loaded pile analysis

Today’s downloads (the last in the Engineering category) are related to the analysis of piles subject to lateral loads: LatPile – Analysis of Lateral Loads on Piles describes the principles of the analysis. Download file: http://interactiveds.com.au/software/LatPile.zip  P-Y Curve function describes function to … Continue reading

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

LatPilePY 1.04

Following comments from Stephen on LatPile 1.03 I have modified the code so that if the specified Soil Properties range includes lines 8 and 9 (for specified effective depths at the top of each layer), but these lines are blank, the effective … Continue reading

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

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

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

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