Free Excel format
BBS format in Excel (free download)
Short answer
A bar bending schedule lists each bar with its diameter, number and cutting length, then works out total length and weight using d² ÷ 162 kg per metre. Download the sheet below; weights and the steel summary are already in formulas.
Preview
| Member | Bar mark | Dia (mm) | No. of members | Bars per member | Cutting length (m) | Total length (m) | kg per m | Weight (kg) |
|---|---|---|---|---|---|---|---|---|
| Footing F1 (example) | Bottom mesh X | 12 | 20 | 12 | 2.38 | 571.2 | 0.889 | 507.73 |
| Footing F1 (example) | Bottom mesh Y | 12 | 20 | 12 | 2.38 | 571.2 | 0.889 | 507.73 |
| Column C1 (example) | Main bars | 16 | 20 | 8 | 4.2 | 672 | 1.58 | 1,061.93 |
| Column C1 (example) | Ties | 8 | 20 | 28 | 1.1 | 616 | 0.395 | 243.36 |
| … | your items |
Example rows from a sample project. Delete them and type your own.
What's inside
- BBS sheet with total length and weight formulas
- Steel summary by diameter, 8 mm to 32 mm
- Total in kg and tonnes
- 50 blank rows ready to fill
Track steel from BBS to bill: PRIME ERP records steel measurements by weight and links the cost to each BOQ item. Start 14-day free trial
How to fill it
- One row per bar mark: member, bar mark, diameter, number of members, bars in each member and cutting length.
- Total length, weight per metre and weight work themselves out.
- The steel summary at the bottom adds up each diameter, in kg and in tonnes.
Questions
What is a bar bending schedule?
A list of every reinforcement bar in a member: its mark, diameter, how many there are, the cutting length, and the total weight. It is used to cut and bend steel and to bill it by weight.
How is the weight of a bar worked out?
Weight in kg per metre is the diameter in mm squared divided by 162. A 12 mm bar weighs 0.889 kg per metre. The sheet multiplies this by the total length.
Does the sheet work out the cutting length?
No. Cutting length depends on the shape, bend deductions, hooks and laps on your drawing, so type it in. Everything after it is worked out.
What does the steel summary show?
Total length and weight for each diameter from 8 mm to 32 mm, and the total in kg and tonnes, ready for ordering steel or billing it.