{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Voorblad","Invoer","Groepsfase","Finales","MC"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":59,"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":"Voorblad","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  EK-voetbal 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2016, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Invoer","index":1,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,7,1,8]]}
[]
[null,null,null,"Sterkte",null,null,null,"Groepschema"]
[null,null,"Landen","Min","Max",null,null,1,2]
[null,"Groep A","Frankrijk",35,85,null,null,3,4]
[null,null,"Roemenië",15,55,null,null,2,4]
[null,null,"Albanië",15,50,null,null,1,3]
[null,null,"Zwitserland",20,65,null,null,2,3]
[null,"Groep B","Engeland",30,80,null,null,4,1]
[null,null,"Rusland",20,65]
[null,null,"Wales",20,65]
[null,null,"Slowakije",15,55]
[null,"Groep C","Duitsland",40,85]
[null,null,"Oekraïne",15,60]
[null,null,"Polen",20,65]
[null,null,"Noord-Ierland",15,55]
[null,"Groep D","Spanje",30,85]
[null,null,"Tsjechië",15,60]
[null,null,"Turkije",15,70]
[null,null,"Kroatië",25,75]
[null,"Groep E","België",31,81]
[null,null,"Italië",25,80]
[null,null,"Ierland",15,55]
[null,null,"Zweden",25,65]
[null,"Groep F","Portugal",25,80]
[null,null,"IJsland",15,65]
[null,null,"Oostenrijk",20,70]
[null,null,"Hongarije",15,55]

{"sheet":"Groepsfase","index":2,"n_rows":39,"n_cols":27,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,15,2,16],[2,12,2,13],[2,22,2,23],[10,22,10,23]]}
[null,null,null,null,1,2]
[]
[null,"GroepNr","Wedstrijd",null,"Land1","Land2","Min","Max","Sterkte1","Min","Max","Sterkte2","Punten",null,null,"Groepsresultaat",null,null,"Nr","Land","Pt",null,"Nr's 3"]
[null,1,1,"Groep A",{"$f":"OFFSET(LandKop,(GroepNr-1)*4+INDEX(GroepSchema,WedNr,E$1),0)","v":"Frankrijk"},"Roemenië",{"$f":"INDEX(Sterkte,MATCH(E4,Landen,0),2)","v":35},{"$f":"INDEX(Sterkte,MATCH(E4,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(G4,H4)","v":56},{"$f":"INDEX(Sterkte,MATCH(F4,Landen,0),2)","v":15},{"$f":"INDEX(Sterkte,MATCH(F4,Landen,0),3)","v":55},{"$f":"RANDBETWEEN(J4,K4)","v":53},{"$f":"IF(I4>L4,3,IF(I4=L4,1,0))","v":3},{"$f":"IF(M4=1,1,IF(M4=3,0,3))","v":0},null,{"$f":"E4","v":"Frankrijk"},{"$f":"SUMIF($E$4:$E$39,P4,$M$4:$M$39)+SUMIF($F$4:$F$39,P4,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":6.0500930000000004},null,1,{"$f":"INDEX($P$4:$P$7,MATCH(U4,$Q$4:$Q$7,0))","v":"Zwitserland"},{"$f":"LARGE($Q$4:$Q$7,S4)","v":9.0735100000000006},null,"A",{"$f":"GA_3P","v":3.0692710000000001}]
[null,1,2,null,"Albanië","Zwitserland",15,50,{"$f":"RANDBETWEEN(G5,H5)","v":20},20,65,{"$f":"RANDBETWEEN(J5,K5)","v":42},{"$f":"IF(I5>L5,3,IF(I5=L5,1,0))","v":0},{"$f":"IF(M5=1,1,IF(M5=3,0,3))","v":3},null,{"$f":"F4","v":"Roemenië"},{"$f":"SUMIF($E$4:$E$39,P5,$M$4:$M$39)+SUMIF($F$4:$F$39,P5,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":3.0692710000000001},null,2,{"$f":"INDEX($P$4:$P$7,MATCH(U5,$Q$4:$Q$7,0))","v":"Frankrijk"},{"$f":"LARGE($Q$4:$Q$7,S5)","v":6.0500930000000004},null,"B",{"$f":"GB_3P","v":3.0445380000000002}]
[null,1,3,null,"Roemenië","Zwitserland",15,55,30,20,65,65,0,3,null,{"$f":"E5","v":"Albanië"},5.2148E-2,null,3,"Roemenië",3.0692710000000001,null,"C",{"$f":"GC_3P","v":3.0621}]
[null,1,4,null,"Frankrijk","Albanië",35,85,75,15,50,18,3,0,null,{"$f":"F5","v":"Zwitserland"},9.0735100000000006,null,4,"Albanië",5.2148E-2,null,"D",{"$f":"GD_3P","v":3.0593620000000001}]
[null,1,5,null,"Roemenië","Albanië",15,55,51,15,50,43,3,0,null,null,null,null,null,null,null,null,"E",{"$f":"GE_3P","v":3.0462899999999999}]
[null,1,6,null,"Zwitserland","Frankrijk",20,65,44,35,85,42,3,0,null,null,null,null,null,null,null,null,"F",{"$f":"GF_3P","v":3.035644}]
[null,2,1,"Groep B","Engeland","Rusland",30,80,36,20,65,57,0,3,null,{"$f":"E10","v":"Engeland"},{"$f":"SUMIF($E$4:$E$39,P10,$M$4:$M$39)+SUMIF($F$4:$F$39,P10,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":3.0445380000000002},null,1,{"$f":"INDEX($P$10:$P$13,MATCH(U10,$Q$10:$Q$13,0))","v":"Rusland"},{"$f":"LARGE($Q$10:$Q$13,S10)","v":9.0711659999999998}]
[null,2,2,null,"Wales","Slowakije",20,65,58,15,55,44,3,0,null,{"$f":"F10","v":"Rusland"},9.0711659999999998,null,2,{"$f":"INDEX($P$10:$P$13,MATCH(U11,$Q$10:$Q$13,0))","v":"Wales"},{"$f":"LARGE($Q$10:$Q$13,S11)","v":6.0813249999999996},null,"Beste Nr's 3"]
[null,2,3,null,"Rusland","Slowakije",20,65,33,15,55,19,3,0,null,{"$f":"E11","v":"Wales"},6.0813249999999996,null,3,{"$f":"INDEX($P$10:$P$13,MATCH(U12,$Q$10:$Q$13,0))","v":"Engeland"},3.0445380000000002,null,1,{"$f":"LARGE($X$4:$X$9,W12)","v":3.0692710000000001},{"$f":"INDEX($W$4:$W$9,MATCH(X12,$X$4:$X$9,0))","v":"A"}]
[null,2,4,null,"Engeland","Wales",30,80,48,20,65,55,0,3,null,{"$f":"F11","v":"Slowakije"},8.7180000000000001E-3,null,4,{"$f":"INDEX($P$10:$P$13,MATCH(U13,$Q$10:$Q$13,0))","v":"Slowakije"},8.7180000000000001E-3,null,2,{"$f":"LARGE($X$4:$X$9,W13)","v":3.0621},{"$f":"INDEX($W$4:$W$9,MATCH(X13,$X$4:$X$9,0))","v":"C"}]
[null,2,5,null,"Rusland","Wales",20,65,47,20,65,25,3,0,null,null,null,null,null,null,null,null,3,3.0593620000000001,"D"]
[null,2,6,null,"Slowakije","Engeland",15,55,18,30,80,70,0,3,null,null,null,null,null,null,null,null,4,3.0462899999999999,"E"]
[null,3,1,"Groep C","Duitsland","Oekraïne",40,85,51,15,60,{"$f":"RANDBETWEEN(J16,K16)","v":35},3,0,null,{"$f":"E16","v":"Duitsland"},{"$f":"SUMIF($E$4:$E$39,P16,$M$4:$M$39)+SUMIF($F$4:$F$39,P16,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":9.0041759999999993},null,1,{"$f":"INDEX($P$16:$P$19,MATCH(U16,$Q$16:$Q$19,0))","v":"Duitsland"},{"$f":"LARGE($Q$16:$Q$19,S16)","v":9.0041759999999993},null,null,null,{"$f":"CHAR(LARGE(CODE(Y12:Y15),4))&CHAR(LARGE(CODE(Y12:Y15),3))&CHAR(LARGE(CODE(Y12:Y15),2))&CHAR(LARGE(CODE(Y12:Y15),1))","v":"ACDE"}]
[null,3,2,null,"Polen","Noord-Ierland",20,65,23,15,55,37,0,3,null,{"$f":"F16","v":"Oekraïne"},2.6506999999999999E-2,null,2,{"$f":"INDEX($P$16:$P$19,MATCH(U17,$Q$16:$Q$19,0))","v":"Noord-Ierland"},{"$f":"LARGE($Q$16:$Q$19,S17)","v":6.0421750000000003}]
[null,3,3,null,"Oekraïne","Noord-Ierland",15,60,21,15,55,{"$f":"RANDBETWEEN(J18,K18)","v":38},0,3,null,{"$f":"E17","v":"Polen"},3.0621,null,3,"Polen",3.0621,null,null,"Winnaar Groep A v","Winnaar Groep B v","Winnaar Groep C v","Winnaar Groep D v"]
[null,3,4,null,"Duitsland","Polen",40,85,44,20,65,22,3,0,null,{"$f":"F17","v":"Noord-Ierland"},6.0421750000000003,null,4,"Oekraïne",2.6506999999999999E-2,null,"ABCD",{"$f":"GC_3","v":"Polen"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GB_3","v":"Engeland"}]
[null,3,5,null,"Oekraïne","Polen",15,60,33,20,65,52,0,3,null,null,null,null,null,null,null,null,"ABCE",{"$f":"GC_3","v":"Polen"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GE_3","v":"Italië"}]
[null,3,6,null,"Noord-Ierland","Duitsland",15,55,15,40,85,68,0,3,null,null,null,null,null,null,null,null,"ABCF",{"$f":"GC_3","v":"Polen"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GF_3","v":"Hongarije"}]
[null,4,1,"Groep D","Spanje","Tsjechië",30,85,75,15,60,41,3,0,null,{"$f":"E22","v":"Spanje"},{"$f":"SUMIF($E$4:$E$39,P22,$M$4:$M$39)+SUMIF($F$4:$F$39,P22,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":9.0312289999999997},null,1,{"$f":"INDEX($P$22:$P$25,MATCH(U22,$Q$22:$Q$25,0))","v":"Spanje"},{"$f":"LARGE($Q$22:$Q$25,S22)","v":9.0312289999999997},null,"ABDE",{"$f":"GD_3","v":"Tsjechië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GE_3","v":"Italië"}]
[null,4,2,null,"Turkije","Kroatië",15,70,35,25,75,55,0,3,null,{"$f":"F22","v":"Tsjechië"},3.0593620000000001,null,2,{"$f":"INDEX($P$22:$P$25,MATCH(U23,$Q$22:$Q$25,0))","v":"Kroatië"},{"$f":"LARGE($Q$22:$Q$25,S23)","v":6.062881},null,"ABDF",{"$f":"GD_3","v":"Tsjechië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GF_3","v":"Hongarije"}]
[null,4,3,null,{"$f":"OFFSET(LandKop,(GroepNr-1)*4+INDEX(GroepSchema,WedNr,E$1),0)","v":"Tsjechië"},"Kroatië",15,60,38,25,75,{"$f":"RANDBETWEEN(J24,K24)","v":64},0,3,null,{"$f":"E23","v":"Turkije"},1.977E-3,null,3,"Tsjechië",3.0593620000000001,null,"ABEF",{"$f":"GE_3","v":"Italië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GF_3","v":"Hongarije"}]
[null,4,4,null,"Spanje","Turkije",30,85,65,15,70,44,3,0,null,{"$f":"F23","v":"Kroatië"},6.062881,null,4,"Turkije",1.977E-3,null,"ACDE",{"$f":"GC_3","v":"Polen"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GE_3","v":"Italië"}]
[null,4,5,null,"Tsjechië","Turkije",15,60,21,15,70,16,3,0,null,null,null,null,null,null,null,null,"ACDF",{"$f":"GC_3","v":"Polen"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GF_3","v":"Hongarije"}]
[null,4,6,null,"Kroatië","Spanje",25,75,35,30,85,79,0,3,null,null,null,null,null,null,null,null,"ACEF",{"$f":"GC_3","v":"Polen"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GF_3","v":"Hongarije"},{"$f":"GE_3","v":"Italië"}]
[null,5,1,"Groep E","België","Italië",31,81,38,25,80,37,3,0,null,{"$f":"E28","v":"België"},{"$f":"SUMIF($E$4:$E$39,P28,$M$4:$M$39)+SUMIF($F$4:$F$39,P28,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":9.0065249999999999},null,1,{"$f":"INDEX($P$28:$P$31,MATCH(U28,$Q$28:$Q$31,0))","v":"België"},{"$f":"LARGE($Q$28:$Q$31,S28)","v":9.0065249999999999},null,"ADEF",{"$f":"GD_3","v":"Tsjechië"},{"$f":"GA_3","v":"Roemenië"},{"$f":"GF_3","v":"Hongarije"},{"$f":"GE_3","v":"Italië"}]
[null,5,2,null,"Ierland","Zweden",15,55,27,25,65,36,0,3,null,{"$f":"F28","v":"Italië"},3.0462899999999999,null,2,{"$f":"INDEX($P$28:$P$31,MATCH(U29,$Q$28:$Q$31,0))","v":"Zweden"},{"$f":"LARGE($Q$28:$Q$31,S29)","v":6.0751670000000004},null,"BCDE",{"$f":"GC_3","v":"Polen"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GE_3","v":"Italië"}]
[null,5,3,null,"Italië","Zweden",25,80,38,25,65,61,0,3,null,{"$f":"E29","v":"Ierland"},8.8836999999999999E-2,null,3,"Italië",3.0462899999999999,null,"BCDF",{"$f":"GC_3","v":"Polen"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GF_3","v":"Hongarije"}]
[null,5,4,null,"België","Ierland",31,81,56,15,55,18,3,0,null,{"$f":"F29","v":"Zweden"},6.0751670000000004,null,4,"Ierland",8.8836999999999999E-2,null,"BCEF",{"$f":"GE_3","v":"Italië"},{"$f":"GC_3","v":"Polen"},{"$f":"GB_3","v":"Engeland"},{"$f":"GF_3","v":"Hongarije"}]
[null,5,5,null,"Italië","Ierland",25,80,54,15,55,29,3,0,null,null,null,null,null,null,null,null,"BDEF",{"$f":"GE_3","v":"Italië"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GB_3","v":"Engeland"},{"$f":"GF_3","v":"Hongarije"}]
[null,5,6,null,"Zweden","België",25,65,43,31,81,73,0,{"$f":"IF(M33=1,1,IF(M33=3,0,3))","v":3},null,null,null,null,null,null,null,null,"CDEF",{"$f":"GC_3","v":"Polen"},{"$f":"GD_3","v":"Tsjechië"},{"$f":"GF_3","v":"Hongarije"},{"$f":"GE_3","v":"Italië"}]
[null,6,1,"Groep F","Portugal","IJsland",25,80,71,15,65,{"$f":"RANDBETWEEN(J34,K34)","v":34},3,0,null,{"$f":"E34","v":"Portugal"},{"$f":"SUMIF($E$4:$E$39,P34,$M$4:$M$39)+SUMIF($F$4:$F$39,P34,$N$4:$N$39)+RANDBETWEEN(1,90000)/1000000","v":9.0759720000000002},null,1,{"$f":"INDEX($P$34:$P$37,MATCH(U34,$Q$34:$Q$37,0))","v":"Portugal"},{"$f":"LARGE($Q$34:$Q$37,S34)","v":9.0759720000000002}]
[null,6,2,null,"Oostenrijk","Hongarije",20,70,38,15,55,43,0,3,null,{"$f":"F34","v":"IJsland"},3.022894,null,2,{"$f":"INDEX($P$34:$P$37,MATCH(U35,$Q$34:$Q$37,0))","v":"Oostenrijk"},{"$f":"LARGE($Q$34:$Q$37,S35)","v":3.054071}]
[null,6,3,null,"IJsland","Hongarije",15,65,{"$f":"RANDBETWEEN(G36,H36)","v":60},15,55,37,{"$f":"IF(I36>L36,3,IF(I36=L36,1,0))","v":3},0,null,{"$f":"E35","v":"Oostenrijk"},3.054071,null,3,"Hongarije",3.035644]
[null,6,4,null,"Portugal","Oostenrijk",25,80,26,20,70,20,3,0,null,{"$f":"F35","v":"Hongarije"},3.035644,null,4,"IJsland",3.022894]
[null,6,5,null,"IJsland","Oostenrijk",15,65,30,20,70,69,0,3]
[null,6,6,null,"Hongarije","Portugal",15,55,37,25,80,71,0,3]

{"sheet":"Finales","index":3,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11],[1,13,1,17],[1,19,1,24]]}
[]
[null,"1/8 Finales",null,null,null,null,null,"1/4 Finales",null,null,null,null,null,"1/2 Finales",null,null,null,null,null,"Finale"]
[null,{"$f":"GA_2","v":"Frankrijk"},{"$f":"INDEX(Sterkte,MATCH(B3,Landen,0),2)","v":35},{"$f":"INDEX(Sterkte,MATCH(B3,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(C3,D3)","v":35}]
[null,null,null,null,null,{"$f":"IF(E3>=E5,B3,B5)","v":"Frankrijk"}]
[null,{"$f":"GC_2","v":"Noord-Ierland"},{"$f":"INDEX(Sterkte,MATCH(B5,Landen,0),2)","v":15},{"$f":"INDEX(Sterkte,MATCH(B5,Landen,0),3)","v":55},{"$f":"RANDBETWEEN(C5,D5)","v":27}]
[]
[null,{"$f":"GB_1","v":"Rusland"},{"$f":"INDEX(Sterkte,MATCH(B7,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(B7,Landen,0),3)","v":65},{"$f":"RANDBETWEEN(C7,D7)","v":25}]
[null,null,null,null,null,{"$f":"IF(E7>=E9,B7,B9)","v":"Tsjechië"}]
[null,{"$f":"VLOOKUP(Serie3,Series3,3,FALSE)","v":"Tsjechië"},{"$f":"INDEX(Sterkte,MATCH(B9,Landen,0),2)","v":15},{"$f":"INDEX(Sterkte,MATCH(B9,Landen,0),3)","v":60},{"$f":"RANDBETWEEN(C9,D9)","v":30}]
[]
[null,{"$f":"GD_1","v":"Spanje"},{"$f":"INDEX(Sterkte,MATCH(B11,Landen,0),2)","v":30},{"$f":"INDEX(Sterkte,MATCH(B11,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(C11,D11)","v":36},null,null,{"$f":"AF_5","v":"Duitsland"},{"$f":"INDEX(Sterkte,MATCH(H11,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(H11,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(I11,J11)","v":50}]
[null,null,null,null,null,{"$f":"IF(E11>=E13,B11,B13)","v":"Italië"},null,null,null,null,null,{"$f":"IF(K11>=K13,H11,H13)","v":"Portugal"}]
[null,{"$f":"VLOOKUP(Serie3,Series3,5,FALSE)","v":"Italië"},{"$f":"INDEX(Sterkte,MATCH(B13,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(B13,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(C13,D13)","v":60},null,null,{"$f":"AF_6","v":"Portugal"},{"$f":"INDEX(Sterkte,MATCH(H13,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(H13,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(I13,J13)","v":52}]
[]
[null,{"$f":"GA_1","v":"Zwitserland"},{"$f":"INDEX(Sterkte,MATCH(B15,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(B15,Landen,0),3)","v":65},{"$f":"RANDBETWEEN(C15,D15)","v":65},null,null,{"$f":"AF_1","v":"Frankrijk"},{"$f":"INDEX(Sterkte,MATCH(H15,Landen,0),2)","v":35},{"$f":"INDEX(Sterkte,MATCH(H15,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(I15,J15)","v":85},null,null,{"$f":"KF_2","v":"Frankrijk"},{"$f":"INDEX(Sterkte,MATCH(N15,Landen,0),2)","v":35},{"$f":"INDEX(Sterkte,MATCH(N15,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(O15,P15)","v":44}]
[null,null,null,null,null,{"$f":"IF(E15>=E17,B15,B17)","v":"Zwitserland"},null,null,null,null,null,{"$f":"IF(K15>=K17,H15,H17)","v":"Frankrijk"},null,null,null,null,null,{"$f":"IF(Q15>=Q17,N15,N17)","v":"Portugal"},null,{"$f":"HF_1","v":"Portugal"},{"$f":"INDEX(Sterkte,MATCH(T16,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(T16,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(U16,V16)","v":37}]
[null,{"$f":"VLOOKUP(Serie3,Series3,2,FALSE)","v":"Polen"},{"$f":"INDEX(Sterkte,MATCH(B17,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(B17,Landen,0),3)","v":65},{"$f":"RANDBETWEEN(C17,D17)","v":30},null,null,{"$f":"AF_2","v":"Tsjechië"},{"$f":"INDEX(Sterkte,MATCH(H17,Landen,0),2)","v":15},{"$f":"INDEX(Sterkte,MATCH(H17,Landen,0),3)","v":60},{"$f":"RANDBETWEEN(I17,J17)","v":20},null,null,{"$f":"KF_1","v":"Portugal"},{"$f":"INDEX(Sterkte,MATCH(N17,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(N17,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(O17,P17)","v":47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W16>=W20,T16,T20)","v":"Portugal"}]
[null,{"$f":"GC_1","v":"Duitsland"},{"$f":"INDEX(Sterkte,MATCH(B19,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(B19,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(C19,D19)","v":44},null,null,{"$f":"AF_7","v":"België"},{"$f":"INDEX(Sterkte,MATCH(H19,Landen,0),2)","v":31},{"$f":"INDEX(Sterkte,MATCH(H19,Landen,0),3)","v":81},{"$f":"RANDBETWEEN(I19,J19)","v":75},null,null,{"$f":"KF_4","v":"Italië"},{"$f":"INDEX(Sterkte,MATCH(N19,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(N19,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(O19,P19)","v":48}]
[null,null,null,null,null,{"$f":"IF(E19>=E21,B19,B21)","v":"Duitsland"},null,null,null,null,null,{"$f":"IF(K19>=K21,H19,H21)","v":"België"},null,null,null,null,null,{"$f":"IF(Q19>=Q21,N19,N21)","v":"Italië"},null,{"$f":"HF_2","v":"Italië"},{"$f":"INDEX(Sterkte,MATCH(T20,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(T20,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(U20,V20)","v":37}]
[null,{"$f":"VLOOKUP(Serie3,Series3,4,FALSE)","v":"Roemenië"},{"$f":"INDEX(Sterkte,MATCH(B21,Landen,0),2)","v":15},{"$f":"INDEX(Sterkte,MATCH(B21,Landen,0),3)","v":55},{"$f":"RANDBETWEEN(C21,D21)","v":28},null,null,{"$f":"AF_8","v":"Oostenrijk"},{"$f":"INDEX(Sterkte,MATCH(H21,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(H21,Landen,0),3)","v":70},{"$f":"RANDBETWEEN(I21,J21)","v":57},null,null,{"$f":"KF_3","v":"België"},{"$f":"INDEX(Sterkte,MATCH(N21,Landen,0),2)","v":31},{"$f":"INDEX(Sterkte,MATCH(N21,Landen,0),3)","v":81},{"$f":"RANDBETWEEN(O21,P21)","v":40}]
[]
[null,{"$f":"GF_1","v":"Portugal"},{"$f":"INDEX(Sterkte,MATCH(B23,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(B23,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(C23,D23)","v":69},null,null,{"$f":"AF_3","v":"Italië"},{"$f":"INDEX(Sterkte,MATCH(H23,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(H23,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(I23,J23)","v":43}]
[null,null,null,null,null,{"$f":"IF(E23>=E25,B23,B25)","v":"Portugal"},null,null,null,null,null,{"$f":"IF(K23>=K25,H23,H25)","v":"Italië"}]
[null,{"$f":"GE_2","v":"Zweden"},{"$f":"INDEX(Sterkte,MATCH(B25,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(B25,Landen,0),3)","v":65},{"$f":"RANDBETWEEN(C25,D25)","v":35},null,null,{"$f":"AF_4","v":"Zwitserland"},{"$f":"INDEX(Sterkte,MATCH(H25,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(H25,Landen,0),3)","v":65},{"$f":"RANDBETWEEN(I25,J25)","v":42}]
[]
[null,{"$f":"GE_1","v":"België"},{"$f":"INDEX(Sterkte,MATCH(B27,Landen,0),2)","v":31},{"$f":"INDEX(Sterkte,MATCH(B27,Landen,0),3)","v":81},{"$f":"RANDBETWEEN(C27,D27)","v":42}]
[null,null,null,null,null,{"$f":"IF(E27>=E29,B27,B29)","v":"België"}]
[null,{"$f":"GD_2","v":"Kroatië"},{"$f":"INDEX(Sterkte,MATCH(B29,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(B29,Landen,0),3)","v":75},{"$f":"RANDBETWEEN(C29,D29)","v":31}]
[]
[null,{"$f":"GB_2","v":"Wales"},{"$f":"INDEX(Sterkte,MATCH(B31,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(B31,Landen,0),3)","v":65},{"$f":"RANDBETWEEN(C31,D31)","v":28}]
[null,null,null,null,null,{"$f":"IF(E31>=E33,B31,B33)","v":"Oostenrijk"}]
[null,{"$f":"GF_2","v":"Oostenrijk"},{"$f":"INDEX(Sterkte,MATCH(B33,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(B33,Landen,0),3)","v":70},{"$f":"RANDBETWEEN(C33,D33)","v":62}]

{"sheet":"MC","index":4,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,8,3,9],[4,8,4,9]]}
[]
[]
[null,"Land","Aantal","Perc"]
[null,{"$f":"Landen","v":"Frankrijk"},179,{"$f":"+C4/$C$28","v":0.17899999999999999},null,null,null,null,"Aantal per run"]
[null,"Roemenië",2,2E-3,null,null,null,null,50]
[null,"Albanië",1,1E-3]
[null,"Zwitserland",13,1.2999999999999999E-2]
[null,"Engeland",93,9.2999999999999999E-2]
[null,"Rusland",12,1.2E-2]
[null,"Wales",9,8.9999999999999993E-3]
[null,"Slowakije",1,1E-3]
[null,"Duitsland",290,0.28999999999999998]
[null,"Oekraïne",null,0]
[null,"Polen",17,1.7000000000000001E-2]
[null,"Noord-Ierland",1,1E-3]
[null,"Spanje",106,0.106]
[null,"Tsjechië",null,0]
[null,"Turkije",8,8.0000000000000002E-3]
[null,"Kroatië",43,4.2999999999999997E-2]
[null,"België",95,9.5000000000000001E-2]
[null,"Italië",55,5.5E-2]
[null,"Ierland",1,1E-3]
[null,"Zweden",8,8.0000000000000002E-3]
[null,"Portugal",46,4.5999999999999999E-2]
[null,"IJsland",6,6.0000000000000001E-3]
[null,"Oostenrijk",14,1.4E-2]
[null,"Hongarije",null,0]
[null,null,{"$f":"SUM(C4:C27)","v":1000},1]