{"title":"用于能源系统多准则决策分析的新型MS Excel工具","authors":"Musti K. S. Sastry, M. Van der Merwe","doi":"10.4018/978-1-6684-4012-4.ch003","DOIUrl":null,"url":null,"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.","PeriodicalId":7235,"journal":{"name":"Advances in Environmental Engineering and Green Technologies","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2022-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"A Novel MS Excel Tool for Multi-Criteria Decision Analysis in Energy Systems\",\"authors\":\"Musti K. S. Sastry, M. Van der Merwe\",\"doi\":\"10.4018/978-1-6684-4012-4.ch003\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":7235,\"journal\":{\"name\":\"Advances in Environmental Engineering and Green Technologies\",\"volume\":null,\"pages\":null},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-01-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Advances in Environmental Engineering and Green Technologies\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.4018/978-1-6684-4012-4.ch003\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Advances in Environmental Engineering and Green Technologies","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.4018/978-1-6684-4012-4.ch003","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
A Novel MS Excel Tool for Multi-Criteria Decision Analysis in Energy Systems
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.