{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Demi-fond"],"not_rendered":{"charts":39,"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":85,"n_cols":103,"rows_kept":85,"cut":false,"hidden":false,"merged":[[6,69,6,72],[6,73,6,76],[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],[2,0,2,1],[3,32,3,35],[1,0,1,8],[3,0,3,1],[2,4,2,8],[3,4,3,8],[3,10,3,15],[1,36,1,38],[3,36,3,38],[4,0,4,16],[5,3,5,4],[5,16,6,16],[2,10,2,15]]}
["Lycée :",null,null,null,null,null,null,"CAP BEP CCF 2018",null,null,null,null,null,null,null,null,"EPS",null,null,null,null,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,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,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,1,3,7,2,5,8,4,6,2,4,7,3,6,8,1,5,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,"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,"C1/C3",null,null,null,null,"C1/C3",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,"C1/C3","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":"BN8","v":0},0,0,0,{"$f":"IF(AND(COUNTA(F8:H8)=3,ISTEXT(C8)),CY8,\"\")","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(F8<=H8,H8-F8,F8-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(ISNUMBER(S8),SECOND(AI8),\"\")","v":0},{"$f":"IF(AND((AJ8>=1),(AK8>=1),(F8>G8),(G8<H8)),1,0)","v":0},{"$f":"IF(AND(AJ8<=3,AK8<=3),2,0)","v":0},{"$f":"IF(AND((G8<F8),(H8<G8)),3,0)","v":0},{"$f":"IF(AND((AJ8>=1),(AK8<=3),(F8<G8)),4,0)","v":0},{"$f":"IF(AND((AJ8<=3),(G8<H8),(AK8>=1)),5,0)","v":0},{"$f":"IF(AND((AJ8>=1),(AK8>=1),(F8<G8),(G8>H8)),6,0)","v":0},{"$f":"IF(AND((AJ8>=1),(AK8<=3),(F8>G8)),7,0)","v":0},{"$f":"IF(AND((AJ8<=3),(H8<G8),(AK8>=1)),8,0)","v":0},{"$f":"IF(AO8=0,\"\",AO8)","v":""},"","","","","","","",{"$f":"CONCATENATE(AW8,AX8,AY8,AZ8,BA8,BB8,BC8,BD8)","v":""},{"$f":"LEFT(BE8)","v":""},{"$f":"RIGHT(BE8)","v":""},{"$f":"LEFT(BE8,2)","v":""},{"$f":"RIGHT(BE8,2)","v":""},{"$f":"LEFT(BH8)","v":""},{"$f":"RIGHT(BH8)","v":""},{"$f":"LEFT(BI8)","v":""},{"$f":"RIGHT(BI8)","v":""},{"$f":"IF(BJ8=\"\",0,BJ8)","v":0},{"$f":"IF(BK8=BJ8,0,BK8)","v":0},{"$f":"IF(BL8=\"\",0,IF(OR(BL8=BJ8,BL8=BK8),0,BL8))","v":0},{"$f":"IF(BM8=\"\",0,(IF(OR(BM8=BJ8,BM8=BK8,BM8=BL8),0,BM8)))","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(BR8:BU8)=3,3,IF(SUM(BV8:BY8)=2.5,2.5,0))","v":0},{"$f":"MAX(BV8:BY8)","v":2},{"$f":"IF(AL8>1,$CB$5,0)","v":0},{"$f":"IF(AL8>1,$CC$5,0)","v":0},{"$f":"IF(AL8>1,$CD$5,0)","v":0},{"$f":"IF(AJ8<=3,$CE$5,0)","v":0},{"$f":"IF(AJ8<=3,$CF$5,0)","v":0},{"$f":"IF(AJ8<=3,$CG$5,0)","v":0},{"$f":"IF(AL8<-1,$CH$5,0)","v":0},{"$f":"IF(AL8<-1,$CI$5,0)","v":0},{"$f":"IF(AK8<=3,$CJ$5,0)","v":0},{"$f":"IF(AK8<=3,$CK$5,0)","v":0},{"$f":"IF(AK8<=3,$CL$5,0)","v":0},{"$f":"IF(AM8>1,$CM$5,0)","v":0},{"$f":"IF(AM8>1,$CN$5,0)","v":0},{"$f":"IF(AM8>1,$CO$5,0)","v":0},{"$f":"IF(AM8<-1,$CP$5,0)","v":0},{"$f":"IF(AM8<-1,$CQ$5,0)","v":0},{"$f":"IF(AN8<1,$CR$5,0)","v":1},{"$f":"IF(D8=\"\",\"\",D8)","v":""},{"$f":"IF(OR(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,CS8=CO8,CS8=CP8,CS8=CQ8,CR8=CS8),1.5,0)","v":0},null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"IF(OR(CV8=CB8,CV8=CC8,CV8=CD8,CV8=CE8,CV8=CF8,CV8=CG8,CV8=CH8,CV8=CI8,CV8=CJ8,CV8=CK8,CV8=CL8,CV8=CM8,CV8=CN8,CV8=CO8,CV8=CP8,CV8=CQ8,CV8=CR8),1,0)","v":0},null,{"$f":"IF(E8=\"\",MAX(BZ8,CT8,CW8),MAX(CA8,CW8))","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"},"00:00:00",{"$f":"IF(ISNUMBER(I9),SECOND(AG9),\"\")","v":""},{"$f":"IF(ISNUMBER(I9),SECOND(AH9),\"\")","v":""},0,0,{"$f":"IF(ISNUMBER(S9),SECOND(AI9),\"\")","v":0},0,0,0,0,0,0,0,0,"","","","","","","","","",{"$f":"LEFT(BE9)","v":""},{"$f":"RIGHT(BE9)","v":""},{"$f":"LEFT(BE9,2)","v":""},{"$f":"RIGHT(BE9,2)","v":""},{"$f":"LEFT(BH9)","v":""},{"$f":"RIGHT(BH9)","v":""},{"$f":"LEFT(BI9)","v":""},{"$f":"RIGHT(BI9)","v":""},{"$f":"IF(BJ9=\"\",0,BJ9)","v":0},{"$f":"IF(BK9=BJ9,0,BK9)","v":0},{"$f":"IF(BL9=\"\",0,IF(OR(BL9=BJ9,BL9=BK9),0,BL9))","v":0},{"$f":"IF(BM9=\"\",0,(IF(OR(BM9=BJ9,BM9=BK9,BM9=BL9),0,BM9)))","v":0},{"$f":"IF(K9-D9=0,IF(K9=0,0,3),0)","v":0},3,3,3,{"$f":"IF(K9-E9=0,2,0)","v":2},{"$f":"IF(L9-E9=0,2,0)","v":2},{"$f":"IF(M9-E9=0,2,0)","v":2},{"$f":"IF(N9-E9=0,2,0)","v":2},{"$f":"IF(SUM(BR9:BU9)=3,3,IF(SUM(BV9:BY9)=2.5,2.5,0))","v":0},{"$f":"MAX(BV9:BY9)","v":2},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AN9<1,$CR$5,0)","v":1},"",{"$f":"IF(OR(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,CS9=CO9,CS9=CP9,CS9=CQ9,CR9=CS9),1.5,0)","v":0},null,"",{"$f":"IF(OR(CV9=CB9,CV9=CC9,CV9=CD9,CV9=CE9,CV9=CF9,CV9=CG9,CV9=CH9,CV9=CI9,CV9=CJ9,CV9=CK9,CV9=CL9,CV9=CM9,CV9=CN9,CV9=CO9,CV9=CP9,CV9=CQ9,CV9=CR9),1,0)","v":0},null,0]
["élève",3,null,null,null,null,null,null,"","",{"$f":"BN10","v":0},{"$f":"BO10","v":0},{"$f":"BP10","v":0},{"$f":"BQ10","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","00:00:00",{"$f":"IF(ISNUMBER(I10),SECOND(AG10),\"\")","v":""},{"$f":"IF(ISNUMBER(I10),SECOND(AH10),\"\")","v":""},0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","",{"$f":"LEFT(BE10,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,1,"",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","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,{"$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,1,"",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","00:00:00","","",0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR(BL12=BJ12,BL12=BK12),0,BL12)","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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",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",{"$f":"IF(F13<=H13,H13-F13,F13-H13)","v":"00:00:00"},"","",0,0,0,{"$f":"IF(AND((AJ13>=1),(AK13>=1),(F13>G13),(G13<H13)),1,0)","v":0},{"$f":"IF(AND(AJ13<=3,AK13<=3),2,0)","v":0},{"$f":"IF(AND((G13<F13),(H13<G13)),3,0)","v":0},{"$f":"IF(AND((AJ13>=1),(AK13<=3),(F13<G13)),4,0)","v":0},{"$f":"IF(AND((AJ13<=3),(G13<H13),(AK13>=1)),5,0)","v":0},{"$f":"IF(AND((AJ13>=1),(AK13>=1),(F13<G13),(G13>H13)),6,0)","v":0},{"$f":"IF(AND((AJ13>=1),(AK13<=3),(F13>G13)),7,0)","v":0},{"$f":"IF(AND((AJ13<=3),(H13<G13),(AK13>=1)),8,0)","v":0},{"$f":"IF(AP13=0,\"\",AP13)","v":""},{"$f":"IF(AQ13=0,\"\",AQ13)","v":""},{"$f":"IF(AV13=0,\"\",AV13)","v":""},{"$f":"IF(AS13=0,\"\",AS13)","v":""},{"$f":"IF(AR13=0,\"\",AR13)","v":""},{"$f":"IF(AU13=0,\"\",AU13)","v":""},{"$f":"IF(AT13=0,\"\",AT13)","v":""},{"$f":"IF(AO13=0,\"\",AO13)","v":""},"","","","","","","","","",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,1,"",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","00:00:00","","",0,0,0,{"$f":"IF(AND((AJ14>=1),(AK14>=1),(F14>G14),(G14<H14)),1,0)","v":0},{"$f":"IF(AND(AJ14<=3,AK14<=3),2,0)","v":0},{"$f":"IF(AND((G14<F14),(H14<G14)),3,0)","v":0},{"$f":"IF(AND((AJ14>=1),(AK14<=3),(F14<G14)),4,0)","v":0},{"$f":"IF(AND((AJ14<=3),(G14<H14),(AK14>=1)),5,0)","v":0},{"$f":"IF(AND((AJ14>=1),(AK14>=1),(F14<G14),(G14>H14)),6,0)","v":0},{"$f":"IF(AND((AJ14>=1),(AK14<=3),(F14>G14)),7,0)","v":0},{"$f":"IF(AND((AJ14<=3),(H14<G14),(AK14>=1)),8,0)","v":0},{"$f":"IF(AO14=0,\"\",AO14)","v":""},{"$f":"IF(AP14=0,\"\",AP14)","v":""},{"$f":"IF(AQ14=0,\"\",AQ14)","v":""},{"$f":"IF(AR14=0,\"\",AR14)","v":""},{"$f":"IF(AS14=0,\"\",AS14)","v":""},{"$f":"IF(AT14=0,\"\",AT14)","v":""},{"$f":"IF(AU14=0,\"\",AU14)","v":""},{"$f":"IF(AV14=0,\"\",AV14)","v":""},"","","","","","","","","",0,0,{"$f":"IF(BL14=BJ14,0,IF(BL14=BK14,0,BL14))","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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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","00:00:00","","",0,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,1,"",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,{"$f":"CONCATENATE(A43,\" \",B43)","v":"élève 36"},"00:00:00","00:00:00","00:00:00","","",0,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,1,"",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":"IF(AND(ISTEXT(C41),ISNUMBER(I41)),\nIF(C41=\"F\",INDEX(noteperf,MATCH(I41,perffilles,-1)),INDEX(noteperf,MATCH(I41,perfgars,-1))),\"\")","v":""},{"$f":"BN41","v":0},{"$f":"BO41","v":0},{"$f":"BP41","v":0},{"$f":"BQ41","v":0},{"$f":"IF(AND(COUNTA(F41:H41)=3,ISTEXT(C41)),CY41,\"\")","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,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,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,1,"",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","00:00:00","","",0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","",{"$f":"LEFT(BH42)","v":""},{"$f":"RIGHT(BH42)","v":""},null,null,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,1,"",0,null,"",0,null,0]
["élève",36,null,null,null,null,null,null,"","",0,0,0,0,"",null,"",null,{"$f":"$S$7-F43","v":"00:05:30"},{"$f":"$S$7-G43","v":"00:05:30"},{"$f":"$S$7-H43","v":"00:05:30"}]
[{"$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":""},null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(A46,\" \",B46)","v":" "},null,null,null,{"$f":"CONCATENATE(A47,\" \",B47)","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:20.010",0.5,"00:09:20.010"]
[null,null,null,null,null,"00:12:00.010",1,"00:09:00.010"]
[null,null,null,null,null,"00:11:40.010",1.5,"00:08:40.010"]
[null,null,null,null,null,"00:11:20.010",2,"00:08:20.010"]
[null,null,null,null,null,"00:11:00.010",2.5,"00:08:00.010"]
[null,null,null,null,null,"00:10:40.010",3,"00:07:40.010"]
[null,null,null,null,null,"00:10:20.010",3.5,"00:07:20.010"]
[null,null,null,null,null,"00:10:02.010",4,"00:07:10.010"]
[null,null,null,null,null,"00:09:44.010",4.5,"00:07:00.010"]
[null,null,null,null,null,"00:09:26.010",5,"00:06:50.010"]
[null,null,null,null,null,"00:09:08.010",5.5,"00:06:40.010"]
[null,null,null,null,null,"00:08:50.010",6,"00:06:30.010"]
[null,null,null,null,null,"00:08:32.010",6.5,"00:06:20.010"]
[null,null,null,null,null,"00:08:15.010",7,"00:06:10.010"]
[null,null,null,null,null,"00:08:02.010",7.5,"00:06:03.010"]
[null,null,null,null,null,"00:07:50.010",8,"00:05:55.010"]
[null,null,null,null,null,"00:07:37.010",8.5,"00:05:48.010"]
[null,null,null,null,null,"00:07:25",9,"00:05:40.010"]
[null,null,null,null,null,"00:07:12.010",9.5,"00:05:33.010"]
[null,null,null,null,null,"00:07:00.010",10,"00:05:25.010"]
[null,null,null,null,null,"00:06:47.010",10.5,"00:05:17.010"]
[null,null,null,null,null,"00:06:42.010",11,"00:05:13.010"]
[null,null,null,null,null,"00:06:37.010",11.5,"00:05:09.010"]
[null,null,null,null,null,"00:06:31.010",12,"00:05:05.010"]
[null,null,null,null,null,"00:06:26.010",12.5,"00:05:01.010"]
[null,null,null,null,null,"00:06:21.010",13,"00:04:56.010"]
[null,null,null,null,null,"00:06:16.010",13.5,"00:04:52.010"]
[null,null,null,null,null,"00:06:11.010",14,"00:04:48.010"]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(J8:J42)),\"\",MIN(J8:J42))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(AVERAGE(J8:J42)),\"\",AVERAGE(J8:J42))","v":""}]