SPREADSHEET  q0                ! {+6s2 `! `````````` ` ` ``````````` ` `QN$ֿd $ `ֿѿd ҿѿ `п  ``````````` `QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п  ````````````QN$ֿd $ `ֿѿd ҿѿ `п   {s ѿҿ ` x%%p x&&p x''p x((p x))p x**p x++p x,,p x..p x//p x00p x--pQNֿd $ `ֿѿd ҿѿ `п  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿпd ѿп `Ͽ  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿϿd пϿ `ο  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿοd Ͽο `Ϳ  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ֿd $ `ֿͿd οͿ `̿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ̿d Ϳ̿ `˿  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿ˿d ̿˿ `ʿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿʿd ˿ʿ `ɿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN$ ֿd $ `ֿɿd ʿɿ `ȿ  QN $ ֿd $ `ֿȿ d ɿ ȿ  `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN$ ֿd $ `ֿȿd ɿȿ `ǿ  QN $ֿd $ `ֿǿ d ȿ ǿ  `ƿ  QN $ֿd $ `ֿǿ d ȿ ǿ  `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN$ֿd $ `ֿǿd ȿǿ `ƿ  QN $ֿd $ `ֿƿ d ǿ ƿ  `ſ  QN $ֿd $ `ֿƿ d ǿ ƿ  `ſ  QN $ֿd $ `ֿƿ d ǿ ƿ  `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ  QN$ֿd $ `ֿƿd ǿƿ `ſ          !"#$%&'()*+,-./01234NormTab4?NumFacts22Free1)}@*%%Free2)}@*&&Free3)}@*''Free4)}@*((Free5)}@*))Free6)}H***Free7)}H*++Free8)}H*,,Free9)}H*--Free10)}H*..Free11)}H*//Free12)}H*00MaxFree1s}rt$$MaxFree2s}rt$$MaxFree3s}>t$$MaxFree4-}0.$$MaxFree5-}0.$$MaxFree6-}0.$ $ MaxFree7-}0.$ $ MaxFree8-}0.$ $ MaxFree9-}0.$ $ MaxFree10}0.$ $ MaxFree11}0.$$MaxFree12}0.$$:h.AX 3LOC::M:\WDR\PSIPRINT.WDR%P- %Decider v2.1 -- Pandora Productions  ----------> Factors Options  Individual Ratings Decision notes  Description  Wt  Min.  Max.q  Description   SCORE (%) qSalary qCommuting time (mins) qCareer prospects' qPossibility to work from home qCarqPerksqStressqqq q q +*q#This example shows a comparison for*Salary *Acme Trading Co.  >@ "0u 3 3 3 3 3 3000#q $qj@%qL@&q>@'q(q)q*q+q,q-q.q/q0q2q?4qN@5qD6T@7qN@8qN@9q:qD;q<q =q>q$?q0**q"working for 3 different companies.*Commuting time (mins) * Bad Boys Inc.  UUUUUU7 " N 3< 3 3 3 3 3000#q $qN@%q@&qN@'q(q)q*q+q ,q!-q".q#/q$0q%2q?4q&D@5qT67q8q9q:qY;q<q =q>q%?q10q*Career prospects   *Perfecto Biz ltd.  I@ "j@ 3 3 3 3 3 3000#q ?$q%q'j@&q('q)(q*)q+*q,+q-,q.-q/.q0/q10q22q?4q3Y@5q6T@7qN@8qN@9q:q;q<q=q>q&?q20*q(The salary is set as a range-free factor%*Possibility to work from home      "#q ?$q%q4&q5'q6(q7)q8*q9+q:,q;-q<.q=/q>0q?2q?4q@5q67q8q9q:q;q<q=q>q'?q31*q)(there is no limit on what you get paid). *Car      "#q ?$q%qA&qB'qC(qD)qE*qF+qG,qH-qI.qJ/qK0qL2q?4qM5q67q8q9q:q;q<q=q>q(?q46 *q.Salary and stress are the most important ones,  *Perks         "# q ?$ q% qN& qO' qP( qQ) qR* qS+ qT, qU- qV. qW/ qX0 qY2 q4 qZ5 q6 7 q8 q9 q: q; q< q= q> q)? q53 *q+with an *absolute* weight of 5. Commuting *Stress         "# q ?$ q% q[& q\' q]( q^) q_* q`+ qa, qb- qc. qd/ qe0 qf2 q?4 qg5 q6 7 q8 q9 q: q; q< q= q> q*? q62 *q*time's weight is set to a negative number, (      "# q $ q% qh& qi' qj( qk) ql* qm+ qn, qo- qp. qq/ qr0 qs2 q4 qt5 q6 7 q8 q9 q: q; q< q= q> q+? q76 *q.to denote that it is an *unfavourable* factor. (      "# q $ q% qu& qv' qw( qx) qy* qz+ q{, q|- q}. q~/ q0 q2 q4 q5 q6 7 q8 q9 q: q; q< q= q > q,? q80 *q(Career prospects has a *range* to denote    # q $ q% q& q' q( q) q* q+ q, q- q. q/ q0 q2 q4 q5 q6 7 q8 q9 q: q; q < q= q!> q-? q93*q+None (0), through to Excellent (3), and Car  #q $q%q&q'q(q)q*q+q,q-q.q/q0q2q4q5q67q8q9q:q;q <q=q">q.?q:42q,has a range of 0 to 1 to show you either get  #q $q%q&q'q(q)q*q+q,q-q.q/q0q2q4q5q6T@7qN@8qN@9q:q;q <q=q#>q/?q;*qa car, or you don't.5*q-Note that Perks has factor weight 0 to denote2q@6*q.that it should not be counted in the decision.0q9*q1Having assigned values for these factors for each;*q3company (in the cells K5:Q7), you can observe their*qscores in J4:J7.0q7*q/NOTE 1: If you select I5:J7, and then press the:*q2diamond key, you'll see a graphical representation*qof the scores!(q22q*NOTE 2: You'll notice that even though the12q)Perfecto Biz company got perfect marks in42q,all factors, it only reached a score of 50%.62q.This is due to the weighting mechanism, and in5 2q-particular, to the fact that setting a weight0!2q(between -4 and 4, means that the maximum3"2q+achievable score for that particular factor6#2q.will only be between -80% to 80%. This means6$2q.that the final score cannot be a perfect 100%.8%*q0In this example, the weight of the Car factor is;&*q3set to 3. This means that Perfecto Biz ltd gets a9'*q1score of only 3x20%=60%, for the Car factor, thus$(*qinfluencing its final score.7* /You can ignore cells after column W. They are+ for calculations only.