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

{"sheet":"Kasregister","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"Kasregister"]
[null,"Voer uw bankrekeningnummer in deze cel in"]
[null,{"$f":"CONCATENATE(\"Huidig saldo : \"&TEXT(Kasregister[[#Totals],[Saldo]],\"€ #.##0,00\"))","v":"Huidig saldo : € 2.730,84"}]
[]
[{"$nulls":4},"Chequenummer","Datum","Beschrijving","Categorie","Opname","Storting","Saldo"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-10"},"Beginsaldo","Storting",null,{"v":2916.73,"d":"€ 2,916.73"},{"$f":"InitialBalance","v":{"v":2916.73,"d":"€ 2,916.73"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-11"},"Supermarkt","Boodschappen",{"v":205.61,"d":"€ 205.61"},null,{"$f":"Saldo","v":{"v":2711.12,"d":"€ 2,711.12"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-25"},"Hypotheek huis","Hypotheek",{"v":961.77,"d":"€ 961.77"},null,{"$f":"Saldo","v":{"v":1749.35,"d":"€ 1,749.35"}}]
[{"$nulls":4},"Debet",{"$f":"TODAY()-40","v":"2018-03-30"},"Koffiezaak","Overig",{"v":3.65,"d":"€ 3.65"},null,{"$f":"Saldo","v":{"v":1745.6999999999998,"d":"€ 1,745.70"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-04"},"Gas en elektra","Water, gas, elektriciteit",{"v":145.33,"d":"€ 145.33"},null,{"$f":"Saldo","v":{"v":1600.37,"d":"€ 1,600.37"}}]
[{"$nulls":4},"Pinautomaat",{"$f":"TODAY()-30","v":"2018-04-09"},"Contant geld","Overig",{"v":50,"d":"€ 50.00"},null,{"$f":"Saldo","v":{"v":1550.37,"d":"€ 1,550.37"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-14"},"Creditcard","Creditcard",{"v":936.48,"d":"€ 936.48"},null,{"$f":"Saldo","v":{"v":613.8899999999999,"d":"€ 613.89"}}]
[null,"Overzicht",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-19"},"Salaris","Storting",null,{"v":2365.82,"d":"€ 2,365.82"},{"$f":"Saldo","v":{"v":2979.71,"d":"€ 2,979.71"}}]
[null,"Categorie","Totaal",null,null,{"$f":"TODAY()-15","v":"2018-04-24"},"Gemeenschappelijk beleggingsfonds","Belegging",{"v":200,"d":"€ 200.00"},null,{"$f":"Saldo","v":{"v":2779.71,"d":"€ 2,779.71"}}]
[null,"Storting",{"$f":"CategoryTotal","v":{"v":5282.55,"d":"€ 5,282.55"}},null,2253,{"$f":"TODAY()","v":"2018-05-09"},"The Phone Company","Water, gas, elektriciteit",{"v":48.87,"d":"€ 48.87"},null,{"$f":"Saldo","v":{"v":2730.84,"d":"€ 2,730.84"}}]
[null,"Creditcard",{"$f":"CategoryTotal","v":{"v":936.48,"d":"€ 936.48"}},null,"Totaal",{"$nulls":3},{"$f":"SUBTOTAL(109,Kasregister[Opname])","v":{"v":2551.71,"d":"€ 2,551.71"}},{"$f":"SUBTOTAL(109,Kasregister[Storting])","v":{"v":5282.55,"d":"€ 5,282.55"}},{"$f":"Kasregister[[#Totals],[Storting]]-Kasregister[[#Totals],[Opname]]","v":{"v":2730.84,"d":"€ 2,730.84"}}]
[null,"Belegging",{"$f":"CategoryTotal","v":{"v":200,"d":"€ 200.00"}}]
[null,"Boodschappen",{"$f":"CategoryTotal","v":{"v":205.61,"d":"€ 205.61"}}]
[null,"Water, gas, elektriciteit",{"$f":"CategoryTotal","v":{"v":194.20000000000002,"d":"€ 194.20"}}]
[null,"Verzekering",{"$f":"CategoryTotal","v":{"v":0,"d":"€ 0.00"}}]
[null,"Hypotheek",{"$f":"CategoryTotal","v":{"v":961.77,"d":"€ 961.77"}}]
[null,"Overig",{"$f":"CategoryTotal","v":{"v":53.65,"d":"€ 53.65"}}]