{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cost Worksheet","Data Table"],"not_rendered":{"charts":0,"images":3,"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":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,1,5,8],[17,1,17,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[6,1,6,3],[13,1,13,3],[27,2,28,3],[6,7,13,8],[17,7,23,7],[15,8,25,8],[8,1,8,3],[7,1,7,3],[15,1,15,3],[16,1,16,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[24,1,24,3],[25,1,25,3]]}
[]
[]
[]
[]
[]
[null,"ESTIMATED COST WORKSHEET"]
[null,"What We'll Bill You For",null,null,"Fall","Spring","Year","This is an estimate of what you will be billed"]
[null,"15 Hrs/Sem (In-State)",null,null,{"$f":"IF(B8=\"Click Here to Select Course Load\",0,IF(B8=\"18 Hrs/Sem (In-State)\",5370,IF(B8=\"17 Hrs/Sem (In-State)\",5103,IF(B8=\"16 Hrs/Sem (In-State)\",4836,IF(B8=\"15 Hrs/Sem (In-State)\",4569,IF(B8=\"14 Hrs/Sem (In-State)\",4302,IF(B8=\"13 Hrs/Sem (In-State)\",4035,IF(B8=\"12 Hrs/Sem (In-State)\",3768,IF(B8=\"11 Hrs/Sem (In-State)\",3501,IF(B8=\"10 Hrs/Sem (In-State)\",3234,IF(B8=\"9 Hrs/Sem (In-State)\",2967,IF(B8=\"8 Hrs/Sem (In-State)\",2700,IF(B8=\"7 Hrs/Sem (In-State)\",2433,IF(B8=\"6 Hrs/Sem (In-State)\",2069,IF(B8=\"18 Hrs/Sem (Out-of-State)\",10860,IF(B8=\"17 Hrs/Sem (Out-of-State)\",10288,IF(B8=\"16 Hrs/Sem (Out-of-State)\",9716,IF(B8=\"15 Hrs/Sem (Out-of-State)\",9144,IF(B8=\"14 Hrs/Sem (Out-of-State)\",8572,IF(B8=\"13 Hrs/Sem (Out-of-State)\",8000,IF(B8=\"12 Hrs/Sem (Out-of-State)\",7428,IF(B8=\"11 Hrs/Sem (Out-of-State)\",6856,IF(B8=\"10 Hrs/Sem (Out-of-State)\",6284,IF(B8=\"9 Hrs/Sem (Out-of-State)\",5712,IF(B8=\"8 Hrs/Sem (Out-of-State)\",5140,IF(B8=\"7 Hrs/Sem (Out-of-State)\",4568,IF(B8=\"6 Hrs/Sem (Out-of-State)\",3899,IF(B8=\"\",0))))))))))))))))))))))))))))","v":4569},{"$f":"IF(B8=\"Click Here to Select Course Load\",0,IF(B8=\"18 Hrs/Sem (In-State)\",5370,IF(B8=\"17 Hrs/Sem (In-State)\",5103,IF(B8=\"16 Hrs/Sem (In-State)\",4836,IF(B8=\"15 Hrs/Sem (In-State)\",4569,IF(B8=\"14 Hrs/Sem (In-State)\",4302,IF(B8=\"13 Hrs/Sem (In-State)\",4035,IF(B8=\"12 Hrs/Sem (In-State)\",3768,IF(B8=\"11 Hrs/Sem (In-State)\",3501,IF(B8=\"10 Hrs/Sem (In-State)\",3234,IF(B8=\"9 Hrs/Sem (In-State)\",2967,IF(B8=\"8 Hrs/Sem (In-State)\",2700,IF(B8=\"7 Hrs/Sem (In-State)\",2433,IF(B8=\"6 Hrs/Sem (In-State)\",2069,IF(B8=\"18 Hrs/Sem (Out-of-State)\",10860,IF(B8=\"17 Hrs/Sem (Out-of-State)\",10288,IF(B8=\"16 Hrs/Sem (Out-of-State)\",9716,IF(B8=\"15 Hrs/Sem (Out-of-State)\",9144,IF(B8=\"14 Hrs/Sem (Out-of-State)\",8572,IF(B8=\"13 Hrs/Sem (Out-of-State)\",8000,IF(B8=\"12 Hrs/Sem (Out-of-State)\",7428,IF(B8=\"11 Hrs/Sem (Out-of-State)\",6856,IF(B8=\"10 Hrs/Sem (Out-of-State)\",6284,IF(B8=\"9 Hrs/Sem (Out-of-State)\",5712,IF(B8=\"8 Hrs/Sem (Out-of-State)\",5140,IF(B8=\"7 Hrs/Sem (Out-of-State)\",4568,IF(B8=\"6 Hrs/Sem (Out-of-State)\",3899,IF(B8=\"\",0))))))))))))))))))))))))))))","v":4569},{"$f":"SUM(E8:F8)","v":9138}]
[null,"Blair-Shannon 6-Person",null,null,{"$f":"IF(B9 = \"Click Here to Select Housing\", 0, IF(B9=\"Freudenberger 2 or 3-Person\", 3225, IF(B9=\"Wells 2-Person\", 3225, IF(B9=\"Wells 4-Person\", 3469, IF(B9=\"Woods 2-Person\", 3225, IF(B9=\"Blair-Shannon 6-Person\", 3573, IF(B9=\"Hammons or Hutchens 2-Person\", 4493, IF(B9=\"Hammons or Hutchens 4-Person\", 3922, IF(B9=\"Kentwood 1-Person\", 4166, IF(B9=\"Kentwood 2 and 3-Person\", 3573, IF(B9=\"Kentwood 2-Person Super Double\", 4041, IF(B9=\"Scholars\", 3918, IF(B9=\"Monroe 1-Person\", 3620, IF(B9=\"Monroe 2-Person\", 3513, IF(B9=\"Monroe 4-Person\", 3292, IF(B9=\"Sunvilla 2-Person\", 3094, IF(B9=\"Sunvilla 3-Person\", 2959, IF(B9=\"Sunvilla 3-Person - Private\", 3228, IF(B9=\"Sunvilla 4-Person\", 2825, IF(B9=\"With Parent(s)\", 0))))))))))))))))))))","v":3573},{"$f":"IF(B9 = \"Click Here to Select Housing\", 0, IF(B9=\"Freudenberger 2 or 3-Person\", 3225, IF(B9=\"Wells 2-Person\", 3225, IF(B9=\"Wells 4-Person\", 3469, IF(B9=\"Woods 2-Person\", 3225, IF(B9=\"Blair-Shannon 6-Person\", 3573, IF(B9=\"Hammons or Hutchens 2-Person\", 4493, IF(B9=\"Hammons or Hutchens 4-Person\", 3922, IF(B9=\"Kentwood 1-Person\", 4166, IF(B9=\"Kentwood 2 and 3-Person\", 3573, IF(B9=\"Kentwood 2-Person Super Double\", 4041, IF(B9=\"Scholars\", 3918, IF(B9=\"Monroe 1-Person\", 3620, IF(B9=\"Monroe 2-Person\", 3513, IF(B9=\"Monroe 4-Person\", 3292, IF(B9=\"Sunvilla 2-Person\", 3094, IF(B9=\"Sunvilla 3-Person\", 2959, IF(B9=\"Sunvilla 3-Person - Private\", 3228, IF(B9=\"Sunvilla 4-Person\", 2825, IF(B9=\"With Parent(s)\", 0))))))))))))))))))))","v":3573},7146]
[null,"14-Meals/week",null,null,{"$f":"IF(B10 =\"Click Here to Select a Meal Plan\", 0, IF(B10 =\"Unlimited meal/week\", 1349, IF(B10 =\"19-Meals/week\", 1261, IF(B10 =\"14-Meals/week\", 1238, IF(B10 =\"10-Meals/week\", 1222, IF(B10 = \"\", 0))))))","v":1238},{"$f":"IF(B10 =\"Click Here to Select a Meal Plan\", 0, IF(B10 =\"Unlimited meal/week\", 1349, IF(B10 =\"19-Meals/week\", 1261, IF(B10 =\"14-Meals/week\", 1238, IF(B10 =\"10-Meals/week\", 1222, IF(B10 = \"\", 0))))))","v":1238},2476]
[null,"Option 3 - $165 (Worth $181)",null,null,{"$f":"IF(B11=\"Click Here to Select a Dining Dollars Plan\", 0, IF(B11=\"Option 1 - $280 (Worth $307)\",280,IF(B11=\"Option 2 - $215 (Worth $236)\",215,IF(B11=\"Option 3 - $165 (Worth $181)\",165,IF(B11=\"\",0)))))","v":165},{"$f":"IF(B11=\"Click Here to Select a Dining Dollars Plan\", 0, IF(B11=\"Option 1 - $280 (Worth $307)\",280,IF(B11=\"Option 2 - $215 (Worth $236)\",215,IF(B11=\"Option 3 - $165 (Worth $181)\",165,IF(B11=\"\",0)))))","v":165},330]
[null,"Click Here to Select a Parking Permit",null,null,{"$f":"IF(B12=\"Click Here to Select a Parking Permit\", 0, IF(B12=\"Commuter Parking\",66.5,IF(B12=\"Residence Hall Parking\",109,IF(B12=\"Motorcycle Parking\",12.5,IF(B12=\"Orange Lot Parking\",37,IF(B12=\"\",0))))))","v":0},{"$f":"IF(B12=\"Click Here to Select a Parking Permit\", 0, IF(B12=\"Commuter Parking\",66.5,IF(B12=\"Residence Hall Parking\",109,IF(B12=\"Motorcycle Parking\",12.5,IF(B12=\"Orange Lot Parking\",37,IF(B12=\"\",0))))))","v":0},0]
[null,{"$f":"IF(B8= \"Click Here to Select Course Load\", \"\",\"Books & Supplies\")","v":"Books & Supplies"},null,null,{"$f":"IF(B8=\"18 Hrs/Sem (In-State)\",600,IF(B8=\"17 Hrs/Sem (In-State)\",600,IF(B8=\"16 Hrs/Sem (In-State)\",600,IF(B8=\"15 Hrs/Sem (In-State)\",600,IF(B8=\"14 Hrs/Sem (In-State)\",600,IF(B8=\"13 Hrs/Sem (In-State)\",600,IF(B8=\"12 Hrs/Sem (In-State)\",600,IF(B8=\"11 Hrs/Sem (In-State)\",450,IF(B8=\"10 Hrs/Sem (In-State)\",450,IF(B8=\"9 Hrs/Sem (In-State)\",450,IF(B8=\"8 Hrs/Sem (In-State)\",300,IF(B8=\"7 Hrs/Sem (In-State)\",300,IF(B8=\"6 Hrs/Sem (In-State)\",300,IF(B8=\"18 Hrs/Sem (Out-of-State)\",600,IF(B8=\"17 Hrs/Sem (Out-of-State)\",600,IF(B8=\"16 Hrs/Sem (Out-of-State)\",600,IF(B8=\"15 Hrs/Sem (Out-of-State)\",600,IF(B8=\"14 Hrs/Sem (Out-of-State)\",600,IF(B8=\"13 Hrs/Sem (Out-of-State)\",600,IF(B8=\"12 Hrs/Sem (Out-of-State)\",600,IF(B8=\"11 Hrs/Sem (Out-of-State)\",450,IF(B8=\"10 Hrs/Sem (Out-of-State)\",450,IF(B8=\"9 Hrs/Sem (Out-of-State)\",450,IF(B8=\"8 Hrs/Sem (Out-of-State)\",300,IF(B8=\"7 Hrs/Sem (Out-of-State)\",300,IF(B8=\"6 Hrs/Sem (Out-of-State)\",300,IF(B8=\"Click Here to Select Course Load\",0)))))))))))))))))))))))))))","v":600},{"$f":"IF(B8=\"18 Hrs/Sem (In-State)\",600,IF(B8=\"17 Hrs/Sem (In-State)\",600,IF(B8=\"16 Hrs/Sem (In-State)\",600,IF(B8=\"15 Hrs/Sem (In-State)\",600,IF(B8=\"14 Hrs/Sem (In-State)\",600,IF(B8=\"13 Hrs/Sem (In-State)\",600,IF(B8=\"12 Hrs/Sem (In-State)\",600,IF(B8=\"11 Hrs/Sem (In-State)\",450,IF(B8=\"10 Hrs/Sem (In-State)\",450,IF(B8=\"9 Hrs/Sem (In-State)\",450,IF(B8=\"8 Hrs/Sem (In-State)\",300,IF(B8=\"7 Hrs/Sem (In-State)\",300,IF(B8=\"6 Hrs/Sem (In-State)\",300,IF(B8=\"18 Hrs/Sem (Out-of-State)\",600,IF(B8=\"17 Hrs/Sem (Out-of-State)\",600,IF(B8=\"16 Hrs/Sem (Out-of-State)\",600,IF(B8=\"15 Hrs/Sem (Out-of-State)\",600,IF(B8=\"14 Hrs/Sem (Out-of-State)\",600,IF(B8=\"13 Hrs/Sem (Out-of-State)\",600,IF(B8=\"12 Hrs/Sem (Out-of-State)\",600,IF(B8=\"11 Hrs/Sem (Out-of-State)\",450,IF(B8=\"10 Hrs/Sem (Out-of-State)\",450,IF(B8=\"9 Hrs/Sem (Out-of-State)\",450,IF(B8=\"8 Hrs/Sem (Out-of-State)\",300,IF(B8=\"7 Hrs/Sem (Out-of-State)\",300,IF(B8=\"6 Hrs/Sem (Out-of-State)\",300,IF(B8=\"Click Here to Select Course Load\",0)))))))))))))))))))))))))))","v":600},1200]
[null,"Your Total Estimated Bill",null,null,{"$f":"SUM(E8:E13)","v":10145},{"$f":"SUM(F8:F13)","v":10145},20290]
[]
[null,"Financial Aid Offer",null,null,"Fall","Spring","Total",null,"This is the financial aid  you will use to help pay your bill"]
[null,"Institutional Scholarship",null,null,{"$f":"G17/2","v":1000},{"$f":"G17/2","v":1000},2000]
[null,"Click Here to Select an Aid Program",null,null,{"$f":"G18/2","v":0},{"$f":"G18/2","v":0},null,"Enter your grants, scholarships, and loans here"]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Click Here to Select an Aid Program",null,null,0,0]
[null,"Your Total Estimated Aid",null,null,{"$f":"SUM(E17:E25)","v":1000},{"$f":"SUM(F17:F25)","v":1000},2000]
[]
[null,null,"Estimated Out-of-Pocket Expenses",null,"Fall","Spring","Total"]
[null,null,null,null,{"$f":"SUM(E14-E26)","v":9145},{"$f":"SUM(F14-F26)","v":9145},18290]

{"sheet":"Data Table","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"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",3225,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",3225,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",3469,null,"Access Missouri Grant",null,null,null,null,""]
[null,"Woods 2-Person",3225,null,"Bright Flight Scholarship",null,null,null,null,""]
[null,"Blair-Shannon 6-Person",3573,null,"Institutional Scholarship",null,null,null,null,""]
[null,"Hammons or Hutchens 2-Person",4493,null,"Foundation Scholarship",null,null,null,null,""]
[null,"Hammons or Hutchens 4-Person",3922,null,"Outside Scholarship",null,null,null,null,""]
[null,"Kentwood 1-Person",4166,null,"Federal Work-Study",null,null,null,null,""]
[null,"Kentwood 2 and 3-Person",3573,null,"Direct Subsidized Loan",null,null,null,null,""]
[null,"Kentwood 2-Person Super Double",4041,null,"Direct Unsubsidized Loan",null,null,null,null,""]
[null,"Scholars",3918,null,"Other",null,null,null,null,""]
[null,"Monroe 1-Person",3620]
[null,"Monroe 2-Person",3513,null,"Click Here to Select Course Load"]
[null,"Monroe 4-Person",3292,null,"18 Hrs/Sem (In-State)",18,{"$f":"SUM(F16*267)","v":4806},564,{"$f":"SUM(G16:H16)","v":5370}]
[null,"Sunvilla 2-Person",3094,null,"17 Hrs/Sem (In-State)",17,4539,564,{"$f":"SUM(G17:H17)","v":5103}]
[null,"Sunvilla 3-Person",2959,null,"16 Hrs/Sem (In-State)",16,4272,564,4836]
[null,"Sunvilla 3-Person - Private",3228,null,"15 Hrs/Sem (In-State)",15,4005,564,{"$f":"SUM(G19:H19)","v":4569}]
[null,"Sunvilla 4-Person",2825,null,"14 Hrs/Sem (In-State)",14,3738,564,4302]
[null,"With Parent(s)",0,null,"13 Hrs/Sem (In-State)",13,3471,564,4035]
[null,null,null,null,"12 Hrs/Sem (In-State)",12,3204,564,3768]
[null,"Click Here to Select a Meal Plan",null,null,"11 Hrs/Sem (In-State)",11,2937,564,3501]
[null,"Unlimited meal/week",1349,null,"10 Hrs/Sem (In-State)",10,2670,564,3234]
[null,"19-Meals/week",1261,null,"9 Hrs/Sem (In-State)",9,2403,564,2967]
[null,"14-Meals/week",1238,null,"8 Hrs/Sem (In-State)",8,2136,564,2700]
[null,"10-Meals/week",1222,null,"7 Hrs/Sem (In-State)",7,1869,564,2433]
[null,null,null,null,"6 Hrs/Sem (In-State)",6,1602,467,2069]
[null,"Click Here to Select a Dining Dollars Plan",null,null,"18 Hrs/Sem (Out-of-State)",18,{"$f":"SUM(F29*572)","v":10296},564,10860]
[null,"Option 1 - $280 (Worth $307)",280,null,"17 Hrs/Sem (Out-of-State)",17,9724,564,10288]
[null,"Option 2 - $215 (Worth $236)",215,null,"16 Hrs/Sem (Out-of-State)",16,9152,564,9716]
[null,"Option 3 - $165 (Worth $181)",165,null,"15 Hrs/Sem (Out-of-State)",15,8580,564,9144]
[null,null,null,null,"14 Hrs/Sem (Out-of-State)",14,8008,564,8572]
[null,"Click Here to Select a Parking Permit",null,null,"13 Hrs/Sem (Out-of-State)",13,7436,564,8000]
[null,"Commuter Parking",66.5,null,"12 Hrs/Sem (Out-of-State)",12,6864,564,7428]
[null,"Residence Hall Parking",109,null,"11 Hrs/Sem (Out-of-State)",11,6292,564,6856]
[null,"Motorcycle Parking",12.5,null,"10 Hrs/Sem (Out-of-State)",10,5720,564,6284]
[null,"Orange Lot Parking",37,null,"9 Hrs/Sem (Out-of-State)",9,5148,564,5712]
[null,null,null,null,"8 Hrs/Sem (Out-of-State)",8,4576,564,5140]
[null,null,null,null,"7 Hrs/Sem (Out-of-State)",7,4004,564,4568]
[null,null,null,null,"6 Hrs/Sem (Out-of-State)",6,3432,467,3899]