{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Contrôle","Notice d'utilisation","Feuille de Score","Feuille de match","Cumul Club","Cumul Joueur","Classement équipes","Participations"],"not_rendered":{"images":1,"macros":1,"defined_names":88},"read":"whole","date_system":"1900"}

{"sheet":"Contrôle","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"hidden":true}
["Index max série Blanc-Bleu","Saison","SSJ","VériFication Lille","Vérification Saint Omer","VériFication Béthune","VériFication Vert parc","VériFication Mérignies","Liste des clubs","Liste capitaine","Libellé Vert Parc","Libellé Saint Omer/Béthune/ Ruminghem","Liste validation Scratch","Index max ZTA"]
[15.4,null,null,"LILLE METROPOLE","ST OMER ST OMER BETHUNE RUMINGHEM","BETHUNE","VERT PARC","MERIGNIES",null,null,{"$f":"I14","v":"VERT PARC"},{"$f":"I12","v":"ST OMER/BETHUNE/RUMINGHEM"},"Oui",18.45]
[null,1,-1,{"$nulls":5},"BOIS DES RETZ","David GODZECKI",null,null,"Non"]
[null,2,0,{"$nulls":5},"CAMBRESIS","Olivier TELLE"]
[null,3,1,{"$nulls":5},"DUNKERQUE","Philippe DUREUX"]
[null,4,2,{"$nulls":5},"LILLE-ALBATROS","Jérôme OFFROY"]
[null,5,{"$nulls":6},"LILLE-BIRDIE","Michel BONNET"]
[null,6,{"$nulls":6},"MERIGNIES-NOVA","Yves FOUTRY"]
[{"$nulls":8},"MERIGNIES-TECK","Hervé FROMENTIN"]
[{"$nulls":8},"MORMAL","Jacques DEMAREZ"]
[{"$nulls":8},"OLHAIN","Didier DIETHMANN"]
[{"$nulls":8},"ST OMER/BETHUNE/RUMINGHEM","Hervé MOLMY / Eric GANACHAUD / Rémy JOONNEKIN"]
[{"$nulls":8},"THUMERIES","Régine GOSTEAU"]
[{"$nulls":8},"VERT PARC","Philippe BIALAIS"]

{"sheet":"Notice d'utilisation","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"merged":[[14,1,14,2],[16,1,16,4]]}
[]
[null,"Ce classeur a pour objectif de générer automatiquement une feuille de match."]
[]
[null,"Suivre scrupuleusement les opérations suivantes :"]
[]
[null,"A) - Ouvrir l'onglet ''Feuille de score''"]
[null,"1 - Sélectionner le numéro du tour dans la liste déroulante"]
[]
[null,"2 - Sélectionner le nom du Club-hôte dans la liste déroulante"]
[]
[null,"3 - Importer les résultats BRUTS (document EXCEL issu du système de la FFG)"]
[]
[null,"4 - Importer les résultats NETS (document EXCEL issu du système de la FFG)"]
[]
[null,"      a) - Si un ou plusieurs noms d'équipe apparaissent sur fond rouge, corriger chaque tableau en mettant le nom de l'équipe que le joueur a représenté."]
[null,"      b) - Si des joueurs n'ont pas été retenus par le capitaine pour la participation aux classements d'équipe, il suffit de taper ou de "]
[null,"             sélectionner ''Oui'' dans la colonne \"Joueur scratché\" des résultats nets sur les lignes des joueurs concernés, il seront scratchés automatiquement dans l'autre tableau."]
[null,"             Tout joueur scratché aux classements d'équipes, participe néanmoins au classement individuel."]
[]
[null,"5 - Générer les cumuls (et seulement lorsque toutes les opérations précédentes sont faites). La feuille de match va s'établir automatiquement."]
[null,"      Excel vous proposera d'enregistrer la feuille de match générée, pensez à l'enregistrer sous un autre nom pour ne pas perdre le modèle."]
[]
[null,"B) - Ouvrir l'onglet ''Feuille de match''"]
[null,"6 - Sur la feuille de match ainsi générée, il ne reste plus qu'à indiquer la date de la rencontre et vos observations dans les cases prévues à cet effet."]
[]
[null,"7 - Enregistrer votre feuille de match sous un autre nom, afin de ne pas perdre le modèle d'origine."]

{"sheet":"Feuille de Score","index":2,"n_rows":13,"n_cols":18,"rows_kept":13,"merged":[[1,14,1,15],[3,3,3,7],[11,1,11,8],[11,10,11,17]]}
[null,"nombre joueur Net",null,"Nom de la feuille","Nom du fichier résultat","Tour","Index SSJ","Index Club hôte",null,null,"nombre joueur brut",null,"SSJ","Nombre tour","Date de la rencontre"]
[null,{"$f":"COUNTA(B14:B7702)","v":0},null,{"$f":"RIGHT(CELL(\"NomFichier\",NomFeuilleResultatTour),LEN(CELL(\"NomFichier\",NomFeuilleResultatTour))-SEARCH(\"]\",CELL(\"NomFichier\",NomFeuilleResultatTour)))","v":"Feuille de Score"},{"$f":"CELL(\"NomFichier\",NomFeuilleResultatTour)","v":"https://d.docs.live.net/09781062b7f16d61/Documents/Golf/BYT site documents 2024/[Calcul-d-une-feuille-de-match-avec-RMS9.1.0.xlsm]Feuille de Score"},{"$f":"IndexTour-1","v":0},1,1,1,null,{"$f":"COUNTA(K14:K7702)","v":0},null,0,{"$f":"MAX(LstSaison)","v":6}," 08/04/2022"]
[]
[{"$nulls":3},"Lire attentivement la notice d'utilisation"]
[]
[{"$nulls":3},"Tour à importer"]
[]
[]
[]
[{"$nulls":3},"Club Hôte"]
[]
[null,"RESULTATS NETS",{"$nulls":8},"RESULTATS BRUTS"]
[null,"Tour","Rang","Nom - Prénom","Club","Index","Série","Score net","Joueur Scratché",null,"Tour","Rang","Nom- Prénom","Club","Index","Série","Score brut","Joueur Scratché"]

{"sheet":"Feuille de match","index":3,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[1,4,1,8],[5,4,5,8],[9,3,9,4],[10,3,10,4],[12,6,12,7],[14,2,14,4],[14,6,14,8],[21,2,21,4],[21,6,21,8],[32,4,32,6],[36,2,36,3],[36,4,36,8],[37,2,37,3],[37,4,37,8]]}
[]
[{"$nulls":4},"Cette feuille se génére automatiquement par la feuille de score,                         seules les cases ''date'' et ''observations'' sont à remplir"]
[]
[]
[]
[{"$nulls":4},"BY TROPHY 2024 - FEUILLE DE MATCH"]
[]
[{"$nulls":3},"Tour n° :",{"$f":"Tour","v":0},"CLUB-HOTE","CLUB n° 2","CLUB n° 3"]
[{"$nulls":3},"Date :",null,{"$f":"INDEX(LstClub,IndexClubHote)","v":0}]
[{"$nulls":3},"Nbre joueurs en ''serie BB''",null,{"$f":"IF(ISNA(HLOOKUP(F$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(F$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+1,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(G$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(G$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+1,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(H$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+1,FALSE))","v":""},{"$f":"SUM(F10:H10)","v":0}]
[{"$nulls":3},"Nbre joueurs en ''serie JR''",null,{"$f":"IF(ISNA(HLOOKUP(F$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(F$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+2,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(G$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(G$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+2,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(H$9,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+2,FALSE))","v":""},{"$f":"SUM(F11:H11)","v":0}]
[{"$nulls":8},"x 3 € ="]
[{"$nulls":6},"Montant total droits de jeu ",null,{"$f":"PRODUCT(3*SUM(I10:I11))","v":{"v":0,"d":"0 €"}}]
[]
[null,null,"SERIE ''B B'' (Index < ou = à 15,4) - RESULTATS BRUTS",{"$nulls":3},"SERIE ''B B''  (Index < ou = à 15,4) - RESULTATS NETS"]
[null,null,{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0},null,{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+3,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+3,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+3,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+3,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+3,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+3,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+6,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+6,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+6,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+6,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+6,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+6,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+4,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+4,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+4,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+4,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+4,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+4,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+7,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+7,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+7,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+7,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+7,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+7,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+5,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+5,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+5,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+5,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+5,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+5,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+8,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+8,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+8,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+8,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+8,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+8,FALSE))","v":""}]
[null,null,{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},{"$f":"SUM(E17:E19)","v":0},null,{"$f":"SUM(G17:G19)","v":0},{"$f":"SUM(H17:H19)","v":0},{"$f":"SUM(I17:I19)","v":0}]
[]
[null,null,"SERIE ''J R'' (index de 15,5 à 36,0) - RESULTATS BRUTS",{"$nulls":3},"SERIE ''J R''  (index de 15,5 à 36,0)  - RESULTATS NETS"]
[null,null,{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0},null,{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+9,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+9,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+9,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+9,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+9,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+9,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+16,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+16,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+16,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+16,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+16,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+16,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+10,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+10,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+10,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+10,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+10,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+10,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+17,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+17,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+17,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+17,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+17,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+17,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+11,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+11,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+11,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+11,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+11,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+11,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+18,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+18,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+18,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+18,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+18,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+18,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+12,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+12,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+12,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+12,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+12,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+12,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+19,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+19,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+19,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+19,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+19,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+19,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+13,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+13,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+13,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+13,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+13,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+13,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+20,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+20,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+20,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+20,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+20,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+20,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+14,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+14,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+14,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+14,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+14,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+14,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+21,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+21,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+21,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+21,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+21,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+21,FALSE))","v":""}]
[null,null,{"$f":"IF(ISNA(HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+15,FALSE)),\"\",HLOOKUP(C$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+15,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+15,FALSE)),\"\",HLOOKUP(D$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+15,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+15,FALSE)),\"\",HLOOKUP(E$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+15,FALSE))","v":""},null,{"$f":"IF(ISNA(HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+22,FALSE)),\"\",HLOOKUP(G$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+22,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+22,FALSE)),\"\",HLOOKUP(H$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+22,FALSE))","v":""},{"$f":"IF(ISNA(HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+22,FALSE)),\"\",HLOOKUP(I$16,TableauCumulClub,MATCH(\"Tour \" & TourFeuilleMatch,ColTourTableauCumulClub,0)+22,FALSE))","v":""}]
[null,null,{"$f":"SUM(C24:C30)","v":0},{"$f":"SUM(D24:D30)","v":0},0,null,{"$f":"SUM(G24:G30)","v":0},0,0]
[]
[{"$nulls":4},"CUMUL DES POINTS ''BRUTS et NETS'' des 2 SERIES"]
[{"$nulls":4},{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0}]
[{"$nulls":4},{"$f":"SUM(C20,G20,C31,G31)","v":0},{"$f":"SUM(D20,H20,D31,H31)","v":0},{"$f":"SUM(E20,I20,E31,I31)","v":0}]
[]
[null,null,"Visa capitaine du club-hôte :",null,"Observations"]
[null,null,{"$f":"VLOOKUP(ClubHote,Contrôle!I2:J14,2,FALSE)","v":{"$error":"#N/A"}},null,"RAS"]

{"sheet":"Cumul Club","index":4,"n_rows":175,"n_cols":17,"rows_kept":175,"hidden":true,"merged":[[8,1,34,1],[8,2,8,4],[9,2,9,4],[10,2,15,2],[10,3,12,3],[13,3,15,3],[16,2,29,2],[16,3,22,3],[23,3,29,3],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[36,1,62,1],[36,2,36,4],[37,2,37,4],[38,2,43,2],[38,3,40,3],[41,3,43,3],[44,2,57,2],[44,3,50,3],[51,3,57,3],[58,2,58,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[64,1,90,1],[64,2,64,4],[65,2,65,4],[66,2,71,2],[66,3,68,3],[69,3,71,3],[72,2,85,2],[72,3,78,3],[79,3,85,3],[86,2,86,4],[87,2,87,4],[88,2,88,4],[89,2,89,4],[90,2,90,4],[92,1,118,1],[92,2,92,4],[93,2,93,4],[94,2,99,2],[94,3,96,3],[97,3,99,3],[100,2,113,2],[100,3,106,3],[107,3,113,3],[114,2,114,4],[115,2,115,4],[116,2,116,4],[117,2,117,4],[118,2,118,4],[120,1,146,1],[120,2,120,4],[121,2,121,4],[122,2,127,2],[122,3,124,3],[125,3,127,3],[128,2,141,2],[128,3,134,3],[135,3,141,3],[142,2,142,4],[143,2,143,4],[144,2,144,4],[145,2,145,4],[146,2,146,4],[148,1,174,1],[148,2,148,4],[149,2,149,4],[150,2,155,2],[150,3,152,3],[153,3,155,3],[156,2,169,2],[156,3,162,3],[163,3,169,3],[170,2,170,4],[171,2,171,4],[172,2,172,4],[173,2,173,4],[174,2,174,4]]}
[{"$f":"RIGHT(CELL(\"NomFichier\",NomFeuilleCumulClub),LEN(CELL(\"NomFichier\",NomFeuilleCumulClub))-SEARCH(\"]\",CELL(\"NomFichier\",NomFeuilleCumulClub)))","v":"Cumul Club"}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"BOIS DES RETZ","CAMBRESIS","DUNKERQUE","LILLE-ALBATROS","LILLE-BIRDIE","MERIGNIES-NOVA","MERIGNIES-TECK","MORMAL","OLHAIN","ST OMER/BETHUNE/RUMINGHEM","THUMERIES","VERT PARC"]
[null,"Tour 1","Nombre de joueurs BB"]
[null,null,"Nombre de joueurs JR"]
[null,null,"Cartes Blanc - Bleu","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[null,null,"Cartes Jaune - Rouge","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[null,null,"Total Brut Blanc - Bleu",null,null,{"$f":"SUM(F11:F13)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Blanc - Bleu",null,null,{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut Jaune - Rouge",null,null,{"$f":"SUM(F17:F23)","v":0},{"$f":"SUM(G17:G23)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Jaune - Rouge",null,null,{"$f":"SUM(F24:F30)","v":0},{"$f":"SUM(G24:G30)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut + Net - BB + JR",null,null,{"$f":"SUM(F31:F34)","v":0},{"$f":"SUM(G31:G34)","v":0},{"$f":"SUM(H31:H34)","v":0},{"$f":"SUM(I31:I34)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(Q31:Q34)","v":0}]
[]
[null,"Tour 2","Nombre de joueurs BB"]
[null,null,"Nombre de joueurs JR"]
[null,null,"Cartes Blanc - Bleu","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[null,null,"Cartes Jaune - Rouge","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[null,null,"Total Brut Blanc - Bleu",null,null,{"$f":"SUM(F39:F41)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Blanc - Bleu",null,null,{"$f":"SUM(F42:F44)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut Jaune - Rouge",null,null,{"$f":"SUM(F45:F51)","v":0},{"$f":"SUM(G45:G51)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Jaune - Rouge",null,null,{"$f":"SUM(F52:F58)","v":0},{"$f":"SUM(G52:G58)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut + Net - BB + JR",null,null,{"$f":"SUM(F59:F62)","v":0},{"$f":"SUM(G59:G62)","v":0},{"$f":"SUM(H59:H62)","v":0},{"$f":"SUM(I59:I62)","v":0},{"$f":"SUM(J59:J62)","v":0},{"$f":"SUM(K59:K62)","v":0},{"$f":"SUM(L59:L62)","v":0},{"$f":"SUM(M59:M62)","v":0},{"$f":"SUM(N59:N62)","v":0},{"$f":"SUM(O59:O62)","v":0},{"$f":"SUM(P59:P62)","v":0},0]
[]
[null,"Tour 3","Nombre de joueurs BB"]
[null,null,"Nombre de joueurs JR"]
[null,null,"Cartes Blanc - Bleu","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[null,null,"Cartes Jaune - Rouge","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[null,null,"Total Brut Blanc - Bleu",null,null,{"$f":"SUM(F67:F69)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Blanc - Bleu",null,null,{"$f":"SUM(F70:F72)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut Jaune - Rouge",null,null,{"$f":"SUM(F73:F79)","v":0},{"$f":"SUM(G73:G79)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Jaune - Rouge",null,null,{"$f":"SUM(F80:F86)","v":0},{"$f":"SUM(G80:G86)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut + Net - BB + JR",null,null,{"$f":"SUM(F87:F90)","v":0},{"$f":"SUM(G87:G90)","v":0},{"$f":"SUM(H87:H90)","v":0},{"$f":"SUM(I87:I90)","v":0},{"$f":"SUM(J87:J90)","v":0},{"$f":"SUM(K87:K90)","v":0},{"$f":"SUM(L87:L90)","v":0},{"$f":"SUM(M87:M90)","v":0},{"$f":"SUM(N87:N90)","v":0},{"$f":"SUM(O87:O90)","v":0},{"$f":"SUM(P87:P90)","v":0},0]
[]
[null,"Tour 4","Nombre de joueurs BB"]
[null,null,"Nombre de joueurs JR"]
[null,null,"Cartes Blanc - Bleu","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[null,null,"Cartes Jaune - Rouge","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[null,null,"Total Brut Blanc - Bleu",null,null,{"$f":"SUM(F95:F97)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Blanc - Bleu",null,null,{"$f":"SUM(F98:F100)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut Jaune - Rouge",null,null,{"$f":"SUM(F101:F107)","v":0},{"$f":"SUM(G101:G107)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Jaune - Rouge",null,null,{"$f":"SUM(F108:F114)","v":0},{"$f":"SUM(G108:G114)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut + Net - BB + JR",null,null,{"$f":"SUM(F115:F118)","v":0},{"$f":"SUM(G115:G118)","v":0},{"$f":"SUM(H115:H118)","v":0},{"$f":"SUM(I115:I118)","v":0},{"$f":"SUM(J115:J118)","v":0},{"$f":"SUM(K115:K118)","v":0},{"$f":"SUM(L115:L118)","v":0},{"$f":"SUM(M115:M118)","v":0},{"$f":"SUM(N115:N118)","v":0},{"$f":"SUM(O115:O118)","v":0},{"$f":"SUM(P115:P118)","v":0},0]
[]
[null,"Tour 5","Nombre de joueurs BB"]
[null,null,"Nombre de joueurs JR"]
[null,null,"Cartes Blanc - Bleu","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[null,null,"Cartes Jaune - Rouge","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[null,null,"Total Brut Blanc - Bleu",null,null,{"$f":"SUM(F123:F125)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Blanc - Bleu",null,null,{"$f":"SUM(F126:F128)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut Jaune - Rouge",null,null,{"$f":"SUM(F129:F135)","v":0},{"$f":"SUM(G129:G135)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Jaune - Rouge",null,null,{"$f":"SUM(F136:F142)","v":0},{"$f":"SUM(G136:G142)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut + Net - BB + JR",null,null,{"$f":"SUM(F143:F146)","v":0},{"$f":"SUM(G143:G146)","v":0},{"$f":"SUM(H143:H146)","v":0},{"$f":"SUM(I143:I146)","v":0},{"$f":"SUM(J143:J146)","v":0},{"$f":"SUM(K143:K146)","v":0},{"$f":"SUM(L143:L146)","v":0},{"$f":"SUM(M143:M146)","v":0},{"$f":"SUM(N143:N146)","v":0},{"$f":"SUM(O143:O146)","v":0},{"$f":"SUM(P143:P146)","v":0},0]
[]
[null,"Tour 6","Nombre de joueurs BB"]
[null,null,"Nombre de joueurs JR"]
[null,null,"Cartes Blanc - Bleu","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[null,null,"Cartes Jaune - Rouge","Brut",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[{"$nulls":3},"Net",1]
[{"$nulls":4},2]
[{"$nulls":4},3]
[{"$nulls":4},4]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7]
[null,null,"Total Brut Blanc - Bleu",null,null,{"$f":"SUM(F151:F153)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Blanc - Bleu",null,null,{"$f":"SUM(F154:F156)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut Jaune - Rouge",null,null,{"$f":"SUM(F157:F163)","v":0},{"$f":"SUM(G157:G163)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Net Jaune - Rouge",null,null,{"$f":"SUM(F164:F170)","v":0},{"$f":"SUM(G164:G170)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Total Brut + Net - BB + JR",null,null,{"$f":"SUM(F171:F174)","v":0},{"$f":"SUM(G171:G174)","v":0},{"$f":"SUM(H171:H174)","v":0},{"$f":"SUM(I171:I174)","v":0},{"$f":"SUM(J171:J174)","v":0},{"$f":"SUM(K171:K174)","v":0},{"$f":"SUM(L171:L174)","v":0},{"$f":"SUM(M171:M174)","v":0},{"$f":"SUM(N171:N174)","v":0},{"$f":"SUM(O171:O174)","v":0},{"$f":"SUM(P171:P174)","v":0},0]

{"sheet":"Cumul Joueur","index":5,"n_rows":4,"n_cols":31,"rows_kept":4,"hidden":true,"merged":[[2,4,2,7],[2,8,2,11],[2,12,2,15],[2,16,2,19],[2,20,2,23],[2,24,2,27]]}
[{"$f":"RIGHT(CELL(\"NomFichier\",NomFeuilleCumulJoueur),LEN(CELL(\"NomFichier\",NomFeuilleCumulJoueur))-SEARCH(\"]\",CELL(\"NomFichier\",NomFeuilleCumulJoueur)))","v":"Cumul Joueur"},{"$f":"COUNTA(B5:B4197)","v":0}]
[]
[{"$nulls":4},"Tour 1",{"$nulls":3},"Tour 2",{"$nulls":3},"Tour 3",{"$nulls":3},"Tour 4",{"$nulls":3},"Tour 5",{"$nulls":3},"Tour 6"]
[null,"Nom - Prénom","Club","Série","Rang Brut","Score Brut","Rang Net","Score Net","Rang Brut","Score Brut","Rang Net","Score Net","Rang Brut","Score Brut","Rang Net","Score Net","Rang Brut","Score Brut","Rang Net","Score Net","Rang Brut","Score Brut","Rang Net","Score Net","Rang Brut","Score Brut","Rang Net","Score Net","Total Brut","Total Net","Total Brut + Net"]

{"sheet":"Classement équipes","index":6,"n_rows":26,"n_cols":16,"rows_kept":26,"hidden":true,"merged":[[9,4,9,5],[9,7,9,12],[11,1,11,5],[11,7,11,11],[11,13,11,15],[12,1,13,1],[12,2,12,3],[12,4,12,5],[12,7,13,7],[12,8,12,9],[12,10,12,11],[12,13,12,15],[27,4,27,5],[27,7,27,12],[30,2,36,2],[38,2,44,2],[46,2,46,3]]}
[{"$f":"RIGHT(CELL(\"NomFichier\",NomFeuilleClassementEquipes),LEN(CELL(\"NomFichier\",NomFeuilleClassementEquipes))-SEARCH(\"]\",CELL(\"NomFichier\",NomFeuilleClassementEquipes)))","v":"Classement équipes"}]
{"$rows_empty":8}
[{"$nulls":4},"Saison 2023",null,null,"LES CLASSEMENTS DES EQUIPES après le tour n° ",{"$nulls":5},1]
[]
[null,"SERIE ‘‘BB’’ (index < et = à 15,4)",{"$nulls":5},"SERIE ‘‘JR’’ (index = et > à 15,5)",{"$nulls":5},"SERIES ''BB'' et ''JR''"]
[null,"Places","Classement Brut",null,"Classement Net",null,null,"Places","Classement Brut",null,"Classement Net",null,null,"Classement Cumul des points"]
[null,null,"Equipes","Points","Equipes","Points",null,null,"Equipes","Points","Equipes","Points",null,"Places","Equipes","Points"]
[null,1,{"$f":"Contrôle!I3","v":"BOIS DES RETZ"},{"$f":"IF(ISNA(HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+23,FALSE)),\"\",HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+23,FALSE))*(TourClassementEquipe>=1)+ IF(ISNA(HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+23,FALSE)),\"\",HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+23,FALSE))*(TourClassementEquipe>=2)+ IF(ISNA(HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+23,FALSE)),\"\",HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+23,FALSE))*(TourClassementEquipe>=3)+ IF(ISNA(HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+23,FALSE)),\"\",HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+23,FALSE))*(TourClassementEquipe>=4)+ IF(ISNA(HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+23,FALSE)),\"\",HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+23,FALSE))*(TourClassementEquipe>=5)+ IF(ISNA(HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+23,FALSE)),\"\",HLOOKUP(C15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+23,FALSE))*(TourClassementEquipe>=6)","v":0},{"$f":"Contrôle!I3","v":"BOIS DES RETZ"},{"$f":"IF(ISNA(HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+24,FALSE)),\"\",HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+24,FALSE))*(TourClassementEquipe>=1)+ IF(ISNA(HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+24,FALSE)),\"\",HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+24,FALSE))*(TourClassementEquipe>=2)+ IF(ISNA(HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+24,FALSE)),\"\",HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+24,FALSE))*(TourClassementEquipe>=3)+ IF(ISNA(HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+24,FALSE)),\"\",HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+24,FALSE))*(TourClassementEquipe>=4)+ IF(ISNA(HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+24,FALSE)),\"\",HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+24,FALSE))*(TourClassementEquipe>=5)+ IF(ISNA(HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+24,FALSE)),\"\",HLOOKUP(E15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+24,FALSE))*(TourClassementEquipe>=6)","v":0},null,1,{"$f":"Contrôle!I3","v":"BOIS DES RETZ"},{"$f":"IF(ISNA(HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+25,FALSE)),\"\",HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+25,FALSE))*(TourClassementEquipe>=1)+ IF(ISNA(HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+25,FALSE)),\"\",HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+25,FALSE))*(TourClassementEquipe>=2)+ IF(ISNA(HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+25,FALSE)),\"\",HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+25,FALSE))*(TourClassementEquipe>=3)+ IF(ISNA(HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+25,FALSE)),\"\",HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+25,FALSE))*(TourClassementEquipe>=4)+ IF(ISNA(HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+25,FALSE)),\"\",HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+25,FALSE))*(TourClassementEquipe>=5)+ IF(ISNA(HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+25,FALSE)),\"\",HLOOKUP(I15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+25,FALSE))*(TourClassementEquipe>=6)","v":0},{"$f":"Contrôle!I3","v":"BOIS DES RETZ"},{"$f":"IF(ISNA(HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+26,FALSE)),\"\",HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+26,FALSE))*(TourClassementEquipe>=1)+ IF(ISNA(HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+26,FALSE)),\"\",HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+26,FALSE))*(TourClassementEquipe>=2)+ IF(ISNA(HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+26,FALSE)),\"\",HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+26,FALSE))*(TourClassementEquipe>=3)+ IF(ISNA(HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+26,FALSE)),\"\",HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+26,FALSE))*(TourClassementEquipe>=4)+ IF(ISNA(HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+26,FALSE)),\"\",HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+26,FALSE))*(TourClassementEquipe>=5)+ IF(ISNA(HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+26,FALSE)),\"\",HLOOKUP(K15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+26,FALSE))*(TourClassementEquipe>=6)","v":0},null,1,{"$f":"Contrôle!I3","v":"BOIS DES RETZ"},{"$f":"IF(ISNA(HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+27,FALSE)),\"\",HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+27,FALSE))*(TourClassementEquipe>=1)+ IF(ISNA(HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+27,FALSE)),\"\",HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+27,FALSE))*(TourClassementEquipe>=2)+ IF(ISNA(HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+27,FALSE)),\"\",HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+27,FALSE))*(TourClassementEquipe>=3)+ IF(ISNA(HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+27,FALSE)),\"\",HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+27,FALSE))*(TourClassementEquipe>=4)+ IF(ISNA(HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+27,FALSE)),\"\",HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+27,FALSE))*(TourClassementEquipe>=5)+ IF(ISNA(HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+27,FALSE)),\"\",HLOOKUP(O15,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+27,FALSE))*(TourClassementEquipe>=6)","v":0}]
[null,2,{"$f":"Contrôle!I4","v":"CAMBRESIS"},0,{"$f":"Contrôle!I4","v":"CAMBRESIS"},0,null,2,{"$f":"Contrôle!I4","v":"CAMBRESIS"},0,{"$f":"Contrôle!I4","v":"CAMBRESIS"},0,null,2,{"$f":"Contrôle!I4","v":"CAMBRESIS"},0]
[null,3,{"$f":"Contrôle!I5","v":"DUNKERQUE"},0,{"$f":"Contrôle!I5","v":"DUNKERQUE"},0,null,3,{"$f":"Contrôle!I5","v":"DUNKERQUE"},0,{"$f":"Contrôle!I5","v":"DUNKERQUE"},0,null,3,{"$f":"Contrôle!I5","v":"DUNKERQUE"},0]
[null,4,{"$f":"Contrôle!I6","v":"LILLE-ALBATROS"},0,{"$f":"Contrôle!I6","v":"LILLE-ALBATROS"},0,null,4,{"$f":"Contrôle!I6","v":"LILLE-ALBATROS"},0,{"$f":"Contrôle!I6","v":"LILLE-ALBATROS"},0,null,4,{"$f":"Contrôle!I6","v":"LILLE-ALBATROS"},0]
[null,5,{"$f":"Contrôle!I7","v":"LILLE-BIRDIE"},0,{"$f":"Contrôle!I7","v":"LILLE-BIRDIE"},0,null,5,{"$f":"Contrôle!I7","v":"LILLE-BIRDIE"},0,{"$f":"Contrôle!I7","v":"LILLE-BIRDIE"},0,null,5,{"$f":"Contrôle!I7","v":"LILLE-BIRDIE"},0]
[null,6,{"$f":"Contrôle!I8","v":"MERIGNIES-NOVA"},0,{"$f":"Contrôle!I8","v":"MERIGNIES-NOVA"},0,null,6,{"$f":"Contrôle!I8","v":"MERIGNIES-NOVA"},0,{"$f":"Contrôle!I8","v":"MERIGNIES-NOVA"},0,null,6,{"$f":"Contrôle!I8","v":"MERIGNIES-NOVA"},0]
[null,7,{"$f":"Contrôle!I9","v":"MERIGNIES-TECK"},0,{"$f":"Contrôle!I9","v":"MERIGNIES-TECK"},0,null,7,{"$f":"Contrôle!I9","v":"MERIGNIES-TECK"},0,{"$f":"Contrôle!I9","v":"MERIGNIES-TECK"},0,null,7,{"$f":"Contrôle!I9","v":"MERIGNIES-TECK"},0]
[null,8,{"$f":"Contrôle!I10","v":"MORMAL"},0,{"$f":"Contrôle!I10","v":"MORMAL"},0,null,8,{"$f":"Contrôle!I10","v":"MORMAL"},0,{"$f":"Contrôle!I10","v":"MORMAL"},0,null,8,{"$f":"Contrôle!I10","v":"MORMAL"},0]
[null,9,{"$f":"Contrôle!I11","v":"OLHAIN"},0,{"$f":"Contrôle!I11","v":"OLHAIN"},0,null,9,{"$f":"Contrôle!I11","v":"OLHAIN"},0,{"$f":"Contrôle!I11","v":"OLHAIN"},0,null,9,{"$f":"Contrôle!I11","v":"OLHAIN"},0]
[null,10,{"$f":"Contrôle!I12","v":"ST OMER/BETHUNE/RUMINGHEM"},0,{"$f":"Contrôle!I12","v":"ST OMER/BETHUNE/RUMINGHEM"},0,null,10,{"$f":"Contrôle!I12","v":"ST OMER/BETHUNE/RUMINGHEM"},0,{"$f":"Contrôle!I12","v":"ST OMER/BETHUNE/RUMINGHEM"},0,null,10,{"$f":"Contrôle!I12","v":"ST OMER/BETHUNE/RUMINGHEM"},0]
[null,11,{"$f":"Contrôle!I13","v":"THUMERIES"},0,{"$f":"Contrôle!I13","v":"THUMERIES"},0,null,11,{"$f":"Contrôle!I13","v":"THUMERIES"},0,{"$f":"Contrôle!I13","v":"THUMERIES"},0,null,11,{"$f":"Contrôle!I13","v":"THUMERIES"},0]
[null,12,{"$f":"Contrôle!I14","v":"VERT PARC"},0,{"$f":"Contrôle!I14","v":"VERT PARC"},0,null,12,{"$f":"Contrôle!I14","v":"VERT PARC"},0,{"$f":"Contrôle!I14","v":"VERT PARC"},0,null,12,{"$f":"Contrôle!I14","v":"VERT PARC"},0]

{"sheet":"Participations","index":7,"n_rows":23,"n_cols":16,"rows_kept":23,"hidden":true,"merged":[[3,1,3,2],[3,3,3,4],[3,6,3,10],[6,1,12,1],[14,1,20,1],[22,1,22,2]]}
[]
[]
[]
[{"$nulls":3},"Saison 2023",null,null,"     NOMBRE DE PARTICIPANTS après le tour n° ",{"$nulls":4},1]
[]
[{"$nulls":3},{"$f":"Contrôle!I3","v":"BOIS DES RETZ"},{"$f":"Contrôle!I4","v":"CAMBRESIS"},{"$f":"Contrôle!I5","v":"DUNKERQUE"},{"$f":"Contrôle!I6","v":"LILLE-ALBATROS"},{"$f":"Contrôle!I7","v":"LILLE-BIRDIE"},{"$f":"Contrôle!I8","v":"MERIGNIES-NOVA"},{"$f":"Contrôle!I9","v":"MERIGNIES-TECK"},{"$f":"Contrôle!I10","v":"MORMAL"},{"$f":"Contrôle!I11","v":"OLHAIN"},{"$f":"Contrôle!I12","v":"ST OMER/BETHUNE/RUMINGHEM"},{"$f":"Contrôle!I13","v":"THUMERIES"},{"$f":"Contrôle!I14","v":"VERT PARC"},"TOTAUX"]
[null,"série BB","Tour 1",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+1,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D7:O7)","v":0}]
[null,null,"Tour 2",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+1,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D8:O8)","v":0}]
[null,null,"Tour 3",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+1,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 4",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+1,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 5",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+1,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 6",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+1,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+1,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"S/Total",{"$f":"SUM(D7:D12)","v":0},{"$f":"SUM(E7:E12)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(N7:N12)","v":0},0,{"$f":"SUM(D13:O13)","v":0}]
[]
[null,"série JR","Tour 1",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 1\",ColTourTableauCumulClub,0)+2,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D15:O15)","v":0}]
[null,null,"Tour 2",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 2\",ColTourTableauCumulClub,0)+2,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 3",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 3\",ColTourTableauCumulClub,0)+2,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 4",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 4\",ColTourTableauCumulClub,0)+2,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 5",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 5\",ColTourTableauCumulClub,0)+2,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Tour 6",{"$f":"IF(ISNA(HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+2,FALSE)),\"\",HLOOKUP(D$6,TableauCumulClub,MATCH(\"Tour 6\",ColTourTableauCumulClub,0)+2,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"S/Total",{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(N15:N20)","v":0},0,{"$f":"SUM(D21:O21)","v":0}]
[]
[null,"Total participations",null,{"$f":"SUM(D13,D21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]