{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Feuille de saisie","Feuille individuelle","Tests détaillés","Barèmes","Points"],"not_rendered":{"charts":1,"images":10,"macros":1,"external_links":0,"defined_names":31,"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":"Feuille de saisie","index":0,"n_rows":292,"n_cols":24,"rows_kept":292,"cut":false,"hidden":false,"merged":[[8,1,10,1],[8,4,10,4],[8,5,10,5],[8,6,9,6],[8,7,9,7],[8,3,10,3],[8,2,10,2],[10,22,10,23],[5,5,5,12],[1,5,2,12],[8,8,9,8],[8,15,9,15],[8,9,9,9],[8,11,9,11],[8,10,9,10],[8,12,9,12],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,13,9,13],[8,14,9,14],[8,16,9,16]]}
[]
[null,null,null,null,null,"Résultats des tests de condition physique - Rameurs J12 à J14"]
[]
[]
[]
[null,null,null,null,null,"Ligue Nouvelle Aquitaine"]
[]
[null,{"$f":"\"Nombre de sportifs : \"&COUNTA(totalsexe)&\" dont \"&COUNTIF(totalsexe,\"F\")&\" femmes et \"&COUNTIF(totalsexe,\"H\")&\" hommes\"","v":"Nombre de sportifs : 132 dont 132 femmes et 0 hommes"}]
[null,"NOM Prénom","Club","Catégorie","Sexe","Date de\nnaissance","SAUT EN LONGUEUR \nSANS ÉLAN","5 FOULÉES BONDISSANTES","SAUT EN HAUTEUR SANS ÉLAN","POMPES","ABDOMINAUX","ERGO : 5 COUPS MAX","TEST NAVETTE",{"$f":"G9","v":"SAUT EN LONGUEUR \rSANS ÉLAN"},"5 FOULÉES BONDISSANTES","SAUT EN HAUTEUR SANS ÉLAN","POMPES","ABDOMINAUX","ERGO : 5 COUPS MAX","TEST NAVETTE"]
[]
[null,null,null,null,null,null,"Distance en m","Distance en m","Hauteur en cm","Nombre","Nombre","Puissance en Watt","Numéro du palier","Note/20","Note/20","Note/20","Note/20","Note/20","Note/20","Note/20","Somme","Moyenne","Catégories J12 et J14"]
[null,"TOME-BELMONTE MAELYS","BAYONNE SN",{"$f":"IF(B12<>\"\",\"J\"&((2018)-(YEAR(F12)))&E12,\"\")","v":"J14F"},"F","2004-05-16",1.9,10.4,42,40,18,386,8,{"$f":"IF(G12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(G12,saut_f,3,TRUE),VLOOKUP(G12,saut_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(G12,saut_f,3,TRUE),VLOOKUP(G12,saut_m,2,TRUE))),\"\")","v":16},{"$f":"IF(H12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(H12,foulees_f,3,TRUE),VLOOKUP(H12,foulees_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(H12,foulees_f,3,TRUE),VLOOKUP(H12,foulees_m,2,TRUE))),\"\")","v":20},{"$f":"IF(I12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(I12,sauth_f,3,TRUE),VLOOKUP(I12,sauth_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(I12,sauth_f,3,TRUE),VLOOKUP(I12,sauth_m,2,TRUE))),\"\")","v":20},{"$f":"IF(J12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(J12,pompes_f,3,TRUE),VLOOKUP(J12,pompes_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(J12,pompes_f,3,TRUE),VLOOKUP(J12,pompes_m,2,TRUE))),\"\")","v":20},{"$f":"IF(K12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(K12,abdos_f,3,TRUE),VLOOKUP(K12,abdos_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(K12,abdos_f,3,TRUE),VLOOKUP(K12,abdos_m,2,TRUE))),\"\")","v":4},{"$f":"IF(L12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(L12,ergo_f,3,TRUE),VLOOKUP(L12,ergo_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(L12,ergo_f,3,TRUE),VLOOKUP(L12,ergo_m,2,TRUE))),\"\")","v":18},{"$f":"IF(M12<>\"\",IF(ISERROR(IF(E12=\"F\",VLOOKUP(M12,nav_f,3,TRUE),VLOOKUP(M12,nav_m,2,TRUE))),0,IF(E12=\"F\",VLOOKUP(M12,nav_f,3,TRUE),VLOOKUP(M12,nav_m,2,TRUE)) ),\"\")","v":8},{"$f":"SUM(T12,N12,O12,P12,Q12,R12,S12)","v":106},{"$f":"IF(ISERROR(AVERAGE(T12,N12,O12,P12,Q12,R12,S12)),\"0\",AVERAGE(T12,N12,O12,P12,Q12,R12,S12))","v":15.142857142857142},{"$f":"IF(D12<>\"\",(IF(OR(LEFT(D12,3)=\"J13\",LEFT(D12,3)=\"J14\"),\"J14\",IF(OR(LEFT(D12,3)=\"J11\",LEFT(D12,3)=\"J12\"),\"J12\",\"J10\"))),\"\")","v":"J14"},{"$f":"E12","v":"F"}]
[null,"CAPDEVILLE EVA","BAYONNE AV","J14F","F","2004-02-04",2.0499999999999998,10.5,42,30,16,324,7,19,20,20,20,4,12,6,101,14.428571428571429,"J14","F"]
[null,"VOGELEER ANDRÉA","MARMANDE AV","J14F","F","2004-06-27",1.86,9.9,35,30,20,329,8.25,15,20,17,20,5,12,8,97,13.857142857142858,"J14","F"]
[null,"HAMOIR ALIX","CHATELLERAULT SN","J14F","F","2004-01-06",1.8,10.02,34,25,19,335,7.75,14,20,17,20,4,13,7,95,13.571428571428571,"J14","F"]
[null,"COSSON EMMY","ST SYLVESTRE CNSS","J14F","F","2004-09-27",1.67,9.76,37,26,21,317,7.75,11,20,18,20,6,11,7,93,13.285714285714286,"J14","F"]
[null,"LABAT CAMILLE","BAYONNE SN","J14F","F","2004-12-27",1.9,10.6,48,38,17,333,6,16,20,20,20,4,13,0,93,13.285714285714286,"J14","F"]
[null,"PIAUGEARD LAOWEN","SAINTES CA","J14F","F","2004-03-01",1.73,9.8800000000000008,42,110,22,276,7.3,12,20,20,20,7,7,6,92,13.142857142857142,"J14","F"]
[null,"PERON HEZEKIA","LIBOURNE CN","J13F","F","2005-09-08",1.71,9.48,28,20,20,314,9.25,12,19,14,20,5,11,10,91,13,"J14","F"]
[null,"SHIGETOMI TAÏNA","BAYONNE AV","J13F","F","2005-01-09",1.85,10.1,47,13,14,428,5,15,20,20,13,3,20,0,91,13,"J14","F"]
[null,"COSSON LISE","ST SYLVESTRE CNSS","J14F","F","2004-09-27",1.78,10.220000000000001,42,13,20,400,6,13,20,20,13,5,20,0,91,13,"J14","F"]
[null,"AMRI INES","BERGERAC SN","J14F","F","2004-10-06",1.87,10.83,30,29,25,244,7.5,15,20,15,20,10,4,7,91,13,"J14","F"]
[null,"SOURGEN LALIE","AVIRON LANDES","J14F","F","2004-06-09",1.8,10.4,42,40,17,275,7,14,20,20,20,4,7,6,91,13,"J14","F"]
[null,"DURCI DWEYNE","LIBOURNE CN","J14F","F","2004-01-04",1.79,10.19,32,28,19,318,7,13,20,16,20,4,11,6,90,12.857142857142858,"J14","F"]
[null,"LENIER CLEMENCE","LIBOURNE CN","J14F","F","2004-07-29",1.81,10.48,33,27,19,298,7.75,14,20,16,20,4,9,7,90,12.857142857142858,"J14","F"]
[null,"MAZOYER DIT MAZURIER DAYANA","BORDEAUX EN","J14F","F","2004-09-27",1.9,10.68,47,31,19,230,7,16,20,20,20,4,3,6,89,12.714285714285714,"J14","F"]
[null,"MAILLOT JULENA","BAYONNE SN","J14F","F","2004-10-26",1.8,9.6,40,28,20,304,4,14,20,20,20,5,10,0,89,12.714285714285714,"J14","F"]
[null,"MARTIN MEYLI","CASTILLON RC","J14F","F","2004-04-07",1.74,11.55,33,23,20,356,5.5,12,20,16,20,5,15,0,88,12.571428571428571,"J14","F"]
[null,"POLYCARPE ELOISE","VILLENEUVE AV","J13F","F","2005-11-08",1.92,10.210000000000001,36,18,21,231,7,16,20,18,18,6,3,6,87,12.428571428571429,"J14","F"]
[null,"PANIER ADELE","CHATELLERAULT SN","J13F","F","2005-02-15",1.75,9.4,33,20,15,363,6,13,19,16,20,3,16,0,87,12.428571428571429,"J14","F"]
[null,"TERPEREAU LISON","ANGOULEME AC","J13F","F","2005-11-16",1.78,9.5,36,20,18,320,6.75,13,20,18,20,4,12,0,87,12.428571428571429,"J14","F"]
[null,"GONCALVES MANON","BAYONNE SN","J14F","F","2004-02-21",1.8,9.3000000000000007,39,27,13,241,8,14,18,19,20,3,4,8,86,12.285714285714286,"J14","F"]
[null,"JEANNERET CHARLOTTE","VILLENEUVE AV","J14F","F","2004-03-14",1.74,9.4,39,28,19,258,7.25,12,19,19,20,4,5,6,85,12.142857142857142,"J14","F"]
[null,"GONCALVES CARLA","VILLENEUVE AV","J14F","F","2004-05-07",1.7,9.6300000000000008,31,16,20,367,5,12,20,15,16,5,16,0,84,12,"J14","F"]
[null,"COLLIN DORA","BERGERAC SN","J13F","F","2005-02-16",1.74,9.43,34,20,19,249,7.75,12,19,17,20,4,4,7,83,11.857142857142858,"J14","F"]
[null,"PIALLEPORT LAURA","CASTILLON RC","J14F","F","2004-12-02",1.79,9.9,25,22,20,333,5.5,13,20,12,20,5,13,0,83,11.857142857142858,"J14","F"]
[null,"MOURCEINS-ZECCHI SARAH","CASTILLON RC","J14F","F","2004-02-04",1.59,9.1,28,15,17,357,7.75,9,17,14,15,4,15,7,81,11.571428571428571,"J14","F"]
[null,"ANDRADE CLEMENCE","BAYONNE AV","J14F","F","2004-07-22",1.6,9.3000000000000007,46,15,14,355,4,10,18,20,15,3,15,0,81,11.571428571428571,"J14","F"]
[null,"FICHET HELENE","LIBOURNE CN","J14F","F","2004-02-15",1.82,10.199999999999999,23,22,13,200,9,14,20,11,20,3,0,10,78,11.142857142857142,"J14","F"]
[null,"EGELE EVE","LIBOURNE CN","J13F","F","2005-12-19",1.85,9.83,23,12,17,280,7.75,15,20,11,12,4,8,7,77,11,"J14","F"]
[null,"PUY GALDOS HAIZEA","HENDAYE EAE","J14F","F","2004-09-23",1.7,8.6999999999999993,40,13,12,344,2,12,14,20,13,3,14,0,76,10.857142857142858,"J14","F"]
[null,"BIGOT CHLOE","SAINTES CA","J14F","F","2004-04-03",1.57,8.25,35,30,12,264,9,9,11,17,20,3,6,10,76,10.857142857142858,"J14","F"]
[null,"GROOTSWAGERS MILA","BAYONNE AV","J13F","F","2005-02-21",1.7,9.4,30,24,15,208,7,12,19,15,20,3,0,6,75,10.714285714285714,"J14","F"]
[null,"JAUREGUIBERRY LOLA","BAYONNE AV","J13F","F","2005-07-05",1.95,9.3000000000000007,35,5,15,331,3,17,18,17,5,3,13,0,73,10.428571428571429,"J14","F"]
[null,"SHIGETOMI TIARÉ","BAYONNE AV","J13F","F","2005-01-09",1.75,10,30,11,11,268,7,13,20,15,11,2,6,6,73,10.428571428571429,"J14","F"]
[null,"HOUZEL CHARLOTTE","BAYONNE SN","J14F","F","2004-08-20",1.7,9.3000000000000007,38,29,12,214,6,12,18,19,20,3,1,0,73,10.428571428571429,"J14","F"]
[null,"VINCENT ALIX","BORDEAUX EN","J14F","F","2004-02-01",1.57,9.0299999999999994,30,8,19,305,8.75,9,16,15,8,4,10,9,71,10.142857142857142,"J14","F"]
[null,"PUMONT EVA","LIBOURNE CN","J14F","F","2004-05-16",1.66,9.17,27,19,20,260,5.5,11,17,13,19,5,6,0,71,10.142857142857142,"J14","F"]
[null,"BEAUVILAIN AMELIE","AVIRON LANDES","J14F","F","2004-05-12",1.55,9,28,27,13,296,4,9,16,14,20,3,9,0,71,10.142857142857142,"J14","F"]
[null,"ETCHEVERRY NINA","BAYONNE SN","J14F","F","2004-07-14",1.55,8.6999999999999993,34,11,14,367,6,9,14,17,11,3,16,0,70,10,"J14","F"]
[null,"ZANON JULIETTE","LIBOURNE CN","J14F","F","2004-05-08",1.46,8.8800000000000008,29,25,20,281,5.5,7,15,14,20,5,8,0,69,9.8571428571428577,"J14","F"]
[null,"BIRAL EMILIE","SAINTES CA","J14F","F","2004-08-20",1.82,9.9499999999999993,41,6,13,264,6.5,14,20,20,6,3,6,0,69,9.8571428571428577,"J14","F"]
[null,"GALTIER DAURIAC JUSTINE","BAYONNE AV","J13F","F","2005-09-08",1.8,9.3000000000000007,27,23,12,208,5,14,18,13,20,3,0,0,68,9.7142857142857135,"J14","F"]
[null,"CANTINI GUILLIMETTE","COGNAC YRC","J13F","F","2005-10-14",1.73,8.6,25,21,21,249,6.75,12,14,12,20,6,4,0,68,9.7142857142857135,"J14","F"]
[null,"NAISSANT TAINA","BERGERAC SN","J14F","F","2004-01-26",1.39,8.42,24,20,18,293,7,5,12,12,20,4,9,6,68,9.7142857142857135,"J14","F"]
[null,"DE BOISSEZON ZIA","SAINTE FOY CN","J13F","F","2005-09-22",1.74,8.51,32,11,18,305,6,12,13,16,11,4,10,0,66,9.4285714285714288,"J14","F"]
[null,"CIMOLAI LOUISE","BAYONNE SN","J14F","F","2004-07-05",1.55,8.4,33,29,16,254,4,9,12,16,20,4,5,0,66,9.4285714285714288,"J14","F"]
[null,"CURUTCHET JADE","BAYONNE AV","J14F","F","2004-09-15",1.75,9.6999999999999993,33,13,15,176,5,13,20,16,13,3,0,0,65,9.2857142857142865,"J14","F"]
[null,"GOURGEAUD SARAH","ANGOULEME AC","J14F","F","2004-05-25",1.62,8.93,27,14,13,291,5.75,10,16,13,14,3,9,0,65,9.2857142857142865,"J14","F"]
[null,"DEVAUX ANNA","AVIRON LANDES","J14F","F","2004-05-14",1.8,9.1,33,10,13,241,5,14,17,16,10,3,4,0,64,9.1428571428571423,"J14","F"]
[null,"BARDELINI BEUNE LOLA","LIBOURNE CN","J13F","F","2005-01-23",1.57,8.82,20,15,15,319,4,9,15,10,15,3,11,0,63,9,"J14","F"]
[null,"HEBERT LISA","MARMANDE AV","J14F","F","2004-03-05",1.55,9.24,26,6,18,259,7.5,9,18,13,6,4,5,7,62,8.8571428571428577,"J14","F"]
[null,"LAMOUROUX CLARA","LIBOURNE CN","J14F","F","2004-01-19",1.38,8.26,26,30,15,235,7,5,11,13,20,3,3,6,61,8.7142857142857135,"J14","F"]
[null,"BROSSET ANAIS","VILLENEUVE AV","J14F","F","2004-08-14",1.67,9.32,28,4,21,277,4,11,18,14,4,6,7,0,60,8.5714285714285712,"J14","F"]
[null,"MONTAUD NORAH","BAYONNE AV","J14F","F","2004-03-25",1.75,9.6,32,6,15,229,5,13,20,16,6,3,2,0,60,8.5714285714285712,"J14","F"]
[null,"RANSINANGUE CAMILLE","AVIRON LANDES","J13F","F","2005-10-01",1.5,8.3000000000000007,32,0,12,489,3,8,12,16,0,3,20,0,59,8.4285714285714288,"J14","F"]
[null,"LEFEVRE MAELLE","COGNAC YRC","J13F","F","2005-02-10",1.64,8.8000000000000007,28,10,18,264,4.75,10,15,14,10,4,6,0,59,8.4285714285714288,"J14","F"]
[null,"BARRE THYLANE","VILLENEUVE AV","J14F","F","2004-02-11",1.46,8.24,20,4,22,410,3,7,11,10,4,7,20,0,59,8.4285714285714288,"J14","F"]
[null,"DUPOUY AMELIE","LIBOURNE CN","J13F","F","2005-08-15",1.58,8.5399999999999991,25,20,13,172,4,9,13,12,20,3,0,0,57,8.1428571428571423,"J14","F"]
[null,"URRU MARIE","LIBOS-FUMEL CN ","J13F","F","2005-11-16",1.59,8.0399999999999991,29,30,16,166,4.75,9,10,14,20,4,0,0,57,8.1428571428571423,"J14","F"]
[null,"KELLER EMMA","AVIRON LANDES","J13F","F","2005-03-12",1.4,9.1999999999999993,35,4,14,294,3,6,18,17,4,3,9,0,57,8.1428571428571423,"J14","F"]
[null,"RAMON FAUSTINE","BAYONNE AV","J13F","F","2005-04-01",1.6,8.1,29,13,12,140,7,10,10,14,13,3,0,6,56,8,"J14","F"]
[null,"VALENTIN NAYA","MARMANDE AV","J14F","F","2004-02-02",1.68,10.039999999999999,34,3,19,218,5.5,11,20,17,3,4,1,0,56,8,"J14","F"]
[null,"ALAOUI AXELLE","ANGOULEME AC","J14F","F","2004-09-01",1.42,8.35,35,8,19,284,5,6,12,17,8,4,8,0,55,7.8571428571428568,"J14","F"]
[null,"AZILE ADIÄMA","CHATELLERAULT SN","J13F","F","2005-07-19",1.38,8.5,24,18,16,144,6,5,13,12,18,4,0,0,52,7.4285714285714288,"J14","F"]
[null,"GOUDICHAUD ENEA","LIBOURNE CN",{"$f":"IF(B76<>\"\",\"J\"&((2018)-(YEAR(F76)))&E76,\"\")","v":"J14F"},"F","2004-11-27",1.55,0,22,16,19,329,5,{"$f":"IF(G76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(G76,saut_f,3,TRUE),VLOOKUP(G76,saut_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(G76,saut_f,3,TRUE),VLOOKUP(G76,saut_m,2,TRUE))),\"\")","v":9},{"$f":"IF(H76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(H76,foulees_f,3,TRUE),VLOOKUP(H76,foulees_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(H76,foulees_f,3,TRUE),VLOOKUP(H76,foulees_m,2,TRUE))),\"\")","v":0},{"$f":"IF(I76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(I76,sauth_f,3,TRUE),VLOOKUP(I76,sauth_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(I76,sauth_f,3,TRUE),VLOOKUP(I76,sauth_m,2,TRUE))),\"\")","v":11},{"$f":"IF(J76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(J76,pompes_f,3,TRUE),VLOOKUP(J76,pompes_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(J76,pompes_f,3,TRUE),VLOOKUP(J76,pompes_m,2,TRUE))),\"\")","v":16},{"$f":"IF(K76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(K76,abdos_f,3,TRUE),VLOOKUP(K76,abdos_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(K76,abdos_f,3,TRUE),VLOOKUP(K76,abdos_m,2,TRUE))),\"\")","v":4},{"$f":"IF(L76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(L76,ergo_f,3,TRUE),VLOOKUP(L76,ergo_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(L76,ergo_f,3,TRUE),VLOOKUP(L76,ergo_m,2,TRUE))),\"\")","v":12},{"$f":"IF(M76<>\"\",IF(ISERROR(IF(E76=\"F\",VLOOKUP(M76,nav_f,3,TRUE),VLOOKUP(M76,nav_m,2,TRUE))),0,IF(E76=\"F\",VLOOKUP(M76,nav_f,3,TRUE),VLOOKUP(M76,nav_m,2,TRUE)) ),\"\")","v":0},{"$f":"SUM(T76,N76,O76,P76,Q76,R76,S76)","v":52},{"$f":"IF(ISERROR(AVERAGE(T76,N76,O76,P76,Q76,R76,S76)),\"0\",AVERAGE(T76,N76,O76,P76,Q76,R76,S76))","v":7.4285714285714288},{"$f":"IF(D76<>\"\",(IF(OR(LEFT(D76,3)=\"J13\",LEFT(D76,3)=\"J14\"),\"J14\",IF(OR(LEFT(D76,3)=\"J11\",LEFT(D76,3)=\"J12\"),\"J12\",\"J10\"))),\"\")","v":"J14"},{"$f":"E76","v":"F"}]
[null,"TANGUY LOU","BAYONNE AV","J14F","F","2004-07-07",1.4,8,27,21,15,194,4,6,10,13,20,3,0,0,52,7.4285714285714288,"J14","F"]
[null,"ROUX JADE","BAYONNE SN","J13F","F","2005-04-22",1.3,7.4,24,12,10,346,3,4,6,12,12,2,14,0,50,7.1428571428571432,"J14","F"]
[null,"BERNARDIN ZOE","COGNAC YRC","J14F","F","2004-09-02",1.62,8.6,26,2,14,285,5.45,10,14,13,2,3,8,0,50,7.1428571428571432,"J14","F"]
[null,"COLLIN EUGENIE","COGNAC YRC","J14F","F","2004-06-13",1.58,8.77,29,4,17,242,5,9,15,14,4,4,4,0,50,7.1428571428571432,"J14","F"]
[null,"BAKRI SELMA","LIBOURNE CN","J13F","F","2005-12-17",1.5,8.3000000000000007,25,12,17,218,5,8,12,12,12,4,1,0,49,7,"J14","F"]
[null,"DECAUX PAULINE","VILLENEUVE AV","J13F","F","2005-12-22",1.74,8.5399999999999991,26,8,15,158,4,12,13,13,8,3,0,0,49,7,"J14","F"]
[null,"BLAIN TARA","AVIRON LANDES","J13F","F","2005-08-04",1.6,8.5,31,5,11,247,4,10,13,15,5,2,4,0,49,7,"J14","F"]
[null,"DAHAN SOLINE","BERGERAC SN","J14F","F","2004-04-21",1.27,9.2799999999999994,25,7,21,214,4.5,3,18,12,7,6,1,0,47,6.7142857142857144,"J14","F"]
[null,"THOMAS CHLOE","BORDEAUX EN","J13F","F","2005-09-19",1.43,7.82,17,20,17,190,4,6,8,8,20,4,0,0,46,6.5714285714285712,"J14","F"]
[null,"LAPEGUE ANAIS","BAYONNE AV","J14F","F","2004-09-09",1.45,7.1,35,11,13,241,6,7,4,17,11,3,4,0,46,6.5714285714285712,"J14","F"]
[null,"SOUARD-MAIRE LILI","BAYONNE AV","J13F","F","2005-07-10",1.5,7.8,30,9,15,211,4,8,8,15,9,3,1,0,44,6.2857142857142856,"J14","F"]
[null,"NUNES MARGAUX","CHATELLERAULT SN","J13F","F","2005-09-07",1.5,6.8,20,11,13,316,2.4500000000000002,8,1,10,11,3,11,0,44,6.2857142857142856,"J14","F"]
[null,"COUPEZ JULIE","CASTILLON RC","J14F","F","2004-03-05",1.31,8.06,24,12,21,203,4.5,4,10,12,12,6,0,0,44,6.2857142857142856,"J14","F"]
[null,"NAISSANT AMELIE","BERGERAC SN","J13F","F","2005-02-11",1.56,7.83,21,6,15,178,7.25,9,8,10,6,3,0,6,42,6,"J14","F"]
[null,"COIFFARD DUPREUILH LÉA","BAYONNE AV","J13F","F","2005-03-03",1.5,8.3000000000000007,31,2,10,144,4,8,12,15,2,2,0,0,39,5.5714285714285712,"J14","F"]
[null,"MARTINEZ ALICE","AVIRON LANDES","J14F","F","2004-03-10",1.3,7.6,28,7,10,229,6,4,7,14,7,2,2,0,36,5.1428571428571432,"J14","F"]
[null,"MISSONNIER ANAELLE","CHATELLERAULT SN","J14F","F","2004-10-05",1.1299999999999999,7,26,15,13,147,4.1500000000000004,0,3,13,15,3,0,0,34,4.8571428571428568,"J14","F"]
[null,"BLONDEL INES","BERGERAC SN","J13F","F","2005-01-08",1.21,6.59,13,3,11,405,0,2,0,6,3,2,20,0,33,4.7142857142857144,"J14","F"]
[null,"BETAILLE CHLOE","BERGERAC SN","J13F","F","2005-06-14",1.48,7.83,19,1,15,255,6,7,8,9,1,3,5,0,33,4.7142857142857144,"J14","F"]
[null,"INTROVIGNE LILI","BERGERAC SN","J13F","F","2005-07-27",1.31,7.18,15,2,19,301,1,4,4,7,2,4,10,0,31,4.4285714285714288,"J14","F"]
[null,"BRETAUD ALYSON","MARMANDE AV","J13F","F","2005-01-20",1.23,7.44,20,10,13,205,5,2,6,10,10,3,0,0,31,4.4285714285714288,"J14","F"]
[null,"DURU KEZIBAN","BORDEAUX EN","J13F","F","2005-04-18",1.38,8.06,16,1,16,206,1.51,5,10,8,1,4,0,0,28,4,"J14","F"]
[null,"BLEUZEN LEA","MARMANDE AV","J13F","F","2005-08-13",1.38,6.79,17,3,16,265,5,5,1,8,3,4,6,0,27,3.8571428571428572,"J14","F"]
[null,"JACQUET OMBELINE","LIBOS-FUMEL CN ","J13F","F","2005-07-26",1.18,6.21,26,4,18,234,3.75,1,0,13,4,4,3,0,25,3.5714285714285716,"J14","F"]
[null,"GACHARD JESSICA","LIBOURNE CN","J13F","F","2005-07-26",1.24,6.12,18,3,16,251,1,2,0,9,3,4,5,0,23,3.2857142857142856,"J14","F"]
[null,"ROGNERUD MAELANE","BERGERAC SN","J13F","F","2005-03-29",1.2,6.32,10,null,17,193,3.5,2,0,5,"",4,0,0,11,1.8333333333333333,"J14","F"]
[null,"ANIELLO DORA","BERGERAC SN","J12F","F","2006-10-11",1.96,10.26,37,20,19,202,6,17,20,18,20,4,0,0,79,11.285714285714286,"J12","F"]
[null,"CARPENE MARIE-ANGE","MARMANDE AV","J12F","F","2006-04-07",1.65,10.050000000000001,25,6,22,299,7,11,20,12,6,7,9,6,71,10.142857142857142,"J12","F"]
[null,"MIDEKIN MARINE","VILLENEUVE AV","J12F","F","2006-05-03",1.83,10.050000000000001,36,12,17,202,4.5,14,20,18,12,4,0,0,68,9.7142857142857135,"J12","F"]
[null,"LAURENT INES","ANGOULEME AC","J11F","F","2007-12-23",1.62,9.3000000000000007,27,21,12,133,3.75,10,18,13,20,3,0,0,64,9.1428571428571423,"J12","F"]
[null,"TOMEBELMONTE OIHANA","BAYONNE SN","J12F","F","2006-12-14",1.55,8.8000000000000007,27,25,19,239,4,9,15,13,20,4,3,0,64,9.1428571428571423,"J12","F"]
[null,"JARJANETTE CHLOE","BERGERAC SN","J12F","F","2006-05-18",1.51,8.8000000000000007,24,16,16,271,5.75,8,15,12,16,4,7,0,62,8.8571428571428577,"J12","F"]
[null,"RICARDO MORGAN","VILLENEUVE AV","J12F","F","2006-06-16",1.6,8.64,29,30,18,160,4.25,10,14,14,20,4,0,0,62,8.8571428571428577,"J12","F"]
[null,"GRAJA INES","VILLENEUVE AV","J12F","F","2006-09-07",1.65,9.1300000000000008,36,10,16,193,4.25,11,17,18,10,4,0,0,60,8.5714285714285712,"J12","F"]
[null,"CERIEZ ANNE","LIBOURNE CN","J12F","F","2006-11-14",1.53,9.1199999999999992,22,30,18,182,5.25,8,17,11,20,4,0,0,60,8.5714285714285712,"J12","F"]
[null,"DECKERMERCIER ELOISE","COGNAC YRC","J12F","F","2006-05-24",1.57,8.9499999999999993,30,12,14,245,5.25,9,16,15,12,3,4,0,59,8.4285714285714288,"J12","F"]
[null,"ENGARD LALIE","MIMIZAN CN","J11F","F","2007-04-17",1.35,8.6,23,30,15,180,5,5,14,11,20,3,0,0,53,7.5714285714285712,"J12","F"]
[null,"JANKOWSKI CAROLINE","LIBOURNE CN","J12F","F","2006-05-23",1.56,8,25,15,19,230,5,9,10,12,15,4,3,0,53,7.5714285714285712,"J12","F"]
[null,"JAGU IHINTZA","BAYONNE SN","J12F","F","2006-06-19",1.4,7.8,30,15,10,261,3,6,8,15,15,2,6,0,52,7.4285714285714288,"J12","F"]
[null,"SALUDAS MAYLIS","MIMIZAN CN","J11F","F","2007-07-28",1.5,8.5,28,13,14,202,3,8,13,14,13,3,0,0,51,7.2857142857142856,"J12","F"]
[null,"GOMEZ LAURA","AVIRON LANDES","J12F","F","2006-08-25",1.5,8,29,16,11,210,3,8,10,14,16,2,1,0,51,7.2857142857142856,"J12","F"]
[null,"RAVENET  CARLA UNSS","ANGOULEME AC","J12F","F","2006-07-14",1.3,8.0299999999999994,24,20,15,139,4.25,4,10,12,20,3,0,0,49,7,"J12","F"]
[null,"FOURCAUD MELISSANDRE","BERGERAC SN","J11F","F","2007-03-05",1.64,8.0500000000000007,21,10,17,210,4,10,10,10,10,4,1,0,45,6.4285714285714288,"J12","F"]
[null,"BRICOUT AGATHE","AVIRON LANDES","J11F","F","2007-04-03",1.4,8.1999999999999993,31,10,13,168,4,6,11,15,10,3,0,0,45,6.4285714285714288,"J12","F"]
[null,"SOURIMANT MAEWENN","BAYONNE SN","J12F","F","2006-01-16",1.45,8.3000000000000007,33,8,10,207,5,7,12,16,8,2,0,0,45,6.4285714285714288,"J12","F"]
[null,"SIRAMY  ANNA UNSS","ANGOULEME AC","J12F","F","2006-07-14",1.39,7.65,30,15,15,145,6.25,5,7,15,15,3,0,0,45,6.4285714285714288,"J12","F"]
[null,"NOURISSON LISE","AVIRON LANDES","J12F","F","2006-06-07",1.6,8.3000000000000007,27,3,14,170,2,10,12,13,3,3,0,0,41,5.8571428571428568,"J12","F"]
[null,"LANOS JULIETTE","BORDEAUX EN","J12F","F","2006-07-14",1.52,8.3000000000000007,18,5,16,224,3,8,12,9,5,4,2,0,40,5.7142857142857144,"J12","F"]
[null,"MAURICE JEANNE","LIBOURNE CN","J12F","F","2006-01-29",1.56,8.82,33,0,0,141,5.25,9,15,16,0,0,0,0,40,5.7142857142857144,"J12","F"]
[null,"MOREAUCHAPELLE SARAH","BAYONNE SN","J12F","F","2006-12-30",1.4,8.1,20,9,13,105,3,6,10,10,9,3,0,0,38,5.4285714285714288,"J12","F"]
[null,"LANTIAT-LESPERANCE LUNA","BAYONNE SN","J12F","F","2006-06-07",1.3,7.2,27,7,12,268,2,4,4,13,7,3,6,0,37,5.2857142857142856,"J12","F"]
[null,"BLAIN NINA","MIMIZAN CN","J11F","F","2007-08-25",1.35,8.1,29,4,12,201,3,5,10,14,4,3,0,0,36,5.1428571428571432,"J12","F"]
[null,"MALIE CHLOÉ","AVIRON LANDES","J12F","F","2006-10-05",1.1499999999999999,7.2,22,17,13,148,4,1,4,11,17,3,0,0,36,5.1428571428571432,"J12","F"]
[null,"BERTIN LOLA","ANGOULEME AC","J12F","F","2006-05-11",1.43,7.58,24,10,0,218,4.5,6,7,12,10,0,1,0,36,5.1428571428571432,"J12","F"]
[null,"CRESPO LOU","BAYONNE SN","J12F","F","2006-12-22",1.2,6.6,22,12,14,276,2,2,0,11,12,3,7,0,35,5,"J12","F"]
[null,"MONTAGNE LUCILE","AVIRON LANDES","J12F","F","2006-09-27",1.35,7.9,24,4,11,181,2,5,9,12,4,2,0,0,32,4.5714285714285712,"J12","F"]
[null,"MECSVEBER ANOUK","AVIRON LANDES","J11F","F","2007-06-26",1.35,7.3,30,3,15,167,1,5,5,15,3,3,0,0,31,4.4285714285714288,"J12","F"]
[null,"GOMEZ ANAÏS","MIMIZAN CN","J11F","F","2007-02-22",1.35,7.2,28,5,7,91,3,5,4,14,5,1,0,0,29,4.1428571428571432,"J12","F"]
[null,"STROSSERHAVARD JEANNE","VILLENEUVE AV","J12F","F","2006-02-08",1.21,7.65,23,0,16,201,1.5,2,7,11,0,4,0,0,24,3.4285714285714284,"J12","F"]
[null,"FORRESTIER EMMA","MIMIZAN CN","J11F","F","2007-12-12",1.25,7.3,19,3,12,110,2,3,5,9,3,3,0,0,23,3.2857142857142856,"J12","F"]
[null,"SAEZ ELAIA","HENDAYE EAE","J12F","F","2006-08-30",1.1499999999999999,6.8,27,2,10,246,2,1,1,13,2,2,4,0,23,3.2857142857142856,"J12","F"]
[null,"MECS--VEBER KEREN","AVIRON LANDES","J12F","F","2006-01-14",1.2,7.1,25,1,15,200,2,2,4,12,1,3,0,0,22,3.1428571428571428,"J12","F"]
[null,"BARBAS MARGAUX","VILLENEUVE AV",{"$f":"IF(B139<>\"\",\"J\"&((2018)-(YEAR(F139)))&E139,\"\")","v":"J12F"},"F","2006-02-01",1.19,6.11,18,0,16,185,1.5,{"$f":"IF(G139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(G139,saut_f,3,TRUE),VLOOKUP(G139,saut_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(G139,saut_f,3,TRUE),VLOOKUP(G139,saut_m,2,TRUE))),\"\")","v":1},{"$f":"IF(H139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(H139,foulees_f,3,TRUE),VLOOKUP(H139,foulees_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(H139,foulees_f,3,TRUE),VLOOKUP(H139,foulees_m,2,TRUE))),\"\")","v":0},{"$f":"IF(I139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(I139,sauth_f,3,TRUE),VLOOKUP(I139,sauth_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(I139,sauth_f,3,TRUE),VLOOKUP(I139,sauth_m,2,TRUE))),\"\")","v":9},{"$f":"IF(J139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(J139,pompes_f,3,TRUE),VLOOKUP(J139,pompes_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(J139,pompes_f,3,TRUE),VLOOKUP(J139,pompes_m,2,TRUE))),\"\")","v":0},{"$f":"IF(K139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(K139,abdos_f,3,TRUE),VLOOKUP(K139,abdos_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(K139,abdos_f,3,TRUE),VLOOKUP(K139,abdos_m,2,TRUE))),\"\")","v":4},{"$f":"IF(L139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(L139,ergo_f,3,TRUE),VLOOKUP(L139,ergo_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(L139,ergo_f,3,TRUE),VLOOKUP(L139,ergo_m,2,TRUE))),\"\")","v":0},{"$f":"IF(M139<>\"\",IF(ISERROR(IF(E139=\"F\",VLOOKUP(M139,nav_f,3,TRUE),VLOOKUP(M139,nav_m,2,TRUE))),0,IF(E139=\"F\",VLOOKUP(M139,nav_f,3,TRUE),VLOOKUP(M139,nav_m,2,TRUE)) ),\"\")","v":0},{"$f":"SUM(T139,N139,O139,P139,Q139,R139,S139)","v":14},{"$f":"IF(ISERROR(AVERAGE(T139,N139,O139,P139,Q139,R139,S139)),\"0\",AVERAGE(T139,N139,O139,P139,Q139,R139,S139))","v":2},{"$f":"IF(D139<>\"\",(IF(OR(LEFT(D139,3)=\"J13\",LEFT(D139,3)=\"J14\"),\"J14\",IF(OR(LEFT(D139,3)=\"J11\",LEFT(D139,3)=\"J12\"),\"J12\",\"J10\"))),\"\")","v":"J12"},{"$f":"E139","v":"F"}]
[null,"GOURD ANAIS","BERGERAC SN","J12F","F","2006-08-20",0.99,5.45,14,2,14,159,1.75,0,0,7,2,3,0,0,12,1.7142857142857142,"J12","F"]
[null,"LARROCHE MARINA","MARMANDE AV","J11F","F","2007-11-16",1.04,5.97,17,1,13,109,1.5,0,0,8,1,3,0,0,12,1.7142857142857142,"J12","F"]
[null,"PERVIEUX LYSIZ","BERGERAC SN","J10F","F","2008-07-14",1.21,7.96,21,0,14,168,3,2,9,10,0,3,0,0,24,3.4285714285714284,"J10","F"]
[null,"SOUBIELLE LEANE","MIMIZAN CN","J9F","F","2009-04-13",1.2,6.6,null,1,9,87,2,2,0,"",1,2,0,0,5,0.83333333333333337,"J10","F"]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,{"$f":"IF(B201<>\"\",\"J\"&((2018)-(YEAR(F201)))&E201,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(G201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(G201,saut_f,3,TRUE),VLOOKUP(G201,saut_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(G201,saut_f,3,TRUE),VLOOKUP(G201,saut_m,2,TRUE))),\"\")","v":""},{"$f":"IF(H201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(H201,foulees_f,3,TRUE),VLOOKUP(H201,foulees_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(H201,foulees_f,3,TRUE),VLOOKUP(H201,foulees_m,2,TRUE))),\"\")","v":""},{"$f":"IF(I201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(I201,sauth_f,3,TRUE),VLOOKUP(I201,sauth_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(I201,sauth_f,3,TRUE),VLOOKUP(I201,sauth_m,2,TRUE))),\"\")","v":""},{"$f":"IF(J201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(J201,pompes_f,3,TRUE),VLOOKUP(J201,pompes_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(J201,pompes_f,3,TRUE),VLOOKUP(J201,pompes_m,2,TRUE))),\"\")","v":""},{"$f":"IF(K201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(K201,abdos_f,3,TRUE),VLOOKUP(K201,abdos_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(K201,abdos_f,3,TRUE),VLOOKUP(K201,abdos_m,2,TRUE))),\"\")","v":""},{"$f":"IF(L201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(L201,ergo_f,3,TRUE),VLOOKUP(L201,ergo_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(L201,ergo_f,3,TRUE),VLOOKUP(L201,ergo_m,2,TRUE))),\"\")","v":""},{"$f":"IF(M201<>\"\",IF(ISERROR(IF(E201=\"F\",VLOOKUP(M201,nav_f,3,TRUE),VLOOKUP(M201,nav_m,2,TRUE))),0,IF(E201=\"F\",VLOOKUP(M201,nav_f,3,TRUE),VLOOKUP(M201,nav_m,2,TRUE)) ),\"\")","v":""},{"$f":"SUM(T201,N201,O201,P201,Q201,R201,S201)","v":0},{"$f":"IF(ISERROR(AVERAGE(T201,N201,O201,P201,Q201,R201,S201)),\"0\",AVERAGE(T201,N201,O201,P201,Q201,R201,S201))","v":"0"},{"$f":"IF(D201<>\"\",(IF(OR(LEFT(D201,3)=\"J13\",LEFT(D201,3)=\"J14\"),\"J14\",IF(OR(LEFT(D201,3)=\"J11\",LEFT(D201,3)=\"J12\"),\"J12\",\"J10\"))),\"\")","v":""},{"$f":"E201","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,{"$f":"IF(B235<>\"\",\"J\"&((2017)-(YEAR(F235)))&E235,\"\")","v":""},null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(G265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(G265,saut_f,3,TRUE),VLOOKUP(G265,saut_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(G265,saut_f,3,TRUE),VLOOKUP(G265,saut_m,2,TRUE))),\"\")","v":""},{"$f":"IF(H265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(H265,foulees_f,3,TRUE),VLOOKUP(H265,foulees_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(H265,foulees_f,3,TRUE),VLOOKUP(H265,foulees_m,2,TRUE))),\"\")","v":""},{"$f":"IF(I265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(I265,sauth_f,3,TRUE),VLOOKUP(I265,sauth_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(I265,sauth_f,3,TRUE),VLOOKUP(I265,sauth_m,2,TRUE))),\"\")","v":""},{"$f":"IF(J265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(J265,pompes_f,3,TRUE),VLOOKUP(J265,pompes_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(J265,pompes_f,3,TRUE),VLOOKUP(J265,pompes_m,2,TRUE))),\"\")","v":""},{"$f":"IF(K265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(K265,abdos_f,3,TRUE),VLOOKUP(K265,abdos_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(K265,abdos_f,3,TRUE),VLOOKUP(K265,abdos_m,2,TRUE))),\"\")","v":""},{"$f":"IF(L265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(L265,ergo_f,3,TRUE),VLOOKUP(L265,ergo_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(L265,ergo_f,3,TRUE),VLOOKUP(L265,ergo_m,2,TRUE))),\"\")","v":""},{"$f":"IF(M265<>\"\",IF(ISERROR(IF(E265=\"F\",VLOOKUP(M265,nav_f,3,TRUE),VLOOKUP(M265,nav_m,2,TRUE))),0,IF(E265=\"F\",VLOOKUP(M265,nav_f,3,TRUE),VLOOKUP(M265,nav_m,2,TRUE)) ),\"\")","v":""},{"$f":"SUM(T265,N265,O265,P265,Q265,R265,S265)","v":0},{"$f":"IF(ISERROR(AVERAGE(T265,N265,O265,P265,Q265,R265,S265)),\"0\",AVERAGE(T265,N265,O265,P265,Q265,R265,S265))","v":"0"},{"$f":"IF(D265<>\"\",(IF(OR(LEFT(D265,3)=\"J13\",LEFT(D265,3)=\"J14\"),\"J14\",IF(OR(LEFT(D265,3)=\"J11\",LEFT(D265,3)=\"J12\"),\"J12\",\"J10\"))),\"\")","v":""},{"$f":"E265","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,{"$f":"IF(B267<>\"\",\"J\"&((2017)-(YEAR(F267)))&E267,\"\")","v":""},null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]
[null,null,null,"",null,null,null,null,null,null,null,null,null,"","","","","","","",0,"0","",0]

{"sheet":"Feuille individuelle","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,2,2,3],[10,7,11,7],[10,8,11,8],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[4,2,4,7],[5,2,5,7],[6,2,6,7]]}
[]
[null,null,"Cliquer dans la cellule ci-dessous et choisir le nom désiré dans la liste déroulante.",null,null,null,null,"Sexe : ",{"$f":"VLOOKUP(nom,donnees,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"NOM Prénom : ","WERNER LUCIEN",null,null,null,null,"Date de naissance : ",{"$f":"VLOOKUP(nom,donnees,5,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Résultats des tests de condition physique - Rameurs J12 à J14"]
[null,null,{"$f":"nom","v":"WERNER LUCIEN"}]
[null,null,{"$f":"\"Sexe : \"&sexe&\" - Date de naissance : \"&TEXT(ddn,\"jj mmmm aaaa\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,"SAUT EN LONGUEUR \nSANS ÉLAN","5 FOULÉES BONDISSANTES","SAUT EN HAUTEUR SANS ÉLAN","POMPES","ABDOMINAUX","ERGO : 5 COUPS MAX","TEST NAVETTE"]
[]
[]
[null,"RÉSULTATS INDIVIDUELS",{"$f":"VALUE(VLOOKUP(nom,donnees,6,FALSE))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(nom,donnees,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(nom,donnees,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(nom,donnees,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(nom,donnees,10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(nom,donnees,11,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(nom,donnees,12,FALSE)","v":{"$error":"#N/A"}}]
[null,"POINTS INDIVIDUELS",{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(C14,saut_f,3,TRUE),VLOOKUP(C14,saut_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(C14,saut_f,3,TRUE),VLOOKUP(C14,saut_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(D14,foulees_f,3,TRUE),VLOOKUP(D14,foulees_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(D14,foulees_f,3,TRUE),VLOOKUP(D14,foulees_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(E14,sauth_f,3,TRUE),VLOOKUP(E14,sauth_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(E14,sauth_f,3,TRUE),VLOOKUP(E14,sauth_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(F14,pompes_f,3,TRUE),VLOOKUP(F14,pompes_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(F14,pompes_f,3,TRUE),VLOOKUP(F14,pompes_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(G14,abdos_f,3,TRUE),VLOOKUP(G14,abdos_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(G14,abdos_f,3,TRUE),VLOOKUP(G14,abdos_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(H14,ergo_f,3,TRUE),VLOOKUP(H14,ergo_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(H14,ergo_f,3,TRUE),VLOOKUP(H14,ergo_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(I14,nav_f,3,TRUE),VLOOKUP(I14,nav_m,2,TRUE))),          0,IF(sexe=\"F\",VLOOKUP(I14,nav_f,3,TRUE),VLOOKUP(I14,nav_m,2,TRUE))       )","v":0}]
[null,{"$f":"\"MOYENNE DES RÉSULTATS (\"&sexe&\")\"","v":{"$error":"#N/A"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalsaut)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalfoulees)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalsauth)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalpompes)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalabdos)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalergo)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(totalsexe, sexe,totalnav)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"\"MOYENNE DES POINTS (\"&sexe&\")\"","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(C16,saut_f,3,TRUE),VLOOKUP(C16,saut_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(C16,saut_f,3,TRUE),VLOOKUP(C16,saut_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(D16,foulees_f,3,TRUE),VLOOKUP(D16,foulees_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(D16,foulees_f,3,TRUE),VLOOKUP(D16,foulees_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(E16,sauth_f,3,TRUE),VLOOKUP(E16,sauth_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(E16,sauth_f,3,TRUE),VLOOKUP(E16,sauth_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(F16,pompes_f,3,TRUE),VLOOKUP(F16,pompes_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(F16,pompes_f,3,TRUE),VLOOKUP(F16,pompes_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(G16,abdos_f,3,TRUE),VLOOKUP(G16,abdos_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(G16,abdos_f,3,TRUE),VLOOKUP(G16,abdos_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(H16,ergo_f,3,TRUE),VLOOKUP(H16,ergo_m,2,TRUE))),0,IF(sexe=\"F\",VLOOKUP(H16,ergo_f,3,TRUE),VLOOKUP(H16,ergo_m,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(sexe=\"F\",VLOOKUP(I16,nav_f,3,TRUE),VLOOKUP(I16,nav_m,2,TRUE))),          0,IF(sexe=\"F\",VLOOKUP(I16,nav_f,3,TRUE),VLOOKUP(I16,nav_m,2,TRUE))       )","v":0}]

{"sheet":"Tests détaillés","index":2,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[[77,1,85,1],[2,1,10,1],[14,1,22,1],[26,1,37,1],[41,1,46,1],[50,1,62,1],[66,1,73,1]]}
[]
[null,"TEST N°1","SAUT EN LONGUEUR SANS ÉLAN"]
[null,null,"Objectif"]
[null,null,"Évaluer la puissance des membres inférieurs."]
[null,null,"Consignes"]
[null,null,"Position de départ : juste derrière la ligne, pieds joints (légèrement écartés), genoux fléchis à 90°, bras libres en arrière. Je saute pieds joints le plus loin possible en lançant les bras en avant. Je me réceptionne au sol en ramenant mes pieds sous les fesses. \u2028"]
[null,null,"Critères de réussite"]
[null,null,"Je ne tombe pas en arrière à la réception."]
[null,null,"Je note la distance réalisée sur le saut (ligne de départ - talon)"]
[null,null,"Matériels"]
[null,null,"Décamètre – Mesure au niveau du talon."]
[]
[]
[null,"TEST N°2","5 FOULÉES BONDISSANTES"]
[null,null,"Objectif"]
[null,null,"Évaluer la coordination des membres inférieurs."]
[null,null,"Consignes"]
[null,null,"Position de départ : juste derrière la ligne, pieds joints (légèrement écartés). Je saute le plus loin possible en réalisant 5 foulées bondissantes pieds-joints sans m’arrêter."]
[null,null,"Critères de réussite"]
[null,null,"La distance réalisée sur ces 5 foulées doit être supérieure à la somme des 5 sauts pieds-joints sans élan (Test n°1). Je ne tombe pas en arrière à la réception de la 5e foulée."]
[null,null,"Je note la distance totale réalisée sur les 5 sauts (ligne de départ - talon)"]
[null,null,"Matériels"]
[null,null,"Décamètre – Mesure au niveau du talon."]
[]
[]
[null,"TEST N°3","SAUT EN HAUTEUR SANS ÉLAN"]
[null,null,"Objectif"]
[null,null,"Évaluer la puissance des membres inférieurs."]
[null,null,"Consignes"]
[null,null,"La position de départ est debout, jambes tendues.  Au signal, je fléchis les jambes rapidement puis je saute le plus haut possible. Les mains restent libres. Je touche avec la main côté mur un point le plus haut possible."]
[null,null,"Critères de réussite"]
[null,null,"Améliorer sa hauteur de saut sur chacun des trois essais. La meilleure performance réalisée est retenue. "]
[null,null,"Je note la hauteur de saut réalisée (en cm)."]
[null,null,"Matériels"]
[null,null,"La hauteur de saut peut être mesurée avec :"]
[null,null,"-       une échelle de saut,"]
[null,null,"-       une craie sur un mur,"]
[null,null,"-       iPhone équipé de l’application MyJump (cf annexe pour les modalités d’utilisation)."]
[]
[]
[null,"TEST N°4","POMPES"]
[null,null,"Objectif"]
[null,null,"Réaliser le maximum de pompes."]
[null,null,"Consignes"]
[null,null,"Position de départ : allongé sur le ventre, les pieds écartés de 10 cm et en appui sur la face inférieure des orteils. L’espacement des mains correspond à une distance légèrement supérieure à celle des deux épaules. Les mains sont orientées vers l’avant. Je réalise le maximum de flexion-extension des membres supérieurs. La poitrine et le menton effleurent le sol à chaque flexion."]
[null,null,"Critères de réussite"]
[null,null,"L’extension des bras est complète. Le corps reste en ligne droite (tête, tronc, fesses, genoux, pieds) durant tout le mouvement. Je descends complètement à chaque répétition sans me laisser tomber. \nJe note le nombre de pompes réalisées en respectant les critères de résussite."]
[]
[]
[null,"ÉVALUATION N°5","ABDOMINAUX"]
[null," ","Objectif"]
[null,null,"Évaluer le gainage de la chaine abdominale."]
[null,null,"Consignes"]
[null,null,"Au signal, je réalise le maximum de flexions-extensions du tronc durant 30 secondes. \u2028"]
[null,null,"Critères de réalisation"]
[null,null,"Je suis à plat dos au sol, les mains derrière la tête, les coudes écartés et les membres inférieurs fléchis à 90° environ. Les pieds sont posés au sol (en fléchissant les genoux). Je réalise le plus de flexions du tronc."]
[null,null,"Critères de réussite"]
[null,null,"En flexion, mes coudes touchent mes genoux."]
[null,null,"En extension, mes épaules retrouvent le contact avec le sol."]
[null,null,"Mes pieds restent toujours au contact avec le sol."]
[null,null,"Je note le  nombre de flexions-extensions réalisées en respectant le critère de réussite."]
[null,null,"Matériels"]
[null,null,"Chrono"]
[]
[]
[null,"ÉVALUATION N°6","ERGO : 5 COUPS MAX"]
[null,null,"Objectif"]
[null,null,"Évaluer la puissance (en Watt) sur 5 coups."]
[null,null,"Consignes"]
[null,null,"Position de départ : 1/2 coulisse. Au signal, je produis la puissance la plus élevée possible sur 5 coups en respectant l'enchaînement du coup d’aviron (jambes, tronc, bras). Le volet de résistance est réglé sur à 5."]
[null,null,"Critères de réussite"]
[null,null,"Je note la puissance maximale atteinte lors du 5e coup d'aviron"]
[null,null,"Matériels"]
[null,null,"1 ergomètre aviron"]
[]
[]
[null,"ÉVALUATION N°7","TEST NAVETTE "]
[null,null,"Objectif"]
[null,null,"Évaluer l’endurance."]
[null,null,"Consignes"]
[null,null,"Je parcours le plus d’aller-retour entre deux bornes espacées de 20 m. J’arrive à chaque borne en même temps que le signal sonore."]
[null,null,"Critères de réussite"]
[null,null,"Je termine l’épreuve au palier le plus élevé. "]
[null,null,"Je note le nombre de paliers réalisés."]
[null,null,"Matériels"]
[null,null,"10 coupelles – 1 chrono – 1 sono – 1 bande sonore."]

{"sheet":"Barèmes","index":3,"n_rows":178,"n_cols":5,"rows_kept":178,"cut":false,"hidden":false,"merged":[[14,4,18,4],[1,1,1,2],[2,1,2,2],[2,3,2,4],[4,4,8,4],[9,4,13,4],[56,4,60,4],[19,4,23,4],[27,1,27,2],[28,1,28,2],[28,3,28,4],[30,4,34,4],[35,4,39,4],[40,4,44,4],[45,4,49,4],[53,1,53,2],[54,1,54,2],[54,3,54,4],[105,1,105,2],[105,3,105,4],[61,4,65,4],[66,4,70,4],[71,4,75,4],[78,1,78,2],[79,1,79,2],[79,3,79,4],[81,4,85,4],[86,4,90,4],[91,4,95,4],[96,4,100,4],[104,1,104,2],[155,1,155,2],[156,1,156,2],[156,3,156,4],[107,4,111,4],[112,4,116,4],[117,4,121,4],[122,4,126,4],[129,1,129,2],[130,1,130,2],[130,3,130,4],[158,4,162,4],[163,4,167,4],[168,4,172,4],[173,4,177,4],[132,4,136,4],[137,4,141,4],[142,4,146,4],[147,4,151,4]]}
[]
[null,"TEST N°1 : SAUT EN LONGUEUR SANS ÉLAN"]
[null,"BARÈME DE PERFORMANCE (m)"]
[null,"Filles","Garçons","Points"]
[null,2.1,2.4,20,"Excellent"]
[null,2.0499999999999998,2.35,19]
[null,2,2.2999999999999998,18]
[null,1.95,2.25,17]
[null,1.9,2.15,16]
[null,1.85,2.1,15,"Très bien"]
[null,1.8,2.0499999999999998,14]
[null,1.75,2,13]
[null,1.7,1.95,12]
[null,1.65,1.9,11]
[null,1.6,1.85,10,"Bien"]
[null,1.55,1.8,9]
[null,1.5,1.75,8]
[null,1.45,1.7,7]
[null,1.4,1.65,6]
[null,1.35,1.6,5,"Moyen"]
[null,1.3,1.55,4]
[null,1.25,1.5,3]
[null,1.2,1.45,2]
[null,1.1499999999999999,1.4,1]
[]
[]
[]
[null,"TEST N°2 : 5 FOULÉES BONDISSANTES"]
[null,"BARÈME DE PERFORMANCE (m)"]
[null,"Filles","Garçons","Points"]
[null,9.5,11,20,"Excellent"]
[null,9.35,10.85,19]
[null,9.1999999999999993,10.7,18]
[null,9.0500000000000007,10.55,17]
[null,8.9,10.4,16]
[null,8.75,10.25,15,"Très bien"]
[null,8.6,10.1,14]
[null,8.4499999999999993,9.9499999999999993,13]
[null,8.3000000000000007,9.8000000000000007,12]
[null,8.15,9.65,11]
[null,8,9.5,10,"Bien"]
[null,7.85,9.35,9]
[null,7.7,9.1999999999999993,8]
[null,7.55,9.0500000000000007,7]
[null,7.4,8.9,6]
[null,7.25,8.65,5,"Moyen"]
[null,7.1,8.5,4]
[null,7,8.35,3]
[null,6.85,8.1999999999999993,2]
[null,6.7,8.0500000000000007,1]
[]
[]
[]
[null,"TEST N°3 : SAUT EN HAUTEUR SANS ÉLAN"]
[null,"BARÈME DE PERFORMANCE (cm)"]
[null,"Filles","Garçons","Points"]
[null,40,50,20,"Excellent"]
[null,38,48,19]
[null,36,46,18]
[null,34,44,17]
[null,32,42,16]
[null,30,40,15,"Très bien"]
[null,28,38,14]
[null,26,36,13]
[null,24,34,12]
[null,22,32,11]
[null,20,30,10,"Bien"]
[null,18,28,9]
[null,16,26,8]
[null,14,24,7]
[null,12,22,6]
[null,10,20,5,"Moyen"]
[null,8,18,4]
[null,"-",16,3]
[null,"-","-",2]
[null,"-","-",1]
[]
[]
[null,"TEST N°4 : POMPES"]
[null,"BARÈME DE PERFORMANCE (rép.)"]
[null,"Filles","Garçons","Points"]
[null,20,30,20,"Excellent"]
[null,19,29,19]
[null,18,28,18]
[null,17,27,17]
[null,16,26,16]
[null,15,25,15,"Très bien"]
[null,14,24,14]
[null,13,23,13]
[null,12,22,12]
[null,11,21,11]
[null,10,20,10,"Bien"]
[null,9,19,9]
[null,8,18,8]
[null,7,17,7]
[null,6,16,6]
[null,5,13,5,"Moyen"]
[null,4,10,4]
[null,3,7,3]
[null,2,4,2]
[null,1,1,1]
[]
[]
[]
[null,"TEST N°5 : ABDOMINAUX"]
[null,"BARÈME DE PERFORMANCE (rép.)"]
[null,"Filles","Garçons","Points"]
[null,35,35,20,"Excellent"]
[null,34,34,19]
[null,33,33,18]
[null,32,32,17]
[null,31,31,16]
[null,30,30,15,"Très bien"]
[null,29,29,14]
[null,28,28,13]
[null,27,27,12]
[null,26,26,11]
[null,25,25,10,"Bien"]
[null,24,24,9]
[null,23,23,8]
[null,22,22,7]
[null,21,21,6]
[null,20,20,5,"Moyen"]
[null,16,16,4]
[null,12,12,3]
[null,8,8,2]
[null,4,4,1]
[]
[]
[null,"TEST N°6 : ERGO - 5 COUPS MAX"]
[null,"BARÈME DE PERFORMANCE (W)"]
[null,"Filles","Garçons","Points"]
[null,400,430,20,"Excellent"]
[null,390,420,19]
[null,380,410,18]
[null,370,400,17]
[null,360,390,16]
[null,350,380,15,"Très bien"]
[null,340,370,14]
[null,330,360,13]
[null,320,350,12]
[null,310,340,11]
[null,300,330,10,"Bien"]
[null,290,320,9]
[null,280,310,8]
[null,270,300,7]
[null,260,290,6]
[null,250,280,5,"Moyen"]
[null,240,270,4]
[null,230,260,3]
[null,220,250,2]
[null,210,240,1]
[]
[]
[]
[null,"TEST N°6 : TEST NAVETTE"]
[null,"BARÈME DE PERFORMANCE (palier)"]
[null,"Filles","Garçons","Points"]
[null,14,15,20,"Excellent"]
[null,13.5,14.5,19]
[null,13,14,18]
[null,12.5,13.5,17]
[null,12,13,16]
[null,11.5,12.5,15,"Très bien"]
[null,11,12,14]
[null,10.5,11.5,13]
[null,10,11,12]
[null,9.5,10.5,11]
[null,9,10,10,"Bien"]
[null,8.5,9.5,9]
[null,8,9,8]
[null,7.5,8.5,7]
[null,7,8,6]
[null,"-","-",5,"Moyen"]
[null,"-","-",4]
[null,"-","-",3]
[null,"-","-",2]
[null,"-","-",1]

{"sheet":"Points","index":4,"n_rows":175,"n_cols":6,"rows_kept":175,"cut":false,"hidden":true,"merged":[[1,1,1,2],[27,1,27,2],[26,1,26,2],[2,1,2,2],[51,1,51,2],[151,1,151,2],[152,1,152,2],[77,1,77,2],[76,1,76,2],[52,1,52,2],[101,1,101,2],[127,1,127,2],[126,1,126,2],[102,1,102,2]]}
[null,null,null,null,null,"Liste H & F"]
[null,"TEST N°1 : SAUT EN LONGUEUR SANS ÉLAN",null,null,null,"F"]
[null,"BARÈME DE PERFORMANCE (m)",null,null,null,"H"]
[null,"Filles","Garçons","Points"]
[null,1.1499999999999999,1.4,1]
[null,1.2,1.45,2]
[null,1.25,1.5,3]
[null,1.3,1.55,4]
[null,1.35,1.6,5]
[null,1.4,1.65,6]
[null,1.45,1.7,7]
[null,1.5,1.75,8]
[null,1.55,1.8,9]
[null,1.6,1.85,10]
[null,1.65,1.9,11]
[null,1.7,1.95,12]
[null,1.75,2,13]
[null,1.8,2.0499999999999998,14]
[null,1.85,2.1,15]
[null,1.9,2.15,16]
[null,1.95,2.25,17]
[null,2,2.2999999999999998,18]
[null,2.0499999999999998,2.35,19]
[null,2.1,2.4,20]
[null,3,3,20]
[]
[null,"TEST N°2 : 5 FOULÉES BONDISSANTES"]
[null,"BARÈME DE PERFORMANCE (m)"]
[null,"Filles","Garçons","Points"]
[null,6.7,8.0500000000000007,1]
[null,6.85,8.1999999999999993,2]
[null,7,8.35,3]
[null,7.1,8.5,4]
[null,7.25,8.65,5]
[null,7.4,8.9,6]
[null,7.55,9.0500000000000007,7]
[null,7.7,9.1999999999999993,8]
[null,7.85,9.35,9]
[null,8,9.5,10]
[null,8.15,9.65,11]
[null,8.3000000000000007,9.8000000000000007,12]
[null,8.4499999999999993,9.9499999999999993,13]
[null,8.6,10.1,14]
[null,8.75,10.25,15]
[null,8.9,10.4,16]
[null,9.0500000000000007,10.55,17]
[null,9.1999999999999993,10.7,18]
[null,9.35,10.85,19]
[null,9.5,11,20]
[null,15,15,20]
[]
[null,"TEST N°3 : SAUT EN HAUTEUR SANS ÉLAN"]
[null,"BARÈME DE PERFORMANCE (cm)"]
[null,"Filles","Garçons","Points"]
[null,"-","-",1]
[null,"-","-",2]
[null,"-",16,3]
[null,8,18,4]
[null,10,20,5]
[null,12,22,6]
[null,14,24,7]
[null,16,26,8]
[null,18,28,9]
[null,20,30,10]
[null,22,32,11]
[null,24,34,12]
[null,26,36,13]
[null,28,38,14]
[null,30,40,15]
[null,32,42,16]
[null,34,44,17]
[null,36,46,18]
[null,38,48,19]
[null,40,50,20]
[null,100,100,20]
[]
[null,"TEST N°4 : POMPES"]
[null,"BARÈME DE PERFORMANCE (rép.)"]
[null,"Filles","Garçons","Points"]
[null,1,1,1]
[null,2,4,2]
[null,3,7,3]
[null,4,10,4]
[null,5,13,5]
[null,6,16,6]
[null,7,17,7]
[null,8,18,8]
[null,9,19,9]
[null,10,20,10]
[null,11,21,11]
[null,12,22,12]
[null,13,23,13]
[null,14,24,14]
[null,15,25,15]
[null,16,26,16]
[null,17,27,17]
[null,18,28,18]
[null,19,29,19]
[null,20,30,20]
[null,50,50,20]
[]
[null,"TEST N°5 : ABDOMINAUX"]
[null,"BARÈME DE PERFORMANCE (rép.)"]
[null,"Filles","Garçons","Points"]
[null,4,4,1]
[null,8,8,2]
[null,12,12,3]
[null,16,16,4]
[null,20,20,5]
[null,21,21,6]
[null,22,22,7]
[null,23,23,8]
[null,24,24,9]
[null,25,25,10]
[null,26,26,11]
[null,27,27,12]
[null,28,28,13]
[null,29,29,14]
[null,30,30,15]
[null,31,31,16]
[null,32,32,17]
[null,33,33,18]
[null,34,34,19]
[null,35,35,20]
[null,100,100,20]
[]
[null,"TEST N°6 : ERGO - 5 COUPS MAX"]
[null,"BARÈME DE PERFORMANCE (W)"]
[null,"Filles","Garçons","Points"]
[null,210,240,1]
[null,220,250,2]
[null,230,260,3]
[null,240,270,4]
[null,250,280,5]
[null,260,290,6]
[null,270,300,7]
[null,280,310,8]
[null,290,320,9]
[null,300,330,10]
[null,310,340,11]
[null,320,350,12]
[null,330,360,13]
[null,340,370,14]
[null,350,380,15]
[null,360,390,16]
[null,370,400,17]
[null,380,410,18]
[null,390,420,19]
[null,400,430,20]
[null,100,100,20]
[]
[null,"TEST N°6 : TEST NAVETTE"]
[null,"BARÈME DE PERFORMANCE (palier)"]
[null,"Filles","Garçons","Points"]
[null,"-","-",1]
[null,"-","-",2]
[null,"-","-",3]
[null,"-","-",4]
[null,"-","-",5]
[null,7,8,6]
[null,7.5,8.5,7]
[null,8,9,8]
[null,8.5,9.5,9]
[null,9,10,10]
[null,9.5,10.5,11]
[null,10,11,12]
[null,10.5,11.5,13]
[null,11,12,14]
[null,11.5,12.5,15]
[null,12,13,16]
[null,12.5,13.5,17]
[null,13,14,18]
[null,13.5,14.5,19]
[null,14,15,20]
[null,20,20,20]