The AHP Excel template works under Windows OS and Excel version MS Excel 2013. The workbook consists of 20 input worksheets for pairwise 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: 20180915.
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 pairwise 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 subcategory. 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 MultiCriteria 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 2018.09.15 (zip)
Please consider a donation, it will help me to maintain the website and program. At least rate the template from 1 star (poor) to 5 stars (excellent) below. 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!
Incoming search terms:
 Ahp excel
 analytical hierarchy process excel
 ahp excel template
 ahp template
 ahp calculations in excel
 analytic hierarchy process excel template
Thanks for the excel sheet. Very helpful for my research work. New to this field but your excel is self complementary.
I have just downloaded your template for usage and will be citing your paper in my paper. I believe it should work fine in my final year project. Thanks.
Dear Sir,
I am unable to calculate the sensitivity analysis after the AHP. So, kindly help me.
I just now downloaded and opened the tool. Do you provide a mechanism for incorporating one or more subcriteria under each major criteria (i.e., next layer)? For example, if Cost is a major criteria, can you include Purchase Cost and Maintenance Cost as subcriteria? If so, how many additional layers (subsubcriteria) can be incorporated in your tool?
Unfortunately, it cannot be done within the excel template. You can use my (free_ online software AHPOS to do it. https://bpmsg.com/ahp
Hi,
I’m new in using AHP, I just wanted to ask what lambda max is used here? Is it the one reflected on the summary sheet?
Also, may I ask why did you consider AlonsoLamata’s linear fit in computation of CR?
Hoping for a favorable response regarding the matter.
Thank you.
Always take the values from the summary sheet, as this is the one using the eigen value method. AlonsoLamata’s fit is used because the template works with up to 10 criteria.
Thank you very much
There is certainly a lot to learn about this subject. I love all of the points you’ve made.
Hi Mr. Klaus,
First of all i want to thank you for your amazing study.
I am now trying to solve multi criteria decision case. The problem is how to decide which scale shall i use?
Shall I use the scale which results the best consensus and least MRE?
If you help me on this, i will be very greatful
Best regards.
Hi Tolga,
thank you. As long as you do not have a specific reason to change the scale, use the standard 19 AHP scale. Most AHP publications are using the original scale.
Best regards, Klaus
Hi, Khlaus, great tool,
I am trying to use it, I have 10 criteria.
I am having a problem with criteria 9&10,
I don’t see them in worksheet “ln1” so I can add the scale values for them.
I tried to unlock the protected the cells, I couldn’t because it requires a password.
how to go about so I can finish my analysis
It is a great site and very useful. Thank you for your help.
Thank you for the excel template file and for sharing it help me a lot in my research work.
I’m using the latest excel version and I’d appreciate it if you could help me with something. I’m studying 17 criteria divided in 5 groups according to categories. One of my groups contain only 2 criteria but in excel minimum is 3. Any version can allow comparing 2 criteria? Can you help to fix it?
Thank you so much.
Hi Fatma,
do you have the latest version 15.09.2018? It works with two criteria. Otherwise please just download again.
Regards,
Klaus