{"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":52,"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 Modifier les images"]
[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":[[82,0,82,5],[83,1,83,5],[88,3,88,5],[69,3,69,5],[71,0,71,5],[72,1,72,5],[80,3,80,5],[50,3,50,5],[52,0,52,5],[53,1,53,5],[61,3,61,5],[63,0,63,5],[64,1,64,5],[29,3,29,5],[31,0,31,5],[32,1,32,5],[38,3,38,5],[40,0,40,5],[41,1,41,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],[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],[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],[22,54,22,55],[22,56,22,57],[22,58,22,59],[22,60,22,61],[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,44,20,45],[20,22,20,23],[20,24,20,25],[22,32,22,33],[20,32,20,33],[19,64,19,65],[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,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],[20,58,20,59],[20,60,20,61],[20,62,20,63],[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],[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],[19,38,19,39],[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,0,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[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],[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],[17,60,17,61],[17,62,17,63],[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],[16,60,16,61],[16,62,16,63],[13,0,13,5],[14,0,14,5],[16,0,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,28,16,29],[16,30,16,31],[16,32,16,33]]}
[null,2,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":"B39","v":16},{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},null,{"$f":"Q39","v":0},null,{"$f":"S39","v":0},null,{"$f":"U39","v":0},null,{"$f":"W39","v":0},null,{"$f":"Y39","v":0},null,{"$f":"AA39","v":0},null,{"$f":"AC39","v":0},null,{"$f":"AE39","v":0},null,{"$f":"AG39","v":0},null,{"$f":"AI39","v":0},null,{"$f":"AK39","v":0},null,{"$f":"AM39","v":0},null,{"$f":"AO39","v":0},null,{"$f":"AQ39","v":0},null,{"$f":"AS39","v":0},null,{"$f":"AU39","v":0},null,{"$f":"AW39","v":0},null,{"$f":"AY39","v":0},null,{"$f":"BA39","v":0},null,{"$f":"BC39","v":0},null,{"$f":"BE39","v":0},null,{"$f":"BG39","v":0},null,{"$f":"BI39","v":0},null,{"$f":"BK39","v":0},null,{"$f":"BM39","v":0}]
["Tâche TABLEUR",null,null,null,null,{"$f":"B51","v":28},{"$f":"G51","v":0},null,{"$f":"I51","v":0},null,{"$f":"K51","v":0},null,{"$f":"M51","v":0},null,{"$f":"O51","v":0},null,{"$f":"Q51","v":0},null,{"$f":"S51","v":0},null,{"$f":"U51","v":0},null,{"$f":"W51","v":0},null,{"$f":"Y51","v":0},null,{"$f":"AA51","v":0},null,{"$f":"AC51","v":0},null,{"$f":"AE51","v":0},null,{"$f":"AG51","v":0},null,{"$f":"AI51","v":0},null,{"$f":"AK51","v":0},null,{"$f":"AM51","v":0},null,{"$f":"AO51","v":0},null,{"$f":"AQ51","v":0},null,{"$f":"AS51","v":0},null,{"$f":"AU51","v":0},null,{"$f":"AW51","v":0},null,{"$f":"AY51","v":0},null,{"$f":"BA51","v":0},null,{"$f":"BC51","v":0},null,{"$f":"BE51","v":0},null,{"$f":"BG51","v":0},null,{"$f":"BI51","v":0},null,{"$f":"BK51","v":0},null,{"$f":"BM51","v":0}]
["Tâche TRAITEMENT DE TEXTE: Préparer une brochure",null,null,null,null,{"$f":"B62","v":24},{"$f":"G62","v":0},null,{"$f":"I62","v":0},null,{"$f":"K62","v":0},null,{"$f":"M62","v":0},null,{"$f":"O62","v":0},null,{"$f":"Q62","v":0},null,{"$f":"S62","v":0},null,{"$f":"U62","v":0},null,{"$f":"W62","v":0},null,{"$f":"Y62","v":0},null,{"$f":"AA62","v":0},null,{"$f":"AC62","v":0},null,{"$f":"AE62","v":0},null,{"$f":"AG62","v":0},null,{"$f":"AI62","v":0},null,{"$f":"AK62","v":0},null,{"$f":"AM62","v":0},null,{"$f":"AO62","v":0},null,{"$f":"AQ62","v":0},null,{"$f":"AS62","v":0},null,{"$f":"AU62","v":0},null,{"$f":"AW62","v":0},null,{"$f":"AY62","v":0},null,{"$f":"BA62","v":0},null,{"$f":"BC62","v":0},null,{"$f":"BE62","v":0},null,{"$f":"BG62","v":0},null,{"$f":"BI62","v":0},null,{"$f":"BK62","v":0},null,{"$f":"BM62","v":0}]
["Tâche TRAITEMENT DE TEXTE: Préparer un publipostage",null,null,null,null,{"$f":"B70","v":12},{"$f":"G70","v":0},null,{"$f":"I70","v":0},null,{"$f":"K70","v":0},null,{"$f":"M70","v":0},null,{"$f":"O70","v":0},null,{"$f":"Q70","v":0},null,{"$f":"S70","v":0},null,{"$f":"U70","v":0},null,{"$f":"W70","v":0},null,{"$f":"Y70","v":0},null,{"$f":"AA70","v":0},null,{"$f":"AC70","v":0},null,{"$f":"AE70","v":0},null,{"$f":"AG70","v":0},null,{"$f":"AI70","v":0},null,{"$f":"AK70","v":0},null,{"$f":"AM70","v":0},null,{"$f":"AO70","v":0},null,{"$f":"AQ70","v":0},null,{"$f":"AS70","v":0},null,{"$f":"AU70","v":0},null,{"$f":"AW70","v":0},null,{"$f":"AY70","v":0},null,{"$f":"BA70","v":0},null,{"$f":"BC70","v":0},null,{"$f":"BE70","v":0},null,{"$f":"BG70","v":0},null,{"$f":"BI70","v":0},null,{"$f":"BK70","v":0},null,{"$f":"BM70","v":0}]
["Tâche COMMUNICATION : Rédiger une invitation",null,null,null,null,{"$f":"B81","v":24},{"$f":"G81","v":0},null,{"$f":"I81","v":0},null,{"$f":"K81","v":0},null,{"$f":"M81","v":0},null,{"$f":"O81","v":0},null,{"$f":"Q81","v":0},null,{"$f":"S81","v":0},null,{"$f":"U81","v":0},null,{"$f":"W81","v":0},null,{"$f":"Y81","v":0},null,{"$f":"AA81","v":0},null,{"$f":"AC81","v":0},null,{"$f":"AE81","v":0},null,{"$f":"AG81","v":0},null,{"$f":"AI81","v":0},null,{"$f":"AK81","v":0},null,{"$f":"AM81","v":0},null,{"$f":"AO81","v":0},null,{"$f":"AQ81","v":0},null,{"$f":"AS81","v":0},null,{"$f":"AU81","v":0},null,{"$f":"AW81","v":0},null,{"$f":"AY81","v":0},null,{"$f":"BA81","v":0},null,{"$f":"BC81","v":0},null,{"$f":"BE81","v":0},null,{"$f":"BG81","v":0},null,{"$f":"BI81","v":0},null,{"$f":"BK81","v":0},null,{"$f":"BM81","v":0}]
["Tâche ARBORESCENCE : Gérer des dossiers et des fichiers",null,null,null,null,{"$f":"B89","v":12},{"$f":"G89","v":0},null,{"$f":"I89","v":0},null,{"$f":"K89","v":0},null,{"$f":"M89","v":0},null,{"$f":"O89","v":0},null,{"$f":"Q89","v":0},null,{"$f":"S89","v":0},null,{"$f":"U89","v":0},null,{"$f":"W89","v":0},null,{"$f":"Y89","v":0},null,{"$f":"AA89","v":0},null,{"$f":"AC89","v":0},null,{"$f":"AE89","v":0},null,{"$f":"AG89","v":0},null,{"$f":"AI89","v":0},null,{"$f":"AK89","v":0},null,{"$f":"AM89","v":0},null,{"$f":"AO89","v":0},null,{"$f":"AQ89","v":0},null,{"$f":"AS89","v":0},null,{"$f":"AU89","v":0},null,{"$f":"AW89","v":0},null,{"$f":"AY89","v":0},null,{"$f":"BA89","v":0},null,{"$f":"BC89","v":0},null,{"$f":"BE89","v":0},null,{"$f":"BG89","v":0},null,{"$f":"BI89","v":0},null,{"$f":"BK89","v":0},null,{"$f":"BM89","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,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème 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  sauf celle de titre (1)\n- date (1) sur toutes les diapositives sauf celle de titre (1) ",4,3,2,1,0]
["Diaporama\n- transition identique entre les dias (1)\n- affichage en boucle (1)\n- durée d'affichage 10 secondes par dia (1)\n- enregistré au format pdf (1)",4,3,2,1,0]
["Diapositives nouvelles locations :\n- images insérées (1)\n- spécificités et prix (1)\n- mise en page (1) et type de dia 2 contenus (1)",4,3,2,1,0]
["Diapositives \"Rafraîchir correctement en été\" :\n- sélection pertinente du texte (2)\n- quantité de texte adaptée (1)\n- animations (1)",4,3,2,1,0]
[{"$f":"A$6&\" - Points max\"","v":"Tâche PréAO - Points max"},{"$f":"SUM(B35:B38)","v":16},null,"Points obtenus",null,null,{"$f":"SUM(G35:G38)","v":0},null,{"$f":"SUM(I35:I38)","v":0},null,{"$f":"SUM(K35:K38)","v":0},null,{"$f":"SUM(M35:M38)","v":0},null,{"$f":"SUM(O35:O38)","v":0},null,{"$f":"SUM(Q35:Q38)","v":0},null,{"$f":"SUM(S35:S38)","v":0},null,{"$f":"SUM(U35:U38)","v":0},null,{"$f":"SUM(W35:W38)","v":0},null,{"$f":"SUM(Y35:Y38)","v":0},null,{"$f":"SUM(AA35:AA38)","v":0},null,{"$f":"SUM(AC35:AC38)","v":0},null,{"$f":"SUM(AE35:AE38)","v":0},null,{"$f":"SUM(AG35:AG38)","v":0},null,{"$f":"SUM(AI35:AI38)","v":0},null,{"$f":"SUM(AK35:AK38)","v":0},null,{"$f":"SUM(AM35:AM38)","v":0},null,{"$f":"SUM(AO35:AO38)","v":0},null,{"$f":"SUM(AQ35:AQ38)","v":0},null,{"$f":"SUM(AS35:AS38)","v":0},null,{"$f":"SUM(AU35:AU38)","v":0},null,{"$f":"SUM(AW35:AW38)","v":0},null,{"$f":"SUM(AY35:AY38)","v":0},null,{"$f":"SUM(BA35:BA38)","v":0},null,{"$f":"SUM(BC35:BC38)","v":0},null,{"$f":"SUM(BE35:BE38)","v":0},null,{"$f":"SUM(BG35:BG38)","v":0},null,{"$f":"SUM(BI35:BI38)","v":0},null,{"$f":"SUM(BK35:BK38)","v":0},null,{"$f":"SUM(BM35:BM38)","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 Immeubles\n- création / utilisation de constantes (1)\n- calcul remise SI(OU) (2) \n- calcul loyer mensuel net (1)",4,3,2,1,0]
["Onglet Immeubles\n- calcul % du loyer (1)\n- calcul rang décroissant (1)\n- tri des loyers mensuels net selon rang (1)\n- mise en forme conditionnel. (1)",4,3,2,1,0]
["Onglet Immeubles\n- frais chauffage Neuchâtel SOMME.SI (2) \n- immeubles de plus de 5 étages NB.SI (1)\n- loyer mensuel brut le moins élevé MIN (1)",4,3,2,1,0]
["Onglet Locaux\n- figer volet (1)\n- affichage année en cours (1)\n- calcul ancienneté (1) (DATEDIF, ARRONDI.INF, \n  FRACTION ANNEE, ANNEE-ANNEE)\n- affichage mention SI (1)",4,3,2,1,0]
["Onglet Appartements\n- tri avec 2 clés + ordres de tri corrects (2)\n- filtre d'une table de données :\n  appartement occupé oui + filtre numérique (2)",4,3,2,1,0]
["Onglet Bulletin\n- nom RECHERCHEV (2)\n- calcul somme heures (1)\n- format [h]:mm ou *24 avec autre format nombre (1)",4,3,2,1,0]
["Onglet Bulletin\n- calcul coût nettoyage * 24 (1)\n- coût nettoyage ARRONDI.SUP (1)\n- format comptabilité CHF sans décimale (1)\n- orientation de la page : paysage (1)",4,3,2,1,0]
[{"$f":"A$7&\" - Points max\"","v":"Tâche TABLEUR - Points max"},{"$f":"SUM(B44:B50)","v":28},null,"Points obtenus",null,null,{"$f":"SUM(G44:G50)","v":0},null,{"$f":"SUM(I44:I50)","v":0},null,{"$f":"SUM(K44:K50)","v":0},null,{"$f":"SUM(M44:M50)","v":0},null,{"$f":"SUM(O44:O50)","v":0},null,{"$f":"SUM(Q44:Q50)","v":0},null,{"$f":"SUM(S44:S50)","v":0},null,{"$f":"SUM(U44:U50)","v":0},null,{"$f":"SUM(W44:W50)","v":0},null,{"$f":"SUM(Y44:Y50)","v":0},null,{"$f":"SUM(AA44:AA50)","v":0},null,{"$f":"SUM(AC44:AC50)","v":0},null,{"$f":"SUM(AE44:AE50)","v":0},null,{"$f":"SUM(AG44:AG50)","v":0},null,{"$f":"SUM(AI44:AI50)","v":0},null,{"$f":"SUM(AK44:AK50)","v":0},null,{"$f":"SUM(AM44:AM50)","v":0},null,{"$f":"SUM(AO44:AO50)","v":0},null,{"$f":"SUM(AQ44:AQ50)","v":0},null,{"$f":"SUM(AS44:AS50)","v":0},null,{"$f":"SUM(AU44:AU50)","v":0},null,{"$f":"SUM(AW44:AW50)","v":0},null,{"$f":"SUM(AY44:AY50)","v":0},null,{"$f":"SUM(BA44:BA50)","v":0},null,{"$f":"SUM(BC44:BC50)","v":0},null,{"$f":"SUM(BE44:BE50)","v":0},null,{"$f":"SUM(BG44:BG50)","v":0},null,{"$f":"SUM(BI44:BI50)","v":0},null,{"$f":"SUM(BK44:BK50)","v":0},null,{"$f":"SUM(BM44:BM50)","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- titres et sous-titres hiérarchisés (1)\nNouveau style \"Eco-cadre\"\n- créé et appliqué (1)\n- police claire (1) fond couleur brochure (1)",4,3,2,1,0]
["Mise en forme du texte\n- § 1 : insertion (1) d'images adéquates (1)\n- § 2 et § 3 : création de 2 colonnes (1) tenant sur la page (1)",4,3,2,1,0]
["Tableau\n- création (1) titre (1) \n- 1ère ligne mise en évidence (1)\n- lisibilité et sur une page (1)",4,3,2,1,0]
["Tableau\n- mise en évidence par rue (1)\n- couleur brochure (1)\n- ligne total fusionnée (1) et mise en évidence (1)",4,3,2,1,0]
["Document\n- sommaire automatique disposé sur toute la page (1) et titre (1)\n- alternance des pages portrait et paysage (2)",4,3,2,1,0]
["Pieds de page\n- insertion : logo (1), titre (1) page x sur y (1)\n- ajusté sur toutes les pages / absent de la 1re (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(B56:B61)","v":24},null,"Points obtenus",null,null,{"$f":"SUM(G56:G61)","v":0},null,{"$f":"SUM(I56:I61)","v":0},null,{"$f":"SUM(K56:K61)","v":0},null,{"$f":"SUM(M56:M61)","v":0},null,{"$f":"SUM(O56:O61)","v":0},null,{"$f":"SUM(Q56:Q61)","v":0},null,{"$f":"SUM(S56:S61)","v":0},null,{"$f":"SUM(U56:U61)","v":0},null,{"$f":"SUM(W56:W61)","v":0},null,{"$f":"SUM(Y56:Y61)","v":0},null,{"$f":"SUM(AA56:AA61)","v":0},null,{"$f":"SUM(AC56:AC61)","v":0},null,{"$f":"SUM(AE56:AE61)","v":0},null,{"$f":"SUM(AG56:AG61)","v":0},null,{"$f":"SUM(AI56:AI61)","v":0},null,{"$f":"SUM(AK56:AK61)","v":0},null,{"$f":"SUM(AM56:AM61)","v":0},null,{"$f":"SUM(AO56:AO61)","v":0},null,{"$f":"SUM(AQ56:AQ61)","v":0},null,{"$f":"SUM(AS56:AS61)","v":0},null,{"$f":"SUM(AU56:AU61)","v":0},null,{"$f":"SUM(AW56:AW61)","v":0},null,{"$f":"SUM(AY56:AY61)","v":0},null,{"$f":"SUM(BA56:BA61)","v":0},null,{"$f":"SUM(BC56:BC61)","v":0},null,{"$f":"SUM(BE56:BE61)","v":0},null,{"$f":"SUM(BG56:BG61)","v":0},null,{"$f":"SUM(BI56:BI61)","v":0},null,{"$f":"SUM(BK56:BK61)","v":0},null,{"$f":"SUM(BM56:BM61)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A9","v":"Grille de correction – Tâche TRAITEMENT DE TEXTE: Préparer un publipostage"}]
[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"]
["Mise en page\n- format A5 (1)\n- orientation paysage (1)\n- présentation sur deux colonnes (1) avec ligne séparatrice (1)\n  (tableau ou colonne)",4,3,2,1,0]
["Contenu\n- insertion texte (1)\n- insertion et positionnement du timbre (1)\n- positionnement adresse destinataire (1)\n- présentation ordre des champs : disposition de l'adresse (1)",4,3,2,1,0]
["Fusion\n- accord par \"si alors sinon\" (2)\n- filtre sur localité (1)\n- résultat fusion publipostage (1)",4,3,2,1,0]
[{"$f":"A$9&\" - Points max\"","v":"Tâche TRAITEMENT DE TEXTE: Préparer un publipostage - Points max"},{"$f":"SUM(B67:B69)","v":12},null,"Points obtenus",null,null,{"$f":"SUM(G67:G69)","v":0},null,{"$f":"SUM(I67:I69)","v":0},null,{"$f":"SUM(K67:K69)","v":0},null,{"$f":"SUM(M67:M69)","v":0},null,{"$f":"SUM(O67:O69)","v":0},null,{"$f":"SUM(Q67:Q69)","v":0},null,{"$f":"SUM(S67:S69)","v":0},null,{"$f":"SUM(U67:U69)","v":0},null,{"$f":"SUM(W67:W69)","v":0},null,{"$f":"SUM(Y67:Y69)","v":0},null,{"$f":"SUM(AA67:AA69)","v":0},null,{"$f":"SUM(AC67:AC69)","v":0},null,{"$f":"SUM(AE67:AE69)","v":0},null,{"$f":"SUM(AG67:AG69)","v":0},null,{"$f":"SUM(AI67:AI69)","v":0},null,{"$f":"SUM(AK67:AK69)","v":0},null,{"$f":"SUM(AM67:AM69)","v":0},null,{"$f":"SUM(AO67:AO69)","v":0},null,{"$f":"SUM(AQ67:AQ69)","v":0},null,{"$f":"SUM(AS67:AS69)","v":0},null,{"$f":"SUM(AU67:AU69)","v":0},null,{"$f":"SUM(AW67:AW69)","v":0},null,{"$f":"SUM(AY67:AY69)","v":0},null,{"$f":"SUM(BA67:BA69)","v":0},null,{"$f":"SUM(BC67:BC69)","v":0},null,{"$f":"SUM(BE67:BE69)","v":0},null,{"$f":"SUM(BG67:BG69)","v":0},null,{"$f":"SUM(BI67:BI69)","v":0},null,{"$f":"SUM(BK67:BK69)","v":0},null,{"$f":"SUM(BM67:BM69)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A10","v":"Grille de correction – Tâche COMMUNICATION : Rédiger une invitation"}]
[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 (circulaire) (1)\n- objet et appel adaptés (1)\n- salutations et signature (1)     ",4,3,2,1,0]
["Contenu : fond\n- introduction et mention de l'invitation (1)\n- date, lieu de l'invitation (1)\n- programme de la soirée cohérent (1)\n- conclusion (1)",4,3,2,1,0]
["Contenu : fond\n- 2 gestes eco-responsables (2)\n- pertinence des éléments pour les inscriptions (2)",4,3,2,1,0]
["Contenu : structure de la lettre\n- ordre logique et idées reliées régulièrement par des mots de liaison (2)\n- qualité de la solution, la lettre pourrait-elle être envoyée sans 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 invitation - Points max"},{"$f":"SUM(B75:B80)","v":24},null,"Points obtenus",null,null,{"$f":"SUM(G75:G80)","v":0},null,{"$f":"SUM(I75:I80)","v":0},null,{"$f":"SUM(K75:K80)","v":0},null,{"$f":"SUM(M75:M80)","v":0},null,{"$f":"SUM(O75:O80)","v":0},null,{"$f":"SUM(Q75:Q80)","v":0},null,{"$f":"SUM(S75:S80)","v":0},null,{"$f":"SUM(U75:U80)","v":0},null,{"$f":"SUM(W75:W80)","v":0},null,{"$f":"SUM(Y75:Y80)","v":0},null,{"$f":"SUM(AA75:AA80)","v":0},null,{"$f":"SUM(AC75:AC80)","v":0},null,{"$f":"SUM(AE75:AE80)","v":0},null,{"$f":"SUM(AG75:AG80)","v":0},null,{"$f":"SUM(AI75:AI80)","v":0},null,{"$f":"SUM(AK75:AK80)","v":0},null,{"$f":"SUM(AM75:AM80)","v":0},null,{"$f":"SUM(AO75:AO80)","v":0},null,{"$f":"SUM(AQ75:AQ80)","v":0},null,{"$f":"SUM(AS75:AS80)","v":0},null,{"$f":"SUM(AU75:AU80)","v":0},null,{"$f":"SUM(AW75:AW80)","v":0},null,{"$f":"SUM(AY75:AY80)","v":0},null,{"$f":"SUM(BA75:BA80)","v":0},null,{"$f":"SUM(BC75:BC80)","v":0},null,{"$f":"SUM(BE75:BE80)","v":0},null,{"$f":"SUM(BG75:BG80)","v":0},null,{"$f":"SUM(BI75:BI80)","v":0},null,{"$f":"SUM(BK75:BK80)","v":0},null,{"$f":"SUM(BM75:BM80)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A11","v":"Grille de correction – Tâche ARBORESCENCE : 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 fichier\n- Dossiers créés (1)\n  Nombre de fichiers attendus par mois :\n  Factures : 01 janvier (38), 02 février (38), 03 mars (20), 04 avril (30)\n  Factures : 01 janvier (32), 02 février (39), 03 mars (20), 04 avril (24)\n avec noms cohérents (1)\n- Fichiers triés (2)",4,3,2,1,0]
["Capture d'écran de l'arborescence :\n- Enregistrée (1)\nCapture d'écran du dossier :\n- Enregistrée (1)\n- Flèche ajoutée (1)\n- Texte ajouté (1)",4,3,2,1,0]
["Document Word :\n- Images insérées (1)\n- Tailles adaptées pour tenir sur 1 page (1)\n- Nuances de gris (1)\n- Texte ajouté",4,3,2,1,0]
[{"$f":"A$11&\" - Points max\"","v":"Tâche ARBORESCENCE : Gérer des dossiers et des fichiers - Points max"},{"$f":"SUM(B86:B88)","v":12},null,"Points obtenus",null,null,{"$f":"SUM(G86:G88)","v":0},null,{"$f":"SUM(I86:I88)","v":0},null,{"$f":"SUM(K86:K88)","v":0},null,{"$f":"SUM(M86:M88)","v":0},null,{"$f":"SUM(O86:O88)","v":0},null,{"$f":"SUM(Q86:Q88)","v":0},null,{"$f":"SUM(S86:S88)","v":0},null,{"$f":"SUM(U86:U88)","v":0},null,{"$f":"SUM(W86:W88)","v":0},null,{"$f":"SUM(Y86:Y88)","v":0},null,{"$f":"SUM(AA86:AA88)","v":0},null,{"$f":"SUM(AC86:AC88)","v":0},null,{"$f":"SUM(AE86:AE88)","v":0},null,{"$f":"SUM(AG86:AG88)","v":0},null,{"$f":"SUM(AI86:AI88)","v":0},null,{"$f":"SUM(AK86:AK88)","v":0},null,{"$f":"SUM(AM86:AM88)","v":0},null,{"$f":"SUM(AO86:AO88)","v":0},null,{"$f":"SUM(AQ86:AQ88)","v":0},null,{"$f":"SUM(AS86:AS88)","v":0},null,{"$f":"SUM(AU86:AU88)","v":0},null,{"$f":"SUM(AW86:AW88)","v":0},null,{"$f":"SUM(AY86:AY88)","v":0},null,{"$f":"SUM(BA86:BA88)","v":0},null,{"$f":"SUM(BC86:BC88)","v":0},null,{"$f":"SUM(BE86:BE88)","v":0},null,{"$f":"SUM(BG86:BG88)","v":0},null,{"$f":"SUM(BI86:BI88)","v":0},null,{"$f":"SUM(BK86:BK88)","v":0},null,{"$f":"SUM(BM86:BM88)","v":0}]

{"sheet":"Recap-classe","index":2,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,1],[7,15,8,15],[7,24,8,24],[7,25,8,25],[3,1,3,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,13,8,13]]}
["Procédures de qualification 2020"]
["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)","Tâche\nIMAGES\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(%)","Tâche\nIMAGES\n(%)","% des points","Moyenne %"]
[null,null,null,null,{"$f":"'Grille-classe'!$F$5","v":4},{"$f":"'Grille-classe'!$F$6","v":16},{"$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},{"$f":"'Grille-classe'!$F$11","v":12},null,{"$f":"SUM(E9:L9)","v":120},null,null,null,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},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},{"$f":"'Grille-classe'!G$11","v":0},null,{"$f":"SUM(E10:L10)","v":0},{"$f":"ROUND((M10/$M$9*5+1)*2,0)/2","v":1},null,{"$f":"M10/$M$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},0,{"$f":"IF(M10=$M$9,0,M10/M$9)","v":0},{"$f":"AVERAGE(R10:X10)","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},{"$f":"'Grille-classe'!I$11","v":0},null,{"$f":"SUM(E11:L11)","v":0},{"$f":"ROUND((M11/$M$9*5+1)*2,0)/2","v":1},null,{"$f":"M11/$M$9*5+1","v":1},null,0,0,0,0,0,0,0,{"$f":"IF(M11=$M$9,0,M11/M$9)","v":0},{"$f":"AVERAGE(R11:X11)","v":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},{"$f":"'Grille-classe'!K$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!M$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!O$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!Q$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!S$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!U$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!W$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!Y$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AA$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AC$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AE$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AG$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AI$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AK$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AM$11","v":0},null,0,1,null,1,null,0,0,0,0,0,{"$f":"J26/J$9","v":0},{"$f":"K26/K$9","v":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},{"$f":"'Grille-classe'!AO$11","v":0},null,0,1,null,1,null,0,0,0,0,0,{"$f":"J27/J$9","v":0},{"$f":"K27/K$9","v":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},{"$f":"'Grille-classe'!AQ$11","v":0},null,0,1,null,1,null,0,0,0,0,0,{"$f":"J28/J$9","v":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},{"$f":"'Grille-classe'!AS$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AU$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AW$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!AY$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!BA$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!BC$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!BE$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!BG$11","v":0},null,0,1,null,1,null,0,0,0,0,0,{"$f":"J36/J$9","v":0},{"$f":"K36/K$9","v":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},{"$f":"'Grille-classe'!BI$11","v":0},null,0,1,null,1,null,0,0,0,0,0,{"$f":"J37/J$9","v":0},{"$f":"K37/K$9","v":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},{"$f":"'Grille-classe'!BK$11","v":0},null,0,1,null,1,null,0,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},{"$f":"'Grille-classe'!BM$11","v":0},null,0,1,null,1,null,0,0,0,0,0,{"$f":"J39/J$9","v":0},{"$f":"K39/K$9","v":0},0,0]