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

See LatPilePY 1.02 for more details of the spreadsheet content and background.

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

5 Responses to LatPilePY 1.03

  1. Stephen says:

    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

    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.


  2. dougaj4 says:

    Hi Stephen – thanks for letting me know. I’ll change the code so it works if last two rows are selected but blank.


  3. Pingback: LatPilePY 1.04 | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

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

You are commenting using your 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.