{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Expense Log","Category Setup","Personal Expenses Data"],"not_rendered":{"charts":1,"defined_names":6,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":30,"n_cols":7,"rows_kept":30}
[]
[null,"personal expenses"]
{"$rows_empty":27}
[{"$nulls":6}," "]

{"sheet":"Expense Log","index":1,"n_rows":24,"n_cols":6,"rows_kept":24}
[]
[null,"expense log"]
[]
[null,"date","category","subcategory","amount","note"]
[null,"2011-05-03","Transport","Fuel",{"v":54,"d":"54.00"}]
[null,"2011-06-01","Daily","Hair Cut",{"v":12,"d":"12.00"}]
[null,"2011-07-01","Fun","Cinema",{"v":21,"d":"21.00"},"Classic Movie Night"]
[null,"2011-08-01","Daily","Sweets / Candy",2.75]
[null,"2011-03-02","Housing","Internet",{"v":29,"d":"29.00"}]
[null,"2011-03-02","Housing","Landline Phone",{"v":39,"d":"39.00"}]
[null,"2011-03-02","Housing","Electricity",{"v":62,"d":"62.00"}]
[null,"2011-03-04","Fun","Gym",{"v":29,"d":"29.00"}]
[null,"2011-03-04","Daily","Clothing",{"v":42,"d":"42.00"}]
[null,"2011-03-06","Transport","Subway Pass",{"v":21,"d":"21.00"},"March Pass"]
[null,"2011-04-01","Transport","Fuel",{"v":54,"d":"54.00"}]
[null,"2011-04-01","Daily","Hair Cut",{"v":12,"d":"12.00"}]
[null,"2011-04-01","Daily","Tea/Coffee",{"v":12,"d":"12.00"}]
[null,"2011-04-01","Daily","Sweets / Candy",2.75]
[null,"2011-04-02","Housing","Internet",{"v":29,"d":"29.00"}]
[null,"2011-04-02","Housing","Landline Phone",{"v":39,"d":"39.00"}]
[null,"2011-04-02","Housing","Electricity",{"v":62,"d":"62.00"}]
[null,"2011-04-04","Daily","Contact Lenses",{"v":29,"d":"29.00"}]
[null,"2011-04-04","Daily","Clothing",{"v":42,"d":"42.00"}]
[null,"2011-04-06","Transport","Subway Pass",{"v":21,"d":"21.00"},"April Pass"]

{"sheet":"Category Setup","index":2,"n_rows":17,"n_cols":16,"rows_kept":17}
[]
[null,"main categories",null,"subcategories"]
[]
[null,"category name"]
[null,"Housing"]
[null,"Daily",null,"housing",null,"daily",null,"transport",null,"fun",null,"category 5",null,"category 6",null,"category 7"]
[null,"Transport",null,"Rent/Mortgage",null,"Food",null,"Car",null,"Cable",null,"Subcategory 1",null,"Subcategory 1",null,"Subcategory 1"]
[null,"Fun",null,"Gas",null,"Hair Cut",null,"Car Insurance",null,"Cinema",null,"Subcategory 2",null,"Subcategory 2",null,"Subcategory 2"]
[{"$nulls":3},"Landline Phone",null,"Medication",null,"Bus Pass",null,"Club"]
[{"$nulls":3},"Internet",null,"Contact Lenses",null,"Subway Pass",null,"DVD Purchases"]
[{"$nulls":3},"Mobile Phone",null,"Tea/Coffee",null,"Fuel",null,"DVD Rentals"]
[{"$nulls":3},"Water",null,"Clothing",null,"Car Tax",null,"Eating Out"]
[{"$nulls":3},"Electricity",null,"Dry Cleaning",null,"Rail Card",null,"Gym"]
[{"$nulls":3},"Insurance",null,"Cosmetics",null,"Car Repairs",null,"Magazines"]
[{"$nulls":3},"Health Insurance",null,"Tuition",{"$nulls":3},"Music CD"]
[{"$nulls":3},"Credit Cards",null,"Sweets / Candy",{"$nulls":3},"Music Lessons"]
[{"$nulls":9},"Sporting Events"]

{"sheet":"Personal Expenses Data","index":3,"n_rows":25,"n_cols":3,"rows_kept":25,"hidden":true,"merged":[[4,1,4,12]]}
[]
[null,"personal expenses data"]
[]
[]
[null,"The PivotTable below provides the data source for the Personal Expenses PivotChart on the Dashboard. Any changes you make may result in visual modifications to the PivotChart or errors."]
[]
[null,"Row Labels","Sum of Amount"]
[null,"Mar",222]
[null,"Fun",29]
[null,"Transport",21]
[null,"Daily",42]
[null,"Housing",130]
[null,"Apr",302.75]
[null,"Transport",75]
[null,"Daily",97.75]
[null,"Housing",130]
[null,"May",54]
[null,"Transport",54]
[null,"Jun",12]
[null,"Daily",12]
[null,"Jul",21]
[null,"Fun",21]
[null,"Aug",2.75]
[null,"Daily",2.75]
[null,"Grand Total",614.5]