MS Excel Template for Multi Criteria Decision Making (MCDM)

Making decisions can be hard - especially if you have many factors to consider. Here is an easy way and a fully prepared Excel template to make it easier and faster. If you ever had to decide on one of multiple options based on many influencing factors, you know what I am talking about.

This is an Excel template for fast and easy decision-making.

The template is using the "weighted sum" method. It is easy to understand and very effective.

The weighted sum method allows you to compare X alternatives using Y decision criteria. It assumes that these are benefit criteria, i.e., higher values are better.

I took this idea and created an Excel template with which you can

• easily compare up to 10 alternatives,
• use up to 10 decision criteria, and
• get the results displayed in a clean bubble chart.