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!

Foundations

Structural Engineering Spreadsheet	URL	Inputs	Outputs	Based on...	Comments
Wall footing design and analysis	http://www.psnconsulting.com/wall-footing	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	​http://www.psnconsulting.com/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	http://www.technouk.com/Programs/RC981220p.zip	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	http://www.technouk.com/Programs/Rect-Column_20091211-.zip	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	http://www.yakpol.net/ShortColEC2_down.html	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	http://www.technouk.com/Programs/RoundCol000104-.zip	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	http://www.technouk.com/Programs/RetWall20150415-.zip	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	​http://bcsatools.steel-sci.org/Compression/Input	Steel grade Member size ​Buckling length	Compression capacity	BS EN 1993-1-1	-
Bending Resistnace for UKB, UKC (against major axis)	http://bcsatools.steel-sci.org/BendingUKBUKC	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	​http://bcsatools.steel-sci.org/ CombinedAxial ​CompressionBendingUKBUKC	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	http://bcsatools.steel-sci.org/CompositeBeam ​	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	​http://bcsatools.steel-sci.org/FlexEndPlateDesigner	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	http://bcsatools.steel-sci.org/FinPlateDesigner	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	http://bcsatools.steel-sci.org/GussetPlateDesigner/GussetPlateTool.html ​	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	http://www.technouk.com/Programs/WeldCalc20141217-.zip	​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	http://www.technouk.com/Programs/Fasten449000527-.zip	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	-
-	-	-	-	-	-