Bid pipeline and win rate dashboard
Bids submitted, won and lost, hit rates, weighted pipeline and margins by month, sector, estimator and bid size.
5 tabs · 3,845 formulas
Templates
Bidding spreadsheet templates
Templates for both sides of a competitive bid. Owners and engineers tabulate the bids they receive and see the spread and the low bidder at once; general contractors level subcontractor quotes for scope gaps, build up a bid price from direct cost with overhead and profit, price a unit price bid schedule with alternates, and score whether a bid is worth pursuing at all.
Markup and margin are kept apart throughout, because confusing the two is the most common pricing mistake in a bid.
Bid price build-up: overhead, profit, markup and margin
Build a bid price from direct cost with job and home office overhead, contingency, profit, bond and insurance.
3 tabs · 87 formulas
Bid tabulation sheet for comparing contractor bids
Unit prices, extended totals, unbalanced-line flags, responsiveness and ranking for competing contractor bids.
4 tabs · 819 formulas
Bid/no-bid decision matrix with expected value
Pass-or-fail gates, weighted scores, expected profit and a bid log with hit rates by sector.
4 tabs · 258 formulas
Subcontractor bid leveling sheet
Level subcontractor bids for scope gaps: each excluded or qualified item adds its plug value to the base bid.
3 tabs · 168 formulas
Unit price bid schedule with alternates
Base bid by section, with allowances, contingency, add and deduct alternates and a total contract amount.
4 tabs · 148 formulas