{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["2 poules","4 poules","8 poules","deelnemers"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"2 poules","index":0,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,3,52,5],[1,1,1,3],[1,5,1,7],[2,2,2,3],[2,6,2,7],[50,3,50,5],[5,2,5,3],[5,6,5,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[4,6,4,7]]}
[]
[null,"Poule 1",null,null,null,"Poule 2"]
[null,"A","deelnemer 5",null,null,"A","deelnemer 2"]
[null,"B","deelnemer 4",null,null,"B","deelnemer 8"]
[null,"C","deelnemer 7",null,null,"C","deelnemer 1"]
[null,"D","deelnemer 6",null,null,"D","deelnemer 3"]
[]
[null,"Wedstrijd 1",null,null,null,"Wedstrijd 1"]
[null,"A",{"$f":"C3","v":"deelnemer 5"},3,null,"A",{"$f":"G3","v":"deelnemer 2"},1,{"$f":"IF(H9=3,2,0)","v":0}]
[null,"B",{"$f":"C4","v":"deelnemer 4"},0,null,"B",{"$f":"G4","v":"deelnemer 8"},3,{"$f":"IF(H10=3,2,0)","v":2}]
[null,"C",{"$f":"C5","v":"deelnemer 7"},3,null,"C",{"$f":"G5","v":"deelnemer 1"},2,0]
[null,"D",{"$f":"C6","v":"deelnemer 6"},1,null,"D",{"$f":"G6","v":"deelnemer 3"},3,2]
[null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,0]
[null,"A",{"$f":"C3","v":"deelnemer 5"},2,null,"A",{"$f":"G3","v":"deelnemer 2"},3,2]
[null,"C",{"$f":"C5","v":"deelnemer 7"},3,null,"C",{"$f":"G5","v":"deelnemer 1"},0,3]
[null,"B",{"$f":"C4","v":"deelnemer 4"},1,null,"B",{"$f":"G4","v":"deelnemer 8"},0,0]
[null,"D",{"$f":"C6","v":"deelnemer 6"},3,null,"D",{"$f":"G6","v":"deelnemer 3"},3,2]
[null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,0]
[null,"A",{"$f":"C3","v":"deelnemer 5"},0,null,"A",{"$f":"G3","v":"deelnemer 2"},3,2]
[null,"D",{"$f":"C6","v":"deelnemer 6"},3,null,"D",{"$f":"G6","v":"deelnemer 3"},2,0]
[null,"B",{"$f":"C4","v":"deelnemer 4"},2,null,"B",{"$f":"G4","v":"deelnemer 8"},3,2,"Emiel","de rangschikking en het invullen van de halve finalses zal gebeuren na het invullen van de blauwe cel"]
[null,"C",{"$f":"C5","v":"deelnemer 7"},3,null,"C",{"$f":"G5","v":"deelnemer 1"},0,0]
[]
[null,"Legs","Naam","Punten",null,"Legs","Naam","Punten"]
[null,{"$f":"SUMIF($C$9:$C$22,C25,$D$9:$D$22)","v":9},"deelnemer 7",{"$f":"COUNTIFS($C$9:$C$22,C25,$D$9:$D$22,3)*2","v":6},null,{"$f":"SUMIF($G$9:$G$22,G25,$H$9:$H$22)","v":8},"deelnemer 3",{"$f":"SUMIF($G$9:$G$22,G25,$I$9:$I$22)","v":4}]
[null,{"$f":"SUMIF($C$9:$C$22,C26,$D$9:$D$22)","v":7},"deelnemer 6",{"$f":"COUNTIFS($C$9:$C$22,C26,$D$9:$D$22,3)*2","v":4},null,{"$f":"SUMIF($G$9:$G$22,G26,$H$9:$H$22)","v":7},"deelnemer 2",{"$f":"SUMIF($G$9:$G$22,G26,$I$9:$I$22)","v":4},"<---","Ludo","Hoe je het gedaan hebt weet ik niet maar de rangschikking klopt"]
[null,{"$f":"SUMIF($C$9:$C$22,C27,$D$9:$D$22)","v":5},"deelnemer 5",{"$f":"COUNTIFS($C$9:$C$22,C27,$D$9:$D$22,3)*2","v":2},null,{"$f":"SUMIF($G$9:$G$22,G27,$H$9:$H$22)","v":6},"deelnemer 8",{"$f":"SUMIF($G$9:$G$22,G27,$I$9:$I$22)","v":4}]
[null,{"$f":"SUMIF($C$9:$C$22,C28,$D$9:$D$22)","v":3},"deelnemer 4",{"$f":"COUNTIFS($C$9:$C$22,C28,$D$9:$D$22,3)*2","v":0},null,{"$f":"SUMIF($G$9:$G$22,G28,$H$9:$H$22)","v":2},"deelnemer 1",{"$f":"SUMIF($G$9:$G$22,G28,$I$9:$I$22)","v":3},null,"Ludo","Dit waren de voorrondes, de volgende zijn knockouts, 1 en 2 spelen de A halve ronde en 3 en 4 spelen de B halve finale"]
[]
[null,"Halve finales"]
[null,null,null,null,null,null,null,null,null,"Emiel","Ik heb niet kunnen achterhalen hoe de puntenverdeling in de halve finales gebeurd"]
[null,"A ronde",null,null,null,"B ronde"]
[null,"A1","deelnemer 7",3,null,"A3","deelnemer 5",2]
[null,"B2","deelnemer 2",2,null,"B4","deelnemer 1",3]
[null,null," ",null,null,null," "]
[null,"B1","deelnemer 3",1,null,"B3","deelnemer 8",1]
[null,"A2","deelnemer 6",3,null,"A4","deelnemer 4",3]
[]
[]
[null,"Finales"]
[]
[null,"A ronde",null,null,null,"B ronde"]
[null,"WA1",{"$f":"IF(D33=3,$C$33,$C$34)","v":"deelnemer 7"},null,null,"WC1",{"$f":"IF(H33=3,$G$33,$G$34)","v":"deelnemer 1"}]
[null,"WB1",{"$f":"IF(D34=3,$C$33,$C$34)","v":"deelnemer 2"},null,null,"WC2",{"$f":"IF(H34=3,$G$33,$G$34)","v":"deelnemer 5"}]
[]
[]
[null,null,null,"Ludo","Gaat goed als er geen twee getallen hetzelfde zijn",null,null,null,null,"Ludo","Hoe je het gedaan hebt weet ik niet maar de rangschikking klopt"]
[null,null,null,null,"E soms zijn zowel de punten als de legs hetzelfde"]
[null,null,null,null,"dan nog kijken naar het onderling duel zou ook mooi zijn"]
[]
[null,null,null,3,null,null,{"$f":"IF(D43>D44,C43,C44)","v":"deelnemer 2"},null,null,"Ludo","Deelnemer 5 wint het toernooi!!"]
[]
[null,null,null,1,null,null,{"$f":"IF(H43>H44,G43,G44)","v":"deelnemer 5"}]

{"sheet":"4 poules","index":1,"n_rows":68,"n_cols":17,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7],[1,9,1,11],[1,13,1,15],[2,2,2,3],[2,6,2,7],[2,10,2,11],[2,14,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,2,4,3],[4,6,4,7],[4,10,4,11],[4,14,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15],[7,1,7,3],[7,5,7,7],[7,9,7,11],[7,13,7,15],[12,1,12,3],[12,5,12,7],[12,9,12,11],[12,13,12,15],[17,1,17,3],[17,5,17,7],[17,9,17,11],[17,13,17,15],[29,1,29,11],[65,3,65,5],[67,3,67,5],[55,1,55,11],[45,1,45,11]]}
[]
[null,"Poule 1",null,null,null,"Poule 2",null,null,null,"Poule 3",null,null,null,"Poule 4"]
[null,"A","Jan",null,null,"A","Wim",null,null,"A",null,null,null,"A"]
[null,"B","Kevin",null,null,"B","jo",null,null,"B",null,null,null,"B"]
[null,"C","steve",null,null,"C","dfr",null,null,"C",null,null,null,"C"]
[null,"D","ruben",null,null,"D","gal",null,null,"D",null,null,null,"D"]
[]
[null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1"]
[null,"A",{"$f":"IF(B9=B3,C3,IF(B9=B4,C4,IF(B9=B5,C5,IF(B9=B6,C6))))","v":"Jan"},null,{"$f":"IF(D9=3,2,0)","v":0},"A",{"$f":"IF(F9=F3,G3,IF(F9=F4,G4,IF(F9=F5,G5,IF(F9=F6,G6))))","v":"Wim"},null,{"$f":"IF(H9=3,2,0)","v":0},"A",{"$f":"IF(J9=J3,K3,IF(J9=J4,K4,IF(J9=J5,K5,IF(J9=J6,K6))))","v":0},null,{"$f":"IF(L9=3,2,0)","v":0},"A",{"$f":"IF(N9=N3,O3,IF(N9=N4,O4,IF(N9=N5,O5,IF(N9=N6,O6))))","v":0},null,{"$f":"IF(P9=3,2,0)","v":0}]
[null,"B",{"$f":"IF(B10=B3,C3,IF(B10=B4,C4,IF(B10=B5,C5,IF(B10=B6,C6))))","v":"Kevin"},null,{"$f":"IF(D10=3,2,0)","v":0},"B",{"$f":"IF(F10=F3,G3,IF(F10=F4,G4,IF(F10=F5,G5,IF(F10=F6,G6))))","v":"jo"},null,{"$f":"IF(H10=3,2,0)","v":0},"B",{"$f":"IF(J10=J3,K3,IF(J10=J4,K4,IF(J10=J5,K5,IF(J10=J6,K6))))","v":0},null,{"$f":"IF(L10=3,2,0)","v":0},"B",{"$f":"IF(N10=N3,O3,IF(N10=N4,O4,IF(N10=N5,O5,IF(N10=N6,O6))))","v":0},null,{"$f":"IF(P10=3,2,0)","v":0}]
[null,"C",{"$f":"IF(B11=B3,C3,IF(B11=B4,C4,IF(B11=B5,C5,IF(B11=B6,C6))))","v":"steve"},null,0,"C",{"$f":"IF(F11=F3,G3,IF(F11=F4,G4,IF(F11=F5,G5,IF(F11=F6,G6))))","v":"dfr"},null,0,"C",{"$f":"IF(J11=J3,K3,IF(J11=J4,K4,IF(J11=J5,K5,IF(J11=J6,K6))))","v":0},null,0,"C",{"$f":"IF(N11=N3,O3,IF(N11=N4,O4,IF(N11=N5,O5,IF(N11=N6,O6))))","v":0},null,0]
[null,"D",{"$f":"IF(B12=B3,C3,IF(B12=B4,C4,IF(B12=B5,C5,IF(B12=B6,C6))))","v":"ruben"},null,0,"D",{"$f":"IF(F12=F3,G3,IF(F12=F4,G4,IF(F12=F5,G5,IF(F12=F6,G6))))","v":"gal"},null,0,"D",{"$f":"IF(J12=J3,K3,IF(J12=J4,K4,IF(J12=J5,K5,IF(J12=J6,K6))))","v":0},null,0,"D",{"$f":"IF(N12=N3,O3,IF(N12=N4,O4,IF(N12=N5,O5,IF(N12=N6,O6))))","v":0},null,0]
[null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2"]
[null,"A",{"$f":"IF(B14=B3,C3,IF(B14=B4,C4,IF(B14=B5,C5,IF(B14=B6,C6))))","v":"Jan"},null,0,"A",{"$f":"IF(F14=F3,G3,IF(F14=F4,G4,IF(F14=F5,G5,IF(F14=F6,G6))))","v":"Wim"},null,0,"A",{"$f":"IF(J14=J3,K3,IF(J14=J4,K4,IF(J14=J5,K5,IF(J14=J6,K6))))","v":0},null,0,"A",{"$f":"IF(N14=N3,O3,IF(N14=N4,O4,IF(N14=N5,O5,IF(N14=N6,O6))))","v":0},null,0]
[null,"C",{"$f":"IF(B15=B3,C3,IF(B15=B4,C4,IF(B15=B5,C5,IF(B15=B6,C6))))","v":"steve"},null,0,"C",{"$f":"IF(F15=F3,G3,IF(F15=F4,G4,IF(F15=F5,G5,IF(F15=F6,G6))))","v":"dfr"},null,0,"C",{"$f":"IF(J15=J3,K3,IF(J15=J4,K4,IF(J15=J5,K5,IF(J15=J6,K6))))","v":0},null,0,"C",{"$f":"IF(N15=N3,O3,IF(N15=N4,O4,IF(N15=N5,O5,IF(N15=N6,O6))))","v":0},null,0]
[null,"B",{"$f":"IF(B16=B3,C3,IF(B16=B4,C4,IF(B16=B5,C5,IF(B16=B6,C6))))","v":"Kevin"},null,0,"B",{"$f":"IF(F16=F3,G3,IF(F16=F4,G4,IF(F16=F5,G5,IF(F16=F6,G6))))","v":"jo"},null,0,"B",{"$f":"IF(J16=J3,K3,IF(J16=J4,K4,IF(J16=J5,K5,IF(J16=J6,K6))))","v":0},null,0,"B",{"$f":"IF(N16=N3,O3,IF(N16=N4,O4,IF(N16=N5,O5,IF(N16=N6,O6))))","v":0},null,0]
[null,"D",{"$f":"IF(B17=B3,C3,IF(B17=B4,C4,IF(B17=B5,C5,IF(B17=B6,C6))))","v":"ruben"},null,0,"D",{"$f":"IF(F17=F3,G3,IF(F17=F4,G4,IF(F17=F5,G5,IF(F17=F6,G6))))","v":"gal"},null,0,"D",{"$f":"IF(J17=J3,K3,IF(J17=J4,K4,IF(J17=J5,K5,IF(J17=J6,K6))))","v":0},null,0,"D",{"$f":"IF(N17=N3,O3,IF(N17=N4,O4,IF(N17=N5,O5,IF(N17=N6,O6))))","v":0},null,0]
[null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3"]
[null,"A",{"$f":"IF(B19=B3,C3,IF(B19=B4,C4,IF(B19=B5,C5,IF(B19=B6,C6))))","v":"Jan"},null,0,"A",{"$f":"IF(F19=F3,G3,IF(F19=F4,G4,IF(F19=F5,G5,IF(F19=F6,G6))))","v":"Wim"},null,0,"A",{"$f":"IF(J19=J3,K3,IF(J19=J4,K4,IF(J19=J5,K5,IF(J19=J6,K6))))","v":0},null,0,"A",{"$f":"IF(N19=N3,O3,IF(N19=N4,O4,IF(N19=N5,O5,IF(N19=N6,O6))))","v":0},null,0]
[null,"D",{"$f":"IF(B20=B3,C3,IF(B20=B4,C4,IF(B20=B5,C5,IF(B20=B6,C6))))","v":"ruben"},null,0,"D",{"$f":"IF(F20=F3,G3,IF(F20=F4,G4,IF(F20=F5,G5,IF(F20=F6,G6))))","v":"gal"},null,0,"D",{"$f":"IF(J20=J3,K3,IF(J20=J4,K4,IF(J20=J5,K5,IF(J20=J6,K6))))","v":0},null,0,"D",{"$f":"IF(N20=N3,O3,IF(N20=N4,O4,IF(N20=N5,O5,IF(N20=N6,O6))))","v":0},null,0]
[null,"B",{"$f":"IF(B21=B3,C3,IF(B21=B4,C4,IF(B21=B5,C5,IF(B21=B6,C6))))","v":"Kevin"},null,0,"B",{"$f":"IF(F21=F3,G3,IF(F21=F4,G4,IF(F21=F5,G5,IF(F21=F6,G6))))","v":"jo"},null,0,"B",{"$f":"IF(J21=J3,K3,IF(J21=J4,K4,IF(J21=J5,K5,IF(J21=J6,K6))))","v":0},null,0,"B",{"$f":"IF(N21=N3,O3,IF(N21=N4,O4,IF(N21=N5,O5,IF(N21=N6,O6))))","v":0},null,0]
[null,"C",{"$f":"IF(B22=B3,C3,IF(B22=B4,C4,IF(B22=B5,C5,IF(B22=B6,C6))))","v":"steve"},null,0,"C",{"$f":"IF(F22=F3,G3,IF(F22=F4,G4,IF(F22=F5,G5,IF(F22=F6,G6))))","v":"dfr"},null,0,"C",{"$f":"IF(J22=J3,K3,IF(J22=J4,K4,IF(J22=J5,K5,IF(J22=J6,K6))))","v":0},null,0,"C",{"$f":"IF(N22=N3,O3,IF(N22=N4,O4,IF(N22=N5,O5,IF(N22=N6,O6))))","v":0},null,0]
[]
[null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten"]
[null,{"$f":"SUMIF($C$9:$C$22,C25,$D$9:$D$22)","v":0},{"$f":"C3","v":"Jan"},{"$f":"SUMIF($C$9:$C$22,C25,$E$9:$E$22)","v":0},null,{"$f":"SUMIF($G$9:$G$22,G25,$H$9:$H$22)","v":0},{"$f":"G3","v":"Wim"},{"$f":"SUMIF($G$9:$G$22,G25,$I$9:$I$22)","v":0},null,{"$f":"SUMIF($K$9:$K$22,K25,$L$9:$L$22)","v":0},{"$f":"K3","v":0},{"$f":"SUMIF($K$9:$K$22,K25,$M$9:$M$22)","v":0},null,{"$f":"SUMIF($O$9:$O$22,O25,$P$9:$P$22)","v":0},{"$f":"O3","v":0},{"$f":"SUMIF($O$9:$O$22,O25,$Q$9:$Q$22)","v":0}]
[null,{"$f":"SUMIF($C$9:$C$22,C26,$D$9:$D$22)","v":0},{"$f":"C4","v":"Kevin"},{"$f":"SUMIF($C$9:$C$22,C26,$E$9:$E$22)","v":0},null,{"$f":"SUMIF($G$9:$G$22,G26,$H$9:$H$22)","v":0},{"$f":"G4","v":"jo"},{"$f":"SUMIF($G$9:$G$22,G26,$I$9:$I$22)","v":0},null,{"$f":"SUMIF($K$9:$K$22,K26,$L$9:$L$22)","v":0},{"$f":"K4","v":0},{"$f":"SUMIF($C$9:$C$22,K26,$E$9:$E$22)","v":0},null,{"$f":"SUMIF($O$9:$O$22,O26,$P$9:$P$22)","v":0},{"$f":"O4","v":0},{"$f":"SUMIF($O$9:$O$22,O26,$Q$9:$Q$22)","v":0}]
[null,{"$f":"SUMIF($C$9:$C$22,C27,$D$9:$D$22)","v":0},{"$f":"C5","v":"steve"},{"$f":"SUMIF($C$9:$C$22,C27,$E$9:$E$22)","v":0},null,0,{"$f":"G5","v":"dfr"},0,null,0,{"$f":"K5","v":0},{"$f":"SUMIF($C$9:$C$22,K27,$E$9:$E$22)","v":0},null,0,{"$f":"O5","v":0},0]
[null,{"$f":"SUMIF($C$9:$C$22,C28,$D$9:$D$22)","v":0},{"$f":"C6","v":"ruben"},{"$f":"SUMIF($C$9:$C$22,C28,$E$9:$E$22)","v":0},null,0,{"$f":"G6","v":"gal"},0,null,0,{"$f":"K6","v":0},{"$f":"SUMIF($C$9:$C$22,K28,$E$9:$E$22)","v":0},null,0,{"$f":"O6","v":0},0]
[]
[null,"Kwart finales"]
[]
[null,null,"A ronde",null,null,null,null,null,null,null,"A ronde"]
[null,"A1",null,null,null,null,null,null,null,"C1"]
[null,"B2",null,null,null,null,null,null,null,"D2"]
[]
[null,"B1",null,null,null,null,null,null,null,"D1"]
[null,"A2",null,null,null,null,null,null,null,"C2"]
[]
[null,null,"B ronde",null,null,null,null,null,null,null,"B ronde"]
[null,"A3",null,null,null,null,null,null,null,"C3"]
[null,"B4",null,null,null,null,null,null,null,"D4"]
[]
[null,"B3",null,null,null,null,null,null,null,"C4"]
[null,"A4",null,null,null,null,null,null,null,"D3"]
[]
[null,"Halve finales"]
[]
[null,null,"A ronde",null,null,null,null,null,null,null,"A ronde"]
[null,"WA1",{"$f":"IF(D33>D34,C33,C34)","v":0},null,null,null,null,null,null,"WA3",{"$f":"IF(L33>L34,K33,K34)","v":0}]
[null,"WB1",{"$f":"IF(D36>D37,C36,C37)","v":0},null,null,null,null,null,null,"WB3",{"$f":"IF(L36>L37,K36,K37)","v":0}]
[]
[null,null,"B ronde",null,null,null,null,null,null,null,"B ronde"]
[null,"WC1",{"$f":"IF(D40>D41,C40,C41)","v":0},null,null,null,null,null,null,"WC3",{"$f":"IF(L40>L41,K40,K41)","v":0}]
[null,"WC2",{"$f":"IF(D43>D44,C43,C44)","v":0},null,null,null,null,null,null,"WC4",{"$f":"IF(L44>K45,K44,J45)","v":0}]
[]
[null,"Finales met 4 poules"]
[]
[null,null,null,null,null,null,"A ronde"]
[null,null,null,null,null,"WA1",{"$f":"IF(D49>D50,C49,C50)","v":0}]
[null,null,null,null,null,"WA3",{"$f":"IF(L49>L50,K49,K50)","v":0}]
[]
[null,null,null,null,null,null,"B ronde"]
[null,null,null,null,null,"WC1",{"$f":"IF(D53>D54,C53,C54)","v":0}]
[null,null,null,null,null,"WC3",{"$f":"IF(L53>L54,K53,K54)","v":0}]
[]
[null,null,null,"WINNAAR A ronde",null,null,{"$f":"IF(H59>H60,G59,G60)","v":0}]
[]
[null,null,null,"WINNAAR B ronde",null,null,{"$f":"IF(H63>H64,G63,G64)","v":0}]

{"sheet":"8 poules","index":2,"n_rows":75,"n_cols":32,"rows_kept":75,"cut":false,"hidden":false,"merged":[[29,1,29,31],[12,25,12,27],[17,25,17,27],[1,29,1,31],[2,30,2,31],[3,30,3,31],[4,30,4,31],[5,30,5,31],[7,29,7,31],[12,29,12,31],[17,29,17,31],[1,25,1,27],[2,26,2,27],[3,26,3,27],[4,26,4,27],[5,26,5,27],[12,17,12,19],[17,17,17,19],[1,21,1,23],[2,22,2,23],[3,22,3,23],[4,22,4,23],[5,22,5,23],[7,21,7,23],[12,21,12,23],[17,21,17,23],[1,17,1,19],[2,18,2,19],[3,18,3,19],[4,18,4,19],[5,18,5,19],[1,13,1,15],[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[1,5,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[1,9,1,11],[2,10,2,11],[3,10,3,11],[4,10,4,11],[5,10,5,11],[1,1,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[7,1,7,3],[12,1,12,3],[17,1,17,3],[44,1,44,27],[53,1,53,27],[7,5,7,7],[12,5,12,7],[17,5,17,7],[7,9,7,11],[12,9,12,11],[7,17,7,19],[17,9,17,11],[7,13,7,15],[12,13,12,15],[17,13,17,15],[7,25,7,27],[63,1,63,27],[72,10,72,12],[72,13,72,15],[74,10,74,12],[74,13,74,15]]}
[]
[null,"Poule 1",null,null,null,"Poule 2",null,null,null,"Poule 3",null,null,null,"Poule 4",null,null,null,"Poule 5",null,null,null,"Poule 6",null,null,null,"Poule 7",null,null,null,"Poule 8"]
[null,"A",null,null,null,"A",null,null,null,"A",null,null,null,"A",null,null,null,"A",null,null,null,"A",null,null,null,"A",null,null,null,"A"]
[null,"B",null,null,null,"B",null,null,null,"B",null,null,null,"B",null,null,null,"B",null,null,null,"B",null,null,null,"B",null,null,null,"B"]
[null,"C",null,null,null,"C",null,null,null,"C",null,null,null,"C",null,null,null,"C",null,null,null,"C",null,null,null,"C",null,null,null,"C"]
[null,"D",null,null,null,"D",null,null,null,"D",null,null,null,"D",null,null,null,"D",null,null,null,"D",null,null,null,"D",null,null,null,"D"]
[]
[null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1",null,null,null,"Wedstrijd 1"]
[null,"A",{"$f":"C3","v":0},null,null,"A",{"$f":"G3","v":0},null,null,"A",{"$f":"K3","v":0},null,null,"A",{"$f":"O3","v":0},null,null,"A",{"$f":"S3","v":0},null,null,"A",{"$f":"W3","v":0},null,null,"A",{"$f":"AA3","v":0},null,null,"A",{"$f":"AE3","v":0}]
[null,"B",{"$f":"C4","v":0},null,null,"B",{"$f":"G4","v":0},null,null,"B",{"$f":"K4","v":0},null,null,"B",{"$f":"O4","v":0},null,null,"B",{"$f":"S4","v":0},null,null,"B",{"$f":"W4","v":0},null,null,"B",{"$f":"AA4","v":0},null,null,"B",{"$f":"AE4","v":0}]
[null,"C",{"$f":"C5","v":0},null,null,"C",{"$f":"G5","v":0},null,null,"C",{"$f":"K5","v":0},null,null,"C",{"$f":"O5","v":0},null,null,"C",{"$f":"S5","v":0},null,null,"C",{"$f":"W5","v":0},null,null,"C",{"$f":"AA5","v":0},null,null,"C",{"$f":"AE5","v":0}]
[null,"D",{"$f":"C6","v":0},null,null,"D",{"$f":"G6","v":0},null,null,"D",{"$f":"K6","v":0},null,null,"D",{"$f":"O6","v":0},null,null,"D",{"$f":"S6","v":0},null,null,"D",{"$f":"W6","v":0},null,null,"D",{"$f":"AA6","v":0},null,null,"D",{"$f":"AE6","v":0}]
[null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2",null,null,null,"Wedstrijd 2"]
[null,"A",{"$f":"C3","v":0},null,null,"A",{"$f":"G3","v":0},null,null,"A",{"$f":"K3","v":0},null,null,"A",{"$f":"O3","v":0},null,null,"A",{"$f":"S3","v":0},null,null,"A",{"$f":"W3","v":0},null,null,"A",{"$f":"AA3","v":0},null,null,"A",{"$f":"AE3","v":0}]
[null,"C",{"$f":"C5","v":0},null,null,"C",{"$f":"G5","v":0},null,null,"C",{"$f":"K5","v":0},null,null,"C",{"$f":"O5","v":0},null,null,"C",{"$f":"S5","v":0},null,null,"C",{"$f":"W5","v":0},null,null,"C",{"$f":"AA5","v":0},null,null,"C",{"$f":"AE5","v":0}]
[null,"B",{"$f":"C4","v":0},null,null,"B",{"$f":"G4","v":0},null,null,"B",{"$f":"K4","v":0},null,null,"B",{"$f":"O4","v":0},null,null,"B",{"$f":"S4","v":0},null,null,"B",{"$f":"W4","v":0},null,null,"B",{"$f":"AA4","v":0},null,null,"B",{"$f":"AE4","v":0}]
[null,"D",{"$f":"C6","v":0},null,null,"D",{"$f":"G6","v":0},null,null,"D",{"$f":"K6","v":0},null,null,"D",{"$f":"O6","v":0},null,null,"D",{"$f":"S6","v":0},null,null,"D",{"$f":"W6","v":0},null,null,"D",{"$f":"AA6","v":0},null,null,"D",{"$f":"AE6","v":0}]
[null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3",null,null,null,"Wedstrijd 3"]
[null,"A",{"$f":"C3","v":0},null,null,"A",{"$f":"G3","v":0},null,null,"A",{"$f":"K3","v":0},null,null,"A",{"$f":"O3","v":0},null,null,"A",{"$f":"S3","v":0},null,null,"A",{"$f":"W3","v":0},null,null,"A",{"$f":"AA3","v":0},null,null,"A",{"$f":"AE3","v":0}]
[null,"D",{"$f":"C6","v":0},null,null,"D",{"$f":"G6","v":0},null,null,"D",{"$f":"K6","v":0},null,null,"D",{"$f":"O6","v":0},null,null,"D",{"$f":"S6","v":0},null,null,"D",{"$f":"W6","v":0},null,null,"D",{"$f":"AA6","v":0},null,null,"D",{"$f":"AE6","v":0}]
[null,"B",{"$f":"C4","v":0},null,null,"B",{"$f":"G4","v":0},null,null,"B",{"$f":"K4","v":0},null,null,"B",{"$f":"O4","v":0},null,null,"B",{"$f":"S4","v":0},null,null,"B",{"$f":"W4","v":0},null,null,"B",{"$f":"AA4","v":0},null,null,"B",{"$f":"AE4","v":0}]
[null,"C",{"$f":"C5","v":0},null,null,"C",{"$f":"G5","v":0},null,null,"C",{"$f":"K5","v":0},null,null,"C",{"$f":"O5","v":0},null,null,"C",{"$f":"S5","v":0},null,null,"C",{"$f":"W5","v":0},null,null,"C",{"$f":"AA5","v":0},null,null,"C",{"$f":"AE5","v":0}]
[]
[null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten",null,"Legs","Naam","Punten"]
[null,{"$f":"D9+D14+D19","v":0},{"$f":"C3","v":0},null,null,{"$f":"H9+H14+H19","v":0},{"$f":"G3","v":0},null,null,{"$f":"L9+L14+L19","v":0},{"$f":"K3","v":0},null,null,{"$f":"P9+P14+P19","v":0},{"$f":"O3","v":0},null,null,{"$f":"T9+T14+T19","v":0},{"$f":"S3","v":0},null,null,{"$f":"X9+X14+X19","v":0},{"$f":"W3","v":0},null,null,{"$f":"AB9+AB14+AB19","v":0},{"$f":"AA3","v":0},null,null,{"$f":"AF9+AF14+AF19","v":0},{"$f":"AE3","v":0}]
[null,{"$f":"D10+D21+D16","v":0},{"$f":"C4","v":0},null,null,{"$f":"H10+H21+H16","v":0},{"$f":"G4","v":0},null,null,{"$f":"L10+L21+L16","v":0},{"$f":"K4","v":0},null,null,{"$f":"P10+P21+P16","v":0},{"$f":"O4","v":0},null,null,{"$f":"T10+T21+T16","v":0},{"$f":"S4","v":0},null,null,{"$f":"X10+X21+X16","v":0},{"$f":"W4","v":0},null,null,{"$f":"AB10+AB21+AB16","v":0},{"$f":"AA4","v":0},null,null,{"$f":"AF10+AF21+AF16","v":0},{"$f":"AE4","v":0}]
[null,{"$f":"D11+D15+D22","v":0},{"$f":"C5","v":0},null,null,{"$f":"H11+H15+H22","v":0},{"$f":"G5","v":0},null,null,{"$f":"L11+L15+L22","v":0},{"$f":"K5","v":0},null,null,{"$f":"P11+P15+P22","v":0},{"$f":"O5","v":0},null,null,{"$f":"T11+T15+T22","v":0},{"$f":"S5","v":0},null,null,{"$f":"X11+X15+X22","v":0},{"$f":"W5","v":0},null,null,{"$f":"AB11+AB15+AB22","v":0},{"$f":"AA5","v":0},null,null,{"$f":"AF11+AF15+AF22","v":0},{"$f":"AE5","v":0}]
[null,{"$f":"D12+D17+D20","v":0},{"$f":"C6","v":0},null,null,{"$f":"H12+H17+H20","v":0},{"$f":"G6","v":0},null,null,{"$f":"L12+L17+L20","v":0},{"$f":"K6","v":0},null,null,{"$f":"P12+P17+P20","v":0},{"$f":"O6","v":0},null,null,{"$f":"T12+T17+T20","v":0},{"$f":"S6","v":0},null,null,{"$f":"X12+X17+X20","v":0},{"$f":"W6","v":0},null,null,{"$f":"AB12+AB17+AB20","v":0},{"$f":"AA6","v":0},null,null,{"$f":"AF12+AF17+AF20","v":0},{"$f":"AE6","v":0}]
[]
[null,"Kwart finales"]
[null,null,"A ronde",null,null,null,null,null,null,null,"A ronde",null,null,null,null,null,null,null,"A ronde",null,null,null,null,null,null,null,"A ronde"]
[null,"A1",null,null,null,null,null,null,null,"A3",null,null,null,null,null,null,null,"A5",null,null,null,null,null,null,null,"A7"]
[null,"B2",null,null,null,null,null,null,null,"B4",null,null,null,null,null,null,null,"B6",null,null,null,null,null,null,null,"B8"]
[]
[null,"B1",null,null,null,null,null,null,null,"B3",null,null,null,null,null,null,null,"B5",null,null,null,null,null,null,null,"B7"]
[null,"A2",null,null,null,null,null,null,null,"A4",null,null,null,null,null,null,null,"A6",null,null,null,null,null,null,null,"A8"]
[]
[null,null,"B ronde",null,null,null,null,null,null,null,"B ronde",null,null,null,null,null,null,null,"B ronde",null,null,null,null,null,null,null,"B ronde"]
[null,"C1",null,null,null,null,null,null,null,"C3",null,null,null,null,null,null,null,"C5",null,null,null,null,null,null,null,"C7"]
[null,"D2",null,null,null,null,null,null,null,"D4",null,null,null,null,null,null,null,"D6",null,null,null,null,null,null,null,"D8"]
[]
[null,"C2",null,null,null,null,null,null,null,"C4",null,null,null,null,null,null,null,"C6",null,null,null,null,null,null,null,"C8"]
[null,"D1",null,null,null,null,null,null,null,"D3",null,null,null,null,null,null,null,"D5",null,null,null,null,null,null,null,"D7"]
[]
[null,"Halve finales"]
[null,null,"A ronde",null,null,null,null,null,null,null,"A ronde",null,null,null,null,null,null,null,"A ronde",null,null,null,null,null,null,null,"A ronde"]
[null,"WA1",{"$f":"IF(D32>D33,C32,C33)","v":0},null,null,null,null,null,null,"WA3",{"$f":"IF(L32>L33,K32,K33)","v":0},null,null,null,null,null,null,"WA5",{"$f":"IF(T32>T33,S32,S33)","v":0},null,null,null,null,null,null,"WA7",{"$f":"IF(AB32>AB33,AA32,AA33)","v":0}]
[null,"WB1",{"$f":"IF(D35>D36,C35,C36)","v":0},null,null,null,null,null,null,"WB3",{"$f":"IF(L35>L36,K35,K36)","v":0},null,null,null,null,null,null,"WB5",{"$f":"IF(T35>T36,S35,S36)","v":0},null,null,null,null,null,null,"WB7",{"$f":"IF(AB35>AB36,AA35,AA36)","v":0}]
[]
[null,null,"B ronde",null,null,null,null,null,null,null,"B ronde",null,null,null,null,null,null,null,"B ronde",null,null,null,null,null,null,null,"B ronde"]
[null,"WC1",{"$f":"IF(D39>D40,C39,C40)","v":0},null,null,null,null,null,null,"WC3",{"$f":"IF(L39>L40,K39,K40)","v":0},null,null,null,null,null,null,"WC5",{"$f":"IF(T39>T40,S39,S40)","v":0},null,null,null,null,null,null,"WC7",{"$f":"IF(AB39>AB40,AA39,AA40)","v":0}]
[null,"WC2",{"$f":"IF(D42>D43,C42,C43)","v":0},null,null,null,null,null,null,"WC4",{"$f":"IF(L42>L43,K42,K43)","v":0},null,null,null,null,null,null,"WC6",{"$f":"IF(T42>T43,S42,S43)","v":0},null,null,null,null,null,null,"WC8",{"$f":"IF(AB42>AB43,AA42,AA43)","v":0}]
[]
[null,"Finales met 2 poules"]
[null,null,null,null,null,null,"A ronde"]
[null,null,null,null,null,"WA1",{"$f":"IF(D47>D48,C47,C48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A ronde"]
[null,null,null,null,null,"WA3",{"$f":"IF(L47>L48,K47,K48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA5",{"$f":"IF(T47>T48,S47,S48)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA7",{"$f":"IF(AB47>AB48,AA47,AA48)","v":0}]
[null,null,null,null,null,null,"B ronde"]
[null,null,null,null,null,"WC1",{"$f":"IF(D51>D52,C51,C52)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B ronde"]
[null,null,null,null,null,"WC3",{"$f":"IF(L51>L52,K51,K52)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WC5",{"$f":"IF(T51>T52,S51,S52)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WC7",{"$f":"IF(AB51>AB52,AA51,AA52)","v":0}]
[]
[null,"Finales met 4 poules"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A ronde"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"WA1",{"$f":"IF(H56>H57,G56,G57)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"WA5",{"$f":"IF(X57>X58,W57,W58)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B ronde"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"WC1",{"$f":"IF(H60>H61,G60,G61)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"WC5",{"$f":"IF(X61>X62,W61,W62)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"WINNAAR A ronde",null,null,{"$f":"IF(P66>P67,O66,O67)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"WINNAAR B ronde",null,null,{"$f":"IF(P70>P71,O70,O71)","v":0}]

{"sheet":"deelnemers","index":3,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["nr.","naam",null,null,"deelnemer 5"]
[1,"deelnemer 5",{"$f":"IF(B2<>\"\",RAND(),\"\")","v":0.48193139295414866},null,"deelnemer 4"]
[2,"deelnemer 4",0.5443349429718598,null,"deelnemer 7"]
[3,"deelnemer 7",0.44454407398514073,null,"deelnemer 6"]
[4,"deelnemer 6",0.2050108398800452,null,"deelnemer 2"]
[5,"deelnemer 2",0.99882752069179004,null,"deelnemer 8"]
[6,"deelnemer 8",0.41364387892283871,null,"deelnemer 1"]
[7,"deelnemer 1",0.1621573298647474,null,"deelnemer 3",null,null,null,null,"kolom E is voor de loting van de spelers"]
[8,"deelnemer 3",0.7307630306263766]
[9,null,"",null,null,null,null,null,null,"klik op de knop \"naar poules\""]
[10,null,"",null,null,null,null,null,null,"automatisch gebeurd de loting en het invullen van het blad aan de hand van het aantal spelers."]
[11,null,""]
[12,null,""]
[13,null,""]
[14,null,"",null,null,null,null,null,null,"Wegens het gebrek aan kennis van het spel is het nog maar voor de helft in orde."]
[15,null,""]
[16,null,""]
[17,null,"",null,null,null,null,null,null,"vul eens een gans blad in (liefst  2 poules) zodat ik kan achterhalen hoe de puntenverdeling verder gebeurd"]
[18,null,""]
[19,null,""]
[20,null,""]
[21,null,""]
[22,null,""]
[23,null,""]
[24,null,""]
[25,null,"",null,null,null,null,null," "]
[26,null,""]
[27,null,""]
[28,null,""]
[29,null,""]
[30,null,""]
[31,null,""]
[32,null,""]