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

{"sheet":"Start","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use Monthly university 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 colour."]

{"sheet":"Monthly university budget","index":1,"n_rows":72,"n_cols":16,"rows_kept":72,"merged":[[5,1,14,3],[5,4,14,11],[5,12,13,15],[15,1,19,15],[20,1,21,15]]}
["Create Monthly university budget in this worksheet. Title of this worksheet is in cell to the right and cell B1. Helpful instructions on how to use this worksheet are in the cells in this column. Next instruction is in cell A4.","Monthly university budget"]
[]
[]
["Income label is in cell to the right, Expenses label in cell E4 and Cash flow label in M4.",{"$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:"}]
["Income is auto-updated in cell to the right, Expenses in cell E5 and Cash flow in M5.",{"$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"}]
["Doughnut chart showing income summary in cell to the right, expenses summary in cell E6, and bar chart showing positive and negative cash flow in cell M6 are auto-updated. Next instruction is in cell A17.","Doughnut chart showing income summary for selected month or year is in this cell.",null,null,"Doughnut chart showing expenses summary for selected month or year is in this cell.",{"$nulls":7},"Bar chart showing positive and negative cash flow for selected month or year is in this cell."]
{"$rows_empty":9}
[null,"Line chart showing cash flow for the selected month or year is in this cell."]
["Cash flow line chart is in cell to the right. Next instruction is in cell A21."]
[]
[]
[]
["Select slider to the right to get monthly or annual Income, Expenses and Cash flow data and charts. Next instruction is in cell A25.","Slider is in this cell."]
[]
[]
[]
["Select Month in cell to the right. Press ALT+DOWN ARROW for options, then DOWN ARROW and ENTER to make selection.","JAN"]
["Selected period is auto-updated in cell P26.",{"$nulls":14},{"$f":"SelectedPeriod","v":"JAN "}]
["Labels are in this row, Monthly cash after expense label in cell to the right, months in cells C27 to N27, Year in O27 and percentage increase in P27.","Monthly cash after expense",{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
["Cash flow label is in cell to the right. Cash flow for each month is auto-calculated in cells C28 to N28, Annual amount in O28 and percentage increase in P28. Sparkline is auto-updated in Q29.","Cash flow",{"$f":"C37-C72","v":169},69,192,199,204,{"v":-771,"d":"-771 "},124,154,{"v":-721,"d":"-721 "},109,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%"}}]
["Cumulative cash flow label is in cell to the right. Cumulative cash flow for each month is auto-calculated in cells C29 to N29, Annual amount in O29 and percentage increase in P29. Sparkline is auto-updated Q29. Next instruction is in cell A31.","Cumulative cash flow",{"$f":"SUM($C$28:C$28)","v":169},{"$f":"SUM($C$28:D$28)","v":238},{"$f":"SUM($C$28:E$28)","v":430},{"$f":"SUM($C$28:F$28)","v":629},{"$f":"SUM($C$28:G$28)","v":833},{"$f":"SUM($C$28:H$28)","v":62},{"$f":"SUM($C$28:I$28)","v":186},{"$f":"SUM($C$28:J$28)","v":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 "}}]
[]
["Monthly income label is in cell to the right, months in cells C31 to N31, Year in O31 and percentage increase label in P31. Enter Monthly income items in cells B32 to B36 and monthly amounts in cells C32 to N36. Annual income is auto-calculated in cells O32 to O36 and percentage increase in cells P32 to P36. Next instruction is in cell A37.","MONTHLY INCOME",{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
[null,"Student loan (plus any grants or scholarships) 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,900,{"$f":"INDEX($C36:$O36,,SelectedPeriodColumn)/INDEX($C$37:$O$37,,SelectedPeriodColumn)","v":{"v":0.061224489795918366,"d":"6.1%"}}]
["Total income label is in cell to the right. Total income for each month is auto-calculated in cells C37 to N37, Annual income in O37 and percentage increase in P37. Sparkline is auto-updated in Q37. Next instruction is in cell A39.","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%"}}]
[]
["Monthly expense label is in cell to the right, months in cells C39 to N39, Year in O39 and percentage increase label in P39.","MONTHLY EXPENSE",{"$f":"FirstMonth","v":"JAN "},{"$f":"NextMonth","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","YEAR  ","% INC "]
["Enter or modify expense item in cell to the right, and monthly amounts in cells C40 to N43. Annual amount is auto-calculated in cells O40 to O43 and percentage increase in cells P40 to P43. Sparkline is auto-updated in Q40. Next instruction is in cell A45.","Room & board",{"$f":"SUM(C41:C43)","v":565},565,565,565,565,565,565,565,565,565,565,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":600},{"$f":"INDEX($C43:$O43,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.04734848484848485,"d":"4.7%"}}]
[]
["Enter or modify expense item in cell to the right, and monthly amounts in cells C45 to N47. Annual amount is auto-calculated in cells O45 to O47 and percentage increase in cells P45 to P47. Sparkline is auto-updated in Q45. The next instruction is in cell A49.","Tuition & fees",{"$f":"SUM(C46:C47)","v":0},0,750,0,0,650,0,0,650,0,0,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":550},{"$f":"INDEX($C47:$O47,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
["Enter or modify expense item in cell to the right, and monthly amounts in cells C49 to N51. Annual amount is auto-calculated in cells O49 to O51 and percentage increase in cells P49 to P51. Sparkline is auto-updated in Q49. Next instruction is in cell A53.","Books & supplies",{"$f":"SUM(C50:C51)","v":0},0,325,20,20,325,10,10,400,15,15,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":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":330},{"$f":"INDEX($C51:$O51,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
["Enter or modify expense item in cell to the right, and monthly amounts in cells C53 to N57. Annual amount is auto-calculated in cells O53 to O57 and percentage increase in cells P53 to P57. Sparkline is auto-updated in Q53. Next instruction is in cell A59.","Transport",{"$f":"SUM(C54:C57)","v":224},174,174,219,174,174,274,219,174,174,224,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":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":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":250},{"$f":"INDEX($C57:$O57,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.04734848484848485,"d":"4.7%"}}]
[]
["Enter or modify expense item in cell to the right, and monthly amounts in cells C59 to N65. Annual amount is auto-calculated in cells O59 to O65 and percentage increase in cells P59 to P65. Sparkline is auto-updated in Q59. Next instruction is in cell A67.","Discretionary",{"$f":"SUM(C60:C65)","v":69},69,169,369,419,444,419,419,394,394,419,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,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,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,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,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,900,{"$f":"INDEX($C65:$O65,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0,"d":"0.0%"}}]
[]
["Enter or modify expense item in cell to the right, and monthly amounts in cells C67 to N70. Annual amount is auto-calculated in cells O67 to O70 and percentage increase in cells P67 to P70. Sparkline is auto-updated in Q67. Next instruction is in cell A72.","Other expenses",{"$f":"SUM(C68:C70)","v":198},{"$f":"SUM(D68:D70)","v":198},250,253,243,238,233,258,263,268,268,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":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":900},{"$f":"INDEX($C70:$O70,,SelectedPeriodColumn)/INDEX($C$72:$O$72,,SelectedPeriodColumn)","v":{"v":0.07102272727272728,"d":"7.1%"}}]
[]
["Total expenses label is in cell to the right. Total expenses for each month is auto-calculated in cells C72 to N72, Annual expenses in O72 and percentage increase in P72. Sparkline is auto-updated in Q72.","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 university budget'!$C$37:$O$37,,SelectedPeriodColumn),\"£#,###\")","v":"£1,225"}]
[{"$nulls":3},{"$f":"D3&\" expenses:\"","v":"january expenses:"},null,{"$f":"TEXT(INDEX('Monthly university budget'!$C$72:$O$72,,SelectedPeriodColumn),\"£#,###\")","v":"£1,056"}]
[{"$nulls":3},{"$f":"D3&\" cash flow:\"","v":"january cash flow:"},{"$f":"INDEX('Monthly university budget'!C28:O28,ScrollBarValue)","v":169},{"$f":"TEXT(E8,\"£#,###\")","v":"£169"}]
[]
[]
[]
[{"$nulls":3},{"$f":"LOWER('Monthly university budget'!C27)","v":"jan "},{"$f":"LOWER('Monthly university budget'!D27)","v":"feb "},{"$f":"LOWER('Monthly university budget'!E27)","v":"mar "},{"$f":"LOWER('Monthly university budget'!F27)","v":"apr "},{"$f":"LOWER('Monthly university budget'!G27)","v":"may "},{"$f":"LOWER('Monthly university budget'!H27)","v":"jun "},{"$f":"LOWER('Monthly university budget'!I27)","v":"jul "},{"$f":"LOWER('Monthly university budget'!J27)","v":"aug "},{"$f":"LOWER('Monthly university budget'!K27)","v":"sep "},{"$f":"LOWER('Monthly university budget'!L27)","v":"oct "},{"$f":"LOWER('Monthly university budget'!M27)","v":"nov "},{"$f":"LOWER('Monthly university budget'!N27)","v":"dec "},{"$f":"LOWER('Monthly university budget'!O27)","v":"year  "}]
[null,null,"Scroll bar value: ",1]
[null,null,"Cash flow chart: ",{"$f":"IF(SelectedPeriod='Monthly university budget'!C$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":69},{"$f":"IF(SelectedPeriod='Monthly university budget'!D$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!E$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!F$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!G$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!H$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!I$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!J$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!K$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!L$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!M$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!N$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!O$31,IF('Monthly university budget'!$C$28:$O$28>=0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,"Cumulative: ",{"$f":"IF(SelectedPeriod='Monthly university budget'!C$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!D$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!E$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!F$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!G$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!H$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!I$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!J$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!K$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!L$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!M$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!N$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(SelectedPeriod='Monthly university budget'!O$31,IF('Monthly university budget'!$C$28:$O$28<0,'Monthly university budget'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"INCOME CHART DATA"]
[null,null,"Student loan (plus any grants or scholarships) paid to you",{"$f":"'Monthly university budget'!P32","v":{"v":0,"d":"0.0%"}}]
[null,null,"After-tax wages from a job",{"$f":"'Monthly university budget'!P33","v":{"v":0.3673469387755102,"d":"36.7%"}}]
[null,null,"Financial help from family",{"$f":"'Monthly university budget'!P34","v":{"v":0.16326530612244897,"d":"16.3%"}}]
[null,null,"Withdrawals from savings",{"$f":"'Monthly university budget'!P35","v":{"v":0.40816326530612246,"d":"40.8%"}}]
[null,null,"Other (child support, public assistance, gifts etc.)",{"$f":"'Monthly university budget'!P36","v":{"v":0.061224489795918366,"d":"6.1%"}}]