{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["DecisionMatrix"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"DecisionMatrix","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[2,0,2,1],[2,8,2,9],[11,0,11,1],[11,8,11,9]]}
["Weighted Decision Matrix - Post High School Choices "]
[]
["Life After High School ",null,"College ","Technical School","Military ","Workforce Participation","Apprenticenship",null,"Description of Criteria "]
["Criteria","Wt.",1,2,3,4,5,null,"Criteria","Definition"]
["Lifetime Income",{"v":2,"d":"2.0"},0,5,6,2,2,null,{"$f":"A5","v":"Lifetime Income"},"Based on available data, how high are my lifetime earnings likely to be. "]
["Staying out of Debt",{"v":2,"d":"2.0"},0,0,4,2,2,null,"Staying out of Debt","How likely am I to stay out of debt with this option?"]
["Professional Network ",{"v":2,"d":"2.0"},0,2,2,2,4,null,"Professional Network ","How likely am I to meet people who will help me advance in my life and career ?"]
["Easiness of Path ",{"v":1,"d":"1.0"},0,1,1,2,1,null,"Easiness of Path ","How easy will this path be to follow?"]
["Closeness to Family ",{"v":1,"d":"1.0"},0,2,2,2,4,null,"Closeness to Family ","Will I bel able to stay near my family?"]
["Status",{"v":1,"d":"1.0"},1,-2,-2,-3,-3,null,"Status","How positively will I be viewed by others if I choose this path?"]
["Future Job Market ",{"v":1,"d":"1.0"},0,3,5,5,3,null,"Future Job Market ","Based on available data, how likely am I to be employed throughout my life?"]
["Weighted Scores",null,{"$f":"SUMPRODUCT($B5:$B11,C5:C11)","v":{"v":1,"d":"1.0"}},{"$f":"SUMPRODUCT($B5:$B11,D5:D11)","v":{"v":18,"d":"18.0"}},{"$f":"SUMPRODUCT($B5:$B11,E5:E11)","v":{"v":30,"d":"30.0"}},{"$f":"SUMPRODUCT($B5:$B11,F5:F11)","v":{"v":18,"d":"18.0"}},{"v":21,"d":"21.0"},null,"Note on calculation\nThe formula for weighted scores uses a Sumproduct formula and has conditional formatting applied. Please check that the formula and conditional formatting includes the correct cell ranges if you add or remove any rows or columns."]
[]
["Instructions: Select and insert a score of -5 to +5 for each criteria. The score will be multiplied by the weight to arrive at the total weighted score."]
["Keep the first column for status quo (i.e. no change) and score the options against the status quo."]