Pole Foundation Design Excel spreadsheet (POLEFDN) - CivilEngineeringBible.com (Download FREE!)

Files > Download Pole Foundation Design Excel spreadsheet (POLEFDN) - CivilEngineeringBible.com (FREE!)

POLEFDN is a spreadsheet program written in MS-Excel for the purpose of analysis of a pole foundation assuming the use of a rigid round pier which is assumed free (unrestrained) at the top and subjected to lateral and vertical loads. Specifically, the required embedment depth, the maximum moment and shear, the plain concrete stresses, and the soil bearing pressures are calculated.

This program is a workbook consisting of six (6) worksheets, described as follows:

• Doc - Documentation sheet
• Pole Fdn (Czerniak) - Pole foundation analysis for free-top round piers using PCA/Czerniak method
• Pole Fdn (UBC-IBC) - Pole foundation analysis for free-top round piers using UBC/IBC method
• Pole Fdn (OAAA) - Pole foundation analysis for free-top round piers using OAAA method
• Granular Soil (Teng) - Pole foundation analysis in granular soil using USS/Teng method
• Cohesive Soil (Teng) - Pole foundation analysis in cohesive soil using USS/Teng method

Program Assumptions and Limitations:

1. Since there is not a universally accepted method for pole foundation analysis, this program offers up five different methods of determining embedment length for pole foundations. The "Pole Fdn(Czerniak)" worksheet is the primary method emphasized in this program, since it provides the most detail in overall analysis. However, it does yield the most conservative embedment depth results of all the methods presented.

2. The references used in the different analysis methods in this program are as follows:

a."Design of Concrete Foundation Piers" - by Frank Randall Portland Cement Association (PCA) - Skokie, IL, May 1968

b."Resistance to Overturning of Single, Short Piles" - by Eli Czerniak ASCE Journal of the Structural Division, Vol. 83, No. ST2, Paper 1188, March 1957

* POLEFDN download link provides freeware version of the software.