Accuracy and effectiveness are paramount in any contemporary civil engineering activity, particularly when it comes to structural design. To facilitate both engineers and students, we have provided a free Beam Design Excel sheet with which the complex beam design process can be simplified under different loading conditions.
What This Beam Design Excel Sheet Covers
This Excel sheet is a comprehensive tool for the structural design of reinforced concrete and steel beams. It covers the full range of checks required under standard design codes:
- Bending moment and shear force diagrams for simply supported, continuous, and cantilever beams
- Flexural design — calculating required tension and compression reinforcement
- Shear design — stirrup size, spacing, and zone requirements
- Deflection check — span-to-depth ratio and calculated deflection vs allowable limits
- Crack width check for serviceability compliance
Supported Beam Types
The sheet handles the most commonly encountered beam configurations in practice:
- Simply supported beams with UDL, point loads, or combined loading
- Cantilever beams
- Continuous beams (two-span and three-span)
- T-beams and L-beams (flanged sections)
Design Code Basis
The sheet is primarily structured around ACI 318 principles (USD method) but can be adapted for BS 8110 or Eurocode 2 by adjusting the material partial factors and stress block geometry. Key parameters such as f'c, fy, cover, and beam dimensions are fully user-defined inputs.
How to Use the Sheet
- Input beam span, support conditions, and loading
- Enter cross-section dimensions (b, d, h)
- Specify material properties (f'c and fy)
- The sheet computes Mu, Vu, required As, stirrup spacing, and deflection automatically
- Review the colour-coded pass/fail cells to confirm all checks are satisfied
Other Beam Design Sheets Available
Below are additional beam design Excel sheets for more specialised applications:
- Deep Beam Design Excel Sheet
- Grade Beam Design Based on ACI 318-99
Download Beam Design Excel Sheet
Download the Free Beam Design Sheet
This sheet is one of the most downloaded structural design tools on the site because it covers the full beam design workflow in a single file without requiring any specialist software. It is particularly well suited to engineers in early career, students preparing university projects, and consultants needing a quick independent check of analysis software outputs. Download the free Excel sheet below to get started.
