A practical Excel solution for multi-criteria analysis using the Entropy-ARAS approach

In this project, the Entropy-Additive Ratio Assessment (Entropy-ARAS) method is integrated with a user-friendly Microsoft Excel template. Traditionally, the decision maker chooses the best option or the best alternative independently of mathematical analysis. The project used the Entropy-ARAS to resolve the complex multi-criteria decision-making (MCDM) problems. The ARAS method is used to select the best alternative, and the Entropy method is used to establish the weights of the criteria. On the other hand, the Microsoft Excel template is designed to facilitate the complex MCDM problems by offering an organized and transparent framework for assessing the alternatives according to the multiple conflicting criteria. The novelty of this innovation lies in the incorporation of the Entropy-ARAS method into a Microsoft Excel template. Users can make an efficient and transparent decision without programming knowledge. The implementation of this template will guarantee the consistency of the final decisions and minimize the computation errors. In addition, the Excel-based Entropy-ARAS tool helps users comprehend and apply MCDM techniques to real-world problems as well as improve the quality and speed of decision-making.