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
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
Collection: International Symposium on the Analytic Hierarchy Process (ISAHP2013)
Views index: %
Popularity index: 11.25%
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.