Calculate priorities from pairwise comparisons using the analytic hierarchy process (AHP) with eigen vector method. Input the number of criteria between 2 and 20 1) and a name for each criterion. Next, do a pairwise comparison: Which of the criterion in each pair is more important, and how many times more, on a one to nine scale. With Check consistency you will then get the resulting priorities, their ranking, and a consistency ratio CR2) (ideally < 10%). Calculation is done using the fundamental 1 to 9 AHP ratio scale.
The three judgments with highest inconsistency will be highlighted, with the last column showing the recommended judgment for lowest consistency ratio. Slightly modify your comparisons, if you want to improve consistency, and recalculate the result, or download the result as a csv file.
Example of inconsistent pair-wise comparisons. The most inconsistent judgment no 2 is marked in red (Color or Delivery); the consistent judgment would be 3 (B) and is highlighted in light green. Decision makers can decide to adjust some of their original judgments to improve consistency.
|Here the link: AHP priority calculator|
Kindly rate the software from 1 star (poor) to 5 stars (excellent) at the bottom of this post.
Format of the csv file
Fields are separated by tabs:
- Line 1: Date (yyyy-mm-dd) Time (hh:mm:ss) Title (text)
- Line 2: Number of criteria n
- Line 3: Criteria
- Line 4 to 4+n: Decison matrix
- Second last line: Priority vector
- Last line: eigenvalue and consistency ratio CR
1) Though the maximum number of criteria is 15, you should always try to structure your decision problem in a way that the number of criteria is in the range 5 to 9.
2) Alonso, Lamata, (2006). Consistency in the analytic hierarchy process: a new approach. International Journal of Uncertainty, Fuzziness and Knowledge based systems, Vol 14, No 4, 445-459.
Incoming search terms:
- pairwise comparison calculator
- ahp calculator excel
- pairwise comparison method calculator excel
- ahp online
- pairwise comparison method calculator
- ahp tool