A well-designed spreadsheet will produce a summary like the following:
| Parameter | Calculated Value | Allowable Limit | Status | | :--- | :--- | :--- | :--- | | Max Soil Bearing Pressure | 185 kPa | 200 kPa | OK | | Overturning Safety Factor | 1.72 | ≥1.50 | OK | | Sliding Safety Factor | 2.10 | ≥1.50 | OK | | Required Rebar (Top) | 1,250 mm²/m | 1,200 mm²/m | OK | | Punching Shear Stress | 0.62 MPa | 0.75 MPa (φVc) | OK |
Leading manufacturers now provide Excel-based design wizards. You input your soil data; the XLS outputs a drawing. These are gold standard because the crane load data is hard-coded and correct. Tower Crane Foundation Design Xls
The most interesting cell logic in the sheet would be a Traffic Light System for the "No Uplift" condition.
A robust spreadsheet shouldn't just be a "black box." It needs to clearly verify the following limit states: A well-designed spreadsheet will produce a summary like
1. Soil Bearing Pressure (SLS - Serviceability Limit State) The most common failure point. Your spreadsheet must calculate the maximum corner pressure under the crane’s maximum load case.
2. Overturning Stability The crane acts like a lever. The wind load and load moment try to tip it over; the self-weight of the foundation and the ballast try to keep it down. The most interesting cell logic in the sheet
3. Sliding Resistance Often overlooked but dangerous. Horizontal forces from the crane (slewing, wind, or trolleying) can push the foundation block.
4. Structural Integrity (Rebar Design) The concrete block itself acts as a cantilever. Your Xls needs to calculate the required bending reinforcement (top and bottom) based on the pedestal pressure or soil uplift.
What separates a messy worksheet from a professional Tower Crane Foundation Design Xls? It must contain the following interconnected modules.