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
Newton Excel Bach, not (just) an Excel Blog 
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.
LikeLike
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.
LikeLike
I’ve heard you can put windows on Mac as an additional operating system that should do the trick for you!
LikeLike