{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instruction","Grille-classe","Recap-classe"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":51,"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":"Instruction","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Saisie des noms et prénoms des élèves"]
["Vous avez à disposition une grille d'évaluation avec 30 élèves. ",null,null,null,"Utilisation du mode plan pour personnaliser les affichages"]
[null,null,null,null,"afficher les colonnes au niveau 1 : afficher les résultats de la classe"]
["Commencez par compléter les noms et prénom des élèves dans la  feuille  Recap-classe",null,null,null,"afficher les colonnes au niveau 2 : afficher les points et les commentaires"]
["> vous avez plus de 30 élèves ? Vous avez besoin de 2 fichiers. A vous de dupliquer le fichier",null,null,null,"afficher les lignes au niveau 1, mais masquer certains niveaux"]
["> vous avez moins de 30 élèves ? Laisser simplement les nom et prénom \"vides\" dans la feuille Grille-Classe"]
["Saisie des résultats puis impression par élève",null,null,null,"cliquez sur les flèches pour déclencher l'affichage souhaitée:"]
["Les différents options d'affichage vous permettent de vous partager le travail de correction par tâche",null,null,null,"Affichages à disposition"]
["Pour chaque tâche, il est possible de saisir les points et commentaires par élève dans la feuille Grille-classe",null,null,null,"une page par élève (nommer fichiers - toutes tâches)"]
["L'impression reflètera l'affichage que vous avez choisi.",null,null,null,"une page par élève - tache PréAO"]
[null,null,null,null,"une page par élève - tache TABLEUR"]
["Pour changer de tâche, vous pouvez utiliser les flèches ci-contre, la liste déroulante de la feuille Grille-Classe",null,null,null,"une page par élève - tache TRAITEMENT DE TEXTE"]
["ou le menu Affichage > Affichage personnalisé, choisir une des options pré-enregistrées",null,null,null,"une page par élève - tache COMMUNICATION"]
[null,null,null,null,"une page par élève - tache Gérer des dossiers et des fichiers"]
[null,null,null,null,"les résultats de la classe"]
["Travail collaboratif (plusieurs correcteurs)"]
["Il est possible de partager le fichier excel si vous êtes plusieurs à corriger la même classe (révision > partager le classeur)"]
["Vous pouvez également faire les corrections de manière individuelle et ensuite consolider (copier/coller)"]
[]
["Impression des résultats"]
["Vous pouvez  imprimer la feuille Recap-classe."]
["Si vous souhaitez des impressions par élève, utilier les affichages prédéfinis de la feuille Grille-Classe, "]
["puis imprimez. Vous obtenez 6 pages par élève (impression avec 1 page par tâche)"]
["Si vous souhaitez n'imprimer qu'une seule des tâches pour tous vos élèves, utilisez simplement l'affichage approprié,"]
["puis imprimez avec le bouton impression tâche(s)."]
[]
["Le classeur tout comme les feuilles ne peuvent pas être protégés pour des raisons techniques."]

{"sheet":"Grille-classe","index":1,"n_rows":89,"n_cols":66,"rows_kept":89,"cut":false,"hidden":false,"merged":[[54,0,54,5],[55,1,55,5],[63,3,63,5],[65,0,65,5],[66,1,66,5],[23,58,23,59],[23,60,23,61],[23,62,23,63],[26,1,26,5],[23,46,23,47],[23,48,23,49],[23,50,23,51],[23,52,23,53],[23,54,23,55],[23,56,23,57],[23,34,23,35],[23,36,23,37],[23,38,23,39],[23,40,23,41],[23,42,23,43],[23,44,23,45],[23,22,23,23],[23,24,23,25],[23,26,23,27],[22,54,22,55],[22,56,22,57],[22,58,22,59],[22,60,22,61],[23,28,23,29],[23,30,23,31],[23,32,23,33],[22,42,22,43],[22,44,22,45],[22,46,22,47],[22,48,22,49],[22,50,22,51],[22,28,22,29],[22,30,22,31],[22,34,22,35],[22,36,22,37],[20,44,20,45],[20,22,20,23],[20,24,20,25],[22,32,22,33],[23,64,23,65],[25,0,25,5],[22,38,22,39],[22,16,22,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[22,24,22,25],[22,26,22,27],[22,64,22,65],[23,1,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[22,52,22,53],[20,58,20,59],[20,60,20,61],[20,62,20,63],[19,38,19,39],[22,62,22,63],[22,40,22,41],[20,64,20,65],[22,0,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[20,46,20,47],[20,48,20,49],[20,50,20,51],[20,52,20,53],[20,54,20,55],[20,56,20,57],[20,34,20,35],[20,36,20,37],[20,38,20,39],[20,40,20,41],[20,42,20,43],[20,1,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[20,20,20,21],[19,16,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,26,19,27],[20,26,20,27],[20,28,20,29],[20,30,20,31],[20,32,20,33],[19,12,19,13],[19,14,19,15],[17,54,17,55],[17,56,17,57],[17,58,17,59],[17,30,17,31],[17,32,17,33],[17,34,17,35],[17,36,17,37],[17,38,17,39],[17,40,17,41],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25],[17,26,17,27],[17,28,17,29],[19,48,19,49],[19,50,19,51],[19,28,19,29],[19,30,19,31],[19,32,19,33],[19,34,19,35],[19,36,19,37],[17,60,17,61],[17,62,17,63],[17,64,17,65],[17,42,17,43],[17,44,17,45],[17,46,17,47],[17,48,17,49],[17,50,17,51],[17,52,17,53],[19,64,19,65],[19,52,19,53],[19,54,19,55],[19,56,19,57],[19,58,19,59],[19,60,19,61],[19,62,19,63],[19,40,19,41],[19,42,19,43],[19,44,19,45],[19,46,19,47],[16,60,16,61],[16,62,16,63],[16,64,16,65],[17,1,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[16,48,16,49],[16,50,16,51],[16,52,16,53],[16,54,16,55],[16,56,16,57],[16,58,16,59],[16,36,16,37],[16,38,16,39],[16,40,16,41],[16,42,16,43],[16,44,16,45],[16,46,16,47],[16,24,16,25],[16,26,16,27],[16,28,16,29],[16,30,16,31],[16,32,16,33],[16,34,16,35],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[16,22,16,23],[84,0,84,5],[85,1,85,5],[88,3,88,5],[13,0,13,5],[14,0,14,5],[16,0,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[19,0,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[29,3,29,5],[31,0,31,5],[32,1,32,5],[40,3,40,5],[42,0,42,5],[43,1,43,5],[71,3,71,5],[73,0,73,5],[74,1,74,5],[82,3,82,5],[52,3,52,5]]}
[null,1,1,null,null,null,{"$f":"'Recap-classe'!B10&\"\"","v":"Eleve 1"},null,{"$f":"'Recap-classe'!B11&\"\"","v":"Eleve 2"},null,{"$f":"'Recap-classe'!B12&\"\"","v":"Eleve 3"},null,{"$f":"'Recap-classe'!B13&\"\"","v":""},null,{"$f":"'Recap-classe'!B14&\"\"","v":""},null,{"$f":"'Recap-classe'!B15&\"\"","v":""},null,{"$f":"'Recap-classe'!B16&\"\"","v":""},null,{"$f":"'Recap-classe'!B17&\"\"","v":""},null,{"$f":"'Recap-classe'!B18&\"\"","v":""},null,{"$f":"'Recap-classe'!B19&\"\"","v":""},null,{"$f":"'Recap-classe'!B20&\"\"","v":""},null,{"$f":"'Recap-classe'!B21&\"\"","v":""},null,{"$f":"'Recap-classe'!B22&\"\"","v":""},null,{"$f":"'Recap-classe'!B23&\"\"","v":""},null,{"$f":"'Recap-classe'!B24&\"\"","v":""},null,{"$f":"'Recap-classe'!B25&\"\"","v":""},null,{"$f":"'Recap-classe'!B26&\"\"","v":""},null,{"$f":"'Recap-classe'!B27&\"\"","v":""},null,{"$f":"'Recap-classe'!B28&\"\"","v":""},null,{"$f":"'Recap-classe'!B29&\"\"","v":""},null,{"$f":"'Recap-classe'!B30&\"\"","v":""},null,{"$f":"'Recap-classe'!B31&\"\"","v":""},null,{"$f":"'Recap-classe'!B32&\"\"","v":""},null,{"$f":"'Recap-classe'!B33&\"\"","v":""},null,{"$f":"'Recap-classe'!B34&\"\"","v":""},null,{"$f":"'Recap-classe'!B35&\"\"","v":""},null,{"$f":"'Recap-classe'!B36&\"\"","v":""},null,{"$f":"'Recap-classe'!B37&\"\"","v":""},null,{"$f":"'Recap-classe'!B38&\"\"","v":""},null,{"$f":"'Recap-classe'!B39&\"\"","v":""}]
[null,null,null,null,null,null,{"$f":"'Recap-classe'!C10&\"\"","v":"Prenom 1"},null,{"$f":"'Recap-classe'!C11&\"\"","v":"Prénom 2"},null,{"$f":"'Recap-classe'!C12&\"\"","v":"Prénom 3"},null,{"$f":"'Recap-classe'!C13&\"\"","v":""},null,{"$f":"'Recap-classe'!C14&\"\"","v":""},null,{"$f":"'Recap-classe'!C15&\"\"","v":""},null,{"$f":"'Recap-classe'!C16&\"\"","v":""},null,{"$f":"'Recap-classe'!C17&\"\"","v":""},null,{"$f":"'Recap-classe'!C18&\"\"","v":""},null,{"$f":"'Recap-classe'!C19&\"\"","v":""},null,{"$f":"'Recap-classe'!C20&\"\"","v":""},null,{"$f":"'Recap-classe'!C21&\"\"","v":""},null,{"$f":"'Recap-classe'!C22&\"\"","v":""},null,{"$f":"'Recap-classe'!C23&\"\"","v":""},null,{"$f":"'Recap-classe'!C24&\"\"","v":""},null,{"$f":"'Recap-classe'!C25&\"\"","v":""},null,{"$f":"'Recap-classe'!C26&\"\"","v":""},null,{"$f":"'Recap-classe'!C27&\"\"","v":""},null,{"$f":"'Recap-classe'!C28&\"\"","v":""},null,{"$f":"'Recap-classe'!C29&\"\"","v":""},null,{"$f":"'Recap-classe'!C30&\"\"","v":""},null,{"$f":"'Recap-classe'!C31&\"\"","v":""},null,{"$f":"'Recap-classe'!C32&\"\"","v":""},null,{"$f":"'Recap-classe'!C33&\"\"","v":""},null,{"$f":"'Recap-classe'!C34&\"\"","v":""},null,{"$f":"'Recap-classe'!C35&\"\"","v":""},null,{"$f":"'Recap-classe'!C36&\"\"","v":""},null,{"$f":"'Recap-classe'!C37&\"\"","v":""},null,{"$f":"'Recap-classe'!C38&\"\"","v":""},null,{"$f":"'Recap-classe'!C39&\"\"","v":""}]
[null,null,null,null,null,null,1,1.5,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30]
[null,null,null,null,null,"Points maximum","Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus"]
["Tâche Nommer les fichiers",null,null,null,null,{"$f":"B30","v":4},{"$f":"G30","v":0},null,{"$f":"I30","v":0},null,{"$f":"K30","v":0},null,{"$f":"M30","v":0},null,{"$f":"O30","v":0},null,{"$f":"Q30","v":0},null,{"$f":"S30","v":0},null,{"$f":"U30","v":0},null,{"$f":"W30","v":0},null,{"$f":"Y30","v":0},null,{"$f":"AA30","v":0},null,{"$f":"AC30","v":0},null,{"$f":"AE30","v":0},null,{"$f":"AG30","v":0},null,{"$f":"AI30","v":0},null,{"$f":"AK30","v":0},null,{"$f":"AM30","v":0},null,{"$f":"AO30","v":0},null,{"$f":"AQ30","v":0},null,{"$f":"AS30","v":0},null,{"$f":"AU30","v":0},null,{"$f":"AW30","v":0},null,{"$f":"AY30","v":0},null,{"$f":"BA30","v":0},null,{"$f":"BC30","v":0},null,{"$f":"BE30","v":0},null,{"$f":"BG30","v":0},null,{"$f":"BI30","v":0},null,{"$f":"BK30","v":0},null,{"$f":"BM30","v":0}]
["Tâche PréAO",null,null,null,null,{"$f":"B41","v":24},{"$f":"G41","v":0},null,{"$f":"I41","v":0},null,{"$f":"K41","v":0},null,{"$f":"M41","v":0},null,{"$f":"O41","v":0},null,{"$f":"Q41","v":0},null,{"$f":"S41","v":0},null,{"$f":"U41","v":0},null,{"$f":"W41","v":0},null,{"$f":"Y41","v":0},null,{"$f":"AA41","v":0},null,{"$f":"AC41","v":0},null,{"$f":"AE41","v":0},null,{"$f":"AG41","v":0},null,{"$f":"AI41","v":0},null,{"$f":"AK41","v":0},null,{"$f":"AM41","v":0},null,{"$f":"AO41","v":0},null,{"$f":"AQ41","v":0},null,{"$f":"AS41","v":0},null,{"$f":"AU41","v":0},null,{"$f":"AW41","v":0},null,{"$f":"AY41","v":0},null,{"$f":"BA41","v":0},null,{"$f":"BC41","v":0},null,{"$f":"BE41","v":0},null,{"$f":"BG41","v":0},null,{"$f":"BI41","v":0},null,{"$f":"BK41","v":0},null,{"$f":"BM41","v":0}]
["Tâche TABLEUR",null,null,null,null,{"$f":"B53","v":28},{"$f":"G53","v":0},null,{"$f":"I53","v":0},null,{"$f":"K53","v":0},null,{"$f":"M53","v":0},null,{"$f":"O53","v":0},null,{"$f":"Q53","v":0},null,{"$f":"S53","v":0},null,{"$f":"U53","v":0},null,{"$f":"W53","v":0},null,{"$f":"Y53","v":0},null,{"$f":"AA53","v":0},null,{"$f":"AC53","v":0},null,{"$f":"AE53","v":0},null,{"$f":"AG53","v":0},null,{"$f":"AI53","v":0},null,{"$f":"AK53","v":0},null,{"$f":"AM53","v":0},null,{"$f":"AO53","v":0},null,{"$f":"AQ53","v":0},null,{"$f":"AS53","v":0},null,{"$f":"AU53","v":0},null,{"$f":"AW53","v":0},null,{"$f":"AY53","v":0},null,{"$f":"BA53","v":0},null,{"$f":"BC53","v":0},null,{"$f":"BE53","v":0},null,{"$f":"BG53","v":0},null,{"$f":"BI53","v":0},null,{"$f":"BK53","v":0},null,{"$f":"BM53","v":0}]
["Tâche TRAITEMENT DE TEXTE: Préparer une brochure",null,null,null,null,{"$f":"B64","v":24},{"$f":"G64","v":0},null,{"$f":"I64","v":0},null,{"$f":"K64","v":0},null,{"$f":"M64","v":0},null,{"$f":"O64","v":0},null,{"$f":"Q64","v":0},null,{"$f":"S64","v":0},null,{"$f":"U64","v":0},null,{"$f":"W64","v":0},null,{"$f":"Y64","v":0},null,{"$f":"AA64","v":0},null,{"$f":"AC64","v":0},null,{"$f":"AE64","v":0},null,{"$f":"AG64","v":0},null,{"$f":"AI64","v":0},null,{"$f":"AK64","v":0},null,{"$f":"AM64","v":0},null,{"$f":"AO64","v":0},null,{"$f":"AQ64","v":0},null,{"$f":"AS64","v":0},null,{"$f":"AU64","v":0},null,{"$f":"AW64","v":0},null,{"$f":"AY64","v":0},null,{"$f":"BA64","v":0},null,{"$f":"BC64","v":0},null,{"$f":"BE64","v":0},null,{"$f":"BG64","v":0},null,{"$f":"BI64","v":0},null,{"$f":"BK64","v":0},null,{"$f":"BM64","v":0}]
["Tâche TRAITEMENT DE TEXTE: Terminer un formulaire",null,null,null,null,{"$f":"B72","v":12},{"$f":"G72","v":0},null,{"$f":"I72","v":0},null,{"$f":"K72","v":0},null,{"$f":"M72","v":0},null,{"$f":"O72","v":0},null,{"$f":"Q72","v":0},null,{"$f":"S72","v":0},null,{"$f":"U72","v":0},null,{"$f":"W72","v":0},null,{"$f":"Y72","v":0},null,{"$f":"AA72","v":0},null,{"$f":"AC72","v":0},null,{"$f":"AE72","v":0},null,{"$f":"AG72","v":0},null,{"$f":"AI72","v":0},null,{"$f":"AK72","v":0},null,{"$f":"AM72","v":0},null,{"$f":"AO72","v":0},null,{"$f":"AQ72","v":0},null,{"$f":"AS72","v":0},null,{"$f":"AU72","v":0},null,{"$f":"AW72","v":0},null,{"$f":"AY72","v":0},null,{"$f":"BA72","v":0},null,{"$f":"BC72","v":0},null,{"$f":"BE72","v":0},null,{"$f":"BG72","v":0},null,{"$f":"BI72","v":0},null,{"$f":"BK72","v":0},null,{"$f":"BM72","v":0}]
["Tâche COMMUNICATION : Rédiger une demande d'offre",null,null,null,null,{"$f":"B83","v":24},{"$f":"G83","v":0},null,{"$f":"I83","v":0},null,{"$f":"K83","v":0},null,{"$f":"M83","v":0},null,{"$f":"O83","v":0},null,{"$f":"Q83","v":0},null,{"$f":"S83","v":0},null,{"$f":"U83","v":0},null,{"$f":"W83","v":0},null,{"$f":"Y83","v":0},null,{"$f":"AA83","v":0},null,{"$f":"AC83","v":0},null,{"$f":"AE83","v":0},null,{"$f":"AG83","v":0},null,{"$f":"AI83","v":0},null,{"$f":"AK83","v":0},null,{"$f":"AM83","v":0},null,{"$f":"AO83","v":0},null,{"$f":"AQ83","v":0},null,{"$f":"AS83","v":0},null,{"$f":"AU83","v":0},null,{"$f":"AW83","v":0},null,{"$f":"AY83","v":0},null,{"$f":"BA83","v":0},null,{"$f":"BC83","v":0},null,{"$f":"BE83","v":0},null,{"$f":"BG83","v":0},null,{"$f":"BI83","v":0},null,{"$f":"BK83","v":0},null,{"$f":"BM83","v":0}]
["Tâche Gérer des dossiers et des fichiers",null,null,null,null,{"$f":"B89","v":4},{"$f":"G89","v":0},null,{"$f":"I88","v":0},null,{"$f":"K88","v":0},null,{"$f":"M88","v":0},null,{"$f":"O88","v":0},null,{"$f":"Q88","v":0},null,{"$f":"S88","v":0},null,{"$f":"U88","v":0},null,{"$f":"W88","v":0},null,{"$f":"Y88","v":0},null,{"$f":"AA88","v":0},null,{"$f":"AC88","v":0},null,{"$f":"AE88","v":0},null,{"$f":"AG88","v":0},null,{"$f":"AI88","v":0},null,{"$f":"AK88","v":0},null,{"$f":"AM88","v":0},null,{"$f":"AO88","v":0},null,{"$f":"AQ88","v":0},null,{"$f":"AS88","v":0},null,{"$f":"AU88","v":0},null,{"$f":"AW88","v":0},null,{"$f":"AY88","v":0},null,{"$f":"BA88","v":0},null,{"$f":"BC88","v":0},null,{"$f":"BE88","v":0},null,{"$f":"BG88","v":0},null,{"$f":"BI88","v":0},null,{"$f":"BK88","v":0},null,{"$f":"BM88","v":0}]
[null,null,null,null,null,{"$f":"SUM(F5:F11)","v":120},{"$f":"SUM(G5:G11)","v":0},null,{"$f":"SUM(I5:I11)","v":0},null,{"$f":"SUM(K5:K11)","v":0},null,{"$f":"SUM(M5:M11)","v":0},null,{"$f":"SUM(O5:O11)","v":0},null,{"$f":"SUM(Q5:Q11)","v":0},null,{"$f":"SUM(S5:S11)","v":0},null,{"$f":"SUM(U5:U11)","v":0},null,{"$f":"SUM(W5:W11)","v":0},null,{"$f":"SUM(Y5:Y11)","v":0},null,{"$f":"SUM(AA5:AA11)","v":0},null,{"$f":"SUM(AC5:AC11)","v":0},null,{"$f":"SUM(AE5:AE11)","v":0},null,{"$f":"SUM(AG5:AG11)","v":0},null,{"$f":"SUM(AI5:AJ11)","v":0},null,{"$f":"SUM(AK5:AK11)","v":0},null,{"$f":"SUM(AM5:AM11)","v":0},null,{"$f":"SUM(AO5:AO11)","v":0},null,{"$f":"SUM(AQ5:AQ11)","v":0},null,{"$f":"SUM(AS5:AS11)","v":0},null,{"$f":"SUM(AU5:AU11)","v":0},null,{"$f":"SUM(AW5:AW11)","v":0},null,{"$f":"SUM(AY5:AY11)","v":0},null,{"$f":"SUM(BA5:BA11)","v":0},null,{"$f":"SUM(BC5:BC11)","v":0},null,{"$f":"SUM(BE5:BE11)","v":0},null,{"$f":"SUM(BG5:BG11)","v":0},null,{"$f":"SUM(BI5:BI11)","v":0},null,{"$f":"SUM(BK5:BK11)","v":0},null,{"$f":"SUM(BM5:BM11)","v":0}]
[]
["Total des points attribués",null,null,null,null,null,{"$f":"ROUNDUP(G12,0)","v":0},null,{"$f":"ROUNDUP(I12,0)","v":0},null,{"$f":"ROUNDUP(K12,0)","v":0},null,{"$f":"ROUNDUP(M12,0)","v":0},null,{"$f":"ROUNDUP(O12,0)","v":0},null,{"$f":"ROUNDUP(Q12,0)","v":0},null,{"$f":"ROUNDUP(S12,0)","v":0},null,{"$f":"ROUNDUP(U12,0)","v":0},null,{"$f":"ROUNDUP(W12,0)","v":0},null,{"$f":"ROUNDUP(Y12,0)","v":0},null,{"$f":"ROUNDUP(AA12,0)","v":0},null,{"$f":"ROUNDUP(AC12,0)","v":0},null,{"$f":"ROUNDUP(AE12,0)","v":0},null,{"$f":"ROUNDUP(AG12,0)","v":0},null,{"$f":"ROUNDUP(AI12,0)","v":0},null,{"$f":"ROUNDUP(AK12,0)","v":0},null,{"$f":"ROUNDUP(AM12,0)","v":0},null,{"$f":"ROUNDUP(AO12,0)","v":0},null,{"$f":"ROUNDUP(AQ12,0)","v":0},null,{"$f":"ROUNDUP(AS12,0)","v":0},null,{"$f":"ROUNDUP(AU12,0)","v":0},null,{"$f":"ROUNDUP(AW12,0)","v":0},null,{"$f":"ROUNDUP(AY12,0)","v":0},null,{"$f":"ROUNDUP(BA12,0)","v":0},null,{"$f":"ROUNDUP(BC12,0)","v":0},null,{"$f":"ROUNDUP(BE12,0)","v":0},null,{"$f":"ROUNDUP(BG12,0)","v":0},null,{"$f":"ROUNDUP(BI12,0)","v":0},null,{"$f":"ROUNDUP(BK12,0)","v":0},null,{"$f":"ROUNDUP(BM12,0)","v":0}]
["Note attribuée",null,null,null,null,null,{"$f":"ROUND((G12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((I12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((K12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((M12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((O12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((Q12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((S12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((U12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((W12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((Y12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AA12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AC12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AE12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AG12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AI12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AK12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AM12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AO12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AQ12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AS12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AU12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AW12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AY12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BA12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BC12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BE12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BG12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BI12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BK12/$F$12*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BM12/$F$12*5+1)*2,0)/2","v":1}]
[]
["Remarques générales",null,null,null,null,null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève"]
[]
[]
["Enseignant-examinateur (nom prénom date et signature): ",null,null,null,null,null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)"]
[]
[]
["2e expert (nom prénom date et signature): ",null,null,null,null,null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)",null,"2e expert pour cet élève (si différent)"]
[]
[]
[{"$f":"\"Grille de correction - \" &A5","v":"Grille de correction - Tâche Nommer les fichiers"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Tous les fichiers rendus doivent être nommés selon les indications figurant à la fin de chaque tâche. ",4,3,2,1,0]
[{"$f":"A$5&\" - Points max\"","v":"Tâche Nommer les fichiers - Points max"},{"$f":"SUM(B29:B29)","v":4},null,"Points obtenus",null,null,{"$f":"SUM(G29:G29)","v":0},null,{"$f":"SUM(I29:I29)","v":0},null,{"$f":"SUM(K29:K29)","v":0},null,{"$f":"SUM(M29:M29)","v":0},null,{"$f":"SUM(O29:O29)","v":0},null,{"$f":"SUM(Q29:Q29)","v":0},null,{"$f":"SUM(S29:S29)","v":0},null,{"$f":"SUM(U29:U29)","v":0},null,{"$f":"SUM(W29:W29)","v":0},null,{"$f":"SUM(Y29:Y29)","v":0},null,{"$f":"SUM(AA29:AA29)","v":0},null,{"$f":"SUM(AC29:AC29)","v":0},null,{"$f":"SUM(AE29:AE29)","v":0},null,{"$f":"SUM(AG29:AG29)","v":0},null,{"$f":"SUM(AI29:AI29)","v":0},null,{"$f":"SUM(AK29:AK29)","v":0},null,{"$f":"SUM(AM29:AM29)","v":0},null,{"$f":"SUM(AO29:AO29)","v":0},null,{"$f":"SUM(AQ29:AQ29)","v":0},null,{"$f":"SUM(AS29:AS29)","v":0},null,{"$f":"SUM(AU29:AU29)","v":0},null,{"$f":"SUM(AW29:AW29)","v":0},null,{"$f":"SUM(AY29:AY29)","v":0},null,{"$f":"SUM(BA29:BA29)","v":0},null,{"$f":"SUM(BC29:BC29)","v":0},null,{"$f":"SUM(BE29:BE29)","v":0},null,{"$f":"SUM(BG29:BG29)","v":0},null,{"$f":"SUM(BI29:BI29)","v":0},null,{"$f":"SUM(BK29:BK29)","v":0},null,{"$f":"SUM(BM29:BM29)","v":0}]
[]
[{"$f":"\"Grille de correction – \" &A6","v":"Grille de correction – Tâche PréAO"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Masque adapté\n- logo en haut à droite sur toutes les diapositives (1)\n- taille adaptée (1)  \n- sauf sur page de titre (1)\n- les titres principaux sont en gras (1)",4,3,2,1,0]
["Pied de page\n- date automatique insérée (1)\n- numéro de page inséré (1) \n- date et numéro de page pas présent sur la page de titre (1)\n- la numérotation commence à 1 sur 2e diapositive (1)",4,3,2,1,0]
["Présentation \n- transitions différentes entre dias 1&2 et les autres (2)\nDiapositive \"comportement adéquat : code de conduite\"\n- ordre des animations modifié:  texte puis image (2)",4,3,2,1,0]
["Diapositive  \"Manuel pour un sport de valeur\"\n- complété, avec une sélection pertinente du texte (2)\n- animation différente pour le texte et l'image (1)\n- image insérée (1)",4,3,2,1,0]
["Travail sur image\n- insérer + remplacer image (1)\n- suppression fond gris (1)\n- affecter une ombre (1) et couleur rouge (1)",4,3,2,1,0]
["Création PDF\n- en-tête et pied de page propre au pdf (2)\n- 3 dias + lignes de commentaires (1)\n- pdf créé et enregistré (1)",4,3,2,1,0]
[{"$f":"A$6&\" - Points max\"","v":"Tâche PréAO - Points max"},{"$f":"SUM(B35:B40)","v":24},null,"Points obtenus",null,null,{"$f":"SUM(G35:G40)","v":0},null,{"$f":"SUM(I35:I40)","v":0},null,{"$f":"SUM(K35:K40)","v":0},null,{"$f":"SUM(M35:M40)","v":0},null,{"$f":"SUM(O35:O40)","v":0},null,{"$f":"SUM(Q35:Q40)","v":0},null,{"$f":"SUM(S35:S40)","v":0},null,{"$f":"SUM(U35:U40)","v":0},null,{"$f":"SUM(W35:W40)","v":0},null,{"$f":"SUM(Y35:Y40)","v":0},null,{"$f":"SUM(AA35:AA40)","v":0},null,{"$f":"SUM(AC35:AC40)","v":0},null,{"$f":"SUM(AE35:AE40)","v":0},null,{"$f":"SUM(AG35:AG40)","v":0},null,{"$f":"SUM(AI35:AI40)","v":0},null,{"$f":"SUM(AK35:AK40)","v":0},null,{"$f":"SUM(AM35:AM40)","v":0},null,{"$f":"SUM(AO35:AO40)","v":0},null,{"$f":"SUM(AQ35:AQ40)","v":0},null,{"$f":"SUM(AS35:AS40)","v":0},null,{"$f":"SUM(AU35:AU40)","v":0},null,{"$f":"SUM(AW35:AW40)","v":0},null,{"$f":"SUM(AY35:AY40)","v":0},null,{"$f":"SUM(BA35:BA40)","v":0},null,{"$f":"SUM(BC35:BC40)","v":0},null,{"$f":"SUM(BE35:BE40)","v":0},null,{"$f":"SUM(BG35:BG40)","v":0},null,{"$f":"SUM(BI35:BI40)","v":0},null,{"$f":"SUM(BK35:BK40)","v":0},null,{"$f":"SUM(BM35:BM40)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A7","v":"Grille de correction – Tâche TABLEUR"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Onglet Contributions\n- constantes définies et utilisées (1)\n- mise en forme conditionnelle : nbre club > 500 (1)\n- format personnalisé : \"membres\" (1)\n- Nombre moyen de membres : division (1)",4,3,2,1,0]
["Onglet Contributions\n- contribution de base : calcul et arrondi au franc inférieur  (2)\n- contribution discipline : RECHERCHEV et RECHERCHEX (2)",4,3,2,1,0]
["Onglet Contributions\n- contribution membres : SI (1)\n- contribution relève : SI ET (2)\n- total : SOMME (1)",4,3,2,1,0]
["Onglet Contributions : tri et statistiques\n- tableau trié (2)\n- nombre de clubs : SOMME.SI (2)",4,3,2,1,0]
["Onglet Contributions\n- total : SOMME (1)\n- pourcentage : calcul (1) et format % avec deux décimales (1)\nOnglet Adresses\n- tableau filtré pour TI et ZH (1)",4,3,2,1,0]
["- orientation paysage, 2 pages (1)\n- zone d'impression définie (1)\n- titres répétés (1)\n- en-tête et pied de page (1)",4,3,2,1,0]
["Onglet Activite\n- sélection des données (1)\n- type de graphique (1)\n- étiquettes avec texte et valeur (1)\n- mise en évidence au libre choix de l'élève (1)",4,3,2,1,0]
[{"$f":"A$7&\" - Points max\"","v":"Tâche TABLEUR - Points max"},{"$f":"SUM(B46:B52)","v":28},null,"Points obtenus",null,null,{"$f":"SUM(G46:G52)","v":0},null,{"$f":"SUM(I46:I52)","v":0},null,{"$f":"SUM(K46:K52)","v":0},null,{"$f":"SUM(M46:M52)","v":0},null,{"$f":"SUM(O46:O52)","v":0},null,{"$f":"SUM(Q46:Q52)","v":0},null,{"$f":"SUM(S46:S52)","v":0},null,{"$f":"SUM(U46:U52)","v":0},null,{"$f":"SUM(W46:W52)","v":0},null,{"$f":"SUM(Y46:Y52)","v":0},null,{"$f":"SUM(AA46:AA52)","v":0},null,{"$f":"SUM(AC46:AC52)","v":0},null,{"$f":"SUM(AE46:AE52)","v":0},null,{"$f":"SUM(AG46:AG52)","v":0},null,{"$f":"SUM(AI46:AI52)","v":0},null,{"$f":"SUM(AK46:AK52)","v":0},null,{"$f":"SUM(AM46:AM52)","v":0},null,{"$f":"SUM(AO46:AO52)","v":0},null,{"$f":"SUM(AQ46:AQ52)","v":0},null,{"$f":"SUM(AS46:AS52)","v":0},null,{"$f":"SUM(AU46:AU52)","v":0},null,{"$f":"SUM(AW46:AW52)","v":0},null,{"$f":"SUM(AY46:AY52)","v":0},null,{"$f":"SUM(BA46:BA52)","v":0},null,{"$f":"SUM(BC46:BC52)","v":0},null,{"$f":"SUM(BE46:BE52)","v":0},null,{"$f":"SUM(BG46:BG52)","v":0},null,{"$f":"SUM(BI46:BI52)","v":0},null,{"$f":"SUM(BK46:BK52)","v":0},null,{"$f":"SUM(BM46:BM52)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A8","v":"Grille de correction – Tâche TRAITEMENT DE TEXTE: Préparer une brochure"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Styles\n- style Texte : modifié (1)\n- style Titre1 : modifié (1)\n- titres/sous-titres : hiérarchisation appliquée (1) et personnalisée (1)",4,3,2,1,0]
["- nouveau style Puce : crée et basé sur Texte (1), \n   puce personnalisée (1) et retrait du texte à 1 cm (1)\n1re page\n- logo et texte (1)",4,3,2,1,0]
["- bordure rouge (1), largeur 3 pts (1)\nLégendes\n- légende présente (1)\n- groupée (1)",4,3,2,1,0]
["Mise en forme du texte\n- 2 colonnes (1), ligne séparatrice (1)\n- distance 2 cm entre les 2 colonnes (1)\nPieds de page\n- 1re page vide (1)",4,3,2,1,0]
["- utilisation option pages paires et impaires (1)\n- pied de page: no page automatique & prénom et nom (1)\nTableau \"Profil des sportifs\"\n- marges des cellules (1)\n- ligne \"Totaux\" ajoutée et mise en forme (1)",4,3,2,1,0]
["Tableau \"Coûts …\"\n- format paysage (1)\n- présentation soignée, alignement  avec un tableau \n  ou des tabulations (1)\n- titres mis en évidence (1)\nRechercher/Remplacer\n- mise en évidence mot Swiss Olympic (1)",4,3,2,1,0]
[{"$f":"A$8&\" - Points max\"","v":"Tâche TRAITEMENT DE TEXTE: Préparer une brochure - Points max"},{"$f":"SUM(B58:B63)","v":24},null,"Points obtenus",null,null,{"$f":"SUM(G58:G63)","v":0},null,{"$f":"SUM(I58:I63)","v":0},null,{"$f":"SUM(K58:K63)","v":0},null,{"$f":"SUM(M58:M63)","v":0},null,{"$f":"SUM(O58:O63)","v":0},null,{"$f":"SUM(Q58:Q63)","v":0},null,{"$f":"SUM(S58:S63)","v":0},null,{"$f":"SUM(U58:U63)","v":0},null,{"$f":"SUM(W58:W63)","v":0},null,{"$f":"SUM(Y58:Y63)","v":0},null,{"$f":"SUM(AA58:AA63)","v":0},null,{"$f":"SUM(AC58:AC63)","v":0},null,{"$f":"SUM(AE58:AE63)","v":0},null,{"$f":"SUM(AG58:AG63)","v":0},null,{"$f":"SUM(AI58:AI63)","v":0},null,{"$f":"SUM(AK58:AK63)","v":0},null,{"$f":"SUM(AM58:AM63)","v":0},null,{"$f":"SUM(AO58:AO63)","v":0},null,{"$f":"SUM(AQ58:AQ63)","v":0},null,{"$f":"SUM(AS58:AS63)","v":0},null,{"$f":"SUM(AU58:AU63)","v":0},null,{"$f":"SUM(AW58:AW63)","v":0},null,{"$f":"SUM(AY58:AY63)","v":0},null,{"$f":"SUM(BA58:BA63)","v":0},null,{"$f":"SUM(BC58:BC63)","v":0},null,{"$f":"SUM(BE58:BE63)","v":0},null,{"$f":"SUM(BG58:BG63)","v":0},null,{"$f":"SUM(BI58:BI63)","v":0},null,{"$f":"SUM(BK58:BK63)","v":0},null,{"$f":"SUM(BM58:BM63)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A9","v":"Grille de correction – Tâche TRAITEMENT DE TEXTE: Terminer un formulaire"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Formulaire\n- sauvé sous forme de modèle (2)\n- restriction de modification : remplissage de formulaire (1)\n- protégé sans mot de passe (1)",4,3,2,1,0]
["Champs\n- nom : texte d'aide ajouté (1)\n- prénom : adaptation champ (première majuscule) (1)\n- courriel : insertion champ bloqué à 50 caractères (1)\n- sport : case à cocher ajoutée (1)",4,3,2,1,0]
["- liste déroulante Thème : complétée et corrigée (1), \n  triée par ordre alphabétique (1)\nPartie remarque\n- sauts de section avant et après (1)\n- déverrouillage de la partie remarques (1)",4,3,2,1,0]
[{"$f":"A$9&\" - Points max\"","v":"Tâche TRAITEMENT DE TEXTE: Terminer un formulaire - Points max"},{"$f":"SUM(B69:B71)","v":12},null,"Points obtenus",null,null,{"$f":"SUM(G69:G71)","v":0},null,{"$f":"SUM(I69:I71)","v":0},null,{"$f":"SUM(K69:K71)","v":0},null,{"$f":"SUM(M69:M71)","v":0},null,{"$f":"SUM(O69:O71)","v":0},null,{"$f":"SUM(Q69:Q71)","v":0},null,{"$f":"SUM(S69:S71)","v":0},null,{"$f":"SUM(U69:U71)","v":0},null,{"$f":"SUM(W69:W71)","v":0},null,{"$f":"SUM(Y69:Y71)","v":0},null,{"$f":"SUM(AA69:AA71)","v":0},null,{"$f":"SUM(AC69:AC71)","v":0},null,{"$f":"SUM(AE69:AE71)","v":0},null,{"$f":"SUM(AG69:AG71)","v":0},null,{"$f":"SUM(AI69:AI71)","v":0},null,{"$f":"SUM(AK69:AK71)","v":0},null,{"$f":"SUM(AM69:AM71)","v":0},null,{"$f":"SUM(AO69:AO71)","v":0},null,{"$f":"SUM(AQ69:AQ71)","v":0},null,{"$f":"SUM(AS69:AS71)","v":0},null,{"$f":"SUM(AU69:AU71)","v":0},null,{"$f":"SUM(AW69:AW71)","v":0},null,{"$f":"SUM(AY69:AY71)","v":0},null,{"$f":"SUM(BA69:BA71)","v":0},null,{"$f":"SUM(BC69:BC71)","v":0},null,{"$f":"SUM(BE69:BE71)","v":0},null,{"$f":"SUM(BG69:BG71)","v":0},null,{"$f":"SUM(BI69:BI71)","v":0},null,{"$f":"SUM(BK69:BK71)","v":0},null,{"$f":"SUM(BM69:BM71)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A10","v":"Grille de correction – Tâche COMMUNICATION : Rédiger une demande d'offre"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Contenu : éléments formels\n- lieu et date (1) \n- destinataire - DigitalPrint (1)\n- objet et appel adaptés (1)\n- salutations et signature (1)",4,3,2,1,0]
["Contenu : fond\n- introduction demande d'offre formelle (1)\n- critères techniques (1)\n- critères écologiques (2)",4,3,2,1,0]
["Contenu : fond\n- budget CHF 3800 (1)\n- nombre d'exemplaires 1000 (1)\n- accès aux fichiers (1)\n- délai 8 jours (1)",4,3,2,1,0]
["Contenu : structure de la lettre\n- ordre logique et idées reliées régulièrement par des mots \n  de liaison et si énumération correspond à la consigne (2)\n- qualité de la solution, la lettre pourrait-elle être envoyée sans \n  retouche fondamentale ? (2)",4,3,2,1,0]
["Contenu : forme\n- syntaxe et grammaire (2)\n- orthographe et ponctuation (2)",4,3,2,1,0]
["Contenu : forme\n- style (2)\n- vocabulaire et répétitions (2)",4,3,2,1,0]
[{"$f":"A$10&\" - Points max\"","v":"Tâche COMMUNICATION : Rédiger une demande d'offre - Points max"},{"$f":"SUM(B77:B82)","v":24},null,"Points obtenus",null,null,{"$f":"SUM(G77:G82)","v":0},null,{"$f":"SUM(I77:I82)","v":0},null,{"$f":"SUM(K77:K82)","v":0},null,{"$f":"SUM(M77:M82)","v":0},null,{"$f":"SUM(O77:O82)","v":0},null,{"$f":"SUM(Q77:Q82)","v":0},null,{"$f":"SUM(S77:S82)","v":0},null,{"$f":"SUM(U77:U82)","v":0},null,{"$f":"SUM(W77:W82)","v":0},null,{"$f":"SUM(Y77:Y82)","v":0},null,{"$f":"SUM(AA77:AA82)","v":0},null,{"$f":"SUM(AC77:AC82)","v":0},null,{"$f":"SUM(AE77:AE82)","v":0},null,{"$f":"SUM(AG77:AG82)","v":0},null,{"$f":"SUM(AI77:AI82)","v":0},null,{"$f":"SUM(AK77:AK82)","v":0},null,{"$f":"SUM(AM77:AM82)","v":0},null,{"$f":"SUM(AO77:AO82)","v":0},null,{"$f":"SUM(AQ77:AQ82)","v":0},null,{"$f":"SUM(AS77:AS82)","v":0},null,{"$f":"SUM(AU77:AU82)","v":0},null,{"$f":"SUM(AW77:AW82)","v":0},null,{"$f":"SUM(AY77:AY82)","v":0},null,{"$f":"SUM(BA77:BA82)","v":0},null,{"$f":"SUM(BC77:BC82)","v":0},null,{"$f":"SUM(BE77:BE82)","v":0},null,{"$f":"SUM(BG77:BG82)","v":0},null,{"$f":"SUM(BI77:BI82)","v":0},null,{"$f":"SUM(BK77:BK82)","v":0},null,{"$f":"SUM(BM77:BM82)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A11","v":"Grille de correction – Tâche Gérer des dossiers et des fichiers"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Dossiers et fichiers\n- Dossiers créés (PDF + Word) (1)\n- sous-dossiers créés (2010/2013/2016) (1)\n- Fichiers triés (2)\nNombre de fichiers PDF attendus par année :\n2010 -> 9\n2013 -> 7\n2016 -> 7\nNombre de fichiers Word attendus par année :\n2010 -> 4\n2013 -> 4\n2016 -> 5",4,3,2,1,0]
[{"$f":"A$11&\" - Points max\"","v":"Tâche Gérer des dossiers et des fichiers - Points max"},{"$f":"SUM(B88)","v":4},null,"Points obtenus",null,null,{"$f":"SUM(G88)","v":0},null,{"$f":"SUM(I88)","v":0},null,{"$f":"SUM(K88)","v":0},null,{"$f":"SUM(M88)","v":0},null,{"$f":"SUM(O88)","v":0},null,{"$f":"SUM(Q88)","v":0},null,{"$f":"SUM(S88)","v":0},null,{"$f":"SUM(U88)","v":0},null,{"$f":"SUM(W88)","v":0},null,{"$f":"SUM(Y88)","v":0},null,{"$f":"SUM(AA88)","v":0},null,{"$f":"SUM(AC88)","v":0},null,{"$f":"SUM(AE88)","v":0},null,{"$f":"SUM(AG88)","v":0},null,{"$f":"SUM(AI88)","v":0},null,{"$f":"SUM(AK88)","v":0},null,{"$f":"SUM(AM88)","v":0},null,{"$f":"SUM(AO88)","v":0},null,{"$f":"SUM(AQ88)","v":0},null,{"$f":"SUM(AS88)","v":0},null,{"$f":"SUM(AU88)","v":0},null,{"$f":"SUM(AW88)","v":0},null,{"$f":"SUM(AY88)","v":0},null,{"$f":"SUM(BA88)","v":0},null,{"$f":"SUM(BC88)","v":0},null,{"$f":"SUM(BE88)","v":0},null,{"$f":"SUM(BG88)","v":0},null,{"$f":"SUM(BI88)","v":0},null,{"$f":"SUM(BK88)","v":0},null,{"$f":"SUM(BM88)","v":0}]

{"sheet":"Recap-classe","index":2,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,1],[7,14,8,14],[7,22,8,22],[7,23,8,23],[3,1,3,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,12,8,12]]}
["Procédures de qualification 2022"]
["ICA"]
[null,null,"Profil B"]
["Ecole"]
["Date"]
["# élèves",{"$f":"COUNTA(B10:B39)","v":3}]
[]
["Numéro","Nom","Prénom","Classe","Nommer les fichiers\n(pts)","Tâche\nPréAO\n(pts)","Tâche\nTABLEUR\n(pts)","Tâche\nTTT\n(pts)","Tâche\nTTT\n(pts)","Tâche\nCORRESP\n(pts)",null,"Total\n(pts)","Note",null,"Note \nsans arrondi",null,"Tâche \"nommer\"\n(%)","Tâche\nPréAO\n(%)","Tâche\nTABLEUR\n(%)","Tâche\nTTT\n(%)","Tâche\nTTT\n(%)","Tâche\nCORRESP\n(%)","% des points","Moyenne %"]
[null,null,null,null,{"$f":"'Grille-classe'!$F$5","v":4},{"$f":"'Grille-classe'!$F$6","v":24},{"$f":"'Grille-classe'!$F$7","v":28},{"$f":"'Grille-classe'!$F$8","v":24},{"$f":"'Grille-classe'!$F$9","v":12},{"$f":"'Grille-classe'!$F$10","v":24},null,{"$f":"SUM(E9:K9)","v":116},null,null,null,null,{"$f":"E10/E$9","v":0},0,0,0,0,0]
[1,"Eleve 1","Prenom 1",null,{"$f":"'Grille-classe'!G$5","v":0},{"$f":"'Grille-classe'!G$6","v":0},{"$f":"'Grille-classe'!G$7","v":0},{"$f":"'Grille-classe'!G$8","v":0},{"$f":"'Grille-classe'!G$9","v":0},{"$f":"'Grille-classe'!G$10","v":0},null,0,{"$f":"ROUND((L10/$L$9*5+1)*2,0)/2","v":1},null,{"$f":"L10/$L$9*5+1","v":1},null,{"$f":"E10/E$9","v":0},{"$f":"F10/F$9","v":0},{"$f":"G10/G$9","v":0},{"$f":"H10/H$9","v":0},{"$f":"I10/I$9","v":0},{"$f":"J10/J$9","v":0},{"$f":"IF(L10=$L$9,0,L10/L$9)","v":0},{"$f":"AVERAGE(Q10:V10)","v":0}]
[2,"Eleve 2","Prénom 2",null,{"$f":"'Grille-classe'!I$5","v":0},{"$f":"'Grille-classe'!I$6","v":0},{"$f":"'Grille-classe'!I$7","v":0},{"$f":"'Grille-classe'!I$8","v":0},{"$f":"'Grille-classe'!I$9","v":0},{"$f":"'Grille-classe'!I$10","v":0},null,0,{"$f":"ROUND((L11/$L$9*5+1)*2,0)/2","v":1},null,{"$f":"L11/$L$9*5+1","v":1},null,0,0,0,0,0,0,0,0]
[3,"Eleve 3","Prénom 3",null,{"$f":"'Grille-classe'!K$5","v":0},{"$f":"'Grille-classe'!K$6","v":0},{"$f":"'Grille-classe'!K$7","v":0},{"$f":"'Grille-classe'!K$8","v":0},{"$f":"'Grille-classe'!K$9","v":0},{"$f":"'Grille-classe'!K$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[4,null,null,null,{"$f":"'Grille-classe'!M$5","v":0},{"$f":"'Grille-classe'!M$6","v":0},{"$f":"'Grille-classe'!M$7","v":0},{"$f":"'Grille-classe'!M$8","v":0},{"$f":"'Grille-classe'!M$9","v":0},{"$f":"'Grille-classe'!M$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[5,null,null,null,{"$f":"'Grille-classe'!O$5","v":0},{"$f":"'Grille-classe'!O$6","v":0},{"$f":"'Grille-classe'!O$7","v":0},{"$f":"'Grille-classe'!O$8","v":0},{"$f":"'Grille-classe'!O$9","v":0},{"$f":"'Grille-classe'!O$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[6,null,null,null,{"$f":"'Grille-classe'!Q$5","v":0},{"$f":"'Grille-classe'!Q$6","v":0},{"$f":"'Grille-classe'!Q$7","v":0},{"$f":"'Grille-classe'!Q$8","v":0},{"$f":"'Grille-classe'!Q$9","v":0},{"$f":"'Grille-classe'!Q$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[7,null,null,null,{"$f":"'Grille-classe'!S$5","v":0},{"$f":"'Grille-classe'!S$6","v":0},{"$f":"'Grille-classe'!S$7","v":0},{"$f":"'Grille-classe'!S$8","v":0},{"$f":"'Grille-classe'!S$9","v":0},{"$f":"'Grille-classe'!S$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[8,null,null,null,{"$f":"'Grille-classe'!U$5","v":0},{"$f":"'Grille-classe'!U$6","v":0},{"$f":"'Grille-classe'!U$7","v":0},{"$f":"'Grille-classe'!U$8","v":0},{"$f":"'Grille-classe'!U$9","v":0},{"$f":"'Grille-classe'!U$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[9,null,null,null,{"$f":"'Grille-classe'!W$5","v":0},{"$f":"'Grille-classe'!W$6","v":0},{"$f":"'Grille-classe'!W$7","v":0},{"$f":"'Grille-classe'!W$8","v":0},{"$f":"'Grille-classe'!W$9","v":0},{"$f":"'Grille-classe'!W$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[10,null,null,null,{"$f":"'Grille-classe'!Y$5","v":0},{"$f":"'Grille-classe'!Y$6","v":0},{"$f":"'Grille-classe'!Y$7","v":0},{"$f":"'Grille-classe'!Y$8","v":0},{"$f":"'Grille-classe'!Y$9","v":0},{"$f":"'Grille-classe'!Y$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[11,null,null,null,{"$f":"'Grille-classe'!AA$5","v":0},{"$f":"'Grille-classe'!AA$6","v":0},{"$f":"'Grille-classe'!AA$7","v":0},{"$f":"'Grille-classe'!AA$8","v":0},{"$f":"'Grille-classe'!AA$9","v":0},{"$f":"'Grille-classe'!AA$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[12,null,null,null,{"$f":"'Grille-classe'!AC$5","v":0},{"$f":"'Grille-classe'!AC$6","v":0},{"$f":"'Grille-classe'!AC$7","v":0},{"$f":"'Grille-classe'!AC$8","v":0},{"$f":"'Grille-classe'!AC$9","v":0},{"$f":"'Grille-classe'!AC$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[13,null,null,null,{"$f":"'Grille-classe'!AE$5","v":0},{"$f":"'Grille-classe'!AE$6","v":0},{"$f":"'Grille-classe'!AE$7","v":0},{"$f":"'Grille-classe'!AE$8","v":0},{"$f":"'Grille-classe'!AE$9","v":0},{"$f":"'Grille-classe'!AE$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[14,null,null,null,{"$f":"'Grille-classe'!AG$5","v":0},{"$f":"'Grille-classe'!AG$6","v":0},{"$f":"'Grille-classe'!AG$7","v":0},{"$f":"'Grille-classe'!AG$8","v":0},{"$f":"'Grille-classe'!AG$9","v":0},{"$f":"'Grille-classe'!AG$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[15,null,null,null,{"$f":"'Grille-classe'!AI$5","v":0},{"$f":"'Grille-classe'!AI$6","v":0},{"$f":"'Grille-classe'!AI$7","v":0},{"$f":"'Grille-classe'!AI$8","v":0},{"$f":"'Grille-classe'!AI$9","v":0},{"$f":"'Grille-classe'!AI$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[16,null,null,null,{"$f":"'Grille-classe'!AK$5","v":0},{"$f":"'Grille-classe'!AK$6","v":0},{"$f":"'Grille-classe'!AK$7","v":0},{"$f":"'Grille-classe'!AK$8","v":0},{"$f":"'Grille-classe'!AK$9","v":0},{"$f":"'Grille-classe'!AK$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[17,null,null,null,{"$f":"'Grille-classe'!AM$5","v":0},{"$f":"'Grille-classe'!AM$6","v":0},{"$f":"'Grille-classe'!AM$7","v":0},{"$f":"'Grille-classe'!AM$8","v":0},{"$f":"'Grille-classe'!AM$9","v":0},{"$f":"'Grille-classe'!AM$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[18,null,null,null,{"$f":"'Grille-classe'!AO$5","v":0},{"$f":"'Grille-classe'!AO$6","v":0},{"$f":"'Grille-classe'!AO$7","v":0},{"$f":"'Grille-classe'!AO$8","v":0},{"$f":"'Grille-classe'!AO$9","v":0},{"$f":"'Grille-classe'!AO$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[19,null,null,null,{"$f":"'Grille-classe'!AQ$5","v":0},{"$f":"'Grille-classe'!AQ$6","v":0},{"$f":"'Grille-classe'!AQ$7","v":0},{"$f":"'Grille-classe'!AQ$8","v":0},{"$f":"'Grille-classe'!AQ$9","v":0},{"$f":"'Grille-classe'!AQ$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[20,null,null,null,{"$f":"'Grille-classe'!AS$5","v":0},{"$f":"'Grille-classe'!AS$6","v":0},{"$f":"'Grille-classe'!AS$7","v":0},{"$f":"'Grille-classe'!AS$8","v":0},{"$f":"'Grille-classe'!AS$9","v":0},{"$f":"'Grille-classe'!AS$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[21,null,null,null,{"$f":"'Grille-classe'!AU$5","v":0},{"$f":"'Grille-classe'!AU$6","v":0},{"$f":"'Grille-classe'!AU$7","v":0},{"$f":"'Grille-classe'!AU$8","v":0},{"$f":"'Grille-classe'!AU$9","v":0},{"$f":"'Grille-classe'!AU$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[22,null,null,null,{"$f":"'Grille-classe'!AW$5","v":0},{"$f":"'Grille-classe'!AW$6","v":0},{"$f":"'Grille-classe'!AW$7","v":0},{"$f":"'Grille-classe'!AW$8","v":0},{"$f":"'Grille-classe'!AW$9","v":0},{"$f":"'Grille-classe'!AW$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[23,null,null,null,{"$f":"'Grille-classe'!AY$5","v":0},{"$f":"'Grille-classe'!AY$6","v":0},{"$f":"'Grille-classe'!AY$7","v":0},{"$f":"'Grille-classe'!AY$8","v":0},{"$f":"'Grille-classe'!AY$9","v":0},{"$f":"'Grille-classe'!AY$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[24,null,null,null,{"$f":"'Grille-classe'!BA$5","v":0},{"$f":"'Grille-classe'!BA$6","v":0},{"$f":"'Grille-classe'!BA$7","v":0},{"$f":"'Grille-classe'!BA$8","v":0},{"$f":"'Grille-classe'!BA$9","v":0},{"$f":"'Grille-classe'!BA$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[25,null,null,null,{"$f":"'Grille-classe'!BC$5","v":0},{"$f":"'Grille-classe'!BC$6","v":0},{"$f":"'Grille-classe'!BC$7","v":0},{"$f":"'Grille-classe'!BC$8","v":0},{"$f":"'Grille-classe'!BC$9","v":0},{"$f":"'Grille-classe'!BC$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[26,null,null,null,{"$f":"'Grille-classe'!BE$5","v":0},{"$f":"'Grille-classe'!BE$6","v":0},{"$f":"'Grille-classe'!BE$7","v":0},{"$f":"'Grille-classe'!BE$8","v":0},{"$f":"'Grille-classe'!BE$9","v":0},{"$f":"'Grille-classe'!BE$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[27,null,null,null,{"$f":"'Grille-classe'!BG$5","v":0},{"$f":"'Grille-classe'!BG$6","v":0},{"$f":"'Grille-classe'!BG$7","v":0},{"$f":"'Grille-classe'!BG$8","v":0},{"$f":"'Grille-classe'!BG$9","v":0},{"$f":"'Grille-classe'!BG$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[28,null,null,null,{"$f":"'Grille-classe'!BI$5","v":0},{"$f":"'Grille-classe'!BI$6","v":0},{"$f":"'Grille-classe'!BI$7","v":0},{"$f":"'Grille-classe'!BI$8","v":0},{"$f":"'Grille-classe'!BI$9","v":0},{"$f":"'Grille-classe'!BI$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[29,null,null,null,{"$f":"'Grille-classe'!BK$5","v":0},{"$f":"'Grille-classe'!BK$6","v":0},{"$f":"'Grille-classe'!BK$7","v":0},{"$f":"'Grille-classe'!BK$8","v":0},{"$f":"'Grille-classe'!BK$9","v":0},{"$f":"'Grille-classe'!BK$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[30,null,null,null,{"$f":"'Grille-classe'!BM$5","v":0},{"$f":"'Grille-classe'!BM$6","v":0},{"$f":"'Grille-classe'!BM$7","v":0},{"$f":"'Grille-classe'!BM$8","v":0},{"$f":"'Grille-classe'!BM$9","v":0},{"$f":"'Grille-classe'!BM$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]