A user-friendly Excel template for multi-criteria decision making (MCDM) problems using the Entropy-COPRAS method

Multi-criteria decision-making (MCDM) problems are about choosing the best alternative while considering multiple conflicting criteria. Various MCDM techniques can be implemented to solve the MCDM problems. In this project, Entropy-COPRAS is implemented to solve the problem. The Entropy method is used to compute the weights of the criteria, while the COPRAS method is used to choose the best alternative. Traditionally, the decisions are made based on the decision-makers' subjective preferences and past experiences, which will lead to bias in the process. However, with the help of a mathematical analysis, the bias may be reduced significantly, since the Entropy calculates the weights of the criteria objectively. The Entropy-COPRAS integrates into a Microsoft Excel-based template to help decision-makers make transparent and organized decisions. The template will also allow decision-makers without programming knowledge to apply the Entropy-COPRAS method effectively. As a result, decision-makers can make decisions more quickly and with guaranteed calculation transparency.