When it comes to designing deep foundations, one of the most important tasks is determining the load-carrying capacity of piles. The American Association of State Highway and Transportation Officials (AASHTO) provides comprehensive guidelines for evaluating pile capacity, ensuring that structures such as bridges, flyovers, and high-rise buildings rest on safe and reliable foundations.
What Is Pile Capacity?
Pile capacity is the maximum axial load — combining skin friction along the shaft and end bearing at the tip — that a pile can transfer safely to the surrounding soil without excessive settlement or shear failure. AASHTO's methodology distinguishes between the ultimate (nominal) resistance of a pile and the factored resistance available for design, applying resistance factors that reflect the reliability of the capacity method used, the quality of the geotechnical investigation, and the level of construction control (static load test, dynamic testing, or wave equation analysis).
What This Excel Sheet Calculates
- Ultimate skin friction resistance using the Alpha (α) method for cohesive soils and the Beta (β) method for cohesionless soils
- End bearing resistance derived from SPT N-values or soil shear strength at the pile tip
- Allowable pile capacity after applying the selected factor of safety or LRFD resistance factor
- Group efficiency reduction for closely spaced pile groups in a pile cap
- A summary table of capacity versus pile diameter and embedment depth for quick comparison
Design Inputs Required
- Pile type and diameter (driven pile, drilled shaft, or auger-cast pile)
- Embedment or penetration depth
- Soil profile — SPT N-values or undrained shear strength (Su) by layer
- Unit weight of each soil layer
- Depth to the water table
- Target factor of safety or LRFD resistance factor
Applicable Design Codes
The calculations follow the AASHTO LRFD Bridge Design Specifications approach to deep foundation design, cross-referenced against the static analysis methods for driven piles and drilled shafts commonly cited in FHWA geotechnical design manuals.
Who Should Use This Tool
This sheet is built for bridge and structural engineers sizing pile foundations for abutments, piers, and heavily loaded structures, as well as geotechnical engineers who need to cross-check capacity estimates against borehole data before committing to a static load test program.
Download the Free AASHTO Pile Capacity Sheet
Sizing piles by hand across multiple soil layers and pile diameters is slow and easy to get wrong. This spreadsheet automates the skin friction and end bearing calculations so you can compare options quickly and focus your time on the geotechnical judgment calls that actually need it. Download the free Excel sheet above and use it as a starting point for your next foundation design.
Be the first to comment.