QUICK ANSWER
A bid leveling spreadsheet needs four things to be useful: a scope baseline column listing every item a complete bid should cover, bidder columns with inclusion/exclusion status for each scope item, a normalization section that calculates adjusted totals after scope gaps are plugged, and an award recommendation section that documents the decision. The most common mistake is starting with the bidder columns and working backward — the scope baseline must come first, or the comparison is only as complete as what the bids happen to mention.
INTRODUCTION
Every estimator has built a bid leveling spreadsheet. Most have built several — one for each project, each slightly different, each reflecting the pressures and shortcuts of the bid day it was created on.
The problem is not that estimators don't know how to build them. The problem is that ad-hoc spreadsheets built under bid-day pressure tend to be thin on scope coverage and inconsistent in structure. The estimator knows what they checked. The PM who reviews it a week later does not know what was not checked.
This article builds the spreadsheet correctly, from scratch, with the structure and scope depth that makes it a reliable analytical tool rather than a documentation artifact.
what a complete bid leveling template must include and how to structure it
BEFORE YOU BUILD: THE SCOPE BASELINE
The spreadsheet cannot be built until the scope baseline exists. This is the step most skipped, and the one that determines whether the spreadsheet is useful.
The scope baseline is the master list of every item a complete bid for this trade package should include. It is the left column of the spreadsheet — the reference against which every bidder is measured.
How to build the scope baseline for your spreadsheet:
Open the project specifications for the relevant division. Go section by section. For each specification section, identify the deliverables and responsibilities a fully scoped subcontractor must provide. Note each one as a line item.
Add the "usually excluded" items for this trade. Based on your experience with this trade, which items do subs routinely leave out? Add those explicitly. For mechanical packages: temporary heat, commissioning and startup, BAS interface, as-built documentation. For electrical packages: temporary power, switchgear (if owner-furnished), commissioning, fiber and low-voltage demarcation. For concrete packages: formwork, curing, flatwork finishing tolerances, saw-cut joints.
Add interface items. Where this trade touches another — mechanical-electrical on controls, structural-architectural on cladding connections — add explicit rows for who is responsible at each interface. These are the items most likely to fall through the cracks between trades.
The result is a list of 20–50 items (depending on trade complexity). This becomes the left column of your spreadsheet.
Per Archdesk's guide to subcontractor bid leveling (https://archdesk.com/blog/guide-to-subcontractor-bid-leveling), the scope baseline quality is the single most important factor in bid leveling accuracy. A strong baseline catches gaps a weak one misses entirely.
STEP 1: SET UP THE WORKBOOK STRUCTURE
Create a workbook with four tabs:
Tab 1 — Summary: One-page overview for PM and project leadership. Contains: bidder list, submitted prices, normalized prices, schedule inputs summary, award recommendation.
Tab 2 — Full Level: The working document. Contains: the complete scope matrix, all bidder columns, adjustment rows, qualifications log, clarification tracker.
Tab 3 — Clarification Tracker: A log of every clarification request sent, the date sent, the date response received, and the response text. This creates the paper trail.
Tab 4 — Historical Reference: A lightweight record of the normalized results and award for future reference. Useful when the same sub bids a follow-on project or when the PM questions a historical award.
STEP 2: BUILD THE SCOPE MATRIX (TAB 2)
Start with the left column: your scope baseline items. Group them by category:
Category A — Primary scope (the main work of the trade)
Category B — Temporary conditions (temporary heat, power, protection)
Category C — Closeout and commissioning (as-builts, O&M manuals, startup, commissioning)
Category D — Interface responsibilities (penetrations, firestopping, coordination)
Category E — Administrative (submittals, schedule, coordination meetings, permit participation)
For each scope item row, include:
- Item code (e.g., C-01 for commissioning item 1)
- Item description
- Specification reference (CSI section number if applicable)
- "Required?" flag — Yes/No based on project spec review
This last column is useful when some scope items are contract options or addenda items. Items marked No are removed from the comparison; items marked Yes are the baseline.
Now add bidder columns. For each bidder, add three sub-columns:
- Status: INC / EXC / UNCLEAR
- Notes: free text for qualifications, conditions, or source reference
- Add Price: if EXC, the confirmed add price from the sub (from clarification) or blank
At the bottom of the bidder columns, add the pricing section:
- Submitted base bid
- Total of add prices for excluded items
- Normalized total (submitted + adds)
- Normalized rank
STEP 3: BUILD THE NORMALIZATION FORMULA
The normalization formula is straightforward:
Normalized Total = Submitted Base Bid + SUM of Add Prices for all EXC items in this bidder column
Use Excel's SUMIF function to sum only the rows where the Status column equals "EXC" for a given bidder column. This avoids manual summing errors and updates automatically if you add more exclusions.
=Submitted_Price + SUMIF(Status_Range,"EXC",AddPrice_Range)
Apply this formula to all bidder columns. The normalized total row becomes the primary comparison row.
Add a conditional format to highlight the lowest normalized total — green fill for the lowest value. This makes the comparison immediately visible on the Summary tab.
STEP 4: ADD THE ADJUSTMENT DOCUMENTATION SECTION
Below the normalized totals, add a section that documents each adjustment:
For each scope item that has at least one bidder showing EXC:
- Item code and description
- Which bidders exclude it
- Add price source: confirmed by clarification (specify date and reference) or plug number (specify basis: GC estimate, comparable bid, historical data)
- Add price amount used
This is the documentation section that explains to the PM why Bidder A's normalized total is $120,000 above their submitted price. Every adjustment has a documented source. Every plug number has a stated basis.
This documentation is also your protection if the award recommendation is questioned. The analysis is auditable.
STEP 5: ADD THE SCHEDULE INPUT SECTION
Below the price analysis, add a schedule input section. For each bidder:
- Long-lead equipment items and confirmed delivery dates
- Crew start date availability
- Stated schedule conflicts or conditions
Flag any bidder whose schedule inputs are incompatible with the project schedule. A normalized price that requires a 22-week equipment lead on a 20-week critical path is not a viable award regardless of the price.
STEP 6: ADD THE QUALIFICATIONS LOG
The qualifications log is separate from the exclusions matrix. It captures conditions attached to the bid — assumptions, contingencies, and conditions that are included in the price but conditional on specific circumstances.
For each bidder, list every qualification from their proposal:
- Qualification text (verbatim or paraphrased)
- Impact assessment: cost impact if the condition triggers (estimated or confirmed)
- Resolution status: addressed in clarification, to be addressed in subcontract scope letter, or accepted
Qualifications that represent significant contingent cost exposure should be flagged in red and addressed before award. Per Procore's bid evaluation guide (https://www.procore.com/library/bid-evaluation), unresolved qualifications in the bid that survive into the subcontract are among the most common sources of post-award disputes.
STEP 7: BUILD THE SUMMARY TAB
The Summary tab is what the PM sees. It should be clean, clear, and self-explanatory.
Include:
- Package name, project name, date
- Bidder table: company name, submitted price, normalized price, normalized rank
- Key scope gaps summary: 3–5 bullet points on the most significant scope differences discovered
- Schedule summary: any bidder schedule flags
- Significant qualifications: any unresolved qualifications the PM should know about before the award meeting
- Award recommendation: recommended bidder, awarded price, rationale in 3–5 sentences
The Summary tab should be printable and self-contained. A PM who was not in the leveling session should be able to read it and understand what was analyzed, what was found, and why the recommended bidder was selected.
THE LIMITS OF THIS APPROACH
A well-built spreadsheet does the analysis reliably. What it cannot do:
Read PDF proposals automatically. Every scope item classification in the matrix was entered by a human who read the proposals. If an exclusion was buried on page 38 and missed in the review, it will not appear in the matrix.
Version control itself. When two estimators update the same workbook on different machines, conflicts arise. Use a shared cloud location (SharePoint, Google Drive) and establish a clear owner for each bid level.
Scale efficiently to high bid volume. On a complex project with 12–15 trade packages due on the same day, building and populating 12–15 spreadsheets manually is the bottleneck.
software that automates the population of bid leveling spreadsheets for high-volume workflows
MELTPLAN SOLUTIONS
How Melt Bid Populates This Spreadsheet for You
The spreadsheet structure described in this article is exactly what Melt Bid produces. The AI reads the subcontractor proposals, extracts scope coverage data, and auto-populates the comparison matrix — the inclusion/exclusion status, the qualifications notes, and the scope gap flags.
The estimator gets a pre-built matrix ready for review, not a blank spreadsheet to populate from scratch. The structure is the same. The time to produce it is not.
For estimators who have built this spreadsheet manually many times and know what it should contain, Melt Bid is a tool that removes the excavation step and leaves the analysis step. The expertise stays with the estimator. The data entry moves to the machine.
See how Melt Bid's bid leveling tool that works in Excel reduces the time from bid receipt to leveled matrix at meltplan.com/bid (https://www.meltplan.com/bid).
FREQUENTLY ASKED QUESTIONS
What should a bid leveling spreadsheet include?
At minimum: a scope baseline column, bidder status columns (INC/EXC/UNCLEAR for each scope item), pricing rows with submitted and normalized totals, an adjustment documentation section, a qualifications log, schedule inputs, and an award recommendation. The scope baseline — the list of everything a complete bid should cover — is the most important structural element.
What columns should a bid leveling spreadsheet have?
Each bidder needs at minimum: inclusion/exclusion status per scope item, notes/qualifications per scope item, submitted price, add price for excluded items, and normalized total. The scope items are rows, not columns — the trade's scope baseline defines the rows, and each bidder gets a column set.
How many tabs should a bid leveling workbook have?
Four is the recommended minimum: a Summary tab for PM review, a Full Level tab for the working analysis, a Clarification Tracker tab for BCR documentation, and a Historical Reference tab. Additional tabs may be useful for complex projects with alternates or unit price schedules.
Should I use a different spreadsheet template for each trade?
The workbook structure can be standardized, but the scope baseline rows should be trade-specific. A mechanical bid leveling template needs different scope rows than an electrical template. Using a universal template with generic rows produces weaker coverage than trade-specific scope baselines. Build one strong template per trade type and reuse it.
CONCLUSION
The spreadsheet is not complicated to build. The scope baseline is the hard part — and it is hard not because the Excel work is difficult, but because building a complete scope list requires knowing the trade, knowing the project, and knowing what subs in this market routinely exclude.
That knowledge is the estimator's. The spreadsheet is just the structure that makes it visible and traceable.
Build it right. Use it every time. The scope gaps it catches will consistently exceed the time it took to build.
REFERENCES
1. Archdesk — Guide to Subcontractor Bid Leveling: https://archdesk.com/blog/guide-to-subcontractor-bid-leveling
2. Procore — Bid Evaluation: https://www.procore.com/library/bid-evaluation
3. DownToBid — Free Bid Leveling Template: https://downtobid.com/blog/bid-leveling-template
4. Buildr — Tools for Comparing Subcontractor Bids Automatically: https://buildr.com/blog/tools-for-comparing-subcontractor-bids-automatically/