{"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":1,"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":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,5,3,7],[3,8,3,10]]}
[null,null,"Fiche évaluation DNB",null,null,null,null,null,null,null,null,"APSA:","Pentabonds "]
[null,null,"Classe/Groupe",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,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Pentabonds   .pdf"]
[null,null,null,null,null,"Performance sans élan",null,null,"Performance avec élan"]
[null,"Nom- Prénom","Sexe","Classe","Note",1,2,3,1,2,3,"Performance retenue (adition de la meilleur perf sans élan et avec élan.","Note de performance /8 points","Efficacité dans le domaine de la conservation de la vitesse et de la forme des bonds /8 points","Efficacité dans le rôle d'observateur et de juge /4 points",null,null,"Sauteur saccadé",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=\"\"),\"\",LARGE(F6:H6,1)+LARGE(I6:K6,1))","v":""},{"$f":"IF(L6=\"\",\"\",(IF(C6=\"F\",IF(L6>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L6,Feuil2!$B$3:$B$11,-1)))),(IF(L6>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L6,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,0,null,0]
[2,null,null,null,{"$f":"IF(M7=\"\",\"\",(M7+N7+O7))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(F7=\"\",I7=\"\"),\"\",LARGE(F7:H7,1)+LARGE(I7:K7,1))","v":""},{"$f":"IF(L7=\"\",\"\",(IF(C7=\"F\",IF(L7>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L7,Feuil2!$B$3:$B$11,-1)))),(IF(L7>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L7,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,0.5,null,0.5]
[3,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L8=\"\",\"\",(IF(C8=\"F\",IF(L8>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L8,Feuil2!$B$3:$B$11,-1)))),(IF(L8>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L8,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,1,null,1]
[4,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L9=\"\",\"\",(IF(C9=\"F\",IF(L9>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L9,Feuil2!$B$3:$B$11,-1)))),(IF(L9>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L9,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,1.5,null,1.5]
[5,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L10=\"\",\"\",(IF(C10=\"F\",IF(L10>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L10,Feuil2!$B$3:$B$11,-1)))),(IF(L10>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L10,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,2,null,"Juge fiable"]
[6,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L11=\"\",\"\",(IF(C11=\"F\",IF(L11>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L11,Feuil2!$B$3:$B$11,-1)))),(IF(L11>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L11,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,2.5,null,2]
[7,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L12=\"\",\"\",(IF(C12=\"F\",IF(L12>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L12,Feuil2!$B$3:$B$11,-1)))),(IF(L12>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L12,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,3,null,2.5]
[8,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L13=\"\",\"\",(IF(C13=\"F\",IF(L13>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L13,Feuil2!$B$3:$B$11,-1)))),(IF(L13>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L13,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,3.5,null,3]
[9,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L14=\"\",\"\",(IF(C14=\"F\",IF(L14>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L14,Feuil2!$B$3:$B$11,-1)))),(IF(L14>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L14,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,4,null,"Juge multifonctions"]
[10,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L15=\"\",\"\",(IF(C15=\"F\",IF(L15>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L15,Feuil2!$B$3:$B$11,-1)))),(IF(L15>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L15,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,"Sauteur coordonné",null,3.5]
[11,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L16=\"\",\"\",(IF(C16=\"F\",IF(L16>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L16,Feuil2!$B$3:$B$11,-1)))),(IF(L16>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L16,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,4.5,null,4]
[12,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L17=\"\",\"\",(IF(C17=\"F\",IF(L17>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L17,Feuil2!$B$3:$B$11,-1)))),(IF(L17>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L17,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L18,Feuil2!$B$3:$B$11,-1)))),(IF(L18>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L18,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L19,Feuil2!$B$3:$B$11,-1)))),(IF(L19>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L19,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L20,Feuil2!$B$3:$B$11,-1)))),(IF(L20>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L20,Feuil2!$C$3:$C$11,-1)))))))","v":""},null,null,null,null,"Sauteur fluide accélérateur"]
[16,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L21=\"\",\"\",(IF(C21=\"F\",IF(L21>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L21,Feuil2!$B$3:$B$11,-1)))),(IF(L21>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L21,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L22,Feuil2!$B$3:$B$11,-1)))),(IF(L22>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L22,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L23,Feuil2!$B$3:$B$11,-1)))),(IF(L23>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L23,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L24,Feuil2!$B$3:$B$11,-1)))),(IF(L24>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L24,Feuil2!$C$3:$C$11,-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>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L25,Feuil2!$B$3:$B$11,-1)))),(IF(L25>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L25,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[21,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L26=\"\",\"\",(IF(C26=\"F\",IF(L26>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L26,Feuil2!$B$3:$B$11,-1)))),(IF(L26>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L26,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[22,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L27=\"\",\"\",(IF(C27=\"F\",IF(L27>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L27,Feuil2!$B$3:$B$11,-1)))),(IF(L27>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L27,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[23,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L28=\"\",\"\",(IF(C28=\"F\",IF(L28>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L28,Feuil2!$B$3:$B$11,-1)))),(IF(L28>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L28,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[24,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L29=\"\",\"\",(IF(C29=\"F\",IF(L29>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L29,Feuil2!$B$3:$B$11,-1)))),(IF(L29>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L29,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[25,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L30=\"\",\"\",(IF(C30=\"F\",IF(L30>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L30,Feuil2!$B$3:$B$11,-1)))),(IF(L30>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L30,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[26,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L31=\"\",\"\",(IF(C31=\"F\",IF(L31>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L31,Feuil2!$B$3:$B$11,-1)))),(IF(L31>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L31,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[27,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L32=\"\",\"\",(IF(C32=\"F\",IF(L32>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L32,Feuil2!$B$3:$B$11,-1)))),(IF(L32>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L32,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[28,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L33=\"\",\"\",(IF(C33=\"F\",IF(L33>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L33,Feuil2!$B$3:$B$11,-1)))),(IF(L33>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L33,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[29,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L34=\"\",\"\",(IF(C34=\"F\",IF(L34>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L34,Feuil2!$B$3:$B$11,-1)))),(IF(L34>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L34,Feuil2!$C$3:$C$11,-1)))))))","v":""}]
[30,null,null,null,"",null,null,null,null,null,null,"",{"$f":"IF(L35=\"\",\"\",(IF(C35=\"F\",IF(L35>22.6,8,(INDEX(Feuil2!$D$3:$D$11,MATCH(L35,Feuil2!$B$3:$B$11,-1)))),(IF(L35>31,8,INDEX(Feuil2!$D$3:$D$11,MATCH(L35,Feuil2!$C$3:$C$11,-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(E7=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$6:$C$35,\"M\",$E$6:$E$35)))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[null,"filles","garçons","Note"]
[null,22.6,31,8,null,null,null,"Sauteur saccadé",null,"Juge dilettante"]
[null,21.3,29,7,null,null,null,0,null,0]
[null,20,27,6,null,null,null,0.5,null,0.5]
[null,18.7,25,5,null,null,null,1,null,1]
[null,17.399999999999999,23,4,null,null,null,1.5,null,1.5]
[null,16.100000000000001,21,3,null,null,null,2,null,"Juge fiable"]
[null,14.8,19,2,null,null,null,2.5,null,2]
[null,13.5,17,1,null,null,null,3,null,2.5]
[null,12.2,15,0,null,null,null,3.5,null,3]
[null,null,null,null,null,null,null,4,null,"Juge multifonctions"]
[null,null,null,null,null,null,null,"Sauteur coordonné",null,3.5]
[null,null,null,null,null,null,null,4.5,null,4]
[null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,"Sauteur fluide accélérateur"]
[null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,7.5]
[null,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":[]}