Vendor & Sub Quote Recap
Level every quote to the same scope, then carry one number with confidence.
Bid day, six quotes, three formats, one of them missing the emergency fixtures. This recap levels vendor and subcontractor quotes the way a working estimator does: base, required adders, freight, and tax roll into one leveled total, while alternates show but never sneak into it. Expired quotes, partial scope, and outliers light up so you don't carry a number you'll regret.
Features
- 12 package blocks, up to 6 bidders each
- Leveled totals with automatic tax on vendor material
- EXPIRED / EXPIRING quote flags against your bid date
- LOW / HIGH outlier flags against the median
- Scope-complete tracking, carried-bidder dropdown, and a plug line for gaps
- Line-item leveling: 150 lines × 4 vendors, checked against your takeoff quantities; missing lines plugged at the average price
- Summary of carried numbers by package, lead time, and quote status
Questions
How do I get the files?
Checkout runs through Gumroad. Right after you pay, you get a download link on screen and by email. Nothing ships.
Do they work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. Formulas, dropdowns, and colors carry over. No macros are used anywhere, so there's nothing to enable.
Are the labor units and rates filled in?
No, and on purpose. Every rate, factor, and markup is a clearly labeled placeholder you replace with your own. Your numbers stay yours.
What if something doesn't work?
Email helloscottcox@gmail.com and I'll fix it or make it right.
Is this engineering or legal advice?
No. These are estimating tools. You're responsible for verifying quantities, pricing, labor, and code compliance.