POLEFDN – A excel based construction program for pole foundation analysis

POLEFDN is a MS-excel based spreadsheet program that can be used for making analysis of a pole foundation on the assumption of the application of a inflexible round pier that is supposed free (unrestrained) at the top and exposed to lateral and vertical loads. The spreadsheet particularly makes calculation for the necessary embedment depth, the maximum moment and shear, the plain concrete stresses, and the soil bearing pressures.

This program stands for a workbook that comprises of the following six (6) worksheets:

• Doc - Documentation sheet
• Pole Fdn (Czerniak) - Pole foundation analysis for free-top round piers with PCA/Czerniak method
• Pole Fdn (UBC-IBC) - Pole foundation analysis for free-top round piers with UBC/IBC method
• Pole Fdn (OAAA) - Pole foundation analysis for free-top round piers with OAAA method

• Granular Soil (Teng) - Pole foundation analysis in granular soil with USS/Teng method
• Cohesive Soil (Teng) - Pole foundation analysis in cohesive soil with USS/Teng method

Given below, some useful features of the program :-

This program can deal with both horizontally and vertically applied loads. The vertical load may contain an associated eccentricity that leads to an additional overturning moment to be always assumed to add directly to the overturning moment formed with the horizontal load.

This program guesses that the top of the pier remains at or over the top of the ground surface level.

This program guesses that the actual resisting surface remains at or under the ground surface level. It takes into account any weak soil or any soil that is detached at the top.

The "Pole Fdn(Czerniak)" worksheet guesses that the inflexible pier rotates about a point situated at a distance, 'a', under resisting the surface. The highest shear in pier is supposed to be at that 'a' distance, whereas the maximum moment in the pier is supposed to be at a distance = 'a/2'.

The "Pole Fdn(Czerniak)" worksheet works out the "plain" (unreinforced) concrete stresses, compression, tension, and shear in the pier. The corresponding permissible stresses are also set on the basis of the strength (f'c) of the concrete. It is performed to check whether the steel reinforcing is actually necessary or not. The permissible tension stress in "plain" concrete is supposed to be equivalent to 10% of the value of the permissible compressive stress.

The "Pole Fdn(Czerniak)" worksheet measures the actual soil bearing pressures along the side of the pier at equivalent distances to 'a/2' and 'L'. The relevant permissible passive pressures at those locations are set for comparison.

As all overturning loads are protected with the passive pressure against the embedment of the pier, this program guesses that the pier functions in direct end bearing to withstand only the vertical loading. The bottom of pier bearing pressure is measured that contains the self-weight of the pier, assumed at 0.150 kcf for the concrete.

To download the program, click on the following link www.cesdb.com

POLEFDN – A excel based construction program for pole foundation analysis