{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Tirage_poules","A LIRE Explications","Poule 1","Poule 2","Poule 3","Poule 4","Poule 5","Poule 6","Poule 8","Classement","Poule 7"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tirage_poules","index":0,"n_rows":53,"n_cols":35,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["N°","NOMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poule1",null,"Poule2",null,"Poule3",null,"Poule4",null,"Poule5",null,"Poule6",null,"Poule7",null,"Poule8"]
[1,"A1",null,31,null,7,null,24,null,25,null,17,null,33,null,43,null,39,null,null,{"$f":"IFERROR(VLOOKUP(D2,$A$2:$B$100,2,0),\"\")","v":"A31"},{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$100,2,0),\"\")","v":""},"A7","","A24","","A25","","A17","","A33","","A43","",{"$f":"IFERROR(VLOOKUP(R2,$A$2:$B$100,2,0),\"\")","v":"A39"}]
[2,"A2",null,44,null,28,null,19,null,26,null,42,null,22,null,38,null,32,null,null,{"$f":"IFERROR(VLOOKUP(D3,$A$2:$B$100,2,0),\"\")","v":"A44"},"","A28","","A19","","A26","","A42","","A22","","A38","","A32"]
[3,"A3",null,1,null,35,null,8,null,9,null,16,null,50,null,23,null,41,null,null,"A1","","A35","","A8","","A9","","A16","","A50","","A23","","A41"]
[4,"A4",null,11,null,29,null,37,null,15,null,13,null,12,null,27,null,30,null,null,"A11","","A29","","A37","","A15","","A13","","A12","","A27","","A30"]
[5,"A5",null,4,null,5,null,49,null,46,null,3,null,52,null,47,null,34,null,null,"A4","","A5","","A49","","A46","","A3","","A52","","A47","","A34"]
[6,"A6",null,6,null,10,null,40,null,14,null,45,null,48,null,20,null,41,null,null,"A6","","A10","","A40","","A14","","A45","","A48","","A20","","A41"]
[7,"A7",null,18,null,36,null,21,null,2,null,null,null,null,null,null,null,null,null,null,"A18","","A36","","A21","","A2","","","","","","","",""]
[8,"A8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","",""]
[9,"A9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"","","","","",""]
[10,"A10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"","","","","",""]
[11,"A11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",null,"",null,"",null,"","","","","",""]
[12,"A12"]
[13,"A13"]
[14,"A14"]
[15,"A15"]
[16,"A16"]
[17,"A17"]
[18,"A18"]
[19,"A19"]
[20,"A20"]
[21,"A21"]
[22,"A22"]
[23,"A23"]
[24,"A24"]
[25,"A25"]
[26,"A26"]
[27,"A27"]
[28,"A28"]
[29,"A29"]
[30,"A30"]
[31,"A31"]
[32,"A32"]
[33,"A33"]
[34,"A34"]
[35,"A35"]
[36,"A36"]
[37,"A37"]
[38,"A38"]
[39,"A39"]
[40,"A40"]
[41,"A41"]
[42,"A42"]
[43,"A43"]
[44,"A44"]
[45,"A45"]
[46,"A46"]
[47,"A47"]
[48,"A48"]
[49,"A49"]
[50,"A50"]
[41,"A51"]
[52,"A52"]

{"sheet":"A LIRE Explications","index":1,"n_rows":22,"n_cols":1,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,0,7,2],[1,0,1,2],[11,0,11,2],[15,0,15,10]]}
[]
["Sur la feuille Tirage_poules "]
["Remplir les cellules colonne \"Noms\"avec les noms et la colonne N° des numéros a partir de 1 ,et selon le nombre de joueurs ou équipes"]
["Ensuite cliquer sur le bouton Tirage et tous les tirages sont effectués"]
["Les différents boutons donnent accés directement  a la feuille voulue"]
["Attention les boutons effacer sont à utiliser que si vous etes sur de vouloir tout supprimer"]
[]
["Sur les feuilles de Poule "]
[" Vous n'avez que les scores à noter exemple\" 13  8 \""]
["Le calcul se fait automatiquement"]
[]
["Sur la feuille Classement "]
["Les résultats s'inscrivent au fur et a mesure "]
["Pour avoir le classement ,vous cliquez sur le bouton \"Classement\""]
[]
["Sur toutes les feuilles vous avez un bouton \"Retour tirage\" qui vous renvoie sur la feuille Tirage_poules"]
[]
[]
["J'ai volontairement mis des N° ,des Noms, des scores pour montrer le fonctionnement et le classement."]
["Il y a des trous dans les poules ,c'est normal il n'y a pas 64 joueurs"]
["Pour les joueurs qui n'ont pas d'adversaire j'ai attribué 13 au score de facon que le joueur soit classé normalement."]
["Pour effacer ce que j'ai mis rien de plus facile ,les boutons effacer sont là pour cela"]

{"sheet":"Poule 1","index":2,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[30,9,30,10],[0,9,0,10],[0,4,0,5],[29,9,29,10]]}
[null,"Poule 1",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!U2","v":"A31"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A31"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!U3","v":"A44"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A44"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":"A18"},11,13,null,{"$f":"IF($J3=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":1}]
[3,{"$f":"Tirage_poules!U4","v":"A1"},null,null,3,6,"A1",">>>>","A6",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!U5","v":"A11"},null,null,4,5,"A11",">>>>","A4",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!U6","v":"A4"},null,null,1,7,"A31",">>>>","A18",13,2,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!U7","v":"A6"},null,null,6,8,"A6",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!U8","v":"A18"},null,null,2,5,"A44",">>>>","A4",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!U9","v":""},null,null,3,4,"A1",">>>>","A11",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A31",">>>>","A6",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A4",">>>>","A18",3,13,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":0},null,{"$f":"IF($K11=13,1,0)","v":1}]
[null,null,null,null,4,8,"A11",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A44",">>>>","A1",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A31",">>>>","A4",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A11",">>>>","A6",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A1",">>>>","A18",7,13,null,null,{"$f":"IF($J16=13,1,0)","v":0},null,null,null,{"$f":"IF($K16=13,1,0)","v":1}]
[null,null,null,null,2,8,"A44",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A31",">>>>","A11",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A1",">>>>","A4",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A44",">>>>","A6",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"A18",">>>>","",13,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":1},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A31",">>>>","A1",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A44",">>>>","A11",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A4",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A6",">>>>","A18",4,13,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":0},{"$f":"IF($K25=13,1,0)","v":1}]
[null,null,null,null,1,2,"A31",">>>>","A44",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A1",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A11",">>>>","A18",13,6,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A4",">>>>","A6",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":3},2,4,4,5,5,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":28},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":-8},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-26},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":0},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":15},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":36},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":22},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-91}]

{"sheet":"Poule 2","index":3,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 2",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!W2","v":"A7"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A7"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!W3","v":"A28"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A28"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":"A36"},11,13,null,{"$f":"IF($J3=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":1}]
[3,{"$f":"Tirage_poules!W4","v":"A35"},null,null,3,6,"A35",">>>>","A10",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!W5","v":"A29"},null,null,4,5,"A29",">>>>","A5",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!W6","v":"A5"},null,null,1,7,"A7",">>>>","A36",13,2,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!W7","v":"A10"},null,null,6,8,"A10",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!W8","v":"A36"},null,null,2,5,"A28",">>>>","A5",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!W9","v":""},null,null,3,4,"A35",">>>>","A29",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A7",">>>>","A10",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A5",">>>>","A36",3,13,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":0},null,{"$f":"IF($K11=13,1,0)","v":1}]
[null,null,null,null,4,8,"A29",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A28",">>>>","A35",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A7",">>>>","A5",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A29",">>>>","A10",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A35",">>>>","A36",7,13,null,null,{"$f":"IF($J16=13,1,0)","v":0},null,null,null,{"$f":"IF($K16=13,1,0)","v":1}]
[null,null,null,null,2,8,"A28",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A7",">>>>","A29",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A35",">>>>","A5",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A28",">>>>","A10",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"A36",">>>>","",13,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":1},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A7",">>>>","A35",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A28",">>>>","A29",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A5",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A10",">>>>","A36",4,13,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":0},{"$f":"IF($K25=13,1,0)","v":1}]
[null,null,null,null,1,2,"A7",">>>>","A28",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A35",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A29",">>>>","A36",13,6,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A5",">>>>","A10",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":3},2,4,4,5,5,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":28},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":-8},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-26},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":0},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":15},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":36},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":22},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-91}]

{"sheet":"Poule 3","index":4,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 3",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!Y2","v":"A24"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A24"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!Y3","v":"A19"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A19"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":"A21"},11,13,null,{"$f":"IF($J3=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":1}]
[3,{"$f":"Tirage_poules!Y4","v":"A8"},null,null,3,6,"A8",">>>>","A40",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!Y5","v":"A37"},null,null,4,5,"A37",">>>>","A49",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!Y6","v":"A49"},null,null,1,7,"A24",">>>>","A21",13,2,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!Y7","v":"A40"},null,null,6,8,"A40",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!Y8","v":"A21"},null,null,2,5,"A19",">>>>","A49",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!Y9","v":""},null,null,3,4,"A8",">>>>","A37",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A24",">>>>","A40",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A49",">>>>","A21",3,13,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":0},null,{"$f":"IF($K11=13,1,0)","v":1}]
[null,null,null,null,4,8,"A37",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A19",">>>>","A8",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A24",">>>>","A49",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A37",">>>>","A40",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A8",">>>>","A21",7,13,null,null,{"$f":"IF($J16=13,1,0)","v":0},null,null,null,{"$f":"IF($K16=13,1,0)","v":1}]
[null,null,null,null,2,8,"A19",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A24",">>>>","A37",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A8",">>>>","A49",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A19",">>>>","A40",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"A21",">>>>","",13,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":1},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A24",">>>>","A8",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A19",">>>>","A37",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A49",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A40",">>>>","A21",4,13,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":0},{"$f":"IF($K25=13,1,0)","v":1}]
[null,null,null,null,1,2,"A24",">>>>","A19",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A8",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A37",">>>>","A21",13,6,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A49",">>>>","A40",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":3},2,4,4,5,5,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":28},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":-8},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-26},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":0},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":15},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":36},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":22},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-91}]

{"sheet":"Poule 4","index":5,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 4",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!AA2","v":"A25"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A25"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!AA3","v":"A26"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A26"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":"A2"},11,13,null,{"$f":"IF($J3=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":1}]
[3,{"$f":"Tirage_poules!AA4","v":"A9"},null,null,3,6,"A9",">>>>","A14",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!AA5","v":"A15"},null,null,4,5,"A15",">>>>","A46",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!AA6","v":"A46"},null,null,1,7,"A25",">>>>","A2",13,2,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!AA7","v":"A14"},null,null,6,8,"A14",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!AA8","v":"A2"},null,null,2,5,"A26",">>>>","A46",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!AA9","v":""},null,null,3,4,"A9",">>>>","A15",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A25",">>>>","A14",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A46",">>>>","A2",3,13,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":0},null,{"$f":"IF($K11=13,1,0)","v":1}]
[null,null,null,null,4,8,"A15",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A26",">>>>","A9",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A25",">>>>","A46",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A15",">>>>","A14",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A9",">>>>","A2",7,13,null,null,{"$f":"IF($J16=13,1,0)","v":0},null,null,null,{"$f":"IF($K16=13,1,0)","v":1}]
[null,null,null,null,2,8,"A26",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A25",">>>>","A15",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A9",">>>>","A46",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A26",">>>>","A14",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"A2",">>>>","",13,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":1},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A25",">>>>","A9",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A26",">>>>","A15",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A46",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A14",">>>>","A2",4,13,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":0},{"$f":"IF($K25=13,1,0)","v":1}]
[null,null,null,null,1,2,"A25",">>>>","A26",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A9",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A15",">>>>","A2",13,6,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A46",">>>>","A14",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":3},2,4,4,5,5,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":28},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":-8},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-26},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":0},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":15},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":36},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":22},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-91}]

{"sheet":"Poule 5","index":6,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 5",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!AC2","v":"A17"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A17"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!AC3","v":"A42"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A42"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":""},13,null,null,{"$f":"IF($J3=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":0}]
[3,{"$f":"Tirage_poules!AC4","v":"A16"},null,null,3,6,"A16",">>>>","A45",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!AC5","v":"A13"},null,null,4,5,"A13",">>>>","A3",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!AC6","v":"A3"},null,null,1,7,"A17",">>>>","",13,null,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!AC7","v":"A45"},null,null,6,8,"A45",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!AC8","v":""},null,null,2,5,"A42",">>>>","A3",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!AC9","v":""},null,null,3,4,"A16",">>>>","A13",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A17",">>>>","A45",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A3",">>>>","",13,null,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":1},null,{"$f":"IF($K11=13,1,0)","v":0}]
[null,null,null,null,4,8,"A13",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A42",">>>>","A16",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A17",">>>>","A3",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A13",">>>>","A45",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A16",">>>>","",13,null,null,null,{"$f":"IF($J16=13,1,0)","v":1},null,null,null,{"$f":"IF($K16=13,1,0)","v":0}]
[null,null,null,null,2,8,"A42",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A17",">>>>","A13",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A16",">>>>","A3",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A42",">>>>","A45",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"",">>>>","",null,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":0},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A17",">>>>","A16",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A42",">>>>","A13",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A3",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A45",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":1},{"$f":"IF($K25=13,1,0)","v":0}]
[null,null,null,null,1,2,"A17",">>>>","A42",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A16",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A13",">>>>","",13,null,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A3",">>>>","A45",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":4},3,4,5,6,0,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":30},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":7},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-7},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":6},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":38},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":58},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":-78},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-78}]

{"sheet":"Poule 6","index":7,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 6",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!AE2","v":"A33"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A33"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!AE3","v":"A22"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A22"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":""},13,null,null,{"$f":"IF($J3=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":0}]
[3,{"$f":"Tirage_poules!AE4","v":"A50"},null,null,3,6,"A50",">>>>","A48",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!AE5","v":"A12"},null,null,4,5,"A12",">>>>","A52",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!AE6","v":"A52"},null,null,1,7,"A33",">>>>","",13,null,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!AE7","v":"A48"},null,null,6,8,"A48",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!AE8","v":""},null,null,2,5,"A22",">>>>","A52",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!AE9","v":""},null,null,3,4,"A50",">>>>","A12",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A33",">>>>","A48",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A52",">>>>","",13,null,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":1},null,{"$f":"IF($K11=13,1,0)","v":0}]
[null,null,null,null,4,8,"A12",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A22",">>>>","A50",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A33",">>>>","A52",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A12",">>>>","A48",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A50",">>>>","",13,null,null,null,{"$f":"IF($J16=13,1,0)","v":1},null,null,null,{"$f":"IF($K16=13,1,0)","v":0}]
[null,null,null,null,2,8,"A22",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A33",">>>>","A12",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A50",">>>>","A52",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A22",">>>>","A48",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"",">>>>","",null,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":0},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A33",">>>>","A50",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A22",">>>>","A12",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A52",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A48",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":1},{"$f":"IF($K25=13,1,0)","v":0}]
[null,null,null,null,1,2,"A33",">>>>","A22",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A50",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A12",">>>>","",13,null,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A52",">>>>","A48",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":4},3,4,5,6,0,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":30},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":7},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-7},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":6},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":38},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":58},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":-78},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-78}]

{"sheet":"Poule 8","index":8,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 8",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!AI2","v":"A39"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A39"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!AI3","v":"A32"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A32"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":""},13,null,null,{"$f":"IF($J3=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":0}]
[3,{"$f":"Tirage_poules!AI4","v":"A41"},null,null,3,6,"A41",">>>>","A41",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!AI5","v":"A30"},null,null,4,5,"A30",">>>>","A34",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!AI6","v":"A34"},null,null,1,7,"A39",">>>>","",13,null,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!AI7","v":"A41"},null,null,6,8,"A41",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!AI8","v":""},null,null,2,5,"A32",">>>>","A34",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!AI9","v":""},null,null,3,4,"A41",">>>>","A30",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A39",">>>>","A41",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A34",">>>>","",13,null,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":1},null,{"$f":"IF($K11=13,1,0)","v":0}]
[null,null,null,null,4,8,"A30",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A32",">>>>","A41",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A39",">>>>","A34",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A30",">>>>","A41",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A41",">>>>","",13,null,null,null,{"$f":"IF($J16=13,1,0)","v":1},null,null,null,{"$f":"IF($K16=13,1,0)","v":0}]
[null,null,null,null,2,8,"A32",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A39",">>>>","A30",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A41",">>>>","A34",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A32",">>>>","A41",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"",">>>>","",null,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":0},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A39",">>>>","A41",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A32",">>>>","A30",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A34",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A41",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":1},{"$f":"IF($K25=13,1,0)","v":0}]
[null,null,null,null,1,2,"A39",">>>>","A32",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A41",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A30",">>>>","",13,null,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A34",">>>>","A41",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":4},3,4,5,6,0,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":30},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":7},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-7},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":6},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":38},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":58},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":-78},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-78}]

{"sheet":"Classement","index":9,"n_rows":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"N° Inscription","Noms ","Parties gagnées","Ecart de points",null,"Classement","Noms "]
[null,1,{"$f":"'Poule 7'!B7","v":"A20"},{"$f":"'Poule 7'!Q$30","v":6},{"$f":"'Poule 7'!Q$31","v":58},{"$f":"SUM(D4*10000+E4*100)","v":65800},{"$f":"RANK(F4,$F$4:$F$67,0)","v":1},{"$f":"IF(C4=\"\",\"\",C4)","v":"A20"}]
[null,2,{"$f":"'Poule 6'!B7","v":"A48"},{"$f":"'Poule 6'!Q$30","v":6},{"$f":"'Poule 6'!Q$31","v":58},{"$f":"SUM(D5*10000+E5*100)","v":65800},{"$f":"RANK(F5,$F$4:$F$67,0)","v":1},{"$f":"IF(C5=\"\",\"\",C5)","v":"A48"}]
[null,3,{"$f":"'Poule 8'!B7","v":"A41"},{"$f":"'Poule 8'!Q$30","v":6},{"$f":"'Poule 8'!Q$31","v":58},{"$f":"SUM(D6*10000+E6*100)","v":65800},1,"A41"]
[null,4,{"$f":"'Poule 5'!B7","v":"A45"},{"$f":"'Poule 5'!Q$30","v":6},{"$f":"'Poule 5'!Q$31","v":58},{"$f":"SUM(D7*10000+E7*100)","v":65800},1,"A45"]
[null,5,{"$f":"'Poule 6'!B6","v":"A52"},{"$f":"'Poule 6'!P$30","v":5},{"$f":"'Poule 6'!P$31","v":38},{"$f":"SUM(D8*10000+E8*100)","v":53800},5,"A52"]
[null,6,{"$f":"'Poule 5'!B6","v":"A3"},{"$f":"'Poule 5'!P$30","v":5},{"$f":"'Poule 5'!P$31","v":38},{"$f":"SUM(D9*10000+E9*100)","v":53800},5,"A3"]
[null,7,{"$f":"'Poule 8'!B6","v":"A34"},{"$f":"'Poule 8'!P$30","v":5},{"$f":"'Poule 8'!P$31","v":38},{"$f":"SUM(D10*10000+E10*100)","v":53800},5,"A34"]
[null,8,{"$f":"'Poule 7'!B6","v":"A47"},{"$f":"'Poule 7'!P$30","v":5},{"$f":"'Poule 7'!P$31","v":38},{"$f":"SUM(D11*10000+E11*100)","v":53800},5,"A47"]
[null,9,{"$f":"'Poule 1'!B7","v":"A6"},{"$f":"'Poule 1'!Q$30","v":5},{"$f":"'Poule 1'!Q$31","v":36},{"$f":"SUM(D12*10000+E12*100)","v":53600},9,"A6"]
[null,10,{"$f":"'Poule 4'!B7","v":"A14"},{"$f":"'Poule 4'!Q$30","v":5},{"$f":"'Poule 4'!Q$31","v":36},{"$f":"SUM(D13*10000+E13*100)","v":53600},9,"A14"]
[null,11,{"$f":"'Poule 3'!B7","v":"A40"},{"$f":"'Poule 3'!Q$30","v":5},{"$f":"'Poule 3'!Q$31","v":36},{"$f":"SUM(D14*10000+E14*100)","v":53600},9,"A40"]
[null,12,{"$f":"'Poule 2'!B7","v":"A10"},{"$f":"'Poule 2'!Q$30","v":5},{"$f":"'Poule 2'!Q$31","v":36},{"$f":"SUM(D15*10000+E15*100)","v":53600},9,"A10"]
[null,13,{"$f":"'Poule 6'!B2","v":"A33"},{"$f":"'Poule 6'!L$30","v":5},{"$f":"'Poule 6'!L$31","v":30},{"$f":"SUM(D16*10000+E16*100)","v":53000},13,"A33"]
[null,14,{"$f":"'Poule 8'!B2","v":"A39"},{"$f":"'Poule 8'!L$30","v":5},{"$f":"'Poule 8'!L$31","v":30},{"$f":"SUM(D17*10000+E17*100)","v":53000},13,"A39"]
[null,15,{"$f":"'Poule 7'!B2","v":"A43"},{"$f":"'Poule 7'!L$30","v":5},{"$f":"'Poule 7'!L$31","v":30},{"$f":"SUM(D18*10000+E18*100)","v":53000},13,"A43"]
[null,16,{"$f":"'Poule 5'!B2","v":"A17"},{"$f":"'Poule 5'!L$30","v":5},{"$f":"'Poule 5'!L$31","v":30},{"$f":"SUM(D19*10000+E19*100)","v":53000},{"$f":"RANK(F19,$F$4:$F$67,0)","v":13},"A17"]
[null,17,{"$f":"'Poule 1'!B2","v":"A31"},{"$f":"'Poule 1'!L$30","v":5},{"$f":"'Poule 1'!L$31","v":28},{"$f":"SUM(D20*10000+E20*100)","v":52800},17,"A31"]
[null,18,{"$f":"'Poule 4'!B2","v":"A25"},{"$f":"'Poule 4'!L$30","v":5},{"$f":"'Poule 4'!L$31","v":28},{"$f":"SUM(D21*10000+E21*100)","v":52800},17,"A25"]
[null,19,{"$f":"'Poule 2'!B2","v":"A7"},{"$f":"'Poule 2'!L$30","v":5},{"$f":"'Poule 2'!L$31","v":28},{"$f":"SUM(D22*10000+E22*100)","v":52800},17,"A7"]
[null,20,{"$f":"'Poule 3'!B2","v":"A24"},{"$f":"'Poule 3'!L$30","v":5},{"$f":"'Poule 3'!L$31","v":28},{"$f":"SUM(D23*10000+E23*100)","v":52800},17,"A24"]
[null,21,{"$f":"'Poule 1'!B8","v":"A18"},{"$f":"'Poule 1'!R$30","v":5},{"$f":"'Poule 1'!R$31","v":22},{"$f":"SUM(D24*10000+E24*100)","v":52200},21,"A18"]
[null,22,{"$f":"'Poule 4'!B8","v":"A2"},{"$f":"'Poule 4'!R$30","v":5},{"$f":"'Poule 4'!R$31","v":22},{"$f":"SUM(D25*10000+E25*100)","v":52200},21,"A2"]
[null,23,{"$f":"'Poule 3'!B8","v":"A21"},{"$f":"'Poule 3'!R$30","v":5},{"$f":"'Poule 3'!R$31","v":22},{"$f":"SUM(D26*10000+E26*100)","v":52200},21,"A21"]
[null,24,{"$f":"'Poule 2'!B8","v":"A36"},{"$f":"'Poule 2'!R$30","v":5},{"$f":"'Poule 2'!R$31","v":22},{"$f":"SUM(D27*10000+E27*100)","v":52200},21,"A36"]
[null,25,{"$f":"'Poule 1'!B6","v":"A4"},{"$f":"'Poule 1'!P$30","v":4},{"$f":"'Poule 1'!P$31","v":15},{"$f":"SUM(D28*10000+E28*100)","v":41500},25,"A4"]
[null,26,{"$f":"'Poule 2'!B6","v":"A5"},{"$f":"'Poule 2'!P$30","v":4},{"$f":"'Poule 2'!P$31","v":15},{"$f":"SUM(D29*10000+E29*100)","v":41500},25,"A5"]
[null,27,{"$f":"'Poule 3'!B6","v":"A49"},{"$f":"'Poule 3'!P$30","v":4},{"$f":"'Poule 3'!P$31","v":15},{"$f":"SUM(D30*10000+E30*100)","v":41500},25,"A49"]
[null,28,{"$f":"'Poule 4'!B6","v":"A46"},{"$f":"'Poule 4'!P$30","v":4},{"$f":"'Poule 4'!P$31","v":15},{"$f":"SUM(D31*10000+E31*100)","v":41500},25,"A46"]
[null,29,{"$f":"'Poule 8'!B3","v":"A32"},{"$f":"'Poule 8'!M$30","v":4},{"$f":"'Poule 8'!M$31","v":7},{"$f":"SUM(D32*10000+E32*100)","v":40700},29,"A32"]
[null,30,{"$f":"'Poule 7'!B3","v":"A38"},{"$f":"'Poule 7'!M$30","v":4},{"$f":"'Poule 7'!M$31","v":7},{"$f":"SUM(D33*10000+E33*100)","v":40700},29,"A38"]
[null,31,{"$f":"'Poule 6'!B3","v":"A22"},{"$f":"'Poule 6'!M$30","v":4},{"$f":"'Poule 6'!M$31","v":7},{"$f":"SUM(D34*10000+E34*100)","v":40700},29,"A22"]
[null,32,{"$f":"'Poule 5'!B3","v":"A42"},{"$f":"'Poule 5'!M$30","v":4},{"$f":"'Poule 5'!M$31","v":7},{"$f":"SUM(D35*10000+E35*100)","v":40700},29,"A42"]
[null,33,{"$f":"'Poule 7'!B5","v":"A27"},{"$f":"'Poule 7'!O$30","v":4},{"$f":"'Poule 7'!O$31","v":6},{"$f":"SUM(D36*10000+E36*100)","v":40600},33,"A27"]
[null,34,{"$f":"'Poule 6'!B5","v":"A12"},{"$f":"'Poule 6'!O$30","v":4},{"$f":"'Poule 6'!O$31","v":6},{"$f":"SUM(D37*10000+E37*100)","v":40600},33,"A12"]
[null,35,{"$f":"'Poule 8'!B5","v":"A30"},{"$f":"'Poule 8'!O$30","v":4},{"$f":"'Poule 8'!O$31","v":6},{"$f":"SUM(D38*10000+E38*100)","v":40600},33,"A30"]
[null,36,{"$f":"'Poule 5'!B5","v":"A13"},{"$f":"'Poule 5'!O$30","v":4},{"$f":"'Poule 5'!O$31","v":6},{"$f":"SUM(D39*10000+E39*100)","v":40600},33,"A13"]
[null,37,{"$f":"'Poule 1'!B5","v":"A11"},{"$f":"'Poule 1'!O$30","v":4},{"$f":"'Poule 1'!O$31","v":0},{"$f":"SUM(D40*10000+E40*100)","v":40000},37,"A11"]
[null,38,{"$f":"'Poule 4'!B5","v":"A15"},{"$f":"'Poule 4'!O$30","v":4},{"$f":"'Poule 4'!O$31","v":0},{"$f":"SUM(D41*10000+E41*100)","v":40000},37,"A15"]
[null,39,{"$f":"'Poule 2'!B5","v":"A29"},{"$f":"'Poule 2'!O$30","v":4},{"$f":"'Poule 2'!O$31","v":0},{"$f":"SUM(D42*10000+E42*100)","v":40000},37,"A29"]
[null,40,{"$f":"'Poule 3'!B5","v":"A37"},{"$f":"'Poule 3'!O$30","v":4},{"$f":"'Poule 3'!O$31","v":0},{"$f":"SUM(D43*10000+E43*100)","v":40000},37,"A37"]
[null,41,{"$f":"'Poule 7'!B4","v":"A23"},{"$f":"'Poule 7'!N$30","v":3},{"$f":"'Poule 7'!N$31","v":-7},{"$f":"SUM(D44*10000+E44*100)","v":29300},41,"A23"]
[null,42,{"$f":"'Poule 8'!B4","v":"A41"},{"$f":"'Poule 8'!N$30","v":3},{"$f":"'Poule 8'!N$31","v":-7},{"$f":"SUM(D45*10000+E45*100)","v":29300},41,"A41"]
[null,43,{"$f":"'Poule 6'!B4","v":"A50"},{"$f":"'Poule 6'!N$30","v":3},{"$f":"'Poule 6'!N$31","v":-7},{"$f":"SUM(D46*10000+E46*100)","v":29300},41,"A50"]
[null,44,{"$f":"'Poule 5'!B4","v":"A16"},{"$f":"'Poule 5'!N$30","v":3},{"$f":"'Poule 5'!N$31","v":-7},{"$f":"SUM(D47*10000+E47*100)","v":29300},41,"A16"]
[null,45,{"$f":"'Poule 1'!B3","v":"A44"},{"$f":"'Poule 1'!M$30","v":3},{"$f":"'Poule 1'!M$31","v":-8},{"$f":"SUM(D48*10000+E48*100)","v":29200},45,"A44"]
[null,46,{"$f":"'Poule 2'!B3","v":"A28"},{"$f":"'Poule 2'!M$30","v":3},{"$f":"'Poule 2'!M$31","v":-8},{"$f":"SUM(D49*10000+E49*100)","v":29200},45,"A28"]
[null,47,{"$f":"'Poule 3'!B3","v":"A19"},{"$f":"'Poule 3'!M$30","v":3},{"$f":"'Poule 3'!M$31","v":-8},{"$f":"SUM(D50*10000+E50*100)","v":29200},45,"A19"]
[null,48,{"$f":"'Poule 4'!B3","v":"A26"},{"$f":"'Poule 4'!M$30","v":3},{"$f":"'Poule 4'!M$31","v":-8},{"$f":"SUM(D51*10000+E51*100)","v":29200},45,"A26"]
[null,49,{"$f":"'Poule 1'!B4","v":"A1"},{"$f":"'Poule 1'!N$30","v":2},{"$f":"'Poule 1'!N$31","v":-26},{"$f":"SUM(D52*10000+E52*100)","v":17400},49,"A1"]
[null,50,{"$f":"'Poule 4'!B4","v":"A9"},{"$f":"'Poule 4'!N$30","v":2},{"$f":"'Poule 4'!N$31","v":-26},{"$f":"SUM(D53*10000+E53*100)","v":17400},49,"A9"]
[null,51,{"$f":"'Poule 3'!B4","v":"A8"},{"$f":"'Poule 3'!N$30","v":2},{"$f":"'Poule 3'!N$31","v":-26},{"$f":"SUM(D54*10000+E54*100)","v":17400},49,"A8"]
[null,52,{"$f":"'Poule 2'!B4","v":"A35"},{"$f":"'Poule 2'!N$30","v":2},{"$f":"'Poule 2'!N$31","v":-26},{"$f":"SUM(D55*10000+E55*100)","v":17400},49,"A35"]
[null,53,{"$f":"'Poule 5'!B9","v":""},{"$f":"'Poule 5'!S$30","v":0},{"$f":"'Poule 5'!S$31","v":-78},{"$f":"SUM(D56*10000+E56*100)","v":-7800},53,""]
[null,54,{"$f":"'Poule 5'!B8","v":""},{"$f":"'Poule 5'!R$30","v":0},{"$f":"'Poule 5'!R$31","v":-78},{"$f":"SUM(D57*10000+E57*100)","v":-7800},53,""]
[null,55,{"$f":"'Poule 8'!B8","v":""},{"$f":"'Poule 8'!R$30","v":0},{"$f":"'Poule 8'!R$31","v":-78},{"$f":"SUM(D58*10000+E58*100)","v":-7800},53,""]
[null,56,{"$f":"'Poule 6'!B8","v":""},{"$f":"'Poule 6'!R$30","v":0},{"$f":"'Poule 6'!R$31","v":-78},{"$f":"SUM(D59*10000+E59*100)","v":-7800},53,""]
[null,57,{"$f":"'Poule 7'!B8","v":""},{"$f":"'Poule 7'!R$30","v":0},{"$f":"'Poule 7'!R$31","v":-78},{"$f":"SUM(D60*10000+E60*100)","v":-7800},53,""]
[null,58,{"$f":"'Poule 7'!B9","v":""},{"$f":"'Poule 7'!S$30","v":0},{"$f":"'Poule 7'!S$31","v":-78},{"$f":"SUM(D61*10000+E61*100)","v":-7800},53,""]
[null,59,{"$f":"'Poule 8'!B9","v":""},{"$f":"'Poule 8'!S$30","v":0},{"$f":"'Poule 8'!S$31","v":-78},{"$f":"SUM(D62*10000+E62*100)","v":-7800},53,""]
[null,60,{"$f":"'Poule 6'!B9","v":""},{"$f":"'Poule 6'!S$30","v":0},{"$f":"'Poule 6'!S$31","v":-78},{"$f":"SUM(D63*10000+E63*100)","v":-7800},53,""]
[null,61,{"$f":"'Poule 2'!B9","v":""},{"$f":"'Poule 2'!S$30","v":0},{"$f":"'Poule 2'!S$31","v":-91},{"$f":"SUM(D64*10000+E64*100)","v":-9100},61,""]
[null,62,{"$f":"'Poule 3'!B9","v":""},{"$f":"'Poule 3'!S$30","v":0},{"$f":"'Poule 3'!S$31","v":-91},{"$f":"SUM(D65*10000+E65*100)","v":-9100},61,""]
[null,63,{"$f":"'Poule 4'!B9","v":""},{"$f":"'Poule 4'!S$30","v":0},{"$f":"'Poule 4'!S$31","v":-91},{"$f":"SUM(D66*10000+E66*100)","v":-9100},61,""]
[null,64,{"$f":"'Poule 1'!B9","v":""},{"$f":"'Poule 1'!S$30","v":0},{"$f":"'Poule 1'!S$31","v":-91},{"$f":"SUM(D67*10000+E67*100)","v":-9100},61,""]

{"sheet":"Poule 7","index":10,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,9,0,10],[29,9,29,10],[30,9,30,10]]}
[null,"Poule 7",null,null,"Tirage",null,"NOM du joueur 1","Contre","NOM du joueur 2","POINTS",null,1,2,3,4,5,6,7,8]
[1,{"$f":"Tirage_poules!AG2","v":"A43"},null,null,1,8,{"$f":"IFERROR(VLOOKUP(E2,$A$2:$B$9,2,0),\"\")","v":"A43"},">>>>",{"$f":"IFERROR(VLOOKUP(F2,$A$2:$B$9,2,0),\"\")","v":""},13,null,{"$f":"IF($J2=13,1,0)","v":1},null,null,null,null,null,null,{"$f":"IF($K2=13,1,0)","v":0}]
[2,{"$f":"Tirage_poules!AG3","v":"A38"},null,null,2,7,{"$f":"IFERROR(VLOOKUP(E3,$A$2:$B$9,2,0),\"\")","v":"A38"},">>>>",{"$f":"IFERROR(VLOOKUP(F3,$A$2:$B$9,2,0),\"\")","v":""},13,null,null,{"$f":"IF($J3=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K3=13,1,0)","v":0}]
[3,{"$f":"Tirage_poules!AG4","v":"A23"},null,null,3,6,"A23",">>>>","A20",13,8,null,null,{"$f":"IF($J4=13,1,0)","v":1},null,null,{"$f":"IF($K4=13,1,0)","v":0}]
[4,{"$f":"Tirage_poules!AG5","v":"A27"},null,null,4,5,"A27",">>>>","A47",5,13,null,null,null,{"$f":"IF($J5=13,1,0)","v":0},{"$f":"IF($K5=13,1,0)","v":1}]
[5,{"$f":"Tirage_poules!AG6","v":"A47"},null,null,1,7,"A43",">>>>","",13,null,{"$f":"IF($J6=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K6=13,1,0)","v":0}]
[6,{"$f":"Tirage_poules!AG7","v":"A20"},null,null,6,8,"A20",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J7=13,1,0)","v":1},null,{"$f":"IF($K7=13,1,0)","v":0}]
[7,{"$f":"Tirage_poules!AG8","v":""},null,null,2,5,"A38",">>>>","A47",13,9,null,{"$f":"IF($J8=13,1,0)","v":1},null,null,{"$f":"IF($K8=13,1,0)","v":0}]
[8,{"$f":"Tirage_poules!AG9","v":""},null,null,3,4,"A23",">>>>","A27",1,13,null,null,{"$f":"IF($J9=13,1,0)","v":0},{"$f":"IF($K9=13,1,0)","v":1}]
[null,null,null,null,1,6,"A43",">>>>","A20",1,13,{"$f":"IF($J10=13,1,0)","v":0},null,null,null,null,{"$f":"IF($K10=13,1,0)","v":1}]
[null,null,null,null,5,7,"A47",">>>>","",13,null,null,null,null,null,{"$f":"IF($J11=13,1,0)","v":1},null,{"$f":"IF($K11=13,1,0)","v":0}]
[null,null,null,null,4,8,"A27",">>>>","",13,null,null,null,null,{"$f":"IF($J12=13,1,0)","v":1},null,null,null,{"$f":"IF($K12=13,1,0)","v":0}]
[null,null,null,null,2,3,"A38",">>>>","A23",13,6,null,{"$f":"IF($J13=13,1,0)","v":1},{"$f":"IF($K13=13,1,0)","v":0}]
[null,null,null,null,1,5,"A43",">>>>","A47",10,13,{"$f":"IF($J14=13,1,0)","v":0},null,null,null,{"$f":"IF($K14=13,1,0)","v":1}]
[null,null,null,null,4,6,"A27",">>>>","A20",4,13,null,null,null,{"$f":"IF($J15=13,1,0)","v":0},null,{"$f":"IF($K15=13,1,0)","v":1}]
[null,null,null,null,3,7,"A23",">>>>","",13,null,null,null,{"$f":"IF($J16=13,1,0)","v":1},null,null,null,{"$f":"IF($K16=13,1,0)","v":0}]
[null,null,null,null,2,8,"A38",">>>>","",13,null,null,{"$f":"IF($J17=13,1,0)","v":1},null,null,null,null,null,{"$f":"IF($K17=13,1,0)","v":0}]
[null,null,null,null,1,4,"A43",">>>>","A27",13,10,{"$f":"IF($J18=13,1,0)","v":1},null,null,{"$f":"IF($K18=13,1,0)","v":0}]
[null,null,null,null,3,5,"A23",">>>>","A47",5,13,null,null,{"$f":"IF($J19=13,1,0)","v":0},null,{"$f":"IF($K19=13,1,0)","v":1}]
[null,null,null,null,2,6,"A38",">>>>","A20",0,13,null,{"$f":"IF($J20=13,1,0)","v":0},null,null,null,{"$f":"IF($K20=13,1,0)","v":1}]
[null,null,null,null,7,8,"",">>>>","",null,null,null,null,null,null,null,null,{"$f":"IF($J21=13,1,0)","v":0},{"$f":"IF($K21=13,1,0)","v":0}]
[null,null,null,null,1,3,"A43",">>>>","A23",13,2,{"$f":"IF($J22=13,1,0)","v":1},null,{"$f":"IF($K22=13,1,0)","v":0}]
[null,null,null,null,2,4,"A38",">>>>","A27",1,13,null,{"$f":"IF($J23=13,1,0)","v":0},null,{"$f":"IF($K23=13,1,0)","v":1}]
[null,null,null,null,5,8,"A47",">>>>","",13,null,null,null,null,null,{"$f":"IF($J24=13,1,0)","v":1},null,null,{"$f":"IF($K24=13,1,0)","v":0}]
[null,null,null,null,6,7,"A20",">>>>","",13,null,null,null,null,null,null,{"$f":"IF($J25=13,1,0)","v":1},{"$f":"IF($K25=13,1,0)","v":0}]
[null,null,null,null,1,2,"A43",">>>>","A38",13,8,{"$f":"IF($J26=13,1,0)","v":1},{"$f":"IF($K26=13,1,0)","v":0}]
[null,null,null,null,3,8,"A23",">>>>","",13,null,null,null,{"$f":"IF($J27=13,1,0)","v":1},null,null,null,null,{"$f":"IF($K27=13,1,0)","v":0}]
[null,null,null,null,4,7,"A27",">>>>","",13,null,null,null,null,{"$f":"IF($J28=13,1,0)","v":1},null,null,{"$f":"IF($K28=13,1,0)","v":0}]
[null,null,null,null,5,6,"A47",">>>>","A20",10,13,null,null,null,null,{"$f":"IF($J29=13,1,0)","v":0},{"$f":"IF($K29=13,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Total Points",null,{"$f":"SUM(L2:L29)","v":5},{"$f":"SUM(M2:M29)","v":4},3,4,5,6,0,0]
[null,null,null,null,null,null,null,null,null,"Diff points",null,{"$f":"(J2+J6+J10+J14+J18+J22+J26)-(K2+K6+K10+K14+K18+K22+K26)","v":30},{"$f":"(J3+J8+J13+J17+J20+J23+K26)-(K3+K8+K13+K17+K20+K23+J26)","v":7},{"$f":"(J4+J9+K13+J16+J19+K22+J27)-(K4+K9+J13+K16+K19+J22+K27)","v":-7},{"$f":"(J5+K9+J12+J15+K18+J23+J28)-(K5+J9+K12+K15+J18+K23+K28)","v":6},{"$f":"(K5+K8+J11+K14+K19+J24+J29)-(J5+J8+K11+J14+J19+K24+K29)","v":38},{"$f":"(K4+J7+K10+K15+K20+J25+K29)-(J4+K7+J10+J15+J20+K25+J29)","v":58},{"$f":"(K6+K11+K16+J21+K25+K28+K3)-(J3+J6+J11+J16+K21+J25+J28)","v":-78},{"$f":"(K2+K7+K12+K17+K21+K24+K27)-(J2+J7+J12+J17+J21+J24+J27)","v":-78}]