Work out the rebar takeoff

Rules

Weight per metre table

The weight per metre of 17 bar sizes from Ø6 to Ø50 comes from π/4 × Ø² × 7.85, to 3 decimals. Standards may give the nominal mass to other digits; you can enter your own value as the unit weight.

Own unit weight

Enter the unit weight by hand for another steel or standard. For an "Other" size it is required; lines with their own value are totalled apart.

Waste and laps

The tool adds no waste or lap allowance. Lap lengths are inside the bar length you enter; waste is up to the item description and the contract.

Totals per bar size

Each size's length and weight are totalled apart; the grand total is given in kg and tonnes. Tonnes are a thousandth of the kg, worked out from the exact value, not the rounded kg.

No rounding along the way

Lines and total are worked out with exact values; only the figure on screen is rounded: m, m², m³ and kg to 3 decimals, tonnes to 6. A copied value carries 8 decimals. A quantity rounded along the way leaves a gap that turns into money once multiplied by the unit price.

Deduction lines

Each thing to deduct goes on its own line, marked as a deduction; the sheet counts it negative. If the deductions exceed what was added, no total is given.

Measurement rules come from the item description

The "Measurement" clause of the item description and the technical specification decide which voids are deducted and how intersections are measured. The tool applies no void threshold and deducts no intersection by itself.

Copying for Excel

The sheet is copied with its header, lines and total as tab-separated text. Numbers use the page's decimal mark and no thousands separator; deductions carry a minus sign.

• Price IndicesDomestic PPI sub-indices and CPI, monthly tables since 2012.
• Price Adjustment CalculatorPrice adjustment with the official formula, from Domestic PPI and CPI.
• Progress Payment Deductions CalculatorThe cover's VAT, every deduction from a) to k) and the net amount paid to the contractor, on one sheet.
• Index Change CalculatorHow Domestic PPI and CPI moved since your tender month, with the In/Io ratio.
• Work Experience Update CalculatorWhat a work experience certificate counts for in the tender you enter, with the right Domestic PPI months for its kind.
• Stamp Duty CalculatorThe 9.48 per mille stamp duty on a progress payment, with the yearly cap.
• VAT Withholding CalculatorThe VAT withheld on a progress payment, at the communiqué's rate for the work type.
• Withholding Tax CalculatorWithholding tax on a multi-year construction payment, at the rate for the work type and payment month.
• Performance Bond CalculatorThe performance bond on a bid, with the below-limit 9% rule and additional bonds.
• Minimum Labour CalculatorThe minimum labour to declare for the SGK clearance, the shortfall and its estimated premium.
• Advance Payment CalculatorThe advance, its 30% or one-third cap, the recovery rate and what comes off each progress payment.
• Work Increase CalculatorThe work increase room left under the 20% (unit price) or 10% (lump sum) limit.
• Completion Compensation Calculator5% of the shortfall when work ends below 80%, updated to the acceptance month by Domestic PPI.
• Delay Penalty CalculatorThe delay penalty from the first contract price, daily rate and days late, with the 15% cap.
• Work Duration CalculatorCompletion date from the site handover, days late, final acceptance and payment deadlines.
• Fuel PricesEPDK monthly averages by fuel type, for the fuel coefficient of a price adjustment.