Template · Bidding
Bid pipeline and win rate dashboard
Bids submitted, won and lost, hit rates, weighted pipeline and margins by month, sector, estimator and bid size.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| Bid pipeline and win rate dashboard | |||||||
| Example data — replace the blue input cells with your own. | |||||||
| HIT RATE, LAST 12 MONTHS | VALUE WON, LAST 12 MONTHS | PENDING WEIGHTED BACKLOG | AVERAGE MARGIN ON WINS | ||||
| 24.2% | $92,668,000 | $60,200,250 | 8.5% | ||||
| Won over decided bids, by count | Value of bids won, by bid month | Bid amount times win probability, pending bids | Estimated margin, all won bids | ||||
| As-of date (input) | Dec 31, 2026 | The 12-month tiles and the monthly table end in this month. | |||||
| Value submitted and won, last 12 months | |||||||
| Bid month | Value submitted | Submitted bar | Value won | Won bar | |||
| Jan 2026 | $31,825,000 | █████████ | $22,236,000 | ██████ | |||
| Feb 2026 | $31,419,000 | █████████ | $5,204,000 | █ | |||
| Mar 2026 | $67,537,000 | ██████████████████ | $0 | ||||
| Apr 2026 | $45,071,000 | ████████████ | $26,568,000 | ███████ | |||
| May 2026 | $39,016,000 | ███████████ | $3,430,000 | █ |
Showing the first 16 of 53 rows and 8 of 8 columns. Cells with formulas show the formula on hover.
| Bid log: one row per bid | |||||||||||
| One row per bid. Enter the blue cells; the formula columns fill in on their own. Capacity 400 bids. | |||||||||||
| Bid records: inputs in columns A to M, formulas in N to U | |||||||||||
| Bid ID | Bid date | Project | Client | Sector | Estimator | Delivery method | Bid amount | Estimated margin | Status | Award date | Winning amount (if lost) |
| B25-001 | Jan 1, 2025 | High school science labs, Cedar Park | Example Unified School District | Education | Casey Placeholder | Hard bid | $14,129,000 | 11.9% | Won | Jun 5, 2025 | |
| B25-002 | Jan 9, 2025 | Office tenant improvement, Westbrook | Summit Example Realty | Commercial | Avery Example | Negotiated | $2,619,000 | 11.6% | Won | Apr 24, 2025 | |
| B25-003 | Jan 12, 2025 | Warehouse office buildout, Ridge Street | Lakeside Example Holdings | Commercial | Casey Placeholder | Hard bid | $2,679,000 | 4.6% | Won | Jun 6, 2025 | |
| B25-004 | Jan 26, 2025 | Campus parking structure, Eastfield | Example Unified School District | Education | Avery Example | Design-build | $24,756,000 | 12.3% | Won | Jun 24, 2025 | |
| B25-005 | Feb 9, 2025 | Warehouse office buildout, Lakeview | Lakeside Example Holdings | Commercial | Avery Example | Negotiated | $5,855,000 | 4.9% | Won | Mar 29, 2025 | |
| B25-006 | Feb 10, 2025 | Lobby renovation, Millbrook | Riverbend Example Properties | Commercial | Casey Placeholder | Hard bid | $6,199,000 | 11.7% | Won | Jul 6, 2025 | |
| B25-007 | Feb 17, 2025 | Apartment roof and envelope, Westbrook | Maple Example Development | Residential | Avery Example | Negotiated | $3,893,000 | 9.7% | Won | Jun 16, 2025 | |
| B25-008 | Feb 27, 2025 | Water main replacement, phase 2, Lakeview | Example City Water Department | Public works | Blair Sample | Hard bid | $4,757,000 | 5.1% | Won | Jun 12, 2025 | |
| B25-009 | Mar 1, 2025 | Imaging suite renovation, Harbor Point | Northwind Example Medical Group | Healthcare | Blair Sample | Hard bid | $31,766,000 | 6.7% | Won | May 9, 2025 | |
| B25-010 | Mar 15, 2025 | Cold storage expansion, Lakeview | Harbor Example Foods | Industrial | Avery Example | Design-build | $14,650,000 | 7.1% | Won | May 7, 2025 | |
| B25-011 | Mar 16, 2025 | Process piping replacement, Harbor Point | Harbor Example Foods | Industrial | Casey Placeholder | Hard bid | $1,934,000 | 12.3% | Lost | Apr 27, 2025 | $1,679,000 |
Showing the first 16 of 405 rows and 12 of 21 columns. Cells with formulas show the formula on hover.
| Monthly bids, wins and hit rates | |||||||||||
| Twenty-four months ending in the as-of month. Bids count in the month they were submitted; No bid rows are left out. | |||||||||||
| Scale and trend | |||||||||||
| Bar scale: largest month submitted | $73,825,000 | Blue and green bars share this scale. | |||||||||
| Hit rate by count, 24 months | ██▅▃▃▁▅▆▆▆▃▅▆▃▁▃▃▁▃▁▅▅ | ||||||||||
| Lowest and highest monthly hit rate | 0% | 100% | |||||||||
| Month | Bids submitted | Value submitted | Won | Lost | Hit rate (count) | Value won | Value lost | Hit rate (value) | Trailing 12-month hit rate (count) | Value submitted (blue bar) | Value won (green bar) |
| Jan 2025 | 4 | $44,183,000 | 4 | 0 | 100% | $44,183,000 | $0 | 100% | ████████████ | ████████████ | |
| Feb 2025 | 4 | $20,704,000 | 4 | 0 | 100% | $20,704,000 | $0 | 100% | ██████ | ██████ | |
| Mar 2025 | 4 | $63,609,000 | 2 | 2 | 50% | $46,416,000 | $17,193,000 | 73% | █████████████████ | █████████████ | |
| Apr 2025 | 4 | $49,923,000 | 1 | 3 | 25% | $8,254,000 | $41,669,000 | 17% | ██████████████ | ██ | |
| May 2025 | 3 | $37,259,000 | 1 | 2 | 33% | $5,741,000 | $31,518,000 | 15% | ██████████ | ██ | |
| Jun 2025 | 3 | $48,281,000 | 0 | 3 | 0% | $0 | $48,281,000 | 0% | █████████████ | ||
| Jul 2025 | 4 | $58,463,000 | 2 | 2 | 50% | $7,644,000 | $50,819,000 | 13% | ████████████████ | ██ | |
| Aug 2025 | 3 | $22,445,000 | 2 | 1 | 67% | $17,312,000 | $5,133,000 | 77% | ██████ | █████ |
Showing the first 16 of 35 rows and 12 of 12 columns. Cells with formulas show the formula on hover.
| Win rate by sector, estimator, delivery method and size | |||||||||
| Decided bids are won plus lost. Hit rate is won over decided. Averages use only the bids that have the value needed. | |||||||||
| By sector | |||||||||
| Group | Bids | Decided | Won | Hit rate | Hit rate bar | Avg margin on wins | Avg premium when lost | Value won | Value won bar |
| Education | 12 | 11 | 7 | 64% | ██████░░░░ | 8.5% | 9.0% | $98,049,000 | ████████████████████ |
| Healthcare | 12 | 12 | 1 | 8% | █░░░░░░░░░ | 6.7% | 10.2% | $31,766,000 | ██████ |
| Commercial | 16 | 14 | 8 | 57% | ██████░░░░ | 8.5% | 8.6% | $39,526,000 | ████████ |
| Industrial | 17 | 14 | 7 | 50% | █████░░░░░ | 8.4% | 8.9% | $54,288,000 | ███████████ |
| Public works | 16 | 13 | 6 | 46% | █████░░░░░ | 8.3% | 6.7% | $79,005,000 | ████████████████ |
| Residential | 15 | 14 | 4 | 29% | ███░░░░░░░ | 9.5% | 9.6% | $15,149,000 | ███ |
| All bids | 88 | 78 | 33 | 42% | ████░░░░░░ | 8.5% | 9.0% | $317,783,000 | |
| By estimator | |||||||||
| Group | Bids | Decided | Won | Hit rate | Hit rate bar | Avg margin on wins | Avg premium when lost | Value won | Value won bar |
| Avery Example | 27 | 25 | 12 | 48% | █████░░░░░ | 8.9% | 9.1% | $107,331,000 | ████████████████████ |
Showing the first 16 of 37 rows and 10 of 10 columns. Cells with formulas show the formula on hover.
| Bid pipeline and win rate dashboard |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Keeps one log of each bid a fictional general contractor submits: sector, estimator, delivery method, bid amount, estimated margin, status, award date and, for a lost bid, the winning amount. |
| Shows the hit rate, the value won, the weighted pending pipeline and the average margin on wins. The Monthly and Breakdown tabs show the same figures by month, sector, estimator, delivery method and bid size. |
| The example covers 96 bids from January 2025 to December 2026, including eight bids marked No bid. Every name and amount is invented. |
| How to use it |
| 1. Set the as-of date on the Dashboard. The last 12 months end in that month, and the Monthly tab shows the 24 months ending there. |
| 2. Add each bid on the Bid log tab in the next empty row and choose its status: Won, Lost, Pending or No bid. |
| 3. For a lost bid, enter the winning amount. For a pending bid, enter the win probability as a fraction of one, such as 0.4. |
| 4. Read the KPI tiles and the checks on the Dashboard. Fix any line that starts with Check. |
| 5. Compare groups on the Breakdown tab. |
| Formulas and method |
Showing the first 16 of 37 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
What does this template do?
A bid pipeline and win rate dashboard keeps one log of every bid a general contractor submits, then shows how the bidding business is doing. It is built for the bid manager and the estimating team who review the hit rate, the value won and the open pipeline each month.
The Bid log holds up to 400 bids with the sector, estimator, delivery method, bid amount, estimated margin, status, award date and the winning amount when a bid was lost. Formulas assign each bid to a month, flag decided bids, weight pending bids by their win probability and measure our premium over the winner on lost bids. The Monthly tab gives 24 months of counts, values and hit rates, with a trailing 12-month hit rate. The Breakdown tab groups the same figures by sector, estimator, delivery method and bid size.
The as-of date on the Dashboard sets the 12-month window. The example is a fictional general contractor with 96 bids from January 2025 to December 2026. The bids, clients and names are invented.
What’s inside
- Bid log for up to 400 bids with status, award date, margin and winning amount
- Hit rate by count and by value, decided bids only, with a trailing 12-month figure
- Weighted pipeline: bid amount times win probability for pending bids
- Breakdowns by sector, estimator, delivery method and bid size, with progress bars
- Premium over the winner for every lost bid, averaged by group
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Dashboard | KPI tiles, the last 12 months of submitted and won value, hit rate by sector and the top 8 pending bids. |
| Bid log | One row per bid with inputs, status, award date, weighted pipeline and premium over the winner. |
| Monthly | 24 months of bids, wins, losses, hit rates and a trailing 12-month hit rate, with bars. |
| Breakdown | Hit rate, margins and premiums by sector, estimator, delivery method and bid size. |
| Notes | What the workbook does, the method behind it and its limits. |
What formulas does this template use?
This template holds 3,845 formulas in 5,128 cells across 5 tabs, so 75% of its cells calculate. They use 20 distinct functions; the longest formula is 2,628 characters and 379 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 7,930 | one result when a test is true, another when false |
MAX | 1,047 | largest value |
ROUND | 969 | rounds to a number of digits |
MIN | 946 | smallest value |
REPT | 945 | repeats text |
OR | 503 | true when any test is true |
EOMONTH | 424 | last day of a month, months later |
AND | 400 | true when every test is true |
COUNTA | 400 | counts non-empty cells |
COUNTIFS | 173 | counts cells meeting several conditions |
SUMIFS | 132 | adds values meeting several conditions |
SUM | 94 | adds numbers |
The 12 most used of 20 functions. Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- Set the as-of date on the Dashboard. The 12-month figures end in that month.
- Add each bid on the Bid log tab in the next empty row and choose its status.
- Enter the winning amount for each lost bid and the win probability for each pending bid.
- Read the Dashboard tiles and checks, then compare groups on the Breakdown tab.
What is it good for?
- Monthly bid review with the leadership team
- Tracking the backlog of pending bids and its weighted value
- Checking whether a sector or delivery method is worth pursuing
- Reviewing how far our bids sit above the winning amount
Questions about this sheet
How is the hit rate calculated?
Won bids divided by decided bids, which are the won and lost bids. Pending and No bid rows are left out.
Why are No bid rows not counted as submitted?
They are opportunities the company chose not to bid. They stay in the log, but the submitted counts and values leave them out.
How does the weighted pipeline work?
Each pending bid's amount is multiplied by its win probability, and the backlog is the sum of those values.
What does the premium over the winner measure?
Our bid amount divided by the winning amount, minus one, for each lost bid with a winning amount entered.