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

{"sheet":"Kasregister","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,"LEGENDA",{"$nulls":5},"HUIDIG SALDO"]
[null,"BP = Betaalpas",null,"AB = Automatische betaling ",{"$nulls":3},{"$f":"CURRENT_BALANCE","v":{"v":3311,"d":"€ 3,311.00"}}]
[null,"GA = Geldautomaat",null,"RB = Online rekeningbetaling"]
[null,"AS = Automatische storting ",null,"OV = Online of telefonische overboeking"]
[]
[null,"Cheque/code","Datum","Transactie","Beschrijving","Opname","Storting","Saldo"]
[null,null,{"$f":"TODAY()-19","v":"2019-05-12"},"Woodgrove Bank","Beginsaldo",null,{"v":2000,"d":"€ 2,000.00"},{"$f":"IFERROR(Kasregister[[#This Row],[Storting]], \"\")","v":{"v":2000,"d":"€ 2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2019-05-20"},"De Kunstacademie","Marloe's kunstcursus - 6 weken",{"v":100,"d":"€ 100.00"},null,{"$f":"IFERROR(IF(ISBLANK(Kasregister[[#This Row],[Opname]]),H9+Kasregister[[#This Row],[Storting]],H9-Kasregister[[#This Row],[Opname]]), \"\")","v":{"v":1900,"d":"€ 1,900.00"}}]
[null,"AS",{"$f":"TODAY()-11","v":"2019-05-20"},"Salaris",null,null,{"v":1500,"d":"€ 1,500.00"},{"$f":"IFERROR(IF(ISBLANK(Kasregister[[#This Row],[Opname]]),H10+Kasregister[[#This Row],[Storting]],H10-Kasregister[[#This Row],[Opname]]), \"\")","v":{"v":3400,"d":"€ 3,400.00"}}]
[null,"BP",{"$f":"TODAY()-8","v":"2019-05-23"},"Video Zuiderlaan","Filmhuur + € 10 cashback",{"v":16,"d":"€ 16.00"},null,{"$f":"IFERROR(IF(ISBLANK(Kasregister[[#This Row],[Opname]]),H11+Kasregister[[#This Row],[Storting]],H11-Kasregister[[#This Row],[Opname]]), \"\")","v":{"v":3384,"d":"€ 3,384.00"}}]
[null,"GA",{"$f":"TODAY()-5","v":"2019-05-26"},null,"Contant geld om uit eten te gaan",{"v":50,"d":"€ 50.00"},null,{"$f":"IFERROR(IF(ISBLANK(Kasregister[[#This Row],[Opname]]),H12+Kasregister[[#This Row],[Storting]],H12-Kasregister[[#This Row],[Opname]]), \"\")","v":{"v":3334,"d":"€ 3,334.00"}}]
[null,"RB",{"$f":"TODAY()","v":"2019-05-31"},"The Phone Company",null,{"v":23,"d":"€ 23.00"},null,{"$f":"IFERROR(IF(ISBLANK(Kasregister[[#This Row],[Opname]]),H13+Kasregister[[#This Row],[Storting]],H13-Kasregister[[#This Row],[Opname]]), \"\")","v":{"v":3311,"d":"€ 3,311.00"}}]
[null,"Totaal",null,{"$f":"CONCATENATE(\"Aantal transacties: \",SUBTOTAL(103,Kasregister[Transactie]))","v":"Aantal transacties: 5"},null,{"$f":"SUBTOTAL(109,Kasregister[Opname])","v":{"v":189,"d":"€ 189.00"}},{"$f":"SUBTOTAL(109,Kasregister[Storting])","v":{"v":3500,"d":"€ 3,500.00"}},{"$f":"Kasregister[[#Totals],[Storting]]-Kasregister[[#Totals],[Opname]]","v":{"v":3311,"d":"€ 3,311.00"}}]