How to do a quantity takeoff that holds up on bid day
Your estimate can't be better than your takeoff. If the conduit is short 20%, the drywall doesn't account for the second layer on the rated walls, or nobody counted the housekeeping pads, the unit prices don't matter. You've bid the job light. The free quantity takeoff template above gives you a disciplined structure: one line per item, tied to a spec section and a drawing, with waste, labor hours, and extensions calculated the same way every time, and a summary that rolls it all up by CSI division into a bid total.
What goes on each takeoff line
| Column | What to enter |
|---|---|
| CSI Division | Dropdown fed from the Summary tab (03 Concrete, 09 Finishes, 26 Electrical…). It drives the division subtotals. |
| Spec Section | The section that governs the item (e.g. 26 05 33 for raceways). Check it before you price, because the spec may call for a different material than you'd assume from the drawings. |
| Item / Description | Specific enough to price and to install: size, type, rating, and condition ("3/4 in. EMT, concealed above ceiling," not just "conduit"). |
| Dwg Ref | The sheet you took it off. When a revision drops, this is how you find what to re-take. |
| Measured Qty / Unit | What you measured or counted, with no waste. Units: EA, LF, SF, SY, CY, LB, TON, GAL, HR, LS. |
| Waste % | Per line, from your own history. Produces the Order Qty that material is priced on. |
| Labor Unit (hrs/unit) | Your hours per unit for this item and condition. You enter it. The template has no published units. |
| Material Unit $ | Current supplier pricing. Note the quote date on volatile commodities like copper, steel, and lumber. |
| Labor Hours / Extensions / Line Total | Formulas: hours = measured qty × labor unit; material ext = order qty × unit $; labor ext = hours × the crew rate cell. |
Counting and measuring conventions
Most takeoff errors come from inconsistency, not arithmetic. Two estimators taking off the same sheet will land within a couple of percent of each other if they follow the same conventions, and 15% apart if they don't. Write your conventions down and use them every time.
Counts (EA)
- Count by type and by area or floor, not one total for the building. Area breakouts make revisions, phasing, and change orders much easier to price.
- Mark every symbol as you count it, one highlighter color per item type. When the sheet is fully colored, you're done.
- Read the legend and the fixture/device schedule before you count. A symbol with a subscript letter is a different item.
- Count anything that drives the number twice, or have a second estimator count it: fixtures, devices, equipment, valves.
Linear measurements (LF)
- Measure the route the material will actually take, not the straight-line distance. Runs go around beams, ducts, and shafts.
- Add the vertical: drops from the ceiling to device height, stub-ups, risers between floors, and offsets. Plan-view takeoffs miss vertical footage all the time.
- Wire and cable = raceway length × conductors in the run, plus makeup at each termination.
- Pipe: measure centerline through fittings, and count the fittings separately.
Areas (SF / SY) and volumes (CY)
- Say whether the quantity is gross or net. A common convention is to measure gross and deduct only openings larger than a threshold you set. Write the threshold on the takeoff.
- Walls = perimeter × height, one side unless noted. Watch for rated walls, double layers, and full-height vs. ceiling-height partitions.
- CY = length × width × depth (all in feet) ÷ 27. Convert inches first: a 4 in. slab is 0.333 ft. Take off pads, curbs, and thickened edges as their own lines.
Scale and revisions
- Check the scale on every sheet against a known dimension before you measure. Half-size prints and PDFs that were re-plotted won't match the stated scale, and "NTS" details aren't to scale at all.
- When an addendum or revision lands, re-take only the clouded areas, and update the Dwg Ref column so the bid file shows what changed.
Waste is a material problem, not a labor problem
A lot of takeoff spreadsheets multiply the entire line, labor included, by a waste factor. That overstates labor on every item with meaningful waste. This template keeps them separate: labor hours come from the measured quantity (what gets installed) and material comes from the order quantity (measured plus waste). Set waste per line. Cut goods, stick material, and sheet goods carry waste. Counted items you install whole, like fixtures, panels, and equipment, usually don't.
Where your labor units should come from
This template has no published labor units in it, on purpose. Published units are a starting point at best. They assume average conditions and average crews, and your job may have neither. The units that win work at a profit come from your own cost reports:
- Track installed quantities and hours by cost code on every job, not just dollars.
- At closeout, divide actual hours by installed quantity for each item: that's your real labor unit.
- Keep separate units for different conditions: exposed vs. concealed, new work vs. remodel, first floor vs. high work off a lift, occupied building vs. empty shell.
- Apply condition factors deliberately. Don't pad every unit "just in case" and then add a contingency on top.
If you don't have that history yet, build it now. Every job you run is a free productivity study if your foremen report quantities installed along with hours. The productivity calculator can help you turn those numbers into units.
One composite crew rate
The takeoff prices all labor at a single composite burdened crew rate: the blended hourly cost of the crew mix you'll actually run (foreman, journeymen, apprentices), including payroll taxes, workers comp, and fringes. Build it once per job with the labor burden calculator and put it in the Crew Rate cell. Change it and every line re-extends.
From takeoff to bid: the Summary tab
The Summary tab subtotals hours, material, and labor by CSI division with SUMIF and shows each division's share of the total. A check line flags any takeoff dollars that didn't roll up because of a blank or misspelled division. It should always read $0. Below that, the bid recap adds sales tax on material, equipment and rentals, subcontracts, and general conditions to reach direct cost, then overhead, profit, and bond to reach the total bid. A schedule check divides total labor hours by crew size and hours per day, so you can see whether the manpower fits the duration before you commit to it.
For a fuller recap and a proposal letter, carry the totals into the estimate recap & bid proposal template. If part of the scope is going to subs, level their numbers first with the bid leveling matrix. For equipment costs, the equipment rate sheet works out what your owned and rented equipment really costs per hour.
Common takeoff mistakes
- Taking off from the wrong revision. Log the drawing set and addenda at the top of the sheet.
- Plan-view only. Missing vertical runs, drops, and risers is the most common way linear takeoffs come up short.
- Skipping the specs. The drawings show where; the specs say what. A spec that calls for rigid conduit, copper-only, or a higher finish level changes your price.
- Double-counting across sheets. Match lines and enlarged plans repeat work shown elsewhere. Note which sheet "owns" each area.
- One waste factor for everything. It over-buys some items and under-buys others.
- No second check. A 15-minute check of the big counts by someone else catches the errors that sink a bid.
When the job is won
A good takeoff becomes the job budget. Hours and quantities by cost code are what you track your crews against. Field PM turns the estimate into a cost-coded budget and collects installed quantities and hours from the field on daily reports, so you can see earned vs. burned hours while there's still time to fix a problem, and your labor units improve on every job. Start a free 30-day trial, no credit card required.
Related free templates and calculators
- Estimate recap & bid proposal template: markups, bond, and a proposal letter
- Bid leveling matrix: level sub and supplier bids on equal scope
- Equipment rate sheet: owned vs. rented cost per hour
- Labor burden calculator: build your composite crew rate
- Markup vs. margin calculator: set overhead and profit correctly
- Concrete calculator: slabs, footings, and pads in CY
- Browse all free construction templates
