Free download, bid decisions

Free Go/No-Go bid decision scorecard (Excel)

This free Go/No-Go scorecard is an Excel workbook for deciding whether a bid is worth the estimating hours. It scores 14 weighted criteria from fit and owner to contract risk and margin, treats bonding, insurance and mandatory pre-bid attendance as hard stops, and calculates a Go, Review or No-Go you can adjust to your own thresholds. No email, no macros.

Download the template

No sign-up, no email. 3 sheets, no macros, 11 KB. Opens in Excel or Google Sheets. The example sheet uses illustrative Texas project data; the blank sheet is ready to use.

What is in the workbook?

SheetWhat it is for
InstructionsThe steps on this page and what each column means
ScorecardThe working scorecard with 14 criteria and weights filled in: dropdowns for score and hard stop failed, weighted score, percent and decision
Example (Texas)An illustrative Travis County, TX school addition, scored

What do the columns mean?

Weights say what matters to your company; scores say how this bid measures up; hard stops end the discussion.

ColumnWhat to enterWhy it matters
Criterion, CategoryFourteen criteria grouped into fit, owner, risk, capacity, eligibility, competition and valueCovers what the bid package, the contract and your own capacity decide; edit the list to match how your company bids.
Weight (1-5)How much the criterion matters to your companySet once by leadership, not per bid, so decisions stay consistent.
Hard stop?, Hard stop failed?Criteria that end the bid on their own: bonding, insurance, mandatory pre-bid attendanceBonding is required above $150,000 on federal work (FAR 28.102-1) and above $100,000 on Texas public work (Gov Code 2253.021).
Score (1-5), WeightedHow this bid measures up, times the weightScores without evidence are guesses; the evidence column keeps them honest.
Evidence and bid package pageThe fact behind the score and where it is in the packageLets anyone check the call, and reuse it on the next bid for the same owner.
Percent and decisionWeighted score as a share of the maximum; Go at 70% or more, Review at 55 to 69%, otherwise No-GoThresholds are a starting point; set your own from your win history.

What does the example look like?

The Example sheet for an illustrative school addition bid. Illustrative data, not a real project.

CriterionWeightScoreWeightedEvidence
Bonding capacity available for this job (hard stop)5525Single-job limit $8M; bid est. $5.2M
Insurance requirements we can meet (hard stop)4416Builder's risk at 100% insurable value, OK
Mandatory pre-bid meeting attended (if required) (hard stop)3515Attended Oct 29
Project type matches our experience5525Three school additions in 5 years
Size within our usual range4416$5.2M, within range
Location within our working area3515Travis County
Owner relationship and payment history4312New owner to us; district pays in 30 days
Schedule and liquidated damages acceptable428LDs $2,500 per day, 300 calendar days (bid package p. 14)
Contract terms acceptable (indemnity, payment, delay)4312Broad-form indemnity, Section 11.2
Estimating capacity before the due date339Due Dec 3; two estimators free
Subcontractor coverage in this market3412Strong local MEP coverage
Prevailing wage and DBE requirements we can meet3412State prevailing wage; no DBE goal
Number of bidders expected3268 plan holders
Margin potential5315Competitive; margin likely 4 to 5%
Total198 of 26575%: GO

IllustrativeNo hard stop failed. The bid scores 198 of 265, or 75%: GO. The weak spots, liquidated damages and broad-form indemnity, go to the contract review before pricing starts.

How do you use the template?

  1. Set weights once. Leadership sets the weight of each criterion and the Go and Review thresholds; keep them the same across bids.
  2. Check the hard stops first. Bonding, insurance and mandatory meetings. If one fails, mark it Y and stop: the decision is No-Go.
  3. Score from the bid package. Score each criterion 1 to 5 and write the fact and the page that supports it.
  4. Read the decision. The weighted score, percent and decision calculate at the bottom.
  5. Discuss the Review band. A Review result means the team decides in a short meeting, with the weak criteria on the table.
  6. Keep the scorecards. Compare scores with outcomes each quarter and adjust the weights and thresholds.

For the criteria behind each line, read how to make a Go/No-Go bid decision.

When does a spreadsheet stop being enough?

The scoring takes minutes; finding the facts takes hours. The bond requirement, the liquidated damages, the indemnity clause and the prevailing wage rules are spread across a few hundred pages of bid package. Clara, BAU AI's agent for bids and RFPs, reads every page of the package, flags bonds, liquidated damages, insurance and prevailing wage with the page they are on, and drafts a Go/No-Go memo for your team to decide on.

Frequently asked questions

Is the Go/No-Go scorecard free?

Yes. Download it without an email address and adapt it for your own company. A credit line to BAU AI sits at the bottom of each sheet.

Can I change the criteria and weights?

Yes. Edit, add or delete rows; the totals and the maximum score adjust to the rows you score.

Why use hard stops?

Some failures cannot be offset by a good score elsewhere: without bonding capacity or the required insurance, the bid cannot be awarded to you.

Does it work in Google Sheets?

Yes. The formulas use IF, SUM, SUMPRODUCT and COUNTIF. There are no macros.

See Clara read a bid package and draft the Go/No-Go

Bring one bid package you are deciding on. In 15 minutes Clara reads it with you, every risk cited to its page.