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 LatPilePY.zip, 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.
Newton Excel Bach, not (just) an Excel Blog 
Pingback: Daily Download 7: Lateraly loaded pile analysis | Newton Excel Bach, not (just) an Excel Blog
Could you please consider including option for ‘Weak Rock’ as per COM624 Manual as well. Next update could be fixed headed pile.
LikeLike
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?
LikeLike
I hadn’t noticed this.
If you could send an example to my gmail account (dougaj4) that would be helpful.
LikeLike
Hi,
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 ?
LikeLike
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.
LikeLike
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?
Thanks,
Frank
LikeLike
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.
LikeLike
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
http://www.grceng.com
LikeLike
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?
LikeLike
There is nothing built in, but it shouldn’t be too difficult to add something. I will have a look when I have time.
LikeLike
Cool. I didn’t expect a reply so soon when the last thread entry was 6 years ago, so thanks. Great website BTW.
LikeLike