This Excel sheet provides a fast and accurate method to calculate the quantity and weight of steel reinforcement bars (rebar) used in slabs, beams, columns, and other structural elements. Just input the bar diameter, length, and quantity — this tool will instantly compute the total steel weight based on standard unit weight formulas. Perfect for engineers, estimators, and site supervisors for quick and reliable results.
Why Accurate Steel Quantity Estimation Matters
Rebar quantity takeoff is a critical step in structural construction. Under-ordering steel delays the project; over-ordering inflates material costs. For large buildings, even a 2–3% error in steel estimation can translate to significant cost overruns or shortage-related delays on site.
This Excel sheet eliminates manual calculation errors by automating the unit weight formula for all standard bar diameters.
The Unit Weight Formula Used
The sheet uses the universally accepted formula for unit weight of steel rebar:
Weight (kg) = (D² / 162) × Length (m)
Where D is the bar diameter in millimetres. This formula gives the weight per metre for each bar size, and the sheet multiplies by the number of bars and their lengths to give total weight in kg or tonnes.
Bar Diameters Supported
The sheet supports all standard metric bar sizes: T8, T10, T12, T16, T20, T25, T32, and T40. Imperial bar sizes (#3 through #11) can also be handled by adjusting the unit weight values.
What the Sheet Calculates
- Total steel weight per bar diameter, based on measured or specified bar lengths
- Total number of bars required for a given slab, beam, or column layout, derived from spacing and member dimensions
- Combined steel weight across multiple bar diameters and structural elements for a full estimate
- Steel weight per square metre of slab area, useful for quick cross-checks against typical reinforcement ratios
- A summary table breaking down quantity and weight by bar diameter for the bill of quantities
Design Inputs Required
- Bar diameter for each reinforcement type used in the slab (main bars and distribution bars)
- Bar length or, alternatively, slab span and bar spacing so the sheet can derive the number and length of bars
- Number of bars per layer, or spacing centre-to-centre
- Slab area or plan dimensions, for a per-square-metre steel ratio check
- Lap length and development length allowances, if being included in the takeoff
Applicable Design Codes
The unit weight formula used in this sheet is the standard metric formula for deformed steel bars referenced across ACI 318, BS 8110, and IS 456 design and detailing practice, so the quantity takeoff is consistent regardless of which design code was used to arrive at the reinforcement layout.
Who Should Use This Tool
This sheet is aimed at site engineers, quantity surveyors, and estimators who need a fast rebar takeoff for a bill of quantities, as well as structural engineers who want a quick check on the total steel weight implied by a slab reinforcement drawing.
Download the Free Slab Steel Estimation Sheet
Counting bars and multiplying by unit weight by hand for every diameter on a drawing is slow and prone to transcription errors, especially on larger slabs with mixed bar sizes. This Excel sheet automates the unit weight calculation and totals the steel quantity across all bar diameters used, giving a reliable figure for procurement and billing. Download the free sheet above and enter your own bar schedule to get an instant steel quantity and weight estimate.
Be the first to comment.