Soil Bearing Capacity Analysis Calculation Excel Template

Soil bearing capacity analysis determines the maximum pressure a soil can sustain without undergoing shear failure or excessive settlement—critical for safe and economical foundation design. The Excel template integrates classical bearing capacity theories with real-world engineering constraints: it accepts user inputs such as soil cohesion (c), effective friction angle (φ), unit weight (γ), foundation width (B), depth (D_f), and embedment conditions, then computes ultimate bearing capacity (q_u) using modified versions of Terzaghi’s original equation (for strip footings) and extended formulations by Meyerhof and Vesic that account for shape, depth, and inclination factors. The template typically includes built-in validation checks (e.g., φ ≥ 0°, B > 0, D_f ≥ 0), unit consistency safeguards (SI or imperial), and automatic conversion between total and effective stress parameters where pore water pressure is considered. Advanced versions incorporate load eccentricity correction, two-layer soil models, and comparative output tables enabling side-by-side evaluation of multiple footing configurations or soil profiles. Its utility extends beyond calculation—it serves as an educational aid for students, a peer-review checklist for practicing engineers, and a documentation artifact compliant with ISO 19901-3 and ASCE 7-22 reporting requirements.