{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Monatsbudget für Essen","Tatsächliche Kosten"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Monatsbudget für Essen","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 für den Monat",null,null,{"$f":"\"Percentage of budget already spent: \"&TEXT(E4,\"0%\")","v":"Percentage of budget already spent: 35%"}]
[null,{"$f":"TEXT(NOW(),\"MMMM\")","v":"Oktober"},null,null,{"$f":"E6/B6","v":0.3508695652173913}]
[null,"Gesamtbudget für Nahrungsmittel für den Monat",null,null,"Bereits aufgewendeter Betrag"]
[null,{"$f":"SUM(D9:G9)","v":{"v":575,"d":"575 €"}},null,null,{"$f":"SUM(D10:G10)","v":{"v":201.75,"d":"202 €"}}]
[]
[{"$nulls":3},"Lebensmittel","Auswärtsessen","Snacks","Sonstiges"]
[null,"Monatsbudget",null,{"v":325,"d":"325 €"},{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"v":50,"d":"50 €"}]
[null,"Tatsächliche Ausgaben",null,{"$f":"SUMIF(Tabelle_TatsächlicheEssensausgaben[Kategorie],'Monatsbudget für Essen'!D8,Tabelle_TatsächlicheEssensausgaben[Kosten])","v":{"v":175,"d":"175 €"}},{"$f":"SUMIF(Tabelle_TatsächlicheEssensausgaben[Kategorie],'Monatsbudget für Essen'!E8,Tabelle_TatsächlicheEssensausgaben[Kosten])","v":{"v":0,"d":"0 €"}},{"$f":"SUMIF(Tabelle_TatsächlicheEssensausgaben[Kategorie],'Monatsbudget für Essen'!F8,Tabelle_TatsächlicheEssensausgaben[Kosten])","v":{"v":16.75,"d":"17 €"}},{"$f":"SUMIF(Tabelle_TatsächlicheEssensausgaben[Kategorie],'Monatsbudget für Essen'!G8,Tabelle_TatsächlicheEssensausgaben[Kosten])","v":{"v":10,"d":"10 €"}}]

{"sheet":"Tatsächliche Kosten","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[null,"Tatsächliche Ausgaben für Nahrungsmittel",{"$nulls":3}," "]
[null,"Datum","Kosten","Kategorie","Anmerkungen"]
[null,{"$f":"DATE(YEAR(NOW()),MONTH(NOW()),F3)","v":"2019-10-01"},{"v":175,"d":"175.00 €"},"Lebensmittel",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 €"},"Sonstiges",null,8]