{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Parcours","Joueurs","Poules","Tournoi","Feuille de match","Joueur 1","Joueur 2","Indiv"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":55,"comments":2,"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":"Instructions","index":0,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[" "]
[null,"Bienvenue sur le Challenge 35",null,null,"Cuvée :",2018]
[null,null,"Les joueurs participant à ce Challenge sont listés dans l'onglet Joueurs."]
[null,null,"Ils sont listés par ordre d'index, et alphabétique en cas d'index égal."]
[null,null,"Cet ordre détermine la répartion initiale dans les 4 poules automatiquement."]
[]
[null,"1ère manche : poules"]
[null,null,"La liste des rencontres est dans l'onglet Poules."]
[null,null,"Pour chaque rencontre est indiqué le nombre de coups reçus par le jour d'index le plus faible, pour 9 et 18 trous."]
[null,null,"Pour un 18 trous, il est égal à 75% de la différence d'index, arrondi à la valeur entière la plus proche, avec un maximum de 27."]
[null,null,"La rencontre peut être partagée."]
[]
[null,"2ème manche : élimination"]
[null,null,"A la fin des matchs de poule, les 2 premiers de chaque poule intègrent un tournoi à élimination directe."]
[null,null,"Ce tableau est rempli automatiquement avec les résultats des poules."]
[null,null,"En cas d'égalité à la fin de 18 trous, la rencontre revient avec 1 UP à celui qui a fait le meilleur score sur les 9 derniers trous, à défaut les 6 derniers, à défaut les 3 derniers."]
[]
[null,"Pour préparer votre feuille de match :"]
[null,null,"Vérifiez que votre parcours est décrit dans l'onglet Parcours. S'il n'y est pas, ajoutez sa description à la fin (ou demandez à l'organisateur)."]
[null,null,"Vérifiez que votre index est à jour dans l'onglet Joueurs. C'est l'index au jour de la rencontre qui doit être pris en compte."]
[null,null,"Dans l'onglet Poules ou Tournoi, sur la ligne de votre rencontre, sélectionnez votre parcours dans la liste déroulante."]
[null,null,"Entrez aussi la date prévue de votre rencontre (optionnel)."]
[null,null,"Dans l'onglet \"Feuille de match\", choisissez votre rencontre dans la liste déroulante."]
[null,null,null,"Les coups reçus sont automatiquement distribués sur les trous dans l'ordre de difficulté des trous."]
[]
[null,null,"Vous pouvez maintenant imprimer votre feuille de match et la remplir pendant votre rencontre."]
[null,null,"Vous pouvez également la remplir sur Excel après la rencontre pour calculer vos positions si vous ne l'avez pas fait pendant la rencontre."]
[null,null,"Une fois remplie (papier ou électronique), transmettez votre feuille à l'organisateur pour mise à jour de la compétition."]
[]
[null,"Bonus :","Vous pouvez aussi avoir vos feuilles de score individuel en stableford dans les onglets Joueur."]
[]
[null,"Comment remplir votre position en match play durant le parcours :"]
[]
[null,null,"Trou",1,2,3,4]
[null,null,"SPIETH"]
[null,null,"Coups",4,5,4,"x"]
[null,null,"Position ","1 UP","AS","AS"]
[null,null,"DUBUISSON"]
[null,null,"Coups",6,6,5,5]
[null,null,"Coups reçus ",1,2,1,1]
[null,null,"Position ","","AS","AS","1 UP"]
[]
[null,null,"Trou 1 : Dubuisson a 1 coup rendu, il a donc droit à 1 coup de plus que son adversaire pour gagner le trou."]
[null,null,null,"Mais il fait 2 coups de plus : son adversaire gagne le trou et passe à 1 UP."]
[null,null,"Trou 2 : Cette fois Dubuisson a 2 coups rendus, et ne fait que 1 coup de plus que son adversaire."]
[null,null,null,"Dubuisson gagne le trou, et la position passe à égalité (AS = All Square)."]
[null,null,"Trou 3 : Un coup rendu, Dubuisson fait un coup de plus de son adversaire."]
[null,null,null,"Partage du trou, status quo, la position reste à AS."]
[null,null,"Trou 4 : Un coup rendu, mais Spieth abandonne ou concède le trou."]
[null,null,null,"Dubuisson gagne le trou et passe à 1 UP."]

{"sheet":"Parcours","index":1,"n_rows":94,"n_cols":48,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
["Parcours","Trous","PAR",1,{"$f":"D1+1","v":2},3,4,5,6,7,8,9,{"$f":"L1+1","v":10},{"$f":"M1+1","v":11},12,13,14,15,16,17,18,"Handicap",1,{"$f":"W1+1","v":2},{"$f":"X1+1","v":3},{"$f":"Y1+1","v":4},{"$f":"Z1+1","v":5},{"$f":"AA1+1","v":6},{"$f":"AB1+1","v":7},{"$f":"AC1+1","v":8},{"$f":"AD1+1","v":9},{"$f":"AE1+1","v":10},{"$f":"AF1+1","v":11},{"$f":"AG1+1","v":12},{"$f":"AH1+1","v":13},{"$f":"AI1+1","v":14},{"$f":"AJ1+1","v":15},{"$f":"AK1+1","v":16},{"$f":"AL1+1","v":17},{"$f":"AM1+1","v":18},"Slope blanc","SSS blanc","Slope jaune","SSS jaune","Slope bleu","SSS bleu","Slope rouge","SSS rouge"]
["Ableiges - Les étangs",18,"PAR",4,4,5,3,4,5,4,3,4,5,4,3,4,4,5,4,3,4,"Handicap",4,6,12,8,2,10,16,18,14,13,3,11,5,7,15,1,17,9,139,73.599999999999994,132,71.3,134,74.099999999999994,129,71.400000000000006]
["Apremont",18,"PAR",4,5,3,5,4,4,4,3,4,5,4,3,4,5,4,3,4,4,"Handicap",5,9,15,1,7,17,3,13,11,10,2,16,6,12,4,14,18,8,134,73.099999999999994,124,70,122,73.400000000000006,120,71.3]
["Bellefontaine - Rouge",9,"PAR",4,4,5,3,4,3,4,4,5,null,null,null,null,null,null,null,null,null,"Handicap",8,5,6,9,4,3,2,1,7,null,null,null,null,null,null,null,null,null,64,35.4,63,34.4,64,36.299999999999997,58,34.9]
["Bellefontaine - Jaune Blanc",18,"PAR",4,4,5,4,3,4,3,5,4,4,4,4,3,4,5,3,4,5,"Handicap",17,1,7,3,9,11,15,13,5,18,14,8,6,2,16,10,4,12,128,72.900000000000006,125,70.2,125,72.900000000000006,123,69.8]
["Bellefontaine - Jaune Rouge",18,"PAR",4,4,5,4,3,4,3,5,4,4,4,5,3,4,3,4,4,5,"Handicap",17,1,7,3,9,11,15,13,5,16,10,12,18,8,6,4,2,14,127,72.2,125,70,126,73,120,70]
["Bellême",18,"PAR",5,4,3,4,5,3,4,4,5,4,4,5,4,3,4,3,4,4,"Handicap",14,18,4,2,16,6,8,12,10,1,3,17,9,7,15,5,11,13,135,72.5,127,70.5,125,72.400000000000006,121,70.099999999999994]
["Béthemont",18,"PAR",4,3,4,4,3,5,3,5,5,4,5,4,3,5,4,4,3,4,"Handicap",7,13,1,3,15,9,17,11,5,14,8,6,12,16,2,10,18,4,134,73.099999999999994,122,71.2,131,74.8,126,72.5]
["Boucles de Seine",18,"PAR",4,4,4,3,5,4,3,4,4,4,4,4,4,4,3,4,3,5,"Handicap",6,7,3,15,1,5,18,9,4,8,13,11,12,10,16,14,17,2,129,69.099999999999994,124,67.099999999999994,124,68,120,67.099999999999994]
["Buc",9,"PAR",3,3,3,4,3,3,3,3,3,null,null,null,null,null,null,null,null,null,"Handicap",4,6,3,1,7,5,9,8,2,null,null,null,null,null,null,null,null,null,45,26.1,45,26.1,45,26.2,45,26.2]
["Caen - Plaine Vallon",18,"PAR",4,4,3,4,5,3,4,4,5,4,5,3,4,3,4,5,4,4,"Handicap",6,8,17,7,12,15,1,3,13,5,14,9,2,10,11,16,18,4,130,72.8,123,70.8,129,73.8,125,71.7]
["Cély",18,"PAR",5,4,4,4,3,5,3,4,4,5,4,3,4,4,5,4,3,4,"Handicap",8,16,8,9,3,1,18,7,4,5,15,14,12,11,2,13,17,10,133,72.5,131,70,132,73.3,131,71.099999999999994]
["Cergy-Vauréal",18,"PAR",4,3,4,3,4,3,4,4,5,4,5,3,4,4,4,5,3,5,"Handicap",17,18,10,13,1,14,2,15,5,4,8,16,7,3,12,6,11,9,134,69.400000000000006,120,68.3,123,70.7,118,68.5]
["Champ de Bataille",18,"PAR",4,3,4,5,3,4,4,5,4,5,4,3,4,4,4,5,3,4,"Handicap",9,16,3,1,18,17,11,4,6,12,8,14,2,13,5,10,15,7,139,72.599999999999994,135,71,141,71.400000000000006,128,70.2]
["Chaumont - Bertichères",18,"PAR",4,3,4,4,3,5,4,4,4,4,5,3,4,3,5,4,4,5,"Handicap",7,17,3,11,5,9,1,13,15,8,2,18,12,16,4,6,14,10,144,73.7,138,70.7,135,73.3,135,73.3]
["Courson - Lilas Orange",18,"PAR",4,4,4,3,4,5,4,3,5,5,4,4,4,3,4,4,3,5,"Handicap",8,16,2,14,10,6,4,12,18,17,9,11,15,5,3,1,13,7,135,73.599999999999994,126,71.5,126,72.8,120,70]
["Courson - Vert Lilas",18,"PAR",4,3,4,4,5,4,4,3,5,4,4,4,3,4,5,4,3,5,"Handicap",6,17,15,8,1,3,5,13,10,9,16,2,14,7,11,4,12,18,131,75.599999999999994,126,72.8,127,75,123,71.8]
["Courson - Vert Noir",18,"PAR",4,3,4,4,5,4,4,3,5,4,3,4,4,5,3,4,4,5,"Handicap",7,17,15,9,1,3,5,13,11,2,18,10,12,4,14,8,6,16,131,75.7,126,72.900000000000006,131,74.8,122,71.5]
["Courson - Vert Orange",18,"PAR",4,3,4,4,5,4,4,3,5,5,4,4,4,3,4,4,3,5,"Handicap",7,17,15,9,1,3,5,13,11,18,10,12,16,6,4,2,14,8,142,72.599999999999994,135,71.099999999999994,135,74.099999999999994,126,71.400000000000006]
["Crécy - Vignoly",18,"PAR",4,5,3,4,4,5,4,3,4,5,3,4,5,4,4,3,4,4,"Handicap",11,7,3,15,1,9,5,13,17,16,6,8,10,18,4,14,12,2,142,73.099999999999994,136,70.599999999999994,135,74.400000000000006,127,72.3]
["Dieppe",18,"PAR",4,3,5,4,4,3,4,4,4,3,4,4,4,5,3,5,3,4,"Handicap",17,13,15,1,3,9,7,5,11,18,8,6,2,10,16,4,12,14,131,71.2,127,70,130,72.5,126,71.099999999999994]
["Disneyland - Rouge Bleu",18,"PAR",5,3,5,4,3,5,4,3,4,4,4,4,3,5,3,4,4,5,"Handicap",8,16,4,12,18,2,6,14,10,13,17,5,9,1,15,11,3,7,131,72,123,69.900000000000006,132,72.8,127,70.400000000000006]
["Etiolles - Les Cerfs",18,"PAR",5,4,4,4,3,5,4,5,3,4,4,4,5,4,3,5,3,4,"Handicap",8,12,2,18,10,4,14,6,16,13,7,1,3,17,15,9,11,5,130,71.900000000000006,121,69.5,128,73.5,119,71.5]
["Etiolles - Les Chênes",9,"PAR",4,3,4,4,4,4,4,3,5,null,null,null,null,null,null,null,null,null,"Handicap",4,5,7,6,8,1,9,3,2,null,null,null,null,null,null,null,null,null,57,34.299999999999997,53,32.9,61,34.4,57,33.5]
["Evreux",18,"PAR",4,5,4,4,3,5,3,4,4,4,4,5,3,4,5,3,4,4,"Handicap",9,7,11,1,15,13,17,3,5,14,18,6,10,2,16,8,12,4,135,72.7,123,69.7,128,72.900000000000006,121,70.400000000000006]
["Feucherolles",18,"PAR",4,4,4,3,4,5,3,4,5,4,5,4,3,4,3,4,4,5,"Handicap",18,12,16,10,14,8,6,4,2,11,7,9,3,1,5,17,15,13,141,74.599999999999994,138,72.099999999999994,139,75.8,137,72.2]
["Forges les Bains",18,"PAR",4,3,4,4,5,4,4,3,5,4,4,3,5,4,3,4,4,5,"Handicap",1,17,5,7,9,3,11,15,13,4,2,18,12,6,16,14,8,10,134,72.099999999999994,130,70.099999999999994,124,73.099999999999994,124,70.400000000000006]
["Fourqueux - Blanc Rouge",18,"PAR",4,5,4,4,4,3,5,4,3,4,4,4,3,4,4,4,5,3,"Handicap",15,7,13,1,11,3,17,9,5,4,8,10,6,14,18,2,12,16,138,71.400000000000006,131,69.900000000000006,135,73.099999999999994,124,71.7]
["Fourqueux - Bleu Blanc",18,"PAR",4,4,3,4,5,4,5,3,5,4,5,4,4,4,3,5,4,3,"Handicap",5,7,13,15,11,1,9,17,3,16,8,14,2,12,4,18,10,6,138,71.8,129,70.400000000000006,130,73.599999999999994,123,72.7]
["Fourqueux - Rouge Bleu",18,"PAR",4,4,4,3,4,4,4,5,3,4,4,3,4,5,4,5,3,5,"Handicap",15,7,13,1,11,3,17,9,5,4,8,10,6,14,18,2,12,16,138,69.5,125,68.599999999999994,136,71.400000000000006,123,69.7]
["Gadancourt",18,"PAR",4,4,4,3,4,5,4,4,3,5,3,4,5,4,3,4,5,4,"Handicap",3,11,13,9,8,1,5,18,10,14,16,6,7,2,12,15,17,4,127,72.8,125,71.7,125,72.5,124,69.599999999999994]
["Gif Chevry",9,"PAR",4,4,3,4,3,4,4,3,4,null,null,null,null,null,null,null,null,null,"Handicap",8,6,4,1,7,2,3,9,5,null,null,null,null,null,null,null,null,null,59,33.700000000000003,58,33.4,28,33.9,58,33.1]
["Grenouillère",9,"PAR",3,3,3,3,3,3,4,3,3,null,null,null,null,null,null,null,null,null,"Handicap",3,9,1,2,8,6,5,4,7,null,null,null,null,null,null,null,null,null,44,28.1,44,28.1,43,28.3,43,28.3]
["Guerville",18,"PAR",4,4,3,5,4,5,4,3,5,5,4,3,4,3,4,5,3,4,"Handicap",11,1,17,7,13,3,5,15,9,10,18,16,8,14,2,6,12,4,126,71.099999999999994,120,69.099999999999994,125,71.099999999999994,119,69.2]
["Haras de Jardy",9,"PAR",3,3,4,3,3,3,4,3,4,null,null,null,null,null,null,null,null,null,"Handicap",6,5,1,3,7,9,2,8,4,null,null,null,null,null,null,null,null,null,47,28.8,47,28.8,49,28.9,57,28.9]
["Houlgate",18,"PAR",4,3,5,3,4,4,5,3,5,4,3,4,5,4,3,5,4,3,"Handicap",10,6,4,8,2,12,16,14,18,15,17,1,13,9,11,3,5,7,133,71,124,68.5,125,71.900000000000006,122,70.099999999999994]
["Ile Fleurie",9,"PAR",3,3,3,3,4,3,3,3,3,null,null,null,null,null,null,null,null,null,"Handicap",3,7,8,5,1,6,9,2,4,null,null,null,null,null,null,null,null,null,48,29,48,29,44,28.1,44,28.1]
["Isabella",18,"PAR",4,4,5,3,4,4,5,3,4,5,4,4,4,3,4,4,3,4,"Handicap",6,12,2,18,10,14,4,16,8,11,1,5,3,9,15,17,13,7,130,70.7,128,68.7,128,72.2,127,69.8]
["Joyenval - Marly",18,"PAR",4,5,3,5,4,4,4,3,4,4,3,4,4,4,4,5,3,5,"Handicap",17,9,15,5,13,1,11,7,3,2,14,8,4,18,12,10,6,16,144,72.3,135,70.099999999999994,134,73.400000000000006,128,70]
["Joyenval - Retz",18,"PAR",4,3,4,5,4,5,3,4,4,4,3,4,5,4,3,5,4,4,"Handicap",15,9,17,1,3,11,13,5,7,8,2,18,14,4,12,10,6,16,141,72.099999999999994,132,70.099999999999994,132,73.3,125,70.099999999999994]
["La Boulie - La Forêt",18,"PAR",4,3,5,4,5,4,4,4,3,5,3,4,3,5,4,4,4,4,"Handicap",10,18,11,1,13,8,3,6,15,2,12,4,17,7,9,5,16,14,141,73.900000000000006,126,72.400000000000006,130,74.8,120,73.400000000000006]
["La Boulie - La Vallée",18,"PAR",4,4,3,5,4,4,3,5,4,3,5,4,3,4,3,4,5,5,"Handicap",5,1,9,17,3,11,7,13,15,6,14,12,4,8,10,2,16,18,138,72.8,135,71.2,137,74.7,138,73.400000000000006]
["La Chouette",18,"PAR",4,4,3,5,4,4,3,5,4,4,5,4,4,3,4,4,3,5,"Handicap",5,11,9,13,17,1,7,15,3,4,10,18,12,16,14,2,6,8,143,74.3,135,71.8,143,75.400000000000006,134,72.599999999999994]
["Les Aisses",18,"PAR",5,4,3,4,4,5,3,4,4,3,4,5,4,4,5,4,3,4,"Handicap",17,5,9,7,1,15,11,13,3,16,2,10,8,6,18,14,12,4,137,72.400000000000006,136,71.5,135,73.3,130,71.7]
["L'Isle Adam",18,"PAR",4,4,4,3,5,3,4,5,4,4,4,5,3,4,4,3,4,5,"Handicap",5,3,1,11,9,17,15,13,7,10,6,14,12,2,16,18,4,8,131,72.400000000000006,128,69.900000000000006,126,72.3,121,68.900000000000006]
["Mâcon - La Commanderie",18,"PAR",4,5,5,4,4,3,4,3,4,4,5,5,4,4,3,4,3,4,"Handicap",1,5,9,7,11,3,17,15,13,2,6,10,8,12,4,18,16,14,128,71.3,130,69.2,114,72.400000000000006,117,70.8]
["Mâcon - La Salle",18,"PAR",4,4,3,4,5,5,4,4,3,4,4,3,4,4,3,4,4,5,"Handicap",4,17,11,6,13,15,18,2,9,1,7,16,12,8,10,5,3,14,124,72.3,120,70.599999999999994,119,71.900000000000006,118,70.5]
["Maintenon",18,"PAR",4,4,4,4,4,4,3,4,4,3,4,4,5,3,4,3,4,5,"Handicap",7,3,1,15,13,9,5,17,11,8,16,4,12,2,6,10,18,14,131,69.5,126,68.400000000000006,121,70.2,116,68.5]
["Maisons Laffite",9,"PAR",3,4,4,3,4,3,3,3,3,null,null,null,null,null,null,null,null,null,"Handicap",9,2,5,7,3,6,8,1,4,null,null,null,null,null,null,null,null,null,50,29.4,49,29.1,52,29.6,49,29.2]
["Marivaux",18,"PAR",4,4,3,5,4,4,5,3,4,4,3,4,5,4,4,5,3,4,"Handicap",3,7,13,5,1,11,17,15,9,2,16,8,6,12,10,18,14,4,138,72.8,128,71,130,73.400000000000006,124,71]
["Marolles en Brie",9,"PAR",4,4,3,4,3,5,3,3,4,4,3,4,4,4,3,5,4,3,"Handicap",7,3,15,5,11,1,17,13,9,12,10,16,6,2,4,8,18,14,56,31.9,55,31.3,53,32.299999999999997,54,31.9]
["Montgriffon - Les Lacs",18,"PAR",4,4,4,4,5,3,3,5,4,4,3,5,5,4,4,3,4,4,"Handicap",17,8,4,6,13,15,10,7,2,14,18,9,16,12,3,5,1,11,137,71.900000000000006,130,70.5,133,73.7,127,71.3]
["National - Aigle",18,"PAR",4,4,4,3,4,3,5,4,4,3,4,4,3,4,5,4,5,4,"Handicap",12,2,18,16,6,14,10,8,4,9,11,1,17,5,15,3,13,7,122,70.599999999999994,120,69.400000000000006,125,71.900000000000006,119,70.5]
["National - Albatros",18,"PAR",4,3,5,4,4,4,4,3,5,4,3,4,4,5,4,3,4,5,"Handicap",4,6,12,8,16,18,2,14,10,9,17,7,3,11,1,13,5,15,155,73.8,141,71.599999999999994,148,75.099999999999994,141,74.2]
["National - Oiselet",9,"PAR",3,4,4,4,3,3,5,3,3,null,null,null,null,null,null,null,null,null,"Handicap",7,3,6,1,5,9,8,4,2,null,null,null,null,null,null,null,null,null,51,30.4,51,30.4,51,31.2,51,31.2]
["Noisy le Roy",9,"PAR",3,3,3,3,3,3,3,3,3,null,null,null,null,null,null,null,null,null,"Handicap",3,8,4,7,5,9,6,2,1,null,null,null,null,null,null,null,null,null,42,27.5,42,27.1,42,27.5,41,26.9]
["Omaha Beach - Manoir",18,"PAR",4,3,4,4,3,5,5,4,4,4,3,4,4,4,4,3,4,5,"Handicap",13,17,5,6,18,1,2,7,3,10,15,12,8,9,11,16,14,4,144,73,136,71.7,139,74.400000000000006,133,73.599999999999994]
["Omaha Beach - Mer",18,"PAR",5,3,4,4,5,4,4,3,4,3,5,4,5,4,3,4,4,4,"Handicap",9,18,8,7,5,3,6,15,13,14,2,11,10,12,17,1,4,16,135,72.099999999999994,127,70,128,72.8,122,71]
["Ormesson",18,"PAR",5,4,4,4,3,4,4,5,3,4,3,5,4,3,4,5,4,4,"Handicap",9,3,13,1,15,7,17,5,11,2,12,10,6,16,4,8,18,14,131,72.400000000000006,128,71.099999999999994,136,72.5,134,71.3]
["Perche",18,"PAR",5,4,4,4,3,5,4,4,3,4,5,5,3,4,4,4,3,4,"Handicap",10,8,2,12,6,16,4,18,14,1,3,7,11,9,17,15,5,13,133,72.5,131,70.5,124,72.8,121,70.900000000000006]
["Prieuré - Est",18,"PAR",4,4,3,5,4,3,4,4,4,5,4,3,5,4,4,4,5,3,"Handicap",16,2,12,10,6,18,14,8,4,1,11,9,5,15,3,13,7,17,132,71.900000000000006,129,69.8,133,73,129,70.400000000000006]
["Prieuré - Ouest",18,"PAR",3,4,4,4,5,3,4,5,3,5,3,4,3,4,5,4,4,5,"Handicap",17,3,11,5,1,9,7,13,15,8,16,2,18,14,10,4,6,12,132,73.3,126,71.400000000000006,130,74.599999999999994,124,72.3]
["Raray",18,"PAR",5,4,3,4,5,3,4,4,4,4,4,3,4,4,5,3,5,4,"Handicap",8,4,18,6,14,12,2,10,7,1,3,17,5,9,13,16,11,15,133,72.099999999999994,129,70.2,125,73.099999999999994,124,70.900000000000006]
["Rebetz",18,"PAR",5,4,4,3,4,5,4,4,3,4,5,5,3,4,4,3,4,5,"Handicap",9,13,1,15,3,17,5,7,11,2,18,16,12,14,8,10,4,6,132,71.5,127,70.599999999999994,128,73,128,71.2]
["Robert Hersant",18,"PAR",4,4,3,4,4,5,4,3,5,4,4,5,3,4,5,3,4,4,"Handicap",11,13,15,1,17,9,3,5,7,16,18,10,12,6,2,8,14,4,133,72.599999999999994,131,70,125,73.400000000000006,120,69.5]
["Rochefort Château",18,"PAR",4,5,3,4,5,4,4,3,4,3,5,3,4,5,4,4,3,4,"Handicap",9,11,17,3,15,13,5,7,1,8,18,14,2,10,16,4,12,6,129,71.3,125,70.2,129,73.599999999999994,126,72.3]
["Rosny sous Bois",9,"PAR",5,3,4,4,4,3,3,3,4,null,null,null,null,null,null,null,null,null,"Handicap",4,9,6,3,5,1,7,2,8,null,null,null,null,null,null,null,null,null,62,32.200000000000003,62,32.200000000000003,59,32.700000000000003,59,32.700000000000003]
["Rueil-Malmaison",9,"PAR",3,4,5,4,4,3,3,3,3,null,null,null,null,null,null,null,null,null,"Handicap",8,3,1,2,6,9,4,7,5,null,null,null,null,null,null,null,null,null,57,30.8,52,30.4,55,30.3,51,29.7]
["Rueil-Malmaison - 18T",18,"PAR",3,4,5,4,4,3,3,3,3,3,4,5,4,4,3,3,3,3,"Handicap",15,5,1,3,11,17,7,13,9,16,6,2,4,12,18,8,14,10,114,61.6,104,60.7,109,60.6,102,59.4]
["Saint Aubin - Le Mesnil",18,"PAR",5,4,4,4,3,4,4,4,4,3,4,4,4,5,3,4,3,4,"Handicap",5,17,1,9,7,15,11,3,13,4,16,10,8,12,6,18,2,14,131,69.3,127,67.7,130,72.2,130,70.5]
["St Germain - Grand Parcours",18,"PAR",4,5,4,4,3,5,3,4,5,4,3,4,4,4,5,4,3,4,"Handicap",3,15,11,1,7,9,5,13,17,10,12,4,14,2,16,18,8,6,138,72.5,132,70.7,136,75.2,135,73.099999999999994]
["St Germain - Les Genêts",9,"PAR",3,4,3,4,3,4,4,4,4,null,null,null,null,null,null,null,null,null,"Handicap",8,3,7,5,9,1,6,2,4,null,null,null,null,null,null,null,null,null,114,62.2,114,62.2,114,65.400000000000006,114,65.400000000000006]
["Saint Marc",18,"PAR",4,4,5,4,4,3,4,5,3,4,4,3,5,4,3,5,3,4,"Handicap",16,10,6,2,12,14,8,18,4,5,7,17,3,1,13,15,9,11,134,71.8,130,70,131,73.2,127,70.599999999999994]
["Saint-Nom-La-Bretèche - Bleu",18,"PAR",4,3,4,4,3,4,5,5,4,3,4,5,5,3,4,4,4,4,"Handicap",3,11,7,1,13,15,9,5,17,18,10,4,14,16,2,8,12,6,139,73.2,132,71.7,135,74.099999999999994,131,72.599999999999994]
["Saint-Nom-La-Bretèche - Rouge",18,"PAR",4,4,3,4,5,4,5,4,3,4,4,5,3,4,4,3,5,4,"Handicap",15,11,9,3,17,1,13,5,7,4,18,14,6,10,2,8,16,12,142,74.7,133,72.8,132,75.5,125,73.3]
["Saint-Quentin - Bleu",18,"PAR",4,4,3,4,4,5,3,4,4,5,3,4,5,4,4,5,3,4,"Handicap",4,14,10,2,16,18,12,8,6,15,13,1,5,11,3,7,17,9,125,71.400000000000006,122,69.3,129,72.900000000000006,123,70.400000000000006]
["Saint-Quentin - Rouge",18,"PAR",5,4,3,5,4,4,3,4,4,3,4,4,4,5,4,3,4,5,"Handicap",12,4,18,14,2,10,8,6,16,15,13,3,1,7,5,17,9,11,125,70.2,122,68.400000000000006,119,71.8,121,69.599999999999994]
["Seraincourt",18,"PAR",4,3,4,3,4,4,5,3,5,4,4,3,4,4,5,4,3,5,"Handicap",3,15,7,1,9,5,17,11,13,12,4,18,16,6,14,8,2,10,132,71.3,132,69.2,130,71.599999999999994,129,71.3]
["Sologne",18,"PAR",4,3,4,4,4,3,5,3,5,3,4,4,4,5,3,4,4,5,"Handicap",3,15,9,5,7,17,11,13,1,16,6,8,18,10,14,2,4,12,139,71.7,134,71,133,72.5,124,70.099999999999994]
["Templiers",18,"PAR",4,4,3,4,4,3,4,5,4,4,4,3,4,5,4,3,5,4,"Handicap",16,14,10,4,6,8,18,2,12,3,1,7,11,15,5,9,17,13,134,73.099999999999994,128,70.8,132,73.7,128,72.400000000000006]
["Tremblay Parc",9,"PAR",3,3,3,3,3,3,3,3,3,null,null,null,null,null,null,null,null,null,"Handicap",2,5,8,7,9,4,3,6,1,null,null,null,null,null,null,null,null,null,40,24.8,40,24.8,40,25.7,40,25.7]
["Tremblay sur Mauldre",9,"PAR",4,5,3,4,4,4,3,4,5,null,null,null,null,null,null,null,null,null,"Handicap",9,5,8,6,7,1,2,4,3,null,null,null,null,null,null,null,null,null,69,35.799999999999997,64,35.200000000000003,69,37.4,65,36.4]
["Tremblay sur Mauldre - 18T",18,"PAR",4,5,3,4,4,4,3,4,5,4,5,3,4,4,4,3,4,5,"Handicap",17,9,15,11,13,1,3,7,5,18,10,16,12,14,2,4,8,6,143,72.8,127,70.3,137,74.7,129,72.7]
["Val Grand",18,"PAR",5,4,4,4,3,4,5,3,4,3,5,4,3,5,4,4,3,4,"Handicap",8,10,14,6,12,18,4,16,2,9,1,13,7,5,17,15,11,3,132,70.8,117,68,123,71,114,67.599999999999994]
["Vaucouleurs - Rivière",18,"PAR",4,5,3,4,5,4,3,5,4,5,3,4,3,3,4,5,5,4,"Handicap",15,7,11,5,9,3,17,13,1,16,18,4,8,12,2,6,14,10,144,72.900000000000006,132,70.400000000000006,137,74.3,128,71.400000000000006]
["Vaucouleurs - Vallons",18,"PAR",4,3,5,3,4,4,3,4,5,5,4,3,4,4,3,5,4,3,"Handicap",15,13,5,11,1,9,17,7,3,12,18,14,10,6,16,4,2,8,136,70.5,126,67.8,134,71.599999999999994,120,67.900000000000006]
["Vaudreuil",18,"PAR",4,4,3,4,3,4,4,5,4,3,4,5,4,4,5,3,4,5,"Handicap",9,1,13,7,17,3,15,11,5,10,4,12,2,8,18,14,6,16,136,72.900000000000006,134,71.8,136,75.599999999999994,128,71.2]
["Villacoublay",18,"PAR",4,5,4,5,3,4,3,5,3,4,4,4,4,5,3,5,3,4,"Handicap",6,18,2,8,12,10,16,14,4,7,3,9,1,13,11,5,17,15,137,72.099999999999994,136,70.400000000000006,135,72.5,132,70.7]
["Villennes",18,"PAR",4,4,3,5,4,3,4,4,4,3,4,4,4,4,3,4,5,4,"Handicap",17,9,15,11,1,13,3,7,5,14,18,12,10,6,4,16,2,8,124,68.7,122,66.900000000000006,121,70.8,116,68.599999999999994]
["Villeray",18,"PAR",3,4,4,5,4,4,3,4,5,4,4,4,4,3,5,3,4,5,"Handicap",16,12,4,10,2,6,14,8,18,7,1,5,11,9,15,13,3,17,130,71.5,126,70.2,122,73.7,118,70.8]
["Yvelines - Les Chênes",18,"PAR",4,4,4,3,4,5,4,5,3,4,3,4,5,3,4,4,4,5,"Handicap",17,9,5,11,1,15,13,3,7,14,10,2,16,8,6,18,4,12,136,73.400000000000006,128,71.5,134,75.3,124,71.8]
["Yvelines - Les Tilleuls",9,"PAR",3,4,3,3,3,4,4,4,3,null,null,null,null,null,null,null,null,null,"Handicap",5,7,9,3,6,8,1,2,4,null,null,null,null,null,null,null,null,null,55,31,53,30.8,51,31,50,30.7]
["Forfait",18,"PAR",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Handicap",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tirage au sort",18,"PAR",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Handicap",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Joueurs","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["ASIP Golf",null,"Challenge 35 : les joueurs"]
[]
["Numéro","Poule","Nom","Prénom","S","Index","Licence","Index Orig","Repère"]
[1,"A","MABILE","Claude","H",17.399999999999999,546853076,16.899999999999999,{"$f":"IF(E4=\"H\",IF(F4<=15,\"Blanc\",\"Jaune\"),IF(F4<18.4,\"Bleu\",\"Rouge\"))","v":"Jaune"}]
[2,"D","SZAFIR","Patrick","H",{"$f":"H5","v":20.100000000000001},528029072,20.100000000000001,"Jaune"]
[3,"C","COULOMB","Thierry","H",20.2,542760227,20.2,"Jaune"]
[4,"B","VINAY","Guillaume","H",20.5,523598243,20.5,"Jaune"]
[5,"B","NGUYEN","Jean-Paul","H",20.3,536502142,23.1,"Jaune"]
[6,"C","DOGUIN","Pierre","H",24.7,521724243,24.7,"Jaune"]
[7,"D","ROBERT","Valérie","F",25,521904110,25,"Rouge"]
[8,"A","M'HAMDI","Jalel","H",27.5,43132307,27.5,"Jaune"]
[9,"A","BORDET","Bruno","H",28.4,545127264,29.4,"Jaune"]
[10,"D","GERSON","David","H",21.6,48823290,31,"Jaune"]
[11,"C","LEFRANC","Virginie","F",32.200000000000003,512192228,32.700000000000003,"Rouge"]
[12,"B","GATIGNOL","Christian","H",29.5,538242287,34,"Jaune"]
[13,"B","BOISSERPE","Patrick","H",34.5,532120179,34.5,"Jaune"]
[14,"C","TRAVERS","Philippe","H",34,47953296,34.5,"Jaune"]
[15,"D","ROME","Virginie","F",36,44303311,45,"Rouge"]
[16,"A","PICARD","Luc","H",46,3590314,51,"Jaune"]
[]
[]
["Les joueurs sont classés de 1 à 16 en fonction de leur index croissant, et par ordre alphabétique en cas d'index identique."]
["Ils sont ensuite dispatchés en poules suivant une répartition classique de tournoi."]
["L'index doit être mis à jour en cours de tournoi si le joueur en a changé depuis son inscription."]

{"sheet":"Poules","index":3,"n_rows":38,"n_cols":38,"rows_kept":38,"cut":false,"hidden":false,"merged":[[7,0,10,0],[14,0,17,0],[21,0,24,0],[28,0,31,0],[4,29,4,37]]}
["ASIP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Challenge 35 cuvée \",Cuvée,\" : poules\")","v":"Challenge 35 cuvée 2018 : poules"}]
[]
[]
["Poule","N°","Nom","Index",null,null,9,18,null,"Numéro de rencontre","Rencontre","Poule","Liste_nonvide","Hcp18","Hcp9","Date","Parcours","Trous","Vainqueur","J1","J2","Résultat","Bonus J1","Bonus J2","Bonus J1","Bonus J2",null,null,null,"Classement Poule"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ValNum","ValNum","Score","Bonus",null,null,null,"Match","Bonus","Composé","Rang","Joueur","Matchs","Points"]
[null,null,null,null,null,{"$f":"CONCATENATE(A8,B8,\" / \",A8,B9)","v":"A1 / A8"},{"$f":"C8","v":"MABILE"},{"$f":"C9","v":"M'HAMDI"},"Partagé",{"$f":"IF(COUNTBLANK(K7),0,1)","v":1},{"$f":"IF(OR(G7=\"\",H7=\"\"),\"\",CONCATENATE(G7,\" / \",H7))","v":"MABILE / M'HAMDI"},"A",{"$f":"IF(ROW()-6<28-COUNTBLANK($K$7:$K$33),VLOOKUP(ROW()-6,$J$7:$K$33,2,FALSE),\"\")","v":"MABILE / M'HAMDI"},{"$f":"IF(OR(G7=\"\",H7=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H7,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G7,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":8},{"$f":"IF(OR(G7=\"\",H7=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H7,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G7,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":4},"2018-06-24","Omaha Beach - Mer",{"$f":"IF(Q7=\"\",\"\",VLOOKUP(Q7,Parcours!$A$2:$B$130,2,FALSE))","v":18},"MABILE",{"$f":"IF(K7=\"\",0,IF(S7=G7,1,IF(S7=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K7=\"\",0,IF(S7=H7,1,IF(S7=\"Partagé\",0.5,0)))","v":0},"6&5",{"$f":"IF(V7=\"\",0,IF(T7=0,-VLOOKUP(V7,$AA$7:$AB$25,2,FALSE),IF(T7=1,VLOOKUP(V7,$AA$7:$AB$25,2,FALSE),0)))","v":"11"},{"$f":"-W7","v":-11},{"$f":"W7+0.001","v":11.000999999999999},{"$f":"X7+0.001","v":-10.999000000000001},"AS","0"]
["A",1,{"$f":"IF((VLOOKUP(B8,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B8,Joueurs!A$4:F$19,3,FALSE))","v":"MABILE"},{"$f":"IF((VLOOKUP(B8,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B8,Joueurs!A$4:F$19,6,FALSE))","v":17.399999999999999},null,{"$f":"CONCATENATE(A8,B8,\" / \",A8,B10)","v":"A1 / A9"},{"$f":"C8","v":"MABILE"},{"$f":"C10","v":"BORDET"},"Partagé",{"$f":"J7+IF(COUNTBLANK(K8),0,1)","v":2},"MABILE / BORDET","A",{"$f":"IF(ROW()-6<28-COUNTBLANK($K$7:$K$33),VLOOKUP(ROW()-6,$J$7:$K$33,2,FALSE),\"\")","v":"MABILE / BORDET"},{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H8,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G8,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":8},{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H8,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G8,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":4},"2018-05-03","Saint Aubin - Le Mesnil",{"$f":"IF(Q8=\"\",\"\",VLOOKUP(Q8,Parcours!$A$2:$B$130,2,FALSE))","v":18},"MABILE",{"$f":"IF(K8=\"\",0,IF(S8=G8,1,IF(S8=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K8=\"\",0,IF(S8=H8,1,IF(S8=\"Partagé\",0.5,0)))","v":0},"4&2",{"$f":"IF(V8=\"\",0,IF(T8=0,-VLOOKUP(V8,$AA$7:$AB$25,2,FALSE),IF(T8=1,VLOOKUP(V8,$AA$7:$AB$25,2,FALSE),0)))","v":"6"},{"$f":"-W8","v":-6},{"$f":"W8+0.002","v":6.0019999999999998},{"$f":"X8+0.002","v":-5.9980000000000002},"1UP","1",null,"1A",{"$f":"C8","v":"MABILE"},{"$f":"IF(AE8=\"\",-1,SUMIF(G7:G12,AE8,T7:T12)+SUMIF(H7:H12,AE8,U7:U12))","v":3},{"$f":"SUMIF(G7:G12,AE8,Y7:Y12)+SUMIF(H7:H12,AE8,Z7:Z12)","v":20.007000000000001},{"$f":"100*AF8+AG8","v":320.00700000000001},{"$f":"RANK(AH8,AH8:AH11)","v":1},{"$f":"IF(AE8=\"\",\"\",INDEX(AE8:AE11,MATCH(1,AI8:AI11,0)))","v":"MABILE"},{"$f":"IF(AE8=\"\",\"\",VLOOKUP(AJ8,AE8:AF11,2,FALSE))","v":3},{"$f":"IF(AE8=\"\",\"\",VLOOKUP(AJ8,AE8:AG11,3,FALSE))","v":20.007000000000001}]
[null,8,{"$f":"IF((VLOOKUP(B9,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B9,Joueurs!A$4:C$19,3,FALSE))","v":"M'HAMDI"},{"$f":"IF((VLOOKUP(B9,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B9,Joueurs!A$4:F$19,6,FALSE))","v":27.5},null,{"$f":"CONCATENATE(A8,B9,\" / \",A8,B10)","v":"A8 / A9"},{"$f":"C9","v":"M'HAMDI"},{"$f":"C10","v":"BORDET"},"Partagé",3,"M'HAMDI / BORDET","A",{"$f":"IF(ROW()-6<28-COUNTBLANK($K$7:$K$33),VLOOKUP(ROW()-6,$J$7:$K$33,2,FALSE),\"\")","v":"M'HAMDI / BORDET"},{"$f":"IF(OR(G9=\"\",H9=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H9,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G9,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":1},{"$f":"IF(OR(G9=\"\",H9=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H9,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G9,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":0},"2018-05-26","Forges les Bains",{"$f":"IF(Q9=\"\",\"\",VLOOKUP(Q9,Parcours!$A$2:$B$130,2,FALSE))","v":18},"BORDET",0,1,"6&5",-11,11,{"$f":"W9+0.003","v":-10.997},{"$f":"X9+0.003","v":11.003},"2UP","2",null,"2A",{"$f":"C9","v":"M'HAMDI"},{"$f":"IF(AE9=\"\",-1,SUMIF(G7:G12,AE9,T7:T12)+SUMIF(H7:H12,AE9,U7:U12))","v":0},{"$f":"SUMIF(G7:G12,AE9,Y7:Y12)+SUMIF(H7:H12,AE9,Z7:Z12)","v":-24.991},{"$f":"100*AF9+AG9","v":-24.991},{"$f":"RANK(AH9,AH8:AH11)","v":4},{"$f":"IF(AE9=\"\",\"\",INDEX(AE8:AE11,MATCH(2,AI8:AI11,0)))","v":"BORDET"},{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AJ9,AE8:AF11,2,FALSE))","v":2},{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AJ9,AE8:AG11,3,FALSE))","v":8.0109999999999992}]
[null,9,{"$f":"IF((VLOOKUP(B10,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B10,Joueurs!A$4:C$19,3,FALSE))","v":"BORDET"},{"$f":"IF((VLOOKUP(B10,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B10,Joueurs!A$4:F$19,6,FALSE))","v":28.4},null,{"$f":"CONCATENATE(A8,B8,\" / \",A8,B11)","v":"A1 / A16"},{"$f":"C8","v":"MABILE"},{"$f":"C11","v":"PICARD"},"Partagé",4,"MABILE / PICARD","A","MABILE / PICARD",{"$f":"IF(OR(G10=\"\",H10=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H10,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G10,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":21},{"$f":"IF(OR(G10=\"\",H10=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H10,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G10,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":11},"2018-06-23","Caen - Plaine Vallon",{"$f":"IF(Q10=\"\",\"\",VLOOKUP(Q10,Parcours!$A$2:$B$130,2,FALSE))","v":18},"MABILE",{"$f":"IF(K10=\"\",0,IF(S10=G10,1,IF(S10=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K10=\"\",0,IF(S10=H10,1,IF(S10=\"Partagé\",0.5,0)))","v":0},"2&1","3",-3,{"$f":"W10+0.004","v":3.004},{"$f":"X10+0.004","v":-2.996},"2&1","3",null,"3A",{"$f":"C10","v":"BORDET"},{"$f":"IF(AE10=\"\",-1,SUMIF(G7:G12,AE10,T7:T12)+SUMIF(H7:H12,AE10,U7:U12))","v":2},{"$f":"SUMIF(G7:G12,AE10,Y7:Y12)+SUMIF(H7:H12,AE10,Z7:Z12)","v":8.0109999999999992},208.011,{"$f":"RANK(AH10,AH8:AH11)","v":2},{"$f":"IF(AE10=\"\",\"\",INDEX(AE8:AE11,MATCH(3,AI8:AI11,0)))","v":"PICARD"},{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AJ10,AE8:AF11,2,FALSE))","v":1},{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AJ10,AE8:AG11,3,FALSE))","v":-2.9850000000000003}]
[null,16,{"$f":"IF((VLOOKUP(B11,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B11,Joueurs!A$4:C$19,3,FALSE))","v":"PICARD"},{"$f":"IF((VLOOKUP(B11,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B11,Joueurs!A$4:F$19,6,FALSE))","v":46},null,{"$f":"CONCATENATE(A8,B9,\" / \",A8,B11)","v":"A8 / A16"},{"$f":"C9","v":"M'HAMDI"},{"$f":"C11","v":"PICARD"},"Partagé",5,"M'HAMDI / PICARD","A","M'HAMDI / PICARD",{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H11,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G11,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":14},{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H11,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G11,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":7},"2018-05-18","Gadancourt",{"$f":"IF(Q11=\"\",\"\",VLOOKUP(Q11,Parcours!$A$2:$B$130,2,FALSE))","v":18},"PICARD",{"$f":"IF(K11=\"\",0,IF(S11=G11,1,IF(S11=\"Partagé\",0.5,0)))","v":0},{"$f":"IF(K11=\"\",0,IF(S11=H11,1,IF(S11=\"Partagé\",0.5,0)))","v":1},"2&1",-3,3,{"$f":"W11+0.005","v":-2.9950000000000001},{"$f":"X11+0.005","v":3.0049999999999999},"3&1","4",null,"4A",{"$f":"C11","v":"PICARD"},{"$f":"IF(AE11=\"\",-1,SUMIF(G7:G12,AE11,T7:T12)+SUMIF(H7:H12,AE11,U7:U12))","v":1},{"$f":"SUMIF(G7:G12,AE11,Y7:Y12)+SUMIF(H7:H12,AE11,Z7:Z12)","v":-2.9850000000000003},97.015000000000001,{"$f":"RANK(AH11,AH8:AH11)","v":3},{"$f":"IF(AE11=\"\",\"\",INDEX(AE8:AE11,MATCH(4,AI8:AI11,0)))","v":"M'HAMDI"},{"$f":"IF(AE11=\"\",\"\",VLOOKUP(AJ11,AE8:AF11,2,FALSE))","v":0},{"$f":"IF(AE11=\"\",\"\",VLOOKUP(AJ11,AE8:AG11,3,FALSE))","v":-24.991}]
[null,null,null,null,null,{"$f":"CONCATENATE(A8,B10,\" / \",A8,B11)","v":"A9 / A16"},{"$f":"C10","v":"BORDET"},{"$f":"C11","v":"PICARD"},"Partagé",6,"BORDET / PICARD","A","BORDET / PICARD",{"$f":"IF(OR(G12=\"\",H12=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H12,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G12,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":13},{"$f":"IF(OR(G12=\"\",H12=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H12,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G12,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":7},"2018-06-13","Rueil-Malmaison - 18T",{"$f":"IF(Q12=\"\",\"\",VLOOKUP(Q12,Parcours!$A$2:$B$130,2,FALSE))","v":18},"BORDET",1,0,"2&1","3",-3,{"$f":"W12+0.006","v":3.0059999999999998},{"$f":"X12+0.006","v":-2.9940000000000002},"3&2","5",null,null,null,null,null,null,null,{"$f":"4-COUNTBLANK(AJ8:AJ11)","v":4},{"$f":"IF(AJ12=2,1,IF(AJ12=3,3,6))","v":6},{"$f":"SUM(AK8:AK11)","v":6}]
[null,null,null,null,null,null,null,null,null,6,null,null,"VINAY / NGUYEN",null,null,null,null,null,null,null,null,null,null,null,null,null,"4&2","6"]
[null,null,null,null,null,{"$f":"CONCATENATE(A15,B15,\" / \",A15,B16)","v":"B4 / B5"},{"$f":"C15","v":"VINAY"},{"$f":"C16","v":"NGUYEN"},"Partagé",7,{"$f":"IF(OR(G14=\"\",H14=\"\"),\"\",CONCATENATE(G14,\" / \",H14))","v":"VINAY / NGUYEN"},"B","VINAY / GATIGNOL",{"$f":"IF(OR(G14=\"\",H14=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H14,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G14,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":0},{"$f":"IF(OR(G14=\"\",H14=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H14,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G14,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":0},"2018-07-26","National - Aigle",{"$f":"IF(Q14=\"\",\"\",VLOOKUP(Q14,Parcours!$A$2:$B$130,2,FALSE))","v":18},"VINAY",{"$f":"IF(K14=\"\",0,IF(S14=G14,1,IF(S14=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K14=\"\",0,IF(S14=H14,1,IF(S14=\"Partagé\",0.5,0)))","v":0},"7&6",{"$f":"IF(V14=\"\",0,IF(T14=0,-VLOOKUP(V14,$AA$7:$AB$25,2,FALSE),IF(T14=1,VLOOKUP(V14,$AA$7:$AB$25,2,FALSE),0)))","v":"13"},{"$f":"-W14","v":-13},{"$f":"W14+0.001","v":13.000999999999999},{"$f":"X14+0.001","v":-12.999000000000001},"4&3","7"]
["B",4,{"$f":"IF((VLOOKUP(B15,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B15,Joueurs!A$4:C$19,3,FALSE))","v":"VINAY"},{"$f":"IF((VLOOKUP(B15,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B15,Joueurs!A$4:F$19,6,FALSE))","v":20.5},null,{"$f":"CONCATENATE(A15,B15,\" / \",A15,B17)","v":"B4 / B12"},{"$f":"C15","v":"VINAY"},{"$f":"C17","v":"GATIGNOL"},"Partagé",8,"VINAY / GATIGNOL","B","NGUYEN / GATIGNOL",{"$f":"IF(OR(G15=\"\",H15=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H15,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G15,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":7},{"$f":"IF(OR(G15=\"\",H15=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H15,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G15,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":3},"2018-06-29","Vaucouleurs - Vallons",{"$f":"IF(Q15=\"\",\"\",VLOOKUP(Q15,Parcours!$A$2:$B$130,2,FALSE))","v":18},"GATIGNOL",0,1,"1UP",{"$f":"IF(V15=\"\",0,IF(T15=0,-VLOOKUP(V15,$AA$7:$AB$25,2,FALSE),IF(T15=1,VLOOKUP(V15,$AA$7:$AB$25,2,FALSE),0)))","v":-1},{"$f":"-W15","v":1},{"$f":"W15+0.002","v":-0.998},{"$f":"X15+0.002","v":1.002},"5&3","8",null,"1B",{"$f":"C15","v":"VINAY"},{"$f":"IF(AE15=\"\",-1,SUMIF(G14:G19,AE15,T14:T19)+SUMIF(H14:H19,AE15,U14:U19))","v":2},{"$f":"SUMIF(G14:G19,AE15,Y14:Y19)+SUMIF(H14:H19,AE15,Z14:Z19)","v":19.006999999999998},{"$f":"100*AF15+AG15","v":219.00700000000001},{"$f":"RANK(AH15,AH15:AH18)","v":1},{"$f":"IF(AE15=\"\",\"\",INDEX(AE15:AE18,MATCH(1,AI15:AI18,0)))","v":"VINAY"},{"$f":"IF(AE15=\"\",\"\",VLOOKUP(AJ15,AE15:AF18,2,FALSE))","v":2},{"$f":"IF(AE15=\"\",\"\",VLOOKUP(AJ15,AE15:AG18,3,FALSE))","v":19.006999999999998}]
["B",5,{"$f":"IF((VLOOKUP(B16,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B16,Joueurs!A$4:C$19,3,FALSE))","v":"NGUYEN"},{"$f":"IF((VLOOKUP(B16,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B16,Joueurs!A$4:F$19,6,FALSE))","v":20.3},null,{"$f":"CONCATENATE(A15,B16,\" / \",A15,B17)","v":"B5 / B12"},{"$f":"C16","v":"NGUYEN"},{"$f":"C17","v":"GATIGNOL"},"Partagé",9,"NGUYEN / GATIGNOL","B","VINAY / BOISSERPE",{"$f":"IF(OR(G16=\"\",H16=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H16,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G16,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":7},{"$f":"IF(OR(G16=\"\",H16=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H16,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G16,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":3},"2018-06-06","Villennes",{"$f":"IF(Q16=\"\",\"\",VLOOKUP(Q16,Parcours!$A$2:$B$130,2,FALSE))","v":18},"NGUYEN",1,0,"5&3","8",-8,{"$f":"W16+0.003","v":8.0030000000000001},{"$f":"X16+0.003","v":-7.9969999999999999},"5&4","9",null,"2B",{"$f":"C16","v":"NGUYEN"},{"$f":"IF(AE16=\"\",-1,SUMIF(G14:G19,AE16,T14:T19)+SUMIF(H14:H19,AE16,U14:U19))","v":2},{"$f":"SUMIF(G14:G19,AE16,Y14:Y19)+SUMIF(H14:H19,AE16,Z14:Z19)","v":5.0090000000000021},{"$f":"100*AF16+AG16","v":205.00900000000001},{"$f":"RANK(AH16,AH15:AH18)","v":2},{"$f":"IF(AE16=\"\",\"\",INDEX(AE15:AE18,MATCH(2,AI15:AI18,0)))","v":"NGUYEN"},{"$f":"IF(AE16=\"\",\"\",VLOOKUP(AJ16,AE15:AF18,2,FALSE))","v":2},{"$f":"IF(AE16=\"\",\"\",VLOOKUP(AJ16,AE15:AG18,3,FALSE))","v":5.0090000000000021}]
[null,12,{"$f":"IF((VLOOKUP(B17,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B17,Joueurs!A$4:C$19,3,FALSE))","v":"GATIGNOL"},{"$f":"IF((VLOOKUP(B17,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B17,Joueurs!A$4:F$19,6,FALSE))","v":29.5},null,{"$f":"CONCATENATE(A15,B15,\" / \",A15,B18)","v":"B4 / B13"},{"$f":"C15","v":"VINAY"},{"$f":"C18","v":"BOISSERPE"},"Partagé",10,"VINAY / BOISSERPE","B","NGUYEN / BOISSERPE",{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H17,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G17,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":11},{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H17,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G17,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":5},"2018-05-18","Gadancourt",{"$f":"IF(Q17=\"\",\"\",VLOOKUP(Q17,Parcours!$A$2:$B$130,2,FALSE))","v":18},"VINAY",{"$f":"IF(K17=\"\",0,IF(S17=G17,1,IF(S17=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K17=\"\",0,IF(S17=H17,1,IF(S17=\"Partagé\",0.5,0)))","v":0},"4&3","7",-7,{"$f":"W17+0.004","v":7.0039999999999996},{"$f":"X17+0.004","v":-6.9960000000000004},"6&4","10",null,"3B",{"$f":"C17","v":"GATIGNOL"},{"$f":"IF(AE17=\"\",-1,SUMIF(G14:G19,AE17,T14:T19)+SUMIF(H14:H19,AE17,U14:U19))","v":1},{"$f":"SUMIF(G14:G19,AE17,Y14:Y19)+SUMIF(H14:H19,AE17,Z14:Z19)","v":-11.989000000000001},88.010999999999996,{"$f":"RANK(AH17,AH15:AH18)","v":4},{"$f":"IF(AE17=\"\",\"\",INDEX(AE15:AE18,MATCH(3,AI15:AI18,0)))","v":"BOISSERPE"},{"$f":"IF(AE17=\"\",\"\",VLOOKUP(AJ17,AE15:AF18,2,FALSE))","v":1},{"$f":"IF(AE17=\"\",\"\",VLOOKUP(AJ17,AE15:AG18,3,FALSE))","v":-11.984999999999999}]
[null,13,{"$f":"IF((VLOOKUP(B18,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B18,Joueurs!A$4:C$19,3,FALSE))","v":"BOISSERPE"},{"$f":"IF((VLOOKUP(B18,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B18,Joueurs!A$4:F$19,6,FALSE))","v":34.5},null,{"$f":"CONCATENATE(A15,B16,\" / \",A15,B18)","v":"B5 / B13"},{"$f":"C16","v":"NGUYEN"},{"$f":"C18","v":"BOISSERPE"},"Partagé",11,"NGUYEN / BOISSERPE","B","GATIGNOL / BOISSERPE",{"$f":"IF(OR(G18=\"\",H18=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H18,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G18,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":11},{"$f":"IF(OR(G18=\"\",H18=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H18,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G18,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":5},"2018-05-10","Cergy-Vauréal",{"$f":"IF(Q18=\"\",\"\",VLOOKUP(Q18,Parcours!$A$2:$B$130,2,FALSE))","v":18},"NGUYEN",{"$f":"IF(K18=\"\",0,IF(S18=G18,1,IF(S18=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K18=\"\",0,IF(S18=H18,1,IF(S18=\"Partagé\",0.5,0)))","v":0},"6&4","10",-10,{"$f":"W18+0.005","v":10.005000000000001},{"$f":"X18+0.005","v":-9.9949999999999992},"6&5","11",null,"4B",{"$f":"C18","v":"BOISSERPE"},{"$f":"IF(AE18=\"\",-1,SUMIF(G14:G19,AE18,T14:T19)+SUMIF(H14:H19,AE18,U14:U19))","v":1},{"$f":"SUMIF(G14:G19,AE18,Y14:Y19)+SUMIF(H14:H19,AE18,Z14:Z19)","v":-11.984999999999999},88.015000000000001,{"$f":"RANK(AH18,AH15:AH18)","v":3},{"$f":"IF(AE18=\"\",\"\",INDEX(AE15:AE18,MATCH(4,AI15:AI18,0)))","v":"GATIGNOL"},{"$f":"IF(AE18=\"\",\"\",VLOOKUP(AJ18,AE15:AF18,2,FALSE))","v":1},{"$f":"IF(AE18=\"\",\"\",VLOOKUP(AJ18,AE15:AG18,3,FALSE))","v":-11.989000000000001}]
[null,null,null,null,null,{"$f":"CONCATENATE(A15,B17,\" / \",A15,B18)","v":"B12 / B13"},{"$f":"C17","v":"GATIGNOL"},{"$f":"C18","v":"BOISSERPE"},"Partagé",12,"GATIGNOL / BOISSERPE","B","COULOMB / DOGUIN",{"$f":"IF(OR(G19=\"\",H19=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H19,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G19,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":4},{"$f":"IF(OR(G19=\"\",H19=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H19,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G19,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":2},"2018-06-12","Cergy-Vauréal",{"$f":"IF(Q19=\"\",\"\",VLOOKUP(Q19,Parcours!$A$2:$B$130,2,FALSE))","v":18},"BOISSERPE",0,1,"3&2",-5,5,{"$f":"W19+0.006","v":-4.9939999999999998},{"$f":"X19+0.006","v":5.0060000000000002},"7&5","12",null,null,null,null,null,null,null,{"$f":"4-COUNTBLANK(AJ15:AJ18)","v":4},{"$f":"IF(AJ19=2,1,IF(AJ19=3,3,6))","v":6},{"$f":"SUM(AK15:AK18)","v":6}]
[null,null,null,null,null,null,null,null,null,12,null,null,"COULOMB / LEFRANC",null,null,null,null,null,null,null,null,null,null,null,null,null,"7&6","13"]
[null,null,null,null,null,{"$f":"CONCATENATE(A22,B22,\" / \",A22,B23)","v":"C3 / C6"},{"$f":"C22","v":"COULOMB"},{"$f":"C23","v":"DOGUIN"},"Partagé",13,{"$f":"IF(OR(G21=\"\",H21=\"\"),\"\",CONCATENATE(G21,\" / \",H21))","v":"COULOMB / DOGUIN"},"C","DOGUIN / LEFRANC",{"$f":"IF(OR(G21=\"\",H21=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H21,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G21,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":3},{"$f":"IF(OR(G21=\"\",H21=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H21,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G21,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":2},"2018-06-01","La Chouette",{"$f":"IF(Q21=\"\",\"\",VLOOKUP(Q21,Parcours!$A$2:$B$130,2,FALSE))","v":18},"COULOMB",{"$f":"IF(K21=\"\",0,IF(S21=G21,1,IF(S21=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K21=\"\",0,IF(S21=H21,1,IF(S21=\"Partagé\",0.5,0)))","v":0},"6&4",{"$f":"IF(V21=\"\",0,IF(T21=0,-VLOOKUP(V21,$AA$7:$AB$25,2,FALSE),IF(T21=1,VLOOKUP(V21,$AA$7:$AB$25,2,FALSE),0)))","v":"10"},{"$f":"-W21","v":-10},{"$f":"W21+0.001","v":10.000999999999999},{"$f":"X21+0.001","v":-9.9990000000000006},"8&6","14"]
["C",3,{"$f":"IF((VLOOKUP(B22,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B22,Joueurs!A$4:C$19,3,FALSE))","v":"COULOMB"},{"$f":"IF((VLOOKUP(B22,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B22,Joueurs!A$4:F$19,6,FALSE))","v":20.2},null,{"$f":"CONCATENATE(A22,B22,\" / \",A22,B24)","v":"C3 / C11"},{"$f":"C22","v":"COULOMB"},{"$f":"C24","v":"LEFRANC"},"Partagé",14,"COULOMB / LEFRANC","C","COULOMB / TRAVERS",{"$f":"IF(OR(G22=\"\",H22=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H22,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G22,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":9},{"$f":"IF(OR(G22=\"\",H22=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H22,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G22,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":5},"2018-05-11","Saint-Quentin - Rouge",{"$f":"IF(Q22=\"\",\"\",VLOOKUP(Q22,Parcours!$A$2:$B$130,2,FALSE))","v":18},"LEFRANC",0,1,"2&1",{"$f":"IF(V22=\"\",0,IF(T22=0,-VLOOKUP(V22,$AA$7:$AB$25,2,FALSE),IF(T22=1,VLOOKUP(V22,$AA$7:$AB$25,2,FALSE),0)))","v":-3},{"$f":"-W22","v":3},{"$f":"W22+0.002","v":-2.9980000000000002},{"$f":"X22+0.002","v":3.0019999999999998},"8&7","15",null,"1C",{"$f":"C22","v":"COULOMB"},{"$f":"IF(AE22=\"\",-1,SUMIF(G21:G26,AE22,T21:T26)+SUMIF(H21:H26,AE22,U21:U26))","v":2},{"$f":"SUMIF(G21:G26,AE22,Y21:Y26)+SUMIF(H21:H26,AE22,Z21:Z26)","v":8.0069999999999997},{"$f":"100*AF22+AG22","v":208.00700000000001},{"$f":"RANK(AH22,AH22:AH25)","v":1},{"$f":"IF(AE22=\"\",\"\",INDEX(AE22:AE25,MATCH(1,AI22:AI25,0)))","v":"COULOMB"},{"$f":"IF(AE22=\"\",\"\",VLOOKUP(AJ22,AE22:AF25,2,FALSE))","v":2},{"$f":"IF(AE22=\"\",\"\",VLOOKUP(AJ22,AE22:AG25,3,FALSE))","v":8.0069999999999997}]
["B",6,{"$f":"IF((VLOOKUP(B23,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B23,Joueurs!A$4:C$19,3,FALSE))","v":"DOGUIN"},{"$f":"IF((VLOOKUP(B23,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B23,Joueurs!A$4:F$19,6,FALSE))","v":24.7},null,{"$f":"CONCATENATE(A22,B23,\" / \",A22,B24)","v":"C6 / C11"},{"$f":"C23","v":"DOGUIN"},{"$f":"C24","v":"LEFRANC"},"Partagé",15,"DOGUIN / LEFRANC","C","DOGUIN / TRAVERS",{"$f":"IF(OR(G23=\"\",H23=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H23,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G23,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":6},{"$f":"IF(OR(G23=\"\",H23=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H23,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G23,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":3},"2018-07-13","Saint Aubin - Le Mesnil",{"$f":"IF(Q23=\"\",\"\",VLOOKUP(Q23,Parcours!$A$2:$B$130,2,FALSE))","v":18},"DOGUIN",1,0,"1UP","1",-1,{"$f":"W23+0.003","v":1.0029999999999999},{"$f":"X23+0.003","v":-0.997},"9&7","16",null,"2C",{"$f":"C23","v":"DOGUIN"},{"$f":"IF(AE23=\"\",-1,SUMIF(G21:G26,AE23,T21:T26)+SUMIF(H21:H26,AE23,U21:U26))","v":2},{"$f":"SUMIF(G21:G26,AE23,Y21:Y26)+SUMIF(H21:H26,AE23,Z21:Z26)","v":-6.9910000000000005},{"$f":"100*AF23+AG23","v":193.00899999999999},{"$f":"RANK(AH23,AH22:AH25)","v":3},{"$f":"IF(AE23=\"\",\"\",INDEX(AE22:AE25,MATCH(2,AI22:AI25,0)))","v":"LEFRANC"},{"$f":"IF(AE23=\"\",\"\",VLOOKUP(AJ23,AE22:AF25,2,FALSE))","v":2},{"$f":"IF(AE23=\"\",\"\",VLOOKUP(AJ23,AE22:AG25,3,FALSE))","v":4.0109999999999992}]
[null,11,{"$f":"IF((VLOOKUP(B24,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B24,Joueurs!A$4:C$19,3,FALSE))","v":"LEFRANC"},{"$f":"IF((VLOOKUP(B24,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B24,Joueurs!A$4:F$19,6,FALSE))","v":32.200000000000003},null,{"$f":"CONCATENATE(A22,B22,\" / \",A22,B25)","v":"C3 / C14"},{"$f":"C22","v":"COULOMB"},{"$f":"C25","v":"TRAVERS"},"Partagé",16,"COULOMB / TRAVERS","C","LEFRANC / TRAVERS",{"$f":"IF(OR(G24=\"\",H24=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H24,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G24,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":10},{"$f":"IF(OR(G24=\"\",H24=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H24,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G24,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":5},"2018-06-18","Villennes",{"$f":"IF(Q24=\"\",\"\",VLOOKUP(Q24,Parcours!$A$2:$B$130,2,FALSE))","v":18},"COULOMB",{"$f":"IF(K24=\"\",0,IF(S24=G24,1,IF(S24=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K24=\"\",0,IF(S24=H24,1,IF(S24=\"Partagé\",0.5,0)))","v":0},"1UP","1",-1,{"$f":"W24+0.004","v":1.004},{"$f":"X24+0.004","v":-0.996},"9&8","17",null,"3C",{"$f":"C24","v":"LEFRANC"},{"$f":"IF(AE24=\"\",-1,SUMIF(G21:G26,AE24,T21:T26)+SUMIF(H21:H26,AE24,U21:U26))","v":2},{"$f":"SUMIF(G21:G26,AE24,Y21:Y26)+SUMIF(H21:H26,AE24,Z21:Z26)","v":4.0109999999999992},204.011,{"$f":"RANK(AH24,AH22:AH25)","v":2},{"$f":"IF(AE24=\"\",\"\",INDEX(AE22:AE25,MATCH(3,AI22:AI25,0)))","v":"DOGUIN"},{"$f":"IF(AE24=\"\",\"\",VLOOKUP(AJ24,AE22:AF25,2,FALSE))","v":2},{"$f":"IF(AE24=\"\",\"\",VLOOKUP(AJ24,AE22:AG25,3,FALSE))","v":-6.9910000000000005}]
[null,14,{"$f":"IF((VLOOKUP(B25,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B25,Joueurs!A$4:C$19,3,FALSE))","v":"TRAVERS"},{"$f":"IF((VLOOKUP(B25,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B25,Joueurs!A$4:F$19,6,FALSE))","v":34},null,{"$f":"CONCATENATE(A22,B23,\" / \",A22,B25)","v":"C6 / C14"},{"$f":"C23","v":"DOGUIN"},{"$f":"C25","v":"TRAVERS"},"Partagé",17,"DOGUIN / TRAVERS","C","SZAFIR / ROBERT",{"$f":"IF(OR(G25=\"\",H25=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H25,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G25,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":7},{"$f":"IF(OR(G25=\"\",H25=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H25,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G25,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":3},"2018-07-11","Villennes",{"$f":"IF(Q25=\"\",\"\",VLOOKUP(Q25,Parcours!$A$2:$B$130,2,FALSE))","v":18},"DOGUIN",{"$f":"IF(K25=\"\",0,IF(S25=G25,1,IF(S25=\"Partagé\",0.5,0)))","v":1},{"$f":"IF(K25=\"\",0,IF(S25=H25,1,IF(S25=\"Partagé\",0.5,0)))","v":0},"2UP","2",-2,{"$f":"W25+0.005","v":2.0049999999999999},{"$f":"X25+0.005","v":-1.9950000000000001},"10&8","18",null,"4C",{"$f":"C25","v":"TRAVERS"},{"$f":"IF(AE25=\"\",-1,SUMIF(G21:G26,AE25,T21:T26)+SUMIF(H21:H26,AE25,U21:U26))","v":0},{"$f":"SUMIF(G21:G26,AE25,Y21:Y26)+SUMIF(H21:H26,AE25,Z21:Z26)","v":-4.9850000000000003},-4.9850000000000003,{"$f":"RANK(AH25,AH22:AH25)","v":4},{"$f":"IF(AE25=\"\",\"\",INDEX(AE22:AE25,MATCH(4,AI22:AI25,0)))","v":"TRAVERS"},{"$f":"IF(AE25=\"\",\"\",VLOOKUP(AJ25,AE22:AF25,2,FALSE))","v":0},{"$f":"IF(AE25=\"\",\"\",VLOOKUP(AJ25,AE22:AG25,3,FALSE))","v":-4.9850000000000003}]
[null,null,null,null,null,{"$f":"CONCATENATE(A22,B24,\" / \",A22,B25)","v":"C11 / C14"},{"$f":"C24","v":"LEFRANC"},{"$f":"C25","v":"TRAVERS"},"Partagé",18,"LEFRANC / TRAVERS","C","SZAFIR / GERSON",{"$f":"IF(OR(G26=\"\",H26=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H26,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G26,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":1},{"$f":"IF(OR(G26=\"\",H26=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H26,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G26,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":1},"2018-06-29","Vaucouleurs - Vallons",{"$f":"IF(Q26=\"\",\"\",VLOOKUP(Q26,Parcours!$A$2:$B$130,2,FALSE))","v":18},"LEFRANC",1,0,"2UP","2",-2,{"$f":"W26+0.006","v":2.0059999999999998},{"$f":"X26+0.006","v":-1.994},null,null,null,null,null,null,null,null,null,{"$f":"4-COUNTBLANK(AJ22:AJ25)","v":4},{"$f":"IF(AJ26=2,1,IF(AJ26=3,3,6))","v":6},{"$f":"SUM(AK22:AK25)","v":6}]
[null,null,null,null,null,null,null,null,null,18,null,null,"ROBERT / GERSON"]
[null,null,null,null,null,{"$f":"CONCATENATE(A29,B29,\" / \",A29,B30)","v":"D2 / D7"},{"$f":"C29","v":"SZAFIR"},{"$f":"C30","v":"ROBERT"},"Partagé",19,{"$f":"IF(OR(G28=\"\",H28=\"\"),\"\",CONCATENATE(G28,\" / \",H28))","v":"SZAFIR / ROBERT"},"D","SZAFIR / ROME",{"$f":"IF(OR(G28=\"\",H28=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H28,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G28,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":4},{"$f":"IF(OR(G28=\"\",H28=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H28,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G28,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":2},"2018-05-26","Forges les Bains",{"$f":"IF(Q28=\"\",\"\",VLOOKUP(Q28,Parcours!$A$2:$B$130,2,FALSE))","v":18},"Partagé",{"$f":"IF(K28=\"\",0,IF(S28=G28,1,IF(S28=\"Partagé\",0.5,0)))","v":0.5},{"$f":"IF(K28=\"\",0,IF(S28=H28,1,IF(S28=\"Partagé\",0.5,0)))","v":0.5},"AS",{"$f":"IF(V28=\"\",0,IF(T28=0,-VLOOKUP(V28,$AA$7:$AB$25,2,FALSE),IF(T28=1,VLOOKUP(V28,$AA$7:$AB$25,2,FALSE),0)))","v":0},{"$f":"-W28","v":0},{"$f":"W28+0.001","v":1E-3},{"$f":"X28+0.001","v":1E-3}]
["D",2,{"$f":"IF((VLOOKUP(B29,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B29,Joueurs!A$4:C$19,3,FALSE))","v":"SZAFIR"},{"$f":"IF((VLOOKUP(B29,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B29,Joueurs!A$4:F$19,6,FALSE))","v":20.100000000000001},null,{"$f":"CONCATENATE(A29,B29,\" / \",A29,B31)","v":"D2 / D10"},{"$f":"C29","v":"SZAFIR"},{"$f":"C31","v":"GERSON"},"Partagé",20,"SZAFIR / GERSON","D","ROBERT / ROME",{"$f":"IF(OR(G29=\"\",H29=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H29,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G29,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":1},{"$f":"IF(OR(G29=\"\",H29=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H29,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G29,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":1},"2018-05-18","Gadancourt",{"$f":"IF(Q29=\"\",\"\",VLOOKUP(Q29,Parcours!$A$2:$B$130,2,FALSE))","v":18},"GERSON",0,1,"6&5",{"$f":"IF(V29=\"\",0,IF(T29=0,-VLOOKUP(V29,$AA$7:$AB$25,2,FALSE),IF(T29=1,VLOOKUP(V29,$AA$7:$AB$25,2,FALSE),0)))","v":-11},{"$f":"-W29","v":11},{"$f":"W29+0.002","v":-10.997999999999999},{"$f":"X29+0.002","v":11.002000000000001},null,null,null,"1D",{"$f":"C29","v":"SZAFIR"},{"$f":"IF(AE29=\"\",-1,SUMIF(G28:G33,AE29,T28:T33)+SUMIF(H28:H33,AE29,U28:U33))","v":0.5},{"$f":"SUMIF(G28:G33,AE29,Y28:Y33)+SUMIF(H28:H33,AE29,Z28:Z33)","v":-11.993},{"$f":"100*AF29+AG29","v":38.006999999999998},{"$f":"RANK(AH29,AH29:AH32)","v":4},{"$f":"IF(AE29=\"\",\"\",INDEX(AE29:AE32,MATCH(1,AI29:AI32,0)))","v":"ROME"},{"$f":"IF(AE29=\"\",\"\",VLOOKUP(AJ29,AE29:AF32,2,FALSE))","v":3},{"$f":"IF(AE29=\"\",\"\",VLOOKUP(AJ29,AE29:AG32,3,FALSE))","v":4.0149999999999997}]
["B",7,{"$f":"IF((VLOOKUP(B30,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B30,Joueurs!A$4:C$19,3,FALSE))","v":"ROBERT"},{"$f":"IF((VLOOKUP(B30,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B30,Joueurs!A$4:F$19,6,FALSE))","v":25},null,{"$f":"CONCATENATE(A29,B30,\" / \",A29,B31)","v":"D7 / D10"},{"$f":"C30","v":"ROBERT"},{"$f":"C31","v":"GERSON"},"Partagé",21,"ROBERT / GERSON","D","GERSON / ROME",{"$f":"IF(OR(G30=\"\",H30=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H30,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G30,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":-3},{"$f":"IF(OR(G30=\"\",H30=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H30,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G30,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":-1},"2018-07-30","National - Albatros",{"$f":"IF(Q30=\"\",\"\",VLOOKUP(Q30,Parcours!$A$2:$B$130,2,FALSE))","v":18},"GERSON",0,1,"6&4",-10,10,{"$f":"W30+0.003","v":-9.9969999999999999},{"$f":"X30+0.003","v":10.003},null,null,null,"2D",{"$f":"C30","v":"ROBERT"},{"$f":"IF(AE30=\"\",-1,SUMIF(G28:G33,AE30,T28:T33)+SUMIF(H28:H33,AE30,U28:U33))","v":0.5},{"$f":"SUMIF(G28:G33,AE30,Y28:Y33)+SUMIF(H28:H33,AE30,Z28:Z33)","v":-10.991},{"$f":"100*AF30+AG30","v":39.009},{"$f":"RANK(AH30,AH29:AH32)","v":3},{"$f":"IF(AE30=\"\",\"\",INDEX(AE29:AE32,MATCH(2,AI29:AI32,0)))","v":"GERSON"},{"$f":"IF(AE30=\"\",\"\",VLOOKUP(AJ30,AE29:AF32,2,FALSE))","v":2},{"$f":"IF(AE30=\"\",\"\",VLOOKUP(AJ30,AE29:AG32,3,FALSE))","v":19.011000000000003}]
[null,10,{"$f":"IF((VLOOKUP(B31,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B31,Joueurs!A$4:C$19,3,FALSE))","v":"GERSON"},{"$f":"IF((VLOOKUP(B31,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B31,Joueurs!A$4:F$19,6,FALSE))","v":21.6},null,{"$f":"CONCATENATE(A29,B29,\" / \",A29,B32)","v":"D2 / D15"},{"$f":"C29","v":"SZAFIR"},{"$f":"C32","v":"ROME"},"Partagé",22,"SZAFIR / ROME","D","",{"$f":"IF(OR(G31=\"\",H31=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H31,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G31,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":12},{"$f":"IF(OR(G31=\"\",H31=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H31,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G31,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":6},"2018-08-30","Tirage au sort",{"$f":"IF(Q31=\"\",\"\",VLOOKUP(Q31,Parcours!$A$2:$B$130,2,FALSE))","v":18},"ROME",{"$f":"IF(K31=\"\",0,IF(S31=G31,1,IF(S31=\"Partagé\",0.5,0)))","v":0},{"$f":"IF(K31=\"\",0,IF(S31=H31,1,IF(S31=\"Partagé\",0.5,0)))","v":1},"1UP",-1,1,{"$f":"W31+0.004","v":-0.996},{"$f":"X31+0.004","v":1.004},null,null,null,"3D",{"$f":"C31","v":"GERSON"},{"$f":"IF(AE31=\"\",-1,SUMIF(G28:G33,AE31,T28:T33)+SUMIF(H28:H33,AE31,U28:U33))","v":2},{"$f":"SUMIF(G28:G33,AE31,Y28:Y33)+SUMIF(H28:H33,AE31,Z28:Z33)","v":19.011000000000003},219.011,{"$f":"RANK(AH31,AH29:AH32)","v":2},{"$f":"IF(AE31=\"\",\"\",INDEX(AE29:AE32,MATCH(3,AI29:AI32,0)))","v":"ROBERT"},{"$f":"IF(AE31=\"\",\"\",VLOOKUP(AJ31,AE29:AF32,2,FALSE))","v":0.5},{"$f":"IF(AE31=\"\",\"\",VLOOKUP(AJ31,AE29:AG32,3,FALSE))","v":-10.991}]
[null,15,{"$f":"IF((VLOOKUP(B32,Joueurs!A$4:C$19,3,FALSE))=0,\"\",VLOOKUP(B32,Joueurs!A$4:C$19,3,FALSE))","v":"ROME"},{"$f":"IF((VLOOKUP(B32,Joueurs!A$4:F$19,3,FALSE))=0,\"\",VLOOKUP(B32,Joueurs!A$4:F$19,6,FALSE))","v":36},null,{"$f":"CONCATENATE(A29,B30,\" / \",A29,B32)","v":"D7 / D15"},{"$f":"C30","v":"ROBERT"},{"$f":"C32","v":"ROME"},"Partagé",23,"ROBERT / ROME","D","",{"$f":"IF(OR(G32=\"\",H32=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H32,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G32,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":8},{"$f":"IF(OR(G32=\"\",H32=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H32,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G32,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":4},"2018-05-18","Gadancourt",{"$f":"IF(Q32=\"\",\"\",VLOOKUP(Q32,Parcours!$A$2:$B$130,2,FALSE))","v":18},"ROME",{"$f":"IF(K32=\"\",0,IF(S32=G32,1,IF(S32=\"Partagé\",0.5,0)))","v":0},{"$f":"IF(K32=\"\",0,IF(S32=H32,1,IF(S32=\"Partagé\",0.5,0)))","v":1},"1UP",-1,1,{"$f":"W32+0.005","v":-0.995},{"$f":"X32+0.005","v":1.0049999999999999},null,null,null,"4D",{"$f":"C32","v":"ROME"},{"$f":"IF(AE32=\"\",-1,SUMIF(G28:G33,AE32,T28:T33)+SUMIF(H28:H33,AE32,U28:U33))","v":3},{"$f":"SUMIF(G28:G33,AE32,Y28:Y33)+SUMIF(H28:H33,AE32,Z28:Z33)","v":4.0149999999999997},304.01499999999999,{"$f":"RANK(AH32,AH29:AH32)","v":1},{"$f":"IF(AE32=\"\",\"\",INDEX(AE29:AE32,MATCH(4,AI29:AI32,0)))","v":"SZAFIR"},{"$f":"IF(AE32=\"\",\"\",VLOOKUP(AJ32,AE29:AF32,2,FALSE))","v":0.5},{"$f":"IF(AE32=\"\",\"\",VLOOKUP(AJ32,AE29:AG32,3,FALSE))","v":-11.993}]
[null,null,null,null,null,{"$f":"CONCATENATE(A29,B31,\" / \",A29,B32)","v":"D10 / D15"},{"$f":"C31","v":"GERSON"},{"$f":"C32","v":"ROME"},"Partagé",24,"GERSON / ROME","D",null,{"$f":"IF(OR(G33=\"\",H33=\"\"),\"\",MIN(27,ROUND(0.75*(VLOOKUP(H33,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G33,Joueurs!$C$4:$F$19,4,FALSE)),0)))","v":11},{"$f":"IF(OR(G33=\"\",H33=\"\"),\"\",ROUND(MIN(27,0.75*(VLOOKUP(H33,Joueurs!$C$4:$F$19,4,FALSE)-VLOOKUP(G33,Joueurs!$C$4:$F$19,4,FALSE)))/2,0))","v":5},"2018-05-26","Forges les Bains",{"$f":"IF(Q33=\"\",\"\",VLOOKUP(Q33,Parcours!$A$2:$B$130,2,FALSE))","v":18},"ROME",0,1,"2UP",-2,2,{"$f":"W33+0.006","v":-1.994},{"$f":"X33+0.006","v":2.0059999999999998},null,null,null,null,null,null,null,null,null,{"$f":"4-COUNTBLANK(AJ29:AJ32)","v":4},{"$f":"IF(AJ33=2,1,IF(AJ33=3,3,6))","v":6},{"$f":"SUM(AK29:AK32)","v":6}]
[]
["=> Cliquer sur le nom d'une rencontre pour accéder à sa feuille de match"]
["Hcp18 :",null,"nombre de coups reçus par le joueur de plus faible index sur un 18 trous"]
["Hcp9 : ",null,"nombre de coups reçus par le joueur de plus faible index sur un 9 trous"]
["Points :",null,"points notant la performance de la rencontre. AS=0, 1UP = 1, 2UP=2, 2&1=3, 3&1=4, 3&2=5, … Sert à départager les ex-aequos."]

{"sheet":"Tournoi","index":4,"n_rows":63,"n_cols":50,"rows_kept":63,"cut":false,"hidden":false,"merged":[[7,4,8,4],[7,5,8,5],[13,4,14,4],[13,5,14,5],[19,4,20,4],[19,5,20,5],[16,10,17,10],[16,11,17,11],[25,4,26,4],[25,5,26,5],[10,7,11,7],[10,8,11,8],[22,7,23,7],[22,8,23,8]]}
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Challenge 35 cuvée \",Cuvée,\" : tableau final\")","v":"Challenge 35 cuvée 2018 : tableau final"}]
[]
[]
[null,null,"1/4 finale (avant 8 oct.)"]
[null,null,null,null,"1/2 finale (avant 29 oct.)"]
[null,"1A",{"$f":"IF(OR(Poules!AK8>=Poules!$AJ$12-1,Poules!$AK$12=Poules!$AL$12),Poules!AJ8,\"\")","v":"MABILE"},null,{"$f":"IF(OR(C7=\"\",C10=\"\"),\"\",CONCATENATE(C7,\" / \",C10))","v":"MABILE / LEFRANC"}]
[null,null,{"$f":"C7","v":"MABILE"},"Saint Marc","MABILE","8&6"]
[null,null,{"$f":"C10","v":"LEFRANC"},"2018-09-26",null,null,null,"Finale (10 nov.)"]
[null,"2C",{"$f":"IF(OR(Poules!AK23>=Poules!$AJ$26-1,Poules!$AK$26=Poules!$AL$26),Poules!AJ23,\"\")","v":"LEFRANC"},null,null,null,null,{"$f":"IF(OR(E8=\"\",E14=\"\"),\"\",CONCATENATE(E8,\" / \",E14))","v":"MABILE / ROME"}]
[null,null,null,null,{"$f":"E8","v":"MABILE"},null,"Villennes","MABILE","3&2"]
[null,null,null,null,{"$f":"E14","v":"ROME"},null,"2018-11-02"]
[null,"1D",{"$f":"IF(OR(Poules!AK29>=Poules!$AJ$33-1,Poules!$AK$33=Poules!$AL$33),Poules!AJ29,\"\")","v":"ROME"},null,{"$f":"IF(OR(C13=\"\",C16=\"\"),\"\",CONCATENATE(C13,\" / \",C16))","v":"ROME / NGUYEN"}]
[null,null,{"$f":"C13","v":"ROME"},"Sologne","ROME","4&2"]
[null,null,{"$f":"C16","v":"NGUYEN"},"2018-09-22",null,null,null,null,null,null,"Vainqueur"]
[null,"2B",{"$f":"IF(OR(Poules!AK16>=Poules!$AJ$19-1,Poules!$AK$19=Poules!$AL$19),Poules!AJ16,\"\")","v":"NGUYEN"},null,null,null,null,null,null,null,{"$f":"IF(OR(H11=\"\",H23=\"\"),\"\",CONCATENATE(H11,\" / \",H23))","v":"MABILE / VINAY"}]
[null,null,null,null,null,null,null,{"$f":"H11","v":"MABILE"},null,"Fourqueux - Blanc Rouge","VINAY","7&5"]
[null,null,null,null,null,null,null,{"$f":"H23","v":"VINAY"},null,"2018-11-10"]
[null,"1C",{"$f":"IF(OR(Poules!AK22>=Poules!$AJ$26-1,Poules!$AK$26=Poules!$AL$26),Poules!AJ22,\"\")","v":"COULOMB"},null,{"$f":"IF(OR(C19=\"\",C22=\"\"),\"\",CONCATENATE(C19,\" / \",C22))","v":"COULOMB / BORDET"}]
[null,null,{"$f":"C19","v":"COULOMB"},"Saint Marc","COULOMB","2&1"]
[null,null,{"$f":"C22","v":"BORDET"},"2018-09-20"]
[null,"2A",{"$f":"IF(OR(Poules!AK9>=Poules!$AJ$12-1,Poules!$AK$12=Poules!$AL$12),Poules!AJ9,\"\")","v":"BORDET"},null,null,null,null,{"$f":"IF(OR(E20=\"\",E26=\"\"),\"\",CONCATENATE(E20,\" / \",E26))","v":"COULOMB / VINAY"}]
[null,null,null,null,{"$f":"E20","v":"COULOMB"},null,"La Chouette","VINAY","6&5"]
[null,null,null,null,{"$f":"E26","v":"VINAY"},null,"2018-10-23"]
[null,"2D",{"$f":"IF(OR(Poules!AK30>=Poules!$AJ$33-1,Poules!$AK$33=Poules!$AL$33),Poules!AJ30,\"\")","v":"GERSON"},null,{"$f":"IF(OR(C25=\"\",C28=\"\"),\"\",CONCATENATE(C25,\" / \",C28))","v":"GERSON / VINAY"}]
[null,null,{"$f":"C25","v":"GERSON"},"Marivaux","VINAY","4&2"]
[null,null,{"$f":"C28","v":"VINAY"},"2018-09-28"]
[null,"1B",{"$f":"IF(OR(Poules!AK15>=Poules!$AJ$19-1,Poules!$AK$19=Poules!$AL$19),Poules!AJ15,\"\")","v":"VINAY"}]
[]
[]
[null,null,null,"----- Rencontre Tournoi -----","Match","Date","Lieu",null,null,null,null,"Index",null,"Score joueur 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score joueur 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commentaire"]
[null,null,null,{"$f":"CONCATENATE(C7,\" / \",C10)","v":"MABILE / LEFRANC"},"1/4 de finale",{"$f":"IF(D9=\"\",\"\",D9)","v":"2018-09-26"},{"$f":"IF(D8=\"\",\"\",D8)","v":"Saint Marc"},null,null,null,null,17.3,32.700000000000003,4,5,6,5,5,4,5,7,3,4,5,3,6,5,3,7,5,5,4,7,9,6,6,5,8,9,4,7,"x",6,"x",5,3,6,5,6]
[null,null,null,{"$f":"CONCATENATE(C13,\" / \",C16)","v":"ROME / NGUYEN"},"1/4 de finale",{"$f":"IF(D15=\"\",\"\",D15)","v":"2018-09-22"},{"$f":"IF(D14=\"\",\"\",D14)","v":"Sologne"},null,null,null,null,20.3,36,6,8,9,5,6,5,8,4,6,4,5,6,6,9,5,6,5,7,6,"x",5,6,6,5,5,5,8,3,6,5,5,12,5,9,7,6,"Départ en shotgun du 10. Résultat effectif : ROME 4&2"]
[null,null,null,{"$f":"CONCATENATE(C19,\" / \",C22)","v":"COULOMB / BORDET"},"1/4 de finale",{"$f":"IF(D21=\"\",\"\",D21)","v":"2018-09-20"},{"$f":"IF(D20=\"\",\"\",D20)","v":"Saint Marc"},null,null,null,null,20.2,28.4,5,"x",6,8,7,4,7,6,6,6,6,4,8,6,4,8,4,5,5,6,"x",9,7,5,5,"x",4,7,7,6,7,6,5,8,6,5]
[null,null,null,{"$f":"CONCATENATE(C25,\" / \",C28)","v":"GERSON / VINAY"},"1/4 de finale",{"$f":"IF(D27=\"\",\"\",D27)","v":"2018-09-28"},{"$f":"IF(D26=\"\",\"\",D26)","v":"Marivaux"},null,null,null,null,20.5,21.6,5,7,4,5,5,5,6,3,6,5,4,8,6,5,6,7,5,6,5,7,4,6,8,4,6,3,7,5,5,5,7,6,5,8,5,6]
[null,null,null,{"$f":"CONCATENATE(E8,\" / \",E14)","v":"MABILE / ROME"},"1/2 finale",{"$f":"IF(G12=\"\",\"\",G12)","v":"2018-11-02"},{"$f":"IF(G11=\"\",\"\",G11)","v":"Villennes"},null,null,null,null,17.399999999999999,36,4,5,4,7,7,4,5,5,6,5,4,5,5,5,4,4,7,5,6,8,3,8,6,5,6,9,7,3,5,6,6,6,9,7,7,6]
[null,null,null,{"$f":"CONCATENATE(E20,\" / \",E26)","v":"COULOMB / VINAY"},"1/2 finale",{"$f":"IF(G24=\"\",\"\",G24)","v":"2018-10-23"},{"$f":"IF(G23=\"\",\"\",G23)","v":"La Chouette"},null,null,null,null,20.2,20.5,5,6,4,7,6,8,4,8,6,6,8,8,8,null,null,null,null,null,4,6,4,8,5,6,3,7,7,6,6,5,6]
[null,null,null,{"$f":"CONCATENATE(H11,\" / \",H23)","v":"MABILE / VINAY"},"Finale",{"$f":"IF(J18=\"\",\"\",J18)","v":"2018-11-10"},{"$f":"IF(J17=\"\",\"\",J17)","v":"Fourqueux - Blanc Rouge"},null,null,null,null,17.399999999999999,20.5,6,9,6,6,6,5,6,5,5,"x","x","x",4,5,5,6,6,3,3,7,6,5,6,4,6,6,5,8,6,6,2,6,5,6,"x",3]
[null,null,null,"----- Rencontre Poules -----"]
[null,null,null,{"$f":"Poules!M7","v":"MABILE / M'HAMDI"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D40,Poules!K7:Q33,2,FALSE))","v":"Poule A"},{"$f":"IF(VLOOKUP(D40,Poules!K7:Q33,6,FALSE)=\"\",\"\",VLOOKUP(D40,Poules!K7:Q33,6,FALSE))","v":"2018-06-24"},{"$f":"VLOOKUP(D40,Poules!K7:Q33,7,FALSE)","v":"Omaha Beach - Mer"},null,null,null,null,17.100000000000001,27.5,7,4,5,6,7,6,5,3,5,5,6,4,5,5,5,"x",5,5,7,5,"x",6,8,8,4,"x","x",5,9,"x",8,5,4,6,7,5]
[null,null,null,{"$f":"Poules!M8","v":"MABILE / BORDET"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D41,Poules!K8:Q34,2,FALSE))","v":"Poule A"},{"$f":"IF(VLOOKUP(D41,Poules!K8:Q34,6,FALSE)=\"\",\"\",VLOOKUP(D41,Poules!K8:Q34,6,FALSE))","v":"2018-05-03"},{"$f":"VLOOKUP(D41,Poules!K8:Q34,7,FALSE)","v":"Saint Aubin - Le Mesnil"},null,null,null,null,16.899999999999999,29.4,8,5,6,5,"x",5,5,4,6,5,5,5,6,6,"x",6,"x",5,10,6,9,6,6,"x",4,"x",6,5,7,6,6,"x",4,"x",4,6]
[null,null,null,{"$f":"Poules!M9","v":"M'HAMDI / BORDET"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D42,Poules!K9:Q36,2,FALSE))","v":"Poule A"},{"$f":"IF(VLOOKUP(D42,Poules!K9:Q35,6,FALSE)=\"\",\"\",VLOOKUP(D42,Poules!K9:Q35,6,FALSE))","v":"2018-05-26"},{"$f":"VLOOKUP(D42,Poules!K9:Q36,7,FALSE)","v":"Forges les Bains"},null,null,null,null,27.5,29.4,6,3,9,8,9,9,7,5,10,6,6,5,10,9,6,6,6,8,5,6,7,8,6,6,6,5,7,7,8,4,7,6,5,8,7,7,"Shotgun avec départ du trou 12. Résultat effectif : BORDET 6&5"]
[null,null,null,{"$f":"Poules!M10","v":"MABILE / PICARD"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D43,Poules!K10:Q37,2,FALSE))","v":"Poule A"},{"$f":"IF(VLOOKUP(D43,Poules!K10:Q36,6,FALSE)=\"\",\"\",VLOOKUP(D43,Poules!K10:Q36,6,FALSE))","v":"2018-06-23"},{"$f":"VLOOKUP(D43,Poules!K10:Q37,7,FALSE)","v":"Caen - Plaine Vallon"}]
[null,null,null,{"$f":"Poules!M11","v":"M'HAMDI / PICARD"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D44,Poules!K11:Q38,2,FALSE))","v":"Poule A"},{"$f":"IF(VLOOKUP(D44,Poules!K11:Q37,6,FALSE)=\"\",\"\",VLOOKUP(D44,Poules!K11:Q37,6,FALSE))","v":"2018-05-18"},{"$f":"VLOOKUP(D44,Poules!K11:Q38,7,FALSE)","v":"Gadancourt"},null,null,null,null,27.5,51,7,6,5,5,6,8,8,5,7,6,4,6,8,6,6,6,8,6,7,8,7,4,6,8,6,"x",4,7,7,8,5,"x",4,"x",8,6]
[null,null,null,{"$f":"Poules!M12","v":"BORDET / PICARD"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D45,Poules!K12:Q39,2,FALSE))","v":"Poule A"},{"$f":"IF(VLOOKUP(D45,Poules!K12:Q38,6,FALSE)=\"\",\"\",VLOOKUP(D45,Poules!K12:Q38,6,FALSE))","v":"2018-06-13"},{"$f":"VLOOKUP(D45,Poules!K12:Q39,7,FALSE)","v":"Rueil-Malmaison - 18T"},null,null,null,null,29.4,46,4,"x",9,4,4,5,4,5,4,4,6,8,5,5,5,"x",5,5,6,7,8,6,7,4,5,"x",3,4,6,"x",8,8,5,4,"x","x"]
[null,null,null,{"$f":"Poules!M13","v":"VINAY / NGUYEN"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D46,Poules!K13:Q40,2,FALSE))","v":"Poule B"},{"$f":"IF(VLOOKUP(D46,Poules!K13:Q39,6,FALSE)=\"\",\"\",VLOOKUP(D46,Poules!K13:Q39,6,FALSE))","v":"2018-07-26"},{"$f":"VLOOKUP(D46,Poules!K13:Q40,7,FALSE)","v":"National - Aigle"},null,null,null,null,20.5,23.1,5,5,4,4,4,3,7,7,4,4,5,5,6,5,5,4,5,4,6,6,6,4,5,6,8,7,7,5,5,6,5,6,7,6,6,4]
[null,null,null,{"$f":"Poules!M14","v":"VINAY / GATIGNOL"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D47,Poules!K14:Q41,2,FALSE))","v":"Poule B"},{"$f":"IF(VLOOKUP(D47,Poules!K14:Q40,6,FALSE)=\"\",\"\",VLOOKUP(D47,Poules!K14:Q40,6,FALSE))","v":"2018-06-29"},{"$f":"VLOOKUP(D47,Poules!K14:Q41,7,FALSE)","v":"Vaucouleurs - Vallons"},null,null,null,null,20.5,33.5,6,4,"x",4,6,5,3,7,6,5,5,5,6,4,4,5,5,5,5,4,8,5,6,5,7,"x",7,"x",5,4,7,6,7,6,5,5]
[null,null,null,{"$f":"Poules!M15","v":"NGUYEN / GATIGNOL"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D48,Poules!K15:Q42,2,FALSE))","v":"Poule B"},{"$f":"IF(VLOOKUP(D48,Poules!K15:Q41,6,FALSE)=\"\",\"\",VLOOKUP(D48,Poules!K15:Q41,6,FALSE))","v":"2018-06-06"},{"$f":"VLOOKUP(D48,Poules!K15:Q42,7,FALSE)","v":"Villennes"},null,null,null,null,23.1,33.5,5,5,5,5,5,"x",6,5,5,5,5,7,5,6,4,5,5,7,6,7,5,"x",6,4,8,5,7,4,7,6,6,9,6,6,9,"x"]
[null,null,null,{"$f":"Poules!M16","v":"VINAY / BOISSERPE"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D49,Poules!K16:Q43,2,FALSE))","v":"Poule B"},{"$f":"IF(VLOOKUP(D49,Poules!K16:Q42,6,FALSE)=\"\",\"\",VLOOKUP(D49,Poules!K16:Q42,6,FALSE))","v":"2018-05-18"},{"$f":"VLOOKUP(D49,Poules!K16:Q43,7,FALSE)","v":"Gadancourt"},null,null,null,null,20.5,34.5,5,5,4,4,6,7,6,5,5,6,4,6,5,5,5,"x",5,6,6,8,8,4,5,9,6,5,4,9,6,8,8,7,5,8,8,6]
[null,null,null,{"$f":"Poules!M17","v":"NGUYEN / BOISSERPE"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D50,Poules!K17:Q44,2,FALSE))","v":"Poule B"},{"$f":"IF(VLOOKUP(D50,Poules!K17:Q43,6,FALSE)=\"\",\"\",VLOOKUP(D50,Poules!K17:Q43,6,FALSE))","v":"2018-05-10"},{"$f":"VLOOKUP(D50,Poules!K17:Q44,7,FALSE)","v":"Cergy-Vauréal"}]
[null,null,null,{"$f":"Poules!M18","v":"GATIGNOL / BOISSERPE"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D51,Poules!K18:Q45,2,FALSE))","v":"Poule B"},{"$f":"IF(VLOOKUP(D51,Poules!K18:Q44,6,FALSE)=\"\",\"\",VLOOKUP(D51,Poules!K18:Q44,6,FALSE))","v":"2018-06-12"},{"$f":"VLOOKUP(D51,Poules!K18:Q45,7,FALSE)","v":"Cergy-Vauréal"},null,null,null,null,33.5,34.5,5,5,4,5,7,5,8,6,"x",8,8,5,8,6,9,8,5,9,7,5,7,4,6,5,6,6,7,7,9,6,7,"x",7,7,4,9]
[null,null,null,{"$f":"Poules!M19","v":"COULOMB / DOGUIN"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D52,Poules!K19:Q46,2,FALSE))","v":"Poule C"},{"$f":"IF(VLOOKUP(D52,Poules!K19:Q45,6,FALSE)=\"\",\"\",VLOOKUP(D52,Poules!K19:Q45,6,FALSE))","v":"2018-06-01"},{"$f":"VLOOKUP(D52,Poules!K19:Q46,7,FALSE)","v":"La Chouette"},null,null,null,null,20.2,24.7,6,5,4,5,6,6,3,7,6,5,8,5,7,4,6,7,6,5,7,8,9,8,7,7,6,5,5,4,9,5,11,5,6,10,3,10]
[null,null,null,{"$f":"Poules!M20","v":"COULOMB / LEFRANC"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D53,Poules!K20:Q47,2,FALSE))","v":"Poule C"},{"$f":"IF(VLOOKUP(D53,Poules!K20:Q46,6,FALSE)=\"\",\"\",VLOOKUP(D53,Poules!K20:Q46,6,FALSE))","v":"2018-05-11"},{"$f":"VLOOKUP(D53,Poules!K20:Q47,7,FALSE)","v":"Saint-Quentin - Rouge"},null,null,null,null,20.2,32.700000000000003,5,5,5,7,5,5,4,6,6,4,5,6,7,8,5,4,5,6,9,6,4,8,8,6,4,6,5,3,4,6,9,9,7,4,5,6,"A"]
[null,null,null,{"$f":"Poules!M21","v":"DOGUIN / LEFRANC"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D54,Poules!K21:Q48,2,FALSE))","v":"Poule C"},{"$f":"IF(VLOOKUP(D54,Poules!K21:Q47,6,FALSE)=\"\",\"\",VLOOKUP(D54,Poules!K21:Q47,6,FALSE))","v":"2018-07-13"},{"$f":"VLOOKUP(D54,Poules!K21:Q48,7,FALSE)","v":"Saint Aubin - Le Mesnil"},null,null,null,null,24.7,32.700000000000003,6,6,8,6,4,3,8,5,6,6,6,5,8,6,4,9,9,5,8,6,6,9,5,7,7,6,6,5,6,9,5,8,5,7,4,7]
[null,null,null,{"$f":"Poules!M22","v":"COULOMB / TRAVERS"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D55,Poules!K22:Q49,2,FALSE))","v":"Poule C"},{"$f":"IF(VLOOKUP(D55,Poules!K22:Q48,6,FALSE)=\"\",\"\",VLOOKUP(D55,Poules!K22:Q48,6,FALSE))","v":"2018-06-18"},{"$f":"VLOOKUP(D55,Poules!K22:Q49,7,FALSE)","v":"Villennes"},null,null,null,null,20.2,34.5,5,4,5,7,5,4,5,8,6,3,6,4,7,7,4,4,6,4,6,4,5,8,8,4,7,4,5,4,5,7,6,6,5,4,8,6]
[null,null,null,{"$f":"Poules!M23","v":"DOGUIN / TRAVERS"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D56,Poules!K23:Q50,2,FALSE))","v":"Poule C"},{"$f":"IF(VLOOKUP(D56,Poules!K23:Q49,6,FALSE)=\"\",\"\",VLOOKUP(D56,Poules!K23:Q49,6,FALSE))","v":"2018-07-11"},{"$f":"VLOOKUP(D56,Poules!K23:Q50,7,FALSE)","v":"Villennes"},null,null,null,null,24.7,34.5,6,4,4,5,7,3,8,4,4,6,4,6,6,5,5,7,6,4]
[null,null,null,{"$f":"Poules!M24","v":"LEFRANC / TRAVERS"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D57,Poules!K24:Q51,2,FALSE))","v":"Poule C"},{"$f":"IF(VLOOKUP(D57,Poules!K24:Q50,6,FALSE)=\"\",\"\",VLOOKUP(D57,Poules!K24:Q50,6,FALSE))","v":"2018-06-29"},{"$f":"VLOOKUP(D57,Poules!K24:Q51,7,FALSE)","v":"Vaucouleurs - Vallons"},null,null,null,null,32.700000000000003,34.5,6,6,7,4,6,5,3,6,8,7,5,3,6,8,4,8,9,4,3,6,7,3,7,6,7,7,7,7,9,4,8,5,7,3,6,6]
[null,null,null,{"$f":"Poules!M25","v":"SZAFIR / ROBERT"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D58,Poules!K25:Q52,2,FALSE))","v":"Poule D"},{"$f":"IF(VLOOKUP(D58,Poules!K25:Q51,6,FALSE)=\"\",\"\",VLOOKUP(D58,Poules!K25:Q51,6,FALSE))","v":"2018-05-26"},{"$f":"VLOOKUP(D58,Poules!K25:Q52,7,FALSE)","v":"Forges les Bains"},null,null,null,null,20.100000000000001,25,5,3,6,5,7,6,5,4,5,5,6,4,10,5,5,5,6,6,6,3,6,5,6,6,7,4,7,6,8,3,6,5,3,6,6,7,"Shotgun avec départ du trou 11. Résultat effectif : Partagé AS"]
[null,null,null,{"$f":"Poules!M26","v":"SZAFIR / GERSON"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D59,Poules!K26:Q53,2,FALSE))","v":"Poule D"},{"$f":"IF(VLOOKUP(D59,Poules!K26:Q52,6,FALSE)=\"\",\"\",VLOOKUP(D59,Poules!K26:Q52,6,FALSE))","v":"2018-05-18"},{"$f":"VLOOKUP(D59,Poules!K26:Q53,7,FALSE)","v":"Gadancourt"},null,null,null,null,20.100000000000001,31,8,4,7,5,4,6,5,3,5,8,5,5,6,7,6,7,6,5,5,4,6,4,6,7,4,5,3,5,4,6,5,5,5,4,4,6]
[null,null,null,{"$f":"Poules!M27","v":"ROBERT / GERSON"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D60,Poules!K27:Q54,2,FALSE))","v":"Poule D"},{"$f":"IF(VLOOKUP(D60,Poules!K27:Q53,6,FALSE)=\"\",\"\",VLOOKUP(D60,Poules!K27:Q53,6,FALSE))","v":"2018-07-30"},{"$f":"VLOOKUP(D60,Poules!K27:Q54,7,FALSE)","v":"National - Albatros"},null,null,null,null,22.8,25,7,6,7,6,9,6,"x",3,10,10,3,5,6,5,7,4,9,10,7,"x",8,6,7,7,8,4,7,"x",6,7,"x",7,9,"x",9,12]
[null,null,null,{"$f":"Poules!M28","v":"SZAFIR / ROME"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D61,Poules!K28:Q55,2,FALSE))","v":"Poule D"},{"$f":"IF(VLOOKUP(D61,Poules!K28:Q54,6,FALSE)=\"\",\"\",VLOOKUP(D61,Poules!K28:Q54,6,FALSE))","v":"2018-08-30"},{"$f":"VLOOKUP(D61,Poules!K28:Q55,7,FALSE)","v":"Tirage au sort"}]
[null,null,null,{"$f":"Poules!M29","v":"ROBERT / ROME"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D62,Poules!K29:Q56,2,FALSE))","v":"Poule D"},{"$f":"IF(VLOOKUP(D62,Poules!K29:Q55,6,FALSE)=\"\",\"\",VLOOKUP(D62,Poules!K29:Q55,6,FALSE))","v":"2018-05-18"},{"$f":"VLOOKUP(D62,Poules!K29:Q56,7,FALSE)","v":"Gadancourt"},null,null,null,null,25,45,6,6,6,6,6,7,6,6,4,6,4,6,6,5,4,7,6,6,8,5,6,6,5,8,7,4,8,"x",7,6,9,4,8,8,7,6]
[null,null,null,{"$f":"Poules!M30","v":"GERSON / ROME"},{"$f":"CONCATENATE(\"Poule \",VLOOKUP(D63,Poules!K30:Q57,2,FALSE))","v":"Poule D"},{"$f":"IF(VLOOKUP(D63,Poules!K30:Q56,6,FALSE)=\"\",\"\",VLOOKUP(D63,Poules!K30:Q56,6,FALSE))","v":"2018-05-26"},{"$f":"VLOOKUP(D63,Poules!K30:Q57,7,FALSE)","v":"Forges les Bains"},null,null,null,null,22.8,45,6,4,4,6,6,5,6,6,9,5,6,6,9,4,4,6,5,8,6,5,6,9,8,6,7,6,8,7,7,3,6,6,5,5,9,6,"Shotgun avec  départ du trou 15. Résultat effectif : ROME 2 UP"]

{"sheet":"Feuille de match","index":5,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,13,1,17],[4,5,4,11],[4,18,4,23],[7,11,9,11]]}
["ASIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scores"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Challenge 35  -  Rencontre : ","MABILE / VINAY",null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C7=\"\",C9=\"\"),\"\",CONCATENATE(C7,\" / \",C9))","v":""},null,{"$f":"VLOOKUP(LEFT(Rencontre_Tournoi,SEARCH(\"/\",Rencontre_Tournoi)-2),Joueurs!C$4:F$19,4,FALSE)","v":17.399999999999999},null,{"$f":"VLOOKUP(RIGHT(Rencontre_Tournoi,LEN(Rencontre_Tournoi)-SEARCH(\"/\",Rencontre_Tournoi)-1),Joueurs!C$4:F$19,4,FALSE)","v":20.5},null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,"Parcours : ",{"$f":"IF(Rencontre_Tournoi=\"\",\"\",IF(VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$G$63,4,FALSE)=\"\",\"\",VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$G$63,4,FALSE)))","v":"Fourqueux - Blanc Rouge"},null,null,null,null,null,null,null,"Trous :",{"$f":"IF(Rencontre_Tournoi=\"\",\"\",IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$B$130,2,FALSE)))","v":18},null,null,"Date : ",{"$f":"IF(Rencontre_Tournoi=\"\",\"\",IF(VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$F$63,3,FALSE)=\"\",\"\",VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$F$63,3,FALSE)))","v":"2018-11-10"},null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,{"$f":"IF(O3<Q3,LEFT(Rencontre_Tournoi,SEARCH(\"/\",Rencontre_Tournoi)-2),RIGHT(Rencontre_Tournoi,LEN(Rencontre_Tournoi)-SEARCH(\"/\",Rencontre_Tournoi)-1))","v":"MABILE"},{"$f":"IF((VLOOKUP(C8,Joueurs!C$4:F$19,1,FALSE))=0,\"\",CONCATENATE(VLOOKUP(C8,Joueurs!C$4:F$19,2,FALSE),\" \",VLOOKUP(C8,Joueurs!C$4:F$19,1,FALSE)))","v":"Claude MABILE"},null,null,null,null,"Index :",{"$f":"IF(VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$M$63,9,FALSE)=\"\",IF((VLOOKUP(C8,Joueurs!C$4:F$19,1,FALSE))=0,\"\",VLOOKUP(C8,Joueurs!C$4:F$19,4,FALSE)),VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$M$63,9,FALSE))","v":17.399999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[{"$f":"IF(Rencontre_Tournoi=\"\",\"\",IF(VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$G$63,2,FALSE)=\"\",\"\",VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$G$63,2,FALSE)))","v":"Finale"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Coups reçus par \",$C$10,\" :\")","v":"Coups reçus par VINAY :"},{"$f":"IF(OR(Trous=\"\",J8=\"\",J10=\"\"),\"\",ROUND(MIN(27,T9*(J10-J8))/(18/Trous),0))","v":2},0.75,null,null,null,null,null,6]
[null,null,{"$f":"IF(O3>=Q3,LEFT(Rencontre_Tournoi,SEARCH(\"/\",Rencontre_Tournoi)-2),RIGHT(Rencontre_Tournoi,LEN(Rencontre_Tournoi)-SEARCH(\"/\",Rencontre_Tournoi)-1))","v":"VINAY"},{"$f":"IF((VLOOKUP(C10,Joueurs!C$4:F$19,1,FALSE))=0,\"\",CONCATENATE(VLOOKUP(C10,Joueurs!C$4:F$19,2,FALSE),\" \",VLOOKUP(C10,Joueurs!C$4:F$19,1,FALSE)))","v":"Guillaume VINAY"},null,null,null,null,"Index :",{"$f":"IF(VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$M$63,10,FALSE)=\"\",IF((VLOOKUP(C10,Joueurs!C$4:F$19,1,FALSE))=0,\"\",VLOOKUP(C10,Joueurs!C$4:F$19,4,FALSE)),VLOOKUP(Rencontre_Tournoi,Tournoi!$D$32:$M$63,10,FALSE))","v":20.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
["Trou",1,{"$f":"B13+1","v":2},3,4,5,6,7,8,9,"Aller",null,10,{"$f":"M13+1","v":11},12,13,14,15,16,17,18,"Retour",null,"Total",null,10]
["Par ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B13+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C13+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D13+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E13+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F13+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G13+3,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H13+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I13+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J13+3,FALSE))","v":3},{"$f":"SUM(B14:J14)","v":36},null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M13+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N13+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O13+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P13+3,FALSE)))","v":3},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q13+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R13+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S13+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T13+3,FALSE)))","v":5},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U13+3,FALSE)))","v":3},{"$f":"SUM(M14:U14)","v":35},null,{"$f":"K14+V14","v":71},null,11]
["Handicap ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B13+22,FALSE))","v":15},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C13+22,FALSE))","v":7},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D13+22,FALSE))","v":13},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E13+22,FALSE))","v":1},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F13+22,FALSE))","v":11},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G13+22,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H13+22,FALSE))","v":17},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I13+22,FALSE))","v":9},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J13+22,FALSE))","v":5},null,null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M13+22,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N13+22,FALSE)))","v":8},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O13+22,FALSE)))","v":10},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P13+22,FALSE)))","v":6},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q13+22,FALSE)))","v":14},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R13+22,FALSE)))","v":18},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S13+22,FALSE)))","v":2},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T13+22,FALSE)))","v":12},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U13+22,FALSE)))","v":16},null,null,null,null,12]
[]
[]
[{"$f":"C8","v":"MABILE"}]
["Coups",6,9,6,6,6,5,6,5,5,{"$f":"IF(OR(COUNTIF(B19:J19,\"x\"),COUNTIF(B19:J19,\"\")),\"\",SUM(B19:J19))","v":54},null,"x","x","x",4,5,5,6,6,3,{"$f":"IF(OR(COUNTIF(M19:U19,\"x\"),COUNTIF(M19:U19,\"\")),\"\",SUM(M19:U19))","v":""},null,{"$f":"IF(OR(COUNTIF(B19:J19,\"x\"),COUNTIF(B19:J19,\"\"),COUNTIF(M19:U19,\"x\"),COUNTIF(M19:U19,\"\")),\"\",SUM(B19:J19,M19:U19))","v":""}]
["Position ",{"$f":"IF(OR(B19=\"\",B24=\"\",Trous=\"\"),\"\",IF(B28<>\"\",B28,IF(B27=0,\"AS\",IF(B27<0,CONCATENATE(ABS(B27),\" UP\"),\"\"))))","v":""},{"$f":"IF(OR(C19=\"\",C24=\"\",Trous=\"\"),\"\",IF(C28<>\"\",IF(B28<>\"\",\"\",IF(C27<0,C28,\"\")),IF(C27=0,\"AS\",IF(C27<0,CONCATENATE(ABS(C27),\" UP\"),\"\"))))","v":""},"","","","","","","",null,null,{"$f":"IF(OR(M19=\"\",M24=\"\",Trous=\"\"),\"\",IF(M28<>\"\",IF(J28<>\"\",\"\",IF(M27<0,M28,\"\")),IF(M27=0,\"AS\",IF(M27<0,CONCATENATE(ABS(M27),\" UP\"),\"\"))))","v":""},{"$f":"IF(OR(N19=\"\",N24=\"\",Trous=\"\"),\"\",IF(N28<>\"\",IF(M28<>\"\",\"\",IF(N27<0,N28,\"\")),IF(N27=0,\"AS\",IF(N27<0,CONCATENATE(ABS(N27),\" UP\"),\"\"))))","v":""},"","","","","","",{"$f":"IF(OR(U19=\"\",U24=\"\",Trous=\"\"),\"\",IF(U28<>\"\",IF(T28<>\"\",\"\",IF(U27<=0,U28,\"\"))))","v":""}]
[null,{"$f":"IF(OR(B19=\"\",B24=\"\",Trous<>'Feuille de match'!Trous,AND(B19=\"-\",B24=\"-\")),0,IF(AND(B19=\"x\",B24=\"x\"),0,IF(B19=\"x\",1,IF(B24=\"x\",-1,IF(B19+B25-B24>0,1,IF(B19+B25-B24<0,-1,0))))))","v":1},{"$f":"IF(OR(C19=\"\",C24=\"\",Trous<>'Feuille de match'!Trous,AND(C19=\"-\",C24=\"-\")),0,IF(AND(C19=\"x\",C24=\"x\"),0,IF(C19=\"x\",1,IF(C24=\"x\",-1,IF(C19+C25-C24>0,1,IF(C19+C25-C24<0,-1,0))))))","v":1},{"$f":"IF(OR(D19=\"\",D24=\"\",Trous<>'Feuille de match'!Trous,AND(D19=\"-\",D24=\"-\")),0,IF(AND(D19=\"x\",D24=\"x\"),0,IF(D19=\"x\",1,IF(D24=\"x\",-1,IF(D19+D25-D24>0,1,IF(D19+D25-D24<0,-1,0))))))","v":0},{"$f":"IF(OR(E19=\"\",E24=\"\",Trous<>'Feuille de match'!Trous,AND(E19=\"-\",E24=\"-\")),0,IF(AND(E19=\"x\",E24=\"x\"),0,IF(E19=\"x\",1,IF(E24=\"x\",-1,IF(E19+E25-E24>0,1,IF(E19+E25-E24<0,-1,0))))))","v":1},{"$f":"IF(OR(F19=\"\",F24=\"\",Trous<>'Feuille de match'!Trous,AND(F19=\"-\",F24=\"-\")),0,IF(AND(F19=\"x\",F24=\"x\"),0,IF(F19=\"x\",1,IF(F24=\"x\",-1,IF(F19+F25-F24>0,1,IF(F19+F25-F24<0,-1,0))))))","v":0},{"$f":"IF(OR(G19=\"\",G24=\"\",Trous<>'Feuille de match'!Trous,AND(G19=\"-\",G24=\"-\")),0,IF(AND(G19=\"x\",G24=\"x\"),0,IF(G19=\"x\",1,IF(G24=\"x\",-1,IF(G19+G25-G24>0,1,IF(G19+G25-G24<0,-1,0))))))","v":1},{"$f":"IF(OR(H19=\"\",H24=\"\",Trous<>'Feuille de match'!Trous,AND(H19=\"-\",H24=\"-\")),0,IF(AND(H19=\"x\",H24=\"x\"),0,IF(H19=\"x\",1,IF(H24=\"x\",-1,IF(H19+H25-H24>0,1,IF(H19+H25-H24<0,-1,0))))))","v":0},{"$f":"IF(OR(I19=\"\",I24=\"\",Trous<>'Feuille de match'!Trous,AND(I19=\"-\",I24=\"-\")),0,IF(AND(I19=\"x\",I24=\"x\"),0,IF(I19=\"x\",1,IF(I24=\"x\",-1,IF(I19+I25-I24>0,1,IF(I19+I25-I24<0,-1,0))))))","v":-1},{"$f":"IF(OR(J19=\"\",J24=\"\",Trous<>'Feuille de match'!Trous,AND(J19=\"-\",J24=\"-\")),0,IF(AND(J19=\"x\",J24=\"x\"),0,IF(J19=\"x\",1,IF(J24=\"x\",-1,IF(J19+J25-J24>0,1,IF(J19+J25-J24<0,-1,0))))))","v":0},null,null,{"$f":"IF(OR(M19=\"\",M24=\"\",Trous<>'Feuille de match'!Trous,AND(M19=\"-\",M24=\"-\")),0,IF(AND(M19=\"x\",M24=\"x\"),0,IF(M19=\"x\",1,IF(M24=\"x\",-1,IF(M19+M25-M24>0,1,IF(M19+M25-M24<0,-1,0))))))","v":1},{"$f":"IF(OR(N19=\"\",N24=\"\",Trous<>'Feuille de match'!Trous,AND(N19=\"-\",N24=\"-\")),0,IF(AND(N19=\"x\",N24=\"x\"),0,IF(N19=\"x\",1,IF(N24=\"x\",-1,IF(N19+N25-N24>0,1,IF(N19+N25-N24<0,-1,0))))))","v":1},{"$f":"IF(OR(O19=\"\",O24=\"\",Trous<>'Feuille de match'!Trous,AND(O19=\"-\",O24=\"-\")),0,IF(AND(O19=\"x\",O24=\"x\"),0,IF(O19=\"x\",1,IF(O24=\"x\",-1,IF(O19+O25-O24>0,1,IF(O19+O25-O24<0,-1,0))))))","v":1},{"$f":"IF(OR(P19=\"\",P24=\"\",Trous<>'Feuille de match'!Trous,AND(P19=\"-\",P24=\"-\")),0,IF(AND(P19=\"x\",P24=\"x\"),0,IF(P19=\"x\",1,IF(P24=\"x\",-1,IF(P19+P25-P24>0,1,IF(P19+P25-P24<0,-1,0))))))","v":1},{"$f":"IF(OR(Q19=\"\",Q24=\"\",Trous<>'Feuille de match'!Trous,AND(Q19=\"-\",Q24=\"-\")),0,IF(AND(Q19=\"x\",Q24=\"x\"),0,IF(Q19=\"x\",1,IF(Q24=\"x\",-1,IF(Q19+Q25-Q24>0,1,IF(Q19+Q25-Q24<0,-1,0))))))","v":-1},{"$f":"IF(OR(R19=\"\",R24=\"\",Trous<>'Feuille de match'!Trous,AND(R19=\"-\",R24=\"-\")),0,IF(AND(R19=\"x\",R24=\"x\"),0,IF(R19=\"x\",1,IF(R24=\"x\",-1,IF(R19+R25-R24>0,1,IF(R19+R25-R24<0,-1,0))))))","v":0},{"$f":"IF(OR(S19=\"\",S24=\"\",Trous<>'Feuille de match'!Trous,AND(S19=\"-\",S24=\"-\")),0,IF(AND(S19=\"x\",S24=\"x\"),0,IF(S19=\"x\",1,IF(S24=\"x\",-1,IF(S19+S25-S24>0,1,IF(S19+S25-S24<0,-1,0))))))","v":1},{"$f":"IF(OR(T19=\"\",T24=\"\",Trous<>'Feuille de match'!Trous,AND(T19=\"-\",T24=\"-\")),0,IF(AND(T19=\"x\",T24=\"x\"),0,IF(T19=\"x\",1,IF(T24=\"x\",-1,IF(T19+T25-T24>0,1,IF(T19+T25-T24<0,-1,0))))))","v":-1},{"$f":"IF(OR(U19=\"\",U24=\"\",Trous<>'Feuille de match'!Trous,AND(U19=\"-\",U24=\"-\")),0,IF(AND(U19=\"x\",U24=\"x\"),0,IF(U19=\"x\",1,IF(U24=\"x\",-1,IF(U19+U25-U24>0,1,IF(U19+U25-U24<0,-1,0))))))","v":0}]
[]
[{"$f":"C10","v":"VINAY"}]
["Coups",3,7,6,5,6,4,6,6,5,{"$f":"IF(OR(COUNTIF(B24:J24,\"x\"),COUNTIF(B24:J24,\"\")),\"\",SUM(B24:J24))","v":48},null,8,6,6,2,6,5,6,"x",3,{"$f":"IF(OR(COUNTIF(M24:U24,\"x\"),COUNTIF(M24:U24,\"\")),\"\",SUM(M24:U24))","v":""},null,{"$f":"IF(OR(COUNTIF(B24:J24,\"x\"),COUNTIF(B24:J24,\"\"),COUNTIF(M24:U24,\"x\"),COUNTIF(M24:U24,\"\")),\"\",SUM(B24:J24,M24:U24))","v":""}]
["Coups reçus ",{"$f":"IF(Parcours=\"\",\"\",IF(Coups_reçus-TRUNC(Coups_reçus/Trous)*Trous<B15,TRUNC(Coups_reçus/Trous),TRUNC(Coups_reçus/Trous)+1))","v":0},0,0,1,0,0,0,0,0,{"$f":"SUM(B25:J25)","v":1},null,{"$f":"IF(OR(Parcours=\"\",Trous=9),\"\",IF(Coups_reçus-TRUNC(Coups_reçus/Trous)*Trous<M15,TRUNC(Coups_reçus/Trous),TRUNC(Coups_reçus/Trous)+1))","v":0},0,0,0,0,0,1,0,0,{"$f":"SUM(M25:U25)","v":1},null,{"$f":"K25+V25","v":2}]
["Position ",{"$f":"IF(OR(B19=\"\",B24=\"\",Trous=\"\"),\"\",IF(B27=0,\"AS\",IF(B27>0,CONCATENATE(ABS(B27),\" UP\"),\"\")))","v":"1 UP"},{"$f":"IF(OR(C19=\"\",C24=\"\",Trous=\"\"),\"\",IF(C28<>\"\",IF(B28<>\"\",\"\",IF(C27>0,C28,\"\")),IF(C27=0,\"AS\",IF(C27>0,CONCATENATE(ABS(C27),\" UP\"),\"\"))))","v":"2 UP"},"2 UP","3 UP","3 UP","4 UP","4 UP","3 UP","3 UP",null,null,{"$f":"IF(OR(M19=\"\",M24=\"\",Trous=\"\"),\"\",IF(M28<>\"\",IF(J28<>\"\",\"\",IF(M27>0,M28,\"\")),IF(M27=0,\"AS\",IF(M27>0,CONCATENATE(ABS(M27),\" UP\"),\"\"))))","v":"4 UP"},{"$f":"IF(OR(N19=\"\",N24=\"\",Trous=\"\"),\"\",IF(N28<>\"\",IF(M28<>\"\",\"\",IF(N27>0,N28,\"\")),IF(N27=0,\"AS\",IF(N27>0,CONCATENATE(ABS(N27),\" UP\"),\"\"))))","v":"5 UP"},"6 UP","7&5","","","","",{"$f":"IF(OR(U19=\"\",U24=\"\",Trous=\"\"),\"\",IF(U28<>\"\",IF(T28<>\"\",\"\",IF(U27>=0,U28,\"\"))))","v":""}]
[null,{"$f":"B21","v":1},{"$f":"B27+C21","v":2},{"$f":"C27+D21","v":2},3,3,4,4,3,3,null,null,{"$f":"J27+M21","v":4},{"$f":"M27+N21","v":5},6,7,6,6,7,6,6]
[null,null,{"$f":"IF(B28<>\"\",B28,IF(AND(C19<>\"\",C24<>\"\",ABS(C27)>(Trous-C13)),CONCATENATE(ABS(C27),\"&\",Trous-C13),\"\"))","v":""},"","","","","","",{"$f":"IF(I28<>\"\",I28,IF(AND(J19<>\"\",J24<>\"\"),IF(ABS(J27)>(Trous-J13),CONCATENATE(ABS(J27),\" UP\"),IF(AND(J27=0,Trous=9),\"AS\",\"\")),\"\"))","v":""},null,null,{"$f":"IF(J28<>\"\",J28,IF(AND(M19<>\"\",M24<>\"\",ABS(M27)>(Trous-M13)),CONCATENATE(ABS(M27),\"&\",Trous-M13),\"\"))","v":""},{"$f":"IF(M28<>\"\",M28,IF(AND(N19<>\"\",N24<>\"\",ABS(N27)>(Trous-N13)),CONCATENATE(ABS(N27),\"&\",Trous-N13),\"\"))","v":""},"","7&5","7&5","7&5","7&5","7&5",{"$f":"IF(T28<>\"\",T28,IF(AND(U19<>\"\",U24<>\"\"),IF(ABS(U27)>(Trous-U13),CONCATENATE(ABS(U27),\" UP\"),IF(U27=0,\"AS\",\"\")),\"\"))","v":"7&5"}]
[null,{"$f":"IF(B27>0,Joueur2,IF(B27<0,Joueur1,\"Partagé\"))","v":"VINAY"},"VINAY","VINAY","VINAY","VINAY","VINAY","VINAY","VINAY","VINAY",null,null,{"$f":"IF(M27>0,Joueur2,IF(M27<0,Joueur1,\"Partagé\"))","v":"VINAY"},"VINAY","VINAY","VINAY","VINAY","VINAY","VINAY","VINAY","VINAY"]
[]
[null,null,null,null,null,null,null,null,null,null,"Résultat : ",{"$f":"IF(U28=\"\",\"\",CONCATENATE(U29,\"  \",U28))","v":"VINAY  7&5"}]
[]
["Commentaires"]

{"sheet":"Joueur 1","index":6,"n_rows":30,"n_cols":26,"rows_kept":30,"cut":false,"hidden":true,"merged":[[4,5,4,11],[4,18,4,23],[28,1,30,23]]}
["ASIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scores"]
[null,null,null,null,null,null,null,null,null,null,"Joueur 1 :",null,{"$f":"'Feuille de match'!D8","v":"Claude MABILE"},null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Parcours : ",{"$f":"'Feuille de match'!Parcours","v":"Fourqueux - Blanc Rouge"},null,null,null,null,null,null,null,"Trous :",{"$f":"'Feuille de match'!Trous","v":18},null,null,"Date : ",{"$f":"'Feuille de match'!S5:X5","v":"2018-11-10"},null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Index :",{"$f":"IF(VLOOKUP([0]!Rencontre_Tournoi,Tournoi!$D$32:$M$63,9,FALSE)=\"\",IF((VLOOKUP('Feuille de match'!Joueur1,Joueurs!C$4:F$19,1,FALSE))=0,\"\",VLOOKUP('Feuille de match'!Joueur1,Joueurs!C$4:F$19,4,FALSE)),VLOOKUP([0]!Rencontre_Tournoi,Tournoi!$D$32:$M$63,9,FALSE))","v":17.399999999999999},null,null,"Repère :",{"$f":"IF((VLOOKUP('Feuille de match'!Joueur1,Joueurs!C$4:C$19,1,FALSE))=0,\"\",VLOOKUP('Feuille de match'!Joueur1,Joueurs!C$4:I$19,7,FALSE))","v":"Jaune"},null,null,"Slope :",{"$f":"VLOOKUP(Parcours,Parcours!$A$2:$AV$130,MATCH(CONCATENATE(\"Slope \",F8),Parcours!A1:AV1,0),FALSE)","v":131},null,"SSS :",{"$f":"VLOOKUP(Parcours,Parcours!$A$2:$AV$130,MATCH(CONCATENATE(\"SSS \",F8),Parcours!A1:AV1,0),FALSE)","v":69.900000000000006},null,null,null,null,"Coups reçus :",{"$f":"MIN(TRUNC(B8*J8/113+M8-X12+0.5),54)","v":19},null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Trou",1,{"$f":"B11+1","v":2},3,4,5,6,7,8,9,"Aller",null,10,{"$f":"M11+1","v":11},12,13,14,15,16,17,18,"Retour",null,"Total",null,11]
["Par ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C11+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G11+3,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H11+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J11+3,FALSE))","v":3},{"$f":"SUM(B12:J12)","v":36},null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P11+3,FALSE)))","v":3},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T11+3,FALSE)))","v":5},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U11+3,FALSE)))","v":3},{"$f":"SUM(M12:U12)","v":35},null,{"$f":"K12+V12","v":71},null,12]
["Handicap ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B11+22,FALSE))","v":15},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C11+22,FALSE))","v":7},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D11+22,FALSE))","v":13},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E11+22,FALSE))","v":1},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F11+22,FALSE))","v":11},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G11+22,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H11+22,FALSE))","v":17},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I11+22,FALSE))","v":9},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J11+22,FALSE))","v":5},null,null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M11+22,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N11+22,FALSE)))","v":8},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O11+22,FALSE)))","v":10},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P11+22,FALSE)))","v":6},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q11+22,FALSE)))","v":14},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R11+22,FALSE)))","v":18},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S11+22,FALSE)))","v":2},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T11+22,FALSE)))","v":12},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U11+22,FALSE)))","v":16}]
["Coups reçus ",{"$f":"IF($S$8-TRUNC($S$8/18)*18<B13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<C13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},1,2,1,1,1,1,1,{"$f":"SUM(B14:J14)","v":10},null,{"$f":"IF($S$8-TRUNC($S$8/18)*18<M13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<N13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<O13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<P13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<Q13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<R13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<S13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<T13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<U13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"SUM(M14:U14)","v":9},null,{"$f":"K14+V14","v":19}]
[]
["Score brut ",{"$f":"IF('Feuille de match'!B19=\"\",\"\",'Feuille de match'!B19)","v":6},{"$f":"IF('Feuille de match'!C19=\"\",\"\",'Feuille de match'!C19)","v":9},{"$f":"IF('Feuille de match'!D19=\"\",\"\",'Feuille de match'!D19)","v":6},{"$f":"IF('Feuille de match'!E19=\"\",\"\",'Feuille de match'!E19)","v":6},{"$f":"IF('Feuille de match'!F19=\"\",\"\",'Feuille de match'!F19)","v":6},{"$f":"IF('Feuille de match'!G19=\"\",\"\",'Feuille de match'!G19)","v":5},{"$f":"IF('Feuille de match'!H19=\"\",\"\",'Feuille de match'!H19)","v":6},{"$f":"IF('Feuille de match'!I19=\"\",\"\",'Feuille de match'!I19)","v":5},{"$f":"IF('Feuille de match'!J19=\"\",\"\",'Feuille de match'!J19)","v":5},{"$f":"IF(OR(COUNTIF(B16:J16,\"x\"),COUNTIF(B16:J16,\"\")),\"\",SUM(B16:J16))","v":54},null,{"$f":"IF('Feuille de match'!M19=\"\",\"\",'Feuille de match'!M19)","v":"x"},{"$f":"IF('Feuille de match'!N19=\"\",\"\",'Feuille de match'!N19)","v":"x"},{"$f":"IF('Feuille de match'!O19=\"\",\"\",'Feuille de match'!O19)","v":"x"},{"$f":"IF('Feuille de match'!P19=\"\",\"\",'Feuille de match'!P19)","v":4},{"$f":"IF('Feuille de match'!Q19=\"\",\"\",'Feuille de match'!Q19)","v":5},{"$f":"IF('Feuille de match'!R19=\"\",\"\",'Feuille de match'!R19)","v":5},{"$f":"IF('Feuille de match'!S19=\"\",\"\",'Feuille de match'!S19)","v":6},{"$f":"IF('Feuille de match'!T19=\"\",\"\",'Feuille de match'!T19)","v":6},{"$f":"IF('Feuille de match'!U19=\"\",\"\",'Feuille de match'!U19)","v":3},{"$f":"IF(OR(COUNTIF(M16:U16,\"x\"),COUNTIF(M16:U16,\"\")),\"\",SUM(M16:U16))","v":""},null,{"$f":"IF(OR(COUNTIF(B16:J16,\"x\"),COUNTIF(B16:J16,\"\"),COUNTIF(M16:U16,\"x\"),COUNTIF(M16:U16,\"\")),\"\",SUM(B16:J16,M16:U16))","v":""}]
[]
["Stableford brut ",{"$f":"IF(B16=\"\",\"\",IF(B16=\"x\",0,MAX(0,B12-B16+2)))","v":0},{"$f":"IF(C16=\"\",\"\",IF(C16=\"x\",0,MAX(0,C12-C16+2)))","v":0},0,0,0,0,1,1,0,{"$f":"SUM(B18:J18)","v":2},null,{"$f":"IF(M16=\"\",\"\",IF(M16=\"x\",0,MAX(0,M12-M16+2)))","v":0},0,0,1,1,1,0,1,2,{"$f":"SUM(M18:U18)","v":6},null,{"$f":"K18+V18","v":8}]
["Stableford net ",{"$f":"IF(B16=\"\",\"\",IF(B16=\"x\",0,MAX(0,B12-B16+2+B14)))","v":1},{"$f":"IF(C16=\"\",\"\",IF(C16=\"x\",0,MAX(0,C12-C16+2+C14)))","v":0},1,2,1,1,2,2,1,11,null,{"$f":"IF(M16=\"\",\"\",IF(M16=\"x\",0,MAX(0,M12-M16+2+M14)))","v":0},0,0,2,2,2,1,2,3,12,null,{"$f":"K19+V19","v":23}]
[]
["Nb de putts "]
["Bunker de green "]
["Sortie & putt "]
["Fairway touché "]
["Manqué à gauche "]
["Manqué à droite "]
["Longueur drive "]
[]
[]
["Commentaires"]

{"sheet":"Joueur 2","index":7,"n_rows":30,"n_cols":26,"rows_kept":30,"cut":false,"hidden":true,"merged":[[4,5,4,11],[4,18,4,23],[28,1,30,23]]}
["ASIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scores"]
[null,null,null,null,null,null,null,null,null,null,"Joueur 2 :",null,{"$f":"'Feuille de match'!D10","v":"Guillaume VINAY"},null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Parcours : ",{"$f":"'Feuille de match'!Parcours","v":"Fourqueux - Blanc Rouge"},null,null,null,null,null,null,null,"Trous :",{"$f":"'Feuille de match'!Trous","v":18},null,null,"Date : ",{"$f":"'Feuille de match'!S5:X5","v":"2018-11-10"},null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Index :",{"$f":"IF(VLOOKUP([0]!Rencontre_Tournoi,Tournoi!$D$32:$M$63,10,FALSE)=\"\",IF((VLOOKUP('Feuille de match'!Joueur2,Joueurs!C$4:F$19,1,FALSE))=0,\"\",VLOOKUP('Feuille de match'!Joueur2,Joueurs!C$4:F$19,4,FALSE)),VLOOKUP([0]!Rencontre_Tournoi,Tournoi!$D$32:$M$63,10,FALSE))","v":20.5},null,null,"Repère :",{"$f":"IF((VLOOKUP('Feuille de match'!Joueur2,Joueurs!C$4:C$19,1,FALSE))=0,\"\",VLOOKUP('Feuille de match'!Joueur2,Joueurs!C$4:I$19,7,FALSE))","v":"Jaune"},null,null,"Slope :",{"$f":"VLOOKUP(Parcours,Parcours!$A$2:$AV$130,MATCH(CONCATENATE(\"Slope \",F8),Parcours!A1:AV1,0),FALSE)","v":131},null,"SSS :",{"$f":"VLOOKUP(Parcours,Parcours!$A$2:$AV$130,MATCH(CONCATENATE(\"SSS \",F8),Parcours!A1:AV1,0),FALSE)","v":69.900000000000006},null,null,null,null,"Coups reçus :",{"$f":"MIN(TRUNC(B8*J8/113+M8-X12+0.5),54)","v":23},null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Trou",1,{"$f":"B11+1","v":2},3,4,5,6,7,8,9,"Aller",null,10,{"$f":"M11+1","v":11},12,13,14,15,16,17,18,"Retour",null,"Total",null,11]
["Par ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C11+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G11+3,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H11+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J11+3,FALSE))","v":3},{"$f":"SUM(B12:J12)","v":36},null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P11+3,FALSE)))","v":3},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T11+3,FALSE)))","v":5},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U11+3,FALSE)))","v":3},{"$f":"SUM(M12:U12)","v":35},null,{"$f":"K12+V12","v":71},null,12]
["Handicap ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B11+22,FALSE))","v":15},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C11+22,FALSE))","v":7},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D11+22,FALSE))","v":13},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E11+22,FALSE))","v":1},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F11+22,FALSE))","v":11},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G11+22,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H11+22,FALSE))","v":17},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I11+22,FALSE))","v":9},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J11+22,FALSE))","v":5},null,null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M11+22,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N11+22,FALSE)))","v":8},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O11+22,FALSE)))","v":10},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P11+22,FALSE)))","v":6},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q11+22,FALSE)))","v":14},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R11+22,FALSE)))","v":18},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S11+22,FALSE)))","v":2},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T11+22,FALSE)))","v":12},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U11+22,FALSE)))","v":16}]
["Coups reçus ",{"$f":"IF($S$8-TRUNC($S$8/18)*18<B13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},{"$f":"IF($S$8-TRUNC($S$8/18)*18<C13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":1},1,2,1,2,1,1,2,{"$f":"SUM(B14:J14)","v":12},null,{"$f":"IF($S$8-TRUNC($S$8/18)*18<M13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":2},1,1,1,1,1,2,1,1,{"$f":"SUM(M14:U14)","v":11},null,{"$f":"K14+V14","v":23}]
[]
["Score brut ",{"$f":"IF('Feuille de match'!B24=\"\",\"\",'Feuille de match'!B24)","v":3},{"$f":"IF('Feuille de match'!C24=\"\",\"\",'Feuille de match'!C24)","v":7},{"$f":"IF('Feuille de match'!D24=\"\",\"\",'Feuille de match'!D24)","v":6},{"$f":"IF('Feuille de match'!E24=\"\",\"\",'Feuille de match'!E24)","v":5},{"$f":"IF('Feuille de match'!F24=\"\",\"\",'Feuille de match'!F24)","v":6},{"$f":"IF('Feuille de match'!G24=\"\",\"\",'Feuille de match'!G24)","v":4},{"$f":"IF('Feuille de match'!H24=\"\",\"\",'Feuille de match'!H24)","v":6},{"$f":"IF('Feuille de match'!I24=\"\",\"\",'Feuille de match'!I24)","v":6},{"$f":"IF('Feuille de match'!J24=\"\",\"\",'Feuille de match'!J24)","v":5},{"$f":"IF(OR(COUNTIF(B16:J16,\"x\"),COUNTIF(B16:J16,\"\")),\"\",SUM(B16:J16))","v":48},null,{"$f":"IF('Feuille de match'!M24=\"\",\"\",'Feuille de match'!M24)","v":8},{"$f":"IF('Feuille de match'!N24=\"\",\"\",'Feuille de match'!N24)","v":6},{"$f":"IF('Feuille de match'!O24=\"\",\"\",'Feuille de match'!O24)","v":6},{"$f":"IF('Feuille de match'!P24=\"\",\"\",'Feuille de match'!P24)","v":2},{"$f":"IF('Feuille de match'!Q24=\"\",\"\",'Feuille de match'!Q24)","v":6},{"$f":"IF('Feuille de match'!R24=\"\",\"\",'Feuille de match'!R24)","v":5},{"$f":"IF('Feuille de match'!S24=\"\",\"\",'Feuille de match'!S24)","v":6},{"$f":"IF('Feuille de match'!T24=\"\",\"\",'Feuille de match'!T24)","v":"x"},{"$f":"IF('Feuille de match'!U24=\"\",\"\",'Feuille de match'!U24)","v":3},{"$f":"IF(OR(COUNTIF(M16:U16,\"x\"),COUNTIF(M16:U16,\"\")),\"\",SUM(M16:U16))","v":""},null,{"$f":"IF(OR(COUNTIF(B16:J16,\"x\"),COUNTIF(B16:J16,\"\"),COUNTIF(M16:U16,\"x\"),COUNTIF(M16:U16,\"\")),\"\",SUM(B16:J16,M16:U16))","v":""}]
[]
["Stableford brut ",{"$f":"IF(B16=\"\",\"\",IF(B16=\"x\",0,MAX(0,B12-B16+2)))","v":3},0,0,1,0,1,1,0,{"$f":"IF(J16=\"\",\"\",IF(J16=\"x\",0,MAX(0,J12-J16+2)))","v":0},{"$f":"SUM(B18:J18)","v":6},null,{"$f":"IF(M16=\"\",\"\",IF(M16=\"x\",0,MAX(0,M12-M16+2)))","v":0},0,0,3,0,1,0,0,2,{"$f":"SUM(M18:U18)","v":6},null,{"$f":"K18+V18","v":12}]
["Stableford net ",{"$f":"IF(B16=\"\",\"\",IF(B16=\"x\",0,MAX(0,B12-B16+2+B14)))","v":4},1,1,3,1,3,2,1,{"$f":"IF(J16=\"\",\"\",IF(J16=\"x\",0,MAX(0,J12-J16+2+J14)))","v":2},18,null,{"$f":"IF(M16=\"\",\"\",IF(M16=\"x\",0,MAX(0,M12-M16+2+M14)))","v":0},1,1,4,1,2,2,0,3,14,null,{"$f":"K19+V19","v":32}]
[]
["Nb de putts "]
["Bunker de green "]
["Sortie & putt "]
["Fairway touché "]
["Manqué à gauche "]
["Manqué à droite "]
["Longueur drive "]
[]
[]
["Commentaires"]

{"sheet":"Indiv","index":8,"n_rows":30,"n_cols":26,"rows_kept":30,"cut":false,"hidden":true,"merged":[[4,5,4,11],[4,18,4,23],[28,1,30,23],[1,12,1,18]]}
["ASIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scores"]
[null,null,null,null,null,null,null,null,null,null,"Joueur :",null,"Alex NOREN",null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"Parcours : ","National - Albatros",null,null,null,null,null,null,null,"Trous :",{"$f":"IF(F5=\"\",\"\",VLOOKUP(F5,Parcours!$A$2:$B$130,2,FALSE))","v":18},null,null,"Date : ","2018-07-01",null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Index :",0,null,null,"Repère :","Blanc",null,null,"Slope :",{"$f":"VLOOKUP(Parcours,Parcours!$A$2:$AV$130,MATCH(CONCATENATE(\"Slope \",F8),Parcours!A1:AV1,0),FALSE)","v":155},null,"SSS :",{"$f":"VLOOKUP(Parcours,Parcours!$A$2:$AV$130,MATCH(CONCATENATE(\"SSS \",F8),Parcours!A1:AV1,0),FALSE)","v":73.8},null,null,null,null,"Coups reçus :",{"$f":"MIN(TRUNC(B8*J8/113+M8-X12+0.5),54)","v":2},null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Trou",1,{"$f":"B11+1","v":2},3,4,5,6,7,8,9,"Aller",null,10,{"$f":"M11+1","v":11},12,13,14,15,16,17,18,"Retour",null,"Total",null,11]
["Par ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C11+3,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D11+3,FALSE))","v":5},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H11+3,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I11+3,FALSE))","v":3},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J11+3,FALSE))","v":5},{"$f":"SUM(B12:J12)","v":36},null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N11+3,FALSE)))","v":3},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q11+3,FALSE)))","v":5},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S11+3,FALSE)))","v":3},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T11+3,FALSE)))","v":4},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U11+3,FALSE)))","v":5},{"$f":"SUM(M12:U12)","v":36},null,{"$f":"K12+V12","v":72},null,12]
["Handicap ",{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,B11+22,FALSE))","v":4},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,C11+22,FALSE))","v":6},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,D11+22,FALSE))","v":12},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,E11+22,FALSE))","v":8},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,F11+22,FALSE))","v":16},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,G11+22,FALSE))","v":18},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,H11+22,FALSE))","v":2},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,I11+22,FALSE))","v":14},{"$f":"IF(Parcours=\"\",\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,J11+22,FALSE))","v":10},null,null,{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,M11+22,FALSE)))","v":9},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,N11+22,FALSE)))","v":17},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,O11+22,FALSE)))","v":7},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,P11+22,FALSE)))","v":3},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,Q11+22,FALSE)))","v":11},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,R11+22,FALSE)))","v":1},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,S11+22,FALSE)))","v":13},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,T11+22,FALSE)))","v":5},{"$f":"IF(Parcours=\"\",\"\",IF(Trous=9,\"\",VLOOKUP(Parcours,Parcours!$A$2:$AN$130,U11+22,FALSE)))","v":15}]
["Coups reçus ",{"$f":"IF($S$8-TRUNC($S$8/18)*18<B13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":0},{"$f":"IF($S$8-TRUNC($S$8/18)*18<C13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":0},0,0,0,0,1,0,0,{"$f":"SUM(B14:J14)","v":1},null,{"$f":"IF($S$8-TRUNC($S$8/18)*18<M13,TRUNC($S$8/18),TRUNC($S$8/18)+1)","v":0},0,0,0,0,1,0,0,0,{"$f":"SUM(M14:U14)","v":1},null,{"$f":"K14+V14","v":2}]
[]
["Score brut ",4,2,5,5,3,4,4,3,5,{"$f":"IF(OR(COUNTIF(B16:J16,\"x\"),COUNTIF(B16:J16,\"\")),\"\",SUM(B16:J16))","v":35},null,4,3,3,4,5,4,2,3,4,{"$f":"IF(OR(COUNTIF(M16:U16,\"x\"),COUNTIF(M16:U16,\"\")),\"\",SUM(M16:U16))","v":32},null,{"$f":"IF(OR(COUNTIF(B16:J16,\"x\"),COUNTIF(B16:J16,\"\"),COUNTIF(M16:U16,\"x\"),COUNTIF(M16:U16,\"\")),\"\",SUM(B16:J16,M16:U16))","v":67}]
[]
["Stableford brut ",{"$f":"IF(B16=\"\",\"\",IF(B16=\"x\",0,MAX(0,B12-B16+2)))","v":2},3,2,1,3,2,2,2,{"$f":"IF(J16=\"\",\"\",IF(J16=\"x\",0,MAX(0,J12-J16+2)))","v":2},{"$f":"SUM(B18:J18)","v":19},null,{"$f":"IF(M16=\"\",\"\",IF(M16=\"x\",0,MAX(0,M12-M16+2)))","v":2},2,3,2,2,2,3,3,3,{"$f":"SUM(M18:U18)","v":22},null,{"$f":"K18+V18","v":41}]
["Stableford net ",{"$f":"IF(B16=\"\",\"\",IF(B16=\"x\",0,MAX(0,B12-B16+2+B14)))","v":2},3,2,1,3,2,3,2,{"$f":"IF(J16=\"\",\"\",IF(J16=\"x\",0,MAX(0,J12-J16+2+J14)))","v":2},20,null,{"$f":"IF(M16=\"\",\"\",IF(M16=\"x\",0,MAX(0,M12-M16+2+M14)))","v":2},2,3,2,2,3,3,3,3,23,null,{"$f":"K19+V19","v":43}]
[]
["Nb de putts "]
["Bunker de green "]
["Sortie & putt "]
["Fairway touché "]
["Manqué à gauche "]
["Manqué à droite "]
["Longueur drive "]
[]
[null,"Vainqueur de l'Open de France"]
["Commentaires"]