{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["NATATION de distance"],"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":"NATATION de distance","index":0,"n_rows":91,"n_cols":23,"rows_kept":91,"cut":false,"hidden":false,"merged":[[83,0,83,1],[5,13,6,13],[5,2,6,2],[5,11,6,11],[5,1,6,1],[0,1,0,6],[2,19,2,22],[3,19,3,22],[2,5,2,16],[3,5,3,16],[1,29,1,31],[2,0,2,1],[3,29,3,31],[5,22,6,22],[5,0,6,0],[5,15,6,15],[5,16,6,16],[5,17,6,17],[5,12,6,12],[1,0,1,10],[3,0,3,1],[4,0,4,22],[5,14,6,14]]}
["Lycée :"]
[]
["Classe",null,null,null,null,"BAC GT 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,"NATATION DE DISTANCE  NIVEAU 5"]
["IMPORTANT : les temps sont à saisir sous forme \"143\" pour \"1mn43s\".                                 Ne pas oublier de remplir la colonne Sx (sexe) "]
["NOMS","Prénoms","Sx","temps de passage au","temps de passage au","temps de passage au","temps de passage au","temps de passage au","temps de passage au","temps de passage au","arrivée au","temps 2eme 100m","temps 3eme 100m","temps 4eme 100m","temps 5eme 100m","temps 6eme 100m","temps 7eme 100m","temps 8eme 100m","dernier 100m","perf",null,"gestion effort","Note\nsur\n/20"]
[null,null,null,100,200,300,400,500,600,700,800,null,null,null,null,null,null,null,"/  3","/  14","/1","/  3"]
["EXEMPLE","garçons","G","00:01:11","00:02:22","00:03:33","00:04:44","00:05:55","00:07:06","00:08:30","00:09:30",{"$f":"IF(E8=\"\",\"\",E8-D8)","v":"00:01:11"},{"$f":"IF(F8=\"\",\"\",F8-E8)","v":"00:01:11"},"00:01:11","00:01:11","00:01:11","00:01:24","00:01:00",{"$f":"IF(ISNUMBER(R8),IF(R8>=MIN(L8:Q8),0,3),\"\")","v":3},{"$f":"IF(AND(ISTEXT(C8),ISNUMBER(K8)),IF(C8=\"F\",INDEX($B$56:$B$83,MATCH(K8,$A$56:$A$83,-1)),INDEX($B$56:$B$83,MATCH(K8,$C$56:$C$83,-1))),\"\")","v":14},{"$f":"IF(K8=\"\",\"\",ABS(MIN(L8:Q8)-MAX(L8:Q8)))","v":"00:00:13"},{"$f":"IF(U8=\"\",\"\",VLOOKUP(U8,$A$86:$B$91,2))","v":0.5},{"$f":"IF(ISNUMBER(S8),SUM(S8,T8,V8),\"\")","v":17.5}]
["EXEMPLE","filles","G","00:01:50","00:03:22","00:05:12","00:06:55","00:08:22","00:10:00","00:12:40","00:14:25",{"$f":"IF(E9=\"\",\"\",E9-D9)","v":"00:01:32"},{"$f":"IF(F9=\"\",\"\",F9-E9)","v":"00:01:50"},{"$f":"IF(G9=\"\",\"\",G9-F9)","v":"00:01:43"},{"$f":"IF(H9=\"\",\"\",H9-G9)","v":"00:01:27"},{"$f":"IF(I9=\"\",\"\",I9-H9)","v":"00:01:38"},{"$f":"IF(J9=\"\",\"\",J9-I9)","v":"00:02:40"},{"$f":"IF(K9=\"\",\"\",K9-J9)","v":"00:01:45"},{"$f":"IF(ISNUMBER(R9),IF(R9>=MIN(L9:Q9),0,3),\"\")","v":0},6,"00:01:13",{"$f":"IF(U9=\"\",\"\",VLOOKUP(U9,$A$86:$B$91,2))","v":0},{"$f":"IF(ISNUMBER(S9),SUM(S9,T9,V9),\"\")","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,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(COUNTA(A8:A36)>1,COUNTA(A8:A36)&\" élèves\",COUNTA(A8:A36)&\" élève\")","v":"2 élèves"},null,"Min.",{"$f":"IF(ISERROR(AVERAGE(D8:D36)),\"\",MIN(D8:D36))","v":"00:01:11"},"00:02:22","00:03:33","00:04:44",null,null,null,"00:09:30","00:01:11","00:01:11","00:01:11",null,null,null,"00:01:00",0,6,1.5046296296296422E-4,0,{"$f":"IF(ISERROR(AVERAGE(W8:W36)),\"\",MIN(W8:W36))","v":6}]
[{"$f":"IF(A37=\"\",\"\",IF(COUNTIF(C8:C36,\"f\")>1,\"dont    \"& COUNTIF(C8:C36,\"f\")&\"   filles\",COUNTIF(C8:C36,\"f\")&\"  fille\"))","v":"0  fille"},null,"Moy.",{"$f":"IF(ISERROR(AVERAGE(D8:D36)),\"\",AVERAGE(D8:D36))","v":"00:01:30.500"},"00:02:52","00:04:22.500","00:05:49.500",null,null,null,"00:11:57.500","00:01:21.500","00:01:30.500","00:01:27",null,null,null,"00:01:22.500",1.5,10,4.9768518518518608E-4,0.25,{"$f":"IF(ISERROR(AVERAGE(W8:W36)),\"\",AVERAGE(W8:W36))","v":11.75}]
[null,null,"Max.",{"$f":"IF(ISERROR(AVERAGE(D8:D36)),\"\",MAX(D8:D36))","v":"00:01:50"},"00:03:22","00:05:12","00:06:55",null,null,null,"00:14:25","00:01:32","00:01:50","00:01:43",null,null,null,"00:01:45",3,14,8.4490740740740793E-4,0.5,{"$f":"IF(ISERROR(AVERAGE(W8:W36)),\"\",MAX(W8:W36))","v":17.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["perffilles","note","perfgars"]
["00:30:00",0,"00:30:00"]
["00:19:00",1,"00:17:00"]
["00:18:40",1.5,"00:16:41"]
["00:18:24",2,"00:16:26"]
["00:18:08",2.5,"00:16:11"]
["00:17:52",3,"00:15:56"]
["00:17:36",3.5,"00:15:41"]
["00:17:20",4,"00:15:28"]
["00:17:04",4.5,"00:15:15"]
["00:16:48",5,"00:15:02"]
["00:16:32",5.5,"00:14:49"]
["00:16:16",6,"00:14:36"]
["00:16:00",6.5,"00:14:23"]
["00:15:44",7,"00:14:10"]
["00:15:32",7.5,"00:14:00"]
["00:15:20",8,"00:13:50"]
["00:15:08",8.5,"00:13:40"]
["00:14:56",9,"00:13:30"]
["00:14:44",9.5,"00:13:20"]
["00:14:32",10,"00:13:10"]
["00:14:20",10.5,"00:13:00"]
["00:14:08",11,"00:12:50"]
["00:13:56",11.5,"00:12:40"]
["00:13:44",12,"00:12:30"]
["00:13:32",12.5,"00:12:20"]
["00:13:20",13,"00:12:10"]
["00:13:08",13.5,"00:11:50"]
["00:12:56",14,"00:11:40"]
["Projet"]
["écart","note"]
["00:00:00",3]
["00:00:04",2]
["00:00:06",1.5]
["00:00:08",1]
["00:00:10",0.5]
["00:00:13.010",0]