Guide / Construction
Bid leveling template for Excel: the columns that matter
A good bid leveling template in Excel has one row per scope item and, for each bidder, a status, a price, a plug and the page it came from. Alternates sit in their own block. The adjusted total, base plus plugs, is the only number you compare. The sheet breaks when proposals have to be retyped, revised or traced after award.
01
What a bid leveling sheet is for
Sub bids never arrive on the same basis. One carries the fire caulking, one excludes it, one doesn't say. Leveling puts every bid on the same scope so the totals mean the same thing.
Rows are scope items. Columns are bidders. The adjusted total at the bottom is the number you compare.
02
Bid leveling template: the columns
| Column | What goes in it |
|---|---|
| Scope item | One line per item from your scope sheet or spec section. Set before bids arrive. |
| Budget | Your estimate for the line. |
| Status (per bidder) | Included, excluded or not mentioned. Blank is not an answer. |
| Price (per bidder) | The number as quoted. Lump sum if that's all they gave. |
| Plug (per bidder) | Your number for scope they left out, marked as a plug. |
| Note and page | Their clarification, and the page it sits on. |
| Alternates | Separate block below the base. Never in the base total. |
| Adjusted total | Base price plus plugs. The like-for-like number. |
| Variance | Adjusted total against budget. |
| Questions | What you asked each bidder, and the answer. |
03
Rules for filling the bid leveling spreadsheet
- Scope first. Build the rows from your scope before the first bid lands.
- Status every cell. "Not mentioned" is a question to the bidder, not an inclusion.
- Plug with a source. Your estimate or another bidder's price. Say which.
- Alternates apart. Price them, but keep them out of the base.
- Cite the page. Every number points back to the proposal it came from.
- Log revisions. When a bidder resubmits, record what changed and when.
04
Where the bid leveling sheet breaks
- Retyping. Every proposal comes in a different format. Each number is keyed by hand.
- Fine print. Exclusions sit on page four of a PDF and get missed.
- Lump sums. One number with no breakdown can't be leveled line by line.
- Revisions. A new version arrives and nobody knows which cells moved.
- No trail. After award, nobody can say where a plug came from.
- Copies. A fresh copy of the template per package. Formulas drift; history is lost.
Most of that is reading and typing, not judgment. It is the part a computer can take. See when to replace a spreadsheet.
05
What changes when proposals are read for you
- Read. Every proposal, PDF or spreadsheet, lands in one sheet.
- Trace. Each number links to its page.
- Flag. Scope no bidder carried, and exclusions, are marked.
- Ask. Questions to bidders are drafted for the estimator to send.
The estimator still sets plugs and picks the award. For how this compares with Procore's own tools, see bid leveling in Procore and with AI.
The bid package review prototype shows the leveling sheet, scope coverage and drafted questions with sample electrical bids.
Questions
Direct answers
Is Excel enough for bid leveling?
For a few bidders on a simple package, yes. It strains when proposals arrive in many formats, bids get revised, or several packages run at once.
What is a plug in a bid leveling spreadsheet?
A number you add for scope a bidder left out, so totals compare like for like. Mark every plug and write down where the number came from.
What does a custom bid leveling tool cost?
It depends on complexity and the business case. Book a call and bring a recent bid package.