Winter Quarter 2012

 Perspectives in Assistive Technology 

David L. Jaffe, MS and Professor Drew Nelson
Tuesdays & Thursdays   4:15pm - 5:30pm
Building 530 - Classroom 127

home icon

Example Spreadsheet
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?

Updated 10/04/2011

Back to Homepage

back to homepage