{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Aanmeldformulier"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Aanmeldformulier","index":0,"n_rows":104,"n_cols":55,"rows_kept":104,"merged":[[4,0,9,0],[4,30,4,35],[5,30,5,35],[6,30,6,35],[7,30,7,35],[8,30,8,35],[9,30,9,35],[12,0,17,0],[12,30,12,35],[13,30,13,35],[14,30,14,35],[15,30,15,35],[16,30,16,35],[17,30,17,35],[20,0,25,0],[28,0,33,0],[36,0,41,0],[44,0,49,0],[52,0,57,0],[60,0,65,0],[71,2,71,4],[81,2,81,4],[87,2,87,4],[91,2,91,4],[94,2,94,4]]}
[null,"Stuur dit formulier vóór 20 november 2022 (17:00u) naar aanmelding@haemerke.nl",{"$nulls":9},"VERSIE 1.3"]
[]
[null,"Naam deelnemer:",{"$nulls":6},{"$f":"SUM(I5:I104)","v":0},{"$nulls":45},"Deze velden dien je in te vullen"]
[{"$nulls":25},"loten"]
["Groep A",{"$f":"O6","v":"Qatar"},null,"-",null,{"$f":"O7","v":"Ecuador"},{"$nulls":4},"Groep A",{"$f":"IF(E10=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","Onderling","Punten",{"$f":"IF(AND(COUNT(C5:G10)=12,OR(Y6=Y7,Y6=Y8,Y6=Y9,Y7=Y8,Y7=Y9,Y8=Y9)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C5>E5,1,-1)","v":-1},{"$f":"IF(C5=E5,2,-2)","v":2},{"$f":"IF(C5<E5,3,-3)","v":-3}]
[null,{"$f":"O8","v":"Senegal"},null,"-",null,{"$f":"O9","v":"Nederland"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C5:G6)<4,\"Nr. 1 - groep A\",IF(COUNTIF(M6:M9,M6)>1,INDEX(O3:O9,SMALL(IF(EXACT(M6,AB6:AB9),ROW(O6:O9)),1),0)&\"/\"&INDEX(O3:O9,SMALL(IF(EXACT(M6,AB6:AB9),ROW(AB6:AB9)),2),0),INDEX(O6:O9,MATCH(M6,AB6:AB9,0))))","v":"Nr. 1 - groep A"},{"$f":"LARGE(AB6:AB9,1)","v":0},null,"Qatar",{"$f":"T6-U6","v":0},{"$f":"IF(C5=\"\",0,IF(C5>E5,1,0))+IF(C7=\"\",0,IF(C7>E7,1,0))+IF(E9=\"\",0,IF(E9>C9,1,0))","v":0},{"$f":"IF(E5=\"\",0,IF(C5=E5,1,0))+IF(E7=\"\",0,IF(C7=E7,1,0))+IF(E9=\"\",0,IF(C9=E9,1,0))","v":0},{"$f":"IF(C5=\"\",0,IF(C5<E5,1,0))+IF(C7=\"\",0,IF(C7<E7,1,0))+IF(E9=\"\",0,IF(E9<C9,1,0))","v":0},{"$f":"SUMIF(B5:B50,O6,C5:C50)+SUMIF(F5:F50,O6,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O6,E5:E50)+SUMIF(F5:F50,O6,C5:C50)","v":0},{"$f":"Q6*3+R6","v":0},{"$f":"V6+P6/100+T6/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W6=W7,C5-E5+(P6-P7)/100+(T6-T7)/10000,0)+IF(W6=W8,C7-E7+(P6-P8)/100+(T6-T8)/10000,0)+IF(W6=W9,E9-C9+(P6-P9)/100+(T6-T9)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W6+X6/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O6","v":"Qatar"},null,{"$f":"Y6+AA6/100000000","v":{"v":0,"d":"0.00000000"}},null,null,"Volgorde als 2 of 3 teams gelijk eindigen in de Groepswedstrijden:",{"$nulls":7},{"$f":"IF(C6>E6,1,-1)","v":-1},{"$f":"IF(C6=E6,2,-2)","v":2},{"$f":"IF(C6<E6,3,-3)","v":-3}]
[null,{"$f":"O6","v":"Qatar"},null,"-",null,{"$f":"O8","v":"Senegal"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C5:G6)<4,\"Nr. 2 - groep A\",IF(COUNTIF(M6:M9,M7)>1,INDEX(O3:O9,SMALL(IF(EXACT(M7,AB6:AB9),ROW(O6:O9)),1),0)&\"/\"&INDEX(O3:O9,SMALL(IF(EXACT(M7,AB6:AB9),ROW(AB6:AB9)),2),0),INDEX(O6:O9,MATCH(M7,AB6:AB9,0))))","v":"Nr. 2 - groep A"},{"$f":"LARGE(AB6:AB9,2)","v":0},null,"Ecuador",{"$f":"T7-U7","v":0},{"$f":"IF(E5=\"\",0,IF(E5>C5,1,0))+IF(E8=\"\",0,IF(E8>C8,1,0))+IF(E10=\"\",0,IF(C10>E10,1,0))","v":0},{"$f":"IF(E5=\"\",0,IF(C5=E5,1,0))+IF(E8=\"\",0,IF(C8=E8,1,0))+IF(E10=\"\",0,IF(C10=E10,1,0))","v":0},{"$f":"IF(E5=\"\",0,IF(E5<C5,1,0))+IF(E8=\"\",0,IF(E8<C8,1,0))+IF(E10=\"\",0,IF(C10<E10,1,0))","v":0},{"$f":"SUMIF(B5:B50,O7,C5:C50)+SUMIF(F5:F50,O7,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O7,E5:E50)+SUMIF(F5:F50,O7,C5:C50)","v":0},{"$f":"Q7*3+R7","v":0},{"$f":"V7+P7/100+T7/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W7=W6,E5-C5+(P7-P6)/100+(T7-T6)/10000,0)+IF(W7=W8,C10-E10+(P7-P8)/100+(T7-T8)/10000,0)+IF(W7=W9,C8-E8+(P7-P9)/100+(T7-T9)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W7+X7/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O7","v":"Ecuador"},null,{"$f":"Y7+AA7/100000000","v":{"v":0,"d":"0.00000000"}},null,1,"De meeste wedstrijdpunten uit alle groepswedstrijden,",{"$nulls":7},-1,2,-3]
[null,{"$f":"O9","v":"Nederland"},null,"-",null,{"$f":"O7","v":"Ecuador"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C5:G6)<4,\"Nr. 3 - groep A\",IF(COUNTIF(M6:M9,M8)>1,INDEX(O3:O10,SMALL(IF(EXACT(M8,AB6:AB9),ROW(O6:O9)),1),0)&\"/\"&INDEX(O3:O10,SMALL(IF(EXACT(M8,AB6:AB9),ROW(AB6:AB9)),2),0),INDEX(O6:O9,MATCH(M8,AB6:AB9,0))))","v":"Nr. 3 - groep A"},{"$f":"LARGE(AB6:AB9,3)","v":0},null,"Senegal",{"$f":"T8-U8","v":0},{"$f":"IF(C6=\"\",0,IF(C6>E6,1,0))+IF(E7=\"\",0,IF(E7>C7,1,0))+IF(E10=\"\",0,IF(E10>C10,1,0))","v":0},{"$f":"IF(C6=\"\",0,IF(C6=E6,1,0))+IF(E7=\"\",0,IF(C7=E7,1,0))+IF(E10=\"\",0,IF(C10=E10,1,0))","v":0},{"$f":"IF(C6=\"\",0,IF(C6<E6,1,0))+IF(E7=\"\",0,IF(E7<C7,1,0))+IF(E10=\"\",0,IF(E10<C10,1,0))","v":0},{"$f":"SUMIF(B5:B50,O8,C5:C50)+SUMIF(F5:F50,O8,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O8,E5:E50)+SUMIF(F5:F50,O8,C5:C50)","v":0},{"$f":"Q8*3+R8","v":0},{"$f":"V8+P8/100+T8/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W8=W6,E7-C7+(P8-P6)/100+(T8-T6)/10000,0)+IF(W8=W7,E10-C10+(P8-P7)/100+(T8-T7)/10000,0)+IF(W8=W9,C6-E6+(P8-P9)/100+(T8-T9)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W8+X8/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O8","v":"Senegal"},null,{"$f":"Y8+AA8/100000000","v":{"v":0,"d":"0.00000000"}},null,2,"Het doelpuntensaldo over alle groepswedstrijden,",{"$nulls":7},-1,2,-3]
[null,{"$f":"O9","v":"Nederland"},null,"-",null,{"$f":"O6","v":"Qatar"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C5:G6)<4,\"Nr. 4 - groep A\",IF(COUNTIF(M6:M9,M9)>1,INDEX(O3:O13,SMALL(IF(EXACT(M9,AB6:AB9),ROW(O6:O9)),1),0)&\"/\"&INDEX(O3:O13,SMALL(IF(EXACT(M9,AB6:AB9),ROW(AB6:AB9)),2),0),INDEX(O6:O9,MATCH(M9,AB6:AB9,0))))","v":"Nr. 4 - groep A"},{"$f":"LARGE(AB6:AB9,4)","v":0},null,"Nederland",{"$f":"T9-U9","v":0},{"$f":"IF(E6=\"\",0,IF(E6>C6,1,0))+IF(C8=\"\",0,IF(C8>E8,1,0))+IF(C9=\"\",0,IF(C9>E9,1,0))","v":0},{"$f":"IF(E6=\"\",0,IF(C6=E6,1,0))+IF(E8=\"\",0,IF(C8=E8,1,0))+IF(E9=\"\",0,IF(C9=E9,1,0))","v":0},{"$f":"IF(E6=\"\",0,IF(E6<C6,1,0))+IF(C8=\"\",0,IF(C8<E8,1,0))+IF(C9=\"\",0,IF(C9<E9,1,0))","v":0},{"$f":"SUMIF(B5:B50,O9,C5:C50)+SUMIF(F5:F50,O9,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O9,E5:E50)+SUMIF(F5:F50,O9,C5:C50)","v":0},{"$f":"Q9*3+R9","v":0},{"$f":"V9+P9/100+T9/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W9=W6,C9-E9+(P9-P6)/100+(T9-T6)/10000,0)+IF(W9=W7,E8-C8+(P9-P7)/100+(T9-T7)/10000,0)+IF(W9=W8,E6-C6+(P9-P8)/100+(T9-T8)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W9+X9/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O9","v":"Nederland"},null,{"$f":"Y9+AA9/100000000","v":{"v":0,"d":"0.00000000"}},null,3,"Meeste doelpunten gescoord in alle groepswedstrijden,",{"$nulls":7},-1,2,-3]
[null,{"$f":"O7","v":"Ecuador"},null,"-",null,{"$f":"O8","v":"Senegal"},{"$nulls":24},"Staan twee of meer teams hiermee nog gelijk, dan is de rangorde: ",{"$nulls":7},-1,2,-3]
[]
[]
["Groep B",{"$f":"O14","v":"Engeland"},null,"-",null,{"$f":"O15","v":"Iran"},{"$nulls":4},"Groep B",{"$f":"IF(E18=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C13:G18)=12,OR(Y14=Y15,Y14=Y16,Y14=Y17,Y15=Y16,Y15=Y17,Y16=Y17)),\"loten:\",\"\")","v":""},{"$nulls":3},4,"Meeste punten van de betreffende teams,",{"$nulls":7},{"$f":"IF(C13>E13,1,-1)","v":-1},{"$f":"IF(C13=E13,2,-2)","v":2},{"$f":"IF(C13<E13,3,-3)","v":-3}]
[null,{"$f":"O16","v":"America"},null,"-",null,{"$f":"O17","v":"Wales"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C13:G14)<4,\"Nr. 1 - groep B\",IF(COUNTIF(M14:M17,M14)>1,INDEX(O3:O17,SMALL(IF(EXACT(M14,AB14:AB17),ROW(O14:O17)),1),0)&\"/\"&INDEX(O3:O17,SMALL(IF(EXACT(M14,AB14:AB17),ROW(AB14:AB17)),2),0),INDEX(O14:O17,MATCH(M14,AB14:AB17,0))))","v":"Nr. 1 - groep B"},{"$f":"LARGE(AB14:AB17,1)","v":0},null,"Engeland",{"$f":"T14-U14","v":0},{"$f":"IF(C13=\"\",0,IF(C13>E13,1,0))+IF(C15=\"\",0,IF(C15>E15,1,0))+IF(E17=\"\",0,IF(E17>C17,1,0))","v":0},{"$f":"IF(E13=\"\",0,IF(C13=E13,1,0))+IF(E15=\"\",0,IF(C15=E15,1,0))+IF(E17=\"\",0,IF(C17=E17,1,0))","v":0},{"$f":"IF(C13=\"\",0,IF(C13<E13,1,0))+IF(C15=\"\",0,IF(C15<E15,1,0))+IF(E17=\"\",0,IF(E17<C17,1,0))","v":0},{"$f":"SUMIF(B5:B50,O14,C5:C50)+SUMIF(F5:F50,O14,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O14,E5:E50)+SUMIF(F5:F50,O14,C5:C50)","v":0},{"$f":"Q14*3+R14","v":0},{"$f":"V14+P14/100+T14/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W14=W15,C13-E13+(P14-P15)/100+(T14-T15)/10000,0)+IF(W14=W16,C15-E15+(P14-P16)/100+(T14-T16)/10000,0)+IF(W14=W17,E17-C17+(P14-P17)/100+(T14-T17)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W14+X14/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O14","v":"Engeland"},null,{"$f":"Y14+AA14/100000000","v":{"v":0,"d":"0.00000000"}},null,5,"Hoogste doelsaldo van de betreffende teams,",{"$nulls":7},-1,2,-3]
[null,{"$f":"O14","v":"Engeland"},null,"-",null,{"$f":"O16","v":"America"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C13:G14)<4,\"Nr. 2 - groep B\",IF(COUNTIF(M14:M17,M15)>1,INDEX(O3:O17,SMALL(IF(EXACT(M15,AB14:AB17),ROW(O14:O17)),1),0)&\"/\"&INDEX(O3:O17,SMALL(IF(EXACT(M15,AB14:AB17),ROW(AB14:AB17)),2),0),INDEX(O14:O17,MATCH(M15,AB14:AB17,0))))","v":"Nr. 2 - groep B"},{"$f":"LARGE(AB14:AB17,2)","v":0},null,"Iran",{"$f":"T15-U15","v":0},{"$f":"IF(E13=\"\",0,IF(E13>C13,1,0))+IF(E16=\"\",0,IF(E16>C16,1,0))+IF(E18=\"\",0,IF(C18>E18,1,0))","v":0},{"$f":"IF(E13=\"\",0,IF(C13=E13,1,0))+IF(E16=\"\",0,IF(C16=E16,1,0))+IF(E18=\"\",0,IF(C18=E18,1,0))","v":0},{"$f":"IF(E13=\"\",0,IF(E13<C13,1,0))+IF(E16=\"\",0,IF(E16<C16,1,0))+IF(E18=\"\",0,IF(C18<E18,1,0))","v":0},{"$f":"SUMIF(B5:B50,O15,C5:C50)+SUMIF(F5:F50,O15,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O15,E5:E50)+SUMIF(F5:F50,O15,C5:C50)","v":0},{"$f":"Q15*3+R15","v":0},{"$f":"V15+P15/100+T15/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W15=W14,E13-C13+(P15-P14)/100+(T15-T14)/10000,0)+IF(W15=W16,C18-E18+(P15-P16)/100+(T15-T16)/10000,0)+IF(W15=W17,C16-E16+(P15-P17)/100+(T15-T17)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W15+X15/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O15","v":"Iran"},null,{"$f":"Y15+AA15/100000000","v":{"v":0,"d":"0.00000000"}},null,6,"Meeste doelpunten gescoord van de betreffende teams,",{"$nulls":7},-1,2,-3]
[null,{"$f":"O17","v":"Wales"},null,"-",null,{"$f":"O15","v":"Iran"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C13:G14)<4,\"Nr. 3 - groep B\",IF(COUNTIF(M14:M17,M16)>1,INDEX(O3:O18,SMALL(IF(EXACT(M16,AB14:AB17),ROW(O14:O17)),1),0)&\"/\"&INDEX(O3:O18,SMALL(IF(EXACT(M16,AB14:AB17),ROW(AB14:AB17)),2),0),INDEX(O14:O17,MATCH(M16,AB14:AB17,0))))","v":"Nr. 3 - groep B"},{"$f":"LARGE(AB14:AB17,3)","v":0},null,"America",{"$f":"T16-U16","v":0},{"$f":"IF(C14=\"\",0,IF(C14>E14,1,0))+IF(E15=\"\",0,IF(E15>C15,1,0))+IF(E18=\"\",0,IF(E18>C18,1,0))","v":0},{"$f":"IF(E14=\"\",0,IF(C14=E14,1,0))+IF(E15=\"\",0,IF(C15=E15,1,0))+IF(E18=\"\",0,IF(C18=E18,1,0))","v":0},{"$f":"IF(C14=\"\",0,IF(C14<E14,1,0))+IF(E15=\"\",0,IF(E15<C15,1,0))+IF(E18=\"\",0,IF(E18<C18,1,0))","v":0},{"$f":"SUMIF(B5:B50,O16,C5:C50)+SUMIF(F5:F50,O16,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O16,E5:E50)+SUMIF(F5:F50,O16,C5:C50)","v":0},{"$f":"Q16*3+R16","v":0},{"$f":"V16+P16/100+T16/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W16=W14,E15-C15+(P16-P14)/100+(T16-T14)/10000,0)+IF(W16=W15,E18-C18+(P16-P15)/100+(T16-T15)/10000,0)+IF(W16=W17,C14-E14+(P16-P17)/100+(T16-T17)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W16+X16/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O16","v":"America"},null,{"$f":"Y16+AA16/100000000","v":{"v":0,"d":"0.00000000"}},null,null,"Dit wordt allemaal met formules berekend.",{"$nulls":7},-1,2,-3]
[null,{"$f":"O17","v":"Wales"},null,"-",null,{"$f":"O14","v":"Engeland"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C13:G14)<4,\"Nr. 4 - groep B\",IF(COUNTIF(M14:M17,M17)>1,INDEX(O3:O21,SMALL(IF(EXACT(M17,AB14:AB17),ROW(O14:O17)),1),0)&\"/\"&INDEX(O3:O21,SMALL(IF(EXACT(M17,AB14:AB17),ROW(AB14:AB17)),2),0),INDEX(O14:O17,MATCH(M17,AB14:AB17,0))))","v":"Nr. 4 - groep B"},{"$f":"LARGE(AB14:AB17,4)","v":0},null,"Wales",{"$f":"T17-U17","v":0},{"$f":"IF(E14=\"\",0,IF(E14>C14,1,0))+IF(C16=\"\",0,IF(C16>E16,1,0))+IF(C17=\"\",0,IF(C17>E17,1,0))","v":0},{"$f":"IF(E14=\"\",0,IF(C14=E14,1,0))+IF(C16=\"\",0,IF(C16=E16,1,0))+IF(C17=\"\",0,IF(C17=E17,1,0))","v":0},{"$f":"IF(E14=\"\",0,IF(E14<C14,1,0))+IF(C16=\"\",0,IF(C16<E16,1,0))+IF(C17=\"\",0,IF(C17<E17,1,0))","v":0},{"$f":"SUMIF(B5:B50,O17,C5:C50)+SUMIF(F5:F50,O17,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O17,E5:E50)+SUMIF(F5:F50,O17,C5:C50)","v":0},{"$f":"Q17*3+R17","v":0},{"$f":"V17+P17/100+T17/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W17=W14,C17-E17+(P17-P14)/100+(T17-T14)/10000,0)+IF(W17=W15,E16-C16+(P17-P15)/100+(T17-T15)/10000,0)+IF(W17=W16,E14-C14+(P17-P16)/100+(T17-T16)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W17+X17/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O17","v":"Wales"},null,{"$f":"Y17+AA17/100000000","v":{"v":0,"d":"0.00000000"}},null,7,"Loting door het organiserend comité van de FIFA World Cup. ",{"$nulls":7},-1,2,-3]
[null,{"$f":"O15","v":"Iran"},null,"-",null,{"$f":"O16","v":"America"},{"$nulls":24},"Moet er geloot worden, dan lichten in kolom AE de betreffende",{"$nulls":7},-1,2,-3]
[]
[]
["Groep C",{"$f":"O22","v":"Argentinië"},null,"-",null,{"$f":"O23","v":"Saudi-Arabië"},{"$nulls":4},"Groep C",{"$f":"IF(E26=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C21:G26)=12,OR(Y22=Y23,Y22=Y24,Y22=Y25,Y23=Y24,Y23=Y25,Y24=Y25)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C21>E21,1,-1)","v":-1},{"$f":"IF(C21=E21,2,-2)","v":2},{"$f":"IF(C21<E21,3,-3)","v":-3}]
[null,{"$f":"O24","v":"Mexico"},null,"-",null,{"$f":"O25","v":"Polen"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C21:G22)<4,\"Nr. 1 - groep C\",IF(COUNTIF(M22:M25,M22)>1,INDEX(O3:O25,SMALL(IF(EXACT(M22,AB22:AB25),ROW(O22:O25)),1),0)&\"/\"&INDEX(O3:O25,SMALL(IF(EXACT(M22,AB22:AB25),ROW(AB22:AB25)),2),0),INDEX(O22:O25,MATCH(M22,AB22:AB25,0))))","v":"Nr. 1 - groep C"},{"$f":"LARGE(AB22:AB25,1)","v":0},null,"Argentinië",{"$f":"T22-U22","v":0},{"$f":"IF(C21=\"\",0,IF(C21>E21,1,0))+IF(C23=\"\",0,IF(C23>E23,1,0))+IF(E25=\"\",0,IF(E25>C25,1,0))","v":0},{"$f":"IF(C21=\"\",0,IF(C21=E21,1,0))+IF(C23=\"\",0,IF(C23=E23,1,0))+IF(E25=\"\",0,IF(C25=E25,1,0))","v":0},{"$f":"IF(C21=\"\",0,IF(C21<E21,1,0))+IF(C23=\"\",0,IF(C23<E23,1,0))+IF(E25=\"\",0,IF(E25<C25,1,0))","v":0},{"$f":"SUMIF(B5:B50,O22,C5:C50)+SUMIF(F5:F50,O22,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O22,E5:E50)+SUMIF(F5:F50,O22,C5:C50)","v":0},{"$f":"Q22*3+R22","v":0},{"$f":"V22+P22/100+T22/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W22=W23,C21-E21+(P22-P23)/100+(T22-T23)/10000,0)+IF(W22=W24,C23-E23+(P22-P24)/100+(T22-T24)/10000,0)+IF(W22=W25,E25-C25+(P22-P25)/100+(T22-T25)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W22+X22/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O22","v":"Argentinië"},null,{"$f":"Y22+AA22/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O22","v":"Argentinië"},null,"-",null,{"$f":"O24","v":"Mexico"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C21:G22)<4,\"Nr. 2 - groep C\",IF(COUNTIF(M22:M25,M23)>1,INDEX(O3:O25,SMALL(IF(EXACT(M23,AB22:AB25),ROW(O22:O25)),1),0)&\"/\"&INDEX(O3:O25,SMALL(IF(EXACT(M23,AB22:AB25),ROW(AB22:AB25)),2),0),INDEX(O22:O25,MATCH(M23,AB22:AB25,0))))","v":"Nr. 2 - groep C"},{"$f":"LARGE(AB22:AB25,2)","v":0},null,"Saudi-Arabië",{"$f":"T23-U23","v":0},{"$f":"IF(E21=\"\",0,IF(E21>C21,1,0))+IF(E24=\"\",0,IF(E24>C24,1,0))+IF(C26=\"\",0,IF(C26>E26,1,0))","v":0},{"$f":"IF(E21=\"\",0,IF(C21=E21,1,0))+IF(E24=\"\",0,IF(C24=E24,1,0))+IF(C26=\"\",0,IF(C26=E26,1,0))","v":0},{"$f":"IF(E21=\"\",0,IF(E21<C21,1,0))+IF(E24=\"\",0,IF(E24<C24,1,0))+IF(C26=\"\",0,IF(C26<E26,1,0))","v":0},{"$f":"SUMIF(B5:B50,O23,C5:C50)+SUMIF(F5:F50,O23,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O23,E5:E50)+SUMIF(F5:F50,O23,C5:C50)","v":0},{"$f":"Q23*3+R23","v":0},{"$f":"V23+P23/100+T23/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W23=W22,E21-C21+(P23-P22)/100+(T23-T22)/10000,0)+IF(W23=W24,C26-E26+(P23-P24)/100+(T23-T24)/10000,0)+IF(W23=W25,C24-E24+(P23-P25)/100+(T23-T25)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W23+X23/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O23","v":"Saudi-Arabië"},null,{"$f":"Y23+AA23/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O25","v":"Polen"},null,"-",null,{"$f":"O23","v":"Saudi-Arabië"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C21:G22)<4,\"Nr. 3 - groep C\",IF(COUNTIF(M22:M25,M24)>1,INDEX(O3:O26,SMALL(IF(EXACT(M24,AB22:AB25),ROW(O22:O25)),1),0)&\"/\"&INDEX(O3:O26,SMALL(IF(EXACT(M24,AB22:AB25),ROW(AB22:AB25)),2),0),INDEX(O22:O25,MATCH(M24,AB22:AB25,0))))","v":"Nr. 3 - groep C"},{"$f":"LARGE(AB22:AB25,3)","v":0},null,"Mexico",{"$f":"T24-U24","v":0},{"$f":"IF(C22=\"\",0,IF(C22>E22,1,0))+IF(E23=\"\",0,IF(E23>C23,1,0))+IF(E26=\"\",0,IF(E26>C26,1,0))","v":0},{"$f":"IF(C22=\"\",0,IF(C22=E22,1,0))+IF(E23=\"\",0,IF(C23=E23,1,0))+IF(E26=\"\",0,IF(C26=E26,1,0))","v":0},{"$f":"IF(C22=\"\",0,IF(C22<E22,1,0))+IF(E23=\"\",0,IF(E23<C23,1,0))+IF(E26=\"\",0,IF(E26<C26,1,0))","v":0},{"$f":"SUMIF(B5:B50,O24,C5:C50)+SUMIF(F5:F50,O24,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O24,E5:E50)+SUMIF(F5:F50,O24,C5:C50)","v":0},{"$f":"Q24*3+R24","v":0},{"$f":"V24+P24/100+T24/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W24=W22,E23-C23+(P24-P22)/100+(T24-T22)/10000,0)+IF(W24=W23,E26-C26+(P24-P23)/100+(T24-T23)/10000,0)+IF(W24=W25,C22-E22+(P24-P25)/100+(T24-T25)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W24+X24/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O24","v":"Mexico"},null,{"$f":"Y24+AA24/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O25","v":"Polen"},null,"-",null,{"$f":"O22","v":"Argentinië"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C21:G22)<4,\"Nr. 4 - groep C\",IF(COUNTIF(M22:M25,M25)>1,INDEX(O3:O29,SMALL(IF(EXACT(M25,AB22:AB25),ROW(O22:O25)),1),0)&\"/\"&INDEX(O3:O29,SMALL(IF(EXACT(M25,AB22:AB25),ROW(AB22:AB25)),2),0),INDEX(O22:O25,MATCH(M25,AB22:AB25,0))))","v":"Nr. 4 - groep C"},{"$f":"LARGE(AB22:AB25,4)","v":0},null,"Polen",{"$f":"T25-U25","v":0},{"$f":"IF(E22=\"\",0,IF(E22>C22,1,0))+IF(C24=\"\",0,IF(C24>E24,1,0))+IF(C25=\"\",0,IF(C25>E25,1,0))","v":0},{"$f":"IF(E22=\"\",0,IF(C22=E22,1,0))+IF(C24=\"\",0,IF(C24=E24,1,0))+IF(C25=\"\",0,IF(C25=E25,1,0))","v":0},{"$f":"IF(E22=\"\",0,IF(E22<C22,1,0))+IF(C24=\"\",0,IF(C24<E24,1,0))+IF(C25=\"\",0,IF(C25<E25,1,0))","v":0},{"$f":"SUMIF(B5:B50,O25,C5:C50)+SUMIF(F5:F50,O25,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O25,E5:E50)+SUMIF(F5:F50,O25,C5:C50)","v":0},{"$f":"Q25*3+R25","v":0},{"$f":"V25+P25/100+T25/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W25=W22,C25-E25+(P25-P22)/100+(T25-T22)/10000,0)+IF(W25=W23,E24-C24+(P25-P23)/100+(T25-T23)/10000,0)+IF(W25=W24,E22-C22+(P25-P24)/100+(T25-T24)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W25+X25/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O25","v":"Polen"},null,{"$f":"Y25+AA25/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O23","v":"Saudi-Arabië"},null,"-",null,{"$f":"O24","v":"Mexico"},{"$nulls":32},-1,2,-3]
[]
[]
["Groep D",{"$f":"O30","v":"Frankrijk"},null,"-",null,{"$f":"O33","v":"Australië"},{"$nulls":4},"Groep D",{"$f":"IF(E34=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C29:G34)=12,OR(Y30=Y31,Y30=Y32,Y30=Y33,Y31=Y32,Y31=Y33,Y32=Y33)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C29>E29,1,-1)","v":-1},{"$f":"IF(C29=E29,2,-2)","v":2},{"$f":"IF(C29<E29,3,-3)","v":-3}]
[null,{"$f":"O31","v":"Denemarken"},null,"-",null,{"$f":"O32","v":"Tunesië"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C29:G30)<4,\"Nr. 1 - groep D\",IF(COUNTIF(M30:M33,M30)>1,INDEX(O3:O33,SMALL(IF(EXACT(M30,AB30:AB33),ROW(O30:O33)),1),0)&\"/\"&INDEX(O3:O33,SMALL(IF(EXACT(M30,AB30:AB33),ROW(AB30:AB33)),2),0),INDEX(O30:O33,MATCH(M30,AB30:AB33,0))))","v":"Nr. 1 - groep D"},{"$f":"LARGE(AB30:AB33,1)","v":0},null,"Frankrijk",{"$f":"T30-U30","v":0},{"$f":"IF(C29=\"\",0,IF(C29>E29,1,0))+IF(C32=\"\",0,IF(C32>E32,1,0))+IF(E34=\"\",0,IF(E34>C34,1,0))","v":0},{"$f":"IF(C29=\"\",0,IF(C29=E29,1,0))+IF(C32=\"\",0,IF(C32=E32,1,0))+IF(E34=\"\",0,IF(C34=E34,1,0))","v":0},{"$f":"IF(C29=\"\",0,IF(C29<E29,1,0))+IF(C32=\"\",0,IF(C32<E32,1,0))+IF(E34=\"\",0,IF(E34<C34,1,0))","v":0},{"$f":"SUMIF(B5:B50,O30,C5:C50)+SUMIF(F5:F50,O30,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O30,E5:E50)+SUMIF(F5:F50,O30,C5:C50)","v":0},{"$f":"Q30*3+R30","v":0},{"$f":"V30+P30/100+T30/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W30=W31,C29-E29+(P30-P31)/100+(T30-T31)/10000,0)+IF(W30=W32,C31-E31+(P30-P32)/100+(T30-T32)/10000,0)+IF(W30=W33,E33-C33+(P30-P33)/100+(T30-T33)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W30+X30/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O30","v":"Frankrijk"},null,{"$f":"Y30+AA30/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O32","v":"Tunesië"},null,"-",null,{"$f":"O33","v":"Australië"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C29:G30)<4,\"Nr. 2 - groep D\",IF(COUNTIF(M30:M33,M31)>1,INDEX(O3:O33,SMALL(IF(EXACT(M31,AB30:AB33),ROW(O30:O33)),1),0)&\"/\"&INDEX(O3:O33,SMALL(IF(EXACT(M31,AB30:AB33),ROW(AB30:AB33)),2),0),INDEX(O30:O33,MATCH(M31,AB30:AB33,0))))","v":"Nr. 2 - groep D"},{"$f":"LARGE(AB30:AB33,2)","v":0},null,"Denemarken",{"$f":"T31-U31","v":0},{"$f":"IF(C30=\"\",0,IF(C30>E30,1,0))+IF(E32=\"\",0,IF(E32>C32,1,0))+IF(E33=\"\",0,IF(E33>C33,1,0))","v":0},{"$f":"IF(C30=\"\",0,IF(C30=E30,1,0))+IF(E32=\"\",0,IF(C32=E32,1,0))+IF(E33=\"\",0,IF(C33=E33,1,0))","v":0},{"$f":"IF(C29=\"\",0,IF(E29<C29,1,0))+IF(E32=\"\",0,IF(E32<C32,1,0))+IF(E34=\"\",0,IF(C34<E34,1,0))","v":0},{"$f":"SUMIF(B5:B50,O31,C5:C50)+SUMIF(F5:F50,O31,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O31,E5:E50)+SUMIF(F5:F50,O31,C5:C50)","v":0},{"$f":"Q31*3+R31","v":0},{"$f":"V31+P31/100+T31/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W31=W30,E29-C29+(P31-P30)/100+(T31-T30)/10000,0)+IF(W31=W32,C34-E34+(P31-P32)/100+(T31-T32)/10000,0)+IF(W31=W33,C32-E32+(P31-P33)/100+(T31-T33)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W31+X31/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O31","v":"Denemarken"},null,{"$f":"Y31+AA31/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O30","v":"Frankrijk"},null,"-",null,{"$f":"O31","v":"Denemarken"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C29:G30)<4,\"Nr. 3 - groep D\",IF(COUNTIF(M30:M33,M32)>1,INDEX(O3:O34,SMALL(IF(EXACT(M32,AB30:AB33),ROW(O30:O33)),1),0)&\"/\"&INDEX(O3:O34,SMALL(IF(EXACT(M32,AB30:AB33),ROW(AB30:AB33)),2),0),INDEX(O30:O33,MATCH(M32,AB30:AB33,0))))","v":"Nr. 3 - groep D"},{"$f":"LARGE(AB30:AB33,3)","v":0},null,"Tunesië",{"$f":"T32-U32","v":0},{"$f":"IF(E30=\"\",0,IF(E30>C30,1,0))+IF(E31=\"\",0,IF(C31>E31,1,0))+IF(C34=\"\",0,IF(C34>E34,1,0))","v":0},{"$f":"IF(E30=\"\",0,IF(C30=E30,1,0))+IF(C31=\"\",0,IF(C31=E31,1,0))+IF(C34=\"\",0,IF(C34=E34,1,0))","v":0},{"$f":"IF(E30=\"\",0,IF(E30<C30,1,0))+IF(C31=\"\",0,IF(C31<E31,1,0))+IF(C34=\"\",0,IF(C34<E34,1,0))","v":0},{"$f":"SUMIF(B5:B50,O32,C5:C50)+SUMIF(F5:F50,O32,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O32,E5:E50)+SUMIF(F5:F50,O32,C5:C50)","v":0},{"$f":"Q32*3+R32","v":0},{"$f":"V32+P32/100+T32/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W32=W30,E31-C31+(P32-P30)/100+(T32-T30)/10000,0)+IF(W32=W31,E34-C34+(P32-P31)/100+(T32-T31)/10000,0)+IF(W32=W33,C30-E30+(P32-P33)/100+(T32-T33)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W32+X32/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O32","v":"Tunesië"},null,{"$f":"Y32+AA32/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O33","v":"Australië"},null,"-",null,{"$f":"O31","v":"Denemarken"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C29:G30)<4,\"Nr. 4 - groep D\",IF(COUNTIF(M30:M33,M33)>1,INDEX(O3:O37,SMALL(IF(EXACT(M33,AB30:AB33),ROW(O30:O33)),1),0)&\"/\"&INDEX(O3:O37,SMALL(IF(EXACT(M33,AB30:AB33),ROW(AB30:AB33)),2),0),INDEX(O30:O33,MATCH(M33,AB30:AB33,0))))","v":"Nr. 4 - groep D"},{"$f":"LARGE(AB30:AB33,4)","v":0},null,"Australië",{"$f":"T33-U33","v":0},{"$f":"IF(E29=\"\",0,IF(E29>C29,1,0))+IF(E31=\"\",0,IF(E31>C31,1,0))+IF(C33=\"\",0,IF(C33>E33,1,0))","v":0},{"$f":"IF(E29=\"\",0,IF(C29=E29,1,0))+IF(E31=\"\",0,IF(C31=E31,1,0))+IF(E33=\"\",0,IF(C33=E33,1,0))","v":0},{"$f":"IF(E29=\"\",0,IF(E29<C29,1,0))+IF(E31=\"\",0,IF(C31<E31,1,0))+IF(E33=\"\",0,IF(C33<E33,1,0))","v":0},{"$f":"SUMIF(B5:B50,O33,C5:C50)+SUMIF(F5:F50,O33,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O33,E5:E50)+SUMIF(F5:F50,O33,C5:C50)","v":0},{"$f":"Q33*3+R33","v":0},{"$f":"V33+P33/100+T33/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W33=W30,C33-E33+(P33-P30)/100+(T33-T30)/10000,0)+IF(W33=W31,E32-C32+(P33-P31)/100+(T33-T31)/10000,0)+IF(W33=W32,E30-C30+(P33-P32)/100+(T33-T32)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W33+X33/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O33","v":"Australië"},null,{"$f":"Y33+AA33/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O32","v":"Tunesië"},null,"-",null,{"$f":"O30","v":"Frankrijk"},{"$nulls":32},-1,2,-3]
[]
[]
["Groep E",{"$f":"O39","v":"Duitsland"},null,"-",null,{"$f":"O40","v":"Japan"},{"$nulls":4},"Groep E",{"$f":"IF(E42=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C37:G42)=12,OR(Y38=Y39,Y38=Y40,Y38=Y41,Y39=Y40,Y39=Y41,Y40=Y41)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C37>E37,1,-1)","v":-1},{"$f":"IF(C37=E37,2,-2)","v":2},{"$f":"IF(C37<E37,3,-3)","v":-3}]
[null,{"$f":"O38","v":"Spanje"},null,"-",null,{"$f":"O41","v":"Costa Rica"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C37:G38)<4,\"Nr. 1 - groep E\",IF(COUNTIF(M38:M41,M38)>1,INDEX(O3:O41,SMALL(IF(EXACT(M38,AB38:AB41),ROW(O38:O41)),1),0)&\"/\"&INDEX(O3:O41,SMALL(IF(EXACT(M38,AB38:AB41),ROW(AB38:AB41)),2),0),INDEX(O38:O41,MATCH(M38,AB38:AB41,0))))","v":"Nr. 1 - groep E"},{"$f":"LARGE(AB38:AB41,1)","v":0},null,"Spanje",{"$f":"T38-U38","v":0},{"$f":"IF(C38=\"\",0,IF(C38>E38,1,0))+IF(C40=\"\",0,IF(C40>E40,1,0))+IF(E42=\"\",0,IF(E42>C42,1,0))","v":0},{"$f":"IF(E38=\"\",0,IF(C38=E38,1,0))+IF(E40=\"\",0,IF(C40=E40,1,0))+IF(E42=\"\",0,IF(C42=E42,1,0))","v":0},{"$f":"IF(C38=\"\",0,IF(C38<E38,1,0))+IF(E40=\"\",0,IF(E40<C40,1,0))+IF(E42=\"\",0,IF(E42<C42,1,0))","v":0},{"$f":"SUMIF(B5:B50,O38,C5:C50)+SUMIF(F5:F50,O38,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O38,E5:E50)+SUMIF(F5:F50,O38,C5:C50)","v":0},{"$f":"Q38*3+R38","v":0},{"$f":"V38+P38/100+T38/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W38=W39,C37-E37+(P38-P39)/100+(T38-T39)/10000,0)+IF(W38=W40,C39-E39+(P38-P40)/100+(T38-T40)/10000,0)+IF(W38=W41,E41-C41+(P38-P41)/100+(T38-T41)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W38+X38/1000000-0.0002","v":{"v":-0.0002,"d":"-0.000200"}},{"$f":"O38","v":"Spanje"},null,{"$f":"Y38+AA38/100000000","v":{"v":-0.0002,"d":"-0.00020000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O40","v":"Japan"},null,"-",null,{"$f":"O41","v":"Costa Rica"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C37:G38)<4,\"Nr. 2 - groep E\",IF(COUNTIF(M38:M41,M39)>1,INDEX(O3:O41,SMALL(IF(EXACT(M39,AB38:AB41),ROW(O38:O41)),1),0)&\"/\"&INDEX(O3:O41,SMALL(IF(EXACT(M39,AB38:AB41),ROW(AB38:AB41)),2),0),INDEX(O38:O41,MATCH(M39,AB38:AB41,0))))","v":"Nr. 2 - groep E"},{"$f":"LARGE(AB38:AB41,2)","v":0},null,"Duitsland",{"$f":"T39-U39","v":0},{"$f":"IF(C37=\"\",0,IF(C37>E37,1,0))+IF(E40=\"\",0,IF(E40>C40,1,0))+IF(E41=\"\",0,IF(E41>C41,1,0))","v":0},{"$f":"IF(E37=\"\",0,IF(C37=E37,1,0))+IF(E40=\"\",0,IF(C40=E40,1,0))+IF(E41=\"\",0,IF(C41=E41,1,0))","v":0},{"$f":"IF(C37=\"\",0,IF(C37<E37,1,0))+IF(C40=\"\",0,IF(E40<C40,1,0))+IF(C41=\"\",0,IF(E41<C41,1,0))","v":0},{"$f":"SUMIF(B5:B50,O39,C5:C50)+SUMIF(F5:F50,O39,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O39,E5:E50)+SUMIF(F5:F50,O39,C5:C50)","v":0},{"$f":"Q39*3+R39","v":0},{"$f":"V39+P39/100+T39/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W39=W38,E37-C37+(P39-P38)/100+(T39-T38)/10000,0)+IF(W39=W40,C42-E42+(P39-P40)/100+(T39-T40)/10000,0)+IF(W39=W41,C40-E40+(P39-P41)/100+(T39-T41)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W39+X39/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O39","v":"Duitsland"},null,{"$f":"Y39+AA39/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O38","v":"Spanje"},null,"-",null,{"$f":"O39","v":"Duitsland"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C37:G38)<4,\"Nr. 3 - groep E\",IF(COUNTIF(M38:M41,M40)>1,INDEX(O3:O42,SMALL(IF(EXACT(M40,AB38:AB41),ROW(O38:O41)),1),0)&\"/\"&INDEX(O3:O42,SMALL(IF(EXACT(M40,AB38:AB41),ROW(AB38:AB41)),2),0),INDEX(O38:O41,MATCH(M40,AB38:AB41,0))))","v":"Nr. 3 - groep E"},{"$f":"LARGE(AB38:AB41,3)","v":0},null,"Japan",{"$f":"T40-U40","v":0},{"$f":"IF(E37=\"\",0,IF(E37>C37,1,0))+IF(C39=\"\",0,IF(C39>E39,1,0))+IF(C42=\"\",0,IF(C42>E42,1,0))","v":0},{"$f":"IF(E37=\"\",0,IF(C37=E37,1,0))+IF(E39=\"\",0,IF(C39=E39,1,0))+IF(E42=\"\",0,IF(C42=E42,1,0))","v":0},{"$f":"IF(E37=\"\",0,IF(E37<C37,1,0))+IF(C39=\"\",0,IF(C39<E39,1,0))+IF(C42=\"\",0,IF(C42<E42,1,0))","v":0},{"$f":"SUMIF(B5:B50,O40,C5:C50)+SUMIF(F5:F50,O40,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O40,E5:E50)+SUMIF(F5:F50,O40,C5:C50)","v":0},{"$f":"Q40*3+R40","v":0},{"$f":"V40+P40/100+T40/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W40=W38,E39-C39+(P40-P38)/100+(T40-T38)/10000,0)+IF(W40=W39,E42-C42+(P40-P39)/100+(T40-T39)/10000,0)+IF(W40=W41,C38-E38+(P40-P41)/100+(T40-T41)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W40+X40/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O40","v":"Japan"},null,{"$f":"Y40+AA40/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O41","v":"Costa Rica"},null,"-",null,{"$f":"O39","v":"Duitsland"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C37:G38)<4,\"Nr. 4 - groep E\",IF(COUNTIF(M38:M41,M41)>1,INDEX(O3:O45,SMALL(IF(EXACT(M41,AB38:AB41),ROW(O38:O41)),1),0)&\"/\"&INDEX(O3:O45,SMALL(IF(EXACT(M41,AB38:AB41),ROW(AB38:AB41)),2),0),INDEX(O38:O41,MATCH(M41,AB38:AB41,0))))","v":"Nr. 4 - groep E"},{"$f":"LARGE(AB38:AB41,4)","v":{"v":-0.0002,"d":"-0"}},null,"Costa Rica",{"$f":"T41-U41","v":0},{"$f":"IF(E38=\"\",0,IF(E38>C38,1,0))+IF(E39=\"\",0,IF(E39>C39,1,0))+IF(E41=\"\",0,IF(C41>E41,1,0))","v":0},{"$f":"IF(E38=\"\",0,IF(C38=E38,1,0))+IF(E39=\"\",0,IF(C39=E39,1,0))+IF(E41=\"\",0,IF(C41=E41,1,0))","v":0},{"$f":"IF(E38=\"\",0,IF(E38<C38,1,0))+IF(E39=\"\",0,IF(E39<C39,1,0))+IF(C41=\"\",0,IF(C41<E41,1,0))","v":0},{"$f":"SUMIF(B5:B50,O41,C5:C50)+SUMIF(F5:F50,O41,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O41,E5:E50)+SUMIF(F5:F50,O41,C5:C50)","v":0},{"$f":"Q41*3+R41","v":0},{"$f":"V41+P41/100+T41/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W41=W38,C41-E41+(P41-P38)/100+(T41-T38)/10000,0)+IF(W41=W39,E40-C40+(P41-P39)/100+(T41-T39)/10000,0)+IF(W41=W40,E38-C38+(P41-P40)/100+(T41-T40)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W41+X41/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O41","v":"Costa Rica"},null,{"$f":"Y41+AA41/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O40","v":"Japan"},null,"-",null,{"$f":"O38","v":"Spanje"},{"$nulls":32},-1,2,-3]
[]
[]
["Groep F",{"$f":"O46","v":"België"},null,"-",null,{"$f":"O47","v":"Canada"},{"$nulls":4},"Groep F",{"$f":"IF(E50=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C45:G50)=12,OR(Y46=Y47,Y46=Y48,Y46=Y49,Y47=Y48,Y47=Y49,Y48=Y49)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C45>E45,1,-1)","v":-1},{"$f":"IF(C45=E45,2,-2)","v":2},{"$f":"IF(C45<E45,3,-3)","v":-3}]
[null,{"$f":"O48","v":"Marokko"},null,"-",null,{"$f":"O49","v":"Kroatië"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C45:G46)<4,\"Nr. 1 - groep F\",IF(COUNTIF(M46:M49,M46)>1,INDEX(O3:O49,SMALL(IF(EXACT(M46,AB46:AB49),ROW(O46:O49)),1),0)&\"/\"&INDEX(O3:O49,SMALL(IF(EXACT(M46,AB46:AB49),ROW(AB46:AB49)),2),0),INDEX(O46:O49,MATCH(M46,AB46:AB49,0))))","v":"Nr. 1 - groep F"},{"$f":"LARGE(AB46:AB49,1)","v":0},null,"België",{"$f":"T46-U46","v":0},{"$f":"IF(C45=\"\",0,IF(C45>E45,1,0))+IF(E47=\"\",0,IF(C47>E47,1,0))+IF(E49=\"\",0,IF(E49>C49,1,0))","v":0},{"$f":"IF(E45=\"\",0,IF(C45=E45,1,0))+IF(E47=\"\",0,IF(C47=E47,1,0))+IF(E49=\"\",0,IF(C49=E49,1,0))","v":0},{"$f":"IF(C45=\"\",0,IF(C45<E45,1,0))+IF(E47=\"\",0,IF(C47<E47,1,0))+IF(E49=\"\",0,IF(E49<C49,1,0))","v":0},{"$f":"SUMIF(B5:B50,O46,C5:C50)+SUMIF(F5:F50,O46,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O46,E5:E50)+SUMIF(F5:F50,O46,C5:C50)","v":0},{"$f":"Q46*3+R46","v":0},{"$f":"V46+P46/100+T46/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W46=W47,C45-E45+(P46-P47)/100+(T46-T47)/10000,0)+IF(W46=W48,C47-E47+(P46-P48)/100+(T46-T48)/10000,0)+IF(W46=W49,E49-C49+(P46-P49)/100+(T46-T49)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W46+X46/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O46","v":"België"},null,{"$f":"Y46+AA46/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O46","v":"België"},null,"-",null,{"$f":"O48","v":"Marokko"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C45:G46)<4,\"Nr. 2 - groep F\",IF(COUNTIF(M46:M49,M47)>1,INDEX(O3:O49,SMALL(IF(EXACT(M47,AB46:AB49),ROW(O46:O49)),1),0)&\"/\"&INDEX(O3:O49,SMALL(IF(EXACT(M47,AB46:AB49),ROW(AB46:AB49)),2),0),INDEX(O46:O49,MATCH(M47,AB46:AB49,0))))","v":"Nr. 2 - groep F"},{"$f":"LARGE(AB46:AB49,2)","v":0},null,"Canada",{"$f":"T47-U47","v":0},{"$f":"IF(E45=\"\",0,IF(E45>C45,1,0))+IF(E48=\"\",0,IF(E48>C48,1,0))+IF(E50=\"\",0,IF(C50>E50,1,0))","v":0},{"$f":"IF(E45=\"\",0,IF(C45=E45,1,0))+IF(E48=\"\",0,IF(C48=E48,1,0))+IF(E50=\"\",0,IF(C50=E50,1,0))","v":0},{"$f":"IF(E45=\"\",0,IF(E45<C45,1,0))+IF(E48=\"\",0,IF(E48<C48,1,0))+IF(E50=\"\",0,IF(C50<E50,1,0))","v":0},{"$f":"SUMIF(B5:B50,O47,C5:C50)+SUMIF(F5:F50,O47,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O47,E5:E50)+SUMIF(F5:F50,O47,C5:C50)","v":0},{"$f":"Q47*3+R47","v":0},{"$f":"V47+P47/100+T47/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W47=W46,E45-C45+(P47-P46)/100+(T47-T46)/10000,0)+IF(W47=W48,C50-E50+(P47-P48)/100+(T47-T48)/10000,0)+IF(W47=W49,C48-E48+(P47-P49)/100+(T47-T49)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W47+X47/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O47","v":"Canada"},null,{"$f":"Y47+AA47/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O49","v":"Kroatië"},null,"-",null,{"$f":"O47","v":"Canada"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C45:G46)<4,\"Nr. 3 - groep F\",IF(COUNTIF(M46:M49,M48)>1,INDEX(O3:O50,SMALL(IF(EXACT(M48,AB46:AB49),ROW(O46:O49)),1),0)&\"/\"&INDEX(O3:O50,SMALL(IF(EXACT(M48,AB46:AB49),ROW(AB46:AB49)),2),0),INDEX(O46:O49,MATCH(M48,AB46:AB49,0))))","v":"Nr. 3 - groep F"},{"$f":"LARGE(AB46:AB49,3)","v":0},null,"Marokko",{"$f":"T48-U48","v":0},{"$f":"IF(E46=\"\",0,IF(C46>E46,1,0))+IF(E47=\"\",0,IF(E47>C47,1,0))+IF(E50=\"\",0,IF(E50>C50,1,0))","v":0},{"$f":"IF(E46=\"\",0,IF(C46=E46,1,0))+IF(E47=\"\",0,IF(C47=E47,1,0))+IF(E50=\"\",0,IF(C50=E50,1,0))","v":0},{"$f":"IF(E46=\"\",0,IF(C46<E46,1,0))+IF(E47=\"\",0,IF(E47<C47,1,0))+IF(E50=\"\",0,IF(E50<C50,1,0))","v":0},{"$f":"SUMIF(B5:B50,O48,C5:C50)+SUMIF(F5:F50,O48,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O48,E5:E50)+SUMIF(F5:F50,O48,C5:C50)","v":0},{"$f":"Q48*3+R48","v":0},{"$f":"V48+P48/100+T48/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W48=W46,E47-C47+(P48-P46)/100+(T48-T46)/10000,0)+IF(W48=W47,E50-C50+(P48-P47)/100+(T48-T47)/10000,0)+IF(W48=W49,C46-E46+(P48-P49)/100+(T48-T49)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W48+X48/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O48","v":"Marokko"},null,{"$f":"Y48+AA48/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O49","v":"Kroatië"},null,"-",null,{"$f":"O46","v":"België"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C45:G46)<4,\"Nr. 4 - groep F\",IF(COUNTIF(M46:M49,M49)>1,INDEX(O3:O50,SMALL(IF(EXACT(M49,AB46:AB49),ROW(O46:O49)),1),0)&\"/\"&INDEX(O3:O50,SMALL(IF(EXACT(M49,AB46:AB49),ROW(AB46:AB49)),2),0),INDEX(O46:O49,MATCH(M49,AB46:AB49,0))))","v":"Nr. 4 - groep F"},{"$f":"LARGE(AB46:AB49,4)","v":0},null,"Kroatië",{"$f":"T49-U49","v":0},{"$f":"IF(E46=\"\",0,IF(E46>C46,1,0))+IF(E48=\"\",0,IF(C48>E48,1,0))+IF(E49=\"\",0,IF(C49>E49,1,0))","v":0},{"$f":"IF(E46=\"\",0,IF(C46=E46,1,0))+IF(E48=\"\",0,IF(C48=E48,1,0))+IF(E49=\"\",0,IF(C49=E49,1,0))","v":0},{"$f":"IF(E46=\"\",0,IF(E46<C46,1,0))+IF(E48=\"\",0,IF(C48<E48,1,0))+IF(E49=\"\",0,IF(C49<E49,1,0))","v":0},{"$f":"SUMIF(B5:B50,O49,C5:C50)+SUMIF(F5:F50,O49,E5:E50)","v":0},{"$f":"SUMIF(B5:B50,O49,E5:E50)+SUMIF(F5:F50,O49,C5:C50)","v":0},{"$f":"Q49*3+R49","v":0},{"$f":"V49+P49/100+T49/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W49=W46,C49-E49+(P49-P46)/100+(T49-T46)/10000,0)+IF(W49=W47,E48-C48+(P49-P47)/100+(T49-T47)/10000,0)+IF(W49=W48,E46-C46+(P49-P48)/100+(T49-T48)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W49+X49/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O49","v":"Kroatië"},null,{"$f":"Y49+AA49/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O47","v":"Canada"},null,"-",null,{"$f":"O48","v":"Marokko"},{"$nulls":32},-1,2,-3]
[]
[]
["Groep G",{"$f":"O54","v":"Brazilië"},null,"-",null,{"$f":"O55","v":"Servië"},{"$nulls":4},"Groep F",{"$f":"IF(E58=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C53:G58)=12,OR(Y54=Y55,Y54=Y56,Y54=Y57,Y55=Y56,Y55=Y57,Y56=Y57)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C53>E53,1,-1)","v":-1},{"$f":"IF(C53=E53,2,-2)","v":2},{"$f":"IF(C53<E53,3,-3)","v":-3}]
[null,{"$f":"O56","v":"Zwitserland"},null,"-",null,{"$f":"O57","v":"Kameroen"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C53:G54)<4,\"Nr. 1 - groep G\",IF(COUNTIF(M54:M57,M54)>1,INDEX(O11:O57,SMALL(IF(EXACT(M54,AB54:AB57),ROW(O54:O57)),1),0)&\"/\"&INDEX(O11:O57,SMALL(IF(EXACT(M54,AB54:AB57),ROW(AB54:AB57)),2),0),INDEX(O54:O57,MATCH(M54,AB54:AB57,0))))","v":"Nr. 1 - groep G"},{"$f":"LARGE(AB54:AB57,1)","v":0},null,"Brazilië",{"$f":"T54-U54","v":0},{"$f":"IF(C53=\"\",0,IF(C53>E53,1,0))+IF(E55=\"\",0,IF(C55>E55,1,0))+IF(E57=\"\",0,IF(E57>C57,1,0))","v":0},{"$f":"IF(E53=\"\",0,IF(C53=E53,1,0))+IF(E55=\"\",0,IF(C55=E55,1,0))+IF(E57=\"\",0,IF(C57=E57,1,0))","v":0},{"$f":"IF(C53=\"\",0,IF(C53<E53,1,0))+IF(E55=\"\",0,IF(C55<E55,1,0))+IF(E57=\"\",0,IF(E57<C57,1,0))","v":0},{"$f":"SUMIF(B13:B58,O54,C13:C58)+SUMIF(F13:F58,O54,E13:E58)","v":0},{"$f":"SUMIF(B13:B58,O54,E13:E58)+SUMIF(F13:F58,O54,C13:C58)","v":0},{"$f":"Q54*3+R54","v":0},{"$f":"V54+P54/100+T54/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W54=W55,C53-E53+(P54-P55)/100+(T54-T55)/10000,0)+IF(W54=W56,C55-E55+(P54-P56)/100+(T54-T56)/10000,0)+IF(W54=W57,E57-C57+(P54-P57)/100+(T54-T57)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W54+X54/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O54","v":"Brazilië"},null,{"$f":"Y54+AA54/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O54","v":"Brazilië"},null,"-",null,{"$f":"O56","v":"Zwitserland"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C53:G54)<4,\"Nr. 2 - groep G\",IF(COUNTIF(M54:M57,M55)>1,INDEX(O11:O57,SMALL(IF(EXACT(M55,AB54:AB57),ROW(O54:O57)),1),0)&\"/\"&INDEX(O11:O57,SMALL(IF(EXACT(M55,AB54:AB57),ROW(AB54:AB57)),2),0),INDEX(O54:O57,MATCH(M55,AB54:AB57,0))))","v":"Nr. 2 - groep G"},{"$f":"LARGE(AB54:AB57,2)","v":0},null,"Servië",{"$f":"T55-U55","v":0},{"$f":"IF(E53=\"\",0,IF(E53>C53,1,0))+IF(E56=\"\",0,IF(E56>C56,1,0))+IF(E58=\"\",0,IF(C58>E58,1,0))","v":0},{"$f":"IF(E53=\"\",0,IF(C53=E53,1,0))+IF(E56=\"\",0,IF(C56=E56,1,0))+IF(E58=\"\",0,IF(C58=E58,1,0))","v":0},{"$f":"IF(E53=\"\",0,IF(E53<C53,1,0))+IF(E56=\"\",0,IF(E56<C56,1,0))+IF(E58=\"\",0,IF(C58<E58,1,0))","v":0},{"$f":"SUMIF(B13:B58,O55,C13:C58)+SUMIF(F13:F58,O55,E13:E58)","v":0},{"$f":"SUMIF(B13:B58,O55,E13:E58)+SUMIF(F13:F58,O55,C13:C58)","v":0},{"$f":"Q55*3+R55","v":0},{"$f":"V55+P55/100+T55/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W55=W54,E53-C53+(P55-P54)/100+(T55-T54)/10000,0)+IF(W55=W56,C58-E58+(P55-P56)/100+(T55-T56)/10000,0)+IF(W55=W57,C56-E56+(P55-P57)/100+(T55-T57)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W55+X55/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O55","v":"Servië"},null,{"$f":"Y55+AA55/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O57","v":"Kameroen"},null,"-",null,{"$f":"O55","v":"Servië"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C53:G54)<4,\"Nr. 3 - groep G\",IF(COUNTIF(M54:M57,M56)>1,INDEX(O11:O58,SMALL(IF(EXACT(M56,AB54:AB57),ROW(O54:O57)),1),0)&\"/\"&INDEX(O11:O58,SMALL(IF(EXACT(M56,AB54:AB57),ROW(AB54:AB57)),2),0),INDEX(O54:O57,MATCH(M56,AB54:AB57,0))))","v":"Nr. 3 - groep G"},{"$f":"LARGE(AB54:AB57,3)","v":0},null,"Zwitserland",{"$f":"T56-U56","v":0},{"$f":"IF(E54=\"\",0,IF(C54>E54,1,0))+IF(E55=\"\",0,IF(E55>C55,1,0))+IF(E58=\"\",0,IF(E58>C58,1,0))","v":0},{"$f":"IF(E54=\"\",0,IF(C54=E54,1,0))+IF(E55=\"\",0,IF(C55=E55,1,0))+IF(E58=\"\",0,IF(C58=E58,1,0))","v":0},{"$f":"IF(E54=\"\",0,IF(C54<E54,1,0))+IF(E55=\"\",0,IF(E55<C55,1,0))+IF(E58=\"\",0,IF(E58<C58,1,0))","v":0},{"$f":"SUMIF(B13:B58,O56,C13:C58)+SUMIF(F13:F58,O56,E13:E58)","v":0},{"$f":"SUMIF(B13:B58,O56,E13:E58)+SUMIF(F13:F58,O56,C13:C58)","v":0},{"$f":"Q56*3+R56","v":0},{"$f":"V56+P56/100+T56/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W56=W54,E55-C55+(P56-P54)/100+(T56-T54)/10000,0)+IF(W56=W55,E58-C58+(P56-P55)/100+(T56-T55)/10000,0)+IF(W56=W57,C54-E54+(P56-P57)/100+(T56-T57)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W56+X56/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O56","v":"Zwitserland"},null,{"$f":"Y56+AA56/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O57","v":"Kameroen"},null,"-",null,{"$f":"O54","v":"Brazilië"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C53:G54)<4,\"Nr. 4 - groep G\",IF(COUNTIF(M54:M57,M57)>1,INDEX(O11:O58,SMALL(IF(EXACT(M57,AB54:AB57),ROW(O54:O57)),1),0)&\"/\"&INDEX(O11:O58,SMALL(IF(EXACT(M57,AB54:AB57),ROW(AB54:AB57)),2),0),INDEX(O54:O57,MATCH(M57,AB54:AB57,0))))","v":"Nr. 4 - groep G"},{"$f":"LARGE(AB54:AB57,4)","v":0},null,"Kameroen",{"$f":"T57-U57","v":0},{"$f":"IF(E54=\"\",0,IF(E54>C54,1,0))+IF(E56=\"\",0,IF(C56>E56,1,0))+IF(E57=\"\",0,IF(C57>E57,1,0))","v":0},{"$f":"IF(E54=\"\",0,IF(C54=E54,1,0))+IF(E56=\"\",0,IF(C56=E56,1,0))+IF(E57=\"\",0,IF(C57=E57,1,0))","v":0},{"$f":"IF(E54=\"\",0,IF(E54<C54,1,0))+IF(E56=\"\",0,IF(C56<E56,1,0))+IF(E57=\"\",0,IF(C57<E57,1,0))","v":0},{"$f":"SUMIF(B13:B58,O57,C13:C58)+SUMIF(F13:F58,O57,E13:E58)","v":0},{"$f":"SUMIF(B13:B58,O57,E13:E58)+SUMIF(F13:F58,O57,C13:C58)","v":0},{"$f":"Q57*3+R57","v":0},{"$f":"V57+P57/100+T57/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W57=W54,C57-E57+(P57-P54)/100+(T57-T54)/10000,0)+IF(W57=W55,E56-C56+(P57-P55)/100+(T57-T55)/10000,0)+IF(W57=W56,E54-C54+(P57-P56)/100+(T57-T56)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W57+X57/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O57","v":"Kameroen"},null,{"$f":"Y57+AA57/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O55","v":"Servië"},null,"-",null,{"$f":"O56","v":"Zwitserland"},{"$nulls":32},-1,2,-3]
[]
[]
["Groep H",{"$f":"O62","v":"Portugal"},null,"-",null,{"$f":"O63","v":"Ghana"},{"$nulls":4},"Groep F",{"$f":"IF(E66=\"\",\"Tussenstand\",\"Eindstand\")","v":"Tussenstand"},"Punten",null,"Landen","Saldo","Winst","Gelijk","Verlies","Voor","Tegen","Punten","Punten","onderling","Punten",{"$f":"IF(AND(COUNT(C61:G66)=12,OR(Y62=Y63,Y62=Y64,Y62=Y65,Y63=Y64,Y63=Y65,Y64=Y65)),\"loten:\",\"\")","v":""},{"$nulls":12},{"$f":"IF(C61>E61,1,-1)","v":-1},{"$f":"IF(C61=E61,2,-2)","v":2},{"$f":"IF(C61<E61,3,-3)","v":-3}]
[null,{"$f":"O64","v":"Uruguay"},null,"-",null,{"$f":"O65","v":"Zuid Korea"},{"$nulls":4},"nr 1",{"$f":"IF(COUNT(C61:G62)<4,\"Nr. 1 - groep H\",IF(COUNTIF(M62:M65,M62)>1,INDEX(O19:O65,SMALL(IF(EXACT(M62,AB62:AB65),ROW(O62:O65)),1),0)&\"/\"&INDEX(O19:O65,SMALL(IF(EXACT(M62,AB62:AB65),ROW(AB62:AB65)),2),0),INDEX(O62:O65,MATCH(M62,AB62:AB65,0))))","v":"Nr. 1 - groep H"},{"$f":"LARGE(AB62:AB65,1)","v":0},null,"Portugal",{"$f":"T62-U62","v":0},{"$f":"IF(C61=\"\",0,IF(C61>E61,1,0))+IF(E63=\"\",0,IF(C63>E63,1,0))+IF(E65=\"\",0,IF(E65>C65,1,0))","v":0},{"$f":"IF(E61=\"\",0,IF(C61=E61,1,0))+IF(E63=\"\",0,IF(C63=E63,1,0))+IF(E65=\"\",0,IF(C65=E65,1,0))","v":0},{"$f":"IF(C61=\"\",0,IF(C61<E61,1,0))+IF(E63=\"\",0,IF(C63<E63,1,0))+IF(E65=\"\",0,IF(E65<C65,1,0))","v":0},{"$f":"SUMIF(B21:B66,O62,C21:C66)+SUMIF(F21:F66,O62,E21:E66)","v":0},{"$f":"SUMIF(B21:B66,O62,E21:E66)+SUMIF(F21:F66,O62,C21:C66)","v":0},{"$f":"Q62*3+R62","v":0},{"$f":"V62+P62/100+T62/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W62=W63,C61-E61+(P62-P63)/100+(T62-T63)/10000,0)+IF(W62=W64,C63-E63+(P62-P64)/100+(T62-T64)/10000,0)+IF(W62=W65,E65-C65+(P62-P65)/100+(T62-T65)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W62+X62/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O62","v":"Portugal"},null,{"$f":"Y62+AA62/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O62","v":"Portugal"},null,"-",null,{"$f":"O64","v":"Uruguay"},{"$nulls":4},"nr 2",{"$f":"IF(COUNT(C61:G62)<4,\"Nr. 2 - groep H\",IF(COUNTIF(M62:M65,M63)>1,INDEX(O19:O65,SMALL(IF(EXACT(M63,AB62:AB65),ROW(O62:O65)),1),0)&\"/\"&INDEX(O19:O65,SMALL(IF(EXACT(M63,AB62:AB65),ROW(AB62:AB65)),2),0),INDEX(O62:O65,MATCH(M63,AB62:AB65,0))))","v":"Nr. 2 - groep H"},{"$f":"LARGE(AB62:AB65,2)","v":0},null,"Ghana",{"$f":"T63-U63","v":0},{"$f":"IF(E61=\"\",0,IF(E61>C61,1,0))+IF(E64=\"\",0,IF(E64>C64,1,0))+IF(E66=\"\",0,IF(C66>E66,1,0))","v":0},{"$f":"IF(E61=\"\",0,IF(C61=E61,1,0))+IF(E64=\"\",0,IF(C64=E64,1,0))+IF(E66=\"\",0,IF(C66=E66,1,0))","v":0},{"$f":"IF(E61=\"\",0,IF(E61<C61,1,0))+IF(E64=\"\",0,IF(E64<C64,1,0))+IF(E66=\"\",0,IF(C66<E66,1,0))","v":0},{"$f":"SUMIF(B21:B66,O63,C21:C66)+SUMIF(F21:F66,O63,E21:E66)","v":0},{"$f":"SUMIF(B21:B66,O63,E21:E66)+SUMIF(F21:F66,O63,C21:C66)","v":0},{"$f":"Q63*3+R63","v":0},{"$f":"V63+P63/100+T63/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W63=W62,E61-C61+(P63-P62)/100+(T63-T62)/10000,0)+IF(W63=W64,C66-E66+(P63-P64)/100+(T63-T64)/10000,0)+IF(W63=W65,C64-E64+(P63-P65)/100+(T63-T65)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W63+X63/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O63","v":"Ghana"},null,{"$f":"Y63+AA63/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O65","v":"Zuid Korea"},null,"-",null,{"$f":"O63","v":"Ghana"},{"$nulls":4},"nr 3",{"$f":"IF(COUNT(C61:G62)<4,\"Nr. 3 - groep H\",IF(COUNTIF(M62:M65,M64)>1,INDEX(O19:O66,SMALL(IF(EXACT(M64,AB62:AB65),ROW(O62:O65)),1),0)&\"/\"&INDEX(O19:O66,SMALL(IF(EXACT(M64,AB62:AB65),ROW(AB62:AB65)),2),0),INDEX(O62:O65,MATCH(M64,AB62:AB65,0))))","v":"Nr. 3 - groep H"},{"$f":"LARGE(AB62:AB65,3)","v":0},null,"Uruguay",{"$f":"T64-U64","v":0},{"$f":"IF(E62=\"\",0,IF(C62>E62,1,0))+IF(E63=\"\",0,IF(E63>C63,1,0))+IF(E66=\"\",0,IF(E66>C66,1,0))","v":0},{"$f":"IF(E62=\"\",0,IF(C62=E62,1,0))+IF(E63=\"\",0,IF(C63=E63,1,0))+IF(E66=\"\",0,IF(C66=E66,1,0))","v":0},{"$f":"IF(E62=\"\",0,IF(C62<E62,1,0))+IF(E63=\"\",0,IF(E63<C63,1,0))+IF(E66=\"\",0,IF(E66<C66,1,0))","v":0},{"$f":"SUMIF(B21:B66,O64,C21:C66)+SUMIF(F21:F66,O64,E21:E66)","v":0},{"$f":"SUMIF(B21:B66,O64,E21:E66)+SUMIF(F21:F66,O64,C21:C66)","v":0},{"$f":"Q64*3+R64","v":0},{"$f":"V64+P64/100+T64/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W64=W62,E63-C63+(P64-P62)/100+(T64-T62)/10000,0)+IF(W64=W63,E66-C66+(P64-P63)/100+(T64-T63)/10000,0)+IF(W64=W65,C62-E62+(P64-P65)/100+(T64-T65)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W64+X64/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O64","v":"Uruguay"},null,{"$f":"Y64+AA64/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O65","v":"Zuid Korea"},null,"-",null,{"$f":"O62","v":"Portugal"},{"$nulls":4},"nr 4",{"$f":"IF(COUNT(C61:G62)<4,\"Nr. 4 - groep H\",IF(COUNTIF(M62:M65,M65)>1,INDEX(O19:O66,SMALL(IF(EXACT(M65,AB62:AB65),ROW(O62:O65)),1),0)&\"/\"&INDEX(O19:O66,SMALL(IF(EXACT(M65,AB62:AB65),ROW(AB62:AB65)),2),0),INDEX(O62:O65,MATCH(M65,AB62:AB65,0))))","v":"Nr. 4 - groep H"},{"$f":"LARGE(AB62:AB65,4)","v":0},null,"Zuid Korea",{"$f":"T65-U65","v":0},{"$f":"IF(E62=\"\",0,IF(E62>C62,1,0))+IF(E64=\"\",0,IF(C64>E64,1,0))+IF(E65=\"\",0,IF(C65>E65,1,0))","v":0},{"$f":"IF(E62=\"\",0,IF(C62=E62,1,0))+IF(E64=\"\",0,IF(C64=E64,1,0))+IF(E65=\"\",0,IF(C65=E65,1,0))","v":0},{"$f":"IF(E62=\"\",0,IF(E62<C62,1,0))+IF(E64=\"\",0,IF(C64<E64,1,0))+IF(E65=\"\",0,IF(C65<E65,1,0))","v":0},{"$f":"SUMIF(B21:B66,O65,C21:C66)+SUMIF(F21:F66,O65,E21:E66)","v":0},{"$f":"SUMIF(B21:B66,O65,E21:E66)+SUMIF(F21:F66,O65,C21:C66)","v":0},{"$f":"Q65*3+R65","v":0},{"$f":"V65+P65/100+T65/10000","v":{"v":0,"d":"0.0000"}},{"$f":"IF(W65=W62,C65-E65+(P65-P62)/100+(T65-T62)/10000,0)+IF(W65=W63,E64-C64+(P65-P63)/100+(T65-T63)/10000,0)+IF(W65=W64,E62-C62+(P65-P64)/100+(T65-T64)/10000,0)","v":{"v":0,"d":"0.0000000"}},{"$f":"W65+X65/1000000","v":{"v":0,"d":"0.000000"}},{"$f":"O65","v":"Zuid Korea"},null,{"$f":"Y65+AA65/100000000","v":{"v":0,"d":"0.00000000"}},{"$nulls":10},-1,2,-3]
[null,{"$f":"O63","v":"Ghana"},null,"-",null,{"$f":"O64","v":"Uruguay"},{"$nulls":32},-1,2,-3]
[]
[]
[]
[]
["wedstr"]
["nr","Ronde van 16","Einduitslag",{"$nulls":7},"naar kwartfinale"]
[49,{"$f":"L6","v":"Nr. 1 - groep A"},null,"- ",null,{"$f":"L15","v":"Nr. 2 - groep B"},{"$nulls":4},{"$f":"IF(C73>E73,B73,IF(E73>C73,F73,\"winnaar \"&A73))","v":"winnaar 49"},{"$nulls":27},{"$f":"IF(C73>E73,1,-1)","v":-1},{"$f":"IF(C73=E73,2,-2)","v":2},{"$f":"IF(C73<E73,3,-3)","v":-3},{"$nulls":13},"Vul hier de einduitslag in (inclusief eventuele verlenging)"]
[50,{"$f":"L22","v":"Nr. 1 - groep C"},null,"- ",null,{"$f":"L31","v":"Nr. 2 - groep D"},{"$nulls":4},"winnaar 50",{"$nulls":27},-1,2,-3,{"$nulls":13},"Bij gelijke stand geef je hier aan welk land de winnaar c.q. verliezer is"]
[51,{"$f":"L30","v":"Nr. 1 - groep D"},null,"- ",null,{"$f":"L23","v":"Nr. 2 - groep C"},{"$nulls":4},"winnaar 51",{"$nulls":27},-1,2,-3]
[52,{"$f":"L14","v":"Nr. 1 - groep B"},null,"- ",null,{"$f":"L7","v":"Nr. 2 - groep A"},{"$nulls":4},"winnaar 52",{"$nulls":27},-1,2,-3]
[53,{"$f":"L38","v":"Nr. 1 - groep E"},null,"- ",null,{"$f":"L47","v":"Nr. 2 - groep F"},{"$nulls":4},"winnaar 53",{"$nulls":27},-1,2,-3]
[54,{"$f":"L54","v":"Nr. 1 - groep G"},null,"- ",null,{"$f":"L63","v":"Nr. 2 - groep H"},{"$nulls":4},"winnaar 54",{"$nulls":27},-1,2,-3]
[55,{"$f":"L46","v":"Nr. 1 - groep F"},null,"- ",null,{"$f":"L39","v":"Nr. 2 - groep E"},{"$nulls":4},"winnaar 55",{"$nulls":27},-1,2,-3]
[56,{"$f":"L62","v":"Nr. 1 - groep H"},null,"- ",null,{"$f":"L55","v":"Nr. 2 - groep G"},{"$nulls":4},"winnaar 56",{"$nulls":27},-1,2,-3]
[]
[null,"Kwart finale","Einduitslag"]
[57,{"$f":"K77","v":"winnaar 53"},null,"- ",null,{"$f":"K78","v":"winnaar 54"},{"$nulls":4},{"$f":"IF(C83>E83,B83,IF(E83>C83,F83,\"winnaar \"&A83))","v":"winnaar 57"},{"$nulls":27},{"$f":"IF(C83>E83,1,-1)","v":-1},{"$f":"IF(C83=E83,2,-2)","v":2},{"$f":"IF(C83<E83,3,-3)","v":-3}]
[58,{"$f":"K73","v":"winnaar 49"},null,"- ",null,{"$f":"K74","v":"winnaar 50"},{"$nulls":4},"winnaar 58",{"$nulls":27},-1,2,-3]
[59,{"$f":"K79","v":"winnaar 55"},null,"- ",null,{"$f":"K80","v":"winnaar 56"},{"$nulls":4},"winnaar 59",{"$nulls":27},-1,2,-3]
[60,{"$f":"K75","v":"winnaar 51"},null,"- ",null,{"$f":"K76","v":"winnaar 52"},{"$nulls":4},"winnaar 60",{"$nulls":27},-1,2,-3]
[]
[null,"Halve finale","Einduitslag"]
[61,{"$f":"K83","v":"winnaar 57"},null,"-",null,{"$f":"K84","v":"winnaar 58"},{"$nulls":4},{"$f":"IF(C89>E89,B89,IF(E89>C89,F89,\"winnaar \"&A89))","v":"winnaar 61"},{"$f":"IF(C89<E89,B89,IF(E89<C89,F89,\"verliezer \"&A89))","v":"verliezer 61"},{"$nulls":26},{"$f":"IF(C89>E89,1,-1)","v":-1},{"$f":"IF(C89=E89,2,-2)","v":2},{"$f":"IF(C89<E89,3,-3)","v":-3}]
[62,{"$f":"K85","v":"winnaar 59"},null,"-",null,{"$f":"K86","v":"winnaar 60"},{"$nulls":4},{"$f":"IF(C90>E90,B90,IF(E90>C90,F90,\"winnaar \"&A90))","v":"winnaar 62"},{"$f":"IF(C90<E90,B90,IF(E90<C90,F90,\"verliezer \"&A90))","v":"verliezer 62"},{"$nulls":26},-1,2,-3]
[]
[null,"Verliezende finale","Einduitslag"]
[63,{"$f":"L89","v":"verliezer 61"},null,"-",null,{"$f":"L90","v":"verliezer 62"},{"$nulls":32},{"$f":"IF(C93>E93,1,-1)","v":-1},{"$f":"IF(C93=E93,2,-2)","v":2},{"$f":"IF(C93<E93,3,-3)","v":-3}]
[]
[null,"Finale","Einduitslag"]
[64,{"$f":"K89","v":"winnaar 61"},null,"-",null,{"$f":"K90","v":"winnaar 62"},{"$nulls":32},{"$f":"IF(C96>E96,1,-1)","v":-1},{"$f":"IF(C96=E96,2,-2)","v":2},{"$f":"IF(C96<E96,3,-3)","v":-3}]
[]
[]
[null,"Bonus vragen"]
[null,"Hoeveel goals worden er in totaal gescoord?",{"$nulls":3},{"$f":"SUM(C96,E96,C89:C90,E89:E90,C83:C86,E83:E86,C73:C80,E73:E80,C5:C10,E5:E10,C13:C18,E13:E18,C21:C26,E21:E26,C29:C34,E29:E34,C37:C42,E37:E42,C45:C50,E45:E50,C93,E93,C53:C58,E53:E58,C61:C66,E61:E66)","v":0},{"$nulls":4},"Dit veld hiernaast wordt automatisch ingevuld met jouw ingevulde doelpunten, indien je toch een ander aantal wilt kun je deze overschrijven."]
[]
[null,"Hoeveel rode kaarten vallen in het toernooi?"]
[]
[null,"Welk land levert de topscorer van het toernooi?"]