Rebar Calculator Excel: Formulas & Free Templates

Multiply total length by the published unit weight: =total_ft*0.668 gives pounds of #4. For metric sheets, the D²/162.2 formula does it in one cell: with diameter in millimeters in B2 and length in meters in C2, =B2^2/162.2*C2 returns kilograms — a 12 mm bar 10 m long weighs 12²/162.2 × 10 = 8.88 kg. In imperial, keep a two-column lookup table (#3 = 0.376 through #8 = 2.670 lb/ft) and a VLOOKUP, because the imperial numbering does not follow a single closed formula. Add (1+waste) to the order line, not to the net weight, so the takeoff and the waste stay visible as separate numbers.

=ROUNDUP(length_in_feet*12/spacing_in_inches,0)+1. The ROUNDUP guarantees a bar lands on or past the far edge, and the +1 is the starter bar — the fence-post rule that a 40 ft run at 18 in needs 28 bars, not 27. The most common spreadsheet failure is writing ROUNDDOWN or forgetting the +1, which under-counts every run by exactly one bar; across 60 runs that is a full stick of steel short on pour day. Copy the formula with absolute references ($ signs) on the spacing cell so a drag-fill down 200 rows cannot silently repoint it.

Plenty exist, but downloading an unvetted rebar spreadsheet is how wrong numbers ship: the two universal defects are unit-weight tables typed from memory (#5 listed at 1.0 lb/ft instead of 1.043) and missing starter-bar +1 terms. The safer free route is the one this page teaches: build the 7-step template yourself in about 40 minutes with the copy-paste formula generator above, then verify it against this site's free online calculator with one known slab. Your own sheet, checked against a second tool, beats any anonymous download you cannot audit.

It is the metric unit weight of rebar compressed into one constant. Steel weighs 7,850 kg/m³, a bar's cross-section is π×D²/4, so weight per meter = 7,850 × π×D²/4 ÷ 1,000,000 = 0.006165×D² kg/m — and 1/0.006165 = 162.2, giving D²/162.2 kg per meter. The 162.2 constant is the reason the formula is memorized worldwide: one square of the diameter replaces a five-step derivation. Remember its limits: D must be millimeters, the answer is kg per meter, and the result is nominal — rib deformations move real bars about 1–2% around it, which is why published tables still win for billed weight.

Yes, at two levels. A manual first-fit column — sort required lengths descending, then assign each to the first stock stick with room — is five formula columns and typically cuts waste from about 10% to around 7%. A small VBA macro running first-fit-decreasing over mixed 20/40-ft stock pushes it to 2–3%, and the results table in this guide shows the exact progression on a real 112-piece order. Microsoft's Solver add-in can also attack it as an optimization problem, but it slows to a crawl past a few hundred pieces — the 30-line macro path is what fabricators actually run. The macro pays for itself on any job above roughly 80 pieces; below that, sort-and-assign by hand is faster than writing it.

Use Excel when one of three conditions holds: the takeoff covers more than roughly 15–20 members (drag-fill beats re-entry), the job site has no signal (a downloaded sheet never needs Wi-Fi), or someone else must audit your numbers (a workbook carries its own logic). Use the online calculator for the opposite case — a single slab, a fast cross-check, or a homeowner who should never touch a formula. The crossover shows up in the comparison matrix above: the web tool wins every single-item dimension, Excel wins every batch and offline dimension, and the tipping point sits near a dozen members.

Two columns: bar number in H (3 through 8), unit weight in I (0.376 through 2.670 lb/ft). Name the range WEIGHT_TABLE, then anywhere in the sheet: =VLOOKUP(BAR_SIZE,WEIGHT_TABLE,2,FALSE) returns the lb/ft for whatever size the input cell holds. Three details make it bulletproof: FALSE (exact match) so a typo in a #4.5 cell errors instead of guessing, whole numbers in the lookup column so Excel matches your validation list, and one header-free block so the named range cannot drift. Wrap it in IFERROR to show a blank instead of #N/A when the size cell is still empty.

The math is identical — count, feet, unit weight, waste — so a correct spreadsheet and $1,600 takeoff software land on the same tonnage for grid work. The accuracy risk is never the arithmetic; it is the four classic sheet defects: missing starter-bar +1, spacing entered in the wrong unit, a mistyped unit-weight row, and laps omitted on runs longer than stock. The verification habit in Step 7 closes that gap: run one known slab (40×30 ft, #4 @ 18 in ≈ 1,122 lb net) through both your sheet and an independent calculator each time you touch the formulas. Agree within 2% and the spreadsheet is order-grade; disagree and you found the typo before the supplier did.