Anchor Bolt Design Spreadsheet

Anchor Bolts

Steel bolts are used in all kinds of steel construction. They are used in bolted steel connections such as end plate connections, fin plate connections and splice connections. In these cases an analysis may need to be undertaken to check that the bolts used in a bolted connection are suitably strong to withstand the forces acting on them.

Another common use of steel bolts is in holding down bolts or anchor bolts. A typical column in a steel framed building will need to be connected to a reinforced concrete foundation. The connection between the steel column and the concrete foundation typically includes a base plate and steel anchor bolts. The steel plate resists the forces acting on the column and spreads them over a large enough area of the concrete foundation.

The steel anchor bolts help to keep the column stable in all conditions, even where unexpected tensile forces are present during erection or operation of the structure. In some connections such as moment connections the anchor bolts can also be designed to resist tensile and shear forces. The CivilWeb Steel Connection Design Suite includes a Base Plate Design Suite.

Anchor Bolt Design for Shear and Tension XLS

The CivilWeb Anchor Bolt Design Excel Sheet calculates the capacity of either a single bolt or an arrangement of multiple bolts. The designer simply inputs the bolt type and the strength class. The spreadsheet comes pre-set with 29 different standard bolt sizes from M1.6 to M64. The spreadsheet automatically completes the geometrical details for the chosen bolt type, though these can be overridden by the user if required to analyse non standard bolts.

Then the user inputs some more details on partial action factors and plate details. The CivilWeb Anchor Bolt Design Spreadsheet then calculates the following parameters in accordance with BS EN 1993-1-8;

• Tensile Resistance of the Bolts
• Shear Resistance (Either Single Shear or Double Shear)
• Slip Resistance (Either Single Shear or Double Shear)
• Punching Shear Resistance

For multiple bolt designs the user can input the bolt arrangement dimensions including number of bolt rows, number of bolts in each row, bolt spacings and spacings to the edge of the plate. This allows the spreadsheet to calculate the bearing resistance of the bolt group, as well as the Tensile, Shear, Slip and Punching resistances.

The CivilWeb Anchor Bolt Design Spreadsheet XLS also includes a unique dynamic drawing of the bolt arrangement. This shows exactly what bolt arrangement the spreadsheet is analysing including the key dimensions, enabling the designer to quickly check that they have not made any mistakes while entering the inputs.

The CivilWeb Anchor Bolt Design Spreadsheet XLS also includes unique analysis graphs which show the designer exactly what effect any alterations to the bolt diameter will make on the capacity of the bolts. This allows the designer to see at a glance exactly what size of bolt is most optimal. They can check the tensile, shear, slip, punching and bearing resistances for any bolt size instantly, without having to complete time consuming iterative calculations.

CivilWeb Anchor Bolt Design Spreadsheet

The CivilWeb Anchor Bolt Design Spreadsheet is an easy to use spreadsheet for checking the capacity of any steel bolts in accordance with the requirements of BS EN 1993-1-8. This can be used for deign of steel connections, anchor bolts or indeed any steel bolts. Unique analysis graphs show the designer exactly how big the bolts need to be, saving lots of iterative design work on every bolt design.

Buy the CivilWeb Anchor Bolt Design Spreadsheet now for only £19.99.

Or why not buy our best value bundle, the full CivilWeb Steel Design Suite which includes all of our steel design spreadsheets for only £49.99, a saving of 66%.