{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["LISTE","LISTE ENGAGES","EMARG Tableau Qualif","TAB Qualif Poule 12 ","SCORE QUAL","PLANNING ","EMARG Tableau PRINCIPAL","TAB P Poule 12 ","SCORE PRINC","RELEVE"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":42,"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","index":0,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CHAMMPIONNAT DE France",null,null,2020,null,"MASCULIN",null,"ABS"]
[null,null,"SERIE 1 - 2500",null,null,2021,null,"FEMININ",null,1]
[null,null,"SERIE 1 - 2000",null,null,2022,null,"MIXTE",null,2]
[null,null,"SERIE 1 - 1500",null,null,2023,null,null,null,3]
[null,null,"SERIE 2 - 1000",null,null,2024,null,null,null,4]
[null,null,"SERIE 2 - 750",null,null,null,null,null,null,5]
[null,null,"SERIE 2 - 500",null,null,null,null,null,null,6]
[null,null,"SERIE 2 - 250",null,null,null,null,null,null,7]
[null,null,"SERIE 3 - 150",null,null,null,null,null,null,8]
[null,null,"SERIE 3 - 100",null,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]
[null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,32]

{"sheet":"LISTE ENGAGES","index":1,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[13,18,13,22],[0,4,2,8],[0,9,2,9],[4,4,4,9],[5,4,5,9],[12,18,12,22],[3,4,3,6],[3,7,3,8]]}
[null,null,null,null,{"$f":"IF($V$4=\"\",$U$4,$V$4)","v":"APPELATION TOURNOI"},null,null,null,null,{"$f":"IF($V$11=\"\",$U$11,$V$11)","v":"ORGANISATEUR"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDENTITE DU TOURNOI"]
[null,null,null,null,{"$f":"IF($V$5=\"\",$U$5,$V$5)","v":"LIEU"},null,null,{"$f":"IF('LISTE ENGAGES'!V8=\"\",\"DATE\",CONCATENATE('LISTE ENGAGES'!V8,\"-\",'LISTE ENGAGES'!V9,\"/\",'LISTE ENGAGES'!V7))","v":"DATE"},null,{"$f":"IF($V$10=\"\",$U$10,$V$10)","v":"GENRE"},null,null,null,null,null,null,null,null,null,null,"APPELATION TOURNOI"]
[null,null,null,null,{"$f":"IF($V$6=\"\",$U$6,$V$6)","v":"TYPE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIEU"]
[null,null,null,null,"LISTE EQUIPES ENGAGEES",null,null,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,null,null,null,null,"ANNEE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE DEBUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE FIN"]
[null,"N°",null,"NOM","PRENOM","LIC J1","club J1","NOM2","PRENOM3","LIC J2","club J2","pts TEQ EQ","tir",null,null,null,null,null,null,null,"GENRE"]
[null,1,null,"T",null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,"ORGANISATEUR"]
[null,2,null,"T",null,null,null,2]
[null,3,null,"T",null,null,null,3,null,null,null,null,null,null,null,null,null,null,"1- Commencez par renseigner le tableau ci-dessus \"identité du tournoi\""]
[null,4,null,"T",null,null,null,4,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 : "]
[null,5,null,"T",null,null,null,5,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)"]
[null,6,null,"T",null,null,null,6,null,null,null,null,null,null,null,null,null,null,"- l'ordre décroissant des têtes de séries"]
[null,7,null,"T",null,null,null,7,null,null,null,null,null,null,null,null,null,null,"3- Renseignez l'onglet \"EMARG….\" selon l'avancée dans les tableaux"]
[null,8,null,"T",null,null,null,8,null,null,null,null,null,null,null,null,null,null,"4-Renseignez les scores des rencontres dans l'onglet \" Résultats…\" en fonction de l'avancée du tableau"]
[null,9,null,"T",null,null,null,9,null,null,null,null,null,null,null,null,null,null,"Les onglets \"TAB…\" s'actualisent automatiquement, il n'y a rien à saisir."]
[null,10,null,"T",null,null,null,10,null,null,null,null,null,null,null,null,null,null,"5- Renseignez l'onglet \"RELEVE\" à l'issue de la compétition"]
[null,11,null,"T",null,null,null,11]
[null,12,null,"T",null,null,null,12]
[null,13,null,"T",null,null,null,13]
[null,14,null,"T",null,null,null,14]
[null,15,null,"T",null,null,null,15]
[null,16,null,"T",null,null,null,16]
[null,17,null,"T",null,null,null,17]
[null,18,null,"T",null,null,null,18]
[null,19,null,"T",null,null,null,19]
[null,20,null,"T",null,null,null,20]

{"sheet":"EMARG Tableau Qualif","index":2,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,4,5,10],[1,4,2,9],[1,10,3,10],[3,4,3,5],[3,6,3,8],[4,4,4,10]]}
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$1","v":"APPELATION TOURNOI"},null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$J$1","v":"ORGANISATEUR"}]
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$4","v":"LIEU"},null,{"$f":"'LISTE ENGAGES'!$H$4","v":"DATE"},null,null,{"$f":"'LISTE ENGAGES'!$J$4","v":"GENRE"}]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$5","v":"TYPE"}]
[null,null,null,null,"FEUILLE EMARGEMENT"]
[]
[]
[]
[null,"N°",null,"NOM","PRENOM","NOM","PRENOM","pts","tir","SIGNATURE JOUEUR1","SIGNATURE JOUEUR2"]
[null,1,null,"Q",null,1]
[null,2,null,"Q",null,2]
[null,3,null,"Q",null,3]
[null,4,null,"Q",null,4]
[null,5,null,"Q",null,5]
[null,6,null,"Q",null,6]
[null,7,null,"Q",null,7]
[null,8,null,"Q",null,8]
[null,9,null,"Q",null,9]
[null,10,null,"Q",null,10]
[null,11,null,"Q",null,11]
[null,12,null,"Q",null,12]
[]
[null,null,null,"Copier/coller selon LISTE ENGAGES en fonction des équipes confirmées, les colonnes NOM et PRENOM des Joueurs 1 et 2 de chauque équipe."]
[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 Qualif Poule 12 ","index":3,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,4,4,9],[1,11,6,13],[5,3,5,10],[6,3,6,10],[1,3,3,10]]}
[]
[null,null,null,{"$f":"'LISTE ENGAGES'!$E$1","v":"APPELATION TOURNOI"},null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$J$1","v":"ORGANISATEUR"}]
[]
[]
[null,null,null,{"$f":"'LISTE ENGAGES'!$E$4","v":"LIEU"},{"$f":"'LISTE ENGAGES'!$H$4","v":"DATE"},null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$J$4","v":"GENRE"}]
[null,null,null,{"$f":"'LISTE ENGAGES'!$E$5","v":"TYPE"}]
[null,null,null,"TABLEAU PRINCIPAL"]
[]
[]
[null,null,null,"POULES ","ORDRE","TER,","N°",null,null,null,"CLASSEMENT",null,null,"RANG"]
[null,null,null,null,null,null,null,null,null,null,"POULE"]
[null,null,"TS1",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D11,\"/\",'EMARG Tableau Qualif'!F11)","v":"Q/1"},{"$f":"CONCATENATE(C12,\" / \",C14)","v":"TS1 / TS9"},null,"(1)",{"$f":"IF('SCORE QUAL'!K8='SCORE QUAL'!M8,\"\",CONCATENATE('SCORE QUAL'!K8,\" : \",'SCORE QUAL'!M8,\" \",\"(\",'SCORE QUAL'!N8,\" - \",'SCORE QUAL'!O8,\")\",\"(\",'SCORE QUAL'!P8,\" - \",'SCORE QUAL'!Q8,\")\",\"(\",'SCORE QUAL'!R8,\" - \",'SCORE QUAL'!S8,\")\"))","v":""},null,1,{"$f":"'SCORE QUAL'!AJ8","v":""},null,null,"Qualifié"]
[null,"A","TS8",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D18,\"/\",'EMARG Tableau Qualif'!F18)","v":"Q/8"},{"$f":"CONCATENATE(C13,\" / \",C14)","v":"TS8 / TS9"},null,"(5)",{"$f":"IF('SCORE QUAL'!K12='SCORE QUAL'!M12,\"\",CONCATENATE('SCORE QUAL'!K12,\" : \",'SCORE QUAL'!M12,\" \",\"(\",'SCORE QUAL'!N12,\" - \",'SCORE QUAL'!O12,\")\",\"(\",'SCORE QUAL'!P12,\" - \",'SCORE QUAL'!Q12,\")\",\"(\",'SCORE QUAL'!R12,\" - \",'SCORE QUAL'!S12,\")\"))","v":""},null,2,{"$f":"'SCORE QUAL'!AJ9","v":""},null,null,13]
[null,null,"TS9",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D19,\"/\",'EMARG Tableau Qualif'!F19)","v":"Q/9"},{"$f":"CONCATENATE(C12,\" / \",C13)","v":"TS1 / TS8"},null,"(9)",{"$f":"IF('SCORE QUAL'!K16='SCORE QUAL'!M16,\"\",CONCATENATE('SCORE QUAL'!K16,\" : \",'SCORE QUAL'!M16,\" \",\"(\",'SCORE QUAL'!N16,\" - \",'SCORE QUAL'!O16,\")\",\"(\",'SCORE QUAL'!P16,\" - \",'SCORE QUAL'!Q16,\")\",\"(\",'SCORE QUAL'!R16,\" - \",'SCORE QUAL'!S16,\")\"))","v":""},null,3,{"$f":"'SCORE QUAL'!AJ10","v":""},null,null,17]
[]
[]
[null,null,"TS2",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D12,\"/\",'EMARG Tableau Qualif'!F12)","v":"Q/2"},{"$f":"CONCATENATE(C17,\" / \",C19)","v":"TS2 / TS10"},null,"(3)",{"$f":"IF('SCORE QUAL'!K9='SCORE QUAL'!M9,\"\",CONCATENATE('SCORE QUAL'!K9,\" : \",'SCORE QUAL'!M9,\" \",\"(\",'SCORE QUAL'!N9,\" - \",'SCORE QUAL'!O9,\")\",\"(\",'SCORE QUAL'!P9,\" - \",'SCORE QUAL'!Q9,\")\",\"(\",'SCORE QUAL'!R9,\" - \",'SCORE QUAL'!S9,\")\"))","v":""},null,1,{"$f":"'SCORE QUAL'!AJ13","v":""},null,null,"Qualifié"]
[null,"B","TS7",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D17,\"/\",'EMARG Tableau Qualif'!F17)","v":"Q/7"},{"$f":"CONCATENATE(C18,\" / \",C19)","v":"TS7 / TS10"},null,"(7)",{"$f":"IF('SCORE QUAL'!K13='SCORE QUAL'!M13,\"\",CONCATENATE('SCORE QUAL'!K13,\" : \",'SCORE QUAL'!M13,\" \",\"(\",'SCORE QUAL'!N13,\" - \",'SCORE QUAL'!O13,\")\",\"(\",'SCORE QUAL'!P13,\" - \",'SCORE QUAL'!Q13,\")\",\"(\",'SCORE QUAL'!R13,\" - \",'SCORE QUAL'!S13,\")\"))","v":""},null,2,{"$f":"'SCORE QUAL'!AJ14","v":""},null,null,13]
[null,null,"TS10",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D20,\"/\",'EMARG Tableau Qualif'!F20)","v":"Q/10"},{"$f":"CONCATENATE(C17,\" / \",C18)","v":"TS2 / TS7"},null,"(11)",{"$f":"IF('SCORE QUAL'!K17='SCORE QUAL'!M17,\"\",CONCATENATE('SCORE QUAL'!K17,\" : \",'SCORE QUAL'!M17,\" \",\"(\",'SCORE QUAL'!N17,\" - \",'SCORE QUAL'!O17,\")\",\"(\",'SCORE QUAL'!P17,\" - \",'SCORE QUAL'!Q17,\")\",\"(\",'SCORE QUAL'!R17,\" - \",'SCORE QUAL'!S17,\")\"))","v":""},null,3,{"$f":"'SCORE QUAL'!AJ15","v":""},null,null,17]
[]
[]
[null,null,"TS3",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D13,\"/\",'EMARG Tableau Qualif'!F13)","v":"Q/3"},{"$f":"CONCATENATE(C22,\" / \",C24)","v":"TS3 / TS11"},null,"(2)",{"$f":"IF('SCORE QUAL'!K10='SCORE QUAL'!M10,\"\",CONCATENATE('SCORE QUAL'!K10,\" : \",'SCORE QUAL'!M10,\" \",\"(\",'SCORE QUAL'!N10,\" - \",'SCORE QUAL'!O10,\")\",\"(\",'SCORE QUAL'!P10,\" - \",'SCORE QUAL'!Q10,\")\",\"(\",'SCORE QUAL'!R10,\" - \",'SCORE QUAL'!S10,\")\"))","v":""},null,1,{"$f":"'SCORE QUAL'!AJ18","v":""},null,null,"Qualifié"]
[null,"C","TS6",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D16,\"/\",'EMARG Tableau Qualif'!F16)","v":"Q/6"},{"$f":"CONCATENATE(C23,\" / \",C24)","v":"TS6 / TS11"},null,"(6)",{"$f":"IF('SCORE QUAL'!K14='SCORE QUAL'!M14,\"\",CONCATENATE('SCORE QUAL'!K14,\" : \",'SCORE QUAL'!M14,\" \",\"(\",'SCORE QUAL'!N14,\" - \",'SCORE QUAL'!O14,\")\",\"(\",'SCORE QUAL'!P14,\" - \",'SCORE QUAL'!Q14,\")\",\"(\",'SCORE QUAL'!R14,\" - \",'SCORE QUAL'!S14,\")\"))","v":""},null,2,{"$f":"'SCORE QUAL'!AJ19","v":""},null,null,13]
[null,null,"TS11",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D21,\"/\",'EMARG Tableau Qualif'!F21)","v":"Q/11"},{"$f":"CONCATENATE(C22,\" / \",C23)","v":"TS3 / TS6"},null,"(10)",{"$f":"IF('SCORE QUAL'!K18='SCORE QUAL'!M18,\"\",CONCATENATE('SCORE QUAL'!K18,\" : \",'SCORE QUAL'!M18,\" \",\"(\",'SCORE QUAL'!N18,\" - \",'SCORE QUAL'!O18,\")\",\"(\",'SCORE QUAL'!P18,\" - \",'SCORE QUAL'!Q18,\")\",\"(\",'SCORE QUAL'!R18,\" - \",'SCORE QUAL'!S18,\")\"))","v":""},null,3,{"$f":"'SCORE QUAL'!AJ20","v":""},null,null,17]
[]
[]
[null,null,"TS4",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D14,\"/\",'EMARG Tableau Qualif'!F14)","v":"Q/4"},{"$f":"CONCATENATE(C27,\" / \",C29)","v":"TS4 / TS12"},null,"(4)",{"$f":"IF('SCORE QUAL'!K11='SCORE QUAL'!M11,\"\",CONCATENATE('SCORE QUAL'!K11,\" : \",'SCORE QUAL'!M11,\" \",\"(\",'SCORE QUAL'!N11,\" - \",'SCORE QUAL'!O11,\")\",\"(\",'SCORE QUAL'!P11,\" - \",'SCORE QUAL'!Q11,\")\",\"(\",'SCORE QUAL'!R11,\" - \",'SCORE QUAL'!S11,\")\"))","v":""},null,1,{"$f":"'SCORE QUAL'!AJ23","v":""},null,null,"Qualifié"]
[null,"D","TS5",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D15,\"/\",'EMARG Tableau Qualif'!F15)","v":"Q/5"},{"$f":"CONCATENATE(C28,\" / \",C29)","v":"TS5 / TS12"},null,"(8)",{"$f":"IF('SCORE QUAL'!K15='SCORE QUAL'!M15,\"\",CONCATENATE('SCORE QUAL'!K15,\" : \",'SCORE QUAL'!M15,\" \",\"(\",'SCORE QUAL'!N15,\" - \",'SCORE QUAL'!O15,\")\",\"(\",'SCORE QUAL'!P15,\" - \",'SCORE QUAL'!Q15,\")\",\"(\",'SCORE QUAL'!R15,\" - \",'SCORE QUAL'!S15,\")\"))","v":""},null,2,{"$f":"'SCORE QUAL'!AJ24","v":""},null,null,13]
[null,null,"TS12",{"$f":"CONCATENATE('EMARG Tableau Qualif'!D22,\"/\",'EMARG Tableau Qualif'!F22)","v":"Q/12"},{"$f":"CONCATENATE(C27,\" / \",C28)","v":"TS4 / TS5"},null,"(12)",{"$f":"IF('SCORE QUAL'!K19='SCORE QUAL'!M19,\"\",CONCATENATE('SCORE QUAL'!K19,\" : \",'SCORE QUAL'!M19,\" \",\"(\",'SCORE QUAL'!N19,\" - \",'SCORE QUAL'!O19,\")\",\"(\",'SCORE QUAL'!P19,\" - \",'SCORE QUAL'!Q19,\")\",\"(\",'SCORE QUAL'!R19,\" - \",'SCORE QUAL'!S19,\")\"))","v":""},null,3,{"$f":"'SCORE QUAL'!AJ25","v":""},null,null,17]

{"sheet":"SCORE QUAL","index":4,"n_rows":40,"n_cols":36,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"TABLEAU DE SAISIE DE RESULTATS"]
[]
["DEBUT J1","09:00:00",null,"Saisir le résultats des setas dans les cases bordurées et colorées uniquement"]
["TEMPS","00:50:00"]
["DEBUT J2","14:00:00"]
[]
[null,null,"PHASE","JOUR","N° MATCH","HEURE","TER","EQ1",null,"EQ2","SCORE EQ1",null,"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,"A","PTS","S+","S-","P+","P-","CS","CP","CL.I","RG",null,"CLA"]
[null,null,"A",1,1,{"$f":"B3","v":"09:00:00"},1,{"$f":"'TAB Qualif Poule 12 '!D12","v":"Q/1"},"/",{"$f":"'TAB Qualif Poule 12 '!D14","v":"Q/9"},{"$f":"SUM(IF(N8>O8,1,0),IF(P8>Q8,1,0),IF(R8>S8,1,0))","v":0},"/",{"$f":"SUM(IF(O8>N8,1,0),IF(Q8>P8,1,0),IF(S8>R8,1,0))","v":0},null,null,null,null,null,null,{"$f":"IF(K8=M8,\"\",IF(K8>M8,H8,J8))","v":""},{"$f":"IF(K8=M8,\"\",IF(K8<M8,H8,J8))","v":""},null,null,null,{"$f":"'TAB Qualif Poule 12 '!D12","v":"Q/1"},{"$f":"COUNTIF(PLCEQ1,Y8)*2+COUNTIF(PLACEQ2,Y8)","v":0},{"$f":"SUMIF(LISTEE1,Y8,(SCEQ1))+SUMIF(LISTEE2,Y8,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y8,(SCEQ2))+SUMIF(LISTEE2,Y8,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(AA8/AB8,0)","v":0},{"$f":"IFERROR(AC8/AD8,0)","v":0},{"$f":"Z8+AE8/100+AF8/100","v":0},{"$f":"IF(Z8=0,\"\",RANK(AG8,$AG$8:$AG$10))","v":""},1,{"$f":"IF(Z8=0,\"\",IF($AH$8=AI8,$Y$8,IF($AH$9=AI8,$Y$9,IF($AH$10=AI8,$Y$10,IF($AH$11=AI8,$Y$11)))))","v":""}]
[null,null,"B",1,2,{"$f":"B3","v":"09:00:00"},2,{"$f":"'TAB Qualif Poule 12 '!D17","v":"Q/2"},"/",{"$f":"'TAB Qualif Poule 12 '!D19","v":"Q/10"},{"$f":"SUM(IF(N9>O9,1,0),IF(P9>Q9,1,0),IF(R9>S9,1,0))","v":0},"/",{"$f":"SUM(IF(O9>N9,1,0),IF(Q9>P9,1,0),IF(S9>R9,1,0))","v":0},null,null,null,null,null,null,{"$f":"IF(K9=M9,\"\",IF(K9>M9,H9,J9))","v":""},{"$f":"IF(K9=M9,\"\",IF(K9<M9,H9,J9))","v":""},null,null,null,{"$f":"'TAB Qualif Poule 12 '!D13","v":"Q/8"},{"$f":"COUNTIF(PLCEQ1,Y9)*2+COUNTIF(PLACEQ2,Y9)","v":0},{"$f":"SUMIF(LISTEE1,Y9,(SCEQ1))+SUMIF(LISTEE2,Y9,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y9,(SCEQ2))+SUMIF(LISTEE2,Y9,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(AA9/AB9,0)","v":0},{"$f":"IFERROR(AC9/AD9,0)","v":0},{"$f":"Z9+AE9/100+AF9/100","v":0},{"$f":"IF(Z9=0,\"\",RANK(AG9,$AG$8:$AG$10))","v":""},2,{"$f":"IF(Z9=0,\"\",IF($AH$8=AI9,$Y$8,IF($AH$9=AI9,$Y$9,IF($AH$10=AI9,$Y$10,IF($AH$11=AI9,$Y$11)))))","v":""}]
[null,null,"C",1,3,{"$f":"F8+$B$4","v":"09:50:00"},1,{"$f":"'TAB Qualif Poule 12 '!D22","v":"Q/3"},"/",{"$f":"'TAB Qualif Poule 12 '!D24","v":"Q/11"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D14","v":"Q/9"},{"$f":"COUNTIF(PLCEQ1,Y10)*2+COUNTIF(PLACEQ2,Y10)","v":0},{"$f":"SUMIF(LISTEE1,Y10,(SCEQ1))+SUMIF(LISTEE2,Y10,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y10,SCEQ2)+SUMIF(LISTEE2,Y10,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"IF(Z10=0,\"\",RANK(AG10,$AG$8:$AG$10))","v":""},3,{"$f":"IF(Z10=0,\"\",IF($AH$8=AI10,$Y$8,IF($AH$9=AI10,$Y$9,IF($AH$10=AI10,$Y$10,IF($AH$11=AI10,$Y$11)))))","v":""}]
[null,null,"D",1,4,{"$f":"F9+$B$4","v":"09:50:00"},2,{"$f":"'TAB Qualif Poule 12 '!D27","v":"Q/4"},"/",{"$f":"'TAB Qualif Poule 12 '!D29","v":"Q/12"},0,"/",0,null,null,null,null,null,null,"",{"$f":"IF(K11=M11,\"\",IF(K11<M11,H11,J11))","v":""}]
[null,null,"A",1,5,"10:40:00",1,{"$f":"'TAB Qualif Poule 12 '!D13","v":"Q/8"},"/",{"$f":"'TAB Qualif Poule 12 '!D14","v":"Q/9"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"B"]
[null,null,"B",1,6,"10:40:00",2,{"$f":"'TAB Qualif Poule 12 '!D18","v":"Q/7"},"/",{"$f":"'TAB Qualif Poule 12 '!D19","v":"Q/10"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D17","v":"Q/2"},{"$f":"COUNTIF(PLCEQ1,Y13)*2+COUNTIF(PLACEQ2,Y13)","v":0},{"$f":"SUMIF(LISTEE1,Y13,(SCEQ1))+SUMIF(LISTEE2,Y13,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y13,SCEQ2)+SUMIF(LISTEE2,Y13,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG13,$AG$13:$AG$17)","v":1},1,{"$f":"IF(Z13=0,\"\",IF($AH$13=AI13,$Y$13,IF($AH$14=AI13,$Y$14,IF($AH$15=AI13,$Y$15,IF($AH$16=AI13,$Y$16)))))","v":""}]
[null,null,"C",1,7,"11:30:00",1,{"$f":"'TAB Qualif Poule 12 '!D23","v":"Q/6"},"/",{"$f":"'TAB Qualif Poule 12 '!D24","v":"Q/11"},{"$f":"SUM(IF(N14>O14,1,0),IF(P14>Q14,1,0),IF(R14>S14,1,0))","v":0},"/",0,null,null,null,null,null,null,{"$f":"IF(K14=M14,\"\",IF(K14>M14,H14,J14))","v":""},"",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D18","v":"Q/7"},{"$f":"COUNTIF(PLCEQ1,Y14)*2+COUNTIF(PLACEQ2,Y14)","v":0},{"$f":"SUMIF(LISTEE1,Y14,(SCEQ1))+SUMIF(LISTEE2,Y14,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y14,SCEQ2)+SUMIF(LISTEE2,Y14,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG14,$AG$13:$AG$15)","v":1},2,{"$f":"IF(Z14=0,\"\",IF($AH$13=AI14,$Y$13,IF($AH$14=AI14,$Y$14,IF($AH$15=AI14,$Y$15,IF($AH$16=AI14,$Y$16)))))","v":""}]
[null,null,"D",1,8,"11:30:00",2,{"$f":"'TAB Qualif Poule 12 '!D28","v":"Q/5"},"/",{"$f":"'TAB Qualif Poule 12 '!D29","v":"Q/12"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D19","v":"Q/10"},{"$f":"COUNTIF(PLCEQ1,Y15)*2+COUNTIF(PLACEQ2,Y15)","v":0},{"$f":"SUMIF(LISTEE1,Y15,(SCEQ1))+SUMIF(LISTEE2,Y15,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y15,SCEQ2)+SUMIF(LISTEE2,Y15,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG15,$AG$13:$AG$17)","v":1},3,{"$f":"IF(Z15=0,\"\",IF($AH$13=AI15,$Y$13,IF($AH$14=AI15,$Y$14,IF($AH$15=AI15,$Y$15,IF($AH$16=AI15,$Y$16)))))","v":""}]
[null,null,"A",1,9,"12:20:00",1,{"$f":"'TAB Qualif Poule 12 '!D12","v":"Q/1"},"/",{"$f":"'TAB Qualif Poule 12 '!D13","v":"Q/8"},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"B",1,10,"12:20:00",2,{"$f":"'TAB Qualif Poule 12 '!D17","v":"Q/2"},"/",{"$f":"'TAB Qualif Poule 12 '!D18","v":"Q/7"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"C"]
[null,null,"C",1,11,"13:10:00",1,{"$f":"'TAB Qualif Poule 12 '!D22","v":"Q/3"},"/",{"$f":"'TAB Qualif Poule 12 '!D23","v":"Q/6"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D22","v":"Q/3"},{"$f":"COUNTIF(PLCEQ1,Y18)*2+COUNTIF(PLACEQ2,Y18)","v":0},{"$f":"SUMIF(LISTEE1,Y18,(SCEQ1))+SUMIF(LISTEE2,Y18,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y18,SCEQ2)+SUMIF(LISTEE2,Y18,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(AA18/AB18,0)","v":0},0,{"$f":"Z18+AE18/100+AF18/100","v":0},{"$f":"RANK(AG18,$AG$18:$AG$22)","v":1},1,{"$f":"IF(Z18=0,\"\",IF(AH$18=AI18,Y18,IF(AH19=AI18,Y19,IF(AH20=AI18,Y20,IF(AH21=AI18,Y21)))))","v":""}]
[null,null,"D",1,12,{"$f":"F17+$B$4","v":"13:10:00"},2,{"$f":"'TAB Qualif Poule 12 '!D27","v":"Q/4"},"/",{"$f":"'TAB Qualif Poule 12 '!D28","v":"Q/5"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D23","v":"Q/6"},{"$f":"COUNTIF(PLCEQ1,Y19)*2+COUNTIF(PLACEQ2,Y19)","v":0},{"$f":"SUMIF(LISTEE1,Y19,(SCEQ1))+SUMIF(LISTEE2,Y19,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y19,SCEQ2)+SUMIF(LISTEE2,Y19,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,{"$f":"Z19+AE19/100+AF19/100","v":0},{"$f":"RANK(AG19,$AG$18:$AG$22)","v":1},2,{"$f":"IF(Z19=0,\"\",IF(AH$18=AI19,Y18,IF(AH19=AI19,Y19,IF(AH20=AI19,Y20,IF(AH21=AI19,Y21)))))","v":""}]
[null,null,"BARR",1,13,{"$f":"F18+$B$4","v":"14:00:00"},1,{"$f":"AJ19","v":""},"/",{"$f":"AJ15","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D24","v":"Q/11"},{"$f":"COUNTIF(PLCEQ1,Y20)*2+COUNTIF(PLACEQ2,Y20)","v":0},{"$f":"SUMIF(LISTEE1,Y20,(SCEQ1))+SUMIF(LISTEE2,Y20,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y20,SCEQ2)+SUMIF(LISTEE2,Y20,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG20,$AG$18:$AG$22)","v":1},3,{"$f":"IF(Z20=0,\"\",IF(AH$18=AI20,Y18,IF(AH19=AI20,Y19,IF(AH20=AI20,Y20,IF(AH21=AI20,Y21)))))","v":""}]
[null,null,"BARR",1,14,{"$f":"F19+$B$4","v":"14:00:00"},2,{"$f":"AJ14","v":""},"/",{"$f":"AJ25","v":""},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"BARR",1,15,{"$f":"F20+$B$4","v":"14:50:00"},1,{"$f":"AJ9","v":""},"/",{"$f":"AJ20","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"D"]
[null,null,"BARR",1,16,{"$f":"F21+$B$4","v":"14:50:00"},2,{"$f":"AJ24","v":""},"/",{"$f":"AJ10","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D27","v":"Q/4"},{"$f":"COUNTIF(PLCEQ1,Y23)*2+COUNTIF(PLACEQ2,Y23)","v":0},{"$f":"SUMIF(LISTEE1,Y23,(SCEQ1))+SUMIF(LISTEE2,Y23,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y23,SCEQ2)+SUMIF(LISTEE2,Y23,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG23,$AG$23:$AG$27)","v":1},1,{"$f":"IF(Z23=0,\"\",IF($AH$23=AI23,$Y$23,IF($AH$24=AI23,$Y$24,IF($AH$25=AI23,$Y$25,IF($AH$26=AI23,$Y$26)))))","v":""}]
[null,null,"1/4",1,17,{"$f":"B5","v":"14:00:00"},1,{"$f":"AJ8","v":""},"/",{"$f":"T20","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D28","v":"Q/5"},{"$f":"COUNTIF(PLCEQ1,Y24)*2+COUNTIF(PLACEQ2,Y24)","v":0},{"$f":"SUMIF(LISTEE1,Y24,(SCEQ1))+SUMIF(LISTEE2,Y24,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y24,SCEQ2)+SUMIF(LISTEE2,Y24,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG24,$AG$23:$AG$27)","v":1},2,{"$f":"IF(Z24=0,\"\",IF($AH$23=AI24,$Y$23,IF($AH$24=AI24,$Y$24,IF($AH$25=AI24,$Y$25,IF($AH$26=AI24,$Y$26)))))","v":""}]
[null,null,"1/4",1,18,{"$f":"B5","v":"14:00:00"},2,{"$f":"AJ23","v":""},"/",{"$f":"T21","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB Qualif Poule 12 '!D29","v":"Q/12"},{"$f":"COUNTIF(PLCEQ1,Y25)*2+COUNTIF(PLACEQ2,Y25)","v":0},{"$f":"SUMIF(LISTEE1,Y25,(SCEQ1))+SUMIF(LISTEE2,Y25,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y25,SCEQ2)+SUMIF(LISTEE2,Y25,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,1,3,{"$f":"IF(Z25=0,\"\",IF($AH$23=AI25,$Y$23,IF($AH$24=AI25,$Y$24,IF($AH$25=AI25,$Y$25,IF($AH$26=AI25,$Y$26)))))","v":""}]
[null,null,"1/4",1,19,{"$f":"F25+$B$4","v":"14:50:00"},1,{"$f":"AJ13","v":""},"/",{"$f":"T23","v":""},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"1/4",1,20,{"$f":"F25+$B$4","v":"14:50:00"},2,{"$f":"AJ18","v":""},"/",{"$f":"T22","v":""},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"1/2",1,21,{"$f":"F27+$B$4","v":"15:40:00"},1,{"$f":"T24","v":""},"/",{"$f":"T25","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"CLA FINAL"]
[null,null,"1/2",1,22,{"$f":"F28+$B$4","v":"16:30:00"},1,{"$f":"T26","v":""},"/",{"$f":"T27","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,"qualifié",{"$f":"AJ8","v":""}]
[null,null,"PF",1,23,"17:20:00",1,{"$f":"U28","v":""},"/",{"$f":"U29","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,"qualifié",{"$f":"AJ13","v":""}]
[null,null,"FF",1,24,"18:10:00",1,{"$f":"T28","v":""},"/",{"$f":"T29","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,"qualifié",{"$f":"AJ18","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qualifié",{"$f":"AJ23","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"AJ9","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"AJ14","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"AJ19","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"AJ24","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"AJ10","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"AJ15","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"AJ20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"AJ25","v":""}]

{"sheet":"PLANNING ","index":5,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,2,2,3],[7,2,7,3],[12,2,12,3],[6,7,6,14],[4,12,4,14],[1,12,3,14],[1,7,3,11],[4,7,4,8],[4,9,4,11],[5,7,5,14]]}
[]
[null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$1","v":"APPELATION TOURNOI"},null,null,null,null,{"$f":"'LISTE ENGAGES'!$J$1","v":"ORGANISATEUR"}]
[null,"J1","HEURE DEBUT",null,"09:00:00"]
[null,"MATIN","DUREE MATCH",null,"00:40:00"]
[null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$4","v":"LIEU"},null,{"$f":"'LISTE ENGAGES'!$H$4","v":"DATE"},null,null,{"$f":"'LISTE ENGAGES'!$J$4","v":"GENRE"}]
[null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$5","v":"TYPE"}]
[null,null,null,null,null,null,null,"FEUILLE EMARGEMENT"]
[null,"J1","HEURE DEBUT",null,"09:00:00"]
[null,"APM","DUREE MATCH",null,"01:00:00"]
[]
[]
[]
[null,"J2","HEURE DEBUT",null,"09:00:00"]
[null,null,"DUREE MATCH",null,"01:00:00"]
[]
[]
[null,null,null,null,"MATCH","n°","TER.","E1","./.","E2","ARB","MATCH","n°","TER.","E1","./.","E2","ARB","POINTS"]
[null,null,"JOUR 1",{"$f":"E3","v":"09:00:00"},"AF1",1,null,{"$f":"'TAB Qualif Poule 12 '!D12","v":"Q/1"},null,{"$f":"'TAB Qualif Poule 12 '!D14","v":"Q/9"},null,"CF1",2,null,{"$f":"'TAB Qualif Poule 12 '!D22","v":"Q/3"},null,{"$f":"'TAB Qualif Poule 12 '!D24","v":"Q/11"},null,"2*15, SD 11"]
[null,null,null,{"$f":"D18+$E$4","v":"09:40:00"},"BF1",3,null,{"$f":"'TAB Qualif Poule 12 '!D17","v":"Q/2"},null,{"$f":"'TAB Qualif Poule 12 '!D19","v":"Q/10"},null,"DF1",4,null,{"$f":"'TAB Qualif Poule 12 '!D27","v":"Q/4"},null,{"$f":"'TAB Qualif Poule 12 '!D29","v":"Q/12"},null,"2*15, SD 11"]
[null,null,null,{"$f":"D19+$E$4","v":"10:20:00"},"AF2",5,null,{"$f":"'TAB Qualif Poule 12 '!D13","v":"Q/8"},null,{"$f":"'TAB Qualif Poule 12 '!D14","v":"Q/9"},null,"CF2",6,null,{"$f":"'TAB Qualif Poule 12 '!D23","v":"Q/6"},null,{"$f":"'TAB Qualif Poule 12 '!D24","v":"Q/11"},null,"2*15, SD 11"]
[null,null,null,"11:00:00","BF2",7,null,{"$f":"'TAB Qualif Poule 12 '!D18","v":"Q/7"},null,{"$f":"'TAB Qualif Poule 12 '!D19","v":"Q/10"},null,"DF2",8,null,{"$f":"'TAB Qualif Poule 12 '!D28","v":"Q/5"},null,{"$f":"'TAB Qualif Poule 12 '!D29","v":"Q/12"},null,"2*15, SD 11"]
[null,null,null,"11:40:00","AF3",9,null,{"$f":"'TAB Qualif Poule 12 '!D12","v":"Q/1"},null,{"$f":"'TAB Qualif Poule 12 '!D13","v":"Q/8"},null,"CF3",10,null,{"$f":"'TAB Qualif Poule 12 '!D22","v":"Q/3"},null,{"$f":"'TAB Qualif Poule 12 '!D23","v":"Q/6"},null,"2*15, SD 11"]
[null,null,null,"12:20:00","BF3",11,null,{"$f":"'TAB Qualif Poule 12 '!D17","v":"Q/2"},null,{"$f":"'TAB Qualif Poule 12 '!D18","v":"Q/7"},null,"DF3",12,null,{"$f":"'TAB Qualif Poule 12 '!D27","v":"Q/4"},null,{"$f":"'TAB Qualif Poule 12 '!D28","v":"Q/5"},null,"2*15, SD 11"]
[null,null,null,"13:00:00","FIN"]
[]
[]
[]
[null,null,null,null,"MATCH","n°","TER.","E1","./.","E2","ARB","MATCH","n°","TER.","E1","./.","E2","ARB","POINTS"]
[null,null,"JOUR 1",{"$f":"E8","v":"09:00:00"},"AF1",1,null,{"$f":"'TAB P Poule 12 '!C16","v":"T / 1"},null,{"$f":"'TAB P Poule 12 '!C18","v":"T / 9"},null,"CF1",2,null,{"$f":"'TAB P Poule 12 '!C26","v":"T / 3"},null,{"$f":"'TAB P Poule 12 '!C28","v":"T / 11"},null,"2*21, SD 11"]
[null,null,null,{"$f":"D29+$E$9","v":"10:00:00"},"BF1",3,null,{"$f":"'TAB P Poule 12 '!C21","v":"T / 2"},null,{"$f":"'TAB P Poule 12 '!C23","v":"T / 10"},null,"DF1",4,null,{"$f":"'TAB P Poule 12 '!C31","v":"T / 4"},null,{"$f":"'TAB P Poule 12 '!C33","v":"T / 12"},null,"2*21, SD 11"]
[null,null,null,{"$f":"D30+$E$9","v":"11:00:00"},"AF2",5,null,{"$f":"'TAB P Poule 12 '!C17","v":"T / 8"},null,{"$f":"'TAB P Poule 12 '!C18","v":"T / 9"},null,"CF2",6,null,{"$f":"'TAB P Poule 12 '!C27","v":"T / 6"},null,{"$f":"'TAB P Poule 12 '!C28","v":"T / 11"},null,"2*21, SD 11"]
[null,null,null,"12:00:00","BF2",7,null,{"$f":"'TAB P Poule 12 '!C22","v":"T / 7"},null,{"$f":"'TAB P Poule 12 '!C23","v":"T / 10"},null,"DF2",8,null,{"$f":"'TAB P Poule 12 '!C32","v":"T / 5"},null,{"$f":"'TAB P Poule 12 '!C33","v":"T / 12"},null,"2*21, SD 11"]
[null,null,null,"13:00:00","AF3",9,null,{"$f":"'TAB P Poule 12 '!C16","v":"T / 1"},null,{"$f":"'TAB P Poule 12 '!C17","v":"T / 8"},null,"CF3",10,null,{"$f":"'TAB P Poule 12 '!C26","v":"T / 3"},null,{"$f":"'TAB P Poule 12 '!C27","v":"T / 6"},null,"2*21, SD 11"]
[null,null,null,"14:00:00","BF3",11,null,{"$f":"'TAB P Poule 12 '!C21","v":"T / 2"},null,{"$f":"'TAB P Poule 12 '!C22","v":"T / 7"},null,"DF3",12,null,{"$f":"'TAB P Poule 12 '!C31","v":"T / 4"},null,{"$f":"'TAB P Poule 12 '!C32","v":"T / 5"},null,"2*21, SD 11"]
[null,null,null,"15:00:00","FIN"]
[]
[]
[null,null,null,null,"MATCH","n°","TER.","E1","./.","E2","ARB","MATCH","n°","TER.","E1","./.","E2","ARB","POINTS"]
[null,null,"JOUR 2",{"$f":"+E13","v":"09:00:00"},"1/4",null,null,{"$f":"'TAB P Poule 12 '!N17","v":"1A"},null,{"$f":"'TAB P Poule 12 '!N20","v":" "},null,"1/4",null,null,{"$f":"'TAB P Poule 12 '!N27","v":"1C"},null,{"$f":"'TAB P Poule 12 '!N30","v":" "},null,"2*21, SD 11"]
[null,null,null,{"$f":"+D39+$E$14","v":"10:00:00"},"1/4",null,null,{"$f":"'TAB P Poule 12 '!N22","v":" "},null,{"$f":"'TAB P Poule 12 '!N25","v":"1D"},null,"1/4",null,null,{"$f":"'TAB P Poule 12 '!N32","v":"1B"},null,{"$f":"'TAB P Poule 12 '!N35","v":" "},null,"2*21, SD 11"]
[null,null,null,{"$f":"+D40+$E$14","v":"11:00:00"},"DEMI-FINALE",null,null,{"$f":"'TAB P Poule 12 '!P18","v":""},null,{"$f":"'TAB P Poule 12 '!P24","v":""},null,null,null,null,null,null,null,null,"2*21, SD 11"]
[null,null,null,"12:00:00",null,null,null,null,null,null,null,"DEMI-FINALE",null,null,{"$f":"'TAB P Poule 12 '!P28","v":""},null,{"$f":"'TAB P Poule 12 '!P34","v":""},null,"2*21, SD 11"]
[null,null,null,"13:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2*21, SD 11"]
[null,null,null,"14:00:00","FIN 3/4",null,null,{"$f":"'TAB P Poule 12 '!R37","v":""},null,{"$f":"'TAB P Poule 12 '!R44","v":""},null,"FIN 3/4",null,null,null,null,null,null,"2*21, SD 11"]
[null,null,null,"15:00:00","FIN"]
[null,null,null,"16:00:00","FIN",null,null,{"$f":"'TAB P Poule 12 '!R20","v":0},null,{"$f":"'TAB P Poule 12 '!R32","v":0}]
[null,null,null,"17:00:00","PODIUM"]

{"sheet":"EMARG Tableau PRINCIPAL","index":6,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,4,5,10],[1,4,2,9],[1,10,3,10],[3,4,3,5],[3,6,3,8],[4,4,4,10]]}
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$1","v":"APPELATION TOURNOI"},null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$J$1","v":"ORGANISATEUR"}]
[]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$4","v":"LIEU"},null,{"$f":"'LISTE ENGAGES'!$H$4","v":"DATE"},null,null,{"$f":"'LISTE ENGAGES'!$J$4","v":"GENRE"}]
[null,null,null,null,{"$f":"'LISTE ENGAGES'!$E$5","v":"TYPE"}]
[null,null,null,null,"FEUILLE EMARGEMENT"]
[]
[]
[]
[null,"N°",null,"NOM","PRENOM","NOM","PRENOM","pts","tir","SIGNATURE JOUEUR1","SIGNATURE JOUEUR2"]
[null,1,null,"T",null,1]
[null,2,null,"T",null,2]
[null,3,null,"T",null,3]
[null,4,null,"T",null,4]
[null,5,null,"T",null,5]
[null,6,null,"T",null,6]
[null,7,null,"T",null,7]
[null,8,null,"T",null,8]
[null,9,null,"T",null,9]
[null,10,null,"T",null,10]
[null,11,null,"T",null,11]
[null,12,null,"T",null,12]
[]
[]
[null,null,null,"Copier/coller selon LISTE ENGAGES en fonction des équipes confirmées APRES les qualifications"]
[null,null,null,"ATTENTION : Respecter l'ordre des têtes de séries en fonction des points et classement de la LISTE ENGAGES"]
[null,null,null,"Ex: Si Sur LISTE ENGAGES, l'équipe 9 absente, la numéro 10 devient la numéro 9 dans EMARG"]
[null,null,null,"EX: Si toutes les equipes du tableau principal sont confirmées, les équipes issues qualifications sont replacées en fonction de leurs points, en bas de tableau"]

{"sheet":"TAB P Poule 12 ","index":7,"n_rows":44,"n_cols":23,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,3,6,17],[1,3,3,15],[4,12,4,14],[1,16,4,17],[5,3,5,17],[4,3,4,11]]}
[]
[null,null,null,{"$f":"'LISTE ENGAGES'!$E$1","v":"APPELATION TOURNOI"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$J$1","v":"ORGANISATEUR"}]
[]
[]
[null,null,null,{"$f":"'LISTE ENGAGES'!$E$4","v":"LIEU"},null,null,null,null,null,null,null,null,{"$f":"'LISTE ENGAGES'!$H$4","v":"DATE"},null,null,{"$f":"'LISTE ENGAGES'!$J$4","v":"GENRE"}]
[null,null,null,{"$f":"'LISTE ENGAGES'!$E$5","v":"TYPE"}]
[null,null,null,"TABLEAU PRINCIPAL"]
[]
[]
[]
[]
[]
[null,null,"POULES ",null,null,null,"RESULTATS",null,null,"CLASSEMENT POUL.",null,"1/8 FINALES",null,"1/4 FINALES",null,"1/2 FINALES",null,"FINALES"]
[]
[null,null,null,"ORDRE","TER,"]
[null,"TS1",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D11,\" / \",'EMARG Tableau PRINCIPAL'!F11)","v":"T / 1"},{"$f":"CONCATENATE(B16,\" / \",B18)","v":"TS1 / TS9"},null,"(1)",{"$f":"IF('SCORE PRINC'!K8='SCORE PRINC'!M8,\"\",CONCATENATE('SCORE PRINC'!K8,\" : \",'SCORE PRINC'!M8,\" \",\"(\",'SCORE PRINC'!N8,\" - \",'SCORE PRINC'!O8,\")\",\"(\",'SCORE PRINC'!P8,\" - \",'SCORE PRINC'!Q8,\")\",\"(\",'SCORE PRINC'!R8,\" - \",'SCORE PRINC'!S8,\")\"))","v":""},null,1,{"$f":"IF('SCORE PRINC'!AJ8='SCORE PRINC'!AK8,\" \",'SCORE PRINC'!AJ8)","v":" "}]
["A","TS8",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D18,\" / \",'EMARG Tableau PRINCIPAL'!F18)","v":"T / 8"},{"$f":"CONCATENATE(B17,\" / \",B18)","v":"TS8 / TS9"},null,"(5)",{"$f":"IF('SCORE PRINC'!K12='SCORE PRINC'!M12,\"\",CONCATENATE('SCORE PRINC'!K12,\" : \",'SCORE PRINC'!M12,\" \",\"(\",'SCORE PRINC'!N12,\" - \",'SCORE PRINC'!O12,\")\",\"(\",'SCORE PRINC'!P12,\" - \",'SCORE PRINC'!Q12,\")\",\"(\",'SCORE PRINC'!R12,\" - \",'SCORE PRINC'!S12,\")\"))","v":""},null,2,{"$f":"IF('SCORE PRINC'!AJ9='SCORE PRINC'!AK9,\" \",'SCORE PRINC'!AJ9)","v":" "},null,null,null,{"$f":"IF('SCORE PRINC'!AJ8=\"\",\"1A\",'SCORE PRINC'!AJ8)","v":"1A"}]
[null,"TS9",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D19,\" / \",'EMARG Tableau PRINCIPAL'!F19)","v":"T / 9"},{"$f":"CONCATENATE(C16,\" / \",B17)","v":"T / 1 / TS8"},null,"(9)",{"$f":"IF('SCORE PRINC'!K16='SCORE PRINC'!M16,\"\",CONCATENATE('SCORE PRINC'!K16,\" : \",'SCORE PRINC'!M16,\" \",\"(\",'SCORE PRINC'!N16,\" - \",'SCORE PRINC'!O16,\")\",\"(\",'SCORE PRINC'!P16,\" - \",'SCORE PRINC'!Q16,\")\",\"(\",'SCORE PRINC'!R16,\" - \",'SCORE PRINC'!S16,\")\"))","v":""},null,3,{"$f":"IF('SCORE PRINC'!AJ10='SCORE PRINC'!AK10,\" \",'SCORE PRINC'!AJ10)","v":" "},null,{"$f":"J23","v":" "},null,"(13)    ",null,{"$f":"IF('SCORE PRINC'!K24='SCORE PRINC'!M24,\"\",'SCORE PRINC'!T24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"3B",null,"2C",null,{"$f":"IF('SCORE PRINC'!K24='SCORE PRINC'!M24,\"\",CONCATENATE('SCORE PRINC'!K24,\" : \",'SCORE PRINC'!M24,\" \",\"(\",'SCORE PRINC'!N24,\" - \",'SCORE PRINC'!O24,\")\",\"(\",'SCORE PRINC'!P24,\" - \",'SCORE PRINC'!Q24,\")\",\"(\",'SCORE PRINC'!R24,\" - \",'SCORE PRINC'!S24,\")\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"2C",null,{"$f":"J27","v":" "}]
[null,"TS2",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D12,\" / \",'EMARG Tableau PRINCIPAL'!F12)","v":"T / 2"},{"$f":"CONCATENATE(B21,\" / \",B23)","v":"TS2 / TS10"},null,"(3)",{"$f":"IF('SCORE PRINC'!K9='SCORE PRINC'!M9,\"\",CONCATENATE('SCORE PRINC'!K9,\" : \",'SCORE PRINC'!M9,\" \",\"(\",'SCORE PRINC'!N9,\" - \",'SCORE PRINC'!O9,\")\",\"(\",'SCORE PRINC'!P9,\" - \",'SCORE PRINC'!Q9,\")\",\"(\",'SCORE PRINC'!R9,\" - \",'SCORE PRINC'!S9,\")\"))","v":""},null,1,{"$f":"IF('SCORE PRINC'!AJ13='SCORE PRINC'!AK13,\" \",'SCORE PRINC'!AJ13)","v":" "},null,{"$f":"J27","v":" "},null,null,null,"(17)",null,null,null,null,null,null,{"$f":"IF('SCORE PRINC'!K32='SCORE PRINC'!M32,\"\",CONCATENATE('SCORE PRINC'!K32,\" : \",'SCORE PRINC'!M32,\" \",\"(\",'SCORE PRINC'!N32,\" - \",'SCORE PRINC'!O32,\")\",\"(\",'SCORE PRINC'!P32,\" - \",'SCORE PRINC'!Q32,\")\",\"(\",'SCORE PRINC'!R32,\" - \",'SCORE PRINC'!S32,\")\"))","v":""}]
["B","TS7",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D17,\" / \",'EMARG Tableau PRINCIPAL'!F17)","v":"T / 7"},{"$f":"CONCATENATE(B22,\" / \",B23)","v":"TS7 / TS10"},null,"(7)",{"$f":"IF('SCORE PRINC'!K13='SCORE PRINC'!M13,\"\",CONCATENATE('SCORE PRINC'!K13,\" : \",'SCORE PRINC'!M13,\" \",\"(\",'SCORE PRINC'!N13,\" - \",'SCORE PRINC'!O13,\")\",\"(\",'SCORE PRINC'!P13,\" - \",'SCORE PRINC'!Q13,\")\",\"(\",'SCORE PRINC'!R13,\" - \",'SCORE PRINC'!S13,\")\"))","v":""},null,2,{"$f":"IF('SCORE PRINC'!AJ14='SCORE PRINC'!AK14,\" \",'SCORE PRINC'!AJ14)","v":" "},null,null,null,{"$f":"IF(J31=\"\",\"D1\",J31)","v":" "},null,null,null,{"$f":"IF('SCORE PRINC'!K28='SCORE PRINC'!M28,\"\",CONCATENATE('SCORE PRINC'!K28,\" : \",'SCORE PRINC'!M28,\" \",\"(\",'SCORE PRINC'!N28,\" - \",'SCORE PRINC'!O28,\")\",\"(\",'SCORE PRINC'!P28,\" - \",'SCORE PRINC'!Q28,\")\",\"(\",'SCORE PRINC'!R28,\" - \",'SCORE PRINC'!S28,\")\"))","v":""}]
[null,"TS10",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D20,\" / \",'EMARG Tableau PRINCIPAL'!F20)","v":"T / 10"},{"$f":"CONCATENATE(C21,\" / \",B22)","v":"T / 2 / TS7"},null,"(11)",{"$f":"IF('SCORE PRINC'!K17='SCORE PRINC'!M17,\"\",CONCATENATE('SCORE PRINC'!K17,\" : \",'SCORE PRINC'!M17,\" \",\"(\",'SCORE PRINC'!N17,\" - \",'SCORE PRINC'!O17,\")\",\"(\",'SCORE PRINC'!P17,\" - \",'SCORE PRINC'!Q17,\")\",\"(\",'SCORE PRINC'!R17,\" - \",'SCORE PRINC'!S17,\")\"))","v":""},null,3,{"$f":"IF('SCORE PRINC'!AJ15='SCORE PRINC'!AK15,\" \",'SCORE PRINC'!AJ15)","v":" "},null,{"$f":"J28","v":" "},null,"(14)"]
[null,null,null,null,null,null,null,null,null,null,null,"3C",null,"2B",null,{"$f":"IF('SCORE PRINC'!K25='SCORE PRINC'!M25,\"\",'SCORE PRINC'!T25)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"2B",null,{"$f":"IF('SCORE PRINC'!AJ23=\"\",\"1D\",'SCORE PRINC'!AJ23)","v":"1D"},null,{"$f":"IF('SCORE PRINC'!K25='SCORE PRINC'!M25,\"\",CONCATENATE('SCORE PRINC'!K25,\" : \",'SCORE PRINC'!M25,\" \",\"(\",'SCORE PRINC'!N25,\" - \",'SCORE PRINC'!O25,\")\",\"(\",'SCORE PRINC'!P25,\" - \",'SCORE PRINC'!Q25,\")\",\"(\",'SCORE PRINC'!R25,\" - \",'SCORE PRINC'!S25,\")\"))","v":""},null,null,{"$f":"IF('SCORE PRINC'!K31='SCORE PRINC'!M31,\"\",'SCORE PRINC'!T31)","v":""}]
[null,"TS3",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D13,\" / \",'EMARG Tableau PRINCIPAL'!F13)","v":"T / 3"},{"$f":"CONCATENATE(B26,\" / \",B28)","v":"TS3 / TS11"},null,"(2)",{"$f":"IF('SCORE PRINC'!K10='SCORE PRINC'!M10,\"\",CONCATENATE('SCORE PRINC'!K10,\" : \",'SCORE PRINC'!M10,\" \",\"(\",'SCORE PRINC'!N10,\" - \",'SCORE PRINC'!O10,\")\",\"(\",'SCORE PRINC'!P10,\" - \",'SCORE PRINC'!Q10,\")\",\"(\",'SCORE PRINC'!R10,\" - \",'SCORE PRINC'!S10,\")\"))","v":""},null,1,{"$f":"IF('SCORE PRINC'!AJ18='SCORE PRINC'!AK18,\" \",'SCORE PRINC'!AJ18)","v":" "},null,{"$f":"J22","v":" "}]
["C","TS6",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D16,\" / \",'EMARG Tableau PRINCIPAL'!F16)","v":"T / 6"},{"$f":"CONCATENATE(B27,\" / \",B28)","v":"TS6 / TS11"},null,"(6)",{"$f":"IF('SCORE PRINC'!K14='SCORE PRINC'!M14,\"\",CONCATENATE('SCORE PRINC'!K14,\" : \",'SCORE PRINC'!M14,\" \",\"(\",'SCORE PRINC'!N14,\" - \",'SCORE PRINC'!O14,\")\",\"(\",'SCORE PRINC'!P14,\" - \",'SCORE PRINC'!Q14,\")\",\"(\",'SCORE PRINC'!R14,\" - \",'SCORE PRINC'!S14,\")\"))","v":""},null,2,{"$f":"IF('SCORE PRINC'!AJ19='SCORE PRINC'!AK19,\" \",'SCORE PRINC'!AJ19)","v":" "},null,null,null,{"$f":"IF('SCORE PRINC'!AJ18=\"\",\"1C\",'SCORE PRINC'!AJ18)","v":"1C"},null,null,null,"(20)",{"$f":"IF('SCORE PRINC'!K31='SCORE PRINC'!M31,\"\",CONCATENATE('SCORE PRINC'!K31,\" : \",'SCORE PRINC'!M31,\" \",\"(\",'SCORE PRINC'!N31,\" - \",'SCORE PRINC'!O31,\")\",\"(\",'SCORE PRINC'!P31,\" - \",'SCORE PRINC'!Q31,\")\",\"(\",'SCORE PRINC'!R31,\" - \",'SCORE PRINC'!S31,\")\"))","v":""}]
[null,"TS11",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D21,\" / \",'EMARG Tableau PRINCIPAL'!F21)","v":"T / 11"},{"$f":"CONCATENATE(C26,\" / \",B27)","v":"T / 3 / TS6"},null,"(10)",{"$f":"IF('SCORE PRINC'!K18='SCORE PRINC'!M18,\"\",CONCATENATE('SCORE PRINC'!K18,\" : \",'SCORE PRINC'!M18,\" \",\"(\",'SCORE PRINC'!N18,\" - \",'SCORE PRINC'!O18,\")\",\"(\",'SCORE PRINC'!P18,\" - \",'SCORE PRINC'!Q18,\")\",\"(\",'SCORE PRINC'!R18,\" - \",'SCORE PRINC'!S18,\")\"))","v":""},null,3,{"$f":"IF('SCORE PRINC'!AJ20='SCORE PRINC'!AK20,\" \",'SCORE PRINC'!AJ20)","v":" "},null,{"$f":"J33","v":" "},null,"(15)",null,{"$f":"IF('SCORE PRINC'!K27='SCORE PRINC'!M27,\"\",'SCORE PRINC'!T27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"3D",null,"2A",null,{"$f":"IF('SCORE PRINC'!K27='SCORE PRINC'!M27,\"\",CONCATENATE('SCORE PRINC'!K27,\" : \",'SCORE PRINC'!M27,\" \",\"(\",'SCORE PRINC'!N27,\" - \",'SCORE PRINC'!O27,\")\",\"(\",'SCORE PRINC'!P27,\" - \",'SCORE PRINC'!Q27,\")\",\"(\",'SCORE PRINC'!R27,\" - \",'SCORE PRINC'!S27,\")\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"2A",null,{"$f":"J17","v":" "}]
[null,"TS4",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D14,\" / \",'EMARG Tableau PRINCIPAL'!F14)","v":"T / 4"},{"$f":"CONCATENATE(B31,\" / \",B33)","v":"TS4 / TS12"},null,"(4)",{"$f":"IF('SCORE PRINC'!K11='SCORE PRINC'!M11,\"\",CONCATENATE('SCORE PRINC'!K11,\" : \",'SCORE PRINC'!M11,\" \",\"(\",'SCORE PRINC'!N11,\" - \",'SCORE PRINC'!O11,\")\",\"(\",'SCORE PRINC'!P11,\" - \",'SCORE PRINC'!Q11,\")\",\"(\",'SCORE PRINC'!R11,\" - \",'SCORE PRINC'!S11,\")\"))","v":""},null,1,{"$f":"IF('SCORE PRINC'!AJ23='SCORE PRINC'!AK23,\" \",'SCORE PRINC'!AJ23)","v":" "},null,{"$f":"J17","v":" "},null,null,null,"(18)"]
["D","TS5",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D15,\" / \",'EMARG Tableau PRINCIPAL'!F15)","v":"T / 5"},{"$f":"CONCATENATE(B32,\" / \",B33)","v":"TS5 / TS12"},null,"(8)",{"$f":"IF('SCORE PRINC'!K15='SCORE PRINC'!M15,\"\",CONCATENATE('SCORE PRINC'!K15,\" : \",'SCORE PRINC'!M15,\" \",\"(\",'SCORE PRINC'!N15,\" - \",'SCORE PRINC'!O15,\")\",\"(\",'SCORE PRINC'!P15,\" - \",'SCORE PRINC'!Q15,\")\",\"(\",'SCORE PRINC'!R15,\" - \",'SCORE PRINC'!S15,\")\"))","v":""},null,2,{"$f":"IF('SCORE PRINC'!AJ24='SCORE PRINC'!AK24,\" \",'SCORE PRINC'!AJ24)","v":" "},null,null,null,{"$f":"IF('SCORE PRINC'!AJ13=\"\",\"1B\",'SCORE PRINC'!AJ13)","v":"1B"}]
[null,"TS12",{"$f":"CONCATENATE('EMARG Tableau PRINCIPAL'!D22,\" / \",'EMARG Tableau PRINCIPAL'!F22)","v":"T / 12"},{"$f":"CONCATENATE(C31,\" / \",B32)","v":"T / 4 / TS5"},null,"(12)",{"$f":"IF('SCORE PRINC'!K19='SCORE PRINC'!M19,\"\",CONCATENATE('SCORE PRINC'!K19,\" : \",'SCORE PRINC'!M19,\" \",\"(\",'SCORE PRINC'!N19,\" - \",'SCORE PRINC'!O19,\")\",\"(\",'SCORE PRINC'!P19,\" - \",'SCORE PRINC'!Q19,\")\",\"(\",'SCORE PRINC'!R19,\" - \",'SCORE PRINC'!S19,\")\"))","v":""},null,3,{"$f":"IF('SCORE PRINC'!AJ25='SCORE PRINC'!AK25,\" \",'SCORE PRINC'!AJ25)","v":" "},null,{"$f":"J18","v":" "},null,"(16)",null,null,null,{"$f":"IF('SCORE PRINC'!K29='SCORE PRINC'!M29,\"\",CONCATENATE('SCORE PRINC'!K29,\" : \",'SCORE PRINC'!M29,\" \",\"(\",'SCORE PRINC'!N29,\" - \",'SCORE PRINC'!O29,\")\",\"(\",'SCORE PRINC'!P29,\" - \",'SCORE PRINC'!Q29,\")\",\"(\",'SCORE PRINC'!R29,\" - \",'SCORE PRINC'!S29,\")\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"3A",null,"2D",null,{"$f":"IF('SCORE PRINC'!K26='SCORE PRINC'!M26,\"\",'SCORE PRINC'!T26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"2D",null,{"$f":"J32","v":" "},null,{"$f":"IF('SCORE PRINC'!K26='SCORE PRINC'!M26,\"\",CONCATENATE('SCORE PRINC'!K26,\" : \",'SCORE PRINC'!M26,\" \",\"(\",'SCORE PRINC'!N26,\" - \",'SCORE PRINC'!O26,\")\",\"(\",'SCORE PRINC'!P26,\" - \",'SCORE PRINC'!Q26,\")\",\"(\",'SCORE PRINC'!R26,\" - \",'SCORE PRINC'!S26,\")\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"J32","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('SCORE PRINC'!K28='SCORE PRINC'!M28,\"\",'SCORE PRINC'!U28)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLACE 3/4",{"$f":"IF('SCORE PRINC'!K30='SCORE PRINC'!M30,\"\",'SCORE PRINC'!T30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(19)",{"$f":"IF('SCORE PRINC'!K30='SCORE PRINC'!M30,\"\",CONCATENATE('SCORE PRINC'!K30,\" : \",'SCORE PRINC'!M30,\" \",\"(\",'SCORE PRINC'!N30,\" - \",'SCORE PRINC'!O30,\")\",\"(\",'SCORE PRINC'!P30,\" - \",'SCORE PRINC'!Q30,\")\",\"(\",'SCORE PRINC'!R30,\" - \",'SCORE PRINC'!S30,\")\"))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('SCORE PRINC'!K29='SCORE PRINC'!M29,\"\",'SCORE PRINC'!U29)","v":""}]

{"sheet":"SCORE PRINC","index":8,"n_rows":40,"n_cols":36,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"TABLEAU DE SAISIE DE RESULTATS"]
[]
["DEBUT J1","09:00:00",null,"Saisir le résultats des setas dans les cases bordurées et colorées uniquement"]
["TEMPS","00:50:00"]
["DEBUT J2","14:00:00"]
[]
[null,null,"PHASE","JOUR","N° MATCH","HEURE","TER","EQ1",null,"EQ2","SCORE EQ1",null,"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,"A","PTS","S+","S-","P+","P-","CS","CP","CL.I","RG",null,"CLA"]
[null,null,"A",1,1,{"$f":"B3","v":"09:00:00"},1,{"$f":"'TAB P Poule 12 '!C16","v":"T / 1"},"/",{"$f":"'TAB P Poule 12 '!C18","v":"T / 9"},{"$f":"SUM(IF(N8>O8,1,0),IF(P8>Q8,1,0),IF(R8>S8,1,0))","v":0},"/",{"$f":"SUM(IF(O8>N8,1,0),IF(Q8>P8,1,0),IF(S8>R8,1,0))","v":0},null,null,null,null,null,null,{"$f":"IF(K8=M8,\"\",IF(K8>M8,H8,J8))","v":""},{"$f":"IF(K8=M8,\"\",IF(K8<M8,H8,J8))","v":""},null,null,null,{"$f":"'TAB P Poule 12 '!C16","v":"T / 1"},{"$f":"COUNTIF(PLCE1,Y8)*2+COUNTIF(PLACE2,Y8)","v":0},{"$f":"SUMIF(LISTEE1,Y8,(SCEQ1))+SUMIF(LISTEE2,Y8,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y8,(SCEQ2))+SUMIF(LISTEE2,Y8,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y8)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y8)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(AA8/AB8,0)","v":0},{"$f":"IFERROR(AC8/AD8,0)","v":0},{"$f":"Z8+AE8/100+AF8/100","v":0},{"$f":"IF(Z8=0,\"\",RANK(AG8,$AG$8:$AG$10))","v":""},1,{"$f":"IF(Z8=0,\"\",IF($AH$8=AI8,$Y$8,IF($AH$9=AI8,$Y$9,IF($AH$10=AI8,$Y$10,IF($AH$11=AI8,$Y$11)))))","v":""}]
[null,null,"B",1,2,{"$f":"B3","v":"09:00:00"},2,{"$f":"'TAB P Poule 12 '!C21","v":"T / 2"},"/",{"$f":"'TAB P Poule 12 '!C23","v":"T / 10"},{"$f":"SUM(IF(N9>O9,1,0),IF(P9>Q9,1,0),IF(R9>S9,1,0))","v":0},"/",{"$f":"SUM(IF(O9>N9,1,0),IF(Q9>P9,1,0),IF(S9>R9,1,0))","v":0},null,null,null,null,null,null,{"$f":"IF(K9=M9,\"\",IF(K9>M9,H9,J9))","v":""},{"$f":"IF(K9=M9,\"\",IF(K9<M9,H9,J9))","v":""},null,null,null,{"$f":"'TAB P Poule 12 '!C17","v":"T / 8"},{"$f":"COUNTIF(PLCE1,Y9)*2+COUNTIF(PLACE2,Y9)","v":0},{"$f":"SUMIF(LISTEE1,Y9,(SCEQ1))+SUMIF(LISTEE2,Y9,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y9,(SCEQ2))+SUMIF(LISTEE2,Y9,(SCEQ1))","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y9)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y9)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(AA9/AB9,0)","v":0},{"$f":"IFERROR(AC9/AD9,0)","v":0},{"$f":"Z9+AE9/100+AF9/100","v":0},{"$f":"IF(Z9=0,\"\",RANK(AG9,$AG$8:$AG$10))","v":""},2,{"$f":"IF(Z9=0,\"\",IF($AH$8=AI9,$Y$8,IF($AH$9=AI9,$Y$9,IF($AH$10=AI9,$Y$10,IF($AH$11=AI9,$Y$11)))))","v":""}]
[null,null,"C",1,3,{"$f":"F8+$B$4","v":"09:50:00"},1,{"$f":"'TAB P Poule 12 '!C26","v":"T / 3"},"/",{"$f":"'TAB P Poule 12 '!C28","v":"T / 11"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C18","v":"T / 9"},{"$f":"COUNTIF(PLCE1,Y10)*2+COUNTIF(PLACE2,Y10)","v":0},{"$f":"SUMIF(LISTEE1,Y10,(SCEQ1))+SUMIF(LISTEE2,Y10,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y10,SCEQ2)+SUMIF(LISTEE2,Y10,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y10)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y10)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"IF(Z10=0,\"\",RANK(AG10,$AG$8:$AG$10))","v":""},3,{"$f":"IF(Z10=0,\"\",IF($AH$8=AI10,$Y$8,IF($AH$9=AI10,$Y$9,IF($AH$10=AI10,$Y$10,IF($AH$11=AI10,$Y$11)))))","v":""}]
[null,null,"D",1,4,{"$f":"F9+$B$4","v":"09:50:00"},2,{"$f":"'TAB P Poule 12 '!C31","v":"T / 4"},"/",{"$f":"'TAB P Poule 12 '!C33","v":"T / 12"},0,"/",0,null,null,null,null,null,null,"",{"$f":"IF(K11=M11,\"\",IF(K11<M11,H11,J11))","v":""}]
[null,null,"A",1,5,"10:40:00",1,{"$f":"'TAB P Poule 12 '!C17","v":"T / 8"},"/",{"$f":"'TAB P Poule 12 '!C18","v":"T / 9"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"B"]
[null,null,"B",1,6,"10:40:00",2,{"$f":"'TAB P Poule 12 '!C22","v":"T / 7"},"/",{"$f":"'TAB P Poule 12 '!C23","v":"T / 10"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C21","v":"T / 2"},{"$f":"COUNTIF(PLCE1,Y13)*2+COUNTIF(PLACE2,Y13)","v":0},{"$f":"SUMIF(LISTEE1,Y13,(SCEQ1))+SUMIF(LISTEE2,Y13,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y13,SCEQ2)+SUMIF(LISTEE2,Y13,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y13)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y13)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG13,$AG$13:$AG$17)","v":1},1,{"$f":"IF(Z13=0,\"\",IF($AH$13=AI13,$Y$13,IF($AH$14=AI13,$Y$14,IF($AH$15=AI13,$Y$15,IF($AH$16=AI13,$Y$16)))))","v":""}]
[null,null,"C",1,7,"11:30:00",1,{"$f":"'TAB P Poule 12 '!C27","v":"T / 6"},"/",{"$f":"'TAB P Poule 12 '!C28","v":"T / 11"},{"$f":"SUM(IF(N14>O14,1,0),IF(P14>Q14,1,0),IF(R14>S14,1,0))","v":0},"/",0,null,null,null,null,null,null,{"$f":"IF(K14=M14,\"\",IF(K14>M14,H14,J14))","v":""},"",null,null,null,{"$f":"'TAB P Poule 12 '!C22","v":"T / 7"},{"$f":"COUNTIF(PLCE1,Y14)*2+COUNTIF(PLACE2,Y14)","v":0},{"$f":"SUMIF(LISTEE1,Y14,(SCEQ1))+SUMIF(LISTEE2,Y14,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y14,SCEQ2)+SUMIF(LISTEE2,Y14,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y14)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y14)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG14,$AG$13:$AG$15)","v":1},2,{"$f":"IF(Z14=0,\"\",IF($AH$13=AI14,$Y$13,IF($AH$14=AI14,$Y$14,IF($AH$15=AI14,$Y$15,IF($AH$16=AI14,$Y$16)))))","v":""}]
[null,null,"D",1,8,"11:30:00",2,{"$f":"'TAB P Poule 12 '!C32","v":"T / 5"},"/",{"$f":"'TAB P Poule 12 '!C33","v":"T / 12"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C23","v":"T / 10"},{"$f":"COUNTIF(PLCE1,Y15)*2+COUNTIF(PLACE2,Y15)","v":0},{"$f":"SUMIF(LISTEE1,Y15,(SCEQ1))+SUMIF(LISTEE2,Y15,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y15,SCEQ2)+SUMIF(LISTEE2,Y15,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y15)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y15)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG15,$AG$13:$AG$17)","v":1},3,{"$f":"IF(Z15=0,\"\",IF($AH$13=AI15,$Y$13,IF($AH$14=AI15,$Y$14,IF($AH$15=AI15,$Y$15,IF($AH$16=AI15,$Y$16)))))","v":""}]
[null,null,"A",1,9,"12:20:00",1,{"$f":"'TAB P Poule 12 '!C16","v":"T / 1"},"/",{"$f":"'TAB P Poule 12 '!C17","v":"T / 8"},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"B",1,10,"12:20:00",2,{"$f":"'TAB P Poule 12 '!C21","v":"T / 2"},"/",{"$f":"'TAB P Poule 12 '!C22","v":"T / 7"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"C"]
[null,null,"C",1,11,"13:10:00",1,{"$f":"'TAB P Poule 12 '!C26","v":"T / 3"},"/",{"$f":"'TAB P Poule 12 '!C27","v":"T / 6"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C26","v":"T / 3"},{"$f":"COUNTIF(PLCE1,Y18)*2+COUNTIF(PLACE2,Y18)","v":0},{"$f":"SUMIF(LISTEE1,Y18,(SCEQ1))+SUMIF(LISTEE2,Y18,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y18,SCEQ2)+SUMIF(LISTEE2,Y18,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y18)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y18)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"IFERROR(AA18/AB18,0)","v":0},0,{"$f":"Z18+AE18/100+AF18/100","v":0},{"$f":"RANK(AG18,$AG$18:$AG$22)","v":1},1,{"$f":"IF(Z18=0,\"\",IF(AH$18=AI18,Y18,IF(AH19=AI18,Y19,IF(AH20=AI18,Y20,IF(AH21=AI18,Y21)))))","v":""}]
[null,null,"D",1,12,{"$f":"F17+$B$4","v":"13:10:00"},2,{"$f":"'TAB P Poule 12 '!C31","v":"T / 4"},"/",{"$f":"'TAB P Poule 12 '!C32","v":"T / 5"},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C27","v":"T / 6"},{"$f":"COUNTIF(PLCE1,Y19)*2+COUNTIF(PLACE2,Y19)","v":0},{"$f":"SUMIF(LISTEE1,Y19,(SCEQ1))+SUMIF(LISTEE2,Y19,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y19,SCEQ2)+SUMIF(LISTEE2,Y19,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y19)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y19)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,{"$f":"Z19+AE19/100+AF19/100","v":0},{"$f":"RANK(AG19,$AG$18:$AG$22)","v":1},2,{"$f":"IF(Z19=0,\"\",IF(AH$18=AI19,Y18,IF(AH19=AI19,Y19,IF(AH20=AI19,Y20,IF(AH21=AI19,Y21)))))","v":""}]
[null,null,"BARR",1,13,{"$f":"F18+$B$4","v":"14:00:00"},1,{"$f":"AJ19","v":""},"/",{"$f":"AJ15","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C28","v":"T / 11"},{"$f":"COUNTIF(PLCE1,Y20)*2+COUNTIF(PLACE2,Y20)","v":0},{"$f":"SUMIF(LISTEE1,Y20,(SCEQ1))+SUMIF(LISTEE2,Y20,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y20,SCEQ2)+SUMIF(LISTEE2,Y20,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y20)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y20)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG20,$AG$18:$AG$22)","v":1},3,{"$f":"IF(Z20=0,\"\",IF(AH$18=AI20,Y18,IF(AH19=AI20,Y19,IF(AH20=AI20,Y20,IF(AH21=AI20,Y21)))))","v":""}]
[null,null,"BARR",1,14,{"$f":"F19+$B$4","v":"14:00:00"},2,{"$f":"AJ14","v":""},"/",{"$f":"AJ25","v":""},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"BARR",1,15,{"$f":"F20+$B$4","v":"14:50:00"},1,{"$f":"AJ9","v":""},"/",{"$f":"AJ20","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"D"]
[null,null,"BARR",1,16,{"$f":"F21+$B$4","v":"14:50:00"},2,{"$f":"AJ24","v":""},"/",{"$f":"AJ10","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C31","v":"T / 4"},{"$f":"COUNTIF(PLCE1,Y23)*2+COUNTIF(PLACE2,Y23)","v":0},{"$f":"SUMIF(LISTEE1,Y23,(SCEQ1))+SUMIF(LISTEE2,Y23,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y23,SCEQ2)+SUMIF(LISTEE2,Y23,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y23)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y23)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG23,$AG$23:$AG$27)","v":1},1,{"$f":"IF(Z23=0,\"\",IF($AH$23=AI23,$Y$23,IF($AH$24=AI23,$Y$24,IF($AH$25=AI23,$Y$25,IF($AH$26=AI23,$Y$26)))))","v":""}]
[null,null,"1/4",1,17,{"$f":"B5","v":"14:00:00"},1,{"$f":"IF(AJ8=\"\",\"1A\",AJ8)","v":"1A"},"/",{"$f":"T20","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C32","v":"T / 5"},{"$f":"COUNTIF(PLCE1,Y24)*2+COUNTIF(PLACE2,Y24)","v":0},{"$f":"SUMIF(LISTEE1,Y24,(SCEQ1))+SUMIF(LISTEE2,Y24,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y24,SCEQ2)+SUMIF(LISTEE2,Y24,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y24)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y24)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,{"$f":"RANK(AG24,$AG$23:$AG$27)","v":1},2,{"$f":"IF(Z24=0,\"\",IF($AH$23=AI24,$Y$23,IF($AH$24=AI24,$Y$24,IF($AH$25=AI24,$Y$25,IF($AH$26=AI24,$Y$26)))))","v":""}]
[null,null,"1/4",1,18,{"$f":"B5","v":"14:00:00"},2,{"$f":"IF(AJ23=\"\",\"1D\",AJ23)","v":"1D"},"/",{"$f":"T21","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,{"$f":"'TAB P Poule 12 '!C33","v":"T / 12"},{"$f":"COUNTIF(PLCE1,Y25)*2+COUNTIF(PLACE2,Y25)","v":0},{"$f":"SUMIF(LISTEE1,Y25,(SCEQ1))+SUMIF(LISTEE2,Y25,(SCEQ2))","v":0},{"$f":"SUMIF(LISTEE1,Y25,SCEQ2)+SUMIF(LISTEE2,Y25,SCEQ1)","v":0},{"$f":"(SUMPRODUCT((LISTEE1=Y25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE2=Y25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},{"$f":"(SUMPRODUCT((LISTEE2=Y25)*((S1EQ1)+(S2EQ1)+(S3EQ1))))+(SUMPRODUCT((LISTEE1=Y25)*((S1EQ2)+(S2EQ2)+(S3EQ3))))","v":0},0,0,0,1,3,{"$f":"IF(Z25=0,\"\",IF($AH$23=AI25,$Y$23,IF($AH$24=AI25,$Y$24,IF($AH$25=AI25,$Y$25,IF($AH$26=AI25,$Y$26)))))","v":""}]
[null,null,"1/4",1,19,{"$f":"F25+$B$4","v":"14:50:00"},1,{"$f":"IF(AJ13=\"\",\"1B\",AJ13)","v":"1B"},"/",{"$f":"T23","v":""},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"1/4",1,20,{"$f":"F25+$B$4","v":"14:50:00"},2,{"$f":"IF(AJ18=\"\",\"1C\",AJ18)","v":"1C"},"/",{"$f":"T22","v":""},0,"/",0,null,null,null,null,null,null,"",""]
[null,null,"1/2",1,21,{"$f":"F27+$B$4","v":"15:40:00"},1,{"$f":"T24","v":""},"/",{"$f":"T25","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,null,"CLA FINAL"]
[null,null,"1/2",1,22,{"$f":"F28+$B$4","v":"16:30:00"},1,{"$f":"T26","v":""},"/",{"$f":"T27","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,1,{"$f":"T31","v":""}]
[null,null,"PF",1,23,"17:20:00",1,{"$f":"U28","v":""},"/",{"$f":"U29","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,2,{"$f":"U31","v":""}]
[null,null,"FF",1,24,"18:10:00",1,{"$f":"T28","v":""},"/",{"$f":"T29","v":""},0,"/",0,null,null,null,null,null,null,"","",null,null,3,{"$f":"T30","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"U30","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"U24","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"U25","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"U26","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"U27","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"AJ10","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"AJ15","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"AJ20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"AJ25","v":""}]

{"sheet":"RELEVE","index":9,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":false,"merged":[[85,2,91,10],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[17,4,17,6],[18,4,18,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[76,2,82,10],[7,8,7,9],[8,8,8,9],[2,4,2,10],[3,4,3,5],[4,4,4,5],[5,4,5,5]]}
[null,null,"RELEVE DES RESULTATS ET SANCTIONS - TOURNOI DE BEACH VOLLEY"]
[]
[null,null,"APPELATION DU TOURNOI",null,{"$f":"IF('LISTE ENGAGES'!V4=\"\",\"\",'LISTE ENGAGES'!V4)","v":""}]
[null,null,"TYPE",null,{"$f":"IF('LISTE ENGAGES'!V6=\"\",\"\",'LISTE ENGAGES'!V6)","v":""}]
[null,null,"GENRE",null,{"$f":"IF('LISTE ENGAGES'!V10=\"\",\"\",'LISTE ENGAGES'!V10)","v":""}]
[null,null,"DATE",null,{"$f":"IF('LISTE ENGAGES'!V8=\"\",\"\",CONCATENATE('LISTE ENGAGES'!V8,\"-\",'LISTE ENGAGES'!V9,\"/\",'LISTE ENGAGES'!V7))","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":"IF('LISTE ENGAGES'!D11=\"\",\"\",'LISTE ENGAGES'!D11)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E11=\"\",\"\",'LISTE ENGAGES'!E11)","v":""},{"$f":"IF('LISTE ENGAGES'!F11=\"\",\"\",'LISTE ENGAGES'!F11)","v":""},{"$f":"IF('LISTE ENGAGES'!G11=\"\",\"\",'LISTE ENGAGES'!G11)","v":""},{"$f":"IF('LISTE ENGAGES'!H11=\"\",\"\",'LISTE ENGAGES'!H11)","v":1},{"$f":"IF('LISTE ENGAGES'!I11=\"\",\"\",'LISTE ENGAGES'!I11)","v":""},{"$f":"IF('LISTE ENGAGES'!J11=\"\",\"\",'LISTE ENGAGES'!J11)","v":""},{"$f":"IF('LISTE ENGAGES'!K11=\"\",\"\",'LISTE ENGAGES'!K11)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D12=\"\",\"\",'LISTE ENGAGES'!D12)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E12=\"\",\"\",'LISTE ENGAGES'!E12)","v":""},{"$f":"IF('LISTE ENGAGES'!F12=\"\",\"\",'LISTE ENGAGES'!F12)","v":""},{"$f":"IF('LISTE ENGAGES'!G12=\"\",\"\",'LISTE ENGAGES'!G12)","v":""},{"$f":"IF('LISTE ENGAGES'!H12=\"\",\"\",'LISTE ENGAGES'!H12)","v":2},{"$f":"IF('LISTE ENGAGES'!I12=\"\",\"\",'LISTE ENGAGES'!I12)","v":""},{"$f":"IF('LISTE ENGAGES'!J12=\"\",\"\",'LISTE ENGAGES'!J12)","v":""},{"$f":"IF('LISTE ENGAGES'!K12=\"\",\"\",'LISTE ENGAGES'!K12)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D13=\"\",\"\",'LISTE ENGAGES'!D13)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E13=\"\",\"\",'LISTE ENGAGES'!E13)","v":""},{"$f":"IF('LISTE ENGAGES'!F13=\"\",\"\",'LISTE ENGAGES'!F13)","v":""},{"$f":"IF('LISTE ENGAGES'!G13=\"\",\"\",'LISTE ENGAGES'!G13)","v":""},{"$f":"IF('LISTE ENGAGES'!H13=\"\",\"\",'LISTE ENGAGES'!H13)","v":3},{"$f":"IF('LISTE ENGAGES'!I13=\"\",\"\",'LISTE ENGAGES'!I13)","v":""},{"$f":"IF('LISTE ENGAGES'!J13=\"\",\"\",'LISTE ENGAGES'!J13)","v":""},{"$f":"IF('LISTE ENGAGES'!K13=\"\",\"\",'LISTE ENGAGES'!K13)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D14=\"\",\"\",'LISTE ENGAGES'!D14)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E14=\"\",\"\",'LISTE ENGAGES'!E14)","v":""},{"$f":"IF('LISTE ENGAGES'!F14=\"\",\"\",'LISTE ENGAGES'!F14)","v":""},{"$f":"IF('LISTE ENGAGES'!G14=\"\",\"\",'LISTE ENGAGES'!G14)","v":""},{"$f":"IF('LISTE ENGAGES'!H14=\"\",\"\",'LISTE ENGAGES'!H14)","v":4},{"$f":"IF('LISTE ENGAGES'!I14=\"\",\"\",'LISTE ENGAGES'!I14)","v":""},{"$f":"IF('LISTE ENGAGES'!J14=\"\",\"\",'LISTE ENGAGES'!J14)","v":""},{"$f":"IF('LISTE ENGAGES'!K14=\"\",\"\",'LISTE ENGAGES'!K14)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D15=\"\",\"\",'LISTE ENGAGES'!D15)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E15=\"\",\"\",'LISTE ENGAGES'!E15)","v":""},{"$f":"IF('LISTE ENGAGES'!F15=\"\",\"\",'LISTE ENGAGES'!F15)","v":""},{"$f":"IF('LISTE ENGAGES'!G15=\"\",\"\",'LISTE ENGAGES'!G15)","v":""},{"$f":"IF('LISTE ENGAGES'!H15=\"\",\"\",'LISTE ENGAGES'!H15)","v":5},{"$f":"IF('LISTE ENGAGES'!I15=\"\",\"\",'LISTE ENGAGES'!I15)","v":""},{"$f":"IF('LISTE ENGAGES'!J15=\"\",\"\",'LISTE ENGAGES'!J15)","v":""},{"$f":"IF('LISTE ENGAGES'!K15=\"\",\"\",'LISTE ENGAGES'!K15)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D16=\"\",\"\",'LISTE ENGAGES'!D16)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E16=\"\",\"\",'LISTE ENGAGES'!E16)","v":""},{"$f":"IF('LISTE ENGAGES'!F16=\"\",\"\",'LISTE ENGAGES'!F16)","v":""},{"$f":"IF('LISTE ENGAGES'!G16=\"\",\"\",'LISTE ENGAGES'!G16)","v":""},{"$f":"IF('LISTE ENGAGES'!H16=\"\",\"\",'LISTE ENGAGES'!H16)","v":6},{"$f":"IF('LISTE ENGAGES'!I16=\"\",\"\",'LISTE ENGAGES'!I16)","v":""},{"$f":"IF('LISTE ENGAGES'!J16=\"\",\"\",'LISTE ENGAGES'!J16)","v":""},{"$f":"IF('LISTE ENGAGES'!K16=\"\",\"\",'LISTE ENGAGES'!K16)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D17=\"\",\"\",'LISTE ENGAGES'!D17)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E17=\"\",\"\",'LISTE ENGAGES'!E17)","v":""},{"$f":"IF('LISTE ENGAGES'!F17=\"\",\"\",'LISTE ENGAGES'!F17)","v":""},{"$f":"IF('LISTE ENGAGES'!G17=\"\",\"\",'LISTE ENGAGES'!G17)","v":""},{"$f":"IF('LISTE ENGAGES'!H17=\"\",\"\",'LISTE ENGAGES'!H17)","v":7},{"$f":"IF('LISTE ENGAGES'!I17=\"\",\"\",'LISTE ENGAGES'!I17)","v":""},{"$f":"IF('LISTE ENGAGES'!J17=\"\",\"\",'LISTE ENGAGES'!J17)","v":""},{"$f":"IF('LISTE ENGAGES'!K17=\"\",\"\",'LISTE ENGAGES'!K17)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D18=\"\",\"\",'LISTE ENGAGES'!D18)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E18=\"\",\"\",'LISTE ENGAGES'!E18)","v":""},{"$f":"IF('LISTE ENGAGES'!F18=\"\",\"\",'LISTE ENGAGES'!F18)","v":""},{"$f":"IF('LISTE ENGAGES'!G18=\"\",\"\",'LISTE ENGAGES'!G18)","v":""},{"$f":"IF('LISTE ENGAGES'!H18=\"\",\"\",'LISTE ENGAGES'!H18)","v":8},{"$f":"IF('LISTE ENGAGES'!I18=\"\",\"\",'LISTE ENGAGES'!I18)","v":""},{"$f":"IF('LISTE ENGAGES'!J18=\"\",\"\",'LISTE ENGAGES'!J18)","v":""},{"$f":"IF('LISTE ENGAGES'!K18=\"\",\"\",'LISTE ENGAGES'!K18)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D19=\"\",\"\",'LISTE ENGAGES'!D19)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E19=\"\",\"\",'LISTE ENGAGES'!E19)","v":""},{"$f":"IF('LISTE ENGAGES'!F19=\"\",\"\",'LISTE ENGAGES'!F19)","v":""},{"$f":"IF('LISTE ENGAGES'!G19=\"\",\"\",'LISTE ENGAGES'!G19)","v":""},{"$f":"IF('LISTE ENGAGES'!H19=\"\",\"\",'LISTE ENGAGES'!H19)","v":9},{"$f":"IF('LISTE ENGAGES'!I19=\"\",\"\",'LISTE ENGAGES'!I19)","v":""},{"$f":"IF('LISTE ENGAGES'!J19=\"\",\"\",'LISTE ENGAGES'!J19)","v":""},{"$f":"IF('LISTE ENGAGES'!K19=\"\",\"\",'LISTE ENGAGES'!K19)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D20=\"\",\"\",'LISTE ENGAGES'!D20)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E20=\"\",\"\",'LISTE ENGAGES'!E20)","v":""},{"$f":"IF('LISTE ENGAGES'!F20=\"\",\"\",'LISTE ENGAGES'!F20)","v":""},{"$f":"IF('LISTE ENGAGES'!G20=\"\",\"\",'LISTE ENGAGES'!G20)","v":""},{"$f":"IF('LISTE ENGAGES'!H20=\"\",\"\",'LISTE ENGAGES'!H20)","v":10},{"$f":"IF('LISTE ENGAGES'!I20=\"\",\"\",'LISTE ENGAGES'!I20)","v":""},{"$f":"IF('LISTE ENGAGES'!J20=\"\",\"\",'LISTE ENGAGES'!J20)","v":""},{"$f":"IF('LISTE ENGAGES'!K20=\"\",\"\",'LISTE ENGAGES'!K20)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D21=\"\",\"\",'LISTE ENGAGES'!D21)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E21=\"\",\"\",'LISTE ENGAGES'!E21)","v":""},{"$f":"IF('LISTE ENGAGES'!F21=\"\",\"\",'LISTE ENGAGES'!F21)","v":""},{"$f":"IF('LISTE ENGAGES'!G21=\"\",\"\",'LISTE ENGAGES'!G21)","v":""},{"$f":"IF('LISTE ENGAGES'!H21=\"\",\"\",'LISTE ENGAGES'!H21)","v":11},{"$f":"IF('LISTE ENGAGES'!I21=\"\",\"\",'LISTE ENGAGES'!I21)","v":""},{"$f":"IF('LISTE ENGAGES'!J21=\"\",\"\",'LISTE ENGAGES'!J21)","v":""},{"$f":"IF('LISTE ENGAGES'!K21=\"\",\"\",'LISTE ENGAGES'!K21)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D22=\"\",\"\",'LISTE ENGAGES'!D22)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E22=\"\",\"\",'LISTE ENGAGES'!E22)","v":""},{"$f":"IF('LISTE ENGAGES'!F22=\"\",\"\",'LISTE ENGAGES'!F22)","v":""},{"$f":"IF('LISTE ENGAGES'!G22=\"\",\"\",'LISTE ENGAGES'!G22)","v":""},{"$f":"IF('LISTE ENGAGES'!H22=\"\",\"\",'LISTE ENGAGES'!H22)","v":12},{"$f":"IF('LISTE ENGAGES'!I22=\"\",\"\",'LISTE ENGAGES'!I22)","v":""},{"$f":"IF('LISTE ENGAGES'!J22=\"\",\"\",'LISTE ENGAGES'!J22)","v":""},{"$f":"IF('LISTE ENGAGES'!K22=\"\",\"\",'LISTE ENGAGES'!K22)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D23=\"\",\"\",'LISTE ENGAGES'!D23)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E23=\"\",\"\",'LISTE ENGAGES'!E23)","v":""},{"$f":"IF('LISTE ENGAGES'!F23=\"\",\"\",'LISTE ENGAGES'!F23)","v":""},{"$f":"IF('LISTE ENGAGES'!G23=\"\",\"\",'LISTE ENGAGES'!G23)","v":""},{"$f":"IF('LISTE ENGAGES'!H23=\"\",\"\",'LISTE ENGAGES'!H23)","v":13},{"$f":"IF('LISTE ENGAGES'!I23=\"\",\"\",'LISTE ENGAGES'!I23)","v":""},{"$f":"IF('LISTE ENGAGES'!J23=\"\",\"\",'LISTE ENGAGES'!J23)","v":""},{"$f":"IF('LISTE ENGAGES'!K23=\"\",\"\",'LISTE ENGAGES'!K23)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D24=\"\",\"\",'LISTE ENGAGES'!D24)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E24=\"\",\"\",'LISTE ENGAGES'!E24)","v":""},{"$f":"IF('LISTE ENGAGES'!F24=\"\",\"\",'LISTE ENGAGES'!F24)","v":""},{"$f":"IF('LISTE ENGAGES'!G24=\"\",\"\",'LISTE ENGAGES'!G24)","v":""},{"$f":"IF('LISTE ENGAGES'!H24=\"\",\"\",'LISTE ENGAGES'!H24)","v":14},{"$f":"IF('LISTE ENGAGES'!I24=\"\",\"\",'LISTE ENGAGES'!I24)","v":""},{"$f":"IF('LISTE ENGAGES'!J24=\"\",\"\",'LISTE ENGAGES'!J24)","v":""},{"$f":"IF('LISTE ENGAGES'!K24=\"\",\"\",'LISTE ENGAGES'!K24)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D25=\"\",\"\",'LISTE ENGAGES'!D25)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E25=\"\",\"\",'LISTE ENGAGES'!E25)","v":""},{"$f":"IF('LISTE ENGAGES'!F25=\"\",\"\",'LISTE ENGAGES'!F25)","v":""},{"$f":"IF('LISTE ENGAGES'!G25=\"\",\"\",'LISTE ENGAGES'!G25)","v":""},{"$f":"IF('LISTE ENGAGES'!H25=\"\",\"\",'LISTE ENGAGES'!H25)","v":15},{"$f":"IF('LISTE ENGAGES'!I25=\"\",\"\",'LISTE ENGAGES'!I25)","v":""},{"$f":"IF('LISTE ENGAGES'!J25=\"\",\"\",'LISTE ENGAGES'!J25)","v":""},{"$f":"IF('LISTE ENGAGES'!K25=\"\",\"\",'LISTE ENGAGES'!K25)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D26=\"\",\"\",'LISTE ENGAGES'!D26)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E26=\"\",\"\",'LISTE ENGAGES'!E26)","v":""},{"$f":"IF('LISTE ENGAGES'!F26=\"\",\"\",'LISTE ENGAGES'!F26)","v":""},{"$f":"IF('LISTE ENGAGES'!G26=\"\",\"\",'LISTE ENGAGES'!G26)","v":""},{"$f":"IF('LISTE ENGAGES'!H26=\"\",\"\",'LISTE ENGAGES'!H26)","v":16},{"$f":"IF('LISTE ENGAGES'!I26=\"\",\"\",'LISTE ENGAGES'!I26)","v":""},{"$f":"IF('LISTE ENGAGES'!J26=\"\",\"\",'LISTE ENGAGES'!J26)","v":""},{"$f":"IF('LISTE ENGAGES'!K26=\"\",\"\",'LISTE ENGAGES'!K26)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D27=\"\",\"\",'LISTE ENGAGES'!D27)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E27=\"\",\"\",'LISTE ENGAGES'!E27)","v":""},{"$f":"IF('LISTE ENGAGES'!F27=\"\",\"\",'LISTE ENGAGES'!F27)","v":""},{"$f":"IF('LISTE ENGAGES'!G27=\"\",\"\",'LISTE ENGAGES'!G27)","v":""},{"$f":"IF('LISTE ENGAGES'!H27=\"\",\"\",'LISTE ENGAGES'!H27)","v":17},{"$f":"IF('LISTE ENGAGES'!I27=\"\",\"\",'LISTE ENGAGES'!I27)","v":""},{"$f":"IF('LISTE ENGAGES'!J27=\"\",\"\",'LISTE ENGAGES'!J27)","v":""},{"$f":"IF('LISTE ENGAGES'!K27=\"\",\"\",'LISTE ENGAGES'!K27)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D28=\"\",\"\",'LISTE ENGAGES'!D28)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E28=\"\",\"\",'LISTE ENGAGES'!E28)","v":""},{"$f":"IF('LISTE ENGAGES'!F28=\"\",\"\",'LISTE ENGAGES'!F28)","v":""},{"$f":"IF('LISTE ENGAGES'!G28=\"\",\"\",'LISTE ENGAGES'!G28)","v":""},{"$f":"IF('LISTE ENGAGES'!H28=\"\",\"\",'LISTE ENGAGES'!H28)","v":18},{"$f":"IF('LISTE ENGAGES'!I28=\"\",\"\",'LISTE ENGAGES'!I28)","v":""},{"$f":"IF('LISTE ENGAGES'!J28=\"\",\"\",'LISTE ENGAGES'!J28)","v":""},{"$f":"IF('LISTE ENGAGES'!K28=\"\",\"\",'LISTE ENGAGES'!K28)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D29=\"\",\"\",'LISTE ENGAGES'!D29)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E29=\"\",\"\",'LISTE ENGAGES'!E29)","v":""},{"$f":"IF('LISTE ENGAGES'!F29=\"\",\"\",'LISTE ENGAGES'!F29)","v":""},{"$f":"IF('LISTE ENGAGES'!G29=\"\",\"\",'LISTE ENGAGES'!G29)","v":""},{"$f":"IF('LISTE ENGAGES'!H29=\"\",\"\",'LISTE ENGAGES'!H29)","v":19},{"$f":"IF('LISTE ENGAGES'!I29=\"\",\"\",'LISTE ENGAGES'!I29)","v":""},{"$f":"IF('LISTE ENGAGES'!J29=\"\",\"\",'LISTE ENGAGES'!J29)","v":""},{"$f":"IF('LISTE ENGAGES'!K29=\"\",\"\",'LISTE ENGAGES'!K29)","v":""}]
[null,null,{"$f":"IF('LISTE ENGAGES'!D30=\"\",\"\",'LISTE ENGAGES'!D30)","v":"T"},{"$f":"IF('LISTE ENGAGES'!E30=\"\",\"\",'LISTE ENGAGES'!E30)","v":""},{"$f":"IF('LISTE ENGAGES'!F30=\"\",\"\",'LISTE ENGAGES'!F30)","v":""},{"$f":"IF('LISTE ENGAGES'!G30=\"\",\"\",'LISTE ENGAGES'!G30)","v":""},{"$f":"IF('LISTE ENGAGES'!H30=\"\",\"\",'LISTE ENGAGES'!H30)","v":20},{"$f":"IF('LISTE ENGAGES'!I30=\"\",\"\",'LISTE ENGAGES'!I30)","v":""},{"$f":"IF('LISTE ENGAGES'!J30=\"\",\"\",'LISTE ENGAGES'!J30)","v":""},{"$f":"IF('LISTE ENGAGES'!K30=\"\",\"\",'LISTE ENGAGES'!K30)","v":""}]
[]
[]
[]
[]
[null,null,"REMARQUES :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SIGNATURES :"]