-
Excel workbook preview
Project Initiation and Business Case
Options Appraisal Scoring Matrix (weighted criteria)
3 downloads per free account, no card needed.
Who this is for
The project board asked for a transparent comparison of the options before the preferred option goes into the business case.
What is inside
- 8 sample criteria with weights that total 100% plus 16 blank criteria rows
- Weight total check turns red when it is not 100%
- Scores 0 to 5 for up to 5 options with a dropdown, weighted score as a percentage of the maximum
- Pass or fail gate per option: an option that fails a must-have is shown as excluded
- Rank formula over the options that pass, live
- Scoring scale sheet that defines 0 to 5 so scorers score the same way
How to use it: Name your options on the Options sheet, agree the criteria and weights before anyone scores, then enter the panel's agreed scores and read the ranking.
Files & formats
- XLSXoptions-appraisal-scoring-matrix.xlsx12 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



