New AHP Excel template with multiple inputs

AHP IconThe AHP template works under Windows OS and Excel version MS Excel 2010 (xlsx extension). 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). Information about the latest version 2016.05.04.

NEW! BPMSG’s free AHP online software: For a quick evaluation of priorities use my AHP priority calculator. If you need to evaluate alternatives under a complete AHP hierarchy, try out my new AHP Online System.

Excel Template

  • Within the input worksheets (questionnaires) priorities are calculated using the row geometric mean method (RGMM).
  • Two consistency indices (the consistency ratio CR and the geometric consistency index GCI) 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 12 iterations.
  • Different judgment scales are implemented.
  • 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 is given in the pdf document here: AHPcalc-v2013-12-24.pdf

PLEASE READ before DOWNLOAD
The template is free. So I would really appreciate, if you could – at least – feedback or write me about your application, and the use of the template. Please always make a reference to the author and website.

Download AHP Excel Template Version 2016.05.04 (zip) download

The work is licensed under the Creative Commons Attribution-Noncommercial 3.0 Singapore License. For terms of use please see our user agreement and privacy policy.

A small donation is welcome and will help me to maintain the website and program:




An explanation of AHP (Analytic Hierarchy Process) is given in my video here.

Your comments are always welcome!

Incoming search terms:

  • ahp model excel
  • ahp calculator excel
  • ahp questionnaire example
  • ahp questionnaire template
  • ahp questionnaire format
  • ahp questionnaire sample
Share on Facebook
This entry was posted in AHP, Downloads and tagged , , , , , , , , . Bookmark the permalink.

227 Responses to New AHP Excel template with multiple inputs

  1. Roselila says:

    Hi, I’m really grateful to you for the template you’ve provided as it could at least help me out with my Ahp Calculation. I did some adjustment to it as I have 26 respondents (the template was only meant for a max of 20). I am only focusing on the prioritization of 6 factors. AHP is a new method for a research in my field of study (education). So, it was a bit confusing for me to understand it and to convince others as I am still trying my very best to understand it through readings and to make it relevant to my study. I am also comparing the result with the one I get through Expert Choice v.11. The ranking results are the same, except for the percentage of each factor. However, my ultimate goal is to rank the factors accordingly and your AHP Excel Template helps. If only I could get a version of your template with 26 respondents (more than 20)….rather than using the adjustment version (my own manual copy & edit version)…it would be a great help.
    Thank you.

    Roselila
    University of Malaya

    • Klaus says:

      Rosella, thanks for your feedback! Just use my online software AHP-OS. It’s also free and you can handle a practically unlimited number of participants and also complete hierarchies and alternative evaluation. Just need to register once with your e-mal.
      Regards, Klaus

  2. Paria Kia says:

    Thank a lot for sharing this great AHP calculation template for free. I’m an urban planner from Tehran (Iran) and I’m currently working on a neighborhood regeneration project with a consulting firm and would like to use this template to collect inputs from stakeholders and weight our development criteria.
    In one case, we have 10 criteria. When I try to include them all in the excel template, I found out that people get confused when criteria number 9 and 10 are at the very end of the comparison table. I tried to change the criteria table and include 9 and 10 with the other criteria (j=9 and j=10 going right after j=8), but I failed – it’s too complicated for me to make that change. I was wondering if you have any suggestions or advice for me about how I can change that part.
    Many thanks in advance.

    • Klaus says:

      Yes, you are right, it’s a bit confusing. I only extended to 10 criteria because of requests from some users.
      The whole excel workbook is quite complex, and I do not recommend to change it. My recommendation: use my AHP online SW AHP-OS. You can handle up to 15 criteria and it is designed for group inputs. Much more user friendly than the excel sheet for complex projects. With the latest version all input matrices, aggregated matrix and priorities can be easily downloaded in csv text file format and imported into excel.
      Hope this helps.
      Regards, Klaus

      • Paria Kia says:

        Many thanks for your fast reply. Your AHP-OS is very helpful and user friendly, but unfortunately we won’t be able to use it. Since our client is a governmental one, all the text we use need to be in Farsi (Persian language)… 🙁
        Thanks anyways.

  3. Camila Lima says:

    Boa tarde.
    Estou utilizando a sua ferramenta, a qual está me auxiliando muito. Porém tenho uma dúvida. Estou utilizando 6 critérios apenas, no entanto notei que o cálculo de normalização não bate os valores quando faço na mão e então percebi que os cálculos da sua planilha, aba 10×10 que não altera os valores referentes ao número de critérios. Ela está calculando para 10 critérios, mesmo que colocando no inicio o valor n = 6. Eu tentei alterar isso desprotegendo a planilha, porém confesso que não entendi muito bem os cálculos. Isso de fato é uma falha ou eu que não estou sabendo utilizar a ferramenta?
    Grata.

    • Klaus says:

      Unfortunately I don’t speak Portuguese …
      The 10×10 calculation algorithm is always done as 10×10. Regardless of the number of criteria the result should be correct for your actual number of criteria. Question: Are you using the latest version of the template? Otherwise please update to the latest version. Let me know, if there is a discrepancy in the calculated priorities depending on the number of criteria. It should be correct and was tested with different examples from the literature. English please.
      Regards, Klaus

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA Image

*