{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["LISTE ENGAGES","LISTE","EMARGEMENT TQ","SCORE QUALIF","TAB QUALIF","EMARGEMENT TP","TAB PRINC","SCORE PRINC","RELEVE"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":40,"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":"LISTE ENGAGES","index":0,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,14,12,18],[13,14,13,18],[4,2,4,7],[0,2,2,6],[0,7,2,7],[5,2,5,7],[3,2,3,4],[3,5,3,6]]}
[null,null,{"$f":"IF($R$4=\"\",$Q$4,$R$4)","v":"APPELATION TOURNOI"},null,null,null,null,{"$f":"IF($R$11=\"\",$Q$11,$R$11)","v":"ORGANISATEUR"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDENTITE DU TOURNOI"]
[null,null,{"$f":"IF($R$5=\"\",$Q$5,$R$5)","v":"LIEU"},null,null,{"$f":"IF(R8=\"\",\"DATE\",CONCATENATE(R8,\"-\",R9,\"/\",R7))","v":"DATE"},null,{"$f":"IF($R$10=\"\",$Q$10,$R$10)","v":"GENRE"},null,null,null,null,null,null,null,null,"APPELATION TOURNOI"]
[null,null,{"$f":"IF($R$6=\"\",$Q$6,$R$6)","v":"TYPE"},null,null,null,null,null,null,null,null,null,null,null,null,null,"LIEU"]
[null,null,"LISTE EQUIPES ENGAGEES",null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNEE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE DEBUT"]
["N°",null,"NOM","PRENOM","LICENCE","CLUB","NOM J2","PRENOM J2","LICENCE J2","CLUB J2","pts","tir",null,null,null,null,"DATE FIN"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENRE"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORGANISATEUR"]
[3]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,"1- Commencez par renseigner le tableau ci-dessus \"identité du tournoi\""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,"2- Copiez-collez la liste des équipes engagées dans les champs ci-contre en respectant : "]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,"- nom et premon séparés pour chaque joueur ( à défaut, ne mentionez que le nom)"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,"- l'ordre décroissant des têtes de séries"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,"3- Renseignez l'onglet \"EMARG….\" selon l'avancée dans les tableaux"]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Renseignez les scores des rencontres dans l'onglet \" TAB…\" en fonction de l'avancée du tableau"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,"5- Renseignez l'onglet \"RELEVE\" à l'issue de la compétition"]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]

{"sheet":"LISTE","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"CHAMPIONNAT DE France",null,2020,null,"MASCULIN",null,"ABS"]
[null,null,null,"SERIE 1 - 2500",null,2021,null,"FEMININ",null,1]
[null,null,null,"SERIE 1 - 2000",null,2022,null,"MIXTE",null,2]
[null,null,null,"SERIE 1 - 1500",null,2023,null,null,null,3]
[null,null,null,"SERIE 2 - 1000",null,2024,null,null,null,4]
[null,null,null,"SERIE 2 - 750",null,null,null,null,null,5]
[null,null,null,"SERIE 2 - 500",null,null,null,null,null,6]
[null,null,null,"SERIE 2 - 250",null,null,null,null,null,7]
[null,null,null,"SERIE 3 - 150",null,null,null,null,null,8]
[null,null,null,"SERIE 3 - 100",null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,20]

{"sheet":"EMARGEMENT TQ","index":2,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,4,5,14],[1,4,2,13],[1,14,3,14],[3,4,3,7],[3,8,3,12],[4,4,4,14]]}
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$1","v":"APPELATION TOURNOI"},null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$1","v":"ORGANISATEUR"}]
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$4","v":"LIEU"},null,null,null,{"$f":"'LISTE ENGAGES'!$F$4","v":"DATE"},null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$4","v":"GENRE"}]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$5","v":"TYPE"}]
[null,null,null,null,"FEUILLE EMARGEMENT"]
[]
[null,"N°",null,"NOM","PRENOM","LICENCE","CLUB","NOM","PRENOM","LICENCE","CLUB","pts","tir","SIGNATURE JOUEUR1","SIGNATURE JOUEUR2","PAIEMENT"]
[null,1,null,"T",null,null,null,1]
[null,2,null,"T",null,null,null,2]
[null,3,null,"T",null,null,null,3]
[null,4,null,"T",null,null,null,4]
[null,5,null,"T",null,null,null,5]
[null,6,null,"T",null,null,null,6]
[null,7,null,"T",null,null,null,7]
[null,8,null,"T",null,null,null,8]
[null,9,null,"T",null,null,null,9]
[null,10,null,"T",null,null,null,10]
[null,11,null,"T",null,null,null,11]
[null,12,null,"T",null,null,null,12]
[]
[null,null,null,"Copier/coller selon LISTE ENGAGES en fonction des équipes confirmées"]
[null,null,null,"ATTENTION : Respecter l'ordre des têtes de séries."]
[null,null,null,"Ex: Si Sur LISTE ENGAGES, l'équipe 9 absente, la numéro 10 devient la numéro 9 dans EMARG"]

{"sheet":"SCORE QUALIF","index":3,"n_rows":31,"n_cols":34,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
["DEBUT J1","09:00:00"]
["TEMPS","00:50:00"]
["DEBUT J2","14:00:00"]
[]
[null,null,"PHASE","JOUR","N° MATCH","HEURE","TER","EQ1","EQ2","SCORE EQ1","SCORE EQ2","SET 1 EQ1","SET 1 EQ2","SET 2 EQ1","SET 2 EQ2","SET 3 EQ1","SET 3 EQ2","POS 1","POS 2",null,null,null,null,"PTS","S+","S-","P+","P-","CS","CP","CL.I","RG",null,"CLA"]
["POULE A",null,"A",1,1,{"$f":"B3","v":"09:00:00"},1,{"$f":"'TAB QUALIF'!C12","v":"T / 1"},{"$f":"'TAB QUALIF'!C14","v":"T / 9"},{"$f":"SUM(IF(L8>M8,1,0),IF(N8>O8,1,0),IF(P8>Q8,1,0))","v":0},{"$f":"SUM(IF(M8>L8,1,0),IF(O8>N8,1,0),IF(Q8>P8,1,0))","v":0},{"$f":"'TAB QUALIF'!K12","v":0},{"$f":"'TAB QUALIF'!L12","v":0},{"$f":"'TAB QUALIF'!M12","v":0},{"$f":"'TAB QUALIF'!N12","v":0},{"$f":"'TAB QUALIF'!O12","v":0},{"$f":"'TAB QUALIF'!P12","v":0},{"$f":"IF(J8=K8,\"\",IF(J8>K8,H8,I8))","v":""},{"$f":"IF(J8=K8,\"\",IF(J8<K8,H8,I8))","v":""},null,null,null,{"$f":"'TAB QUALIF'!C12","v":"T / 1"},{"$f":"COUNTIF(PLCE1,W8)*2+COUNTIF(PLCE2,W8)","v":0},{"$f":"SUMIF(LISTEE1,W8,(SCEQ1))+SUMIF(LISTEE2,W8,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W8,(SCEQ2))+SUMIF(LISTEE2,W8,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(Y8/Z8,0)","v":0},{"$f":"IFERROR(AA8/AB8,0)","v":0},{"$f":"X8+AC8/100+AD8/100","v":0},{"$f":"IF(X8=0,\"\",RANK(AE8,$AE$8:$AE$10))","v":""},1,{"$f":"IF(X8=0,\"\",IF($AF$8=AG8,$W$8,IF($AF$9=AG8,$W$9,IF($AF$10=AG8,$W$10,IF($AF$11=AG8,$W$11)))))","v":""}]
["A1",null,"B",1,2,{"$f":"B3","v":"09:00:00"},2,{"$f":"'TAB QUALIF'!C16","v":"T / 2"},{"$f":"'TAB QUALIF'!C18","v":"T / 10"},{"$f":"SUM(IF(L9>M9,1,0),IF(N9>O9,1,0),IF(P9>Q9,1,0))","v":0},{"$f":"SUM(IF(M9>L9,1,0),IF(O9>N9,1,0),IF(Q9>P9,1,0))","v":0},{"$f":"'TAB QUALIF'!K16","v":0},{"$f":"'TAB QUALIF'!L16","v":0},{"$f":"'TAB QUALIF'!M16","v":0},{"$f":"'TAB QUALIF'!N16","v":0},{"$f":"'TAB QUALIF'!O16","v":0},{"$f":"'TAB QUALIF'!P16","v":0},{"$f":"IF(J9=K9,\"\",IF(J9>K9,H9,I9))","v":""},{"$f":"IF(J9=K9,\"\",IF(J9<K9,H9,I9))","v":""},null,null,null,{"$f":"'TAB QUALIF'!C13","v":"T / 8"},{"$f":"COUNTIF(PLCE1,W9)*2+COUNTIF(PLCE2,W9)","v":0},{"$f":"SUMIF(LISTEE1,W9,(SCEQ1))+SUMIF(LISTEE2,W9,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W9,(SCEQ2))+SUMIF(LISTEE2,W9,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(Y9/Z9,0)","v":0},{"$f":"IFERROR(AA9/AB9,0)","v":0},{"$f":"X9+AC9/100+AD9/100","v":0},{"$f":"IF(X9=0,\"\",RANK(AE9,$AE$8:$AE$10))","v":""},2,{"$f":"IF(X9=0,\"\",IF($AF$8=AG9,$W$8,IF($AF$9=AG9,$W$9,IF($AF$10=AG9,$W$10,IF($AF$11=AG9,$W$11)))))","v":""}]
["A2",null,"C",1,3,{"$f":"F8+$B$4","v":"09:50:00"},1,{"$f":"'TAB QUALIF'!C20","v":"T / 3"},{"$f":"'TAB QUALIF'!C22","v":"T / 11"},0,0,{"$f":"'TAB QUALIF'!K20","v":0},{"$f":"'TAB QUALIF'!L20","v":0},{"$f":"'TAB QUALIF'!M20","v":0},{"$f":"'TAB QUALIF'!N20","v":0},{"$f":"'TAB QUALIF'!O20","v":0},{"$f":"'TAB QUALIF'!P20","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C14","v":"T / 9"},{"$f":"COUNTIF(PLCE1,W10)*2+COUNTIF(PLCE2,W10)","v":0},{"$f":"SUMIF(LISTEE1,W10,(SCEQ1))+SUMIF(LISTEE2,W10,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W10,SCEQ2)+SUMIF(LISTEE2,W10,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"IF(X10=0,\"\",RANK(AE10,$AE$8:$AE$10))","v":""},3,{"$f":"IF(X10=0,\"\",IF($AF$8=AG10,$W$8,IF($AF$9=AG10,$W$9,IF($AF$10=AG10,$W$10,IF($AF$11=AG10,$W$11)))))","v":""}]
["A3",null,"D",1,4,{"$f":"F9+$B$4","v":"09:50:00"},2,{"$f":"'TAB QUALIF'!C24","v":"T / 4"},{"$f":"'TAB QUALIF'!C26","v":"T / 12"},0,0,{"$f":"'TAB QUALIF'!K24","v":0},{"$f":"'TAB QUALIF'!L24","v":0},{"$f":"'TAB QUALIF'!M24","v":0},{"$f":"'TAB QUALIF'!N24","v":0},{"$f":"'TAB QUALIF'!O24","v":0},{"$f":"'TAB QUALIF'!P24","v":0},"",{"$f":"IF(J11=K11,\"\",IF(J11<K11,H11,I11))","v":""}]
[null,null,"A",1,5,"10:40:00",1,{"$f":"'TAB QUALIF'!C13","v":"T / 8"},{"$f":"'TAB QUALIF'!C14","v":"T / 9"},0,0,{"$f":"'TAB QUALIF'!K13","v":0},{"$f":"'TAB QUALIF'!L13","v":0},{"$f":"'TAB QUALIF'!M13","v":0},{"$f":"'TAB QUALIF'!N13","v":0},{"$f":"'TAB QUALIF'!O13","v":0},{"$f":"'TAB QUALIF'!P13","v":0},"",""]
[null,null,"B",1,6,"10:40:00",2,{"$f":"'TAB QUALIF'!C17","v":"T / 7"},{"$f":"'TAB QUALIF'!C18","v":"T / 10"},0,0,{"$f":"'TAB QUALIF'!K17","v":0},{"$f":"'TAB QUALIF'!L17","v":0},{"$f":"'TAB QUALIF'!M17","v":0},{"$f":"'TAB QUALIF'!N17","v":0},{"$f":"'TAB QUALIF'!O17","v":0},{"$f":"'TAB QUALIF'!P17","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C16","v":"T / 2"},{"$f":"COUNTIF(PLCE1,W13)*2+COUNTIF(PLCE2,W13)","v":0},{"$f":"SUMIF(LISTEE1,W13,(SCEQ1))+SUMIF(LISTEE2,W13,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W13,SCEQ2)+SUMIF(LISTEE2,W13,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE13,$AE$13:$AE$17)","v":1},1,{"$f":"IF(X13=0,\"\",IF($AF$13=AG13,$W$13,IF($AF$14=AG13,$W$14,IF($AF$15=AG13,$W$15,IF($AF$16=AG13,$W$16)))))","v":""}]
["POULE B",null,"C",1,7,"11:30:00",1,{"$f":"'TAB QUALIF'!C21","v":"T / 6"},{"$f":"'TAB QUALIF'!C22","v":"T / 11"},0,0,{"$f":"'TAB QUALIF'!K21","v":0},{"$f":"'TAB QUALIF'!L21","v":0},{"$f":"'TAB QUALIF'!M21","v":0},{"$f":"'TAB QUALIF'!N21","v":0},{"$f":"'TAB QUALIF'!O21","v":0},{"$f":"'TAB QUALIF'!P21","v":0},{"$f":"IF(J14=K14,\"\",IF(J14>K14,H14,I14))","v":""},"",null,null,null,{"$f":"'TAB QUALIF'!C17","v":"T / 7"},{"$f":"COUNTIF(PLCE1,W14)*2+COUNTIF(PLCE2,W14)","v":0},{"$f":"SUMIF(LISTEE1,W14,(SCEQ1))+SUMIF(LISTEE2,W14,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W14,SCEQ2)+SUMIF(LISTEE2,W14,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE14,$AE$13:$AE$15)","v":1},2,{"$f":"IF(X14=0,\"\",IF($AF$13=AG14,$W$13,IF($AF$14=AG14,$W$14,IF($AF$15=AG14,$W$15,IF($AF$16=AG14,$W$16)))))","v":""}]
["B1",null,"D",1,8,"11:30:00",2,{"$f":"'TAB QUALIF'!C25","v":"T / 5"},{"$f":"'TAB QUALIF'!C26","v":"T / 12"},0,0,{"$f":"'TAB QUALIF'!K25","v":0},{"$f":"'TAB QUALIF'!L25","v":0},{"$f":"'TAB QUALIF'!M25","v":0},{"$f":"'TAB QUALIF'!N25","v":0},{"$f":"'TAB QUALIF'!O25","v":0},{"$f":"'TAB QUALIF'!P25","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C18","v":"T / 10"},{"$f":"COUNTIF(PLCE1,W15)*2+COUNTIF(PLCE2,W15)","v":0},{"$f":"SUMIF(LISTEE1,W15,(SCEQ1))+SUMIF(LISTEE2,W15,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W15,SCEQ2)+SUMIF(LISTEE2,W15,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE15,$AE$13:$AE$17)","v":1},3,{"$f":"IF(X15=0,\"\",IF($AF$13=AG15,$W$13,IF($AF$14=AG15,$W$14,IF($AF$15=AG15,$W$15,IF($AF$16=AG15,$W$16)))))","v":""}]
["B2",null,"A",1,9,"12:20:00",1,{"$f":"'TAB QUALIF'!C12","v":"T / 1"},{"$f":"'TAB QUALIF'!C13","v":"T / 8"},0,0,{"$f":"'TAB QUALIF'!K14","v":0},{"$f":"'TAB QUALIF'!L14","v":0},{"$f":"'TAB QUALIF'!M14","v":0},{"$f":"'TAB QUALIF'!N14","v":0},{"$f":"'TAB QUALIF'!O14","v":0},{"$f":"'TAB QUALIF'!P14","v":0},"",""]
["B3",null,"B",1,10,"12:20:00",2,{"$f":"'TAB QUALIF'!C16","v":"T / 2"},{"$f":"'TAB QUALIF'!C17","v":"T / 7"},0,0,{"$f":"'TAB QUALIF'!K18","v":0},{"$f":"'TAB QUALIF'!L18","v":0},{"$f":"'TAB QUALIF'!M18","v":0},{"$f":"'TAB QUALIF'!N18","v":0},{"$f":"'TAB QUALIF'!O18","v":0},{"$f":"'TAB QUALIF'!P18","v":0},"",""]
[null,null,"C",1,11,"13:10:00",1,{"$f":"'TAB QUALIF'!C20","v":"T / 3"},{"$f":"'TAB QUALIF'!C21","v":"T / 6"},0,0,{"$f":"'TAB QUALIF'!K22","v":0},{"$f":"'TAB QUALIF'!L22","v":0},{"$f":"'TAB QUALIF'!M22","v":0},{"$f":"'TAB QUALIF'!N22","v":0},{"$f":"'TAB QUALIF'!O22","v":0},{"$f":"'TAB QUALIF'!P22","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C20","v":"T / 3"},{"$f":"COUNTIF(PLCE1,W18)*2+COUNTIF(PLCE2,W18)","v":0},{"$f":"SUMIF(LISTEE1,W18,(SCEQ1))+SUMIF(LISTEE2,W18,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W18,SCEQ2)+SUMIF(LISTEE2,W18,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(Y18/Z18,0)","v":0},0,{"$f":"X18+AC18/100+AD18/100","v":0},{"$f":"RANK(AE18,$AE$18:$AE$22)","v":1},1,{"$f":"IF(X18=0,\"\",IF(AF$18=AG18,W18,IF(AF19=AG18,W19,IF(AF20=AG18,W20,IF(AF21=AG18,W21)))))","v":""}]
[null,null,"D",1,12,{"$f":"F17+$B$4","v":"13:10:00"},2,{"$f":"'TAB QUALIF'!C24","v":"T / 4"},{"$f":"'TAB QUALIF'!C25","v":"T / 5"},0,0,{"$f":"'TAB QUALIF'!K26","v":0},{"$f":"'TAB QUALIF'!L26","v":0},{"$f":"'TAB QUALIF'!M26","v":0},{"$f":"'TAB QUALIF'!N26","v":0},{"$f":"'TAB QUALIF'!O26","v":0},{"$f":"'TAB QUALIF'!P26","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C21","v":"T / 6"},{"$f":"COUNTIF(PLCE1,W19)*2+COUNTIF(PLCE2,W19)","v":0},{"$f":"SUMIF(LISTEE1,W19,(SCEQ1))+SUMIF(LISTEE2,W19,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W19,SCEQ2)+SUMIF(LISTEE2,W19,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,{"$f":"X19+AC19/100+AD19/100","v":0},{"$f":"RANK(AE19,$AE$18:$AE$22)","v":1},2,{"$f":"IF(X19=0,\"\",IF(AF$18=AG19,W18,IF(AF19=AG19,W19,IF(AF20=AG19,W20,IF(AF21=AG19,W21)))))","v":""}]
["POULE C",null,"BARR",1,13,{"$f":"F18+$B$4","v":"14:00:00"},1,{"$f":"'TAB QUALIF'!X11","v":""},{"$f":"'TAB QUALIF'!X14","v":""},{"$f":"IF(L20=0,\"\",SUM(IF(L20>M20,1,0),IF(N20>O20,1,0),IF(P20>Q20,1,0)))","v":""},{"$f":"IF(M20=0,\"\",SUM(IF(M20>L20,1,0),IF(O20>N20,1,0),IF(Q20>P20,1,0)))","v":""},{"$f":"'TAB QUALIF'!Z12","v":0},{"$f":"'TAB QUALIF'!Z13","v":0},{"$f":"'TAB QUALIF'!AA12","v":0},{"$f":"'TAB QUALIF'!AA13","v":0},{"$f":"'TAB QUALIF'!AB12","v":0},{"$f":"'TAB QUALIF'!AB13","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C22","v":"T / 11"},{"$f":"COUNTIF(PLCE1,W20)*2+COUNTIF(PLCE2,W20)","v":0},{"$f":"SUMIF(LISTEE1,W20,(SCEQ1))+SUMIF(LISTEE2,W20,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W20,SCEQ2)+SUMIF(LISTEE2,W20,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE20,$AE$18:$AE$22)","v":1},3,{"$f":"IF(X20=0,\"\",IF(AF$18=AG20,W18,IF(AF19=AG20,W19,IF(AF20=AG20,W20,IF(AF21=AG20,W21)))))","v":""}]
["C1",null,"BARR",1,14,{"$f":"F19+$B$4","v":"14:00:00"},2,{"$f":"'TAB QUALIF'!X15","v":""},{"$f":"'TAB QUALIF'!X18","v":""},{"$f":"IF(L21=0,\"\",SUM(IF(L21>M21,1,0),IF(N21>O21,1,0),IF(P21>Q21,1,0)))","v":""},{"$f":"IF(M21=0,\"\",SUM(IF(M21>L21,1,0),IF(O21>N21,1,0),IF(Q21>P21,1,0)))","v":""},{"$f":"'TAB QUALIF'!Z16","v":0},{"$f":"'TAB QUALIF'!Z17","v":0},{"$f":"'TAB QUALIF'!AA16","v":0},{"$f":"'TAB QUALIF'!AA17","v":0},{"$f":"'TAB QUALIF'!AB16","v":0},{"$f":"'TAB QUALIF'!AB17","v":0},"",""]
["C2",null,"BARR",1,15,{"$f":"F20+$B$4","v":"14:50:00"},1,{"$f":"'TAB QUALIF'!X21","v":""},{"$f":"'TAB QUALIF'!X24","v":""},"","",{"$f":"'TAB QUALIF'!Z22","v":0},{"$f":"'TAB QUALIF'!Z23","v":0},{"$f":"'TAB QUALIF'!AA22","v":0},{"$f":"'TAB QUALIF'!AA23","v":0},{"$f":"'TAB QUALIF'!AB22","v":0},{"$f":"'TAB QUALIF'!AB23","v":0},"",""]
["C3",null,"BARR",1,16,{"$f":"F21+$B$4","v":"14:50:00"},2,{"$f":"'TAB QUALIF'!X25","v":""},{"$f":"'TAB QUALIF'!X28","v":""},"","",{"$f":"'TAB QUALIF'!Z26","v":0},{"$f":"'TAB QUALIF'!Z27","v":0},{"$f":"'TAB QUALIF'!AA26","v":0},{"$f":"'TAB QUALIF'!AA27","v":0},{"$f":"'TAB QUALIF'!AB26","v":0},{"$f":"'TAB QUALIF'!AB27","v":0},"","",null,null,null,{"$f":"'TAB QUALIF'!C24","v":"T / 4"},{"$f":"COUNTIF(PLCE1,W23)*2+COUNTIF(PLCE2,W23)","v":0},{"$f":"SUMIF(LISTEE1,W23,(SCEQ1))+SUMIF(LISTEE2,W23,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W23,SCEQ2)+SUMIF(LISTEE2,W23,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE23,$AE$23:$AE$27)","v":1},1,{"$f":"IF(X23=0,\"\",IF($AF$23=AG23,$W$23,IF($AF$24=AG23,$W$24,IF($AF$25=AG23,$W$25,IF($AF$26=AG23,$W$26)))))","v":""}]
[null,null,"1/4",1,17,{"$f":"B5","v":"14:00:00"},1,{"$f":"AH8","v":""},{"$f":"R20","v":""},{"$f":"SUM(IF(L24>M24,1,0),IF(N24>O24,1,0),IF(P24>Q24,1,0))","v":0},{"$f":"SUM(IF(M24>L24,1,0),IF(O24>N24,1,0),IF(Q24>P24,1,0))","v":0},null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB QUALIF'!C25","v":"T / 5"},{"$f":"COUNTIF(PLCE1,W24)*2+COUNTIF(PLCE2,W24)","v":0},{"$f":"SUMIF(LISTEE1,W24,(SCEQ1))+SUMIF(LISTEE2,W24,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W24,SCEQ2)+SUMIF(LISTEE2,W24,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE24,$AE$23:$AE$27)","v":1},2,{"$f":"IF(X24=0,\"\",IF($AF$23=AG24,$W$23,IF($AF$24=AG24,$W$24,IF($AF$25=AG24,$W$25,IF($AF$26=AG24,$W$26)))))","v":""}]
[null,null,"1/4",1,18,{"$f":"B5","v":"14:00:00"},2,{"$f":"AH23","v":""},{"$f":"R21","v":""},0,0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB QUALIF'!C26","v":"T / 12"},{"$f":"COUNTIF(PLCE1,W25)*2+COUNTIF(PLCE2,W25)","v":0},{"$f":"SUMIF(LISTEE1,W25,(SCEQ1))+SUMIF(LISTEE2,W25,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W25,SCEQ2)+SUMIF(LISTEE2,W25,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,1,3,{"$f":"IF(X25=0,\"\",IF($AF$23=AG25,$W$23,IF($AF$24=AG25,$W$24,IF($AF$25=AG25,$W$25,IF($AF$26=AG25,$W$26)))))","v":""}]
["POULE D",null,"1/4",1,19,{"$f":"F25+$B$4","v":"14:50:00"},1,{"$f":"AH13","v":""},{"$f":"R23","v":""},0,0,null,null,null,null,null,null,"",""]
["D1",null,"1/4",1,20,{"$f":"F25+$B$4","v":"14:50:00"},2,{"$f":"AH18","v":""},{"$f":"R22","v":""},0,0,null,null,null,null,null,null,"",""]
["D2",null,"1/2",1,21,{"$f":"F27+$B$4","v":"15:40:00"},1,{"$f":"R24","v":""},{"$f":"R25","v":""},0,0,null,null,null,null,null,null,"",""]
["D3",null,"1/2",1,22,{"$f":"F28+$B$4","v":"16:30:00"},1,{"$f":"R26","v":""},{"$f":"R27","v":""},0,0,null,null,null,null,null,null,"",""]
[null,null,"PF",1,23,"17:20:00",1,{"$f":"S28","v":""},{"$f":"S29","v":""},0,0,null,null,null,null,null,null,"",""]
[null,null,"FF",1,24,"18:10:00",1,{"$f":"R28","v":""},{"$f":"R29","v":""},0,0,null,null,null,null,null,null,"",""]

{"sheet":"TAB QUALIF","index":4,"n_rows":31,"n_cols":31,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,4,29,5],[30,4,30,5],[8,2,8,7],[8,9,8,15],[8,17,8,18],[9,8,9,15],[10,3,10,4],[10,10,10,11],[10,12,10,13],[10,14,10,15],[1,5,3,19],[1,20,6,22],[4,5,4,14],[4,15,4,17],[4,18,4,19],[5,5,5,19],[6,5,6,19]]}
[]
[null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$1","v":"APPELATION TOURNOI"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$1","v":"ORGANISATEUR"}]
[]
[]
[null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$4","v":"LIEU"},null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$F$4","v":"DATE"},null,null,{"$f":"'LISTE ENGAGES'!$H$4","v":"GENRE"}]
[null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$5","v":"TYPE"}]
[null,null,null,null,null,"TABLEAU QUALIFICATION"]
[]
[null,null,"POULES",null,null,null,null,null,null,"RESULTATS",null,null,null,null,null,null,null,"CLASS. POULE",null,null,null,null,null,"BARRAGES"]
[]
[null,null,null,"Ordre",null,"Heure","Terrain","Arbitre",null,"Score","Set 1",null,"Set 2",null,"Set 3",null,null,null,null,null,null,null,null,{"$f":"S18","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS1",{"$f":"CONCATENATE('EMARGEMENT TQ'!D9,\" / \",'EMARGEMENT TQ'!H9)","v":"T / 1"},"TS1-TS9","(1)",{"$f":"G30","v":"09:00:00"},"1","B2",null,{"$f":"CONCATENATE('SCORE QUALIF'!J8,\" / \",'SCORE QUALIF'!K8)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE QUALIF'!AH8","v":""},"Qualifié",null,null,null,"3B                              (B1)",{"$f":"IF('SCORE QUALIF'!J20=\"\",\"\",'SCORE QUALIF'!J20)","v":""}]
["A","TS8",{"$f":"CONCATENATE('EMARGEMENT TQ'!D16,\" / \",'EMARGEMENT TQ'!H16)","v":"T / 8"},"TS8-TS9","(5)",{"$f":"F16+G31","v":"10:30:00"},"1","B1",null,{"$f":"CONCATENATE('SCORE QUALIF'!J12,\" / \",'SCORE QUALIF'!K12)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE QUALIF'!AH9","v":""},13,null,null,null,"2C",{"$f":"'SCORE QUALIF'!K20","v":""}]
[null,"TS9",{"$f":"CONCATENATE('EMARGEMENT TQ'!D17,\" / \",'EMARGEMENT TQ'!H17)","v":"T / 9"},"TS1-TS8","(9)",{"$f":"F17+G31","v":"12:00:00"},"1","B3",null,{"$f":"CONCATENATE('SCORE QUALIF'!J16,\" / \",'SCORE QUALIF'!K16)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE QUALIF'!AH10","v":""},17,null,null,null,{"$f":"S21","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S22","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS2",{"$f":"CONCATENATE('EMARGEMENT TQ'!D10,\" / \",'EMARGEMENT TQ'!H10)","v":"T / 2"},"TS2-TS10","(2)",{"$f":"F12+$G$31","v":"09:45:00"},"1","A2",null,{"$f":"CONCATENATE('SCORE QUALIF'!J9,\" / \",'SCORE QUALIF'!K9)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE QUALIF'!AH13","v":""},"Qualifié",null,null,null,"3C                              (B2)",{"$f":"IF(Z16=Z17,\"\",SUM(IF(Z16>Z17,1,0),IF(AA16>AA17,1,0),IF(AB16<=AB17,0,1)))","v":""}]
["B","TS7",{"$f":"CONCATENATE('EMARGEMENT TQ'!D15,\" / \",'EMARGEMENT TQ'!H15)","v":"T / 7"},"TS7-TS10","(6)",{"$f":"F13+G31","v":"11:15:00"},"1","A1",null,{"$f":"CONCATENATE('SCORE QUALIF'!J13,\" / \",'SCORE QUALIF'!K13)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE QUALIF'!AH14","v":""},13,null,null,null,"2B",{"$f":"IF(Z16=Z17,\"\",SUM(IF(Z16<Z17,1,0),IF(AA16<AA17,1,0),IF(AB16>=AB17,0,1)))","v":""}]
[null,"TS10",{"$f":"CONCATENATE('EMARGEMENT TQ'!D18,\" / \",'EMARGEMENT TQ'!H18)","v":"T / 10"},"TS2-TS7","(10)",{"$f":"F14+G31","v":"12:45:00"},"1","A3",null,{"$f":"CONCATENATE('SCORE QUALIF'!J17,\" / \",'SCORE QUALIF'!K17)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE QUALIF'!AH15","v":""},17,null,null,null,{"$f":"S17","v":""}]
[]
[null,"TS3",{"$f":"CONCATENATE('EMARGEMENT TQ'!D11,\" / \",'EMARGEMENT TQ'!H11)","v":"T / 3"},"TS3-TS11","(3)",{"$f":"G30","v":"09:00:00"},"2","D2",null,{"$f":"CONCATENATE('SCORE QUALIF'!J10,\" / \",'SCORE QUALIF'!K10)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE QUALIF'!AH18","v":""},"Qualifié"]
["C","TS6",{"$f":"CONCATENATE('EMARGEMENT TQ'!D14,\" / \",'EMARGEMENT TQ'!H14)","v":"T / 6"},"TS6-TS11","(7)",{"$f":"F24+#REF!","v":{"$error":"#REF!"}},"2","D1",null,{"$f":"CONCATENATE('SCORE QUALIF'!J14,\" / \",'SCORE QUALIF'!K14)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE QUALIF'!AH19","v":""},13,null,null,null,{"$f":"S26","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS11",{"$f":"CONCATENATE('EMARGEMENT TQ'!D19,\" / \",'EMARGEMENT TQ'!H19)","v":"T / 11"},"TS3-TS6","(11)",{"$f":"F25+#REF!","v":{"$error":"#REF!"}},"2","D3",null,{"$f":"CONCATENATE('SCORE QUALIF'!J18,\" / \",'SCORE QUALIF'!K18)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE QUALIF'!AH20","v":""},17,null,null,null,"3D                                (B3)",{"$f":"IF(Z22=Z23,\"\",SUM(IF(Z22>Z23,1,0),IF(AA22>AA23,1,0),IF(AB22<=AB23,0,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2A",{"$f":"IF(Z22=Z23,\"\",SUM(IF(Z22<Z23,1,0),IF(AA22<AA23,1,0),IF(AB22>=AB23,0,1)))","v":""}]
[null,"TS4",{"$f":"CONCATENATE('EMARGEMENT TQ'!D12,\" / \",'EMARGEMENT TQ'!H12)","v":"T / 4"},"TS4-TS12","(4)",{"$f":"F20+$G$31","v":"09:45:00"},"2","C2",null,{"$f":"CONCATENATE('SCORE QUALIF'!J11,\" / \",'SCORE QUALIF'!K11)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE QUALIF'!AH23","v":""},"Qualifié",null,null,null,{"$f":"S13","v":""}]
["D","TS5",{"$f":"CONCATENATE('EMARGEMENT TQ'!D13,\" / \",'EMARGEMENT TQ'!H13)","v":"T / 5"},"TS5-TS12","(8)",{"$f":"F21+#REF!","v":{"$error":"#REF!"}},"2","C1",null,{"$f":"CONCATENATE('SCORE QUALIF'!J15,\" / \",'SCORE QUALIF'!K15)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE QUALIF'!AH24","v":""},13,null,null,null,{"$f":"S25","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS12",{"$f":"CONCATENATE('EMARGEMENT TQ'!D20,\" / \",'EMARGEMENT TQ'!H20)","v":"T / 12"},"TS4-TS5","(12)",{"$f":"F22+#REF!","v":{"$error":"#REF!"}},"2","C3",null,{"$f":"CONCATENATE('SCORE QUALIF'!J19,\" / \",'SCORE QUALIF'!K19)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE QUALIF'!AH25","v":""},17,null,null,null,"2D",{"$f":"IF(Z26=Z27,\"\",SUM(IF(Z26>Z27,1,0),IF(AA26>AA27,1,0),IF(AB26<=AB27,0,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3A                              (B4)",{"$f":"IF(Z26=Z27,\"\",SUM(IF(Z26<Z27,1,0),IF(AA26<AA27,1,0),IF(AB26>=AB27,0,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S14","v":""}]
[]
[null,null,null,null,"HEURE DEBUT MATCH",null,"09:00:00"]
[null,null,null,null,"DUREE MATCH",null,"00:45:00"]

{"sheet":"EMARGEMENT TP","index":5,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,14,3,14],[4,4,4,14],[5,4,5,14],[1,4,2,13],[3,4,3,7],[3,8,3,12]]}
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$1","v":"APPELATION TOURNOI"},null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$1","v":"ORGANISATEUR"}]
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$4","v":"LIEU"},null,null,null,{"$f":"'LISTE ENGAGES'!$F$4","v":"DATE"},null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$4","v":"GENRE"}]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$5","v":"TYPE"}]
[null,null,null,null,"FEUILLE EMARGEMENT"]
[]
[null,"N°",null,"NOM","PRENOM","LICENCE","CLUB","NOM","PRENOM","LICENCE","CLUB","pts","tir","SIGNATURE JOUEUR1","SIGNATURE JOUEUR2","PAIEMENT"]
[null,1,null,"A",null,null,null,1]
[null,2,null,"B",null,null,null,2]
[null,3,null,"C",null,null,null,3]
[null,4,null,"D",null,null,null,4]
[null,5,null,"E",null,null,null,5]
[null,6,null,"F",null,null,null,6]
[null,7,null,"G",null,null,null,7]
[null,8,null,"H",null,null,null,8]
[null,9,null,"I",null,null,null,9]
[null,10,null,"J",null,null,null,10]
[null,11,null,"K",null,null,null,11]
[null,12,null,"L",null,null,null,12]
[]
[null,null,null,"Copier/coller selon LISTE ENGAGES en fonction des équipes confirmées"]
[null,null,null,"ATTENTION : Respecter l'ordre des têtes de séries."]
[null,null,null,"Ex: Si Sur LISTE ENGAGES, l'équipe 9 absente, la numéro 10 devient la numéro 9 dans EMARG"]

{"sheet":"TAB PRINC","index":6,"n_rows":69,"n_cols":32,"rows_kept":69,"cut":false,"hidden":false,"merged":[[31,23,31,24],[53,23,53,24],[10,3,10,4],[10,10,10,11],[10,12,10,13],[10,14,10,15],[55,1,56,2],[1,5,3,19],[4,5,4,14],[4,15,4,17],[4,18,4,19],[8,2,8,7],[8,9,8,15],[8,17,8,18],[9,8,9,15],[29,18,29,19],[5,5,5,22],[6,5,6,22],[1,20,4,22]]}
[]
[null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$1","v":"APPELATION TOURNOI"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$1","v":"ORGANISATEUR"}]
[]
[]
[null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$4","v":"LIEU"},null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$F$4","v":"DATE"},null,null,{"$f":"'LISTE ENGAGES'!$H$4","v":"GENRE"}]
[null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$C$5","v":"TYPE"}]
[null,null,null,null,null,"TABLEAU PRINCIPAL"]
[]
[null,null,"POULES",null,null,null,null,null,null,"RESULTATS",null,null,null,null,null,null,null,"CLASS. POULE",null,null,null,null,null,"BARRAGES"]
[]
[null,null,null,"Ordre",null,"Heure","Terrain","Arbitre",null,"Score","Set 1",null,"Set 2",null,"Set 3",null,null,null,null,null,null,null,null,{"$f":"S18","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS1",{"$f":"CONCATENATE('EMARGEMENT TP'!D9,\" / \",'EMARGEMENT TP'!H9)","v":"A / 1"},"TS1-TS9","(1)","9h00","1","B2",null,{"$f":"CONCATENATE('SCORE PRINC'!J8,\" / \",'SCORE PRINC'!K8)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE PRINC'!AH8","v":""},null,null,null,null,"3B                              (B1)",{"$f":"IF(Z12=Z13,\"\",SUM(IF(Z12>Z13,1,0),IF(AA12>AA13,1,0),IF(AB12<=AB13,0,1)))","v":""}]
["A","TS8",{"$f":"CONCATENATE('EMARGEMENT TP'!D16,\" / \",'EMARGEMENT TP'!H16)","v":"H / 8"},"TS8-TS9","(5)","10h30","1","B1",null,{"$f":"CONCATENATE('SCORE PRINC'!J12,\" / \",'SCORE PRINC'!K12)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE PRINC'!AH9","v":""},null,null,null,null,"2C",{"$f":"IF(Z12=Z13,\"\",SUM(IF(Z12<Z13,1,0),IF(AA12<AA13,1,0),IF(AB12>=AB13,0,1)))","v":""}]
[null,"TS9",{"$f":"CONCATENATE('EMARGEMENT TP'!D17,\" / \",'EMARGEMENT TP'!H17)","v":"I / 9"},"TS1-TS8","(9)","12h00","1","B3",null,{"$f":"CONCATENATE('SCORE PRINC'!J16,\" / \",'SCORE PRINC'!K16)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE PRINC'!AH10","v":""},null,null,null,null,{"$f":"S21","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S22","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS2",{"$f":"CONCATENATE('EMARGEMENT TP'!D10,\" / \",'EMARGEMENT TP'!H10)","v":"B / 2"},"TS2-TS10","(2)","9h45","1","A2",null,{"$f":"CONCATENATE('SCORE PRINC'!J9,\" / \",'SCORE PRINC'!K9)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE PRINC'!AH13","v":""},null,null,null,null,"3C                              (B2)",{"$f":"IF(Z16=Z17,\"\",SUM(IF(Z16>Z17,1,0),IF(AA16>AA17,1,0),IF(AB16<=AB17,0,1)))","v":""}]
["B","TS7",{"$f":"CONCATENATE('EMARGEMENT TP'!D15,\" / \",'EMARGEMENT TP'!H15)","v":"G / 7"},"TS7-TS10","(6)","11h15","1","A1",null,{"$f":"CONCATENATE('SCORE PRINC'!J13,\" / \",'SCORE PRINC'!K13)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE PRINC'!AH14","v":""},null,null,null,null,"2B",{"$f":"IF(Z16=Z17,\"\",SUM(IF(Z16<Z17,1,0),IF(AA16<AA17,1,0),IF(AB16>=AB17,0,1)))","v":""}]
[null,"TS10",{"$f":"CONCATENATE('EMARGEMENT TP'!D18,\" / \",'EMARGEMENT TP'!H18)","v":"J / 10"},"TS2-TS7","(10)","12h45","1","A3",null,{"$f":"CONCATENATE('SCORE PRINC'!J17,\" / \",'SCORE PRINC'!K17)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE PRINC'!AH15","v":""},null,null,null,null,{"$f":"S17","v":""}]
[]
[null,"TS3",{"$f":"CONCATENATE('EMARGEMENT TP'!D11,\" / \",'EMARGEMENT TP'!H11)","v":"C / 3"},"TS3-TS11","(3)","9h00","2","D2",null,{"$f":"CONCATENATE('SCORE PRINC'!J10,\" / \",'SCORE PRINC'!K10)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE PRINC'!AH18","v":""}]
["C","TS6",{"$f":"CONCATENATE('EMARGEMENT TP'!D14,\" / \",'EMARGEMENT TP'!H14)","v":"F / 6"},"TS6-TS11","(7)","10h30","2","D1",null,{"$f":"CONCATENATE('SCORE PRINC'!J14,\" / \",'SCORE PRINC'!K14)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE PRINC'!AH19","v":""},null,null,null,null,{"$f":"S26","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS11",{"$f":"CONCATENATE('EMARGEMENT TP'!D19,\" / \",'EMARGEMENT TP'!H19)","v":"K / 11"},"TS3-TS6","(11)","12h00","2","D3",null,{"$f":"CONCATENATE('SCORE PRINC'!J18,\" / \",'SCORE PRINC'!K18)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE PRINC'!AH20","v":""},null,null,null,null,"3D                                (B3)",{"$f":"IF(Z22=Z23,\"\",SUM(IF(Z22>Z23,1,0),IF(AA22>AA23,1,0),IF(AB22<=AB23,0,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2A",{"$f":"IF(Z22=Z23,\"\",SUM(IF(Z22<Z23,1,0),IF(AA22<AA23,1,0),IF(AB22>=AB23,0,1)))","v":""}]
[null,"TS4",{"$f":"CONCATENATE('EMARGEMENT TP'!D12,\" / \",'EMARGEMENT TP'!H12)","v":"D / 4"},"TS4-TS12","(4)","9h45","2","C2",null,{"$f":"CONCATENATE('SCORE PRINC'!J11,\" / \",'SCORE PRINC'!K11)","v":"0 / 0"},null,null,null,null,null,null,null,1,{"$f":"'SCORE PRINC'!AH23","v":""},null,null,null,null,{"$f":"S13","v":""}]
["D","TS5",{"$f":"CONCATENATE('EMARGEMENT TP'!D13,\" / \",'EMARGEMENT TP'!H13)","v":"E / 5"},"TS5-TS12","(8)","11h15","2","C1",null,{"$f":"CONCATENATE('SCORE PRINC'!J15,\" / \",'SCORE PRINC'!K15)","v":"0 / 0"},null,null,null,null,null,null,null,2,{"$f":"'SCORE PRINC'!AH24","v":""},null,null,null,null,{"$f":"S25","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,"TS12",{"$f":"CONCATENATE('EMARGEMENT TP'!D20,\" / \",'EMARGEMENT TP'!H20)","v":"L / 12"},"TS4-TS5","(12)","12h45","2","C3",null,{"$f":"CONCATENATE('SCORE PRINC'!J19,\" / \",'SCORE PRINC'!K19)","v":"0 / 0"},null,null,null,null,null,null,null,3,{"$f":"'SCORE PRINC'!AH25","v":""},null,null,null,null,"2D",{"$f":"IF(Z26=Z27,\"\",SUM(IF(Z26>Z27,1,0),IF(AA26>AA27,1,0),IF(AB26<=AB27,0,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3A                              (B4)",{"$f":"IF(Z26=Z27,\"\",SUM(IF(Z26<Z27,1,0),IF(AA26<AA27,1,0),IF(AB26>=AB27,0,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S14","v":""}]
[null,null,"1/4 FINALE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 FINALE"]
[null,null,{"$f":"S12","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,null,"1A                       (17)",{"$f":"IF(E32=E33,\"\",SUM(IF(E32>E33,1,0),IF(F32>F33,1,0),IF(G32<=G33,0,1)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINALE"]
[null,null,"B1",{"$f":"IF(E32=E33,\"\",SUM(IF(E32<E33,1,0),IF(F32<F33,1,0),IF(G32>=G33,0,1)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32=D33,\" \",IF(D32>D33,C31,C34))","v":" "}]
[null,null,{"$f":"IF(Y12=Y13,\" \",IF(Y12>Y13,X11,X14))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score","S1","S2","S3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(21)",{"$f":"IF(U36=U37,\"\",SUM(IF(U36>U37,1,0),IF(V36>V37,1,0),IF(W36<=W37,0,1)))","v":""},null,null,null,{"$f":"IF(T36=T37,\" \",IF(T36>T37,S33,S40))","v":" "}]
[null,null,{"$f":"IF(Y16=Y17,\" \",IF(Y16>Y17,X15,X18))","v":" "},"Score","S1","S2","S3","Heure","Terrain","Arbitre",null,null,null,null,null,null,null,null,null,{"$f":"IF(U36=U37,\"\",SUM(IF(U36<U37,1,0),IF(V36<V37,1,0),IF(W36>=W37,0,1)))","v":""}]
[null,null,"B2",{"$f":"IF(E38=E39,\"\",SUM(IF(E38>E39,1,0),IF(F38>F39,1,0),IF(G38<=G39,0,1)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H","T","A"]
[null,null,"1D                        (18)",{"$f":"IF(E38=E39,\"\",SUM(IF(E38<E39,1,0),IF(F38<F39,1,0),IF(G38>=G39,0,1)))","v":""}]
[null,null,{"$f":"S24","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38=D39,\" \",IF(D38>D39,C37,C40))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(24)",{"$f":"IF(Z42=Z43,\"\",SUM(IF(Z42>Z43,1,0),IF(AA42>AA43,1,0),IF(AB42<=AB43,0,1)))","v":""},null,null,null,null,null,null,{"$f":"IF(Y42=Y43,\" \",IF(Y42>Y43,X36,X50))","v":" "}]
[null,null,{"$f":"S20","v":""},"Score","S1","S2","S3","Heure","Terrain","Arbitre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z42=Z43,\"\",SUM(IF(Z42<Z43,1,0),IF(AA42<AA43,1,0),IF(AB42>=AB43,0,1)))","v":""}]
[null,null,"1C                       (19)",{"$f":"IF(E44=E45,\"\",SUM(IF(E44>E45,1,0),IF(F44>F45,1,0),IF(G44<=G45,0,1)))","v":""}]
[null,null,null,{"$f":"IF(E44=E45,\"\",SUM(IF(E44<E45,1,0),IF(F44<F45,1,0),IF(G44>=G45,0,1)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D44=D45,\" \",IF(D44>D45,C43,C46))","v":" "}]
[null,null,{"$f":"IF(Y22=Y23,\" \",IF(Y22>Y23,X21,X24))","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score","S1","S2","S3"]
[null,null,{"$f":"IF(Y26=Y27,\" \",IF(Y26>Y27,X25,Y28))","v":" "},"Score","S1","S2","S3","Heure","Terrain","Arbitre",null,null,null,null,null,null,null,null,"(22)",{"$f":"IF(U49=U50,\"\",SUM(IF(U49>U50,1,0),IF(V49>V50,1,0),IF(W49<=W50,0,1)))","v":""}]
[null,null,null,{"$f":"IF(E50=E51,\"\",SUM(IF(E50>E51,1,0),IF(F50>F51,1,0),IF(G50<=G51,0,1)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U49=U50,\"\",SUM(IF(U49<U50,1,0),IF(V49<V50,1,0),IF(W49>=W50,0,1)))","v":""},null,null,null,{"$f":"IF(T49=T50,\" \",IF(T49>T50,S45,S52))","v":" "}]
[null,null,"1B                       (20)",{"$f":"IF(E50=E51,\"\",SUM(IF(E50<E51,1,0),IF(F50<F51,1,0),IF(G50>=G51,0,1)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H","T","A"]
[null,null,{"$f":"S16","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D50=D51,\" \",IF(D50>D51,C49,C52))","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLACE 3/4"]
[]
[null,"CLASSEMENT FINAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T36=T37,\" \",IF(T36>T37,S40,S33))","v":" "}]
[]
[null,1,{"$f":"AF42","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score","S1","S2","S3","Heure","Terrain","Arbitre"]
[null,2,{"$f":"IF(X36=AF42,X50,X36)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(23)",{"$f":"IF(Z59=Z60,\"\",SUM(IF(Z59>Z60,1,0),IF(AA59>AA60,1,0),IF(AB59<=AB60,0,1)))","v":""},null,null,null,null,null,null,{"$f":"IF(Y59=Y60,\" \",IF(Y59>Y60,X56,AZ59))","v":" "}]
[null,3,{"$f":"AF59","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z59=Z60,\"\",SUM(IF(Z59<Z60,1,0),IF(AA59<AA60,1,0),IF(AB59>=AB60,0,1)))","v":""}]
[null,4,{"$f":"IF(X56=AF59,X62,X56)","v":" "}]
[null,5,{"$f":"IF(C31=S33,C34,C31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T49=T50,\" \",IF(T49>T50,S52,S45))","v":" "}]
[null,5,{"$f":"IF(C37=S40,C40,C37)","v":""}]
[null,5,{"$f":"IF(C43=S45,C46,C43)","v":""}]
[null,5,{"$f":"IF(C49=S52,C52,C49)","v":""}]
[null,9,{"$f":"IF(X11=C34,X14,X11)","v":""}]
[null,9,{"$f":"IF(X15=C37,X18,X15)","v":""}]
[null,9,{"$f":"IF(X21=C46,X24,X21)","v":""}]
[null,9,{"$f":"IF(X25=C49,X28,X25)","v":""}]

{"sheet":"SCORE PRINC","index":7,"n_rows":31,"n_cols":34,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
["DEBUT J1","09:00:00"]
["TEMPS","00:50:00"]
["DEBUT J2","14:00:00"]
[]
[null,null,"PHASE","JOUR","N° MATCH","HEURE","TER","EQ1","EQ2","SCORE EQ1","SCORE EQ2","SET 1 EQ1","SET 1 EQ2","SET 2 EQ1","SET 2 EQ2","SET 3 EQ1","SET 3 EQ2","POS 1","POS 2",null,null,null,null,"PTS","S+","S-","P+","P-","CS","CP","CL.I","RG",null,"CLA"]
["POULE A",null,"A",1,1,{"$f":"B3","v":"09:00:00"},1,{"$f":"'TAB PRINC'!C12","v":"A / 1"},{"$f":"'TAB PRINC'!C14","v":"I / 9"},{"$f":"SUM(IF(L8>M8,1,0),IF(N8>O8,1,0),IF(P8>Q8,1,0))","v":0},{"$f":"SUM(IF(M8>L8,1,0),IF(O8>N8,1,0),IF(Q8>P8,1,0))","v":0},{"$f":"'TAB PRINC'!K12","v":0},{"$f":"'TAB PRINC'!L12","v":0},{"$f":"'TAB PRINC'!M12","v":0},{"$f":"'TAB PRINC'!N12","v":0},{"$f":"'TAB PRINC'!O12","v":0},{"$f":"'TAB PRINC'!P12","v":0},{"$f":"IF(J8=K8,\"\",IF(J8>K8,H8,I8))","v":""},{"$f":"IF(J8=K8,\"\",IF(J8<K8,H8,I8))","v":""},null,null,null,{"$f":"'TAB PRINC'!C12","v":"A / 1"},{"$f":"COUNTIF(PLCE1,W8)*2+COUNTIF(PLCE2,W8)","v":0},{"$f":"SUMIF(LISTEE1,W8,(SCEQ1))+SUMIF(LISTEE2,W8,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W8,(SCEQ2))+SUMIF(LISTEE2,W8,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(Y8/Z8,0)","v":0},{"$f":"IFERROR(AA8/AB8,0)","v":0},{"$f":"X8+AC8/100+AD8/100","v":0},{"$f":"IF(X8=0,\"\",RANK(AE8,$AE$8:$AE$10))","v":""},1,{"$f":"IF(X8=0,\"\",IF($AF$8=AG8,$W$8,IF($AF$9=AG8,$W$9,IF($AF$10=AG8,$W$10,IF($AF$11=AG8,$W$11)))))","v":""}]
["A1",null,"B",1,2,{"$f":"B3","v":"09:00:00"},2,{"$f":"'TAB PRINC'!C16","v":"B / 2"},{"$f":"'TAB PRINC'!C18","v":"J / 10"},{"$f":"SUM(IF(L9>M9,1,0),IF(N9>O9,1,0),IF(P9>Q9,1,0))","v":0},{"$f":"SUM(IF(M9>L9,1,0),IF(O9>N9,1,0),IF(Q9>P9,1,0))","v":0},{"$f":"'TAB PRINC'!K16","v":0},{"$f":"'TAB PRINC'!L16","v":0},{"$f":"'TAB PRINC'!M16","v":0},{"$f":"'TAB PRINC'!N16","v":0},{"$f":"'TAB PRINC'!O16","v":0},{"$f":"'TAB PRINC'!P16","v":0},{"$f":"IF(J9=K9,\"\",IF(J9>K9,H9,I9))","v":""},{"$f":"IF(J9=K9,\"\",IF(J9<K9,H9,I9))","v":""},null,null,null,{"$f":"'TAB PRINC'!C13","v":"H / 8"},{"$f":"COUNTIF(PLCE1,W9)*2+COUNTIF(PLCE2,W9)","v":0},{"$f":"SUMIF(LISTEE1,W9,(SCEQ1))+SUMIF(LISTEE2,W9,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W9,(SCEQ2))+SUMIF(LISTEE2,W9,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(Y9/Z9,0)","v":0},{"$f":"IFERROR(AA9/AB9,0)","v":0},{"$f":"X9+AC9/100+AD9/100","v":0},{"$f":"IF(X9=0,\"\",RANK(AE9,$AE$8:$AE$10))","v":""},2,{"$f":"IF(X9=0,\"\",IF($AF$8=AG9,$W$8,IF($AF$9=AG9,$W$9,IF($AF$10=AG9,$W$10,IF($AF$11=AG9,$W$11)))))","v":""}]
["A2",null,"C",1,3,{"$f":"F8+$B$4","v":"09:50:00"},1,{"$f":"'TAB PRINC'!C20","v":"C / 3"},{"$f":"'TAB PRINC'!C22","v":"K / 11"},0,0,{"$f":"'TAB PRINC'!K20","v":0},{"$f":"'TAB PRINC'!L20","v":0},{"$f":"'TAB PRINC'!M20","v":0},{"$f":"'TAB PRINC'!N20","v":0},{"$f":"'TAB PRINC'!O20","v":0},{"$f":"'TAB PRINC'!P20","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C14","v":"I / 9"},{"$f":"COUNTIF(PLCE1,W10)*2+COUNTIF(PLCE2,W10)","v":0},{"$f":"SUMIF(LISTEE1,W10,(SCEQ1))+SUMIF(LISTEE2,W10,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W10,SCEQ2)+SUMIF(LISTEE2,W10,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"IF(X10=0,\"\",RANK(AE10,$AE$8:$AE$10))","v":""},3,{"$f":"IF(X10=0,\"\",IF($AF$8=AG10,$W$8,IF($AF$9=AG10,$W$9,IF($AF$10=AG10,$W$10,IF($AF$11=AG10,$W$11)))))","v":""}]
["A3",null,"D",1,4,{"$f":"F9+$B$4","v":"09:50:00"},2,{"$f":"'TAB PRINC'!C24","v":"D / 4"},{"$f":"'TAB PRINC'!C26","v":"L / 12"},0,0,{"$f":"'TAB PRINC'!K24","v":0},{"$f":"'TAB PRINC'!L24","v":0},{"$f":"'TAB PRINC'!M24","v":0},{"$f":"'TAB PRINC'!N24","v":0},{"$f":"'TAB PRINC'!O24","v":0},{"$f":"'TAB PRINC'!P24","v":0},"",{"$f":"IF(J11=K11,\"\",IF(J11<K11,H11,I11))","v":""}]
[null,null,"A",1,5,"10:40:00",1,{"$f":"'TAB PRINC'!C13","v":"H / 8"},{"$f":"'TAB PRINC'!C14","v":"I / 9"},0,0,{"$f":"'TAB PRINC'!K13","v":0},{"$f":"'TAB PRINC'!L13","v":0},{"$f":"'TAB PRINC'!M13","v":0},{"$f":"'TAB PRINC'!N13","v":0},{"$f":"'TAB PRINC'!O13","v":0},{"$f":"'TAB PRINC'!P13","v":0},"",""]
[null,null,"B",1,6,"10:40:00",2,{"$f":"'TAB PRINC'!C17","v":"G / 7"},{"$f":"'TAB PRINC'!C18","v":"J / 10"},0,0,{"$f":"'TAB PRINC'!K17","v":0},{"$f":"'TAB PRINC'!L17","v":0},{"$f":"'TAB PRINC'!M17","v":0},{"$f":"'TAB PRINC'!N17","v":0},{"$f":"'TAB PRINC'!O17","v":0},{"$f":"'TAB PRINC'!P17","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C16","v":"B / 2"},{"$f":"COUNTIF(PLCE1,W13)*2+COUNTIF(PLCE2,W13)","v":0},{"$f":"SUMIF(LISTEE1,W13,(SCEQ1))+SUMIF(LISTEE2,W13,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W13,SCEQ2)+SUMIF(LISTEE2,W13,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE13,$AE$13:$AE$17)","v":1},1,{"$f":"IF(X13=0,\"\",IF($AF$13=AG13,$W$13,IF($AF$14=AG13,$W$14,IF($AF$15=AG13,$W$15,IF($AF$16=AG13,$W$16)))))","v":""}]
["POULE B",null,"C",1,7,"11:30:00",1,{"$f":"'TAB PRINC'!C21","v":"F / 6"},{"$f":"'TAB PRINC'!C22","v":"K / 11"},0,0,{"$f":"'TAB PRINC'!K21","v":0},{"$f":"'TAB PRINC'!L21","v":0},{"$f":"'TAB PRINC'!M21","v":0},{"$f":"'TAB PRINC'!N21","v":0},{"$f":"'TAB PRINC'!O21","v":0},{"$f":"'TAB PRINC'!P21","v":0},{"$f":"IF(J14=K14,\"\",IF(J14>K14,H14,I14))","v":""},"",null,null,null,{"$f":"'TAB PRINC'!C17","v":"G / 7"},{"$f":"COUNTIF(PLCE1,W14)*2+COUNTIF(PLCE2,W14)","v":0},{"$f":"SUMIF(LISTEE1,W14,(SCEQ1))+SUMIF(LISTEE2,W14,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W14,SCEQ2)+SUMIF(LISTEE2,W14,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE14,$AE$13:$AE$15)","v":1},2,{"$f":"IF(X14=0,\"\",IF($AF$13=AG14,$W$13,IF($AF$14=AG14,$W$14,IF($AF$15=AG14,$W$15,IF($AF$16=AG14,$W$16)))))","v":""}]
["B1",null,"D",1,8,"11:30:00",2,{"$f":"'TAB PRINC'!C25","v":"E / 5"},{"$f":"'TAB PRINC'!C26","v":"L / 12"},0,0,{"$f":"'TAB PRINC'!K25","v":0},{"$f":"'TAB PRINC'!L25","v":0},{"$f":"'TAB PRINC'!M25","v":0},{"$f":"'TAB PRINC'!N25","v":0},{"$f":"'TAB PRINC'!O25","v":0},{"$f":"'TAB PRINC'!P25","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C18","v":"J / 10"},{"$f":"COUNTIF(PLCE1,W15)*2+COUNTIF(PLCE2,W15)","v":0},{"$f":"SUMIF(LISTEE1,W15,(SCEQ1))+SUMIF(LISTEE2,W15,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W15,SCEQ2)+SUMIF(LISTEE2,W15,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE15,$AE$13:$AE$17)","v":1},3,{"$f":"IF(X15=0,\"\",IF($AF$13=AG15,$W$13,IF($AF$14=AG15,$W$14,IF($AF$15=AG15,$W$15,IF($AF$16=AG15,$W$16)))))","v":""}]
["B2",null,"A",1,9,"12:20:00",1,{"$f":"'TAB PRINC'!C12","v":"A / 1"},{"$f":"'TAB PRINC'!C13","v":"H / 8"},0,0,{"$f":"'TAB PRINC'!K14","v":0},{"$f":"'TAB PRINC'!L14","v":0},{"$f":"'TAB PRINC'!M14","v":0},{"$f":"'TAB PRINC'!N14","v":0},{"$f":"'TAB PRINC'!O14","v":0},{"$f":"'TAB PRINC'!P14","v":0},"",""]
["B3",null,"B",1,10,"12:20:00",2,{"$f":"'TAB PRINC'!C16","v":"B / 2"},{"$f":"'TAB PRINC'!C17","v":"G / 7"},0,0,{"$f":"'TAB PRINC'!K18","v":0},{"$f":"'TAB PRINC'!L18","v":0},{"$f":"'TAB PRINC'!M18","v":0},{"$f":"'TAB PRINC'!N18","v":0},{"$f":"'TAB PRINC'!O18","v":0},{"$f":"'TAB PRINC'!P18","v":0},"",""]
[null,null,"C",1,11,"13:10:00",1,{"$f":"'TAB PRINC'!C20","v":"C / 3"},{"$f":"'TAB PRINC'!C21","v":"F / 6"},0,0,{"$f":"'TAB PRINC'!K22","v":0},{"$f":"'TAB PRINC'!L22","v":0},{"$f":"'TAB PRINC'!M22","v":0},{"$f":"'TAB PRINC'!N22","v":0},{"$f":"'TAB PRINC'!O22","v":0},{"$f":"'TAB PRINC'!P22","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C20","v":"C / 3"},{"$f":"COUNTIF(PLCE1,W18)*2+COUNTIF(PLCE2,W18)","v":0},{"$f":"SUMIF(LISTEE1,W18,(SCEQ1))+SUMIF(LISTEE2,W18,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W18,SCEQ2)+SUMIF(LISTEE2,W18,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(Y18/Z18,0)","v":0},0,{"$f":"X18+AC18/100+AD18/100","v":0},{"$f":"RANK(AE18,$AE$18:$AE$22)","v":1},1,{"$f":"IF(X18=0,\"\",IF(AF$18=AG18,W18,IF(AF19=AG18,W19,IF(AF20=AG18,W20,IF(AF21=AG18,W21)))))","v":""}]
[null,null,"D",1,12,{"$f":"F17+$B$4","v":"13:10:00"},2,{"$f":"'TAB PRINC'!C24","v":"D / 4"},{"$f":"'TAB PRINC'!C25","v":"E / 5"},0,0,{"$f":"'TAB PRINC'!K26","v":0},{"$f":"'TAB PRINC'!L26","v":0},{"$f":"'TAB PRINC'!M26","v":0},{"$f":"'TAB PRINC'!N26","v":0},{"$f":"'TAB PRINC'!O26","v":0},{"$f":"'TAB PRINC'!P26","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C21","v":"F / 6"},{"$f":"COUNTIF(PLCE1,W19)*2+COUNTIF(PLCE2,W19)","v":0},{"$f":"SUMIF(LISTEE1,W19,(SCEQ1))+SUMIF(LISTEE2,W19,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W19,SCEQ2)+SUMIF(LISTEE2,W19,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,{"$f":"X19+AC19/100+AD19/100","v":0},{"$f":"RANK(AE19,$AE$18:$AE$22)","v":1},2,{"$f":"IF(X19=0,\"\",IF(AF$18=AG19,W18,IF(AF19=AG19,W19,IF(AF20=AG19,W20,IF(AF21=AG19,W21)))))","v":""}]
["POULE C",null,"BARR",1,13,{"$f":"F18+$B$4","v":"14:00:00"},1,{"$f":"'TAB PRINC'!X11","v":""},{"$f":"'TAB PRINC'!X14","v":""},{"$f":"IF(L20=0,\"\",SUM(IF(L20>M20,1,0),IF(N20>O20,1,0),IF(P20>Q20,1,0)))","v":""},{"$f":"IF(M20=0,\"\",SUM(IF(M20>L20,1,0),IF(O20>N20,1,0),IF(Q20>P20,1,0)))","v":""},{"$f":"'TAB PRINC'!Z12","v":0},{"$f":"'TAB PRINC'!Z13","v":0},{"$f":"'TAB PRINC'!AA12","v":0},{"$f":"'TAB PRINC'!AA13","v":0},{"$f":"'TAB PRINC'!AB12","v":0},{"$f":"'TAB PRINC'!AB13","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C22","v":"K / 11"},{"$f":"COUNTIF(PLCE1,W20)*2+COUNTIF(PLCE2,W20)","v":0},{"$f":"SUMIF(LISTEE1,W20,(SCEQ1))+SUMIF(LISTEE2,W20,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W20,SCEQ2)+SUMIF(LISTEE2,W20,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE20,$AE$18:$AE$22)","v":1},3,{"$f":"IF(X20=0,\"\",IF(AF$18=AG20,W18,IF(AF19=AG20,W19,IF(AF20=AG20,W20,IF(AF21=AG20,W21)))))","v":""}]
["C1",null,"BARR",1,14,{"$f":"F19+$B$4","v":"14:00:00"},2,{"$f":"'TAB PRINC'!X15","v":""},{"$f":"'TAB PRINC'!X18","v":""},{"$f":"IF(L21=0,\"\",SUM(IF(L21>M21,1,0),IF(N21>O21,1,0),IF(P21>Q21,1,0)))","v":""},{"$f":"IF(M21=0,\"\",SUM(IF(M21>L21,1,0),IF(O21>N21,1,0),IF(Q21>P21,1,0)))","v":""},{"$f":"'TAB PRINC'!Z16","v":0},{"$f":"'TAB PRINC'!Z17","v":0},{"$f":"'TAB PRINC'!AA16","v":0},{"$f":"'TAB PRINC'!AA17","v":0},{"$f":"'TAB PRINC'!AB16","v":0},{"$f":"'TAB PRINC'!AB17","v":0},"",""]
["C2",null,"BARR",1,15,{"$f":"F20+$B$4","v":"14:50:00"},1,{"$f":"'TAB PRINC'!X21","v":""},{"$f":"'TAB PRINC'!X24","v":""},"","",{"$f":"'TAB PRINC'!Z22","v":0},{"$f":"'TAB PRINC'!Z23","v":0},{"$f":"'TAB PRINC'!AA22","v":0},{"$f":"'TAB PRINC'!AA23","v":0},{"$f":"'TAB PRINC'!AB22","v":0},{"$f":"'TAB PRINC'!AB23","v":0},"",""]
["C3",null,"BARR",1,16,{"$f":"F21+$B$4","v":"14:50:00"},2,{"$f":"'TAB PRINC'!X25","v":""},{"$f":"'TAB PRINC'!X28","v":""},"","",{"$f":"'TAB PRINC'!Z26","v":0},{"$f":"'TAB PRINC'!Z27","v":0},{"$f":"'TAB PRINC'!AA26","v":0},{"$f":"'TAB PRINC'!AA27","v":0},{"$f":"'TAB PRINC'!AB26","v":0},{"$f":"'TAB PRINC'!AB27","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C24","v":"D / 4"},{"$f":"COUNTIF(PLCE1,W23)*2+COUNTIF(PLCE2,W23)","v":0},{"$f":"SUMIF(LISTEE1,W23,(SCEQ1))+SUMIF(LISTEE2,W23,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W23,SCEQ2)+SUMIF(LISTEE2,W23,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE23,$AE$23:$AE$27)","v":1},1,{"$f":"IF(X23=0,\"\",IF($AF$23=AG23,$W$23,IF($AF$24=AG23,$W$24,IF($AF$25=AG23,$W$25,IF($AF$26=AG23,$W$26)))))","v":""}]
[null,null,"1/4",1,17,{"$f":"B5","v":"14:00:00"},1,{"$f":"AH8","v":""},{"$f":"R20","v":""},{"$f":"SUM(IF(L24>M24,1,0),IF(N24>O24,1,0),IF(P24>Q24,1,0))","v":0},{"$f":"SUM(IF(M24>L24,1,0),IF(O24>N24,1,0),IF(Q24>P24,1,0))","v":0},{"$f":"'TAB PRINC'!E32","v":0},{"$f":"'TAB PRINC'!E33","v":0},{"$f":"'TAB PRINC'!F32","v":0},{"$f":"'TAB PRINC'!F33","v":0},{"$f":"'TAB PRINC'!G32","v":0},{"$f":"'TAB PRINC'!G33","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C25","v":"E / 5"},{"$f":"COUNTIF(PLCE1,W24)*2+COUNTIF(PLCE2,W24)","v":0},{"$f":"SUMIF(LISTEE1,W24,(SCEQ1))+SUMIF(LISTEE2,W24,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W24,SCEQ2)+SUMIF(LISTEE2,W24,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AE24,$AE$23:$AE$27)","v":1},2,{"$f":"IF(X24=0,\"\",IF($AF$23=AG24,$W$23,IF($AF$24=AG24,$W$24,IF($AF$25=AG24,$W$25,IF($AF$26=AG24,$W$26)))))","v":""}]
[null,null,"1/4",1,18,{"$f":"B5","v":"14:00:00"},2,{"$f":"AH23","v":""},{"$f":"R21","v":""},0,0,{"$f":"'TAB PRINC'!E39","v":0},{"$f":"'TAB PRINC'!E38","v":0},{"$f":"'TAB PRINC'!F39","v":0},{"$f":"'TAB PRINC'!F38","v":0},{"$f":"'TAB PRINC'!G39","v":0},{"$f":"'TAB PRINC'!G38","v":0},"","",null,null,null,{"$f":"'TAB PRINC'!C26","v":"L / 12"},{"$f":"COUNTIF(PLCE1,W25)*2+COUNTIF(PLCE2,W25)","v":0},{"$f":"SUMIF(LISTEE1,W25,(SCEQ1))+SUMIF(LISTEE2,W25,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,W25,SCEQ2)+SUMIF(LISTEE2,W25,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=W25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=W25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=W25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=W25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,1,3,{"$f":"IF(X25=0,\"\",IF($AF$23=AG25,$W$23,IF($AF$24=AG25,$W$24,IF($AF$25=AG25,$W$25,IF($AF$26=AG25,$W$26)))))","v":""}]
["POULE D",null,"1/4",1,19,{"$f":"F25+$B$4","v":"14:50:00"},1,{"$f":"AH13","v":""},{"$f":"R23","v":""},0,0,{"$f":"'TAB PRINC'!E51","v":0},{"$f":"'TAB PRINC'!E50","v":0},{"$f":"'TAB PRINC'!F51","v":0},{"$f":"'TAB PRINC'!F50","v":0},{"$f":"'TAB PRINC'!G51","v":0},{"$f":"'TAB PRINC'!G50","v":0},"",""]
["D1",null,"1/4",1,20,{"$f":"F25+$B$4","v":"14:50:00"},2,{"$f":"AH18","v":""},{"$f":"R22","v":""},0,0,{"$f":"'TAB PRINC'!E44","v":0},{"$f":"'TAB PRINC'!E45","v":0},{"$f":"'TAB PRINC'!F44","v":0},{"$f":"'TAB PRINC'!F45","v":0},{"$f":"'TAB PRINC'!G44","v":0},{"$f":"'TAB PRINC'!G45","v":0},"",""]
["D2",null,"1/2",1,21,{"$f":"F27+$B$4","v":"15:40:00"},1,{"$f":"R24","v":""},{"$f":"R25","v":""},0,0,{"$f":"'TAB PRINC'!U36","v":0},{"$f":"'TAB PRINC'!U37","v":0},{"$f":"'TAB PRINC'!V36","v":0},{"$f":"'TAB PRINC'!V37","v":0},{"$f":"'TAB PRINC'!W36","v":0},{"$f":"'TAB PRINC'!W37","v":0},"",""]
["D3",null,"1/2",1,22,{"$f":"F28+$B$4","v":"16:30:00"},1,{"$f":"R26","v":""},{"$f":"R27","v":""},0,0,{"$f":"'TAB PRINC'!U50","v":0},{"$f":"'TAB PRINC'!U49","v":0},{"$f":"'TAB PRINC'!V50","v":0},{"$f":"'TAB PRINC'!V49","v":0},{"$f":"'TAB PRINC'!W50","v":0},{"$f":"'TAB PRINC'!W49","v":0},"",""]
[null,null,"PF",1,23,"17:20:00",1,{"$f":"S28","v":""},{"$f":"S29","v":""},0,0,{"$f":"'TAB PRINC'!Z59","v":0},{"$f":"'TAB PRINC'!Z60","v":0},{"$f":"'TAB PRINC'!AA59","v":0},{"$f":"'TAB PRINC'!AA60","v":0},{"$f":"'TAB PRINC'!AB59","v":0},{"$f":"'TAB PRINC'!AB60","v":0},"",""]
[null,null,"FF",1,24,"18:10:00",1,{"$f":"R28","v":""},{"$f":"R29","v":""},0,0,{"$f":"'TAB PRINC'!Z42","v":0},{"$f":"'TAB PRINC'!Z43","v":0},{"$f":"'TAB PRINC'!AA42","v":0},{"$f":"'TAB PRINC'!AA43","v":0},{"$f":"'TAB PRINC'!AB42","v":0},{"$f":"'TAB PRINC'!AB43","v":0},"",""]

{"sheet":"RELEVE","index":8,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[[19,2,19,3],[19,4,19,6],[77,2,83,10],[86,2,92,10],[6,2,6,3],[6,4,6,5],[16,2,16,3],[16,4,16,6],[17,2,17,3],[17,4,17,6],[18,2,18,3],[18,4,18,6],[15,2,15,3],[15,4,15,6],[5,2,5,3],[5,4,5,5],[8,8,8,9],[9,8,9,9],[14,4,14,6],[2,2,2,3],[2,4,2,10],[3,2,3,3],[3,4,3,5],[4,2,4,3],[4,4,4,5]]}
[null,null,"RELEVE DES RESULTATS ET SANCTIONS - TOURNOI DE BEACH VOLLEY"]
[]
[null,null,"APPELATION DU TOURNOI",null,{"$f":"IF('LISTE ENGAGES'!R4=\"\",\"\",'LISTE ENGAGES'!R4)","v":""}]
[null,null,"TYPE",null,{"$f":"IF('LISTE ENGAGES'!R6=\"\",\"\",'LISTE ENGAGES'!R6)","v":""}]
[null,null,"GENRE",null,{"$f":"IF('LISTE ENGAGES'!R10=\"\",\"\",'LISTE ENGAGES'!R10)","v":""}]
[null,null,"DATE",null,{"$f":"IF('LISTE ENGAGES'!R8=\"\",\"\",CONCATENATE('LISTE ENGAGES'!R8,\"-\",'LISTE ENGAGES'!R9,\"/\",'LISTE ENGAGES'!R7))","v":""}]
[null,null,"ORGANISATEUR",null,{"$f":"IF('LISTE ENGAGES'!R11=\"\",\"\",'LISTE ENGAGES'!R11)","v":""}]
[]
[null,null,"NOMBRE EQUIPE TABLEAU :",null,null,"PRINCIPAL",null,null,"QUALIFICATION"]
[null,null,"NOMBRE EQUIPE PRESENTES PAR TABLEAU",null,null,"PRINCIPAL",null,null,"QUALIFICATION"]
[]
[]
[null,null,"COMPOSITION DE LA COMMISSION DE DIRECTION"]
[]
[null,null,"DELEGUE INSTANCE FEDERAL"]
[null,null,"SUPERVISEUR"]
[null,null,"JUGE ARBITRE"]
[null,null,"ORGANISATEUR"]
[null,null,"REPRESENTANT JOUEURS"]
[null,null,"RAPPORTEUR*"]
[]
[]
[]
[]
[]
[null,null,"EQUIPES ABSENTES"]
[null,null,"NOM","PRENOM","LIC J1","club J1","NOM2","PRENOM3","LIC J2","club J2"]
[]
[]
[]
[]
[]
[]
[null,null,"RECLAMATIONS"]
[null,null,"NOM","PRENOM","LIC J1","club J1","NOM2","PRENOM3","LIC J2","club J2","RANG","NIVEAU","MOTIF ","AVIS COMMISSION"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
[null,null,"EQUIPES/JOUEURS SANCTIONNES"]
[null,null,"NOM","PRENOM","LIC J1","club J1","NOM2","PRENOM3","LIC J2","club J2","RANG","SANCTION","MOTIF ","AVIS COMMISSION"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
[null,null,"CLASSEMENT FINAL"]
[null,null,"NOM","PRENOM","LIC J1","club J1","NOM2","PRENOM3","LIC J2","club J2","RANG"]
[null,null,{"$f":"'LISTE ENGAGES'!C10","v":0},{"$f":"'LISTE ENGAGES'!D10","v":0},{"$f":"'LISTE ENGAGES'!E10","v":0},{"$f":"'LISTE ENGAGES'!F10","v":0},{"$f":"'LISTE ENGAGES'!G10","v":0},{"$f":"'LISTE ENGAGES'!H10","v":0},{"$f":"'LISTE ENGAGES'!I10","v":0},{"$f":"'LISTE ENGAGES'!J10","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C11","v":0},{"$f":"'LISTE ENGAGES'!D11","v":0},{"$f":"'LISTE ENGAGES'!E11","v":0},{"$f":"'LISTE ENGAGES'!F11","v":0},{"$f":"'LISTE ENGAGES'!G11","v":0},{"$f":"'LISTE ENGAGES'!H11","v":0},{"$f":"'LISTE ENGAGES'!I11","v":0},{"$f":"'LISTE ENGAGES'!J11","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C12","v":0},{"$f":"'LISTE ENGAGES'!D12","v":0},{"$f":"'LISTE ENGAGES'!E12","v":0},{"$f":"'LISTE ENGAGES'!F12","v":0},{"$f":"'LISTE ENGAGES'!G12","v":0},{"$f":"'LISTE ENGAGES'!H12","v":0},{"$f":"'LISTE ENGAGES'!I12","v":0},{"$f":"'LISTE ENGAGES'!J12","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C13","v":0},{"$f":"'LISTE ENGAGES'!D13","v":0},{"$f":"'LISTE ENGAGES'!E13","v":0},{"$f":"'LISTE ENGAGES'!F13","v":0},{"$f":"'LISTE ENGAGES'!G13","v":0},{"$f":"'LISTE ENGAGES'!H13","v":0},{"$f":"'LISTE ENGAGES'!I13","v":0},{"$f":"'LISTE ENGAGES'!J13","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C14","v":0},{"$f":"'LISTE ENGAGES'!D14","v":0},{"$f":"'LISTE ENGAGES'!E14","v":0},{"$f":"'LISTE ENGAGES'!F14","v":0},{"$f":"'LISTE ENGAGES'!G14","v":0},{"$f":"'LISTE ENGAGES'!H14","v":0},{"$f":"'LISTE ENGAGES'!I14","v":0},{"$f":"'LISTE ENGAGES'!J14","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C15","v":0},{"$f":"'LISTE ENGAGES'!D15","v":0},{"$f":"'LISTE ENGAGES'!E15","v":0},{"$f":"'LISTE ENGAGES'!F15","v":0},{"$f":"'LISTE ENGAGES'!G15","v":0},{"$f":"'LISTE ENGAGES'!H15","v":0},{"$f":"'LISTE ENGAGES'!I15","v":0},{"$f":"'LISTE ENGAGES'!J15","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C16","v":0},{"$f":"'LISTE ENGAGES'!D16","v":0},{"$f":"'LISTE ENGAGES'!E16","v":0},{"$f":"'LISTE ENGAGES'!F16","v":0},{"$f":"'LISTE ENGAGES'!G16","v":0},{"$f":"'LISTE ENGAGES'!H16","v":0},{"$f":"'LISTE ENGAGES'!I16","v":0},{"$f":"'LISTE ENGAGES'!J16","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C17","v":0},{"$f":"'LISTE ENGAGES'!D17","v":0},{"$f":"'LISTE ENGAGES'!E17","v":0},{"$f":"'LISTE ENGAGES'!F17","v":0},{"$f":"'LISTE ENGAGES'!G17","v":0},{"$f":"'LISTE ENGAGES'!H17","v":0},{"$f":"'LISTE ENGAGES'!I17","v":0},{"$f":"'LISTE ENGAGES'!J17","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C18","v":0},{"$f":"'LISTE ENGAGES'!D18","v":0},{"$f":"'LISTE ENGAGES'!E18","v":0},{"$f":"'LISTE ENGAGES'!F18","v":0},{"$f":"'LISTE ENGAGES'!G18","v":0},{"$f":"'LISTE ENGAGES'!H18","v":0},{"$f":"'LISTE ENGAGES'!I18","v":0},{"$f":"'LISTE ENGAGES'!J18","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C19","v":0},{"$f":"'LISTE ENGAGES'!D19","v":0},{"$f":"'LISTE ENGAGES'!E19","v":0},{"$f":"'LISTE ENGAGES'!F19","v":0},{"$f":"'LISTE ENGAGES'!G19","v":0},{"$f":"'LISTE ENGAGES'!H19","v":0},{"$f":"'LISTE ENGAGES'!I19","v":0},{"$f":"'LISTE ENGAGES'!J19","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C20","v":0},{"$f":"'LISTE ENGAGES'!D20","v":0},{"$f":"'LISTE ENGAGES'!E20","v":0},{"$f":"'LISTE ENGAGES'!F20","v":0},{"$f":"'LISTE ENGAGES'!G20","v":0},{"$f":"'LISTE ENGAGES'!H20","v":0},{"$f":"'LISTE ENGAGES'!I20","v":0},{"$f":"'LISTE ENGAGES'!J20","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C21","v":0},{"$f":"'LISTE ENGAGES'!D21","v":0},{"$f":"'LISTE ENGAGES'!E21","v":0},{"$f":"'LISTE ENGAGES'!F21","v":0},{"$f":"'LISTE ENGAGES'!G21","v":0},{"$f":"'LISTE ENGAGES'!H21","v":0},{"$f":"'LISTE ENGAGES'!I21","v":0},{"$f":"'LISTE ENGAGES'!J21","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C22","v":0},{"$f":"'LISTE ENGAGES'!D22","v":0},{"$f":"'LISTE ENGAGES'!E22","v":0},{"$f":"'LISTE ENGAGES'!F22","v":0},{"$f":"'LISTE ENGAGES'!G22","v":0},{"$f":"'LISTE ENGAGES'!H22","v":0},{"$f":"'LISTE ENGAGES'!I22","v":0},{"$f":"'LISTE ENGAGES'!J22","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C23","v":0},{"$f":"'LISTE ENGAGES'!D23","v":0},{"$f":"'LISTE ENGAGES'!E23","v":0},{"$f":"'LISTE ENGAGES'!F23","v":0},{"$f":"'LISTE ENGAGES'!G23","v":0},{"$f":"'LISTE ENGAGES'!H23","v":0},{"$f":"'LISTE ENGAGES'!I23","v":0},{"$f":"'LISTE ENGAGES'!J23","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C24","v":0},{"$f":"'LISTE ENGAGES'!D24","v":0},{"$f":"'LISTE ENGAGES'!E24","v":0},{"$f":"'LISTE ENGAGES'!F24","v":0},{"$f":"'LISTE ENGAGES'!G24","v":0},{"$f":"'LISTE ENGAGES'!H24","v":0},{"$f":"'LISTE ENGAGES'!I24","v":0},{"$f":"'LISTE ENGAGES'!J24","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C25","v":0},{"$f":"'LISTE ENGAGES'!D25","v":0},{"$f":"'LISTE ENGAGES'!E25","v":0},{"$f":"'LISTE ENGAGES'!F25","v":0},{"$f":"'LISTE ENGAGES'!G25","v":0},{"$f":"'LISTE ENGAGES'!H25","v":0},{"$f":"'LISTE ENGAGES'!I25","v":0},{"$f":"'LISTE ENGAGES'!J25","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C26","v":0},{"$f":"'LISTE ENGAGES'!D26","v":0},{"$f":"'LISTE ENGAGES'!E26","v":0},{"$f":"'LISTE ENGAGES'!F26","v":0},{"$f":"'LISTE ENGAGES'!G26","v":0},{"$f":"'LISTE ENGAGES'!H26","v":0},{"$f":"'LISTE ENGAGES'!I26","v":0},{"$f":"'LISTE ENGAGES'!J26","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C27","v":0},{"$f":"'LISTE ENGAGES'!D27","v":0},{"$f":"'LISTE ENGAGES'!E27","v":0},{"$f":"'LISTE ENGAGES'!F27","v":0},{"$f":"'LISTE ENGAGES'!G27","v":0},{"$f":"'LISTE ENGAGES'!H27","v":0},{"$f":"'LISTE ENGAGES'!I27","v":0},{"$f":"'LISTE ENGAGES'!J27","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C28","v":0},{"$f":"'LISTE ENGAGES'!D28","v":0},{"$f":"'LISTE ENGAGES'!E28","v":0},{"$f":"'LISTE ENGAGES'!F28","v":0},{"$f":"'LISTE ENGAGES'!G28","v":0},{"$f":"'LISTE ENGAGES'!H28","v":0},{"$f":"'LISTE ENGAGES'!I28","v":0},{"$f":"'LISTE ENGAGES'!J28","v":0}]
[null,null,{"$f":"'LISTE ENGAGES'!C29","v":0},{"$f":"'LISTE ENGAGES'!D29","v":0},{"$f":"'LISTE ENGAGES'!E29","v":0},{"$f":"'LISTE ENGAGES'!F29","v":0},{"$f":"'LISTE ENGAGES'!G29","v":0},{"$f":"'LISTE ENGAGES'!H29","v":0},{"$f":"'LISTE ENGAGES'!I29","v":0},{"$f":"'LISTE ENGAGES'!J29","v":0}]
[]
[]
[]
[]
[null,null,"REMARQUES :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SIGNATURES :"]