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

{"sheet":"Scheckheft","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Scheckheft"]
[null,"LEGENDE",{"$nulls":5},"AKTUELLER SALDO"]
[null,"KK = Kundenkarte",null,"AZ = Automatische Zahlung ",{"$nulls":3},{"$f":"AKTUELLER_SALDO","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"GA = Auszahlung am Geldautomaten",null,"OA = Onlineanweisung"]
[null,"AE = Einzahlung am Geldautomaten ",null,"TA = Telefonische oder Onlineanweisung"]
[null,"ÜBERWEISUNG/CODE","DATUM","TRANSAKTION","BESCHREIBUNG","ABHEBUNG","EINZAHLUNG","SALDO"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-13"},"Bankhaus Halbzettel","Anfangssaldo",null,{"v":2000,"d":"2,000.00 €"},{"$f":"IFERROR(Scheckheft[[#This Row],[EINZAHLUNG]], \"\")","v":{"v":2000,"d":"2,000.00 €"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-21"},"Kunsthochschule","Kevins Zeichenkurs – 6 Wochen",{"v":100,"d":"100.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Scheckheft[[#This Row],[ABHEBUNG]]),H7+Scheckheft[[#This Row],[EINZAHLUNG]],H7-Scheckheft[[#This Row],[ABHEBUNG]]), \"\")","v":{"v":1900,"d":"1,900.00 €"}}]
[null,"AE",{"$f":"TODAY()-11","v":"2022-03-21"},"Gehalt",null,null,{"v":1500,"d":"1,500.00 €"},{"$f":"IFERROR(IF(ISBLANK(Scheckheft[[#This Row],[ABHEBUNG]]),H8+Scheckheft[[#This Row],[EINZAHLUNG]],H8-Scheckheft[[#This Row],[ABHEBUNG]]), \"\")","v":{"v":3400,"d":"3,400.00 €"}}]
[null,"KK",{"$f":"TODAY()-8","v":"2022-03-24"},"Video am Südstern","Filmleihe + 10 € Geld zurück",{"v":16,"d":"16.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Scheckheft[[#This Row],[ABHEBUNG]]),H9+Scheckheft[[#This Row],[EINZAHLUNG]],H9-Scheckheft[[#This Row],[ABHEBUNG]]), \"\")","v":{"v":3384,"d":"3,384.00 €"}}]
[null,"GA",{"$f":"TODAY()-5","v":"2022-03-27"},null,"Bargeld für Restaurantbesuch",{"v":50,"d":"50.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Scheckheft[[#This Row],[ABHEBUNG]]),H10+Scheckheft[[#This Row],[EINZAHLUNG]],H10-Scheckheft[[#This Row],[ABHEBUNG]]), \"\")","v":{"v":3334,"d":"3,334.00 €"}}]
[null,"OA",{"$f":"TODAY()","v":"2022-04-01"},"Telefongesellschaft",null,{"v":23,"d":"23.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(Scheckheft[[#This Row],[ABHEBUNG]]),H11+Scheckheft[[#This Row],[EINZAHLUNG]],H11-Scheckheft[[#This Row],[ABHEBUNG]]), \"\")","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"Summen",null,{"$f":"CONCATENATE(\"Anzahl der Transaktionen: \",SUBTOTAL(103,Scheckheft[TRANSAKTION]))","v":"Anzahl der Transaktionen: 5"},null,{"$f":"SUBTOTAL(109,Scheckheft[ABHEBUNG])","v":{"v":189,"d":"189.00 €"}},{"$f":"SUBTOTAL(109,Scheckheft[EINZAHLUNG])","v":{"v":3500,"d":"3,500.00 €"}},{"$f":"Scheckheft[[#Totals],[EINZAHLUNG]]-Scheckheft[[#Totals],[ABHEBUNG]]","v":{"v":3311,"d":"3,311.00 €"}}]