PRIORITY MATRIX EXCEL TEMPLATE HOW TO

Prioritized using the detailed weights that your team took so much time to thoroughly consider.

The Adjusted Scores in the Decision Matrix will contain your final ranking of your Alternatives. Tip: You might make the columns wider, and adjust the number format to display 2 decimal places, like we did in this example. Objectives are now in columns and Alternatives are now in rows. This example was created using the old version of the Decision Matrix. The Prioritized List (in the bottom section) will auto-populate as you complete the other sections.ĭo not edit anything in that bottom section. The only data that you enter is your forced choice paired comparison values. Notice that almost everything in section 2 auto-populated when you completed section 1. In the corresponding grey cell, it will automatically populate the inverse rating for the column as compared to the row.

In the dropdown list, select your rating for the ROW as compared to the COLUMN. 'Which is more important, and how much more?' Rate each paired comparisonįor each pairing of items on your list, ask If your Annual Maintenance is current, you can request Systems2win to send you the latest template for free. Tip: In October 2020, the number of choices was expanded from 24 to 50.

PRIORITY MATRIX EXCEL TEMPLATE HOW TO

If you come up with more than 50 choices,Įither combine or eliminate some choices, using List Reduction methods, or if you need more choices, see advanced training for How to expand the list.

Perhaps use brainstorming to generate robust options. In the top section, list your options with no attempt to prioritize them.ĭo not leave blanks between line items, but it is okay to leave blank rows at the end of the list. List your unprioritized options, in no particular order Use the ' Open a Blank Sheet' button in the Systems2win menu Where you will compare each Alternative based on just that 1 Evaluation Criterion. Then create 1 worksheet per Evaluation Criterion The focus of the first worksheet should be to brainstorm and prioritize potential Evaluation Criteria.

Priority matrix excel template