EstimatingExplore estimating

Free construction template

Bid Tabulation Template

A bid tab lays every bid received for a trade package side by side, one bidder per column, so the prices can be compared item by item. On this page: a free Excel bid tab with scope leveling, a worked example where the low bid changes, where plug values come from, and our view on reading bids.

Bid Tabulation Template in Excel: the Bid tab sheet with its sample rows
The Bid tab sheet as it opens, with the sample rows you overwrite.

What is in the workbook

  • Package, bid date, and each bidder's base bid across the top
  • Rows for all addenda acknowledged and bond included, so a nonresponsive bid shows at once
  • Up to 12 scope items, each with your own plug value and a Yes or No for every bidder
  • Amount added for scope left out, leveled total, rank, low leveled bidder, and the spread before and after leveling

Get the bid tabulation template (Excel)

Enter your work email and the download unlocks right here.

Need your own numbers to level against? Get the takeoff free.

Send one set of drawings from a job you are bidding and we take it off free, every quantity tied to the sheet it came from.

The takeoff screen on a sample masonry elevation.
See AI takeoff and estimating

No card. Your estimator decides what happens next.

Bid tabulation vs bid leveling

A bid tab on its own can name the wrong low bidder, because the lowest number is often the one that leaves the most out. The bid tabulation glossary entry and the bid leveling glossary entry cover each step.

Bid tabulationBid leveling
What it recordsEach bid as submittedEach bid adjusted to the same scope
Missing scopeShown as missingPriced at your plug value
What it answersWho bid whatWho is lowest for the same work

A worked bid tabulation example

Take an illustrative drywall and ceiling package on an office build-out, with four bids in. Bidder D is low on base bid at $389,900, but it leaves out six scope items and did not acknowledge every addendum. Priced at the general contractor's own plug values, the missing scope adds $28,040.

BidderBase bidScope left outLeveledRank
Bidder A$412,000$5,040$417,0402
Bidder B$398,500$7,800$406,3001
Bidder C$421,300$0$421,3004
Bidder D$389,900$28,040$417,9403

Bidder D left out blocking $4,900, access panels $5,040, firestopping $7,800, Level 5 finish $3,200, cleanup $2,600 and seismic bracing $4,500, which total $28,040.

Once leveled, Bidder B is low at $406,300 and Bidder D drops to third. The spread between high and low falls from $31,400 to $15,000, which is a sign the bids now describe the same work.

Where plug values come from

A plug value is your own price for a scope item a bid leaves out. Take it from your estimate or from the bids that include the item, never from the bidder that left it out. Then call the bidder: many will add the item at a price, and the bid tab records the answer. The scope lines themselves come from the free scope of work template.

Before you award

  • Every bidder acknowledged every addendum.
  • The bond is in hand if the package required one.
  • Each No on the scope grid has been confirmed with the bidder, not assumed.
  • The low leveled bidder's qualifications and exclusions are read line by line.

Our view: read the base bid column last

In our view, the base bid column should be read last. Fill in the scope grid first, price every gap, and only then rank the bids, so the comparison is between the same work.

Bid tabulation template FAQs

What is a bid tabulation in construction?+

It is the comparison sheet for one package: each bidder's base bid, alternates and unit prices in its own column, with the same rows for everyone.

What is the difference between bid tabulation and bid leveling?+

Bid tabulation records bids as submitted. Bid leveling adjusts them for differences in scope, so the comparison is between bids for the same work.

What is a plug value in bid leveling?+

A plug value is the general contractor's own price for a scope item that a bid leaves out, added to that bid so it can be compared fairly with bids that include the item.

Is the lowest bid always the winner?+

No. On private work the general contractor awards on the leveled number, scope and qualifications. On public work the law usually requires award to the lowest responsive, responsible bidder.

How many bids should a general contractor get per package?+

Enough to compare, often three or more, but three full-scope bids beat six partial ones. A bid tab shows quickly which bids are complete.

Is the bid tabulation template free?+

Yes. A work email unlocks it, and you can copy the sheet for every package you bid.

This template is a comparison tool, not legal or procurement advice. Public owners and your own procedures may set how bids are opened and awarded.