Templates

The AHP Worksheet

The AHP component's main worksheet contains everything to fill out and calculate the AHP prioritization.

1
Group Selector
Select the focused group by clicking the drop down button or the scroll buttons
2
VOC / Criteria
This section shows the items inside the selected group
3
AHP Matrix
Enter the comparison values. Clicking into a cell will open a menu to choose from. Use keyboard input 1...9 if the left element is more important or Shift+1...9 if the left element is less important than the top element. Opposite (reciprocal) values are calculated automatically. Press F5 to start calculation. After calculation, items are sorted by importance. This helps to eliminate inconsistencies. Sorting can be changed or stopped using Sort from the Home ribbon.
4
Importance in Group
This section shows the calculated importance in percent for the focused group.
5
Bar Chart
This chart shows the calculated importance as bar graphs. A confidence interval can appear as black line inside each bar.
6
Consistency
This section shows the calculated consistency index. A consistency index of 0 shows that the matrix is completely consistent.