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

Though the analytic hierarchy process (AHP) is univ ersal and powerful in its application, it is still simple enough to be implemented in a spreadsheet pr ogram like MS Excel. In this paper the author describes the development of a general, freely avai lable 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, it practical use is illustrated with actual exampl es. They range from the determination of weights for ke y p rformance indicators in business performance management, over the ranking of growth strategies f or 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 highl i ted. For the analysis of the group judgments within the projects, a new consensus indicator is i ntroduced. It is based on the concept of diversity using Shannon entropy. Partitioning into two indepe ndent components allows finding clusters of high consensus within groups of decision makers.

[1]  Tamás Rapcsák,et al.  On Saaty’s and Koczkodaj’s inconsistencies of pairwise comparison matrices , 2008, J. Glob. Optim..

[2]  Thomas L. Saaty,et al.  Dispersion of group judgments , 2007, Math. Comput. Model..

[3]  R. Macarthur.  PATTERNS OF SPECIES DIVERSITY , 1965 .

[4]  Tommy N. Tucker.  On Measurement , 2009 .

[5]  M. Hill.  Diversity and Evenness: A Unifying Notation and Its Consequences , 1973 .

[6]  R. Hämäläinen,et al.  On the measurement of preferences in the analytic hierarchy process , 1997 .

[7]  Thomas L. Saaty,et al.  Multicriteria Decision Making: The Analytic Hierarchy Process: Planning, Priority Setting, Resource Allocation , 1990 .

[8]  Michele Fedrizzi,et al.  A note on the proportionality between some consistency indices in the AHP , 2012, Appl. Math. Comput..

[9]  Alessio Ishizaka,et al.  Review of the main developments in the analytic hierarchy process , 2011, Expert Syst. Appl..

[10]  R. Kaplan,et al.  Strategy Maps: Converting Intangible Assets into Tangible Outcomes , 2003 .

[11]  Thomas L. Saaty,et al.  Decision-making with the AHP: Why is the principal eigenvector necessary , 2003, Eur. J. Oper. Res..

[12]  S. Siraj.  Preference elicitation from pairwise comparisons in multi-criteria decision making , 2011 .

[13]  Bruce H. Edwards,et al.  Elementary linear algebra , 1988 .

[14]  L. Jost.  Partitioning diversity into independent alpha and beta components. , 2007, Ecology.

[15]  Sevgi Erdogan,et al.  An experiment on the consistency of aggregated comparison matrices in AHP , 2006, Eur. J. Oper. Res..

[16]  L. Jost.  Entropy and diversity , 2006 .

[17]  María Teresa Lamata,et al.  Consistency in the Analytic Hierarchy Process: a New Approach , 2006, Int. J. Uncertain. Fuzziness Knowl. Based Syst..

[18]  C. E. SHANNON,et al.  A mathematical theory of communication , 1948, MOCO.

[19]  T. Saaty,et al.  The Analytic Hierarchy Process , 1985 .