{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Référentiel"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":108,"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":"Feuil1","index":0,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,5,3,7],[3,8,3,10],[3,12,4,12],[3,14,4,14]]}
[null,null,"Fiche évaluation DNB",null,null,null,"APSA:","Course de Haies"]
[null,null,"Classe/Groupe",null,null,null,null,null,null,"Professeur:",null,null,null,null,null,null,null,null,null,null,null,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Course de Haies  .pdf"]
[null,null,null,null,null,"Temps au 50m plat",null,null,"Temps au 50m haies",null,null,null,"Note de performance /8 points","Efficacité de:","Efficacité du starter, du chronométreur, de l'observateur / 4 points"]
[null,"Nom- Prénom","Sexe","Classe","Note","Essai 1","Essai 2","Essai 3","Essai 1","Essai 2","Essai 3",null,null,"- l'élévation du centre de gravité  /Nombre d'appuis dans les intervalles /Appréciation du ressenti associé aux observations exterieures / 8 points",null,null,null,"Coureur sauteur",null,null,"Juge dilettante"]
[1,null,null,null,{"$f":"IF(M6=\"\",\"\",M6+N6+O6)","v":""},null,null,null,null,null,null,{"$f":"IF(OR(F6=\"\",I6=\"\"),\"\",(MIN(F6:H6)+MIN(I6:K6)))","v":""},{"$f":"IF(L6=\"\",\"\",IF(C6=\"F\",IF(L6<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L6,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L6<Feuil2!D2,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L6,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,0,null,null,0]
[2,null,null,null,{"$f":"IF(M7=\"\",\"\",M7+N7+O7)","v":""},null,null,null,null,null,null,{"$f":"IF(OR(F7=\"\",I7=\"\"),\"\",(MIN(F7:H7)+MIN(I7:K7)))","v":""},{"$f":"IF(L7=\"\",\"\",IF(C7=\"F\",IF(L7<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L7,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L7<Feuil2!D3,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L7,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,0.5,null,null,0.5]
[3,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L8=\"\",\"\",IF(C8=\"F\",IF(L8<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L8,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L8<Feuil2!D4,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L8,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,1,null,null,1]
[4,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L9=\"\",\"\",IF(C9=\"F\",IF(L9<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L9,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L9<Feuil2!D5,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L9,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,1.5,null,null,1.5]
[5,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L10=\"\",\"\",IF(C10=\"F\",IF(L10<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L10,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L10<Feuil2!D6,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L10,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,2,null,null,"Juge fiable"]
[6,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L11=\"\",\"\",IF(C11=\"F\",IF(L11<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L11,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L11<Feuil2!D7,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L11,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,2.5,null,null,2]
[7,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L12=\"\",\"\",IF(C12=\"F\",IF(L12<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L12,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L12<Feuil2!D8,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L12,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,3,null,null,2.5]
[8,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L13=\"\",\"\",IF(C13=\"F\",IF(L13<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L13,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L13<Feuil2!D9,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L13,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,3.5,null,null,3]
[9,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L14=\"\",\"\",IF(C14=\"F\",IF(L14<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L14,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L14<Feuil2!D10,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L14,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,4,null,null,"Juge multifonctions"]
[10,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L15=\"\",\"\",IF(C15=\"F\",IF(L15<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L15,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L15<Feuil2!D11,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L15,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,"Coureur de haies coordonné",null,null,3.5]
[11,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L16=\"\",\"\",IF(C16=\"F\",IF(L16<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L16,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L16<Feuil2!D12,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L16,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,4.5,null,null,4]
[12,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L17=\"\",\"\",IF(C17=\"F\",IF(L17<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L17,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L17<Feuil2!D13,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L17,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,5]
[13,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L18=\"\",\"\",IF(C18=\"F\",IF(L18<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L18,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L18<Feuil2!D14,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L18,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,5.5]
[14,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L19=\"\",\"\",IF(C19=\"F\",IF(L19<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L19,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L19<Feuil2!D15,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L19,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,6]
[15,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L20=\"\",\"\",IF(C20=\"F\",IF(L20<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L20,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L20<Feuil2!D16,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L20,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,"Coureur de haies accélérateur"]
[16,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L21=\"\",\"\",IF(C21=\"F\",IF(L21<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L21,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L21<Feuil2!D17,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L21,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,6.5]
[17,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L22=\"\",\"\",IF(C22=\"F\",IF(L22<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L22,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L22<Feuil2!D18,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L22,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,7]
[18,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L23=\"\",\"\",IF(C23=\"F\",IF(L23<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L23,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L23<Feuil2!D19,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L23,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,7.5]
[19,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L24=\"\",\"\",IF(C24=\"F\",IF(L24<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L24,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L24<Feuil2!D20,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L24,Feuil2!$D$2:$D$10,1)))))","v":""},null,null,null,null,8]
[20,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L25=\"\",\"\",IF(C25=\"F\",IF(L25<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L25,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L25<Feuil2!D21,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L25,Feuil2!$D$2:$D$10,1)))))","v":""}]
[21,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L26=\"\",\"\",IF(C26=\"F\",IF(L26<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L26,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L26<Feuil2!D22,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L26,Feuil2!$D$2:$D$10,1)))))","v":""}]
[22,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L27=\"\",\"\",IF(C27=\"F\",IF(L27<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L27,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L27<Feuil2!D23,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L27,Feuil2!$D$2:$D$10,1)))))","v":""}]
[23,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L28=\"\",\"\",IF(C28=\"F\",IF(L28<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L28,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L28<Feuil2!D24,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L28,Feuil2!$D$2:$D$10,1)))))","v":""}]
[24,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L29=\"\",\"\",IF(C29=\"F\",IF(L29<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L29,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L29<Feuil2!D25,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L29,Feuil2!$D$2:$D$10,1)))))","v":""}]
[25,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L30=\"\",\"\",IF(C30=\"F\",IF(L30<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L30,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L30<Feuil2!D26,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L30,Feuil2!$D$2:$D$10,1)))))","v":""}]
[26,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L31=\"\",\"\",IF(C31=\"F\",IF(L31<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L31,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L31<Feuil2!D27,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L31,Feuil2!$D$2:$D$10,1)))))","v":""}]
[27,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L32=\"\",\"\",IF(C32=\"F\",IF(L32<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L32,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L32<Feuil2!D28,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L32,Feuil2!$D$2:$D$10,1)))))","v":""}]
[28,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L33=\"\",\"\",IF(C33=\"F\",IF(L33<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L33,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L33<Feuil2!D29,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L33,Feuil2!$D$2:$D$10,1)))))","v":""}]
[29,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L34=\"\",\"\",IF(C34=\"F\",IF(L34<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L34,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L34<Feuil2!D30,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L34,Feuil2!$D$2:$D$10,1)))))","v":""}]
[30,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L35=\"\",\"\",IF(C35=\"F\",IF(L35<Feuil2!$C$2,8,(INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L35,Feuil2!$C$2:$C$11,1)))),IF(Feuil1!L35<Feuil2!D31,8,INDEX(Feuil2!$B$2:$B$10,MATCH(Feuil1!L35,Feuil2!$D$2:$D$10,1)))))","v":""}]
[null,null,null,"Moyenne générale",{"$f":"IF(E6=\"\",\"\",AVERAGE($E$6:$E$35))","v":""}]
[null,null,null,"Moyenne filles",{"$f":"IF(E6=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$6:$C$35,\"F\",$E$6:$E$35)))","v":""}]
[null,null,null,"Moyenne garçons",{"$f":"IF(E6=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$6:$C$35,\"M\",$E$6:$E$35)))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,null,"F","G"]
[null,8,17.5,16,null,null,0,null,null,"Juge dilettante"]
[null,7,17.899999999999999,16.399999999999999,null,null,0.5,null,null,0]
[null,6,18.5,17,null,null,1,null,null,0.5]
[null,5,19.399999999999999,17.899999999999999,null,null,1.5,null,null,1]
[null,4,20.5,19,null,null,2,null,null,1.5]
[null,3,22,20.2,null,null,2.5,null,null,"Juge fiable"]
[null,2,23.7,21.6,null,null,3,null,null,2]
[null,1,25.5,23,null,null,3.5,null,null,2.5]
[null,0,27,24.5,null,null,4,null,null,3]
[null,null,null,null,null,null,4.5,null,null,"Juge multifonctions"]
[null,null,null,null,null,null,5,null,null,3.5]
[null,null,null,null,null,null,5.5,null,null,4]
[null,null,null,null,null,null,6]
[null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,7]
[null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,8]

{"sheet":"Référentiel","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}