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

{"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":""},null,"Bij vergissing dubbelklik op het codenummer om de ingave te wissen"]
["voorstel 3",null,null,null,"",null,"voor","tegen","onth."]
["voorstel 4",null,null,null,"",4]
["voorstel 5",null,null,null,{"$f":"IF(B8<>\"\",IF(B8>C8,\"Aanvaard\",\"Verworpen\"),\"\")","v":""},8]
["voorstel 6",null,null,null,"",44]
["voorstel 7",null,null,null,"",32]
["voorstel 8",null,null,null,"",40]
["voorstel 9",null,null,null,{"$f":"IF(B12<>\"\",IF(B12>C12,\"Aanvaard\",\"Verworpen\"),\"\")","v":""},36]
["voorstel 10",null,null,null,"",60]
["voorstel 11",null,null,null,"",12]
[null,null,null,null,null,28]
[null,null,null,null,null,20]
[null,null,null,null,null,52]
[null,null,null,null,null,48]
[null,null,null,null,null,56]
[null,null,null,null,null,16]
[null,null,null,null,null,24]

{"sheet":"vve","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["huisnr","naam","code","deel","voor","tegen","onth."]
[1,"Jan",4,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":""}]
[3,"klaas",8,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":""}]
[5,"Gerrit",44,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":""}]
[7,"Cees",32,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":""}]
[9,"Piet",40,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":""}]
[11,"André",36,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":""}]
[13,"Peter",60,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":""}]
[15,"Robert",12,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":""}]
[17,"Ria",28,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":""}]
[19,"Petra",20,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":""}]
[21,"Joop",52,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":""}]
[23,"Ruud",48,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":""}]
[25,"Carla",56,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":""}]
[27,"Hans",16,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,"V.v.E.",24,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,{"$f":"SUM(D2:D16)","v":1627},{"$f":"SUM(E2:E16)","v":0},{"$f":"SUM(F2:F16)","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"]
["x",1,"Jan",4,135]
["x",3,"klaas",8,140]
["x",5,"Gerrit",44,138]
["x",7,"Cees",32,138]
["x",9,"Piet",40,125]
["x",11,"André",36,90]
["x",13,"Peter",60,113]
["x",15,"Robert",12,103]
[null,17,"Ria",28,113]
[null,19,"Petra",20,88]
[null,21,"Joop",52,113]
[null,23,"Ruud",48,110]
[null,25,"Carla",56,98]
[null,27,"Hans",16,113]
[null,null,"V.v.E.",24,10]
[null,null,null,null,{"$f":"SUM(E26:E40)","v":1627}]

{"sheet":"afvalbk","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["kandidaten","voor ","%","afvallers"]
[null,null,null,null,null,null,"plaats een X naast het codenummer bij de juiste kandidaat"]
[]
[]
[null,null,null,null,null,4]
[null,null,null,null,null,8]
[null,null,null,null,null,44]
[null,null,null,null,null,32]
[null,null,null,null,null,40]
[null,null,null,null,null,36]
[null,null,null,null,null,60]
[null,null,null,null,null,12]
[null,null,null,null,null,28]
[null,null,null,null,null,20]
[null,null,null,null,null,52]
[null,null,null,null,null,48]
[null,null,null,null,null,56]
[null,null,null,null,null,16]
[null,null,null,null,null,24]