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

{"sheet":"Dashboard","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,2,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,null,"Personal Expenses Dashboard",null,null,"to expense log >"]
[null,"PivotChart showing expenses by category and month is in this cell. Slicers to filter expenses by Date, Categories and Subcategories is in cells B3, D3 & F3 below."]
[null,"Slicer to filter table data based on date is in this cell.",null,"Slicer to filter table data based on category is in this cell.",null,"Slicer to filter table data based on subcategory is in this cell."]

{"sheet":"Expense Log","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"Expense Log",{"$nulls":3},"< to dashboard"]
[null,"Date","Category","Subcategory","Amount","Note"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Housing","Internet",{"v":29,"d":"£29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Housing","Landline phone",{"v":39,"d":"£39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Housing","Electricity",{"v":62,"d":"£62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Fun","Gym",{"v":29,"d":"£29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Daily","Clothing",{"v":42,"d":"£42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Transport","Travel card",{"v":21,"d":"£21.00"},"March pass"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Transport","Fuel",{"v":54,"d":"£54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Daily","Haircut",{"v":12,"d":"£12.00"}]
[null,"2019-04-02","Daily","Tea/Coffee",{"v":12,"d":"£12.00"}]
[null,"2019-04-02","Daily","Sweets/chocolate",{"v":2.75,"d":"£2.75"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Housing","Internet",{"v":29,"d":"£29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Housing","Landline phone",{"v":39,"d":"£39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Housing","Electricity",{"v":62,"d":"£62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Daily","Contact lenses",{"v":29,"d":"£29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Daily","Clothing",{"v":42,"d":"£42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Transport","Travel card",{"v":21,"d":"£21.00"},"April pass"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2019-05-01"},"Transport","Fuel",{"v":54,"d":"£54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"Daily","Haircut",{"v":12,"d":"£12.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2019-07-01"},"Fun","Cinema",{"v":21,"d":"£21.00"},"Classic movie night"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2019-08-01"},"Daily","Sweets/chocolate",{"v":2.75,"d":"£2.75"}]

{"sheet":"Personal Expenses Data","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3]]}
[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",{"v":222,"d":"£222.00"}]
[null,"Fun",{"v":29,"d":"£29.00"}]
[null,"Transport",{"v":21,"d":"£21.00"}]
[null,"Daily",{"v":42,"d":"£42.00"}]
[null,"Housing",{"v":130,"d":"£130.00"}]
[null,"Apr",{"v":302.75,"d":"£302.75"}]
[null,"Transport",{"v":75,"d":"£75.00"}]
[null,"Daily",{"v":97.75,"d":"£97.75"}]
[null,"Housing",{"v":130,"d":"£130.00"}]
[null,"May",{"v":54,"d":"£54.00"}]
[null,"Transport",{"v":54,"d":"£54.00"}]
[null,"Jun",{"v":12,"d":"£12.00"}]
[null,"Daily",{"v":12,"d":"£12.00"}]
[null,"Jul",{"v":21,"d":"£21.00"}]
[null,"Fun",{"v":21,"d":"£21.00"}]
[null,"Aug",{"v":2.75,"d":"£2.75"}]
[null,"Daily",{"v":2.75,"d":"£2.75"}]
[null,"Grand Total",{"v":614.5,"d":"£614.50"}]