{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Demi-fond"],"not_rendered":{"charts":0,"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":92,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,58,6,61],[6,62,6,65],[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,5,6,5],[0,1,0,6],[0,8,0,11],[5,11,5,15],[43,11,45,14],[1,23,1,25],[2,0,2,1],[3,23,3,25],[1,0,1,9],[3,0,3,1],[2,4,2,9],[3,4,3,9],[2,15,2,18],[3,15,3,18],[4,0,4,19],[5,3,5,4],[5,19,6,19]]}
["Lycée :",null,null,null,null,null,null,null,"BAC GT CCF 2018",null,null,null,null,null,null,null,null,null,null,"EPS"]
[]
["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,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,"base","régulation",null,null,null,null,null,"/ 14","réalisé",null,null,null,"note",null,"/ 1","/ 2",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":"BC8","v":0},0,0,0,{"$f":"IF(AND(COUNTA(G8:I8)=3,ISTEXT(C8)),CN8,\"\")","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,"STRATÉGIE",null,{"$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(X8),\"\")","v":""},{"$f":"IF(ISNUMBER(J8),SECOND(Y8),\"\")","v":""},{"$f":"IF(H8<G8,SECOND(X8),-SECOND(X8))","v":0},{"$f":"IF(I8<H8,SECOND(Y8),-SECOND(Y8))","v":0},{"$f":"IF(AND(Z8<=3,AA8<=3),1,0)","v":0},{"$f":"IF(AND((H8<G8),(I8<H8)),2,0)","v":0},{"$f":"IF(AND((Z8<=3),(I8<H8),(AA8>=1)),3,0)","v":0},{"$f":"IF(AND((Z8<=3),(H8<I8),(AA8>=1)),4,0)","v":0},{"$f":"IF(AND((Z8>=1),(AA8<=3),(G8<H8)),5,0)","v":0},{"$f":"IF(AND((Z8>=1),(AA8<=3),(G8>H8)),6,0)","v":0},{"$f":"IF(AND((Z8>=1),(AA8>=1),(G8<H8),(H8>I8)),7,0)","v":0},{"$f":"IF(AND((Z8>=1),(AA8>=1),(G8>H8),(H8<I8)),8,0)","v":0},{"$f":"IF(AD8=0,\"\",AD8)","v":""},{"$f":"IF(AE8=0,\"\",AE8)","v":""},"","","","","","",{"$f":"CONCATENATE(AL8,AM8,AN8,AO8,AP8,AQ8,AR8,AS8)","v":""},{"$f":"LEFT(AT8)","v":""},{"$f":"RIGHT(AT8)","v":""},{"$f":"LEFT(AT8,2)","v":""},{"$f":"RIGHT(AT8,2)","v":""},{"$f":"LEFT(AW8)","v":""},{"$f":"RIGHT(AW8)","v":""},{"$f":"LEFT(AX8)","v":""},{"$f":"RIGHT(AX8)","v":""},{"$f":"IF(AY8=\"\",0,AY8)","v":0},{"$f":"IF(AZ8=AY8,0,AZ8)","v":0},{"$f":"IF(BA8=\"\",0,IF(OR(BA8=AY8,BA8=AZ8),0,BA8))","v":0},{"$f":"IF(BB8=\"\",0,(IF(OR(BB8=AY8,BB8=AZ8,BB8=BA8),0,BB8)))","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(BG8:BJ8)=3,3,IF(SUM(BK8:BN8)=2.5,2.5,0))","v":0},{"$f":"MAX(BK8:BN8)","v":2.5},{"$f":"IF(AB8>1,$BQ$5,0)","v":0},{"$f":"IF(AB8>1,$BR$5,0)","v":0},{"$f":"IF(AB8>1,$BS$5,0)","v":0},{"$f":"IF(Z8<=3,$BT$5,0)","v":0},{"$f":"IF(Z8<=3,$BU$5,0)","v":0},{"$f":"IF(Z8<=3,$BV$5,0)","v":0},{"$f":"IF(AB8<-1,$BW$5,0)","v":0},{"$f":"IF(AB8<-1,$BX$5,0)","v":0},{"$f":"IF(AA8<=3,$BY$5,0)","v":0},{"$f":"IF(AA8<=3,$BZ$5,0)","v":0},{"$f":"IF(AA8<=3,$CA$5,0)","v":0},{"$f":"IF(AC8>1,$CB$5,0)","v":0},{"$f":"IF(AC8>1,$CC$5,0)","v":0},{"$f":"IF(AC8>1,$CD$5,0)","v":0},{"$f":"IF(AC8<-1,$CE$5,0)","v":0},{"$f":"IF(AC8<-1,$CF$5,0)","v":0},null,{"$f":"IF(D8=\"\",\"\",D8)","v":""},{"$f":"IF(OR(CH8=BQ8,CH8=BR8,CH8=BS8,CH8=BT8,CH8=BU8,CH8=BV8,CH8=BW8,CH8=BX8,CH8=BY8,CH8=BZ8,CH8=CA8,CH8=CB8,CH8=CC8,CH8=CD8,CH8=CE8,CH8=CF8),2,0)","v":0},null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"IF(OR(CK8=BQ8,CK8=BR8,CK8=BS8,CK8=BT8,CK8=BU8,CK8=BV8,CK8=BW8,CK8=BX8,CK8=BY8,CK8=BZ8,CK8=CA8,CK8=CB8,CK8=CC8,CK8=CD8,CK8=CE8,CK8=CF8),1,0)","v":0},null,{"$f":"IF(E8=\"\",MAX(BO8,CI8,CL8),MAX(BP8,CL8))","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,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD9=0,\"\",AD9)","v":""},{"$f":"IF(AE9=0,\"\",AE9)","v":""},{"$f":"IF(AF9=0,\"\",AF9)","v":""},{"$f":"IF(AG9=0,\"\",AG9)","v":""},{"$f":"IF(AH9=0,\"\",AH9)","v":""},{"$f":"IF(AI9=0,\"\",AI9)","v":""},{"$f":"IF(AJ9=0,\"\",AJ9)","v":""},{"$f":"IF(AK9=0,\"\",AK9)","v":""},{"$f":"CONCATENATE(AL9,AM9,AN9,AO9,AP9,AQ9,AR9,AS9)","v":""},{"$f":"LEFT(AT9)","v":""},{"$f":"RIGHT(AT9)","v":""},{"$f":"LEFT(AT9,2)","v":""},{"$f":"RIGHT(AT9,2)","v":""},{"$f":"LEFT(AW9)","v":""},{"$f":"RIGHT(AW9)","v":""},{"$f":"LEFT(AX9)","v":""},{"$f":"RIGHT(AX9)","v":""},{"$f":"IF(AY9=\"\",0,AY9)","v":0},{"$f":"IF(AZ9=AY9,0,AZ9)","v":0},{"$f":"IF(BA9=\"\",0,IF(OR(BA9=AY9,BA9=AZ9),0,BA9))","v":0},{"$f":"IF(BB9=\"\",0,(IF(OR(BB9=AY9,BB9=AZ9,BB9=BA9),0,BB9)))","v":0},{"$f":"IF(L9-D9=0,IF(L9=0,0,3),0)","v":0},3,3,3,2.5,2.5,2.5,2.5,{"$f":"IF(SUM(BG9:BJ9)=3,3,IF(SUM(BK9:BN9)=2.5,2.5,0))","v":0},{"$f":"MAX(BK9:BN9)","v":2.5},0,0,0,0,0,0,0,{"$f":"IF(AB9<-1,$BX$5,0)","v":0},0,0,0,0,0,0,0,0,null,"",{"$f":"IF(OR(CH9=BQ9,CH9=BR9,CH9=BS9,CH9=BT9,CH9=BU9,CH9=BV9,CH9=BW9,CH9=BX9,CH9=BY9,CH9=BZ9,CH9=CA9,CH9=CB9,CH9=CC9,CH9=CD9,CH9=CE9,CH9=CF9),2,0)","v":0},null,"",{"$f":"IF(OR(CK9=BQ9,CK9=BR9,CK9=BS9,CK9=BT9,CK9=BU9,CK9=BV9,CK9=BW9,CK9=BX9,CK9=BY9,CK9=BZ9,CK9=CA9,CK9=CB9,CK9=CC9,CK9=CD9,CK9=CE9,CK9=CF9),1,0)","v":0},null,0]
["élève",3,null,null,null,null,null,null,null,"","",{"$f":"BC10","v":0},{"$f":"BD10","v":0},{"$f":"BE10","v":0},{"$f":"BF10","v":0},"","","",null,"",null,1,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"",{"$f":"IF(AE10=0,\"\",AE10)","v":""},"","","","","","","","","",{"$f":"LEFT(AT10,2)","v":""},"","","","","",0,0,0,0,{"$f":"IF(L10-D10=0,IF(L10=0,0,3),0)","v":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,"",{"$f":"IF(OR(CH10=BQ10,CH10=BR10,CH10=BS10,CH10=BT10,CH10=BU10,CH10=BV10,CH10=BW10,CH10=BX10,CH10=BY10,CH10=BZ10,CH10=CA10,CH10=CB10,CH10=CC10,CH10=CD10,CH10=CE10,CH10=CF10),2,0)","v":0},null,"",0,null,0]
["élève",4,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,{"$f":"IF(L11-D11=0,IF(L11=0,0,3),0)","v":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,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR(BA12=AY12,BA12=AZ12),0,BA12)","v":0},0,{"$f":"IF(L12-D12=0,IF(L12=0,0,3),0)","v":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,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,0,0,{"$f":"IF(L13-D13=0,3,0)","v":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,2,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(BA14=AY14,0,IF(BA14=AZ14,0,BA14))","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,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,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",10,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",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,3,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,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,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",14,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",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,4,null,"00:00:00","00:00:00","","",0,0,{"$f":"IF(AND(Z22<=3,AA22<=3),1,0)","v":0},0,0,0,0,0,0,0,"","","",{"$f":"IF(AG22=0,\"\",AG22)","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,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,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",18,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",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,5,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,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,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",22,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",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,6,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,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,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",26,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",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,7,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,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,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",30,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",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,8,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,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,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,{"$f":"IF(COUNT(G41,H41,I41)=3,SUM(G41,H41,I41),\"\")","v":""},{"$f":"IF(AND(ISTEXT(C41),ISNUMBER(J41)),\nIF(C41=\"F\",INDEX(noteperf,MATCH(J41,perffilles,-1)),INDEX(noteperf,MATCH(J41,perfgars,-1))),\"\")","v":""},{"$f":"BC41","v":0},{"$f":"BD41","v":0},{"$f":"BE41","v":0},{"$f":"BF41","v":0},"",{"$f":"IF(F41=\"\",\"\",IF(G41-F41>=0,G41-F41,F41-G41))","v":""},{"$f":"IF(F41=\"\",\"\",VLOOKUP(Q41,$Q$53:$R$54,2))","v":""},null,{"$f":"IF(ISNUMBER(P41),SUM(K41:S41),\"\")","v":""},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,null,null,"00:00:00","00:00:00","","",0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","","","",{"$f":"LEFT(AW42)","v":""},{"$f":"RIGHT(AW42)","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]
["élève",36,null,null,null,null,null,null,null,"","",0,0,0,0,"","","",null,"",null,null,null,"00:00:00","00:00:00","","",0,0,{"$f":"IF(AND(Z43<=3,AA43<=3),1,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AD43=0,\"\",AD43)","v":""},{"$f":"IF(AE43=0,\"\",AE43)","v":""},{"$f":"IF(AF43=0,\"\",AF43)","v":""},{"$f":"IF(AG43=0,\"\",AG43)","v":""},{"$f":"IF(AH43=0,\"\",AH43)","v":""},{"$f":"IF(AI43=0,\"\",AI43)","v":""},{"$f":"IF(AJ43=0,\"\",AJ43)","v":""},{"$f":"IF(AK43=0,\"\",AK43)","v":""},{"$f":"CONCATENATE(AL43,AM43,AN43,AO43,AP43,AQ43,AR43,AS43)","v":""},{"$f":"LEFT(AT43)","v":""},{"$f":"RIGHT(AT43)","v":""},{"$f":"LEFT(AT43,2)","v":""},{"$f":"RIGHT(AT43,2)","v":""},{"$f":"LEFT(AW43)","v":""},{"$f":"RIGHT(AW43)","v":""},null,null,{"$f":"IF(AY43=\"\",0,AY43)","v":0},{"$f":"IF(AZ43=AY43,0,AZ43)","v":0},{"$f":"IF(BA43=AY43,0,IF(BA43=AZ43,0,BA43))","v":0},{"$f":"IF(BB43=\"\",0,(IF(OR(BB43=AY43,BB43=AZ43,BB43=BA43),0,BB43)))","v":0},3,3,3,3,2.5,2.5,2.5,2.5,{"$f":"IF(SUM(BG43:BJ43)=3,3,IF(SUM(BK43:BN43)=2.5,2.5,0))","v":0},{"$f":"MAX(BK43:BN43)","v":2.5},{"$f":"IF(AB43>1,$BQ$5,0)","v":0},{"$f":"IF(AB43>1,$BR$5,0)","v":0},{"$f":"IF(AB43>1,$BS$5,0)","v":0},{"$f":"IF(Z43<=3,$BT$5,0)","v":0},{"$f":"IF(Z43<=3,$BU$5,0)","v":0},{"$f":"IF(Z43<=3,$BV$5,0)","v":0},{"$f":"IF(AB43<-1,$BW$5,0)","v":0},{"$f":"IF(AB43<-1,$BX$5,0)","v":0},{"$f":"IF(AA43<=3,$BY$5,0)","v":0},{"$f":"IF(AA43<=3,$BZ$5,0)","v":0},{"$f":"IF(AA43<=3,$CA$5,0)","v":0},{"$f":"IF(AC43>1,$CB$5,0)","v":0},{"$f":"IF(AC43>1,$CC$5,0)","v":0},{"$f":"IF(AC43>1,$CD$5,0)","v":0},{"$f":"IF(AC43<-1,$CE$5,0)","v":0},{"$f":"IF(AC43<-1,$CF$5,0)","v":0},null,"",{"$f":"IF(OR(CH43=BQ43,CH43=BR43,CH43=BS43,CH43=BT43,CH43=BU43,CH43=BV43,CH43=BW43,CH43=BX43,CH43=BY43,CH43=BZ43,CH43=CA43,CH43=CB43,CH43=CC43,CH43=CD43,CH43=CE43,CH43=CF43),2,0)","v":0},null,"",{"$f":"IF(OR(CK43=BQ43,CK43=BR43,CK43=BS43,CK43=BT43,CK43=BU43,CK43=BV43,CK43=BW43,CK43=BX43,CK43=BY43,CK43=BZ43,CK43=CA43,CK43=CB43,CK43=CC43,CK43=CD43,CK43=CE43,CK43=CF43),1,0)","v":0},null,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,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(ISERROR(AVERAGE(T8:T42)),\"\",MIN(T8:T42))","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,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":""},{"$f":"IF(ISERROR(AVERAGE(T8:T42)),\"\",AVERAGE(T8:T42))","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":""},{"$f":"IF(ISERROR(AVERAGE(T8:T42)),\"\",MAX(T8:T42))","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"]