{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cost Worksheet","Non-Res Tuition Waiver Calc","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 2025-2026 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)\",6722,IF(A8=\"17 Hrs/Sem (In-State)\",6395,IF(A8=\"16 Hrs/Sem (In-State)\",6068,IF(A8=\"15 Hrs/Sem (In-State)\",5741,IF(A8=\"14 Hrs/Sem (In-State)\",5414,IF(A8=\"13 Hrs/Sem (In-State)\",5087,IF(A8=\"12 Hrs/Sem (In-State)\",4760,IF(A8=\"11 Hrs/Sem (In-State)\",4433,IF(A8=\"10 Hrs/Sem (In-State)\",4106,IF(A8=\"9 Hrs/Sem (In-State)\",3779,IF(A8=\"8 Hrs/Sem (In-State)\",3452,IF(A8=\"7 Hrs/Sem (In-State)\",3125,IF(A8=\"6 Hrs/Sem (In-State)\",2694,IF(A8=\"18 Hrs/Sem (Out-of-State)\",12914,IF(A8=\"17 Hrs/Sem (Out-of-State)\",12243,IF(A8=\"16 Hrs/Sem (Out-of-State)\",11572,IF(A8=\"15 Hrs/Sem (Out-of-State)\",10901,IF(A8=\"14 Hrs/Sem (Out-of-State)\",10230,IF(A8=\"13 Hrs/Sem (Out-of-State)\",9559,IF(A8=\"12 Hrs/Sem (Out-of-State)\",8888,IF(A8=\"11 Hrs/Sem (Out-of-State)\",8217,IF(A8=\"10 Hrs/Sem (Out-of-State)\",7546,IF(A8=\"9 Hrs/Sem (Out-of-State)\",6875,IF(A8=\"8 Hrs/Sem (Out-of-State)\",6204,IF(A8=\"7 Hrs/Sem (Out-of-State)\",5533,IF(A8=\"6 Hrs/Sem (Out-of-State)\",4758,IF(A8=\"\",0))))))))))))))))))))))))))))","v":0},{"$f":"IF(A8=\"Click Here to Select Course Load\",0,IF(A8=\"18 Hrs/Sem (In-State)\",6722,IF(A8=\"17 Hrs/Sem (In-State)\",6395,IF(A8=\"16 Hrs/Sem (In-State)\",6068,IF(A8=\"15 Hrs/Sem (In-State)\",5741,IF(A8=\"14 Hrs/Sem (In-State)\",5414,IF(A8=\"13 Hrs/Sem (In-State)\",5087,IF(A8=\"12 Hrs/Sem (In-State)\",4760,IF(A8=\"11 Hrs/Sem (In-State)\",4433,IF(A8=\"10 Hrs/Sem (In-State)\",4106,IF(A8=\"9 Hrs/Sem (In-State)\",3779,IF(A8=\"8 Hrs/Sem (In-State)\",3452,IF(A8=\"7 Hrs/Sem (In-State)\",3125,IF(A8=\"6 Hrs/Sem (In-State)\",2694,IF(A8=\"18 Hrs/Sem (Out-of-State)\",12914,IF(A8=\"17 Hrs/Sem (Out-of-State)\",12243,IF(A8=\"16 Hrs/Sem (Out-of-State)\",11572,IF(A8=\"15 Hrs/Sem (Out-of-State)\",10901,IF(A8=\"14 Hrs/Sem (Out-of-State)\",10230,IF(A8=\"13 Hrs/Sem (Out-of-State)\",9559,IF(A8=\"12 Hrs/Sem (Out-of-State)\",8888,IF(A8=\"11 Hrs/Sem (Out-of-State)\",8217,IF(A8=\"10 Hrs/Sem (Out-of-State)\",7546,IF(A8=\"9 Hrs/Sem (Out-of-State)\",6875,IF(A8=\"8 Hrs/Sem (Out-of-State)\",6204,IF(A8=\"7 Hrs/Sem (Out-of-State)\",5533,IF(A8=\"6 Hrs/Sem (Out-of-State)\",4758,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\", 3383, IF(A9=\"Wells 2-Person\", 3383, IF(A9=\"Wells 4-Person\", 3640, IF(A9=\"Woods 1-Person\", 4104, IF(A9=\"Woods 2-Person\", 3481, IF(A9=\"Blair-Shannon 6-Person\", 3835, IF(A9=\"Hammons or Hutchens 2-Person\", 4847, IF(A9=\"Hammons or Hutchens 4-Person\", 4229, IF(A9=\"Kentwood 1-Person\", 4495, IF(A9=\"Kentwood 2 and 3-Person\", 3857, IF(A9=\"Kentwood 2-Person Super Double\", 4362, IF(A9=\"Scholars\", 4229, IF(A9=\"Monroe 1-Person\", 3759, IF(A9=\"Monroe 2-Person\", 3648, IF(A9=\"Monroe 4-Person\", 3419, IF(A9=\"Sunvilla 2-Person\", 3214, IF(A9=\"Sunvilla 3-Person\", 3075, IF(A9=\"Sunvilla 3-Person - Private\", 3353, IF(A9=\"Sunvilla 4-Person\", 2926, IF(A9=\"Heitz House\", 3835, IF(A9=\"Off-Campus/With Parent\", 0))))))))))))))))))))))","v":0},{"$f":"IF(A9 = \"Click Here to Select Housing\", 0, IF(A9=\"Freudenberger 2 or 3-Person\", 3383, IF(A9=\"Wells 2-Person\", 3383, IF(A9=\"Wells 4-Person\", 3640, IF(A9=\"Woods 1-Person\", 4104, IF(A9=\"Woods 2-Person\", 3481, IF(A9=\"Blair-Shannon 6-Person\", 3835, IF(A9=\"Hammons or Hutchens 2-Person\", 4847, IF(A9=\"Hammons or Hutchens 4-Person\", 4229, IF(A9=\"Kentwood 1-Person\", 4495, IF(A9=\"Kentwood 2 and 3-Person\", 3857, IF(A9=\"Kentwood 2-Person Super Double\", 4362, IF(A9=\"Scholars\", 4229, IF(A9=\"Monroe 1-Person\", 3759, IF(A9=\"Monroe 2-Person\", 3648, IF(A9=\"Monroe 4-Person\", 3419, IF(A9=\"Sunvilla 2-Person\", 3214, IF(A9=\"Sunvilla 3-Person\", 3075, IF(A9=\"Sunvilla 3-Person - Private\", 3353, IF(A9=\"Sunvilla 4-Person\", 2926, IF(A9=\"Heitz House\", 3835, IF(A9=\"Off-Campus/With Parent\", 0))))))))))))))))))))))","v":0},{"$f":"SUM(D9:E9)","v":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\", 1612, IF(A10 =\"19-Meals/week\", 1506, IF(A10 =\"14-Meals/week\", 1479, IF(A10 =\"10-Meals/week\", 1460, IF(A10 = \"\", 0))))))","v":0},{"$f":"IF(A10 =\"Click Here to Select a Meal Plan\", 0, IF(A10 =\"Unlimited meal/week\", 1612, IF(A10 =\"19-Meals/week\", 1506, IF(A10 =\"14-Meals/week\", 1479, IF(A10 =\"10-Meals/week\", 1460, 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\",100.5,IF(A12=\"Heitz House Parking\",252.5,IF(A12=\"Motorcycle Parking\",14,IF(A12=\"Orange Lot Parking\",33.5,IF(A12=\"No Car\",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\",100.5,IF(A12=\"Heitz House Parking\",252.5,IF(A12=\"Motorcycle Parking\",14,IF(A12=\"Orange Lot Parking\",33.5,IF(A12=\"No Car\",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":"Non-Res Tuition Waiver Calc","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Enrollment","Term Hours","Term OOS Tuition","AYR OOS Tuition","AYR OOS WAIVER VALUE"]
["14 Hrs/Sem (Out-of-State)",{"$f":"IF(A2=\"18 Hrs/Sem (Out-of-State)\",18,IF(A2=\"17 Hrs/Sem (Out-of-State)\",17,IF(A2=\"16 Hrs/Sem (Out-of-State)\",16,IF(A2=\"15 Hrs/Sem (Out-of-State)\",15,IF(A2=\"14 Hrs/Sem (Out-of-State)\",14,IF(A2=\"13 Hrs/Sem (Out-of-State)\",13,IF(A2=\"12 Hrs/Sem (Out-of-State)\",12,IF(A2=\"Click Here to Select Course Load\",0))))))))","v":14},{"$f":"SUM(B2*646)","v":9044},{"$f":"SUM(C2*2)","v":18088},{"$f":"SUM(D2-(302*(B2*2)))","v":9632}]

{"sheet":"Data Table","index":2,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,0,0,10]]}
["WORKSHEET PASSWORD: Boomer"]
[null,"Click Here to Select Housing",null,null,"Click Here to Select an Aid Program",null,"Click Here to Select Course Load","Hrs","Tuition","Term Tuition","Addl Fee","SSF","Term T&F","AYR T&F",null,"Click Here to Select Course Load"]
[null,"Freudenberger 2 or 3-Person",3383,null,"Federal Pell Grant",null,"18 Hrs/Sem (In-State)",18,302,{"$f":"SUM(I3*H3)","v":5436},{"$f":"SUM(H3*25)","v":450},836,{"$f":"SUM(J3:L3)","v":6722},{"$f":"SUM(M3*2)","v":13444},null,"18 Hrs/Sem (Out-of-State)"]
[null,"Wells 2-Person",3383,null,"FSEOG",null,"17 Hrs/Sem (In-State)",17,302,{"$f":"SUM(I4*H4)","v":5134},{"$f":"SUM(H4*25)","v":425},836,{"$f":"SUM(J4:L4)","v":6395},{"$f":"SUM(M4*2)","v":12790},null,"17 Hrs/Sem (Out-of-State)"]
[null,"Wells 4-Person",3640,null,"Access Missouri Grant",null,"16 Hrs/Sem (In-State)",16,302,4832,400,836,6068,12136,null,"16 Hrs/Sem (Out-of-State)"]
[null,"Woods 1-Person",4104,null,"Bright Flight Scholarship",null,"15 Hrs/Sem (In-State)",15,302,4530,375,836,5741,11482,null,"15 Hrs/Sem (Out-of-State)"]
[null,"Woods 2-Person",3481,null,"Presidential Scholarship",null,"14 Hrs/Sem (In-State)",14,302,4228,350,836,5414,10828,null,"14 Hrs/Sem (Out-of-State)"]
[null,"Blair-Shannon 6-Person",3835,null,"Board of Governors Scholarship",null,"13 Hrs/Sem (In-State)",13,302,3926,325,836,5087,10174,null,"13 Hrs/Sem (Out-of-State)"]
[null,"Hammons or Hutchens 2-Person",4847,null,"Provost Scholarship",null,"12 Hrs/Sem (In-State)",12,302,3624,300,836,4760,9520,null,"12 Hrs/Sem (Out-of-State)"]
[null,"Hammons or Hutchens 4-Person",4229,null,"Deans Scholarship",null,"11 Hrs/Sem (In-State)",11,302,3322,275,836,4433,8866,null,"11 Hrs/Sem (Out-of-State)"]
[null,"Kentwood 1-Person",4495,null,"Academic Excellence Scholarship",null,"10 Hrs/Sem (In-State)",10,302,3020,250,836,4106,8212,null,"10 Hrs/Sem (Out-of-State)"]
[null,"Kentwood 2 and 3-Person",3857,null,"Academic Distinction Scholarship",null,"9 Hrs/Sem (In-State)",9,302,2718,225,836,3779,7558,null,"9 Hrs/Sem (Out-of-State)"]
[null,"Kentwood 2-Person Super Double",4362,null,"Academic Achievement Scholarship",null,"8 Hrs/Sem (In-State)",8,302,2416,200,836,3452,6904,null,"8 Hrs/Sem (Out-of-State)"]
[null,"Scholars",4229,null,"Engaged Citizen Award",null,"7 Hrs/Sem (In-State)",7,302,2114,175,836,3125,6250,null,"7 Hrs/Sem (Out-of-State)"]
[null,"Monroe 1-Person",3759,null,"Hutchens/SGA Centennial Leaders",null,"6 Hrs/Sem (In-State)",6,302,1812,150,732,2694,5388,null,"6 Hrs/Sem (Out-of-State)"]
[null,"Monroe 2-Person",3648,null,"A+ Recognition Scholarship",null,"18 Hrs/Sem (Out-of-State)",18,646,11628,450,836,{"$f":"SUM(J16:L16)","v":12914},25828]
[null,"Monroe 4-Person",3419,null,"Other Institutional Scholarship",null,"17 Hrs/Sem (Out-of-State)",17,646,10982,425,836,{"$f":"SUM(J17:L17)","v":12243},24486]
[null,"Sunvilla 2-Person",3214,null,"Non-Resident Tuition Waiver",null,"16 Hrs/Sem (Out-of-State)",16,646,10336,400,836,11572,23144]
[null,"Sunvilla 3-Person",3075,null,"Foundation Scholarship",null,"15 Hrs/Sem (Out-of-State)",15,646,9690,375,836,10901,21802]
[null,"Sunvilla 3-Person - Private",3353,null,"Outside Scholarship",null,"14 Hrs/Sem (Out-of-State)",14,646,9044,350,836,10230,20460]
[null,"Sunvilla 4-Person",2926,null,"Federal Work-Study",null,"13 Hrs/Sem (Out-of-State)",13,646,8398,325,836,9559,19118]
[null,"Heitz House",3835,null,"Direct Subsidized Loan",null,"12 Hrs/Sem (Out-of-State)",12,646,7752,300,836,8888,17776]
[null,"Off-Campus/With Parent",0,null,"Direct Unsubsidized Loan",null,"11 Hrs/Sem (Out-of-State)",11,646,7106,275,836,8217,16434]
[null,null,null,null,"Other",null,"10 Hrs/Sem (Out-of-State)",10,646,6460,250,836,7546,15092]
[null,"Click Here to Select a Meal Plan",null,null,null,null,"9 Hrs/Sem (Out-of-State)",9,646,5814,225,836,6875,13750]
[null,"Unlimited meal/week",1612,null,null,null,"8 Hrs/Sem (Out-of-State)",8,646,5168,200,836,6204,12408]
[null,"19-Meals/week",1506,null,null,null,"7 Hrs/Sem (Out-of-State)",7,646,4522,175,836,5533,11066]
[null,"14-Meals/week",1479,null,null,null,"6 Hrs/Sem (Out-of-State)",6,646,3876,150,732,4758,9516]
[null,"10-Meals/week",1460]
[]
[null,"Click Here to Select a Dining Dollars Plan"]
[null,"Option 1 - $310 (Worth $340)",310]
[null,"Option 2 - $242 (Worth $265)",242]
[null,"Option 3 - $192 (Worth $210)",192]
[]
[null,"Click Here to Select a Parking Permit"]
[null,"Commuter Parking",60.5]
[null,"Residence Hall Parking",100.5]
[null,"Heitz House Parking",252.5]
[null,"Motorcycle Parking",14]
[null,"Orange Lot Parking",33.5]
[null,"No Car",0]