The spreadsheet for anchor bolt design lets engineers rapidly verify anchor bolt capacity, spacing, edge distances, and load combinations against standard design criteria. It internalises anchor type, concrete strength, load direction, and safety factors to perform all required tension and shear checks automatically.
Why Anchor Bolt Design Requires a Systematic Approach
Anchor bolts transfer loads between steel base plates, equipment bases, or structural connections and the concrete substrate. The failure modes are numerous and can be brittle if not properly addressed. Design must consider:
- Steel failure: Tensile or shear fracture of the anchor bolt
- Concrete breakout (cone failure): Cone-shaped concrete pull-out under tension
- Pullout failure: Anchor pulling out due to insufficient embedment
- Concrete side-face blowout: Relevant for deep anchors close to edges
- Concrete pryout: Governs for short anchors under shear load
- Combined tension and shear interaction
Design Codes Applied
This spreadsheet collection covers anchor design per:
- ACI 318-02 Appendix D — Anchorage to concrete (CCD method)
- IBC 2000 — Mechanical equipment anchorage provisions
What Each Sheet Calculates
The ACI 318-02 Single Anchor in Tension Away from Edges sheet checks all relevant tension failure modes for a single cast-in or post-installed anchor with no edge influence. The IBC 2000 Mechanical Equipment Anchorage sheet is tailored for anchoring HVAC units, pumps, and other equipment to concrete slabs and pads.
Inputs Required
- Anchor diameter and embedment depth
- Concrete compressive strength f'c
- Edge distances in both directions
- Applied tension and shear forces (factored)
- Anchor material (ASTM F1554 Gr 36, Gr 55, or Gr 105)
Available Sheets
- Single Tension Fastener Away from Edges — ACI 318-02
- Mechanical Equipment Anchorage to Concrete — IBC 2000
Download Sheet 2 (IBC 2000 Equipment Anchorage)
About This Anchor Design Spreadsheet Collection
This collection of anchor design spreadsheets covers the two most common design scenarios for anchoring to concrete in structural and equipment engineering applications. Both sheets are based on established codes (ACI 318-02 and IBC 2000) and provide transparent, step-by-step calculations that can be included in formal design submissions. Download them free using the links above.
