… and non-linear pile properties.
In previous posts I have presented Excel User Defined Functions (UDFs) to analyse a laterally loaded pile, generate soil PY Curves based on the recommendations in the COM624 Manual, and determine the flexural stiffness of cracked reinforced concrete sections for rectangular and circular sections. I have now combined these into one spreadsheet to provide a convenient and rapid analysis of laterally loaded piles, taking account of both soil and concrete non-linearity.
The spreadsheet includes full open source code, and may be downloaded from LatPilePY.zip.
New features in the functions include:
- Soil PY curves may be automatically generated or externally generated curves may be used
- The pile may be divided into any number of sections, each with either a fixed flexural rigidity, or for circular or rectangular reinforced concrete sections, a calculated rigidity, based on the section properties, applied bending moment and axial load, and the concrete tensile strength and modulus.
- The flexural stiffness of reinforced concrete sections is based on the method specified in Eurocode 2, and includes the effects of tension stiffening, loss of tension stiffening, and shrinkage and creep.
Typical input and output are shown in the screen shots below; further details are given in the spreadsheet.