{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SOMMAIRE","1C","1D","2C1","Ajout"],"not_rendered":{"charts":0,"images":23,"macros":0,"external_links":0,"defined_names":12,"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":"SOMMAIRE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1C","index":1,"n_rows":24,"n_cols":38,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,33,2,33],[8,10,9,12],[1,27,2,27],[1,28,2,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,2,32],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,20,2,20]]}
[null,null,null,null,null,null,null,null,null,null,"SOMMAIRE"]
[null,null,null,null,null,null,null,null,null,null,"index","ligne",null,null,null,{"$f":"INDIRECT(\"$D$\"&COLUMN()-12,TRUE)","v":"Ferry Yoann"},{"$f":"INDIRECT(\"$D$\"&COLUMN()-12,TRUE)","v":"Gueye Serigne"},"Herrmann Sam","Renard2 Noah","Renard Noah","NomEleve4 Franco-Roberto","Caldaras Franco-Roberto","NomEleve3 Emeline","Bernard Emeline","NomEleve1 Dario","Amaro Dario","Nyavo Anaëlle","Demarteau Alessio","NomEleve2 Ahmet","Bakis Ahmet",0,0,0,0]
["N°","Nom Elève","Prénom Elève","Nom-Prenom","AnFF","Orientation","DateNaiss","Date Entrée Ecole",null,null,{"$f":"MATCH(L22,Elèves,0)","v":3},{"$f":"K3+3","v":6}]
[{"$f":"ROW()-3","v":1},"Ferry","Yoann",{"$f":"B4&\" \"&C4","v":"Ferry Yoann"},"1C","D101","31/01/2007","01/09/2019",null,null,null,null,null,"Année Scolaire 2019-2020"]
[{"$f":"ROW()-3","v":2},"Gueye","Serigne",{"$f":"B5&\" \"&C5","v":"Gueye Serigne"},"1C","D101","06/11/2005","01/09/2019"]
[{"$f":"ROW()-3","v":3},"Herrmann","Sam",{"$f":"B6&\" \"&C6","v":"Herrmann Sam"},"1C","D101","06/09/2006","01/09/2019",null,null,null,null,null,"Carte de cantine"]
[{"$f":"ROW()-3","v":4},"Renard2","Noah",{"$f":"B7&\" \"&C7","v":"Renard2 Noah"},"1C","D102","02/08/2007","01/09/2020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo"]
[{"$f":"ROW()-3","v":5},"Renard","Noah",{"$f":"B8&\" \"&C8","v":"Renard Noah"},"1C","D101","02/08/2006","01/09/2019",null,null,"Eléve"]
[{"$f":"ROW()-3","v":6},"NomEleve4","Franco-Roberto",{"$f":"B9&\" \"&C9","v":"NomEleve4 Franco-Roberto"},"1C","D101","17/06/2006","01/09/2019",null,null,{"$f":"INDEX(Elèves,K3,)","v":"Herrmann Sam"}]
[{"$f":"ROW()-3","v":7},"Caldaras","Franco-Roberto",{"$f":"B10&\" \"&C10","v":"Caldaras Franco-Roberto"},"1C","D101","17/06/2006","01/09/2019"]
[{"$f":"ROW()-3","v":8},"NomEleve3","Emeline",{"$f":"B11&\" \"&C11","v":"NomEleve3 Emeline"},"1C","D101","10/09/2006","01/09/2019",null,null,"Classe ",{"$f":"INDEX(E:E,L3)","v":"1C"}]
[{"$f":"ROW()-3","v":9},"Bernard","Emeline",{"$f":"B12&\" \"&C12","v":"Bernard Emeline"},"1C","D101","10/09/2006","01/09/2019"]
[{"$f":"ROW()-3","v":10},"NomEleve1","Dario",{"$f":"B13&\" \"&C13","v":"NomEleve1 Dario"},"1C","D101","20/07/2007","01/09/2019",null,null,"Age",{"$f":"DATEDIF(INDEX(G:G,L3),TODAY(),\"y\")","v":13}]
[{"$f":"ROW()-3","v":11},"Amaro","Dario",{"$f":"B14&\" \"&C14","v":"Amaro Dario"},"1C","D101","20/07/2007","01/09/2019"]
[{"$f":"ROW()-3","v":12},"Nyavo","Anaëlle",{"$f":"B15&\" \"&C15","v":"Nyavo Anaëlle"},"1C","D101","10/08/2006","01/09/2019"]
[{"$f":"ROW()-3","v":13},"Demarteau","Alessio",{"$f":"B16&\" \"&C16","v":"Demarteau Alessio"},"1C","D101","09/09/2006","01/09/2019",null,null,{"$f":"\"*\"&K9&\"*\"","v":"*Herrmann Sam*"}]
[{"$f":"ROW()-3","v":14},"NomEleve2","Ahmet",{"$f":"B17&\" \"&C17","v":"NomEleve2 Ahmet"},"1C","D101","25/06/2006","17/10/2019"]
[{"$f":"ROW()-3","v":15},"Bakis","Ahmet",{"$f":"B18&\" \"&C18","v":"Bakis Ahmet"},"1C","D101","25/06/2006","17/10/2019"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Herrmann Sam"]
[]
[null,null,null,null,null,null,null,null,null,null,"Choisir l'élève  ^^^^"]

{"sheet":"1D","index":2,"n_rows":24,"n_cols":38,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,33,2,33],[8,10,9,12],[1,27,2,27],[1,28,2,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,2,32],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,20,2,20]]}
[null,null,null,null,null,null,null,null,null,null,"SOMMAIRE"]
[null,null,null,null,null,null,null,null,null,null,"index","ligne",null,null,null,{"$f":"INDIRECT(\"$D$\"&COLUMN()-12,TRUE)","v":"Bakis Ahmet"},{"$f":"INDIRECT(\"$D$\"&COLUMN()-12,TRUE)","v":"NomEleve2 Ahmet"},"Demarteau Alessio","Nyavo Anaëlle","Amaro Dario","NomEleve1 Dario","Bernard Emeline","NomEleve3 Emeline","Caldaras Franco-Roberto","NomEleve4 Franco-Roberto","Renard Noah","Renard2 Noah","Herrmann Sam","Gueye Serigne","Ferry Yoann",0,0,0,0]
["N°","Nom Elève","Prénom Elève","Nom-Prenom","AnFF","Orientation","DateNaiss","Date Entrée Ecole",null,null,{"$f":"MATCH(L22,Elèves,0)","v":4},{"$f":"K3+3","v":7}]
[{"$f":"ROW()-3","v":1},"Bakis","Ahmet",{"$f":"B4&\" \"&C4","v":"Bakis Ahmet"},"1D","D101","25/06/2006","17/10/2019",null,null,null,null,null,"Année Scolaire 2019-2020"]
[{"$f":"ROW()-3","v":2},"NomEleve2","Ahmet",{"$f":"B5&\" \"&C5","v":"NomEleve2 Ahmet"},"1D","D101","25/06/2006","17/10/2019"]
[3,"Demarteau","Alessio",{"$f":"B6&\" \"&C6","v":"Demarteau Alessio"},"1D","D101","09/09/2006","01/09/2019",null,null,null,null,null,"Carte de cantine"]
[4,"Nyavo","Anaëlle",{"$f":"B7&\" \"&C7","v":"Nyavo Anaëlle"},"1D","D101","10/08/2006","01/09/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo"]
[5,"Amaro","Dario",{"$f":"B8&\" \"&C8","v":"Amaro Dario"},"1D","D101","20/07/2007","01/09/2019",null,null,"Eléve"]
[6,"NomEleve1","Dario",{"$f":"B9&\" \"&C9","v":"NomEleve1 Dario"},"1D","D101","20/07/2007","01/09/2019",null,null,{"$f":"INDEX(Elèves,K3,)","v":"Nyavo Anaëlle"}]
[7,"Bernard","Emeline",{"$f":"B10&\" \"&C10","v":"Bernard Emeline"},"1D","D101","10/09/2006","01/09/2019"]
[8,"NomEleve3","Emeline",{"$f":"B11&\" \"&C11","v":"NomEleve3 Emeline"},"1D","D101","10/09/2006","01/09/2019",null,null,"Classe ",{"$f":"INDEX(E:E,L3)","v":"1D"}]
[9,"Caldaras","Franco-Roberto",{"$f":"B12&\" \"&C12","v":"Caldaras Franco-Roberto"},"1D","D101","17/06/2006","01/09/2019"]
[10,"NomEleve4","Franco-Roberto",{"$f":"B13&\" \"&C13","v":"NomEleve4 Franco-Roberto"},"1D","D101","17/06/2006","01/09/2019",null,null,"Age",{"$f":"DATEDIF(INDEX(G:G,L3),TODAY(),\"y\")","v":13}]
[11,"Renard","Noah",{"$f":"B14&\" \"&C14","v":"Renard Noah"},"1D","D101","02/08/2006","01/09/2019"]
[12,"Renard2","Noah",{"$f":"B15&\" \"&C15","v":"Renard2 Noah"},"1D","D102","02/08/2007","01/09/2020"]
[13,"Herrmann","Sam",{"$f":"B16&\" \"&C16","v":"Herrmann Sam"},"1D","D101","06/09/2006","01/09/2019",null,null,{"$f":"\"*\"&K9&\"*\"","v":"*Nyavo Anaëlle*"}]
[14,"Gueye","Serigne",{"$f":"B17&\" \"&C17","v":"Gueye Serigne"},"1D","D101","06/11/2005","01/09/2019"]
[15,"Ferry","Yoann",{"$f":"B18&\" \"&C18","v":"Ferry Yoann"},"1D","D101","31/01/2007","01/09/2019"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Nyavo Anaëlle"]
[]
[null,null,null,null,null,null,null,null,null,null,"Choisir l'élève  ^^^^"]

{"sheet":"2C1","index":3,"n_rows":24,"n_cols":38,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,16,2,16],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,20,2,20],[1,33,2,33],[8,10,9,12],[1,27,2,27],[1,28,2,28],[1,29,2,29],[1,30,2,30],[1,31,2,31],[1,32,2,32],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,15,2,15]]}
[null,null,null,null,null,null,null,null,null,null,"SOMMAIRE"]
[null,null,null,null,null,null,null,null,null,null,"index","ligne",null,null,null,{"$f":"INDIRECT(\"$D$\"&COLUMN()-12,TRUE)","v":"Amaro Dario"},{"$f":"INDIRECT(\"$D$\"&COLUMN()-12,TRUE)","v":"Bakis Ahmet"},"Bernard Emeline","Caldaras Franco-Roberto","Demarteau Alessio","Ferry Yoann","Gueye Serigne","Herrmann Sam","Nyavo Anaëlle","Renard Noah","Renard2 Noah","NomEleve1 Dario","NomEleve2 Ahmet","NomEleve3 Emeline","NomEleve4 Franco-Roberto",0,0,0,0]
["N°","Nom Elève","Prénom Elève","Nom-Prenom","AnFF","Orientation","DateNaiss","Date Entrée Ecole",null,null,{"$f":"MATCH(L22,Elèves,0)","v":6},{"$f":"K3+3","v":9}]
[{"$f":"ROW()-3","v":1},"Amaro","Dario",{"$f":"B4&\" \"&C4","v":"Amaro Dario"},"2C1","D101","20/07/2007","01/09/2019",null,null,null,null,null,"Année Scolaire 2019-2020"]
[2,"Bakis","Ahmet",{"$f":"B5&\" \"&C5","v":"Bakis Ahmet"},"2C1","D101","25/06/2006","17/10/2019"]
[3,"Bernard","Emeline","Bernard Emeline","2C1","D101","10/09/2006","01/09/2019",null,null,null,null,null,"Carte de cantine"]
[4,"Caldaras","Franco-Roberto","Caldaras Franco-Roberto","2C1","D101","17/06/2006","01/09/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo","Manque Photo"]
[5,"Demarteau","Alessio","Demarteau Alessio","2C1","D101","09/09/2006","01/09/2019",null,null,"Eléve"]
[6,"Ferry","Yoann","Ferry Yoann","2C1","D101","31/01/2007","01/09/2019",null,null,{"$f":"INDEX(Elèves,K3,)","v":"Ferry Yoann"}]
[7,"Gueye","Serigne","Gueye Serigne","2C1","D101","06/11/2005","01/09/2019"]
[8,"Herrmann","Sam","Herrmann Sam","2C1","D101","06/09/2006","01/09/2019",null,null,"Classe ",{"$f":"INDEX(E:E,L3)","v":"2C1"}]
[9,"Nyavo","Anaëlle","Nyavo Anaëlle","2C1","D101","10/08/2006","01/09/2019"]
[10,"Renard","Noah","Renard Noah","2C1","D101","02/08/2006","01/09/2019",null,null,"Age",{"$f":"DATEDIF(INDEX(G:G,L3),TODAY(),\"y\")","v":13}]
[11,"Renard2","Noah","Renard2 Noah","2C1","D102","02/08/2007","01/09/2020"]
[12,"NomEleve1","Dario","NomEleve1 Dario","2C1","D101","20/07/2007","01/09/2019"]
[13,"NomEleve2","Ahmet","NomEleve2 Ahmet","2C1","D101","25/06/2006","17/10/2019",null,null,{"$f":"\"*\"&K9&\"*\"","v":"*Ferry Yoann*"}]
[14,"NomEleve3","Emeline","NomEleve3 Emeline","2C1","D101","10/09/2006","01/09/2019"]
[15,"NomEleve4","Franco-Roberto","NomEleve4 Franco-Roberto","2C1","D101","17/06/2006","01/09/2019"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ferry Yoann"]
[]
[null,null,null,null,null,null,null,null,null,null,"Choisir l'élève  ^^^^"]

{"sheet":"Ajout","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"SOMMAIRE"]
[]
[null,1,"Dupliquer la feuille 1C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2," renommer le nouvel onglet selon le nom choisi au sommaire"]
[]
[null,3,"mettre à jour les nouvelles données",null,null,"(utilisation des fonctionnalités de Tableau)"]
[]
[null,4,"mettre à jour les nouvelles photos "]
[null,null,null,". à partir de la colonne P6"]
[null,null,null,". Ajuster chaque photo sur 1 colonne 5 lignes (utiliser les poignées de recopie conjointement à l'appui de la touche Alt  => alignement sur les limites de cellules)"]
[]
[]
[null,"Nb : "]
[null,null,"La zone d'impression est définie à la taille de la carte de cantine",null,null,null,null,"$J$3:$O$18"]
[null,null,"Utiliser les commandes standard pour impression"]