{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ACCUEIL","Classeauto","Choixeleves","Choixeleves (2)","MONBAREME","MACROS","SAELEVE1","REFERENTIELS","APPEL","DEBUT","SAMICBIS"],"not_rendered":{"charts":0,"images":59,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"ACCUEIL","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"1- Avant de commencer : dupliquez ce document et renommez le selon vos envies"]
[null,"ACCUEIL","CLASSES","DEBUT",null,"2- Supprimez les onglets et boutons inutiles (les colonnes et lignes aussi)"]
[null,null,null,null,null,"3- Créez votre appli"]
[]
[]
[]
[]
[null,"APP1","APP2","APP3"]
[]
[]
[]
[]
[]
[null,"SA"]
[]
[]
[]
[]
[]
[]
[]
[null,"Niveau 3","Niveau 4","Evaluation Cycle"]

{"sheet":"Classeauto","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,17,2,20],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[0,5,2,14],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[3,1,3,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[18,1,18,2],[19,1,19,2]]}
[null,"Classe "]
[null,"1TU-GA",null,null,"N4"]
[]
[null,"Elèves"]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B5,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B5,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B5,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B5,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B5,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B5,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B5,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B5,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B5,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C3,IF($B$2=APPEL!$E$1,APPEL!F3,IF($B$2=APPEL!$H$1,APPEL!I3,IF($B$2=APPEL!$K$1,APPEL!L3,IF($B$2=APPEL!$N$1,APPEL!O3,IF($B$2=APPEL!$Q$1,APPEL!R3,IF($B$2=APPEL!$T$1,APPEL!U3,IF($B$2=APPEL!$W$1,APPEL!X3,IF($B$2=APPEL!$Z$1,APPEL!AA3)))))))))","v":"Abraham"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B6,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B6,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B6,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B6,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B6,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B6,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B6,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B6,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B6,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C4,IF($B$2=APPEL!$E$1,APPEL!F4,IF($B$2=APPEL!$H$1,APPEL!I4,IF($B$2=APPEL!$K$1,APPEL!L4,IF($B$2=APPEL!$N$1,APPEL!O4,IF($B$2=APPEL!$Q$1,APPEL!R4,IF($B$2=APPEL!$T$1,APPEL!U4,IF($B$2=APPEL!$W$1,APPEL!X4,IF($B$2=APPEL!$Z$1,APPEL!AA4)))))))))","v":"Aimane"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B7,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B7,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B7,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B7,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B7,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B7,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B7,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B7,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B7,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C5,IF($B$2=APPEL!$E$1,APPEL!F5,IF($B$2=APPEL!$H$1,APPEL!I5,IF($B$2=APPEL!$K$1,APPEL!L5,IF($B$2=APPEL!$N$1,APPEL!O5,IF($B$2=APPEL!$Q$1,APPEL!R5,IF($B$2=APPEL!$T$1,APPEL!U5,IF($B$2=APPEL!$W$1,APPEL!X5,IF($B$2=APPEL!$Z$1,APPEL!AA5)))))))))","v":"Amel"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B8,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B8,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B8,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B8,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B8,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B8,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B8,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B8,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B8,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C6,IF($B$2=APPEL!$E$1,APPEL!F6,IF($B$2=APPEL!$H$1,APPEL!I6,IF($B$2=APPEL!$K$1,APPEL!L6,IF($B$2=APPEL!$N$1,APPEL!O6,IF($B$2=APPEL!$Q$1,APPEL!R6,IF($B$2=APPEL!$T$1,APPEL!U6,IF($B$2=APPEL!$W$1,APPEL!X6,IF($B$2=APPEL!$Z$1,APPEL!AA6)))))))))","v":"Amira"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B9,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B9,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B9,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B9,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B9,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B9,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B9,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B9,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B9,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C7,IF($B$2=APPEL!$E$1,APPEL!F7,IF($B$2=APPEL!$H$1,APPEL!I7,IF($B$2=APPEL!$K$1,APPEL!L7,IF($B$2=APPEL!$N$1,APPEL!O7,IF($B$2=APPEL!$Q$1,APPEL!R7,IF($B$2=APPEL!$T$1,APPEL!U7,IF($B$2=APPEL!$W$1,APPEL!X7,IF($B$2=APPEL!$Z$1,APPEL!AA7)))))))))","v":"Anis"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B10,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B10,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B10,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B10,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B10,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B10,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B10,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B10,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B10,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C8,IF($B$2=APPEL!$E$1,APPEL!F8,IF($B$2=APPEL!$H$1,APPEL!I8,IF($B$2=APPEL!$K$1,APPEL!L8,IF($B$2=APPEL!$N$1,APPEL!O8,IF($B$2=APPEL!$Q$1,APPEL!R8,IF($B$2=APPEL!$T$1,APPEL!U8,IF($B$2=APPEL!$W$1,APPEL!X8,IF($B$2=APPEL!$Z$1,APPEL!AA8)))))))))","v":"Beyza"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B11,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B11,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B11,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B11,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B11,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B11,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B11,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B11,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B11,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C9,IF($B$2=APPEL!$E$1,APPEL!F9,IF($B$2=APPEL!$H$1,APPEL!I9,IF($B$2=APPEL!$K$1,APPEL!L9,IF($B$2=APPEL!$N$1,APPEL!O9,IF($B$2=APPEL!$Q$1,APPEL!R9,IF($B$2=APPEL!$T$1,APPEL!U9,IF($B$2=APPEL!$W$1,APPEL!X9,IF($B$2=APPEL!$Z$1,APPEL!AA9)))))))))","v":"Clarky"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B12,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B12,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B12,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B12,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B12,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B12,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B12,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B12,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B12,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C10,IF($B$2=APPEL!$E$1,APPEL!F10,IF($B$2=APPEL!$H$1,APPEL!I10,IF($B$2=APPEL!$K$1,APPEL!L10,IF($B$2=APPEL!$N$1,APPEL!O10,IF($B$2=APPEL!$Q$1,APPEL!R10,IF($B$2=APPEL!$T$1,APPEL!U10,IF($B$2=APPEL!$W$1,APPEL!X10,IF($B$2=APPEL!$Z$1,APPEL!AA10)))))))))","v":"Djamel"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B13,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B13,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B13,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B13,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B13,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B13,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B13,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B13,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B13,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C11,IF($B$2=APPEL!$E$1,APPEL!F11,IF($B$2=APPEL!$H$1,APPEL!I11,IF($B$2=APPEL!$K$1,APPEL!L11,IF($B$2=APPEL!$N$1,APPEL!O11,IF($B$2=APPEL!$Q$1,APPEL!R11,IF($B$2=APPEL!$T$1,APPEL!U11,IF($B$2=APPEL!$W$1,APPEL!X11,IF($B$2=APPEL!$Z$1,APPEL!AA11)))))))))","v":"Dounia"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B14,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B14,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B14,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B14,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B14,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B14,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B14,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B14,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B14,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C12,IF($B$2=APPEL!$E$1,APPEL!F12,IF($B$2=APPEL!$H$1,APPEL!I12,IF($B$2=APPEL!$K$1,APPEL!L12,IF($B$2=APPEL!$N$1,APPEL!O12,IF($B$2=APPEL!$Q$1,APPEL!R12,IF($B$2=APPEL!$T$1,APPEL!U12,IF($B$2=APPEL!$W$1,APPEL!X12,IF($B$2=APPEL!$Z$1,APPEL!AA12)))))))))","v":"Eyat"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B15,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B15,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B15,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B15,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B15,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B15,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B15,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B15,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B15,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C13,IF($B$2=APPEL!$E$1,APPEL!F13,IF($B$2=APPEL!$H$1,APPEL!I13,IF($B$2=APPEL!$K$1,APPEL!L13,IF($B$2=APPEL!$N$1,APPEL!O13,IF($B$2=APPEL!$Q$1,APPEL!R13,IF($B$2=APPEL!$T$1,APPEL!U13,IF($B$2=APPEL!$W$1,APPEL!X13,IF($B$2=APPEL!$Z$1,APPEL!AA13)))))))))","v":"Fatima-Zohra"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B16,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B16,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B16,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B16,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B16,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B16,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B16,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B16,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B16,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C14,IF($B$2=APPEL!$E$1,APPEL!F14,IF($B$2=APPEL!$H$1,APPEL!I14,IF($B$2=APPEL!$K$1,APPEL!L14,IF($B$2=APPEL!$N$1,APPEL!O14,IF($B$2=APPEL!$Q$1,APPEL!R14,IF($B$2=APPEL!$T$1,APPEL!U14,IF($B$2=APPEL!$W$1,APPEL!X14,IF($B$2=APPEL!$Z$1,APPEL!AA14)))))))))","v":"Hana"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B17,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B17,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B17,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B17,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B17,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B17,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B17,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B17,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B17,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C15,IF($B$2=APPEL!$E$1,APPEL!F15,IF($B$2=APPEL!$H$1,APPEL!I15,IF($B$2=APPEL!$K$1,APPEL!L15,IF($B$2=APPEL!$N$1,APPEL!O15,IF($B$2=APPEL!$Q$1,APPEL!R15,IF($B$2=APPEL!$T$1,APPEL!U15,IF($B$2=APPEL!$W$1,APPEL!X15,IF($B$2=APPEL!$Z$1,APPEL!AA15)))))))))","v":"Ikram"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B18,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B18,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B18,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B18,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B18,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B18,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B18,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B18,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B18,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C16,IF($B$2=APPEL!$E$1,APPEL!F16,IF($B$2=APPEL!$H$1,APPEL!I16,IF($B$2=APPEL!$K$1,APPEL!L16,IF($B$2=APPEL!$N$1,APPEL!O16,IF($B$2=APPEL!$Q$1,APPEL!R16,IF($B$2=APPEL!$T$1,APPEL!U16,IF($B$2=APPEL!$W$1,APPEL!X16,IF($B$2=APPEL!$Z$1,APPEL!AA16)))))))))","v":"Jairzhino"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B19,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B19,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B19,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B19,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B19,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B19,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B19,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B19,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B19,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C17,IF($B$2=APPEL!$E$1,APPEL!F17,IF($B$2=APPEL!$H$1,APPEL!I17,IF($B$2=APPEL!$K$1,APPEL!L17,IF($B$2=APPEL!$N$1,APPEL!O17,IF($B$2=APPEL!$Q$1,APPEL!R17,IF($B$2=APPEL!$T$1,APPEL!U17,IF($B$2=APPEL!$W$1,APPEL!X17,IF($B$2=APPEL!$Z$1,APPEL!AA17)))))))))","v":"Mergim"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B20,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B20,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B20,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B20,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B20,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B20,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B20,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B20,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B20,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C18,IF($B$2=APPEL!$E$1,APPEL!F18,IF($B$2=APPEL!$H$1,APPEL!I18,IF($B$2=APPEL!$K$1,APPEL!L18,IF($B$2=APPEL!$N$1,APPEL!O18,IF($B$2=APPEL!$Q$1,APPEL!R18,IF($B$2=APPEL!$T$1,APPEL!U18,IF($B$2=APPEL!$W$1,APPEL!X18,IF($B$2=APPEL!$Z$1,APPEL!AA18)))))))))","v":"Myriam"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B21,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B21,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B21,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B21,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B21,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B21,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B21,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B21,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B21,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C19,IF($B$2=APPEL!$E$1,APPEL!F19,IF($B$2=APPEL!$H$1,APPEL!I19,IF($B$2=APPEL!$K$1,APPEL!L19,IF($B$2=APPEL!$N$1,APPEL!O19,IF($B$2=APPEL!$Q$1,APPEL!R19,IF($B$2=APPEL!$T$1,APPEL!U19,IF($B$2=APPEL!$W$1,APPEL!X19,IF($B$2=APPEL!$Z$1,APPEL!AA19)))))))))","v":"Serone"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B22,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B22,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B22,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B22,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B22,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B22,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B22,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B22,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B22,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C20,IF($B$2=APPEL!$E$1,APPEL!F20,IF($B$2=APPEL!$H$1,APPEL!I20,IF($B$2=APPEL!$K$1,APPEL!L20,IF($B$2=APPEL!$N$1,APPEL!O20,IF($B$2=APPEL!$Q$1,APPEL!R20,IF($B$2=APPEL!$T$1,APPEL!U20,IF($B$2=APPEL!$W$1,APPEL!X20,IF($B$2=APPEL!$Z$1,APPEL!AA20)))))))))","v":"Suha"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B23,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B23,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B23,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B23,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B23,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B23,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B23,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B23,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B23,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C21,IF($B$2=APPEL!$E$1,APPEL!F21,IF($B$2=APPEL!$H$1,APPEL!I21,IF($B$2=APPEL!$K$1,APPEL!L21,IF($B$2=APPEL!$N$1,APPEL!O21,IF($B$2=APPEL!$Q$1,APPEL!R21,IF($B$2=APPEL!$T$1,APPEL!U21,IF($B$2=APPEL!$W$1,APPEL!X21,IF($B$2=APPEL!$Z$1,APPEL!AA21)))))))))","v":"Yassine"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B24,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B24,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B24,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B24,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B24,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B24,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B24,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B24,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B24,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C22,IF($B$2=APPEL!$E$1,APPEL!F22,IF($B$2=APPEL!$H$1,APPEL!I22,IF($B$2=APPEL!$K$1,APPEL!L22,IF($B$2=APPEL!$N$1,APPEL!O22,IF($B$2=APPEL!$Q$1,APPEL!R22,IF($B$2=APPEL!$T$1,APPEL!U22,IF($B$2=APPEL!$W$1,APPEL!X22,IF($B$2=APPEL!$Z$1,APPEL!AA22)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B25,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B25,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B25,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B25,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B25,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B25,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B25,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B25,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B25,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C23,IF($B$2=APPEL!$E$1,APPEL!F23,IF($B$2=APPEL!$H$1,APPEL!I23,IF($B$2=APPEL!$K$1,APPEL!L23,IF($B$2=APPEL!$N$1,APPEL!O23,IF($B$2=APPEL!$Q$1,APPEL!R23,IF($B$2=APPEL!$T$1,APPEL!U23,IF($B$2=APPEL!$W$1,APPEL!X23,IF($B$2=APPEL!$Z$1,APPEL!AA23)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B26,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B26,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B26,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B26,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B26,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B26,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B26,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B26,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B26,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C24,IF($B$2=APPEL!$E$1,APPEL!F24,IF($B$2=APPEL!$H$1,APPEL!I24,IF($B$2=APPEL!$K$1,APPEL!L24,IF($B$2=APPEL!$N$1,APPEL!O24,IF($B$2=APPEL!$Q$1,APPEL!R24,IF($B$2=APPEL!$T$1,APPEL!U24,IF($B$2=APPEL!$W$1,APPEL!X24,IF($B$2=APPEL!$Z$1,APPEL!AA24)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B27,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B27,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B27,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B27,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B27,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B27,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B27,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B27,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B27,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C25,IF($B$2=APPEL!$E$1,APPEL!F25,IF($B$2=APPEL!$H$1,APPEL!I25,IF($B$2=APPEL!$K$1,APPEL!L25,IF($B$2=APPEL!$N$1,APPEL!O25,IF($B$2=APPEL!$Q$1,APPEL!R25,IF($B$2=APPEL!$T$1,APPEL!U25,IF($B$2=APPEL!$W$1,APPEL!X25,IF($B$2=APPEL!$Z$1,APPEL!AA25)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B28,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B28,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B28,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B28,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B28,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B28,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B28,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B28,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B28,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C26,IF($B$2=APPEL!$E$1,APPEL!F26,IF($B$2=APPEL!$H$1,APPEL!I26,IF($B$2=APPEL!$K$1,APPEL!L26,IF($B$2=APPEL!$N$1,APPEL!O26,IF($B$2=APPEL!$Q$1,APPEL!R26,IF($B$2=APPEL!$T$1,APPEL!U26,IF($B$2=APPEL!$W$1,APPEL!X26,IF($B$2=APPEL!$Z$1,APPEL!AA26)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B29,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B29,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B29,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B29,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B29,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B29,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B29,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B29,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B29,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C27,IF($B$2=APPEL!$E$1,APPEL!F27,IF($B$2=APPEL!$H$1,APPEL!I27,IF($B$2=APPEL!$K$1,APPEL!L27,IF($B$2=APPEL!$N$1,APPEL!O27,IF($B$2=APPEL!$Q$1,APPEL!R27,IF($B$2=APPEL!$T$1,APPEL!U27,IF($B$2=APPEL!$W$1,APPEL!X27,IF($B$2=APPEL!$Z$1,APPEL!AA27)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B30,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B30,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B30,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B30,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B30,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B30,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B30,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B30,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B30,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C28,IF($B$2=APPEL!$E$1,APPEL!F28,IF($B$2=APPEL!$H$1,APPEL!I28,IF($B$2=APPEL!$K$1,APPEL!L28,IF($B$2=APPEL!$N$1,APPEL!O28,IF($B$2=APPEL!$Q$1,APPEL!R28,IF($B$2=APPEL!$T$1,APPEL!U28,IF($B$2=APPEL!$W$1,APPEL!X28,IF($B$2=APPEL!$Z$1,APPEL!AA28)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B31,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B31,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B31,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B31,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B31,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B31,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B31,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B31,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B31,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C29,IF($B$2=APPEL!$E$1,APPEL!F29,IF($B$2=APPEL!$H$1,APPEL!I29,IF($B$2=APPEL!$K$1,APPEL!L29,IF($B$2=APPEL!$N$1,APPEL!O29,IF($B$2=APPEL!$Q$1,APPEL!R29,IF($B$2=APPEL!$T$1,APPEL!U29,IF($B$2=APPEL!$W$1,APPEL!X29,IF($B$2=APPEL!$Z$1,APPEL!AA29)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B32,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B32,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B32,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B32,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B32,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B32,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B32,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B32,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B32,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C30,IF($B$2=APPEL!$E$1,APPEL!F30,IF($B$2=APPEL!$H$1,APPEL!I30,IF($B$2=APPEL!$K$1,APPEL!L30,IF($B$2=APPEL!$N$1,APPEL!O30,IF($B$2=APPEL!$Q$1,APPEL!R30,IF($B$2=APPEL!$T$1,APPEL!U30,IF($B$2=APPEL!$W$1,APPEL!X30,IF($B$2=APPEL!$Z$1,APPEL!AA30)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B33,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B33,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B33,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B33,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B33,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B33,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B33,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B33,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B33,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C31,IF($B$2=APPEL!$E$1,APPEL!F31,IF($B$2=APPEL!$H$1,APPEL!I31,IF($B$2=APPEL!$K$1,APPEL!L31,IF($B$2=APPEL!$N$1,APPEL!O31,IF($B$2=APPEL!$Q$1,APPEL!R31,IF($B$2=APPEL!$T$1,APPEL!U31,IF($B$2=APPEL!$W$1,APPEL!X31,IF($B$2=APPEL!$Z$1,APPEL!AA31)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B34,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B34,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B34,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B34,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B34,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B34,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B34,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B34,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B34,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C32,IF($B$2=APPEL!$E$1,APPEL!F32,IF($B$2=APPEL!$H$1,APPEL!I32,IF($B$2=APPEL!$K$1,APPEL!L32,IF($B$2=APPEL!$N$1,APPEL!O32,IF($B$2=APPEL!$Q$1,APPEL!R32,IF($B$2=APPEL!$T$1,APPEL!U32,IF($B$2=APPEL!$W$1,APPEL!X32,IF($B$2=APPEL!$Z$1,APPEL!AA32)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B35,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B35,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B35,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B35,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B35,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B35,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B35,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B35,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B35,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C33,IF($B$2=APPEL!$E$1,APPEL!F33,IF($B$2=APPEL!$H$1,APPEL!I33,IF($B$2=APPEL!$K$1,APPEL!L33,IF($B$2=APPEL!$N$1,APPEL!O33,IF($B$2=APPEL!$Q$1,APPEL!R33,IF($B$2=APPEL!$T$1,APPEL!U33,IF($B$2=APPEL!$W$1,APPEL!X33,IF($B$2=APPEL!$Z$1,APPEL!AA33)))))))))","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B36,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B36,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B36,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B36,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B36,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B36,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B36,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B36,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B36,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C34,IF($B$2=APPEL!$E$1,APPEL!F34,IF($B$2=APPEL!$H$1,APPEL!I34,IF($B$2=APPEL!$K$1,APPEL!L34,IF($B$2=APPEL!$N$1,APPEL!O34,IF($B$2=APPEL!$Q$1,APPEL!R34,IF($B$2=APPEL!$T$1,APPEL!U34,IF($B$2=APPEL!$W$1,APPEL!X34,IF($B$2=APPEL!$Z$1,APPEL!AA34)))))))))","v":0}]

{"sheet":"Choixeleves","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Classe "]
[null,{"$f":"Classeauto!B2","v":"1TU-GA"}]
[]
[null,"Elèves"]
[null,"Amel"]
[null,"Abraham"]

{"sheet":"Choixeleves (2)","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Classe "]
[null,{"$f":"Classeauto!B2","v":"1TU-GA"}]
[]
[null,"Elèves ->","Abraham","Amel"]

{"sheet":"MONBAREME","index":4,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[30,1,30,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[18,1,18,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[6,1,6,2],[0,5,2,10],[0,13,2,16],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[null,"Classe "]
[null,"1TU-GA",null,null,"N4"]
[]
[null,"Elèves",null,{"$f":"Tableau4[[#Headers],[CRITERE 1]]","v":"CRITERE 1"},{"$f":"Tableau4[[#Headers],[CRITERE 2]]","v":"CRITERE 2"},{"$f":"Tableau4[[#Headers],[CRITERE 3]]","v":"CRITERE 3"},{"$f":"Tableau4[[#Headers],[CRITERE 4]]","v":"CRITERE 4"},{"$f":"Tableau46[[#Headers],[C1]]","v":"C1"},{"$f":"Tableau46[[#Headers],[C2]]","v":"C2"},{"$f":"Tableau46[[#Headers],[C3]]","v":"C3"},{"$f":"Tableau46[[#Headers],[C4]]","v":"C4"}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B5,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B5,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B5,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B5,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B5,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B5,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B5,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B5,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B5,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C3,IF($B$2=APPEL!$E$1,APPEL!F3,IF($B$2=APPEL!$H$1,APPEL!I3,IF($B$2=APPEL!$K$1,APPEL!L3,IF($B$2=APPEL!$N$1,APPEL!O3,IF($B$2=APPEL!$Q$1,APPEL!R3,IF($B$2=APPEL!$T$1,APPEL!U3,IF($B$2=APPEL!$W$1,APPEL!X3,IF($B$2=APPEL!$Z$1,APPEL!AA3)))))))))","v":"Abraham"},null,"il a fait ça",{"$f":"IFERROR(VLOOKUP(D5,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":"il a donc cette note la"},{"$f":"IFERROR(VLOOKUP(D5,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":"Et je lui dis"},{"$f":"IFERROR(VLOOKUP(D5,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":18},"Très satisfaisant",{"$f":"IFERROR(VLOOKUP(H5,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(H5,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(H5,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B6,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B6,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B6,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B6,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B6,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B6,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B6,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B6,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B6,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C4,IF($B$2=APPEL!$E$1,APPEL!F4,IF($B$2=APPEL!$H$1,APPEL!I4,IF($B$2=APPEL!$K$1,APPEL!L4,IF($B$2=APPEL!$N$1,APPEL!O4,IF($B$2=APPEL!$Q$1,APPEL!R4,IF($B$2=APPEL!$T$1,APPEL!U4,IF($B$2=APPEL!$W$1,APPEL!X4,IF($B$2=APPEL!$Z$1,APPEL!AA4)))))))))","v":"Aimane"},null,"7\"",{"$f":"IFERROR(VLOOKUP(D6,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":"12/20"},{"$f":"IFERROR(VLOOKUP(D6,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":"BRAVO"},{"$f":"IFERROR(VLOOKUP(D6,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":"+++"},"Insuffisant",{"$f":"IFERROR(VLOOKUP(H6,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(H6,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(H6,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B7,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B7,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B7,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B7,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B7,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B7,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B7,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B7,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B7,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C5,IF($B$2=APPEL!$E$1,APPEL!F5,IF($B$2=APPEL!$H$1,APPEL!I5,IF($B$2=APPEL!$K$1,APPEL!L5,IF($B$2=APPEL!$N$1,APPEL!O5,IF($B$2=APPEL!$Q$1,APPEL!R5,IF($B$2=APPEL!$T$1,APPEL!U5,IF($B$2=APPEL!$W$1,APPEL!X5,IF($B$2=APPEL!$Z$1,APPEL!AA5)))))))))","v":"Amel"},null,null,{"$f":"IFERROR(VLOOKUP(D7,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D7,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D7,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},"Moyen",{"$f":"IFERROR(VLOOKUP(H7,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(H7,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(H7,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":0}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B8,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B8,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B8,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B8,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B8,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B8,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B8,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B8,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B8,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C6,IF($B$2=APPEL!$E$1,APPEL!F6,IF($B$2=APPEL!$H$1,APPEL!I6,IF($B$2=APPEL!$K$1,APPEL!L6,IF($B$2=APPEL!$N$1,APPEL!O6,IF($B$2=APPEL!$Q$1,APPEL!R6,IF($B$2=APPEL!$T$1,APPEL!U6,IF($B$2=APPEL!$W$1,APPEL!X6,IF($B$2=APPEL!$Z$1,APPEL!AA6)))))))))","v":"Amira"},null,null,{"$f":"IFERROR(VLOOKUP(D8,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D8,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D8,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H8,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H8,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H8,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B9,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B9,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B9,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B9,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B9,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B9,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B9,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B9,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B9,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C7,IF($B$2=APPEL!$E$1,APPEL!F7,IF($B$2=APPEL!$H$1,APPEL!I7,IF($B$2=APPEL!$K$1,APPEL!L7,IF($B$2=APPEL!$N$1,APPEL!O7,IF($B$2=APPEL!$Q$1,APPEL!R7,IF($B$2=APPEL!$T$1,APPEL!U7,IF($B$2=APPEL!$W$1,APPEL!X7,IF($B$2=APPEL!$Z$1,APPEL!AA7)))))))))","v":"Anis"},null,null,{"$f":"IFERROR(VLOOKUP(D9,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D9,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D9,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H9,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H9,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H9,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B10,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B10,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B10,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B10,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B10,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B10,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B10,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B10,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B10,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C8,IF($B$2=APPEL!$E$1,APPEL!F8,IF($B$2=APPEL!$H$1,APPEL!I8,IF($B$2=APPEL!$K$1,APPEL!L8,IF($B$2=APPEL!$N$1,APPEL!O8,IF($B$2=APPEL!$Q$1,APPEL!R8,IF($B$2=APPEL!$T$1,APPEL!U8,IF($B$2=APPEL!$W$1,APPEL!X8,IF($B$2=APPEL!$Z$1,APPEL!AA8)))))))))","v":"Beyza"},null,null,{"$f":"IFERROR(VLOOKUP(D10,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D10,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D10,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H10,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H10,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H10,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B11,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B11,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B11,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B11,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B11,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B11,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B11,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B11,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B11,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C9,IF($B$2=APPEL!$E$1,APPEL!F9,IF($B$2=APPEL!$H$1,APPEL!I9,IF($B$2=APPEL!$K$1,APPEL!L9,IF($B$2=APPEL!$N$1,APPEL!O9,IF($B$2=APPEL!$Q$1,APPEL!R9,IF($B$2=APPEL!$T$1,APPEL!U9,IF($B$2=APPEL!$W$1,APPEL!X9,IF($B$2=APPEL!$Z$1,APPEL!AA9)))))))))","v":"Clarky"},null,null,{"$f":"IFERROR(VLOOKUP(D11,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H11,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H11,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H11,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B12,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B12,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B12,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B12,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B12,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B12,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B12,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B12,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B12,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C10,IF($B$2=APPEL!$E$1,APPEL!F10,IF($B$2=APPEL!$H$1,APPEL!I10,IF($B$2=APPEL!$K$1,APPEL!L10,IF($B$2=APPEL!$N$1,APPEL!O10,IF($B$2=APPEL!$Q$1,APPEL!R10,IF($B$2=APPEL!$T$1,APPEL!U10,IF($B$2=APPEL!$W$1,APPEL!X10,IF($B$2=APPEL!$Z$1,APPEL!AA10)))))))))","v":"Djamel"},null,null,{"$f":"IFERROR(VLOOKUP(D12,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D12,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D12,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H12,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H12,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H12,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B13,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B13,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B13,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B13,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B13,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B13,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B13,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B13,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B13,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C11,IF($B$2=APPEL!$E$1,APPEL!F11,IF($B$2=APPEL!$H$1,APPEL!I11,IF($B$2=APPEL!$K$1,APPEL!L11,IF($B$2=APPEL!$N$1,APPEL!O11,IF($B$2=APPEL!$Q$1,APPEL!R11,IF($B$2=APPEL!$T$1,APPEL!U11,IF($B$2=APPEL!$W$1,APPEL!X11,IF($B$2=APPEL!$Z$1,APPEL!AA11)))))))))","v":"Dounia"},null,null,{"$f":"IFERROR(VLOOKUP(D13,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D13,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D13,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H13,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H13,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H13,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B14,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B14,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B14,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B14,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B14,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B14,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B14,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B14,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B14,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C12,IF($B$2=APPEL!$E$1,APPEL!F12,IF($B$2=APPEL!$H$1,APPEL!I12,IF($B$2=APPEL!$K$1,APPEL!L12,IF($B$2=APPEL!$N$1,APPEL!O12,IF($B$2=APPEL!$Q$1,APPEL!R12,IF($B$2=APPEL!$T$1,APPEL!U12,IF($B$2=APPEL!$W$1,APPEL!X12,IF($B$2=APPEL!$Z$1,APPEL!AA12)))))))))","v":"Eyat"},null,null,{"$f":"IFERROR(VLOOKUP(D14,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D14,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D14,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H14,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H14,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H14,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B15,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B15,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B15,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B15,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B15,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B15,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B15,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B15,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B15,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C13,IF($B$2=APPEL!$E$1,APPEL!F13,IF($B$2=APPEL!$H$1,APPEL!I13,IF($B$2=APPEL!$K$1,APPEL!L13,IF($B$2=APPEL!$N$1,APPEL!O13,IF($B$2=APPEL!$Q$1,APPEL!R13,IF($B$2=APPEL!$T$1,APPEL!U13,IF($B$2=APPEL!$W$1,APPEL!X13,IF($B$2=APPEL!$Z$1,APPEL!AA13)))))))))","v":"Fatima-Zohra"},null,null,{"$f":"IFERROR(VLOOKUP(D15,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D15,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D15,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H15,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H15,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H15,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B16,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B16,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B16,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B16,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B16,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B16,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B16,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B16,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B16,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C14,IF($B$2=APPEL!$E$1,APPEL!F14,IF($B$2=APPEL!$H$1,APPEL!I14,IF($B$2=APPEL!$K$1,APPEL!L14,IF($B$2=APPEL!$N$1,APPEL!O14,IF($B$2=APPEL!$Q$1,APPEL!R14,IF($B$2=APPEL!$T$1,APPEL!U14,IF($B$2=APPEL!$W$1,APPEL!X14,IF($B$2=APPEL!$Z$1,APPEL!AA14)))))))))","v":"Hana"},null,null,{"$f":"IFERROR(VLOOKUP(D16,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D16,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D16,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H16,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H16,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H16,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B17,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B17,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B17,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B17,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B17,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B17,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B17,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B17,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B17,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C15,IF($B$2=APPEL!$E$1,APPEL!F15,IF($B$2=APPEL!$H$1,APPEL!I15,IF($B$2=APPEL!$K$1,APPEL!L15,IF($B$2=APPEL!$N$1,APPEL!O15,IF($B$2=APPEL!$Q$1,APPEL!R15,IF($B$2=APPEL!$T$1,APPEL!U15,IF($B$2=APPEL!$W$1,APPEL!X15,IF($B$2=APPEL!$Z$1,APPEL!AA15)))))))))","v":"Ikram"},null,null,{"$f":"IFERROR(VLOOKUP(D17,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D17,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D17,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H17,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H17,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H17,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B18,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B18,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B18,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B18,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B18,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B18,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B18,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B18,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B18,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C16,IF($B$2=APPEL!$E$1,APPEL!F16,IF($B$2=APPEL!$H$1,APPEL!I16,IF($B$2=APPEL!$K$1,APPEL!L16,IF($B$2=APPEL!$N$1,APPEL!O16,IF($B$2=APPEL!$Q$1,APPEL!R16,IF($B$2=APPEL!$T$1,APPEL!U16,IF($B$2=APPEL!$W$1,APPEL!X16,IF($B$2=APPEL!$Z$1,APPEL!AA16)))))))))","v":"Jairzhino"},null,null,{"$f":"IFERROR(VLOOKUP(D18,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D18,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D18,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H18,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H18,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H18,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B19,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B19,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B19,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B19,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B19,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B19,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B19,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B19,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B19,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C17,IF($B$2=APPEL!$E$1,APPEL!F17,IF($B$2=APPEL!$H$1,APPEL!I17,IF($B$2=APPEL!$K$1,APPEL!L17,IF($B$2=APPEL!$N$1,APPEL!O17,IF($B$2=APPEL!$Q$1,APPEL!R17,IF($B$2=APPEL!$T$1,APPEL!U17,IF($B$2=APPEL!$W$1,APPEL!X17,IF($B$2=APPEL!$Z$1,APPEL!AA17)))))))))","v":"Mergim"},null,null,{"$f":"IFERROR(VLOOKUP(D19,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D19,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D19,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H19,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H19,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H19,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B20,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B20,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B20,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B20,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B20,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B20,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B20,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B20,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B20,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C18,IF($B$2=APPEL!$E$1,APPEL!F18,IF($B$2=APPEL!$H$1,APPEL!I18,IF($B$2=APPEL!$K$1,APPEL!L18,IF($B$2=APPEL!$N$1,APPEL!O18,IF($B$2=APPEL!$Q$1,APPEL!R18,IF($B$2=APPEL!$T$1,APPEL!U18,IF($B$2=APPEL!$W$1,APPEL!X18,IF($B$2=APPEL!$Z$1,APPEL!AA18)))))))))","v":"Myriam"},null,null,{"$f":"IFERROR(VLOOKUP(D20,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D20,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D20,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H20,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H20,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H20,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B21,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B21,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B21,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B21,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B21,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B21,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B21,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B21,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B21,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C19,IF($B$2=APPEL!$E$1,APPEL!F19,IF($B$2=APPEL!$H$1,APPEL!I19,IF($B$2=APPEL!$K$1,APPEL!L19,IF($B$2=APPEL!$N$1,APPEL!O19,IF($B$2=APPEL!$Q$1,APPEL!R19,IF($B$2=APPEL!$T$1,APPEL!U19,IF($B$2=APPEL!$W$1,APPEL!X19,IF($B$2=APPEL!$Z$1,APPEL!AA19)))))))))","v":"Serone"},null,null,{"$f":"IFERROR(VLOOKUP(D21,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D21,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D21,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H21,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H21,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H21,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B22,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B22,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B22,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B22,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B22,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B22,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B22,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B22,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B22,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"f"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C20,IF($B$2=APPEL!$E$1,APPEL!F20,IF($B$2=APPEL!$H$1,APPEL!I20,IF($B$2=APPEL!$K$1,APPEL!L20,IF($B$2=APPEL!$N$1,APPEL!O20,IF($B$2=APPEL!$Q$1,APPEL!R20,IF($B$2=APPEL!$T$1,APPEL!U20,IF($B$2=APPEL!$W$1,APPEL!X20,IF($B$2=APPEL!$Z$1,APPEL!AA20)))))))))","v":"Suha"},null,null,{"$f":"IFERROR(VLOOKUP(D22,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D22,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D22,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H22,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H22,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H22,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B23,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B23,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B23,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B23,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B23,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B23,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B23,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B23,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B23,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":"g"},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C21,IF($B$2=APPEL!$E$1,APPEL!F21,IF($B$2=APPEL!$H$1,APPEL!I21,IF($B$2=APPEL!$K$1,APPEL!L21,IF($B$2=APPEL!$N$1,APPEL!O21,IF($B$2=APPEL!$Q$1,APPEL!R21,IF($B$2=APPEL!$T$1,APPEL!U21,IF($B$2=APPEL!$W$1,APPEL!X21,IF($B$2=APPEL!$Z$1,APPEL!AA21)))))))))","v":"Yassine"},null,null,{"$f":"IFERROR(VLOOKUP(D23,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D23,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D23,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H23,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H23,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H23,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B24,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B24,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B24,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B24,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B24,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B24,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B24,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B24,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B24,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C22,IF($B$2=APPEL!$E$1,APPEL!F22,IF($B$2=APPEL!$H$1,APPEL!I22,IF($B$2=APPEL!$K$1,APPEL!L22,IF($B$2=APPEL!$N$1,APPEL!O22,IF($B$2=APPEL!$Q$1,APPEL!R22,IF($B$2=APPEL!$T$1,APPEL!U22,IF($B$2=APPEL!$W$1,APPEL!X22,IF($B$2=APPEL!$Z$1,APPEL!AA22)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D24,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D24,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D24,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H24,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H24,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H24,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B25,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B25,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B25,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B25,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B25,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B25,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B25,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B25,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B25,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C23,IF($B$2=APPEL!$E$1,APPEL!F23,IF($B$2=APPEL!$H$1,APPEL!I23,IF($B$2=APPEL!$K$1,APPEL!L23,IF($B$2=APPEL!$N$1,APPEL!O23,IF($B$2=APPEL!$Q$1,APPEL!R23,IF($B$2=APPEL!$T$1,APPEL!U23,IF($B$2=APPEL!$W$1,APPEL!X23,IF($B$2=APPEL!$Z$1,APPEL!AA23)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D25,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D25,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D25,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H25,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H25,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H25,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B26,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B26,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B26,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B26,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B26,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B26,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B26,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B26,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B26,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C24,IF($B$2=APPEL!$E$1,APPEL!F24,IF($B$2=APPEL!$H$1,APPEL!I24,IF($B$2=APPEL!$K$1,APPEL!L24,IF($B$2=APPEL!$N$1,APPEL!O24,IF($B$2=APPEL!$Q$1,APPEL!R24,IF($B$2=APPEL!$T$1,APPEL!U24,IF($B$2=APPEL!$W$1,APPEL!X24,IF($B$2=APPEL!$Z$1,APPEL!AA24)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D26,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D26,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D26,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H26,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H26,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H26,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B27,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B27,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B27,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B27,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B27,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B27,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B27,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B27,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B27,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C25,IF($B$2=APPEL!$E$1,APPEL!F25,IF($B$2=APPEL!$H$1,APPEL!I25,IF($B$2=APPEL!$K$1,APPEL!L25,IF($B$2=APPEL!$N$1,APPEL!O25,IF($B$2=APPEL!$Q$1,APPEL!R25,IF($B$2=APPEL!$T$1,APPEL!U25,IF($B$2=APPEL!$W$1,APPEL!X25,IF($B$2=APPEL!$Z$1,APPEL!AA25)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D27,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D27,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D27,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H27,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H27,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H27,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B28,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B28,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B28,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B28,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B28,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B28,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B28,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B28,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B28,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C26,IF($B$2=APPEL!$E$1,APPEL!F26,IF($B$2=APPEL!$H$1,APPEL!I26,IF($B$2=APPEL!$K$1,APPEL!L26,IF($B$2=APPEL!$N$1,APPEL!O26,IF($B$2=APPEL!$Q$1,APPEL!R26,IF($B$2=APPEL!$T$1,APPEL!U26,IF($B$2=APPEL!$W$1,APPEL!X26,IF($B$2=APPEL!$Z$1,APPEL!AA26)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D28,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D28,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D28,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H28,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H28,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H28,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B29,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B29,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B29,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B29,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B29,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B29,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B29,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B29,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B29,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C27,IF($B$2=APPEL!$E$1,APPEL!F27,IF($B$2=APPEL!$H$1,APPEL!I27,IF($B$2=APPEL!$K$1,APPEL!L27,IF($B$2=APPEL!$N$1,APPEL!O27,IF($B$2=APPEL!$Q$1,APPEL!R27,IF($B$2=APPEL!$T$1,APPEL!U27,IF($B$2=APPEL!$W$1,APPEL!X27,IF($B$2=APPEL!$Z$1,APPEL!AA27)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D29,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D29,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D29,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H29,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H29,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H29,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B30,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B30,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B30,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B30,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B30,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B30,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B30,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B30,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B30,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C28,IF($B$2=APPEL!$E$1,APPEL!F28,IF($B$2=APPEL!$H$1,APPEL!I28,IF($B$2=APPEL!$K$1,APPEL!L28,IF($B$2=APPEL!$N$1,APPEL!O28,IF($B$2=APPEL!$Q$1,APPEL!R28,IF($B$2=APPEL!$T$1,APPEL!U28,IF($B$2=APPEL!$W$1,APPEL!X28,IF($B$2=APPEL!$Z$1,APPEL!AA28)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D30,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D30,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D30,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H30,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H30,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H30,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B31,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B31,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B31,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B31,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B31,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B31,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B31,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B31,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B31,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C29,IF($B$2=APPEL!$E$1,APPEL!F29,IF($B$2=APPEL!$H$1,APPEL!I29,IF($B$2=APPEL!$K$1,APPEL!L29,IF($B$2=APPEL!$N$1,APPEL!O29,IF($B$2=APPEL!$Q$1,APPEL!R29,IF($B$2=APPEL!$T$1,APPEL!U29,IF($B$2=APPEL!$W$1,APPEL!X29,IF($B$2=APPEL!$Z$1,APPEL!AA29)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D31,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D31,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D31,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H31,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H31,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H31,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B32,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B32,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B32,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B32,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B32,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B32,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B32,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B32,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B32,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C30,IF($B$2=APPEL!$E$1,APPEL!F30,IF($B$2=APPEL!$H$1,APPEL!I30,IF($B$2=APPEL!$K$1,APPEL!L30,IF($B$2=APPEL!$N$1,APPEL!O30,IF($B$2=APPEL!$Q$1,APPEL!R30,IF($B$2=APPEL!$T$1,APPEL!U30,IF($B$2=APPEL!$W$1,APPEL!X30,IF($B$2=APPEL!$Z$1,APPEL!AA30)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D32,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D32,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D32,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H32,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H32,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H32,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B33,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B33,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B33,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B33,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B33,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B33,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B33,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B33,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B33,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C31,IF($B$2=APPEL!$E$1,APPEL!F31,IF($B$2=APPEL!$H$1,APPEL!I31,IF($B$2=APPEL!$K$1,APPEL!L31,IF($B$2=APPEL!$N$1,APPEL!O31,IF($B$2=APPEL!$Q$1,APPEL!R31,IF($B$2=APPEL!$T$1,APPEL!U31,IF($B$2=APPEL!$W$1,APPEL!X31,IF($B$2=APPEL!$Z$1,APPEL!AA31)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D33,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D33,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D33,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H33,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H33,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H33,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B34,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B34,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B34,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B34,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B34,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B34,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B34,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B34,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B34,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C32,IF($B$2=APPEL!$E$1,APPEL!F32,IF($B$2=APPEL!$H$1,APPEL!I32,IF($B$2=APPEL!$K$1,APPEL!L32,IF($B$2=APPEL!$N$1,APPEL!O32,IF($B$2=APPEL!$Q$1,APPEL!R32,IF($B$2=APPEL!$T$1,APPEL!U32,IF($B$2=APPEL!$W$1,APPEL!X32,IF($B$2=APPEL!$Z$1,APPEL!AA32)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D34,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D34,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D34,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H34,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H34,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H34,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B35,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B35,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B35,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B35,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B35,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B35,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B35,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B35,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B35,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C33,IF($B$2=APPEL!$E$1,APPEL!F33,IF($B$2=APPEL!$H$1,APPEL!I33,IF($B$2=APPEL!$K$1,APPEL!L33,IF($B$2=APPEL!$N$1,APPEL!O33,IF($B$2=APPEL!$Q$1,APPEL!R33,IF($B$2=APPEL!$T$1,APPEL!U33,IF($B$2=APPEL!$W$1,APPEL!X33,IF($B$2=APPEL!$Z$1,APPEL!AA33)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D35,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D35,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D35,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H35,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H35,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H35,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]
[{"$f":"IF($B$2=APPEL!$B$1,VLOOKUP(B36,APPEL!$C$3:$D$38,2,FALSE),IF($B$2=APPEL!$E$1,VLOOKUP(B36,APPEL!$F$3:$G$38,2,FALSE),IF($B$2=APPEL!$H$1,VLOOKUP(B36,APPEL!$I$3:$J$38,2,FALSE),IF($B$2=APPEL!$K$1,VLOOKUP(B36,APPEL!$L$3:$M$38,2,FALSE),IF($B$2=APPEL!$N$1,VLOOKUP(B36,APPEL!$O$3:$P$38,2,FALSE),IF($B$2=APPEL!$Q$1,VLOOKUP(B36,APPEL!$R$3:$S$38,2,FALSE),IF($B$2=APPEL!$T$1,VLOOKUP(B36,APPEL!$U$3:$V$38,2,FALSE),IF($B$2=APPEL!$W$1,VLOOKUP(B36,APPEL!$X$3:$Y$38,2,FALSE),IF($B$2=APPEL!$Z$1,VLOOKUP(B36,APPEL!$AA$3:$AB$38,2,FALSE))))))))))","v":{"$error":"#N/A"}},{"$f":"IF($B$2=APPEL!$B$1,APPEL!C34,IF($B$2=APPEL!$E$1,APPEL!F34,IF($B$2=APPEL!$H$1,APPEL!I34,IF($B$2=APPEL!$K$1,APPEL!L34,IF($B$2=APPEL!$N$1,APPEL!O34,IF($B$2=APPEL!$Q$1,APPEL!R34,IF($B$2=APPEL!$T$1,APPEL!U34,IF($B$2=APPEL!$W$1,APPEL!X34,IF($B$2=APPEL!$Z$1,APPEL!AA34)))))))))","v":0},null,null,{"$f":"IFERROR(VLOOKUP(D36,DEBUT!$B$5:$E$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D36,DEBUT!$B$5:$E$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D36,DEBUT!$B$5:$E$100,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(H36,DEBUT!$G$5:$J$100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H36,DEBUT!$G$5:$J$100,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H36,DEBUT!$G$5:$J$100,4,FALSE),\"\")","v":""}]

{"sheet":"MACROS","index":5,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,7,16,8]]}
[3]
["15:47:48"]
[null,"MACROS UTILISABLES SUR N'IMPORTE QUELLE FEUILLE"]
[]
[]
[]
[]
[]
[]
[]
[null,"MACROS OU IL FAUDRA CHANGER LE NOM DE LA CELLULE, LIGNE OU COLONNE (et le nom de la macro si elle doit être dupliquée), et/ou LA VALEUR"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Effacer d'abord A1","Bien définir le format de cellule",null,3]
[null,"MACROS OU IL FAUDRA CHANGER LE NOM DE LA FEUILLE"]

{"sheet":"SAELEVE1","index":6,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,3,3,4],[2,6,2,9],[2,10,3,10],[3,6,3,9],[4,2,4,6],[4,7,4,10],[5,2,7,6],[5,7,5,10],[6,7,6,10],[7,7,7,10],[13,2,13,4],[14,2,14,4],[13,9,13,10],[13,5,13,8],[7,17,7,18],[8,2,8,6],[8,7,8,10],[9,2,9,6],[9,7,9,10],[12,2,12,10],[15,2,15,10],[16,2,16,10],[17,2,17,10],[18,2,18,10],[14,9,14,10],[14,5,14,8]]}
[null,null,null,"Situation d'apprentissage"]
[]
[null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,4,FALSE)","v":"BAD"},"Max Tirs en 1'",null,"Obj",{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,5,FALSE)","v":"Améliorer la qualité du tir en course"},null,null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,2,FALSE)","v":"T1'"}]
[null,null,null,null,null,"But",{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,6,FALSE)","v":"Marquer le plus de paniers possibles en 1 minute"}]
[null,null,"Schéma / Matériel nécessaire",null,null,null,null,"Matériel nécessaire"]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,13,FALSE)","v":"2 ballons (1 chacun). 1 panier. 2 plots. 1 chrono. 1 tablette."}]
[null,null,null,null,null,null,null,"Consignes"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,8,FALSE),\"  -  \",VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,10,FALSE))","v":"Mini défi 1 contre 1. Les joueurs se placent à leur plot. AU signal d'un camarade ils dribblent pour aller shooter au panier. Que le tir soit réussi ou non, les 2 joueurs retournent faire le tour du plot en dribblant pour tenter un nouveau tir. Ils tournent pendant 1 minute. chacun compte son score en même temps que les observateurs et le relève sur la tablette à la fin. 2 nouveaux élèves passent quand la minute est finie.  -  Consignes 2"}]
[null,null,"Critères de réussite",null,null,null,null,"Conseils pour réussir"]
[null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,14,FALSE)","v":"Je réussi au moins 3 tirs à l'arrêt et 5 tirs en course."},null,null,null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,12,FALSE)","v":"JE dribble rapidement pour pouvoir effectuer plusieurs shoots. Je m'applique sur chaque tir en m'aidant de l'angle du carré de la planche. "}]
[]
[]
[null,null,"ACQUISITIONS PRIORITAIRES"]
[null,null,"Connaissances",null,null,"Capacités",null,null,null,"Attitudes"]
[null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,16,FALSE)","v":"Cns"},null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,17,FALSE)","v":"Cap"},null,null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,18,FALSE)","v":"Att"}]
[null,null,"COMPLEXIFICATION "]
[null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,19,FALSE)","v":"Cplx"}]
[null,null,"Simplification"]
[null,null,{"$f":"VLOOKUP($D$3,SAMICBIS!$A$3:$T$70,20,FALSE)","v":"Simpli"}]

{"sheet":"REFERENTIELS","index":7,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[21,4,21,9],[22,4,22,5],[22,6,22,9],[23,2,24,2],[23,3,24,3],[20,4,20,9],[8,3,9,3],[6,3,7,3],[6,2,7,2],[8,2,9,2],[10,2,11,2],[10,3,11,3],[12,8,12,9],[3,4,3,9],[4,4,4,9],[13,2,13,9],[5,4,5,5],[5,6,5,9],[40,3,41,3],[42,2,43,2],[3,2,3,3],[4,2,4,3],[20,2,20,3],[21,2,21,3],[42,3,43,3],[44,2,45,2],[44,3,45,3],[46,8,46,9],[25,2,26,2],[25,3,26,3],[27,2,28,2],[27,3,28,3],[29,8,29,9],[30,2,30,9],[37,2,37,3],[37,4,37,9],[38,2,38,3],[38,4,38,9],[39,4,39,5],[39,6,39,9],[40,2,41,2]]}
[]
[]
[null,null,"APSA N3"]
[null,null,"COMPETENCES ATTENDUES",null,"PRINCIPES D’ELABORATION DE L’EPREUVE"]
[]
[null,null,"POINTS A AFFECTER","ELEMENTS A EVALUER","COMPETENCE DE NIVEAU 3 EN COURS D’ACQUISITION\nDe 0 à 09 pts",null,"COMPETENCE DE NIVEAU 3 ACQUISE\nDe 10 à 20 pts"]
[null,null,"05 Points","Performance Individuelle sur 50m.\nTemps individuel sur 50 mètres"]
[]
[null,null,"05 Points","Indice de transmission. Différence entre  le meilleur temps réalisé sur 4x50 mètres (2) et la somme des temps des 4 coureurs sur 50m"]
[]
[null,null,"05 Points","Performances sur 4X50m.\nTemps cumulés des 2 4x50m, sans et avec changement de rôle (3)"]
[]
[null,null,"05 Points","Préparation avant l’épreuve et récupération après l’effort.\nEtre capable d’assurer une transmission valide\n(zone de transmission respectée)."]
[null,null,"COMMENTAIRES"]
[null,null,-1]
[]
[]
[]
[]
[null,null,"APSA N4"]
[null,null,"COMPETENCES ATTENDUES",null,"PRINCIPES D’ELABORATION DE L’EPREUVE"]
[]
[null,null,"POINTS A AFFECTER","ELEMENTS A EVALUER","COMPETENCE DE NIVEAU 3 EN COURS D’ACQUISITION\nDe 0 à 09 pts",null,"COMPETENCE DE NIVEAU 3 ACQUISE\nDe 10 à 20 pts"]
[null,null,"05 Points","Performance Individuelle sur 50m.\nTemps individuel sur 50 mètres"]
[]
[null,null,"05 Points","Indice de transmission. Différence entre  le meilleur temps réalisé sur 4x50 mètres (2) et la somme des temps des 4 coureurs sur 50m"]
[]
[null,null,"05 Points","Performances sur 4X50m.\nTemps cumulés des 2 4x50m, sans et avec changement de rôle (3)"]
[]
[null,null,"05 Points","Préparation avant l’épreuve et récupération après l’effort.\nEtre capable d’assurer une transmission valide\n(zone de transmission respectée)."]
[null,null,"COMMENTAIRES"]
[null,null,-1]
[]
[]
[]
[]
[null,null,"APSA EVALUATION CYCLE"]
[null,null,"COMPETENCES ATTENDUES",null,"PRINCIPES D’ELABORATION DE L’EPREUVE"]
[]
[null,null,"POINTS A AFFECTER","ELEMENTS A EVALUER","COMPETENCE DE NIVEAU 3 EN COURS D’ACQUISITION\nDe 0 à 09 pts",null,"COMPETENCE DE NIVEAU 3 ACQUISE\nDe 10 à 20 pts"]
[null,null,"05 Points","Performance Individuelle sur 50m.\nTemps individuel sur 50 mètres"]
[]
[null,null,"05 Points","Indice de transmission. Différence entre  le meilleur temps réalisé sur 4x50 mètres (2) et la somme des temps des 4 coureurs sur 50m"]
[]
[null,null,"05 Points","Performances sur 4X50m.\nTemps cumulés des 2 4x50m, sans et avec changement de rôle (3)"]
[]
[null,null,"05 Points","Préparation avant l’épreuve et récupération après l’effort.\nEtre capable d’assurer une transmission valide\n(zone de transmission respectée)."]

{"sheet":"APPEL","index":8,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,19,0,20],[0,22,0,23],[0,25,0,26],[0,1,0,2],[0,4,0,5],[0,7,0,8],[0,10,0,11],[0,13,0,14],[0,16,0,17]]}
[null,"1TU-GA",null,null,"1TU-GA2",null,null,"TGA",null,null,"1EVS",null,null,"1GA",null,null,"1TU",null,null,"STAGE",null,null,"classe8",null,null,"classe9"]
[null,"NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe","NOMS","PRENOMS","sexe"]
[1,null,"Abraham","g",null,"Ali Malek","g",null,"a"]
[2,null,"Aimane","f",null,"Aline","f",null,"l"]
[3,null,"Amel","f",null,"Alya","f",null,"b"]
[4,null,"Amira","f",null,"Amine","g",null,"r"]
[5,null,"Anis","g",null,"Badis","g"]
[6,null,"Beyza","f",null,"Jean-Michaël","g"]
[7,null,"Clarky","g",null,"Jessica","f"]
[8,null,"Djamel","g",null,"Kaïna","f"]
[9,null,"Dounia","f",null,"Katy","f"]
[10,null,"Eyat","g",null,"Léonard","g"]
[11,null,"Fatima-Zohra","f",null,"Marinho","g"]
[12,null,"Hana","f",null,"Mervé","f"]
[13,null,"Ikram","f",null,"Mouhamadou Moustapha","g"]
[14,null,"Jairzhino","g",null,"Rayane","g"]
[15,null,"Mergim","f",null,"Sania","f"]
[16,null,"Myriam","f",null,"Sonia","f"]
[17,null,"Serone","f",null,"Suzana","f"]
[18,null,"Suha","f",null,"Thomas","g"]
[19,null,"Yassine","g"]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]

{"sheet":"DEBUT","index":9,"n_rows":16,"n_cols":28,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,2,4],[0,11,2,16],[0,6,2,9]]}
[null,"MON BAREME 1",null,null,null,null,"MON BAREME 2",null,null,null,null,"MES DONNES DE VALIDATION MODIFIABLES"]
[]
[]
[null,"CRITERE 1","CRITERE 2","CRITERE 3","CRITERE 4",null,"C1","C2","C3","C4",null,"DV1","DV2","DV3","DV4","DV5","DV6","DV7","DV8","DV9","DV10","DV11","DV12","DV13","DV14","DV15","DV16","DV17"]
[null,"il a fait ça","il a donc cette note la","Et je lui dis",18,null,"Très inusffisant"]
[null,"7\"","12/20","BRAVO","+++",null,"Insuffisant"]
[]
[]
[]
[null,null,null,null,null,null,"Moyen"]
[null,null,null,null,null,null,"Satisfaisant"]
[null,null,null,null,null,null,"Assez satisfaisant"]
[]
[]
[null,null,null,null,null,null,"Très satisfaisant"]
[null,null,null,null,null,null,"Escellent"]

{"sheet":"SAMICBIS","index":10,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Taille schéma PC : 1,25x2,26",null,"Taille schéma tablette : 1,85x3,4\"",null,null,null,null,null,null,null,null,"Conseil pour "]
["nom SA","n° SA","OBJ GENERAL","APSA","Obj SA","But","Type SA","Consignes","Schéma","Consignes 2","Schéma 2","Réussir","Matériel ","CR","Intérêt SA","Connaissances","Capacités","Attitudes","Complexification","Simplification"]
["Max Tirs en 1'","T1'","Améliorer la qualité du tir en course. Construire une continuité dribble-tir","BAD","Améliorer la qualité du tir en course","Marquer le plus de paniers possibles en 1 minute","Défi","Mini défi 1 contre 1. Les joueurs se placent à leur plot. AU signal d'un camarade ils dribblent pour aller shooter au panier. Que le tir soit réussi ou non, les 2 joueurs retournent faire le tour du plot en dribblant pour tenter un nouveau tir. Ils tournent pendant 1 minute. chacun compte son score en même temps que les observateurs et le relève sur la tablette à la fin. 2 nouveaux élèves passent quand la minute est finie.",null,"Consignes 2",null,"JE dribble rapidement pour pouvoir effectuer plusieurs shoots. Je m'applique sur chaque tir en m'aidant de l'angle du carré de la planche. ","2 ballons (1 chacun). 1 panier. 2 plots. 1 chrono. 1 tablette.","Je réussi au moins 3 tirs à l'arrêt et 5 tirs en course.","Intérêt SA","Cns","Cap","Att","Cplx","Simpli"]
["1000 plots",1000]
["PASSE et VA","PVA"]