Updated AHP Excel Template Version 08.02.13

An updated version of my AHP Excel template for multiple inputs is now available as version 08.02.13. Beside the extension from 8 to 10 criteria and from 7 to 20 participants some new features have been added. In the past it was sometimes difficult for participants to achieve a low consistency ratio. Now inconsistent comparisons in the input sheet will be highlighted, if the required consistency level is exceeded.  The level of consistency needed (“alpha” in the summary sheet) can also be changed from 0.1 (standard rule of thumb from Saaty) to higher values, for example 0.15 or 0.2. In addition another scale for the judgment can be chosen. For my projects I made good experience with the balanced scale.

A new feature is the consensus index. If you have more than 1 participant and do the group aggregation (select participant “0”), the consensus index is an indicator, how homogenous the judgment within the group was done. Zero percent means no consensus, all participants put their preference on different criteria;  100% means full consensus. Here the changes in detail:

Summary sheet

  • Number of criteria increased from 8 to 10
  • Number of participants increased from 7 to 20
  • Different scales added:
  1. Linear standard scale
  2. Log
  3. Sqrt
  4. InvLin
  5. Balanced
  6. Power
  7. Geom.
  • Alpha – allows to adjust consistency threshold (0.1 default)
  • Consensus indicator for group aggregation added
  • Geometric Consistency Index CGI added

Input sheets

  • Consistency ratio is calculated on each input sheet.
  • Priorities are calculated and shown based on RGMM (row geometric mean method)
  • Top three inconsistent pairwise comparisons highlighted (if CR>alpha)

Known Issues

Thanks to feedback from Rick, sometimes there seems to be a problem with the correct display of weights beside the criteria in the summary sheet. If you face this problem, unprotect sheet summary. Select weigths (O18:O27). Click “conditional formating”, “clear rules”,”clear rules from selected cells”. Then the values will be displayed correctly, and you can format them in the way you want. It is a strange effect; it only appears on one of my PCs, on the other it works fine. I uploaded a modified version, but not sure whether it works for everyone.

I appreciate any feedback! Please download the latest version from my AHP template download page.

Updated AHP Excel Template Version 08.02.13
Rate this post