{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Betalingsoverzicht","Betalingslogboek"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Betalingsoverzicht","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Betalingsoverzicht",null,null,"Wijzig in de koptekst van de onderstaande tabel Betalingsoverzicht de categorienamen om deze sjabloon naar wens aan te passen. Als u extra categorieën nodig hebt, kopieert u de laatste kolom in de tabel en plakt u deze rechts van de gekopieerde kolom. Wanneer u de categorienaam wijzigt, worden de formules automatisch bijgewerkt. Zorg dat deze tabel hetzelfde aantal rijen heeft als in het werkblad Betalingslogboek."]
[null,"Datum","Autoverzekering","Kantoor-benodigdheden","Elektriciteit","Hypotheek","Telefoon","Leeg 1","Leeg 2","Leeg 3","Leeg 4"]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"Register[@Bedrag]\")*(INDIRECT(\"Register[@Categorie]\")=CategoryName),\"\")","v":0},0,0,{"v":1200,"d":"€ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"€ 85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"€ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"€ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"€ 99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"€ 68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"€ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"€ 345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"€ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"€ 74.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"€ 123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"€ 99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"€ 100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"€ 1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"€ 128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,Betalingsoverzicht[Autoverzekering])","v":{"v":300,"d":"€ 300.00"}},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Kantoor-benodigdheden])","v":{"v":572,"d":"€ 572.00"}},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Elektriciteit])","v":{"v":159,"d":"€ 159.00"}},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Hypotheek])","v":{"v":4899,"d":"€ 4,899.00"}},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Telefoon])","v":{"v":191,"d":"€ 191.00"}},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Leeg 1])","v":0},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Leeg 2])","v":0},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Leeg 3])","v":0},{"$f":"SUBTOTAL(109,Betalingsoverzicht[Leeg 4])","v":0}]

{"sheet":"Betalingslogboek","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Betalingslogboek"]
[null,"Datum","Nummer","Beschrijving","Categorie","Bedrag"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","De Bank","Hypotheek",{"v":1200,"d":"€ 1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"Licht & Energie","Elektriciteit",{"v":85,"d":"€ 85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"De Verzekeraar","Autoverzekering",{"v":100,"d":"€ 100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"De Bank","Hypotheek",{"v":1200,"d":"€ 1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"Licht & Energie","Hypotheek",{"v":99,"d":"€ 99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"De Telecomwinkel","Telefoon",{"v":68,"d":"€ 68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"De Verzekeraar","Autoverzekering",{"v":100,"d":"€ 100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","Kantoor-benodigdheden",{"v":345,"d":"€ 345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"De Bank","Hypotheek",{"v":1200,"d":"€ 1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"Licht & Energie","Elektriciteit",{"v":74,"d":"€ 74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"De Telecomwinkel","Telefoon",{"v":123,"d":"€ 123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","Kantoor-benodigdheden",{"v":99,"d":"€ 99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"De Verzekeraar","Autoverzekering",{"v":100,"d":"€ 100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"De Bank","Hypotheek",{"v":1200,"d":"€ 1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","Kantoor-benodigdheden",{"v":128,"d":"€ 128.00"}]
[null,"Totalen",{"$nulls":3},{"$f":"SUBTOTAL(109,Register[Bedrag])","v":{"v":6121,"d":"€ 6,121.00"}}]