{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Demi-fond"],"not_rendered":{"charts":38,"images":14,"macros":1,"external_links":0,"defined_names":10,"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":"Demi-fond","index":0,"n_rows":71,"n_cols":104,"rows_kept":71,"cut":false,"hidden":false,"merged":[[4,0,4,19],[5,3,5,4],[5,19,6,19],[0,1,0,6],[0,8,0,11],[5,11,5,15],[5,5,6,5],[1,35,1,37],[2,0,2,1],[3,35,3,37],[1,0,1,9],[3,0,3,1],[2,4,2,9],[3,4,3,9],[2,15,2,18],[3,15,3,18],[42,11,44,14],[6,70,6,73],[6,74,6,77],[5,8,6,8],[5,0,6,0],[5,9,6,9],[5,7,6,7],[5,6,6,6],[5,2,6,2],[5,1,6,1],[6,11,6,14],[5,27,5,34]]}
["Lycée :",null,null,null,null,null,null,null,"BAC GT CCF 2018",null,null,null,null,null,null,null,null,null,null,"EPS",null,null,null,null,null,null,null,null,1,null,2,null,3,null,4]
[]
["Classe",null,null,null,"ACTIVITE",null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,"3 x 500 mètres"]
["\"chaque course chronométrée par  un enseignant à la seconde.\" reférentiel  du bac\nIMPORTANT : les temps sont à saisir sous forme \"143\" pour \"1mn43s\".\nNe pas oublier de remplir la colonne Sx (sexe) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,6,null,7,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,8,1,3,4,5,7,1,5,6,2,3,7,4,8]
["NOMS","Prénoms","Sx","Stratégie choisie",null,"Projet temps C1","temps réalisé 1er 500m","temps réalisé 2eme 500m","temps réalisé 3eme 500m","Temps total\nréalisé\nmn Sec","Note\nperf.","stratégie de course  /3",null,null,null,null,null,"Note Projet C1","Préparation et récupération","Note\nsur\n/20",null,null,null,null,null,null,null,"STRATÉGIES POSSIBLES"]
[null,null,null,"base","régulation",null,null,null,null,null,"/ 14","réalisé",null,null,null,"note",null,"/ 1","/ 2",null,null,"00:05:30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,null,"g","d","GG","DD","g","d",null,null,null,null,null,null,"base",null,null,null,"regul",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",null,null,"r"]
["élève",1,null,null,null,null,null,null,null,{"$f":"IF(COUNT(G8,H8,I8)=3,SUM(G8,H8,I8),\"\")","v":""},{"$f":"IF(AND(ISTEXT(C8),ISNUMBER(J8)),\nIF(C8=\"F\",INDEX(noteperf,MATCH(J8,perffilles,-1)),INDEX(noteperf,MATCH(J8,perfgars,-1))),\"\")","v":""},{"$f":"BO8","v":0},{"$f":"BP8","v":0},{"$f":"BQ8","v":0},{"$f":"BR8","v":0},{"$f":"IF(AND(COUNTA(G8:I8)=3,ISTEXT(C8)),CZ8,\"\")","v":""},{"$f":"IF(F8=\"\",\"\",IF(G8-F8>=0,G8-F8,F8-G8))","v":""},{"$f":"IF(F8=\"\",\"\",VLOOKUP(Q8,$Q$53:$R$54,2))","v":""},null,{"$f":"IF(ISNUMBER(P8),SUM(K8:S8),\"\")","v":""},null,{"$f":"$V$7-G8","v":"00:05:30"},{"$f":"$V$7-H8","v":"00:05:30"},{"$f":"$V$7-I8","v":"00:05:30"},null,null,null,null,{"$f":"CONCATENATE(A8,\" \",B8)","v":"élève 1"},null,{"$f":"CONCATENATE(A9,\" \",B9)","v":"élève 2"},null,{"$f":"CONCATENATE(A10,\" \",B10)","v":"élève 3"},null,{"$f":"CONCATENATE(A11,\" \",B11)","v":"élève 4"},{"$f":"IF(G8<=H8,H8-G8,G8-H8)","v":"00:00:00"},{"$f":"IF(H8<=I8,I8-H8,H8-I8)","v":"00:00:00"},{"$f":"IF(ISNUMBER(J8),SECOND(AJ8),\"\")","v":""},{"$f":"IF(ISNUMBER(J8),SECOND(AK8),\"\")","v":""},{"$f":"IF(H8<G8,SECOND(AJ8),-SECOND(AJ8))","v":0},0,{"$f":"IF(AND(AL8<=3,AM8<=3),1,0)","v":0},{"$f":"IF(AND((H8<G8),(I8<H8)),2,0)","v":0},{"$f":"IF(AND((AL8<=3),(I8<H8),(AM8>=1)),3,0)","v":0},{"$f":"IF(AND((AL8<=3),(H8<I8),(AM8>=1)),4,0)","v":0},{"$f":"IF(AND((AL8>=1),(AM8<=3),(G8<H8)),5,0)","v":0},{"$f":"IF(AND((AL8>=1),(AM8<=3),(G8>H8)),6,0)","v":0},{"$f":"IF(AND((AL8>=1),(AM8>=1),(G8<H8),(H8>I8)),7,0)","v":0},{"$f":"IF(AND((AL8>=1),(AM8>=1),(G8>H8),(H8<I8)),8,0)","v":0},{"$f":"IF(AP8=0,\"\",AP8)","v":""},{"$f":"IF(AQ8=0,\"\",AQ8)","v":""},"","","","","","",{"$f":"CONCATENATE(AX8,AY8,AZ8,BA8,BB8,BC8,BD8,BE8)","v":""},{"$f":"LEFT(BF8)","v":""},{"$f":"RIGHT(BF8)","v":""},{"$f":"LEFT(BF8,2)","v":""},{"$f":"RIGHT(BF8,2)","v":""},{"$f":"LEFT(BI8)","v":""},{"$f":"RIGHT(BI8)","v":""},{"$f":"LEFT(BJ8)","v":""},{"$f":"RIGHT(BJ8)","v":""},{"$f":"IF(BK8=\"\",0,BK8)","v":0},{"$f":"IF(BL8=BK8,0,BL8)","v":0},{"$f":"IF(BM8=\"\",0,IF(OR(BM8=BK8,BM8=BL8),0,BM8))","v":0},{"$f":"IF(BN8=\"\",0,(IF(OR(BN8=BK8,BN8=BL8,BN8=BM8),0,BN8)))","v":0},{"$f":"IF(L8-D8=0,3,0)","v":3},{"$f":"IF(M8-D8=0,3,0)","v":3},{"$f":"IF(N8-D8=0,3,0)","v":3},{"$f":"IF(O8-D8=0,3,0)","v":3},{"$f":"IF(L8-E8=0,2.5,0)","v":2.5},{"$f":"IF(M8-E8=0,2.5,0)","v":2.5},{"$f":"IF(N8-E8=0,2.5,0)","v":2.5},{"$f":"IF(O8-E8=0,2.5,0)","v":2.5},{"$f":"IF(SUM(BS8:BV8)=3,3,IF(SUM(BW8:BZ8)=2.5,2.5,0))","v":0},{"$f":"MAX(BW8:BZ8)","v":2.5},{"$f":"IF(AN8>1,$CC$5,0)","v":0},{"$f":"IF(AN8>1,$CD$5,0)","v":0},{"$f":"IF(AN8>1,$CE$5,0)","v":0},{"$f":"IF(AL8<=3,$CF$5,0)","v":0},{"$f":"IF(AL8<=3,$CG$5,0)","v":0},{"$f":"IF(AL8<=3,$CH$5,0)","v":0},{"$f":"IF(AN8<-1,$CI$5,0)","v":0},{"$f":"IF(AN8<-1,$CJ$5,0)","v":0},{"$f":"IF(AM8<=3,$CK$5,0)","v":0},{"$f":"IF(AM8<=3,$CL$5,0)","v":0},{"$f":"IF(AM8<=3,$CM$5,0)","v":0},{"$f":"IF(AO8>1,$CN$5,0)","v":0},{"$f":"IF(AO8>1,$CO$5,0)","v":0},{"$f":"IF(AO8>1,$CP$5,0)","v":0},{"$f":"IF(AO8<-1,$CQ$5,0)","v":0},{"$f":"IF(AO8<-1,$CR$5,0)","v":0},null,{"$f":"IF(D8=\"\",\"\",D8)","v":""},{"$f":"IF(OR(CT8=CC8,CT8=CD8,CT8=CE8,CT8=CF8,CT8=CG8,CT8=CH8,CT8=CI8,CT8=CJ8,CT8=CK8,CT8=CL8,CT8=CM8,CT8=CN8,CT8=CO8,CT8=CP8,CT8=CQ8,CT8=CR8),2,0)","v":0},null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"IF(OR(CW8=CC8,CW8=CD8,CW8=CE8,CW8=CF8,CW8=CG8,CW8=CH8,CW8=CI8,CW8=CJ8,CW8=CK8,CW8=CL8,CW8=CM8,CW8=CN8,CW8=CO8,CW8=CP8,CW8=CQ8,CW8=CR8),1,0)","v":0},null,{"$f":"IF(E8=\"\",MAX(CA8,CU8,CX8),MAX(CB8,CX8))","v":0}]
["élève",2,null,null,null,null,null,null,null,"","",0,0,0,0,"",{"$f":"IF(F9=\"\",\"\",IF(G9-F9>=0,G9-F9,F9-G9))","v":""},{"$f":"IF(F9=\"\",\"\",VLOOKUP(Q9,$Q$53:$R$54,2))","v":""},null,{"$f":"IF(ISNUMBER(P9),SUM(K9:S9),\"\")","v":""},null,{"$f":"$V$7-G9","v":"00:05:30"},{"$f":"$V$7-H9","v":"00:05:30"},{"$f":"$V$7-I9","v":"00:05:30"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G9<=H9,H9-G9,G9-H9)","v":"00:00:00"},{"$f":"IF(H9<=I9,I9-H9,H9-I9)","v":"00:00:00"},{"$f":"IF(ISNUMBER(J9),SECOND(AJ9),\"\")","v":""},{"$f":"IF(ISNUMBER(J9),SECOND(AK9),\"\")","v":""},0,0,0,0,{"$f":"IF(AND((AL9<=3),(I9<H9),(AM9>=1)),3,0)","v":0},{"$f":"IF(AND((AL9<=3),(H9<I9),(AM9>=1)),4,0)","v":0},{"$f":"IF(AND((AL9>=1),(AM9<=3),(G9<H9)),5,0)","v":0},0,0,0,{"$f":"IF(AP9=0,\"\",AP9)","v":""},{"$f":"IF(AQ9=0,\"\",AQ9)","v":""},{"$f":"IF(AR9=0,\"\",AR9)","v":""},{"$f":"IF(AS9=0,\"\",AS9)","v":""},{"$f":"IF(AT9=0,\"\",AT9)","v":""},{"$f":"IF(AU9=0,\"\",AU9)","v":""},{"$f":"IF(AV9=0,\"\",AV9)","v":""},{"$f":"IF(AW9=0,\"\",AW9)","v":""},{"$f":"CONCATENATE(AX9,AY9,AZ9,BA9,BB9,BC9,BD9,BE9)","v":""},{"$f":"LEFT(BF9)","v":""},{"$f":"RIGHT(BF9)","v":""},{"$f":"LEFT(BF9,2)","v":""},{"$f":"RIGHT(BF9,2)","v":""},{"$f":"LEFT(BI9)","v":""},{"$f":"RIGHT(BI9)","v":""},{"$f":"LEFT(BJ9)","v":""},{"$f":"RIGHT(BJ9)","v":""},{"$f":"IF(BK9=\"\",0,BK9)","v":0},{"$f":"IF(BL9=BK9,0,BL9)","v":0},{"$f":"IF(BM9=\"\",0,IF(OR(BM9=BK9,BM9=BL9),0,BM9))","v":0},{"$f":"IF(BN9=\"\",0,(IF(OR(BN9=BK9,BN9=BL9,BN9=BM9),0,BN9)))","v":0},{"$f":"IF(L9-D9=0,IF(L9=0,0,3),0)","v":0},3,{"$f":"IF(N9-D9=0,3,0)","v":3},3,2.5,{"$f":"IF(M9-E9=0,2.5,0)","v":2.5},{"$f":"IF(N9-E9=0,2.5,0)","v":2.5},2.5,{"$f":"IF(SUM(BS9:BV9)=3,3,IF(SUM(BW9:BZ9)=2.5,2.5,0))","v":0},{"$f":"MAX(BW9:BZ9)","v":2.5},0,0,0,0,0,0,{"$f":"IF(AN9<-1,$CI$5,0)","v":0},{"$f":"IF(AN9<-1,$CJ$5,0)","v":0},0,0,0,0,0,0,0,0,null,"",{"$f":"IF(OR(CT9=CC9,CT9=CD9,CT9=CE9,CT9=CF9,CT9=CG9,CT9=CH9,CT9=CI9,CT9=CJ9,CT9=CK9,CT9=CL9,CT9=CM9,CT9=CN9,CT9=CO9,CT9=CP9,CT9=CQ9,CT9=CR9),2,0)","v":0},null,"",{"$f":"IF(OR(CW9=CC9,CW9=CD9,CW9=CE9,CW9=CF9,CW9=CG9,CW9=CH9,CW9=CI9,CW9=CJ9,CW9=CK9,CW9=CL9,CW9=CM9,CW9=CN9,CW9=CO9,CW9=CP9,CW9=CQ9,CW9=CR9),1,0)","v":0},null,{"$f":"IF(E9=\"\",MAX(CA9,CU9,CX9),MAX(CB9,CX9))","v":0}]
["élève",3,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00",{"$f":"IF(ISNUMBER(J10),SECOND(AJ10),\"\")","v":""},{"$f":"IF(ISNUMBER(J10),SECOND(AK10),\"\")","v":""},0,0,0,0,0,0,0,{"$f":"IF(AND((AL10>=1),(AM10<=3),(G10>H10)),6,0)","v":0},0,0,"",{"$f":"IF(AQ10=0,\"\",AQ10)","v":""},"","","","","","","","","",{"$f":"LEFT(BF10,2)","v":""},"","","","","",0,0,0,0,{"$f":"IF(L10-D10=0,IF(L10=0,0,3),0)","v":0},3,{"$f":"IF(N10-D10=0,3,0)","v":3},3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",{"$f":"IF(OR(CT10=CC10,CT10=CD10,CT10=CE10,CT10=CF10,CT10=CG10,CT10=CH10,CT10=CI10,CT10=CJ10,CT10=CK10,CT10=CL10,CT10=CM10,CT10=CN10,CT10=CO10,CT10=CP10,CT10=CQ10,CT10=CR10),2,0)","v":0},null,"",0,null,0]
["élève",4,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,{"$f":"$V$7-G11","v":"00:05:30"},"00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",{"$f":"IF(H11<G11,SECOND(AJ11),-SECOND(AJ11))","v":0},{"$f":"IF(I11<H11,SECOND(AK11),-SECOND(AK11))","v":0},0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,0,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",5,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A12,\" \",B12)","v":"élève 5"},null,{"$f":"CONCATENATE(A13,\" \",B13)","v":"élève 6"},null,{"$f":"CONCATENATE(A14,\" \",B14)","v":"élève 7"},null,{"$f":"CONCATENATE(A15,\" \",B15)","v":"élève 8"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR(BM12=BK12,BM12=BL12),0,BM12)","v":0},0,0,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",6,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",7,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(BM14=BK14,0,IF(BM14=BL14,0,BM14))","v":0},0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",8,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",9,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A16,\" \",B16)","v":"élève 9"},null,{"$f":"CONCATENATE(A17,\" \",B17)","v":"élève 10"},null,{"$f":"CONCATENATE(A18,\" \",B18)","v":"élève 11"},null,{"$f":"CONCATENATE(A19,\" \",B19)","v":"élève 12"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",10,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",11,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",12,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",13,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A20,\" \",B20)","v":"élève 13"},null,{"$f":"CONCATENATE(A21,\" \",B21)","v":"élève 14"},null,{"$f":"CONCATENATE(A22,\" \",B22)","v":"élève 15"},null,{"$f":"CONCATENATE(A23,\" \",B23)","v":"élève 16"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",14,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",15,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,{"$f":"$V$7-G22","v":"00:05:30"},{"$f":"$V$7-H22","v":"00:05:30"},{"$f":"$V$7-I22","v":"00:05:30"},null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,{"$f":"IF(AND(AL22<=3,AM22<=3),1,0)","v":0},{"$f":"IF(AND((H22<G22),(I22<H22)),2,0)","v":0},0,0,0,0,0,0,"","","",{"$f":"IF(AS22=0,\"\",AS22)","v":""},"","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",16,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",17,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A24,\" \",B24)","v":"élève 17"},null,{"$f":"CONCATENATE(A25,\" \",B25)","v":"élève 18"},null,{"$f":"CONCATENATE(A26,\" \",B26)","v":"élève 19"},null,{"$f":"CONCATENATE(A27,\" \",B27)","v":"élève 20"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",18,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",19,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",20,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",21,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A28,\" \",B28)","v":"élève 21"},null,{"$f":"CONCATENATE(A29,\" \",B29)","v":"élève 22"},null,{"$f":"CONCATENATE(A30,\" \",B30)","v":"élève 23"},null,{"$f":"CONCATENATE(A31,\" \",B31)","v":"élève 24"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",22,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",23,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",24,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",25,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A32,\" \",B32)","v":"élève 25"},null,{"$f":"CONCATENATE(A33,\" \",B33)","v":"élève 26"},null,{"$f":"CONCATENATE(A34,\" \",B34)","v":"élève 27"},null,{"$f":"CONCATENATE(A35,\" \",B35)","v":"élève 28"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",26,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",27,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",28,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",29,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A36,\" \",B36)","v":"élève 29"},null,{"$f":"CONCATENATE(A37,\" \",B37)","v":"élève 30"},null,{"$f":"CONCATENATE(A38,\" \",B38)","v":"élève 31"},null,{"$f":"CONCATENATE(A39,\" \",B39)","v":"élève 32"},"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",30,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",31,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",32,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",33,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,{"$f":"CONCATENATE(A40,\" \",B40)","v":"élève 33"},null,{"$f":"CONCATENATE(A41,\" \",B41)","v":"élève 34"},null,{"$f":"CONCATENATE(A42,\" \",B42)","v":"élève 35"},null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",34,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
["élève",35,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","",{"$f":"LEFT(BI42)","v":""},{"$f":"RIGHT(BI42)","v":""},null,null,0,0,0,0,3,3,3,3,2.5,2.5,2.5,2.5,0,2.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,null,"",0,null,0]
[{"$f":"IF(COUNTA(A8:A42)=0,\"\",IF(COUNTA(A8:A42)>1,COUNTA(A8:A42)&\"  élèves\",COUNTA(A8:A42)&\"  élève\"))","v":"35  élèves"},null,null,null,null,null,null,null,null,"Min.",{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",MIN(K8:K42))","v":""},null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(P8:P42)),\"\",MIN(P8:P42))","v":""},{"$f":"IF(ISERROR(AVERAGE(Q8:Q42)),\"\",MIN(Q8:Q42))","v":""},{"$f":"IF(ISERROR(AVERAGE(R8:R42)),\"\",MIN(R8:R42))","v":""},{"$f":"IF(ISERROR(AVERAGE(S8:S42)),\"\",MIN(S8:S42))","v":""},""]
[{"$f":"IF(A43=\"\",\"\",IF(COUNTIF(C8:C42,\"f\")>1,\"dont    \"& COUNTIF(C8:C42,\"f\")&\"   filles\",COUNTIF(C8:C42,\"f\")&\"  fille\"))","v":"0  fille"},null,null,null,null,null,null,null,null,"Moy.",{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",AVERAGE(K8:K42))","v":""},null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(P8:P42)),\"\",AVERAGE(P8:P42))","v":""},{"$f":"IF(ISERROR(AVERAGE(Q8:Q42)),\"\",AVERAGE(Q8:Q42))","v":""},{"$f":"IF(ISERROR(AVERAGE(R8:R42)),\"\",AVERAGE(R8:R42))","v":""},{"$f":"IF(ISERROR(AVERAGE(S8:S42)),\"\",AVERAGE(S8:S42))","v":""},"",null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(A45,\" \",B45)","v":" "},null,{"$f":"CONCATENATE(A46,\" \",B46)","v":" "},null,{"$f":"CONCATENATE(A47,\" \",B47)","v":" "}]
[null,null,null,null,null,null,null,null,null,"Max.",{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",MAX(K8:K42))","v":""},null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(P8:P42)),\"\",MAX(P8:P42))","v":""},{"$f":"IF(ISERROR(AVERAGE(Q8:Q42)),\"\",MAX(Q8:Q42))","v":""},{"$f":"IF(ISERROR(AVERAGE(R8:R42)),\"\",MAX(R8:R42))","v":""},{"$f":"IF(ISERROR(AVERAGE(S8:S42)),\"\",MAX(S8:S42))","v":""},""]
[]
[]
[]
[]
[null,null,null,null,null,null,"perffilles","note","perfgars"]
[null,null,null,null,null,null,"00:30:00",0,"00:30:00"]
[null,null,null,null,null,null,"00:10:50.010",0.7,"00:08:05.010"]
[null,null,null,null,null,null,"00:10:20.010",1.4,"00:07:38.010",null,null,null,null,null,null,null,"00:00:00",1]
[null,null,null,null,null,null,"00:09:50.010",2.1,"00:07:11.010",null,null,null,null,null,null,null,"00:00:03.010",0]
[null,null,null,null,null,null,"00:09:24.010",2.8,"00:06:49.010"]
[null,null,null,null,null,null,"00:08:59.010",3.5,"00:06:28.010"]
[null,null,null,null,null,null,"00:08:37.010",4.2,"00:06:10.010"]
[null,null,null,null,null,null,"00:08:15.010",4.9000000000000004,"00:05:53.010"]
[null,null,null,null,null,null,"00:07:56.010",5.6,"00:05:37.010"]
[null,null,null,null,null,null,"00:07:38.010",6.3,"00:05:24.010"]
[null,null,null,null,null,null,"00:07:20.010",7,"00:05:14.010"]
[null,null,null,null,null,null,"00:07:03.010",7.7,"00:05:03.010"]
[null,null,null,null,null,null,"00:06:47.010",8.4,"00:04:56.010"]
[null,null,null,null,null,null,"00:06:31.010",9.1,"00:04:48.010"]
[null,null,null,null,null,null,"00:06:17.010",9.8000000000000007,"00:04:40.010"]
[null,null,null,null,null,null,"00:06:03.010",10.5,"00:04:34.010"]
[null,null,null,null,null,null,"00:05:55.010",11.2,"00:04:29.010"]
[null,null,null,null,null,null,"00:05:47.010",11.9,"00:04:24.010"]
[null,null,null,null,null,null,"00:05:41.010",12.6,"00:04:19.010"]
[null,null,null,null,null,null,"00:05:35.010",13.3,"00:04:15.010"]
[null,null,null,null,null,null,"00:05:30.010",14,"00:04:10.010"]