The AHP Worksheet

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

en
  1. 1
    Group Selector
    Select the focused group by clicking the drop down button or the scroll buttons
  2. 2
    VOC / Criteria
    This section shows the items inside the selected group
  3. 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. 4
    Importance in Group
    This section shows the calculated importance in percent for the focused group.
  5. 5
    Bar Chart
    This chart shows the calculated importance as bar graphs. A confidence interval can appear as black line inside each bar.
  6. 6
    Consistency
    This section shows the calculated consistency index. A consistency index of 0 shows that the matrix is completely consistent.

More Worksheets

VOC
VOC AHP Pareto
AHP Matrix (VOC)
VOC AHP Calculation Sheet
VOC Prioritization