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 return non-linear “P-Y” curves, describing soil load-deflection behaviour, based on the manual for the program COM-624.
Download file: http://interactiveds.com.au/software/PY-COM624.zip

Beam on Elastic Foundations Analysis describes a more refined analysis of members with soil support, that can be used for both laterally loaded piles and beams on elastic foundations.
Download file: http://interactiveds.com.au/software/LatPileB.zip

The latest version of the LatPilePY spreadsheet is described at: LatPilePY 1.04
Download file: http://interactiveds.com.au/software/LatPilePY.zip

PY Curve function output

LatPileB input and output

Latest version compared with COM624 program output

This entry was posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

3 Responses to Daily Download 7: Lateraly loaded pile analysis

  1. andyrich says:

    Hi, this appears to be a nice spreadsheet, but unfortunately it is not opening for me properly. I am on a mac, so that may be the issue. I have tried excel for mac 2011, numbers and open office, and non seem to properly open the output.


    • dougaj4 says:

      The spreadsheet needs VBA, so Numbers and Open Office definitely won’t work.

      Excel for mac 2011 has VBA, so I don’t know why that isn’t working. Unfortunately I don’t have access to a mac, so I’m not in a position to investigate it.

      If anyone else has a solution, I ‘d be glad to hear from you.


  2. Ray says:

    I’ve heard you can put windows on Mac as an additional operating system that should do the trick for you!


Leave a Reply to Ray Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.