Related Resources: Civil Engineering

Excel Spreadheet Design Calculator per. BS: 449: Part 2

NOTE: Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.

Engineering ANSI Hardware Design Data
Engineering Metric Hardware Design Data
Fastener Bolt Design, Formula and Calculations

Engineering Excel Spreadsheet Downloads

Excel Spreadheet Design Calculator per. BS: 449: Part 2

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

Download: Excel Spreadheet Calculator per. BS: 449: Part 2

 

---

Ordinary & Countersunk Bolts per. BS: 449: Part 2

Gives capacities for Ordinary and Countersunk Bolts.

The features are: Bolt Heads can be: Normal or Countersunk Bolt Grades can be: 4.6, 6.8, 8.8, 10.9, 12.9 and 14.9

Shear Plane can be: Bolt Threads or Shank When Shear Plane in the Shank is selected, a warning is displayed to remind that Threads should not be in the Shear Plane and that the use of many washers may be necessary to achieve it.

End distance from a Bolt centre of to its ply edge can be 2d to 1.25d The permitted Bearing Capacity of the ply is maximum when 2d and reduced to a lesser value when 1.25d, where d is the nominal bolt diameter.

Bolt Diameters are: M1.6, M2, M2.5, M3, M4, M5, M6, M8, M10, M12, (M14), M16, (M18), M20, (M22), M24, (M27), M30, (M33), M36, (M39), M42, (M45), (M52), M56, (M60), M64 and (M68), the sizes in brackets being non-preferred.

Connected Ply Grades can be: S275 (43), S355 (50) and S460 (55).

The capacities calculated are: Tensile, Single Shear, Double Shear and Bearing for various Ply thickneses. The Combined Tension and Shear Capacity can also be calculated for each bolt diameter. For any typed value of Applied Tension Ft, the corresponding Shear Capacity Fs of Threads or Shank is displayed in the adjacent cell.

---

HSFG Bolts Gives capacities for High Strength Friction Grip Bolts per. BS: 449: Part 2

The features are:

Bolt Grades can be: General Grade to BS4604: Part 1 and Higher Grade to BS4604: Part 2 Bolt diameters are: M12, M16, M20, M22, M24, M27, M30 and M36 for General Grade and M16, M20, M22, M24, M27, M30 and M33 for Higher Grade Bolts

Slip Factor can be any value in the range 0 to 0.55, depending upon the contact surface. For example, it can be a value of 0.5 for grit or shot blasted steel, a value of 0.05 for steel finished with red-lead paint. In the normal use, however, the surface specified is clean and lightly rusted for which the slip factor is taken as 0.45.

The Applied Tension Condition can be No Fatigue or With Fatigue.

Based on the Proof Load, the capacities calculated are: Tension Capacity and Slip Resistance in Single/Double Shear.

The Combined Tension and Shear Capacity can also be calculated for each bolt diameter. For any typed value of Applied Tension Ft, the corresponding Shear Capacity Fs of Threads or Shank is displayed in the adjacent cell.

To display bearing capacities, 3 colours and font styles are used. The values below the single shear capacity are shown in Red and Normal font. The values above the single shear and below the double shear capacity are shown in Blue and Bold. The values above the double shear capacity are shown in Green and Italic.

Ply thicknesses at the head row of bearing values (shown in light green cell background) can be changed to suit any value required for design.

---

Fillet Welds Gives Fillet Weld Capacities for Steel Grades S275, S355 and S460, using E43 and E51 Electrodes to BS639.