{"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":39,"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":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  WK-voetbal 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2014, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mail: Vraag/opmerking over WK-voetbal 2014"]

{"sheet":"Invoer","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"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","Brazilië",40,85,null,null,3,4]
[null,null,"Kroatië",11,71,null,null,1,3]
[null,null,"Mexico",11,71,null,null,4,2]
[null,null,"Kameroen",11,71,null,null,4,1]
[null,"Groep B","Spanje",20,85,null,null,2,3]
[null,null,"Nederland",15,75]
[null,null,"Chili",11,71]
[null,null,"Australië",11,71]
[null,"Groep C","Colombia",11,71]
[null,null,"Griekenland",11,71]
[null,null,"Ivoorkust",11,71]
[null,null,"Japan",11,71]
[null,"Groep D","Uruguay",11,71]
[null,null,"Costa Rica",11,71]
[null,null,"Engeland",12,72]
[null,null,"Italië",12,72]
[null,"Groep E","Zwitserland",11,71]
[null,null,"Ecuador",11,71]
[null,null,"Frankrijk",11,71]
[null,null,"Honduras",11,71]
[null,"Groep F","Argentinië",25,85]
[null,null,"Bosnië-Herzegovina",11,71]
[null,null,"Iran",11,71]
[null,null,"Nigeria",11,71]
[null,"Groep G","Duitsland",20,80]
[null,null,"Portugal",11,71]
[null,null,"Ghana",11,71]
[null,null,"VS",11,71]
[null,"Groep H","België",11,71]
[null,null,"Algerije",11,71]
[null,null,"Rusland",11,71]
[null,null,"Zuid-Korea",11,71]

{"sheet":"Groepsfase","index":2,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,15,2,16],[2,12,2,13]]}
[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,1,1,"Groep A",{"$f":"OFFSET(LandKop,(GroepNr-1)*4+INDEX(GroepSchema,WedNr,E$1),0)","v":"Brazilië"},"Kroatië",{"$f":"INDEX(Sterkte,MATCH(E4,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(E4,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(G4,H4)","v":74},{"$f":"INDEX(Sterkte,MATCH(F4,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(F4,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(J4,K4)","v":58},{"$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":"Brazilië"},{"$f":"SUMIF($E$4:$E$51,P4,$M$4:$M$51)+SUMIF($F$4:$F$51,P4,$N$4:$N$51)+RAND()/10000","v":6.0000350446436128},null,1,{"$f":"INDEX($P$4:$P$7,MATCH(U4,$Q$4:$Q$7,0))","v":"Kameroen"},{"$f":"LARGE($Q$4:$Q$7,S4)","v":9.0000420431395582}]
[null,1,2,null,"Mexico","Kameroen",11,71,{"$f":"RANDBETWEEN(G5,H5)","v":22},11,71,{"$f":"RANDBETWEEN(J5,K5)","v":56},{"$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":"Kroatië"},{"$f":"SUMIF($E$4:$E$51,P5,$M$4:$M$51)+SUMIF($F$4:$F$51,P5,$N$4:$N$51)+RAND()/10000","v":5.6997495510492716E-6},null,2,{"$f":"INDEX($P$4:$P$7,MATCH(U5,$Q$4:$Q$7,0))","v":"Brazilië"},{"$f":"LARGE($Q$4:$Q$7,S5)","v":6.0000350446436128}]
[null,1,3,null,"Brazilië","Mexico",40,85,76,11,71,32,3,0,null,{"$f":"E5","v":"Mexico"},3.0000323797575983,null,3,"Mexico",3.0000323797575983]
[null,1,4,null,"Kameroen","Kroatië",11,71,62,11,71,17,3,0,null,{"$f":"F5","v":"Kameroen"},9.0000420431395582,null,4,"Kroatië",5.6997495510492716E-6]
[null,1,5,null,"Kameroen","Brazilië",11,71,63,40,85,55,3,0]
[null,1,6,null,"Kroatië","Mexico",11,71,11,11,71,27,0,3]
[null,2,1,"Groep B","Spanje","Nederland",20,85,33,15,75,74,0,3,null,{"$f":"E10","v":"Spanje"},{"$f":"SUMIF($E$4:$E$51,P10,$M$4:$M$51)+SUMIF($F$4:$F$51,P10,$N$4:$N$51)+RAND()/10000","v":3.0000621095446909},null,1,{"$f":"INDEX($P$10:$P$13,MATCH(U10,$Q$10:$Q$13,0))","v":"Chili"},{"$f":"LARGE($Q$10:$Q$13,S10)","v":6.000024106362253}]
[null,2,2,null,"Chili","Australië",11,71,60,11,71,58,3,0,null,{"$f":"F10","v":"Nederland"},{"$f":"SUMIF($E$4:$E$51,P11,$M$4:$M$51)+SUMIF($F$4:$F$51,P11,$N$4:$N$51)+RAND()/10000","v":6.0000208930050549},null,2,{"$f":"INDEX($P$10:$P$13,MATCH(U11,$Q$10:$Q$13,0))","v":"Nederland"},{"$f":"LARGE($Q$10:$Q$13,S11)","v":6.0000208930050549}]
[null,2,3,null,"Spanje","Chili",20,85,82,11,71,47,3,0,null,{"$f":"E11","v":"Chili"},6.000024106362253,null,3,{"$f":"INDEX($P$10:$P$13,MATCH(U12,$Q$10:$Q$13,0))","v":"Spanje"},3.0000621095446909]
[null,2,4,null,"Australië","Nederland",11,71,11,15,75,27,0,3,null,{"$f":"F11","v":"Australië"},3.0000525146714043,null,4,{"$f":"INDEX($P$10:$P$13,MATCH(U13,$Q$10:$Q$13,0))","v":"Australië"},3.0000525146714043]
[null,2,5,null,"Australië","Spanje",11,71,25,20,85,20,3,0]
[null,2,6,null,"Nederland","Chili",15,75,26,11,71,52,0,3]
[null,3,1,"Groep C","Colombia","Griekenland",11,71,24,11,71,{"$f":"RANDBETWEEN(J16,K16)","v":41},0,3,null,{"$f":"E16","v":"Colombia"},{"$f":"SUMIF($E$4:$E$51,P16,$M$4:$M$51)+SUMIF($F$4:$F$51,P16,$N$4:$N$51)+RAND()/10000","v":1.5094431933133379E-5},null,1,{"$f":"INDEX($P$16:$P$19,MATCH(U16,$Q$16:$Q$19,0))","v":"Japan"},{"$f":"LARGE($Q$16:$Q$19,S16)","v":9.0000747427678416}]
[null,3,2,null,"Ivoorkust","Japan",11,71,22,11,71,28,0,3,null,{"$f":"F16","v":"Griekenland"},{"$f":"SUMIF($E$4:$E$51,P17,$M$4:$M$51)+SUMIF($F$4:$F$51,P17,$N$4:$N$51)+RAND()/10000","v":3.0000394025708079},null,2,{"$f":"INDEX($P$16:$P$19,MATCH(U17,$Q$16:$Q$19,0))","v":"Ivoorkust"},{"$f":"LARGE($Q$16:$Q$19,S17)","v":6.0000870311185963}]
[null,3,3,null,"Colombia","Ivoorkust",11,71,24,11,71,{"$f":"RANDBETWEEN(J18,K18)","v":62},0,3,null,{"$f":"E17","v":"Ivoorkust"},6.0000870311185963,null,3,"Griekenland",3.0000394025708079]
[null,3,4,null,"Japan","Griekenland",11,71,19,11,71,11,3,0,null,{"$f":"F17","v":"Japan"},9.0000747427678416,null,4,"Colombia",1.5094431933133379E-5]
[null,3,5,null,"Japan","Colombia",11,71,69,11,71,41,3,0]
[null,3,6,null,"Griekenland","Ivoorkust",11,71,39,11,71,48,0,3]
[null,4,1,"Groep D","Uruguay","Costa Rica",11,71,23,11,71,40,0,3,null,{"$f":"E22","v":"Uruguay"},{"$f":"SUMIF($E$4:$E$51,P22,$M$4:$M$51)+SUMIF($F$4:$F$51,P22,$N$4:$N$51)+RAND()/10000","v":5.5645911047384865E-5},null,1,{"$f":"INDEX($P$22:$P$25,MATCH(U22,$Q$22:$Q$25,0))","v":"Costa Rica"},{"$f":"LARGE($Q$22:$Q$25,S22)","v":9.0000519274548285}]
[null,4,2,null,"Engeland","Italië",12,72,14,12,72,50,0,3,null,{"$f":"F22","v":"Costa Rica"},9.0000519274548285,null,2,{"$f":"INDEX($P$22:$P$25,MATCH(U23,$Q$22:$Q$25,0))","v":"Italië"},{"$f":"LARGE($Q$22:$Q$25,S23)","v":6.0000833699682161}]
[null,4,3,null,{"$f":"OFFSET(LandKop,(GroepNr-1)*4+INDEX(GroepSchema,WedNr,E$1),0)","v":"Uruguay"},"Engeland",11,71,44,12,72,{"$f":"RANDBETWEEN(J24,K24)","v":60},0,3,null,{"$f":"E23","v":"Engeland"},3.0000197335651224,null,3,"Engeland",3.0000197335651224]
[null,4,4,null,"Italië","Costa Rica",12,72,64,11,71,71,0,3,null,{"$f":"F23","v":"Italië"},6.0000833699682161,null,4,"Uruguay",5.5645911047384865E-5]
[null,4,5,null,"Italië","Uruguay",12,72,38,11,71,36,3,0]
[null,4,6,null,"Costa Rica","Engeland",11,71,66,12,72,31,3,0]
[null,5,1,"Groep E","Zwitserland","Ecuador",11,71,70,11,71,16,3,0,null,{"$f":"E28","v":"Zwitserland"},{"$f":"SUMIF($E$4:$E$51,P28,$M$4:$M$51)+SUMIF($F$4:$F$51,P28,$N$4:$N$51)+RAND()/10000","v":9.0000231906692463},null,1,{"$f":"INDEX($P$28:$P$31,MATCH(U28,$Q$28:$Q$31,0))","v":"Zwitserland"},{"$f":"LARGE($Q$28:$Q$31,S28)","v":9.0000231906692463}]
[null,5,2,null,"Frankrijk","Honduras",11,71,39,11,71,13,3,0,null,{"$f":"F28","v":"Ecuador"},6.1635854469245659E-5,null,2,{"$f":"INDEX($P$28:$P$31,MATCH(U29,$Q$28:$Q$31,0))","v":"Frankrijk"},{"$f":"LARGE($Q$28:$Q$31,S29)","v":6.0000752845207614}]
[null,5,3,null,"Zwitserland","Frankrijk",11,71,66,11,71,12,3,0,null,{"$f":"E29","v":"Frankrijk"},6.0000752845207614,null,3,"Honduras",3.0000188371825129]
[null,5,4,null,"Honduras","Ecuador",11,71,33,11,71,11,3,0,null,{"$f":"F29","v":"Honduras"},3.0000188371825129,null,4,"Ecuador",6.1635854469245659E-5]
[null,5,5,null,"Honduras","Zwitserland",11,71,57,11,71,66,0,3]
[null,5,6,null,"Ecuador","Frankrijk",11,71,16,11,71,50,0,{"$f":"IF(M33=1,1,IF(M33=3,0,3))","v":3}]
[null,6,1,"Groep F","Argentinië","Bosnië-Herzegovina",25,85,83,11,71,{"$f":"RANDBETWEEN(J34,K34)","v":59},3,0,null,{"$f":"E34","v":"Argentinië"},{"$f":"SUMIF($E$4:$E$51,P34,$M$4:$M$51)+SUMIF($F$4:$F$51,P34,$N$4:$N$51)+RAND()/10000","v":6.0000804532921004},null,1,{"$f":"INDEX($P$34:$P$37,MATCH(U34,$Q$34:$Q$37,0))","v":"Argentinië"},{"$f":"LARGE($Q$34:$Q$37,S34)","v":6.0000804532921004}]
[null,6,2,null,"Iran","Nigeria",11,71,51,11,71,64,0,3,null,{"$f":"F34","v":"Bosnië-Herzegovina"},3.00001291480006,null,2,{"$f":"INDEX($P$34:$P$37,MATCH(U35,$Q$34:$Q$37,0))","v":"Nigeria"},{"$f":"LARGE($Q$34:$Q$37,S35)","v":6.0000579083808736}]
[null,6,3,null,"Argentinië","Iran",25,85,{"$f":"RANDBETWEEN(G36,H36)","v":76},11,71,46,{"$f":"IF(I36>L36,3,IF(I36=L36,1,0))","v":3},0,null,{"$f":"E35","v":"Iran"},3.0000965215019511,null,3,"Iran",3.0000965215019511]
[null,6,4,null,"Nigeria","Bosnië-Herzegovina",11,71,29,11,71,37,0,3,null,{"$f":"F35","v":"Nigeria"},6.0000579083808736,null,4,"Bosnië-Herzegovina",3.00001291480006]
[null,6,5,null,"Nigeria","Argentinië",11,71,40,25,85,28,3,0]
[null,6,6,null,"Bosnië-Herzegovina","Iran",11,71,48,11,71,67,0,3]
[null,7,1,"Groep G","Duitsland","Portugal",20,80,80,11,71,60,3,0,null,{"$f":"E40","v":"Duitsland"},{"$f":"SUMIF($E$4:$E$51,P40,$M$4:$M$51)+SUMIF($F$4:$F$51,P40,$N$4:$N$51)+RAND()/10000","v":9.0000733504863391},null,1,{"$f":"INDEX($P$40:$P$43,MATCH(U40,$Q$40:$Q$43,0))","v":"Duitsland"},{"$f":"LARGE($Q$40:$Q$43,S40)","v":9.0000733504863391}]
[null,7,2,null,"Ghana","VS",11,71,27,11,71,18,3,0,null,{"$f":"F40","v":"Portugal"},2.0395247028841624E-5,null,2,{"$f":"INDEX($P$40:$P$43,MATCH(U41,$Q$40:$Q$43,0))","v":"Ghana"},{"$f":"LARGE($Q$40:$Q$43,S41)","v":6.0000140383161078}]
[null,7,3,null,"Duitsland","Ghana",20,80,64,11,71,35,3,0,null,{"$f":"E41","v":"Ghana"},6.0000140383161078,null,3,"VS",3.0000424871437428]
[null,7,4,null,"VS","Portugal",11,71,28,11,71,24,3,0,null,{"$f":"F41","v":"VS"},3.0000424871437428,null,4,"Portugal",2.0395247028841624E-5]
[null,7,5,null,{"$f":"OFFSET(LandKop,(GroepNr-1)*4+INDEX(GroepSchema,WedNr,E$1),0)","v":"VS"},"Duitsland",11,71,25,20,80,34,0,3]
[null,7,6,null,"Portugal","Ghana",11,71,50,11,71,56,0,3]
[null,8,1,"Groep H","België","Algerije",11,71,25,11,71,{"$f":"RANDBETWEEN(J46,K46)","v":58},0,3,null,{"$f":"E46","v":"België"},{"$f":"SUMIF($E$4:$E$51,P46,$M$4:$M$51)+SUMIF($F$4:$F$51,P46,$N$4:$N$51)+RAND()/10000","v":3.0000185738021128},null,1,{"$f":"INDEX($P$46:$P$49,MATCH(U46,$Q$46:$Q$49,0))","v":"Algerije"},{"$f":"LARGE($Q$46:$Q$49,S46)","v":6.0000197440327314}]
[null,8,2,null,"Rusland","Zuid-Korea",11,71,38,11,71,49,0,3,null,{"$f":"F46","v":"Algerije"},6.0000197440327314,null,2,{"$f":"INDEX($P$46:$P$49,MATCH(U47,$Q$46:$Q$49,0))","v":"Rusland"},{"$f":"LARGE($Q$46:$Q$49,S47)","v":6.0000017795712344}]
[null,8,3,null,"België","Rusland",11,71,54,11,71,{"$f":"RANDBETWEEN(J48,K48)","v":71},0,3,null,{"$f":"E47","v":"Rusland"},6.0000017795712344,null,3,"Zuid-Korea",3.0000708406593271]
[null,8,4,null,"Zuid-Korea","Algerije",11,71,25,11,71,42,0,3,null,{"$f":"F47","v":"Zuid-Korea"},3.0000708406593271,null,4,"België",3.0000185738021128]
[null,8,5,null,"Zuid-Korea","België",11,71,19,11,71,52,0,3]
[null,8,6,null,"Algerije","Rusland",11,71,17,11,71,38,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_1","v":"Kameroen"},{"$f":"INDEX(Sterkte,MATCH(B3,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B3,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C3,D3)","v":52}]
[null,null,null,null,null,{"$f":"IF(E3>=E5,B3,B5)","v":"Kameroen"}]
[null,{"$f":"GB_2","v":"Nederland"},{"$f":"INDEX(Sterkte,MATCH(B5,Landen,0),2)","v":15},{"$f":"INDEX(Sterkte,MATCH(B5,Landen,0),3)","v":75},{"$f":"RANDBETWEEN(C5,D5)","v":24}]
[]
[null,{"$f":"GC_1","v":"Japan"},{"$f":"INDEX(Sterkte,MATCH(B7,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B7,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C7,D7)","v":66}]
[null,null,null,null,null,{"$f":"IF(E7>=E9,B7,B9)","v":"Japan"}]
[null,{"$f":"GD_2","v":"Italië"},{"$f":"INDEX(Sterkte,MATCH(B9,Landen,0),2)","v":12},{"$f":"INDEX(Sterkte,MATCH(B9,Landen,0),3)","v":72},{"$f":"RANDBETWEEN(C9,D9)","v":21}]
[]
[null,{"$f":"GB_1","v":"Chili"},{"$f":"INDEX(Sterkte,MATCH(B11,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B11,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C11,D11)","v":60},null,null,{"$f":"AF_5","v":"Nigeria"},{"$f":"INDEX(Sterkte,MATCH(H11,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(H11,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(I11,J11)","v":43}]
[null,null,null,null,null,{"$f":"IF(E11>=E13,B11,B13)","v":"Brazilië"},null,null,null,null,null,{"$f":"IF(K11>=K13,H11,H13)","v":"Nigeria"}]
[null,{"$f":"GA_2","v":"Brazilië"},{"$f":"INDEX(Sterkte,MATCH(B13,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(B13,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(C13,D13)","v":62},null,null,{"$f":"AF_6","v":"Duitsland"},{"$f":"INDEX(Sterkte,MATCH(H13,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(H13,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(I13,J13)","v":31}]
[]
[null,{"$f":"GD_1","v":"Costa Rica"},{"$f":"INDEX(Sterkte,MATCH(B15,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B15,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C15,D15)","v":56},null,null,{"$f":"AF_1","v":"Kameroen"},{"$f":"INDEX(Sterkte,MATCH(H15,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(H15,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(I15,J15)","v":62},null,null,{"$f":"KF_2","v":"Kameroen"},{"$f":"INDEX(Sterkte,MATCH(N15,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(N15,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(O15,P15)","v":61}]
[null,null,null,null,null,{"$f":"IF(E15>=E17,B15,B17)","v":"Costa Rica"},null,null,null,null,null,{"$f":"IF(K15>=K17,H15,H17)","v":"Kameroen"},null,null,null,null,null,{"$f":"IF(Q15>=Q17,N15,N17)","v":"Kameroen"},null,{"$f":"HF_1","v":"Kameroen"},{"$f":"INDEX(Sterkte,MATCH(T16,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(T16,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(U16,V16)","v":48}]
[null,{"$f":"GC_2","v":"Ivoorkust"},{"$f":"INDEX(Sterkte,MATCH(B17,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B17,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C17,D17)","v":11},null,null,{"$f":"AF_2","v":"Japan"},{"$f":"INDEX(Sterkte,MATCH(H17,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(H17,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(I17,J17)","v":24},null,null,{"$f":"KF_1","v":"Nigeria"},{"$f":"INDEX(Sterkte,MATCH(N17,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(N17,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(O17,P17)","v":25}]
[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":"Brazilië"}]
[null,{"$f":"GE_1","v":"Zwitserland"},{"$f":"INDEX(Sterkte,MATCH(B19,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B19,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C19,D19)","v":31},null,null,{"$f":"AF_7","v":"Frankrijk"},{"$f":"INDEX(Sterkte,MATCH(H19,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(H19,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(I19,J19)","v":49},null,null,{"$f":"KF_4","v":"Brazilië"},{"$f":"INDEX(Sterkte,MATCH(N19,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(N19,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(O19,P19)","v":48}]
[null,null,null,null,null,{"$f":"IF(E19>=E21,B19,B21)","v":"Nigeria"},null,null,null,null,null,{"$f":"IF(K19>=K21,H19,H21)","v":"Frankrijk"},null,null,null,null,null,{"$f":"IF(Q19>=Q21,N19,N21)","v":"Brazilië"},null,{"$f":"HF_2","v":"Brazilië"},{"$f":"INDEX(Sterkte,MATCH(T20,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(T20,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(U20,V20)","v":75}]
[null,{"$f":"GF_2","v":"Nigeria"},{"$f":"INDEX(Sterkte,MATCH(B21,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B21,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C21,D21)","v":68},null,null,{"$f":"AF_8","v":"Ghana"},{"$f":"INDEX(Sterkte,MATCH(H21,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(H21,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(I21,J21)","v":15},null,null,{"$f":"KF_3","v":"Frankrijk"},{"$f":"INDEX(Sterkte,MATCH(N21,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(N21,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(O21,P21)","v":39}]
[]
[null,{"$f":"GG_1","v":"Duitsland"},{"$f":"INDEX(Sterkte,MATCH(B23,Landen,0),2)","v":20},{"$f":"INDEX(Sterkte,MATCH(B23,Landen,0),3)","v":80},{"$f":"RANDBETWEEN(C23,D23)","v":49},null,null,{"$f":"AF_3","v":"Brazilië"},{"$f":"INDEX(Sterkte,MATCH(H23,Landen,0),2)","v":40},{"$f":"INDEX(Sterkte,MATCH(H23,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(I23,J23)","v":50}]
[null,null,null,null,null,{"$f":"IF(E23>=E25,B23,B25)","v":"Duitsland"},null,null,null,null,null,{"$f":"IF(K23>=K25,H23,H25)","v":"Brazilië"}]
[null,{"$f":"GH_2","v":"Rusland"},{"$f":"INDEX(Sterkte,MATCH(B25,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B25,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C25,D25)","v":49},null,null,{"$f":"AF_4","v":"Costa Rica"},{"$f":"INDEX(Sterkte,MATCH(H25,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(H25,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(I25,J25)","v":25}]
[]
[null,{"$f":"GF_1","v":"Argentinië"},{"$f":"INDEX(Sterkte,MATCH(B27,Landen,0),2)","v":25},{"$f":"INDEX(Sterkte,MATCH(B27,Landen,0),3)","v":85},{"$f":"RANDBETWEEN(C27,D27)","v":63}]
[null,null,null,null,null,{"$f":"IF(E27>=E29,B27,B29)","v":"Frankrijk"}]
[null,{"$f":"GE_2","v":"Frankrijk"},{"$f":"INDEX(Sterkte,MATCH(B29,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B29,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C29,D29)","v":65}]
[]
[null,{"$f":"GH_1","v":"Algerije"},{"$f":"INDEX(Sterkte,MATCH(B31,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B31,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C31,D31)","v":14}]
[null,null,null,null,null,{"$f":"IF(E31>=E33,B31,B33)","v":"Ghana"}]
[null,{"$f":"GG_2","v":"Ghana"},{"$f":"INDEX(Sterkte,MATCH(B33,Landen,0),2)","v":11},{"$f":"INDEX(Sterkte,MATCH(B33,Landen,0),3)","v":71},{"$f":"RANDBETWEEN(C33,D33)","v":27}]

{"sheet":"MC","index":4,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,8,3,9],[4,8,4,9]]}
[]
[]
[null,"Land","Aantal","Perc"]
[null,{"$f":"Landen","v":"Brazilië"},16,{"$f":"+C4/$C$36","v":0.32},null,null,null,null,"Aantal per run"]
[null,"Kroatië",null,{"$f":"+C5/$C$36","v":0},null,null,null,null,50]
[null,"Mexico",null,0]
[null,"Kameroen",null,0]
[null,"Spanje",5,0.1]
[null,"Nederland",3,0.06]
[null,"Chili",1,0.02]
[null,"Australië",null,0]
[null,"Colombia",1,0.02]
[null,"Griekenland",1,0.02]
[null,"Ivoorkust",1,0.02]
[null,"Japan",1,0.02]
[null,"Uruguay",1,0.02]
[null,"Costa Rica",1,0.02]
[null,"Engeland",2,0.04]
[null,"Italië",1,0.02]
[null,"Zwitserland",null,0]
[null,"Ecuador",2,0.04]
[null,"Frankrijk",2,0.04]
[null,"Honduras",1,0.02]
[null,"Argentinië",4,0.08]
[null,"Bosnië-Herzegovina",1,0.02]
[null,"Iran",null,0]
[null,"Nigeria",null,0]
[null,"Duitsland",2,0.04]
[null,"Portugal",null,0]
[null,"Ghana",1,0.02]
[null,"VS",null,0]
[null,"België",null,0]
[null,"Algerije",null,0]
[null,"Rusland",null,0]
[null,"Zuid-Korea",3,0.06]
[null,null,{"$f":"SUM(C4:C35)","v":50},1]