{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Feestdagenbudget","Lijst","Lijstgegevens"],"not_rendered":{"charts":1,"images":3,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Feestdagenbudget","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,1,1,3],[0,4,1,4],[2,1,2,2],[2,3,5,5],[6,4,12,4],[6,5,12,5],[7,3,22,3],[13,4,19,4],[13,5,20,5]]}
[null,"Cadeaubudget feestdagen",null,null,"Deze cel bevat een reeks lichten.","NAAR LIJST >"]
[{"$nulls":5},"NAAR LIJSTGEGEVENS >"]
[null,"TOTALEN",null,"Deze cel bevat een gegroepeerd staafdiagram met de kostenverdeling en de uitgaven tot nu toe."]
[null,"KOSTENVERDELING",{"$f":"SUM(Cadeaugegevens[KOSTEN])","v":{"v":377,"d":"€ 377.00"}}]
[null,"UITGAVEN TOT NU TOE",{"$f":"SUMIF(Cadeaugegevens[GEKOCHT],\"Gekocht\",Cadeaugegevens[KOSTEN])","v":{"v":233,"d":"€ 233.00"}}]
[null,"VERSCHIL",{"$f":"C4-C5","v":{"v":144,"d":"€ 144.00"}}]
[null,"Vernieuwen het onderstaande rapport om het bij te werken.",null,null,"Deze cel bevat een slicer om tabelgegevens te filteren op Inpakstatus.","Deze cel bevat een slicer om tabelgegevens te filteren op Gekocht."]
[null,"UITSPLITSING",null,"Deze cel bevat een slicer om tabelgegevens te filteren op Voor."]
[null,null,"Cadeaukosten"]
[null,"Naam 3",{"v":71,"d":"€ 71.00"}]
[null,"Gekocht"]
[null,"Speelgoedtrein",{"v":26,"d":"€ 26.00"}]
[null,"Puzzel",{"v":16,"d":"€ 16.00"}]
[null,"Niet gekocht",null,null,"Deze cel bevat een slicer om tabelgegevens te filteren op Bezorgstatus.","Deze cel bevat een slicer om tabelgegevens te filteren op Cadeaucategorie."]
[null,"Fiets",{"v":29,"d":"€ 29.00"}]
[]
[null,"Naam 2",{"v":59,"d":"€ 59.00"}]
[null,"Gekocht"]
[null,"Sokken",{"v":23,"d":"€ 23.00"}]
[null,"Poppenhuis",{"v":36,"d":"€ 36.00"}]
[]
[null,"Naam 4",{"v":44,"d":"€ 44.00"}]
[null,"Gekocht"]
[null,"Plakboekmaterialen",{"v":14,"d":"€ 14.00"}]
[null,"Fotoalbum",{"v":30,"d":"€ 30.00"}]
[]
[null,"Naam 5",{"v":118,"d":"€ 118.00"}]
[null,"Gekocht"]
[null,"Xbox-spel",{"v":49,"d":"€ 49.00"}]
[null,"Niet gekocht"]
[null,"Overhemd",{"v":37,"d":"€ 37.00"}]
[null,"Geschenkbon",{"v":32,"d":"€ 32.00"}]
[]
[null,"Naam 1",{"v":39,"d":"€ 39.00"}]
[null,"Gekocht"]
[null,"Trui",{"v":39,"d":"€ 39.00"}]
[]
[null,"Naam 6",{"v":46,"d":"€ 46.00"}]
[null,"Niet gekocht"]
[null,"Sokken",{"v":46,"d":"€ 46.00"}]
[]
[null,"Eindtotaal",{"v":377,"d":"€ 377.00"}]

{"sheet":"Lijst","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,2],[0,3,1,6]]}
[null,"Boodschappenlijst",null,"Deze cel bevat een reeks lichten.",{"$nulls":3},"NAAR LIJSTGEGEVENS >"]
[{"$nulls":7},"< NAAR FEESTDAGENBUDGET"]
[null,"VOOR","CADEAUCATEGORIE","CADEAU","KOSTEN","GEKOCHT","BEZORGSTATUS","INPAKSTATUS"]
[null,"Naam 3","Familiecadeau","Speelgoedtrein",{"v":26,"d":"€ 26.00"},"Gekocht","Aangekomen","Ingepakt"]
[null,"Naam 2","Algemeen cadeau","Sokken",{"v":23,"d":"€ 23.00"},"Gekocht","Aangekomen","Ingepakt"]
[null,"Naam 3","Algemeen cadeau","Puzzel",{"v":16,"d":"€ 16.00"},"Gekocht","Aangekomen","Niet ingepakt"]
[null,"Naam 4","Algemeen cadeau","Plakboekmaterialen",{"v":14,"d":"€ 14.00"},"Gekocht","Onderweg","Niet ingepakt"]
[null,"Naam 5","Algemeen cadeau","Xbox-spel",{"v":49,"d":"€ 49.00"},"Gekocht","Onderweg","Niet ingepakt"]
[null,"Naam 5","Algemeen cadeau","Overhemd",{"v":37,"d":"€ 37.00"},"Niet gekocht","Onderweg","Niet ingepakt"]
[null,"Naam 1","Algemeen cadeau","Trui",{"v":39,"d":"€ 39.00"},"Gekocht","Onderweg","Niet ingepakt"]
[null,"Naam 2","Algemeen cadeau","Poppenhuis",{"v":36,"d":"€ 36.00"},"Gekocht","Aangekomen","Niet ingepakt"]
[null,"Naam 3","Algemeen cadeau","Fiets",{"v":29,"d":"€ 29.00"},"Niet gekocht"]
[null,"Naam 4","Algemeen cadeau","Fotoalbum",{"v":30,"d":"€ 30.00"},"Gekocht","Aangekomen"]
[null,"Naam 5","Algemeen cadeau","Geschenkbon",{"v":32,"d":"€ 32.00"},"Niet gekocht"]
[null,"Naam 6","Algemeen cadeau","Sokken",{"v":46,"d":"€ 46.00"},"Niet gekocht"]

{"sheet":"Lijstgegevens","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"Lijstgegevens","Deze cel bevat een reeks lichten.",null,"< NAAR LIJST"]
[{"$nulls":4},"< NAAR FEESTDAGENBUDGET"]
[null,"PERSONEN",null,"CADEAUCATEGORIEËN"]
[null,"Naam 1",null,"Klein cadeautje"]
[null,"Naam 2",null,"Algemeen cadeau"]
[null,"Naam 3",null,"Geschenk voor echtgenot(e)"]
[null,"Naam 4",null,"Familiecadeau"]
[null,"Naam 5",null,"Speciaal cadeau"]
[null,"Naam 6"]