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
- Weight per bar (kg)
- Total weight per bar type (kg)
- Combined total steel weight (kg and tonnes)
- Optional cost estimate when price per tonne is entered
Who Benefits from This Tool
This sheet is used daily by quantity surveyors preparing Bills of Quantities, structural engineers doing material schedules, site engineers ordering steel, and students learning construction estimating. It is especially useful for one-way slab reinforcement layouts where bar spacing and cut lengths need to be summed systematically.
