{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Demi-fond"],"not_rendered":{"charts":0,"images":8,"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":15,"rows_kept":79,"cut":false,"hidden":false,"merged":[[5,2,6,2],[5,1,6,1],[4,0,4,12],[5,3,5,4],[5,12,6,12],[5,7,6,7],[5,0,6,0],[5,8,6,8],[5,6,6,6],[5,5,6,5],[0,1,0,5],[0,7,0,9],[2,0,2,1],[1,0,1,8],[3,0,3,1],[2,4,2,8],[3,4,3,8]]}
["Lycée :",null,null,null,null,null,null,"BAC PRO CCF 2018",null,null,null,null,"EPS",null,"STRATÉGIE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Classe",null,null,null,"ACTIVITE"]
[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,2]
["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":""},null,3]
["é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,"",null,4]
["é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,"",null,5]
["é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,"",null,6]
["é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,"",null,7]
["é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,"",null,8]
["é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,""]
["élève",36,null,null,null,null,null,null,{"$f":"IF(COUNT(F43,G43,H43)=3,SUM(F43,G43,H43),\"\")","v":""},{"$f":"IF(AND(ISTEXT(C43),ISNUMBER(I43)),\nIF(C43=\"F\",INDEX(noteperf,MATCH(I43,perffilles,-1)),INDEX(noteperf,MATCH(I43,perfgars,-1))),\"\")","v":""},null,null,{"$f":"IF(ISNUMBER(K43),SUM(J43:L43),\"\")","v":""}]
[{"$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":""},{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",MIN(K8:K42))","v":""},{"$f":"IF(ISERROR(AVERAGE(L8:L42)),\"\",MIN(L8:L42))","v":""},{"$f":"IF(ISERROR(AVERAGE(M8:M42)),\"\",MIN(M8:M42))","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":""},{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",AVERAGE(K8:K42))","v":""},{"$f":"IF(ISERROR(AVERAGE(L8:L42)),\"\",AVERAGE(L8:L42))","v":""},{"$f":"IF(ISERROR(AVERAGE(M8:M42)),\"\",AVERAGE(M8:M42))","v":""}]
[null,null,null,null,null,null,null,null,"Max.",{"$f":"IF(ISERROR(AVERAGE(J8:J42)),\"\",MAX(J8:J42))","v":""},{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",MAX(K8:K42))","v":""},{"$f":"IF(ISERROR(AVERAGE(L8:L42)),\"\",MAX(L8:L42))","v":""},{"$f":"IF(ISERROR(AVERAGE(M8:M42)),\"\",MAX(M8:M42))","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"]