{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Monthly College Budget","chart_calcs"],"not_rendered":{"charts":4,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"Monthly College Budget","index":0,"n_rows":73,"n_cols":17,"rows_kept":73}
[null,"Monthly"]
[{"$f":"\"\"","v":""},"College Budget"]
[""]
[""]
["",{"$f":"chart_calcs!$D$6","v":"march income:"},{"$nulls":3},{"$f":"chart_calcs!$D$7","v":"march expenses:"},{"$nulls":7},{"$f":"chart_calcs!$D$8","v":"march cash flow:"}]
["",{"$f":"\" \"&chart_calcs!$F$6","v":" $2,425"},{"$nulls":3},{"$f":"\" \"&chart_calcs!$F$7","v":" $2,233"},{"$nulls":7},{"$f":"\" \"&chart_calcs!$F$8","v":" $192"}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[]
[]
[]
[]
[null,"JAN"," Select First Budget Month"]
[{"$nulls":16},{"$f":"SelectedPeriod","v":"MAR "}]
[null,"Monthly Cash After Expense",null,{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Cash Flow",null,{"$f":"D38-D73","v":{"v":169,"d":"169 "}},{"v":69,"d":"69 "},{"v":192,"d":"192 "},{"v":199,"d":"199 "},{"v":204,"d":"204 "},{"v":-771,"d":"(771)"},{"v":124,"d":"124 "},{"v":154,"d":"154 "},{"v":-721,"d":"(721)"},{"v":109,"d":"109 "},{"v":34,"d":"34 "},{"v":-61,"d":"(61)"},{"$f":"SUM(D29:O29)","v":{"v":-299,"d":"(299)"}},{"$f":"INDEX($D29:$P29,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.07917525773195876,"d":"7.9%"}}]
[null,"Cumulative Cash Flow",null,{"$f":"SUM($D$29:D$29)","v":{"v":169,"d":"169 "}},{"$f":"SUM($D$29:E$29)","v":{"v":238,"d":"238 "}},{"$f":"SUM($D$29:F$29)","v":{"v":430,"d":"430 "}},{"$f":"SUM($D$29:G$29)","v":{"v":629,"d":"629 "}},{"$f":"SUM($D$29:H$29)","v":{"v":833,"d":"833 "}},{"$f":"SUM($D$29:I$29)","v":{"v":62,"d":"62 "}},{"$f":"SUM($D$29:J$29)","v":{"v":186,"d":"186 "}},{"$f":"SUM($D$29:K$29)","v":{"v":340,"d":"340 "}},{"$f":"SUM($D$29:L$29)","v":{"v":-381,"d":"(381)"}},{"$f":"SUM($D$29:M$29)","v":{"v":-272,"d":"(272)"}},{"$f":"SUM($D$29:N$29)","v":{"v":-238,"d":"(238)"}},{"$f":"SUM($D$29:O$29)","v":{"v":-299,"d":"(299)"}}]
[]
[null,"MONTHLY INCOME",null,{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Financial aid (grants, scholarships, loans) paid to you",null,0,0,750,750,750,750,750,750,750,750,750,750,{"$f":"SUM(D33:O33)","v":{"v":7500,"d":"7,500 "}},{"$f":"INDEX($D33:$P33,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.30927835051546393,"d":"30.9%"}}]
[null,"After-tax wages from a job",null,450,450,450,450,450,450,450,450,550,350,350,350,{"v":5200,"d":"5,200 "},{"$f":"INDEX($D34:$P34,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.18556701030927836,"d":"18.6%"}}]
[null,"Financial help from family",null,200,200,{"v":1000,"d":"1,000"},350,350,350,350,350,350,350,350,350,{"v":4550,"d":"4,550 "},{"$f":"INDEX($D35:$P35,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.41237113402061853,"d":"41.2%"}}]
[null,"Withdrawals from savings",null,500,350,150,0,0,0,0,0,0,0,0,0,{"v":1000,"d":"1,000 "},{"$f":"INDEX($D36:$P36,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.061855670103092786,"d":"6.2%"}}]
[null,"Other (child support, public assistance, gifts, etc.)",null,75,75,75,75,75,75,75,75,75,75,75,75,{"v":900,"d":"900 "},{"$f":"INDEX($D37:$P37,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":0.030927835051546393,"d":"3.1%"}}]
[null,"TOTAL INCOME",null,{"$f":"SUM(D33:D37)","v":{"v":1225,"d":"1,225 "}},{"v":1075,"d":"1,075 "},{"v":2425,"d":"2,425 "},{"v":1625,"d":"1,625 "},{"v":1625,"d":"1,625 "},{"v":1625,"d":"1,625 "},{"v":1625,"d":"1,625 "},{"v":1625,"d":"1,625 "},{"v":1725,"d":"1,725 "},{"v":1525,"d":"1,525 "},{"v":1525,"d":"1,525 "},{"v":1525,"d":"1,525 "},{"v":19150,"d":"19,150 "},{"$f":"INDEX($D38:$P38,,SelectedPeriodColumn)/INDEX($D$38:$P$38,,SelectedPeriodColumn)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"MONTHLY EXPENSE",null,{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Room & Board",null,{"$f":"SUM(D42:D44)","v":{"v":565,"d":"565 "}},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"v":565,"d":"565 "},{"$f":"SUM(D41:O41)","v":{"v":6780,"d":"6,780 "}},{"$f":"INDEX($D41:$P41,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.2530228392297358,"d":"25.3%"}}]
[null,null,"Rent, mortgage, or dorm room",315,315,315,315,315,315,315,315,315,315,315,315,{"$f":"SUM(D42:O42)","v":{"v":3780,"d":"3,780 "}},{"$f":"INDEX($D42:$P42,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.14106583072100312,"d":"14.1%"}}]
[null,null,"Food (groceries or meal plan)",200,200,200,200,200,200,200,200,200,200,200,200,{"$f":"SUM(D43:O43)","v":{"v":2400,"d":"2,400 "}},{"$f":"INDEX($D43:$P43,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.08956560680698612,"d":"9.0%"}}]
[null,null,"Utilities (heat, water, electricity)",50,50,50,50,50,50,50,50,50,50,50,50,{"$f":"SUM(D44:O44)","v":{"v":600,"d":"600 "}},{"$f":"INDEX($D44:$P44,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.02239140170174653,"d":"2.2%"}}]
[]
[null,"Tuition & Fees",null,{"$f":"SUM(D47:D48)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":750,"d":"750 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":650,"d":"650 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":650,"d":"650 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D46:O46)","v":{"v":2050,"d":"2,050 "}},{"$f":"INDEX($D46:$P46,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.33587102552619796,"d":"33.6%"}}]
[null,null,"Tuition you pay",0,0,500,0,0,500,0,0,500,0,0,0,{"$f":"SUM(D47:O47)","v":{"v":1500,"d":"1,500 "}},{"$f":"INDEX($D47:$P47,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.2239140170174653,"d":"22.4%"}}]
[null,null,"Fees you pay",0,0,250,0,0,150,0,0,150,0,0,0,{"$f":"SUM(D48:O48)","v":{"v":550,"d":"550 "}},{"$f":"INDEX($D48:$P48,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.11195700850873265,"d":"11.2%"}}]
[]
[null,"Books & Supplies",null,{"$f":"SUM(D51:D52)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":325,"d":"325 "},{"v":20,"d":"20 "},{"v":20,"d":"20 "},{"v":325,"d":"325 "},{"v":10,"d":"10 "},{"v":10,"d":"10 "},{"v":400,"d":"400 "},{"v":15,"d":"15 "},{"v":15,"d":"15 "},{"v":15,"d":"15 "},{"$f":"SUM(D50:O50)","v":{"v":1155,"d":"1,155 "}},{"$f":"INDEX($D50:$P50,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.14554411106135243,"d":"14.6%"}}]
[null,null,"Textbooks",0,0,225,0,0,275,0,0,325,0,0,0,{"$f":"SUM(D51:O51)","v":{"v":825,"d":"825 "}},{"$f":"INDEX($D51:$P51,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.10076130765785939,"d":"10.1%"}}]
[null,null,"School supplies",0,0,100,20,20,50,10,10,75,15,15,15,{"$f":"SUM(D52:O52)","v":{"v":330,"d":"330 "}},{"$f":"INDEX($D52:$P52,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.04478280340349306,"d":"4.5%"}}]
[]
[null,"Transportation",null,{"$f":"SUM(D55:D58)","v":{"v":224,"d":"224 "}},{"v":174,"d":"174 "},{"v":174,"d":"174 "},{"v":219,"d":"219 "},{"v":174,"d":"174 "},{"v":174,"d":"174 "},{"v":274,"d":"274 "},{"v":219,"d":"219 "},{"v":174,"d":"174 "},{"v":174,"d":"174 "},{"v":224,"d":"224 "},{"v":269,"d":"269 "},{"$f":"SUM(D54:O54)","v":{"v":2473,"d":"2,473 "}},{"$f":"INDEX($D54:$P54,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.07792207792207792,"d":"7.8%"}}]
[null,null,"Gas, maintenance",30,30,30,75,30,30,30,75,30,30,30,75,{"$f":"SUM(D55:O55)","v":{"v":495,"d":"495 "}},{"$f":"INDEX($D55:$P55,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.013434841021047918,"d":"1.3%"}}]
[null,null,"Vehicle payment",129,129,129,129,129,129,129,129,129,129,129,129,{"$f":"SUM(D56:O56)","v":{"v":1548,"d":"1,548 "}},{"$f":"INDEX($D56:$P56,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.057769816390506046,"d":"5.8%"}}]
[null,null,"Transit fares",15,15,15,15,15,15,15,15,15,15,15,15,{"$f":"SUM(D57:O57)","v":{"v":180,"d":"180 "}},{"$f":"INDEX($D57:$P57,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":6.717420510523959E-3,"d":"0.7%"}}]
[null,null,"Travel at holidays",50,0,0,0,0,0,100,0,0,0,50,50,{"$f":"SUM(D58:O58)","v":{"v":250,"d":"250 "}},{"$f":"INDEX($D58:$P58,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Discretionary",null,{"$f":"SUM(D61:D66)","v":{"v":69,"d":"69 "}},{"v":69,"d":"69 "},{"v":169,"d":"169 "},{"v":369,"d":"369 "},{"v":419,"d":"419 "},{"v":444,"d":"444 "},{"v":419,"d":"419 "},{"v":419,"d":"419 "},{"v":394,"d":"394 "},{"v":394,"d":"394 "},{"v":419,"d":"419 "},{"v":469,"d":"469 "},{"$f":"SUM(D60:O60)","v":{"v":4053,"d":"4,053 "}},{"$f":"INDEX($D60:$P60,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.07568293775190327,"d":"7.6%"}}]
[null,null,"Savings",0,0,0,50,100,100,100,100,75,75,100,100,{"v":800,"d":"800 "},{"$f":"INDEX($D61:$P61,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Cell phone, Internet, cable",69,69,69,69,69,69,69,69,69,69,69,69,{"v":828,"d":"828 "},{"$f":"INDEX($D62:$P62,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.03090013434841021,"d":"3.1%"}}]
[null,null,"Donations",0,0,0,0,0,25,0,0,0,0,0,50,{"v":75,"d":"75 "},{"$f":"INDEX($D63:$P63,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Snacks, dining out",0,0,100,100,100,100,100,100,100,100,100,100,{"v":1000,"d":"1,000 "},{"$f":"INDEX($D64:$P64,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.04478280340349306,"d":"4.5%"}}]
[null,null,"Clothes",0,0,0,50,50,50,50,50,50,50,50,50,{"v":450,"d":"450 "},{"$f":"INDEX($D65:$P65,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,"Entertainment (movies, dates, concerts)",0,0,0,100,100,100,100,100,100,100,100,100,{"v":900,"d":"900 "},{"$f":"INDEX($D66:$P66,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Other Expenses",null,{"$f":"SUM(D69:D71)","v":{"v":198,"d":"198 "}},{"$f":"SUM(E69:E71)","v":{"v":198,"d":"198 "}},{"v":250,"d":"250 "},{"v":253,"d":"253 "},{"v":243,"d":"243 "},{"v":238,"d":"238 "},{"v":233,"d":"233 "},{"v":258,"d":"258 "},{"v":263,"d":"263 "},{"v":268,"d":"268 "},{"v":268,"d":"268 "},{"v":268,"d":"268 "},{"$f":"SUM(D68:O68)","v":{"v":2938,"d":"2,938 "}},{"$f":"INDEX($D68:$P68,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.11195700850873265,"d":"11.2%"}}]
[null,null,"Insurance (car, health, renter's)",123,123,123,123,123,123,123,123,123,123,123,123,{"$f":"SUM(D69:O69)","v":{"v":1476,"d":"1,476 "}},{"$f":"INDEX($D69:$P69,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.05508284818629646,"d":"5.5%"}}]
[null,null,"Loan, credit card payment",0,0,52,55,45,40,35,60,65,70,70,70,{"$f":"SUM(D70:O70)","v":{"v":562,"d":"562 "}},{"$f":"INDEX($D70:$P70,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.02328705776981639,"d":"2.3%"}}]
[null,null,"Other",75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(D71:O71)","v":{"v":900,"d":"900 "}},{"$f":"INDEX($D71:$P71,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":0.03358710255261979,"d":"3.4%"}}]
[]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D41,D46,D50,D54,D60,D68)","v":{"v":1056,"d":"1,056 "}},{"v":1006,"d":"1,006 "},{"v":2233,"d":"2,233 "},{"v":1426,"d":"1,426 "},{"v":1421,"d":"1,421 "},{"v":2396,"d":"2,396 "},{"v":1501,"d":"1,501 "},{"v":1471,"d":"1,471 "},{"v":2446,"d":"2,446 "},{"v":1416,"d":"1,416 "},{"v":1491,"d":"1,491 "},{"v":1586,"d":"1,586 "},{"$f":"SUM(D73:O73)","v":{"v":19449,"d":"19,449 "}},{"$f":"INDEX($D73:$P73,,SelectedPeriodColumn)/INDEX($D$73:$P$73,,SelectedPeriodColumn)","v":{"v":1,"d":"100.0%"}}]

{"sheet":"chart_calcs","index":1,"n_rows":23,"n_cols":16,"rows_kept":23,"hidden":true}
["***This sheet should remain HIDDEN***"]
[]
[{"$nulls":3},{"$f":"IFERROR(LOWER(TEXT(VALUE(SelectedPeriod&\" 1\"),\"mmmm\")),\"year\")","v":"march"}]
[]
[{"$nulls":3},"Dynamic Chart Titles"]
[{"$nulls":3},{"$f":"D3&\" income:\"","v":"march income:"},null,{"$f":"TEXT(INDEX('Monthly College Budget'!$D$38:$P$38,,SelectedPeriodColumn),\"$#,###\")","v":"$2,425"}]
[{"$nulls":3},{"$f":"D3&\" expenses:\"","v":"march expenses:"},null,{"$f":"TEXT(INDEX('Monthly College Budget'!$D$73:$P$73,,SelectedPeriodColumn),\"$#,###\")","v":"$2,233"}]
[{"$nulls":3},{"$f":"D3&\" cash flow:\"","v":"march cash flow:"},{"$f":"INDEX('Monthly College Budget'!D29:P29,ScrollBarValue)","v":192},{"$f":"TEXT(E8,\"$#,###\")","v":"$192"}]
[]
[]
[]
[{"$nulls":3},{"$f":"LOWER('Monthly College Budget'!D28)","v":"jan "},{"$f":"LOWER('Monthly College Budget'!E28)","v":"feb "},{"$f":"LOWER('Monthly College Budget'!F28)","v":"mar "},{"$f":"LOWER('Monthly College Budget'!G28)","v":"apr "},{"$f":"LOWER('Monthly College Budget'!H28)","v":"may "},{"$f":"LOWER('Monthly College Budget'!I28)","v":"jun "},{"$f":"LOWER('Monthly College Budget'!J28)","v":"jul "},{"$f":"LOWER('Monthly College Budget'!K28)","v":"aug "},{"$f":"LOWER('Monthly College Budget'!L28)","v":"sep "},{"$f":"LOWER('Monthly College Budget'!M28)","v":"oct "},{"$f":"LOWER('Monthly College Budget'!N28)","v":"nov "},{"$f":"LOWER('Monthly College Budget'!O28)","v":"dec "},{"$f":"LOWER('Monthly College Budget'!P28)","v":"year  "}]
[null,null,"Scroll Bar Value: ",3]
[null,null,"Cash Flow Chart: ",{"$f":"IF(SelectedPeriod='Monthly College Budget'!D$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!E$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!F$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":192},{"$f":"IF(SelectedPeriod='Monthly College Budget'!G$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!H$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!I$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!J$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!K$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!L$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!M$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!N$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!O$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!P$32,IF('Monthly College Budget'!$D$29:$P$29>=0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,"Cumulative: ",{"$f":"IF(SelectedPeriod='Monthly College Budget'!D$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!E$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!F$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!G$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!H$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!I$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!J$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!K$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!L$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!M$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!N$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!O$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly College Budget'!P$32,IF('Monthly College Budget'!$D$29:$P$29<0,'Monthly College Budget'!$D$29:$P$29,NA()),NA())","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"INCOME CHART DATA"]
[null,null,"Financial aid (grants, scholarships, loans) paid to you",{"$f":"'Monthly College Budget'!Q33","v":{"v":0.30927835051546393,"d":"30.9%"}}]
[null,null,"After tax wages from a job",{"$f":"'Monthly College Budget'!Q34","v":{"v":0.18556701030927836,"d":"18.6%"}}]
[null,null,"Financial help from family",{"$f":"'Monthly College Budget'!Q35","v":{"v":0.41237113402061853,"d":"41.2%"}}]
[null,null,"Withdrawals from savings",{"$f":"'Monthly College Budget'!Q36","v":{"v":0.061855670103092786,"d":"6.2%"}}]
[null,null,"Other (child support, public assistance, gifts, etc.)",{"$f":"'Monthly College Budget'!Q37","v":{"v":0.030927835051546393,"d":"3.1%"}}]