Structural • Rc Microsoft Excel (.xlsx)
RC Beam Design (BS 8110)
Flexural and shear design of a singly reinforced rectangular beam.
Download Excel Workbook (.xlsx)
Version 0.1
What this workbook is
A real, downloadable Microsoft Excel workbook — not a rendered demo. Every sheet is built around a single engineering method: inputs in one place, calculated results and a PASS / WARN / FAIL check sheet, with the method, sources and assumptions recorded next to the numbers. Open it in Excel, Sheets or LibreOffice, change the inputs, and the workbook recalculates.
- Light cells are user-entered inputs on the Inputs sheet.
- Dark cells are calculated automatically and are not editable.
- The method and sources for every calculation are listed below and inside the workbook.
What you enter
- ✓fcu, fy
- ✓Width b
- ✓Effective depth d
- ✓Bending moment M
- ✓Shear V
What it calculates
- ✓K and z
- ✓Required As
- ✓Min As
- ✓Shear stress vs vc
Method
K = M/(bdآ²fcu); K′ = 0.156; z = d(0.5+âˆڑ(0.25−K/0.9)) ≤ 0.95d; As = M/(0.87fyآ·z); v = V/(bd) vs vc
Sources
- [1] BS 8110-1:1997 simplified design equations (public worked examples)
Inside the workbook
CoverTitle, scope and revision block
SummaryCore inputs and headline results
InputsYour project values (light cells)
CalculationsStep-by-step working sheet (dark cells)
OutputsReadback of results for reporting
ChecksPASS / WARN / FAIL against stated limits
ReferenceSources for each calculation
Notes & AssumptionsScope, exclusions and stated limits