{"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":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,4,2,5]]}
[null,null,"Fiche évaluation DNB",null,null,null,"APSA:",null,"Escalade"]
[null,"Classe/Groupe",null,null,null,"Professeur:",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,"C:\\Users\\GERARD HOLDER EPS\\Documents\\fiches compatibles pack EPS\\Nouveau dossier\\macros2\\Fiche évaluation DNB Escalade  .pdf"]
[null,"Nom- Prénom","Sexe","Classe","Note","Pertinence et efficacité du projet /5 points","Cotation des voies","Note cotation des voies /3 points","Efficacité du grimpeur/8 points","Efficacité dans le rôle de l'assureur/4 points"]
[1,null,null,null,{"$f":"IF(F5=\"\",\"\",F5+H5+I5+J5)","v":""},null,null,{"$f":"IF(G5=\"\",\"\",INDEX($O$5:$O$10,MATCH(G5,$N$5:$N$10,0)))","v":""},null,null,null,"Projet formel",null,"3c",0.5,null,"Le grimpeur tatonne",null,"Sécurité assurée"]
[2,null,null,null,{"$f":"IF(F6=\"\",\"\",F6+H6+I6+J6)","v":""},null,null,{"$f":"IF(G6=\"\",\"\",INDEX($O$5:$O$10,MATCH(G6,$N$5:$N$10,0)))","v":""},null,null,null,0,null,"4a",1,null,0,null,0]
[3,null,null,null,"",null,null,"",null,null,null,0.5,null,"4b",1.5,null,0.5,null,0.5]
[4,null,null,null,"",null,null,"",null,null,null,1,null,"4c",2,null,1,null,1]
[5,null,null,null,"",null,null,"",null,null,null,1.5,null,"5a",2.5,null,1.5,null,1.5]
[6,null,null,null,"",null,null,"",null,null,null,2,null,"5b",3,null,2,null,"Sécurité maîtisée"]
[7,null,null,null,"",null,null,"",null,null,null,"Projet réfléchi",null,null,null,null,2.5,null,2]
[8,null,null,null,"",null,null,"",null,null,null,2.5,null,null,null,null,3,null,2.5]
[9,null,null,null,"",null,null,"",null,null,null,3,null,null,null,null,3.5,null,3]
[10,null,null,null,"",null,null,"",null,null,null,3.5,null,null,null,null,4,null,"Sécurité optimale"]
[11,null,null,null,"",null,null,"",null,null,null,"Projet réalisé",null,null,null,null,"Le grimpeur enchaîne",null,3.5]
[12,null,null,null,"",null,null,"",null,null,null,4,null,null,null,null,4.5,null,4]
[13,null,null,null,"",null,null,"",null,null,null,4.5,null,null,null,null,5]
[14,null,null,null,"",null,null,"",null,null,null,5,null,null,null,null,5.5]
[15,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,6]
[16,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,"Le grimpeur anticipe"]
[17,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,6.5]
[18,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,7]
[19,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,7.5]
[20,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,8]
[21,null,null,null,"",null,null,""]
[22,null,null,null,"",null,null,""]
[23,null,null,null,"",null,null,""]
[24,null,null,null,"",null,null,""]
[25,null,null,null,"",null,null,""]
[26,null,null,null,"",null,null,""]
[27,null,null,null,"",null,null,""]
[28,null,null,null,"",null,null,""]
[29,null,null,null,"",null,null,""]
[30,null,null,null,"",null,null,""]
[null,null,null,"Moyenne générale",{"$f":"IF(E5=\"\",\"\",AVERAGE($E$6:$E$35))","v":""}]
[null,null,null,"Moyenne filles",{"$f":"IF(E5=\"\",\"\",IF(C5=\"\",\"\",AVERAGEIF($C$6:$C$35,\"F\",$E$6:$E$35)))","v":""}]
[null,null,null,"Moyenne garçons",{"$f":"IF(E6=\"\",\"\",IF(C5=\"\",\"\",AVERAGEIF($C$6:$C$35,\"M\",$E$6:$E$35)))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Projet formel",null,null,"Le kayakiste subit les éléments naturels",null,null,null,"Sécurité respectée"]
[null,0,null,null,0,null,null,null,0]
[null,0.5,null,null,0.5,null,null,null,0.5]
[null,1,null,null,1,null,null,null,1]
[null,1.5,null,null,1.5,null,null,null,1.5]
[null,2,null,null,2,null,null,null,"Sécurité assurée"]
[null,2.5,null,null,2.5,null,null,null,2]
[null,3,null,null,3,null,null,null,2.5]
[null,3.5,null,null,3.5,null,null,null,3]
[null,4,null,null,4,null,null,null,"Sécurité optimale"]
[null,"Projet réfléchi",null,null,"Le kayakiste maîtrise son bateau",null,null,null,3.5]
[null,4.5,null,null,4.5,null,null,null,4]
[null,5,null,null,5]
[null,5.5,null,null,5.5]
[null,6,null,null,6]
[null,"Projet réalisé",null,null,"Le kayakiste est maître de son parcours"]
[null,6.5,null,null,6.5]
[null,7,null,null,7]
[null,7.5,null,null,7.5]
[null,8,null,null,8]

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