The AHP Excel template works under Office Libre and Excel version MS Excel 2013. The workbook consists of 20 input worksheets for pair-wise comparisons, a sheet for the consolidation of all judgments, a summary sheet to display the result, a sheet with reference tables (random index, limits for geometric consistency index GCI, judgment scales) and a sheet for solving the eigenvalue problem when using the eigenvector method (EVM). Latest version: 2022-07-08.
Alternative for complex AHP projects: AHP free online software.
Excel Template
-
Within the input worksheets (questionnaires) priorities are calculated using the row geometric mean method (RGMM).
-
Three consistency indices (the consistency ratio CR, the geometric consistency index GCI and overall dissonance Psi) are calculated. The level of consistency needed (α) is implemented as a variable input field in the summary sheet, and can be set between zero and one.
-
If CR exceeds α, the top 3 inconsistent pair-wise comparisons on the input sheets are highlighted, to allow the participants an adjustment of their judgments. The judgment resulting in lower inconsistency is proposed.
-
Final priorities are shown in a summary sheet; their calculation is based on the eigen vector method (EVM). For the solution of the eigenvalue problem the power method algorithm is applied with a fixed number of 20 iterations.
-
Different judgment scales are implemented.
- Errors of the EVM and RGMM are show beside the calculated priorities.
-
Either individual participants, or an aggregation of individual judgments (AIJ) based on the weighted geometric mean of all participants’ judgments can be selected.
Limitations
- The template does not include the hierarchy of the decision problem and the final aggregation of weights, i.e. it is only suitable for finding the weights in each category or sub-category. For the definition of a hierarchy and evaluation of alternatives see here.
- Sensitivity analysis of the final result is not included.
How to use the template?
A detailed description (pdf) is attached in the download file.
Reference
When you use the template for your research, please make a reference to the author’s paper.
Please cite:Klaus D. Goepel, (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, Proceedings of the International Symposium on the Analytic Hierarchy Process, Kuala Lumpur 2013. DOI: https://doi.org/10.13033/isahp.y2013.047
Download
Download AHP Excel Template Version 2022.07.08 (zip)
Please consider a donation, it will help me to maintain the website and program. An explanation of AHP (Analytic Hierarchy Process) is given in my video here. For terms of use please see our user agreement and privacy policy.
Your comments are always welcome!
Hi Dr Klaus
I’m writing thesis combining AHP and Geographic Information System (GIS) for site selection. One of my main reference is this journal article (Al Garni, H.Z. and Awasthi, A., 2017. Solar PV power plant site selection using a GIS-AHP based approach with application in Saudi Arabia. Applied energy, 206, pp.1225-1240.)
Could we use your AHP excel for this?
Yes, no problem.
Consegui me cadastrar, contudo realizando pelo navegar Microsoft Edge.
Hi Klaus!
Thank you for your efforts and the great tool you have served as an open source. We have a question for you. We have 10 criteria to assess. However we can not manage to expand light green areas for these 9th and 10th criteria. There is a note already that you’ve left for users, and yet we couldn’t manage to make it work. Can you pls explain how to expand light green areas for 9th and 10th critera. Thank you.
Simply unprotect the sheets before expanding clicking on the + . There is no password
thank you!
thank u for this important tool
Thank you so much.
I would like to inquire about how you do it with 50 or more participants since the AHP Analytic Hierarchy Process (EVM multiple inputs) excel format is for 20 participants only. Hoping for your response. Thank you very much.
Use my online software AHP-OS.
https://bpmsg.com/ahp/
Klaus
Não consigo me cadastrar. Recebo a mensagem de erro “Form input error”.
Thanks for all the information on AHP and in Excel. I have a project on risk management in sheep production in the ecological region of the Pantanal, western Brazil. I will try to set up an AHP online on your site. José Francisco
Thank you for developing and allowing the access , but the no of criteria is limited
https://bpmsg.com/ahp-and-the-magical-number-seven-plus-or-minus-two/
thank you for free app, but it is limited criteria to 10
https://bpmsg.com/ahp-and-the-magical-number-seven-plus-or-minus-two/
Hello Klaus,
Thank you for this brilliant tool and granting access as an open source.
Much appreciated.
Thank you for this template sir, it’s ery halpfull.