Menu:

Steel Beam to Beam Endplate Splice Connection Design Spreadsheet
(to BS5950 and Joints in Steel Construction: Moment Connections by BCSA and SCI)
 
Description:
A very easy to use spreadsheet for designing steel beam to beam endplate bolted splice connections subject to moment (positive or negative), axial load (tension or compression), and shear. It covers flush and extended endplates with two or four bolt lines and up to six bolt rows per endplate end. Joints in Steel Construction: Moment Connections book provides guidance on connections with two bolt lines only, therefore apply extra caution when using this spreadsheet for four vertical lines of bolts. 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 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;
- Enplate types: fulsh, extended one way, extended both ways;
- Steel grades: S275; S355;
- UC and UB sections;
- Bolt types: 4.6, 6.8, 8.8, 10.9, untorqued general and higher grade HSFG bolts ('bearing type');
- Bolt diameters: M12, M16, M20, M24, M30;
- Loading options: axial load (tension, compression), shear and moment (positive, negative);
- Easy input of dimensions - these are clearly shown and updated on diagram in 'real time';
- Checks dimension requirements, and gives minimum and maximum allowed dimensions;
- Two and four bolt lines supported;
- Up to five bolt rows per end for flush endplates;
- Up to six bolt rows per end for extended endplates;
- Very advanced and 'live' connection diagram with dimensions;
- 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
Thank you - what a fantastic spread sheet.

Stuart Agars - Senior Engineer
Struct-Sure
www.structural-building-design.co.uk

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

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Straightforward to input and simple to use. From my perspective I find the ability to easily amend design conditions very useful and time saving. The end results easily translate to working drawings. 

David Annakin

/

  • 1
  • 2
  • 3
  • 4
  • 5
  • 0
  • 1
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 to Beam Endplate Bolted Splice Connection 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 loads, steel grade etc.
 
 


FULL version: Steel Beam to Beam Endplate Bolted Splice Design to BS (1.2).

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).