{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Evaluations","Recap EA-NA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Evaluations","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"compétence 1","compétence 2","compétence 3","compétence 4"]
["Elève 1","A","NA","NA","A"]
["Elève 2","A","EA","NA","EA"]
["Elève 3","NE","A","A","A"]
["Elève 4","EA","EA","EA","A"]

{"sheet":"Recap EA-NA","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"EA",null,null,null,"NA"]
["Elève 1",{"$f":"releve(A2,$B$1)","v":"/"},null,null,"Elève 1",{"$f":"releve(E2,$F$1)","v":0}]
["Elève 2",{"$f":"releve(A3,$B$1)","v":0},null,null,"Elève 2",{"$f":"releve(E3,$F$1)","v":0}]
["Elève 3",{"$f":"releve(A4,$B$1)","v":"/"},null,null,"Elève 3",{"$f":"releve(E4,$F$1)","v":"/"}]
["Elève 4",{"$f":"releve(A5,$B$1)","v":0},null,null,"Elève 4",{"$f":"releve(E5,$F$1)","v":"/"}]
[]
[]
[null,null,null,null,null,null,"Fonction personnalisée releve"]
[]
[null,null,null,null,null,null,"Syntaxe : =releve( élève; code évaluation cherché)"]
[]
[null,null,null,null,null,null,"Pour voir le code"]
[null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,"Clic droit sur l'onglet de la feuille puis Visualiser le code pour ouvrir l'éditeur VBA"]
[]
[null,null,null,null,null,null,"Allez dans Module 1 pour voir le code commenté de la fonction"]