{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Carnet de notes"],"not_rendered":{"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Carnet de notes","index":0,"n_rows":57,"n_cols":33,"rows_kept":57,"merged":[[4,1,6,2],[8,3,8,6],[9,3,9,6],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2]]}
[]
[{"$nulls":3},"Moyenne",{"v":0,"d":"0%"},{"v":6,"d":"600%"},{"v":63,"d":"6300%"},{"v":67,"d":"6700%"},{"v":7,"d":"700%"},{"v":73,"d":"7300%"},{"v":77,"d":"7700%"},{"v":8,"d":"800%"},{"v":83,"d":"8300%"},{"v":87,"d":"8700%"},{"v":9,"d":"900%"},{"v":93,"d":"9300%"},{"v":97,"d":"9700%"}]
[{"$nulls":3},"Classement","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":3},"Moyenne pondérée de notes",1,67,100,133,167,200,233,267,300,333,367,400,400]
[null,"Nom de l'école"]
[{"$nulls":3},"Titre du devoir ou du test"]
[{"$nulls":3},"Points possibles"]
[null,"Nom de l'enseignant"]
[null,"Classe/Projet",null,"Nombre total de devoirs et de tests :",{"$nulls":3},{"$f":"COUNTA(G6:AG6)","v":0}]
[null,"Année/Semestre/Trimestre",null,"Total de points possibles :",{"$nulls":3},{"$f":"SUM(G7:AG7)","v":0}]
[]
[null,"Nom de l'élève","Numéro de l'élève","Moyenne","Classement","Moyenne pondérée de notes",{"$f":"IF(OR(G6,G6>\"\"),G6,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[{"$nulls":3},{"$f":"(IF(SUM(G13:AG13),ROUND(SUM(G13:AG13)/$H$10,2),\"\"))","v":""},{"$f":"IF(D13<>\"\",HLOOKUP(D13,GradeTable,2),\"\")","v":""},{"$f":"IF(D13<>\"\",HLOOKUP(D13,GradeTable,3),\"\")","v":""}]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[{"$nulls":3},"","",""]
[]
[null,"Synthèse de la classe",null,{"$f":"IF(OR(D12,D12>\"\"),D12,\"\")","v":"Moyenne"},"Classement","Moyenne pondérée de notes","","","","","","","","","","","",{"$nulls":8},{"$f":"IF(OR(Z12,Z12>\"\"),Z12,\"\")","v":""},"","","","","","",""]
[null," Moyenne",null,{"$f":"IF(SUM(D13:D52),AVERAGE(D13:D52),\"\")","v":""},{"$f":"IF(D55<>\"\",HLOOKUP(D55,GradeTable,2),\"\")","v":""},{"$f":"IF(SUM(F13:F52),AVERAGE(F13:F52),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null," Note la plus élevée",null,{"$f":"IF(SUM(D13:D52),MAX(D13:D52),\"\")","v":""},{"$f":"IF(D56<>\"\",HLOOKUP(D56,GradeTable,2),\"\")","v":""},{"$f":"IF(SUM(F13:F52),MAX(F13:F52),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null," Note la plus basse",null,{"$f":"IF(SUM(D13:D52),MIN(D13:D52),\"\")","v":""},{"$f":"IF(D57<>\"\",HLOOKUP(D57,GradeTable,2),\"\")","v":""},{"$f":"IF(SUM(F13:F52),MIN(F13:F52),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]