{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Income and Expenses","Calculation"],"not_rendered":{"charts":4,"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Income and Expenses","index":0,"n_rows":39,"n_cols":10,"rows_kept":39,"merged":[[10,7,10,9],[24,1,24,2],[24,4,24,5],[24,7,24,9],[25,7,25,8]]}
["Create college budget in this worksheet. Next tip is in cell A5."]
[]
[]
[]
["Chart in cell B5 is updated automatically. Values are based on data from the tables in cells B27, E27 & H28. Next tip in cell A12"]
[]
[]
[]
[]
[]
[]
["Chart in cells B12, E12 & H12 are updated automatically. Values are based on data from the tables in cells B27, E27 & H28.\nNext tip is in cell A25."]
{"$rows_empty":12}
["Type all your income and expenses in tables on this sheet.\nType how long (in months) your semester is in cell J26","Monthly Income",null,null,"Monthly Expenses",null,null,"Semester Expenses"]
[{"$nulls":7},"Type Semester Length (months):",null,4]
[null,"Item","Amount",null,"Item","Amount"]
[null,"Fixed income",{"v":1500,"d":"$1,500"},null,"Rent",{"v":350,"d":"$350"},null,"Item","Amount","Per month"]
[null,"Financial aid",{"v":500,"d":"$500"},null,"Utilities",{"v":50,"d":"$50"},null,"Tuition",{"v":750,"d":"$750"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":187.5,"d":"$188"}}]
[null,"Loans",{"v":500,"d":"$500"},null,"Cell phone",{"v":75,"d":"$75"},null,"Lab fees",{"v":300,"d":"$300"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":75,"d":"$75"}}]
[null,"Other income",{"v":250,"d":"$250"},null,"Groceries",{"v":250,"d":"$250"},null,"Books",{"v":500,"d":"$500"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":125,"d":"$125"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Monthly_Income[Amount])","v":{"v":2750,"d":"$2,750"}},null,"Auto expenses",{"v":50,"d":"$50"},null,"Deposits",{"v":0,"d":"$0"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},"Student loans",{"v":500,"d":"$500"},null,"Transportation",{"v":0,"d":"$0"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},"Credit cards",{"v":275,"d":"$275"},null,"Other fees",{"v":0,"d":"$0"},{"$f":"Semester_Expenses[[#This Row],[Amount]]/Months_in_semester","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},"Insurance",{"v":125,"d":"$125"},null,"Total",{"$f":"SUBTOTAL(109,Semester_Expenses[Amount])","v":{"v":1550,"d":"$1,550"}},{"$f":"SUM(J29:J34)","v":{"v":387.5,"d":"$388"}}]
[{"$nulls":4},"Hair cuts",{"v":50,"d":"$50"}]
[{"$nulls":4},"Entertainment",{"v":0,"d":"$0"}]
[{"$nulls":4},"Miscellaneous",{"v":0,"d":"$0"}]
[{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,Monthly_Expenses[Amount])","v":{"v":1725,"d":"$1,725"}}]

{"sheet":"Calculation","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"hidden":true}
["Income",{"$f":"Monthly_Income[[#Totals],[Amount]]","v":{"v":2750,"d":"$2,750"}}]
["Expenses",{"$f":"Monthly_Expenses[[#Totals],[Amount]]+Semester_Expenses[[#Totals],[Per month]]","v":{"v":2112.5,"d":"$2,113"}}]
["Income Left",{"$f":"B1-B2","v":{"v":637.5,"d":"$638"}}]
["Monthly Expenses",{"$f":"Monthly_Expenses[[#Totals],[Amount]]","v":{"v":1725,"d":"$1,725"}}]
["Semester Expenses (per month)",{"$f":"Semester_Expenses[[#Totals],[Per month]]","v":{"v":387.5,"d":"$388"}}]