{"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":79,"n_cols":101,"rows_kept":79,"cut":false,"hidden":false,"merged":[[6,67,6,70],[6,71,6,74],[5,7,6,7],[5,0,6,0],[5,8,6,8],[5,6,6,6],[5,5,6,5],[5,2,6,2],[5,1,6,1],[6,10,6,13],[5,24,5,31],[0,1,0,5],[0,7,0,10],[5,10,5,14],[1,32,1,34],[2,0,2,1],[3,32,3,34],[1,0,1,8],[3,0,3,1],[2,4,2,8],[3,4,3,8],[3,10,3,15],[42,10,44,13],[4,0,4,16],[5,3,5,4],[5,16,6,16],[2,10,2,15]]}
["Lycée :",null,null,null,null,null,null,"BAC PRO CCF 2018",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,"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,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,"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,"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,"/ 14","réalisé",null,null,null,"note","/ 3",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,{"$f":"IF(COUNT(F8,G8,H8)=3,SUM(F8,G8,H8),\"\")","v":""},{"$f":"IF(AND(ISTEXT(C8),ISNUMBER(I8)),\nIF(C8=\"F\",INDEX(noteperf,MATCH(I8,perffilles,-1)),INDEX(noteperf,MATCH(I8,perfgars,-1))),\"\")","v":""},{"$f":"BL8","v":0},0,0,0,{"$f":"IF(AND(COUNTA(F8:H8)=3,ISTEXT(C8)),CW8,\"\")","v":""},null,{"$f":"IF(ISNUMBER(O8),SUM(J8:P8),\"\")","v":""},null,{"$f":"$S$7-F8","v":"00:05:30"},{"$f":"$S$7-G8","v":"00:05:30"},{"$f":"$S$7-H8","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(F8<=G8,G8-F8,F8-G8)","v":"00:00:00"},{"$f":"IF(G8<=H8,H8-G8,G8-H8)","v":"00:00:00"},{"$f":"IF(ISNUMBER(I8),SECOND(AG8),\"\")","v":""},{"$f":"IF(ISNUMBER(I8),SECOND(AH8),\"\")","v":""},{"$f":"IF(G8<F8,SECOND(AG8),-SECOND(AG8))","v":0},0,{"$f":"IF(AND(AI8<=3,AJ8<=3),1,0)","v":0},{"$f":"IF(AND((G8<F8),(H8<G8)),2,0)","v":0},{"$f":"IF(AND((AI8<=3),(H8<G8),(AJ8>=1)),3,0)","v":0},{"$f":"IF(AND((AI8<=3),(G8<H8),(AJ8>=1)),4,0)","v":0},{"$f":"IF(AND((AI8>=1),(AJ8<=3),(F8<G8)),5,0)","v":0},{"$f":"IF(AND((AI8>=1),(AJ8<=3),(F8>G8)),6,0)","v":0},{"$f":"IF(AND((AI8>=1),(AJ8>=1),(F8<G8),(G8>H8)),7,0)","v":0},{"$f":"IF(AND((AI8>=1),(AJ8>=1),(F8>G8),(G8<H8)),8,0)","v":0},{"$f":"IF(AM8=0,\"\",AM8)","v":""},{"$f":"IF(AN8=0,\"\",AN8)","v":""},"","","","","","",{"$f":"CONCATENATE(AU8,AV8,AW8,AX8,AY8,AZ8,BA8,BB8)","v":""},{"$f":"LEFT(BC8)","v":""},{"$f":"RIGHT(BC8)","v":""},{"$f":"LEFT(BC8,2)","v":""},{"$f":"RIGHT(BC8,2)","v":""},{"$f":"LEFT(BF8)","v":""},{"$f":"RIGHT(BF8)","v":""},{"$f":"LEFT(BG8)","v":""},{"$f":"RIGHT(BG8)","v":""},{"$f":"IF(BH8=\"\",0,BH8)","v":0},{"$f":"IF(BI8=BH8,0,BI8)","v":0},{"$f":"IF(BJ8=\"\",0,IF(OR(BJ8=BH8,BJ8=BI8),0,BJ8))","v":0},{"$f":"IF(BK8=\"\",0,(IF(OR(BK8=BH8,BK8=BI8,BK8=BJ8),0,BK8)))","v":0},{"$f":"IF(K8-D8=0,3,0)","v":3},{"$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(K8-E8=0,2.5,0)","v":2.5},{"$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(SUM(BP8:BS8)=3,3,IF(SUM(BT8:BW8)=2.5,2.5,0))","v":0},{"$f":"MAX(BT8:BW8)","v":2.5},{"$f":"IF(AK8>1,$BZ$5,0)","v":0},{"$f":"IF(AK8>1,$CA$5,0)","v":0},{"$f":"IF(AK8>1,$CB$5,0)","v":0},{"$f":"IF(AI8<=3,$CC$5,0)","v":0},{"$f":"IF(AI8<=3,$CD$5,0)","v":0},{"$f":"IF(AI8<=3,$CE$5,0)","v":0},{"$f":"IF(AK8<-1,$CF$5,0)","v":0},{"$f":"IF(AK8<-1,$CG$5,0)","v":0},{"$f":"IF(AJ8<=3,$CH$5,0)","v":0},{"$f":"IF(AJ8<=3,$CI$5,0)","v":0},{"$f":"IF(AJ8<=3,$CJ$5,0)","v":0},{"$f":"IF(AL8>1,$CK$5,0)","v":0},{"$f":"IF(AL8>1,$CL$5,0)","v":0},{"$f":"IF(AL8>1,$CM$5,0)","v":0},{"$f":"IF(AL8<-1,$CN$5,0)","v":0},{"$f":"IF(AL8<-1,$CO$5,0)","v":0},null,{"$f":"IF(D8=\"\",\"\",D8)","v":""},{"$f":"IF(OR(CQ8=BZ8,CQ8=CA8,CQ8=CB8,CQ8=CC8,CQ8=CD8,CQ8=CE8,CQ8=CF8,CQ8=CG8,CQ8=CH8,CQ8=CI8,CQ8=CJ8,CQ8=CK8,CQ8=CL8,CQ8=CM8,CQ8=CN8,CQ8=CO8),2,0)","v":0},null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"IF(OR(CT8=BZ8,CT8=CA8,CT8=CB8,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),1,0)","v":0},null,{"$f":"IF(E8=\"\",MAX(BX8,CR8,CU8),MAX(BY8,CU8))","v":0}]
["élève",2,null,null,null,null,null,null,"","",0,0,0,0,"",null,{"$f":"IF(ISNUMBER(O9),SUM(J9:P9),\"\")","v":""},null,{"$f":"$S$7-F9","v":"00:05:30"},{"$f":"$S$7-G9","v":"00:05:30"},{"$f":"$S$7-H9","v":"00:05:30"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F9<=G9,G9-F9,F9-G9)","v":"00:00:00"},{"$f":"IF(G9<=H9,H9-G9,G9-H9)","v":"00:00:00"},{"$f":"IF(ISNUMBER(I9),SECOND(AG9),\"\")","v":""},{"$f":"IF(ISNUMBER(I9),SECOND(AH9),\"\")","v":""},0,0,0,0,{"$f":"IF(AND((AI9<=3),(H9<G9),(AJ9>=1)),3,0)","v":0},{"$f":"IF(AND((AI9<=3),(G9<H9),(AJ9>=1)),4,0)","v":0},{"$f":"IF(AND((AI9>=1),(AJ9<=3),(F9<G9)),5,0)","v":0},0,0,0,{"$f":"IF(AM9=0,\"\",AM9)","v":""},{"$f":"IF(AN9=0,\"\",AN9)","v":""},{"$f":"IF(AO9=0,\"\",AO9)","v":""},{"$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":"CONCATENATE(AU9,AV9,AW9,AX9,AY9,AZ9,BA9,BB9)","v":""},{"$f":"LEFT(BC9)","v":""},{"$f":"RIGHT(BC9)","v":""},{"$f":"LEFT(BC9,2)","v":""},{"$f":"RIGHT(BC9,2)","v":""},{"$f":"LEFT(BF9)","v":""},{"$f":"RIGHT(BF9)","v":""},{"$f":"LEFT(BG9)","v":""},{"$f":"RIGHT(BG9)","v":""},{"$f":"IF(BH9=\"\",0,BH9)","v":0},{"$f":"IF(BI9=BH9,0,BI9)","v":0},{"$f":"IF(BJ9=\"\",0,IF(OR(BJ9=BH9,BJ9=BI9),0,BJ9))","v":0},{"$f":"IF(BK9=\"\",0,(IF(OR(BK9=BH9,BK9=BI9,BK9=BJ9),0,BK9)))","v":0},{"$f":"IF(K9-D9=0,IF(K9=0,0,3),0)","v":0},3,{"$f":"IF(M9-D9=0,3,0)","v":3},3,2.5,{"$f":"IF(L9-E9=0,2.5,0)","v":2.5},{"$f":"IF(M9-E9=0,2.5,0)","v":2.5},2.5,{"$f":"IF(SUM(BP9:BS9)=3,3,IF(SUM(BT9:BW9)=2.5,2.5,0))","v":0},{"$f":"MAX(BT9:BW9)","v":2.5},0,0,0,0,0,0,{"$f":"IF(AK9<-1,$CF$5,0)","v":0},{"$f":"IF(AK9<-1,$CG$5,0)","v":0},0,0,0,0,0,0,0,0,null,"",{"$f":"IF(OR(CQ9=BZ9,CQ9=CA9,CQ9=CB9,CQ9=CC9,CQ9=CD9,CQ9=CE9,CQ9=CF9,CQ9=CG9,CQ9=CH9,CQ9=CI9,CQ9=CJ9,CQ9=CK9,CQ9=CL9,CQ9=CM9,CQ9=CN9,CQ9=CO9),2,0)","v":0},null,"",{"$f":"IF(OR(CT9=BZ9,CT9=CA9,CT9=CB9,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),1,0)","v":0},null,{"$f":"IF(E9=\"\",MAX(BX9,CR9,CU9),MAX(BY9,CU9))","v":0}]
["élève",3,null,null,null,null,null,null,"","",{"$f":"BL10","v":0},{"$f":"BM10","v":0},{"$f":"BN10","v":0},{"$f":"BO10","v":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(I10),SECOND(AG10),\"\")","v":""},{"$f":"IF(ISNUMBER(I10),SECOND(AH10),\"\")","v":""},0,0,0,0,0,0,0,{"$f":"IF(AND((AI10>=1),(AJ10<=3),(F10>G10)),6,0)","v":0},0,0,"",{"$f":"IF(AN10=0,\"\",AN10)","v":""},"","","","","","","","","",{"$f":"LEFT(BC10,2)","v":""},"","","","","",0,0,0,0,{"$f":"IF(K10-D10=0,IF(K10=0,0,3),0)","v":0},3,{"$f":"IF(M10-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(CQ10=BZ10,CQ10=CA10,CQ10=CB10,CQ10=CC10,CQ10=CD10,CQ10=CE10,CQ10=CF10,CQ10=CG10,CQ10=CH10,CQ10=CI10,CQ10=CJ10,CQ10=CK10,CQ10=CL10,CQ10=CM10,CQ10=CN10,CQ10=CO10),2,0)","v":0},null,"",0,null,0]
["élève",4,null,null,null,null,null,null,"","",0,0,0,0,"",null,"",null,{"$f":"$S$7-F11","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(G11<F11,SECOND(AG11),-SECOND(AG11))","v":0},{"$f":"IF(H11<G11,SECOND(AH11),-SECOND(AH11))","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,"","",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(BJ12=BH12,BJ12=BI12),0,BJ12)","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,"","",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,"","",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(BJ14=BH14,0,IF(BJ14=BI14,0,BJ14))","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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",0,0,0,0,"",null,"",null,{"$f":"$S$7-F22","v":"00:05:30"},{"$f":"$S$7-G22","v":"00:05:30"},{"$f":"$S$7-H22","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(AI22<=3,AJ22<=3),1,0)","v":0},{"$f":"IF(AND((G22<F22),(H22<G22)),2,0)","v":0},0,0,0,0,0,0,"","","",{"$f":"IF(AP22=0,\"\",AP22)","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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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,"","",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(BF42)","v":""},{"$f":"RIGHT(BF42)","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,"Min.",{"$f":"IF(ISERROR(AVERAGE(J8:J42)),\"\",MIN(J8:J42))","v":""},null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(O8:O42)),\"\",MIN(O8:O42))","v":""},{"$f":"IF(ISERROR(AVERAGE(P8:P42)),\"\",MIN(P8:P42))","v":""},{"$f":"IF(ISERROR(AVERAGE(Q8:Q42)),\"\",MIN(Q8:Q42))","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,"Moy.",{"$f":"IF(ISERROR(AVERAGE(J8:J42)),\"\",AVERAGE(J8:J42))","v":""},null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(O8:O42)),\"\",AVERAGE(O8:O42))","v":""},{"$f":"IF(ISERROR(AVERAGE(P8:P42)),\"\",AVERAGE(P8:P42))","v":""},{"$f":"IF(ISERROR(AVERAGE(Q8:Q42)),\"\",AVERAGE(Q8:Q42))","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,"Max.",{"$f":"IF(ISERROR(AVERAGE(J8:J42)),\"\",MAX(J8:J42))","v":""},null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(O8:O42)),\"\",MAX(O8:O42))","v":""},{"$f":"IF(ISERROR(AVERAGE(P8:P42)),\"\",MAX(P8:P42))","v":""},{"$f":"IF(ISERROR(AVERAGE(Q8:Q42)),\"\",MAX(Q8:Q42))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,"perffilles","note","perfgars"]
[null,null,null,null,null,"00:30:00",0,"00:30:00"]
[null,null,null,null,null,"00:12:00.010",0.5,"00:08:35.013"]
[null,null,null,null,null,"00:11:40.010",1,"00:08:17.010"]
[null,null,null,null,null,"00:11:20.010",1.5,"00:08:00.010"]
[null,null,null,null,null,"00:11:00.010",2,"00:07:42.010"]
[null,null,null,null,null,"00:10:40.010",2.5,"00:07:24.013"]
[null,null,null,null,null,"00:10:20.010",3,"00:07:06.010"]
[null,null,null,null,null,"00:10:00.010",3.5,"00:06:49.010"]
[null,null,null,null,null,"00:09:40.010",4,"00:06:41.010"]
[null,null,null,null,null,"00:09:20.010",4.5,"00:06:33.010"]
[null,null,null,null,null,"00:09:00.010",5,"00:06:25"]
[null,null,null,null,null,"00:08:40.010",5.5,"00:06:17.010"]
[null,null,null,null,null,"00:08:20.010",6,"00:06:09.010"]
[null,null,null,null,null,"00:08:01.010",6.5,"00:06:01.010"]
[null,null,null,null,null,"00:07:42.010",7,"00:05:53.010"]
[null,null,null,null,null,"00:07:31.010",7.5,"00:05:43.010"]
[null,null,null,null,null,"00:07:20.010",8,"00:05:33.010"]
[null,null,null,null,null,"00:07:09.010",8.5,"00:05:23.010"]
[null,null,null,null,null,"00:06:58.010",9,"00:05:13.010"]
[null,null,null,null,null,"00:06:47.010",9.5,"00:05:03.010"]
[null,null,null,null,null,"00:06:36.010",10,"00:04:54.010"]
[null,null,null,null,null,"00:06:28.010",10.5,"00:04:45.010"]
[null,null,null,null,null,"00:06:21.010",11,"00:04:41.010"]
[null,null,null,null,null,"00:06:14.010",11.5,"00:04:37.010"]
[null,null,null,null,null,"00:06:07.010",12,"00:04:33.010"]
[null,null,null,null,null,"00:06:00.010",12.5,"00:04:29.010"]
[null,null,null,null,null,"00:05:54.010",13,"00:04:25.010"]
[null,null,null,null,null,"00:05:47.010",13.5,"00:04:21.010"]
[null,null,null,null,null,"00:05:41.010",14,"00:04:18.010"]