{"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":79,"n_cols":90,"rows_kept":79,"cut":false,"hidden":false,"merged":[[6,56,6,59],[6,60,6,63],[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,19,1,22],[2,0,2,1],[3,19,3,22],[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,"STRATÉGIE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["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,2,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,"C1-C3"]
[null,null,null,"base","régulation",null,null,null,null,"/ 14","réalisé",null,null,null,"note","/ 3",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)),\nIF(C8=\"F\",INDEX(noteperf,MATCH(I8,perffilles,-1)),INDEX(noteperf,MATCH(I8,perfgars,-1))),\"\")","v":""},{"$f":"BA8","v":0},{"$f":"BB8","v":0},{"$f":"BC8","v":0},{"$f":"BD8","v":0},{"$f":"IF(AND(COUNTA(F8:H8)=3,ISTEXT(C8)),CL8,\"\")","v":""},null,{"$f":"IF(ISNUMBER(O8),SUM(J8:P8),\"\")","v":""},null,3,{"$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(T8),\"\")","v":""},{"$f":"IF(ISNUMBER(I8),SECOND(U8),\"\")","v":""},{"$f":"IF(G8<F8,SECOND(T8),-SECOND(T8))","v":0},{"$f":"IF(H8<G8,SECOND(U8),-SECOND(U8))","v":0},{"$f":"IF(ISNUMBER(I8),SECOND(V8),\"\")","v":""},{"$f":"IF(AND(W8<=3,X8<=3),1,0)","v":0},{"$f":"IF(AND((G8<F8),(H8<G8)),2,0)","v":0},{"$f":"IF(AND((W8<=3),(H8<G8),(X8>=1)),3,0)","v":0},{"$f":"IF(AND((W8<=3),(G8<H8),(X8>=1)),4,0)","v":0},{"$f":"IF(AND((W8>=1),(X8<=3),(F8<G8)),5,0)","v":0},{"$f":"IF(AND((W8>=1),(X8<=3),(F8>G8)),6,0)","v":0},{"$f":"IF(AND((W8>=1),(X8>=1),(F8<G8),(G8>H8)),7,0)","v":0},{"$f":"IF(AND((W8>=1),(X8>=1),(F8>G8),(G8<H8)),8,0)","v":0},{"$f":"IF(AB8=0,\"\",AB8)","v":""},{"$f":"IF(AC8=0,\"\",AC8)","v":""},"","","","","","",{"$f":"CONCATENATE(AJ8,AK8,AL8,AM8,AN8,AO8,AP8,AQ8)","v":""},{"$f":"LEFT(AR8)","v":""},{"$f":"RIGHT(AR8)","v":""},{"$f":"LEFT(AR8,2)","v":""},{"$f":"RIGHT(AR8,2)","v":""},{"$f":"LEFT(AU8)","v":""},{"$f":"RIGHT(AU8)","v":""},{"$f":"LEFT(AV8)","v":""},{"$f":"RIGHT(AV8)","v":""},{"$f":"IF(AW8=\"\",0,AW8)","v":0},{"$f":"IF(AX8=AW8,0,AX8)","v":0},{"$f":"IF(AY8=\"\",0,IF(OR(AY8=AW8,AY8=AX8),0,AY8))","v":0},{"$f":"IF(AZ8=\"\",0,(IF(OR(AZ8=AW8,AZ8=AX8,AZ8=AY8),0,AZ8)))","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(BE8:BH8)=3,3,IF(SUM(BI8:BL8)=2,2,0))","v":0},{"$f":"MAX(BI8:BL8)","v":2},{"$f":"IF(Y8>1,$BO$5,0)","v":0},{"$f":"IF(Y8>1,$BP$5,0)","v":0},{"$f":"IF(Y8>1,$BQ$5,0)","v":0},{"$f":"IF(W8<=3,$BR$5,0)","v":0},{"$f":"IF(W8<=3,$BS$5,0)","v":0},{"$f":"IF(W8<=3,$BT$5,0)","v":0},{"$f":"IF(Y8<-1,$BU$5,0)","v":0},{"$f":"IF(Y8<-1,$BV$5,0)","v":0},{"$f":"IF(X8<=3,$BW$5,0)","v":0},{"$f":"IF(X8<=3,$BX$5,0)","v":0},{"$f":"IF(X8<=3,$BY$5,0)","v":0},{"$f":"IF(Z8>1,$BZ$5,0)","v":0},{"$f":"IF(Z8>1,$CA$5,0)","v":0},{"$f":"IF(Z8>1,$CB$5,0)","v":0},{"$f":"IF(Z8<-1,$CC$5,0)","v":0},{"$f":"IF(Z8<-1,$CD$5,0)","v":0},{"$f":"IF(AA8<1,$CE$5,0)","v":0},{"$f":"IF(D8=\"\",\"\",D8)","v":""},{"$f":"IF(OR(CF8=BO8,CF8=BP8,CF8=BQ8,CF8=BR8,CF8=BS8,CF8=BT8,CF8=BU8,CF8=BV8,CF8=BW8,CF8=BX8,CF8=BY8,CF8=BZ8,CF8=CA8,CF8=CB8,CF8=CC8,CF8=CD8,CF8=CE8),1.5,0)","v":0},null,{"$f":"IF(E8=\"\",\"\",E8)","v":""},{"$f":"IF(OR(CI8=BO8,CI8=BP8,CI8=BQ8,CI8=BR8,CI8=BS8,CI8=BT8,CI8=BU8,CI8=BV8,CI8=BW8,CI8=BX8,CI8=BY8,CI8=BZ8,CI8=CA8,CI8=CB8,CI8=CC8,CI8=CD8),1,0)","v":0},null,{"$f":"IF(E8=\"\",MAX(BM8,CG8,CJ8),MAX(BN8,CJ8))","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,null,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,{"$f":"IF(AB9=0,\"\",AB9)","v":""},{"$f":"IF(AC9=0,\"\",AC9)","v":""},{"$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":"CONCATENATE(AJ9,AK9,AL9,AM9,AN9,AO9,AP9,AQ9)","v":""},{"$f":"LEFT(AR9)","v":""},{"$f":"RIGHT(AR9)","v":""},{"$f":"LEFT(AR9,2)","v":""},{"$f":"RIGHT(AR9,2)","v":""},{"$f":"LEFT(AU9)","v":""},{"$f":"RIGHT(AU9)","v":""},{"$f":"LEFT(AV9)","v":""},{"$f":"RIGHT(AV9)","v":""},{"$f":"IF(AW9=\"\",0,AW9)","v":0},{"$f":"IF(AX9=AW9,0,AX9)","v":0},{"$f":"IF(AY9=\"\",0,IF(OR(AY9=AW9,AY9=AX9),0,AY9))","v":0},{"$f":"IF(AZ9=\"\",0,(IF(OR(AZ9=AW9,AZ9=AX9,AZ9=AY9),0,AZ9)))","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(BE9:BH9)=3,3,IF(SUM(BI9:BL9)=2,2,0))","v":0},{"$f":"MAX(BI9:BL9)","v":2},0,0,0,0,0,0,{"$f":"IF(Y9<-1,$BU$5,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AA9<-1,$CE$5,0)","v":0},"",{"$f":"IF(OR(CF9=BO9,CF9=BP9,CF9=BQ9,CF9=BR9,CF9=BS9,CF9=BT9,CF9=BU9,CF9=BV9,CF9=BW9,CF9=BX9,CF9=BY9,CF9=BZ9,CF9=CA9,CF9=CB9,CF9=CC9,CF9=CD9,CF9=CE9),1.5,0)","v":0},null,"",{"$f":"IF(OR(CI9=BO9,CI9=BP9,CI9=BQ9,CI9=BR9,CI9=BS9,CI9=BT9,CI9=BU9,CI9=BV9,CI9=BW9,CI9=BX9,CI9=BY9,CI9=BZ9,CI9=CA9,CI9=CB9,CI9=CC9,CI9=CD9),1,0)","v":0},null,0]
["élève",3,null,null,null,null,null,null,"","",0,0,0,0,"",null,"",null,null,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"",{"$f":"IF(AC10=0,\"\",AC10)","v":""},"","","","","","","","","",{"$f":"LEFT(AR10,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,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,4,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR(AY12=AW12,AY12=AX12),0,AY12)","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(Y12>1,$BO$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,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,null,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(AY14=AW14,0,IF(AY14=AX14,0,AY14))","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,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(Y15<-1,$BV$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,5,"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,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,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,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,6,"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,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,null,"00:00:00","00:00:00","00:00:00","","",0,0,"",{"$f":"IF(AND(W22<=3,X22<=3),1,0)","v":0},0,0,0,0,0,0,0,"","","",{"$f":"IF(AE22=0,\"\",AE22)","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,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,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,7,"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,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,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,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,8,"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,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,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,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,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,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,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,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,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,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,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,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,"","",0,0,0,0,"",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,{"$f":"IF(COUNT(F42,G42,H42)=3,SUM(F42,G42,H42),\"\")","v":""},{"$f":"IF(AND(ISTEXT(C42),ISNUMBER(I42)),\nIF(C42=\"F\",INDEX(noteperf,MATCH(I42,perffilles,-1)),INDEX(noteperf,MATCH(I42,perfgars,-1))),\"\")","v":""},{"$f":"BA42","v":0},{"$f":"BB42","v":0},{"$f":"BC42","v":0},{"$f":"BD42","v":0},{"$f":"IF(AND(COUNTA(F42:H42)=3,ISTEXT(C42)),CL42,\"\")","v":""},null,{"$f":"IF(ISNUMBER(O42),SUM(J42:P42),\"\")","v":""},null,null,"00:00:00","00:00:00","00:00:00","","",0,0,"",0,0,0,0,0,0,0,0,"","","","","","","","","","","","","",{"$f":"LEFT(AU42)","v":""},{"$f":"RIGHT(AU42)","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,0,"",0,null,"",0,null,0]
["élève",36,null,null,null,null,null,null,"","",0,0,0,0,"",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(T43),\"\")","v":""},{"$f":"IF(ISNUMBER(I43),SECOND(U43),\"\")","v":""},{"$f":"IF(G43<F43,SECOND(T43),-SECOND(T43))","v":0},{"$f":"IF(H43<G43,SECOND(U43),-SECOND(U43))","v":0},{"$f":"IF(ISNUMBER(I43),SECOND(V43),\"\")","v":""},{"$f":"IF(AND(W43<=3,X43<=3),1,0)","v":0},{"$f":"IF(AND((G43<F43),(H43<G43)),2,0)","v":0},{"$f":"IF(AND((W43<=3),(H43<G43),(X43>=1)),3,0)","v":0},{"$f":"IF(AND((W43<=3),(G43<H43),(X43>=1)),4,0)","v":0},{"$f":"IF(AND((W43>=1),(X43<=3),(F43<G43)),5,0)","v":0},{"$f":"IF(AND((W43>=1),(X43<=3),(F43>G43)),6,0)","v":0},{"$f":"IF(AND((W43>=1),(X43>=1),(F43<G43),(G43>H43)),7,0)","v":0},{"$f":"IF(AND((W43>=1),(X43>=1),(F43>G43),(G43<H43)),8,0)","v":0},{"$f":"IF(AB43=0,\"\",AB43)","v":""},{"$f":"IF(AC43=0,\"\",AC43)","v":""},{"$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":"CONCATENATE(AJ43,AK43,AL43,AM43,AN43,AO43,AP43,AQ43)","v":""},{"$f":"LEFT(AR43)","v":""},{"$f":"RIGHT(AR43)","v":""},{"$f":"LEFT(AR43,2)","v":""},{"$f":"RIGHT(AR43,2)","v":""},{"$f":"LEFT(AU43)","v":""},{"$f":"RIGHT(AU43)","v":""},null,null,{"$f":"IF(AW43=\"\",0,AW43)","v":0},{"$f":"IF(AX43=AW43,0,AX43)","v":0},{"$f":"IF(AY43=AW43,0,IF(AY43=AX43,0,AY43))","v":0},{"$f":"IF(AZ43=\"\",0,(IF(OR(AZ43=AW43,AZ43=AX43,AZ43=AY43),0,AZ43)))","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(BE43:BH43)=3,3,IF(SUM(BI43:BL43)=2,2,0))","v":0},{"$f":"MAX(BI43:BL43)","v":2},{"$f":"IF(Y43>1,$BO$5,0)","v":0},{"$f":"IF(Y43>1,$BP$5,0)","v":0},{"$f":"IF(Y43>1,$BQ$5,0)","v":0},{"$f":"IF(W43<=3,$BR$5,0)","v":0},{"$f":"IF(W43<=3,$BS$5,0)","v":0},{"$f":"IF(W43<=3,$BT$5,0)","v":0},{"$f":"IF(Y43<-1,$BU$5,0)","v":0},{"$f":"IF(Y43<-1,$BV$5,0)","v":0},{"$f":"IF(X43<=3,$BW$5,0)","v":0},{"$f":"IF(X43<=3,$BX$5,0)","v":0},{"$f":"IF(X43<=3,$BY$5,0)","v":0},{"$f":"IF(Z43>1,$BZ$5,0)","v":0},{"$f":"IF(Z43>1,$CA$5,0)","v":0},{"$f":"IF(Z43>1,$CB$5,0)","v":0},{"$f":"IF(Z43<-1,$CC$5,0)","v":0},{"$f":"IF(Z43<-1,$CD$5,0)","v":0},{"$f":"IF(AA43<-1,$CE$5,0)","v":0},{"$f":"IF(D43=\"\",\"\",D43)","v":""},{"$f":"IF(OR(CF43=BO43,CF43=BP43,CF43=BQ43,CF43=BR43,CF43=BS43,CF43=BT43,CF43=BU43,CF43=BV43,CF43=BW43,CF43=BX43,CF43=BY43,CF43=BZ43,CF43=CA43,CF43=CB43,CF43=CC43,CF43=CD43,CF43=CE43),1.5,0)","v":0},null,{"$f":"IF(E43=\"\",\"\",E43)","v":""},{"$f":"IF(OR(CI43=BO43,CI43=BP43,CI43=BQ43,CI43=BR43,CI43=BS43,CI43=BT43,CI43=BU43,CI43=BV43,CI43=BW43,CI43=BX43,CI43=BY43,CI43=BZ43,CI43=CA43,CI43=CB43,CI43=CC43,CI43=CD43),1,0)","v":0},null,{"$f":"IF(E43=\"\",MAX(BM43,CG43,CJ43),MAX(BN43,CJ43))","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"]