{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Maandbudget voedingsmiddelen","Werkelijke kosten"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Maandbudget voedingsmiddelen","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[3,1,3,3],[3,4,3,6],[5,1,5,3],[5,4,5,6],[7,1,7,2],[8,1,8,2],[9,1,9,2]]}
[{"$nulls":7}," "]
[]
[null,"Budget voor de maand",null,null,{"$f":"\"Percentage van het budget dat al is uitgegeven: \"&TEXT(E4,\"0%\")","v":"Percentage van het budget dat al is uitgegeven: 35%"}]
[null,{"$f":"TEXT(NOW(),\"mmmm\")","v":"oktober"},null,null,{"$f":"E6/B6","v":0.3508695652173913}]
[null,"Totaal voedingsmiddelenbudget voor de maand",null,null,"Al uitgegeven bedrag"]
[null,{"$f":"SUM(D9:G9)","v":{"v":575,"d":"€ 575"}},null,null,{"$f":"SUM(D10:G10)","v":{"v":201.75,"d":"€ 202"}}]
[]
[{"$nulls":3},"Boodschappen","Uit eten","Snacks","Overig"]
[null,"Maandbudget",null,{"v":325,"d":"€ 325"},{"v":100,"d":"€ 100"},{"v":100,"d":"€ 100"},{"v":50,"d":"€ 50"}]
[null,"Werkelijke onkosten",null,{"$f":"SUMIF(Tabel_WerkelijkeUitgavenVoedingsmiddelen[Categorie],'Maandbudget voedingsmiddelen'!D8,Tabel_WerkelijkeUitgavenVoedingsmiddelen[Kosten])","v":{"v":175,"d":"€ 175"}},{"$f":"SUMIF(Tabel_WerkelijkeUitgavenVoedingsmiddelen[Categorie],'Maandbudget voedingsmiddelen'!E8,Tabel_WerkelijkeUitgavenVoedingsmiddelen[Kosten])","v":{"v":0,"d":"€ 0"}},{"$f":"SUMIF(Tabel_WerkelijkeUitgavenVoedingsmiddelen[Categorie],'Maandbudget voedingsmiddelen'!F8,Tabel_WerkelijkeUitgavenVoedingsmiddelen[Kosten])","v":{"v":16.75,"d":"€ 17"}},{"$f":"SUMIF(Tabel_WerkelijkeUitgavenVoedingsmiddelen[Categorie],'Maandbudget voedingsmiddelen'!G8,Tabel_WerkelijkeUitgavenVoedingsmiddelen[Kosten])","v":{"v":10,"d":"€ 10"}}]

{"sheet":"Werkelijke kosten","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[null,"Werkelijke onkosten voor voedingsmiddelen",{"$nulls":3}," "]
[null,"Datum","Kosten","Categorie","Opmerkingen"]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F3)","v":"2019-10-01"},{"v":175,"d":"€ 175.00"},"Boodschappen",null,1]
[null,"2019-10-05",{"v":4.75,"d":"€ 4.75"},"Snacks",null,5]
[null,"2019-10-07",{"v":12,"d":"€ 12.00"},"Snacks",null,7]
[null,"2019-10-08",{"v":10,"d":"€ 10.00"},"Overig",null,8]