A Novel MS Excel Tool for Multi-Criteria Decision Analysis in Energy Systems

Abstract

Application of multi-criteria decision analysis (MCDA) methods to various aspects of energy systems is of significant interest. This chapter first proposes a simple yet user-friendly MS-Excel tool with four popular MCDA methods. The tool can be effectively used to apply MCDA techniques and to determine the rankings for the alternatives. This MS-Excel tool is made available on Mendeley data repository. The chapter explains the overall MCDA computational processes, algorithms, and provides details on using the tool itself with the help of two case studies to demonstrate its effectiveness and applicability.