{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cost Worksheet","Data Table"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cost Worksheet","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,0,5,7],[17,0,17,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[6,0,6,2],[13,0,13,2],[16,7,24,7],[6,6,13,7],[8,0,8,2],[7,0,7,2],[15,0,15,2],[16,0,16,2],[25,0,25,2],[27,0,28,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[24,0,24,2]]}
[]
[]
[]
[]
[]
["ESTIMATED COST WORKSHEET"]
["What We'll Bill You For",null,null,"Fall","Spring","Year","This is an estimate of what you will be billed"]
["Click Here to Select Course Load",null,null,{"$f":"IF(A8=\"Click Here to Select Course Load\",0,IF(A8=\"18 Hrs/Sem (In-State)\",5911,IF(A8=\"17 Hrs/Sem (In-State)\",5621,IF(A8=\"16 Hrs/Sem (In-State)\",5331,IF(A8=\"15 Hrs/Sem (In-State)\",5041,IF(A8=\"14 Hrs/Sem (In-State)\",4751,IF(A8=\"13 Hrs/Sem (In-State)\",4461,IF(A8=\"12 Hrs/Sem (In-State)\",4171,IF(A8=\"11 Hrs/Sem (In-State)\",3881,IF(A8=\"10 Hrs/Sem (In-State)\",3591,IF(A8=\"9 Hrs/Sem (In-State)\",3301,IF(A8=\"8 Hrs/Sem (In-State)\",3011,IF(A8=\"7 Hrs/Sem (In-State)\",2721,IF(A8=\"6 Hrs/Sem (In-State)\",2327,IF(A8=\"18 Hrs/Sem (Out-of-State)\",11869,IF(A8=\"17 Hrs/Sem (Out-of-State)\",10627,IF(A8=\"16 Hrs/Sem (Out-of-State)\",10627,IF(A8=\"15 Hrs/Sem (Out-of-State)\",10006,IF(A8=\"14 Hrs/Sem (Out-of-State)\",9385,IF(A8=\"13 Hrs/Sem (Out-of-State)\",8764,IF(A8=\"12 Hrs/Sem (Out-of-State)\",8143,IF(A8=\"11 Hrs/Sem (Out-of-State)\",7522,IF(A8=\"10 Hrs/Sem (Out-of-State)\",6901,IF(A8=\"9 Hrs/Sem (Out-of-State)\",6280,IF(A8=\"8 Hrs/Sem (Out-of-State)\",5659,IF(A8=\"7 Hrs/Sem (Out-of-State)\",5038,IF(A8=\"6 Hrs/Sem (Out-of-State)\",4313,IF(A8=\"\",0))))))))))))))))))))))))))))","v":0},{"$f":"IF(A8=\"Click Here to Select Course Load\",0,IF(A8=\"18 Hrs/Sem (In-State)\",5911,IF(A8=\"17 Hrs/Sem (In-State)\",5621,IF(A8=\"16 Hrs/Sem (In-State)\",5331,IF(A8=\"15 Hrs/Sem (In-State)\",5041,IF(A8=\"14 Hrs/Sem (In-State)\",4751,IF(A8=\"13 Hrs/Sem (In-State)\",4461,IF(A8=\"12 Hrs/Sem (In-State)\",4171,IF(A8=\"11 Hrs/Sem (In-State)\",3881,IF(A8=\"10 Hrs/Sem (In-State)\",3591,IF(A8=\"9 Hrs/Sem (In-State)\",3301,IF(A8=\"8 Hrs/Sem (In-State)\",3011,IF(A8=\"7 Hrs/Sem (In-State)\",2721,IF(A8=\"6 Hrs/Sem (In-State)\",2327,IF(A8=\"18 Hrs/Sem (Out-of-State)\",11869,IF(A8=\"17 Hrs/Sem (Out-of-State)\",10627,IF(A8=\"16 Hrs/Sem (Out-of-State)\",10627,IF(A8=\"15 Hrs/Sem (Out-of-State)\",10006,IF(A8=\"14 Hrs/Sem (Out-of-State)\",9385,IF(A8=\"13 Hrs/Sem (Out-of-State)\",8764,IF(A8=\"12 Hrs/Sem (Out-of-State)\",8143,IF(A8=\"11 Hrs/Sem (Out-of-State)\",7522,IF(A8=\"10 Hrs/Sem (Out-of-State)\",6901,IF(A8=\"9 Hrs/Sem (Out-of-State)\",6280,IF(A8=\"8 Hrs/Sem (Out-of-State)\",5659,IF(A8=\"7 Hrs/Sem (Out-of-State)\",5038,IF(A8=\"6 Hrs/Sem (Out-of-State)\",4313,IF(A8=\"\",0))))))))))))))))))))))))))))","v":0},{"$f":"SUM(D8:E8)","v":0}]
["Click Here to Select Housing",null,null,{"$f":"IF(A9 = \"Click Here to Select Housing\", 0, IF(A9=\"Freudenberger 2 or 3-Person\", 3371, IF(A9=\"Wells 2-Person\", 3371, IF(A9=\"Wells 4-Person\", 3628, IF(A9=\"Woods 1-Person\", 3977, IF(A9=\"Woods 2-Person\", 3371, IF(A9=\"Blair-Shannon 6-Person\", 3715, IF(A9=\"Hammons or Hutchens 2-Person\", 4699, IF(A9=\"Hammons or Hutchens 4-Person\", 4098, IF(A9=\"Kentwood 1-Person\", 4357, IF(A9=\"Kentwood 2 and 3-Person\", 3737, IF(A9=\"Kentwood 2-Person Super Double\", 4227, IF(A9=\"Scholars\", 4098, IF(A9=\"Monroe 1-Person\", 3747, IF(A9=\"Monroe 2-Person\", 3636, IF(A9=\"Monroe 4-Person\", 3407, IF(A9=\"Sunvilla 2-Person\", 3202, IF(A9=\"Sunvilla 3-Person\", 3063, IF(A9=\"Sunvilla 3-Person - Private\", 3341, IF(A9=\"Sunvilla 4-Person\", 2914, IF(A9=\"Heitz Hall\", 3715, IF(A9=\"With Parent(s)\", 0))))))))))))))))))))))","v":0},{"$f":"IF(A9 = \"Click Here to Select Housing\", 0, IF(A9=\"Freudenberger 2 or 3-Person\", 3371, IF(A9=\"Wells 2-Person\", 3371, IF(A9=\"Wells 4-Person\", 3628, IF(A9=\"Woods 1-Person\", 3977, IF(A9=\"Woods 2-Person\", 3371, IF(A9=\"Blair-Shannon 6-Person\", 3715, IF(A9=\"Hammons or Hutchens 2-Person\", 4699, IF(A9=\"Hammons or Hutchens 4-Person\", 4098, IF(A9=\"Kentwood 1-Person\", 4357, IF(A9=\"Kentwood 2 and 3-Person\", 3737, IF(A9=\"Kentwood 2-Person Super Double\", 4227, IF(A9=\"Scholars\", 4098, IF(A9=\"Monroe 1-Person\", 3747, IF(A9=\"Monroe 2-Person\", 3636, IF(A9=\"Monroe 4-Person\", 3407, IF(A9=\"Sunvilla 2-Person\", 3202, IF(A9=\"Sunvilla 3-Person\", 3063, IF(A9=\"Sunvilla 3-Person - Private\", 3341, IF(A9=\"Sunvilla 4-Person\", 2914, IF(A9=\"Heitz Hall\", 3715, IF(A9=\"With Parent(s)\", 0))))))))))))))))))))))","v":0},0]
["Click Here to Select a Meal Plan",null,null,{"$f":"IF(A10 =\"Click Here to Select a Meal Plan\", 0, IF(A10 =\"Unlimited meal/week\", 1566, IF(A10 =\"19-Meals/week\", 1463, IF(A10 =\"14-Meals/week\", 1437, IF(A10 =\"10-Meals/week\", 1418, IF(A10 = \"\", 0))))))","v":0},{"$f":"IF(A10 =\"Click Here to Select a Meal Plan\", 0, IF(A10 =\"Unlimited meal/week\", 1566, IF(A10 =\"19-Meals/week\", 1463, IF(A10 =\"14-Meals/week\", 1437, IF(A10 =\"10-Meals/week\", 1418, IF(A10 = \"\", 0))))))","v":0},0]
["Click Here to Select a Dining Dollars Plan",null,null,{"$f":"IF(A11=\"Click Here to Select a Dining Dollars Plan\", 0, IF(A11=\"Option 1 - $310 (Worth $340)\",310,IF(A11=\"Option 2 - $242 (Worth $265)\",242,IF(A11=\"Option 3 - $192 (Worth $210)\",192,IF(A11=\"\",0)))))","v":0},{"$f":"IF(A11=\"Click Here to Select a Dining Dollars Plan\", 0, IF(A11=\"Option 1 - $310 (Worth $340)\",310,IF(A11=\"Option 2 - $242 (Worth $265)\",242,IF(A11=\"Option 3 - $192 (Worth $210)\",192,IF(A11=\"\",0)))))","v":0},0]
["Click Here to Select a Parking Permit",null,null,{"$f":"IF(A12=\"Click Here to Select a Parking Permit\", 0, IF(A12=\"Commuter Parking\",60.5,IF(A12=\"Residence Hall Parking\",99,IF(A12=\"Motorcycle Parking\",13.5,IF(A12=\"Orange Lot Parking\",33.5,IF(A12=\"\",0))))))","v":0},{"$f":"IF(A12=\"Click Here to Select a Parking Permit\", 0, IF(A12=\"Commuter Parking\",60.5,IF(A12=\"Residence Hall Parking\",99,IF(A12=\"Motorcycle Parking\",13.5,IF(A12=\"Orange Lot Parking\",33.5,IF(A12=\"\",0))))))","v":0},0]
[{"$f":"IF(A8= \"Click Here to Select Course Load\", \"\",\"Books & Supplies\")","v":""},null,null,{"$f":"IF(A8=\"18 Hrs/Sem (In-State)\",600,IF(A8=\"17 Hrs/Sem (In-State)\",600,IF(A8=\"16 Hrs/Sem (In-State)\",600,IF(A8=\"15 Hrs/Sem (In-State)\",600,IF(A8=\"14 Hrs/Sem (In-State)\",600,IF(A8=\"13 Hrs/Sem (In-State)\",600,IF(A8=\"12 Hrs/Sem (In-State)\",600,IF(A8=\"11 Hrs/Sem (In-State)\",450,IF(A8=\"10 Hrs/Sem (In-State)\",450,IF(A8=\"9 Hrs/Sem (In-State)\",450,IF(A8=\"8 Hrs/Sem (In-State)\",300,IF(A8=\"7 Hrs/Sem (In-State)\",300,IF(A8=\"6 Hrs/Sem (In-State)\",300,IF(A8=\"18 Hrs/Sem (Out-of-State)\",600,IF(A8=\"17 Hrs/Sem (Out-of-State)\",600,IF(A8=\"16 Hrs/Sem (Out-of-State)\",600,IF(A8=\"15 Hrs/Sem (Out-of-State)\",600,IF(A8=\"14 Hrs/Sem (Out-of-State)\",600,IF(A8=\"13 Hrs/Sem (Out-of-State)\",600,IF(A8=\"12 Hrs/Sem (Out-of-State)\",600,IF(A8=\"11 Hrs/Sem (Out-of-State)\",450,IF(A8=\"10 Hrs/Sem (Out-of-State)\",450,IF(A8=\"9 Hrs/Sem (Out-of-State)\",450,IF(A8=\"8 Hrs/Sem (Out-of-State)\",300,IF(A8=\"7 Hrs/Sem (Out-of-State)\",300,IF(A8=\"6 Hrs/Sem (Out-of-State)\",300,IF(A8=\"Click Here to Select Course Load\",0)))))))))))))))))))))))))))","v":0},{"$f":"IF(A8=\"18 Hrs/Sem (In-State)\",600,IF(A8=\"17 Hrs/Sem (In-State)\",600,IF(A8=\"16 Hrs/Sem (In-State)\",600,IF(A8=\"15 Hrs/Sem (In-State)\",600,IF(A8=\"14 Hrs/Sem (In-State)\",600,IF(A8=\"13 Hrs/Sem (In-State)\",600,IF(A8=\"12 Hrs/Sem (In-State)\",600,IF(A8=\"11 Hrs/Sem (In-State)\",450,IF(A8=\"10 Hrs/Sem (In-State)\",450,IF(A8=\"9 Hrs/Sem (In-State)\",450,IF(A8=\"8 Hrs/Sem (In-State)\",300,IF(A8=\"7 Hrs/Sem (In-State)\",300,IF(A8=\"6 Hrs/Sem (In-State)\",300,IF(A8=\"18 Hrs/Sem (Out-of-State)\",600,IF(A8=\"17 Hrs/Sem (Out-of-State)\",600,IF(A8=\"16 Hrs/Sem (Out-of-State)\",600,IF(A8=\"15 Hrs/Sem (Out-of-State)\",600,IF(A8=\"14 Hrs/Sem (Out-of-State)\",600,IF(A8=\"13 Hrs/Sem (Out-of-State)\",600,IF(A8=\"12 Hrs/Sem (Out-of-State)\",600,IF(A8=\"11 Hrs/Sem (Out-of-State)\",450,IF(A8=\"10 Hrs/Sem (Out-of-State)\",450,IF(A8=\"9 Hrs/Sem (Out-of-State)\",450,IF(A8=\"8 Hrs/Sem (Out-of-State)\",300,IF(A8=\"7 Hrs/Sem (Out-of-State)\",300,IF(A8=\"6 Hrs/Sem (Out-of-State)\",300,IF(A8=\"Click Here to Select Course Load\",0)))))))))))))))))))))))))))","v":0},0]
["Your Total Estimated Bill",null,null,{"$f":"SUM(D8:D13)","v":0},{"$f":"SUM(E8:E13)","v":0},0]
[]
["Financial Aid Offer",null,null,"Fall","Spring","Total"]
["Click Here to Select an Aid Program",null,null,{"$f":"F17/2","v":0},{"$f":"F17/2","v":0},null,null,"Enter your scholarships,grants, and loans here"]
["Click Here to Select an Aid Program",null,null,{"$f":"F18/2","v":0},{"$f":"F18/2","v":0}]
["Click Here to Select an Aid Program",null,null,0,0]
["Click Here to Select an Aid Program",null,null,0,0]
["Click Here to Select an Aid Program",null,null,0,0]
["Click Here to Select an Aid Program",null,null,0,0]
["Click Here to Select an Aid Program",null,null,0,0]
["Click Here to Select an Aid Program",null,null,0,0]
["Click Here to Select an Aid Program",null,null,0,0]
["Your Total Estimated Aid",null,null,{"$f":"SUM(D17:D25)","v":0},{"$f":"SUM(E17:E25)","v":0},0]
[]
["Estimated Out-of-Pocket Expenses",null,null,"Fall","Spring","Total"]
[null,null,null,{"$f":"SUM(D14-D26)","v":0},{"$f":"SUM(E14-E26)","v":0},0]

{"sheet":"Data Table","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["WORKSHEET PASSWORD: Boomer"]
[null,"Click Here to Select Housing",null,null,"Click Here to Select an Aid Program"]
[null,"Freudenberger 2 or 3-Person",3371,null,"Federal Pell Grant",null,null,null,null,{"$f":"IF(ROW(E3:E13)-ROW(E3)=1>COUNT(I3:I13),\"\",INDEX(E3:E13,SMALL(I3:I13,ROW(INDIRECT(\"1:\"&ROWS(E3:E13))))))","v":""}]
[null,"Wells 2-Person",3371,null,"FSEO Grant",null,null,null,null,{"$f":"IF(ROW(E4:E14)-ROW(E4)=1>COUNT(I4:I14),\"\",INDEX(E4:E14,SMALL(I4:I14,ROW(INDIRECT(\"1:\"&ROWS(E4:E14))))))","v":""}]
[null,"Wells 4-Person",3628,null,"Access Missouri Grant",null,null,null,null,""]
[null,"Woods 1-Person",3977,null,"Bright Flight Scholarship",null,null,null,null,""]
[null,"Woods 2-Person",3371,null,"Institutional Scholarship",null,null,null,null,""]
[null,"Blair-Shannon 6-Person",3715,null,"Foundation Scholarship",null,null,null,null,""]
[null,"Hammons or Hutchens 2-Person",4699,null,"Outside Scholarship",null,null,null,null,""]
[null,"Hammons or Hutchens 4-Person",4098,null,"Federal Work-Study",null,null,null,null,""]
[null,"Kentwood 1-Person",4357,null,"Direct Subsidized Loan",null,null,null,null,""]
[null,"Kentwood 2 and 3-Person",3737,null,"Direct Unsubsidized Loan",null,null,null,null,""]
[null,"Kentwood 2-Person Super Double",4227,null,"Other",null,null,null,null,""]
[null,"Scholars",4098]
[null,"Monroe 1-Person",3747,null,"Click Here to Select Course Load"]
[null,"Monroe 2-Person",3636,null,"18 Hrs/Sem (In-State)",18,{"$f":"SUM(F16*290)","v":5220},691,{"$f":"SUM(G16:H16)","v":5911},2,{"$f":"SUM(I16*J16)","v":11822}]
[null,"Monroe 4-Person",3407,null,"17 Hrs/Sem (In-State)",17,{"$f":"SUM(F17*290)","v":4930},691,{"$f":"SUM(G17:H17)","v":5621},2,{"$f":"SUM(I17*J17)","v":11242}]
[null,"Sunvilla 2-Person",3202,null,"16 Hrs/Sem (In-State)",16,4640,691,5331,2,10662]
[null,"Sunvilla 3-Person",3063,null,"15 Hrs/Sem (In-State)",15,4350,691,{"$f":"SUM(G19:H19)","v":5041},2,10082]
[null,"Sunvilla 3-Person - Private",3341,null,"14 Hrs/Sem (In-State)",14,4060,691,4751,2,9502]
[null,"Sunvilla 4-Person",2914,null,"13 Hrs/Sem (In-State)",13,3770,691,4461,2,8922]
[null,"Heitz Hall",3715,null,"12 Hrs/Sem (In-State)",12,3480,691,4171,2,8342]
[null,"With Parent(s)",0,null,"11 Hrs/Sem (In-State)",11,3190,691,3881,2,7762]
[null,null,null,null,"10 Hrs/Sem (In-State)",10,2900,691,3591,2,7182]
[null,"Click Here to Select a Meal Plan",null,null,"9 Hrs/Sem (In-State)",9,2610,691,3301,2,6602]
[null,"Unlimited meal/week",1566,null,"8 Hrs/Sem (In-State)",8,2320,691,3011,2,6022]
[null,"19-Meals/week",1463,null,"7 Hrs/Sem (In-State)",7,2030,691,2721,2,5442]
[null,"14-Meals/week",1437,null,"6 Hrs/Sem (In-State)",6,1740,587,2327,2,4654]
[null,"10-Meals/week",1418,null,"18 Hrs/Sem (Out-of-State)",18,{"$f":"SUM(F29*621)","v":11178},691,11869,2,23738]
[null,null,null,null,"17 Hrs/Sem (Out-of-State)",17,{"$f":"SUM(F30*621)","v":10557},691,11248,2,22496]
[null,"Click Here to Select a Dining Dollars Plan",null,null,"16 Hrs/Sem (Out-of-State)",16,9936,691,10627,2,21254]
[null,"Option 1 - $310 (Worth $340)",310,null,"15 Hrs/Sem (Out-of-State)",15,9315,691,10006,2,20012]
[null,"Option 2 - $242 (Worth $265)",242,null,"14 Hrs/Sem (Out-of-State)",14,8694,691,9385,2,18770]
[null,"Option 3 - $192 (Worth $210)",192,null,"13 Hrs/Sem (Out-of-State)",13,8073,691,8764,2,17528]
[null,null,null,null,"12 Hrs/Sem (Out-of-State)",12,7452,691,8143,2,16286]
[null,"Click Here to Select a Parking Permit",null,null,"11 Hrs/Sem (Out-of-State)",11,6831,691,7522,2,15044]
[null,"Commuter Parking",60.5,null,"10 Hrs/Sem (Out-of-State)",10,6210,691,6901,2,13802]
[null,"Residence Hall Parking",99,null,"9 Hrs/Sem (Out-of-State)",9,5589,691,6280,2,12560]
[null,"Motorcycle Parking",13.5,null,"8 Hrs/Sem (Out-of-State)",8,4968,691,5659,2,11318]
[null,"Orange Lot Parking",34,null,"7 Hrs/Sem (Out-of-State)",7,4347,691,5038,2,10076]
[null,null,null,null,"6 Hrs/Sem (Out-of-State)",6,3726,587,4313,2,8626]