{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["gegevens","fact","deb","lijst"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"gegevens","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["naam","Demo bedrijf"]
["adres","Oefenlaan 99"]
["postcode","9999 XX","woonplaats","WIJNJEWOUDE"]
[null,null,null,null,null,null,"Weinterp 60"]
["telefoon","0516 480 993",null,null,null,null,"9241 HE  Wijnjewoude"]
["e-mail","oefenmail@demo.nl"]
["KvK",999888777,null,null,null,null,"tel. 0516 480 993"]
["btw nr.","NL.123 456 782.B01",null,null,null,null,"e-mail info@boumaadmin.nl"]
["iban","NL99INGB000999999"]
["website","demo.nl"]
["Naam ondertekening","Demo van Demo's"]
[null,null,null,null,null,"Voorbeeld Logo"]
["jaar",2018]
[]
["nummer 1e fact.",2018023]
[]
["hoofdmap facturen","C:\\docutest\\test"]
["te gebruiken map","C:\\docutest\\test\\2018\\"]
["btw percentages",0.21]
[null,0.06]
[null,"geen"]
[null,"marge"]
[null,"verlegd"]
[]
[null,"Onderstaand kan uw logo worden geplakt en in hetjuiste formaat worden gezet."]
[null,"Indien geen logo dan wordt de naam van uw bedrijf bovenaan de factuur getoond"]
["Logo"]

{"sheet":"fact","index":1,"n_rows":3332,"n_cols":17,"rows_kept":3332,"cut":false,"hidden":false,"merged":[[8,6,9,8],[9,1,9,2],[10,1,10,2],[55,3,55,6],[0,0,3,4],[19,2,19,3],[17,2,17,3],[18,2,18,3],[7,1,7,2],[108,3,108,6],[107,3,107,4],[51,3,51,4],[52,3,52,4],[54,3,54,4],[106,3,106,4],[66,6,67,8],[58,0,61,4],[104,3,104,4],[105,3,105,4],[75,2,75,3],[76,2,76,3],[77,2,77,3],[67,1,67,2],[68,1,68,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"gegevens!B12","v":"Demo van Demo's"}]
[]
[]
[{"$f":"gegevens!B2","v":"Demo bedrijf"}]
[{"$f":"gegevens!B3","v":"Oefenlaan 99"}]
[{"$f":"gegevens!B4&\" \"&gegevens!D4","v":"9999 XX WIJNJEWOUDE"}]
["tel.",{"$f":"gegevens!B6","v":"0516 480 993"}]
["e-mail",{"$f":"gegevens!B7","v":"oefenmail@demo.nl"},null,null,null,null,{"$f":"VLOOKUP($C$19,deb!A:J,3,FALSE)","v":"debiteur oefen 1"},null,null,null,null,null,"pad",{"$f":"gegevens!B18&\"\\\"&gegevens!B14&\"\\\"","v":"C:\\docutest\\test\\2018\\"}]
["b.t.w. no.",{"$f":"gegevens!B9","v":"NL.123 456 782.B01"},null,null,null,null,null,null,null,null,null,null,"1e factuur no.",18100]
["k.v.k. nr",{"$f":"gegevens!B8","v":999888777},null,null,null,null,{"$f":"VLOOKUP($C$19,deb!A:J,7,FALSE)","v":"de heer Demo"},null,null,null,null,null,"aantal fact.",{"$f":"COUNT(lijst!A:A)","v":1}]
[null,null,null,null,null,null,{"$f":"VLOOKUP($C$19,deb!$A:J,8,FALSE)","v":"Postbus 9999"},null,null,null,null,null,"naam",{"$f":"VLOOKUP(C19,deb!A:B,2,FALSE)","v":"debit32"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP($C$19,deb!$A:J,9,FALSE)","v":"9999  YY"},{"$f":"VLOOKUP($C$19,deb!$A:J,10,FALSE)","v":"OEFENSTAD"},null,null,null,null,"jaar",2018]
[null," ",null,null,null,null,null,null,null,null,null,null,"opslaan als",{"$f":"\"Factuur \"&C18&\"   \"&N12","v":"Factuur 18101   debit32"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2e mail"]
[" "," ",null,null,null,null,null,null,null,null,null,null,"Email",{"$f":"VLOOKUP(C19,deb!A4:D25,4,FALSE)","v":"info@demo.nl"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"CC"]
["faktuurno",null,{"$f":"N10+N11","v":18101}]
["debiteuren no.",null,1000]
["fakt. Datum",null,{"$f":"TODAY()","v":"2018-07-20"}]
[]
["Hierbij berekenen wij u voor onderstaande diensten"]
[null," "]
["art. no","omschrijving",null,null,null,null,"aantal","per stuk","bedrag","btw"]
[null,"Demo artikel",null,null,null,null,1,10,{"$f":"IFERROR(G25*H25,0)","v":10},0.21]
[null,"klein materiaal",null,null,null,null,1,25,{"$f":"IFERROR(G26*H26,0)","v":25},0.06]
[null,"gebruikt materiaal",null,null,null,null,1,223,223,"verlegd"]
[null,null,null,null,null,null,1,111,111,"marge"]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K48","v":0}]
[null,"Transport ---------------------------------------------------------------------",null,null,null,null,null,null,{"$f":"SUM(I25:I46)","v":369},null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K48","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K49","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K49","v":0}]
["btw",{"$f":"gegevens!B20","v":0.21},{"$f":"IFERROR(SUMIF($J$25:$J$47,B52,$I$25:$I$47),0)","v":10},{"$f":"IF(B52>0,ROUND(C52*B52,2))","v":2.1},null,null,null,null,null,null,{"$f":"K53","v":1}]
[null,{"$f":"gegevens!B21","v":0.06},{"$f":"IFERROR(SUMIF($J$25:$J$47,B53,$I$25:$I$47),0)","v":25},{"$f":"IF(B53>0,ROUND(C53*B53,2))","v":1.5},null,null,null,null,{"$f":"SUM(I25:I46)","v":369},null,1]
[null,{"$f":"gegevens!B23","v":"marge"},{"$f":"IFERROR(SUMIF($J$25:$J$47,B54,$I$25:$I$47),0)","v":111},null,null,null,"btw",null,{"$f":"SUM(D48:D53)","v":3.6},null,{"$f":"K53","v":1}]
[null,{"$f":"gegevens!B22","v":"geen"},{"$f":"IFERROR(SUMIF($J$25:$J$47,B55,$I$25:$I$47),0)","v":0},null,null,null,"Te betalen……..",null,{"$f":"SUM(I53:I54)","v":372.6},null,{"$f":"K54","v":1}]
[null,{"$f":"gegevens!B24","v":"verlegd"},{"$f":"IFERROR(SUMIF($J$25:$J$47,B56,$I$25:$I$47),0)","v":223},{"$f":"IF(C56<>0,\"btw nummer  \"&VLOOKUP(C19,deb!A:F,6,FALSE),\"\")","v":"btw nummer  nl 051648555B01"},null,null,null,null,null,null,{"$f":"K55","v":1}]
[null,null,{"$f":"IF(SUM(C48:C56)=I53,\"\",\"FOUT, niet overal btw veld ingevuld\")","v":""}]
[{"$f":"gegevens!A10& \" \"&gegevens!B10","v":"iban NL99INGB000999999"},null,null,null,{"$f":"gegevens!A9&\" \"&gegevens!B9","v":"btw nr. NL.123 456 782.B01"},null,null,{"$f":"gegevens!A11&\" \"&gegevens!B11","v":"website demo.nl"}]
[{"$f":"A1","v":0},null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K59","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K60","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A6","v":"Oefenlaan 99"},null,null,null,null,null,null,null,null,null,0]
[{"$f":"A7","v":"9999 XX WIJNJEWOUDE"},null,null,null,null,null,null,null,null,null,0]
["tel.",{"$f":"B8","v":"0516 480 993"},null,null,null,null,null,null,null,null,0]
["e-mail",{"$f":"B9","v":"oefenmail@demo.nl"},null,null,null,null,{"$f":"G9","v":"debiteur oefen 1"},null,null,null,0]
["Becon nr.","NL.123 456 782.B01",null,null,null,null,null,null,null,null,0]
["k.v.k. nr",999888777,null,null,null,null,{"$f":"G11","v":"de heer Demo"},null,null,null,0]
[null,null,null,null,null,null,{"$f":"G12","v":"Postbus 9999"},null,null,null,0]
[null,null,null,null,null,null,{"$f":"G13","v":"9999  YY"},{"$f":"H13","v":"OEFENSTAD"},null,null,0]
[null," ",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[" "," ",null,null,null," ",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["faktuurno",null,{"$f":"C18","v":18101},null,null,null,null,null,"Pagina 2/2",null,0]
["debiteuren no.",null,{"$f":"C19","v":1000},null,null,null,null,null,null,null,0]
["fakt. Datum",null,{"$f":"C20","v":"2018-07-20"},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Hierbij berekenen wij u voor onderstaande diensten",null,null,null,null,null,null,{"$f":"IF(H22>0,H22,\"\")","v":""},null,null,0]
[null," ",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"bedrag",null,0]
[null,null,null,null,null,null,null,null,{"$f":"I48","v":369},null,0]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(G84*H84,0)","v":0},null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
["btw",{"$f":"gegevens!B20","v":0.21},{"$f":"IFERROR(SUMIF($J$84:$J$104,B105,$I$84:$I$104)+C52,0)","v":10},{"$f":"IF(B105>0,ROUND(B105*C105,2))","v":2.1},null,null,null,null,null,null,0]
[null,{"$f":"gegevens!B21","v":0.06},{"$f":"IFERROR(SUMIF($J$84:$J$104,B106,$I$84:$I$104)+C53,0)","v":25},{"$f":"IF(B106>0,ROUND(B106*C106,2))","v":1.5},null,null,null,null,{"$f":"SUM(I83:I104)","v":369},null,0]
[null,{"$f":"gegevens!B23","v":"marge"},{"$f":"IFERROR(SUMIF($J$84:$J$104,B107,$I$84:$I$104)+C54,0)","v":111},null,null,null,"btw",null,{"$f":"SUM(D105:D106)","v":3.6},null,0]
[null,{"$f":"gegevens!B22","v":"geen"},{"$f":"IFERROR(SUMIF($J$84:$J$104,B108,$I$84:$I$104)+C55,0)","v":0}," ",null,null,"Te betalen……..",null,{"$f":"SUM(I106:I107)","v":372.6},null,0]
[null,{"$f":"gegevens!B24","v":"verlegd"},{"$f":"IFERROR(SUMIF($J$84:$J$104,B109,$I$84:$I$104)+C56,0)","v":223},{"$f":"IF(C109<>0,\"btw nummer  \"&VLOOKUP(C19,deb!A:F,6,FALSE),\"\")","v":"btw nummer  nl 051648555B01"},null,null,null,null,null,null,0]
[null,null,{"$f":"IF(SUM(C105:C109)=I106,\"\",\"FOUT een btw code niet ingevuld\")","v":""},null,null,null,null,null,null,null,0]
[{"$f":"A58","v":"iban NL99INGB000999999"},null,null,null,{"$f":"E58","v":"btw nr. NL.123 456 782.B01"},null,null,{"$f":"H58","v":"website demo.nl"},null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,7]

{"sheet":"deb","index":2,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["deb.nr","zoek code","naam","e-mail","2e email","btw nummer","tav","adres","postcode","plaats"]
[]
[]
[1000,"debit32","debiteur oefen 1","info@demo.nl"," ","nl 051648555B01","de heer Demo","Postbus 9999","9999  YY","OEFENSTAD"]
[2000,"debit22","debiteur oefen 2","info@oefen.nl",null,null,null,null,"8999 xx","demostad"]

{"sheet":"lijst","index":3,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Deb.Nr","Naam","Naam","Fact.nr","Datum","Bedrag",{"$f":"TODAY()","v":"2018-07-20"},{"$f":"MAX(D:D)","v":18100},{"$f":"VLOOKUP(H1,D:F,2,FALSE)","v":"2018-05-15"},{"$f":"G1-I1","v":66}]
[1000,"debit32","debiteur oefen 1",18100,"2018-05-15",372.6]