{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["My university budget","Income and expenses","Calculation"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"My university budget","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"merged":[[1,1,1,9]]}
[{"$nulls":10}," "]
[null,"MY UNIVERSITY BUDGET"]
[]
[null,"Income left",{"$f":"Net_Monthly_Income-Net_Monthly_Expenses","v":{"v":637.5,"d":"$637.50"}}]
[null,"% of income spent",{"$f":"Net_Monthly_Expenses/Net_Monthly_Income","v":{"v":0.7681818181818182,"d":"77%"}}]
[]
[null,"Net monthly income",{"$f":"Monthly_Income[[#Totals],[Amount]]","v":{"v":2750,"d":"$2,750.00"}}]
[null,"Net monthly expenses",{"$f":"Monthly_Expenses[[#Totals],[Amount]]+Semester_Expenses[[#Totals],[Per month]]","v":{"v":2112.5,"d":"$2,112.50"}}]

{"sheet":"Income and expenses","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"merged":[[1,1,1,2],[1,4,1,5],[1,7,1,9],[15,7,15,8]]}
[{"$nulls":10}," "]
[null,"MONTHLY INCOME",null,null,"MONTHLY EXPENSES",null,null,"SEMESTER EXPENSES"]
[]
[null,"Item","Amount",null,"Item","Amount",null,"Item","Amount","Per month"]
[null,"Fixed income",{"v":1500,"d":"$1,500.00"},null,"Rent",{"v":350,"d":"$350.00"},null,"Tuition",{"v":750,"d":"$750.00"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":187.5,"d":"$187.50"}}]
[null,"Financial support",{"v":500,"d":"$500.00"},null,"Utilities",{"v":50,"d":"$50.00"},null,"Parking",{"v":300,"d":"$300.00"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":75,"d":"$75.00"}}]
[null,"Loans",{"v":500,"d":"$500.00"},null,"Mobile phone",{"v":75,"d":"$75.00"},null,"Books",{"v":500,"d":"$500.00"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":125,"d":"$125.00"}}]
[null,"Other income",{"v":250,"d":"$250.00"},null,"Food and household supplies",{"v":250,"d":"$250.00"},null,"Deposits",{"v":0,"d":"$0.00"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Monthly_Income[Amount])","v":{"v":2750,"d":"$2,750.00"}},null,"Car expenses",{"v":50,"d":"$50.00"},null,"Transport",{"v":0,"d":"$0.00"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Student loans",{"v":500,"d":"$500.00"},null,"Other fees",{"v":0,"d":"$0.00"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Credit cards",{"v":275,"d":"$275.00"},null,"Total",{"$f":"SUBTOTAL(109,Semester_Expenses[Amount])","v":{"v":1550,"d":"$1,550.00"}},{"$f":"SUBTOTAL(109,Semester_Expenses[Per month])","v":{"v":387.5,"d":"$387.50"}}]
[{"$nulls":4},"Insurance",{"v":125,"d":"$125.00"}]
[{"$nulls":4},"Haircuts",{"v":50,"d":"$50.00"}]
[{"$nulls":4},"Entertainment",{"v":0,"d":"$0.00"}]
[{"$nulls":4},"Miscellaneous",{"v":0,"d":"$0.00"}]
[{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,Monthly_Expenses[Amount])","v":{"v":1725,"d":"$1,725.00"}},null,"Type semester length (months):",null,4]

{"sheet":"Calculation","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["Income",{"$f":"'My university budget'!C7","v":{"v":2750,"d":"$2,750.00"}}]
["Expenses",{"$f":"'My university budget'!C8","v":{"v":2112.5,"d":"$2,112.50"}}]