{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Resultaten","Gegevens"],"not_rendered":{"charts":0,"images":0,"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":"Resultaten","index":0,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["willekeurig ","Vóór","Tegen","Onthouding"]
["getal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkwijze:"]
[{"$f":"Gegevens!$D7","v":15},"x",null,"x",{"$f":"IF($B4<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A4,Gegevens!$D$7:$D$20,0),1),\"\")","v":135},{"$f":"IF($C4<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A4,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D4<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A4,Gegevens!$D$7:$D$20,0),1),\"\")","v":135}]
[{"$f":"Gegevens!$D8","v":22},null,"x",null,{"$f":"IF($B5<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A5,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C5<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A5,Gegevens!$D$7:$D$20,0),1),\"\")","v":140},{"$f":"IF($D5<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A5,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},null,null,null,null,null,null,"Maak het gegevensblad zichtbaar door op de knop te klikken en het juiste paswoord in te geven. Wijzig dan de willekeurige getallen."]
[{"$f":"Gegevens!$D9","v":42},null,null,"x",{"$f":"IF($B6<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A6,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C6<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A6,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D6<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A6,Gegevens!$D$7:$D$20,0),1),\"\")","v":138}]
[{"$f":"Gegevens!$D10","v":12},"x",null,null,{"$f":"IF($B7<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A7,Gegevens!$D$7:$D$20,0),1),\"\")","v":138},{"$f":"IF($C7<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A7,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D7<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A7,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},null,null,null,null,null,null,"De huidige code is a1b2c3 maar deze kan je altijd wijzigen in de achterliggende code."]
[{"$f":"Gegevens!$D11","v":55},null,"x",null,{"$f":"IF($B8<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A8,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C8<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A8,Gegevens!$D$7:$D$20,0),1),\"\")","v":125},{"$f":"IF($D8<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A8,Gegevens!$D$7:$D$20,0),1),\"\")","v":""}]
[{"$f":"Gegevens!$D12","v":17},null,null,"x",{"$f":"IF($B9<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A9,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C9<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A9,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D9<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A9,Gegevens!$D$7:$D$20,0),1),\"\")","v":90},null,null,null,null,null,null,"Deze worden automatisch overgenomen op blad Resultaten kolom A."]
[{"$f":"Gegevens!$D13","v":88},"x",null,null,{"$f":"IF($B10<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A10,Gegevens!$D$7:$D$20,0),1),\"\")","v":113},{"$f":"IF($C10<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A10,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D10<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A10,Gegevens!$D$7:$D$20,0),1),\"\")","v":""}]
[{"$f":"Gegevens!$D14","v":67},null,"x",null,{"$f":"IF($B11<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A11,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C11<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A11,Gegevens!$D$7:$D$20,0),1),\"\")","v":103},{"$f":"IF($D11<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A11,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},null,null,null,null,null,null,"Verberg het blad Gegevens met knop."]
[{"$f":"Gegevens!$D15","v":93},null,null,"x",{"$f":"IF($B12<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A12,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C12<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A12,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D12<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A12,Gegevens!$D$7:$D$20,0),1),\"\")","v":113}]
[{"$f":"Gegevens!$D16","v":19},"x",null,null,{"$f":"IF($B13<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A13,Gegevens!$D$7:$D$20,0),1),\"\")","v":88},{"$f":"IF($C13<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A13,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D13<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A13,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},null,null,null,null,null,null,"Zet nu bij elk getal de uitgebrachte stem in de overeenkomstige kolom. De berekeningen worden gemaakt in de verborgen kolommen E tot F,"]
[{"$f":"Gegevens!$D17","v":47},null,"x",null,{"$f":"IF($B14<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A14,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C14<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A14,Gegevens!$D$7:$D$20,0),1),\"\")","v":113},{"$f":"IF($D14<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A14,Gegevens!$D$7:$D$20,0),1),\"\")","v":""}]
[{"$f":"Gegevens!$D18","v":11},null,null,"x",{"$f":"IF($B15<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A15,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C15<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A15,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D15<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A15,Gegevens!$D$7:$D$20,0),1),\"\")","v":110},null,null,null,null,null,null,"en de resultaten komen in de cellen B20 tot E20."]
[{"$f":"Gegevens!$D19","v":83},"x",null,null,{"$f":"IF($B16<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A16,Gegevens!$D$7:$D$20,0),1),\"\")","v":98},{"$f":"IF($C16<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A16,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($D16<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A16,Gegevens!$D$7:$D$20,0),1),\"\")","v":""}]
[{"$f":"Gegevens!$D20","v":72},null,"x",null,{"$f":"IF($B17<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A17,Gegevens!$D$7:$D$20,0),1),\"\")","v":""},{"$f":"IF($C17<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A17,Gegevens!$D$7:$D$20,0),1),\"\")","v":113},{"$f":"IF($D17<>\"\",INDEX(Gegevens!$C$7:$D$20,MATCH($A17,Gegevens!$D$7:$D$20,0),1),\"\")","v":""}]
[]
["Totaal","Vóór","Tegen","Onthouding"]
[{"$f":"Gegevens!$C$22","v":1627},{"$f":"SUM(E4:E17)","v":572},{"$f":"SUM(F4:F17)","v":594},{"$f":"SUM(G4:G17)","v":586}]
[]
[null,"Stemgedrag",null,null,null,null,null,null,"Stemmen aantal"]
["Voor",null,{"$f":"COUNTA(B4:B17)","v":5},null,null,null,null,"Uitgebrachte stemmen",null,{"$f":"COUNTA($B$4:$D$17)","v":15}]
["Tegen",null,{"$f":"COUNTA(C4:C17)","v":5},null,null,null,null,"Totaal stemmen",null,{"$f":"COUNTA($A$4:$A$17)","v":14}]
["Onthouding",null,{"$f":"COUNTA(D4:D17)","v":5}]

{"sheet":"Gegevens","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["a1b2c3"]
[]
[null,null,null,null,null,null,null,null,null,"Geheim stemmen. De enige die een naam kan weten is degene die de stembriefjes uit deelt want het willekeurig getal hoort bij de persoon die in die rij"]
[null,null,null,"willekeurig ","Vóór","Tegen",null,null,null,"genoemd is. De willekeurige getallen wijzigen elke vergadering."]
[null,null,null,"getal",null,null,null,null,null," In kolom D komt bij elke stemming een ander willkeurig getal."]
[null,null,null,null,null,null,null,null,null,"De stembriefjes worden uitgedeeld met het nummer uit kolom D aan de persoon die voorkomt in die rij."]
[1,"Jan",135,15,null,null,null,null,null,"Het rekenprogramma zoekt het nummer uit kolom D die in dezelfde rij uit kolom A moet zien."]
[3,"klaas",140,22]
[5,"Gerrit",138,42,null,null,null,null,null,"Het getal 1 hoort bij getal 135; het getal 3 hoort bij 140 enz. enz."]
[7,"Cees",138,12,null,null,null,null,null,"Het getal onder kolom C uit de rij van dat willekeurige nummer moet ingevuld worden bij Vóór of Tegen."]
[9,"Piet",125,55]
[11,"André",90,17,null,null,null,null,null,"Voorbeeld:"]
[13,"Peter",113,88,null,null,null,null,null,"Er zijn minimaal 2 kolommen extra nodig nl. vóór en een tegen kolom"]
[15,"Robert",103,67,null,null,null,null,null,"Onder een keuzemenu ik geef nummer 12 in en die hoort bij huisnummer 7."]
[17,"Ria",113,93,null,null,null,null,null,"stemt die vóór dan moet er in de kolom het getal 138 uit kolom C worden weggeschreven in kolom Vóór (E)"]
[19,"Petra",88,19]
[21,"Joop",113,47,null,null,null,null,null,"Stemt willekeurig getal 47 tegen dan wordt gekeken naar nummer 27 onder kolom A zodat het getal 113 in kolom C terecht komt in kolom (F) Tegen."]
[23,"Ruud",110,11]
[25,"Carla",98,83,null,null,null,null,null,"NB. 1 t/27 stellen de huisnummers voor die hoort bij de naam die er naast staat"]
[27,"Hans",113,72]
[null,"V.v.E.",10]
[null,null,{"$f":"SUM(C7:C21)","v":1627},null,{"$f":"SUM(E7:E20)","v":0},{"$f":"SUM(F7:F20)","v":0}]