Score up to five bidders on weighted criteria, with knockout requirements and automatic price scoring, so the award decision is documented and defensible.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 4 | Criterion | Weight | Brianza | Lumen | Ostrava |
| 5 | Price (scored automatically) | 30% | 4.66 | 5.00 | 4.82 |
| 6 | Technical fit | 20% | 4 | 3 | 4 |
| 7 | Quality system | 15% | 4 | 4 | 3 |
| 8 | Weighted score | 4.05 | 3.90 | 3.79 | |
| 9 | Qualified? | Yes | Yes | No: knockout |
What is inside
Yellow cells are yours to fill in. Grey cells calculate. Every sheet has a worked example so you can see the expected format.
Purpose, steps, colour legend and assumptions.
Seven weighted criteria with what a 5 looks like, plus four knockout requirements.
Bidder prices and scores, automatic price score, weighted totals, knockouts, ranking and the award rationale.
How to use it
No macros, no add-ins. It works in Excel, Google Sheets and LibreOffice.
01
Set the criteria weights before bids are opened. They must total 100%.
02
Enter each bidder’s price, a score from 1 to 5 per criterion, and Pass or Fail per knockout.
03
Price is scored automatically: the lowest price gets 5, others get 5 x lowest price / their price.
04
Bidders who fail a knockout are excluded from the ranking. Record the award rationale and approval.
Spreadsheet or platform
The template and the platform use the same structure, so nothing you set up here is wasted.
Questions
Fix the criteria and weights before any bid is opened, keep to a handful of criteria, and let each evaluator score independently before you compare. Changing weights after seeing the bids is the quickest way to lose the credibility of the result.
Yes. The file downloads directly, with no form and no email address.
When several people rate the same suppliers, when suppliers need to see their results, or when actions get lost between file versions. That is usually the point where a shared platform pays back. Signs you have outgrown the spreadsheet →
Related templates
Templates that pick up where this one ends.
Request form that calculates sourcing route, risk class and required approvers.
View template →
21 onboarding tasks in five phases with owners, due dates and progress.
View template →
Six dimensions, weights by segment, tiers and next actions.
View template →
Run it live
Start a free sandbox and set it up yourself: send requests and surveys to real suppliers, collect answers and see scores in one place.