The final output of a well-designed spreadsheet is not just a set of numbers, but a comprehensive, auditable design report . This report is a crucial project document, serving as a record of the calculations and verifying compliance. All inputs, intermediate values, and final checks should be clearly displayed.
Checks the risk of the crane mast punching through the concrete slab at a distance of from the perimeter of the anchor base.
Add a "Pass/Fail" cell with conditional formatting. If the factor of safety against overturning drops below 1.5, make it turn bright red. Reinforcement Specs:
The foundation must resist tipping over under extreme wind loads. The restoring moment (driven by weight) is divided by the overturning moment.
Spreadsheets for tower crane foundation design are specialized tools used by structural engineers to automate complex stability and reinforcement calculations . Because these foundations are critical for preventing crane collapse, any "Xls" tool must be reviewed against rigorous industry standards such as CIRIA C761D . Tower Crane Foundation Design Xls
) is generated by the self-weight of the foundation concrete pad and the soil overburden resting on top of it. The overturning moment ( Movercap M sub o v e r end-sub
, compression occurs only over a partial area of the footing, requiring complex triangular pressure distribution formulas in your spreadsheet equations. Maximum Soil Pressure Calculations
IF(FOS_Overturning >= 1.5, "PASS", "FAIL") (Note: Some regional codes require a factor of 2.0). C. Safety Factor Against Sliding
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. The final output of a well-designed spreadsheet is
Incorporates breakout cone failure, pull-out capacity, and side-face blowout per ACI 349 or EN 1992-4.
is the strength reduction factor (0.75 for shear under ACI 318). Vccap V sub c is the nominal concrete shear strength ( in metric units). Flexural Reinforcement
Ppile=Ptotaln±Mx⋅y∑y2±My⋅x∑x2cap P sub p i l e end-sub equals the fraction with numerator cap P sub t o t a l end-sub and denominator n end-fraction plus or minus the fraction with numerator cap M sub x center dot y and denominator sum of y squared end-fraction plus or minus the fraction with numerator cap M sub y center dot x and denominator sum of x squared end-fraction
The crane mast legs exert concentrated forces that can punch through the concrete slab. This is checked at a perimeter distance of Checks the risk of the crane mast punching
The concentrated load from the four legs of the crane mast poses a high risk of punching through the concrete pad. The design slab thickness must provide an internal concrete shear capacity ( Vccap V sub c ) greater than the factored punching shear force ( Vucap V sub u ) at a critical perimeter located at a distance of from the face of the mast legs (per ACI 318). Flexural Reinforcement Design
Horizontal forces must not push the foundation sideways. Resistance is generated by friction between the bottom of the concrete pad and the soil.
Reinforcement bar diameter, bar spacing, clear concrete cover. Punching shear capacity vs demand, flexural steel area ( As,reqcap A sub s comma r e q end-sub As,provcap A sub s comma p r o v end-sub 5. Overturning and Sliding Stability Benchmarks
Utilized across Europe and the UK, incorporating Limit State Design (ULS and SLS) and partial safety factors for load and soil combinations.