{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Engagements Pilotes","Tables","Données Courses","Modele","S1","OPEN","S2","S3+","S3+ MAT2","S3","S3 MAT2","S4+","S4+ MAT2","S4","S4 MAT2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":41,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Engagements Pilotes","index":0,"n_rows":85,"n_cols":39,"rows_kept":85,"cut":false,"hidden":false,"merged":[[44,0,60,0],[71,0,83,0],[84,0,84,16],[1,10,1,11],[14,0,20,0],[9,0,13,0],[21,0,33,0],[34,0,43,0],[61,0,70,0],[2,0,8,0]]}
[]
[null,"N°\nDossard","Nom","Prénom","Type et                        N° Licence","Catégorie","Ligue","Club","Date de\n naissance","Sexe","Validité\nLicence",null,"Moto.","Cyl.","Enga.","Payé","Observations"]
[null,null,null,null,null,"Expert"]
[null,null,null,null,null,"Expert"]
[null,null,null,null,null,"Expert"]
[null,null,null,null,null,"Expert"]
[null,null,null,null,null,"Expert"]
[null,null,null,null,null,"Expert"]
[null,null,null,null,null,"Expert"]
["De\n1 à 15\nTaille XL\nEt de\n16 à 20\nTaille L",1,"POIROT","Pierre","NTR 220715","S1","Grand Est","La Bressaude","2000-10-05","M",null,null,"GASGAS",300,"Complet","Non","OK"]
[null,2,"PACALIS","Adam","NTR 265793","S1","Grand Est","MC Stanislas","1996-02-23","M",null,null,"MONTESA",300,"Complet","Oui"]
[null,3,"THIRIAT","Lionel","NTR 300894","S1","Grand Est","AMVHV","2001-05-31","M",null,null,"TRRS",300,"Complet","Oui"]
[null,4,"FEIDT","Mathieu","NTR 059073","S1","Grand Est","TC Ban de la Roche","1982-01-30","M",null,null,"SHERCO",250,"Complet","Oui"]
[null,5,"GREMILLET","Alexandre","NTR 056371","S1","Grand Est","La Bressaude","1987-02-11","M",null,null,"GASGAS",300,"Complet","Non","OK"]
["De\n21 à 35 Taille XL\nEt de\n36 à 40 Taille L",21,"PIQUET","Steve","NTR 312485","OPEN","Bourg. - Fr Comté","TC Comptois","1987-09-24","M",null,null,"BETA",300,"Incomplet","Non","Doit 30 euros"]
[null,22,"BADET","Clément","NTR 056023","OPEN","Bourg. - Fr Comté","TC Comptois","1981-06-12","M",null,null,"TRRS",280,"Incomplet","Non","Doit 30 euros"]
[null,23,"DROUHIN","Neil","NTR 286005","OPEN","Bourg. - Fr Comté","TC Comptois","2002-08-13","M",null,null,"TRRS",300,"Incomplet","Non","Doit 30 euros"]
[null,24,"LAUCHER","Valentin","NTR 200198","OPEN","Grand Est","MC Zone 68","1996-02-11","M",null,null,"GASGAS",300,"Complet","Oui"]
[null,25,"POIROT","Louis","NTR 234487","OPEN","Grand Est","La Bressaude","2002-06-05","M",null,null,"GASGAS",280,"Complet","Oui","RENDRE 30 euros"]
[null,26,"NORMAND","Sebastien","LJA 055441-564","OPEN",null,"JOURNEE","1981-05-21","M",null,null,"BETA",300,"Complet","Oui","Controler licence"]
[null,27,"SABRIA LIORET","Joel","LJA 312865-564","OPEN",null,"JOURNEE","1975-07-02","M",null,null,"BETA",300,"Complet","Oui","ligue?"]
["De\n41 à 65 Taille XL \nEt de\n66 à 70 Taille L",41,"JEUDY","Adrien","NCO 331167","S2","Grand Est","RN 66","2001-10-11","M",null,null,"GASGAS",300,"Complet","Oui"]
[null,42,"POIROT","Kevin","NTR 106709","S2","Grand Est","La Bressaude","1987-07-14","M",null,null,"TRRS",300,"Complet","Non","OK"]
[null,43,"JACQUES","Julien","NTR 117187","S2","Grand Est","MC Stanislas","1988-07-08","M",null,null,"GASGAS",280,"Complet","Oui"]
[null,44,"PACALIS","Eric","NTR 018542","S2","Grand Est","MC Stanislas","1961-10-14","M",null,null,"VERTIGO",300,"Complet","Oui"]
[null,45,"TRIMOREAU","Stephane","NCO 250394","S2","Grand Est","MC Stanislas","1972-05-21","M",null,null,"MONTESA",260,"Complet","Oui"]
[null,46,"POIROT","Thierry","LJA 019778-564","S2","Grand Est","La Bressaude","1968-05-21","M",null,null,"GASGAS",300,"Complet","Non","OK"]
[null,47,"MAGEN-TERRASSE","Corentin","NTR 319153","S2","Grand Est","AMVHV","1994-01-29","M",null,null,"BETA",300,"Complet","Oui"]
[null,48,"PERNIN","Simon","NTR 260188","S2","Bourg. - Fr Comté","TC Comptois","1997-10-04","M",null,null,"GASGAS",300,"Complet","Oui"]
[null,49,"PIQUET","David","NTR 038065","S2","Bourg. - Fr Comté","TC Comptois","1972-11-29","M",null,null,"BETA",300,"Incomplet","Non","Doit 30 euros"]
[null,50,"PIQUET","Alois","NTR 287931","S2","Bourg. - Fr Comté","TC Comptois","2003-03-23","M",null,null,"BETA",125,"Incomplet","Non","Doit 30 euros"]
[null,51,"ANTOINE","Stephane","NTR 192504","S2","Grand Est","AMVHV","1974-07-31","M",null,null,"GASGAS",300,"Complet","Oui"]
[null,53,"MOREL","Alexandre","LJA 108917-056","S2","Grand Est","JOURNEE","1981-04-13","M",null,null,"BETA",270,"Incomplet","Non","Sous licence"]
[null,54,"PROST","Ayrton","NTR 205623","S2","Bourg. - Fr Comté","TC Comptois","1996-02-09","M",null,null,"BETA",300,"Complet","Oui"]
["De\n71 à 95 Taille XL Et de\n96 à 100 Taille L",71,"POIROT","Kevin","NTR 132374","S3+","Grand Est","La Bressaude","1992-11-16","M",null,null,"GASGAS",300,"Incomplet","Non","licence"]
[null,72,"POIROT","Hervé","NCO 019772","S3+","Grand Est","La Bressaude","1966-03-01","M",null,null,"MONTESA",260,"Complet","Non","OK"]
[null,73,"RIEGER","Denis","NTR 030508","S3+","Grand Est","TC Ban de la Roche","1960-03-15","M",null,null,"SHERCO",250,"Incomplet","Non","Doit 30 euros"]
[null,74,"MARTIN","Eric","NTR 016638","S3+","Grand Est","MC Stanislas","1967-12-28","M",null,null,"TRS",300,"Incomplet","Non","Doit 30 euros"]
[null,75,"BELLETTINI","Igor","NTR 288844","S3+","Bourg. - Fr Comté","TC Comptois","2006-05-06","M",null,null,"BETA",125,"Complet","Oui"]
[null,76,"BECK","Solène","NTR 263869","S3+","Grand Est","TC Ban de la Roche","2001-06-15","M",null,null,"SHERCO",250,"Complet","Oui"]
[null,77,"MELET","Denis","NTR 045027","S3+","Bourg. - Fr Comté","MC du Risoux","1963-04-02","M",null,null,"MONTESA",300,"Complet","Oui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NCO 013920"]
[null,78,"CUNAT","Jerome","NTR 007609","S3+","Grand Est","AMVHV","1975-04-07","M",null,null,"SHERCO",300,"Incomplet","Oui","Licence"]
[null,79,"SESSA","Marc","NTR 110020","S3+","Grand Est","ETLB","1991-01-05","M",null,null,"MONTESA",260,"Incomplet","Oui","Type licence et 30euro"]
[null,90,"GERLIER","Denis","NTR 011402","S3+ MAT2","Bourg. - Fr Comté","MC Bermont","1961-01-05","M",null,null,"HONDA",250,"Incomplet","Non","Doit 30 euros"]
["De\n101 à 145 Taille XL Et de\n146 à 150 Taille L",101,"HOLFERT","Dominique","NTR 013020","S3","Grand Est","TC Ban de la Roche","1957-10-24","M",null,null,"BETA",250,"Incomplet","Oui","Ligue?"]
[null,102,"PIERREL","Christophe","NCO 019494","S3","Grand Est","La Bressaude","1962-04-01","M",null,null,"MONTESA",260,"Complet","Non","OK"]
[null,103,"POIROT","Ethan","NJ3C 318948","S3","Grand Est","La Bressaude","2008-10-26","M",null,null,"BETA",125,"Complet","Non","Licence?"]
[null,104,"PETITJEAN","Marc","NTR 037880","S3","Grand Est","AMVHV","1960-04-11","M",null,null,"GASGAS",280,"Complet","Oui"]
[null,105,"NADOT","Marie","NTR 329543","S3","Grand Est","MC Stanislas","1989-03-01","F",null,null,"GASGAS",250,"Complet","Oui"]
[null,106,"POIROT","Joel","NTR 019775","S3","Grand Est","La Bressaude","1962-05-25","M",null,null,"BETA",300,"Complet","Non","OK"]
[null,107,"ALLHEILY","Jules","NTR 342860","S3","Grand Est","MC Zone 68","2005-06-14","M",null,null,"SCORPA",250,"Complet","Oui"]
[null,108,"BUCHER","Thomas","NTR 005409","S3","Grand Est","MC Zone 68","1969-05-23","M",null,null,"SHERCO",300,"Complet","Oui"]
[null,109,"CHRISTOPH","Claude","NTR 267647","S3","Grand Est","MC Stanislas","1965-08-13","M",null,null,"MONTESA",260,"Complet","Oui","Controler licence"]
[null,110,"THIEBAUT","Mathéo","NCO 340098","S3","Grand Est","La Bressaude","2002-04-26","M",null,null,"BETA",250,"Complet","Oui","Rendre 30 euros"]
[null,112,"COLIN","Jeremy","NTR 081748","S3","Grand Est","La Bressaude","1988-06-21","M",null,null,"HONDA TL",125,"Complet","Non","OK"]
[null,113,"EQUOY","Maxence","LJA 358767-564","S3",null,"JOURNEE","2006-09-25","M",null,null,"BETA",125,"Complet","Oui","Controler licence"]
[null,115,"SCHMIDLIN","Jean Luc","NTR 38884","S3","Bourg. - Fr Comté","TC Comptois","1964-05-25","M",null,null,"VERTIGO",250,"Incomplet","Non","Doit 30 euros"]
[null,116,"BALLAND","Florian","NTR 361550","S3","Grand Est","La Bressaude","2001-02-09","M",null,null,"GASGAS",250,"Incomplet","Non","A CONTROLER"]
[null,117,"ANTOINE","Aurelien","LJA 188981-056","S3","Grand Est","La Bressaude","1988-02-24","M",null,null,"SHERCO",290,"Incomplet","Non","Licence"]
[null,118,"VAXELAIRE","Gerald","NTR 039562","S3","Grand Est","La Bressaude","1972-05-24","M",null,null,"GASGAS",300,"Incomplet","Non","Licence"]
[null,140,"WEIBEL","Christian","MAT2 040920","S3 MAT2","Grand Est","TC Ban de la Roche","1959-03-24","M",null,null,"YAMAHA TY",250,"Incomplet","Oui"]
[null,151,"JEUDY","Justin","NTR 331168","S4+","Grand Est","RN 66","2005-01-21","M",null,null,"GASGAS",280,"Complet","Oui"]
[null,152,"POIROT","Noah","NJ3 318952","S4+","Grand Est","La Bressaude","2009-11-25","M",null,null,"SHERCO",125,"Complet","Non","Licence?"]
[null,153,"GREMILLET","Luc","NTR 081896","S4+","Grand Est","La Bressaude","1958-01-12","M",null,null,"VERTIGO",300,"Complet","Non","OK"]
[null,154,"SCHMITZ","Jean Paul","NTR 151263","S4+","Grand Est","MC Stanislas","1957-01-26","M",null,null,"BETA",300,"Complet","Oui"]
[null,155,"FLEURETTE","Mathieu","NTR 308338","S4+","Grand Est","La Bressaude","1983-08-13","M",null,null,"GASGAS",125,"Complet","Oui","Rendre 30 euros"]
[null,156,"TOUSSAINT","Laurent","NTR 260384","S4+","Grand Est","TC Ban de la Roche","1967-01-15","M",null,null,"SHERCO",250,"Complet","Oui"]
[null,157,"FEIDT","Martin","NTR 010125","S4+","Grand Est","TC Ban de la Roche","1953-01-07","M",null,null,"SHERCO",250,"Complet","Oui"]
[null,170,"POIRIER","Regis","MAT2 139683","S4+ MAT2","Grand Est","ETLB","1961-04-28","M",null,null,"YAMAHA TY",250,"Complet","Oui"]
[null,171,"DEREMARQUE","Jean Paul","MAT2 154364","S4+ MAT2","Grand Est","MC Epernay","1959-07-02","M",null,null,"YAMAHA TY",250,"Complet","Oui","Ligue?"]
[null,172,"WEBER","Christian","MAT2 286684","S4+ MAT2","Grand Est","ETLB","1962-07-07","M",null,null,"OSSA",250,"Complet","Oui"]
["De\n181 à 205 Taille XL Et de\n206 à 210 Taille L",181,"PIERREL","Charlotte","NCO 331170","S4","Grand Est","La Bressaude","2002-10-07","M",null,null,"SHERCO",125,"Complet","Non","OK"]
[null,182,"MANGIN","David","LJA 382075-564","S4",null,"JOURNEE","1989-10-07","M",null,null,"GASGAS",300,"Complet","Oui","Rendre 30 euros"]
[null,183,"NADOT","Camille","NTR 339275","S4","Grand Est","MC Stanislas","1995-06-06","M",null,null,"GASGAS",250,"Complet","Oui"]
[null,184,"RIVET","Jean Christophe","NTR 50899","S4","Grand Est","AMVHV","1966-07-03","M",null,null,"MONTESA",250,"Incomplet","Non","Doit 30 euros"]
[null,185,"CLAUDE","Zoe","NJ3C 364632","S4","Grand Est","AMVHV","2007-05-30","F",null,null,"GASGAS",125,"Complet","Oui"]
[null,187,"CROUVIZIER","Morgane","NTR 295688","S4","Grand Est","ETLB","1990-04-15","F",null,null,"BETA",270,"Incomplet",null,"Type licence et 30 euros"]
[null,206,"KARST","Nolan","NJ3C 403074","S4","Grand Est","MC Gazelec","2009-06-22","M",null,null,"BETA",50,"Incomplet",null,"Type licence et 30 euros"]
[null,207,"KARST","Leny","NJ3 403068","S4","Grand Est","MC Gazelec","2010-12-15","M",null,null,"BETA",50,"Incomplet",null,"Type licence et 30 euros"]
[null,208,"CAILLEAU","Tom","LJA 395153-564","S4",null,"JOURNEE","2010-10-28","M",null,null,"SHERCO",80,"Complet","Oui"]
[null,209,"CAILLEAU","Timothé","LJA 395075-564","S4",null,"JOURNEE","2008-08-12","M",null,null,"GASGAS",125,"Complet","Oui"]
[null,200,"THOMAS","Dominique","NTR 023004","S4 MAT2","Grand Est","MC Stanislas","1960-12-14","M",null,null,"TLR",125,"Complet","Oui"]
[null,201,"THOMAS","Nicolas","NTR 023012","S4 MAT2","Grand Est","MC Stanislas","1964-11-14","M",null,null,"HONDA",250,"Incomplet","Non","Doit 30 euros"]
[null,202,"FILLER","Jean Marc","MAT2 010275","S4 MAT2","Grand Est","TC Ban de la Roche","1956-04-29","M",null,null,"BULTACO",250,"Complet","Oui","cylindrée?"]
["Insérer IMPÉRATIVEMENT les nouveaux pilotes avant cette ligne."]

{"sheet":"Tables","index":1,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ligue","Club","Catégorie","Sexe","Type Licence","Moto","Cylindrée","Engagement","Payement"]
[null,"Auvergne Rhone Alpes","AMVHV","Expert","M","NTR","Beta","50cc","Incomplet","Oui"]
[null,"Bourg. - Fr Comté","Chaumont Enduro 52","S1","F","NCO","GasGas","80cc","Complet","Non"]
[null,"Bretagne","Enduro Extreme","OPEN",null,"NJ3","JTG","125cc"]
[null,"Centre","ETLB","S2",null,"MAT2","Montesa","250cc"]
[null,"Corse","Gazelec","S3+",null,"Journée","Ossa","280cc"]
[null,"Grand Est","Hermenonville","S3",null,"Autre","Scorpa","300cc"]
[null,"Guadeloupe","MC 3 Lys","S4+",null,null,"Sherco"]
[null,"Guyane","MC Amitié","S4",null,null,"Vertigo"]
[null,"Haut de France","MC Andlau","S3+ MAT2",null,null,"TRS"]
[null,"Ile de France","MC Ban de la Roche","S3 MAT2"]
[null,"La Reunion","MC Bergheim","S4+ MAT2"]
[null,"Martinique","MC Centre Alsace","S4 MAT2"]
[null,"Normandie","MC Charleville","Journée"]
[null,"Nouvelle Aquitaine","MC des Corbeaux"]
[null,"Nouvelle Caledonie","MC Epernay"]
[null,"Nouvelle Occitanie","MC Faulx"]
[null,"Pays de Loire","MC Granges"]
[null,"Provence","MC Gye"]
[null,null,"MC Haguenau"]
[null,null,"MC Haut Marnais"]
[null,null,"MC Haut Saonois"]
[null,null,"MC La Bressaude"]
[null,null,"MC Mazel"]
[null,null,"MC Munster"]
[null,null,"MC Neuville"]
[null,null,"MC Nogentais"]
[null,null,"MC Passion Vitesse"]
[null,null,"MC Portusien"]
[null,null,"MC Saint Dié"]
[null,null,"MC Saint Mihel"]
[null,null,"MC Saint Remy"]
[null,null,"MC Soultz"]
[null,null,"MC Stanislas"]
[null,null,"MC Viel Armand"]
[null,null,"MC Villars"]
[null,null,"MC Zone 68"]
[null,null,"MC Cercle de l'amitié"]
[null,null,"SEE"]
[null,null,"TCVB"]
[null,null,"TP55"]
[null,null,"Trial 70"]
[null,null,"UM Marne"]
[null,null,"Autres"]
[null,null,"AO Gazelec"]

{"sheet":"Données Courses","index":2,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":false,"merged":[[23,1,23,3],[2,6,2,7],[3,1,3,2],[5,1,5,2],[9,1,9,4],[10,1,10,3],[11,1,11,3],[13,1,13,3],[14,1,14,3],[12,1,12,3],[18,1,18,3],[22,8,22,10],[16,1,16,3],[17,1,17,3],[22,1,22,3],[15,1,15,3],[21,1,21,3],[19,1,19,3],[20,1,20,3]]}
[]
[]
[null,null,null,null,null,null,"Attribution des points"]
[null,"TEMPS DE COURSE",null,null,"08:30:00",null,1,20]
[null,null,null,null,null,null,2,17]
[null,"HEURE D'ARRIVÉE MAXI",null,null,"17:30:00",null,3,15]
[null,null,null,null,null,null,4,13]
[null,null,null,null,null,null,5,11]
[null,null,null,null,null,null,6,10]
[null,"Nombre de pilotes par catégorie",null,null,null,null,7,9]
[null,"Expert",null,null,0,null,8,8]
[null,"S1",null,null,5,null,9,7]
[null,"OPEN",null,null,7,null,10,6]
[null,"S2",null,null,13,null,10,6]
[null,"S3+",null,null,9,null,11,5]
[null,"S3",null,null,16,null,12,4]
[null,"S4+",null,null,7,null,13,3]
[null,"S4",null,null,10,null,14,2]
[null,"S3+ MAT2",null,null,1]
[null,"S3 MAT2",null,null,1]
[null,"S4+ MAT2",null,null,3]
[null,"S4 MAT2",null,null,3]
["Dont","Journée",null,null,0,null,15,1,"(Déjà compté dans le total)"]
[null,"TOTAL",null,null,{"$f":"SUM(E11:E22)","v":75},null,16,0]
[null,null,null,null,null,null,17,0]
[null,null,null,null,null,null,18,0]
[null,null,null,null,null,null,19,0]
[null,null,null,null,null,null,20,0]
[null,null,null,null,null,null,21,0]
[null,null,null,null,null,null,22,0]
[null,null,null,null,null,null,23,0]
[null,null,null,null,null,null,24,0]
[null,null,null,null,null,null,25,0]
[null,null,null,null,null,null,26,0]
[null,null,null,null,null,null,27,0]
[null,null,null,null,null,null,28,0]
[null,null,null,null,null,null,29,0]
[null,null,null,null,null,null,30,0]
[null,null,null,null,null,null,31,0]
[null,null,null,null,null,null,32,0]
[null,null,null,null,null,null,33,0]
[null,null,null,null,null,null,34,0]
[null,null,null,null,null,null,35,0]
[null,null,null,null,null,null,36,0]
[null,null,null,null,null,null,37,0]
[null,null,null,null,null,null,38,0]
[null,null,null,null,null,null,39,0]
[null,null,null,null,null,null,40,0]
[null,null,null,null,null,null,41,0]
[null,null,null,null,null,null,42,0]
[null,null,null,null,null,null,43,0]
[null,null,null,null,null,null,44,0]
[null,null,null,null,null,null,45,0]
[null,null,null,null,null,null,46,0]
[null,null,null,null,null,null,47,0]
[null,null,null,null,null,null,48,0]
[null,null,null,null,null,null,49,0]
[null,null,null,null,null,null,50,0]
[null,null,null,null,null,null,51,0]
[null,null,null,null,null,null,52,0]
[null,null,null,null,null,null,53,0]
[null,null,null,null,null,null,54,0]
[null,null,null,null,null,null,55,0]
[null,null,null,null,null,null,56,0]
[null,null,null,null,null,null,57,0]
[null,null,null,null,null,null,58,0]
[null,null,null,null,null,null,59,0]
[null,null,null,null,null,null,60,0]
[null,null,null,null,null,null,61,0]
[null,null,null,null,null,null,62,0]
[null,null,null,null,null,null,63,0]
[null,null,null,null,null,null,64,0]
[null,null,null,null,null,null,65,0]
[null,null,null,null,null,null,66,0]
[null,null,null,null,null,null,67,0]
[null,null,null,null,null,null,68,0]
[null,null,null,null,null,null,69,0]
[null,null,null,null,null,null,70,0]
[null,null,null,null,null,null,71,0]
[null,null,null,null,null,null,72,0]
[null,null,null,null,null,null,73,0]
[null,null,null,null,null,null,74,0]
[null,null,null,null,null,null,75,0]
[null,null,null,null,null,null,76,0]
[null,null,null,null,null,null,77,0]
[null,null,null,null,null,null,78,0]
[null,null,null,null,null,null,79,0]
[null,null,null,null,null,null,80,0]
[null,null,null,null,null,null,81,0]
[null,null,null,null,null,null,82,0]
[null,null,null,null,null,null,83,0]
[null,null,null,null,null,null,84,0]
[null,null,null,null,null,null,85,0]
[null,null,null,null,null,null,86,0]
[null,null,null,null,null,null,87,0]
[null,null,null,null,null,null,88,0]
[null,null,null,null,null,null,89,0]
[null,null,null,null,null,null,90,0]
[null,null,null,null,null,null,91,0]
[null,null,null,null,null,null,92,0]
[null,null,null,null,null,null,93,0]
[null,null,null,null,null,null,94,0]
[null,null,null,null,null,null,95,0]
[null,null,null,null,null,null,96,0]
[null,null,null,null,null,null,97,0]
[null,null,null,null,null,null,98,0]
[null,null,null,null,null,null,99,0]
[null,null,null,null,null,null,"Abd","NC"]
[null,null,null,null,null,null,"Disq","NC"]

{"sheet":"Modele","index":3,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,19,9,19],[3,5,4,5],[1,14,1,15],[3,10,3,11],[3,13,3,14],[3,6,4,6],[3,9,4,9],[1,7,1,12],[1,1,1,4],[7,1,8,1],[3,3,3,4],[3,8,4,8],[3,7,4,7],[4,1,5,1],[4,3,5,4],[6,2,8,4]]}
[]
[null,"CLASSEMENT",null,null,null,"Cat",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":1}]
[]
[null,"place","N°","NOM",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":0},null,null,null,{"$f":"P4","v":0}]
[null,99,"N° Licence","Prénom",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Ligue",null,null,"Heure Départ","00:00:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":0},{"$f":"SUM(K6:O6)","v":0},null,null,null,null,null,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":0},{"$f":"SUM(L6:L9)","v":0},{"$f":"SUM(M6:M9)","v":0}]
[null,"Pts Chpt","Club",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":0},{"$f":"SUM(K7:O7)","v":0}]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":0},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K8:O8)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"00:00:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]

{"sheet":"S1","index":4,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[17,10,17,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[31,9,32,9],[31,10,31,11],[31,13,31,14],[31,19,37,19],[32,1,33,1],[32,3,33,4],[34,2,36,4],[35,1,36,1],[31,3,31,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[24,19,30,19],[27,2,29,4],[28,1,29,1],[25,3,26,4],[25,1,26,1],[24,9,25,9],[24,8,25,8],[24,7,25,7],[24,6,25,6],[24,5,25,5],[24,13,24,14],[24,10,24,11],[24,3,24,4],[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4],[14,1,15,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,10,10,11],[10,13,10,14],[3,10,3,11],[3,13,3,14]]}
[]
[null,"CLASSEMENT",null,null,null,"S1",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":5}]
[]
[null,"place",5,"GREMILLET",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.19444444444444445},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":7},null,null,null,{"$f":"P4","v":7}]
[null,1,"NTR 056371","Alexandre",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:54:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":4},{"$f":"SUM(K6:O6)","v":12},10,1,0,1,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":31},{"$f":"SUM(L6:L9)","v":4},{"$f":"SUM(M6:M9)","v":0}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":2},{"$f":"SUM(K7:O7)","v":12},10,2,0,0,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","16:00:00","T3",1,{"$f":"SUM(K8:O8)","v":12},11,1,0,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:06:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",1,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":1.8055555555555556},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":65},null,null,null,{"$f":"P11","v":65}]
[null,2,"NTR 220715","Pierre",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:02:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":29},{"$f":"SUM(K13:O13)","v":12},3,0,2,5,2,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":8},{"$f":"SUM(L13:L16)","v":9},{"$f":"SUM(M13:M16)","v":7}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":22},{"$f":"SUM(K14:O14)","v":12},3,2,3,3,1]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","17:23:00","T3",14,{"$f":"SUM(K15:O15)","v":12},2,7,2,1,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"07:21:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",4,"FEIDT",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":2.3888888888888888},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":86},null,null,null,{"$f":"P18","v":86}]
[null,3,"NTR 059073","Mathieu",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:13:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":42},{"$f":"SUM(K20:O20)","v":12},0,2,2,2,6,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":4},{"$f":"SUM(L20:L23)","v":11},{"$f":"SUM(M20:M23)","v":6}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":25},{"$f":"SUM(K21:O21)","v":12},1,5,2,2,2]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","17:19:00","T3",19,{"$f":"SUM(K22:O22)","v":12},3,4,2,2,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"07:06:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",2,"PACALIS",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":3.2222222222222223},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":116},null,null,null,{"$f":"P25","v":116}]
[null,4,"NTR 265793","Adam",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:16:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":38},{"$f":"SUM(K27:O27)","v":12},3,1,1,0,7,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":7},{"$f":"SUM(L27:L30)","v":3},{"$f":"SUM(M27:M30)","v":3}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":35},{"$f":"SUM(K28:O28)","v":12},2,2,1,2,5]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","17:28:00","T3",43,{"$f":"SUM(K29:O29)","v":12},2,0,1,2,7]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"08:12:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",3,"THIRIAT",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":4.1111111111111107},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":148},null,null,null,{"$f":"P32","v":148}]
[null,5,"NTR 300894","Lionel",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:53:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":28},{"$f":"SUM(K34:O34)","v":12},3,3,1,1,4,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":3},{"$f":"SUM(L34:L37)","v":3},{"$f":"SUM(M34:M37)","v":1}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":60},{"$f":"SUM(K35:O35)","v":12},0,0,0,0,12]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","16:50:00","T3",60,{"$f":"SUM(K36:O36)","v":12},0,0,0,0,12]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"06:57:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]

{"sheet":"OPEN","index":5,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,10,38,11],[38,13,38,14],[38,19,44,19],[39,1,40,1],[39,3,40,4],[41,2,43,4],[42,1,43,1],[38,3,38,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[31,10,31,11],[31,13,31,14],[31,19,37,19],[32,1,33,1],[32,3,33,4],[34,2,36,4],[35,1,36,1],[31,3,31,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[31,9,32,9],[10,10,10,11],[10,13,10,14],[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4],[14,1,15,1],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[24,10,24,11],[24,13,24,14],[24,19,30,19],[25,1,26,1],[25,3,26,4],[27,2,29,4],[28,1,29,1],[24,3,24,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[17,9,18,9],[17,10,17,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[45,19,51,19],[48,2,50,4],[49,1,50,1],[46,3,47,4],[46,1,47,1],[45,9,46,9],[45,8,46,8],[45,7,46,7],[45,6,46,6],[45,5,46,5],[45,13,45,14],[45,10,45,11],[45,3,45,4],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[3,13,3,14]]}
[]
[null,"CLASSEMENT",null,null,null,"OPEN",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":7}]
[]
[null,"place",21,"PIQUET",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":2.0833333333333335},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":75},null,null,null,{"$f":"P4","v":75}]
[null,1,"NTR 312485","Steve",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:43:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":32},{"$f":"SUM(K6:O6)","v":12},3,2,1,1,5,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":13},{"$f":"SUM(L6:L9)","v":5},{"$f":"SUM(M6:M9)","v":4}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":20},{"$f":"SUM(K7:O7)","v":12},4,3,2,1,2]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","16:10:00","T3",23,{"$f":"SUM(K8:O8)","v":12},6,0,1,2,3]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:27:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",25,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":2.25},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":81},null,null,null,{"$f":"P11","v":81}]
[null,2,"NTR 234487","Louis",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:03:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":34},{"$f":"SUM(K13:O13)","v":12},3,0,1,4,4,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":11},{"$f":"SUM(L13:L16)","v":4},{"$f":"SUM(M13:M16)","v":4}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":21},{"$f":"SUM(K14:O14)","v":12},4,2,3,1,2]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","17:24:00","T3",26,{"$f":"SUM(K15:O15)","v":12},4,2,0,3,3]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"07:21:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",23,"DROUHIN",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":2.25},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":81},null,null,null,{"$f":"P18","v":81}]
[null,3,"NTR 286005","Neil",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:44:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":28},{"$f":"SUM(K20:O20)","v":12},3,1,3,2,3,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":10},{"$f":"SUM(L20:L23)","v":4},{"$f":"SUM(M20:M23)","v":7}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":32},{"$f":"SUM(K21:O21)","v":12},3,0,3,2,4]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","17:13:00","T3",21,{"$f":"SUM(K22:O22)","v":12},4,3,1,2,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"07:29:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",24,"LAUCHER",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":2.3611111111111112},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":85},null,null,null,{"$f":"P25","v":85}]
[null,4,"NTR 200198","Valentin",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:51:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":35},{"$f":"SUM(K27:O27)","v":12},1,2,2,3,4,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":8},{"$f":"SUM(L27:L30)","v":8},{"$f":"SUM(M27:M30)","v":5}]
[null,"Pts Chpt","MC Zone 68",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":26},{"$f":"SUM(K28:O28)","v":12},2,4,2,1,3]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","16:54:00","T3",24,{"$f":"SUM(K29:O29)","v":12},5,2,1,0,4]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"07:03:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",26,"NORMAND",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":2.4444444444444446},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":88},null,null,null,{"$f":"P32","v":88}]
[null,5,"LJA 055441-564","Sebastien",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,null,null,null,"Heure Départ","09:58:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":32},{"$f":"SUM(K34:O34)","v":12},2,3,2,0,5,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":8},{"$f":"SUM(L34:L37)","v":8},{"$f":"SUM(M34:M37)","v":2}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":35},{"$f":"SUM(K35:O35)","v":12},1,3,0,4,4]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","17:23:00","T3",21,{"$f":"SUM(K36:O36)","v":12},5,2,0,3,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"07:25:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]
[]
[null,"place",27,"SABRIA LIORET",null,"Moyenne par zone",{"$f":"IF(SUM(J41:J44)=0,0,(SUM(L41:L44)*1+SUM(M41:M44)*2+SUM(N41:N44)*3+SUM(O41:O44)*5)/SUM(J41:J44))","v":2.9444444444444446},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R41","v":0},"TOTAL",null,{"$f":"IF(OR(P41=\"Disq\",P42=\"Disq\",P43=\"Disq\",P44=\"Disq\",R41=\"HC\"),\"Disq\",IF(OR(P41=\"Abd\",P42=\"Abd\",P43=\"Abd\",P44=\"Abd\"),\"Abd\",SUM(I41:I44)+M39))","v":106},null,null,null,{"$f":"P39","v":106}]
[null,6,"LJA 312865-564","Joel",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,null,null,null,"Heure Départ","09:18:00","T1",{"$f":"IF(OR(P41=\"Disq\",P41=\"Abd\"),P41,(L41*1)+(M41*2)+(N41*3)+(O41*5)+P41)","v":35},{"$f":"SUM(K41:O41)","v":12},1,3,0,4,4,null,null,{"$f":"IF(G43>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K41:K44)","v":5},{"$f":"SUM(L41:L44)","v":6},{"$f":"SUM(M41:M44)","v":3}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P42=\"Disq\",P42=\"Abd\"),P42,(L42*1)+(M42*2)+(N42*3)+(O42*5)+P42)","v":38},{"$f":"SUM(K42:O42)","v":12},1,3,1,1,6]
[null,{"$f":"VLOOKUP(B40,Attribution_des_points,2,FALSE)","v":10},null,null,null,"Heure Arrivée","15:52:00","T3",33,{"$f":"SUM(K43:O43)","v":12},3,0,2,3,4]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G43=0,0,G43-G41)","v":"06:34:00"},"T4",0,{"$f":"SUM(K44:O44)","v":0}]
[]
[null,"place",22,"BADET",null,"Moyenne par zone",{"$f":"IF(SUM(J48:J51)=0,0,(SUM(L48:L51)*1+SUM(M48:M51)*2+SUM(N48:N51)*3+SUM(O48:O51)*5)/SUM(J48:J51))","v":2.9444444444444446},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R48","v":0},"TOTAL",null,{"$f":"IF(OR(P48=\"Disq\",P49=\"Disq\",P50=\"Disq\",P51=\"Disq\",R48=\"HC\"),\"Disq\",IF(OR(P48=\"Abd\",P49=\"Abd\",P50=\"Abd\",P51=\"Abd\"),\"Abd\",SUM(I48:I51)+M46))","v":106},null,null,null,{"$f":"P46","v":106}]
[null,7,"NTR 056023","Clément",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:59:00","T1",{"$f":"IF(OR(P48=\"Disq\",P48=\"Abd\"),P48,(L48*1)+(M48*2)+(N48*3)+(O48*5)+P48)","v":35},{"$f":"SUM(K48:O48)","v":12},0,4,1,3,4,null,null,{"$f":"IF(G50>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K48:K51)","v":2},{"$f":"SUM(L48:L51)","v":9},{"$f":"SUM(M48:M51)","v":4}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P49=\"Disq\",P49=\"Abd\"),P49,(L49*1)+(M49*2)+(N49*3)+(O49*5)+P49)","v":37},{"$f":"SUM(K49:O49)","v":12},1,2,2,2,5]
[null,{"$f":"VLOOKUP(B47,Attribution_des_points,2,FALSE)","v":9},null,null,null,"Heure Arrivée","17:23:00","T3",34,{"$f":"SUM(K50:O50)","v":12},1,3,1,3,4]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G50=0,0,G50-G48)","v":"07:24:00"},"T4",0,{"$f":"SUM(K51:O51)","v":0}]

{"sheet":"S2","index":6,"n_rows":93,"n_cols":23,"rows_kept":93,"cut":false,"hidden":false,"merged":[[45,19,51,19],[46,1,47,1],[46,3,47,4],[48,2,50,4],[49,1,50,1],[45,3,45,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[73,19,79,19],[74,1,75,1],[74,3,75,4],[76,2,78,4],[77,1,78,1],[73,3,73,4],[73,5,74,5],[73,6,74,6],[73,7,74,7],[73,8,74,8],[73,9,74,9],[38,19,44,19],[39,1,40,1],[39,3,40,4],[41,2,43,4],[42,1,43,1],[38,3,38,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[66,19,72,19],[67,1,68,1],[67,3,68,4],[69,2,71,4],[70,1,71,1],[66,3,66,4],[66,5,67,5],[66,6,67,6],[66,7,67,7],[66,8,67,8],[66,9,67,9],[24,19,30,19],[25,1,26,1],[25,3,26,4],[27,2,29,4],[28,1,29,1],[24,3,24,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[31,19,37,19],[32,1,33,1],[32,3,33,4],[34,2,36,4],[35,1,36,1],[31,3,31,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[31,9,32,9],[80,19,86,19],[81,1,82,1],[81,3,82,4],[83,2,85,4],[84,1,85,1],[80,3,80,4],[80,5,81,5],[80,6,81,6],[80,7,81,7],[80,8,81,8],[80,9,81,9],[3,10,3,11],[3,13,3,14],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[87,19,93,19],[88,1,89,1],[88,3,89,4],[90,2,92,4],[91,1,92,1],[87,3,87,4],[87,5,88,5],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,9,88,9],[14,1,15,1],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[87,10,87,11],[87,13,87,14],[80,10,80,11],[80,13,80,14],[31,10,31,11],[31,13,31,14],[24,10,24,11],[24,13,24,14],[66,10,66,11],[66,13,66,14],[38,10,38,11],[38,13,38,14],[73,10,73,11],[73,13,73,14],[45,10,45,11],[45,13,45,14],[59,13,59,14],[59,19,65,19],[60,1,61,1],[60,3,61,4],[62,2,64,4],[63,1,64,1],[17,13,17,14],[17,10,17,11],[17,3,17,4],[59,3,59,4],[59,5,60,5],[59,6,60,6],[59,7,60,7],[59,8,60,8],[59,9,60,9],[59,10,59,11],[17,19,23,19],[20,2,22,4],[21,1,22,1],[18,3,19,4],[18,1,19,1],[17,9,18,9],[17,8,18,8],[17,7,18,7],[17,6,18,6],[17,5,18,5],[52,13,52,14],[52,19,58,19],[53,1,54,1],[53,3,54,4],[55,2,57,4],[56,1,57,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[52,3,52,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[52,9,53,9],[52,10,52,11],[10,10,10,11],[10,13,10,14],[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4]]}
[]
[null,"CLASSEMENT",null,null,null,"S2",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":13}]
[]
[null,"place",46,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.47222222222222221},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":17},null,null,null,{"$f":"P4","v":17}]
[null,1,"LJA 019778-564","Thierry",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:05:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":9},{"$f":"SUM(K6:O6)","v":12},5,5,2,0,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":22},{"$f":"SUM(L6:L9)","v":11},{"$f":"SUM(M6:M9)","v":3}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":2},{"$f":"SUM(K7:O7)","v":12},10,2,0,0,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","16:50:00","T3",6,{"$f":"SUM(K8:O8)","v":12},7,4,1,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:45:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",44,"PACALIS",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":0.88888888888888884},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":32},null,null,null,{"$f":"P11","v":32}]
[null,2,"NTR 018542","Eric",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:17:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":13},{"$f":"SUM(K13:O13)","v":12},5,5,0,1,1,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":16},{"$f":"SUM(L13:L16)","v":15},{"$f":"SUM(M13:M16)","v":2}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":12},{"$f":"SUM(K14:O14)","v":12},5,5,1,0,1]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","17:27:00","T3",7,{"$f":"SUM(K15:O15)","v":12},6,5,1,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"08:10:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",42,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":0.94444444444444442},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":34},null,null,null,{"$f":"P18","v":34}]
[null,3,"NTR 106709","Kevin",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:04:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":20},{"$f":"SUM(K20:O20)","v":12},3,4,3,0,2,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":17},{"$f":"SUM(L20:L23)","v":10},{"$f":"SUM(M20:M23)","v":7}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":7},{"$f":"SUM(K21:O21)","v":12},6,5,1,0,0]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","16:10:00","T3",7,{"$f":"SUM(K22:O22)","v":12},8,1,3,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"06:06:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",49,"PIQUET",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":1.9166666666666667},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":69},null,null,null,{"$f":"P25","v":69}]
[null,4,"NTR 038065","David",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:41:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":26},{"$f":"SUM(K27:O27)","v":12},2,5,0,2,3,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":9},{"$f":"SUM(L27:L30)","v":11},{"$f":"SUM(M27:M30)","v":4}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":14},{"$f":"SUM(K28:O28)","v":12},4,4,2,2,0]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","17:10:00","T3",29,{"$f":"SUM(K29:O29)","v":12},3,2,2,1,4]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"07:29:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",48,"PERNIN",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":2.0555555555555554},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":74},null,null,null,{"$f":"P32","v":74}]
[null,5,"NTR 260188","Simon",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:22:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":28},{"$f":"SUM(K34:O34)","v":12},1,4,1,4,2,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":7},{"$f":"SUM(L34:L37)","v":9},{"$f":"SUM(M34:M37)","v":5}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":24},{"$f":"SUM(K35:O35)","v":12},2,3,2,4,1]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","16:10:00","T3",22,{"$f":"SUM(K36:O36)","v":12},4,2,2,2,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"06:48:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]
[]
[null,"place",51,"ANTOINE",null,"Moyenne par zone",{"$f":"IF(SUM(J41:J44)=0,0,(SUM(L41:L44)*1+SUM(M41:M44)*2+SUM(N41:N44)*3+SUM(O41:O44)*5)/SUM(J41:J44))","v":2.1666666666666665},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R41","v":0},"TOTAL",null,{"$f":"IF(OR(P41=\"Disq\",P42=\"Disq\",P43=\"Disq\",P44=\"Disq\",R41=\"HC\"),\"Disq\",IF(OR(P41=\"Abd\",P42=\"Abd\",P43=\"Abd\",P44=\"Abd\"),\"Abd\",SUM(I41:I44)+M39))","v":78},null,null,null,{"$f":"P39","v":78}]
[null,6,"NTR 192504","Stephane",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:45:00","T1",{"$f":"IF(OR(P41=\"Disq\",P41=\"Abd\"),P41,(L41*1)+(M41*2)+(N41*3)+(O41*5)+P41)","v":19},{"$f":"SUM(K41:O41)","v":12},3,3,4,1,1,null,null,{"$f":"IF(G43>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K41:K44)","v":6},{"$f":"SUM(L41:L44)","v":7},{"$f":"SUM(M41:M44)","v":8}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P42=\"Disq\",P42=\"Abd\"),P42,(L42*1)+(M42*2)+(N42*3)+(O42*5)+P42)","v":24},{"$f":"SUM(K42:O42)","v":12},2,3,2,4,1]
[null,{"$f":"VLOOKUP(B40,Attribution_des_points,2,FALSE)","v":10},null,null,null,"Heure Arrivée","15:58:00","T3",35,{"$f":"SUM(K43:O43)","v":12},1,1,2,5,3]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G43=0,0,G43-G41)","v":"06:13:00"},"T4",0,{"$f":"SUM(K44:O44)","v":0}]
[]
[null,"place",54,"PROST",null,"Moyenne par zone",{"$f":"IF(SUM(J48:J51)=0,0,(SUM(L48:L51)*1+SUM(M48:M51)*2+SUM(N48:N51)*3+SUM(O48:O51)*5)/SUM(J48:J51))","v":2.2222222222222223},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R48","v":0},"TOTAL",null,{"$f":"IF(OR(P48=\"Disq\",P49=\"Disq\",P50=\"Disq\",P51=\"Disq\",R48=\"HC\"),\"Disq\",IF(OR(P48=\"Abd\",P49=\"Abd\",P50=\"Abd\",P51=\"Abd\"),\"Abd\",SUM(I48:I51)+M46))","v":80},null,null,null,{"$f":"P46","v":80}]
[null,7,"NTR 205623","Ayrton",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:14:00","T1",{"$f":"IF(OR(P48=\"Disq\",P48=\"Abd\"),P48,(L48*1)+(M48*2)+(N48*3)+(O48*5)+P48)","v":25},{"$f":"SUM(K48:O48)","v":12},1,3,4,3,1,null,null,{"$f":"IF(G50>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K48:K51)","v":3},{"$f":"SUM(L48:L51)","v":6},{"$f":"SUM(M48:M51)","v":11}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P49=\"Disq\",P49=\"Abd\"),P49,(L49*1)+(M49*2)+(N49*3)+(O49*5)+P49)","v":31},{"$f":"SUM(K49:O49)","v":12},0,1,3,8,0]
[null,{"$f":"VLOOKUP(B47,Attribution_des_points,2,FALSE)","v":9},null,null,null,"Heure Arrivée","16:14:00","T3",24,{"$f":"SUM(K50:O50)","v":12},2,2,4,3,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G50=0,0,G50-G48)","v":"07:00:00"},"T4",0,{"$f":"SUM(K51:O51)","v":0}]
[]
[null,"place",41,"JEUDY",null,"Moyenne par zone",{"$f":"IF(SUM(J55:J58)=0,0,(SUM(L55:L58)*1+SUM(M55:M58)*2+SUM(N55:N58)*3+SUM(O55:O58)*5)/SUM(J55:J58))","v":2.3055555555555554},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R55","v":0},"TOTAL",null,{"$f":"IF(OR(P55=\"Disq\",P56=\"Disq\",P57=\"Disq\",P58=\"Disq\",R55=\"HC\"),\"Disq\",IF(OR(P55=\"Abd\",P56=\"Abd\",P57=\"Abd\",P58=\"Abd\"),\"Abd\",SUM(I55:I58)+M53))","v":83},null,null,null,{"$f":"P53","v":83}]
[null,8,"NCO 331167","Adrien",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:10:00","T1",{"$f":"IF(OR(P55=\"Disq\",P55=\"Abd\"),P55,(L55*1)+(M55*2)+(N55*3)+(O55*5)+P55)","v":25},{"$f":"SUM(K55:O55)","v":12},3,0,2,7,0,null,null,{"$f":"IF(G57>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K55:K58)","v":6},{"$f":"SUM(L55:L58)","v":3},{"$f":"SUM(M55:M58)","v":5}]
[null,"Pts Chpt","RN 66",null,null,null,null,"T2",{"$f":"IF(OR(P56=\"Disq\",P56=\"Abd\"),P56,(L56*1)+(M56*2)+(N56*3)+(O56*5)+P56)","v":32},{"$f":"SUM(K56:O56)","v":12},2,1,0,7,2]
[null,{"$f":"VLOOKUP(B54,Attribution_des_points,2,FALSE)","v":8},null,null,null,"Heure Arrivée","16:21:00","T3",26,{"$f":"SUM(K57:O57)","v":12},1,2,3,6,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G57=0,0,G57-G55)","v":"07:11:00"},"T4",0,{"$f":"SUM(K58:O58)","v":0}]
[]
[null,"place",43,"JACQUES",null,"Moyenne par zone",{"$f":"IF(SUM(J62:J65)=0,0,(SUM(L62:L65)*1+SUM(M62:M65)*2+SUM(N62:N65)*3+SUM(O62:O65)*5)/SUM(J62:J65))","v":2.4722222222222223},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R62","v":0},"TOTAL",null,{"$f":"IF(OR(P62=\"Disq\",P63=\"Disq\",P64=\"Disq\",P65=\"Disq\",R62=\"HC\"),\"Disq\",IF(OR(P62=\"Abd\",P63=\"Abd\",P64=\"Abd\",P65=\"Abd\"),\"Abd\",SUM(I62:I65)+M60))","v":89},null,null,null,{"$f":"P60","v":89}]
[null,9,"NTR 117187","Julien",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:30:00","T1",{"$f":"IF(OR(P62=\"Disq\",P62=\"Abd\"),P62,(L62*1)+(M62*2)+(N62*3)+(O62*5)+P62)","v":35},{"$f":"SUM(K62:O62)","v":12},0,2,3,4,3,null,null,{"$f":"IF(G64>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K62:K65)","v":4},{"$f":"SUM(L62:L65)","v":6},{"$f":"SUM(M62:M65)","v":7}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P63=\"Disq\",P63=\"Abd\"),P63,(L63*1)+(M63*2)+(N63*3)+(O63*5)+P63)","v":27},{"$f":"SUM(K63:O63)","v":12},2,2,3,3,2]
[null,{"$f":"VLOOKUP(B61,Attribution_des_points,2,FALSE)","v":7},null,null,null,"Heure Arrivée","16:54:00","T3",27,{"$f":"SUM(K64:O64)","v":12},2,2,1,6,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G64=0,0,G64-G62)","v":"07:24:00"},"T4",0,{"$f":"SUM(K65:O65)","v":0}]
[]
[null,"place",50,"PIQUET",null,"Moyenne par zone",{"$f":"IF(SUM(J69:J72)=0,0,(SUM(L69:L72)*1+SUM(M69:M72)*2+SUM(N69:N72)*3+SUM(O69:O72)*5)/SUM(J69:J72))","v":2.5277777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R69","v":0},"TOTAL",null,{"$f":"IF(OR(P69=\"Disq\",P70=\"Disq\",P71=\"Disq\",P72=\"Disq\",R69=\"HC\"),\"Disq\",IF(OR(P69=\"Abd\",P70=\"Abd\",P71=\"Abd\",P72=\"Abd\"),\"Abd\",SUM(I69:I72)+M67))","v":91},null,null,null,{"$f":"P67","v":91}]
[null,10,"NTR 287931","Alois",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:42:00","T1",{"$f":"IF(OR(P69=\"Disq\",P69=\"Abd\"),P69,(L69*1)+(M69*2)+(N69*3)+(O69*5)+P69)","v":31},{"$f":"SUM(K69:O69)","v":12},1,2,2,5,2,null,null,{"$f":"IF(G71>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K69:K72)","v":5},{"$f":"SUM(L69:L72)","v":5},{"$f":"SUM(M69:M72)","v":8}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P70=\"Disq\",P70=\"Abd\"),P70,(L70*1)+(M70*2)+(N70*3)+(O70*5)+P70)","v":26},{"$f":"SUM(K70:O70)","v":12},3,1,3,3,2]
[null,{"$f":"VLOOKUP(B68,Attribution_des_points,2,FALSE)","v":6},null,null,null,"Heure Arrivée","17:10:00","T3",34,{"$f":"SUM(K71:O71)","v":12},1,2,3,2,4]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G71=0,0,G71-G69)","v":"07:28:00"},"T4",0,{"$f":"SUM(K72:O72)","v":0}]
[]
[null,"place",53,"MOREL",null,"Moyenne par zone",{"$f":"IF(SUM(J76:J79)=0,0,(SUM(L76:L79)*1+SUM(M76:M79)*2+SUM(N76:N79)*3+SUM(O76:O79)*5)/SUM(J76:J79))","v":2.5833333333333335},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R76","v":0},"TOTAL",null,{"$f":"IF(OR(P76=\"Disq\",P77=\"Disq\",P78=\"Disq\",P79=\"Disq\",R76=\"HC\"),\"Disq\",IF(OR(P76=\"Abd\",P77=\"Abd\",P78=\"Abd\",P79=\"Abd\"),\"Abd\",SUM(I76:I79)+M74))","v":93},null,null,null,{"$f":"P74","v":93}]
[null,11,"LJA 108917-056","Alexandre",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:06:00","T1",{"$f":"IF(OR(P76=\"Disq\",P76=\"Abd\"),P76,(L76*1)+(M76*2)+(N76*3)+(O76*5)+P76)","v":27},{"$f":"SUM(K76:O76)","v":12},1,1,6,3,1,null,null,{"$f":"IF(G78>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K76:K79)","v":5},{"$f":"SUM(L76:L79)","v":3},{"$f":"SUM(M76:M79)","v":8}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P77=\"Disq\",P77=\"Abd\"),P77,(L77*1)+(M77*2)+(N77*3)+(O77*5)+P77)","v":36},{"$f":"SUM(K77:O77)","v":12},1,1,1,6,3]
[null,{"$f":"VLOOKUP(B75,Attribution_des_points,2,FALSE)","v":5},null,null,null,"Heure Arrivée","16:11:00","T3",30,{"$f":"SUM(K78:O78)","v":12},3,1,1,4,3]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G78=0,0,G78-G76)","v":"06:05:00"},"T4",0,{"$f":"SUM(K79:O79)","v":0}]
[]
[null,"place",47,"MAGEN-TERRASSE",null,"Moyenne par zone",{"$f":"IF(SUM(J83:J86)=0,0,(SUM(L83:L86)*1+SUM(M83:M86)*2+SUM(N83:N86)*3+SUM(O83:O86)*5)/SUM(J83:J86))","v":3.0277777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R83","v":0},"TOTAL",null,{"$f":"IF(OR(P83=\"Disq\",P84=\"Disq\",P85=\"Disq\",P86=\"Disq\",R83=\"HC\"),\"Disq\",IF(OR(P83=\"Abd\",P84=\"Abd\",P85=\"Abd\",P86=\"Abd\"),\"Abd\",SUM(I83:I86)+M81))","v":109},null,null,null,{"$f":"P81","v":109}]
[null,12,"NTR 319153","Corentin",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:47:00","T1",{"$f":"IF(OR(P83=\"Disq\",P83=\"Abd\"),P83,(L83*1)+(M83*2)+(N83*3)+(O83*5)+P83)","v":34},{"$f":"SUM(K83:O83)","v":12},0,2,2,6,2,null,null,{"$f":"IF(G85>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K83:K86)","v":0},{"$f":"SUM(L83:L86)","v":6},{"$f":"SUM(M83:M86)","v":5}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P84=\"Disq\",P84=\"Abd\"),P84,(L84*1)+(M84*2)+(N84*3)+(O84*5)+P84)","v":30},{"$f":"SUM(K84:O84)","v":12},0,3,2,6,1]
[null,{"$f":"VLOOKUP(B82,Attribution_des_points,2,FALSE)","v":4},null,null,null,"Heure Arrivée","16:54:00","T3",45,{"$f":"SUM(K85:O85)","v":12},0,1,1,4,6]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G85=0,0,G85-G83)","v":"07:07:00"},"T4",0,{"$f":"SUM(K86:O86)","v":0}]
[]
[null,"place",45,"TRIMOREAU",null,"Moyenne par zone",{"$f":"IF(SUM(J90:J93)=0,0,(SUM(L90:L93)*1+SUM(M90:M93)*2+SUM(N90:N93)*3+SUM(O90:O93)*5)/SUM(J90:J93))","v":3.6666666666666665},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R90","v":0},"TOTAL",null,{"$f":"IF(OR(P90=\"Disq\",P91=\"Disq\",P92=\"Disq\",P93=\"Disq\",R90=\"HC\"),\"Disq\",IF(OR(P90=\"Abd\",P91=\"Abd\",P92=\"Abd\",P93=\"Abd\"),\"Abd\",SUM(I90:I93)+M88))","v":132},null,null,null,{"$f":"P88","v":132}]
[null,13,"NCO 250394","Stephane",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:31:00","T1",{"$f":"IF(OR(P90=\"Disq\",P90=\"Abd\"),P90,(L90*1)+(M90*2)+(N90*3)+(O90*5)+P90)","v":42},{"$f":"SUM(K90:O90)","v":12},0,0,0,9,3,null,null,{"$f":"IF(G92>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K90:K93)","v":0},{"$f":"SUM(L90:L93)","v":0},{"$f":"SUM(M90:M93)","v":0}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P91=\"Disq\",P91=\"Abd\"),P91,(L91*1)+(M91*2)+(N91*3)+(O91*5)+P91)","v":44},{"$f":"SUM(K91:O91)","v":12},0,0,0,8,4]
[null,{"$f":"VLOOKUP(B89,Attribution_des_points,2,FALSE)","v":3},null,null,null,"Heure Arrivée","16:54:00","T3",46,{"$f":"SUM(K92:O92)","v":12},0,0,0,7,5]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G92=0,0,G92-G90)","v":"07:23:00"},"T4",0,{"$f":"SUM(K93:O93)","v":0}]

{"sheet":"S3+","index":7,"n_rows":65,"n_cols":23,"rows_kept":65,"cut":false,"hidden":false,"merged":[[17,10,17,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[10,10,10,11],[10,13,10,14],[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4],[14,1,15,1],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[38,19,44,19],[39,1,40,1],[39,3,40,4],[41,2,43,4],[42,1,43,1],[38,3,38,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[45,19,51,19],[46,1,47,1],[46,3,47,4],[48,2,50,4],[49,1,50,1],[45,3,45,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[52,19,58,19],[53,1,54,1],[53,3,54,4],[55,2,57,4],[56,1,57,1],[52,3,52,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[52,9,53,9],[28,1,29,1],[24,3,24,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[52,10,52,11],[52,13,52,14],[45,10,45,11],[45,13,45,14],[38,10,38,11],[38,13,38,14],[59,13,59,14],[59,19,65,19],[60,1,61,1],[60,3,61,4],[62,2,64,4],[63,1,64,1],[31,13,31,14],[31,10,31,11],[31,3,31,4],[59,3,59,4],[59,5,60,5],[59,6,60,6],[59,7,60,7],[59,8,60,8],[59,9,60,9],[59,10,59,11],[31,19,37,19],[34,2,36,4],[35,1,36,1],[32,3,33,4],[32,1,33,1],[31,9,32,9],[31,8,32,8],[31,7,32,7],[31,6,32,6],[31,5,32,5],[3,13,3,14],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[24,10,24,11],[24,13,24,14],[24,19,30,19],[25,1,26,1],[25,3,26,4],[27,2,29,4]]}
[]
[null,"CLASSEMENT",null,null,null,"S3+",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":9}]
[]
[null,"place",71,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.47222222222222221},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":17},null,null,null,{"$f":"P4","v":17}]
[null,1,"NTR 132374","Kevin",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:20:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":6},{"$f":"SUM(K6:O6)","v":12},6,6,0,0,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":23},{"$f":"SUM(L6:L9)","v":10},{"$f":"SUM(M6:M9)","v":2}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":7},{"$f":"SUM(K7:O7)","v":12},8,2,1,1,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","16:29:00","T3",4,{"$f":"SUM(K8:O8)","v":12},9,2,1,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:09:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",78,"CUNAT",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":1.1111111111111112},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":40},null,null,null,{"$f":"P11","v":40}]
[null,2,"NTR 007609","Jerome",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:10:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":17},{"$f":"SUM(K13:O13)","v":12},5,3,0,3,1,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":20},{"$f":"SUM(L13:L16)","v":5},{"$f":"SUM(M13:M16)","v":4}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":10},{"$f":"SUM(K14:O14)","v":12},7,1,3,1,0]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","16:08:00","T3",13,{"$f":"SUM(K15:O15)","v":12},8,1,1,0,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"05:58:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",79,"SESSA",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":1.5277777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":55},null,null,null,{"$f":"P18","v":55}]
[null,3,"NTR 110020","Marc",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:36:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":19},{"$f":"SUM(K20:O20)","v":12},5,2,0,4,1,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":16},{"$f":"SUM(L20:L23)","v":5},{"$f":"SUM(M20:M23)","v":1}]
[null,"Pts Chpt","ETLB",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":17},{"$f":"SUM(K21:O21)","v":12},7,0,0,4,1]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","15:40:00","T3",19,{"$f":"SUM(K22:O22)","v":12},4,3,1,3,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"06:04:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",74,"MARTIN",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":1.5833333333333333},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":57},null,null,null,{"$f":"P25","v":57}]
[null,4,"NTR 016638","Eric",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:07:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":24},{"$f":"SUM(K27:O27)","v":12},5,0,1,4,2,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":16},{"$f":"SUM(L27:L30)","v":3},{"$f":"SUM(M27:M30)","v":3}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":18},{"$f":"SUM(K28:O28)","v":12},6,0,2,3,1]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","16:10:00","T3",15,{"$f":"SUM(K29:O29)","v":12},5,3,0,4,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"06:03:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",72,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":1.5833333333333333},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":57},null,null,null,{"$f":"P32","v":57}]
[null,5,"NCO 019772","Hervé",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:06:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":19},{"$f":"SUM(K34:O34)","v":12},5,2,2,1,2,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":13},{"$f":"SUM(L34:L37)","v":8},{"$f":"SUM(M34:M37)","v":6}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":17},{"$f":"SUM(K35:O35)","v":12},4,4,1,2,1]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","15:00:00","T3",21,{"$f":"SUM(K36:O36)","v":12},4,2,3,1,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"05:54:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]
[]
[null,"place",77,"MELET",null,"Moyenne par zone",{"$f":"IF(SUM(J41:J44)=0,0,(SUM(L41:L44)*1+SUM(M41:M44)*2+SUM(N41:N44)*3+SUM(O41:O44)*5)/SUM(J41:J44))","v":1.6666666666666667},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R41","v":0},"TOTAL",null,{"$f":"IF(OR(P41=\"Disq\",P42=\"Disq\",P43=\"Disq\",P44=\"Disq\",R41=\"HC\"),\"Disq\",IF(OR(P41=\"Abd\",P42=\"Abd\",P43=\"Abd\",P44=\"Abd\"),\"Abd\",SUM(I41:I44)+M39))","v":60},null,null,null,{"$f":"P39","v":60}]
[null,6,"NTR 045027","Denis",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:49:00","T1",{"$f":"IF(OR(P41=\"Disq\",P41=\"Abd\"),P41,(L41*1)+(M41*2)+(N41*3)+(O41*5)+P41)","v":25},{"$f":"SUM(K41:O41)","v":12},2,2,5,1,2,null,null,{"$f":"IF(G43>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K41:K44)","v":16},{"$f":"SUM(L41:L44)","v":4},{"$f":"SUM(M41:M44)","v":6}]
[null,"Pts Chpt","MC du Risoux",null,null,null,null,"T2",{"$f":"IF(OR(P42=\"Disq\",P42=\"Abd\"),P42,(L42*1)+(M42*2)+(N42*3)+(O42*5)+P42)","v":20},{"$f":"SUM(K42:O42)","v":12},6,2,0,1,3]
[null,{"$f":"VLOOKUP(B40,Attribution_des_points,2,FALSE)","v":10},null,null,null,"Heure Arrivée","16:08:00","T3",15,{"$f":"SUM(K43:O43)","v":12},8,0,1,1,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G43=0,0,G43-G41)","v":"06:19:00"},"T4",0,{"$f":"SUM(K44:O44)","v":0}]
[]
[null,"place",76,"BECK",null,"Moyenne par zone",{"$f":"IF(SUM(J48:J51)=0,0,(SUM(L48:L51)*1+SUM(M48:M51)*2+SUM(N48:N51)*3+SUM(O48:O51)*5)/SUM(J48:J51))","v":1.9166666666666667},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R48","v":0},"TOTAL",null,{"$f":"IF(OR(P48=\"Disq\",P49=\"Disq\",P50=\"Disq\",P51=\"Disq\",R48=\"HC\"),\"Disq\",IF(OR(P48=\"Abd\",P49=\"Abd\",P50=\"Abd\",P51=\"Abd\"),\"Abd\",SUM(I48:I51)+M46))","v":69},null,null,null,{"$f":"P46","v":69}]
[null,7,"NTR 263869","Solène",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:00:00","T1",{"$f":"IF(OR(P48=\"Disq\",P48=\"Abd\"),P48,(L48*1)+(M48*2)+(N48*3)+(O48*5)+P48)","v":22},{"$f":"SUM(K48:O48)","v":12},4,2,2,2,2,null,null,{"$f":"IF(G50>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K48:K51)","v":14},{"$f":"SUM(L48:L51)","v":4},{"$f":"SUM(M48:M51)","v":3}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P49=\"Disq\",P49=\"Abd\"),P49,(L49*1)+(M49*2)+(N49*3)+(O49*5)+P49)","v":20},{"$f":"SUM(K49:O49)","v":12},6,1,0,3,2]
[null,{"$f":"VLOOKUP(B47,Attribution_des_points,2,FALSE)","v":9},null,null,null,"Heure Arrivée","16:55:00","T3",27,{"$f":"SUM(K50:O50)","v":12},4,1,1,3,3]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G50=0,0,G50-G48)","v":"06:55:00"},"T4",0,{"$f":"SUM(K51:O51)","v":0}]
[]
[null,"place",75,"BELLETTINI",null,"Moyenne par zone",{"$f":"IF(SUM(J55:J58)=0,0,(SUM(L55:L58)*1+SUM(M55:M58)*2+SUM(N55:N58)*3+SUM(O55:O58)*5)/SUM(J55:J58))","v":2.0555555555555554},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R55","v":0},"TOTAL",null,{"$f":"IF(OR(P55=\"Disq\",P56=\"Disq\",P57=\"Disq\",P58=\"Disq\",R55=\"HC\"),\"Disq\",IF(OR(P55=\"Abd\",P56=\"Abd\",P57=\"Abd\",P58=\"Abd\"),\"Abd\",SUM(I55:I58)+M53))","v":74},null,null,null,{"$f":"P53","v":74}]
[null,8,"NTR 288844","Igor",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:15:00","T1",{"$f":"IF(OR(P55=\"Disq\",P55=\"Abd\"),P55,(L55*1)+(M55*2)+(N55*3)+(O55*5)+P55)","v":21},{"$f":"SUM(K55:O55)","v":12},5,0,2,4,1,null,null,{"$f":"IF(G57>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K55:K58)","v":12},{"$f":"SUM(L55:L58)","v":2},{"$f":"SUM(M55:M58)","v":4}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P56=\"Disq\",P56=\"Abd\"),P56,(L56*1)+(M56*2)+(N56*3)+(O56*5)+P56)","v":22},{"$f":"SUM(K56:O56)","v":12},3,2,1,6,0]
[null,{"$f":"VLOOKUP(B54,Attribution_des_points,2,FALSE)","v":8},null,null,null,"Heure Arrivée","16:16:00","T3",31,{"$f":"SUM(K57:O57)","v":12},4,0,1,3,4]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G57=0,0,G57-G55)","v":"07:01:00"},"T4",0,{"$f":"SUM(K58:O58)","v":0}]
[]
[null,"place",73,"RIEGER",null,"Moyenne par zone",{"$f":"IF(SUM(J62:J65)=0,0,(SUM(L62:L65)*1+SUM(M62:M65)*2+SUM(N62:N65)*3+SUM(O62:O65)*5)/SUM(J62:J65))","v":1.5},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R62","v":0},"TOTAL",null,{"$f":"IF(OR(P62=\"Disq\",P63=\"Disq\",P64=\"Disq\",P65=\"Disq\",R62=\"HC\"),\"Disq\",IF(OR(P62=\"Abd\",P63=\"Abd\",P64=\"Abd\",P65=\"Abd\"),\"Abd\",SUM(I62:I65)+M60))","v":"Abd"},null,null,null,{"$f":"P60","v":"Abd"}]
[null,"Abd","NTR 030508","Denis",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:01:00","T1",{"$f":"IF(OR(P62=\"Disq\",P62=\"Abd\"),P62,(L62*1)+(M62*2)+(N62*3)+(O62*5)+P62)","v":20},{"$f":"SUM(K62:O62)","v":12},5,1,1,4,1,null,null,{"$f":"IF(G64>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K62:K65)","v":12},{"$f":"SUM(L62:L65)","v":1},{"$f":"SUM(M62:M65)","v":2}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P63=\"Disq\",P63=\"Abd\"),P63,(L63*1)+(M63*2)+(N63*3)+(O63*5)+P63)","v":"abd"},{"$f":"SUM(K63:O63)","v":12},7,0,1,3,1,"abd"]
[null,{"$f":"VLOOKUP(B61,Attribution_des_points,2,FALSE)","v":"NC"},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K64:O64)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G64=0,0,G64-G62)","v":"00:00:00"},"T4",0,{"$f":"SUM(K65:O65)","v":0}]

{"sheet":"S3+ MAT2","index":8,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[3,13,3,14]]}
[]
[null,"CLASSEMENT",null,null,null,"S3+ MAT2",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":1}]
[]
[null,"place",90,"GERLIER",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":1.1388888888888888},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":41},null,null,null,{"$f":"P4","v":41}]
[null,1,"NTR 011402","Denis",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:48:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":12},{"$f":"SUM(K6:O6)","v":12},6,2,2,2,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":22},{"$f":"SUM(L6:L9)","v":4},{"$f":"SUM(M6:M9)","v":3}]
[null,"Pts Chpt","MC Bermont",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":17},{"$f":"SUM(K7:O7)","v":12},7,2,0,0,3]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","15:55:00","T3",12,{"$f":"SUM(K8:O8)","v":12},9,0,1,0,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:07:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]

{"sheet":"S3","index":9,"n_rows":114,"n_cols":23,"rows_kept":114,"cut":false,"hidden":false,"merged":[[3,10,3,11],[3,13,3,14],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[108,10,108,11],[108,13,108,14],[108,19,114,19],[109,1,110,1],[109,3,110,4],[111,2,113,4],[112,1,113,1],[108,3,108,4],[108,5,109,5],[108,6,109,6],[108,7,109,7],[108,8,109,8],[108,9,109,9],[24,9,25,9],[66,10,66,11],[66,13,66,14],[66,19,72,19],[67,1,68,1],[67,3,68,4],[69,2,71,4],[70,1,71,1],[66,3,66,4],[66,5,67,5],[66,6,67,6],[66,7,67,7],[66,8,67,8],[66,9,67,9],[25,1,26,1],[25,3,26,4],[27,2,29,4],[28,1,29,1],[24,3,24,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[94,10,94,11],[94,13,94,14],[94,19,100,19],[95,1,96,1],[95,3,96,4],[97,2,99,4],[98,1,99,1],[94,3,94,4],[94,5,95,5],[94,6,95,6],[94,7,95,7],[94,8,95,8],[94,9,95,9],[10,10,10,11],[10,13,10,14],[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4],[14,1,15,1],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[52,10,52,11],[52,13,52,14],[52,19,58,19],[53,1,54,1],[53,3,54,4],[55,2,57,4],[56,1,57,1],[52,3,52,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[52,9,53,9],[101,10,101,11],[101,13,101,14],[101,19,107,19],[102,1,103,1],[102,3,103,4],[104,2,106,4],[105,1,106,1],[101,3,101,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[59,10,59,11],[59,13,59,14],[59,19,65,19],[60,1,61,1],[60,3,61,4],[62,2,64,4],[63,1,64,1],[59,3,59,4],[59,5,60,5],[59,6,60,6],[59,7,60,7],[59,8,60,8],[59,9,60,9],[87,10,87,11],[87,13,87,14],[87,19,93,19],[88,1,89,1],[88,3,89,4],[90,2,92,4],[91,1,92,1],[87,3,87,4],[87,5,88,5],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,9,88,9],[38,19,44,19],[39,1,40,1],[39,3,40,4],[41,2,43,4],[42,1,43,1],[38,3,38,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[73,10,73,11],[73,13,73,14],[73,19,79,19],[74,1,75,1],[74,3,75,4],[76,2,78,4],[77,1,78,1],[73,3,73,4],[73,5,74,5],[73,6,74,6],[73,7,74,7],[73,8,74,8],[73,9,74,9],[31,19,37,19],[34,2,36,4],[35,1,36,1],[32,3,33,4],[32,1,33,1],[31,9,32,9],[31,8,32,8],[31,7,32,7],[17,10,17,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[24,10,24,11],[24,13,24,14],[24,19,30,19],[31,13,31,14],[31,10,31,11],[31,3,31,4],[45,3,45,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[45,10,45,11],[38,10,38,11],[38,13,38,14],[31,6,32,6],[31,5,32,5],[80,13,80,14],[80,19,86,19],[81,1,82,1],[81,3,82,4],[83,2,85,4],[84,1,85,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[80,3,80,4],[80,5,81,5],[80,6,81,6],[80,7,81,7],[80,8,81,8],[80,9,81,9],[80,10,80,11],[45,13,45,14],[45,19,51,19],[46,1,47,1],[46,3,47,4],[48,2,50,4],[49,1,50,1]]}
[]
[null,"CLASSEMENT",null,null,null,"S3",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":16}]
[]
[null,"place",118,"VAXELAIRE",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.16666666666666666},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":6},null,null,null,{"$f":"P4","v":6}]
[null,1,"NTR 039562","Gerald",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:21:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":4},{"$f":"SUM(K6:O6)","v":12},9,2,1,0,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":31},{"$f":"SUM(L6:L9)","v":4},{"$f":"SUM(M6:M9)","v":1}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":2},{"$f":"SUM(K7:O7)","v":12},10,2,0,0,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","16:10:00","T3",0,{"$f":"SUM(K8:O8)","v":12},12,0,0,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"05:49:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",112,"COLIN",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":0.33333333333333331},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":12},null,null,null,{"$f":"P11","v":12}]
[null,2,"NTR 081748","Jeremy",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:37:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":1},{"$f":"SUM(K13:O13)","v":12},11,1,0,0,0,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":29},{"$f":"SUM(L13:L16)","v":5},{"$f":"SUM(M13:M16)","v":1}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":3},{"$f":"SUM(K14:O14)","v":12},9,3,0,0,0]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","15:50:00","T3",8,{"$f":"SUM(K15:O15)","v":12},9,1,1,0,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"06:13:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",104,"PETITJEAN",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":0.41666666666666669},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":15},null,null,null,{"$f":"P18","v":15}]
[null,3,"NTR 037880","Marc",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:46:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":8},{"$f":"SUM(K20:O20)","v":12},8,3,0,0,1,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":27},{"$f":"SUM(L20:L23)","v":6},{"$f":"SUM(M20:M23)","v":2}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":4},{"$f":"SUM(K21:O21)","v":12},9,2,1,0,0]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","15:58:00","T3",3,{"$f":"SUM(K22:O22)","v":12},10,1,1,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"06:12:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",115,"SCHMIDLIN",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":0.44444444444444442},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":16},null,null,null,{"$f":"P25","v":16}]
[null,4,"NTR 38884","Jean Luc",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Bourg. - Fr Comté",null,null,"Heure Départ","09:23:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":2},{"$f":"SUM(K27:O27)","v":12},10,2,0,0,0,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":24},{"$f":"SUM(L27:L30)","v":9},{"$f":"SUM(M27:M30)","v":2}]
[null,"Pts Chpt","TC Comptois",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":6},{"$f":"SUM(K28:O28)","v":12},8,3,0,1,0]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","16:00:00","T3",8,{"$f":"SUM(K29:O29)","v":12},6,4,2,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"06:37:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",102,"PIERREL",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":0.61111111111111116},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":22},null,null,null,{"$f":"P32","v":22}]
[null,5,"NCO 019494","Christophe",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:10:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":6},{"$f":"SUM(K34:O34)","v":12},9,1,1,1,0,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":27},{"$f":"SUM(L34:L37)","v":3},{"$f":"SUM(M34:M37)","v":3}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":10},{"$f":"SUM(K35:O35)","v":12},8,1,2,0,1]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","15:47:00","T3",6,{"$f":"SUM(K36:O36)","v":12},10,1,0,0,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"06:37:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]
[]
[null,"place",106,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J41:J44)=0,0,(SUM(L41:L44)*1+SUM(M41:M44)*2+SUM(N41:N44)*3+SUM(O41:O44)*5)/SUM(J41:J44))","v":0.72222222222222221},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R41","v":0},"TOTAL",null,{"$f":"IF(OR(P41=\"Disq\",P42=\"Disq\",P43=\"Disq\",P44=\"Disq\",R41=\"HC\"),\"Disq\",IF(OR(P41=\"Abd\",P42=\"Abd\",P43=\"Abd\",P44=\"Abd\"),\"Abd\",SUM(I41:I44)+M39))","v":26},null,null,null,{"$f":"P39","v":26}]
[null,6,"NTR 019775","Joel",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:00:00","T1",{"$f":"IF(OR(P41=\"Disq\",P41=\"Abd\"),P41,(L41*1)+(M41*2)+(N41*3)+(O41*5)+P41)","v":5},{"$f":"SUM(K41:O41)","v":12},9,2,0,1,0,null,null,{"$f":"IF(G43>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K41:K44)","v":22},{"$f":"SUM(L41:L44)","v":8},{"$f":"SUM(M41:M44)","v":2}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P42=\"Disq\",P42=\"Abd\"),P42,(L42*1)+(M42*2)+(N42*3)+(O42*5)+P42)","v":17},{"$f":"SUM(K42:O42)","v":12},5,2,2,2,1]
[null,{"$f":"VLOOKUP(B40,Attribution_des_points,2,FALSE)","v":10},null,null,null,"Heure Arrivée","14:01:00","T3",4,{"$f":"SUM(K43:O43)","v":12},8,4,0,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G43=0,0,G43-G41)","v":"05:01:00"},"T4",0,{"$f":"SUM(K44:O44)","v":0}]
[]
[null,"place",103,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J48:J51)=0,0,(SUM(L48:L51)*1+SUM(M48:M51)*2+SUM(N48:N51)*3+SUM(O48:O51)*5)/SUM(J48:J51))","v":0.88888888888888884},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R48","v":0},"TOTAL",null,{"$f":"IF(OR(P48=\"Disq\",P49=\"Disq\",P50=\"Disq\",P51=\"Disq\",R48=\"HC\"),\"Disq\",IF(OR(P48=\"Abd\",P49=\"Abd\",P50=\"Abd\",P51=\"Abd\"),\"Abd\",SUM(I48:I51)+M46))","v":32},null,null,null,{"$f":"P46","v":32}]
[null,7,"NJ3C 318948","Ethan",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:05:00","T1",{"$f":"IF(OR(P48=\"Disq\",P48=\"Abd\"),P48,(L48*1)+(M48*2)+(N48*3)+(O48*5)+P48)","v":9},{"$f":"SUM(K48:O48)","v":12},7,3,0,2,0,null,null,{"$f":"IF(G50>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K48:K51)","v":19},{"$f":"SUM(L48:L51)","v":8},{"$f":"SUM(M48:M51)","v":3}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P49=\"Disq\",P49=\"Abd\"),P49,(L49*1)+(M49*2)+(N49*3)+(O49*5)+P49)","v":15},{"$f":"SUM(K49:O49)","v":12},5,2,2,3,0]
[null,{"$f":"VLOOKUP(B47,Attribution_des_points,2,FALSE)","v":9},null,null,null,"Heure Arrivée","15:21:00","T3",8,{"$f":"SUM(K50:O50)","v":12},7,3,1,1,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G50=0,0,G50-G48)","v":"06:16:00"},"T4",0,{"$f":"SUM(K51:O51)","v":0}]
[]
[null,"place",110,"THIEBAUT",null,"Moyenne par zone",{"$f":"IF(SUM(J55:J58)=0,0,(SUM(L55:L58)*1+SUM(M55:M58)*2+SUM(N55:N58)*3+SUM(O55:O58)*5)/SUM(J55:J58))","v":1.2222222222222223},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R55","v":0},"TOTAL",null,{"$f":"IF(OR(P55=\"Disq\",P56=\"Disq\",P57=\"Disq\",P58=\"Disq\",R55=\"HC\"),\"Disq\",IF(OR(P55=\"Abd\",P56=\"Abd\",P57=\"Abd\",P58=\"Abd\"),\"Abd\",SUM(I55:I58)+M53))","v":44},null,null,null,{"$f":"P53","v":44}]
[null,8,"NCO 340098","Mathéo",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:08:00","T1",{"$f":"IF(OR(P55=\"Disq\",P55=\"Abd\"),P55,(L55*1)+(M55*2)+(N55*3)+(O55*5)+P55)","v":13},{"$f":"SUM(K55:O55)","v":12},7,2,0,2,1,null,null,{"$f":"IF(G57>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K55:K58)","v":17},{"$f":"SUM(L55:L58)","v":8},{"$f":"SUM(M55:M58)","v":3}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P56=\"Disq\",P56=\"Abd\"),P56,(L56*1)+(M56*2)+(N56*3)+(O56*5)+P56)","v":14},{"$f":"SUM(K56:O56)","v":12},5,4,1,1,1]
[null,{"$f":"VLOOKUP(B54,Attribution_des_points,2,FALSE)","v":8},null,null,null,"Heure Arrivée","13:48:00","T3",17,{"$f":"SUM(K57:O57)","v":12},5,2,2,2,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G57=0,0,G57-G55)","v":"04:40:00"},"T4",0,{"$f":"SUM(K58:O58)","v":0}]
[]
[null,"place",108,"BUCHER",null,"Moyenne par zone",{"$f":"IF(SUM(J62:J65)=0,0,(SUM(L62:L65)*1+SUM(M62:M65)*2+SUM(N62:N65)*3+SUM(O62:O65)*5)/SUM(J62:J65))","v":1.2777777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R62","v":0},"TOTAL",null,{"$f":"IF(OR(P62=\"Disq\",P63=\"Disq\",P64=\"Disq\",P65=\"Disq\",R62=\"HC\"),\"Disq\",IF(OR(P62=\"Abd\",P63=\"Abd\",P64=\"Abd\",P65=\"Abd\"),\"Abd\",SUM(I62:I65)+M60))","v":46},null,null,null,{"$f":"P60","v":46}]
[null,9,"NTR 005409","Thomas",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:50:00","T1",{"$f":"IF(OR(P62=\"Disq\",P62=\"Abd\"),P62,(L62*1)+(M62*2)+(N62*3)+(O62*5)+P62)","v":20},{"$f":"SUM(K62:O62)","v":12},5,2,1,2,2,null,null,{"$f":"IF(G64>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K62:K65)","v":18},{"$f":"SUM(L62:L65)","v":7},{"$f":"SUM(M62:M65)","v":4}]
[null,"Pts Chpt","MC Zone 68",null,null,null,null,"T2",{"$f":"IF(OR(P63=\"Disq\",P63=\"Abd\"),P63,(L63*1)+(M63*2)+(N63*3)+(O63*5)+P63)","v":15},{"$f":"SUM(K63:O63)","v":12},7,1,2,0,2]
[null,{"$f":"VLOOKUP(B61,Attribution_des_points,2,FALSE)","v":7},null,null,null,"Heure Arrivée","16:55:00","T3",11,{"$f":"SUM(K64:O64)","v":12},6,4,1,0,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G64=0,0,G64-G62)","v":"07:05:00"},"T4",0,{"$f":"SUM(K65:O65)","v":0}]
[]
[null,"place",116,"BALLAND",null,"Moyenne par zone",{"$f":"IF(SUM(J69:J72)=0,0,(SUM(L69:L72)*1+SUM(M69:M72)*2+SUM(N69:N72)*3+SUM(O69:O72)*5)/SUM(J69:J72))","v":1.6388888888888888},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R69","v":0},"TOTAL",null,{"$f":"IF(OR(P69=\"Disq\",P70=\"Disq\",P71=\"Disq\",P72=\"Disq\",R69=\"HC\"),\"Disq\",IF(OR(P69=\"Abd\",P70=\"Abd\",P71=\"Abd\",P72=\"Abd\"),\"Abd\",SUM(I69:I72)+M67))","v":59},null,null,null,{"$f":"P67","v":59}]
[null,10,"NTR 361550","Florian",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:38:00","T1",{"$f":"IF(OR(P69=\"Disq\",P69=\"Abd\"),P69,(L69*1)+(M69*2)+(N69*3)+(O69*5)+P69)","v":25},{"$f":"SUM(K69:O69)","v":12},3,1,2,5,1,null,null,{"$f":"IF(G71>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K69:K72)","v":9},{"$f":"SUM(L69:L72)","v":11},{"$f":"SUM(M69:M72)","v":4}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P70=\"Disq\",P70=\"Abd\"),P70,(L70*1)+(M70*2)+(N70*3)+(O70*5)+P70)","v":24},{"$f":"SUM(K70:O70)","v":12},2,3,2,4,1]
[null,{"$f":"VLOOKUP(B68,Attribution_des_points,2,FALSE)","v":6},null,null,null,"Heure Arrivée","15:55:00","T3",10,{"$f":"SUM(K71:O71)","v":12},4,7,0,1,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G71=0,0,G71-G69)","v":"06:17:00"},"T4",0,{"$f":"SUM(K72:O72)","v":0}]
[]
[null,"place",105,"NADOT",null,"Moyenne par zone",{"$f":"IF(SUM(J76:J79)=0,0,(SUM(L76:L79)*1+SUM(M76:M79)*2+SUM(N76:N79)*3+SUM(O76:O79)*5)/SUM(J76:J79))","v":1.6944444444444444},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R76","v":0},"TOTAL",null,{"$f":"IF(OR(P76=\"Disq\",P77=\"Disq\",P78=\"Disq\",P79=\"Disq\",R76=\"HC\"),\"Disq\",IF(OR(P76=\"Abd\",P77=\"Abd\",P78=\"Abd\",P79=\"Abd\"),\"Abd\",SUM(I76:I79)+M74))","v":61},null,null,null,{"$f":"P74","v":61}]
[null,11,"NTR 329543","Marie",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:34:00","T1",{"$f":"IF(OR(P76=\"Disq\",P76=\"Abd\"),P76,(L76*1)+(M76*2)+(N76*3)+(O76*5)+P76)","v":27},{"$f":"SUM(K76:O76)","v":12},3,2,0,5,2,null,null,{"$f":"IF(G78>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K76:K79)","v":11},{"$f":"SUM(L76:L79)","v":8},{"$f":"SUM(M76:M79)","v":4}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P77=\"Disq\",P77=\"Abd\"),P77,(L77*1)+(M77*2)+(N77*3)+(O77*5)+P77)","v":19},{"$f":"SUM(K77:O77)","v":12},4,3,1,3,1]
[null,{"$f":"VLOOKUP(B75,Attribution_des_points,2,FALSE)","v":5},null,null,null,"Heure Arrivée","15:54:00","T3",15,{"$f":"SUM(K78:O78)","v":12},4,3,3,2,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G78=0,0,G78-G76)","v":"06:20:00"},"T4",0,{"$f":"SUM(K79:O79)","v":0}]
[]
[null,"place",101,"HOLFERT",null,"Moyenne par zone",{"$f":"IF(SUM(J83:J86)=0,0,(SUM(L83:L86)*1+SUM(M83:M86)*2+SUM(N83:N86)*3+SUM(O83:O86)*5)/SUM(J83:J86))","v":2},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R83","v":0},"TOTAL",null,{"$f":"IF(OR(P83=\"Disq\",P84=\"Disq\",P85=\"Disq\",P86=\"Disq\",R83=\"HC\"),\"Disq\",IF(OR(P83=\"Abd\",P84=\"Abd\",P85=\"Abd\",P86=\"Abd\"),\"Abd\",SUM(I83:I86)+M81))","v":72},null,null,null,{"$f":"P81","v":72}]
[null,12,"NTR 013020","Dominique",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:52:00","T1",{"$f":"IF(OR(P83=\"Disq\",P83=\"Abd\"),P83,(L83*1)+(M83*2)+(N83*3)+(O83*5)+P83)","v":34},{"$f":"SUM(K83:O83)","v":12},1,2,1,5,3,null,null,{"$f":"IF(G85>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K83:K86)","v":6},{"$f":"SUM(L83:L86)","v":10},{"$f":"SUM(M83:M86)","v":4}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P84=\"Disq\",P84=\"Abd\"),P84,(L84*1)+(M84*2)+(N84*3)+(O84*5)+P84)","v":20},{"$f":"SUM(K84:O84)","v":12},2,4,2,4,0]
[null,{"$f":"VLOOKUP(B82,Attribution_des_points,2,FALSE)","v":4},null,null,null,"Heure Arrivée","16:52:00","T3",18,{"$f":"SUM(K85:O85)","v":12},3,4,1,4,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G85=0,0,G85-G83)","v":"07:00:00"},"T4",0,{"$f":"SUM(K86:O86)","v":0}]
[]
[null,"place",107,"ALLHEILY",null,"Moyenne par zone",{"$f":"IF(SUM(J90:J93)=0,0,(SUM(L90:L93)*1+SUM(M90:M93)*2+SUM(N90:N93)*3+SUM(O90:O93)*5)/SUM(J90:J93))","v":2.0277777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R90","v":0},"TOTAL",null,{"$f":"IF(OR(P90=\"Disq\",P91=\"Disq\",P92=\"Disq\",P93=\"Disq\",R90=\"HC\"),\"Disq\",IF(OR(P90=\"Abd\",P91=\"Abd\",P92=\"Abd\",P93=\"Abd\"),\"Abd\",SUM(I90:I93)+M88))","v":73},null,null,null,{"$f":"P88","v":73}]
[null,13,"NTR 342860","Jules",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:19:00","T1",{"$f":"IF(OR(P90=\"Disq\",P90=\"Abd\"),P90,(L90*1)+(M90*2)+(N90*3)+(O90*5)+P90)","v":34},{"$f":"SUM(K90:O90)","v":12},2,1,0,6,3,null,null,{"$f":"IF(G92>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K90:K93)","v":9},{"$f":"SUM(L90:L93)","v":8},{"$f":"SUM(M90:M93)","v":2}]
[null,"Pts Chpt","MC Zone 68",null,null,null,null,"T2",{"$f":"IF(OR(P91=\"Disq\",P91=\"Abd\"),P91,(L91*1)+(M91*2)+(N91*3)+(O91*5)+P91)","v":14},{"$f":"SUM(K91:O91)","v":12},5,3,1,3,0]
[null,{"$f":"VLOOKUP(B89,Attribution_des_points,2,FALSE)","v":3},null,null,null,"Heure Arrivée","15:45:00","T3",25,{"$f":"SUM(K92:O92)","v":12},2,4,1,3,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G92=0,0,G92-G90)","v":"06:26:00"},"T4",0,{"$f":"SUM(K93:O93)","v":0}]
[]
[null,"place",113,"EQUOY",null,"Moyenne par zone",{"$f":"IF(SUM(J97:J100)=0,0,(SUM(L97:L100)*1+SUM(M97:M100)*2+SUM(N97:N100)*3+SUM(O97:O100)*5)/SUM(J97:J100))","v":2.3333333333333335},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R97","v":0},"TOTAL",null,{"$f":"IF(OR(P97=\"Disq\",P98=\"Disq\",P99=\"Disq\",P100=\"Disq\",R97=\"HC\"),\"Disq\",IF(OR(P97=\"Abd\",P98=\"Abd\",P99=\"Abd\",P100=\"Abd\"),\"Abd\",SUM(I97:I100)+M95))","v":84},null,null,null,{"$f":"P95","v":84}]
[null,14,"LJA 358767-564","Maxence",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,null,null,null,"Heure Départ","09:25:00","T1",{"$f":"IF(OR(P97=\"Disq\",P97=\"Abd\"),P97,(L97*1)+(M97*2)+(N97*3)+(O97*5)+P97)","v":25},{"$f":"SUM(K97:O97)","v":12},2,2,3,4,1,null,null,{"$f":"IF(G99>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K97:K100)","v":6},{"$f":"SUM(L97:L100)","v":4},{"$f":"SUM(M97:M100)","v":8}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P98=\"Disq\",P98=\"Abd\"),P98,(L98*1)+(M98*2)+(N98*3)+(O98*5)+P98)","v":29},{"$f":"SUM(K98:O98)","v":12},1,2,4,3,2]
[null,{"$f":"VLOOKUP(B96,Attribution_des_points,2,FALSE)","v":2},null,null,null,"Heure Arrivée","16:16:00","T3",30,{"$f":"SUM(K99:O99)","v":12},3,0,1,6,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G99=0,0,G99-G97)","v":"06:51:00"},"T4",0,{"$f":"SUM(K100:O100)","v":0}]
[]
[null,"place",109,"CHRISTOPH",null,"Moyenne par zone",{"$f":"IF(SUM(J104:J107)=0,0,(SUM(L104:L107)*1+SUM(M104:M107)*2+SUM(N104:N107)*3+SUM(O104:O107)*5)/SUM(J104:J107))","v":2.3888888888888888},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R104","v":0},"TOTAL",null,{"$f":"IF(OR(P104=\"Disq\",P105=\"Disq\",P106=\"Disq\",P107=\"Disq\",R104=\"HC\"),\"Disq\",IF(OR(P104=\"Abd\",P105=\"Abd\",P106=\"Abd\",P107=\"Abd\"),\"Abd\",SUM(I104:I107)+M102))","v":86},null,null,null,{"$f":"P102","v":86}]
[null,15,"NTR 267647","Claude",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:32:00","T1",{"$f":"IF(OR(P104=\"Disq\",P104=\"Abd\"),P104,(L104*1)+(M104*2)+(N104*3)+(O104*5)+P104)","v":33},{"$f":"SUM(K104:O104)","v":12},1,2,0,7,2,null,null,{"$f":"IF(G106>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K104:K107)","v":6},{"$f":"SUM(L104:L107)","v":4},{"$f":"SUM(M104:M107)","v":6}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P105=\"Disq\",P105=\"Abd\"),P105,(L105*1)+(M105*2)+(N105*3)+(O105*5)+P105)","v":25},{"$f":"SUM(K105:O105)","v":12},3,1,2,5,1]
[null,{"$f":"VLOOKUP(B103,Attribution_des_points,2,FALSE)","v":1},null,null,null,"Heure Arrivée","16:09:00","T3",28,{"$f":"SUM(K106:O106)","v":12},2,1,4,3,2]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G106=0,0,G106-G104)","v":"06:37:00"},"T4",0,{"$f":"SUM(K107:O107)","v":0}]
[]
[null,"place",117,"ANTOINE",null,"Moyenne par zone",{"$f":"IF(SUM(J111:J114)=0,0,(SUM(L111:L114)*1+SUM(M111:M114)*2+SUM(N111:N114)*3+SUM(O111:O114)*5)/SUM(J111:J114))","v":0},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R111","v":0},"TOTAL",null,{"$f":"IF(OR(P111=\"Disq\",P112=\"Disq\",P113=\"Disq\",P114=\"Disq\",R111=\"HC\"),\"Disq\",IF(OR(P111=\"Abd\",P112=\"Abd\",P113=\"Abd\",P114=\"Abd\"),\"Abd\",SUM(I111:I114)+M109))","v":"Abd"},null,null,null,{"$f":"P109","v":"Abd"}]
[null,"Abd","LJA 188981-056","Aurelien",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","00:00:00","T1",{"$f":"IF(OR(P111=\"Disq\",P111=\"Abd\"),P111,(L111*1)+(M111*2)+(N111*3)+(O111*5)+P111)","v":"abd"},{"$f":"SUM(K111:O111)","v":0},null,null,null,null,null,"abd",null,{"$f":"IF(G113>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K111:K114)","v":0},{"$f":"SUM(L111:L114)","v":0},{"$f":"SUM(M111:M114)","v":0}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P112=\"Disq\",P112=\"Abd\"),P112,(L112*1)+(M112*2)+(N112*3)+(O112*5)+P112)","v":0},{"$f":"SUM(K112:O112)","v":0}]
[null,{"$f":"VLOOKUP(B110,Attribution_des_points,2,FALSE)","v":"NC"},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K113:O113)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G113=0,0,G113-G111)","v":"00:00:00"},"T4",0,{"$f":"SUM(K114:O114)","v":0}]

{"sheet":"S3 MAT2","index":10,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[3,13,3,14]]}
[]
[null,"CLASSEMENT",null,null,null,"S3 MAT2",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":1}]
[]
[null,"place",140,"WEIBEL",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.66666666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":"Abd"},null,null,null,{"$f":"P4","v":"Abd"}]
[null,"Abd","MAT2 040920","Christian",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:21:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":"abd"},{"$f":"SUM(K6:O6)","v":12},8,3,0,0,1,"abd",null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":8},{"$f":"SUM(L6:L9)","v":3},{"$f":"SUM(M6:M9)","v":0}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":0},{"$f":"SUM(K7:O7)","v":0}]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":"NC"},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K8:O8)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"00:00:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]

{"sheet":"S4+","index":11,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,10,3,11],[3,13,3,14],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[24,10,24,11],[24,13,24,14],[24,19,30,19],[25,1,26,1],[25,3,26,4],[27,2,29,4],[28,1,29,1],[24,3,24,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[38,10,38,11],[38,13,38,14],[38,19,44,19],[39,1,40,1],[39,3,40,4],[41,2,43,4],[42,1,43,1],[38,3,38,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[31,10,31,11],[31,13,31,14],[31,19,37,19],[32,1,33,1],[32,3,33,4],[34,2,36,4],[35,1,36,1],[31,3,31,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[31,9,32,9],[17,9,18,9],[17,10,17,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1],[10,19,16,19],[13,2,15,4],[14,1,15,1],[11,3,12,4],[11,1,12,1],[10,9,11,9],[10,8,11,8],[10,7,11,7],[10,6,11,6],[10,5,11,5],[10,13,10,14],[10,10,10,11],[10,3,10,4],[45,19,51,19],[46,1,47,1],[46,3,47,4],[48,2,50,4],[49,1,50,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[45,3,45,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[45,10,45,11],[45,13,45,14],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8]]}
[]
[null,"CLASSEMENT",null,null,null,"S4+",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":7}]
[]
[null,"place",157,"FEIDT",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.66666666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":24},null,null,null,{"$f":"P4","v":24}]
[null,1,"NTR 010125","Martin",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:12:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":13},{"$f":"SUM(K6:O6)","v":12},4,5,1,2,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":21},{"$f":"SUM(L6:L9)","v":10},{"$f":"SUM(M6:M9)","v":1}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":5},{"$f":"SUM(K7:O7)","v":12},9,2,0,1,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","17:11:00","T3",6,{"$f":"SUM(K8:O8)","v":12},8,3,0,1,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:59:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",152,"POIROT",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":0.77777777777777779},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":28},null,null,null,{"$f":"P11","v":28}]
[null,2,"NJ3 318952","Noah",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:07:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":6},{"$f":"SUM(K13:O13)","v":12},10,1,0,0,1,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":24},{"$f":"SUM(L13:L16)","v":6},{"$f":"SUM(M13:M16)","v":0}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":14},{"$f":"SUM(K14:O14)","v":12},6,3,0,2,1]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","15:12:00","T3",8,{"$f":"SUM(K15:O15)","v":12},8,2,0,2,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"06:05:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",153,"GREMILLET",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":0.80555555555555558},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":29},null,null,null,{"$f":"P18","v":29}]
[null,3,"NTR 081896","Luc",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:01:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":12},{"$f":"SUM(K20:O20)","v":12},7,2,1,1,1,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":24},{"$f":"SUM(L20:L23)","v":5},{"$f":"SUM(M20:M23)","v":1}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":6},{"$f":"SUM(K21:O21)","v":12},8,3,0,1,0]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","13:40:00","T3",11,{"$f":"SUM(K22:O22)","v":12},9,0,0,2,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"04:39:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",156,"TOUSSAINT",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":1.0277777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":37},null,null,null,{"$f":"P25","v":37}]
[null,4,"NTR 260384","Laurent",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:26:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":17},{"$f":"SUM(K27:O27)","v":12},5,2,0,5,0,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":19},{"$f":"SUM(L27:L30)","v":5},{"$f":"SUM(M27:M30)","v":4}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":11},{"$f":"SUM(K28:O28)","v":12},6,2,3,1,0]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","15:56:00","T3",9,{"$f":"SUM(K29:O29)","v":12},8,1,1,2,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"06:30:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",154,"SCHMITZ",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":1.0277777777777777},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":37},null,null,null,{"$f":"P32","v":37}]
[null,5,"NTR 151263","Jean Paul",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:29:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":11},{"$f":"SUM(K34:O34)","v":12},4,6,1,1,0,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":16},{"$f":"SUM(L34:L37)","v":12},{"$f":"SUM(M34:M37)","v":3}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":12},{"$f":"SUM(K35:O35)","v":12},6,3,2,0,1]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","16:10:00","T3",14,{"$f":"SUM(K36:O36)","v":12},6,3,0,2,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"06:41:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]
[]
[null,"place",155,"FLEURETTE",null,"Moyenne par zone",{"$f":"IF(SUM(J41:J44)=0,0,(SUM(L41:L44)*1+SUM(M41:M44)*2+SUM(N41:N44)*3+SUM(O41:O44)*5)/SUM(J41:J44))","v":1.1388888888888888},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R41","v":0},"TOTAL",null,{"$f":"IF(OR(P41=\"Disq\",P42=\"Disq\",P43=\"Disq\",P44=\"Disq\",R41=\"HC\"),\"Disq\",IF(OR(P41=\"Abd\",P42=\"Abd\",P43=\"Abd\",P44=\"Abd\"),\"Abd\",SUM(I41:I44)+M39))","v":41},null,null,null,{"$f":"P39","v":41}]
[null,6,"NTR 308338","Mathieu",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:27:00","T1",{"$f":"IF(OR(P41=\"Disq\",P41=\"Abd\"),P41,(L41*1)+(M41*2)+(N41*3)+(O41*5)+P41)","v":12},{"$f":"SUM(K41:O41)","v":12},6,2,2,2,0,null,null,{"$f":"IF(G43>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K41:K44)","v":19},{"$f":"SUM(L41:L44)","v":6},{"$f":"SUM(M41:M44)","v":2}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P42=\"Disq\",P42=\"Abd\"),P42,(L42*1)+(M42*2)+(N42*3)+(O42*5)+P42)","v":17},{"$f":"SUM(K42:O42)","v":12},5,3,0,3,1]
[null,{"$f":"VLOOKUP(B40,Attribution_des_points,2,FALSE)","v":10},null,null,null,"Heure Arrivée","14:36:00","T3",12,{"$f":"SUM(K43:O43)","v":12},8,1,0,2,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G43=0,0,G43-G41)","v":"05:09:00"},"T4",0,{"$f":"SUM(K44:O44)","v":0}]
[]
[null,"place",151,"JEUDY",null,"Moyenne par zone",{"$f":"IF(SUM(J48:J51)=0,0,(SUM(L48:L51)*1+SUM(M48:M51)*2+SUM(N48:N51)*3+SUM(O48:O51)*5)/SUM(J48:J51))","v":1.1944444444444444},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R48","v":0},"TOTAL",null,{"$f":"IF(OR(P48=\"Disq\",P49=\"Disq\",P50=\"Disq\",P51=\"Disq\",R48=\"HC\"),\"Disq\",IF(OR(P48=\"Abd\",P49=\"Abd\",P50=\"Abd\",P51=\"Abd\"),\"Abd\",SUM(I48:I51)+M46))","v":43},null,null,null,{"$f":"P46","v":43}]
[null,7,"NTR 331168","Justin",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:11:00","T1",{"$f":"IF(OR(P48=\"Disq\",P48=\"Abd\"),P48,(L48*1)+(M48*2)+(N48*3)+(O48*5)+P48)","v":13},{"$f":"SUM(K48:O48)","v":12},7,1,0,4,0,null,null,{"$f":"IF(G50>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K48:K51)","v":18},{"$f":"SUM(L48:L51)","v":5},{"$f":"SUM(M48:M51)","v":1}]
[null,"Pts Chpt","RN 66",null,null,null,null,"T2",{"$f":"IF(OR(P49=\"Disq\",P49=\"Abd\"),P49,(L49*1)+(M49*2)+(N49*3)+(O49*5)+P49)","v":13},{"$f":"SUM(K49:O49)","v":12},6,2,1,3,0]
[null,{"$f":"VLOOKUP(B47,Attribution_des_points,2,FALSE)","v":9},null,null,null,"Heure Arrivée","16:21:00","T3",17,{"$f":"SUM(K50:O50)","v":12},5,2,0,5,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G50=0,0,G50-G48)","v":"07:10:00"},"T4",0,{"$f":"SUM(K51:O51)","v":0}]

{"sheet":"S4+ MAT2","index":12,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,9,11,9],[10,10,10,11],[10,13,10,14],[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4],[14,1,15,1],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[17,19,23,19],[20,2,22,4],[21,1,22,1],[18,3,19,4],[18,1,19,1],[17,9,18,9],[17,8,18,8],[17,7,18,7],[17,6,18,6],[17,5,18,5],[17,13,17,14],[17,10,17,11],[17,3,17,4],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[3,13,3,14]]}
[]
[null,"CLASSEMENT",null,null,null,"S4+ MAT2",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":3}]
[]
[null,"place",170,"POIRIER",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.3611111111111111},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":13},null,null,null,{"$f":"P4","v":13}]
[null,1,"MAT2 139683","Regis",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:55:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":4},{"$f":"SUM(K6:O6)","v":12},9,2,1,0,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":28},{"$f":"SUM(L6:L9)","v":6},{"$f":"SUM(M6:M9)","v":1}]
[null,"Pts Chpt","ETLB",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":3},{"$f":"SUM(K7:O7)","v":12},9,3,0,0,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","16:52:00","T3",6,{"$f":"SUM(K8:O8)","v":12},10,1,0,0,1]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"06:57:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",172,"WEBER",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":0.63888888888888884},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":23},null,null,null,{"$f":"P11","v":23}]
[null,2,"MAT2 286684","Christian",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:57:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":10},{"$f":"SUM(K13:O13)","v":12},8,2,0,1,1,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":25},{"$f":"SUM(L13:L16)","v":4},{"$f":"SUM(M13:M16)","v":4}]
[null,"Pts Chpt","ETLB",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":5},{"$f":"SUM(K14:O14)","v":12},9,2,0,1,0]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","16:52:00","T3",8,{"$f":"SUM(K15:O15)","v":12},8,0,4,0,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"06:55:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",171,"DEREMARQUE",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":0.77777777777777779},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":28},null,null,null,{"$f":"P18","v":28}]
[null,3,"MAT2 154364","Jean Paul",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:56:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":14},{"$f":"SUM(K20:O20)","v":12},6,1,2,3,0,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":21},{"$f":"SUM(L20:L23)","v":7},{"$f":"SUM(M20:M23)","v":3}]
[null,"Pts Chpt","MC Epernay",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":6},{"$f":"SUM(K21:O21)","v":12},8,3,0,1,0]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","16:52:00","T3",8,{"$f":"SUM(K22:O22)","v":12},7,3,1,1,0]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"06:56:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]

{"sheet":"S4","index":13,"n_rows":72,"n_cols":23,"rows_kept":72,"cut":false,"hidden":false,"merged":[[10,19,16,19],[11,1,12,1],[11,3,12,4],[13,2,15,4],[14,1,15,1],[10,3,10,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[52,10,52,11],[52,13,52,14],[52,19,58,19],[53,1,54,1],[53,3,54,4],[55,2,57,4],[56,1,57,1],[52,3,52,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[52,9,53,9],[66,10,66,11],[66,13,66,14],[66,19,72,19],[67,1,68,1],[67,3,68,4],[69,2,71,4],[70,1,71,1],[66,3,66,4],[66,5,67,5],[66,6,67,6],[66,7,67,7],[66,8,67,8],[66,9,67,9],[59,10,59,11],[59,13,59,14],[59,19,65,19],[60,1,61,1],[60,3,61,4],[62,2,64,4],[63,1,64,1],[59,3,59,4],[59,5,60,5],[59,6,60,6],[59,7,60,7],[59,8,60,8],[59,9,60,9],[38,9,39,9],[31,10,31,11],[31,13,31,14],[31,19,37,19],[32,1,33,1],[32,3,33,4],[34,2,36,4],[35,1,36,1],[31,3,31,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[31,9,32,9],[39,1,40,1],[39,3,40,4],[41,2,43,4],[42,1,43,1],[38,3,38,4],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[3,19,9,19],[6,2,8,4],[7,1,8,1],[4,3,5,4],[4,1,5,1],[3,9,4,9],[3,8,4,8],[3,7,4,7],[45,10,45,11],[45,13,45,14],[45,19,51,19],[46,1,47,1],[46,3,47,4],[48,2,50,4],[49,1,50,1],[45,3,45,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[38,10,38,11],[38,13,38,14],[38,19,44,19],[3,13,3,14],[3,10,3,11],[3,3,3,4],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[17,10,17,11],[10,10,10,11],[10,13,10,14],[3,6,4,6],[3,5,4,5],[24,13,24,14],[24,19,30,19],[25,1,26,1],[25,3,26,4],[27,2,29,4],[28,1,29,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[24,3,24,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[24,10,24,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1]]}
[]
[null,"CLASSEMENT",null,null,null,"S4",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":10}]
[]
[null,"place",182,"MANGIN",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.33333333333333331},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":8},null,null,null,{"$f":"P4","v":8}]
[null,1,"LJA 382075-564","David",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,null,null,null,"Heure Départ","09:28:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":6},{"$f":"SUM(K6:O6)","v":12},8,2,2,0,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":18},{"$f":"SUM(L6:L9)","v":4},{"$f":"SUM(M6:M9)","v":2}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":2},{"$f":"SUM(K7:O7)","v":12},10,2,0,0,0]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","13:58:00","T3",0,{"$f":"SUM(K8:O8)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"04:30:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",209,"CAILLEAU",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":0.66666666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":16},null,null,null,{"$f":"P11","v":16}]
[null,2,"LJA 395075-564","Timothé",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,null,null,null,"Heure Départ","09:21:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":11},{"$f":"SUM(K13:O13)","v":12},8,1,1,1,1,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":17},{"$f":"SUM(L13:L16)","v":3},{"$f":"SUM(M13:M16)","v":1}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":5},{"$f":"SUM(K14:O14)","v":12},9,2,0,1,0]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","16:16:00","T3",0,{"$f":"SUM(K15:O15)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"06:55:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",183,"NADOT",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":0.79166666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":19},null,null,null,{"$f":"P18","v":19}]
[null,3,"NTR 339275","Camille",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:33:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":14},{"$f":"SUM(K20:O20)","v":12},5,4,1,1,1,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":13},{"$f":"SUM(L20:L23)","v":7},{"$f":"SUM(M20:M23)","v":2}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":5},{"$f":"SUM(K21:O21)","v":12},8,3,1,0,0]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","14:08:00","T3",0,{"$f":"SUM(K22:O22)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"04:35:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]
[]
[null,"place",181,"PIERREL",null,"Moyenne par zone",{"$f":"IF(SUM(J27:J30)=0,0,(SUM(L27:L30)*1+SUM(M27:M30)*2+SUM(N27:N30)*3+SUM(O27:O30)*5)/SUM(J27:J30))","v":0.91666666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R27","v":0},"TOTAL",null,{"$f":"IF(OR(P27=\"Disq\",P28=\"Disq\",P29=\"Disq\",P30=\"Disq\",R27=\"HC\"),\"Disq\",IF(OR(P27=\"Abd\",P28=\"Abd\",P29=\"Abd\",P30=\"Abd\"),\"Abd\",SUM(I27:I30)+M25))","v":22},null,null,null,{"$f":"P25","v":22}]
[null,4,"NCO 331170","Charlotte",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:09:00","T1",{"$f":"IF(OR(P27=\"Disq\",P27=\"Abd\"),P27,(L27*1)+(M27*2)+(N27*3)+(O27*5)+P27)","v":9},{"$f":"SUM(K27:O27)","v":12},5,5,2,0,0,null,null,{"$f":"IF(G29>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K27:K30)","v":10},{"$f":"SUM(L27:L30)","v":10},{"$f":"SUM(M27:M30)","v":2}]
[null,"Pts Chpt","La Bressaude",null,null,null,null,"T2",{"$f":"IF(OR(P28=\"Disq\",P28=\"Abd\"),P28,(L28*1)+(M28*2)+(N28*3)+(O28*5)+P28)","v":13},{"$f":"SUM(K28:O28)","v":12},5,5,0,1,1]
[null,{"$f":"VLOOKUP(B26,Attribution_des_points,2,FALSE)","v":13},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K29:O29)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G29=0,0,G29-G27)","v":"00:00:00"},"T4",0,{"$f":"SUM(K30:O30)","v":0}]
[]
[null,"place",187,"CROUVIZIER",null,"Moyenne par zone",{"$f":"IF(SUM(J34:J37)=0,0,(SUM(L34:L37)*1+SUM(M34:M37)*2+SUM(N34:N37)*3+SUM(O34:O37)*5)/SUM(J34:J37))","v":2},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R34","v":0},"TOTAL",null,{"$f":"IF(OR(P34=\"Disq\",P35=\"Disq\",P36=\"Disq\",P37=\"Disq\",R34=\"HC\"),\"Disq\",IF(OR(P34=\"Abd\",P35=\"Abd\",P36=\"Abd\",P37=\"Abd\"),\"Abd\",SUM(I34:I37)+M32))","v":48},null,null,null,{"$f":"P32","v":48}]
[null,5,"NTR 295688","Morgane",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:35:00","T1",{"$f":"IF(OR(P34=\"Disq\",P34=\"Abd\"),P34,(L34*1)+(M34*2)+(N34*3)+(O34*5)+P34)","v":30},{"$f":"SUM(K34:O34)","v":12},1,2,3,4,2,null,null,{"$f":"IF(G36>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K34:K37)","v":7},{"$f":"SUM(L34:L37)","v":2},{"$f":"SUM(M34:M37)","v":5}]
[null,"Pts Chpt","ETLB",null,null,null,null,"T2",{"$f":"IF(OR(P35=\"Disq\",P35=\"Abd\"),P35,(L35*1)+(M35*2)+(N35*3)+(O35*5)+P35)","v":18},{"$f":"SUM(K35:O35)","v":12},6,0,2,3,1]
[null,{"$f":"VLOOKUP(B33,Attribution_des_points,2,FALSE)","v":11},null,null,null,"Heure Arrivée","15:39:00","T3",0,{"$f":"SUM(K36:O36)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G36=0,0,G36-G34)","v":"06:04:00"},"T4",0,{"$f":"SUM(K37:O37)","v":0}]
[]
[null,"place",185,"CLAUDE",null,"Moyenne par zone",{"$f":"IF(SUM(J41:J44)=0,0,(SUM(L41:L44)*1+SUM(M41:M44)*2+SUM(N41:N44)*3+SUM(O41:O44)*5)/SUM(J41:J44))","v":2.2916666666666665},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R41","v":0},"TOTAL",null,{"$f":"IF(OR(P41=\"Disq\",P42=\"Disq\",P43=\"Disq\",P44=\"Disq\",R41=\"HC\"),\"Disq\",IF(OR(P41=\"Abd\",P42=\"Abd\",P43=\"Abd\",P44=\"Abd\"),\"Abd\",SUM(I41:I44)+M39))","v":55},null,null,null,{"$f":"P39","v":55}]
[null,6,"NJ3C 364632","Zoe",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:09:00","T1",{"$f":"IF(OR(P41=\"Disq\",P41=\"Abd\"),P41,(L41*1)+(M41*2)+(N41*3)+(O41*5)+P41)","v":31},{"$f":"SUM(K41:O41)","v":12},1,2,0,8,1,null,null,{"$f":"IF(G43>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K41:K44)","v":2},{"$f":"SUM(L41:L44)","v":5},{"$f":"SUM(M41:M44)","v":3}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P42=\"Disq\",P42=\"Abd\"),P42,(L42*1)+(M42*2)+(N42*3)+(O42*5)+P42)","v":24},{"$f":"SUM(K42:O42)","v":12},1,3,3,5,0]
[null,{"$f":"VLOOKUP(B40,Attribution_des_points,2,FALSE)","v":10},null,null,null,"Heure Arrivée","15:53:00","T3",0,{"$f":"SUM(K43:O43)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G43=0,0,G43-G41)","v":"05:44:00"},"T4",0,{"$f":"SUM(K44:O44)","v":0}]
[]
[null,"place",184,"RIVET",null,"Moyenne par zone",{"$f":"IF(SUM(J48:J51)=0,0,(SUM(L48:L51)*1+SUM(M48:M51)*2+SUM(N48:N51)*3+SUM(O48:O51)*5)/SUM(J48:J51))","v":2.5833333333333335},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R48","v":0},"TOTAL",null,{"$f":"IF(OR(P48=\"Disq\",P49=\"Disq\",P50=\"Disq\",P51=\"Disq\",R48=\"HC\"),\"Disq\",IF(OR(P48=\"Abd\",P49=\"Abd\",P50=\"Abd\",P51=\"Abd\"),\"Abd\",SUM(I48:I51)+M46))","v":62},null,null,null,{"$f":"P46","v":62}]
[null,7,"NTR 50899","Jean Christophe",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:08:00","T1",{"$f":"IF(OR(P48=\"Disq\",P48=\"Abd\"),P48,(L48*1)+(M48*2)+(N48*3)+(O48*5)+P48)","v":30},{"$f":"SUM(K48:O48)","v":12},2,1,0,8,1,null,null,{"$f":"IF(G50>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K48:K51)","v":4},{"$f":"SUM(L48:L51)","v":2},{"$f":"SUM(M48:M51)","v":0}]
[null,"Pts Chpt","AMVHV",null,null,null,null,"T2",{"$f":"IF(OR(P49=\"Disq\",P49=\"Abd\"),P49,(L49*1)+(M49*2)+(N49*3)+(O49*5)+P49)","v":32},{"$f":"SUM(K49:O49)","v":12},2,1,0,7,2]
[null,{"$f":"VLOOKUP(B47,Attribution_des_points,2,FALSE)","v":9},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K50:O50)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G50=0,0,G50-G48)","v":"00:00:00"},"T4",0,{"$f":"SUM(K51:O51)","v":0}]
[]
[null,"place",208,"CAILLEAU",null,"Moyenne par zone",{"$f":"IF(SUM(J55:J58)=0,0,(SUM(L55:L58)*1+SUM(M55:M58)*2+SUM(N55:N58)*3+SUM(O55:O58)*5)/SUM(J55:J58))","v":3.4166666666666665},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R55","v":0},"TOTAL",null,{"$f":"IF(OR(P55=\"Disq\",P56=\"Disq\",P57=\"Disq\",P58=\"Disq\",R55=\"HC\"),\"Disq\",IF(OR(P55=\"Abd\",P56=\"Abd\",P57=\"Abd\",P58=\"Abd\"),\"Abd\",SUM(I55:I58)+M53))","v":82},null,null,null,{"$f":"P53","v":82}]
[null,8,"LJA 395153-564","Tom",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,null,null,null,"Heure Départ","09:20:00","T1",{"$f":"IF(OR(P55=\"Disq\",P55=\"Abd\"),P55,(L55*1)+(M55*2)+(N55*3)+(O55*5)+P55)","v":45},{"$f":"SUM(K55:O55)","v":12},1,0,0,5,6,null,null,{"$f":"IF(G57>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K55:K58)","v":3},{"$f":"SUM(L55:L58)","v":0},{"$f":"SUM(M55:M58)","v":1}]
[null,"Pts Chpt","JOURNEE",null,null,null,null,"T2",{"$f":"IF(OR(P56=\"Disq\",P56=\"Abd\"),P56,(L56*1)+(M56*2)+(N56*3)+(O56*5)+P56)","v":37},{"$f":"SUM(K56:O56)","v":12},2,0,1,5,4]
[null,{"$f":"VLOOKUP(B54,Attribution_des_points,2,FALSE)","v":8},null,null,null,"Heure Arrivée","16:13:00","T3",0,{"$f":"SUM(K57:O57)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G57=0,0,G57-G55)","v":"06:53:00"},"T4",0,{"$f":"SUM(K58:O58)","v":0}]
[]
[null,"place",206,"KARST",null,"Moyenne par zone",{"$f":"IF(SUM(J62:J65)=0,0,(SUM(L62:L65)*1+SUM(M62:M65)*2+SUM(N62:N65)*3+SUM(O62:O65)*5)/SUM(J62:J65))","v":4.416666666666667},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R62","v":0},"TOTAL",null,{"$f":"IF(OR(P62=\"Disq\",P63=\"Disq\",P64=\"Disq\",P65=\"Disq\",R62=\"HC\"),\"Disq\",IF(OR(P62=\"Abd\",P63=\"Abd\",P64=\"Abd\",P65=\"Abd\"),\"Abd\",SUM(I62:I65)+M60))","v":"Abd"},null,null,null,{"$f":"P60","v":"Abd"}]
[null,"Abd","NJ3C 403074","Nolan",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:13:00","T1",{"$f":"IF(OR(P62=\"Disq\",P62=\"Abd\"),P62,(L62*1)+(M62*2)+(N62*3)+(O62*5)+P62)","v":"abd"},{"$f":"SUM(K62:O62)","v":12},0,0,1,2,9,"abd",null,{"$f":"IF(G64>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K62:K65)","v":0},{"$f":"SUM(L62:L65)","v":0},{"$f":"SUM(M62:M65)","v":1}]
[null,"Pts Chpt","MC Gazelec",null,null,null,null,"T2",{"$f":"IF(OR(P63=\"Disq\",P63=\"Abd\"),P63,(L63*1)+(M63*2)+(N63*3)+(O63*5)+P63)","v":0},{"$f":"SUM(K63:O63)","v":0}]
[null,{"$f":"VLOOKUP(B61,Attribution_des_points,2,FALSE)","v":"NC"},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K64:O64)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G64=0,0,G64-G62)","v":"00:00:00"},"T4",0,{"$f":"SUM(K65:O65)","v":0}]
[]
[null,"place",207,"KARST",null,"Moyenne par zone",{"$f":"IF(SUM(J69:J72)=0,0,(SUM(L69:L72)*1+SUM(M69:M72)*2+SUM(N69:N72)*3+SUM(O69:O72)*5)/SUM(J69:J72))","v":3.5},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R69","v":0},"TOTAL",null,{"$f":"IF(OR(P69=\"Disq\",P70=\"Disq\",P71=\"Disq\",P72=\"Disq\",R69=\"HC\"),\"Disq\",IF(OR(P69=\"Abd\",P70=\"Abd\",P71=\"Abd\",P72=\"Abd\"),\"Abd\",SUM(I69:I72)+M67))","v":"Abd"},null,null,null,{"$f":"P67","v":"Abd"}]
[null,"Abd","NJ3 403068","Leny",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:12:00","T1",{"$f":"IF(OR(P69=\"Disq\",P69=\"Abd\"),P69,(L69*1)+(M69*2)+(N69*3)+(O69*5)+P69)","v":"abd"},{"$f":"SUM(K69:O69)","v":12},0,1,0,7,4,"abd",null,{"$f":"IF(G71>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K69:K72)","v":0},{"$f":"SUM(L69:L72)","v":1},{"$f":"SUM(M69:M72)","v":0}]
[null,"Pts Chpt","MC Gazelec",null,null,null,null,"T2",{"$f":"IF(OR(P70=\"Disq\",P70=\"Abd\"),P70,(L70*1)+(M70*2)+(N70*3)+(O70*5)+P70)","v":0},{"$f":"SUM(K70:O70)","v":0}]
[null,{"$f":"VLOOKUP(B68,Attribution_des_points,2,FALSE)","v":"NC"},null,null,null,"Heure Arrivée","00:00:00","T3",0,{"$f":"SUM(K71:O71)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G71=0,0,G71-G69)","v":"00:00:00"},"T4",0,{"$f":"SUM(K72:O72)","v":0}]

{"sheet":"S4 MAT2","index":14,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,9,18,9],[17,10,17,11],[17,13,17,14],[17,19,23,19],[18,1,19,1],[18,3,19,4],[20,2,22,4],[21,1,22,1],[17,3,17,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[10,19,16,19],[13,2,15,4],[14,1,15,1],[11,3,12,4],[11,1,12,1],[10,9,11,9],[10,8,11,8],[10,7,11,7],[10,6,11,6],[10,5,11,5],[10,13,10,14],[10,10,10,11],[10,3,10,4],[3,19,9,19],[4,1,5,1],[4,3,5,4],[6,2,8,4],[7,1,8,1],[1,1,1,4],[1,7,1,12],[1,14,1,15],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,11],[3,13,3,14]]}
[]
[null,"CLASSEMENT",null,null,null,"S4 MAT2",null,"Heure d'Arrivée Maxi",null,null,null,null,null,null,{"$f":"'Données Courses'!E6","v":"17:30:00"},null,null,null,{"$f":"COUNTA(T:T)","v":3}]
[]
[null,"place",200,"THOMAS",null,"Moyenne par zone",{"$f":"IF(SUM(J6:J9)=0,0,(SUM(L6:L9)*1+SUM(M6:M9)*2+SUM(N6:N9)*3+SUM(O6:O9)*5)/SUM(J6:J9))","v":0.79166666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R6","v":0},"TOTAL",null,{"$f":"IF(OR(P6=\"Disq\",P7=\"Disq\",P8=\"Disq\",P9=\"Disq\",R6=\"HC\"),\"Disq\",IF(OR(P6=\"Abd\",P7=\"Abd\",P8=\"Abd\",P9=\"Abd\"),\"Abd\",SUM(I6:I9)+M4))","v":19},null,null,null,{"$f":"P4","v":19}]
[null,1,"NTR 023004","Dominique",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:39:00","T1",{"$f":"IF(OR(P6=\"Disq\",P6=\"Abd\"),P6,(L6*1)+(M6*2)+(N6*3)+(O6*5)+P6)","v":10},{"$f":"SUM(K6:O6)","v":12},5,5,1,1,0,null,null,{"$f":"IF(G8>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K6:K9)","v":14},{"$f":"SUM(L6:L9)","v":5},{"$f":"SUM(M6:M9)","v":3}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P7=\"Disq\",P7=\"Abd\"),P7,(L7*1)+(M7*2)+(N7*3)+(O7*5)+P7)","v":9},{"$f":"SUM(K7:O7)","v":12},9,0,2,0,1]
[null,{"$f":"VLOOKUP(B5,Attribution_des_points,2,FALSE)","v":20},null,null,null,"Heure Arrivée","14:34:00","T3",0,{"$f":"SUM(K8:O8)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G8=0,0,G8-G6)","v":"04:55:00"},"T4",0,{"$f":"SUM(K9:O9)","v":0}]
[]
[null,"place",201,"THOMAS",null,"Moyenne par zone",{"$f":"IF(SUM(J13:J16)=0,0,(SUM(L13:L16)*1+SUM(M13:M16)*2+SUM(N13:N16)*3+SUM(O13:O16)*5)/SUM(J13:J16))","v":0.91666666666666663},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R13","v":0},"TOTAL",null,{"$f":"IF(OR(P13=\"Disq\",P14=\"Disq\",P15=\"Disq\",P16=\"Disq\",R13=\"HC\"),\"Disq\",IF(OR(P13=\"Abd\",P14=\"Abd\",P15=\"Abd\",P16=\"Abd\"),\"Abd\",SUM(I13:I16)+M11))","v":22},null,null,null,{"$f":"P11","v":22}]
[null,2,"NTR 023012","Nicolas",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","09:40:00","T1",{"$f":"IF(OR(P13=\"Disq\",P13=\"Abd\"),P13,(L13*1)+(M13*2)+(N13*3)+(O13*5)+P13)","v":11},{"$f":"SUM(K13:O13)","v":12},6,4,1,0,1,null,null,{"$f":"IF(G15>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K13:K16)","v":12},{"$f":"SUM(L13:L16)","v":7},{"$f":"SUM(M13:M16)","v":2}]
[null,"Pts Chpt","MC Stanislas",null,null,null,null,"T2",{"$f":"IF(OR(P14=\"Disq\",P14=\"Abd\"),P14,(L14*1)+(M14*2)+(N14*3)+(O14*5)+P14)","v":11},{"$f":"SUM(K14:O14)","v":12},6,3,1,2,0]
[null,{"$f":"VLOOKUP(B12,Attribution_des_points,2,FALSE)","v":17},null,null,null,"Heure Arrivée","14:33:00","T3",0,{"$f":"SUM(K15:O15)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G15=0,0,G15-G13)","v":"04:53:00"},"T4",0,{"$f":"SUM(K16:O16)","v":0}]
[]
[null,"place",202,"FILLER",null,"Moyenne par zone",{"$f":"IF(SUM(J20:J23)=0,0,(SUM(L20:L23)*1+SUM(M20:M23)*2+SUM(N20:N23)*3+SUM(O20:O23)*5)/SUM(J20:J23))","v":1.125},"TOUR","Total/tr","Nbre Zones","Pénalité Temps",null,{"$f":"R20","v":0},"TOTAL",null,{"$f":"IF(OR(P20=\"Disq\",P21=\"Disq\",P22=\"Disq\",P23=\"Disq\",R20=\"HC\"),\"Disq\",IF(OR(P20=\"Abd\",P21=\"Abd\",P22=\"Abd\",P23=\"Abd\"),\"Abd\",SUM(I20:I23)+M18))","v":27},null,null,null,{"$f":"P18","v":27}]
[null,3,"MAT2 010275","Jean Marc",null,null,null,null,null,null,"Nbr.0","Nbr.1","Nbr.2","Nbr.3","Nbr.5","Pén. Jury"]
[null,null,"Grand Est",null,null,"Heure Départ","10:11:00","T1",{"$f":"IF(OR(P20=\"Disq\",P20=\"Abd\"),P20,(L20*1)+(M20*2)+(N20*3)+(O20*5)+P20)","v":10},{"$f":"SUM(K20:O20)","v":12},7,2,1,2,null,null,null,{"$f":"IF(G22>$O$2,\"HC\",0)","v":0},null,null,{"$f":"SUM(K20:K23)","v":11},{"$f":"SUM(L20:L23)","v":5},{"$f":"SUM(M20:M23)","v":4}]
[null,"Pts Chpt","TC Ban de la Roche",null,null,null,null,"T2",{"$f":"IF(OR(P21=\"Disq\",P21=\"Abd\"),P21,(L21*1)+(M21*2)+(N21*3)+(O21*5)+P21)","v":17},{"$f":"SUM(K21:O21)","v":12},4,3,3,1,1]
[null,{"$f":"VLOOKUP(B19,Attribution_des_points,2,FALSE)","v":15},null,null,null,"Heure Arrivée","15:42:00","T3",0,{"$f":"SUM(K22:O22)","v":0}]
[null,null,null,null,null,"Temps de course",{"$f":"IF(G22=0,0,G22-G20)","v":"05:31:00"},"T4",0,{"$f":"SUM(K23:O23)","v":0}]