A professional-grade spreadsheet should align with industry benchmarks like the CIRIA C761D Guide
When programming or using a design spreadsheet, engineers follow a strict sequence of calculations:
Ensure every project follows the same rigorous check-list.
Designing a tower crane foundation is a high-stakes engineering puzzle where the "Overturning Moment" is the boss level
Easily export the sheet to PDF for submission to local building authorities. If you'd like to build this out further, let me know: What crane model are you designing for? Tower Crane Foundation Design Xls
): Extreme wind shear acting on the entire projected surface area of the crane. 3. Foundation Typologies
Lack of version control can lead to using outdated or unverified design standards.
Bearing pressure is not enough. An advanced XLS includes immediate settlement (elastic) and consolidation settlement (clay soils) using Schmertmann or Hough methods.
FOSslide=μ⋅VtotalH≥1.50cap F cap O cap S sub s l i d e end-sub equals the fraction with numerator mu center dot cap V sub t o t a l end-sub and denominator cap H end-fraction is greater than or equal to 1.50 is the friction coefficient between concrete and soil. Summary of Design Validation Checks ): Extreme wind shear acting on the entire
q=PA±MZq equals the fraction with numerator cap P and denominator cap A end-fraction plus or minus the fraction with numerator cap M and denominator cap Z end-fraction = Total vertical load (Crane + Foundation + Soil) = Area of the foundation ( = Total moment at the base = Section modulus of the foundation base The spreadsheet must check that
Select rebar diameters and spacings that satisfy the required steel area ( Ascap A sub s
Using a specialized tower crane foundation design XLS template provides several advantages over manual calculations:
| # | Check | Method / Code Reference | |---|-------|--------------------------| | 1 | (service) | ( P/A \pm M_x/Z_x \pm M_y/Z_y ) – all corners < allowable | | 2 | Overturning stability | Restoring moment / Overturning moment ≥ 1.5 (EN 1997) or 2.0 (some codes) | | 3 | Sliding stability | Friction + passive resistance / Horizontal load ≥ 1.5 | | 4 | Uplift check | Net upward pressure at any point = zero (or tension permitted with anchors) | | 5 | Reinforcement design | Flexural reinforcement (top & bottom) per EC2 or ACI 318 | | 6 | Punching shear | Around anchor bolts and mast plate | | 7 | Anchor bolt tension | Bolt group resistance + concrete breakout (ACI 318 Appendix D / EN 1992-4) | Bearing pressure is not enough
Often the silent killer. Even an out-of-service crane must withstand regional gust factors. 3. Soil Bearing Capacity: The Hard Truth
The project avoided a soil failure. The XLS took 4 minutes to run. Manual recalculation would have taken 3 hours and likely missed the eccentricity check.
Allowable soil bearing capacity, soil density, friction angle, and groundwater table depth. Material Properties: Concrete compressive strength ( fc′f sub c prime ) and steel reinforcement yield strength ( Stability Calculations
An industrial-grade is typically divided into four functional modules: Sheet Tab / Section Input Elements Outputs & Validations 1. Crane Data & Loads