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.
Recent Comments
Newton Excel Bach, not (just) an Excel Blog 
Doug,
I am attempting to upgrade from the Brinch Hansen method for lateral pile capacity (an ultimate method that gives no indication of pile deflection) to your LatPilePY spreadsheet. For my first attempt, I have tried the example given in Brinch Hansen’s paper
(http://www.geo.dk/media/4903/geo.dgi.bulletin.no.12.pdf).
If I enter the soil as a single layer (i.e. a 5m void above the 5.4m sand layer), I get believable results.
However, if I subdivide the sand layer (say 3 no. 1.8m layers with the same properties for all layers), the deflections increase significantly. Inspecting the output, I find that the spring force returns sharply to (almost) zero at the top of each arbitrary soil layer division. I have left both ‘Layer Top Effective Depth’ parameters blank when getting these results.
To get the same results as the single-layer case, I need to enter the ‘Layer Top’ values manually, whereas your LatPilePY 1.02 post sounds as though this should have happened automatically. Am I doing something wrong? Happy to email you my spreadsheet if needed.
LikeLike
Stephen – I’ll try and have a look at it this evening. If you could send your spreadsheet to dougaj4@gmail.com that would be helpful.
LikeLike
Error found. I didn’t exclude rows 27 & 28 from the LatPile UDF parameters (in cell C85) when I left them blank. Works fine with the layered soil when used properly.
LikeLike
Hi Stephen – thanks for letting me know. I’ll change the code so it works if last two rows are selected but blank.
LikeLike
Pingback: LatPilePY 1.04 | Newton Excel Bach, not (just) an Excel Blog