Related Resources: Design Engineering

Bolt Pattern Group Pullout Excel Spreadsheet Calculator

NOTE:

  • Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
  • This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
  • Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering Excel Spreadsheet Downloads
Structural Design Engineering Resources
Fastener, Thread, Bolt Design and Engineering

Bolt Pattern Group Pullout Excel Spreadsheet Calculator

Spreadsheet Calculator Calculated per the AISC Ninth Edition

Note: Accessing this resource requires an active Premium Membership with Engineers Edge

Download: Bolt Pattern Group Pullout Excel Spreadsheet Calculator

Preview: Bolt Pattern Group Pullout Excel Spreadsheet Calculator

This design uses the anchor bolt to clamp the steel baseplate down onto the concrete slab/foundation. After grouting beneath the base plate, the bolt is tensioned by tightening the nut -- usually about 1/4 turn of the nut.

Lateral loads are converted to bolt tension loads via the concept of shear friction. Bolt lateral capability is factored down with the factors λ and µ which account for a steel plate trying to slide on concrete.
Force per Turn-of-the-Nut

SHEAR FRICTION CONNECTION -- PUNCHING SHEAR UBC 1911.7
Force per Lateral Movement
SHEAR FRICTION CONNECTION -- Strength of Bolt
SHEAR FRICTION CONNECTION -- Base Plate Sliding / Shear Plane
Punching Shear
SHEAR FRICTION CONNECTION -- Bearing Against Anchor Plate
ANCHORAGE TO CONCRETE, Tension -- Fully Encased Bolt UBC 1923.2
ANCHORAGE TO CONCRETE, Tension -- Fully Encased Bolts in a Row UBC 1923.2
ANCHORAGE TO CONCRETE, Tension -- Fully Encased Group of Bolts UBC 1923.2
ANCHORAGE TO CONCRETE, Shear -- Fully Encased Bolt UBC 1923.3.3