{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Budget summary","Monthly income","Monthly expenses","Semester expenses"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Budget summary","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[1,2,1,5],[2,2,2,5],[4,2,4,3],[4,4,4,5],[5,2,5,3]]}
[]
[null,null,"my college budget"]
[null,null,"PERCENTAGE OF INCOME SPENT"]
[]
[null,null,{"$f":"NetMonthlyExpenses/NetMonthlyIncome","v":{"v":0.6436363636363637,"d":"64%"}},null,{"$f":"NetMonthlyExpenses","v":1770}]
[]
[null,null,"net monthly income"]
[null,null,{"$f":"Total_MonthlyIncome","v":{"v":2750,"d":"$2,750"}}]
[null,null,"net monthly expenses"]
[null,null,{"$f":"Total_MonthlyExpenses+Total_SemesterExpenses","v":{"v":1770,"d":"$1,770"}}]
[null,null,"balance"]
[null,null,{"$f":"NetMonthlyIncome-NetMonthlyExpenses","v":{"v":980,"d":"$980"}}]

{"sheet":"Monthly income","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[1,2,1,3],[2,2,2,3]]}
[]
[null,null,{"$f":"Workbook_Title","v":"my college budget"}]
[null,null,"MONTHLY INCOME"]
[]
[null,null,"ITEM","AMOUNT"]
[null,null,"fixed income",{"v":1500,"d":"$1,500"}]
[null,null,"financial aid",{"v":500,"d":"$500"}]
[null,null,"loans",{"v":500,"d":"$500"}]
[null,null,"other income",{"v":250,"d":"$250"}]
[null,null,"TOTAL",{"$f":"SUBTOTAL(109,MonthlyIncome[AMOUNT])","v":{"v":2750,"d":"$2,750"}}]

{"sheet":"Monthly expenses","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[1,2,1,3],[2,2,2,3]]}
[]
[null,null,{"$f":"Workbook_Title","v":"my college budget"}]
[null,null,"MONTHLY EXPENSES"]
[]
[null,null,"ITEM","AMOUNT"]
[null,null,"rent",{"v":20,"d":"$20"}]
[null,null,"utilities",{"v":50,"d":"$50"}]
[null,null,"cell phone",{"v":75,"d":"$75"}]
[null,null,"groceries",{"v":250,"d":"$250"}]
[null,null,"auto expenses",{"v":50,"d":"$50"}]
[null,null,"student loans",{"v":500,"d":"$500"}]
[null,null,"credit cards",{"v":275,"d":"$275"}]
[null,null,"insurance",{"v":125,"d":"$125"}]
[null,null,"hair cuts",{"v":50,"d":"$50"}]
[null,null,"entertainment",{"v":0,"d":"$0"}]
[null,null,"miscellaneous",{"v":0,"d":"$0"}]
[null,null,"TOTAL",{"$f":"SUBTOTAL(109,MonthlyExpenses[AMOUNT])","v":{"v":1395,"d":"$1,395"}}]

{"sheet":"Semester expenses","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"merged":[[1,2,1,4],[2,2,2,4]]}
[]
[null,null,{"$f":"Workbook_Title","v":"my college budget"}]
[null,null,"SEMESTER EXPENSES *"]
[]
[null,null,"ITEM","AMOUNT","PER MONTH"]
[null,null,"tuition",{"v":750,"d":"$750"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[AMOUNT]]/4, \"\")","v":{"v":187.5,"d":"$188"}}]
[null,null,"lab fees",{"v":250,"d":"$250"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[AMOUNT]]/4, \"\")","v":{"v":62.5,"d":"$63"}}]
[null,null,"books",{"v":500,"d":"$500"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[AMOUNT]]/4, \"\")","v":{"v":125,"d":"$125"}}]
[null,null,"deposits",{"v":0,"d":"$0"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[AMOUNT]]/4, \"\")","v":{"v":0,"d":"$0"}}]
[null,null,"transportation",{"v":0,"d":"$0"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[AMOUNT]]/4, \"\")","v":{"v":0,"d":"$0"}}]
[null,null,"other fees",{"v":0,"d":"$0"},{"$f":"IFERROR(SemesterExpenses[[#This Row],[AMOUNT]]/4, \"\")","v":{"v":0,"d":"$0"}}]
[null,null,"TOTAL",{"$f":"SUBTOTAL(109,SemesterExpenses[AMOUNT])","v":{"v":1500,"d":"$1,500"}},{"$f":"SUBTOTAL(109,SemesterExpenses[PER MONTH])","v":{"v":375,"d":"$375"}}]
[null,null,"* based on a 4 month semester"]