{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Demi-fond"],"not_rendered":{"charts":0,"images":0,"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":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[[4,0,4,12],[5,3,5,4],[5,12,6,12],[2,10,2,11],[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],[0,1,0,5],[0,7,0,10],[2,0,2,1],[1,0,1,8],[3,0,3,1],[2,4,2,8],[3,4,3,8],[3,10,3,11]]}
["Lycée :",null,null,null,null,null,null,"CAP BEP CCF 2018",null,null,null,null,"EPS"]
[]
["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  de l'examen\nIMPORTANT : les temps sont à saisir sous forme \"143\" pour \"1mn43s\".\nNe pas oublier de remplir la colonne Sx (sexe) "]
["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","Préparation et récupération","Note\nsur\n/20"]
[null,null,null,"base","régulation",null,null,null,null,"/ 14","/ 3","/ 3"]
["é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":""},null,null,{"$f":"IF(ISNUMBER(K8),SUM(J8:L8),\"\")","v":""}]
["élève",2,null,null,null,null,null,null,"","",null,null,""]
["élève",3,null,null,null,null,null,null,"","",null,null,""]
["élève",4,null,null,null,null,null,null,"","",null,null,""]
["élève",5,null,null,null,null,null,null,"","",null,null,""]
["élève",6,null,null,null,null,null,null,"","",null,null,""]
["élève",7,null,null,null,null,null,null,"","",null,null,""]
["élève",8,null,null,null,null,null,null,"","",null,null,""]
["élève",9,null,null,null,null,null,null,"","",null,null,""]
["élève",10,null,null,null,null,null,null,"","",null,null,""]
["élève",11,null,null,null,null,null,null,"","",null,null,""]
["élève",12,null,null,null,null,null,null,"","",null,null,""]
["élève",13,null,null,null,null,null,null,"","",null,null,""]
["élève",14,null,null,null,null,null,null,"","",null,null,""]
["élève",15,null,null,null,null,null,null,"","",null,null,""]
["élève",16,null,null,null,null,null,null,"","",null,null,""]
["élève",17,null,null,null,null,null,null,"","",null,null,""]
["élève",18,null,null,null,null,null,null,"","",null,null,""]
["élève",19,null,null,null,null,null,null,"","",null,null,""]
["élève",20,null,null,null,null,null,null,"","",null,null,""]
["élève",21,null,null,null,null,null,null,"","",null,null,""]
["élève",22,null,null,null,null,null,null,"","",null,null,""]
["élève",23,null,null,null,null,null,null,"","",null,null,""]
["élève",24,null,null,null,null,null,null,"","",null,null,""]
["élève",25,null,null,null,null,null,null,"","",null,null,""]
["élève",26,null,null,null,null,null,null,"","",null,null,""]
["élève",27,null,null,null,null,null,null,"","",null,null,""]
["élève",28,null,null,null,null,null,null,"","",null,null,""]
["élève",29,null,null,null,null,null,null,"","",null,null,""]
["élève",30,null,null,null,null,null,null,"","",null,null,""]
["élève",31,null,null,null,null,null,null,"","",null,null,""]
["élève",32,null,null,null,null,null,null,"","",null,null,""]
["élève",33,null,null,null,null,null,null,"","",null,null,""]
["élève",34,null,null,null,null,null,null,"","",null,null,""]
["élève",35,null,null,null,null,null,null,"","",null,null,""]
[{"$f":"IF(COUNTA(A8:A42)=0,\"\",IF(COUNTA(A8:A42)>1,COUNTA(A8:A42)&\"  élèves\",COUNTA(A8:A42)&\"  élève\"))","v":"35  élèves"},null,null,null,null,null,null,null,"Min.",{"$f":"IF(ISERROR(AVERAGE(I8:I42)),\"\",MIN(I8:I42))","v":""},null,"",""]
[{"$f":"IF(A43=\"\",\"\",IF(COUNTIF(C8:C42,\"f\")>1,\"dont    \"& COUNTIF(C8:C42,\"f\")&\"   filles\",COUNTIF(C8:C42,\"f\")&\"  fille\"))","v":"0  fille"},null,null,null,null,null,null,null,"Moy.",{"$f":"IF(ISERROR(AVERAGE(I8:I42)),\"\",AVERAGE(I8:I42))","v":""},null,"",""]
[null,null,null,null,null,null,null,null,"Max.",{"$f":"IF(ISERROR(AVERAGE(I8:I42)),\"\",MAX(I8:I42))","v":""},null,"",""]
[]
[]
[]
[]
[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"]