LatPilePY 1.04

Following comments from Stephen on LatPile 1.03 I have modified the code so that if the specified Soil Properties range includes lines 8 and 9 (for specified effective depths at the top of each layer), but these lines are blank, the effective depths are calculated by the program, rather than being set to zero.  The revised files may be downloaded from, including full open source code.

The spreadsheet provides User Defined Functions to carry out the analysis of vertical piles under lateral load, following the methods described in the COM624 Manual.  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.

12 Responses to LatPilePY 1.04

  1. Pingback: Daily Download 7: Lateraly loaded pile analysis | Newton Excel Bach, not (just) an Excel Blog

  2. Khaled says:

    Could you please consider including option for ‘Weak Rock’ as per COM624 Manual as well. Next update could be fixed headed pile.


  3. g2-9ed9acc685824c6663c51c5b093476cc says:

    I continue to struggle with using LatPile, in that for some reason there is a combination of total segment length and segment division that causes the function to “blow up.” I’m not sure what the pattern is, though I’m sure if I messed with it enough I could figure it out.

    Have you noticed this yet?

    Is there a fix or workaround?


  4. cumfy says:

    Thanks for your work on this.
    I’m just trying to get started using OpenOffice, but am getting a lot of #MACRO? errors.
    Any ideas if there is a workaround ?
    Also is it going to be straightforward to specify a steel only tubular pile ?


  5. dougaj4 says:

    cumfy – As far as I know OpenOffice will not run VBA, so the spreadsheet won’t work. Unfortunately the object model in OpenOffice Basic is very different to VBA, and converting all the macros would be a difficult job.

    Steel piles should be no problem though. Just specify the diameter and stiffness.


  6. Frank says:

    Hi Doug, Thank you very much for this spreadsheet and the VBA that runs it!
    I noticed that we have strange results when the density of a layer is reduced due to the presence of groundwater. I have so far been using the effective density of the soil for the SoilData table. I usually split the layers at the groundwater table so I can input the correct densities above and below this line.
    When this is done in a granular layer with otherwise consistent properties (phi and Ki constant), the soil resistance actually increases immediately below the groundwater table. It seems this happens because the effective depth is based on the effective vertical stress divided by the much lower density of the water-bearing layer. This results in artificially high soil resistance values, in my opinion. I have reviewed your code to see if I could add a “cap” on the effective depth where this is the case (so I could limit the effective depth to the actual depth where this occurs), but this does not match the COM624P results. I think I get the best match for these soil parameters when I input the total density of the soil rather than the effective density. Is this how you intended the input to work? Does the program subtract out the weight of the water?


  7. dougaj4 says:

    Frank – thanks for the feedback.
    I’ll have to do some investigation. I’ll et back to you as soon as I have an answer.


    • Frank Voss says:

      Hi Doug, If it helps I can send you the input information where I discovered the behavior. For this location I had sand over clay with the water table about halfway down the sand. I think that should give you a similar response.

      Frank Voss, S.E. (Illinois) GRC Engineering, Inc. 5544 W 147th Street Oak Forest, Illinois 60452 Ph: 708-489-0400 Fx: 708-489-9380


  8. Brian Dolan says:

    I cannot find an option to allow for fixed pile heads to be used in the spreadsheet. Am I missing something? If not, is there an easy way to include this?


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 )

Twitter picture

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