{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Einzahlungen","Abhebungen"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Einzahlungen","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"Monatlicher\nKonto-\nauszug",null,"MONAT","VORHERIGER SALDO","EINZAHLUNGEN GESAMT"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"MMMM\"))","v":"MAI"},{"v":2525.54,"d":"2,525.54 €"},{"$f":"Einzahlungen_gesamt","v":{"v":5400,"d":"5,400.00 €"}}]
[{"$nulls":3},"JAHR","ENDSALDO","ABHEBUNGEN GESAMT"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(AbschlussSaldo+Einzahlungen_gesamt-Abhebungen_gesamt, \"\")","v":{"v":6550.54,"d":"6,550.54 €"}},{"$f":"Abhebungen_gesamt","v":{"v":1375,"d":"1,375.00 €"}}]
[null,"Einzahlungen"]
[null,"Einzahlung Nr.","Datum","Betrag","Beschreibung","Wertstellung"]
[null,{"$f":"ROW()-ROW(Einzahlungen[[#Headers],[Einzahlung Nr.]])","v":1},{"$f":"TODAY()-15","v":"2018-05-01"},{"v":1500,"d":"1,500.00 €"},"Auftrag 1, Scheck 1","Ja"]
[null,{"$f":"ROW()-ROW(Einzahlungen[[#Headers],[Einzahlung Nr.]])","v":2},{"$f":"TODAY()-10","v":"2018-05-06"},{"v":1200,"d":"1,200.00 €"},"Auftrag 2, Scheck 1","Ja"]
[null,{"$f":"ROW()-ROW(Einzahlungen[[#Headers],[Einzahlung Nr.]])","v":3},{"$f":"TODAY()-5","v":"2018-05-11"},{"v":1500,"d":"1,500.00 €"},"Auftrag 1, Scheck 2","Ja"]
[null,{"$f":"ROW()-ROW(Einzahlungen[[#Headers],[Einzahlung Nr.]])","v":4},{"$f":"TODAY()","v":"2018-05-16"},{"v":1200,"d":"1,200.00 €"},"Auftrag 2, Scheck 2","Ja"]
[null,"SUMME",null,{"$f":"SUBTOTAL(109,Einzahlungen[Betrag])","v":{"v":5400,"d":"5,400.00 €"}}]

{"sheet":"Abhebungen","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"Abhebungen"]
[null,"Typ","Datum","Betrag","für","Wertstellung"]
[null,"Scheck 1001",{"$f":"TODAY()-8","v":"2018-05-08"},{"v":150,"d":"150.00 €"},"Strom/Heizung","Ja"]
[null,"Scheck 1002",{"$f":"TODAY()-6","v":"2018-05-10"},{"v":150,"d":"150.00 €"},"Wasser/Abwasser/Müll","Ja"]
[null,"Scheck 1003",{"$f":"TODAY()-4","v":"2018-05-12"},{"v":850,"d":"850.00 €"},"Hypothek","Ja"]
[null,"Belastung",{"$f":"TODAY()-2","v":"2018-05-14"},{"v":125,"d":"125.00 €"},"Lebensmittel","Ja"]
[null,"Geldautomat",{"$f":"TODAY()","v":"2018-05-16"},{"v":100,"d":"100.00 €"},"Bargeld","Ja"]
[null,"SUMME",null,{"$f":"SUBTOTAL(109,Schecks[Betrag])","v":{"v":1375,"d":"1,375.00 €"}}]