|
BPMSG |
 |
|
Goepel, K. D. 2013, Implementing the analytic hierarchy process as a standard method for multi-criteria decision making in corporate enterprises – a new ahp excel template with multiple inputs. Paper presented at International Symposium on the Analytic Hierarchy Process (ISAHP2013). Added by: Klaus D. Goepel (07 Jun 2019 08:20:55 Asia/Singapore) Last edited by: Klaus D. Goepel (10 Jun 2019 00:59:33 Asia/Singapore) |
| Resource type: Proceedings Article DOI: 10.13033/isahp.y2013.047 BibTeX citation key: Goepel2013 Email resource to friend View all bibliographic details  |
Categories: AHP/ANP, Decision Making Subcategories: Decision making support systems Keywords: AHP software, Analytic Hierarchy Process (AHP), consensus, consensus indicator, entropy, Excel, group decision making, Shannon, Shannon entropy Creators: Goepel Collection: International Symposium on the Analytic Hierarchy Process (ISAHP2013) |
Views: 9/557 Views index: % Popularity index: 12.25% |
| Abstract |
|
Though the analytic hierarchy process (AHP) is universal and powerful in its application, it is still simple enough to be implemented in a spreadsheet program like MS Excel. In this paper the author describes the development of a general, freely available AHP Excel template, allowing for multiple inputs with individual and consolidated output for decision makers. After an explanation of the template’s structure, realization and limitations, its practical use is illustrated with actual examples. They range from the determination of weights for key performance indicators in business performance management, over the ranking of growth strategies for a company, to the selection of leadership competencies for a leadership development program. Experiences and challenges in the implementation and application of AHP will be highlighted. For the analysis of the group judgments within the projects, a new consensus indicator is introduced. It is based on the concept of diversity using Shannon entropy. Partitioning into two independent components allows finding clusters of high consensus within groups of decision makers. |