Techno Consultants Ltd.
Software Download - Bolt & Welds Features

Fasten5950 is an Excel Template for finding the Capacities of Bolts and Welds to BS5950-1: 2000. The bolts can be Ordinary, Countersunk or High Strength Friction Grip Bolts. Welds can be Fillet or Butt.

Loading the Template on to your computer
 Fasten5950 is supplied as an Excel 97 Template, having .zip as its filename extension.

To load Fasten5950 on to your computer, copy this file into Microsoft Office folder for its Templates. Generally the path to this folder in Excel 97 is: C:\Program Files\Microsoft Office\Templates

If you are using Excel 2000, the path to this folder is: C:\Windows\Application Data\Microsoft\Templates

To load and use the Template in Excel 97 or Excel 2000, choose: File, New and the select the file Fasten595020030119-

If you receive an Excel Warning about running Macros and are prompted for whether to load them, answer YES to Load and Enable Macros. Fasten5950 incorporates VB Macros and to allow your computer to use them is vital for its operation.

Features

Fasten5950 gives capacities of Hexagon Head Bolts, Countersunk Bolts, High Strength Friction Grip Bolts, Fillet Welds and Butt Welds using BS5950-1:2000..

It also includes data worksheets for detailing bolts. The information includes: dimensions of bolts and nuts, washers, various bolt hole sizes, spacing of holes and back marks, bolt symbols, etc. The Tensile Stress Areas are taken 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 taken from BS 4395: Part 1 for General Grade and BS 4395: Part 2 for Higher Grade (Parallel Shank). Scope & method details of various worksheets are described below.

Non-preloaded Hexagon Head & Countersunk Bolts

This worksheet calculates various capacities: Tensile, Single Shear, Double Shear and Bearing for various Ply thicknesses. The features are:

Bolt Heads can be: Normal or Countersunk

Bolt Grades can be: 4.6, 6.8, 8.8, 10.9 and HSFG General and HSFG Higher Grade

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. Bolt Holes can be Clearance, Over-size, Short-slotted, Long-slotted and Kidney-shaped

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.

Hole Edge Distance can be any user-typed value from 1.25 to 2.0 of the Bolt Hole Diameter D.

Connected Ply Grades can be: S275, S355 and S460

Connected Ply Thicknesses can be any User-Typed Values. They can be changed at the head row of bearing values (shown in light green cell background) to suit any value required for design. 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.

Preloaded HSFG Bolts

This worksheet calculates: Proof Load, Tension Capacity, Slip Resistance in Single/Double Shear and After-slip Bearing Capacities of bolts in various Ply thicknesses. 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 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 Perpendicular to Load and Long-slotted parallel to load as defined in BS5950: Part 1

Slip Factor can be 0.2, 0.3, 0.4 and o.5, depending upon the condition of faying surfaces described in Table 35 of the Code.

Design criteria for connections can be Non-slip in service and Non-slip under factored loads

Connected Ply Grades can be: S275, S355 and S460

Connected Ply Thicknesses can be any User-Typed Values. They can be changed at the head row of bearing values (shown in light green cell background) to suit any value required for design. 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.

Fillet Weld Capacities

Two worksheets give Fillet Weld Capacities for Steel Grades S275, S355 and S460, using E35, E42 and E50 Electrodes. One worksheet uses the Simple Method as per clause 6.8.7.2 and the other uses the Directional Method as per Clause 6.8.7.3 of the code.

Butt Weld Capacities

Gives Capacities for Full Penetration Butt Welds. The capacities calculated are Shear and Tension/Compression strength for Steel Grades S275, S355 and S460using E35, E42 and E50 electrodes respectively.

IMPORTANT: Please read DISCLAIMER before download and use   

IMPORTANT: Terms and Conditions      

Software Sections

Masonry           Reinforced Concrete
Structural Analysis              Units Conversion               Steelwork