Spreadsheet Instructions Edit data only in color coded cells - white cells contain formulas and should be left alone) Note: If you need to add factors or categories, please see the example tab for more instructions
Title your options: replace "Option 1", "Option 2" with your option titles
Title categories for consideration in column A : replace "Category 1", "Category 2" with your category labels
Add factors for decision in each category in column B (for a job, this might be commute, pay, etc.)
Assign weights to categories (column C) so that they add to 100 (see below cat weight column for total). This forces you to understand how important these categories are to you relative to each other
Assign weights to each factor within the categories (column D) so they add to 100 (see above factor weights for total). When assigning weights to factors, concentrate on their relative importance, ignoring factors in other categories
Note: when your weights add up properly, you should have no more red totals visible.
Fill out blue areas with scores from 0-10
Note for negatives, reverse your thinking (so a high score on a negative like Risk means it's NOT risky)
Note that as you edit scores, the weighted averages are shown as subtotals and absolute totals along the bottom. For "yes/no" factors, use 0 for no, and 10 for yes.
Comments