{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Uitgavenlogboek","Gegevens persoonlijke uitgaven"],"not_rendered":{"charts":1,"defined_names":6,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,1,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,"dashboard persoonlijke uitgaven",{"$nulls":3},"naar uitgavenlogboek >"]
[null,"Draaigrafiek met uitgaven per categorie en maand in deze cel. Slicers om uitgaven te filteren op Datum, Categorieën en Subcategorieën bevinden zich in de cellen B3, D3 en F3 hieronder."]
[null,"Slicer om tabelgegevens te filteren op datum staat in deze cel.",null,"Slicer om tabelgegevens te filteren op categorie staat in deze cel.",null,"Slicer om tabelgegevens te filteren op subcategorie staat in deze cel."]

{"sheet":"Uitgavenlogboek","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"uitgavenlogboek",{"$nulls":3},"< naar dashboard"]
[null,"datum","categorie","subcategorie","bedrag","notitie"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Huisvesting","Internet",{"v":29,"d":"€ 29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Huisvesting","Vaste telefoon",{"v":39,"d":"€ 39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Huisvesting","Elektriciteit",{"v":62,"d":"€ 62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Amusement","Sport",{"v":29,"d":"€ 29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Dagelijks","Kleding",{"v":42,"d":"€ 42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Vervoer","OV-kaart",{"v":21,"d":"€ 21.00"},"maandkaart maart"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Vervoer","Benzine",{"v":54,"d":"€ 54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Dagelijks","Kapper",{"v":12,"d":"€ 12.00"}]
[null,"2019-04-02","Dagelijks","Thee/koffie",{"v":12,"d":"€ 12.00"}]
[null,"2019-04-02","Dagelijks","Snoep",{"v":2.75,"d":"€ 2.75"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Huisvesting","Internet",{"v":29,"d":"€ 29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Huisvesting","Vaste telefoon",{"v":39,"d":"€ 39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Huisvesting","Elektriciteit",{"v":62,"d":"€ 62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Dagelijks","Contactlenzen",{"v":29,"d":"€ 29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Dagelijks","Kleding",{"v":42,"d":"€ 42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Vervoer","OV-kaart",{"v":21,"d":"€ 21.00"},"maandkaart april"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2019-05-01"},"Vervoer","Benzine",{"v":54,"d":"€ 54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"Dagelijks","Kapper",{"v":12,"d":"€ 12.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2019-07-01"},"Amusement","Bioscoop",{"v":21,"d":"€ 21.00"},"Filmklassiekeravond"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2019-08-01"},"Dagelijks","Snoep",{"v":2.75,"d":"€ 2.75"}]

{"sheet":"Gegevens persoonlijke uitgaven","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true,"merged":[[0,1,0,6],[1,1,1,6]]}
[null,"gegevens persoonlijke uitgaven"]
[null,"In de onderstaande draaitabel wordt de gegevensbron gegeven voor de draaigrafiek Persoonlijke uitgaven in het dashboard. Eventuele aanpassingen kunnen leiden tot visuele wijzigingen in de draaigrafiek of tot fouten."]
[null,"Som van bedrag","Kolomlabels"]
[null,"Rijlabels","Amusement","Vervoer","Dagelijks","Huisvesting","Eindtotaal"]
[null,"mrt",29,21,42,130,222]
[null,"apr",null,75,97.75,130,302.75]
[null,"mei",null,54,null,null,54]
[null,"jun",null,null,12,null,12]
[null,"jul",21,{"$nulls":3},21]
[null,"aug",null,null,2.75,null,2.75]
[null,"Eindtotaal",50,150,154.5,260,614.5]