|
Example
Spreadsheet
for
Comparing Design Concepts
| |
Design
1 |
Design
2 |
Design
3 |
| |
|
|
|
| Feature
1 |
Score
1,1 |
Score
2,1 |
Score
3,1 |
| Feature
2 |
Score
1,2 |
Score
2,2 |
Score
3,2 |
| Feature
3 |
Score
1,3 |
Score
2,3 |
Score
3,3 |
| |
|
|
|
| Totals |
Total 1 |
Total 2 |
Total 3 |
This is a basic template of a spreadsheet you
can use for comparing your design concepts: Design 1, Design 2, and Design 3,
etc. The Features are characteristics such as cost to build, purchase price,
complexity, how well a specific need is addressed, coolness factor, user
acceptance, etc. (You can have more than 3 designs and 3 features.) Score each
design for the features you have selected on a numeric scale (such as 1 - 10)
and add up the columns. The design with the highest total is the overall
best.
You can modify this template to include
weighting factors for each feature. For example, if you believe that cost is
twice as important as other features, you can multiply its score by 2, enter
that value into the cell, and re-compute the totals. This is called a
Pugh Selection
Matrix. Also see:
What is a
Decision Matrix?
|
