12701.xls
Cat Wt Time
Weight
Company X
25 Commute Hours
Work
12 13 25
Team 4 Fun 16 Boss 5 Compensation 16 Salary & Beni's 12 Stock potential 2 Risk 2 Meaning 34 Management and growth 4 Place (where you live) 20 Movement towards something meaningful 0 End product 10 Total 100
1.35 8 3 1.66 6 7 6 1.22 7 9 10 1.46 4 4 4 5
96 39 24 112 30 84 18 20 16 80 0 50 5.69
Company Y 1.61 8 5 1.76 6 7 8 1.22 7 9 10 1.36 4 4 4 4
96 65 24 112 40 84 18 20 16 80 0 40 5.95
Company Z 1.23 7 3 0.98 5 3 6 1.24 9 7 1 2.18 7 6 5 7
84 39 20 48 30 108 14 2 28 120 0 70 5.63
Own business 1.46 10 2 1.49 2 6 9 0.58 4 4 1 2.18 7 6 5 7
Instructions: Add factors (like commute, etc.) Make sure you copy formulas if you add rows… Change weights so that they add to 100 (see below cat weight column) This forces you to understand how important these elements are to you relative to each other I've shown my weights and scores for fictitious job options Fill out green areas with scores from 1-10 Note for negatives, reverse your thinking (so a high score on a negative like Risk means it's NOT risky) Use cat wt subtotals to help guide your weighting Note that as you do, the weighted averages are shown as subtotals and absolute totals along the bottom. Resulting scores are shown at the bottom of each option
W inner
6 5.5 5 4.5 4 3.5 3 2.5
02/09/2008 Row 20
120 26 8 96 45 48 8 2 28 120 0 70 5.71
12701.xls
6 5.5 5 4.5 4 3.5 3 2.5 2 1.5 1 0.5 0
Row 20
Company X
Company Y
Company Z
Own business
02/09/2008
12701.xls
Own business
02/09/2008
12701.xls
02/09/2008