When we’re working on a project, we often have to compare complex things – features/services/software – and work out which one is the best in the given situation. I use a spreadsheet and create a matrix. This is what you should end up with.Click on screen shots to see the next step. There’s a brief explanation of each step underneath.

Open a spreadsheet, and in A2 type Criteria and then copy and past your criteria list beneath that, one cell per item.

Select cell B1 and type in Weighting. Assign a Weighting value to each criteria. The value represents the level of importance this item has within your overall decision. It doesn’t matter what range you use as long as you’re consistent. I used the range 0.1 (not important) – 1.0 (essential).