Weighted Decision Matrix Template

You can now scroll the matrix any direction and the headings remain visible.

Weighted decision matrix template. Common uses include deciding between optional solutions or choosing the most appropriate software application to purchase. For our decision matrix example lets consider the information belowlets say weve identified criteria c1 c2 and c3 playing a role in the final decision with a respective weight of 1 2 and 3. The more important the factor the higher the number. Various unweighted decision matrix templates can be sourced from the internet for free.

What is a weighted criteria matrix. This makes it a great technique to use in almost any important decision where there isnt a clear and obvious preferred option. There are a number of variations but the two main categories are weighted and unweighted. If youd like to create your own weighted decision matrix then you can download a template here to help you to get started.

Its particularly powerful where you have a number of good alternatives to choose from and many different factors to take into account. Other versions include the pugh decision matrix and the eisenhower box matrix. Download a weighted decision matrix example to save you the bother of building a template yourself download now. Using a decision matrix you can effectively blast through tough decisions.

In a weighted decision matrix each factor is given a numerical weight. Sample decision matrix and template decision matrix template option 1. An unweighted decision matrix assumes that all factors have the same value. A weighted criteria matrix is a decision making tool that evaluates potential options against a list of weighted factors.

Check out these links to decision matrix resources on the web read our articles about using a decision matrix in excel or get a free copy of our decision. The unweighted decision matrix which doesnt use an assumed weight scale to identify the best option. The steps to create a weighted decision matrix are shown below along with an example from the business world. A decision matrix is a tool to help you decide between multiple options by scoring them against different criteria.

Creating the excel weighted decision matrix. Selection criteria weight w value v weighted value w x v value v weighted value w x v value v weighted value w x v. Weighted decision matrix templates are some of the most popular. Follow the instructions here if you dont know how to make a decision matrix or need to remind yourself how to make a decision matrix instructions.

Although any basic excel user could create the matrix using just multiplication and addition doing so would require some bruising manual formulas.