{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Überweisungsaufstellung"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Überweisungsaufstellung","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[]
[]
[null,"LEGENDE",{"$nulls":5},"AKTUELLER SALDO"]
[null,"DC = Debitkarte",null,"AP = automatische Zahlung ",{"$nulls":3},{"$f":"AKTUELLER_SALDO","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"ATM = Geldabhebung am Automaten",null,"BP = Onlineanweisung"]
[null,"AD = Einzahlung am Geldautomaten ",null,"TR = Telefonische oder Onlineanweisung"]
[]
[null,"Scheck/Kürzel","Datum","Transaktion","Beschreibung","Abhebung","Einzahlung","Saldo"]
[null,null,{"$f":"TODAY()-19","v":"2019-06-26"},"Woodgrove Bank","Anfangssaldo",null,{"v":2000,"d":"2,000.00 €"},{"$f":"IFERROR(ÜberweisungAufstellung[[#This Row],[Einzahlung]], \"\")","v":{"v":2000,"d":"2,000.00 €"}}]
[null,1001,{"$f":"TODAY()-11","v":"2019-07-04"},"Kunsthochschule","Kevins Zeichenkurs – 6 Wochen",{"v":100,"d":"100.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(ÜberweisungAufstellung[[#This Row],[Abhebung]]),H9+ÜberweisungAufstellung[[#This Row],[Einzahlung]],H9-ÜberweisungAufstellung[[#This Row],[Abhebung]]), \"\")","v":{"v":1900,"d":"1,900.00 €"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2019-07-04"},"Gehalt",null,null,{"v":1500,"d":"1,500.00 €"},{"$f":"IFERROR(IF(ISBLANK(ÜberweisungAufstellung[[#This Row],[Abhebung]]),H10+ÜberweisungAufstellung[[#This Row],[Einzahlung]],H10-ÜberweisungAufstellung[[#This Row],[Abhebung]]), \"\")","v":{"v":3400,"d":"3,400.00 €"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2019-07-07"},"Video am Südstern","Filmleihe + 10 € Geld zurück",{"v":16,"d":"16.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(ÜberweisungAufstellung[[#This Row],[Abhebung]]),H11+ÜberweisungAufstellung[[#This Row],[Einzahlung]],H11-ÜberweisungAufstellung[[#This Row],[Abhebung]]), \"\")","v":{"v":3384,"d":"3,384.00 €"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2019-07-10"},null,"Bargeld für Restaurantbesuch",{"v":50,"d":"50.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(ÜberweisungAufstellung[[#This Row],[Abhebung]]),H12+ÜberweisungAufstellung[[#This Row],[Einzahlung]],H12-ÜberweisungAufstellung[[#This Row],[Abhebung]]), \"\")","v":{"v":3334,"d":"3,334.00 €"}}]
[null,"BP",{"$f":"TODAY()","v":"2019-07-15"},"The Phone Company",null,{"v":23,"d":"23.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(ÜberweisungAufstellung[[#This Row],[Abhebung]]),H13+ÜberweisungAufstellung[[#This Row],[Einzahlung]],H13-ÜberweisungAufstellung[[#This Row],[Abhebung]]), \"\")","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"Summen",null,{"$f":"CONCATENATE(\"Transaktionsanzahl: \",SUBTOTAL(103,ÜberweisungAufstellung[Transaktion]))","v":"Transaktionsanzahl: 5"},null,{"$f":"SUBTOTAL(109,ÜberweisungAufstellung[Abhebung])","v":{"v":189,"d":"189.00 €"}},{"$f":"SUBTOTAL(109,ÜberweisungAufstellung[Einzahlung])","v":{"v":3500,"d":"3,500.00 €"}},{"$f":"ÜberweisungAufstellung[[#Totals],[Einzahlung]]-ÜberweisungAufstellung[[#Totals],[Abhebung]]","v":{"v":3311,"d":"3,311.00 €"}}]