Which does your jurisdiction require? (e.g., ACI, Eurocode, or AS3600)
: Foundation design requires professional engineering expertise . Never rely solely on an unverified spreadsheet for construction without a signature from a licensed Professional Engineer (PE).
Complete Guide to Tower Crane Foundation Design and Excel Spreadsheet Analysis
A well-designed .xls tool typically generates a printable report including: Tower Crane Foundation Design Xls
): Extreme environmental wind loads (e.g., a 50-year or 100-year storm event) acting on the structure. The crane is allowed to weather-vane to reduce drag, but the wind moment on the mast remains exceptionally high. Horizontal Force ( H2cap H sub 2
Vout−of−servicecap V sub o u t minus o f minus s e r v i c e end-sub , Mast dimensions. Soil properties from the site investigation. Allowable bearing capacity ( qallq sub a l l end-sub ), Soil density, Friction coefficient ( Input: Material Props Concrete and steel strengths. Concrete Compressive Strength ( fc′f sub c prime fcuf sub c u end-sub ), Steel Yield Strength ( Trial Dimensions Geometry variables for the foundation block. Footing Width ( ), Length ( ), Thickness ( Geotechnical Analysis Automated calculation cells. Total weight, Eccentricity ( ), Max/Min soil pressure, Stability FOS. Structural Design Flexure and shear capacity math. Required Area of Steel ( Ascap A sub s ), Provided bar size/spacing, Punching shear capacity. Summary / Dashboard High-level overview of the engineering safety status.
Always verify whether the manufacturer’s load sheets provide static values or factored dynamic values. If they are static, the XLS must apply impact factors. Which does your jurisdiction require
This is the most critical check. The spreadsheet calculates the Stability Moment ($M_stability$) vs. the Overturning Moment ($M_overturning$).
is the footing width): The entire footing remains in compression. Base pressures are calculated using:
Factor of Safety (FOS) Overturning=MrestoringMoverturning=Vtotal×B2M+(H×h)Factor of Safety (FOS) Overturning equals the fraction with numerator cap M sub r e s t o r i n g end-sub and denominator cap M sub o v e r t u r n i n g end-sub end-fraction equals the fraction with numerator cap V sub t o t a l end-sub cross the fraction with numerator cap B and denominator 2 end-fraction and denominator cap M plus open paren cap H cross h close paren end-fraction = Width of the footing. = Thickness of the concrete pad. Complete Guide to Tower Crane Foundation Design and
To help tailor this guide or assist with a design you are working on,
The weight of the crane structure, counterweights, and the maximum hook load.
The spreadsheet will then execute a series of calculations. It will check the foundation's stability against overturning and sliding , ensuring the factor of safety is met. It will also verify that the bearing pressure under the pad or at the pile toe does not exceed the soil's or pile's allowable capacity . Finally, it will compute the required reinforcement to resist bending and shear, and check for punching shear at the crane's base. Most sheets will provide a clear "PASS" or "FAIL" verdict for each check.
Always validate a new spreadsheet's outputs against a known textbook example or alternative finite element analysis (FEA) software like SAFE, STAAD.Pro, or Robot Structural Analysis before deployment on a live construction project. Conclusion
must never exceed the allowable net soil bearing capacity provided by the geotechnical engineer. Punching Shear Resistance