Menu:

Steel Beam Splice Connection Design Spreadsheet to BS 5950
(and Joints in Steel Construction: Moment Connections by BCSA and SCI)
 
Description:
Essential spreadsheet for designing bolted cover plate splices. Allows design of beam spliced connection subject to axial force (tension, compression), shear and moment. Includes a very advanced and descriptive diagram showing connection in plan and elevation, it also includes dimensions. This makes it very easy to appreciate connection type being checked. The design is based on BS 5950 and Joints in Steel Construction: Moment Connections book. The spreadsheet is easy to use and has a clear output.

​Due to complexity of steel connections design (methodology, terms, requirements, limitations) this spreadsheet should be used by structural engineers only.
Features:
- A clear and easy to read output (all on a single page);
- Quick summary of utilization factors;
- Steel grades: S275; S355; S460;
- UC and UB sections;
- Bolt types considered: torqued general and higher grade HSFG bolts;
- Loading options: axial load (tension, compression), shear and moment;
- Up to six bolt rows are supported in flange plates;
- Option to specify inner flange plates and web plates on both sides;
- 'Live' connection diagram with dimensions;
- Includes help notes;
- Design is based on BS 5950 and Joints in Steel Construction: Moment Connections by BCSA and SCI;

(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
What People Say:

Title
/
Company

  • 1
  • 2
  • 3
  • 4
  • 5
This is providing an intuitive way of calculating splice connections with simple format of parameters. In comparison with other calculation packages, this spreadsheet can be used right away, you would not need another course to teach you how to operate it. I strongly recommend this splice calculator.

Mauro Persic
​Director at Gamut Building Solutions
www.gamutbs.co.uk

Director
/
Capita (www.capita.co.uk)

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Useful and simple program and again a big time saver. This quickly allows the designer to consider both the splice position and various loading conditions to achieve the most appropriate design. Another valuable addition to the designer's arsenal.

David Annakin

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Damian, many thanks for both the Steel Eurocode 3 Beam and Steel Beam Splice Spreadsheets. They have saved me a lot of mental sweat!!

Angus Colyer
Mouli Dal Roc
www.mouli-dal-roc.eu

/

  • 1
  • 2
  • 3
  • 4
  • 5
  • 0
  • 1
  • 2
Provide testimonial or feedback
System Requirements:
To run the Single-User or the Company Licensed version of this spreadsheet you require:
- Microsoft Windows Excel version 2007 and above;

Contact me if you want to use this spreadsheet on MAC.
Download Section:
FREE Lite version: Steel Beam Splice Design to BS (1.0).

The restriction in this free lite version is that you cannot change the company name nor the logo (shown in top left corner) - currently set to a made up company. Also you cannot change applied moment or shear, bolt diameter, or number of flange bolts along beam length.
 
 


FULL version: Steel Beam Splice Design to BS (1.0).

Single-User or Company License, which one is the best for me?

Fully working version where you change the company information and company logo. And also input point loads.

By purchasing this spreadsheet you agree to the disclaimer and terms & conditions. Two types of licenses are available for this spreadsheet. The single-user license is offered for a nominal price of £20 - a great product that you can have for a great value.

After purchase fill in this Activation Key Request Form.

 
 
 


For other currencies click here: € (EUR), £ (GBP) or $ (USD).