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.

About these ads
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:

    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.

    Like

    • dougaj4 says:

      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.

      Like

      • Stephen says:

        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.

        Like

  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.

    Like

  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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s