• Preview of Options Appraisal Scoring Matrix (weighted criteria)Excel workbook preview

Project Initiation and Business Case

Options Appraisal Scoring Matrix (weighted criteria)

$17.99 Free XLSX
Excel workbook · 12 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.