Excel and Google Sheets template
Bid leveling sheet for comparing subcontractor bids
The low bid is usually low because something's missing. Permit, startup, gas piping, floor prep. You find out after you've signed. Price those gaps before you award.
$14.50 on Etsy · Instant download
Who it's for
For GCs who award on more than the bottom line
If you've ever picked the low number and paid for what it left out, this is for you.
Each bid gets a base bid, gap plugs and alternates. The leveled total is all three added up, and rank 1 goes to the lowest leveled total, not the lowest base bid. You also see how far each bid is over the low one.
Sample jobs are already filled in so you can see how it works before you level your own.
What's inside
What's in the bid leveling sheet
Bids
Base bid, gap plugs, alternates, leveled total, rank and % over low.
Gap Log
What each sub excluded and where your plug number came from.
Printable Leveling Sheet
Every bid side by side for the job file.
Scopes and Budgets
Each scope with its budget and award status.
Subs
Your sub list with COI expiration. Expired insurance shows red next to the price.
Dashboard
Total budget, awarded vs budget, scopes short on bids and bids with COI problems, plus two pie charts.
How it works
Level the bids, then award
Download
Buy on Etsy and download the file. Open it in Excel, or upload it to Google Drive and open it with Google Sheets.
Set up scopes
Clear the samples and enter your scopes, budgets and subs.
Plug the gaps
Log each bid and price what it left out. The leveled total and rank update.
Award
Print the leveling sheet for the job file and award the scope.
Questions
Bid leveling sheet FAQ
Do I need Excel?
No. It works in Excel and in free Google Sheets. Upload the file to Google Drive and open it with Sheets.
Can I use it on my phone or iPad?
Yes. Open the bid leveling sheet in the Google Sheets or Excel app on your phone or iPad. Setup is easier on a computer screen.
How do I get it?
It's an instant download from Etsy. Buy it, download the file and open it. Nothing ships.
Are there macros or a subscription?
No. There are no macros, no subscription and nothing locked. You pay once on Etsy and the file is yours.
How is the leveled total figured?
Leveled total is base bid plus gap plugs plus alternates. Rank 1 is the lowest leveled total, and each bid shows its % over the low one.
Instant download
Get the bid leveling sheet
$14.50 on Etsy. You'll see the full listing and check out there.
Get it on EtsyMore kits