Rebar Schedule & Weight Calculator in Excel (Simple BBS)

Reinforcement is one of the biggest costs in a concrete frame. An accurate take-off protects you from shortages that stop work and from surplus that wastes money.

This sheet works as a simple bar bending schedule. For each line enter the diameter, members, bars per member and bar length, and it calculates total length and weight, then totals by diameter and gives the number of stock bars to buy.

Who is it for?

• Site engineers and quantity surveyors
• Contractors ordering steel from suppliers
• Civil engineering students

What is inside the sheet?

• A table for forty lines: mark, element, diameter, count, length
• Weight per meter for 8 to 32 mm bars
• Total length and weight per line
• Summary by diameter: length, weight, weight with waste, stock bars, share
• Totals in kg and tons

How to use it

1. Enter the bar mark and element.
2. Pick the diameter, then enter members, bars per member and bar length including laps and bends.
3. Check the summary by diameter.
4. Adjust waste and stock bar length if needed.

Formulas used

• Weight per meter (kg/m) = diameter² ÷ 162
• Total length = members × bars × bar length
• Stock bars = length × (1 + waste) ÷ 12, rounded up

Worked example from the sheet itself

The sample has eight lines for footings, columns, stirrups, ground beams and a slab.

• Total weight is 5,411 kg, or 5,682 kg (5.68 tons) with 5% waste.
• The 12 mm slab bars alone weigh 2,397 kg, and the 16 mm bars need 87 stock bars of 12 m.

Tips for best results

• Use bar lengths from the drawings as they will actually be cut, including laps and hooks.
• Enter stirrups with their developed length.
• Compare the tonnage with the supplier invoice on delivery.

Frequently asked questions

Where does d²/162 come from?

From the bar cross-section times steel density of 7850 kg/m³. It is a standard practical approximation.

Does it optimize cutting?

No, stock bars are approximate (total length ÷ 12 m), good for the first order.

Can I use a different stock length?

Yes, change the stock bar length in the settings.

Download the sheet

Press the download button at the top of the page to get the Excel file. It includes a full guide sheet, yellow input cells and formulas protected from accidental edits. The sheet is also available in Arabic from the language switcher.