{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["kiezen_bestuur","stemming","vve"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"kiezen_bestuur","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["kandidaten","voor ","%","verkozenen"]
[null,null,{"$f":"IF(B4<>\"\",B4/SUM($B$4:$B$14),\"\")","v":""},null,null,null,"plaats een X naast het codenummer bij de juiste kandidaat"]
[]
[null,null,{"$f":"IF(B6<>\"\",B6/SUM($B$4:$B$14),\"\")","v":""}]
[null,null,null,null,null,16]
[null,null,null,null,null,12]
[null,null,null,null,null,8]
[null,null,null,null,null,48]
[null,null,null,null,null,24]
[null,null,null,null,null,40]
[null,null,null,null,null,4]
[null,null,null,null,null,28]
[null,null,null,null,null,36]
[null,null,null,null,null,56]
[null,null,null,null,null,20]
[null,null,null,null,null,44]
[null,null,null,null,null,52]
[null,null,null,null,null,60]
[null,null,null,null,null,32]

{"sheet":"stemming","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Voorstel 1"]
[null,"voor ","tegen","onthouding"]
["voorstel 1",null,null,null,{"$f":"IF(B4<>\"\",IF(B4>C4,\"Aanvaard\",\"Verworpen\"),\"\")","v":""},null,"plaats een X naast het codenummer"]
["voorstel 2",null,null,null,{"$f":"IF(B5<>\"\",IF(B5>C5,\"Aanvaard\",\"Verworpen\"),\"\")","v":""}]
["voorstel 3",null,null,null,"",null,"voor","tegen","onth."]
["voorstel 4",null,null,null,"",16]
["voorstel 5",null,null,null,{"$f":"IF(B8<>\"\",IF(B8>C8,\"Aanvaard\",\"Verworpen\"),\"\")","v":""},12]
["voorstel 6",null,null,null,"",8]
["voorstel 7",null,null,null,"",48]
["voorstel 8",null,null,null,"",24]
["voorstel 9",null,null,null,"",40]
["voorstel 10",null,null,null,"",4]
["voorstel 11",null,null,null,"",28]
[null,null,null,null,null,36]
[null,null,null,null,null,56]
[null,null,null,null,null,20]
[null,null,null,null,null,44]
[null,null,null,null,null,52]
[null,null,null,null,null,60]
[null,null,null,null,null,32]

{"sheet":"vve","index":2,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["huisnr","naam","code","deel","voor","tegen","onth.",1,"voor","tegen","onth."]
[1,"Jan",16,135,{"$f":"IF(stemming!G7<>\"\",VLOOKUP(stemming!$F7,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H7<>\"\",VLOOKUP(stemming!$F7,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I7<>\"\",VLOOKUP(stemming!$F7,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[3,"klaas",12,140,{"$f":"IF(stemming!G8<>\"\",VLOOKUP(stemming!$F8,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H8<>\"\",VLOOKUP(stemming!$F8,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I8<>\"\",VLOOKUP(stemming!$F8,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[5,null,8,138,{"$f":"IF(stemming!G9<>\"\",VLOOKUP(stemming!$F9,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H9<>\"\",VLOOKUP(stemming!$F9,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I9<>\"\",VLOOKUP(stemming!$F9,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[7,null,48,138,{"$f":"IF(stemming!G10<>\"\",VLOOKUP(stemming!$F10,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H10<>\"\",VLOOKUP(stemming!$F10,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I10<>\"\",VLOOKUP(stemming!$F10,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[9,null,24,125,{"$f":"IF(stemming!G11<>\"\",VLOOKUP(stemming!$F11,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H11<>\"\",VLOOKUP(stemming!$F11,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I11<>\"\",VLOOKUP(stemming!$F11,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[11,null,40,90,{"$f":"IF(stemming!G12<>\"\",VLOOKUP(stemming!$F12,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H12<>\"\",VLOOKUP(stemming!$F12,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I12<>\"\",VLOOKUP(stemming!$F12,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[13,null,4,113,{"$f":"IF(stemming!G13<>\"\",VLOOKUP(stemming!$F13,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H13<>\"\",VLOOKUP(stemming!$F13,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I13<>\"\",VLOOKUP(stemming!$F13,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[15,null,28,103,{"$f":"IF(stemming!G14<>\"\",VLOOKUP(stemming!$F14,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H14<>\"\",VLOOKUP(stemming!$F14,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I14<>\"\",VLOOKUP(stemming!$F14,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[17,null,36,113,{"$f":"IF(stemming!G15<>\"\",VLOOKUP(stemming!$F15,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H15<>\"\",VLOOKUP(stemming!$F15,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I15<>\"\",VLOOKUP(stemming!$F15,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[19,null,56,88,{"$f":"IF(stemming!G16<>\"\",VLOOKUP(stemming!$F16,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H16<>\"\",VLOOKUP(stemming!$F16,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I16<>\"\",VLOOKUP(stemming!$F16,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[21,null,20,113,{"$f":"IF(stemming!G17<>\"\",VLOOKUP(stemming!$F17,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H17<>\"\",VLOOKUP(stemming!$F17,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I17<>\"\",VLOOKUP(stemming!$F17,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[23,null,44,110,{"$f":"IF(stemming!G18<>\"\",VLOOKUP(stemming!$F18,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H18<>\"\",VLOOKUP(stemming!$F18,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I18<>\"\",VLOOKUP(stemming!$F18,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[25,null,52,98,{"$f":"IF(stemming!G19<>\"\",VLOOKUP(stemming!$F19,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H19<>\"\",VLOOKUP(stemming!$F19,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I19<>\"\",VLOOKUP(stemming!$F19,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[27,"Hans",60,113,{"$f":"IF(stemming!G20<>\"\",VLOOKUP(stemming!$F20,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H20<>\"\",VLOOKUP(stemming!$F20,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I20<>\"\",VLOOKUP(stemming!$F20,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[null,"V.v.E.",32,10,{"$f":"IF(stemming!G21<>\"\",VLOOKUP(stemming!$F21,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!H21<>\"\",VLOOKUP(stemming!$F21,vve!$C$2:$D$16,2,0),\"\")","v":""},{"$f":"IF(stemming!I21<>\"\",VLOOKUP(stemming!$F21,vve!$C$2:$D$16,2,0),\"\")","v":""},null,"","",""]
[null,null,null,{"$f":"SUM(D2:D16)","v":1627},{"$f":"SUM(E2:E16)","v":0},{"$f":"SUM(F2:F16)","v":0},0,null,0,0,0,null,{"$f":"SUM(M2:M16)","v":0},{"$f":"SUM(N2:N16)","v":0},0,null,{"$f":"SUM(Q2:Q16)","v":0},{"$f":"SUM(R2:R16)","v":0},0,null,{"$f":"SUM(U2:U16)","v":0},{"$f":"SUM(V2:V16)","v":0},0]
[null,null,null,null,{"$f":"IF(E17>0,E17/SUM($L$22:$N$22),0)","v":0},{"$f":"IF(F17>0,F17/SUM($L$22:$N$22),0)","v":0},{"$f":"IF(G17>0,G17/SUM($L$22:$N$22),0)","v":0}]
[]
[]
[]
["kiezen bestuur"]
["Plaats een X voor de naam van de kandidaat en druk op KLAARMAKEN VOOR EERSTE STEMRONDE."]
[]
["kandidaat","huisnr","naam","code","deel"]
[null,1,"Jan",16,135]
[null,3,"klaas",12,140]
[null,5,"Gerrit",8,138]
[null,7,"Cees",48,138]
[null,9,"Piet",24,125]
[null,11,"André",40,90]
[null,13,"Peter",4,113]
[null,15,"Robert",28,103]
[null,17,"Ria",36,113]
[null,19,"Petra",56,88]
[null,21,"Joop",20,113]
[null,23,"Ruud",44,110]
[null,25,"Carla",52,98]
[null,27,"Hans",60,113]
[null,null,"V.v.E.",32,10]
[null,null,null,null,{"$f":"SUM(E26:E40)","v":1627}]