Bolt Threads, Grade, Bolt Strength, Excel Spreadsheet Calculator

Related Resources: Design Engineering

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.

Bolt Threads, Grade, Bolt Strength, Excel Spreadsheet Calculator

Spreadsheet Calculator Calculated per the AISC Ninth Edition

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

Preview

Reference: AISC 9th Edition Part 4 - 3 tension on gross area
Section J - 3, page 5 - 72 and some common sense
American Institute of Steel Construction (AISC)

A36 can be purchased at the hardware store as allthread rod.
A354 Grade BD is usually specified as interchangeable with A490 bolts. A354 Gr. BD is often
furnished as a high-strength anchor bolt and is also used in high temperature conditions, like
your car engine's head bolts.

Comparison of Published and Calculated Threaded Areas
Values in the AISC Ninth Edition, First Printing (7/89) vary from
the formula 0.7854*(D -1.3 /n)² for the root area AK. The
difference between the first and second AISC printings is shown
below and in the graph. ICE calculations equal the revised
AISC values.

Epifoam sleeves, pipes, and plastic pipes are used to prevent concrete bond with
the bolt. This allows bolt stretch during impact events. The bolt can be pretensioned
with the hit wrench or a large impact hammer. Calculate the turn of the nut versus
the length of the bolt between the nuts.