Below are several structural engineering Excel spreadsheets and calculators that our professional structural engineering bloggers and readers have recommended.
Also, visit our blog post here for our top 7 excel spreadsheets for structural engineering design and analysis!
Let us know if you have any spreadsheets that you would love to recommend in our structural engineering Excel spreadsheet and calculator collection!
Also, visit our blog post here for our top 7 excel spreadsheets for structural engineering design and analysis!
Let us know if you have any spreadsheets that you would love to recommend in our structural engineering Excel spreadsheet and calculator collection!
Foundations
Structural Engineering Spreadsheet |
URL |
Inputs |
Outputs |
Based on... |
Comments |
Wall footing design and analysis |
Wall width Applied Axial loads Surcharge Loads Cover Reinforcement size Wall stress Allowable soil pressure Footing dimensions Footing thickness |
Min required reinforcement Bearing pressure Shear checks Checks for min reinforcement Bearing strength at interface checks |
ACI 318-2002 |
- |
|
Design and analysis of spread footing |
Allowable soil pressure Footing dimensions Applied loads |
Applied shear Applied moment Stability checks Soil pressure distribution Min required reinforcement |
- |
- |
Reinforced Concrete
Structural Engineering Spreadsheet |
URL |
Inputs |
Outputs |
Based on... |
Comments |
Design of rectangular RC sections under bi-axial shear, bending, compression or tension |
http://www.technouk.com/Programs/Beam-Column-Tie_20120804-.zip |
Applied axial load Column dimensions Area of reinforcement Cover Rebar arrangement Shear links Option of singly or doubly reinforced section |
Biaxial bending check Shear checks Reinforcement requirement checks Stress and strain of steel above x and y axis |
BS 8110-1 |
- |
Design of concrete structures that retain aqueous liquids |
http://www.technouk.com/Programs/RC8007010108-.zip |
Reinforcement type Concrete grade Depth of section Concrete cover Reinforcement size Reinforcement spacing Crack width |
Serviceability limit state checks Max moment capacity Max shear capacity Crack requirement checks Reinforcement requirement checks Steel ratio required for control of thermal and shrinkage cracking |
BS 8007 BS 8110 |
- |
Design of RC rectangular beam |
Concrete grade Reinforcement grade Concrete section dimensions Area of reinforcement Area of stirrups Design moment |
Span/depth ratio design and limit Max bending capacity Max shear capacity of concrete Max shear capacity of stirrups Torsion capacity |
BS 8110: Part 1&2 |
- |
|
Design of RC columns |
Braced or unbraced conditions Applied axial load Concrete grade Steel grade Section size Support condtiions Effective length Reinforcement size Reinforcement arranagement |
Column slenderness check Max axial capacity Reinforcement reinforcement checks Max bending capacity |
BS 8110 |
- |
|
- |
- |
- |
- |
- |
- |
Design for rectangular, T-shaped, or circular RC columns |
Material properties Section properties Reinforcement sizes Number of reinforcement Reinforcement spacing Reinforcement position based on coordinates Applied loads |
Crack width control analysis Capacity checks against axial load and moment Static equilibrium checks Interaction diagram of P vs M |
Eurocode 2 |
- |
|
Design of RC circular columns |
Concrete grade Steel grade Section diameter Applied axial load Applied moment Braced or unbraced conditions Effective length Cover |
Max axial capacity Reinforcement requirement checks Column slenderness check Min diameter checks |
- |
- |
|
Design of Retaining Wall due to Lateral and Verigcal LOads |
Surcharge loads Wall height Wall thickness Base thickness Heel and toe length Wall density Earth density Angle of repose Coefficient of friction Ground pressures in vertical or horizontal direction Water Lloads Water table level Applied point or line loads Option of including passive earth pressure |
Stability checks for sliding and overturning Checks for restoring and eccentric moment Ground bearing checks |
- |
- |
Steel
Structural Engineering Spreadsheet |
URL |
Inputs |
Outputs |
Based on... |
Comments |
Compression Resistance for UKB, UKC, and Hollow sections |
Steel grade Member size Buckling length |
Compression capacity |
BS EN 1993-1-1 |
- |
|
Bending Resistnace for UKB, UKC (against major axis) |
Steel grade Member size Buckling length C1 shape factor |
Bending capacity Lateral torsional buckling resistance |
BS EN 1993-1-1 |
||
Combined Bending and Axial Compression Check for UKB, UKC |
Steel grade Member size Buckling length Axial compression Max and min bending moments |
Interaction factors between bending and axial compression is verified |
BS EN 1993-1-1 |
Assumes same lengths for major axis buckling, minor axis buckling and lateral torsional buckling |
Composite
Structural Engineering Spreadsheet |
URL |
Inputs |
Outputs |
Based on... |
Comments |
Simply supported composite beams |
Steel framing arrangement based on beam type, location, and spacing Slab details (depth, concrete grade, deck profile) Stud details Steel section details (size and grade) Loading values |
Bending checks Shear checks Lateral torsional buckling checks Checks for concrete strut shear Checks for mesh reinforcement Serviceability (deflection and steel stress) |
BS EN 1994-1-1 |
- |
Steel Connections
Structural Engineering Spreadsheet |
URL |
Inputs |
Outputs |
Based on... |
Comments |
Shear and Tying Resistance of End Plates |
Steel grade Beam size Plate thickness and width Bolt rows Bolt distances |
Bolt shear resistance Bearing resistance Group bolt resistance End plate shear resistance Weld resistance Beam web shear resistance Tying resistance of bolt, end plate, beam web, and weld |
BS EN 1993-1-8 |
- |
|
Base Plate Design |
http://bcsatools.steel-sci.org/BasePlateDesigner |
Column size Concrete grade Baseplate size Steel grade Thickness of plate |
Axial resistance Max plate cantilever |
BS EN 1993-1-1 |
Only applies to UKB, UKC, or hollow sections |
Vertical Shear and Tying Resistance of Fin Plates |
Steel grade Beam size Plate thickness Bolt rows Bolt distances |
Bolt shear resistance Bolt bearing resistance in fit plate and beam web Beam web shear resistance Fin plate shear resistance Bearing resistance Tension resistance Weld resistance |
BS EN 1993-1-8 |
- |
|
Compression resistance of gusset plates |
Steel grade Setting out (bracing angle) Bolt distances Tab and gusset plate geometry properties |
Bolt resistance Gusset plate resistasnce Tab plate resistance |
- |
Gusset plates for use of diagonal bracing Can input one edge gusset plate (for roof bracing) or two edges (bracing at beam-to-column connection) |
|
Design of weld groups according to shear, bending, and torsion |
Applied moment Weld group geometry Applied axial load Design strength |
Strength check Centroid of weld group Stress and force results of weld lengths Load eccentricity moments at centroid Resultant moments to weld group Weld coordinates |
BS 5950-1:2000 |
- |
|
Design of bolts and welds |
Bolt heads Shear plane position Bolt grade Grade of connected part |
Table that has tension capacity, shear capacity, bearing capacity of respective bolt diameters High strength friction grip bolts under specified slip factor Combined tension and shear capacity for each bolt diameter Table of capacities of fillet welds |
BS 449: Part 2 |
- |
|
- |
- |
- |
- |
- |
- |