{"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":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,8,0,13],[2,0,2,1],[1,0,1,9],[3,0,3,1],[3,13,3,14],[4,0,4,15],[2,6,2,10],[3,6,3,10],[5,3,5,4],[5,15,6,15],[2,13,2,14],[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],[5,5,6,5]]}
["Lycée :",null,null,null,null,null,null,null,"BAC GT CCF 2018",null,null,null,null,null,null,"EPS"]
[]
["Classe",null,null,null,null,null,"ACTIVITE",null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,"3 x 500 mètres N4"]
["\"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) "]
["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.",null,"Note\nprojet C1","Stratégie de course","Préparation et récupération","Note\nsur\n/20"]
[null,null,null,"base","régulation",null,null,null,null,null,"/ 14",null,"/ 1","/ 3","/ 2"]
["élève",1,"G",null,null,"00:01:44","00:01:44","00:01:44","00:01:44",{"$f":"IF(COUNT(G8,H8,I8)=3,SUM(G8,H8,I8),\"\")","v":"00:05:12"},{"$f":"IF(AND(ISTEXT(C8),ISNUMBER(J8)),\nIF(C8=\"F\",INDEX(noteperf,MATCH(J8,perffilles,-1)),INDEX(noteperf,MATCH(J8,perfgars,-1))),\"\")","v":7},{"$f":"IF(F8=\"\",\"\",IF(G8-F8>=0,G8-F8,F8-G8))","v":"00:00:00"},{"$f":"IF(L8=\"\",\"\",VLOOKUP(L8,$L$53:$M$54,2))","v":1},null,null,{"$f":"IF(ISNUMBER(N8),(K8+M8+N8+O8),\"\")","v":""}]
["élève",2,"F",null,null,"00:01:44","00:02:10","00:01:44","00:01:44","00:05:38",12.6,"00:00:26",0,null,null,{"$f":"IF(ISNUMBER(N9),(K9+M9+N9+O9),\"\")","v":""}]
[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,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,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,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,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,null,null,null,null,"","","","",null,null,""]
[null,null,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":"IF(F41=\"\",\"\",IF(G41-F41>=0,G41-F41,F41-G41))","v":""},{"$f":"IF(L41=\"\",\"\",VLOOKUP(L41,$L$53:$M$54,2))","v":""},null,null,{"$f":"IF(ISNUMBER(N41),(K41+M41+N41+O41),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"","","","",null,null,""]
[null,null,null,null,null,null,null,null,null,"","","","",null,null,""]
[{"$f":"IF(COUNTA(A8:A43)>1,COUNTA(A8:A43)&\" élèves\",COUNTA(A8:A43)&\" élève\")","v":"2 élèves"},null,null,null,null,null,null,null,null,"Min.",{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",MIN(K8:K42))","v":7},0,0,"","",""]
[{"$f":"IF(A44=\"\",\"\",IF(COUNTIF(C8:C43,\"f\")>1,\"dont    \"& COUNTIF(C8:C43,\"f\")&\"   filles\",COUNTIF(C8:C43,\"f\")&\"  fille\"))","v":"1  fille"},null,null,null,null,null,null,null,null,"Moy.",{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",AVERAGE(K8:K42))","v":9.8000000000000007},1.5046296296296281E-4,0.5,"","",""]
[null,null,null,null,null,null,null,null,null,"Max.",{"$f":"IF(ISERROR(AVERAGE(K8:K42)),\"\",MAX(K8:K42))","v":12.6},3.0092592592592562E-4,1,"","",""]
[]
[]
[]
[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,"00:00:00",1]
[null,null,null,null,null,null,"00:09:50.010",2.1,"00:07:11.010",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"]