{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Monthly Budget Overview","Monthly Expenses","Chart Data","Lookup List"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Monthly Budget Overview","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"merged":[[3,1,3,2]]}
[null,"College Budget Analysis"]
[]
[null,"Percentage of income spent",{"$f":"C6/C5","v":{"v":0.8805882352941177,"d":"$1"}}]
[null,{"$f":"IF(C6>C5,C5,C6)","v":2994}]
[null,"Income",{"$f":"IncomeTable[[#Totals],[AMOUNT]]","v":{"v":3400,"d":"$3,400"}}]
[null,"Expenses",{"$f":"GETPIVOTDATA(\"Cost\",$B$18)","v":{"v":2994,"d":"$2,994"}}]
[null,"BALANCE",{"$f":"C5-C6","v":{"v":406,"d":"$406"}}]
[]
[null,"Money coming in"]
[null,"ITEM","AMOUNT"]
[null,"Estimated income",{"v":1500,"d":"$1,500"}]
[null,"Financial aid",{"v":500,"d":"$500"}]
[null,"Roommate contribution",{"v":700,"d":"$700"}]
[null,"Assistance from parents",{"v":700,"d":"$700"}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,IncomeTable[AMOUNT])","v":{"v":3400,"d":"$3,400"}}]
[]
[null,"Money going out"]
[null,"CATEGORY","COST "]
[null,"Housing",{"v":906,"d":"$906"}]
[null,"Transportation",{"v":430,"d":"$430"}]
[null,"Food",{"v":200,"d":"$200"}]
[null,"Personal care",{"v":140,"d":"$140"}]
[null,"Entertainment",{"v":168,"d":"$168"}]
[null,"School costs",{"v":975,"d":"$975"}]
[null,"Loans/credit cards",{"v":175,"d":"$175"}]
[null,"TOTAL ",{"v":2994,"d":"$2,994"}]

{"sheet":"Monthly Expenses","index":1,"n_rows":39,"n_cols":4,"rows_kept":39}
[null,"Monthly Expenses"]
[null,"DESCRIPTION","CATEGORY","COST"]
[null,"Concerts","Entertainment",{"v":50,"d":"$50"}]
[null,"Live Theater","Entertainment",{"v":25,"d":"$25"}]
[null,"Movies","Entertainment",{"v":28,"d":"$28"}]
[null,"Music (CDs, downloads, etc.)","Entertainment",{"v":10,"d":"$10"}]
[null,"Sporting Events","Entertainment",{"v":40,"d":"$40"}]
[null,"Video/DVD (Purchase)","Entertainment",{"v":15,"d":"$15"}]
[null,"Video/DVD (Rental)","Entertainment",{"v":0,"d":"$0"}]
[null,"Eating Out","Food",{"v":50,"d":"$50"}]
[null,"Groceries","Food",{"v":150,"d":"$150"}]
[null,"Cable/Satellite","Housing",{"v":100,"d":"$100"}]
[null,"Electric","Housing",{"v":40,"d":"$40"}]
[null,"Gas","Housing",{"v":60,"d":"$60"}]
[null,"Mortgage or Rent","Housing",{"v":450,"d":"$450"}]
[null,"Natural gas/oil","Housing",{"v":0,"d":"$0"}]
[null,"Online/Internet Service","Housing",{"v":100,"d":"$100"}]
[null,"Phone (Cellular)","Housing",{"v":40,"d":"$40"}]
[null,"Supplies","Housing",{"v":55,"d":"$55"}]
[null,"Waste Removal and Recycle","Housing",{"v":46,"d":"$46"}]
[null,"Water and Sewer","Housing",{"v":15,"d":"$15"}]
[null,"Credit Card 1","Loans/credit cards",{"v":50,"d":"$50"}]
[null,"Credit Card 2","Loans/credit cards",{"v":25,"d":"$25"}]
[null,"Student Loan","Loans/credit cards",{"v":100,"d":"$100"}]
[null,"Clothing","Personal care",{"v":140,"d":"$140"}]
[null,"Laundry","Personal care",{"v":0,"d":"$0"}]
[null,"Medical Costs","Personal care",{"v":0,"d":"$0"}]
[null,"Books","School costs",{"v":100,"d":"$100"}]
[null,"Extracurricular activities","School costs",{"v":50,"d":"$50"}]
[null,"Lab Fees","School costs",{"v":25,"d":"$25"}]
[null,"Tuition","School costs",{"v":800,"d":"$800"}]
[null,"Auto maintenance","Transportation",{"v":50,"d":"$50"}]
[null,"Bus/train fare","Transportation",{"v":20,"d":"$20"}]
[null,"Fuel","Transportation",{"v":50,"d":"$50"}]
[null,"Insurance","Transportation",{"v":100,"d":"$100"}]
[null,"Licensing ","Transportation",{"v":10,"d":"$10"}]
[null,"Parking fees","Transportation"]
[null,"Vehicle payment","Transportation",{"v":200,"d":"$200"}]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,MonthlyExpenses[COST])","v":{"v":2994,"d":"$2,994"}}]

{"sheet":"Chart Data","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"merged":[[1,1,1,2]]}
[null,"Chart Data"]
[null,"Any changes made to the PivotTable below will modify the chart on the Monthly Budget Overview sheet."]
[null,"CATEGORY","COST "]
[null,"Entertainment",{"v":168,"d":"$168"}]
[null,"Food",{"v":200,"d":"$200"}]
[null,"Housing",{"v":906,"d":"$906"}]
[null,"Loans/credit cards",{"v":175,"d":"$175"}]
[null,"Personal care",{"v":140,"d":"$140"}]
[null,"School costs",{"v":975,"d":"$975"}]
[null,"Transportation",{"v":430,"d":"$430"}]
[null,"GRAND TOTAL ",{"v":2994,"d":"$2,994"}]

{"sheet":"Lookup List","index":3,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"Lookup List"]
[null,"Add or remove items in the list below to  modify the category list on the Monthly Expenses sheet."]
[null,"BUDGET CATEGORY LOOKUP"]
[null,"School costs"]
[null,"Entertainment"]
[null,"Food"]
[null,"Housing"]
[null,"Personal care"]
[null,"Transportation"]
[null,"Loans/credit cards"]