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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use monthly college budget worksheet to track income, expenses, and cash flow."]
[null,"Enter monthly income and expenses to calculate total income and expenses."]
[null,"Cash flow is auto-calculated, and cash flow chart is updated for you."]
[null,"Select slider to get income, expenses, and cash flow charts for a month and year."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in the worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color."]
[null," "]

{"sheet":"Monthly college budget","index":1,"n_rows":72,"n_cols":17,"rows_kept":72}
[null,"Monthly college budget",{"$nulls":14},{"$f":"\"\"","v":""}]
[{"$nulls":16},""]
[{"$nulls":16},""]
[null,{"$f":"chart_calcs!$D$6","v":"january income:"},null,null,{"$f":"chart_calcs!$D$7","v":"january expenses:"},{"$nulls":7},{"$f":"chart_calcs!$D$8","v":"january cash flow:"},{"$nulls":3},""]
[null,{"$f":"\" \"&chart_calcs!$F$6","v":" $1,225"},null,null,{"$f":"\" \"&chart_calcs!$F$7","v":" $1,056"},{"$nulls":7},{"$f":"\" \"&chart_calcs!$F$8","v":" $169"},{"$nulls":3},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[{"$nulls":16},""]
[]
[]
[]
[]
[null,"JAN"]
[{"$nulls":15},{"$f":"SelectedPeriod","v":"JAN "}]
[null,"Monthly Cash After Expense",{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Cash flow",{"$f":"C37-C72","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(C28:N28)","v":{"v":-299,"d":"(299)"}},{"$f":"INDEX($C28:$O28,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0.13795918367346938,"d":"13.8%"}}]
[null,"Cumulative cash flow",{"$f":"SUM($C$28:C$28)","v":{"v":169,"d":"169 "}},{"$f":"SUM($C$28:D$28)","v":{"v":238,"d":"238 "}},{"$f":"SUM($C$28:E$28)","v":{"v":430,"d":"430 "}},{"$f":"SUM($C$28:F$28)","v":{"v":629,"d":"629 "}},{"$f":"SUM($C$28:G$28)","v":{"v":833,"d":"833 "}},{"$f":"SUM($C$28:H$28)","v":{"v":62,"d":"62 "}},{"$f":"SUM($C$28:I$28)","v":{"v":186,"d":"186 "}},{"$f":"SUM($C$28:J$28)","v":{"v":340,"d":"340 "}},{"$f":"SUM($C$28:K$28)","v":{"v":-381,"d":"(381)"}},{"$f":"SUM($C$28:L$28)","v":{"v":-272,"d":"(272)"}},{"$f":"SUM($C$28:M$28)","v":{"v":-238,"d":"(238)"}},{"$f":"SUM($C$28:N$28)","v":{"v":-299,"d":"(299)"}}]
[]
[null,"MONTHLY INCOME",{"$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",0,0,750,750,750,750,750,750,750,750,750,750,{"$f":"SUM(C32:N32)","v":{"v":7500,"d":"7,500 "}},{"$f":"INDEX($C32:$O32,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,"After-tax wages from a job",450,450,450,450,450,450,450,450,550,350,350,350,{"v":5200,"d":"5,200 "},{"$f":"INDEX($C33:$O33,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0.3673469387755102,"d":"36.7%"}}]
[null,"Financial help from family",200,200,{"v":1000,"d":"1,000"},350,350,350,350,350,350,350,350,350,{"v":4550,"d":"4,550 "},{"$f":"INDEX($C34:$O34,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0.16326530612244897,"d":"16.3%"}}]
[null,"Withdrawals from savings",500,350,150,0,0,0,0,0,0,0,0,0,{"v":1000,"d":"1,000 "},{"$f":"INDEX($C35:$O35,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0.40816326530612246,"d":"40.8%"}}]
[null,"Other (child support, public assistance, gifts, etc.)",75,75,75,75,75,75,75,75,75,75,75,75,{"v":900,"d":"900 "},{"$f":"INDEX($C36:$O36,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0.061224489795918366,"d":"6.1%"}}]
[null,"TOTAL INCOME",{"$f":"SUM(C32:C36)","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($C37:$O37,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":1,"d":"100.0%"}}]
[]
[null,"MONTHLY EXPENSE",{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Room & board",{"$f":"SUM(C41:C43)","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(C40:N40)","v":{"v":6780,"d":"6,780 "}},{"$f":"INDEX($C40:$O40,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.5350378787878788,"d":"53.5%"}}]
[null,null,315,315,315,315,315,315,315,315,315,315,315,315,{"$f":"SUM(C41:N41)","v":{"v":3780,"d":"3,780 "}},{"$f":"INDEX($C41:$O41,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.29829545454545453,"d":"29.8%"}}]
[null,null,200,200,200,200,200,200,200,200,200,200,200,200,{"$f":"SUM(C42:N42)","v":{"v":2400,"d":"2,400 "}},{"$f":"INDEX($C42:$O42,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.1893939393939394,"d":"18.9%"}}]
[null,null,50,50,50,50,50,50,50,50,50,50,50,50,{"$f":"SUM(C43:N43)","v":{"v":600,"d":"600 "}},{"$f":"INDEX($C43:$O43,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.04734848484848485,"d":"4.7%"}}]
[]
[null,"Tuition & fees",{"$f":"SUM(C46:C47)","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(C45:N45)","v":{"v":2050,"d":"2,050 "}},{"$f":"INDEX($C45:$O45,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,500,0,0,500,0,0,500,0,0,0,{"$f":"SUM(C46:N46)","v":{"v":1500,"d":"1,500 "}},{"$f":"INDEX($C46:$O46,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,250,0,0,150,0,0,150,0,0,0,{"$f":"SUM(C47:N47)","v":{"v":550,"d":"550 "}},{"$f":"INDEX($C47:$O47,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Books & Supplies",{"$f":"SUM(C50:C51)","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(C49:N49)","v":{"v":1155,"d":"1,155 "}},{"$f":"INDEX($C49:$O49,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,225,0,0,275,0,0,325,0,0,0,{"$f":"SUM(C50:N50)","v":{"v":825,"d":"825 "}},{"$f":"INDEX($C50:$O50,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,100,20,20,50,10,10,75,15,15,15,{"$f":"SUM(C51:N51)","v":{"v":330,"d":"330 "}},{"$f":"INDEX($C51:$O51,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Transportation",{"$f":"SUM(C54:C57)","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(C53:N53)","v":{"v":2473,"d":"2,473 "}},{"$f":"INDEX($C53:$O53,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.21212121212121213,"d":"21.2%"}}]
[null,null,30,30,30,75,30,30,30,75,30,30,30,75,{"$f":"SUM(C54:N54)","v":{"v":495,"d":"495 "}},{"$f":"INDEX($C54:$O54,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.028409090909090908,"d":"2.8%"}}]
[null,null,129,129,129,129,129,129,129,129,129,129,129,129,{"$f":"SUM(C55:N55)","v":{"v":1548,"d":"1,548 "}},{"$f":"INDEX($C55:$O55,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.12215909090909091,"d":"12.2%"}}]
[null,null,15,15,15,15,15,15,15,15,15,15,15,15,{"$f":"SUM(C56:N56)","v":{"v":180,"d":"180 "}},{"$f":"INDEX($C56:$O56,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.014204545454545454,"d":"1.4%"}}]
[null,null,50,0,0,0,0,0,100,0,0,0,50,50,{"$f":"SUM(C57:N57)","v":{"v":250,"d":"250 "}},{"$f":"INDEX($C57:$O57,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.04734848484848485,"d":"4.7%"}}]
[]
[null,"Discretionary",{"$f":"SUM(C60:C65)","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(C59:N59)","v":{"v":4053,"d":"4,053 "}},{"$f":"INDEX($C59:$O59,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.06534090909090909,"d":"6.5%"}}]
[null,null,0,0,0,50,100,100,100,100,75,75,100,100,{"v":800,"d":"800 "},{"$f":"INDEX($C60:$O60,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,69,69,69,69,69,69,69,69,69,69,69,69,{"v":828,"d":"828 "},{"$f":"INDEX($C61:$O61,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.06534090909090909,"d":"6.5%"}}]
[null,null,0,0,0,0,0,25,0,0,0,0,0,50,{"v":75,"d":"75 "},{"$f":"INDEX($C62:$O62,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,100,100,100,100,100,100,100,100,100,100,{"v":1000,"d":"1,000 "},{"$f":"INDEX($C63:$O63,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,0,50,50,50,50,50,50,50,50,50,{"v":450,"d":"450 "},{"$f":"INDEX($C64:$O64,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,0,100,100,100,100,100,100,100,100,100,{"v":900,"d":"900 "},{"$f":"INDEX($C65:$O65,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"Other expenses",{"$f":"SUM(C68:C70)","v":{"v":198,"d":"198 "}},{"$f":"SUM(D68:D70)","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(C67:N67)","v":{"v":2938,"d":"2,938 "}},{"$f":"INDEX($C67:$O67,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.1875,"d":"18.8%"}}]
[null,null,123,123,123,123,123,123,123,123,123,123,123,123,{"$f":"SUM(C68:N68)","v":{"v":1476,"d":"1,476 "}},{"$f":"INDEX($C68:$O68,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.11647727272727272,"d":"11.6%"}}]
[null,null,0,0,52,55,45,40,35,60,65,70,70,70,{"$f":"SUM(C69:N69)","v":{"v":562,"d":"562 "}},{"$f":"INDEX($C69:$O69,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[null,null,75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(C70:N70)","v":{"v":900,"d":"900 "}},{"$f":"INDEX($C70:$O70,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.07102272727272728,"d":"7.1%"}}]
[]
[null,"TOTAL EXPENSES",{"$f":"SUM(C40,C45,C49,C53,C59,C67)","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(C72:N72)","v":{"v":19449,"d":"19,449 "}},{"$f":"INDEX($C72:$O72,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":1,"d":"100.0%"}}]

{"sheet":"chart_calcs","index":2,"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":"january"}]
[]
[{"$nulls":3},"Dynamic Chart Titles"]
[{"$nulls":3},{"$f":"D3&\" income:\"","v":"january income:"},null,{"$f":"TEXT(INDEX('Monthly college budget'!$C$37:$O$37,,SelectedPeriodColumn),\"$#,###\")","v":"$1,225"}]
[{"$nulls":3},{"$f":"D3&\" expenses:\"","v":"january expenses:"},null,{"$f":"TEXT(INDEX('Monthly college budget'!$C$72:$O$72,,SelectedPeriodColumn),\"$#,###\")","v":"$1,056"}]
[{"$nulls":3},{"$f":"D3&\" cash flow:\"","v":"january cash flow:"},{"$f":"INDEX('Monthly college budget'!C28:O28,ScrollBarValue)","v":169},{"$f":"TEXT(E8,\"$#,###\")","v":"$169"}]
[]
[]
[]
[{"$nulls":3},{"$f":"LOWER('Monthly college budget'!C27)","v":"jan "},{"$f":"LOWER('Monthly college budget'!D27)","v":"feb "},{"$f":"LOWER('Monthly college budget'!E27)","v":"mar "},{"$f":"LOWER('Monthly college budget'!F27)","v":"apr "},{"$f":"LOWER('Monthly college budget'!G27)","v":"may "},{"$f":"LOWER('Monthly college budget'!H27)","v":"jun "},{"$f":"LOWER('Monthly college budget'!I27)","v":"jul "},{"$f":"LOWER('Monthly college budget'!J27)","v":"aug "},{"$f":"LOWER('Monthly college budget'!K27)","v":"sep "},{"$f":"LOWER('Monthly college budget'!L27)","v":"oct "},{"$f":"LOWER('Monthly college budget'!M27)","v":"nov "},{"$f":"LOWER('Monthly college budget'!N27)","v":"dec "},{"$f":"LOWER('Monthly college budget'!O27)","v":"year  "}]
[null,null,"Scroll Bar Value: ",1]
[null,null,"Cash Flow Chart: ",{"$f":"IF(SelectedPeriod='Monthly college budget'!C$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":69},{"$f":"IF(SelectedPeriod='Monthly college budget'!D$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!E$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!F$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!G$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!H$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!I$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!J$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!K$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!L$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!M$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!N$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!O$31,IF('Monthly college budget'!$C$28:$O$28>=0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,"Cumulative: ",{"$f":"IF(SelectedPeriod='Monthly college budget'!C$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!D$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!E$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!F$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!G$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!H$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!I$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!J$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!K$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!L$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!M$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!N$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly college budget'!O$31,IF('Monthly college budget'!$C$28:$O$28<0,'Monthly college budget'!$C$28:$O$28,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'!P32","v":{"v":0,"d":"0.0%"}}]
[null,null,"After tax wages from a job",{"$f":"'Monthly college budget'!P33","v":{"v":0.3673469387755102,"d":"36.7%"}}]
[null,null,"Financial help from family",{"$f":"'Monthly college budget'!P34","v":{"v":0.16326530612244897,"d":"16.3%"}}]
[null,null,"Withdrawals from savings",{"$f":"'Monthly college budget'!P35","v":{"v":0.40816326530612246,"d":"40.8%"}}]
[null,null,"Other (child support, public assistance, gifts, etc.)",{"$f":"'Monthly college budget'!P36","v":{"v":0.061224489795918366,"d":"6.1%"}}]