{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["اهداء","tableau de scolarité","tre 1","bulletins_tre1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":4,"defined_names":16,"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":"اهداء","index":0,"n_rows":8,"n_cols":26,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nnn"]
[]
[]
[]
[]
[null,null,"السلام عليكم ورحمة الله وبركاته"]
[null,null,null,"وبعد:"]
[null,null,"تكتب إهداءك هنا"]

{"sheet":"tableau de scolarité","index":1,"n_rows":65,"n_cols":22,"rows_kept":65,"cut":false,"hidden":false,"merged":[[11,15,11,18],[7,11,7,14],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,8,13,13],[13,14,14,14],[4,0,4,2],[4,9,4,11],[4,12,4,14],[5,0,5,2],[5,9,5,11],[5,12,5,14],[2,0,2,2],[2,9,2,11],[2,12,2,14],[2,15,2,18],[3,0,3,2],[3,9,3,11],[3,12,3,14],[3,15,3,18],[0,0,0,2],[0,9,0,11],[0,12,0,14],[0,15,0,18],[1,0,1,2],[1,9,1,11],[1,12,1,14],[1,15,1,18]]}
["المملكة المغربية",null,null,null,null,null,null,null,null,"العام الدراسي",null,null,"2019_2018",null,null,"المواد غير المعممة",null,null,null,0,"ذ"]
["وزارة التربية الوطنية و التكوين المهني",null,null,null,null,null,null,null,null,"الاستاذ(ة)",null,null,"اسمك هنا",null,null,"الامازيغية",null,null,null,1,"أ","مك"]
["الاكاديمية الجهوية للتربية و التكوين",null,null,null,null,null,null,null,null,"المستوى",null,null,"الاول",null,null,0]
["جهة: اسم الجهة هنا",null,null,null,null,null,null,null,null,"الوحدة المدرسية ",null,null,"اسم الوحدة هنا"]
["مديرية: اسم المديرية هنا",null,null,null,null,null,null,null,null,"الفوج",null,null,1]
["المؤسسة: اسم المؤسسة هنا",null,null,null,null,null,null,null,null,"عدد التلاميذ",null,null,{"$f":"O10+O11","v":24}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"احصائيات"]
[null,null,null,null,null,null,null,null,null,null,null,null,"جدد","مك","مجموع"]
[null,null,null,null,null,null,null,null,null,null,null,"ذكور",{"$f":"COUNTIFS($E$16:$E$39,\"\",$D$16:$D$39,\"ذ\")","v":7},{"$f":"COUNTIFS($E$16:$E$39,\"مك\",$D$16:$D$39,\"ذ\")","v":3},{"$f":"IF($A16=\"\",\"\",SUM(M10+N10))","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,"اناث",{"$f":"COUNTIFS($E$16:$E$39,\"\",$D$16:$D$39,\"أ\")","v":13},{"$f":"COUNTIFS($E$16:$E$39,\"مك\",$D$16:$D$39,\"أ\")","v":1},{"$f":"N11+M11","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,"مج",{"$f":"M10+M11","v":20},{"$f":"N10+N11","v":4},{"$f":"N12+M12","v":24}]
[]
["رت","رقم التلميذ","الاسم والنسب","الجنس","التكرار"," رقم","تاريخ ","رقم","مدة الدراسة",null,null,null,null,null,"ملاحظات"]
[null,null,null,null,null,"التسجيل","الازدياد","التسجيل.م",1,2,3,4,5,6]
[{"$f":"IF($C16=\"\",\"\",MAX($A$15:$A15)+1)","v":1},"F1","رضوان","ذ","مك",408,"2005-06-23"]
[{"$f":"IF($C17=\"\",\"\",MAX($A$15:$A16)+1)","v":2},"F3","سلمى","أ",null,405,"2007-10-07"]
[{"$f":"IF($C18=\"\",\"\",MAX($A$15:$A17)+1)","v":3},"F12","سلمان","ذ",null,414,"2007-12-31"]
[{"$f":"IF($C19=\"\",\"\",MAX($A$15:$A18)+1)","v":4},"F6","فاطمة","أ",null,408,"2008-01-08"]
[{"$f":"IF($C20=\"\",\"\",MAX($A$15:$A19)+1)","v":5},"F2","محمد","أ",null,404,"2008-03-14"]
[{"$f":"IF($C21=\"\",\"\",MAX($A$15:$A20)+1)","v":6},"F13","مروة","أ",null,415,"2008-04-07"]
[{"$f":"IF($C22=\"\",\"\",MAX($A$15:$A21)+1)","v":7},"F21","فتيحة","أ",null,423,"2008-04-12"]
[{"$f":"IF($C23=\"\",\"\",MAX($A$15:$A22)+1)","v":8},"F14","خالد ","أ",null,416,"2008-04-14"]
[{"$f":"IF($C24=\"\",\"\",MAX($A$15:$A23)+1)","v":9},"F24","نادية","أ",null,426,"2008-06-24"]
[{"$f":"IF($C25=\"\",\"\",MAX($A$15:$A24)+1)","v":10},"F5","ميلود","ذ","مك",407,"2008-07-10"]
[{"$f":"IF($C26=\"\",\"\",MAX($A$15:$A25)+1)","v":11},"F11","احمد","ذ",null,413,"2008-07-13"]
[{"$f":"IF($C27=\"\",\"\",MAX($A$15:$A26)+1)","v":12},"F9","كمال","ذ",null,411,"2008-07-16"]
[{"$f":"IF($C28=\"\",\"\",MAX($A$15:$A27)+1)","v":13},"F8","فريد","ذ",null,410,"2008-07-27"]
[{"$f":"IF($C29=\"\",\"\",MAX($A$15:$A28)+1)","v":14},"F15","سفيان","ذ",null,417,"2008-08-13"]
[{"$f":"IF($C30=\"\",\"\",MAX($A$15:$A29)+1)","v":15},"F20","سليم","ذ",null,422,"2008-09-22"]
[{"$f":"IF($C31=\"\",\"\",MAX($A$15:$A30)+1)","v":16},"F23","جميلة","أ",null,425,"2008-09-29"]
[{"$f":"IF($C32=\"\",\"\",MAX($A$15:$A31)+1)","v":17},"F4","شعيب","ذ",null,406,"2008-12-06"]
[{"$f":"IF($C33=\"\",\"\",MAX($A$15:$A32)+1)","v":18},"F22","رقية","أ",null,424,"2008-12-22"]
[{"$f":"IF($C34=\"\",\"\",MAX($A$15:$A33)+1)","v":19},"F17","مريم","أ",null,419,"2008-12-31"]
[{"$f":"IF($C35=\"\",\"\",MAX($A$15:$A34)+1)","v":20},"F7","مصطفى","ذ","مك",409,"2009-01-02"]
[{"$f":"IF($C36=\"\",\"\",MAX($A$15:$A35)+1)","v":21},"F19","محمد","أ",null,421,"2009-01-02"]
[{"$f":"IF($C37=\"\",\"\",MAX($A$15:$A36)+1)","v":22},"F16","لمياء","أ",null,418,"2009-01-24"]
[{"$f":"IF($C38=\"\",\"\",MAX($A$15:$A37)+1)","v":23},"F18","لقمان","أ",null,420,"2009-02-20"]
[{"$f":"IF($C39=\"\",\"\",MAX($A$15:$A38)+1)","v":24},"F10","لبنى","أ","مك",412,"2009-03-15"]
[{"$f":"IF($C40=\"\",\"\",MAX($A$15:$A39)+1)","v":""}]
[{"$f":"IF($C41=\"\",\"\",MAX($A$15:$A40)+1)","v":""}]
[{"$f":"IF($C42=\"\",\"\",MAX($A$15:$A41)+1)","v":""}]
[{"$f":"IF($C43=\"\",\"\",MAX($A$15:$A42)+1)","v":""}]
[{"$f":"IF($C44=\"\",\"\",MAX($A$15:$A43)+1)","v":""}]
[{"$f":"IF($C45=\"\",\"\",MAX($A$15:$A44)+1)","v":""}]
[{"$f":"IF($C46=\"\",\"\",MAX($A$15:$A45)+1)","v":""}]
[{"$f":"IF($C47=\"\",\"\",MAX($A$15:$A46)+1)","v":""}]
[{"$f":"IF($C48=\"\",\"\",MAX($A$15:$A47)+1)","v":""}]
[{"$f":"IF($C49=\"\",\"\",MAX($A$15:$A48)+1)","v":""}]
[{"$f":"IF($C50=\"\",\"\",MAX($A$15:$A49)+1)","v":""}]
[{"$f":"IF($C51=\"\",\"\",MAX($A$15:$A50)+1)","v":""}]
[{"$f":"IF($C52=\"\",\"\",MAX($A$15:$A51)+1)","v":""}]
[{"$f":"IF($C53=\"\",\"\",MAX($A$15:$A52)+1)","v":""}]
[{"$f":"IF($C54=\"\",\"\",MAX($A$15:$A53)+1)","v":""}]
[{"$f":"IF($C55=\"\",\"\",MAX($A$15:$A54)+1)","v":""}]
[{"$f":"IF($C56=\"\",\"\",MAX($A$15:$A55)+1)","v":""}]
[{"$f":"IF($C57=\"\",\"\",MAX($A$15:$A56)+1)","v":""}]
[{"$f":"IF($C58=\"\",\"\",MAX($A$15:$A57)+1)","v":""}]
[{"$f":"IF($C59=\"\",\"\",MAX($A$15:$A58)+1)","v":""}]
[{"$f":"IF($C60=\"\",\"\",MAX($A$15:$A59)+1)","v":""}]
[{"$f":"IF($C61=\"\",\"\",MAX($A$15:$A60)+1)","v":""}]
[{"$f":"IF($C62=\"\",\"\",MAX($A$15:$A61)+1)","v":""}]
[{"$f":"IF($C63=\"\",\"\",MAX($A$15:$A62)+1)","v":""}]
[{"$f":"IF($C64=\"\",\"\",MAX($A$15:$A63)+1)","v":""}]
[{"$f":"IF($C65=\"\",\"\",MAX($A$15:$A64)+1)","v":""}]

{"sheet":"tre 1","index":2,"n_rows":59,"n_cols":51,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,29,0,31],[0,32,0,34],[1,2,1,5],[1,29,1,31],[1,32,1,34],[6,33,6,35],[2,2,2,5],[2,29,2,31],[2,32,2,34],[3,2,3,5],[3,8,4,26],[3,29,3,31],[3,32,3,34],[4,2,4,5],[4,29,4,31],[4,32,4,34],[5,2,5,5],[6,6,6,21],[6,22,6,24],[6,25,6,29],[6,30,6,32],[6,48,8,48],[6,49,8,49],[6,50,8,50],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,7,8],[6,36,6,38],[6,39,6,41],[6,42,6,44],[6,45,8,45],[6,46,8,46],[6,47,8,47],[7,33,7,34],[7,36,7,37],[7,39,7,40],[7,42,7,43],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20],[7,22,7,23],[7,30,7,31]]}
[null,null,{"$f":"'tableau de scolarité'!$A$1","v":"المملكة المغربية"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"العــام الدراســي ",null,null,{"$f":"'tableau de scolarité'!M1","v":"2019_2018"}]
[null,null,{"$f":"'tableau de scolarité'!$A$2","v":"وزارة التربية الوطنية و التكوين المهني"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الأستاذ(ة)",null,null,{"$f":"'tableau de scolarité'!M2","v":"اسمك هنا"}]
[null,null,{"$f":"'tableau de scolarité'!$A$3","v":"الاكاديمية الجهوية للتربية و التكوين"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"المستوى ",null,null,{"$f":"'tableau de scolarité'!M3","v":"الاول"}]
[null,null,{"$f":"'tableau de scolarité'!$A$4","v":"جهة: اسم الجهة هنا"},null,null,null,null,null,"مجمل  نتائج الأسدوس الأول",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الوحدة المدرسية",null,null,{"$f":"'tableau de scolarité'!M4","v":"اسم الوحدة هنا"}]
[null,null,{"$f":"'tableau de scolarité'!$A$5","v":"مديرية: اسم المديرية هنا"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الفوج",null,null,{"$f":"'tableau de scolarité'!M5","v":1}]
[null,null,{"$f":"'tableau de scolarité'!$A$6","v":"المؤسسة: اسم المؤسسة هنا"}]
[null,null,null,null,null,null,"اللغة العربية",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الأمازيغية",null,null,"التربية الإسلامية",null,null,null,null,"النشاط العلمي",null,null,"التربية الفنية",null,null,"الرياضيات",null,null,"الفرنسية",null,null,"التربية البدنية",null,null,"معامل ت ب","مج المعاملات","مج المعدلات","معدل الدورة","الرتبة","الميزة"]
["ر.ت","رقم التلميذ","الاسم و النسب","تاريخ الإزدياد","الجنس","ر.التسجيل","القراءة",null,null,"الإملاء",null,null,"الخط",null,null,"التعبير الشفوي",null,null,"النقل",null,null,"معدل","الأمازيغية",null,"معدل","فرض1","فرض2","فرض3","أنشطة","معدل","النشاط العلمي",null,"معدل","التربية الفنية",null,"معدل","الرياضيات",null,"معدل","الفرنسية",null,"معدل","التربية البدنية",null,"معدل"]
[null,null,null,null,null,null,"ن1","ن2","معدل","ن1","ن2","معدل","ن1","ن2","معدل","ن1","ن2","معدل","ن1","ن2","معدل","الوحدة","ن1","ن2","الوحدة","ن1","ن2","ن3","ن  4","الوحدة","ن1","ن2","الوحدة","ن1","ن2","الوحدة","ن1","ن2","الوحدة","ن1","ن2","الوحدة","ن1","ن2","الوحدة"]
[{"$f":"IF('tableau de scolarité'!A16=\"\",\"\",'tableau de scolarité'!A16)","v":1},{"$f":"IF('tableau de scolarité'!B16=\"\",\"\",'tableau de scolarité'!B16)","v":"F1"},{"$f":"IF('tableau de scolarité'!C16=\"\",\"\",'tableau de scolarité'!C16)","v":"رضوان"},{"$f":"IF('tableau de scolarité'!G16=\"\",\"\",'tableau de scolarité'!G16)","v":"2005-06-23"},{"$f":"IF($A10=\"\",\"\",'tableau de scolarité'!D16)","v":"ذ"},{"$f":"IF($A10=\"\",\"\",'tableau de scolarité'!F16)","v":408},4,3,{"$f":"IF(OR(G10=\"\",H10=\"\"),\"\",AVERAGE(G10:H10))","v":3.5},4,3,{"$f":"IF(OR(J10=\"\",K10=\"\"),\"\",AVERAGE(J10:K10))","v":3.5},4,4,{"$f":"IF(OR(M10=\"\",N10=\"\"),\"\",AVERAGE(M10:N10))","v":4},4,3,{"$f":"IF(OR(P10=\"\",Q10=\"\"),\"\",AVERAGE(P10:Q10))","v":3.5},4,4,{"$f":"IF(OR(S10=\"\",T10=\"\"),\"\",AVERAGE(S10:T10))","v":4},{"$f":"IF(OR(U10=\"\",R10=\"\",O10=\"\",L10=\"\",I10=\"\"),\"\",AVERAGE(R10:U10,O10,L10,I10))","v":3.7857142857142856},null,null,{"$f":"IF(OR(X10=\"\",W10=\"\"),\"\",AVERAGE(T10:X10))","v":""},4,3,3.5,4,{"$f":"IF(OR(AC10=\"\",AB10=\"\",AA10=\"\",Z10=\"\"),\"\",AVERAGE(AC10,AB10,Z10:AA10))","v":3.625},4,4,{"$f":"IF(OR(AF10=\"\",AE10=\"\"),\"\",AVERAGE(AE10:AF10))","v":4},4,6.5,{"$f":"IF(OR(AI10=\"\",AH10=\"\"),\"\",AVERAGE(AH10:AI10))","v":5.25},3,3.5,{"$f":"IF(OR(AL10=\"\",AK10=\"\"),\"\",AVERAGE(AK10:AL10))","v":3.25},4,3.5,{"$f":"IF(OR(AO10=\"\",AN10=\"\"),\"\",AVERAGE(AN10:AO10))","v":3.75},6.25,6.75,{"$f":"IF(OR(AR10=\"\",AQ10=\"\"),\"\",AVERAGE(AQ10:AR10))","v":6.5},1,{"$f":"IF($A10=\"\",\"\",6+AT10+'tableau de scolarité'!$P$3)","v":7},{"$f":"IF($A10=\"\",\"\",SUM(V10,AD10,AG10,AJ10,AM10,AP10,AS10))","v":30.160714285714285},{"$f":"IF($A10=\"\",\"\",AV10/AU10)","v":4.3086734693877551},{"$f":"IF(A10=\"\",\"\",RANK(AW10,$AW$10:$AW$59))","v":22},{"$f":"IF($A10=\"\",\"\",IF(AW10>=8,\"تنويه\",IF(AW10>=7,\"تشجيع\",IF(AW10>=6,\"لوحة الشرف\",IF(AW10>=5,\"متوسط\",IF(AW10>=4,\"دون المتوسط\",IF(AW10>=3,\"ناقص\",IF(AW10>2,\"تنبيه\",IF(AW10>=1,\"توبيخ\",\"انذار\")))))))))","v":"دون المتوسط"}]
[{"$f":"IF('tableau de scolarité'!A17=\"\",\"\",'tableau de scolarité'!A17)","v":2},{"$f":"IF($A11=\"\",\"\",'tableau de scolarité'!B17)","v":"F3"},{"$f":"IF($A11=\"\",\"\",'tableau de scolarité'!C17)","v":"سلمى"},{"$f":"IF(A11=\"\",\"\",'tableau de scolarité'!G17)","v":"2007-10-07"},{"$f":"IF($A11=\"\",\"\",'tableau de scolarité'!D17)","v":"أ"},{"$f":"IF($A11=\"\",\"\",'tableau de scolarité'!F17)","v":405},4,4.5,{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",AVERAGE(G11:H11))","v":4.25},6.5,6,{"$f":"IF(OR(J11=\"\",K11=\"\"),\"\",AVERAGE(J11:K11))","v":6.25},6,6,{"$f":"IF(OR(M11=\"\",N11=\"\"),\"\",AVERAGE(M11:N11))","v":6},4,6.5,{"$f":"IF(OR(P11=\"\",Q11=\"\"),\"\",AVERAGE(P11:Q11))","v":5.25},6,5,{"$f":"IF(OR(S11=\"\",T11=\"\"),\"\",AVERAGE(S11:T11))","v":5.5},{"$f":"IF(OR(U11=\"\",R11=\"\",O11=\"\",L11=\"\",I11=\"\"),\"\",AVERAGE(R11:U11,O11,L11,I11))","v":5.4642857142857144},null,null,{"$f":"IF(OR(X11=\"\",W11=\"\"),\"\",AVERAGE(T11:X11))","v":""},6.5,4,5.25,6,{"$f":"IF(OR(AC11=\"\",AB11=\"\",AA11=\"\",Z11=\"\"),\"\",AVERAGE(AC11,AB11,Z11:AA11))","v":5.4375},9.5,9,{"$f":"IF(OR(AF11=\"\",AE11=\"\"),\"\",AVERAGE(AE11:AF11))","v":9.25},7.25,6.5,{"$f":"IF(OR(AI11=\"\",AH11=\"\"),\"\",AVERAGE(AH11:AI11))","v":6.875},6.58,6.75,{"$f":"IF(OR(AL11=\"\",AK11=\"\"),\"\",AVERAGE(AK11:AL11))","v":6.665},6,5.25,{"$f":"IF(OR(AO11=\"\",AN11=\"\"),\"\",AVERAGE(AN11:AO11))","v":5.625},5.5,6.75,{"$f":"IF(OR(AR11=\"\",AQ11=\"\"),\"\",AVERAGE(AQ11:AR11))","v":6.125},1,{"$f":"IF($A11=\"\",\"\",6+AT11+'tableau de scolarité'!$P$3)","v":7},{"$f":"IF($A11=\"\",\"\",SUM(V11,AD11,AG11,AJ11,AM11,AP11,AS11))","v":45.441785714285714},{"$f":"IF($A11=\"\",\"\",AV11/AU11)","v":6.4916836734693879},{"$f":"IF(A11=\"\",\"\",RANK(AW11,$AW$10:$AW$59))","v":8},{"$f":"IF($A11=\"\",\"\",IF(AW11>=8,\"تنويه\",IF(AW11>=7,\"تشجيع\",IF(AW11>=6,\"لوحة الشرف\",IF(AW11>=5,\"متوسط\",IF(AW11>=4,\"دون المتوسط\",IF(AW11>=3,\"ناقص\",IF(AW11>2,\"تنبيه\",IF(AW11>=1,\"توبيخ\",\"انذار\")))))))))","v":"لوحة الشرف"}]
[{"$f":"IF('tableau de scolarité'!A18=\"\",\"\",'tableau de scolarité'!A18)","v":3},{"$f":"IF($A12=\"\",\"\",'tableau de scolarité'!B18)","v":"F12"},{"$f":"IF($A12=\"\",\"\",'tableau de scolarité'!C18)","v":"سلمان"},{"$f":"IF(A12=\"\",\"\",'tableau de scolarité'!G18)","v":"2007-12-31"},{"$f":"IF($A12=\"\",\"\",'tableau de scolarité'!D18)","v":"ذ"},{"$f":"IF($A12=\"\",\"\",'tableau de scolarité'!F18)","v":414},3.5,4.5,4,6,5,5.5,5,5.5,5.25,3.5,4.5,4,5,5,5,{"$f":"IF(OR(U12=\"\",R12=\"\",O12=\"\",L12=\"\",I12=\"\"),\"\",AVERAGE(R12:U12,O12,L12,I12))","v":4.8214285714285712},null,null,"",5,3,4,5.5,4.375,5,6.66,5.83,8,6.5,7.25,5,5.5,5.25,5,4,4.5,6.25,6.5,6.375,1,{"$f":"IF($A12=\"\",\"\",6+AT12+'tableau de scolarité'!$P$3)","v":7},38.401428571428568,5.4859183673469385,12,"متوسط"]
[{"$f":"IF('tableau de scolarité'!A19=\"\",\"\",'tableau de scolarité'!A19)","v":4},{"$f":"IF($A13=\"\",\"\",'tableau de scolarité'!B19)","v":"F6"},{"$f":"IF($A13=\"\",\"\",'tableau de scolarité'!C19)","v":"فاطمة"},{"$f":"IF(A13=\"\",\"\",'tableau de scolarité'!G19)","v":"2008-01-08"},{"$f":"IF($A13=\"\",\"\",'tableau de scolarité'!D19)","v":"أ"},{"$f":"IF($A13=\"\",\"\",'tableau de scolarité'!F19)","v":408},7,6.5,6.75,6,6.75,6.375,6,7,6.5,6.5,8,7.25,6,6,6,{"$f":"IF(OR(U13=\"\",R13=\"\",O13=\"\",L13=\"\",I13=\"\"),\"\",AVERAGE(R13:U13,O13,L13,I13))","v":6.4107142857142856},null,null,"",8.75,5.5,7.13,7.5,7.22,6,9.5,{"$f":"IF(OR(AF13=\"\",AE13=\"\"),\"\",AVERAGE(AE13:AF13))","v":7.75},7.5,9,8.25,8.83,9.5,9.1649999999999991,6,7.125,6.5625,6.25,6.75,6.5,1,{"$f":"IF($A13=\"\",\"\",6+AT13+'tableau de scolarité'!$P$3)","v":7},51.858214285714283,7.4083163265306116,3,"تشجيع"]
[{"$f":"IF('tableau de scolarité'!A20=\"\",\"\",'tableau de scolarité'!A20)","v":5},{"$f":"IF($A14=\"\",\"\",'tableau de scolarité'!B20)","v":"F2"},{"$f":"IF($A14=\"\",\"\",'tableau de scolarité'!C20)","v":"محمد"},{"$f":"IF(A14=\"\",\"\",'tableau de scolarité'!G20)","v":"2008-03-14"},{"$f":"IF($A14=\"\",\"\",'tableau de scolarité'!D20)","v":"أ"},{"$f":"IF($A14=\"\",\"\",'tableau de scolarité'!F20)","v":404},4,5,4.5,5.5,5,5.25,4,6.5,5.25,4,6.5,5.25,4,6,5,5.0357142857142856,null,null,"",5.25,4.5,4.88,6,5.1574999999999998,7,9,8,6,7,6.5,4.66,6.25,5.4550000000000001,4,4.875,4.4375,5.5,6.75,6.125,1,{"$f":"IF($A14=\"\",\"\",6+AT14+'tableau de scolarité'!$P$3)","v":7},40.710714285714282,5.8158163265306113,10,"متوسط"]
[{"$f":"IF('tableau de scolarité'!A21=\"\",\"\",'tableau de scolarité'!A21)","v":6},{"$f":"IF($A15=\"\",\"\",'tableau de scolarité'!B21)","v":"F13"},{"$f":"IF($A15=\"\",\"\",'tableau de scolarité'!C21)","v":"مروة"},{"$f":"IF(A15=\"\",\"\",'tableau de scolarité'!G21)","v":"2008-04-07"},{"$f":"IF($A15=\"\",\"\",'tableau de scolarité'!D21)","v":"أ"},{"$f":"IF($A15=\"\",\"\",'tableau de scolarité'!F21)","v":415},3,3.5,3.25,2,3,2.5,2,4,3,3,4,3.5,2,4,3,3.0357142857142856,null,null,"",3,3,3,4,3.25,4.5,4.5,4.5,6.25,5,5.625,4.33,2.75,3.54,2,3,2.5,5,6,5.5,1,{"$f":"IF($A15=\"\",\"\",6+AT15+'tableau de scolarité'!$P$3)","v":7},27.950714285714284,3.9929591836734692,23,"ناقص"]
[{"$f":"IF('tableau de scolarité'!A22=\"\",\"\",'tableau de scolarité'!A22)","v":7},{"$f":"IF($A16=\"\",\"\",'tableau de scolarité'!B22)","v":"F21"},{"$f":"IF($A16=\"\",\"\",'tableau de scolarité'!C22)","v":"فتيحة"},{"$f":"IF(A16=\"\",\"\",'tableau de scolarité'!G22)","v":"2008-04-12"},{"$f":"IF($A16=\"\",\"\",'tableau de scolarité'!D22)","v":"أ"},{"$f":"IF($A16=\"\",\"\",'tableau de scolarité'!F22)","v":423},3,4.5,3.75,3,5,4,3,5,4,3,5.5,4.25,3,5,4,4,null,null,"",3,3,3,4,3.25,6.5,6.66,6.58,5.5,6.5,6,4.5,5.5,5,3,3,3,5,6,5.5,1,{"$f":"IF($A16=\"\",\"\",6+AT16+'tableau de scolarité'!$P$3)","v":7},33.33,4.7614285714285716,16,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A23=\"\",\"\",'tableau de scolarité'!A23)","v":8},{"$f":"IF($A17=\"\",\"\",'tableau de scolarité'!B23)","v":"F14"},{"$f":"IF($A17=\"\",\"\",'tableau de scolarité'!C23)","v":"خالد "},{"$f":"IF(A17=\"\",\"\",'tableau de scolarité'!G23)","v":"2008-04-14"},{"$f":"IF($A17=\"\",\"\",'tableau de scolarité'!D23)","v":"أ"},{"$f":"IF($A17=\"\",\"\",'tableau de scolarité'!F23)","v":416},4.5,6.5,5.5,6,6.75,6.375,5,6,5.5,4,7.5,5.75,5,6,5.5,5.6607142857142856,null,null,"",5.5,4,4.75,6.5,5.1875,10,9.33,9.6649999999999991,7.5,8.75,8.125,8.16,8.25,8.2050000000000001,5,4.75,4.875,6.5,6.5,6.5,1,{"$f":"IF($A17=\"\",\"\",6+AT17+'tableau de scolarité'!$P$3)","v":7},48.218214285714282,6.888316326530612,5,"لوحة الشرف"]
[{"$f":"IF('tableau de scolarité'!A24=\"\",\"\",'tableau de scolarité'!A24)","v":9},{"$f":"IF($A18=\"\",\"\",'tableau de scolarité'!B24)","v":"F24"},{"$f":"IF($A18=\"\",\"\",'tableau de scolarité'!C24)","v":"نادية"},{"$f":"IF(A18=\"\",\"\",'tableau de scolarité'!G24)","v":"2008-06-24"},{"$f":"IF($A18=\"\",\"\",'tableau de scolarité'!D24)","v":"أ"},{"$f":"IF($A18=\"\",\"\",'tableau de scolarité'!F24)","v":426},5.75,6.5,6.125,7,7,7,6,7,6.5,6,7.75,6.875,7,6.5,6.75,6.6785714285714288,null,null,"",8.5,6.5,4.5,8.5,7,10,8.66,9.33,8,8.75,8.375,8.75,7.5,8.125,6,7.5,6.75,5.75,6.75,6.25,1,{"$f":"IF($A18=\"\",\"\",6+AT18+'tableau de scolarité'!$P$3)","v":7},52.508571428571429,7.5012244897959182,2,"تشجيع"]
[{"$f":"IF('tableau de scolarité'!A25=\"\",\"\",'tableau de scolarité'!A25)","v":10},{"$f":"IF($A19=\"\",\"\",'tableau de scolarité'!B25)","v":"F5"},{"$f":"IF($A19=\"\",\"\",'tableau de scolarité'!C25)","v":"ميلود"},{"$f":"IF(A19=\"\",\"\",'tableau de scolarité'!G25)","v":"2008-07-10"},{"$f":"IF($A19=\"\",\"\",'tableau de scolarité'!D25)","v":"ذ"},{"$f":"IF($A19=\"\",\"\",'tableau de scolarité'!F25)","v":407},3.5,3.5,3.5,4.5,5,4.75,4,5,4.5,3.5,4,3.75,4,5,4.5,4.2857142857142856,null,null,"",4,3,3.5,5,3.875,6,5,5.5,6,6,6,4.25,1.5,2.875,4,3.5,3.75,5.5,6,5.75,1,{"$f":"IF($A19=\"\",\"\",6+AT19+'tableau de scolarité'!$P$3)","v":7},32.035714285714285,4.5765306122448974,18,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A26=\"\",\"\",'tableau de scolarité'!A26)","v":11},{"$f":"IF($A20=\"\",\"\",'tableau de scolarité'!B26)","v":"F11"},{"$f":"IF($A20=\"\",\"\",'tableau de scolarité'!C26)","v":"احمد"},{"$f":"IF(A20=\"\",\"\",'tableau de scolarité'!G26)","v":"2008-07-13"},{"$f":"IF($A20=\"\",\"\",'tableau de scolarité'!D26)","v":"ذ"},{"$f":"IF($A20=\"\",\"\",'tableau de scolarité'!F26)","v":413},6,6,6,6.5,8.5,7.5,6,6.5,6.25,6,7.75,6.875,6.5,7.5,7,6.8035714285714288,null,null,"",5,4,4.5,7,5.125,5.5,10,7.75,7,9,8,8.16,7.5,7.83,6,4.5,5.25,6.25,6.75,6.5,1,{"$f":"IF($A20=\"\",\"\",6+AT20+'tableau de scolarité'!$P$3)","v":7},47.258571428571429,6.7512244897959182,7,"لوحة الشرف"]
[{"$f":"IF('tableau de scolarité'!A27=\"\",\"\",'tableau de scolarité'!A27)","v":12},{"$f":"IF($A21=\"\",\"\",'tableau de scolarité'!B27)","v":"F9"},{"$f":"IF($A21=\"\",\"\",'tableau de scolarité'!C27)","v":"كمال"},{"$f":"IF(A21=\"\",\"\",'tableau de scolarité'!G27)","v":"2008-07-16"},{"$f":"IF($A21=\"\",\"\",'tableau de scolarité'!D27)","v":"ذ"},{"$f":"IF($A21=\"\",\"\",'tableau de scolarité'!F27)","v":411},7,6.5,6.75,7,7,7,6.5,7,6.75,6.75,8.5,7.625,6.5,8,7.25,7.125,null,null,"",4,4,4,8,5,10,10,10,8.5,9,8.75,7.88,10,8.94,6.5,7.5,7,6.25,6.75,6.5,1,{"$f":"IF($A21=\"\",\"\",6+AT21+'tableau de scolarité'!$P$3)","v":7},53.314999999999998,7.6164285714285711,1,"تشجيع"]
[{"$f":"IF('tableau de scolarité'!A28=\"\",\"\",'tableau de scolarité'!A28)","v":13},{"$f":"IF($A22=\"\",\"\",'tableau de scolarité'!B28)","v":"F8"},{"$f":"IF($A22=\"\",\"\",'tableau de scolarité'!C28)","v":"فريد"},{"$f":"IF(A22=\"\",\"\",'tableau de scolarité'!G28)","v":"2008-07-27"},{"$f":"IF($A22=\"\",\"\",'tableau de scolarité'!D28)","v":"ذ"},{"$f":"IF($A22=\"\",\"\",'tableau de scolarité'!F28)","v":410},3.5,3,3.25,2,6,4,3,5,4,3.5,4.5,4,3,6,4.5,4.1071428571428568,null,null,"",4,3,3.5,5,3.875,2.5,9.25,5.875,6.25,6.5,6.375,4.16,2.5,3.33,3,3.5,3.25,6,6.5,6.25,1,{"$f":"IF($A22=\"\",\"\",6+AT22+'tableau de scolarité'!$P$3)","v":7},33.062142857142859,4.7231632653061224,17,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A29=\"\",\"\",'tableau de scolarité'!A29)","v":14},{"$f":"IF($A23=\"\",\"\",'tableau de scolarité'!B29)","v":"F15"},{"$f":"IF($A23=\"\",\"\",'tableau de scolarité'!C29)","v":"سفيان"},{"$f":"IF(A23=\"\",\"\",'tableau de scolarité'!G29)","v":"2008-08-13"},{"$f":"IF($A23=\"\",\"\",'tableau de scolarité'!D29)","v":"ذ"},{"$f":"IF($A23=\"\",\"\",'tableau de scolarité'!F29)","v":417},5.5,6.75,6.125,6,6.75,6.375,6,6.5,6.25,5.5,7.75,6.625,6,6,6,6.1964285714285712,null,null,"",6,3,4.5,6.5,5,6,9.33,7.665,7.5,7,7.25,4.25,9,6.625,6,4.5,5.25,6.5,6.5,6.5,1,{"$f":"IF($A23=\"\",\"\",6+AT23+'tableau de scolarité'!$P$3)","v":7},44.486428571428576,6.355204081632654,9,"لوحة الشرف"]
[{"$f":"IF('tableau de scolarité'!A30=\"\",\"\",'tableau de scolarité'!A30)","v":15},{"$f":"IF($A24=\"\",\"\",'tableau de scolarité'!B30)","v":"F20"},{"$f":"IF($A24=\"\",\"\",'tableau de scolarité'!C30)","v":"سليم"},{"$f":"IF(A24=\"\",\"\",'tableau de scolarité'!G30)","v":"2008-09-22"},{"$f":"IF($A24=\"\",\"\",'tableau de scolarité'!D30)","v":"ذ"},{"$f":"IF($A24=\"\",\"\",'tableau de scolarité'!F30)","v":422},3.5,4.5,4,4,6,5,4,5,4.5,3.5,4.5,4,4,6,5,4.6428571428571432,null,null,"",4,3,3.5,5,3.875,3.5,5.33,4.415,6.75,8,7.375,5.08,5,5.04,4,3.5,3.75,5,6.5,5.75,1,{"$f":"IF($A24=\"\",\"\",6+AT24+'tableau de scolarité'!$P$3)","v":7},34.847857142857137,4.9782653061224478,15,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A31=\"\",\"\",'tableau de scolarité'!A31)","v":16},{"$f":"IF($A25=\"\",\"\",'tableau de scolarité'!B31)","v":"F23"},{"$f":"IF($A25=\"\",\"\",'tableau de scolarité'!C31)","v":"جميلة"},{"$f":"IF(A25=\"\",\"\",'tableau de scolarité'!G31)","v":"2008-09-29"},{"$f":"IF($A25=\"\",\"\",'tableau de scolarité'!D31)","v":"أ"},{"$f":"IF($A25=\"\",\"\",'tableau de scolarité'!F31)","v":425},5.5,4.5,5,4,4,4,4,6,5,5.75,5.5,5.625,4.5,5,4.75,4.8392857142857144,null,null,"",6,3,4.5,6,4.875,9,4.66,6.83,7.25,6,6.625,6.33,4.25,5.29,4,4.5,4.25,6,6,6,1,{"$f":"IF($A25=\"\",\"\",6+AT25+'tableau de scolarité'!$P$3)","v":7},38.709285714285713,5.529897959183673,11,"متوسط"]
[{"$f":"IF('tableau de scolarité'!A32=\"\",\"\",'tableau de scolarité'!A32)","v":17},{"$f":"IF($A26=\"\",\"\",'tableau de scolarité'!B32)","v":"F4"},{"$f":"IF($A26=\"\",\"\",'tableau de scolarité'!C32)","v":"شعيب"},{"$f":"IF(A26=\"\",\"\",'tableau de scolarité'!G32)","v":"2008-12-06"},{"$f":"IF($A26=\"\",\"\",'tableau de scolarité'!D32)","v":"ذ"},{"$f":"IF($A26=\"\",\"\",'tableau de scolarité'!F32)","v":406},7,5.5,6.25,8,9,8.5,6,7,6.5,6.5,7.5,7,6,7,6.5,6.8214285714285712,null,null,"",6,7.5,6.75,7,6.8125,9,9.33,9.1649999999999991,8,7,7.5,7.58,8.5,8.0399999999999991,6,6.75,6.375,6.75,6.75,6.75,1,{"$f":"IF($A26=\"\",\"\",6+AT26+'tableau de scolarité'!$P$3)","v":7},51.463928571428568,7.3519897959183664,4,"تشجيع"]
[{"$f":"IF('tableau de scolarité'!A33=\"\",\"\",'tableau de scolarité'!A33)","v":18},{"$f":"IF($A27=\"\",\"\",'tableau de scolarité'!B33)","v":"F22"},{"$f":"IF($A27=\"\",\"\",'tableau de scolarité'!C33)","v":"رقية"},{"$f":"IF(A27=\"\",\"\",'tableau de scolarité'!G33)","v":"2008-12-22"},{"$f":"IF($A27=\"\",\"\",'tableau de scolarité'!D33)","v":"أ"},{"$f":"IF($A27=\"\",\"\",'tableau de scolarité'!F33)","v":424},3.5,3,3.25,4,4,4,4,4,4,3.5,3,3.25,4,3,3.5,3.5714285714285716,null,null,"",4,4,4,5,4.25,4,6.66,5.33,5.75,5.5,5.625,2.5,1.75,2.125,4,4,4,6,6.75,6.375,1,{"$f":"IF($A27=\"\",\"\",6+AT27+'tableau de scolarité'!$P$3)","v":7},31.276428571428571,4.4680612244897961,19,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A34=\"\",\"\",'tableau de scolarité'!A34)","v":19},{"$f":"IF($A28=\"\",\"\",'tableau de scolarité'!B34)","v":"F17"},{"$f":"IF($A28=\"\",\"\",'tableau de scolarité'!C34)","v":"مريم"},{"$f":"IF(A28=\"\",\"\",'tableau de scolarité'!G34)","v":"2008-12-31"},{"$f":"IF($A28=\"\",\"\",'tableau de scolarité'!D34)","v":"أ"},{"$f":"IF($A28=\"\",\"\",'tableau de scolarité'!F34)","v":419},3.5,3,3.25,2,3,2.5,2,3,2.5,3.5,3,3.25,2,3,2.5,2.7142857142857144,null,null,"",4,3,3.5,4,3.625,3.5,2,2.75,5,4,4.5,4.5,1,2.75,2,3.5,2.75,5.25,6.5,5.875,1,{"$f":"IF($A28=\"\",\"\",6+AT28+'tableau de scolarité'!$P$3)","v":7},24.964285714285715,3.5663265306122449,24,"ناقص"]
[{"$f":"IF('tableau de scolarité'!A35=\"\",\"\",'tableau de scolarité'!A35)","v":20},{"$f":"IF($A29=\"\",\"\",'tableau de scolarité'!B35)","v":"F7"},{"$f":"IF($A29=\"\",\"\",'tableau de scolarité'!C35)","v":"مصطفى"},{"$f":"IF(A29=\"\",\"\",'tableau de scolarité'!G35)","v":"2009-01-02"},{"$f":"IF($A29=\"\",\"\",'tableau de scolarité'!D35)","v":"ذ"},{"$f":"IF($A29=\"\",\"\",'tableau de scolarité'!F35)","v":409},4,4.5,4.25,7,7.5,7.25,7,6.5,6.75,4,7,5.5,7,8,7.5,6.6071428571428568,null,null,"",6.5,4,5.25,7,5.6875,8.5,6,7.25,7.5,9,8.25,7.83,6,6.915,7,5.25,6.125,6.5,6.5,6.5,1,{"$f":"IF($A29=\"\",\"\",6+AT29+'tableau de scolarité'!$P$3)","v":7},47.33464285714286,6.7620918367346947,6,"لوحة الشرف"]
[{"$f":"IF('tableau de scolarité'!A36=\"\",\"\",'tableau de scolarité'!A36)","v":21},{"$f":"IF($A30=\"\",\"\",'tableau de scolarité'!B36)","v":"F19"},{"$f":"IF($A30=\"\",\"\",'tableau de scolarité'!C36)","v":"محمد"},{"$f":"IF(A30=\"\",\"\",'tableau de scolarité'!G36)","v":"2009-01-02"},{"$f":"IF($A30=\"\",\"\",'tableau de scolarité'!D36)","v":"أ"},{"$f":"IF($A30=\"\",\"\",'tableau de scolarité'!F36)","v":421},3.5,3,3.25,6,5,5.5,4,5,4.5,4,5.5,4.75,4,5,4.5,4.5,null,null,"",5,3,4,5,4.25,6.5,6.66,6.58,7.5,7,7.25,4.33,3,3.665,4,4,4,6,6.5,6.25,1,{"$f":"IF($A30=\"\",\"\",6+AT30+'tableau de scolarité'!$P$3)","v":7},36.494999999999997,5.2135714285714281,13,"متوسط"]
[{"$f":"IF('tableau de scolarité'!A37=\"\",\"\",'tableau de scolarité'!A37)","v":22},{"$f":"IF($A31=\"\",\"\",'tableau de scolarité'!B37)","v":"F16"},{"$f":"IF($A31=\"\",\"\",'tableau de scolarité'!C37)","v":"لمياء"},{"$f":"IF(A31=\"\",\"\",'tableau de scolarité'!G37)","v":"2009-01-24"},{"$f":"IF($A31=\"\",\"\",'tableau de scolarité'!D37)","v":"أ"},{"$f":"IF($A31=\"\",\"\",'tableau de scolarité'!F37)","v":418},3.5,3,3.25,3,3,3,3,4,3.5,4,4,4,3,3,3,3.25,null,null,"",4.5,3,3.75,4,3.8125,7.5,4,5.75,6,6.5,6.25,3,1,2,3,3.75,3.375,5,6.5,5.75,1,{"$f":"IF($A31=\"\",\"\",6+AT31+'tableau de scolarité'!$P$3)","v":7},30.1875,4.3125,21,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A38=\"\",\"\",'tableau de scolarité'!A38)","v":23},{"$f":"IF($A32=\"\",\"\",'tableau de scolarité'!B38)","v":"F18"},{"$f":"IF($A32=\"\",\"\",'tableau de scolarité'!C38)","v":"لقمان"},{"$f":"IF(A32=\"\",\"\",'tableau de scolarité'!G38)","v":"2009-02-20"},{"$f":"IF($A32=\"\",\"\",'tableau de scolarité'!D38)","v":"أ"},{"$f":"IF($A32=\"\",\"\",'tableau de scolarité'!F38)","v":420},3.75,3,3.375,2,4,3,2,4,3,4,4,4,2,5,3.5,3.4107142857142856,null,null,"",4.75,3,3.83,5.5,4.2699999999999996,4.5,4,4.25,6.5,6.5,6.5,4.5,4,4.25,2,3.875,2.9375,5,6.25,5.625,1,{"$f":"IF($A32=\"\",\"\",6+AT32+'tableau de scolarité'!$P$3)","v":7},31.243214285714284,4.4633163265306122,20,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A39=\"\",\"\",'tableau de scolarité'!A39)","v":24},{"$f":"IF($A33=\"\",\"\",'tableau de scolarité'!B39)","v":"F10"},{"$f":"IF($A33=\"\",\"\",'tableau de scolarité'!C39)","v":"لبنى"},{"$f":"IF(A33=\"\",\"\",'tableau de scolarité'!G39)","v":"2009-03-15"},{"$f":"IF($A33=\"\",\"\",'tableau de scolarité'!D39)","v":"أ"},{"$f":"IF($A33=\"\",\"\",'tableau de scolarité'!F39)","v":412},3.5,4,3.75,2,4,3,3,4,3.5,3.5,4,3.75,3,5,4,3.7142857142857144,null,null,"",5,4,4.5,4.5,4.5,7,8,7.5,5,8,6.5,4.5,2,3.25,3,4.5,3.75,5,6.5,5.75,1,{"$f":"IF($A33=\"\",\"\",6+AT33+'tableau de scolarité'!$P$3)","v":7},34.964285714285715,4.9948979591836737,14,"دون المتوسط"]
[{"$f":"IF('tableau de scolarité'!A40=\"\",\"\",'tableau de scolarité'!A40)","v":""},{"$f":"IF($A34=\"\",\"\",'tableau de scolarité'!B40)","v":""},{"$f":"IF($A34=\"\",\"\",'tableau de scolarité'!C40)","v":""},{"$f":"IF(A34=\"\",\"\",'tableau de scolarité'!G40)","v":""},{"$f":"IF($A34=\"\",\"\",'tableau de scolarité'!D40)","v":""},{"$f":"IF($A34=\"\",\"\",'tableau de scolarité'!F40)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A34=\"\",\"\",6+AT34+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A41=\"\",\"\",'tableau de scolarité'!A41)","v":""},{"$f":"IF($A35=\"\",\"\",'tableau de scolarité'!B41)","v":""},{"$f":"IF($A35=\"\",\"\",'tableau de scolarité'!C41)","v":""},{"$f":"IF(A35=\"\",\"\",'tableau de scolarité'!G41)","v":""},{"$f":"IF($A35=\"\",\"\",'tableau de scolarité'!D41)","v":""},{"$f":"IF($A35=\"\",\"\",'tableau de scolarité'!F41)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A35=\"\",\"\",6+AT35+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A42=\"\",\"\",'tableau de scolarité'!A42)","v":""},{"$f":"IF($A36=\"\",\"\",'tableau de scolarité'!B42)","v":""},{"$f":"IF($A36=\"\",\"\",'tableau de scolarité'!C42)","v":""},{"$f":"IF(A36=\"\",\"\",'tableau de scolarité'!G42)","v":""},{"$f":"IF($A36=\"\",\"\",'tableau de scolarité'!D42)","v":""},{"$f":"IF($A36=\"\",\"\",'tableau de scolarité'!F42)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A36=\"\",\"\",6+AT36+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A43=\"\",\"\",'tableau de scolarité'!A43)","v":""},{"$f":"IF($A37=\"\",\"\",'tableau de scolarité'!B43)","v":""},{"$f":"IF($A37=\"\",\"\",'tableau de scolarité'!C43)","v":""},{"$f":"IF(A37=\"\",\"\",'tableau de scolarité'!G43)","v":""},{"$f":"IF($A37=\"\",\"\",'tableau de scolarité'!D43)","v":""},{"$f":"IF($A37=\"\",\"\",'tableau de scolarité'!F43)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A37=\"\",\"\",6+AT37+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A44=\"\",\"\",'tableau de scolarité'!A44)","v":""},{"$f":"IF($A38=\"\",\"\",'tableau de scolarité'!B44)","v":""},{"$f":"IF($A38=\"\",\"\",'tableau de scolarité'!C44)","v":""},{"$f":"IF(A38=\"\",\"\",'tableau de scolarité'!G44)","v":""},{"$f":"IF($A38=\"\",\"\",'tableau de scolarité'!D44)","v":""},{"$f":"IF($A38=\"\",\"\",'tableau de scolarité'!F44)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A38=\"\",\"\",6+AT38+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A45=\"\",\"\",'tableau de scolarité'!A45)","v":""},{"$f":"IF($A39=\"\",\"\",'tableau de scolarité'!B45)","v":""},{"$f":"IF($A39=\"\",\"\",'tableau de scolarité'!C45)","v":""},{"$f":"IF(A39=\"\",\"\",'tableau de scolarité'!G45)","v":""},{"$f":"IF($A39=\"\",\"\",'tableau de scolarité'!D45)","v":""},{"$f":"IF($A39=\"\",\"\",'tableau de scolarité'!F45)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A39=\"\",\"\",6+AT39+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A46=\"\",\"\",'tableau de scolarité'!A46)","v":""},{"$f":"IF($A40=\"\",\"\",'tableau de scolarité'!B46)","v":""},{"$f":"IF($A40=\"\",\"\",'tableau de scolarité'!C46)","v":""},{"$f":"IF(A40=\"\",\"\",'tableau de scolarité'!G46)","v":""},{"$f":"IF($A40=\"\",\"\",'tableau de scolarité'!D46)","v":""},{"$f":"IF($A40=\"\",\"\",'tableau de scolarité'!F46)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A40=\"\",\"\",6+AT40+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A47=\"\",\"\",'tableau de scolarité'!A47)","v":""},{"$f":"IF($A41=\"\",\"\",'tableau de scolarité'!B47)","v":""},{"$f":"IF($A41=\"\",\"\",'tableau de scolarité'!C47)","v":""},{"$f":"IF(A41=\"\",\"\",'tableau de scolarité'!G47)","v":""},{"$f":"IF($A41=\"\",\"\",'tableau de scolarité'!D47)","v":""},{"$f":"IF($A41=\"\",\"\",'tableau de scolarité'!F47)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A41=\"\",\"\",6+AT41+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A48=\"\",\"\",'tableau de scolarité'!A48)","v":""},{"$f":"IF($A42=\"\",\"\",'tableau de scolarité'!B48)","v":""},{"$f":"IF($A42=\"\",\"\",'tableau de scolarité'!C48)","v":""},{"$f":"IF(A42=\"\",\"\",'tableau de scolarité'!G48)","v":""},{"$f":"IF($A42=\"\",\"\",'tableau de scolarité'!D48)","v":""},{"$f":"IF($A42=\"\",\"\",'tableau de scolarité'!F48)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A42=\"\",\"\",6+AT42+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A49=\"\",\"\",'tableau de scolarité'!A49)","v":""},{"$f":"IF($A43=\"\",\"\",'tableau de scolarité'!B49)","v":""},{"$f":"IF($A43=\"\",\"\",'tableau de scolarité'!C49)","v":""},{"$f":"IF(A43=\"\",\"\",'tableau de scolarité'!G49)","v":""},{"$f":"IF($A43=\"\",\"\",'tableau de scolarité'!D49)","v":""},{"$f":"IF($A43=\"\",\"\",'tableau de scolarité'!F49)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A43=\"\",\"\",6+AT43+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A50=\"\",\"\",'tableau de scolarité'!A50)","v":""},{"$f":"IF($A44=\"\",\"\",'tableau de scolarité'!B50)","v":""},{"$f":"IF($A44=\"\",\"\",'tableau de scolarité'!C50)","v":""},{"$f":"IF(A44=\"\",\"\",'tableau de scolarité'!G50)","v":""},{"$f":"IF($A44=\"\",\"\",'tableau de scolarité'!D50)","v":""},{"$f":"IF($A44=\"\",\"\",'tableau de scolarité'!F50)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A44=\"\",\"\",6+AT44+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A51=\"\",\"\",'tableau de scolarité'!A51)","v":""},{"$f":"IF($A45=\"\",\"\",'tableau de scolarité'!B51)","v":""},{"$f":"IF($A45=\"\",\"\",'tableau de scolarité'!C51)","v":""},{"$f":"IF(A45=\"\",\"\",'tableau de scolarité'!G51)","v":""},{"$f":"IF($A45=\"\",\"\",'tableau de scolarité'!D51)","v":""},{"$f":"IF($A45=\"\",\"\",'tableau de scolarité'!F51)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A45=\"\",\"\",6+AT45+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A52=\"\",\"\",'tableau de scolarité'!A52)","v":""},{"$f":"IF($A46=\"\",\"\",'tableau de scolarité'!B52)","v":""},{"$f":"IF($A46=\"\",\"\",'tableau de scolarité'!C52)","v":""},{"$f":"IF(A46=\"\",\"\",'tableau de scolarité'!G52)","v":""},{"$f":"IF($A46=\"\",\"\",'tableau de scolarité'!D52)","v":""},{"$f":"IF($A46=\"\",\"\",'tableau de scolarité'!F52)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A46=\"\",\"\",6+AT46+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A53=\"\",\"\",'tableau de scolarité'!A53)","v":""},{"$f":"IF($A47=\"\",\"\",'tableau de scolarité'!B53)","v":""},{"$f":"IF($A47=\"\",\"\",'tableau de scolarité'!C53)","v":""},{"$f":"IF(A47=\"\",\"\",'tableau de scolarité'!G53)","v":""},{"$f":"IF($A47=\"\",\"\",'tableau de scolarité'!D53)","v":""},{"$f":"IF($A47=\"\",\"\",'tableau de scolarité'!F53)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A47=\"\",\"\",6+AT47+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A54=\"\",\"\",'tableau de scolarité'!A54)","v":""},{"$f":"IF($A48=\"\",\"\",'tableau de scolarité'!B54)","v":""},{"$f":"IF($A48=\"\",\"\",'tableau de scolarité'!C54)","v":""},{"$f":"IF(A48=\"\",\"\",'tableau de scolarité'!G54)","v":""},{"$f":"IF($A48=\"\",\"\",'tableau de scolarité'!D54)","v":""},{"$f":"IF($A48=\"\",\"\",'tableau de scolarité'!F54)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A48=\"\",\"\",6+AT48+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A55=\"\",\"\",'tableau de scolarité'!A55)","v":""},{"$f":"IF($A49=\"\",\"\",'tableau de scolarité'!B55)","v":""},{"$f":"IF($A49=\"\",\"\",'tableau de scolarité'!C55)","v":""},{"$f":"IF(A49=\"\",\"\",'tableau de scolarité'!G55)","v":""},{"$f":"IF($A49=\"\",\"\",'tableau de scolarité'!D55)","v":""},{"$f":"IF($A49=\"\",\"\",'tableau de scolarité'!F55)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A49=\"\",\"\",6+AT49+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A56=\"\",\"\",'tableau de scolarité'!A56)","v":""},{"$f":"IF($A50=\"\",\"\",'tableau de scolarité'!B56)","v":""},{"$f":"IF($A50=\"\",\"\",'tableau de scolarité'!C56)","v":""},{"$f":"IF(A50=\"\",\"\",'tableau de scolarité'!G56)","v":""},{"$f":"IF($A50=\"\",\"\",'tableau de scolarité'!D56)","v":""},{"$f":"IF($A50=\"\",\"\",'tableau de scolarité'!F56)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A50=\"\",\"\",6+AT50+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A57=\"\",\"\",'tableau de scolarité'!A57)","v":""},{"$f":"IF($A51=\"\",\"\",'tableau de scolarité'!B57)","v":""},{"$f":"IF($A51=\"\",\"\",'tableau de scolarité'!C57)","v":""},{"$f":"IF(A51=\"\",\"\",'tableau de scolarité'!G57)","v":""},{"$f":"IF($A51=\"\",\"\",'tableau de scolarité'!D57)","v":""},{"$f":"IF($A51=\"\",\"\",'tableau de scolarité'!F57)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A51=\"\",\"\",6+AT51+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A58=\"\",\"\",'tableau de scolarité'!A58)","v":""},{"$f":"IF($A52=\"\",\"\",'tableau de scolarité'!B58)","v":""},{"$f":"IF($A52=\"\",\"\",'tableau de scolarité'!C58)","v":""},{"$f":"IF(A52=\"\",\"\",'tableau de scolarité'!G58)","v":""},{"$f":"IF($A52=\"\",\"\",'tableau de scolarité'!D58)","v":""},{"$f":"IF($A52=\"\",\"\",'tableau de scolarité'!F58)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A52=\"\",\"\",6+AT52+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A59=\"\",\"\",'tableau de scolarité'!A59)","v":""},{"$f":"IF($A53=\"\",\"\",'tableau de scolarité'!B59)","v":""},{"$f":"IF($A53=\"\",\"\",'tableau de scolarité'!C59)","v":""},{"$f":"IF(A53=\"\",\"\",'tableau de scolarité'!G59)","v":""},{"$f":"IF($A53=\"\",\"\",'tableau de scolarité'!D59)","v":""},{"$f":"IF($A53=\"\",\"\",'tableau de scolarité'!F59)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A53=\"\",\"\",6+AT53+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A60=\"\",\"\",'tableau de scolarité'!A60)","v":""},{"$f":"IF($A54=\"\",\"\",'tableau de scolarité'!B60)","v":""},{"$f":"IF($A54=\"\",\"\",'tableau de scolarité'!C60)","v":""},{"$f":"IF(A54=\"\",\"\",'tableau de scolarité'!G60)","v":""},{"$f":"IF($A54=\"\",\"\",'tableau de scolarité'!D60)","v":""},{"$f":"IF($A54=\"\",\"\",'tableau de scolarité'!F60)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A54=\"\",\"\",6+AT54+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A61=\"\",\"\",'tableau de scolarité'!A61)","v":""},{"$f":"IF($A55=\"\",\"\",'tableau de scolarité'!B61)","v":""},{"$f":"IF($A55=\"\",\"\",'tableau de scolarité'!C61)","v":""},{"$f":"IF(A55=\"\",\"\",'tableau de scolarité'!G61)","v":""},{"$f":"IF($A55=\"\",\"\",'tableau de scolarité'!D61)","v":""},{"$f":"IF($A55=\"\",\"\",'tableau de scolarité'!F61)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A55=\"\",\"\",6+AT55+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A62=\"\",\"\",'tableau de scolarité'!A62)","v":""},{"$f":"IF($A56=\"\",\"\",'tableau de scolarité'!B62)","v":""},{"$f":"IF($A56=\"\",\"\",'tableau de scolarité'!C62)","v":""},{"$f":"IF(A56=\"\",\"\",'tableau de scolarité'!G62)","v":""},{"$f":"IF($A56=\"\",\"\",'tableau de scolarité'!D62)","v":""},{"$f":"IF($A56=\"\",\"\",'tableau de scolarité'!F62)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A56=\"\",\"\",6+AT56+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A63=\"\",\"\",'tableau de scolarité'!A63)","v":""},{"$f":"IF($A57=\"\",\"\",'tableau de scolarité'!B63)","v":""},{"$f":"IF($A57=\"\",\"\",'tableau de scolarité'!C63)","v":""},{"$f":"IF(A57=\"\",\"\",'tableau de scolarité'!G63)","v":""},{"$f":"IF($A57=\"\",\"\",'tableau de scolarité'!D63)","v":""},{"$f":"IF($A57=\"\",\"\",'tableau de scolarité'!F63)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A57=\"\",\"\",6+AT57+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A64=\"\",\"\",'tableau de scolarité'!A64)","v":""},{"$f":"IF($A58=\"\",\"\",'tableau de scolarité'!B64)","v":""},{"$f":"IF($A58=\"\",\"\",'tableau de scolarité'!C64)","v":""},{"$f":"IF(A58=\"\",\"\",'tableau de scolarité'!G64)","v":""},{"$f":"IF($A58=\"\",\"\",'tableau de scolarité'!D64)","v":""},{"$f":"IF($A58=\"\",\"\",'tableau de scolarité'!F64)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A58=\"\",\"\",6+AT58+'tableau de scolarité'!$P$3)","v":""},"","","",""]
[{"$f":"IF('tableau de scolarité'!A65=\"\",\"\",'tableau de scolarité'!A65)","v":""},{"$f":"IF($A59=\"\",\"\",'tableau de scolarité'!B65)","v":""},{"$f":"IF($A59=\"\",\"\",'tableau de scolarité'!C65)","v":""},{"$f":"IF(A59=\"\",\"\",'tableau de scolarité'!G65)","v":""},{"$f":"IF($A59=\"\",\"\",'tableau de scolarité'!D65)","v":""},{"$f":"IF($A59=\"\",\"\",'tableau de scolarité'!F65)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A59=\"\",\"\",6+AT59+'tableau de scolarité'!$P$3)","v":""},"","","",""]

{"sheet":"bulletins_tre1","index":3,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,0,42,3],[42,4,42,5],[42,7,42,9],[42,11,42,14],[43,0,43,3],[43,4,43,5],[43,7,44,9],[43,11,44,14],[44,0,44,3],[44,4,44,5],[33,8,33,9],[33,12,34,14],[34,0,34,2],[34,3,34,5],[31,0,31,2],[31,3,31,5],[31,6,31,7],[31,8,31,9],[39,0,39,2],[39,3,39,5],[39,6,39,7],[39,8,39,9],[39,12,40,14],[40,0,40,2],[40,3,40,5],[37,0,38,2],[37,3,37,5],[37,6,37,7],[37,8,37,9],[37,12,38,14],[38,3,38,5],[26,0,27,2],[26,3,26,5],[26,6,26,9],[35,0,36,2],[35,3,35,5],[35,6,35,7],[35,8,35,9],[26,12,30,14],[27,3,27,5],[27,6,27,9],[28,0,30,2],[28,3,28,5],[28,6,28,9],[29,3,29,5],[29,6,29,9],[30,3,30,5],[35,12,36,14],[36,3,36,5],[31,12,32,14],[32,0,32,2],[32,3,32,5],[33,0,33,2],[33,3,33,5],[33,6,33,7],[23,3,23,5],[24,0,24,2],[24,3,24,5],[24,6,24,7],[24,8,24,9],[24,12,25,14],[25,0,25,2],[25,3,25,5],[18,12,23,14],[20,8,20,9],[21,3,21,5],[21,6,21,7],[21,8,21,9],[22,3,22,5],[22,6,22,7],[22,8,22,9],[18,0,23,2],[18,3,18,5],[18,6,18,7],[18,8,18,9],[19,3,19,5],[19,6,19,7],[19,8,19,9],[20,3,20,5],[20,6,20,7],[14,1,14,13],[16,0,17,2],[16,3,17,5],[16,6,16,11],[16,12,17,14],[17,6,17,7],[17,8,17,9],[6,10,6,12],[6,13,6,14],[8,1,9,13],[11,2,11,7],[11,8,11,12],[12,2,12,7],[12,8,12,12],[5,0,5,5],[5,10,5,12],[5,13,5,14],[2,0,2,5],[2,10,2,12],[2,13,2,14],[3,0,3,5],[3,10,3,12],[3,13,3,14],[0,0,0,5],[0,10,0,12],[0,13,0,14],[1,0,1,5],[1,10,1,12],[1,13,1,14],[4,0,4,5],[4,10,4,12],[4,13,4,14]]}
[{"$f":"'tableau de scolarité'!$A$1","v":"المملكة المغربية"},null,null,null,null,null,null,null,null,null,"الموسم الدراسي",null,null,{"$f":"IF($N$7=\"\",\"\",'tableau de scolarité'!$M$1)","v":"2019_2018"},null,null,null,null,null,null,null,null,null,null,null,"uuu"]
[{"$f":"'tableau de scolarité'!$A$2","v":"وزارة التربية الوطنية و التكوين المهني"},null,null,null,null,null,null,null,null,null,"الاسم و النسب",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,3,0))","v":"رضوان"}]
[{"$f":"'tableau de scolarité'!$A$3","v":"الاكاديمية الجهوية للتربية و التكوين"},null,null,null,null,null,null,null,null,null,"الرقم الوطني",null,null,7]
[{"$f":"'tableau de scolarité'!$A$4","v":"جهة: اسم الجهة هنا"},null,null,null,null,null,null,null,null,null,"رقم التسجيل",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,6,0))","v":408}]
[{"$f":"'tableau de scolarité'!$A$5","v":"مديرية: اسم المديرية هنا"},null,null,null,null,null,null,null,null,null,"رقم ت في القسم",null,null,1]
[{"$f":"'tableau de scolarité'!$A$6","v":"المؤسسة: اسم المؤسسة هنا"},null,null,null,null,null,null,null,null,null,"القسم",null,null,{"$f":"IF($N$7=\"\",\"\",'tableau de scolarité'!$M$3)","v":"الاول"}]
[null,null,null,null,null,null,null,null,null,null,"عدد التلاميذ",null,null,{"$f":"IF('tableau de scolarité'!$O$12=0,\"\",'tableau de scolarité'!$O$12)","v":24}]
[]
[null,"بطاقة المراقبة المستمرة"]
[]
[]
[null,null,"مدرسة",null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",'tableau de scolarité'!A6)","v":"المؤسسة: اسم المؤسسة هنا"}]
[null,null,"الاسم والنسب",null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,3,0))","v":"رضوان"}]
[]
[null,"نتائج الأسدوس الأول"]
[]
["الوحدات",null,null,"الانشطة",null,null,"الدورة الأولى",null,null,null,null,null,"ملاحظات"]
[null,null,null,null,null,null,"النقطة1",null,"النقطة2",null,null,"المعدل"]
["اللغة العربية",null,null,"القراءة",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,7,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,8,0))","v":3},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G19:J19))","v":3.5},{"$f":"IF($L$24=\"\",\"\",IF(L24<2,\"  ضعيف جدا\",IF(L24<4,\"ضعيف\",IF(L24<5,\"ناقص\",IF(L24<6,\"متوسط\",IF(L24<7,\"لابأس به\",IF(L24<8,\"مستحسن\",IF(L24<9,\"حسن\",\"حسن جدا\"))))))))","v":"ضعيف"}]
[null,null,null,"الإملاء",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,10,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,11,0))","v":3},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G20:J20))","v":3.5}]
[null,null,null,"الخط",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,13,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,14,0))","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G21:J21))","v":4}]
[null,null,null,"التعبير الشفوي",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,16,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,17,0))","v":3},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G22:J22))","v":3.5}]
[null,null,null,"النقل",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,19,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,20,0))","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G23:J23))","v":4}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(L19:L23))","v":3.7}]
["اللغة",null,null,"الأمازيغية",null,null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP(N5,base1,23,0)=\"\",\"\",VLOOKUP(N5,base1,23,0)))","v":""},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP(N5,base1,24,0)=\"\",\"\",VLOOKUP(N5,base1,24,0)))","v":""},null,null,{"$f":"IF(OR($N$7=\"\",G25=\"\",I25=\"\"),\"\",AVERAGE(D25:I25))","v":""},{"$f":"IF($N$7=\"\",\"\",IF(L26=\"\",\"الأمازيغية غير معممة\",IF(L26<2,\"  ضعيف جدا\",IF(L26<4,\"ضعيف\",IF(L26<5,\"ناقص\",IF(L26<6,\"متوسط\",IF(L26<7,\"لابأس به\",IF(L26<8,\"مستحسن\",IF(L26<9,\"حسن\",\"حسن جدا\")))))))))","v":"الأمازيغية غير معممة"}]
["الأمازيغية",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L25)","v":""}]
["التربية ",null,null,"الفرض 1",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,26,0))","v":4},null,{"$f":"VLOOKUP($N$5,base1,29,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G27)","v":4},{"$f":"IF($L$31=\"\",\"\",IF(L31<2,\"  ضعيف جدا\",IF(L31<4,\"ضعيف\",IF(L31<5,\"ناقص\",IF(L31<6,\"متوسط\",IF(L31<7,\"لابأس به\",IF(L31<8,\"مستحسن\",IF(L31<9,\"حسن\",\"حسن جدا\"))))))))","v":"ضعيف"}]
[null,null,null,"الفرض 2",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,27,0))","v":3},null,{"$f":"VLOOKUP($N$5,base1,29,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G28)","v":3}]
["الإسلامية",null,null,"الفرض 3",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,28,0))","v":3.5},null,{"$f":"VLOOKUP($N$5,base1,32,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G29)","v":3.5}]
[null,null,null,"أنشطة",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,29,0))","v":4},null,{"$f":"VLOOKUP($N$5,base1,32,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G30)","v":4}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(L27:L30))","v":3.625}]
["النشاط ",null,null,"النشاط العلمي",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,31,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,32,0))","v":4},null,null,{"$f":"IF(OR($N$7=\"\",G32=\"\",I32=\"\"),\"\",AVERAGE(D32:I32))","v":4},{"$f":"IF($L$33=\"\",\"\",IF(L33<2,\"  ضعيف جدا\",IF(L33<4,\"ضعيف\",IF(L33<5,\"ناقص\",IF(L33<6,\"متوسط\",IF(L33<7,\"لابأس به\",IF(L33<8,\"مستحسن\",IF(L33<9,\"حسن\",\"حسن جدا\"))))))))","v":"ناقص"}]
["العلمي",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L32)","v":4}]
["التربية",null,null,"التربية الفنية",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,34,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,35,0))","v":6.5},null,null,{"$f":"IF(OR($N$7=\"\",G34=\"\",I34=\"\"),\"\",AVERAGE(D34:I34))","v":5.25},{"$f":"IF($L$35=\"\",\"\",IF(L35<2,\"  ضعيف جدا\",IF(L35<4,\"ضعيف\",IF(L35<5,\"ناقص\",IF(L35<6,\"متوسط\",IF(L35<7,\"لابأس به\",IF(L35<8,\"مستحسن\",IF(L35<9,\"حسن\",\"حسن جدا\"))))))))","v":"متوسط"}]
["الفنية",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L34)","v":5.25}]
["الرياضيات",null,null,"الرياضيات",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,37,0))","v":3},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,38,0))","v":3.5},null,null,{"$f":"IF(OR($N$7=\"\",G36=\"\",I36=\"\"),\"\",AVERAGE(D36:I36))","v":3.25},{"$f":"IF($L$37=\"\",\"\",IF(L37<2,\"  ضعيف جدا\",IF(L37<4,\"ضعيف\",IF(L37<5,\"ناقص\",IF(L37<6,\"متوسط\",IF(L37<7,\"لابأس به\",IF(L37<8,\"مستحسن\",IF(L37<9,\"حسن\",\"حسن جدا\"))))))))","v":"ضعيف"}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L36)","v":3.25}]
["الفرنسية",null,null,"الفرنسية",null,null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP(N5,base1,40,0)=\"\",\"\",VLOOKUP(N5,base1,40,0)))","v":4},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP(N5,base1,41,0)=\"\",\"\",VLOOKUP(N5,base1,41,0)))","v":3.5},null,null,{"$f":"IF(OR($N$7=\"\",G38=\"\",I38=\"\"),\"\",AVERAGE(D38:I38))","v":3.75},{"$f":"IF($L$39=\"\",\"\",IF(L39<2,\"  ضعيف جدا\",IF(L39<4,\"ضعيف\",IF(L39<5,\"ناقص\",IF(L39<6,\"متوسط\",IF(L39<7,\"لابأس به\",IF(L39<8,\"مستحسن\",IF(L39<9,\"حسن\",\"حسن جدا\"))))))))","v":"ضعيف"}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L38)","v":3.75}]
["التربية",null,null,"التربية البدنية",null,null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP(N5,base1,43,0)=\"\",\"\",VLOOKUP(N5,base1,43,0)))","v":6.25},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP(N5,base1,44,0)=\"\",\"\",VLOOKUP(N5,base1,44,0)))","v":6.75},null,null,{"$f":"IF(OR($N$7=\"\",G40=\"\",I40=\"\"),\"\",AVERAGE(D40:I40))","v":6.5},{"$f":"IF($L$41=\"\",\"معفى من التربية البدنية\",IF(L41<2,\"  ضعيف جدا\",IF(L41<4,\"ضعيف\",IF(L41<5,\"ناقص\",IF(L41<6,\"متوسط\",IF(L41<7,\"لابأس به\",IF(L41<8,\"مستحسن\",IF(L41<9,\"حسن\",\"حسن جدا\"))))))))","v":"لابأس به"}]
["البدنية",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L40)","v":6.5}]
[]
["مجموع معدل الوحدات",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,48,0))","v":30.160714285714285},null,null,"الميزة",null,null,null,"خاتم و توقيع رئيس المؤسسة"]
["المعدل الدوري",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,49,0))","v":4.3086734693877551},null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,51,0))","v":"دون المتوسط"}]
["الرتبة",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP(N5,base1,50,0))","v":22}]