The AHP template works under Windows OS 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). Information about the latest version 2016.05.04.
Alternative for complex AHP projects: AHP free online software .
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.
- 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-v2017-03-29.pdf
Please always make a reference to the author and website.
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.
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