Planning template
Weighted comparison matrix
Compare options side by side with weighted criteria to make a clear decision. Scores, ranks and the winner update as you change weights.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Compare
20 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 81 filled cells in all.
Built in
- Charts
- Conditional formatting
- 1 chart
- 2 conditional format rules
- 2 validation rules
A look at the Compare sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Choosing an apartment | |||||||
| 2 | Weight each criterion from 1 to 5 and score each option from 1 to 10. Higher is better. | |||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | Criterion | Weight | Share | Maple Court | Harbor Lofts | Cedar Row | Elm Street flat | |
| 6 | Monthly rent | 5 | 20% | 6 | 4 | 8 | 9 | |
| 7 | Commute time | 4 | 16% | 8 | 9 | 5 | 6 | |
| 8 | Space and layout | 4 | 16% | 7 | 8 | 6 | 5 | |
| 9 | Natural light | 2 | 8% | 6 | 9 | 7 | 5 | |
| 10 | Neighborhood | 3 | 12% | 8 | 7 | 6 | 6 | |
| 11 | Amenities | 2 | 8% | 5 | 9 | 4 | 3 | |
| 12 | Lease terms | 2 | 8% | 7 | 5 | 8 | 7 | |
- decision
- compare
- scoring
- weighted
- choice
More planning templates
PlanningEvent budgetBudget a party, launch or conference with estimates, actual costs and payments to vendors. See the cost per guest and what is still owed.
PlanningWedding plannerKeep the wedding budget, guest list and checklist in one place. RSVP and meal counts, spending by category and due dates update as you go.
PlanningWeekly scheduleLay out a week hour by hour from 7 am to 8 pm. Dates fill in from the start date and booked and free hours are counted per day.
PlanningDaily plannerPlan a single day with top priorities, an hour by hour schedule, a to do list and notes. Progress fills in as you tick things off.
Start your weighted comparison matrix now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.