Concrete Estimating Spreadsheet in Excel: Bid the Pour, Not the Guess

A concrete sub loses money in the truck, not on the invoice. You walk a slab, eyeball "about forty yards, couple grand of steel, two guys for a day," and write a number on the back of the plans. Then the pour comes up two yards short because nobody counted the turndown, the last truck rolls in with a short-load fee, and the yards you over-ordered on the next job get dumped in a wash rack because you had nowhere to put them. A concrete estimating spreadsheet in Excel kills that guess. It computes cubic yards from real dimensions, adds the waste factor before you round, prices the rebar and the placement labor as their own line items, and hands you a bid that actually covers the pour instead of one you hope covers it.

This article builds that estimator in one workbook. You get the concrete takeoff spreadsheet that turns length, width, and thickness into ordered yards, the waste and short-load logic that keeps you from being the guy chasing a second truck, and the bid sheet that rolls concrete, steel, pump, and labor into a defensible number. The point is not to make you slower. A clean takeoff is faster than the guess, because the guess costs you a callback, a cold joint, or a margin you never see.

The Money You Lose Guessing Yardage

Ready-mix concrete runs about $175 per cubic yard delivered for a standard 3,000 to 4,000 psi mix in 2026, and that is before the fees that live in the fine print of the supplier ticket. Two of those fees eat concrete subs alive. The short-load fee hits every delivery under a full truck, usually anything below eight to ten yards, and it runs $40 to $60 per yard short or a flat charge near $150. The second is invisible: the yards you order and never place. Order 44 and pour 40 and you just paid $700 for concrete that hardened in the drum or got washed down a slope.

Guessing pushes you into one of those two holes on almost every job. Under-guess and you come up short mid-pour, the finisher stands around while a second truck batches, and you either eat a short-load fee or fight a cold joint where the two loads met. Over-guess to be safe and you bleed the waste on every pour instead. The fix is not a bigger cushion. It is a takeoff that gives you the real number, then adds one honest waste factor on top so the cushion is sized on purpose, not on nerves.

Build the Takeoff That Computes Cubic Yards

Every concrete estimate starts with volume, and volume is where the guess does its damage because a slab and a footing are not the same math. Give each element its own row so the cubic yards calculator in Excel adds them up instead of you carrying them in your head.

The slab formula

A flat slab is length times width times thickness, divided by 27 to convert cubic feet to cubic yards. The only trap is thickness, which lives in inches on the plans and has to become feet before it multiplies. Lay it out so the formula reads the inches directly:

With length in B2 (40 ft), width in C2 (60 ft), and thickness in inches in D2 (5 in), the slab volume in E2 is =(B2C2(D2/12))/27. That returns 37.0 cubic yards. The D2/12 converts the 5-inch slab to 0.417 feet, and the /27 converts cubic feet to yards. Change the thickness to 6 inches and the number moves to 44.4 without you touching anything else, which is exactly the kind of what-if that catches a design change before it catches your margin.

Footings, turndowns, and columns

The turndown edge is the line item that turns a profitable slab into a break-even one because it is easy to miss and never small. Model it as a cross-section times a run. A 12-inch by 12-inch thickened edge around a 40 by 60 slab has a perimeter of 200 linear feet. Put width in inches in B3 (12), depth in inches in C3 (8, the part below the slab), and run in feet in D3 (200). The volume in E3 is =(B3/12)(C3/12)D3/27, which returns 3.3 cubic yards. That is nearly $600 of concrete plus the placement to go with it, sitting in a line item the guess never opens.

Stack every element the same way and total them. If your slab is in E2 and your turndown is in E3, the total needed in E7 is =SUM(E2:E6), which leaves rows for columns, piers, or a second slab. The needed number here is 40.3 cubic yards, and it is the number you place, not the number you order. Those are two different figures, and confusing them is the single most common way a concrete estimating spreadsheet in Excel still loses money.

Add the Waste Factor Before You Round Up

Concrete has spillage, over-excavation, form deflection, and the simple fact that you cannot place the last shovel of a load with a trowel. The real world eats 5 to 10 percent of what you batch, more on rough subgrade or hand-placed footings. Set the waste factor as its own cell so it is a decision, not an accident. Put 8% in B10, then compute the order in E10:

=CEILING(E7*(1+$B$10),0.5). That takes 40.3 needed yards, adds 8% to reach 43.5, and rounds up to the nearest half yard the supplier will actually batch, giving 44 yards ordered. Locking the waste factor in one cell also lets you tune it by job type. Slab-on-grade over a laser-screeded base might run 5%. Footings in trench with a pump might run 12%. You change one number and the order updates, which beats carrying three different mental rules for three different pours.

Now protect yourself from the short-load fee with a flag instead of a memory. The fee triggers on deliveries under the supplier threshold, so test the order against it. With the threshold in B11 (8 yards), put =IF(E10<$B$11,"SHORT LOAD FEE LIKELY","FULL LOADS") in F10. On a 44-yard pour that reads FULL LOADS. On a 5-yard equipment pad it reads SHORT LOAD FEE LIKELY, and you add the fee to the bid before you lose it on the ticket. The second flag watches your over-order: =IF((E10-E7)*$B$12>300,"REVIEW WASTE","OK"), where B12 holds the $175 unit cost. If the yards you ordered but do not need cost more than $300, the sheet tells you to look again before you pour money into the wash rack.

Rebar and Placement Labor, the Line Items That Sink Bids

Concrete is the headline, but reinforcing steel and placement labor are where a thin bid actually goes underwater. Both scale with the job in ways that are easy to underprice by feel, so the concrete cost estimator has to compute them, not gut-check them.

Reinforcing steel

Rebar in a slab is a grid, and a grid is countable. For #4 bar at 18 inches on center each way in a 40 by 60 slab, count the bars in each direction and multiply by their length. Bars running the long way sit across the 40-foot width: =(ROUNDUP(B2/($B$14/12),0)+1)C2, where B14 holds the 18-inch spacing. That returns 27 bars times 60 feet, or 1,620 linear feet. Bars the short way run across the 60-foot length: =(ROUNDUP(C2/($B$14/12),0)+1)B2, giving 41 bars times 40 feet, or 1,640 linear feet. Sum them for 3,260 linear feet, then add lap splices: =(3260)*(1+$B$15) at a 10% lap factor lands near 3,586 linear feet. At $0.85 per foot for fabricated grade 60 material, that is roughly $3,048 of steel, a number you never want to discover after you signed.

Placement crew hours

Labor is yards divided by a production rate, times crew size, times a loaded wage. A five-man crew placing and finishing a flatwork slab with a line pump runs around 5 cubic yards per crew-hour on the placing side. Needed yards in E7, production rate in B17 (5), crew size in B18 (5), and loaded wage in B19 ($55) give man-hours in one cell: =(E7/B17)B18, which returns 40 man-hours, and cost as =(E7/B17)B18*B19, or $2,200. Loaded wage means the real cost of the man on the job: base pay plus payroll taxes, workers comp, and burden, not the number on his check. Bid the check rate and you are financing your own crew.

The Bid Sheet That Ties It Together

The takeoff feeds one bid sheet where every cost is a line, the markup is a single cell, and the bottom line is a formula you can defend to a GC line by line. Here is the 40 by 60 reinforced slab priced the way the spreadsheet does it.

Total the direct costs with =SUM(E20:E26), apply markup with =E27*(1+$B$28) where B28 holds 0.20, and you have $19,330 before you round the bid to $19,500. Now add the sanity check the guess never has. Cost per placed yard is =E29/E7, or $479 per cubic yard on the 40.3 you actually pour. Set your floor and flag it: =IF(E29/E7<$B$30,"TOO LOW, REVIEW","OK"), with your break-even per yard in B30. If a fat-fingered dimension or a missed line drops you under the floor, the sheet says so in red before the number leaves your truck, not after the GC accepts it.

Run the guess against the takeoff

The same slab, guessed, gets bid near $14,000. The estimator forgot the 3.3-yard turndown, skipped the waste factor and under-ordered, priced rebar by feel at "a couple grand," and lumped labor into a round number. Come pour day it is a truck short, eats a short-load fee, fights a cold joint, and the finished job clears maybe $1,500 on a slab that should have carried $3,200. That $1,700 gap is not bad luck. It is the difference between a number you computed and a number you hoped for, repeated across every pour on the calendar.

Concrete Bid Checklist

Before any concrete number leaves your desk, the spreadsheet should confirm all of it:

• Every element has its own volume row: slab, turndown, footings, columns, piers.
• Thickness is entered in inches and divided by 12 inside the formula, not converted by hand.
• The waste factor is a single named cell, sized to the job type, applied before rounding.
• The order is rounded up to a half yard the supplier will batch, and the short-load flag has been read.
• Rebar is counted as a grid with lap splices added, priced per foot, not estimated as a lump.
• Labor is yards over a production rate at a loaded wage, not a crew day pulled from memory.
• The pump, vapor barrier, and equipment each have a line, because a forgotten line is a free line for the GC.
• The cost-per-yard flag reads OK against your floor before you round and send.

Bid the Pour on Numbers, Not Nerves

A concrete estimating spreadsheet in Excel is not about loving spreadsheets. It is about never again standing on a slab watching a finisher wait for a truck that should have been ordered, or watching yards you paid for run down a wash rack because the guess ran the other way. The takeoff computes the cubic yards, the waste factor sizes the cushion on purpose, and the bid sheet proves the number covers concrete, steel, pump, and labor with margin left standing.

If you would rather not rebuild that takeoff and bid sheet from a blank workbook on every job, SheetCraft's Construction Budget Tracker ships with a concrete estimate structured this way already: element-by-element volume rows with the cubic yards math built in, the waste factor and short-load flag wired up, rebar and placement labor priced as their own lines, and a cost-per-yard check that catches a thin bid before it leaves. The same workbook carries your estimate straight into budget tracking, so the yards and dollars you bid are the yards and dollars you watch against the actual pour. Bid the takeoff, not the guess, and keep the waste off your fee.