Description
See it in action
Make big decisions with confidence — and be able to explain them. List your options and the criteria that matter, rate how important each criterion is, and score every option from 1 to 10. The Decision Matrix weights the scores, rules out any option that misses a must-have, ranks the rest and names the winner. The Results sheet shows where each score comes from and whether the winner would change if any one criterion were ignored.
What it does
- Weighted scoring – importance ratings turned into weights, with a colour-coded score grid
- Must-have rules – set a minimum score for critical criteria; options below it are ruled out
- Clear recommendation – winner banner with score and margin over the runner-up
- Ranking and chart – options ranked by weighted score with a bar chart
- Score breakdown – stacked chart of how much each criterion contributes to each option
- Robustness check – the winner if each criterion were ignored, flagging close calls
- Protected formulas – calculations are locked and hidden so nothing breaks by accident
Who it’s for
Managers choosing suppliers, software or locations, project teams assessing solutions, hiring panels, and anyone weighing up a big decision.
What’s included
- 1 Excel workbook (.xlsx): How to Use, Decision Matrix and Results
- A worked example comparing four CRM systems on eight criteria
- Built-in How to Use guide and sample data you can clear in one step
Requirements
Microsoft Excel 2010 or later, including Excel 2019, 2021 and Microsoft 365 (Windows or Mac). Not designed for Google Sheets.
This is a digital download. No physical item will be shipped. Your file is available to download immediately after purchase.
Reviews
There are no reviews yet.