AnaIysis of a Pole Foundation spreadsheet
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
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
