An XLS built in kN/m that is fed data in kg/cm will fail. Ensure your sheet has unit conversion helpers.
The spreadsheet checks if the ground can support the crane. Assuming an eccentric load, the pressure distribution is calculated:
$$ q = \fracNA \pm \fracM \cdot yI $$
Where:
The maximum calculated pressure ($q_max$) must be less than the allowable bearing capacity ($q_all$).
While powerful, an XLS-based design has inherent risks:
| Limitation | Mitigation Strategy | | :--- | :--- | | Formula errors | Cross-check with hand calculations for first use; lock cells to prevent accidental edits. | | No 3D soil-structure interaction | Verify with geotechnical engineer for layered soils or water table. | | Dynamic effects (hoisting impact) | Apply dynamic load factor (e.g., 1.25× static load) in input cells. | | Wind code updates | Update wind pressure tables annually from ASCE 7 or EN 1991-1-4. | Tower Crane Foundation Design Xls
A robust Tower Crane Foundation Design Xls requires specific input parameters. If your spreadsheet does not ask for these, throw it away.
A professional-grade Tower Crane Foundation XLS includes the following automated sections:
Why use an Excel spreadsheet instead of manual calculations or expensive FEA software? An XLS built in kN/m that is fed data in kg/cm will fail
1. Dynamic Load Combination Engine (EN 14439 or equivalent)
2. Automatic Anchor Bolt Tension vs. Concrete Breakout (ACI 318-19 / EC2)
3. "What-If" Sliders for Soil Settlement The maximum calculated pressure ($q_max$) must be less