A bid tab that levels the scope before it ranks the price.
Enter every bidder’s price and scope per line. The sheet prices each exclusion at a plug, gives each bidder a leveled total, ranks them and keeps addenda, bonding, prequalification and qualifications beside the numbers.
What’s in the workbook
The download is one Excel file (65 KB) with 2 sheets: Instructions, Bid tab. The formulas are live, the inputs are marked, and it opens in Excel for Windows and Mac, Excel for the web, Google Sheets and LibreOffice. This is the Bid tab sheet with the sample data:
Formula in P7: =IF(OR($B7="",H$3=""),"",IF(OR(L7="Excluded",N(H7)=0),$F7,H7))| A | B | D | F | G | H | I | K | L | M | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Bid tabulation and leveling | ||||||||||||
| 2 | Package | BP-14 Interior glazing and storefront | 4/14/2026 | ||||||||||
| 3 | Bidder name → | Northline Glass | Keystone Glass | Summit Glazing | Northline Glass | Keystone Glass | Summit Glazing | Northline Glass | Keystone Glass | Summit Glazing | |||
| 4 | # | Scope item | Estimate / budget | Plug used | Bidder 1 price | Bidder 2 price | Bidder 3 price | Bidder 1 scope | Bidder 2 scope | Bidder 3 scope | Bidder 1 leveled | Bidder 2 leveled | Bidder 3 leveled |
| 5 | 1 | Storefront system, level 1 lobby | $410,000 | $396,500 | $404,000 | $396,500 | $425,500 | Included | Included | Included | $404,000 | $396,500 | $425,500 |
| 6 | 2 | Curtain wall, east elevation | $690,000 | $671,000 | $702,000 | $709,000 | $671,000 | Included | Included | Included | $702,000 | $709,000 | $671,000 |
| 7 | 3 | Fire-rated glazing, stairs 1 and 2 | $145,000 | $139,500 | $152,000 | $139,500 | Included | Excluded | Included | $152,000 | $139,500 | $139,500 | |
| 8 | 4 | Interior glass partitions, level 2 | $220,000 | $214,000 | $214,000 | $238,000 | $231,000 | Included | Included | Qualified | $214,000 | $238,000 | $231,000 |
| 9 | 5 | Automatic entrance doors | $96,000 | $88,500 | $88,500 | $91,000 | $94,000 | Included | Included | Included | $88,500 | $91,000 | $94,000 |
| 10 | 6 | Door hardware at storefront | $38,000 | $36,000 | $36,000 | $41,500 | Included | Excluded | Included | $36,000 | $36,000 | $41,500 | |
| 11 | 7 | Shop drawings and engineering | $30,000 | $22,000 | $28,000 | $22,000 | $26,500 | Included | Included | Included | $28,000 | $22,000 | $26,500 |
| 12 | 8 | Hoisting and equipment | $24,000 | $18,000 | $18,000 | $21,000 | Excluded | Included | Included | $18,000 | $18,000 | $21,000 | |
| 13 | 9 | Perimeter sealants | $42,000 | $39,000 | $39,000 | $44,500 | Included | Included | Excluded | $39,000 | $44,500 | $39,000 | |
| 14 | |||||||||||||
Sheets
- Instructions
- How the plug, leveled totals and ranks work, and when to override the plug.
- Bid tab
- 20 scope lines for up to four bidders with drop-down scope status, plug and leveled columns, totals, ranks and a bidder comparison with non-price checks.
Built in
- Live formulas: change an input and every total, flag and chart updates
- Frozen header rows and columns, so labels stay put as you scroll
- Drop-down lists and value checks on the input cells
- Conditional formatting for flags and overruns
- An Instructions sheet with every column defined
- Prints landscape, one page wide, with the header row repeated
Worked example: three glazing bids
Illustrative bids from the sample file for an interior glazing and storefront package. As submitted, Keystone Glass is lowest at $1,519,000, against $1,663,500 from Northline Glass and $1,650,000 from Summit Glazing.
Keystone excluded the fire-rated glazing at the stairs and the storefront door hardware. Priced at the lowest other bid for each line, those gaps add $175,500, and Keystone’s leveled total of $1,694,500 ranks third.
Northline left out only hoisting, $18,000 at the plug, so its leveled total of $1,681,500 is lowest, $7,500 below the next bidder. Summit qualified its partition price and its prequalification is pending: both are worth settling before anyone recommends an award.
The formulas in the file
Plug usedBid tab · F7
=IF($B7="","",IF(E7<>"",E7,IF(COUNTIFS(K7:N7,"<>Excluded",G7:J7,">0")=0,D7,MINIFS(G7:J7,K7:N7,"<>Excluded",G7:J7,">0"))))Your override if entered; otherwise the lowest price a bidder included for the line; otherwise your estimate.
LeveledBid tab · P7
=IF(OR($B7="",H$3=""),"",IF(OR(L7="Excluded",N(H7)=0),$F7,H7))The bidder’s price, or the plug where they excluded the line or left it blank.
RankBid tab · G31
=IF(G$3="","",RANK(G30,$G$30:$J$30,1))Position of the leveled total among the bidders, 1 being lowest.
Leveled low bidderBid tab · G41
=IFERROR(INDEX($G$3:$J$3,MATCH(MIN($G$30:$J$30),$G$30:$J$30,0)),"")The name above the lowest leveled total.
Bid tabulation and leveling template: printable version
os.construction · free template- Bid package
- Bid date
- Estimator
- Budget for package
Bid tab (sample lines)
| Scope item | Estimate / budget | Plug used | Bidder 1 price | Bidder 2 price | Bidder 3 price | Bidder 1 leveled | Bidder 2 leveled | Bidder 3 leveled |
|---|---|---|---|---|---|---|---|---|
| Storefront system, level 1 lobby | $410,000 | $396,500 | $404,000 | $396,500 | $425,500 | $404,000 | $396,500 | $425,500 |
| Curtain wall, east elevation | $690,000 | $671,000 | $702,000 | $709,000 | $671,000 | $702,000 | $709,000 | $671,000 |
| Fire-rated glazing, stairs 1 and 2 | $145,000 | $139,500 | $152,000 | $139,500 | $152,000 | $139,500 | $139,500 | |
| Interior glass partitions, level 2 | $220,000 | $214,000 | $214,000 | $238,000 | $231,000 | $214,000 | $238,000 | $231,000 |
Sample rows are illustrative and marked for deletion. Your contract, drawings and specifications govern. Template from os.construction/resources/templates/bid-tabulation
Using the bid tabulation and leveling template
- Break the package into the scope lines you want every bidder to price, from your bid form or scope sheet, with your estimate for each.
- Enter each bidder’s price per line and mark the scope Included, Excluded or Qualified from their proposal, exclusions and clarifications.
- Check the plug for each excluded line. By default it is the lowest price another bidder included; type an override when you have a takeoff or quote that is better.
- Compare the leveled totals and ranks, then the non-price rows: addenda acknowledged, bonding, prequalification, lead time and qualifications.
- Write how you leveled into your recommendation and carry the leveled scope into the subcontract, so the gap you priced doesn’t come back as a change order.
- Bids receivedPrices, exclusions, qualifications
- Scope lines tabbedIncluded, excluded, qualified
- Gaps pricedPlug at lowest other price
- Leveled and rankedEqual scope comparedClarify a bid: back to “Bids received”
- RecommendationPrice and non-price checks
- SubcontractLeveled scope written in
Text version
- Bids received: Prices, exclusions, qualifications
- Scope lines tabbed: Included, excluded, qualified
- Gaps priced: Plug at lowest other price
- Leveled and ranked: Equal scope compared
- Recommendation: Price and non-price checks
- Subcontract: Leveled scope written in
Clarify a bid: from “Leveled and ranked” back to “Bids received”.
Do this in os.construction instead of a spreadsheet
Bidding in os.construction runs a bid package from release to award: invited bidders price each line, mark lines excluded and add alternates, qualifications and lead time, and the leveling grid puts the quotes side by side with the lowest price per line highlighted and a spread column. A Bidding editor records the recommendation with a reason and a different Bidding administrator approves it before award. The awarded bid becomes a draft subcontract or purchase order with its lines and cost codes filled in. The app compares the prices bidders give you; it has no plug values, so record how you leveled in the recommendation.
Try it on the sample project
Every trial workspace includes a sample project to run this workflow on. 14-day free trial. Pricing for paid plans isn't set yet.
Questions about the bid tabulation and leveling template
What is a bid tabulation in construction?
A bid tab is a side-by-side comparison of the bids received for one package, line by line. A leveled bid tab goes further: it marks what each bidder included, excluded or qualified and prices the gaps, so the totals compare the same scope.
How do you level subcontractor bids?
List the scope lines, enter each bidder’s price and whether they included each line, then add a plug for every excluded or missing line so all bidders carry the same scope. A common plug is the lowest price another bidder included for that line; a takeoff or quote is better where you have one. Then compare leveled totals, not bid totals.
Is the lowest leveled bid always the one to award?
No. Price is one input. Addenda acknowledged, bonding, prequalification, schedule and lead time, qualifications and the bidder’s current workload all matter, which is why the template keeps them beside the leveled totals.
What do I do with qualified lines?
A qualified line is priced with a condition, such as “per sketch only” or “excludes after-hours work”. The template counts it as included but highlights it, so you can clarify the condition with the bidder or price it before the award.
Does it need a recent version of Excel?
The plug and leveled columns use MINIFS, which works in Excel 2019, Microsoft 365, Excel for the web, Google Sheets and LibreOffice. Older Excel shows #NAME? in those columns.
Keep going
- Pillar guideBidding to an awarded commitment
- Free toolMarkup vs margin calculator
- os.constructionCRM and bidding
- GlossaryBid Bond
- GlossaryBid Leveling
- GlossaryBuyout
- GlossaryBuyout Savings
- GlossaryPrequalification
- GlossaryScope of Work
- GlossarySubcontract
- GlossaryTakeoff
- Free resourceBidding to an awarded commitment
- Free resourceMarkup vs margin calculator
- Free resourceHow to level subcontractor bids
- Free resourceHow to prequalify subcontractors
- TemplatePunch list template
- TemplateMeeting minutes template
- TemplateInspection checklist starter pack
- TemplateT&M ticket template
- TemplateRFI writing checklist
- TemplateDaily log checklist
- TemplateChange event log
- TemplateBack charge notice and log
- TemplateThree-week look-ahead template
- TemplateSafety observation log
- TemplateAction item tracker
- TemplateCloseout and TCO checklist
- TemplateNotice to proceed template
- TemplateJob cost report template
- TemplateConstruction schedule (Gantt) template
- TemplateChange order log template
- TemplateCash flow projection template
- TemplateBuyout log template
- TemplateASI log template
Keep exploring
Related across os.construction
- BlogHow to level subcontractor bids: building a bid tab that compares the same scopeThe low bid is often low because it left something out. Leveling puts every bidder on the same scope before you compare price: break the package into scope lines, tab each bid line by line, price every exclusion with a plug, then rank the leveled totals and check the non-price items. Here is each step and a worked three-bidder example.
- PlatformConstruction CRMInquiries, pipeline, proposals and bidding handoff to won projects, service and warranty, on the job record.
- Free toolBuyout log templateFree construction buyout log for Excel.
- BlogHow to write a scope of work for subcontractors that leaves no gaps between tradesA subcontract scope of work decides who pays when something turns out to be missing. Write it from the leveled bid, name the documents it's based on, spell out the items trades argue about, and check every interface item against the neighboring trades with a responsibility matrix. Here is the method, a scope outline and a worked example that finds two gaps and an overlap.
- ExplainerBuyout savings to commitment change: award a subcontract and track the change (video)
- DocsBidding, RFQs and prequalificationPut work out to bid with bid packages, level the quotes, award with an independent approval and turn the award into a commitment. Price changes with RFQs, and record vendor prequalification.