RHCES Spreadsheet Store

Structural

RC Beam Section Designer (ACI 318-19)

by RHCES

Check a rectangular reinforced-concrete beam section to ACI 318-19 (SI units) in minutes. Enter the materials, section, bars and the factored Mu and Vu, and the sheet works out the rest.

Flexure for singly or doubly reinforced beams, with tension bars placed in one or two layers automatically and the compression-steel stress found whether it yields or not. Ductility to ACI 318-19 (net tensile strain at least the yield strain + 0.003, with the matching phi), minimum steel, bar clear spacing, crack-control spacing and the minimum-depth (deflection) rule.

Shear uses the ACI 318-19 concrete shear table step by step: the simple formula, the formula with the longitudinal steel ratio, and the size-effect formula when stirrups are below the minimum, with the upper limit and a note showing which case governs. Then stirrup strength, the section limit, maximum spacing and minimum stirrups.

A design check summary shows demand, capacity, ratio and PASS / FAIL for every check, with one overall result. Every result is an open Excel formula with readable names and ACI 318-19 clause references, and it prints as a clean 3-page A4 calculation sheet.

Version 1.1 (October 2026): the section drawing is now live, redrawn from your bars and layers as you type. Results are unchanged from version 1.0. Entries outside the allowed ranges are refused, and an incomplete set of inputs shows CHECK INPUTS instead of a verdict. Bars that do not fit in their layer are drawn in red.

Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · 3-page A4 calc sheet · SI units · open formulas · v1.1

Includes 2 files: Excel workbook: RC Beam Section Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Column Section Designer (ACI 318-19)

by RHCES

Design and check a rectangular tied reinforced-concrete column to ACI 318-19 (SI units): axial load with bending about both axes, slenderness and shear, with interaction diagrams drawn for you.

The P–M interaction diagram for each axis is built by strain compatibility over every bar layer and plotted as a chart with your load point on it, using the ACI 318-19 strength reduction factors. The sheet reads the design moment capacity at your factored axial load and checks biaxial bending with the load-contour method, plus the 0.80 Po axial limit.

Slenderness per axis with moment magnification for braced columns (including the minimum moment), sway columns flagged for second-order moments, and unstable columns caught. Curvature is picked from a drop-down, so the code sign rule is applied for you.

Shear in both directions with the ACI 318-19 concrete shear table, including the axial-load term, the longitudinal-steel and size-effect formulas and the upper limit, plus minimum shear ties. Detailing checks: steel ratio 1–8 %, minimum bars, bar spacing, tie size (No. 13 for larger bars), tie spacing and crossties.

Every result is a visible Excel formula with ACI 318-19 clause references; prints as a clean A4 calculation. Ordinary (non-seismic) detailing; special moment frames (Chapter 18) are not covered in this version.

Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheet + P–M interaction diagrams · SI units

Includes 2 files: Excel workbook: RC Column Section Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Circular Column Designer (ACI 318-19)

by RHCES

Design a solid circular reinforced-concrete column to ACI 318-19 (SI units): axial load with biaxial bending (combined as the resultant moment), slenderness and moment magnification for braced frames (with the 1.4 second-order limit), P-M interaction by strain compatibility on a circular compression zone with the bars equally spaced on one circle, shear with axial load, and the longitudinal-bar, spiral and circular-tie detailing limits of Chapters 10 and 25, with the ACI 318-19 phi transition and the Table 22.5.5.1 shear strength.

Enter the diameter, cover, materials, bars and the factored loads (several load rows); the sheet draws the live P-M interaction diagram with your load points, checks capacity, spiral or tie size and pitch, bar spacing and cover, and gives one overall result. Companion to the RC Column Section Designer (rectangular).

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheet + P–M interaction diagram · SI units

Includes 2 files: Excel workbook: RC Circular Column Designer, ACI 318-19 · Sample calculation, A4

Structural

One-Way Slab Designer (ACI 318-19)

by RHCES

Design a solid one-way reinforced-concrete slab to ACI 318-19 (SI units) per 1 m strip, from loads to bar spacing.

Self-weight is worked out for you; the factored load uses the larger of 1.4D and 1.2D + 1.6L. Moments and shear come from your choice: simply supported, cantilever, the ACI approximate coefficients for continuous slabs (all positive and negative locations, with the 1.15 shear factor), or values from your own analysis.

Checks bottom and top bars for strength and the ACI 318-19 tension-controlled limit, minimum and temperature steel (0.0018 Ag), maximum spacing, crack control and clear spacing; one-way shear with the ACI 318-19 size-effect formula (no stirrups); and minimum thickness for deflection. Design aids give the required steel and the largest bar spacing that works.

Every result is a visible Excel formula with ACI 318-19 clause references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · 2-page A4 calc sheet · per 1 m strip · SI units

Includes 2 files: Excel workbook: One-Way Slab Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Stair Designer (ACI 318-19)

by RHCES

Design a reinforced-concrete waist-slab stair to ACI 318-19 (SI units): a straight flight, or a flight with a landing at the bottom, at the top or at both ends, spanning along the flight between simple or restrained supports.

Enter the number of risers, the rise and tread, the landing lengths, the support widths, the materials, the bars and the loads (finishes, soffit, live load and an optional tread load). The sheet works out the self-weight of the waist and steps and the factored load, then the moments and shear: exact statics for simply supported flights, the ACI 318 6.5 coefficients for restrained ends, or your own moments. It checks flexure with the effective depth perpendicular to the slope, ductility, minimum and distribution steel, bar spacing and crack control, cover, shear without stirrups by Table 22.5.5.1 (with the size effect), the minimum thickness for deflection, and the development and anchorage of the bars at the supports. It flags the re-entrant kink where a flight meets a landing above it and shows the crossing-bar detail, and gives editable riser, tread, 2R + T and headroom guidance lines.

A live drawing shows the steps, waist, landings, supports and every bar group. The check summary gives demand, capacity, ratio and PASS / FAIL for every line, with one overall result. Cross-checked against a published university stair example (within 0.3 %).

Not covered: cantilever, helical and free-standing stairs, precast stairs and flights with an intermediate support.

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · 4-page A4 calc sheet + live stair drawing · SI units

Includes 2 files: Excel workbook: RC Stair Designer, ACI 318-19 · Sample calculation, A4

Structural

Two-Way Slab Designer (Coefficient Method, ACI 318-19)

by RHCES

Design a two-way slab panel supported on beams or walls on all four edges with the classic moment and shear coefficient method (ACI 318-63 Method 3), with the bars and checks to ACI 318-19 (SI units).

Pick one of the 9 edge-condition cases (sketches included), enter spans, thickness, loads and bars, and the sheet interpolates every coefficient for your span ratio: middle-strip negative and positive moments both ways, discontinuous-edge moments and column-strip values.

Checks each bar layer for strength and the ACI 318-19 tension-controlled limit, minimum steel (0.0018 Ag), maximum spacing, clear spacing, shear at every edge with the ACI 318-19 size-effect formula, and minimum thickness. It also gives the load carried to each supporting beam. The coefficient tables were cross-checked against three independent sources, including scans of the original ACI 318-63 tables.

Every result is a visible Excel formula with ACI 318-19 clause references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheet + full coefficient tables · SI units

Includes 2 files: Excel workbook: Two-Way Slab Designer, coefficient method, ACI 318-19 · Sample calculation, A4

Structural

Two-Way Slab Designer (Direct Design Method, ACI 318-19)

by RHCES

Design a two-way slab system with the Direct Design Method of ACI 318-19 Section 8.10 (SI units): flat plates (with or without an edge beam) and slabs with beams between all supports, for interior, edge and corner panels, both directions side by side.

Checks the DDM limitations, works out Mo, distributes it along the span and between column strips, middle strips and beams with the code tables (beam stiffness and torsion from your beam sizes), and sizes the bars automatically for every strip location, including the new ACI 318-19 minimum top steel at columns where punching stress is high (8.6.1.2).

Also checks minimum thickness, one-way shear and punching shear with the ACI 318-19 size effect and moment transfer at interior and edge columns (0.3 Mo at edge columns). Corner-column punching is not covered in this version.

Every result is a visible Excel formula with ACI 318-19 clause references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheet + DDM tables · auto bar spacing · SI units

Includes 2 files: Excel workbook: Two-Way Slab Designer, Direct Design Method, ACI 318-19 · Sample calculation, A4

Structural

Isolated Footing Designer (ACI 318-19)

by RHCES

Design an isolated (spread) footing under a rectangular column to ACI 318-19 (SI units), square or rectangular, from service loads to bars.

Enter the column, the dead and live axial loads (moments optional), the soil data and a trial footing. The sheet works out the net allowable soil pressure, the service pressure with moments and the full-contact (kern) check, and the factored soil pressure used for design.

Checks one-way shear in both directions, punching shear at d/2 including the shear from column moments, flexure at the column face both ways, minimum steel, the central-band rule for rectangular footings, bar spacing, development length of the bottom bars, column bearing, dowels and dowel development. Design aids suggest a square footing size and the bar spacing you need. A live footing plan shows the column, the critical sections, the steel band and where the load acts.

ACI 318-19 specifics: one-way shear with the Table 22.5.5.1 formula, a switch for the size-effect factor (13.2.6.2 lets you neglect it for footings), the 8.6.1.2 minimum steel near the column, minimum steel 0.0018 Ag and the εty + 0.003 ductility limit.

Every result is a visible Excel formula with ACI 318-19 clause references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Version 1.1: column offset incl. edge and corner columns, live plan and elevation sketches with forces, live footing section.

Excel · 5-page A4 calc sheet + live footing plan · SI units · v1.1

Includes 2 files: Excel workbook: Isolated Footing Designer, ACI 318-19 · Sample calculation, A4

Structural

Combined Footing Designer (ACI 318-19)

by RHCES

Design a rectangular combined footing carrying two columns to ACI 318-19 (SI units), including an exterior column right at the property line.

The sheet sizes the footing length so the soil pressure is uniform (load resultant at the centre), or checks a length you enter with the trapezoidal pressure and the kern check. The footing is then designed as a beam along its length, with live shear-force and bending-moment diagrams: the largest negative moment between the columns sets the top bars, the moments at the column faces set the bottom bars.

Checks one-way shear at d from the column faces, punching at both columns (a three-sided edge section for a column at the property line), flexure and ductility of the top and bottom bars, transverse bands under each column, minimum steel, spacing, development length (top-bar factor applied), column bearing and dowels. A live plan drawing shows the columns, critical sections and transverse bands. Gravity loads; moment transfer at the columns is not included in this version.

ACI 318-19 specifics: one-way shear with the Table 22.5.5.1 formula, a switch for the size-effect factor (13.2.6.2 lets you neglect it for footings), minimum steel 0.0018 Ag and the εty + 0.003 ductility limit.

Every result is a visible Excel formula with ACI 318-19 clause references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheet + live plan, shear & moment diagrams · SI units

Includes 2 files: Excel workbook: Combined Footing Designer, ACI 318-19 · Sample calculation, A4

Structural

Strap Footing Designer (ACI 318-19)

by RHCES

Design a strap (cantilever) footing to ACI 318-19 (SI units): an exterior column at the property line on its own footing, tied by a strap beam to an interior column on a concentric footing, so the soil pressure stays uniform under both.

The sheet solves the statics for the two footing reactions (strap self-weight optional), sizes the footings from the allowable soil pressure, and lets you design the interior footing for the full column load (default, conservative) or the reduced reaction. It checks uplift on the interior footing.

Strap beam: live shear and bending-moment diagrams, top steel for the maximum moment, minimum bottom steel and any sagging, ductility, stirrups (Vc by Table 22.5.5.1, Vs, maximum spacing, minimum shear steel, section limit) and anchorage of the top bars at the property-line end. Exterior footing: designed across as cantilevers from the strap faces, with one-way shear, flexure, steel both ways, spacing and development. Interior footing: punching (with the optional size effect), one-way shear and flexure both ways, central band, the flexure-driven punching steel of 8.6.1.2, development. Column bearing and dowels for both columns. A true-scale plan shows the property line, both footings, the strap and the critical sections. Gravity loads.

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheet + live plan, strap shear & moment diagrams · SI units

Includes 2 files: Excel workbook: Strap Footing Designer, ACI 318-19 · Sample calculation, A4

Structural

Mat Foundation Designer (ACI 318-19)

by RHCES

Design a rectangular mat (raft) foundation of uniform thickness under a regular grid of columns (2 to 5 column lines each way, up to 25 columns) by the conventional rigid method (ACI 336.2R; Das; Bowles) to ACI 318-19 (SI units): rigidity check, soil pressure under service and factored column loads from the resultant, punching shear at every column (interior, edge and corner sections, cut by the mat edge when the overhang is short) with the flexure-driven punching steel of 8.6.1.2, the strip method in both directions with the load / reaction adjustment, shear and moment of every strip as live tables and charts, one-way shear in the strips, top and bottom reinforcement both ways per metre, spacing, development and column bearing.

Enter the mat size and thickness, the column grid and loads, the soil pressure and the materials; the sheet draws the plan with the strips and reports every check with PASS / FAIL and one overall result.

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + live plan, strip shear & moment charts · SI units

Includes 2 files: Excel workbook: Mat Foundation Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Slab-on-Grade Designer (ACI 318-19)

by RHCES

Design one concrete slab on ground (slab-on-grade) of uniform thickness for a warehouse, industrial, commercial or residential floor, on a subgrade with an optional granular sub-base (SI units). ACI 318-19 1.4.8 exempts floor slabs on ground that carry no loads from the structure (R1.4.8 points to ACI 360R), so the thickness comes from the published methods with service loads and safety factors, while ACI 318-19 supplies the concrete, durability, cover, spacing, laps, punching and bearing rules. Subgrade k from a plate load test, CBR or soil type, with the composite k on top of the sub-base. Plain slabs with sawcut joints, or one or two layers of distributed steel; dowelled, aggregate-interlock or free-edge joints.

Loads: one forklift or vehicle axle (from the rated capacity, service weight and axle share, or typed; single or dual wheels; solid or pneumatic tyres; load repetitions for the fatigue safety factor), up to 4 rows of rack posts or point loads (back-to-back racks as a 2 × 2 post group, single racks or single posts, at a joint or not) and one uniform storage load with a fixed or variable aisle layout.

Wheels and posts by PCA (default), Westergaard and Meyerhof, all three side by side, the chosen one driving the statuses; flexural strength from the code modulus of rupture 0.62√f'c by default, or a tested value. Checks: flexure in the interior and at joints for each load and the thickness each case needs; the uniform-load aisle moment (Hetenyi) and soil pressure; punching shear around base plates and tyres by the code equations (Table 14.5.5.1, or 22.6.5.2 with the size factor for two layers) with combined perimeters for close loads; bearing; joint spacing, sawcut depth and dowels; distributed steel by subgrade drag and the 0.1 % minimum, cover, spacing and laps. A switch for a slab that carries loads from the structure or acts as a tie adds the code plain-concrete checks under factored loads.

Live drawings show the slab section at a joint, the axle and post-group plans with punching perimeters, the design ratio against slab thickness and the joint layout; the 33-line summary reports demand, capacity, ratio and PASS / FAIL / CHECK, with the required thickness and one overall result. Not covered: fibre-reinforced, post-tensioned, jointless and pile-supported slabs, slabs carrying columns or walls, line and wall loads, multi-axle trucks, mixed-traffic fatigue, curling analysis, dowel capacity, expansive soils and settlement. The Read Me lists the items taken from a single published source that are worth confirming.

Every result is a visible Excel formula, with ACI 318-19 section references for the code items. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + live slab section, axle & post plans, ratio chart & joint layout · SI units

Includes 2 files: Excel workbook: RC Slab-on-Grade Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Shear Wall Designer (ACI 318-19)

by RHCES

Design one section of a cast-in-place reinforced-concrete structural (shear) wall at a time, usually the critical section at the base, to ACI 318-19 Chapter 11 and, for special structural walls, 18.10, with the seismic basis of ASCE 7-22 (SI units): rectangular, with web bars in one or two curtains and optional boundary zones at both ends. Type the factored Pu, Mu and Vu of up to 40 combinations or paste the ETABS Pier Forces table (ETABS 22 or older layouts). The top displacement for the boundary-element check is typed from your analysis.

P-M interaction by strain compatibility for every combination, with the probable moment Mpr. Checks: in-plane shear (special walls: Ve = Ωv ωv Vu not above 3 Vu, 18.10.3.1, with one Ωv for the wall per note [1] of Table 18.10.3.1.2) and its limit; the need for special boundary elements, displacement-based with the drift capacity check (18.10.6.2) or stress-based (18.10.6.3), and their extent, width, Ash, spacing, hx, hoop legs, web crossties and floor concrete (18.10.6.4) and height, or the boundary ties of 18.10.6.5; minimum web steel, end reinforcement (18.10.2.4), curtains and spacing; shear friction and joint roughening; development and Class B laps, the no-lap zone above the critical section (18.10.2.3(c)) and a flag for the Ktr rule of 25.4.2.2 and 25.5.1.5 on Grade 550 and 690 bars spaced closer than 150 mm.

Live drawings show the plan section, the boundary element, the elevation and the P-M diagram with every combination; the 48-line summary reports demand, capacity, ratio and PASS / FAIL, with one overall result. Rectangular, symmetrically reinforced walls only, with the same boundary zone (or none) at both ends: flanged, C, L and barbell walls, openings, coupling beams, wall piers (screened only) and out-of-plane design are not covered. The ASCE 7-22 items follow published secondary sources; the Read Me lists them and what is still to be confirmed.

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + live plan section, boundary element, elevation & P-M diagram · SI units

Includes 2 files: Excel workbook: RC Shear Wall Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Retaining Wall Designer (ACI 318-19)

by RHCES

Design a cantilever reinforced-concrete retaining wall per metre run to ACI 318-19 (SI units): battered stem, level or sloping backfill, surcharge, soil over the toe and an optional reinforced shear key. Earth pressure by Rankine or Coulomb, with a minimum fluid pressure for a level backfill that you set.

Stability under service loads with your factors of safety: overturning, sliding (friction, adhesion, passive and key), the resultant in the middle third, bearing pressure and Meyerhof bearing capacity, plus an optional Mononobe-Okabe seismic check for both signs of kv. The stem, heel, toe and key are designed for Table 5.3.1 with 1.6H: flexure (tension-controlled), one-way shear by Table 22.5.5.1 with the size effect (which 13.2.6.2 lets you neglect in the footing), minimum steel 0.0018 Ag, crack control, clear spacing, cover, development and hooks, the 25.4.2.2 rule for fy 550 MPa bars, shear friction at the stem-footing joint and the cut-off of alternate stem bars.

A to-scale wall section redraws itself as you type, and the 53-line summary reports demand, capacity, ratio and PASS / FAIL for every check, with one overall result. Basement (at-rest) walls, water pressure, settlement and global stability are not covered.

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + live to-scale wall section · SI units

Includes 2 files: Excel workbook: RC Retaining Wall Designer, ACI 318-19 · Sample calculation, A4

Structural

RC Diaphragm Designer (ACI 318-19)

by RHCES

Design a cast-in-place reinforced-concrete floor or roof diaphragm (solid slab of uniform thickness) in both plan directions by the beam analogy of ACI 318-19 Chapter 12 and the seismic rules of 18.12, with the diaphragm forces of ASCE 7-22 12.10 (SI units): a rectangular plan with up to 8 lines of walls or frames each way and one opening, with storey forces for up to 50 levels worked out from the base shear and period, or typed.

Fpx by Eq. 12.10-1 within the limits of 12.10-2 and 12.10-3 (or typed), plus wind and transfer forces; line reactions by a flexible, rigid (with torsion) or envelope model, with live shear and moment diagrams. Checks: in-plane shear and its limit, chords, collectors by the force sets of 12.10.2.1 with Ωo and the Exception 1 cap (tension, compression, the average tensile stress of 18.12.7.5, the stress limit and hoops of 18.12.7.6, splice zones), shear friction with roughened joints in SDC D to F, collector extension, development and Class B laps (with 25.4.2.2), minimum thickness, minimum slab steel and bar spacing, and the net section, chords, trimmers and drag bars at the opening.

A live plan shows the lines, collectors, chords and opening; the 66-line summary reports demand, capacity, ratio and PASS / FAIL for every check, with one overall result. Precast, prestressed and non-rectangular diaphragms, the gravity (out-of-plane) design of the slab and the combined axial force and gravity moment of beam collectors are not covered. The ASCE 7-22 items follow published secondary sources; the Read Me lists them and what is still to be confirmed.

Every result is a visible Excel formula with ACI 318-19 section references. Includes the Excel workbook and a worked A4 sample calculation. One licence per engineer or office. Looking for the Philippine code? See the NSCP 2015 edition.

Excel · A4 calc sheets + live plan, shear & moment diagrams · both directions · SI units

Includes 2 files: Excel workbook: RC Diaphragm Designer, ACI 318-19 · Sample calculation, A4

Spreadsheets that do the work.

RC Beam Section Designer (ACI 318-19)

RC Column Section Designer (ACI 318-19)

RC Circular Column Designer (ACI 318-19)

One-Way Slab Designer (ACI 318-19)

RC Stair Designer (ACI 318-19)

Two-Way Slab Designer (Coefficient Method, ACI 318-19)

Two-Way Slab Designer (Direct Design Method, ACI 318-19)

Isolated Footing Designer (ACI 318-19)

Combined Footing Designer (ACI 318-19)

Strap Footing Designer (ACI 318-19)

Mat Foundation Designer (ACI 318-19)

RC Slab-on-Grade Designer (ACI 318-19)

RC Shear Wall Designer (ACI 318-19)

RC Retaining Wall Designer (ACI 318-19)

RC Diaphragm Designer (ACI 318-19)