Spreadsheet suggested 0.3 m thickness (instead of assumed 0.25 m) to satisfy punching shear. Also showed that minimum steel (0.0018bh) governed over required flexural steel. Engineer saved a potential failure at a negligible cost. The spreadsheet’s calculation sheet was printed, signed, and included in the construction permit.
"RCC Beam Design.xls" from civil engineering forums – widely used for ACI 318-14. 2. Column Design (Axial + Biaxial Bending) What it does: Designs short or slender columns under combined axial load and bending. Some advanced spreadsheets construct an interaction diagram.
Downloaded "Isolated Footing Design.xls" from a civil engineering forum. Input wall load (65 kN/m), soil bearing (150 kPa), concrete C25/30, steel S420.
For professionals: build a curated library of verified spreadsheets. They will become your fastest, most transparent design companions. reinforced concrete design spreadsheet excel free download
No budget for software. Young engineer with two years of experience.
"Biaxial Column Interaction Diagram.xls" – a classic spreadsheet that solves strain compatibility for any section. 3. Slab Design (One-Way and Two-Way) What it does: Calculates required reinforcement for continuous or simply supported slabs, checks deflection limits, and designs edge or corner reinforcement.
Column dimensions, reinforcement ratio (ρg), number and size of bars, axial load (Pu), moments (Mux, Muy), unbraced length, end conditions. Spreadsheet suggested 0
Predicted crack width (pass/fail against code limit), immediate and time-dependent deflection.
For students: download every spreadsheet you find, take them apart, and rebuild them. That process will teach you more about concrete design than any textbook.
Beam width, effective depth, concrete compressive strength (f’c or fck), steel yield strength (fy), ultimate moment (Mu), ultimate shear (Vu). Column Design (Axial + Biaxial Bending) What it
Column loads, footing dimensions (trial), soil allowable bearing pressure, concrete cover, rebar details.
Required As (area of steel), rebar selection (e.g., 4#25 bars), spacing checks, shear reinforcement spacing.
"Two-Way Slab Design (Direct Design Method).xls" – follows ACI 318's DDM, including panel moment distribution. 4. Footing Design (Isolated Square or Rectangular) What it does: Sizes the footing based on soil bearing capacity, checks one-way and two-way (punching) shear, designs flexural reinforcement, and checks development length.