{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Demi-fond"],"not_rendered":{"charts":36,"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":100,"rows_kept":79,"cut":false,"hidden":false,"merged":[[6,66,6,69],[6,70,6,73],[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],[0,1,0,5],[0,7,0,10],[5,10,5,14],[1,29,1,32],[2,0,2,1],[3,29,3,32],[1,0,1,8],[3,0,3,1],[2,4,2,8],[3,4,3,8],[3,10,3,15],[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,"STRATÉGIE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,3,null,5,null,7]
["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,2,null,4,null,6,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,null,null,null,2,6,8,1,3,4,5,7,1,5,6,2,3,7,4,8,1]
["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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C1-C3"]
[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,"C1-C3",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)),IF(C8=\"F\",INDEX(noteperf,MATCH(I8,perffilles,-1)),INDEX(noteperf,MATCH(I8,perfgars,-1))),\"\")","v":""},{"$f":"BK8","v":0},{"$f":"BL8","v":0},{"$f":"BM8","v":0},{"$f":"BN8","v":0},{"$f":"IF(AND(COUNTA(F8:H8)=3,ISTEXT(C8)),CV8,\"\")","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"},{"$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"},null,{"$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(F8<=H8,H8-F8,F8-H8)","v":"00:00:00"},{"$f":"IF(ISNUMBER(I8),SECOND(AD8),\"\")","v":""},{"$f":"IF(ISNUMBER(I8),SECOND(AE8),\"\")","v":""},{"$f":"IF(G8<F8,SECOND(AD8),-SECOND(AD8))","v":0},{"$f":"IF(H8<G8,SECOND(AE8),-SECOND(AE8))","v":0},{"$f":"IF(ISNUMBER(I8),SECOND(AF8),\"\")","v":""},{"$f":"IF(AND(AG8<=3,AH8<=3),1,0)","v":0},{"$f":"IF(AND((G8<F8),(H8<G8)),2,0)","v":0},{"$f":"IF(AND((AG8<=3),(H8<G8),(AH8>=1)),3,0)","v":0},{"$f":"IF(AND((AG8<=3),(G8<H8),(AH8>=1)),4,0)","v":0},{"$f":"IF(AND((AG8>=1),(AH8<=3),(F8<G8)),5,0)","v":0},{"$f":"IF(AND((AG8>=1),(AH8<=3),(F8>G8)),6,0)","v":0},{"$f":"IF(AND((AG8>=1),(AH8>=1),(F8<G8),(G8>H8)),7,0)","v":0},{"$f":"IF(AND((AG8>=1),(AH8>=1),(F8>G8),(G8<H8)),8,0)","v":0},{"$f":"IF(AL8=0,\"\",AL8)","v":""},{"$f":"IF(AM8=0,\"\",AM8)","v":""},"","","","","","",{"$f":"CONCATENATE(AT8,AU8,AV8,AW8,AX8,AY8,AZ8,BA8)","v":""},{"$f":"LEFT(BB8)","v":""},{"$f":"RIGHT(BB8)","v":""},{"$f":"LEFT(BB8,2)","v":""},{"$f":"RIGHT(BB8,2)","v":""},{"$f":"LEFT(BE8)","v":""},{"$f":"RIGHT(BE8)","v":""},{"$f":"LEFT(BF8)","v":""},{"$f":"RIGHT(BF8)","v":""},{"$f":"IF(BG8=\"\",0,BG8)","v":0},{"$f":"IF(BH8=BG8,0,BH8)","v":0},{"$f":"IF(BI8=\"\",0,IF(OR(BI8=BG8,BI8=BH8),0,BI8))","v":0},{"$f":"IF(BJ8=\"\",0,(IF(OR(BJ8=BG8,BJ8=BH8,BJ8=BI8),0,BJ8)))","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,0)","v":2},{"$f":"IF(L8-E8=0,2,0)","v":2},{"$f":"IF(M8-E8=0,2,0)","v":2},{"$f":"IF(N8-E8=0,2,0)","v":2},{"$f":"IF(SUM(BO8:BR8)=3,3,IF(SUM(BS8:BV8)=2,2,0))","v":0},{"$f":"MAX(BS8:BV8)","v":2},{"$f":"IF(AI8>1,$BY$5,0)","v":0},{"$f":"IF(AI8>1,$BZ$5,0)","v":0},{"$f":"IF(AI8>1,$CA$5,0)","v":0},{"$f":"IF(AG8<=3,$CB$5,0)","v":0},{"$f":"IF(AG8<=3,$CC$5,0)","v":0},{"$f":"IF(AG8<=3,$CD$5,0)","v":0},{"$f":"IF(AI8<-1,$CE$5,0)","v":0},{"$f":"IF(AI8<-1,$CF$5,0)","v":0},{"$f":"IF(AH8<=3,$CG$5,0)","v":0},{"$f":"IF(AH8<=3,$CH$5,0)","v":0},{"$f":"IF(AH8<=3,$CI$5,0)","v":0},{"$f":"IF(AJ8>1,$CJ$5,0)","v":0},{"$f":"IF(AJ8>1,$CK$5,0)","v":0},{"$f":"IF(AJ8>1,$CL$5,0)","v":0},{"$f":"IF(AJ8<-1,$CM$5,0)","v":0},{"$f":"IF(AJ8<-1,$CN$5,0)","v":0},{"$f":"IF(AK8<1,$CO$5,0)","v":0},{"$f":"IF(D8=\"\",\"\",D8)","v":""},{"$f":"IF(OR(CP8=BY8,CP8=BZ8,CP8=CA8,CP8=CB8,CP8=CC8,CP8=CD8,CP8=CE8,CP8=CF8,CP8=CG8,CP8=CH8,CP8=CI8,CP8=CJ8,CP8=CK8,CP8=CL8,CP8=CM8,CP8=CN8,CP8=CO8),1.5,0)","v":0},null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"IF(OR(CS8=BY8,CS8=BZ8,CS8=CA8,CS8=CB8,CS8=CC8,CS8=CD8,CS8=CE8,CS8=CF8,CS8=CG8,CS8=CH8,CS8=CI8,CS8=CJ8,CS8=CK8,CS8=CL8,CS8=CM8,CS8=CN8),1,0)","v":0},null,{"$f":"IF(E8=\"\",MAX(BW8,CQ8,CT8),MAX(BX8,CT8))","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"},"00:05:30","00:05:30",null,null,null,null,null,null,null,null,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,{"$f":"IF(AL9=0,\"\",AL9)","v":""},{"$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":"CONCATENATE(AT9,AU9,AV9,AW9,AX9,AY9,AZ9,BA9)","v":""},{"$f":"LEFT(BB9)","v":""},{"$f":"RIGHT(BB9)","v":""},{"$f":"LEFT(BB9,2)","v":""},{"$f":"RIGHT(BB9,2)","v":""},{"$f":"LEFT(BE9)","v":""},{"$f":"RIGHT(BE9)","v":""},{"$f":"LEFT(BF9)","v":""},{"$f":"RIGHT(BF9)","v":""},{"$f":"IF(BG9=\"\",0,BG9)","v":0},{"$f":"IF(BH9=BG9,0,BH9)","v":0},{"$f":"IF(BI9=\"\",0,IF(OR(BI9=BG9,BI9=BH9),0,BI9))","v":0},{"$f":"IF(BJ9=\"\",0,(IF(OR(BJ9=BG9,BJ9=BH9,BJ9=BI9),0,BJ9)))","v":0},{"$f":"IF(K9-D9=0,IF(K9=0,0,3),0)","v":0},3,3,3,2,2,2,2,{"$f":"IF(SUM(BO9:BR9)=3,3,IF(SUM(BS9:BV9)=2,2,0))","v":0},{"$f":"MAX(BS9:BV9)","v":2},0,0,0,0,0,0,{"$f":"IF(AI9<-1,$CE$5,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AK9<-1,$CO$5,0)","v":0},"",{"$f":"IF(OR(CP9=BY9,CP9=BZ9,CP9=CA9,CP9=CB9,CP9=CC9,CP9=CD9,CP9=CE9,CP9=CF9,CP9=CG9,CP9=CH9,CP9=CI9,CP9=CJ9,CP9=CK9,CP9=CL9,CP9=CM9,CP9=CN9,CP9=CO9),1.5,0)","v":0},null,"",{"$f":"IF(OR(CS9=BY9,CS9=BZ9,CS9=CA9,CS9=CB9,CS9=CC9,CS9=CD9,CS9=CE9,CS9=CF9,CS9=CG9,CS9=CH9,CS9=CI9,CS9=CJ9,CS9=CK9,CS9=CL9,CS9=CM9,CS9=CN9),1,0)","v":0},null,0]
["élève",3,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,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"",{"$f":"IF(AM10=0,\"\",AM10)","v":""},"","","","","","","","","",{"$f":"LEFT(BB10,2)","v":""},"","","","","",0,0,0,0,{"$f":"IF(K10-D10=0,IF(K10=0,0,3),0)","v":0},3,3,3,2,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,{"$f":"IF(K11-D11=0,IF(K11=0,0,3),0)","v":0},3,3,3,2,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR(BI12=BG12,BI12=BH12),0,BI12)","v":0},0,{"$f":"IF(K12-D12=0,IF(K12=0,0,3),0)","v":0},3,3,3,2,2,2,2,0,2,{"$f":"IF(AI12>1,$BY$5,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,{"$f":"IF(K13-D13=0,3,0)","v":3},3,3,3,2,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(BI14=BG14,0,IF(BI14=BH14,0,BI14))","v":0},0,3,3,3,3,2,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,{"$f":"IF(AI15<-1,$CF$5,0)","v":0},0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,null,"",0,null,0]
["élève",15,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,"00:00:00","00:00:00","00:00:00","","",0,0,"",{"$f":"IF(AND(AG22<=3,AH22<=3),1,0)","v":0},0,0,0,0,0,0,0,"","","",{"$f":"IF(AO22=0,\"\",AO22)","v":""},"","","","","","","","","","","","","",0,0,0,0,3,3,3,3,2,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,null,"",0,null,0]
["élève",18,null,null,null,null,null,null,"","",0,0,0,0,"",null,"",null,{"$f":"$S$7-F25","v":"00:05:30"},"00:05:30","00:05:30",null,null,null,null,null,null,null,null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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",{"$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,{"$f":"CONCATENATE(A43,\" \",B43)","v":"élève 36"},null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,null,"",0,null,0]
["élève",34,null,null,null,null,null,null,{"$f":"IF(COUNT(F41,G41,H41)=3,SUM(F41,G41,H41),\"\")","v":""},"",{"$f":"BK41","v":0},{"$f":"BL41","v":0},{"$f":"BM41","v":0},{"$f":"BN41","v":0},{"$f":"IF(AND(COUNTA(F41:H41)=3,ISTEXT(C41)),CV41,\"\")","v":""},null,{"$f":"IF(ISNUMBER(O41),SUM(J41:P41),\"\")","v":""},null,"00:05:30","00:05:30","00:05:30",null,null,null,null,null,null,null,null,"00:00:00","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,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",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,{"$f":"IF(F42<=G42,G42-F42,F42-G42)","v":"00:00:00"},{"$f":"IF(G42<=H42,H42-G42,G42-H42)","v":"00:00:00"},{"$f":"IF(F42<=H42,H42-F42,F42-H42)","v":"00:00:00"},{"$f":"IF(ISNUMBER(I42),SECOND(AD42),\"\")","v":""},{"$f":"IF(ISNUMBER(I42),SECOND(AE42),\"\")","v":""},{"$f":"IF(G42<F42,SECOND(AD42),-SECOND(AD42))","v":0},{"$f":"IF(H42<G42,SECOND(AE42),-SECOND(AE42))","v":0},{"$f":"IF(ISNUMBER(I42),SECOND(AF42),\"\")","v":""},0,{"$f":"IF(AND((G42<F42),(H42<G42)),2,0)","v":0},{"$f":"IF(AND((AG42<=3),(H42<G42),(AH42>=1)),3,0)","v":0},{"$f":"IF(AND((AG42<=3),(G42<H42),(AH42>=1)),4,0)","v":0},{"$f":"IF(AND((AG42>=1),(AH42<=3),(F42<G42)),5,0)","v":0},{"$f":"IF(AND((AG42>=1),(AH42<=3),(F42>G42)),6,0)","v":0},{"$f":"IF(AND((AG42>=1),(AH42>=1),(F42<G42),(G42>H42)),7,0)","v":0},{"$f":"IF(AND((AG42>=1),(AH42>=1),(F42>G42),(G42<H42)),8,0)","v":0},"","","","","","","","","","","","","",{"$f":"LEFT(BE42)","v":""},{"$f":"RIGHT(BE42)","v":""},null,null,0,0,0,0,{"$f":"IF(K42-D42=0,3,0)","v":3},{"$f":"IF(L42-D42=0,3,0)","v":3},{"$f":"IF(M42-D42=0,3,0)","v":3},{"$f":"IF(N42-D42=0,3,0)","v":3},{"$f":"IF(K42-E42=0,2,0)","v":2},{"$f":"IF(L42-E42=0,2,0)","v":2},{"$f":"IF(M42-E42=0,2,0)","v":2},{"$f":"IF(N42-E42=0,2,0)","v":2},0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(D42=\"\",\"\",D42)","v":""},0,null,{"$f":"IF(E42=\"\",\"\",E42)","v":""},0,null,{"$f":"IF(E42=\"\",MAX(BW42,CQ42,CT42),MAX(BX42,CT42))","v":0}]
["élève",36,null,null,null,null,null,null,"","",0,0,0,0,"",null,"",null,{"$f":"$S$7-F43","v":"00:05:30"},"00:05:30","00:05:30",null,null,null,null,null,null,null,null,{"$f":"IF(F43<=G43,G43-F43,F43-G43)","v":"00:00:00"},{"$f":"IF(G43<=H43,H43-G43,G43-H43)","v":"00:00:00"},{"$f":"IF(F43<=H43,H43-F43,F43-H43)","v":"00:00:00"},{"$f":"IF(ISNUMBER(I43),SECOND(AD43),\"\")","v":""},{"$f":"IF(ISNUMBER(I43),SECOND(AE43),\"\")","v":""},{"$f":"IF(G43<F43,SECOND(AD43),-SECOND(AD43))","v":0},{"$f":"IF(H43<G43,SECOND(AE43),-SECOND(AE43))","v":0},{"$f":"IF(ISNUMBER(I43),SECOND(AF43),\"\")","v":""},{"$f":"IF(AND(AG43<=3,AH43<=3),1,0)","v":0},{"$f":"IF(AND((G43<F43),(H43<G43)),2,0)","v":0},{"$f":"IF(AND((AG43<=3),(H43<G43),(AH43>=1)),3,0)","v":0},{"$f":"IF(AND((AG43<=3),(G43<H43),(AH43>=1)),4,0)","v":0},{"$f":"IF(AND((AG43>=1),(AH43<=3),(F43<G43)),5,0)","v":0},{"$f":"IF(AND((AG43>=1),(AH43<=3),(F43>G43)),6,0)","v":0},{"$f":"IF(AND((AG43>=1),(AH43>=1),(F43<G43),(G43>H43)),7,0)","v":0},{"$f":"IF(AND((AG43>=1),(AH43>=1),(F43>G43),(G43<H43)),8,0)","v":0},{"$f":"IF(AL43=0,\"\",AL43)","v":""},{"$f":"IF(AM43=0,\"\",AM43)","v":""},{"$f":"IF(AN43=0,\"\",AN43)","v":""},{"$f":"IF(AO43=0,\"\",AO43)","v":""},{"$f":"IF(AP43=0,\"\",AP43)","v":""},{"$f":"IF(AQ43=0,\"\",AQ43)","v":""},{"$f":"IF(AR43=0,\"\",AR43)","v":""},{"$f":"IF(AS43=0,\"\",AS43)","v":""},{"$f":"CONCATENATE(AT43,AU43,AV43,AW43,AX43,AY43,AZ43,BA43)","v":""},{"$f":"LEFT(BB43)","v":""},{"$f":"RIGHT(BB43)","v":""},{"$f":"LEFT(BB43,2)","v":""},{"$f":"RIGHT(BB43,2)","v":""},{"$f":"LEFT(BE43)","v":""},{"$f":"RIGHT(BE43)","v":""},null,null,{"$f":"IF(BG43=\"\",0,BG43)","v":0},{"$f":"IF(BH43=BG43,0,BH43)","v":0},{"$f":"IF(BI43=BG43,0,IF(BI43=BH43,0,BI43))","v":0},{"$f":"IF(BJ43=\"\",0,(IF(OR(BJ43=BG43,BJ43=BH43,BJ43=BI43),0,BJ43)))","v":0},{"$f":"IF(K43-D43=0,3,0)","v":3},{"$f":"IF(L43-D43=0,3,0)","v":3},{"$f":"IF(M43-D43=0,3,0)","v":3},{"$f":"IF(N43-D43=0,3,0)","v":3},{"$f":"IF(K43-E43=0,2,0)","v":2},{"$f":"IF(L43-E43=0,2,0)","v":2},{"$f":"IF(M43-E43=0,2,0)","v":2},{"$f":"IF(N43-E43=0,2,0)","v":2},{"$f":"IF(SUM(BO43:BR43)=3,3,IF(SUM(BS43:BV43)=2,2,0))","v":0},{"$f":"MAX(BS43:BV43)","v":2},{"$f":"IF(AI43>1,$BY$5,0)","v":0},{"$f":"IF(AI43>1,$BZ$5,0)","v":0},{"$f":"IF(AI43>1,$CA$5,0)","v":0},{"$f":"IF(AG43<=3,$CB$5,0)","v":0},{"$f":"IF(AG43<=3,$CC$5,0)","v":0},{"$f":"IF(AG43<=3,$CD$5,0)","v":0},{"$f":"IF(AI43<-1,$CE$5,0)","v":0},{"$f":"IF(AI43<-1,$CF$5,0)","v":0},{"$f":"IF(AH43<=3,$CG$5,0)","v":0},{"$f":"IF(AH43<=3,$CH$5,0)","v":0},{"$f":"IF(AH43<=3,$CI$5,0)","v":0},{"$f":"IF(AJ43>1,$CJ$5,0)","v":0},{"$f":"IF(AJ43>1,$CK$5,0)","v":0},{"$f":"IF(AJ43>1,$CL$5,0)","v":0},{"$f":"IF(AJ43<-1,$CM$5,0)","v":0},{"$f":"IF(AJ43<-1,$CN$5,0)","v":0},{"$f":"IF(AK43<-1,$CO$5,0)","v":0},{"$f":"IF(D43=\"\",\"\",D43)","v":""},{"$f":"IF(OR(CP43=BY43,CP43=BZ43,CP43=CA43,CP43=CB43,CP43=CC43,CP43=CD43,CP43=CE43,CP43=CF43,CP43=CG43,CP43=CH43,CP43=CI43,CP43=CJ43,CP43=CK43,CP43=CL43,CP43=CM43,CP43=CN43,CP43=CO43),1.5,0)","v":0},null,{"$f":"IF(E43=\"\",\"\",E43)","v":""},{"$f":"IF(OR(CS43=BY43,CS43=BZ43,CS43=CA43,CS43=CB43,CS43=CC43,CS43=CD43,CS43=CE43,CS43=CF43,CS43=CG43,CS43=CH43,CS43=CI43,CS43=CJ43,CS43=CK43,CS43=CL43,CS43=CM43,CS43=CN43),1,0)","v":0},null,{"$f":"IF(E43=\"\",MAX(BW43,CQ43,CT43),MAX(BX43,CT43))","v":0}]
[{"$f":"IF(COUNTA(A8:A43)=0,\"\",IF(COUNTA(A8:A43)>1,COUNTA(A8:A43)&\"  élèves\",COUNTA(A8:A43)&\"  élève\"))","v":"36  é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(A44=\"\",\"\",IF(COUNTIF(C8:C43,\"f\")>1,\"dont    \"& COUNTIF(C8:C43,\"f\")&\"   filles\",COUNTIF(C8:C43,\"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,"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"]