User Notes and Features are included within the template for ready use and reference on the fly.
The Tensile Stress Areas for bolts are obtained from BS 4190 for Ordinary Black Bolts, BS 3692 for Precision Bolts and BS 4933 for Countersunk Bolts.
The Tensile Stress Areas and Proof Loads for HSFG Bolts are obtained from BS 4604: Part 1 for General Grade and BS 4604: Part 2 for Higher Grade (Parallel Shank).
Fasten5950 includes four worksheets as follows:

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 using a lot of washers may be necessary to achieve it.

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, S355 and S460
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.
Three Colours and Font styles are used to display Bearing Capacities. Values below the single shear capacity are displayed in Red and Normal font. Values above the single shear and below the double shear capacity are displayed in Blue and Bold. Values above the double shear capacity are shown in Green and Italic.
User can change Ply thicknesses at the head row of bearing values (shown in light green cell background) to suit any value required for design.

Gives capacities for High Strength Friction Grip Bolts. The features are:

Bolt Grades can be: General Grade to BS4604: Part 1 and Higher Grade to BS4604: Part 2

Bolt Shanks can be: Parallel or Waisted for General Grade and Parallel for Higher Grade bolts
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

Bolt Holes can be: Clearance, Oversize, Short Slotted and Long Slotted as defined in BS5950: Part 1
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

Connected Ply Grades can be: S275, S355 and S460
The capacities calculated are: Proof Load, Tension Capacity, Slip Resistance in Single/Double Shear and Bearing Capacities of the bolt in various Ply thicknesses.
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.