Esc

↑↓ move↵ openIndex · Pagefind

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.

  • Free
  • No signup
  • Excel · Google Sheets · LibreOffice
The Excel file

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:

P7Formula in P7: =IF(OR($B7="",H$3=""),"",IF(OR(L7="Excluded",N(H7)=0),$F7,H7))
Bid tabulation and leveling template: preview of the “Bid tab” sheet in bid-tabulation-template.xlsx, with the sample data
ABDFGHIKLMOPQ
1Bid tabulation and leveling
2PackageBP-14 Interior glazing and storefront4/14/2026
3Bidder name →Northline GlassKeystone GlassSummit GlazingNorthline GlassKeystone GlassSummit GlazingNorthline GlassKeystone GlassSummit Glazing
4#Scope itemEstimate / budgetPlug usedBidder 1 priceBidder 2 priceBidder 3 priceBidder 1 scopeBidder 2 scopeBidder 3 scopeBidder 1 leveledBidder 2 leveledBidder 3 leveled
51Storefront system, level 1 lobby$410,000$396,500$404,000$396,500$425,500IncludedIncludedIncluded$404,000$396,500$425,500
62Curtain wall, east elevation$690,000$671,000$702,000$709,000$671,000IncludedIncludedIncluded$702,000$709,000$671,000
73Fire-rated glazing, stairs 1 and 2$145,000$139,500$152,000$139,500IncludedExcludedIncluded$152,000$139,500$139,500
84Interior glass partitions, level 2$220,000$214,000$214,000$238,000$231,000IncludedIncludedQualified$214,000$238,000$231,000
95Automatic entrance doors$96,000$88,500$88,500$91,000$94,000IncludedIncludedIncluded$88,500$91,000$94,000
106Door hardware at storefront$38,000$36,000$36,000$41,500IncludedExcludedIncluded$36,000$36,000$41,500
117Shop drawings and engineering$30,000$22,000$28,000$22,000$26,500IncludedIncludedIncluded$28,000$22,000$26,500
128Hoisting and equipment$24,000$18,000$18,000$21,000ExcludedIncludedIncluded$18,000$18,000$21,000
139Perimeter sealants$42,000$39,000$39,000$44,500IncludedIncludedExcluded$39,000$44,500$39,000
14
InstructionsBid tab
Rendered from the downloadable file: same formulas, same sample numbers, same conditional formatting. Sample data is illustrative.

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
Download the .xlsx
Worked example (illustrative)

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 itemEstimate / budgetPlug usedBidder 1 priceBidder 2 priceBidder 3 priceBidder 1 leveledBidder 2 leveledBidder 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

How to use it

Using the bid tabulation and leveling template

  1. 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.
  2. Enter each bidder’s price per line and mark the scope Included, Excluded or Qualified from their proposal, exclusions and clarifications.
  3. 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.
  4. Compare the leveled totals and ranks, then the non-price rows: addenda acknowledged, bonding, prequalification, lead time and qualifications.
  5. 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.
From bids received to awardBids received, then Scope lines tabbed, then Gaps priced, then Leveled and ranked, then Recommendation, then Subcontract. Clarify a bid: from Leveled and ranked back to Bids received.Clarify a bidBids receivedPrices, exclusions, qualificationsScope lines tabbedIncluded, excluded, qualifiedGaps pricedPlug at lowest other priceLeveled and rankedEqual scope comparedRecommendationPrice and non-price checksSubcontractLeveled scope written in
  1. Bids receivedPrices, exclusions, qualifications
  2. Scope lines tabbedIncluded, excluded, qualified
  3. Gaps pricedPlug at lowest other price
  4. Leveled and rankedEqual scope comparedClarify a bid: back to “Bids received”
  5. RecommendationPrice and non-price checks
  6. SubcontractLeveled scope written in
From bids received to award
Text version
  1. Bids received: Prices, exclusions, qualifications
  2. Scope lines tabbed: Included, excluded, qualified
  3. Gaps priced: Plug at lowest other price
  4. Leveled and ranked: Equal scope compared
  5. Recommendation: Price and non-price checks
  6. Subcontract: Leveled scope written in

Clarify a bid: from “Leveled and ranked” back to “Bids received”.

In os.construction

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.

FAQ

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

Open file