{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Voorblad","Vb1","Vb2","BSN"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Voorblad","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  Elf-proef"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2016, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Vb1","index":1,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["BankNr","ElfPrfFn","ElfProef","Get1","Rest","Get2","Rest","Get3","Rest","Get4","Rest","Get5","Rest","Get6","Rest","Get7","Rest","Get8","Rest","Get9","Rest","Get10"]
[736160221,{"$f":"ElfProef1(A2)","v":"ok"},{"$f":"IF(MOD(D2*1+F2*2+H2*3+J2*4+L2*5+N2*6+P2*7+R2*8+T2*9+V2*10,11)=0,\"ok\",\"Geen juist nr\")","v":"ok"},{"$f":"MOD(A2,10)","v":1},{"$f":"TRUNC(A2/10)","v":73616022},{"$f":"MOD(E2,10)","v":2},{"$f":"TRUNC(E2/10)","v":7361602},{"$f":"MOD(G2,10)","v":2},{"$f":"TRUNC(G2/10)","v":736160},{"$f":"MOD(I2,10)","v":0},{"$f":"TRUNC(I2/10)","v":73616},{"$f":"MOD(K2,10)","v":6},{"$f":"TRUNC(K2/10)","v":7361},{"$f":"MOD(M2,10)","v":1},{"$f":"TRUNC(M2/10)","v":736},{"$f":"MOD(O2,10)","v":6},{"$f":"TRUNC(O2/10)","v":73},{"$f":"MOD(Q2,10)","v":3},{"$f":"TRUNC(Q2/10)","v":7},{"$f":"MOD(S2,10)","v":7},{"$f":"TRUNC(S2/10)","v":0},{"$f":"MOD(U2,10)","v":0}]
[736160222,{"$f":"ElfProef1(A3)","v":"ONGELDIG"},"Geen juist nr",{"$f":"MOD(A3,10)","v":2},{"$f":"TRUNC(A3/10)","v":73616022},{"$f":"MOD(E3,10)","v":2},{"$f":"TRUNC(E3/10)","v":7361602},{"$f":"MOD(G3,10)","v":2},{"$f":"TRUNC(G3/10)","v":736160},{"$f":"MOD(I3,10)","v":0},{"$f":"TRUNC(I3/10)","v":73616},{"$f":"MOD(K3,10)","v":6},{"$f":"TRUNC(K3/10)","v":7361},{"$f":"MOD(M3,10)","v":1},{"$f":"TRUNC(M3/10)","v":736},{"$f":"MOD(O3,10)","v":6},{"$f":"TRUNC(O3/10)","v":73},{"$f":"MOD(Q3,10)","v":3},{"$f":"TRUNC(Q3/10)","v":7},{"$f":"MOD(S3,10)","v":7},{"$f":"TRUNC(S3/10)","v":0},{"$f":"MOD(U3,10)","v":0}]
[736160223,{"$f":"ElfProef1(A4)","v":"ONGELDIG"},"Geen juist nr",{"$f":"MOD(A4,10)","v":3},{"$f":"TRUNC(A4/10)","v":73616022},{"$f":"MOD(E4,10)","v":2},{"$f":"TRUNC(E4/10)","v":7361602},{"$f":"MOD(G4,10)","v":2},{"$f":"TRUNC(G4/10)","v":736160},{"$f":"MOD(I4,10)","v":0},{"$f":"TRUNC(I4/10)","v":73616},{"$f":"MOD(K4,10)","v":6},{"$f":"TRUNC(K4/10)","v":7361},{"$f":"MOD(M4,10)","v":1},{"$f":"TRUNC(M4/10)","v":736},{"$f":"MOD(O4,10)","v":6},{"$f":"TRUNC(O4/10)","v":73},{"$f":"MOD(Q4,10)","v":3},{"$f":"TRUNC(Q4/10)","v":7},{"$f":"MOD(S4,10)","v":7},{"$f":"TRUNC(S4/10)","v":0},{"$f":"MOD(U4,10)","v":0}]
[736160224,"ONGELDIG","Geen juist nr",4,73616022,2,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160225,"ONGELDIG","Geen juist nr",5,73616022,2,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160226,"ONGELDIG","Geen juist nr",6,73616022,2,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160227,"ONGELDIG","Geen juist nr",7,73616022,2,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160228,{"$f":"ElfProef1(A9)","v":"ONGELDIG"},"Geen juist nr",8,73616022,2,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160229,"ONGELDIG","Geen juist nr",9,73616022,2,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160230,"ONGELDIG","Geen juist nr",0,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160231,"ONGELDIG","Geen juist nr",1,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160232,"ONGELDIG","Geen juist nr",2,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160233,"ONGELDIG","Geen juist nr",3,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160234,"ONGELDIG","Geen juist nr",4,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160235,"ONGELDIG","Geen juist nr",5,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160236,"ONGELDIG","Geen juist nr",6,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160237,"ONGELDIG","Geen juist nr",7,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160238,"ONGELDIG","Geen juist nr",8,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160239,"ONGELDIG","Geen juist nr",9,73616023,3,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160240,"ONGELDIG","Geen juist nr",0,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160241,"ONGELDIG","Geen juist nr",1,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160242,"ONGELDIG","Geen juist nr",2,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160243,"ONGELDIG","Geen juist nr",3,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160244,"ONGELDIG","Geen juist nr",4,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160245,"ONGELDIG","Geen juist nr",5,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160246,"ONGELDIG","Geen juist nr",6,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160247,"ONGELDIG","Geen juist nr",7,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160248,"ok","ok",8,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160249,"ONGELDIG","Geen juist nr",9,73616024,4,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160250,"ONGELDIG","Geen juist nr",0,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160251,"ONGELDIG","Geen juist nr",1,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160252,"ONGELDIG","Geen juist nr",2,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160253,"ONGELDIG","Geen juist nr",3,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160254,"ONGELDIG","Geen juist nr",4,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160255,"ONGELDIG","Geen juist nr",5,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160256,"ok","ok",6,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160257,"ONGELDIG","Geen juist nr",7,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160258,"ONGELDIG","Geen juist nr",8,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160259,"ONGELDIG","Geen juist nr",9,73616025,5,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160260,"ONGELDIG","Geen juist nr",0,73616026,6,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160261,"ONGELDIG","Geen juist nr",1,73616026,6,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160262,"ONGELDIG","Geen juist nr",2,73616026,6,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160263,"ONGELDIG","Geen juist nr",3,73616026,6,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[736160264,"ok","ok",4,73616026,6,7361602,2,736160,0,73616,6,7361,1,736,6,73,3,7,7,0,0]
[123456789,"ok","ok",9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1,0,0]
[1234567890,"ONGELDIG","Geen juist nr",0,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[{"$f":"A47+1","v":1234567891},"ONGELDIG","Geen juist nr",1,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[{"$f":"A48+1","v":1234567892},"ONGELDIG","Geen juist nr",2,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567893,"ONGELDIG","Geen juist nr",3,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567894,"ONGELDIG","Geen juist nr",4,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567895,"ONGELDIG","Geen juist nr",5,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567896,"ONGELDIG","Geen juist nr",6,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567897,"ONGELDIG","Geen juist nr",7,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567898,"ONGELDIG","Geen juist nr",8,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567899,"ONGELDIG","Geen juist nr",9,123456789,9,12345678,8,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567900,"ONGELDIG","Geen juist nr",0,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567901,"ONGELDIG","Geen juist nr",1,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567902,"ONGELDIG","Geen juist nr",2,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567903,"ok","ok",3,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567904,"ONGELDIG","Geen juist nr",4,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567905,"ONGELDIG","Geen juist nr",5,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567906,"ONGELDIG","Geen juist nr",6,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567907,"ONGELDIG","Geen juist nr",7,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567908,"ONGELDIG","Geen juist nr",8,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567909,"ONGELDIG",{"$f":"IF(MOD(D66*1+F66*2+H66*3+J66*4+L66*5+N66*6+P66*7+R66*8+T66*9+V66*10,11)=0,\"ok\",\"Geen juist nr\")","v":"Geen juist nr"},9,123456790,0,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567910,"ONGELDIG","Geen juist nr",0,123456791,1,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]
[1234567911,{"$f":"ElfProef1(A68)","v":"ok"},"ok",{"$f":"MOD(A68,10)","v":1},{"$f":"TRUNC(A68/10)","v":123456791},{"$f":"MOD(E68,10)","v":1},{"$f":"TRUNC(E68/10)","v":12345679},{"$f":"MOD(G68,10)","v":9},{"$f":"TRUNC(G68/10)","v":1234567},{"$f":"MOD(I68,10)","v":7},{"$f":"TRUNC(I68/10)","v":123456},{"$f":"MOD(K68,10)","v":6},{"$f":"TRUNC(K68/10)","v":12345},{"$f":"MOD(M68,10)","v":5},{"$f":"TRUNC(M68/10)","v":1234},{"$f":"MOD(O68,10)","v":4},{"$f":"TRUNC(O68/10)","v":123},{"$f":"MOD(Q68,10)","v":3},{"$f":"TRUNC(Q68/10)","v":12},{"$f":"MOD(S68,10)","v":2},{"$f":"TRUNC(S68/10)","v":1},{"$f":"MOD(U68,10)","v":1}]
[1234567912,"ONGELDIG","Geen juist nr",2,123456791,1,12345679,9,1234567,7,123456,6,12345,5,1234,4,123,3,12,2,1,1]

{"sheet":"Vb2","index":2,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["BankNr","BankNrTekst","ElfPrfFn","ElfProef",1,2,3,4,5,6,7,8,9,10]
[736160221,{"$f":"RIGHT(\"0000000000\"&A3,10)","v":"0736160221"},{"$f":"ElfProef2(A3)","v":"ok"},{"$f":"IF(MOD(D4,11)=0,\"ok\",\"ONGELDIG\")","v":"ok"},{"$f":"MID($B$3,LEN($B$3)-E2+1,1)+0","v":1},{"$f":"MID($B$3,LEN($B$3)-F2+1,1)+0","v":2},2,0,6,1,6,3,7,0]
[null,{"$f":"RIGHT(REPT(\"0\",10)&A3,10)","v":"0736160221"},"Som",{"$f":"SUM(E4:N4)","v":176},{"$f":"E2*E3","v":1},{"$f":"F2*F3","v":4},6,0,30,6,42,24,63,0]
[null,null,"SomProduct",{"$f":"IF(MOD(SUMPRODUCT(E2:N2,E3:N3),11)=0,\"ok\",\"ONGELDIG\")","v":"ok"}]

{"sheet":"BSN","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"BSN","Controle1","Controle2"]
[null,80671007,{"$f":"ElfProef2(B3)","v":"ONGELDIG"},{"$f":"ElfProef2(B3,TRUE)","v":"ok"}]