AHP (IMPORTANCE) WORKSHEET FEATURES

• Create and manage a AHP matrix with up to 200 x 200 Items
• Add, remove, or insert Items
• Expand matrix with the click of a button
• Compare Items against each other
• Sort Items by Row Total, Relative Importance, or Scaled Importance
• Automatic calculation of Relative Importance and Scaled Importance
• Check inputs for logical consistency
• Identify changes that can improve logical consistency
• Export results to QFD, Pugh Matrix, TOPSIS, and SDI Matrix worksheets.
• Context-sensitive help and right-click popup
• All work is stored in a standard Excel worksheet

The two comparison scales available in the AHP (Importance) worksheet are:

SDI Scale:

• 10: Item A is much more important than Item B
• 5: Item A is more important than Item B
• 1: Item A is equally important as Item B
• 1/5: Item A is less important than Item B
• 1/10: Item A is much less importance than Item B
  

Saaty Scale:

• 9: Item A has absolute importance over Item B
• 8: Intermediate value
• 7: Item A has demonstrated importance over Item B
• 6: Intermediate value
• 5: Item A has essential or strong importance over Item B
• 4: Intermediate value
• 3: Item A has weak importance over Item B
• 2: Intermediate value
• 1: Item A is equally important as Item B
• 1/2: Intermediate value
• 1/3: Item B has weak importance over Item A
• 1/4: Intermediate value
• 1/5: Item B has essential or strong importance over Item A
• 1/6: Intermediate value
• 1/7: Item B has demonstrated importance over Item A
• 1/8: Intermediate value
• 1/9: Item B has absolute importance over Item A
  

Using AHP (Importance) Worksheet in Product Development

The Triptych AHP (Importance) Worksheet can be used to prioritize (or rank) Items by performing pair-wise comparisons of Items against each other in terms of relative importance. The theory behind this approach comes from the Analytical Hierarchy Process developed by Thomas Saaty in 1990.

The main advantage with this approach is that it can be easily applied in a group setting and allows a team to come to a consensus on the relative priority of any set of Items. For example, you can:

• generate Importance values for Whats in the QFD worksheet
• generate Importance values for Criteria in the Pugh Matrix, TOPSIS and SDI Matrix Design Selection worksheets.