{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["APPEL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"APPEL","index":0,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,19,3,20],[3,22,3,23],[3,25,3,26],[3,1,3,2],[3,4,3,5],[3,7,3,8],[3,10,3,11],[3,13,3,14],[3,16,3,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Formule pr dissocier NOMS PRENOMS=SI(ESTNUM(TROUVE(\" \";A1));GAUCHE(A1;TROUVE(\" \";A1)-1);\"\")",null,null,null,null,null,null,null,null,null,"=SI(ESTNUM(TROUVE(\" \";A1));STXT(A1;TROUVE(\" \";A1)+1;99);\"\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"formule pr trouver élève ds tableau=INDEX(eleve;EQUIV(i1;numero;0);EQUIV(J1;classe;0))",null,null,null,null,null,null,null,"Il faut avant tout créer noms : classe, numero et eleve"]
[null,null,null,null,null,null,null,null,null,null,null,"formule choix classe ->",null,"'=si($B$2=APPEL!$B$1;classe1;si($B$2=APPEL!$e$1;classe2;si($B$2=APPEL!$H$1;classe3;si($B$2=APPEL!$K$1;classe4;si($B$2=APPEL!$N$1;classe5;si($B$2=APPEL!$q$1;classe6;si($B$2=APPEL!$t$1;classe7;si($B$2=APPEL!$w$1;classe8;si($B$2=APPEL!$z$1;classe9)))))))))"]
[null,"1GA",null,null,"2TU",null,null,"3PP",null,null,"1TV",null,null,"1COM",null,null,"TMELEC",null,null,"1META",null,null,"TPROE",null,null,"TEVS"]
[null,"PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe","PRENOMS","NOMS","sexe"]
[1,"Amira","Amira","F","Achraf","Achraf","g","Adam","Adam","g","Baptiste","Baptiste",null,"Alaudin","Alaudin","g","Alain","Alain","g","Abdel Nour","Abdel Nour","g","Aboubacar","Aboubacar","g","Aejaz","Aejaz","g"]
[2,"Estelle","Estelle","F","Ali-Han","Alaeddine","g","Amine","Amine","g","Rémy","Rémy",null,"Anissa","Anissa","F","Aslem","Aslem","g","Eric","Eric","g","Bafode","Bafode","g","Ahmad","Ahmad","g"]
[3,"Gentjana","Gentjana","F","Alpha Oumar","Alpha Oumar","g","Anis","Anis","g","Théo","Théo",null,"Arthur","Arthur","g","Erol","Erol","g","Hamza","Hamza","g","Cristiano","Cristiano","g","Angel","Angel","F"]
[4,"Kamylia","Kamylia","F","Amadou","Amadou","g","Anthony","Anthony","g","Maxime","Maxime",null,"Brinna","Brinna","F","Hamza","Hamza","g","Mamadou Oury","Mamadou Oury","g","Emil","Emil","g","Ani","Ani","F"]
[5,"Kathy","Kathy","F","Ensar","Ensar","g","Bilel","Bilel","g","Smaïn","Smaïn",null,"Chahla","Chahla","F","Idriss","Idriss","g","Naby","Naby","g","Fahari","Fahari","g","Chaima","Chaima","F"]
[6,"Maïssa","Maïssa","F","Hamza","Hamza","g","Can","Can","g","Nour","Nour",null,"Chamina","Chamina","F","Iliess","Iliess","g","Salim","Salim","g","Fazil","Fazil","g","Chainese","Chainese","g"]
[7,"Maryka","Maryka","F","Ibrahim","Ibrahim","g","Cherine","Cherine","F","Raymond","Raymond",null,"Claudia","Claudia","F","Ismaïl","Ismaïl","g","Sean","Sean","g","Ibrahim","Ibrahim","g","Fjorel","Fjorel","g"]
[8,"Mounir","Mounir","g","Imad","Imad","g","Eden","Eden","F",null,null,null,"Daniela","Daniela","F","Jessim","Jessim","g","Simon","Simon","g","Jawad","Jawad","g","Howeyda","Howeyda","F"]
[9,"Mounir","Mounir","g","Mamadou Gando","Mamadou Gando","g","Elyes","Elyes","g",null,null,null,"Eva","Eva","F","Khalil","Khalil","g","Souleymane Thierno","Souleymane Thierno","g","Khemandeef","Khemandeef","g","Kaïs","Yolan","g"]
[10,"Munire","Munire","F","Mohamed","Mohamed","g","Farok","Farok","g",null,null,null,"Intissar","Intissar","F","Namereq","Namereq","g","Soumaila","Soumaila","g","Mourad","Mourad","g","Lucie","Lucie","F"]
[11,"Nesrin","Nesrin","F","Walid","Walid","g","Hamza","Hamza","g",null,null,null,"Ivan","Ivan","g","Rayan","Rayan","g","Théo","Théo","g",null,"Redouane",null,"Maily","Maily","F"]
[12,"Nissrine","Nissrine","F","Wassime","Wassime","g","Hosna","Hosna","F",null,null,null,"Kannelle","Kannelle","F","Sandro","Sandro","g","Yanis","Yanis","g",null,null,null,"Mounia","Mounia","F"]
[13,"Rith Assirie","Rith Assirie","F",null,"Boubacar",null,"Jérémy","Jérémy","g",null,null,null,"Kia","Kia","F","Wassim","Wassim","g",null,"Amara",null,null,null,null,"Pticem","Pticem","F"]
[14,"Ruheda Nefisse","Ruheda Nefisse","F",null,"Lamine",null,"Jordan","Jordan","g",null,null,null,"Léonardo","Léonardo","g",null,null,null,null,"Eldin ",null,null,null,null,"Sarah","Sarah","F"]
[15,"Sendes","Sendes","F",null,"Pedro",null,"Kevin","Kevin","g",null,null,null,"Naima","Naima","F",null,null,null,null,"Enis",null,null,null,null,"Sophie","Sophie","F"]
[16,"Shaïnez","Shaïnez","F",null,"Riard",null,"Lukas","Lukas","g",null,null,null,"Naïma","Naïma","F"]
[17,"Sihem","Sihem","F",null,"yanis",null,"Meliana","Meliana","F",null,null,null,"Nasir","Nasir","g"]
[18,"Sueda","Sueda","F",null,null,"g","Muhammed-Yusuf","Muhammed-Yusuf","g",null,null,null,"Riad","Riad","g"]
[19,"Zamira","Zamira","F",null,null,null,"Noha","Noha","F",null,null,null,"Sofiane","Sofiane","g"]
[20,"Zoulfa","Zoulfa","F",null,null,null,"Ricardo","Ricardo","g",null,null,null,"Teguil","Teguil","g"]
[21,"Zumra","Zumra","F",null,null,null,"Tony","Tony","g",null,null,null,"Walid","Walid","g"]
[22,null,null,null,null,null,null,"Wassime","Wassime","g",null,null,null,"Zakaria","Zakaria","g"]
[23,null,null,null,null,null,null,"Wilberlyn","Wilberlyn","F",null,null,null,null,"Célia"]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]