{"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":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"Fiche évaluation DNB",null,null,null,null,null,null,null,"APSA:",null,"Saut en hauteur"]
[null,"Classe/Groupe",null,null,null,null,null,"Professeur:",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"]
[null,null,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 Saut en hauteur  .pdf"]
[null,"Nom- Prénom","Sexe","Classe","Note","Essai 1","Essai 2","Essai 3","Essai 4","Essai 5","Essai 6","Essai 7","Essai 8","Performance retenue (addition du premier saut et du meilleur saut)","Note de performance / 8 points","Efficacité lors de la course d’élan et du franchissement /8 points","Efficacité dans les rôles d'observateur et de juge /4 points",null,null,"Sauteur saccadé",null,null,"Juge dilettante"]
[1,null,null,null,{"$f":"IF(O5=\"\",\"\",O5+P5+Q5)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(F5=\"\",\"\",(F5+MAX(G5:M5)))","v":""},{"$f":"IF(N5=\"\",\"\",IF(Sexe1=\"F\",IF(N5>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N5,Feuil2!$B$2:$B$10,-1))),IF(N5>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N5,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,0,null,null,0]
[2,null,null,null,{"$f":"IF(O6=\"\",\"\",O6+P6+Q6)","v":""},null,null,null,null,null,null,null,null,"",{"$f":"IF(N6=\"\",\"\",IF(Sexe1=\"F\",IF(N6>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N6,Feuil2!$B$2:$B$10,-1))),IF(N6>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N6,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,0.5,null,null,0.5]
[3,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N7=\"\",\"\",IF(Sexe1=\"F\",IF(N7>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N7,Feuil2!$B$2:$B$10,-1))),IF(N7>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N7,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,1,null,null,1]
[4,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N8=\"\",\"\",IF(Sexe1=\"F\",IF(N8>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N8,Feuil2!$B$2:$B$10,-1))),IF(N8>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N8,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,1.5,null,null,1.5]
[5,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N9=\"\",\"\",IF(Sexe1=\"F\",IF(N9>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N9,Feuil2!$B$2:$B$10,-1))),IF(N9>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N9,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,2,null,null,"Juge fiable"]
[6,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N10=\"\",\"\",IF(Sexe1=\"F\",IF(N10>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N10,Feuil2!$B$2:$B$10,-1))),IF(N10>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N10,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,"Sauteur coordonné",null,null,2]
[7,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N11=\"\",\"\",IF(Sexe1=\"F\",IF(N11>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N11,Feuil2!$B$2:$B$10,-1))),IF(N11>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N11,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,4.5,null,null,2.5]
[8,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N12=\"\",\"\",IF(Sexe1=\"F\",IF(N12>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N12,Feuil2!$B$2:$B$10,-1))),IF(N12>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N12,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,5,null,null,3]
[9,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N13=\"\",\"\",IF(Sexe1=\"F\",IF(N13>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N13,Feuil2!$B$2:$B$10,-1))),IF(N13>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N13,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,5.5,null,null,"Juge multifonctions"]
[10,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N14=\"\",\"\",IF(Sexe1=\"F\",IF(N14>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N14,Feuil2!$B$2:$B$10,-1))),IF(N14>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N14,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,6,null,null,3.5]
[11,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N15=\"\",\"\",IF(Sexe1=\"F\",IF(N15>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N15,Feuil2!$B$2:$B$10,-1))),IF(N15>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N15,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,"Sauteur fluide et constant",null,null,4]
[12,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N16=\"\",\"\",IF(Sexe1=\"F\",IF(N16>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N16,Feuil2!$B$2:$B$10,-1))),IF(N16>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N16,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,6.5]
[13,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N17=\"\",\"\",IF(Sexe1=\"F\",IF(N17>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N17,Feuil2!$B$2:$B$10,-1))),IF(N17>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N17,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,7]
[14,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N18=\"\",\"\",IF(Sexe1=\"F\",IF(N18>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N18,Feuil2!$B$2:$B$10,-1))),IF(N18>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N18,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,7.5]
[15,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N19=\"\",\"\",IF(Sexe1=\"F\",IF(N19>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N19,Feuil2!$B$2:$B$10,-1))),IF(N19>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N19,Feuil2!$C$2:$C$10,-1)))))","v":""},null,null,null,null,8]
[16,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N20=\"\",\"\",IF(Sexe1=\"F\",IF(N20>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N20,Feuil2!$B$2:$B$10,-1))),IF(N20>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N20,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[17,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N21=\"\",\"\",IF(Sexe1=\"F\",IF(N21>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N21,Feuil2!$B$2:$B$10,-1))),IF(N21>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N21,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[18,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N22=\"\",\"\",IF(Sexe1=\"F\",IF(N22>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N22,Feuil2!$B$2:$B$10,-1))),IF(N22>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N22,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[19,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N23=\"\",\"\",IF(Sexe1=\"F\",IF(N23>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N23,Feuil2!$B$2:$B$10,-1))),IF(N23>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N23,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[20,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N24=\"\",\"\",IF(Sexe1=\"F\",IF(N24>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N24,Feuil2!$B$2:$B$10,-1))),IF(N24>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N24,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[21,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N25=\"\",\"\",IF(Sexe1=\"F\",IF(N25>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N25,Feuil2!$B$2:$B$10,-1))),IF(N25>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N25,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[22,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N26=\"\",\"\",IF(Sexe1=\"F\",IF(N26>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N26,Feuil2!$B$2:$B$10,-1))),IF(N26>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N26,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[23,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N27=\"\",\"\",IF(Sexe1=\"F\",IF(N27>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N27,Feuil2!$B$2:$B$10,-1))),IF(N27>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N27,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[24,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N28=\"\",\"\",IF(Sexe1=\"F\",IF(N28>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N28,Feuil2!$B$2:$B$10,-1))),IF(N28>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N28,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[25,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N29=\"\",\"\",IF(Sexe1=\"F\",IF(N29>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N29,Feuil2!$B$2:$B$10,-1))),IF(N29>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N29,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[26,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N30=\"\",\"\",IF(Sexe1=\"F\",IF(N30>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N30,Feuil2!$B$2:$B$10,-1))),IF(N30>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N30,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[27,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N31=\"\",\"\",IF(Sexe1=\"F\",IF(N31>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N31,Feuil2!$B$2:$B$10,-1))),IF(N31>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N31,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[28,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N32=\"\",\"\",IF(Sexe1=\"F\",IF(N32>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N32,Feuil2!$B$2:$B$10,-1))),IF(N32>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N32,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[29,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N33=\"\",\"\",IF(Sexe1=\"F\",IF(N33>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N33,Feuil2!$B$2:$B$10,-1))),IF(N33>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N33,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[30,null,null,null,"",null,null,null,null,null,null,null,null,"",{"$f":"IF(N34=\"\",\"\",IF(Sexe1=\"F\",IF(N34>Feuil2!$B$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(Feuil1!N34,Feuil2!$B$2:$B$10,-1))),IF(N34>Feuil2!$C$2,8,INDEX(Feuil2!$D$2:$D$10,MATCH(N34,Feuil2!$C$2:$C$10,-1)))))","v":""}]
[null,null,null,"Moyenne générale",{"$f":"IF(E5=\"\",\"\",AVERAGE($E$5:$E$34))","v":""}]
[null,null,null,"Moyenne filles",{"$f":"IF(E5=\"\",\"\",IF(C5=\"\",\"\",AVERAGEIF($C$5:$C$34,\"F\",$E$5:$E$34)))","v":""}]
[null,null,null,"Moyenne garçons",{"$f":"IF(E6=\"\",\"\",IF(C6=\"\",\"\",AVERAGEIF($C$5:$C$34,\"M\",$E$5:$E$34)))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"filles","garçons","Note"]
[null,2.4,2.9,8,null,null,"Sauteur saccadé",null,null,"Juge dilettante"]
[null,2.2999999999999998,2.75,7,null,null,0,null,null,0]
[null,2.2000000000000002,2.6,6,null,null,0.5,null,null,0.5]
[null,2.1,2.4500000000000002,5,null,null,1,null,null,1]
[null,2,2.2999999999999998,4,null,null,1.5,null,null,1.5]
[null,1.9,2.15,3,null,null,2,null,null,"Juge fiable"]
[null,1.8,2,2,null,null,"Sauteur coordonné",null,null,2]
[null,1.7,1.9,1,null,null,4.5,null,null,2.5]
[null,1.6,1.8,0,null,null,5,null,null,3]
[null,null,null,null,null,null,5.5,null,null,"Juge multifonctions"]
[null,null,null,null,null,null,6,null,null,3.5]
[null,null,null,null,null,null,"Sauteur fluide et constant",null,null,4]
[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":[]}