{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["info","sem1","bulletin_sem1","sem2","bulletin_sem2","مجمل"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":18,"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":"info","index":0,"n_rows":65,"n_cols":22,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,15,0,18],[1,15,1,18],[2,15,2,18],[3,12,3,14],[4,12,4,14],[0,12,0,14],[1,12,1,14],[2,12,2,14],[0,9,0,11],[1,9,1,11],[2,9,2,11],[3,9,3,11],[4,9,4,11],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[13,0,14,0],[13,2,14,2],[5,9,5,11],[5,12,5,14],[7,11,7,14],[13,1,14,1],[5,0,5,2],[13,8,13,13],[13,14,14,14],[13,3,14,3],[13,4,14,4]]}
["المملكة المغربية",null,null,null,null,null,null,null,null,"العـام الدراســي ",null,null,"2018-2017",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":"O12","v":25}]
[]
[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":"SUMPRODUCT(($D$16:$D$65=\"ذ\")*($E$16:$E$65=\"\"))","v":11},{"$f":"SUMPRODUCT(($D$16:$D$65=\"ذ\")*($E$16:$E$65=\"مك\"))","v":3},{"$f":"SUM(M10:N10)","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,"إناث",{"$f":"SUMPRODUCT(($D$16:$D$65=\"أ\")*($E$16:$E$65=\"\"))","v":10},{"$f":"SUMPRODUCT(($D$16:$D$65=\"أ\")*($E$16:$E$65=\"مك\"))","v":1},{"$f":"SUM(M11:N11)","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,"مج",{"$f":"SUM(M10:M11)","v":21},{"$f":"SUM(N10:N11)","v":4},{"$f":"SUM(O10:O11)","v":25}]
[]
["ر.ت","رقم التلميذ","الاسم و النسب","الجنس","التكرار","رقم","تاريخ","تاريخ","مدة الدراسة",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},1,"رضوان","ذ","مك",null,"2005-06-23"]
[{"$f":"IF($C17=\"\",\"\",MAX($A$15:$A16)+1)","v":2},2,"محمد","ذ",null,null,"2008-03-14"]
[{"$f":"IF($C18=\"\",\"\",MAX($A$15:$A17)+1)","v":3},3,"سلمى","أ",null,null,"2007-10-07"]
[{"$f":"IF($C19=\"\",\"\",MAX($A$15:$A18)+1)","v":4},4,"شعيب","ذ",null,null,"2008-12-06"]
[{"$f":"IF($C20=\"\",\"\",MAX($A$15:$A19)+1)","v":5},5,"ميلود","ذ","مك",null,"2008-07-10"]
[{"$f":"IF($C21=\"\",\"\",MAX($A$15:$A20)+1)","v":6},6,"فاطمة","أ",null,null,"2008-01-08"]
[{"$f":"IF($C22=\"\",\"\",MAX($A$15:$A21)+1)","v":7},7,"مصطفى","ذ","مك",null,"2009-01-02"]
[{"$f":"IF($C23=\"\",\"\",MAX($A$15:$A22)+1)","v":8},8,"فريد","ذ",null,null,"2008-07-27"]
[{"$f":"IF($C24=\"\",\"\",MAX($A$15:$A23)+1)","v":9},9,"كمال","ذ",null,null,"2008-07-16"]
[{"$f":"IF($C25=\"\",\"\",MAX($A$15:$A24)+1)","v":10},10,"لبنى","أ","مك",null,"2009-03-15"]
[{"$f":"IF($C26=\"\",\"\",MAX($A$15:$A25)+1)","v":11},11,"أحمد","ذ",null,null,"2008-07-13"]
[{"$f":"IF($C27=\"\",\"\",MAX($A$15:$A26)+1)","v":12},12,"سلمان","ذ",null,null,"2007-12-31"]
[{"$f":"IF($C28=\"\",\"\",MAX($A$15:$A27)+1)","v":13},13,"مروة","أ",null,null,"2008-04-07"]
[{"$f":"IF($C29=\"\",\"\",MAX($A$15:$A28)+1)","v":14},14,"خالد","ذ",null,null,"2008-04-14"]
[{"$f":"IF($C30=\"\",\"\",MAX($A$15:$A29)+1)","v":15},15,"سفيان","ذ",null,null,"2008-08-13"]
[{"$f":"IF($C31=\"\",\"\",MAX($A$15:$A30)+1)","v":16},16,"لمياء","أ",null,null,"2009-01-24"]
[{"$f":"IF($C32=\"\",\"\",MAX($A$15:$A31)+1)","v":17},17,"مريم","أ",null,null,"2008-12-31"]
[{"$f":"IF($C33=\"\",\"\",MAX($A$15:$A32)+1)","v":18},18,"لقمان","ذ",null,null,"2009-02-20"]
[{"$f":"IF($C34=\"\",\"\",MAX($A$15:$A33)+1)","v":19},19,"محمد","ذ",null,null,"2009-01-02"]
[{"$f":"IF($C35=\"\",\"\",MAX($A$15:$A34)+1)","v":20},20,"سليم","ذ",null,null,"2008-09-22"]
[{"$f":"IF($C36=\"\",\"\",MAX($A$15:$A35)+1)","v":21},21,"فتيحة","أ",null,null,"2008-04-12"]
[{"$f":"IF($C37=\"\",\"\",MAX($A$15:$A36)+1)","v":22},22,"رقية","أ",null,null,"2008-12-22"]
[{"$f":"IF($C38=\"\",\"\",MAX($A$15:$A37)+1)","v":23},23,"جميلة","أ",null,null,"2008-11-29"]
[{"$f":"IF($C39=\"\",\"\",MAX($A$15:$A38)+1)","v":24},24,"نادية","أ",null,null,"2008-06-24"]
[{"$f":"IF($C40=\"\",\"\",MAX($A$15:$A39)+1)","v":25},25,"سكينة","أ",null,null,"2008-06-07"]
[{"$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":"sem1","index":1,"n_rows":59,"n_cols":51,"rows_kept":59,"cut":false,"hidden":false,"merged":[[6,25,6,29],[6,39,6,41],[7,36,7,37],[7,39,7,40],[2,2,2,5],[2,32,2,34],[4,2,4,5],[5,2,5,5],[3,2,3,5],[3,8,4,26],[2,29,2,31],[3,29,3,31],[4,29,4,31],[3,32,3,34],[4,32,4,34],[7,22,7,23],[6,6,6,21],[6,22,6,24],[7,6,7,8],[7,9,7,11],[7,18,7,20],[7,12,7,14],[7,15,7,17],[7,30,7,31],[7,33,7,34],[7,42,7,43],[6,30,6,32],[6,33,6,35],[6,36,6,38],[6,42,6,44],[6,45,8,45],[6,49,8,49],[6,50,8,50],[6,46,8,46],[6,47,8,47],[6,48,8,48],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,5,8,5],[7,4,8,4],[0,2,0,5],[0,29,0,31],[0,32,0,34],[1,2,1,5],[1,29,1,31],[1,32,1,34]]}
[null,null,{"$f":"info!$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":"info!M1","v":"2018-2017"}]
[null,null,{"$f":"info!$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":"info!$M$2","v":"هشام "}]
[null,null,{"$f":"info!$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":"info!$M$3","v":"الأول"}]
[null,null,{"$f":"info!$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":"info!$M$4","v":"لايهم"}]
[null,null,{"$f":"info!$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":"info!$M$5","v":1}]
[null,null,{"$f":"info!$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(info!A16=\"\",\"\",info!A16)","v":1},{"$f":"IF($A10=\"\",\"\",info!B16)","v":1},{"$f":"IF($A10=\"\",\"\",info!C16)","v":"رضوان"},{"$f":"IF($A10=\"\",\"\",info!G16)","v":"2005-06-23"},{"$f":"IF($A10=\"\",\"\",info!D16)","v":"ذ"},{"$f":"IF($A10=\"\",\"\",info!F16)","v":0},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(U10,R10,O10,L10,I10))","v":3.7},null,null,{"$f":"IF(OR(W10=\"\",X10=\"\"),\"\",AVERAGE(W10:X10))","v":""},4,3,{"$f":"IF(Z10=\"\",\"\",IF(AA10=\"\",\"\",AVERAGE(Z10:AA10)))","v":3.5},4,{"$f":"IF(OR(Z10=\"\",AA10=\"\",AB10=\"\",AC10=\"\"),\"\",AVERAGE(Z10:AC10))","v":3.625},4,4,{"$f":"IF(OR(AE10=\"\",AF10=\"\"),\"\",AVERAGE(AE10:AF10))","v":4},4,6.5,{"$f":"IF(OR(AH10=\"\",AI10=\"\"),\"\",AVERAGE(AH10:AI10))","v":5.25},3,3.5,{"$f":"IF(OR(AK10=\"\",AL10=\"\"),\"\",AVERAGE(AK10:AL10))","v":3.25},4,3.5,{"$f":"IF(OR(AN10=\"\",AO10=\"\"),\"\",AVERAGE(AN10:AO10))","v":3.75},5.5,6.5,{"$f":"IF(OR(AQ10=\"\",AR10=\"\"),\"\",AVERAGE(AQ10:AR10))","v":6},1,{"$f":"IF($A10=\"\",\"\",6+AT10+info!$P$3)","v":7},{"$f":"IF($A10=\"\",\"\",SUM(V10,AD10,AG10,AJ10,AM10,AS10,Y10))","v":25.824999999999999},{"$f":"IF($A10=\"\",\"\",AV10/AU10)","v":3.6892857142857141},{"$f":"IF($A10=\"\",\"\",RANK(AW10,$AW$10:$AW$59))","v":23},{"$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(info!A17=\"\",\"\",info!A17)","v":2},{"$f":"IF($A11=\"\",\"\",info!B17)","v":2},{"$f":"IF($A11=\"\",\"\",info!C17)","v":"محمد"},{"$f":"IF($A11=\"\",\"\",info!G17)","v":"2008-03-14"},{"$f":"IF($A11=\"\",\"\",info!D17)","v":"ذ"},{"$f":"IF($A11=\"\",\"\",info!F17)","v":0},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(U11,R11,O11,L11,I11))","v":5.45},null,null,{"$f":"IF(OR(W11=\"\",X11=\"\"),\"\",AVERAGE(W11:X11))","v":""},6.5,4,{"$f":"IF(Z11=\"\",\"\",IF(AA11=\"\",\"\",AVERAGE(Z11:AA11)))","v":5.25},6,{"$f":"IF(OR(Z11=\"\",AA11=\"\",AB11=\"\",AC11=\"\"),\"\",AVERAGE(Z11:AC11))","v":5.4375},9.5,9,{"$f":"IF(OR(AE11=\"\",AF11=\"\"),\"\",AVERAGE(AE11:AF11))","v":9.25},7.25,6.5,{"$f":"IF(OR(AH11=\"\",AI11=\"\"),\"\",AVERAGE(AH11:AI11))","v":6.875},6.58,6.75,{"$f":"IF(OR(AK11=\"\",AL11=\"\"),\"\",AVERAGE(AK11:AL11))","v":6.665},6,5.25,{"$f":"IF(OR(AN11=\"\",AO11=\"\"),\"\",AVERAGE(AN11:AO11))","v":5.625},5.5,6.75,{"$f":"IF(OR(AQ11=\"\",AR11=\"\"),\"\",AVERAGE(AQ11:AR11))","v":6.125},1,{"$f":"IF($A11=\"\",\"\",6+AT11+info!$P$3)","v":7},39.802500000000002,{"$f":"IF($A11=\"\",\"\",AV11/AU11)","v":5.6860714285714291},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(info!A18=\"\",\"\",info!A18)","v":3},{"$f":"IF($A12=\"\",\"\",info!B18)","v":3},{"$f":"IF($A12=\"\",\"\",info!C18)","v":"سلمى"},{"$f":"IF($A12=\"\",\"\",info!G18)","v":"2007-10-07"},{"$f":"IF($A12=\"\",\"\",info!D18)","v":"أ"},{"$f":"IF($A12=\"\",\"\",info!F18)","v":0},3.5,4.5,4,6,5,5.5,5,5.5,5.25,3.5,4.5,4,5,5,5,4.75,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+info!$P$3)","v":7},33.83,4.8328571428571427,12,"دون المتوسط"]
[{"$f":"IF(info!A19=\"\",\"\",info!A19)","v":4},{"$f":"IF($A13=\"\",\"\",info!B19)","v":4},{"$f":"IF($A13=\"\",\"\",info!C19)","v":"شعيب"},{"$f":"IF($A13=\"\",\"\",info!G19)","v":"2008-12-06"},{"$f":"IF($A13=\"\",\"\",info!D19)","v":"ذ"},{"$f":"IF($A13=\"\",\"\",info!F19)","v":0},7,6.5,6.75,6,6.75,6.375,6,7,6.5,6.5,8,7.25,6,6,6,6.5750000000000002,null,null,"",8.75,5.5,7.125,7.5,7.21875,6,9.5,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+info!$P$3)","v":7},45.458749999999995,6.4941071428571417,3,"لوحة الشرف"]
[{"$f":"IF(info!A20=\"\",\"\",info!A20)","v":5},{"$f":"IF($A14=\"\",\"\",info!B20)","v":5},{"$f":"IF($A14=\"\",\"\",info!C20)","v":"ميلود"},{"$f":"IF($A14=\"\",\"\",info!G20)","v":"2008-07-10"},{"$f":"IF($A14=\"\",\"\",info!D20)","v":"ذ"},{"$f":"IF($A14=\"\",\"\",info!F20)","v":0},4,5,4.5,5.5,5,5.25,4,6.5,5.25,4,6.5,5.25,4,6,5,5.05,null,null,"",5.25,4.5,4.875,6,5.15625,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+info!$P$3)","v":7},36.286250000000003,5.1837500000000007,10,"متوسط"]
[{"$f":"IF(info!A21=\"\",\"\",info!A21)","v":6},{"$f":"IF($A15=\"\",\"\",info!B21)","v":6},{"$f":"IF($A15=\"\",\"\",info!C21)","v":"فاطمة"},{"$f":"IF($A15=\"\",\"\",info!G21)","v":"2008-01-08"},{"$f":"IF($A15=\"\",\"\",info!D21)","v":"أ"},{"$f":"IF($A15=\"\",\"\",info!F21)","v":0},3,3.5,3.25,2,3,2.5,2,4,3,3,4,3.5,2,4,3,3.05,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+info!$P$3)","v":7},25.465,3.6378571428571429,24,"ناقص"]
[{"$f":"IF(info!A22=\"\",\"\",info!A22)","v":7},{"$f":"IF($A16=\"\",\"\",info!B22)","v":7},{"$f":"IF($A16=\"\",\"\",info!C22)","v":"مصطفى"},{"$f":"IF($A16=\"\",\"\",info!G22)","v":"2009-01-02"},{"$f":"IF($A16=\"\",\"\",info!D22)","v":"ذ"},{"$f":"IF($A16=\"\",\"\",info!F22)","v":0},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+info!$P$3)","v":7},30.33,4.3328571428571427,17,"دون المتوسط"]
[{"$f":"IF(info!A23=\"\",\"\",info!A23)","v":8},{"$f":"IF($A17=\"\",\"\",info!B23)","v":8},{"$f":"IF($A17=\"\",\"\",info!C23)","v":"فريد"},{"$f":"IF($A17=\"\",\"\",info!G23)","v":"2008-07-27"},{"$f":"IF($A17=\"\",\"\",info!D23)","v":"ذ"},{"$f":"IF($A17=\"\",\"\",info!F23)","v":0},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.7249999999999996,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+info!$P$3)","v":7},43.407499999999999,6.2010714285714288,5,"لوحة الشرف"]
[{"$f":"IF(info!A24=\"\",\"\",info!A24)","v":9},{"$f":"IF($A18=\"\",\"\",info!B24)","v":9},{"$f":"IF($A18=\"\",\"\",info!C24)","v":"كمال"},{"$f":"IF($A18=\"\",\"\",info!G24)","v":"2008-07-16"},{"$f":"IF($A18=\"\",\"\",info!D24)","v":"ذ"},{"$f":"IF($A18=\"\",\"\",info!F24)","v":0},5.75,6.5,6.125,7,7,7,6,7,6.5,6,7.75,6.875,7,6.5,6.75,6.65,null,null,"",8.5,6.5,7.5,8.5,7.75,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+info!$P$3)","v":7},46.480000000000004,6.6400000000000006,1,"لوحة الشرف"]
[{"$f":"IF(info!A25=\"\",\"\",info!A25)","v":10},{"$f":"IF($A19=\"\",\"\",info!B25)","v":10},{"$f":"IF($A19=\"\",\"\",info!C25)","v":"لبنى"},{"$f":"IF($A19=\"\",\"\",info!G25)","v":"2009-03-15"},{"$f":"IF($A19=\"\",\"\",info!D25)","v":"أ"},{"$f":"IF($A19=\"\",\"\",info!F25)","v":0},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.2,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+info!$P$3)","v":7},28.2,4.0285714285714285,20,"دون المتوسط"]
[{"$f":"IF(info!A26=\"\",\"\",info!A26)","v":11},{"$f":"IF($A20=\"\",\"\",info!B26)","v":11},{"$f":"IF($A20=\"\",\"\",info!C26)","v":"أحمد"},{"$f":"IF($A20=\"\",\"\",info!G26)","v":"2008-07-13"},{"$f":"IF($A20=\"\",\"\",info!D26)","v":"ذ"},{"$f":"IF($A20=\"\",\"\",info!F26)","v":0},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.7249999999999996,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+info!$P$3)","v":7},41.93,5.99,6,"متوسط"]
[{"$f":"IF(info!A27=\"\",\"\",info!A27)","v":12},{"$f":"IF($A21=\"\",\"\",info!B27)","v":12},{"$f":"IF($A21=\"\",\"\",info!C27)","v":"سلمان"},{"$f":"IF($A21=\"\",\"\",info!G27)","v":"2007-12-31"},{"$f":"IF($A21=\"\",\"\",info!D27)","v":"ذ"},{"$f":"IF($A21=\"\",\"\",info!F27)","v":0},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.0750000000000002,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+info!$P$3)","v":7},46.265000000000001,6.609285714285714,2,"لوحة الشرف"]
[{"$f":"IF(info!A28=\"\",\"\",info!A28)","v":13},{"$f":"IF($A22=\"\",\"\",info!B28)","v":13},{"$f":"IF($A22=\"\",\"\",info!C28)","v":"مروة"},{"$f":"IF($A22=\"\",\"\",info!G28)","v":"2008-04-07"},{"$f":"IF($A22=\"\",\"\",info!D28)","v":"أ"},{"$f":"IF($A22=\"\",\"\",info!F28)","v":0},3.5,3,3.25,2,6,4,3,5,4,3.5,4.5,4,3,6,4.5,3.95,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+info!$P$3)","v":7},29.655000000000001,4.2364285714285712,18,"دون المتوسط"]
[{"$f":"IF(info!A29=\"\",\"\",info!A29)","v":14},{"$f":"IF($A23=\"\",\"\",info!B29)","v":14},{"$f":"IF($A23=\"\",\"\",info!C29)","v":"خالد"},{"$f":"IF($A23=\"\",\"\",info!G29)","v":"2008-04-14"},{"$f":"IF($A23=\"\",\"\",info!D29)","v":"ذ"},{"$f":"IF($A23=\"\",\"\",info!F29)","v":0},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.2750000000000004,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+info!$P$3)","v":7},39.314999999999998,5.6164285714285711,9,"متوسط"]
[{"$f":"IF(info!A30=\"\",\"\",info!A30)","v":15},{"$f":"IF($A24=\"\",\"\",info!B30)","v":15},{"$f":"IF($A24=\"\",\"\",info!C30)","v":"سفيان"},{"$f":"IF($A24=\"\",\"\",info!G30)","v":"2008-08-13"},{"$f":"IF($A24=\"\",\"\",info!D30)","v":"ذ"},{"$f":"IF($A24=\"\",\"\",info!F30)","v":0},3.5,4.5,4,4,6,5,4,5,4.5,3.5,4.5,4,4,6,5,4.5,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+info!$P$3)","v":7},30.954999999999998,4.4221428571428572,16,"دون المتوسط"]
[{"$f":"IF(info!A31=\"\",\"\",info!A31)","v":16},{"$f":"IF($A25=\"\",\"\",info!B31)","v":16},{"$f":"IF($A25=\"\",\"\",info!C31)","v":"لمياء"},{"$f":"IF($A25=\"\",\"\",info!G31)","v":"2009-01-24"},{"$f":"IF($A25=\"\",\"\",info!D31)","v":"أ"},{"$f":"IF($A25=\"\",\"\",info!F31)","v":0},5.5,4.5,5,4,4,4,4,6,5,5.75,5.5,5.625,4.5,5,4.75,4.875,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+info!$P$3)","v":7},34.494999999999997,4.9278571428571425,11,"دون المتوسط"]
[{"$f":"IF(info!A32=\"\",\"\",info!A32)","v":17},{"$f":"IF($A26=\"\",\"\",info!B32)","v":17},{"$f":"IF($A26=\"\",\"\",info!C32)","v":"مريم"},{"$f":"IF($A26=\"\",\"\",info!G32)","v":"2008-12-31"},{"$f":"IF($A26=\"\",\"\",info!D32)","v":"أ"},{"$f":"IF($A26=\"\",\"\",info!F32)","v":0},7,5.5,6.25,8,9,8.5,6,7,6.5,6.5,7.5,7,6,7,6.5,6.95,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+info!$P$3)","v":7},45.217500000000001,6.4596428571428577,4,"لوحة الشرف"]
[{"$f":"IF(info!A33=\"\",\"\",info!A33)","v":18},{"$f":"IF($A27=\"\",\"\",info!B33)","v":18},{"$f":"IF($A27=\"\",\"\",info!C33)","v":"لقمان"},{"$f":"IF($A27=\"\",\"\",info!G33)","v":"2009-02-20"},{"$f":"IF($A27=\"\",\"\",info!D33)","v":"ذ"},{"$f":"IF($A27=\"\",\"\",info!F33)","v":0},3.5,3,3.25,4,4,4,4,4,4,3.5,3,3.25,4,3,3.5,3.6,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+info!$P$3)","v":7},27.305,3.9007142857142858,21,"ناقص"]
[{"$f":"IF(info!A34=\"\",\"\",info!A34)","v":19},{"$f":"IF($A28=\"\",\"\",info!B34)","v":19},{"$f":"IF($A28=\"\",\"\",info!C34)","v":"محمد"},{"$f":"IF($A28=\"\",\"\",info!G34)","v":"2009-01-02"},{"$f":"IF($A28=\"\",\"\",info!D34)","v":"ذ"},{"$f":"IF($A28=\"\",\"\",info!F34)","v":0},3.5,3,3.25,2,3,2.5,2,3,2.5,3.5,3,3.25,2,3,2.5,2.8,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+info!$P$3)","v":7},22.3,3.1857142857142859,25,"ناقص"]
[{"$f":"IF(info!A35=\"\",\"\",info!A35)","v":20},{"$f":"IF($A29=\"\",\"\",info!B35)","v":20},{"$f":"IF($A29=\"\",\"\",info!C35)","v":"سليم"},{"$f":"IF($A29=\"\",\"\",info!G35)","v":"2008-09-22"},{"$f":"IF($A29=\"\",\"\",info!D35)","v":"ذ"},{"$f":"IF($A29=\"\",\"\",info!F35)","v":0},4,4.5,4.25,7,7.5,7.25,7,6.5,6.75,4,7,5.5,7,8,7.5,6.25,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+info!$P$3)","v":7},40.852499999999999,5.8360714285714286,7,"متوسط"]
[{"$f":"IF(info!A36=\"\",\"\",info!A36)","v":21},{"$f":"IF($A30=\"\",\"\",info!B36)","v":21},{"$f":"IF($A30=\"\",\"\",info!C36)","v":"فتيحة"},{"$f":"IF($A30=\"\",\"\",info!G36)","v":"2008-04-12"},{"$f":"IF($A30=\"\",\"\",info!D36)","v":"أ"},{"$f":"IF($A30=\"\",\"\",info!F36)","v":0},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+info!$P$3)","v":7},32.494999999999997,4.6421428571428569,14,"دون المتوسط"]
[{"$f":"IF(info!A37=\"\",\"\",info!A37)","v":22},{"$f":"IF($A31=\"\",\"\",info!B37)","v":22},{"$f":"IF($A31=\"\",\"\",info!C37)","v":"رقية"},{"$f":"IF($A31=\"\",\"\",info!G37)","v":"2008-12-22"},{"$f":"IF($A31=\"\",\"\",info!D37)","v":"أ"},{"$f":"IF($A31=\"\",\"\",info!F37)","v":0},3.5,3,3.25,3,3,3,3,4,3.5,4,4,4,3,3,3,3.35,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+info!$P$3)","v":7},26.912500000000001,3.8446428571428575,22,"ناقص"]
[{"$f":"IF(info!A38=\"\",\"\",info!A38)","v":23},{"$f":"IF($A32=\"\",\"\",info!B38)","v":23},{"$f":"IF($A32=\"\",\"\",info!C38)","v":"جميلة"},{"$f":"IF($A32=\"\",\"\",info!G38)","v":"2008-11-29"},{"$f":"IF($A32=\"\",\"\",info!D38)","v":"أ"},{"$f":"IF($A32=\"\",\"\",info!F38)","v":0},3.75,3,3.375,2,4,3,2,4,3,4,4,4,2,5,3.5,3.375,null,null,"",4.75,3,3.875,5.5,4.28125,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+info!$P$3)","v":7},28.28125,4.0401785714285712,19,"دون المتوسط"]
[{"$f":"IF(info!A39=\"\",\"\",info!A39)","v":24},{"$f":"IF($A33=\"\",\"\",info!B39)","v":24},{"$f":"IF($A33=\"\",\"\",info!C39)","v":"نادية"},{"$f":"IF($A33=\"\",\"\",info!G39)","v":"2008-06-24"},{"$f":"IF($A33=\"\",\"\",info!D39)","v":"أ"},{"$f":"IF($A33=\"\",\"\",info!F39)","v":0},3.5,4,3.75,2,4,3,3,4,3.5,3.5,4,3.75,3,5,4,3.6,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+info!$P$3)","v":7},31.1,4.4428571428571431,15,"دون المتوسط"]
[{"$f":"IF(info!A40=\"\",\"\",info!A40)","v":25},{"$f":"IF($A34=\"\",\"\",info!B40)","v":25},{"$f":"IF($A34=\"\",\"\",info!C40)","v":"سكينة"},{"$f":"IF($A34=\"\",\"\",info!G40)","v":"2008-06-07"},{"$f":"IF($A34=\"\",\"\",info!D40)","v":"أ"},{"$f":"IF($A34=\"\",\"\",info!F40)","v":0},3.5,4.5,4,5,5,5,4,6,5,4.5,5.5,5,5,6,5.5,4.9000000000000004,null,null,"",5.75,3,4.375,5.25,4.59375,6.5,4.66,5.58,7.25,6,6.625,6,4.5,5.25,4,4.375,4.1875,5,6.5,5.75,1,{"$f":"IF($A34=\"\",\"\",6+AT34+info!$P$3)","v":7},32.698750000000004,4.6712500000000006,13,"دون المتوسط"]
[{"$f":"IF(info!A41=\"\",\"\",info!A41)","v":""},{"$f":"IF($A35=\"\",\"\",info!B41)","v":""},{"$f":"IF($A35=\"\",\"\",info!C41)","v":""},{"$f":"IF($A35=\"\",\"\",info!G41)","v":""},{"$f":"IF($A35=\"\",\"\",info!D41)","v":""},{"$f":"IF($A35=\"\",\"\",info!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,{"$f":"IF($A35=\"\",\"\",6+AT35+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A42=\"\",\"\",info!A42)","v":""},{"$f":"IF($A36=\"\",\"\",info!B42)","v":""},{"$f":"IF($A36=\"\",\"\",info!C42)","v":""},{"$f":"IF($A36=\"\",\"\",info!G42)","v":""},{"$f":"IF($A36=\"\",\"\",info!D42)","v":""},{"$f":"IF($A36=\"\",\"\",info!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,{"$f":"IF($A36=\"\",\"\",6+AT36+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A43=\"\",\"\",info!A43)","v":""},{"$f":"IF($A37=\"\",\"\",info!B43)","v":""},{"$f":"IF($A37=\"\",\"\",info!C43)","v":""},{"$f":"IF($A37=\"\",\"\",info!G43)","v":""},{"$f":"IF($A37=\"\",\"\",info!D43)","v":""},{"$f":"IF($A37=\"\",\"\",info!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,{"$f":"IF($A37=\"\",\"\",6+AT37+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A44=\"\",\"\",info!A44)","v":""},{"$f":"IF($A38=\"\",\"\",info!B44)","v":""},{"$f":"IF($A38=\"\",\"\",info!C44)","v":""},{"$f":"IF($A38=\"\",\"\",info!G44)","v":""},{"$f":"IF($A38=\"\",\"\",info!D44)","v":""},{"$f":"IF($A38=\"\",\"\",info!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,{"$f":"IF($A38=\"\",\"\",6+AT38+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A45=\"\",\"\",info!A45)","v":""},{"$f":"IF($A39=\"\",\"\",info!B45)","v":""},{"$f":"IF($A39=\"\",\"\",info!C45)","v":""},{"$f":"IF($A39=\"\",\"\",info!G45)","v":""},{"$f":"IF($A39=\"\",\"\",info!D45)","v":""},{"$f":"IF($A39=\"\",\"\",info!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,{"$f":"IF($A39=\"\",\"\",6+AT39+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A46=\"\",\"\",info!A46)","v":""},{"$f":"IF($A40=\"\",\"\",info!B46)","v":""},{"$f":"IF($A40=\"\",\"\",info!C46)","v":""},{"$f":"IF($A40=\"\",\"\",info!G46)","v":""},{"$f":"IF($A40=\"\",\"\",info!D46)","v":""},{"$f":"IF($A40=\"\",\"\",info!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,{"$f":"IF($A40=\"\",\"\",6+AT40+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A47=\"\",\"\",info!A47)","v":""},{"$f":"IF($A41=\"\",\"\",info!B47)","v":""},{"$f":"IF($A41=\"\",\"\",info!C47)","v":""},{"$f":"IF($A41=\"\",\"\",info!G47)","v":""},{"$f":"IF($A41=\"\",\"\",info!D47)","v":""},{"$f":"IF($A41=\"\",\"\",info!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,{"$f":"IF($A41=\"\",\"\",6+AT41+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A48=\"\",\"\",info!A48)","v":""},{"$f":"IF($A42=\"\",\"\",info!B48)","v":""},{"$f":"IF($A42=\"\",\"\",info!C48)","v":""},{"$f":"IF($A42=\"\",\"\",info!G48)","v":""},{"$f":"IF($A42=\"\",\"\",info!D48)","v":""},{"$f":"IF($A42=\"\",\"\",info!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,{"$f":"IF($A42=\"\",\"\",6+AT42+info!$P$3)","v":""},{"$f":"IF($A42=\"\",\"\",SUM(V42,AD42,AG42,AJ42,AM42,AS42,Y42))","v":""},"",{"$f":"IF($A42=\"\",\"\",RANK(AW42,$AW$10:$AW$59))","v":""},""]
[{"$f":"IF(info!A49=\"\",\"\",info!A49)","v":""},{"$f":"IF($A43=\"\",\"\",info!B49)","v":""},{"$f":"IF($A43=\"\",\"\",info!C49)","v":""},{"$f":"IF($A43=\"\",\"\",info!G49)","v":""},{"$f":"IF($A43=\"\",\"\",info!D49)","v":""},{"$f":"IF($A43=\"\",\"\",info!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,{"$f":"IF($A43=\"\",\"\",6+AT43+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A50=\"\",\"\",info!A50)","v":""},{"$f":"IF($A44=\"\",\"\",info!B50)","v":""},{"$f":"IF($A44=\"\",\"\",info!C50)","v":""},{"$f":"IF($A44=\"\",\"\",info!G50)","v":""},{"$f":"IF($A44=\"\",\"\",info!D50)","v":""},{"$f":"IF($A44=\"\",\"\",info!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,{"$f":"IF($A44=\"\",\"\",6+AT44+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A51=\"\",\"\",info!A51)","v":""},{"$f":"IF($A45=\"\",\"\",info!B51)","v":""},{"$f":"IF($A45=\"\",\"\",info!C51)","v":""},{"$f":"IF($A45=\"\",\"\",info!G51)","v":""},{"$f":"IF($A45=\"\",\"\",info!D51)","v":""},{"$f":"IF($A45=\"\",\"\",info!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,{"$f":"IF($A45=\"\",\"\",6+AT45+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A52=\"\",\"\",info!A52)","v":""},{"$f":"IF($A46=\"\",\"\",info!B52)","v":""},{"$f":"IF($A46=\"\",\"\",info!C52)","v":""},{"$f":"IF($A46=\"\",\"\",info!G52)","v":""},{"$f":"IF($A46=\"\",\"\",info!D52)","v":""},{"$f":"IF($A46=\"\",\"\",info!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,{"$f":"IF($A46=\"\",\"\",6+AT46+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A53=\"\",\"\",info!A53)","v":""},{"$f":"IF($A47=\"\",\"\",info!B53)","v":""},{"$f":"IF($A47=\"\",\"\",info!C53)","v":""},{"$f":"IF($A47=\"\",\"\",info!G53)","v":""},{"$f":"IF($A47=\"\",\"\",info!D53)","v":""},{"$f":"IF($A47=\"\",\"\",info!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,{"$f":"IF($A47=\"\",\"\",6+AT47+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A54=\"\",\"\",info!A54)","v":""},{"$f":"IF($A48=\"\",\"\",info!B54)","v":""},{"$f":"IF($A48=\"\",\"\",info!C54)","v":""},{"$f":"IF($A48=\"\",\"\",info!G54)","v":""},{"$f":"IF($A48=\"\",\"\",info!D54)","v":""},{"$f":"IF($A48=\"\",\"\",info!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,{"$f":"IF($A48=\"\",\"\",6+AT48+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A55=\"\",\"\",info!A55)","v":""},{"$f":"IF($A49=\"\",\"\",info!B55)","v":""},{"$f":"IF($A49=\"\",\"\",info!C55)","v":""},{"$f":"IF($A49=\"\",\"\",info!G55)","v":""},{"$f":"IF($A49=\"\",\"\",info!D55)","v":""},{"$f":"IF($A49=\"\",\"\",info!F55)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,{"$f":"IF(Z49=\"\",\"\",IF(AA49=\"\",\"\",AVERAGE(Z49:AA49)))","v":""},null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A49=\"\",\"\",6+AT49+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A56=\"\",\"\",info!A56)","v":""},{"$f":"IF($A50=\"\",\"\",info!B56)","v":""},{"$f":"IF($A50=\"\",\"\",info!C56)","v":""},{"$f":"IF($A50=\"\",\"\",info!G56)","v":""},{"$f":"IF($A50=\"\",\"\",info!D56)","v":""},{"$f":"IF($A50=\"\",\"\",info!F56)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,{"$f":"IF(Z50=\"\",\"\",IF(AA50=\"\",\"\",AVERAGE(Z50:AA50)))","v":""},null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A50=\"\",\"\",6+AT50+info!$P$3)","v":""},"",{"$f":"IF($A50=\"\",\"\",AV50/AU50)","v":""},"",{"$f":"IF($A50=\"\",\"\",IF(AW50>=8,\" تنويه \",IF(AW50>=7,\"تشجيع \",IF(AW50>=6,\"لوحة الشرف\",IF(AW50>=5,\"متوسط\",IF(AW50>=4,\"دون المتوسط\",IF(AW50>=3,\"ناقص\",IF(AW50>=2,\"تنبيه\",IF(AW50>=1,\"إنذار\",\"توبيخ\")))))))))","v":""}]
[{"$f":"IF(info!A57=\"\",\"\",info!A57)","v":""},{"$f":"IF($A51=\"\",\"\",info!B57)","v":""},{"$f":"IF($A51=\"\",\"\",info!C57)","v":""},{"$f":"IF($A51=\"\",\"\",info!G57)","v":""},{"$f":"IF($A51=\"\",\"\",info!D57)","v":""},{"$f":"IF($A51=\"\",\"\",info!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,{"$f":"IF($A51=\"\",\"\",6+AT51+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A58=\"\",\"\",info!A58)","v":""},{"$f":"IF($A52=\"\",\"\",info!B58)","v":""},{"$f":"IF($A52=\"\",\"\",info!C58)","v":""},{"$f":"IF($A52=\"\",\"\",info!G58)","v":""},{"$f":"IF($A52=\"\",\"\",info!D58)","v":""},{"$f":"IF($A52=\"\",\"\",info!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,{"$f":"IF($A52=\"\",\"\",6+AT52+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A59=\"\",\"\",info!A59)","v":""},{"$f":"IF($A53=\"\",\"\",info!B59)","v":""},{"$f":"IF($A53=\"\",\"\",info!C59)","v":""},{"$f":"IF($A53=\"\",\"\",info!G59)","v":""},{"$f":"IF($A53=\"\",\"\",info!D59)","v":""},{"$f":"IF($A53=\"\",\"\",info!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,{"$f":"IF($A53=\"\",\"\",6+AT53+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A60=\"\",\"\",info!A60)","v":""},{"$f":"IF($A54=\"\",\"\",info!B60)","v":""},{"$f":"IF($A54=\"\",\"\",info!C60)","v":""},{"$f":"IF($A54=\"\",\"\",info!G60)","v":""},{"$f":"IF($A54=\"\",\"\",info!D60)","v":""},{"$f":"IF($A54=\"\",\"\",info!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,{"$f":"IF($A54=\"\",\"\",6+AT54+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A61=\"\",\"\",info!A61)","v":""},{"$f":"IF($A55=\"\",\"\",info!B61)","v":""},{"$f":"IF($A55=\"\",\"\",info!C61)","v":""},{"$f":"IF($A55=\"\",\"\",info!G61)","v":""},{"$f":"IF($A55=\"\",\"\",info!D61)","v":""},{"$f":"IF($A55=\"\",\"\",info!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,{"$f":"IF($A55=\"\",\"\",6+AT55+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A62=\"\",\"\",info!A62)","v":""},{"$f":"IF($A56=\"\",\"\",info!B62)","v":""},{"$f":"IF($A56=\"\",\"\",info!C62)","v":""},{"$f":"IF($A56=\"\",\"\",info!G62)","v":""},{"$f":"IF($A56=\"\",\"\",info!D62)","v":""},{"$f":"IF($A56=\"\",\"\",info!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,{"$f":"IF($A56=\"\",\"\",6+AT56+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A63=\"\",\"\",info!A63)","v":""},{"$f":"IF($A57=\"\",\"\",info!B63)","v":""},{"$f":"IF($A57=\"\",\"\",info!C63)","v":""},{"$f":"IF($A57=\"\",\"\",info!G63)","v":""},{"$f":"IF($A57=\"\",\"\",info!D63)","v":""},{"$f":"IF($A57=\"\",\"\",info!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,{"$f":"IF($A57=\"\",\"\",6+AT57+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A64=\"\",\"\",info!A64)","v":""},{"$f":"IF($A58=\"\",\"\",info!B64)","v":""},{"$f":"IF($A58=\"\",\"\",info!C64)","v":""},{"$f":"IF($A58=\"\",\"\",info!G64)","v":""},{"$f":"IF($A58=\"\",\"\",info!D64)","v":""},{"$f":"IF($A58=\"\",\"\",info!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,{"$f":"IF($A58=\"\",\"\",6+AT58+info!$P$3)","v":""},"","","",""]
[{"$f":"IF(info!A65=\"\",\"\",info!A65)","v":""},{"$f":"IF($A59=\"\",\"\",info!B65)","v":""},{"$f":"IF($A59=\"\",\"\",info!C65)","v":""},{"$f":"IF($A59=\"\",\"\",info!G65)","v":""},{"$f":"IF($A59=\"\",\"\",info!D65)","v":""},{"$f":"IF($A59=\"\",\"\",info!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,{"$f":"IF($A59=\"\",\"\",6+AT59+info!$P$3)","v":""},"","","",""]

{"sheet":"bulletin_sem1","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,10,1,12],[26,0,27,2],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[16,0,17,2],[4,0,4,5],[5,0,5,5],[8,1,9,13],[11,8,11,12],[12,8,12,12],[11,2,11,7],[6,13,6,14],[12,2,12,7],[14,1,14,13],[6,10,6,12],[17,6,17,7],[27,6,27,9],[18,3,18,5],[18,0,23,2],[24,0,24,2],[25,0,25,2],[1,13,1,14],[29,6,29,9],[37,3,37,5],[37,6,37,7],[37,8,37,9],[37,12,38,14],[38,3,38,5],[37,0,38,2],[35,3,35,5],[28,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[29,3,29,5],[31,3,31,5],[33,3,33,5],[39,6,39,7],[16,3,17,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[44,0,44,3],[16,12,17,14],[18,12,23,14],[24,12,25,14],[26,12,30,14],[31,12,32,14],[33,12,34,14],[35,12,36,14],[39,12,40,14],[42,11,42,14],[43,11,44,14],[16,6,16,11],[42,7,42,9],[43,7,44,9],[42,4,42,5],[43,4,43,5],[44,4,44,5],[18,6,18,7],[18,8,18,9],[2,10,2,12],[2,13,2,14],[0,10,0,12],[3,10,3,12],[35,6,35,7],[35,8,35,9],[33,8,33,9],[24,6,24,7],[24,8,24,9],[0,13,0,14],[19,6,19,7],[19,8,19,9],[20,6,20,7],[17,8,17,9],[3,13,3,14],[4,10,4,12],[4,13,4,14],[5,10,5,12],[33,6,33,7],[5,13,5,14],[20,8,20,9],[21,6,21,7],[26,6,26,9],[28,6,28,9],[42,0,42,3],[43,0,43,3],[21,8,21,9],[22,6,22,7],[22,8,22,9],[39,3,39,5],[25,3,25,5],[30,3,30,5],[32,3,32,5],[34,3,34,5],[36,3,36,5],[35,0,36,2],[39,0,39,2],[31,6,31,7],[31,8,31,9],[40,0,40,2],[22,3,22,5],[23,3,23,5],[24,3,24,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[39,8,39,9],[40,3,40,5]]}
[{"$f":"info!$A$1","v":"المملكة المغربية"},null,null,null,null,null,null,null,null,null,"الموسم الدراسي",null,null,{"$f":"IF($N$7=\"\",\"\",info!$M$1)","v":"2018-2017"}]
[{"$f":"info!$A$2","v":"وزارة التربية الوطنية و التكوين المهني"},null,null,null,null,null,null,null,null,null,"الاسم و النسب",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,3,0))","v":"رضوان"}]
[{"$f":"info!$A$3","v":"الأكاديمية الجهوية للتربية والتكوين"},null,null,null,null,null,null,null,null,null,"الرقم الوطني",null,null,7]
[{"$f":"info!$A$4","v":"جهة دكالة عبدة "},null,null,null,null,null,null,null,null,null,"رقم التسجيل",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,6,0))","v":0}]
[{"$f":"info!$A$5","v":"نيابة المديرية"},null,null,null,null,null,null,null,null,null,"رقم ت في القسم",null,null,1]
[{"$f":"info!$A$6","v":"المدرسة"},null,null,null,null,null,null,null,null,null,"القسم",null,null,{"$f":"IF($N$7=\"\",\"\",info!$M$3)","v":"الأول"}]
[null,null,null,null,null,null,null,null,null,null,"عدد التلاميذ",null,null,{"$f":"IF(info!$O$12=0,\"\",info!$O$12)","v":25}]
[]
[null,"بطاقة المراقبة المستمرة"]
[]
[]
[null,null,"مدرسة",null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",info!A6)","v":"المدرسة"}]
[null,null,"الاسم والنسب",null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,7,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,10,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,13,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,16,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,19,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,23,0)=\"\",\"\",VLOOKUP($N$5,base1,23,0)))","v":""},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base1,24,0)=\"\",\"\",VLOOKUP($N$5,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(AND(L26>=2,L26<=3),\"دون المستوى\",IF(AND(L26>3,L26<5),\"متوسط\",IF(AND(L26>=5,L26<7),\"لابأس به\",IF(AND(L26>=7,L26<8),\"مستحسن\",IF(AND(L26>=8,L26<=10),\"ممتاز\"))))))))","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($N$5,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($N$5,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($N$5,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($N$5,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($N$5,base1,31,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,34,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,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($N$5,base1,37,0))","v":3},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,38,0))","v":3.5},null,null,{"$f":"IF(OR($N$7=\"\",G36=\"\",I36=\"\"),\"\",AVERAGE(D36:I36))","v":3.25},{"$f":"IF($N$7=\"\",\"\",IF(L37<2,\"ضعيف\",IF(AND(L37>=2,L37<=3),\"دون المستوى\",IF(AND(L37>3,L37<5),\"متوسط\",IF(AND(L37>=5,L37<7),\"لابأس به\",IF(AND(L37>=7,L37<8),\"مستحسن\",IF(AND(L37>=8,L37<=10),\"ممتاز\")))))))","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($N$5,base1,40,0)=\"\",\"\",VLOOKUP($N$5,base1,40,0)))","v":4},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base1,41,0)=\"\",\"\",VLOOKUP($N$5,base1,41,0)))","v":3.5},null,null,{"$f":"IF(OR($N$7=\"\",G38=\"\",I38=\"\"),\"\",AVERAGE(D38:I38))","v":3.75},{"$f":"IF($N$7=\"\",\"\",IF(L39<2,\"ضعيف\",IF(AND(L39>=2,L39<=3),\"دون المستوى\",IF(AND(L39>3,L39<5),\"متوسط\",IF(AND(L39>=5,L39<7),\"لابأس به\",IF(AND(L39>=7,L39<8),\"مستحسن\",IF(AND(L39>=8,L39<=10),\"ممتاز\")))))))","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($N$5,base1,43,0)=\"\",\"\",VLOOKUP($N$5,base1,43,0)))","v":5.5},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base1,44,0)=\"\",\"\",VLOOKUP($N$5,base1,44,0)))","v":6.5},null,null,{"$f":"IF(OR($N$7=\"\",G40=\"\",I40=\"\"),\"\",AVERAGE(D40:I40))","v":6},{"$f":"IF($N$7=\"\",\"\",IF(L41=\"\",\"معفى من التربية البدنية\",IF(L41<2,\"ضعيف\",IF(AND(L41>=2,L41<=3),\"دون المستوى\",IF(AND(L41>3,L41<5),\"متوسط\",IF(AND(L41>=5,L41<7),\"لابأس به\",IF(AND(L41>=7,L41<8),\"مستحسن\",IF(AND(L41>=8,L41<=10),\"ممتاز\"))))))))","v":"لابأس به"}]
["البدنية",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L40)","v":6}]
[]
["مجموع معدل الوحدات",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,48,0))","v":25.824999999999999},null,null,"الميزة",null,null,null,"خاتم و توقيع رئيس المؤسسة"]
["المعدل الدوري",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,49,0))","v":3.6892857142857141},null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,51,0))","v":"ناقص"}]
["الرتبة",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,50,0))","v":23}]

{"sheet":"sem2","index":3,"n_rows":59,"n_cols":59,"rows_kept":59,"cut":false,"hidden":false,"merged":[[6,52,8,52],[12,54,12,56],[6,50,8,50],[9,54,9,56],[17,54,17,56],[16,54,16,56],[10,54,10,56],[11,54,11,56],[13,54,13,56],[6,57,8,58],[6,54,6,56],[7,54,7,56],[7,30,7,31],[7,33,7,34],[7,42,7,43],[6,33,6,35],[6,53,8,53],[6,45,8,45],[6,46,8,46],[6,47,8,47],[6,48,8,48],[6,51,8,51],[6,30,6,32],[6,49,8,49],[6,39,6,41],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,5,8,5],[7,6,7,8],[7,9,7,11],[7,12,7,14],[6,36,6,38],[6,42,6,44],[7,15,7,17],[7,18,7,20],[7,22,7,23],[7,36,7,37],[7,39,7,40],[4,29,4,31],[4,32,4,34],[5,2,5,5],[6,6,6,21],[6,22,6,24],[6,25,6,29],[18,54,18,55],[7,4,8,4],[0,2,0,5],[0,29,0,31],[0,32,0,34],[1,2,1,5],[1,29,1,31],[1,32,1,34],[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]]}
[null,null,{"$f":"info!$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":"info!M1","v":"2018-2017"}]
[null,null,{"$f":"info!$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":"info!$M$2","v":"هشام "}]
[null,null,{"$f":"info!$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":"info!$M$3","v":"الأول"}]
[null,null,{"$f":"info!$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":"info!$M$4","v":"لايهم"}]
[null,null,{"$f":"info!$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":"info!$M$5","v":1}]
[null,null,{"$f":"info!$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,"معامل ت ب","مج المعاملات","مج المعدلات","معدل الدورة","الرتبة","الميزة","معدل الأسدس1","المعدل العام السنوي","العتبة","عدد الناجحين",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,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","الوحدة",null,null,null,null,null,null,null,null,null,"إناث","ذكور","المجموع"]
[{"$f":"IF(info!A16=\"\",\"\",info!A16)","v":1},{"$f":"IF($A10=\"\",\"\",info!B16)","v":1},{"$f":"IF($A10=\"\",\"\",info!C16)","v":"رضوان"},{"$f":"IF($A10=\"\",\"\",info!G16)","v":"2005-06-23"},{"$f":"IF($A10=\"\",\"\",info!D16)","v":"ذ"},{"$f":"IF($A10=\"\",\"\",info!F16)","v":0},4,4.5,{"$f":"IF(OR(G10=\"\",H10=\"\"),\"\",AVERAGE(G10:H10))","v":4.25},5,4.5,{"$f":"IF(OR(J10=\"\",K10=\"\"),\"\",AVERAGE(J10:K10))","v":4.75},5,4.5,{"$f":"IF(OR(M10=\"\",N10=\"\"),\"\",AVERAGE(M10:N10))","v":4.75},3,4.5,{"$f":"IF(OR(P10=\"\",Q10=\"\"),\"\",AVERAGE(P10:Q10))","v":3.75},5,4.5,{"$f":"IF(OR(S10=\"\",T10=\"\"),\"\",AVERAGE(S10:T10))","v":4.75},{"$f":"IF(OR(U10=\"\",R10=\"\",O10=\"\",L10=\"\",I10=\"\"),\"\",AVERAGE(U10,R10,O10,L10,I10))","v":4.45},null,null,{"$f":"IF(OR(W10=\"\",X10=\"\"),\"\",AVERAGE(W10:X10))","v":""},4,5,{"$f":"IF(Z10=\"\",\"\",IF(AA10=\"\",\"\",AVERAGE(Z10:AA10)))","v":4.5},5.5,{"$f":"IF(OR(Z10=\"\",AA10=\"\",AB10=\"\",AC10=\"\"),\"\",AVERAGE(Z10:AC10))","v":4.75},3,5.5,{"$f":"IF(OR(AE10=\"\",AF10=\"\"),\"\",AVERAGE(AE10:AF10))","v":4.25},4.5,6.5,{"$f":"IF(OR(AH10=\"\",AI10=\"\"),\"\",AVERAGE(AH10:AI10))","v":5.5},5.5,6.5,{"$f":"IF(OR(AK10=\"\",AL10=\"\"),\"\",AVERAGE(AK10:AL10))","v":6},3,5.5,{"$f":"IF(OR(AN10=\"\",AO10=\"\"),\"\",AVERAGE(AN10:AO10))","v":4.25},6,8,{"$f":"IF(OR(AQ10=\"\",AR10=\"\"),\"\",AVERAGE(AQ10:AR10))","v":7},1,{"$f":"IF($A10=\"\",\"\",6+AT10+info!$P$3)","v":7},{"$f":"IF($A10=\"\",\"\",SUM(V10,AD10,AG10,AJ10,AM10,AS10,Y10))","v":31.95},{"$f":"IF($A10=\"\",\"\",AV10/AU10)","v":4.5642857142857141},{"$f":"IF($A10=\"\",\"\",RANK(AW10,$AW$10:$AW$59))","v":14},{"$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($A10=\"\",\"\",'sem1'!AW10)","v":3.6892857142857141},{"$f":"IF($A10=\"\",\"\",AVERAGE(AZ10,AW10))","v":4.1267857142857141},5,{"$f":"SUMPRODUCT(($BA$10:$BA$509>=$BB$10)*($E$10:$E$509=\"أ\"))","v":1},{"$f":"SUMPRODUCT(($BA$10:$BA$509>=$BB$10)*($E$10:$E$509=\"ذ\"))","v":8},{"$f":"SUM(BC10+BD10)","v":9},"] 3 - 0 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=0)*($BA$10:$BA$509<3)*($BA$10:$BA$509<>\"\"))","v":2}]
[{"$f":"IF(info!A17=\"\",\"\",info!A17)","v":2},{"$f":"IF($A11=\"\",\"\",info!B17)","v":2},{"$f":"IF($A11=\"\",\"\",info!C17)","v":"محمد"},{"$f":"IF($A11=\"\",\"\",info!G17)","v":"2008-03-14"},{"$f":"IF($A11=\"\",\"\",info!D17)","v":"ذ"},{"$f":"IF($A11=\"\",\"\",info!F17)","v":0},5,5.5,{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",AVERAGE(G11:H11))","v":5.25},6,6.5,{"$f":"IF(OR(J11=\"\",K11=\"\"),\"\",AVERAGE(J11:K11))","v":6.25},5,6,{"$f":"IF(OR(M11=\"\",N11=\"\"),\"\",AVERAGE(M11:N11))","v":5.5},5.5,6.5,{"$f":"IF(OR(P11=\"\",Q11=\"\"),\"\",AVERAGE(P11:Q11))","v":6},6,6.75,{"$f":"IF(OR(S11=\"\",T11=\"\"),\"\",AVERAGE(S11:T11))","v":6.375},{"$f":"IF(OR(U11=\"\",R11=\"\",O11=\"\",L11=\"\",I11=\"\"),\"\",AVERAGE(U11,R11,O11,L11,I11))","v":5.875},null,null,{"$f":"IF(OR(W11=\"\",X11=\"\"),\"\",AVERAGE(W11:X11))","v":""},5,6,{"$f":"IF(Z11=\"\",\"\",IF(AA11=\"\",\"\",AVERAGE(Z11:AA11)))","v":5.5},6.5,{"$f":"IF(OR(Z11=\"\",AA11=\"\",AB11=\"\",AC11=\"\"),\"\",AVERAGE(Z11:AC11))","v":5.75},3,4.75,{"$f":"IF(OR(AE11=\"\",AF11=\"\"),\"\",AVERAGE(AE11:AF11))","v":3.875},5.75,3,{"$f":"IF(OR(AH11=\"\",AI11=\"\"),\"\",AVERAGE(AH11:AI11))","v":4.375},5.5,5,{"$f":"IF(OR(AK11=\"\",AL11=\"\"),\"\",AVERAGE(AK11:AL11))","v":5.25},5.5,4.75,{"$f":"IF(OR(AN11=\"\",AO11=\"\"),\"\",AVERAGE(AN11:AO11))","v":5.125},6,6.5,{"$f":"IF(OR(AQ11=\"\",AR11=\"\"),\"\",AVERAGE(AQ11:AR11))","v":6.25},1,{"$f":"IF($A11=\"\",\"\",6+AT11+info!$P$3)","v":7},31.375,{"$f":"IF($A11=\"\",\"\",AV11/AU11)","v":4.4821428571428568},16,{"$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($A11=\"\",\"\",'sem1'!AW11)","v":5.6860714285714291},{"$f":"IF($A11=\"\",\"\",AVERAGE(AZ11,AW11))","v":5.0841071428571425},null,"نسبة النجاح",null,null,"] 4 - 3 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=3)*($BA$10:$BA$509<4))","v":5}]
[{"$f":"IF(info!A18=\"\",\"\",info!A18)","v":3},{"$f":"IF($A12=\"\",\"\",info!B18)","v":3},{"$f":"IF($A12=\"\",\"\",info!C18)","v":"سلمى"},{"$f":"IF($A12=\"\",\"\",info!G18)","v":"2007-10-07"},{"$f":"IF($A12=\"\",\"\",info!D18)","v":"أ"},{"$f":"IF($A12=\"\",\"\",info!F18)","v":0},4,4.5,4.25,6,4,5,5.5,4,4.75,4,4,4,6,4,5,4.5999999999999996,null,null,"",5,5.5,5.25,5.75,5.375,3,5.75,4.375,5.75,3.5,4.625,3,6.5,4.75,4,5.75,4.875,6,6.5,6.25,1,{"$f":"IF($A12=\"\",\"\",6+AT12+info!$P$3)","v":7},29.975000000000001,4.2821428571428575,17,"دون المتوسط",{"$f":"IF($A12=\"\",\"\",'sem1'!AW12)","v":4.8328571428571427},4.5575000000000001,null,{"$f":"BE10*100/BE19","v":36},null,null,"] 5 - 4 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=4)*($BA$10:$BA$509<5))","v":9}]
[{"$f":"IF(info!A19=\"\",\"\",info!A19)","v":4},{"$f":"IF($A13=\"\",\"\",info!B19)","v":4},{"$f":"IF($A13=\"\",\"\",info!C19)","v":"شعيب"},{"$f":"IF($A13=\"\",\"\",info!G19)","v":"2008-12-06"},{"$f":"IF($A13=\"\",\"\",info!D19)","v":"ذ"},{"$f":"IF($A13=\"\",\"\",info!F19)","v":0},6,6.5,6.25,7.5,7,7.25,6,6,6,7,6.75,6.875,6,6.75,6.375,6.55,null,null,"",6.5,6,6.25,7.5,6.5625,8,9,8.5,7,8,7.5,9,9.25,9.125,7,9,8,6.5,6.75,6.625,1,{"$f":"IF($A13=\"\",\"\",6+AT13+info!$P$3)","v":7},44.862499999999997,6.4089285714285706,4,"لوحة الشرف",{"$f":"IF($A13=\"\",\"\",'sem1'!AW13)","v":6.4941071428571417},6.4515178571428562,null,"عدد الراسبين",null,null,"[5]",{"$f":"SUMPRODUCT(($BA$10:$BA$509=5))","v":0}]
[{"$f":"IF(info!A20=\"\",\"\",info!A20)","v":5},{"$f":"IF($A14=\"\",\"\",info!B20)","v":5},{"$f":"IF($A14=\"\",\"\",info!C20)","v":"ميلود"},{"$f":"IF($A14=\"\",\"\",info!G20)","v":"2008-07-10"},{"$f":"IF($A14=\"\",\"\",info!D20)","v":"ذ"},{"$f":"IF($A14=\"\",\"\",info!F20)","v":0},6,4.5,5.25,7,4,5.5,6,4,5,5.75,6,5.875,6,4,5,5.3250000000000002,null,null,"",4.5,4.5,4.5,5,4.625,3,3.5,3.25,5,4,4.5,6.25,2.75,4.5,5.75,3.5,4.625,6.5,7,6.75,1,{"$f":"IF($A14=\"\",\"\",6+AT14+info!$P$3)","v":7},28.95,4.1357142857142852,18,"دون المتوسط",{"$f":"IF($A14=\"\",\"\",'sem1'!AW14)","v":5.1837500000000007},4.659732142857143,null,"حسب العتبة",null,null,"] 6 - 5 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=5)*($BA$10:$BA$509<6))","v":3}]
[{"$f":"IF(info!A21=\"\",\"\",info!A21)","v":6},{"$f":"IF($A15=\"\",\"\",info!B21)","v":6},{"$f":"IF($A15=\"\",\"\",info!C21)","v":"فاطمة"},{"$f":"IF($A15=\"\",\"\",info!G21)","v":"2008-01-08"},{"$f":"IF($A15=\"\",\"\",info!D21)","v":"أ"},{"$f":"IF($A15=\"\",\"\",info!F21)","v":0},3.5,2,2.75,2,3,2.5,2,3,2.5,3,2,2.5,2,3,2.5,2.5499999999999998,null,null,"",2,2,2,4,2.5,2,1,1.5,3,1,2,0.25,1.75,1,3,1,2,5.5,4.5,5,1,{"$f":"IF($A15=\"\",\"\",6+AT15+info!$P$3)","v":7},14.55,2.0785714285714287,24,"تنبيه",{"$f":"IF($A15=\"\",\"\",'sem1'!AW15)","v":3.6378571428571429},2.8582142857142858,null,"إناث","ذكور","المجموع","] 7 - 6 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=6)*($BA$10:$BA$509<7))","v":6}]
[{"$f":"IF(info!A22=\"\",\"\",info!A22)","v":7},{"$f":"IF($A16=\"\",\"\",info!B22)","v":7},{"$f":"IF($A16=\"\",\"\",info!C22)","v":"مصطفى"},{"$f":"IF($A16=\"\",\"\",info!G22)","v":"2009-01-02"},{"$f":"IF($A16=\"\",\"\",info!D22)","v":"ذ"},{"$f":"IF($A16=\"\",\"\",info!F22)","v":0},4,4.5,4.25,5,5,5,4,4,4,3,5.5,4.25,4,5,4.5,4.4000000000000004,null,null,"",4,4,4,4.5,4.125,6,8,7,5.5,6.5,6,5.25,6.5,5.875,3,8,5.5,6,7,6.5,1,{"$f":"IF($A16=\"\",\"\",6+AT16+info!$P$3)","v":7},33.9,4.8428571428571425,10,"دون المتوسط",{"$f":"IF($A16=\"\",\"\",'sem1'!AW16)","v":4.3328571428571427},4.5878571428571426,null,{"$f":"SUMPRODUCT(($BA$10:$BA$509<$BB$10)*($E$10:$E$509=\"أ\"))","v":10},{"$f":"SUMPRODUCT(($BA$10:$BA$509<$BB$10)*($E$10:$E$509=\"ذ\"))","v":6},{"$f":"SUM(BC16+BD16)","v":16},"] 8 - 7 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=7)*($BA$10:$BA$509<8))","v":0}]
[{"$f":"IF(info!A23=\"\",\"\",info!A23)","v":8},{"$f":"IF($A17=\"\",\"\",info!B23)","v":8},{"$f":"IF($A17=\"\",\"\",info!C23)","v":"فريد"},{"$f":"IF($A17=\"\",\"\",info!G23)","v":"2008-07-27"},{"$f":"IF($A17=\"\",\"\",info!D23)","v":"ذ"},{"$f":"IF($A17=\"\",\"\",info!F23)","v":0},6.75,6.5,6.625,7,8,7.5,6,7,6.5,7.5,7,7.25,7,7,7,6.9749999999999996,null,null,"",6.5,6.75,6.625,7,6.71875,8,8.75,8.375,8,7.5,7.75,10,9.3800000000000008,9.6900000000000013,7.5,8.75,8.125,6.5,7.5,7,1,{"$f":"IF($A17=\"\",\"\",6+AT17+info!$P$3)","v":7},46.508750000000006,6.6441071428571439,2,"لوحة الشرف",{"$f":"IF($A17=\"\",\"\",'sem1'!AW17)","v":6.2010714285714288},6.4225892857142863,null,"نسبة الرسوب",null,null,"] 9 - 8 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=8)*($BA$10:$BA$509<9))","v":0}]
[{"$f":"IF(info!A24=\"\",\"\",info!A24)","v":9},{"$f":"IF($A18=\"\",\"\",info!B24)","v":9},{"$f":"IF($A18=\"\",\"\",info!C24)","v":"كمال"},{"$f":"IF($A18=\"\",\"\",info!G24)","v":"2008-07-16"},{"$f":"IF($A18=\"\",\"\",info!D24)","v":"ذ"},{"$f":"IF($A18=\"\",\"\",info!F24)","v":0},6.5,7.5,7,7,7.5,7.25,6,8.5,7.25,6.75,8,7.375,6,7,6.5,7.0750000000000002,null,null,"",6.5,7.5,7,8,7.25,9.75,7.5,8.625,6.75,7.5,7.125,9,9.25,9.125,6.75,7.5,7.125,6,8,7,1,{"$f":"IF($A18=\"\",\"\",6+AT18+info!$P$3)","v":7},46.2,6.6000000000000005,3,"لوحة الشرف",{"$f":"IF($A18=\"\",\"\",'sem1'!AW18)","v":6.6400000000000006},6.620000000000001,null,{"$f":"BE16*100/BE19","v":64},null,null,"] 10 - 9 ]",{"$f":"SUMPRODUCT(($BA$10:$BA$509>=9)*($BA$10:$BA$509<10))","v":0}]
[{"$f":"IF(info!A25=\"\",\"\",info!A25)","v":10},{"$f":"IF($A19=\"\",\"\",info!B25)","v":10},{"$f":"IF($A19=\"\",\"\",info!C25)","v":"لبنى"},{"$f":"IF($A19=\"\",\"\",info!G25)","v":"2009-03-15"},{"$f":"IF($A19=\"\",\"\",info!D25)","v":"أ"},{"$f":"IF($A19=\"\",\"\",info!F25)","v":0},3.5,3,3.25,4,4,4,5,4,4.5,3,2,2.5,5,4,4.5,3.75,null,null,"",4,1,2.5,6.25,3.4375,4.75,2,3.375,4,1,2.5,4.5,2,3.25,3,2,2.5,6,4,5,1,{"$f":"IF($A19=\"\",\"\",6+AT19+info!$P$3)","v":7},21.3125,3.0446428571428572,20,"ناقص",{"$f":"IF($A19=\"\",\"\",'sem1'!AW19)","v":4.0285714285714285},3.5366071428571431,null,"المجموع",null,{"$f":"SUM(BE10,BE16)","v":25},"[10]",{"$f":"SUMPRODUCT(($BA$10:$BA$509=10))","v":0}]
[{"$f":"IF(info!A26=\"\",\"\",info!A26)","v":11},{"$f":"IF($A20=\"\",\"\",info!B26)","v":11},{"$f":"IF($A20=\"\",\"\",info!C26)","v":"أحمد"},{"$f":"IF($A20=\"\",\"\",info!G26)","v":"2008-07-13"},{"$f":"IF($A20=\"\",\"\",info!D26)","v":"ذ"},{"$f":"IF($A20=\"\",\"\",info!F26)","v":0},6.5,7,6.75,8,8.5,8.25,7,9,8,6.75,7.5,7.125,8,8.5,8.25,7.6749999999999998,null,null,"",6.5,7,6.75,7.25,6.875,6,6.5,6.25,7.25,5,6.125,7.75,9.25,8.5,6.75,6.5,6.625,7,7.5,7.25,1,{"$f":"IF($A20=\"\",\"\",6+AT20+info!$P$3)","v":7},42.674999999999997,6.0964285714285706,6,"لوحة الشرف",{"$f":"IF($A20=\"\",\"\",'sem1'!AW20)","v":5.99},6.043214285714285]
[{"$f":"IF(info!A27=\"\",\"\",info!A27)","v":12},{"$f":"IF($A21=\"\",\"\",info!B27)","v":12},{"$f":"IF($A21=\"\",\"\",info!C27)","v":"سلمان"},{"$f":"IF($A21=\"\",\"\",info!G27)","v":"2007-12-31"},{"$f":"IF($A21=\"\",\"\",info!D27)","v":"ذ"},{"$f":"IF($A21=\"\",\"\",info!F27)","v":0},7.25,8.5,7.875,8,8.5,8.25,7,9.5,8.25,8.5,8.5,8.5,8,9,8.5,8.2750000000000004,null,null,"",7,8,7.5,8.5,7.75,8,10,9,8.5,8.5,8.5,9.25,9.3800000000000008,9.3150000000000013,8.5,10,9.25,7,8,7.5,1,{"$f":"IF($A21=\"\",\"\",6+AT21+info!$P$3)","v":7},50.34,7.1914285714285722,1,"تشجيع ",{"$f":"IF($A21=\"\",\"\",'sem1'!AW21)","v":6.609285714285714},6.9003571428571426,null,null,null,null,"المجموع",{"$f":"SUM(BG10:BG19)","v":25}]
[{"$f":"IF(info!A28=\"\",\"\",info!A28)","v":13},{"$f":"IF($A22=\"\",\"\",info!B28)","v":13},{"$f":"IF($A22=\"\",\"\",info!C28)","v":"مروة"},{"$f":"IF($A22=\"\",\"\",info!G28)","v":"2008-04-07"},{"$f":"IF($A22=\"\",\"\",info!D28)","v":"أ"},{"$f":"IF($A22=\"\",\"\",info!F28)","v":0},3,4,3.5,6,4.5,5.25,4,5,4.5,4,4,4,5,5.5,5.25,4.5,null,null,"",4,4,4,5.5,4.375,3,8.5,5.75,6.5,6.5,6.5,5.25,4.13,4.6899999999999995,4,8.5,6.25,6.5,7,6.75,1,{"$f":"IF($A22=\"\",\"\",6+AT22+info!$P$3)","v":7},32.564999999999998,4.6521428571428567,13,"دون المتوسط",{"$f":"IF($A22=\"\",\"\",'sem1'!AW22)","v":4.2364285714285712},4.444285714285714]
[{"$f":"IF(info!A29=\"\",\"\",info!A29)","v":14},{"$f":"IF($A23=\"\",\"\",info!B29)","v":14},{"$f":"IF($A23=\"\",\"\",info!C29)","v":"خالد"},{"$f":"IF($A23=\"\",\"\",info!G29)","v":"2008-04-14"},{"$f":"IF($A23=\"\",\"\",info!D29)","v":"ذ"},{"$f":"IF($A23=\"\",\"\",info!F29)","v":0},7,7,7,6.5,7,6.75,6,7.5,6.75,7.5,7.25,7.375,6,7.5,6.75,6.9249999999999998,null,null,"",6.5,7,6.75,7,6.8125,5,5.5,5.25,8,7.5,7.75,9,8.5,8.75,7.5,5.5,6.5,6.75,8,7.375,1,{"$f":"IF($A23=\"\",\"\",6+AT23+info!$P$3)","v":7},42.862499999999997,6.1232142857142851,5,"لوحة الشرف",{"$f":"IF($A23=\"\",\"\",'sem1'!AW23)","v":5.6164285714285711},5.8698214285714281]
[{"$f":"IF(info!A30=\"\",\"\",info!A30)","v":15},{"$f":"IF($A24=\"\",\"\",info!B30)","v":15},{"$f":"IF($A24=\"\",\"\",info!C30)","v":"سفيان"},{"$f":"IF($A24=\"\",\"\",info!G30)","v":"2008-08-13"},{"$f":"IF($A24=\"\",\"\",info!D30)","v":"ذ"},{"$f":"IF($A24=\"\",\"\",info!F30)","v":0},4,4.5,4.25,6.5,3.5,5,6,6,6,4,4,4,6.5,6,6.25,5.0999999999999996,null,null,"",5,4,4.5,6.75,5.0625,5,6.75,5.875,6,6,6,3.75,5.13,4.4399999999999995,4,6.75,5.375,6.5,6,6.25,1,{"$f":"IF($A24=\"\",\"\",6+AT24+info!$P$3)","v":7},32.727499999999999,4.675357142857143,11,"دون المتوسط",{"$f":"IF($A24=\"\",\"\",'sem1'!AW24)","v":4.4221428571428572},4.5487500000000001]
[{"$f":"IF(info!A31=\"\",\"\",info!A31)","v":16},{"$f":"IF($A25=\"\",\"\",info!B31)","v":16},{"$f":"IF($A25=\"\",\"\",info!C31)","v":"لمياء"},{"$f":"IF($A25=\"\",\"\",info!G31)","v":"2009-01-24"},{"$f":"IF($A25=\"\",\"\",info!D31)","v":"أ"},{"$f":"IF($A25=\"\",\"\",info!F31)","v":0},4.5,6,5.25,6,7,6.5,6.5,6.5,6.5,4,6,5,6,6.5,6.25,5.9,null,null,"",4,6.5,5.25,6.5,5.5625,8.5,7.5,8,5.5,4,4.75,4.5,5.38,4.9399999999999995,4,7.5,5.75,6,6.5,6.25,1,{"$f":"IF($A25=\"\",\"\",6+AT25+info!$P$3)","v":7},35.402499999999996,5.0574999999999992,9,"متوسط",{"$f":"IF($A25=\"\",\"\",'sem1'!AW25)","v":4.9278571428571425},4.9926785714285709]
[{"$f":"IF(info!A32=\"\",\"\",info!A32)","v":17},{"$f":"IF($A26=\"\",\"\",info!B32)","v":17},{"$f":"IF($A26=\"\",\"\",info!C32)","v":"مريم"},{"$f":"IF($A26=\"\",\"\",info!G32)","v":"2008-12-31"},{"$f":"IF($A26=\"\",\"\",info!D32)","v":"أ"},{"$f":"IF($A26=\"\",\"\",info!F32)","v":0},6.5,6.25,6.375,8.5,8,8.25,6,8,7,6.75,6.5,6.625,6,8,7,7.05,null,null,"",6,6,6,7.5,6.375,5,9,7,6.5,6.5,6.5,8.25,8.1300000000000008,8.1900000000000013,6.75,9,7.875,6.5,7,6.75,1,{"$f":"IF($A26=\"\",\"\",6+AT26+info!$P$3)","v":7},41.865000000000002,5.9807142857142859,7,"متوسط",{"$f":"IF($A26=\"\",\"\",'sem1'!AW26)","v":6.4596428571428577},6.2201785714285718]
[{"$f":"IF(info!A33=\"\",\"\",info!A33)","v":18},{"$f":"IF($A27=\"\",\"\",info!B33)","v":18},{"$f":"IF($A27=\"\",\"\",info!C33)","v":"لقمان"},{"$f":"IF($A27=\"\",\"\",info!G33)","v":"2009-02-20"},{"$f":"IF($A27=\"\",\"\",info!D33)","v":"ذ"},{"$f":"IF($A27=\"\",\"\",info!F33)","v":0},3.5,3,3.25,4,3,3.5,4,3,3.5,3,3,3,4,3,3.5,3.35,null,null,"",4,3,3.5,4,3.625,2,2.5,2.25,5,1,3,2,1.75,1.875,3,2.5,2.75,6,5,5.5,1,{"$f":"IF($A27=\"\",\"\",6+AT27+info!$P$3)","v":7},19.600000000000001,2.8000000000000003,23,"تنبيه",{"$f":"IF($A27=\"\",\"\",'sem1'!AW27)","v":3.9007142857142858},3.3503571428571428]
[{"$f":"IF(info!A34=\"\",\"\",info!A34)","v":19},{"$f":"IF($A28=\"\",\"\",info!B34)","v":19},{"$f":"IF($A28=\"\",\"\",info!C34)","v":"محمد"},{"$f":"IF($A28=\"\",\"\",info!G34)","v":"2009-01-02"},{"$f":"IF($A28=\"\",\"\",info!D34)","v":"ذ"},{"$f":"IF($A28=\"\",\"\",info!F34)","v":0},2,1,1.5,1,2,1.5,1,2,1.5,2,1,1.5,1,2,1.5,1.5,null,null,"",3,1,2,3,2.25,2,1.5,1.75,2,1,1.5,1,1,1,2,1.5,1.75,5,4,4.5,1,{"$f":"IF($A28=\"\",\"\",6+AT28+info!$P$3)","v":7},12.5,1.7857142857142858,25,"إنذار",{"$f":"IF($A28=\"\",\"\",'sem1'!AW28)","v":3.1857142857142859},2.4857142857142858]
[{"$f":"IF(info!A35=\"\",\"\",info!A35)","v":20},{"$f":"IF($A29=\"\",\"\",info!B35)","v":20},{"$f":"IF($A29=\"\",\"\",info!C35)","v":"سليم"},{"$f":"IF($A29=\"\",\"\",info!G35)","v":"2008-09-22"},{"$f":"IF($A29=\"\",\"\",info!D35)","v":"ذ"},{"$f":"IF($A29=\"\",\"\",info!F35)","v":0},5,6,5.5,8,8,8,7,8,7.5,5.5,6.25,5.875,7,7.5,7.25,6.8250000000000002,null,null,"",4,6,5,5.5,5.125,10,8.5,9.25,7,7.25,7.125,4.75,8.1300000000000008,6.44,5.5,8.5,7,6.75,7,6.875,1,{"$f":"IF($A29=\"\",\"\",6+AT29+info!$P$3)","v":7},41.64,5.9485714285714284,8,"متوسط",{"$f":"IF($A29=\"\",\"\",'sem1'!AW29)","v":5.8360714285714286},5.892321428571428]
[{"$f":"IF(info!A36=\"\",\"\",info!A36)","v":21},{"$f":"IF($A30=\"\",\"\",info!B36)","v":21},{"$f":"IF($A30=\"\",\"\",info!C36)","v":"فتيحة"},{"$f":"IF($A30=\"\",\"\",info!G36)","v":"2008-04-12"},{"$f":"IF($A30=\"\",\"\",info!D36)","v":"أ"},{"$f":"IF($A30=\"\",\"\",info!F36)","v":0},3.5,4.5,4,6,4.5,5.25,6,6,6,4,4.5,4.25,5,6,5.5,5,null,null,"",4.5,4,4.25,6,4.6875,5,5.75,5.375,4,6,5,5.75,6.63,6.1899999999999995,4,5.75,4.875,6,6.75,6.375,1,{"$f":"IF($A30=\"\",\"\",6+AT30+info!$P$3)","v":7},32.627499999999998,4.6610714285714279,12,"دون المتوسط",{"$f":"IF($A30=\"\",\"\",'sem1'!AW30)","v":4.6421428571428569},4.6516071428571424]
[{"$f":"IF(info!A37=\"\",\"\",info!A37)","v":22},{"$f":"IF($A31=\"\",\"\",info!B37)","v":22},{"$f":"IF($A31=\"\",\"\",info!C37)","v":"رقية"},{"$f":"IF($A31=\"\",\"\",info!G37)","v":"2008-12-22"},{"$f":"IF($A31=\"\",\"\",info!D37)","v":"أ"},{"$f":"IF($A31=\"\",\"\",info!F37)","v":0},3.5,3,3.25,4,3,3.5,4,3,3.5,3.5,3.5,3.5,4,3,3.5,3.45,null,null,"",4,3,3.5,4,3.625,2,4.5,3.25,5,1,3,0.5,3.25,1.875,3.5,4.5,4,5.5,4,4.75,1,{"$f":"IF($A31=\"\",\"\",6+AT31+info!$P$3)","v":7},19.95,2.85,22,"تنبيه",{"$f":"IF($A31=\"\",\"\",'sem1'!AW31)","v":3.8446428571428575},3.347321428571429]
[{"$f":"IF(info!A38=\"\",\"\",info!A38)","v":23},{"$f":"IF($A32=\"\",\"\",info!B38)","v":23},{"$f":"IF($A32=\"\",\"\",info!C38)","v":"جميلة"},{"$f":"IF($A32=\"\",\"\",info!G38)","v":"2008-11-29"},{"$f":"IF($A32=\"\",\"\",info!D38)","v":"أ"},{"$f":"IF($A32=\"\",\"\",info!F38)","v":0},3,2,2.5,4,2,3,4,2,3,3,2,2.5,4,2,3,2.8,null,null,"",4,2,3,4,3.25,3,2.5,2.75,5,4,4.5,1.5,3.25,2.375,3,2.5,2.75,5.5,5,5.25,1,{"$f":"IF($A32=\"\",\"\",6+AT32+info!$P$3)","v":7},20.925000000000001,2.9892857142857143,21,"تنبيه",{"$f":"IF($A32=\"\",\"\",'sem1'!AW32)","v":4.0401785714285712},3.5147321428571425]
[{"$f":"IF(info!A39=\"\",\"\",info!A39)","v":24},{"$f":"IF($A33=\"\",\"\",info!B39)","v":24},{"$f":"IF($A33=\"\",\"\",info!C39)","v":"نادية"},{"$f":"IF($A33=\"\",\"\",info!G39)","v":"2008-06-24"},{"$f":"IF($A33=\"\",\"\",info!D39)","v":"أ"},{"$f":"IF($A33=\"\",\"\",info!F39)","v":0},3.5,3,3.25,6,3,4.5,6,3,4.5,3,3,3,5,3,4,3.85,null,null,"",4,3,3.5,5,3.875,3,3,3,4,2,3,2.75,3.88,3.3149999999999999,3,3,3,6,4,5,1,{"$f":"IF($A33=\"\",\"\",6+AT33+info!$P$3)","v":7},22.04,3.1485714285714286,19,"ناقص",{"$f":"IF($A33=\"\",\"\",'sem1'!AW33)","v":4.4428571428571431},3.7957142857142858]
[{"$f":"IF(info!A40=\"\",\"\",info!A40)","v":25},{"$f":"IF($A34=\"\",\"\",info!B40)","v":25},{"$f":"IF($A34=\"\",\"\",info!C40)","v":"سكينة"},{"$f":"IF($A34=\"\",\"\",info!G40)","v":"2008-06-07"},{"$f":"IF($A34=\"\",\"\",info!D40)","v":"أ"},{"$f":"IF($A34=\"\",\"\",info!F40)","v":0},4,6.5,5.25,6.5,6,6.25,5.5,7,6.25,4.5,6,5.25,6,7,6.5,5.9,null,null,"",5,6,5.5,4,5.125,3,4.5,3.75,6,5,5.5,3.75,6.13,4.9399999999999995,4.5,4.5,4.5,6,6.5,6.25,1,{"$f":"IF($A34=\"\",\"\",6+AT34+info!$P$3)","v":7},31.464999999999996,4.4949999999999992,15,"دون المتوسط",{"$f":"IF($A34=\"\",\"\",'sem1'!AW34)","v":4.6712500000000006},4.5831249999999999]
[{"$f":"IF(info!A41=\"\",\"\",info!A41)","v":""},{"$f":"IF($A35=\"\",\"\",info!B41)","v":""},{"$f":"IF($A35=\"\",\"\",info!C41)","v":""},{"$f":"IF($A35=\"\",\"\",info!G41)","v":""},{"$f":"IF($A35=\"\",\"\",info!D41)","v":""},{"$f":"IF($A35=\"\",\"\",info!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,{"$f":"IF($A35=\"\",\"\",6+AT35+info!$P$3)","v":""},"","","","",{"$f":"IF($A35=\"\",\"\",'sem1'!AW35)","v":""},""]
[{"$f":"IF(info!A42=\"\",\"\",info!A42)","v":""},{"$f":"IF($A36=\"\",\"\",info!B42)","v":""},{"$f":"IF($A36=\"\",\"\",info!C42)","v":""},{"$f":"IF($A36=\"\",\"\",info!G42)","v":""},{"$f":"IF($A36=\"\",\"\",info!D42)","v":""},{"$f":"IF($A36=\"\",\"\",info!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,{"$f":"IF($A36=\"\",\"\",6+AT36+info!$P$3)","v":""},"","","","",{"$f":"IF($A36=\"\",\"\",'sem1'!AW36)","v":""},""]
[{"$f":"IF(info!A43=\"\",\"\",info!A43)","v":""},{"$f":"IF($A37=\"\",\"\",info!B43)","v":""},{"$f":"IF($A37=\"\",\"\",info!C43)","v":""},{"$f":"IF($A37=\"\",\"\",info!G43)","v":""},{"$f":"IF($A37=\"\",\"\",info!D43)","v":""},{"$f":"IF($A37=\"\",\"\",info!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,{"$f":"IF($A37=\"\",\"\",6+AT37+info!$P$3)","v":""},"","","","",{"$f":"IF($A37=\"\",\"\",'sem1'!AW37)","v":""},""]
[{"$f":"IF(info!A44=\"\",\"\",info!A44)","v":""},{"$f":"IF($A38=\"\",\"\",info!B44)","v":""},{"$f":"IF($A38=\"\",\"\",info!C44)","v":""},{"$f":"IF($A38=\"\",\"\",info!G44)","v":""},{"$f":"IF($A38=\"\",\"\",info!D44)","v":""},{"$f":"IF($A38=\"\",\"\",info!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,{"$f":"IF($A38=\"\",\"\",6+AT38+info!$P$3)","v":""},"","","","",{"$f":"IF($A38=\"\",\"\",'sem1'!AW38)","v":""},""]
[{"$f":"IF(info!A45=\"\",\"\",info!A45)","v":""},{"$f":"IF($A39=\"\",\"\",info!B45)","v":""},{"$f":"IF($A39=\"\",\"\",info!C45)","v":""},{"$f":"IF($A39=\"\",\"\",info!G45)","v":""},{"$f":"IF($A39=\"\",\"\",info!D45)","v":""},{"$f":"IF($A39=\"\",\"\",info!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,{"$f":"IF($A39=\"\",\"\",6+AT39+info!$P$3)","v":""},"","","","",{"$f":"IF($A39=\"\",\"\",'sem1'!AW39)","v":""},""]
[{"$f":"IF(info!A46=\"\",\"\",info!A46)","v":""},{"$f":"IF($A40=\"\",\"\",info!B46)","v":""},{"$f":"IF($A40=\"\",\"\",info!C46)","v":""},{"$f":"IF($A40=\"\",\"\",info!G46)","v":""},{"$f":"IF($A40=\"\",\"\",info!D46)","v":""},{"$f":"IF($A40=\"\",\"\",info!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,{"$f":"IF($A40=\"\",\"\",6+AT40+info!$P$3)","v":""},"","","","",{"$f":"IF($A40=\"\",\"\",'sem1'!AW40)","v":""},""]
[{"$f":"IF(info!A47=\"\",\"\",info!A47)","v":""},{"$f":"IF($A41=\"\",\"\",info!B47)","v":""},{"$f":"IF($A41=\"\",\"\",info!C47)","v":""},{"$f":"IF($A41=\"\",\"\",info!G47)","v":""},{"$f":"IF($A41=\"\",\"\",info!D47)","v":""},{"$f":"IF($A41=\"\",\"\",info!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,{"$f":"IF($A41=\"\",\"\",6+AT41+info!$P$3)","v":""},"","","","",{"$f":"IF($A41=\"\",\"\",'sem1'!AW41)","v":""},""]
[{"$f":"IF(info!A48=\"\",\"\",info!A48)","v":""},{"$f":"IF($A42=\"\",\"\",info!B48)","v":""},{"$f":"IF($A42=\"\",\"\",info!C48)","v":""},{"$f":"IF($A42=\"\",\"\",info!G48)","v":""},{"$f":"IF($A42=\"\",\"\",info!D48)","v":""},{"$f":"IF($A42=\"\",\"\",info!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,{"$f":"IF($A42=\"\",\"\",6+AT42+info!$P$3)","v":""},{"$f":"IF($A42=\"\",\"\",SUM(V42,AD42,AG42,AJ42,AM42,AS42,Y42))","v":""},"",{"$f":"IF($A42=\"\",\"\",RANK(AW42,$AW$10:$AW$59))","v":""},"",{"$f":"IF($A42=\"\",\"\",'sem1'!AW42)","v":""},""]
[{"$f":"IF(info!A49=\"\",\"\",info!A49)","v":""},{"$f":"IF($A43=\"\",\"\",info!B49)","v":""},{"$f":"IF($A43=\"\",\"\",info!C49)","v":""},{"$f":"IF($A43=\"\",\"\",info!G49)","v":""},{"$f":"IF($A43=\"\",\"\",info!D49)","v":""},{"$f":"IF($A43=\"\",\"\",info!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,{"$f":"IF($A43=\"\",\"\",6+AT43+info!$P$3)","v":""},"","","","",{"$f":"IF($A43=\"\",\"\",'sem1'!AW43)","v":""},""]
[{"$f":"IF(info!A50=\"\",\"\",info!A50)","v":""},{"$f":"IF($A44=\"\",\"\",info!B50)","v":""},{"$f":"IF($A44=\"\",\"\",info!C50)","v":""},{"$f":"IF($A44=\"\",\"\",info!G50)","v":""},{"$f":"IF($A44=\"\",\"\",info!D50)","v":""},{"$f":"IF($A44=\"\",\"\",info!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,{"$f":"IF($A44=\"\",\"\",6+AT44+info!$P$3)","v":""},"","","","",{"$f":"IF($A44=\"\",\"\",'sem1'!AW44)","v":""},""]
[{"$f":"IF(info!A51=\"\",\"\",info!A51)","v":""},{"$f":"IF($A45=\"\",\"\",info!B51)","v":""},{"$f":"IF($A45=\"\",\"\",info!C51)","v":""},{"$f":"IF($A45=\"\",\"\",info!G51)","v":""},{"$f":"IF($A45=\"\",\"\",info!D51)","v":""},{"$f":"IF($A45=\"\",\"\",info!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,{"$f":"IF($A45=\"\",\"\",6+AT45+info!$P$3)","v":""},"","","","",{"$f":"IF($A45=\"\",\"\",'sem1'!AW45)","v":""},""]
[{"$f":"IF(info!A52=\"\",\"\",info!A52)","v":""},{"$f":"IF($A46=\"\",\"\",info!B52)","v":""},{"$f":"IF($A46=\"\",\"\",info!C52)","v":""},{"$f":"IF($A46=\"\",\"\",info!G52)","v":""},{"$f":"IF($A46=\"\",\"\",info!D52)","v":""},{"$f":"IF($A46=\"\",\"\",info!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,{"$f":"IF($A46=\"\",\"\",6+AT46+info!$P$3)","v":""},"","","","",{"$f":"IF($A46=\"\",\"\",'sem1'!AW46)","v":""},""]
[{"$f":"IF(info!A53=\"\",\"\",info!A53)","v":""},{"$f":"IF($A47=\"\",\"\",info!B53)","v":""},{"$f":"IF($A47=\"\",\"\",info!C53)","v":""},{"$f":"IF($A47=\"\",\"\",info!G53)","v":""},{"$f":"IF($A47=\"\",\"\",info!D53)","v":""},{"$f":"IF($A47=\"\",\"\",info!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,{"$f":"IF($A47=\"\",\"\",6+AT47+info!$P$3)","v":""},"","","","",{"$f":"IF($A47=\"\",\"\",'sem1'!AW47)","v":""},""]
[{"$f":"IF(info!A54=\"\",\"\",info!A54)","v":""},{"$f":"IF($A48=\"\",\"\",info!B54)","v":""},{"$f":"IF($A48=\"\",\"\",info!C54)","v":""},{"$f":"IF($A48=\"\",\"\",info!G54)","v":""},{"$f":"IF($A48=\"\",\"\",info!D54)","v":""},{"$f":"IF($A48=\"\",\"\",info!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,{"$f":"IF($A48=\"\",\"\",6+AT48+info!$P$3)","v":""},"","","","",{"$f":"IF($A48=\"\",\"\",'sem1'!AW48)","v":""},""]
[{"$f":"IF(info!A55=\"\",\"\",info!A55)","v":""},{"$f":"IF($A49=\"\",\"\",info!B55)","v":""},{"$f":"IF($A49=\"\",\"\",info!C55)","v":""},{"$f":"IF($A49=\"\",\"\",info!G55)","v":""},{"$f":"IF($A49=\"\",\"\",info!D55)","v":""},{"$f":"IF($A49=\"\",\"\",info!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,{"$f":"IF($A49=\"\",\"\",6+AT49+info!$P$3)","v":""},"","","","",{"$f":"IF($A49=\"\",\"\",'sem1'!AW49)","v":""},""]
[{"$f":"IF(info!A56=\"\",\"\",info!A56)","v":""},{"$f":"IF($A50=\"\",\"\",info!B56)","v":""},{"$f":"IF($A50=\"\",\"\",info!C56)","v":""},{"$f":"IF($A50=\"\",\"\",info!G56)","v":""},{"$f":"IF($A50=\"\",\"\",info!D56)","v":""},{"$f":"IF($A50=\"\",\"\",info!F56)","v":""},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"","",null,null,"",null,null,{"$f":"IF(Z50=\"\",\"\",IF(AA50=\"\",\"\",AVERAGE(Z50:AA50)))","v":""},null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"IF($A50=\"\",\"\",6+AT50+info!$P$3)","v":""},"",{"$f":"IF($A50=\"\",\"\",AV50/AU50)","v":""},"",{"$f":"IF($A50=\"\",\"\",IF(AW50>=8,\" تنويه \",IF(AW50>=7,\"تشجيع \",IF(AW50>=6,\"لوحة الشرف\",IF(AW50>=5,\"متوسط\",IF(AW50>=4,\"دون المتوسط\",IF(AW50>=3,\"ناقص\",IF(AW50>=2,\"تنبيه\",IF(AW50>=1,\"إنذار\",\"توبيخ\")))))))))","v":""},{"$f":"IF($A50=\"\",\"\",'sem1'!AW50)","v":""},{"$f":"IF($A50=\"\",\"\",AVERAGE(AZ50,AW50))","v":""}]
[{"$f":"IF(info!A57=\"\",\"\",info!A57)","v":""},{"$f":"IF($A51=\"\",\"\",info!B57)","v":""},{"$f":"IF($A51=\"\",\"\",info!C57)","v":""},{"$f":"IF($A51=\"\",\"\",info!G57)","v":""},{"$f":"IF($A51=\"\",\"\",info!D57)","v":""},{"$f":"IF($A51=\"\",\"\",info!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,{"$f":"IF($A51=\"\",\"\",6+AT51+info!$P$3)","v":""},"","","","",{"$f":"IF($A51=\"\",\"\",'sem1'!AW51)","v":""},""]
[{"$f":"IF(info!A58=\"\",\"\",info!A58)","v":""},{"$f":"IF($A52=\"\",\"\",info!B58)","v":""},{"$f":"IF($A52=\"\",\"\",info!C58)","v":""},{"$f":"IF($A52=\"\",\"\",info!G58)","v":""},{"$f":"IF($A52=\"\",\"\",info!D58)","v":""},{"$f":"IF($A52=\"\",\"\",info!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,{"$f":"IF($A52=\"\",\"\",6+AT52+info!$P$3)","v":""},"","","","",{"$f":"IF($A52=\"\",\"\",'sem1'!AW52)","v":""},""]
[{"$f":"IF(info!A59=\"\",\"\",info!A59)","v":""},{"$f":"IF($A53=\"\",\"\",info!B59)","v":""},{"$f":"IF($A53=\"\",\"\",info!C59)","v":""},{"$f":"IF($A53=\"\",\"\",info!G59)","v":""},{"$f":"IF($A53=\"\",\"\",info!D59)","v":""},{"$f":"IF($A53=\"\",\"\",info!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,{"$f":"IF($A53=\"\",\"\",6+AT53+info!$P$3)","v":""},"","","","",{"$f":"IF($A53=\"\",\"\",'sem1'!AW53)","v":""},""]
[{"$f":"IF(info!A60=\"\",\"\",info!A60)","v":""},{"$f":"IF($A54=\"\",\"\",info!B60)","v":""},{"$f":"IF($A54=\"\",\"\",info!C60)","v":""},{"$f":"IF($A54=\"\",\"\",info!G60)","v":""},{"$f":"IF($A54=\"\",\"\",info!D60)","v":""},{"$f":"IF($A54=\"\",\"\",info!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,{"$f":"IF($A54=\"\",\"\",6+AT54+info!$P$3)","v":""},"","","","",{"$f":"IF($A54=\"\",\"\",'sem1'!AW54)","v":""},""]
[{"$f":"IF(info!A61=\"\",\"\",info!A61)","v":""},{"$f":"IF($A55=\"\",\"\",info!B61)","v":""},{"$f":"IF($A55=\"\",\"\",info!C61)","v":""},{"$f":"IF($A55=\"\",\"\",info!G61)","v":""},{"$f":"IF($A55=\"\",\"\",info!D61)","v":""},{"$f":"IF($A55=\"\",\"\",info!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,{"$f":"IF($A55=\"\",\"\",6+AT55+info!$P$3)","v":""},"","","","",{"$f":"IF($A55=\"\",\"\",'sem1'!AW55)","v":""},""]
[{"$f":"IF(info!A62=\"\",\"\",info!A62)","v":""},{"$f":"IF($A56=\"\",\"\",info!B62)","v":""},{"$f":"IF($A56=\"\",\"\",info!C62)","v":""},{"$f":"IF($A56=\"\",\"\",info!G62)","v":""},{"$f":"IF($A56=\"\",\"\",info!D62)","v":""},{"$f":"IF($A56=\"\",\"\",info!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,{"$f":"IF($A56=\"\",\"\",6+AT56+info!$P$3)","v":""},"","","","",{"$f":"IF($A56=\"\",\"\",'sem1'!AW56)","v":""},""]
[{"$f":"IF(info!A63=\"\",\"\",info!A63)","v":""},{"$f":"IF($A57=\"\",\"\",info!B63)","v":""},{"$f":"IF($A57=\"\",\"\",info!C63)","v":""},{"$f":"IF($A57=\"\",\"\",info!G63)","v":""},{"$f":"IF($A57=\"\",\"\",info!D63)","v":""},{"$f":"IF($A57=\"\",\"\",info!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,{"$f":"IF($A57=\"\",\"\",6+AT57+info!$P$3)","v":""},"","","","",{"$f":"IF($A57=\"\",\"\",'sem1'!AW57)","v":""},""]
[{"$f":"IF(info!A64=\"\",\"\",info!A64)","v":""},{"$f":"IF($A58=\"\",\"\",info!B64)","v":""},{"$f":"IF($A58=\"\",\"\",info!C64)","v":""},{"$f":"IF($A58=\"\",\"\",info!G64)","v":""},{"$f":"IF($A58=\"\",\"\",info!D64)","v":""},{"$f":"IF($A58=\"\",\"\",info!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,{"$f":"IF($A58=\"\",\"\",6+AT58+info!$P$3)","v":""},"","","","",{"$f":"IF($A58=\"\",\"\",'sem1'!AW58)","v":""},""]
[{"$f":"IF(info!A65=\"\",\"\",info!A65)","v":""},{"$f":"IF($A59=\"\",\"\",info!B65)","v":""},{"$f":"IF($A59=\"\",\"\",info!C65)","v":""},{"$f":"IF($A59=\"\",\"\",info!G65)","v":""},{"$f":"IF($A59=\"\",\"\",info!D65)","v":""},{"$f":"IF($A59=\"\",\"\",info!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,{"$f":"IF($A59=\"\",\"\",6+AT59+info!$P$3)","v":""},"","","","",{"$f":"IF($A59=\"\",\"\",'sem1'!AW59)","v":""},""]

{"sheet":"bulletin_sem2","index":4,"n_rows":47,"n_cols":22,"rows_kept":47,"cut":false,"hidden":false,"merged":[[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],[35,0,36,2],[35,3,35,5],[35,6,35,7],[35,8,35,9],[35,12,36,14],[36,3,36,5],[37,3,37,5],[37,6,37,7],[37,8,37,9],[37,12,38,14],[38,3,38,5],[45,0,45,3],[44,4,44,5],[45,4,45,5],[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,46,9],[43,11,46,14],[46,0,46,3],[46,4,46,5],[44,0,44,3],[34,0,34,2],[37,0,38,2],[33,0,33,2],[33,3,33,5],[33,6,33,7],[33,8,33,9],[33,12,34,14],[34,3,34,5],[26,0,27,2],[26,3,26,5],[31,12,32,14],[32,0,32,2],[32,3,32,5],[26,12,30,14],[27,3,27,5],[28,0,30,2],[28,3,28,5],[30,3,30,5],[26,6,26,9],[29,3,29,5],[27,6,27,9],[28,6,28,9],[29,6,29,9],[31,0,31,2],[31,3,31,5],[31,6,31,7],[31,8,31,9],[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],[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],[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],[19,6,19,7],[19,8,19,9],[0,0,0,5],[0,10,0,12],[0,13,0,14],[1,0,1,5],[1,10,1,12],[1,13,1,14],[6,10,6,12],[6,13,6,14],[8,1,9,13],[4,0,4,5],[4,10,4,12],[4,13,4,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]]}
[{"$f":"info!$A$1","v":"المملكة المغربية"},null,null,null,null,null,null,null,null,null,"الموسم الدراسي",null,null,{"$f":"IF($N$7=\"\",\"\",info!$M$1)","v":"2018-2017"}]
[{"$f":"info!$A$2","v":"وزارة التربية الوطنية و التكوين المهني"},null,null,null,null,null,null,null,null,null,"الاسم و النسب",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,3,0))","v":"رضوان"}]
[{"$f":"info!$A$3","v":"الأكاديمية الجهوية للتربية والتكوين"},null,null,null,null,null,null,null,null,null,"الرقم الوطني",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,2,0))","v":1}]
[{"$f":"info!$A$4","v":"جهة دكالة عبدة "},null,null,null,null,null,null,null,null,null,"رقم التسجيل",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,6,0))","v":0}]
[{"$f":"info!$A$5","v":"نيابة المديرية"},null,null,null,null,null,null,null,null,null,"رقم ت في القسم",null,null,1]
[{"$f":"info!$A$6","v":"المدرسة"},null,null,null,null,null,null,null,null,null,"القسم",null,null,{"$f":"IF($N$7=\"\",\"\",info!$M$3)","v":"الأول"}]
[null,null,null,null,null,null,null,null,null,null,"عدد التلاميذ",null,null,{"$f":"IF(info!$O$12=0,\"\",info!$O$12)","v":25},null,null,null,"i"]
[]
[null,"بطاقة المراقبة المستمرة"]
[]
[]
[null,null,"مدرسة",null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",info!A6)","v":"المدرسة"}]
[null,null,"الاسم والنسب",null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base1,3,0))","v":"رضوان"},null,null,null,null,"i",null,null,"i"]
[]
[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,null,null,null,null,null,"i"]
["اللغة العربية",null,null,"القراءة",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,7,0))","v":4},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,8,0))","v":4.5},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G19:J19))","v":4.25},{"$f":"IF($N$7=\"\",\"\",IF(L24<2,\"ضعيف\",IF(AND(L24>=2,L24<=3),\"دون المستوى\",IF(AND(L24>3,L24<5),\"متوسط\",IF(AND(L24>=5,L24<7),\"لابأس به\",IF(AND(L24>=7,L24<8),\"مستحسن\",IF(AND(L24>=8,L24<=10),\"ممتاز\")))))))","v":"متوسط"}]
[null,null,null,"الإملاء",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,10,0))","v":5},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,11,0))","v":4.5},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G20:J20))","v":4.75}]
[null,null,null,"الخط",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,13,0))","v":5},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,14,0))","v":4.5},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G21:J21))","v":4.75}]
[null,null,null,"التعبير الشفوي",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,16,0))","v":3},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,17,0))","v":4.5},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G22:J22))","v":3.75}]
[null,null,null,"النقل",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,19,0))","v":5},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,20,0))","v":4.5},null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(G23:J23))","v":4.75}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(L19:L23))","v":4.45}]
["اللغة",null,null,"الأمازيغية",null,null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base3,23,0)=\"\",\"\",VLOOKUP($N$5,base3,23,0)))","v":""},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base3,24,0)=\"\",\"\",VLOOKUP($N$5,base3,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(AND(L26>=2,L26<=3),\"دون المستوى\",IF(AND(L26>3,L26<5),\"متوسط\",IF(AND(L26>=5,L26<7),\"لابأس به\",IF(AND(L26>=7,L26<8),\"مستحسن\",IF(AND(L26>=8,L26<=10),\"ممتاز\"))))))))","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($N$5,base3,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($N$7=\"\",\"\",IF(L31<2,\"ضعيف\",IF(AND(L31>=2,L31<=3),\"دون المستوى\",IF(AND(L31>3,L31<5),\"متوسط\",IF(AND(L31>=5,L31<7),\"لابأس به\",IF(AND(L31>=7,L31<8),\"مستحسن\",IF(AND(L31>=8,L31<=10),\"ممتاز\")))))))","v":"متوسط"}]
[null,null,null,"الفرض 2",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,27,0))","v":5},null,{"$f":"VLOOKUP($N$5,base1,29,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G28)","v":5}]
["الإسلامية",null,null,"الفرض 3",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,28,0))","v":4.5},null,{"$f":"VLOOKUP($N$5,base1,32,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G29)","v":4.5}]
[null,null,null,"أنشطة",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,29,0))","v":5.5},null,{"$f":"VLOOKUP($N$5,base1,32,0)","v":4},null,null,{"$f":"IF($N$7=\"\",\"\",G30)","v":5.5}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",AVERAGE(L27:L30))","v":4.75}]
["النشاط ",null,null,"النشاط العلمي",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,31,0))","v":3},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,32,0))","v":5.5},null,null,{"$f":"IF(OR($N$7=\"\",G32=\"\",I32=\"\"),\"\",AVERAGE(D32:I32))","v":4.25},{"$f":"IF($N$7=\"\",\"\",IF(L33<2,\"ضعيف\",IF(AND(L33>=2,L33<=3),\"دون المستوى\",IF(AND(L33>3,L33<5),\"متوسط\",IF(AND(L33>=5,L33<7),\"لابأس به\",IF(AND(L33>=7,L33<8),\"مستحسن\",IF(AND(L33>=8,L33<=10),\"ممتاز\")))))))","v":"متوسط"}]
["العلمي",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L32)","v":4.25}]
["التربية",null,null,"التربية الفنية",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,34,0))","v":4.5},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,35,0))","v":6.5},null,null,{"$f":"IF(OR($N$7=\"\",G34=\"\",I34=\"\"),\"\",AVERAGE(D34:I34))","v":5.5},{"$f":"IF($N$7=\"\",\"\",IF(L35<2,\"ضعيف\",IF(AND(L35>=2,L35<=3),\"دون المستوى\",IF(AND(L35>3,L35<5),\"متوسط\",IF(AND(L35>=5,L35<7),\"لابأس به\",IF(AND(L35>=7,L35<8),\"مستحسن\",IF(AND(L35>=8,L35<=10),\"ممتاز\")))))))","v":"لابأس به"}]
["الفنية",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L34)","v":5.5}]
["الرياضيات",null,null,"الرياضيات",null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,37,0))","v":5.5},null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,38,0))","v":6.5},null,null,{"$f":"IF(OR($N$7=\"\",G36=\"\",I36=\"\"),\"\",AVERAGE(D36:I36))","v":6},{"$f":"IF($N$7=\"\",\"\",IF(L37<2,\"ضعيف\",IF(AND(L37>=2,L37<=3),\"دون المستوى\",IF(AND(L37>3,L37<5),\"متوسط\",IF(AND(L37>=5,L37<7),\"لابأس به\",IF(AND(L37>=7,L37<8),\"مستحسن\",IF(AND(L37>=8,L37<=10),\"ممتاز\")))))))","v":"لابأس به"}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L36)","v":6}]
["الفرنسية",null,null,"الفرنسية",null,null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base3,40,0)=\"\",\"\",VLOOKUP($N$5,base3,40,0)))","v":3},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base3,41,0)=\"\",\"\",VLOOKUP($N$5,base3,41,0)))","v":5.5},null,null,{"$f":"IF(OR($N$7=\"\",G38=\"\",I38=\"\"),\"\",AVERAGE(D38:I38))","v":4.25},{"$f":"IF($N$7=\"\",\"\",IF(L39<2,\"ضعيف\",IF(AND(L39>=2,L39<=3),\"دون المستوى\",IF(AND(L39>3,L39<5),\"متوسط\",IF(AND(L39>=5,L39<7),\"لابأس به\",IF(AND(L39>=7,L39<8),\"مستحسن\",IF(AND(L39>=8,L39<=10),\"ممتاز\")))))))","v":"متوسط"}]
[null,null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L38)","v":4.25}]
["التربية",null,null,"التربية البدنية",null,null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base3,43,0)=\"\",\"\",VLOOKUP($N$5,base3,43,0)))","v":6},null,{"$f":"IF($N$7=\"\",\"\",IF(VLOOKUP($N$5,base3,44,0)=\"\",\"\",VLOOKUP($N$5,base3,44,0)))","v":8},null,null,{"$f":"IF(OR($N$7=\"\",G40=\"\",I40=\"\"),\"\",AVERAGE(D40:I40))","v":7},{"$f":"IF($N$7=\"\",\"\",IF(L41=\"\",\"معفى من التربية البدنية\",IF(L41<2,\"ضعيف\",IF(AND(L41>=2,L41<=3),\"دون المستوى\",IF(AND(L41>3,L41<5),\"متوسط\",IF(AND(L41>=5,L41<7),\"لابأس به\",IF(AND(L41>=7,L41<8),\"مستحسن\",IF(AND(L41>=8,L41<=10),\"ممتاز\"))))))))","v":"مستحسن"}]
["البدنية",null,null,"معدل الوحدة",null,null,null,null,null,null,null,{"$f":"IF($N$7=\"\",\"\",L40)","v":7}]
[]
["مجموع معدل الوحدات",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,48,0))","v":31.95},null,null,"الميزة",null,null,null,"خاتم و توقيع رئيس المؤسسة"]
["المعدل الدوري",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,49,0))","v":4.5642857142857141},null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,51,0))","v":"دون المتوسط"}]
["المعدل الدورة الأولى",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,52,0))","v":3.6892857142857141}]
["المعدل العام السنوي",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,53,0))","v":4.1267857142857141}]
["الرتبة",null,null,null,{"$f":"IF($N$7=\"\",\"\",VLOOKUP($N$5,base3,50,0))","v":14}]

{"sheet":"مجمل","index":5,"n_rows":60,"n_cols":33,"rows_kept":60,"cut":false,"hidden":false,"merged":[[7,30,9,30],[7,31,9,31],[7,27,7,28],[8,15,8,17],[8,12,8,14],[7,12,7,14],[7,15,7,17],[7,18,8,20],[8,27,8,28],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[7,24,7,26],[8,24,8,26],[8,9,8,11],[8,3,8,5],[8,6,8,8],[7,3,7,5],[7,6,7,8],[7,9,7,11],[5,26,5,28],[7,21,8,23],[7,2,9,2],[7,1,9,1],[7,0,9,0],[2,9,3,21],[0,29,0,31],[1,29,1,31],[2,29,2,31],[3,29,3,31],[4,29,4,31],[5,29,5,31],[0,26,0,28],[1,26,1,28],[2,26,2,28],[3,26,3,28],[4,26,4,28]]}
[{"$f":"info!$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,{"$f":"info!J1","v":"العـام الدراســي "},null,null,{"$f":"info!$M$1","v":"2018-2017"}]
[{"$f":"info!$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,{"$f":"info!J2","v":"الأستاذ (ة)"},null,null,{"$f":"info!$M$2","v":"هشام "}]
[{"$f":"info!$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,{"$f":"info!J3","v":"المستوى "},null,null,{"$f":"info!$M$3","v":"الأول"}]
[{"$f":"info!$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,{"$f":"info!J4","v":"الوحدة المدرسية"},null,null,{"$f":"info!$M$4","v":"لايهم"}]
[{"$f":"info!$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,{"$f":"info!J5","v":"الفوج"},null,null,{"$f":"info!$M$5","v":1}]
[{"$f":"info!$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,{"$f":"info!J6","v":"عدد التلاميذ"},null,null,{"$f":"info!$M$6","v":25}]
[]
["ر.ت","ر. تسجيل","الاسم و النسب","اللغة",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","معدل","د1","د2","معدل","د1","د2","معدل","د1","د2","معدل","د1","د2","معدل","د1","د2","معدل","د1","د2","معدل","د1","د2","معدل","د1","د2","معدل",null,null,"السنة"]
[{"$f":"IF(info!$A16=\"\",\"\",info!$A16)","v":1},{"$f":"IF($A11=\"\",\"\",info!$F16)","v":0},{"$f":"IF($A11=\"\",\"\",info!$C16)","v":"رضوان"},{"$f":"IF('sem1'!V10=\"\",\"\",'sem1'!V10)","v":3.7},{"$f":"IF('sem2'!V10=\"\",\"\",'sem2'!V10)","v":4.45},{"$f":"IF(OR(D11=\"\",E11=\"\"),\"\",AVERAGE(D11:E11))","v":4.0750000000000002},{"$f":"IF('sem1'!Y10=\"\",\"\",'sem1'!Y10)","v":""},{"$f":"IF('sem2'!Y10=\"\",\"\",'sem2'!Y10)","v":""},{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",AVERAGE(G11:H11))","v":""},{"$f":"IF('sem1'!AD10=\"\",\"\",'sem1'!AD10)","v":3.625},{"$f":"IF('sem2'!AD10=\"\",\"\",'sem2'!AD10)","v":4.75},{"$f":"IF(OR(J11=\"\",K11=\"\"),\"\",AVERAGE(J11:K11))","v":4.1875},{"$f":"IF('sem1'!AG10=\"\",\"\",'sem1'!AG10)","v":4},{"$f":"IF('sem2'!AG10=\"\",\"\",'sem2'!AG10)","v":4.25},{"$f":"IF(OR(M11=\"\",N11=\"\"),\"\",AVERAGE(M11:N11))","v":4.125},{"$f":"IF('sem1'!AJ10=\"\",\"\",'sem1'!AJ10)","v":5.25},{"$f":"IF('sem2'!AJ10=\"\",\"\",'sem2'!AJ10)","v":5.5},{"$f":"IF(OR(P11=\"\",Q11=\"\"),\"\",AVERAGE(P11:Q11))","v":5.375},{"$f":"IF('sem1'!AM10=\"\",\"\",'sem1'!AM10)","v":3.25},{"$f":"IF('sem2'!AM10=\"\",\"\",'sem2'!AM10)","v":6},{"$f":"IF(OR(S11=\"\",T11=\"\"),\"\",AVERAGE(S11:T11))","v":4.625},{"$f":"IF('sem1'!AP10=\"\",\"\",'sem1'!AP10)","v":3.75},{"$f":"IF('sem2'!AP10=\"\",\"\",'sem2'!AP10)","v":4.25},{"$f":"IF(OR(V11=\"\",W11=\"\"),\"\",AVERAGE(V11:W11))","v":4},{"$f":"IF('sem1'!AS10=\"\",\"\",'sem1'!AS10)","v":6},{"$f":"IF('sem2'!AS10=\"\",\"\",'sem2'!AS10)","v":7},{"$f":"IF(OR(Y11=\"\",Z11=\"\"),\"\",AVERAGE(Y11:Z11))","v":6.5},{"$f":"IF(OR(D11=\"\",J11=\"\",M11=\"\",P11=\"\",S11=\"\",V11=\"\"),\"\",AVERAGE(D11,G11,J11,M11,P11,S11,V11,Y11))","v":4.2249999999999996},{"$f":"IF(OR(E11=\"\",K11=\"\",N11=\"\",Q11=\"\",T11=\"\",W11=\"\"),\"\",AVERAGE(E11,H11,K11,N11,Q11,T11,W11,Z11))","v":5.1714285714285717},{"$f":"IF(OR(AB11=\"\",AC11=\"\"),\"\",AVERAGE(AB11:AC11))","v":4.6982142857142861},{"$f":"IF(IF(AD11=\"\",\"\",RANK(AD11,$AD$11:$AD$60))=\"\",\"\",IF(AD11=\"\",\"\",RANK(AD11,$AD$11:$AD$60)))","v":18},{"$f":"IF(IF(AD11=\"\",\"\",IF(AD11>=8,\" تنويه \",IF(AD11>=7,\"تشجيع \",IF(AD11>=6,\"لوحة الشرف\",IF(AD11>=5,\"متوسط\",IF(AD11>=4,\"دون المتوسط\",IF(AD11>=3,\"ناقص\",IF(AD11>=2,\"تنبيه\",IF(AD11>=1,\"إنذار\",\"توبيخ\")))))))))=\"\",\"\",IF(AD11=\"\",\"\",IF(AD11>=8,\" تنويه \",IF(AD11>=7,\"تشجيع \",IF(AD11>=6,\"لوحة الشرف\",IF(AD11>=5,\"متوسط\",IF(AD11>=4,\"دون المتوسط\",IF(AD11>=3,\"ناقص\",IF(AD11>=2,\"تنبيه\",IF(AD11>=1,\"إنذار\",\"توبيخ\"))))))))))","v":"دون المتوسط"},{"$f":"IF(AD11=\"\",\"\",IF(AD11>=5,\"ينتقل\",\"يكرر\"))","v":"يكرر"}]
[{"$f":"IF(info!$A17=\"\",\"\",info!$A17)","v":2},{"$f":"IF($A12=\"\",\"\",info!$F17)","v":0},{"$f":"IF($A12=\"\",\"\",info!$C17)","v":"محمد"},{"$f":"IF('sem1'!V11=\"\",\"\",'sem1'!V11)","v":5.45},{"$f":"IF('sem2'!V11=\"\",\"\",'sem2'!V11)","v":5.875},{"$f":"IF(OR(D12=\"\",E12=\"\"),\"\",AVERAGE(D12:E12))","v":5.6624999999999996},{"$f":"IF('sem1'!Y11=\"\",\"\",'sem1'!Y11)","v":""},{"$f":"IF('sem2'!Y11=\"\",\"\",'sem2'!Y11)","v":""},{"$f":"IF(OR(G12=\"\",H12=\"\"),\"\",AVERAGE(G12:H12))","v":""},{"$f":"IF('sem1'!AD11=\"\",\"\",'sem1'!AD11)","v":5.4375},{"$f":"IF('sem2'!AD11=\"\",\"\",'sem2'!AD11)","v":5.75},{"$f":"IF(OR(J12=\"\",K12=\"\"),\"\",AVERAGE(J12:K12))","v":5.59375},{"$f":"IF('sem1'!AG11=\"\",\"\",'sem1'!AG11)","v":9.25},{"$f":"IF('sem2'!AG11=\"\",\"\",'sem2'!AG11)","v":3.875},{"$f":"IF(OR(M12=\"\",N12=\"\"),\"\",AVERAGE(M12:N12))","v":6.5625},{"$f":"IF('sem1'!AJ11=\"\",\"\",'sem1'!AJ11)","v":6.875},{"$f":"IF('sem2'!AJ11=\"\",\"\",'sem2'!AJ11)","v":4.375},{"$f":"IF(OR(P12=\"\",Q12=\"\"),\"\",AVERAGE(P12:Q12))","v":5.625},{"$f":"IF('sem1'!AM11=\"\",\"\",'sem1'!AM11)","v":6.665},{"$f":"IF('sem2'!AM11=\"\",\"\",'sem2'!AM11)","v":5.25},{"$f":"IF(OR(S12=\"\",T12=\"\"),\"\",AVERAGE(S12:T12))","v":5.9574999999999996},{"$f":"IF('sem1'!AP11=\"\",\"\",'sem1'!AP11)","v":5.625},{"$f":"IF('sem2'!AP11=\"\",\"\",'sem2'!AP11)","v":5.125},{"$f":"IF(OR(V12=\"\",W12=\"\"),\"\",AVERAGE(V12:W12))","v":5.375},{"$f":"IF('sem1'!AS11=\"\",\"\",'sem1'!AS11)","v":6.125},{"$f":"IF('sem2'!AS11=\"\",\"\",'sem2'!AS11)","v":6.25},{"$f":"IF(OR(Y12=\"\",Z12=\"\"),\"\",AVERAGE(Y12:Z12))","v":6.1875},{"$f":"IF(OR(D12=\"\",J12=\"\",M12=\"\",P12=\"\",S12=\"\",V12=\"\"),\"\",AVERAGE(D12,G12,J12,M12,P12,S12,V12,Y12))","v":6.489642857142857},{"$f":"IF(OR(E12=\"\",K12=\"\",N12=\"\",Q12=\"\",T12=\"\",W12=\"\"),\"\",AVERAGE(E12,H12,K12,N12,Q12,T12,W12,Z12))","v":5.2142857142857144},{"$f":"IF(OR(AB12=\"\",AC12=\"\"),\"\",AVERAGE(AB12:AC12))","v":5.8519642857142857},{"$f":"IF(IF(AD12=\"\",\"\",RANK(AD12,$AD$11:$AD$60))=\"\",\"\",IF(AD12=\"\",\"\",RANK(AD12,$AD$11:$AD$60)))","v":9},{"$f":"IF(IF(AD12=\"\",\"\",IF(AD12>=8,\" تنويه \",IF(AD12>=7,\"تشجيع \",IF(AD12>=6,\"لوحة الشرف\",IF(AD12>=5,\"متوسط\",IF(AD12>=4,\"دون المتوسط\",IF(AD12>=3,\"ناقص\",IF(AD12>=2,\"تنبيه\",IF(AD12>=1,\"إنذار\",\"توبيخ\")))))))))=\"\",\"\",IF(AD12=\"\",\"\",IF(AD12>=8,\" تنويه \",IF(AD12>=7,\"تشجيع \",IF(AD12>=6,\"لوحة الشرف\",IF(AD12>=5,\"متوسط\",IF(AD12>=4,\"دون المتوسط\",IF(AD12>=3,\"ناقص\",IF(AD12>=2,\"تنبيه\",IF(AD12>=1,\"إنذار\",\"توبيخ\"))))))))))","v":"متوسط"},"ينتقل"]
[{"$f":"IF(info!$A18=\"\",\"\",info!$A18)","v":3},{"$f":"IF($A13=\"\",\"\",info!$F18)","v":0},{"$f":"IF($A13=\"\",\"\",info!$C18)","v":"سلمى"},{"$f":"IF('sem1'!V12=\"\",\"\",'sem1'!V12)","v":4.75},{"$f":"IF('sem2'!V12=\"\",\"\",'sem2'!V12)","v":4.5999999999999996},4.6749999999999998,{"$f":"IF('sem1'!Y12=\"\",\"\",'sem1'!Y12)","v":""},{"$f":"IF('sem2'!Y12=\"\",\"\",'sem2'!Y12)","v":""},"",{"$f":"IF('sem1'!AD12=\"\",\"\",'sem1'!AD12)","v":4.375},{"$f":"IF('sem2'!AD12=\"\",\"\",'sem2'!AD12)","v":5.375},4.875,{"$f":"IF('sem1'!AG12=\"\",\"\",'sem1'!AG12)","v":5.83},{"$f":"IF('sem2'!AG12=\"\",\"\",'sem2'!AG12)","v":4.375},5.1025,{"$f":"IF('sem1'!AJ12=\"\",\"\",'sem1'!AJ12)","v":7.25},{"$f":"IF('sem2'!AJ12=\"\",\"\",'sem2'!AJ12)","v":4.625},5.9375,{"$f":"IF('sem1'!AM12=\"\",\"\",'sem1'!AM12)","v":5.25},{"$f":"IF('sem2'!AM12=\"\",\"\",'sem2'!AM12)","v":4.75},5,{"$f":"IF('sem1'!AP12=\"\",\"\",'sem1'!AP12)","v":4.5},{"$f":"IF('sem2'!AP12=\"\",\"\",'sem2'!AP12)","v":4.875},4.6875,{"$f":"IF('sem1'!AS12=\"\",\"\",'sem1'!AS12)","v":6.375},{"$f":"IF('sem2'!AS12=\"\",\"\",'sem2'!AS12)","v":6.25},6.3125,5.4757142857142851,4.9785714285714286,5.2271428571428569,13,"متوسط","ينتقل"]
[{"$f":"IF(info!$A19=\"\",\"\",info!$A19)","v":4},{"$f":"IF($A14=\"\",\"\",info!$F19)","v":0},{"$f":"IF($A14=\"\",\"\",info!$C19)","v":"شعيب"},{"$f":"IF('sem1'!V13=\"\",\"\",'sem1'!V13)","v":6.5750000000000002},{"$f":"IF('sem2'!V13=\"\",\"\",'sem2'!V13)","v":6.55},6.5625,{"$f":"IF('sem1'!Y13=\"\",\"\",'sem1'!Y13)","v":""},{"$f":"IF('sem2'!Y13=\"\",\"\",'sem2'!Y13)","v":""},"",{"$f":"IF('sem1'!AD13=\"\",\"\",'sem1'!AD13)","v":7.21875},{"$f":"IF('sem2'!AD13=\"\",\"\",'sem2'!AD13)","v":6.5625},6.890625,{"$f":"IF('sem1'!AG13=\"\",\"\",'sem1'!AG13)","v":7.75},{"$f":"IF('sem2'!AG13=\"\",\"\",'sem2'!AG13)","v":8.5},8.125,{"$f":"IF('sem1'!AJ13=\"\",\"\",'sem1'!AJ13)","v":8.25},{"$f":"IF('sem2'!AJ13=\"\",\"\",'sem2'!AJ13)","v":7.5},7.875,{"$f":"IF('sem1'!AM13=\"\",\"\",'sem1'!AM13)","v":9.1649999999999991},{"$f":"IF('sem2'!AM13=\"\",\"\",'sem2'!AM13)","v":9.125},9.1449999999999996,{"$f":"IF('sem1'!AP13=\"\",\"\",'sem1'!AP13)","v":6.5625},{"$f":"IF('sem2'!AP13=\"\",\"\",'sem2'!AP13)","v":8},7.28125,{"$f":"IF('sem1'!AS13=\"\",\"\",'sem1'!AS13)","v":6.5},{"$f":"IF('sem2'!AS13=\"\",\"\",'sem2'!AS13)","v":6.625},6.5625,7.4316071428571417,7.5517857142857139,7.4916964285714283,3,"تشجيع ","ينتقل"]
[{"$f":"IF(info!$A20=\"\",\"\",info!$A20)","v":5},{"$f":"IF($A15=\"\",\"\",info!$F20)","v":0},{"$f":"IF($A15=\"\",\"\",info!$C20)","v":"ميلود"},{"$f":"IF('sem1'!V14=\"\",\"\",'sem1'!V14)","v":5.05},{"$f":"IF('sem2'!V14=\"\",\"\",'sem2'!V14)","v":5.3250000000000002},5.1875,{"$f":"IF('sem1'!Y14=\"\",\"\",'sem1'!Y14)","v":""},{"$f":"IF('sem2'!Y14=\"\",\"\",'sem2'!Y14)","v":""},"",{"$f":"IF('sem1'!AD14=\"\",\"\",'sem1'!AD14)","v":5.15625},{"$f":"IF('sem2'!AD14=\"\",\"\",'sem2'!AD14)","v":4.625},4.890625,{"$f":"IF('sem1'!AG14=\"\",\"\",'sem1'!AG14)","v":8},{"$f":"IF('sem2'!AG14=\"\",\"\",'sem2'!AG14)","v":3.25},5.625,{"$f":"IF('sem1'!AJ14=\"\",\"\",'sem1'!AJ14)","v":6.5},{"$f":"IF('sem2'!AJ14=\"\",\"\",'sem2'!AJ14)","v":4.5},5.5,{"$f":"IF('sem1'!AM14=\"\",\"\",'sem1'!AM14)","v":5.4550000000000001},{"$f":"IF('sem2'!AM14=\"\",\"\",'sem2'!AM14)","v":4.5},4.9775,{"$f":"IF('sem1'!AP14=\"\",\"\",'sem1'!AP14)","v":4.4375},{"$f":"IF('sem2'!AP14=\"\",\"\",'sem2'!AP14)","v":4.625},4.53125,{"$f":"IF('sem1'!AS14=\"\",\"\",'sem1'!AS14)","v":6.125},{"$f":"IF('sem2'!AS14=\"\",\"\",'sem2'!AS14)","v":6.75},6.4375,5.8176785714285719,4.7964285714285717,5.3070535714285718,11,"متوسط","ينتقل"]
[{"$f":"IF(info!$A21=\"\",\"\",info!$A21)","v":6},{"$f":"IF($A16=\"\",\"\",info!$F21)","v":0},{"$f":"IF($A16=\"\",\"\",info!$C21)","v":"فاطمة"},{"$f":"IF('sem1'!V15=\"\",\"\",'sem1'!V15)","v":3.05},{"$f":"IF('sem2'!V15=\"\",\"\",'sem2'!V15)","v":2.5499999999999998},2.8,{"$f":"IF('sem1'!Y15=\"\",\"\",'sem1'!Y15)","v":""},{"$f":"IF('sem2'!Y15=\"\",\"\",'sem2'!Y15)","v":""},"",{"$f":"IF('sem1'!AD15=\"\",\"\",'sem1'!AD15)","v":3.25},{"$f":"IF('sem2'!AD15=\"\",\"\",'sem2'!AD15)","v":2.5},2.875,{"$f":"IF('sem1'!AG15=\"\",\"\",'sem1'!AG15)","v":4.5},{"$f":"IF('sem2'!AG15=\"\",\"\",'sem2'!AG15)","v":1.5},3,{"$f":"IF('sem1'!AJ15=\"\",\"\",'sem1'!AJ15)","v":5.625},{"$f":"IF('sem2'!AJ15=\"\",\"\",'sem2'!AJ15)","v":2},3.8125,{"$f":"IF('sem1'!AM15=\"\",\"\",'sem1'!AM15)","v":3.54},{"$f":"IF('sem2'!AM15=\"\",\"\",'sem2'!AM15)","v":1},2.27,{"$f":"IF('sem1'!AP15=\"\",\"\",'sem1'!AP15)","v":2.5},{"$f":"IF('sem2'!AP15=\"\",\"\",'sem2'!AP15)","v":2},2.25,{"$f":"IF('sem1'!AS15=\"\",\"\",'sem1'!AS15)","v":5.5},{"$f":"IF('sem2'!AS15=\"\",\"\",'sem2'!AS15)","v":5},5.25,3.9950000000000001,2.3642857142857143,3.1796428571428574,24,"ناقص","يكرر"]
[{"$f":"IF(info!$A22=\"\",\"\",info!$A22)","v":7},{"$f":"IF($A17=\"\",\"\",info!$F22)","v":0},{"$f":"IF($A17=\"\",\"\",info!$C22)","v":"مصطفى"},{"$f":"IF('sem1'!V16=\"\",\"\",'sem1'!V16)","v":4},{"$f":"IF('sem2'!V16=\"\",\"\",'sem2'!V16)","v":4.4000000000000004},4.2,{"$f":"IF('sem1'!Y16=\"\",\"\",'sem1'!Y16)","v":""},{"$f":"IF('sem2'!Y16=\"\",\"\",'sem2'!Y16)","v":""},"",{"$f":"IF('sem1'!AD16=\"\",\"\",'sem1'!AD16)","v":3.25},{"$f":"IF('sem2'!AD16=\"\",\"\",'sem2'!AD16)","v":4.125},3.6875,{"$f":"IF('sem1'!AG16=\"\",\"\",'sem1'!AG16)","v":6.58},{"$f":"IF('sem2'!AG16=\"\",\"\",'sem2'!AG16)","v":7},6.79,{"$f":"IF('sem1'!AJ16=\"\",\"\",'sem1'!AJ16)","v":6},{"$f":"IF('sem2'!AJ16=\"\",\"\",'sem2'!AJ16)","v":6},6,{"$f":"IF('sem1'!AM16=\"\",\"\",'sem1'!AM16)","v":5},{"$f":"IF('sem2'!AM16=\"\",\"\",'sem2'!AM16)","v":5.875},5.4375,{"$f":"IF('sem1'!AP16=\"\",\"\",'sem1'!AP16)","v":3},{"$f":"IF('sem2'!AP16=\"\",\"\",'sem2'!AP16)","v":5.5},4.25,{"$f":"IF('sem1'!AS16=\"\",\"\",'sem1'!AS16)","v":5.5},{"$f":"IF('sem2'!AS16=\"\",\"\",'sem2'!AS16)","v":6.5},6,4.7614285714285716,5.6285714285714281,5.1950000000000003,16,"متوسط","ينتقل"]
[{"$f":"IF(info!$A23=\"\",\"\",info!$A23)","v":8},{"$f":"IF($A18=\"\",\"\",info!$F23)","v":0},{"$f":"IF($A18=\"\",\"\",info!$C23)","v":"فريد"},{"$f":"IF('sem1'!V17=\"\",\"\",'sem1'!V17)","v":5.7249999999999996},{"$f":"IF('sem2'!V17=\"\",\"\",'sem2'!V17)","v":6.9749999999999996},6.35,{"$f":"IF('sem1'!Y17=\"\",\"\",'sem1'!Y17)","v":""},{"$f":"IF('sem2'!Y17=\"\",\"\",'sem2'!Y17)","v":""},"",{"$f":"IF('sem1'!AD17=\"\",\"\",'sem1'!AD17)","v":5.1875},{"$f":"IF('sem2'!AD17=\"\",\"\",'sem2'!AD17)","v":6.71875},5.953125,{"$f":"IF('sem1'!AG17=\"\",\"\",'sem1'!AG17)","v":9.6649999999999991},{"$f":"IF('sem2'!AG17=\"\",\"\",'sem2'!AG17)","v":8.375},9.02,{"$f":"IF('sem1'!AJ17=\"\",\"\",'sem1'!AJ17)","v":8.125},{"$f":"IF('sem2'!AJ17=\"\",\"\",'sem2'!AJ17)","v":7.75},7.9375,{"$f":"IF('sem1'!AM17=\"\",\"\",'sem1'!AM17)","v":8.2050000000000001},{"$f":"IF('sem2'!AM17=\"\",\"\",'sem2'!AM17)","v":9.6900000000000013},8.9475000000000016,{"$f":"IF('sem1'!AP17=\"\",\"\",'sem1'!AP17)","v":4.875},{"$f":"IF('sem2'!AP17=\"\",\"\",'sem2'!AP17)","v":8.125},6.5,{"$f":"IF('sem1'!AS17=\"\",\"\",'sem1'!AS17)","v":6.5},{"$f":"IF('sem2'!AS17=\"\",\"\",'sem2'!AS17)","v":7},6.75,6.8975,7.8048214285714295,7.3511607142857152,4,"تشجيع ","ينتقل"]
[{"$f":"IF(info!$A24=\"\",\"\",info!$A24)","v":9},{"$f":"IF($A19=\"\",\"\",info!$F24)","v":0},{"$f":"IF($A19=\"\",\"\",info!$C24)","v":"كمال"},{"$f":"IF('sem1'!V18=\"\",\"\",'sem1'!V18)","v":6.65},{"$f":"IF('sem2'!V18=\"\",\"\",'sem2'!V18)","v":7.0750000000000002},6.8625000000000007,{"$f":"IF('sem1'!Y18=\"\",\"\",'sem1'!Y18)","v":""},{"$f":"IF('sem2'!Y18=\"\",\"\",'sem2'!Y18)","v":""},"",{"$f":"IF('sem1'!AD18=\"\",\"\",'sem1'!AD18)","v":7.75},{"$f":"IF('sem2'!AD18=\"\",\"\",'sem2'!AD18)","v":7.25},7.5,{"$f":"IF('sem1'!AG18=\"\",\"\",'sem1'!AG18)","v":9.33},{"$f":"IF('sem2'!AG18=\"\",\"\",'sem2'!AG18)","v":8.625},8.9774999999999991,{"$f":"IF('sem1'!AJ18=\"\",\"\",'sem1'!AJ18)","v":8.375},{"$f":"IF('sem2'!AJ18=\"\",\"\",'sem2'!AJ18)","v":7.125},7.75,{"$f":"IF('sem1'!AM18=\"\",\"\",'sem1'!AM18)","v":8.125},{"$f":"IF('sem2'!AM18=\"\",\"\",'sem2'!AM18)","v":9.125},8.625,{"$f":"IF('sem1'!AP18=\"\",\"\",'sem1'!AP18)","v":6.75},{"$f":"IF('sem2'!AP18=\"\",\"\",'sem2'!AP18)","v":7.125},6.9375,{"$f":"IF('sem1'!AS18=\"\",\"\",'sem1'!AS18)","v":6.25},{"$f":"IF('sem2'!AS18=\"\",\"\",'sem2'!AS18)","v":7},6.625,7.604285714285715,7.6178571428571429,7.6110714285714289,2,"تشجيع ","ينتقل"]
[{"$f":"IF(info!$A25=\"\",\"\",info!$A25)","v":10},{"$f":"IF($A20=\"\",\"\",info!$F25)","v":0},{"$f":"IF($A20=\"\",\"\",info!$C25)","v":"لبنى"},{"$f":"IF('sem1'!V19=\"\",\"\",'sem1'!V19)","v":4.2},{"$f":"IF('sem2'!V19=\"\",\"\",'sem2'!V19)","v":3.75},3.9750000000000001,{"$f":"IF('sem1'!Y19=\"\",\"\",'sem1'!Y19)","v":""},{"$f":"IF('sem2'!Y19=\"\",\"\",'sem2'!Y19)","v":""},"",{"$f":"IF('sem1'!AD19=\"\",\"\",'sem1'!AD19)","v":3.875},{"$f":"IF('sem2'!AD19=\"\",\"\",'sem2'!AD19)","v":3.4375},3.65625,{"$f":"IF('sem1'!AG19=\"\",\"\",'sem1'!AG19)","v":5.5},{"$f":"IF('sem2'!AG19=\"\",\"\",'sem2'!AG19)","v":3.375},4.4375,{"$f":"IF('sem1'!AJ19=\"\",\"\",'sem1'!AJ19)","v":6},{"$f":"IF('sem2'!AJ19=\"\",\"\",'sem2'!AJ19)","v":2.5},4.25,{"$f":"IF('sem1'!AM19=\"\",\"\",'sem1'!AM19)","v":2.875},{"$f":"IF('sem2'!AM19=\"\",\"\",'sem2'!AM19)","v":3.25},3.0625,{"$f":"IF('sem1'!AP19=\"\",\"\",'sem1'!AP19)","v":3.75},{"$f":"IF('sem2'!AP19=\"\",\"\",'sem2'!AP19)","v":2.5},3.125,{"$f":"IF('sem1'!AS19=\"\",\"\",'sem1'!AS19)","v":5.75},{"$f":"IF('sem2'!AS19=\"\",\"\",'sem2'!AS19)","v":5},5.375,4.5642857142857141,3.4017857142857144,3.9830357142857142,20,"ناقص","يكرر"]
[{"$f":"IF(info!$A26=\"\",\"\",info!$A26)","v":11},{"$f":"IF($A21=\"\",\"\",info!$F26)","v":0},{"$f":"IF($A21=\"\",\"\",info!$C26)","v":"أحمد"},{"$f":"IF('sem1'!V20=\"\",\"\",'sem1'!V20)","v":6.7249999999999996},{"$f":"IF('sem2'!V20=\"\",\"\",'sem2'!V20)","v":7.6749999999999998},7.1999999999999993,{"$f":"IF('sem1'!Y20=\"\",\"\",'sem1'!Y20)","v":""},{"$f":"IF('sem2'!Y20=\"\",\"\",'sem2'!Y20)","v":""},"",{"$f":"IF('sem1'!AD20=\"\",\"\",'sem1'!AD20)","v":5.125},{"$f":"IF('sem2'!AD20=\"\",\"\",'sem2'!AD20)","v":6.875},6,{"$f":"IF('sem1'!AG20=\"\",\"\",'sem1'!AG20)","v":7.75},{"$f":"IF('sem2'!AG20=\"\",\"\",'sem2'!AG20)","v":6.25},7,{"$f":"IF('sem1'!AJ20=\"\",\"\",'sem1'!AJ20)","v":8},{"$f":"IF('sem2'!AJ20=\"\",\"\",'sem2'!AJ20)","v":6.125},7.0625,{"$f":"IF('sem1'!AM20=\"\",\"\",'sem1'!AM20)","v":7.83},{"$f":"IF('sem2'!AM20=\"\",\"\",'sem2'!AM20)","v":8.5},8.1649999999999991,{"$f":"IF('sem1'!AP20=\"\",\"\",'sem1'!AP20)","v":5.25},{"$f":"IF('sem2'!AP20=\"\",\"\",'sem2'!AP20)","v":6.625},5.9375,{"$f":"IF('sem1'!AS20=\"\",\"\",'sem1'!AS20)","v":6.5},{"$f":"IF('sem2'!AS20=\"\",\"\",'sem2'!AS20)","v":7.25},6.875,6.74,7.0428571428571427,6.8914285714285715,6,"لوحة الشرف","ينتقل"]
[{"$f":"IF(info!$A27=\"\",\"\",info!$A27)","v":12},{"$f":"IF($A22=\"\",\"\",info!$F27)","v":0},{"$f":"IF($A22=\"\",\"\",info!$C27)","v":"سلمان"},{"$f":"IF('sem1'!V21=\"\",\"\",'sem1'!V21)","v":7.0750000000000002},{"$f":"IF('sem2'!V21=\"\",\"\",'sem2'!V21)","v":8.2750000000000004},7.6750000000000007,{"$f":"IF('sem1'!Y21=\"\",\"\",'sem1'!Y21)","v":""},{"$f":"IF('sem2'!Y21=\"\",\"\",'sem2'!Y21)","v":""},"",{"$f":"IF('sem1'!AD21=\"\",\"\",'sem1'!AD21)","v":5},{"$f":"IF('sem2'!AD21=\"\",\"\",'sem2'!AD21)","v":7.75},6.375,{"$f":"IF('sem1'!AG21=\"\",\"\",'sem1'!AG21)","v":10},{"$f":"IF('sem2'!AG21=\"\",\"\",'sem2'!AG21)","v":9},9.5,{"$f":"IF('sem1'!AJ21=\"\",\"\",'sem1'!AJ21)","v":8.75},{"$f":"IF('sem2'!AJ21=\"\",\"\",'sem2'!AJ21)","v":8.5},8.625,{"$f":"IF('sem1'!AM21=\"\",\"\",'sem1'!AM21)","v":8.94},{"$f":"IF('sem2'!AM21=\"\",\"\",'sem2'!AM21)","v":9.3150000000000013},9.1275000000000013,{"$f":"IF('sem1'!AP21=\"\",\"\",'sem1'!AP21)","v":7},{"$f":"IF('sem2'!AP21=\"\",\"\",'sem2'!AP21)","v":9.25},8.125,{"$f":"IF('sem1'!AS21=\"\",\"\",'sem1'!AS21)","v":6.5},{"$f":"IF('sem2'!AS21=\"\",\"\",'sem2'!AS21)","v":7.5},7,7.609285714285714,8.5128571428571433,8.0610714285714291,1," تنويه ","ينتقل"]
[{"$f":"IF(info!$A28=\"\",\"\",info!$A28)","v":13},{"$f":"IF($A23=\"\",\"\",info!$F28)","v":0},{"$f":"IF($A23=\"\",\"\",info!$C28)","v":"مروة"},{"$f":"IF('sem1'!V22=\"\",\"\",'sem1'!V22)","v":3.95},{"$f":"IF('sem2'!V22=\"\",\"\",'sem2'!V22)","v":4.5},4.2249999999999996,{"$f":"IF('sem1'!Y22=\"\",\"\",'sem1'!Y22)","v":""},{"$f":"IF('sem2'!Y22=\"\",\"\",'sem2'!Y22)","v":""},"",{"$f":"IF('sem1'!AD22=\"\",\"\",'sem1'!AD22)","v":3.875},{"$f":"IF('sem2'!AD22=\"\",\"\",'sem2'!AD22)","v":4.375},4.125,{"$f":"IF('sem1'!AG22=\"\",\"\",'sem1'!AG22)","v":5.875},{"$f":"IF('sem2'!AG22=\"\",\"\",'sem2'!AG22)","v":5.75},5.8125,{"$f":"IF('sem1'!AJ22=\"\",\"\",'sem1'!AJ22)","v":6.375},{"$f":"IF('sem2'!AJ22=\"\",\"\",'sem2'!AJ22)","v":6.5},6.4375,{"$f":"IF('sem1'!AM22=\"\",\"\",'sem1'!AM22)","v":3.33},{"$f":"IF('sem2'!AM22=\"\",\"\",'sem2'!AM22)","v":4.6899999999999995},4.01,{"$f":"IF('sem1'!AP22=\"\",\"\",'sem1'!AP22)","v":3.25},{"$f":"IF('sem2'!AP22=\"\",\"\",'sem2'!AP22)","v":6.25},4.75,{"$f":"IF('sem1'!AS22=\"\",\"\",'sem1'!AS22)","v":6.25},{"$f":"IF('sem2'!AS22=\"\",\"\",'sem2'!AS22)","v":6.75},6.5,4.7007142857142856,5.5449999999999999,5.1228571428571428,17,"متوسط","ينتقل"]
[{"$f":"IF(info!$A29=\"\",\"\",info!$A29)","v":14},{"$f":"IF($A24=\"\",\"\",info!$F29)","v":0},{"$f":"IF($A24=\"\",\"\",info!$C29)","v":"خالد"},{"$f":"IF('sem1'!V23=\"\",\"\",'sem1'!V23)","v":6.2750000000000004},{"$f":"IF('sem2'!V23=\"\",\"\",'sem2'!V23)","v":6.9249999999999998},6.6,{"$f":"IF('sem1'!Y23=\"\",\"\",'sem1'!Y23)","v":""},{"$f":"IF('sem2'!Y23=\"\",\"\",'sem2'!Y23)","v":""},"",{"$f":"IF('sem1'!AD23=\"\",\"\",'sem1'!AD23)","v":5},{"$f":"IF('sem2'!AD23=\"\",\"\",'sem2'!AD23)","v":6.8125},5.90625,{"$f":"IF('sem1'!AG23=\"\",\"\",'sem1'!AG23)","v":7.665},{"$f":"IF('sem2'!AG23=\"\",\"\",'sem2'!AG23)","v":5.25},6.4574999999999996,{"$f":"IF('sem1'!AJ23=\"\",\"\",'sem1'!AJ23)","v":7.25},{"$f":"IF('sem2'!AJ23=\"\",\"\",'sem2'!AJ23)","v":7.75},7.5,{"$f":"IF('sem1'!AM23=\"\",\"\",'sem1'!AM23)","v":6.625},{"$f":"IF('sem2'!AM23=\"\",\"\",'sem2'!AM23)","v":8.75},7.6875,{"$f":"IF('sem1'!AP23=\"\",\"\",'sem1'!AP23)","v":5.25},{"$f":"IF('sem2'!AP23=\"\",\"\",'sem2'!AP23)","v":6.5},5.875,{"$f":"IF('sem1'!AS23=\"\",\"\",'sem1'!AS23)","v":6.5},{"$f":"IF('sem2'!AS23=\"\",\"\",'sem2'!AS23)","v":7.375},6.9375,6.3664285714285711,7.0517857142857139,6.7091071428571425,8,"لوحة الشرف","ينتقل"]
[{"$f":"IF(info!$A30=\"\",\"\",info!$A30)","v":15},{"$f":"IF($A25=\"\",\"\",info!$F30)","v":0},{"$f":"IF($A25=\"\",\"\",info!$C30)","v":"سفيان"},{"$f":"IF('sem1'!V24=\"\",\"\",'sem1'!V24)","v":4.5},{"$f":"IF('sem2'!V24=\"\",\"\",'sem2'!V24)","v":5.0999999999999996},4.8,{"$f":"IF('sem1'!Y24=\"\",\"\",'sem1'!Y24)","v":""},{"$f":"IF('sem2'!Y24=\"\",\"\",'sem2'!Y24)","v":""},"",{"$f":"IF('sem1'!AD24=\"\",\"\",'sem1'!AD24)","v":3.875},{"$f":"IF('sem2'!AD24=\"\",\"\",'sem2'!AD24)","v":5.0625},4.46875,{"$f":"IF('sem1'!AG24=\"\",\"\",'sem1'!AG24)","v":4.415},{"$f":"IF('sem2'!AG24=\"\",\"\",'sem2'!AG24)","v":5.875},5.1449999999999996,{"$f":"IF('sem1'!AJ24=\"\",\"\",'sem1'!AJ24)","v":7.375},{"$f":"IF('sem2'!AJ24=\"\",\"\",'sem2'!AJ24)","v":6},6.6875,{"$f":"IF('sem1'!AM24=\"\",\"\",'sem1'!AM24)","v":5.04},{"$f":"IF('sem2'!AM24=\"\",\"\",'sem2'!AM24)","v":4.4399999999999995},4.74,{"$f":"IF('sem1'!AP24=\"\",\"\",'sem1'!AP24)","v":3.75},{"$f":"IF('sem2'!AP24=\"\",\"\",'sem2'!AP24)","v":5.375},4.5625,{"$f":"IF('sem1'!AS24=\"\",\"\",'sem1'!AS24)","v":5.75},{"$f":"IF('sem2'!AS24=\"\",\"\",'sem2'!AS24)","v":6.25},6,4.9578571428571427,5.4432142857142853,5.2005357142857136,15,"متوسط","ينتقل"]
[{"$f":"IF(info!$A31=\"\",\"\",info!$A31)","v":16},{"$f":"IF($A26=\"\",\"\",info!$F31)","v":0},{"$f":"IF($A26=\"\",\"\",info!$C31)","v":"لمياء"},{"$f":"IF('sem1'!V25=\"\",\"\",'sem1'!V25)","v":4.875},{"$f":"IF('sem2'!V25=\"\",\"\",'sem2'!V25)","v":5.9},5.3875000000000002,{"$f":"IF('sem1'!Y25=\"\",\"\",'sem1'!Y25)","v":""},{"$f":"IF('sem2'!Y25=\"\",\"\",'sem2'!Y25)","v":""},"",{"$f":"IF('sem1'!AD25=\"\",\"\",'sem1'!AD25)","v":4.875},{"$f":"IF('sem2'!AD25=\"\",\"\",'sem2'!AD25)","v":5.5625},5.21875,{"$f":"IF('sem1'!AG25=\"\",\"\",'sem1'!AG25)","v":6.83},{"$f":"IF('sem2'!AG25=\"\",\"\",'sem2'!AG25)","v":8},7.415,{"$f":"IF('sem1'!AJ25=\"\",\"\",'sem1'!AJ25)","v":6.625},{"$f":"IF('sem2'!AJ25=\"\",\"\",'sem2'!AJ25)","v":4.75},5.6875,{"$f":"IF('sem1'!AM25=\"\",\"\",'sem1'!AM25)","v":5.29},{"$f":"IF('sem2'!AM25=\"\",\"\",'sem2'!AM25)","v":4.9399999999999995},5.1150000000000002,{"$f":"IF('sem1'!AP25=\"\",\"\",'sem1'!AP25)","v":4.25},{"$f":"IF('sem2'!AP25=\"\",\"\",'sem2'!AP25)","v":5.75},5,{"$f":"IF('sem1'!AS25=\"\",\"\",'sem1'!AS25)","v":6},{"$f":"IF('sem2'!AS25=\"\",\"\",'sem2'!AS25)","v":6.25},6.125,5.5349999999999993,5.8789285714285713,5.7069642857142853,10,"متوسط","ينتقل"]
[{"$f":"IF(info!$A32=\"\",\"\",info!$A32)","v":17},{"$f":"IF($A27=\"\",\"\",info!$F32)","v":0},{"$f":"IF($A27=\"\",\"\",info!$C32)","v":"مريم"},{"$f":"IF('sem1'!V26=\"\",\"\",'sem1'!V26)","v":6.95},{"$f":"IF('sem2'!V26=\"\",\"\",'sem2'!V26)","v":7.05},7,{"$f":"IF('sem1'!Y26=\"\",\"\",'sem1'!Y26)","v":""},{"$f":"IF('sem2'!Y26=\"\",\"\",'sem2'!Y26)","v":""},"",{"$f":"IF('sem1'!AD26=\"\",\"\",'sem1'!AD26)","v":6.8125},{"$f":"IF('sem2'!AD26=\"\",\"\",'sem2'!AD26)","v":6.375},6.59375,{"$f":"IF('sem1'!AG26=\"\",\"\",'sem1'!AG26)","v":9.1649999999999991},{"$f":"IF('sem2'!AG26=\"\",\"\",'sem2'!AG26)","v":7},8.0824999999999996,{"$f":"IF('sem1'!AJ26=\"\",\"\",'sem1'!AJ26)","v":7.5},{"$f":"IF('sem2'!AJ26=\"\",\"\",'sem2'!AJ26)","v":6.5},7,{"$f":"IF('sem1'!AM26=\"\",\"\",'sem1'!AM26)","v":8.0399999999999991},{"$f":"IF('sem2'!AM26=\"\",\"\",'sem2'!AM26)","v":8.1900000000000013},8.1150000000000002,{"$f":"IF('sem1'!AP26=\"\",\"\",'sem1'!AP26)","v":6.375},{"$f":"IF('sem2'!AP26=\"\",\"\",'sem2'!AP26)","v":7.875},7.125,{"$f":"IF('sem1'!AS26=\"\",\"\",'sem1'!AS26)","v":6.75},{"$f":"IF('sem2'!AS26=\"\",\"\",'sem2'!AS26)","v":6.75},6.75,7.3703571428571433,7.1057142857142859,7.238035714285715,5,"تشجيع ","ينتقل"]
[{"$f":"IF(info!$A33=\"\",\"\",info!$A33)","v":18},{"$f":"IF($A28=\"\",\"\",info!$F33)","v":0},{"$f":"IF($A28=\"\",\"\",info!$C33)","v":"لقمان"},{"$f":"IF('sem1'!V27=\"\",\"\",'sem1'!V27)","v":3.6},{"$f":"IF('sem2'!V27=\"\",\"\",'sem2'!V27)","v":3.35},3.4750000000000001,{"$f":"IF('sem1'!Y27=\"\",\"\",'sem1'!Y27)","v":""},{"$f":"IF('sem2'!Y27=\"\",\"\",'sem2'!Y27)","v":""},"",{"$f":"IF('sem1'!AD27=\"\",\"\",'sem1'!AD27)","v":4.25},{"$f":"IF('sem2'!AD27=\"\",\"\",'sem2'!AD27)","v":3.625},3.9375,{"$f":"IF('sem1'!AG27=\"\",\"\",'sem1'!AG27)","v":5.33},{"$f":"IF('sem2'!AG27=\"\",\"\",'sem2'!AG27)","v":2.25},3.79,{"$f":"IF('sem1'!AJ27=\"\",\"\",'sem1'!AJ27)","v":5.625},{"$f":"IF('sem2'!AJ27=\"\",\"\",'sem2'!AJ27)","v":3},4.3125,{"$f":"IF('sem1'!AM27=\"\",\"\",'sem1'!AM27)","v":2.125},{"$f":"IF('sem2'!AM27=\"\",\"\",'sem2'!AM27)","v":1.875},2,{"$f":"IF('sem1'!AP27=\"\",\"\",'sem1'!AP27)","v":4},{"$f":"IF('sem2'!AP27=\"\",\"\",'sem2'!AP27)","v":2.75},3.375,{"$f":"IF('sem1'!AS27=\"\",\"\",'sem1'!AS27)","v":6.375},{"$f":"IF('sem2'!AS27=\"\",\"\",'sem2'!AS27)","v":5.5},5.9375,4.472142857142857,3.1928571428571431,3.8325,23,"ناقص","يكرر"]
[{"$f":"IF(info!$A34=\"\",\"\",info!$A34)","v":19},{"$f":"IF($A29=\"\",\"\",info!$F34)","v":0},{"$f":"IF($A29=\"\",\"\",info!$C34)","v":"محمد"},{"$f":"IF('sem1'!V28=\"\",\"\",'sem1'!V28)","v":2.8},{"$f":"IF('sem2'!V28=\"\",\"\",'sem2'!V28)","v":1.5},2.15,{"$f":"IF('sem1'!Y28=\"\",\"\",'sem1'!Y28)","v":""},{"$f":"IF('sem2'!Y28=\"\",\"\",'sem2'!Y28)","v":""},"",{"$f":"IF('sem1'!AD28=\"\",\"\",'sem1'!AD28)","v":3.625},{"$f":"IF('sem2'!AD28=\"\",\"\",'sem2'!AD28)","v":2.25},2.9375,{"$f":"IF('sem1'!AG28=\"\",\"\",'sem1'!AG28)","v":2.75},{"$f":"IF('sem2'!AG28=\"\",\"\",'sem2'!AG28)","v":1.75},2.25,{"$f":"IF('sem1'!AJ28=\"\",\"\",'sem1'!AJ28)","v":4.5},{"$f":"IF('sem2'!AJ28=\"\",\"\",'sem2'!AJ28)","v":1.5},3,{"$f":"IF('sem1'!AM28=\"\",\"\",'sem1'!AM28)","v":2.75},{"$f":"IF('sem2'!AM28=\"\",\"\",'sem2'!AM28)","v":1},1.875,{"$f":"IF('sem1'!AP28=\"\",\"\",'sem1'!AP28)","v":2.75},{"$f":"IF('sem2'!AP28=\"\",\"\",'sem2'!AP28)","v":1.75},2.25,{"$f":"IF('sem1'!AS28=\"\",\"\",'sem1'!AS28)","v":5.875},{"$f":"IF('sem2'!AS28=\"\",\"\",'sem2'!AS28)","v":4.5},5.1875,3.5785714285714287,2.0357142857142856,2.8071428571428569,25,"تنبيه","يكرر"]
[{"$f":"IF(info!$A35=\"\",\"\",info!$A35)","v":20},{"$f":"IF($A30=\"\",\"\",info!$F35)","v":0},{"$f":"IF($A30=\"\",\"\",info!$C35)","v":"سليم"},{"$f":"IF('sem1'!V29=\"\",\"\",'sem1'!V29)","v":6.25},{"$f":"IF('sem2'!V29=\"\",\"\",'sem2'!V29)","v":6.8250000000000002},6.5374999999999996,{"$f":"IF('sem1'!Y29=\"\",\"\",'sem1'!Y29)","v":""},{"$f":"IF('sem2'!Y29=\"\",\"\",'sem2'!Y29)","v":""},"",{"$f":"IF('sem1'!AD29=\"\",\"\",'sem1'!AD29)","v":5.6875},{"$f":"IF('sem2'!AD29=\"\",\"\",'sem2'!AD29)","v":5.125},5.40625,{"$f":"IF('sem1'!AG29=\"\",\"\",'sem1'!AG29)","v":7.25},{"$f":"IF('sem2'!AG29=\"\",\"\",'sem2'!AG29)","v":9.25},8.25,{"$f":"IF('sem1'!AJ29=\"\",\"\",'sem1'!AJ29)","v":8.25},{"$f":"IF('sem2'!AJ29=\"\",\"\",'sem2'!AJ29)","v":7.125},7.6875,{"$f":"IF('sem1'!AM29=\"\",\"\",'sem1'!AM29)","v":6.915},{"$f":"IF('sem2'!AM29=\"\",\"\",'sem2'!AM29)","v":6.44},6.6775000000000002,{"$f":"IF('sem1'!AP29=\"\",\"\",'sem1'!AP29)","v":6.125},{"$f":"IF('sem2'!AP29=\"\",\"\",'sem2'!AP29)","v":7},6.5625,{"$f":"IF('sem1'!AS29=\"\",\"\",'sem1'!AS29)","v":6.5},{"$f":"IF('sem2'!AS29=\"\",\"\",'sem2'!AS29)","v":6.875},6.6875,6.7110714285714286,6.9485714285714284,6.829821428571428,7,"لوحة الشرف","ينتقل"]
[{"$f":"IF(info!$A36=\"\",\"\",info!$A36)","v":21},{"$f":"IF($A31=\"\",\"\",info!$F36)","v":0},{"$f":"IF($A31=\"\",\"\",info!$C36)","v":"فتيحة"},{"$f":"IF('sem1'!V30=\"\",\"\",'sem1'!V30)","v":4.5},{"$f":"IF('sem2'!V30=\"\",\"\",'sem2'!V30)","v":5},4.75,{"$f":"IF('sem1'!Y30=\"\",\"\",'sem1'!Y30)","v":""},{"$f":"IF('sem2'!Y30=\"\",\"\",'sem2'!Y30)","v":""},"",{"$f":"IF('sem1'!AD30=\"\",\"\",'sem1'!AD30)","v":4.25},{"$f":"IF('sem2'!AD30=\"\",\"\",'sem2'!AD30)","v":4.6875},4.46875,{"$f":"IF('sem1'!AG30=\"\",\"\",'sem1'!AG30)","v":6.58},{"$f":"IF('sem2'!AG30=\"\",\"\",'sem2'!AG30)","v":5.375},5.9775,{"$f":"IF('sem1'!AJ30=\"\",\"\",'sem1'!AJ30)","v":7.25},{"$f":"IF('sem2'!AJ30=\"\",\"\",'sem2'!AJ30)","v":5},6.125,{"$f":"IF('sem1'!AM30=\"\",\"\",'sem1'!AM30)","v":3.665},{"$f":"IF('sem2'!AM30=\"\",\"\",'sem2'!AM30)","v":6.1899999999999995},4.9275000000000002,{"$f":"IF('sem1'!AP30=\"\",\"\",'sem1'!AP30)","v":4},{"$f":"IF('sem2'!AP30=\"\",\"\",'sem2'!AP30)","v":4.875},4.4375,{"$f":"IF('sem1'!AS30=\"\",\"\",'sem1'!AS30)","v":6.25},{"$f":"IF('sem2'!AS30=\"\",\"\",'sem2'!AS30)","v":6.375},6.3125,5.2135714285714281,5.3574999999999999,5.2855357142857144,12,"متوسط","ينتقل"]
[{"$f":"IF(info!$A37=\"\",\"\",info!$A37)","v":22},{"$f":"IF($A32=\"\",\"\",info!$F37)","v":0},{"$f":"IF($A32=\"\",\"\",info!$C37)","v":"رقية"},{"$f":"IF('sem1'!V31=\"\",\"\",'sem1'!V31)","v":3.35},{"$f":"IF('sem2'!V31=\"\",\"\",'sem2'!V31)","v":3.45},3.4000000000000004,{"$f":"IF('sem1'!Y31=\"\",\"\",'sem1'!Y31)","v":""},{"$f":"IF('sem2'!Y31=\"\",\"\",'sem2'!Y31)","v":""},"",{"$f":"IF('sem1'!AD31=\"\",\"\",'sem1'!AD31)","v":3.8125},{"$f":"IF('sem2'!AD31=\"\",\"\",'sem2'!AD31)","v":3.625},3.71875,{"$f":"IF('sem1'!AG31=\"\",\"\",'sem1'!AG31)","v":5.75},{"$f":"IF('sem2'!AG31=\"\",\"\",'sem2'!AG31)","v":3.25},4.5,{"$f":"IF('sem1'!AJ31=\"\",\"\",'sem1'!AJ31)","v":6.25},{"$f":"IF('sem2'!AJ31=\"\",\"\",'sem2'!AJ31)","v":3},4.625,{"$f":"IF('sem1'!AM31=\"\",\"\",'sem1'!AM31)","v":2},{"$f":"IF('sem2'!AM31=\"\",\"\",'sem2'!AM31)","v":1.875},1.9375,{"$f":"IF('sem1'!AP31=\"\",\"\",'sem1'!AP31)","v":3.375},{"$f":"IF('sem2'!AP31=\"\",\"\",'sem2'!AP31)","v":4},3.6875,{"$f":"IF('sem1'!AS31=\"\",\"\",'sem1'!AS31)","v":5.75},{"$f":"IF('sem2'!AS31=\"\",\"\",'sem2'!AS31)","v":4.75},5.25,4.3267857142857142,3.4214285714285713,3.8741071428571425,22,"ناقص","يكرر"]
[{"$f":"IF(info!$A38=\"\",\"\",info!$A38)","v":23},{"$f":"IF($A33=\"\",\"\",info!$F38)","v":0},{"$f":"IF($A33=\"\",\"\",info!$C38)","v":"جميلة"},{"$f":"IF('sem1'!V32=\"\",\"\",'sem1'!V32)","v":3.375},{"$f":"IF('sem2'!V32=\"\",\"\",'sem2'!V32)","v":2.8},3.0874999999999999,{"$f":"IF('sem1'!Y32=\"\",\"\",'sem1'!Y32)","v":""},{"$f":"IF('sem2'!Y32=\"\",\"\",'sem2'!Y32)","v":""},"",{"$f":"IF('sem1'!AD32=\"\",\"\",'sem1'!AD32)","v":4.28125},{"$f":"IF('sem2'!AD32=\"\",\"\",'sem2'!AD32)","v":3.25},3.765625,{"$f":"IF('sem1'!AG32=\"\",\"\",'sem1'!AG32)","v":4.25},{"$f":"IF('sem2'!AG32=\"\",\"\",'sem2'!AG32)","v":2.75},3.5,{"$f":"IF('sem1'!AJ32=\"\",\"\",'sem1'!AJ32)","v":6.5},{"$f":"IF('sem2'!AJ32=\"\",\"\",'sem2'!AJ32)","v":4.5},5.5,{"$f":"IF('sem1'!AM32=\"\",\"\",'sem1'!AM32)","v":4.25},{"$f":"IF('sem2'!AM32=\"\",\"\",'sem2'!AM32)","v":2.375},3.3125,{"$f":"IF('sem1'!AP32=\"\",\"\",'sem1'!AP32)","v":2.9375},{"$f":"IF('sem2'!AP32=\"\",\"\",'sem2'!AP32)","v":2.75},2.84375,{"$f":"IF('sem1'!AS32=\"\",\"\",'sem1'!AS32)","v":5.625},{"$f":"IF('sem2'!AS32=\"\",\"\",'sem2'!AS32)","v":5.25},5.4375,4.4598214285714288,3.3821428571428571,3.920982142857143,21,"ناقص","يكرر"]
[{"$f":"IF(info!$A39=\"\",\"\",info!$A39)","v":24},{"$f":"IF($A34=\"\",\"\",info!$F39)","v":0},{"$f":"IF($A34=\"\",\"\",info!$C39)","v":"نادية"},{"$f":"IF('sem1'!V33=\"\",\"\",'sem1'!V33)","v":3.6},{"$f":"IF('sem2'!V33=\"\",\"\",'sem2'!V33)","v":3.85},3.7250000000000001,{"$f":"IF('sem1'!Y33=\"\",\"\",'sem1'!Y33)","v":""},{"$f":"IF('sem2'!Y33=\"\",\"\",'sem2'!Y33)","v":""},"",{"$f":"IF('sem1'!AD33=\"\",\"\",'sem1'!AD33)","v":4.5},{"$f":"IF('sem2'!AD33=\"\",\"\",'sem2'!AD33)","v":3.875},4.1875,{"$f":"IF('sem1'!AG33=\"\",\"\",'sem1'!AG33)","v":7.5},{"$f":"IF('sem2'!AG33=\"\",\"\",'sem2'!AG33)","v":3},5.25,{"$f":"IF('sem1'!AJ33=\"\",\"\",'sem1'!AJ33)","v":6.5},{"$f":"IF('sem2'!AJ33=\"\",\"\",'sem2'!AJ33)","v":3},4.75,{"$f":"IF('sem1'!AM33=\"\",\"\",'sem1'!AM33)","v":3.25},{"$f":"IF('sem2'!AM33=\"\",\"\",'sem2'!AM33)","v":3.3149999999999999},3.2824999999999998,{"$f":"IF('sem1'!AP33=\"\",\"\",'sem1'!AP33)","v":3.75},{"$f":"IF('sem2'!AP33=\"\",\"\",'sem2'!AP33)","v":3},3.375,{"$f":"IF('sem1'!AS33=\"\",\"\",'sem1'!AS33)","v":5.75},{"$f":"IF('sem2'!AS33=\"\",\"\",'sem2'!AS33)","v":5},5.375,4.9785714285714286,3.577142857142857,4.277857142857143,19,"دون المتوسط","يكرر"]
[{"$f":"IF(info!$A40=\"\",\"\",info!$A40)","v":25},{"$f":"IF($A35=\"\",\"\",info!$F40)","v":0},{"$f":"IF($A35=\"\",\"\",info!$C40)","v":"سكينة"},{"$f":"IF('sem1'!V34=\"\",\"\",'sem1'!V34)","v":4.9000000000000004},{"$f":"IF('sem2'!V34=\"\",\"\",'sem2'!V34)","v":5.9},5.4,{"$f":"IF('sem1'!Y34=\"\",\"\",'sem1'!Y34)","v":""},{"$f":"IF('sem2'!Y34=\"\",\"\",'sem2'!Y34)","v":""},"",{"$f":"IF('sem1'!AD34=\"\",\"\",'sem1'!AD34)","v":4.59375},{"$f":"IF('sem2'!AD34=\"\",\"\",'sem2'!AD34)","v":5.125},4.859375,{"$f":"IF('sem1'!AG34=\"\",\"\",'sem1'!AG34)","v":5.58},{"$f":"IF('sem2'!AG34=\"\",\"\",'sem2'!AG34)","v":3.75},4.665,{"$f":"IF('sem1'!AJ34=\"\",\"\",'sem1'!AJ34)","v":6.625},{"$f":"IF('sem2'!AJ34=\"\",\"\",'sem2'!AJ34)","v":5.5},6.0625,{"$f":"IF('sem1'!AM34=\"\",\"\",'sem1'!AM34)","v":5.25},{"$f":"IF('sem2'!AM34=\"\",\"\",'sem2'!AM34)","v":4.9399999999999995},5.0949999999999998,{"$f":"IF('sem1'!AP34=\"\",\"\",'sem1'!AP34)","v":4.1875},{"$f":"IF('sem2'!AP34=\"\",\"\",'sem2'!AP34)","v":4.5},4.34375,{"$f":"IF('sem1'!AS34=\"\",\"\",'sem1'!AS34)","v":5.75},{"$f":"IF('sem2'!AS34=\"\",\"\",'sem2'!AS34)","v":6.25},6,5.2694642857142862,5.1378571428571425,5.2036607142857143,14,"متوسط","ينتقل"]
[{"$f":"IF(info!$A41=\"\",\"\",info!$A41)","v":""},{"$f":"IF($A36=\"\",\"\",info!$F41)","v":""},{"$f":"IF($A36=\"\",\"\",info!$C41)","v":""},{"$f":"IF('sem1'!V35=\"\",\"\",'sem1'!V35)","v":""},{"$f":"IF('sem2'!V35=\"\",\"\",'sem2'!V35)","v":""},"",{"$f":"IF('sem1'!Y35=\"\",\"\",'sem1'!Y35)","v":""},{"$f":"IF('sem2'!Y35=\"\",\"\",'sem2'!Y35)","v":""},"",{"$f":"IF('sem1'!AD35=\"\",\"\",'sem1'!AD35)","v":""},{"$f":"IF('sem2'!AD35=\"\",\"\",'sem2'!AD35)","v":""},"",{"$f":"IF('sem1'!AG35=\"\",\"\",'sem1'!AG35)","v":""},{"$f":"IF('sem2'!AG35=\"\",\"\",'sem2'!AG35)","v":""},"",{"$f":"IF('sem1'!AJ35=\"\",\"\",'sem1'!AJ35)","v":""},{"$f":"IF('sem2'!AJ35=\"\",\"\",'sem2'!AJ35)","v":""},"",{"$f":"IF('sem1'!AM35=\"\",\"\",'sem1'!AM35)","v":""},{"$f":"IF('sem2'!AM35=\"\",\"\",'sem2'!AM35)","v":""},"",{"$f":"IF('sem1'!AP35=\"\",\"\",'sem1'!AP35)","v":""},{"$f":"IF('sem2'!AP35=\"\",\"\",'sem2'!AP35)","v":""},"",{"$f":"IF('sem1'!AS35=\"\",\"\",'sem1'!AS35)","v":""},{"$f":"IF('sem2'!AS35=\"\",\"\",'sem2'!AS35)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A42=\"\",\"\",info!$A42)","v":""},{"$f":"IF($A37=\"\",\"\",info!$F42)","v":""},{"$f":"IF($A37=\"\",\"\",info!$C42)","v":""},{"$f":"IF('sem1'!V36=\"\",\"\",'sem1'!V36)","v":""},{"$f":"IF('sem2'!V36=\"\",\"\",'sem2'!V36)","v":""},"",{"$f":"IF('sem1'!Y36=\"\",\"\",'sem1'!Y36)","v":""},{"$f":"IF('sem2'!Y36=\"\",\"\",'sem2'!Y36)","v":""},"",{"$f":"IF('sem1'!AD36=\"\",\"\",'sem1'!AD36)","v":""},{"$f":"IF('sem2'!AD36=\"\",\"\",'sem2'!AD36)","v":""},"",{"$f":"IF('sem1'!AG36=\"\",\"\",'sem1'!AG36)","v":""},{"$f":"IF('sem2'!AG36=\"\",\"\",'sem2'!AG36)","v":""},"",{"$f":"IF('sem1'!AJ36=\"\",\"\",'sem1'!AJ36)","v":""},{"$f":"IF('sem2'!AJ36=\"\",\"\",'sem2'!AJ36)","v":""},"",{"$f":"IF('sem1'!AM36=\"\",\"\",'sem1'!AM36)","v":""},{"$f":"IF('sem2'!AM36=\"\",\"\",'sem2'!AM36)","v":""},"",{"$f":"IF('sem1'!AP36=\"\",\"\",'sem1'!AP36)","v":""},{"$f":"IF('sem2'!AP36=\"\",\"\",'sem2'!AP36)","v":""},"",{"$f":"IF('sem1'!AS36=\"\",\"\",'sem1'!AS36)","v":""},{"$f":"IF('sem2'!AS36=\"\",\"\",'sem2'!AS36)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A43=\"\",\"\",info!$A43)","v":""},{"$f":"IF($A38=\"\",\"\",info!$F43)","v":""},{"$f":"IF($A38=\"\",\"\",info!$C43)","v":""},{"$f":"IF('sem1'!V37=\"\",\"\",'sem1'!V37)","v":""},{"$f":"IF('sem2'!V37=\"\",\"\",'sem2'!V37)","v":""},"",{"$f":"IF('sem1'!Y37=\"\",\"\",'sem1'!Y37)","v":""},{"$f":"IF('sem2'!Y37=\"\",\"\",'sem2'!Y37)","v":""},"",{"$f":"IF('sem1'!AD37=\"\",\"\",'sem1'!AD37)","v":""},{"$f":"IF('sem2'!AD37=\"\",\"\",'sem2'!AD37)","v":""},"",{"$f":"IF('sem1'!AG37=\"\",\"\",'sem1'!AG37)","v":""},{"$f":"IF('sem2'!AG37=\"\",\"\",'sem2'!AG37)","v":""},"",{"$f":"IF('sem1'!AJ37=\"\",\"\",'sem1'!AJ37)","v":""},{"$f":"IF('sem2'!AJ37=\"\",\"\",'sem2'!AJ37)","v":""},"",{"$f":"IF('sem1'!AM37=\"\",\"\",'sem1'!AM37)","v":""},{"$f":"IF('sem2'!AM37=\"\",\"\",'sem2'!AM37)","v":""},"",{"$f":"IF('sem1'!AP37=\"\",\"\",'sem1'!AP37)","v":""},{"$f":"IF('sem2'!AP37=\"\",\"\",'sem2'!AP37)","v":""},"",{"$f":"IF('sem1'!AS37=\"\",\"\",'sem1'!AS37)","v":""},{"$f":"IF('sem2'!AS37=\"\",\"\",'sem2'!AS37)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A44=\"\",\"\",info!$A44)","v":""},{"$f":"IF($A39=\"\",\"\",info!$F44)","v":""},{"$f":"IF($A39=\"\",\"\",info!$C44)","v":""},{"$f":"IF('sem1'!V38=\"\",\"\",'sem1'!V38)","v":""},{"$f":"IF('sem2'!V38=\"\",\"\",'sem2'!V38)","v":""},"",{"$f":"IF('sem1'!Y38=\"\",\"\",'sem1'!Y38)","v":""},{"$f":"IF('sem2'!Y38=\"\",\"\",'sem2'!Y38)","v":""},"",{"$f":"IF('sem1'!AD38=\"\",\"\",'sem1'!AD38)","v":""},{"$f":"IF('sem2'!AD38=\"\",\"\",'sem2'!AD38)","v":""},"",{"$f":"IF('sem1'!AG38=\"\",\"\",'sem1'!AG38)","v":""},{"$f":"IF('sem2'!AG38=\"\",\"\",'sem2'!AG38)","v":""},"",{"$f":"IF('sem1'!AJ38=\"\",\"\",'sem1'!AJ38)","v":""},{"$f":"IF('sem2'!AJ38=\"\",\"\",'sem2'!AJ38)","v":""},"",{"$f":"IF('sem1'!AM38=\"\",\"\",'sem1'!AM38)","v":""},{"$f":"IF('sem2'!AM38=\"\",\"\",'sem2'!AM38)","v":""},"",{"$f":"IF('sem1'!AP38=\"\",\"\",'sem1'!AP38)","v":""},{"$f":"IF('sem2'!AP38=\"\",\"\",'sem2'!AP38)","v":""},"",{"$f":"IF('sem1'!AS38=\"\",\"\",'sem1'!AS38)","v":""},{"$f":"IF('sem2'!AS38=\"\",\"\",'sem2'!AS38)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A45=\"\",\"\",info!$A45)","v":""},{"$f":"IF($A40=\"\",\"\",info!$F45)","v":""},{"$f":"IF($A40=\"\",\"\",info!$C45)","v":""},{"$f":"IF('sem1'!V39=\"\",\"\",'sem1'!V39)","v":""},{"$f":"IF('sem2'!V39=\"\",\"\",'sem2'!V39)","v":""},"",{"$f":"IF('sem1'!Y39=\"\",\"\",'sem1'!Y39)","v":""},{"$f":"IF('sem2'!Y39=\"\",\"\",'sem2'!Y39)","v":""},"",{"$f":"IF('sem1'!AD39=\"\",\"\",'sem1'!AD39)","v":""},{"$f":"IF('sem2'!AD39=\"\",\"\",'sem2'!AD39)","v":""},"",{"$f":"IF('sem1'!AG39=\"\",\"\",'sem1'!AG39)","v":""},{"$f":"IF('sem2'!AG39=\"\",\"\",'sem2'!AG39)","v":""},"",{"$f":"IF('sem1'!AJ39=\"\",\"\",'sem1'!AJ39)","v":""},{"$f":"IF('sem2'!AJ39=\"\",\"\",'sem2'!AJ39)","v":""},"",{"$f":"IF('sem1'!AM39=\"\",\"\",'sem1'!AM39)","v":""},{"$f":"IF('sem2'!AM39=\"\",\"\",'sem2'!AM39)","v":""},"",{"$f":"IF('sem1'!AP39=\"\",\"\",'sem1'!AP39)","v":""},{"$f":"IF('sem2'!AP39=\"\",\"\",'sem2'!AP39)","v":""},"",{"$f":"IF('sem1'!AS39=\"\",\"\",'sem1'!AS39)","v":""},{"$f":"IF('sem2'!AS39=\"\",\"\",'sem2'!AS39)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A46=\"\",\"\",info!$A46)","v":""},{"$f":"IF($A41=\"\",\"\",info!$F46)","v":""},{"$f":"IF($A41=\"\",\"\",info!$C46)","v":""},{"$f":"IF('sem1'!V40=\"\",\"\",'sem1'!V40)","v":""},{"$f":"IF('sem2'!V40=\"\",\"\",'sem2'!V40)","v":""},"",{"$f":"IF('sem1'!Y40=\"\",\"\",'sem1'!Y40)","v":""},{"$f":"IF('sem2'!Y40=\"\",\"\",'sem2'!Y40)","v":""},"",{"$f":"IF('sem1'!AD40=\"\",\"\",'sem1'!AD40)","v":""},{"$f":"IF('sem2'!AD40=\"\",\"\",'sem2'!AD40)","v":""},"",{"$f":"IF('sem1'!AG40=\"\",\"\",'sem1'!AG40)","v":""},{"$f":"IF('sem2'!AG40=\"\",\"\",'sem2'!AG40)","v":""},"",{"$f":"IF('sem1'!AJ40=\"\",\"\",'sem1'!AJ40)","v":""},{"$f":"IF('sem2'!AJ40=\"\",\"\",'sem2'!AJ40)","v":""},"",{"$f":"IF('sem1'!AM40=\"\",\"\",'sem1'!AM40)","v":""},{"$f":"IF('sem2'!AM40=\"\",\"\",'sem2'!AM40)","v":""},"",{"$f":"IF('sem1'!AP40=\"\",\"\",'sem1'!AP40)","v":""},{"$f":"IF('sem2'!AP40=\"\",\"\",'sem2'!AP40)","v":""},"",{"$f":"IF('sem1'!AS40=\"\",\"\",'sem1'!AS40)","v":""},{"$f":"IF('sem2'!AS40=\"\",\"\",'sem2'!AS40)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A47=\"\",\"\",info!$A47)","v":""},{"$f":"IF($A42=\"\",\"\",info!$F47)","v":""},{"$f":"IF($A42=\"\",\"\",info!$C47)","v":""},{"$f":"IF('sem1'!V41=\"\",\"\",'sem1'!V41)","v":""},{"$f":"IF('sem2'!V41=\"\",\"\",'sem2'!V41)","v":""},"",{"$f":"IF('sem1'!Y41=\"\",\"\",'sem1'!Y41)","v":""},{"$f":"IF('sem2'!Y41=\"\",\"\",'sem2'!Y41)","v":""},"",{"$f":"IF('sem1'!AD41=\"\",\"\",'sem1'!AD41)","v":""},{"$f":"IF('sem2'!AD41=\"\",\"\",'sem2'!AD41)","v":""},"",{"$f":"IF('sem1'!AG41=\"\",\"\",'sem1'!AG41)","v":""},{"$f":"IF('sem2'!AG41=\"\",\"\",'sem2'!AG41)","v":""},"",{"$f":"IF('sem1'!AJ41=\"\",\"\",'sem1'!AJ41)","v":""},{"$f":"IF('sem2'!AJ41=\"\",\"\",'sem2'!AJ41)","v":""},"",{"$f":"IF('sem1'!AM41=\"\",\"\",'sem1'!AM41)","v":""},{"$f":"IF('sem2'!AM41=\"\",\"\",'sem2'!AM41)","v":""},"",{"$f":"IF('sem1'!AP41=\"\",\"\",'sem1'!AP41)","v":""},{"$f":"IF('sem2'!AP41=\"\",\"\",'sem2'!AP41)","v":""},"",{"$f":"IF('sem1'!AS41=\"\",\"\",'sem1'!AS41)","v":""},{"$f":"IF('sem2'!AS41=\"\",\"\",'sem2'!AS41)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A48=\"\",\"\",info!$A48)","v":""},{"$f":"IF($A43=\"\",\"\",info!$F48)","v":""},{"$f":"IF($A43=\"\",\"\",info!$C48)","v":""},{"$f":"IF('sem1'!V42=\"\",\"\",'sem1'!V42)","v":""},{"$f":"IF('sem2'!V42=\"\",\"\",'sem2'!V42)","v":""},"",{"$f":"IF('sem1'!Y42=\"\",\"\",'sem1'!Y42)","v":""},{"$f":"IF('sem2'!Y42=\"\",\"\",'sem2'!Y42)","v":""},"",{"$f":"IF('sem1'!AD42=\"\",\"\",'sem1'!AD42)","v":""},{"$f":"IF('sem2'!AD42=\"\",\"\",'sem2'!AD42)","v":""},"",{"$f":"IF('sem1'!AG42=\"\",\"\",'sem1'!AG42)","v":""},{"$f":"IF('sem2'!AG42=\"\",\"\",'sem2'!AG42)","v":""},"",{"$f":"IF('sem1'!AJ42=\"\",\"\",'sem1'!AJ42)","v":""},{"$f":"IF('sem2'!AJ42=\"\",\"\",'sem2'!AJ42)","v":""},"",{"$f":"IF('sem1'!AM42=\"\",\"\",'sem1'!AM42)","v":""},{"$f":"IF('sem2'!AM42=\"\",\"\",'sem2'!AM42)","v":""},"",{"$f":"IF('sem1'!AP42=\"\",\"\",'sem1'!AP42)","v":""},{"$f":"IF('sem2'!AP42=\"\",\"\",'sem2'!AP42)","v":""},"",{"$f":"IF('sem1'!AS42=\"\",\"\",'sem1'!AS42)","v":""},{"$f":"IF('sem2'!AS42=\"\",\"\",'sem2'!AS42)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A49=\"\",\"\",info!$A49)","v":""},{"$f":"IF($A44=\"\",\"\",info!$F49)","v":""},{"$f":"IF($A44=\"\",\"\",info!$C49)","v":""},{"$f":"IF('sem1'!V43=\"\",\"\",'sem1'!V43)","v":""},{"$f":"IF('sem2'!V43=\"\",\"\",'sem2'!V43)","v":""},"",{"$f":"IF('sem1'!Y43=\"\",\"\",'sem1'!Y43)","v":""},{"$f":"IF('sem2'!Y43=\"\",\"\",'sem2'!Y43)","v":""},"",{"$f":"IF('sem1'!AD43=\"\",\"\",'sem1'!AD43)","v":""},{"$f":"IF('sem2'!AD43=\"\",\"\",'sem2'!AD43)","v":""},"",{"$f":"IF('sem1'!AG43=\"\",\"\",'sem1'!AG43)","v":""},{"$f":"IF('sem2'!AG43=\"\",\"\",'sem2'!AG43)","v":""},"",{"$f":"IF('sem1'!AJ43=\"\",\"\",'sem1'!AJ43)","v":""},{"$f":"IF('sem2'!AJ43=\"\",\"\",'sem2'!AJ43)","v":""},"",{"$f":"IF('sem1'!AM43=\"\",\"\",'sem1'!AM43)","v":""},{"$f":"IF('sem2'!AM43=\"\",\"\",'sem2'!AM43)","v":""},"",{"$f":"IF('sem1'!AP43=\"\",\"\",'sem1'!AP43)","v":""},{"$f":"IF('sem2'!AP43=\"\",\"\",'sem2'!AP43)","v":""},"",{"$f":"IF('sem1'!AS43=\"\",\"\",'sem1'!AS43)","v":""},{"$f":"IF('sem2'!AS43=\"\",\"\",'sem2'!AS43)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A50=\"\",\"\",info!$A50)","v":""},{"$f":"IF($A45=\"\",\"\",info!$F50)","v":""},{"$f":"IF($A45=\"\",\"\",info!$C50)","v":""},{"$f":"IF('sem1'!V44=\"\",\"\",'sem1'!V44)","v":""},{"$f":"IF('sem2'!V44=\"\",\"\",'sem2'!V44)","v":""},"",{"$f":"IF('sem1'!Y44=\"\",\"\",'sem1'!Y44)","v":""},{"$f":"IF('sem2'!Y44=\"\",\"\",'sem2'!Y44)","v":""},"",{"$f":"IF('sem1'!AD44=\"\",\"\",'sem1'!AD44)","v":""},{"$f":"IF('sem2'!AD44=\"\",\"\",'sem2'!AD44)","v":""},"",{"$f":"IF('sem1'!AG44=\"\",\"\",'sem1'!AG44)","v":""},{"$f":"IF('sem2'!AG44=\"\",\"\",'sem2'!AG44)","v":""},"",{"$f":"IF('sem1'!AJ44=\"\",\"\",'sem1'!AJ44)","v":""},{"$f":"IF('sem2'!AJ44=\"\",\"\",'sem2'!AJ44)","v":""},"",{"$f":"IF('sem1'!AM44=\"\",\"\",'sem1'!AM44)","v":""},{"$f":"IF('sem2'!AM44=\"\",\"\",'sem2'!AM44)","v":""},"",{"$f":"IF('sem1'!AP44=\"\",\"\",'sem1'!AP44)","v":""},{"$f":"IF('sem2'!AP44=\"\",\"\",'sem2'!AP44)","v":""},"",{"$f":"IF('sem1'!AS44=\"\",\"\",'sem1'!AS44)","v":""},{"$f":"IF('sem2'!AS44=\"\",\"\",'sem2'!AS44)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A51=\"\",\"\",info!$A51)","v":""},{"$f":"IF($A46=\"\",\"\",info!$F51)","v":""},{"$f":"IF($A46=\"\",\"\",info!$C51)","v":""},{"$f":"IF('sem1'!V45=\"\",\"\",'sem1'!V45)","v":""},{"$f":"IF('sem2'!V45=\"\",\"\",'sem2'!V45)","v":""},"",{"$f":"IF('sem1'!Y45=\"\",\"\",'sem1'!Y45)","v":""},{"$f":"IF('sem2'!Y45=\"\",\"\",'sem2'!Y45)","v":""},"",{"$f":"IF('sem1'!AD45=\"\",\"\",'sem1'!AD45)","v":""},{"$f":"IF('sem2'!AD45=\"\",\"\",'sem2'!AD45)","v":""},"",{"$f":"IF('sem1'!AG45=\"\",\"\",'sem1'!AG45)","v":""},{"$f":"IF('sem2'!AG45=\"\",\"\",'sem2'!AG45)","v":""},"",{"$f":"IF('sem1'!AJ45=\"\",\"\",'sem1'!AJ45)","v":""},{"$f":"IF('sem2'!AJ45=\"\",\"\",'sem2'!AJ45)","v":""},"",{"$f":"IF('sem1'!AM45=\"\",\"\",'sem1'!AM45)","v":""},{"$f":"IF('sem2'!AM45=\"\",\"\",'sem2'!AM45)","v":""},"",{"$f":"IF('sem1'!AP45=\"\",\"\",'sem1'!AP45)","v":""},{"$f":"IF('sem2'!AP45=\"\",\"\",'sem2'!AP45)","v":""},"",{"$f":"IF('sem1'!AS45=\"\",\"\",'sem1'!AS45)","v":""},{"$f":"IF('sem2'!AS45=\"\",\"\",'sem2'!AS45)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A52=\"\",\"\",info!$A52)","v":""},{"$f":"IF($A47=\"\",\"\",info!$F52)","v":""},{"$f":"IF($A47=\"\",\"\",info!$C52)","v":""},{"$f":"IF('sem1'!V46=\"\",\"\",'sem1'!V46)","v":""},{"$f":"IF('sem2'!V46=\"\",\"\",'sem2'!V46)","v":""},"",{"$f":"IF('sem1'!Y46=\"\",\"\",'sem1'!Y46)","v":""},{"$f":"IF('sem2'!Y46=\"\",\"\",'sem2'!Y46)","v":""},"",{"$f":"IF('sem1'!AD46=\"\",\"\",'sem1'!AD46)","v":""},{"$f":"IF('sem2'!AD46=\"\",\"\",'sem2'!AD46)","v":""},"",{"$f":"IF('sem1'!AG46=\"\",\"\",'sem1'!AG46)","v":""},{"$f":"IF('sem2'!AG46=\"\",\"\",'sem2'!AG46)","v":""},"",{"$f":"IF('sem1'!AJ46=\"\",\"\",'sem1'!AJ46)","v":""},{"$f":"IF('sem2'!AJ46=\"\",\"\",'sem2'!AJ46)","v":""},"",{"$f":"IF('sem1'!AM46=\"\",\"\",'sem1'!AM46)","v":""},{"$f":"IF('sem2'!AM46=\"\",\"\",'sem2'!AM46)","v":""},"",{"$f":"IF('sem1'!AP46=\"\",\"\",'sem1'!AP46)","v":""},{"$f":"IF('sem2'!AP46=\"\",\"\",'sem2'!AP46)","v":""},"",{"$f":"IF('sem1'!AS46=\"\",\"\",'sem1'!AS46)","v":""},{"$f":"IF('sem2'!AS46=\"\",\"\",'sem2'!AS46)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A53=\"\",\"\",info!$A53)","v":""},{"$f":"IF($A48=\"\",\"\",info!$F53)","v":""},{"$f":"IF($A48=\"\",\"\",info!$C53)","v":""},{"$f":"IF('sem1'!V47=\"\",\"\",'sem1'!V47)","v":""},{"$f":"IF('sem2'!V47=\"\",\"\",'sem2'!V47)","v":""},"",{"$f":"IF('sem1'!Y47=\"\",\"\",'sem1'!Y47)","v":""},{"$f":"IF('sem2'!Y47=\"\",\"\",'sem2'!Y47)","v":""},"",{"$f":"IF('sem1'!AD47=\"\",\"\",'sem1'!AD47)","v":""},{"$f":"IF('sem2'!AD47=\"\",\"\",'sem2'!AD47)","v":""},"",{"$f":"IF('sem1'!AG47=\"\",\"\",'sem1'!AG47)","v":""},{"$f":"IF('sem2'!AG47=\"\",\"\",'sem2'!AG47)","v":""},"",{"$f":"IF('sem1'!AJ47=\"\",\"\",'sem1'!AJ47)","v":""},{"$f":"IF('sem2'!AJ47=\"\",\"\",'sem2'!AJ47)","v":""},"",{"$f":"IF('sem1'!AM47=\"\",\"\",'sem1'!AM47)","v":""},{"$f":"IF('sem2'!AM47=\"\",\"\",'sem2'!AM47)","v":""},"",{"$f":"IF('sem1'!AP47=\"\",\"\",'sem1'!AP47)","v":""},{"$f":"IF('sem2'!AP47=\"\",\"\",'sem2'!AP47)","v":""},"",{"$f":"IF('sem1'!AS47=\"\",\"\",'sem1'!AS47)","v":""},{"$f":"IF('sem2'!AS47=\"\",\"\",'sem2'!AS47)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A54=\"\",\"\",info!$A54)","v":""},{"$f":"IF($A49=\"\",\"\",info!$F54)","v":""},{"$f":"IF($A49=\"\",\"\",info!$C54)","v":""},{"$f":"IF('sem1'!V48=\"\",\"\",'sem1'!V48)","v":""},{"$f":"IF('sem2'!V48=\"\",\"\",'sem2'!V48)","v":""},"",{"$f":"IF('sem1'!Y48=\"\",\"\",'sem1'!Y48)","v":""},{"$f":"IF('sem2'!Y48=\"\",\"\",'sem2'!Y48)","v":""},"",{"$f":"IF('sem1'!AD48=\"\",\"\",'sem1'!AD48)","v":""},{"$f":"IF('sem2'!AD48=\"\",\"\",'sem2'!AD48)","v":""},"",{"$f":"IF('sem1'!AG48=\"\",\"\",'sem1'!AG48)","v":""},{"$f":"IF('sem2'!AG48=\"\",\"\",'sem2'!AG48)","v":""},"",{"$f":"IF('sem1'!AJ48=\"\",\"\",'sem1'!AJ48)","v":""},{"$f":"IF('sem2'!AJ48=\"\",\"\",'sem2'!AJ48)","v":""},"",{"$f":"IF('sem1'!AM48=\"\",\"\",'sem1'!AM48)","v":""},{"$f":"IF('sem2'!AM48=\"\",\"\",'sem2'!AM48)","v":""},"",{"$f":"IF('sem1'!AP48=\"\",\"\",'sem1'!AP48)","v":""},{"$f":"IF('sem2'!AP48=\"\",\"\",'sem2'!AP48)","v":""},"",{"$f":"IF('sem1'!AS48=\"\",\"\",'sem1'!AS48)","v":""},{"$f":"IF('sem2'!AS48=\"\",\"\",'sem2'!AS48)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A55=\"\",\"\",info!$A55)","v":""},{"$f":"IF($A50=\"\",\"\",info!$F55)","v":""},{"$f":"IF($A50=\"\",\"\",info!$C55)","v":""},{"$f":"IF('sem1'!V49=\"\",\"\",'sem1'!V49)","v":""},{"$f":"IF('sem2'!V49=\"\",\"\",'sem2'!V49)","v":""},"",{"$f":"IF('sem1'!Y49=\"\",\"\",'sem1'!Y49)","v":""},{"$f":"IF('sem2'!Y49=\"\",\"\",'sem2'!Y49)","v":""},"",{"$f":"IF('sem1'!AD49=\"\",\"\",'sem1'!AD49)","v":""},{"$f":"IF('sem2'!AD49=\"\",\"\",'sem2'!AD49)","v":""},"",{"$f":"IF('sem1'!AG49=\"\",\"\",'sem1'!AG49)","v":""},{"$f":"IF('sem2'!AG49=\"\",\"\",'sem2'!AG49)","v":""},"",{"$f":"IF('sem1'!AJ49=\"\",\"\",'sem1'!AJ49)","v":""},{"$f":"IF('sem2'!AJ49=\"\",\"\",'sem2'!AJ49)","v":""},"",{"$f":"IF('sem1'!AM49=\"\",\"\",'sem1'!AM49)","v":""},{"$f":"IF('sem2'!AM49=\"\",\"\",'sem2'!AM49)","v":""},"",{"$f":"IF('sem1'!AP49=\"\",\"\",'sem1'!AP49)","v":""},{"$f":"IF('sem2'!AP49=\"\",\"\",'sem2'!AP49)","v":""},"",{"$f":"IF('sem1'!AS49=\"\",\"\",'sem1'!AS49)","v":""},{"$f":"IF('sem2'!AS49=\"\",\"\",'sem2'!AS49)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A56=\"\",\"\",info!$A56)","v":""},{"$f":"IF($A51=\"\",\"\",info!$F56)","v":""},{"$f":"IF($A51=\"\",\"\",info!$C56)","v":""},{"$f":"IF('sem1'!V50=\"\",\"\",'sem1'!V50)","v":""},{"$f":"IF('sem2'!V50=\"\",\"\",'sem2'!V50)","v":""},"",{"$f":"IF('sem1'!Y50=\"\",\"\",'sem1'!Y50)","v":""},{"$f":"IF('sem2'!Y50=\"\",\"\",'sem2'!Y50)","v":""},"",{"$f":"IF('sem1'!AD50=\"\",\"\",'sem1'!AD50)","v":""},{"$f":"IF('sem2'!AD50=\"\",\"\",'sem2'!AD50)","v":""},"",{"$f":"IF('sem1'!AG50=\"\",\"\",'sem1'!AG50)","v":""},{"$f":"IF('sem2'!AG50=\"\",\"\",'sem2'!AG50)","v":""},"",{"$f":"IF('sem1'!AJ50=\"\",\"\",'sem1'!AJ50)","v":""},{"$f":"IF('sem2'!AJ50=\"\",\"\",'sem2'!AJ50)","v":""},"",{"$f":"IF('sem1'!AM50=\"\",\"\",'sem1'!AM50)","v":""},{"$f":"IF('sem2'!AM50=\"\",\"\",'sem2'!AM50)","v":""},"",{"$f":"IF('sem1'!AP50=\"\",\"\",'sem1'!AP50)","v":""},{"$f":"IF('sem2'!AP50=\"\",\"\",'sem2'!AP50)","v":""},"",{"$f":"IF('sem1'!AS50=\"\",\"\",'sem1'!AS50)","v":""},{"$f":"IF('sem2'!AS50=\"\",\"\",'sem2'!AS50)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A57=\"\",\"\",info!$A57)","v":""},{"$f":"IF($A52=\"\",\"\",info!$F57)","v":""},{"$f":"IF($A52=\"\",\"\",info!$C57)","v":""},{"$f":"IF('sem1'!V51=\"\",\"\",'sem1'!V51)","v":""},{"$f":"IF('sem2'!V51=\"\",\"\",'sem2'!V51)","v":""},"",{"$f":"IF('sem1'!Y51=\"\",\"\",'sem1'!Y51)","v":""},{"$f":"IF('sem2'!Y51=\"\",\"\",'sem2'!Y51)","v":""},"",{"$f":"IF('sem1'!AD51=\"\",\"\",'sem1'!AD51)","v":""},{"$f":"IF('sem2'!AD51=\"\",\"\",'sem2'!AD51)","v":""},"",{"$f":"IF('sem1'!AG51=\"\",\"\",'sem1'!AG51)","v":""},{"$f":"IF('sem2'!AG51=\"\",\"\",'sem2'!AG51)","v":""},"",{"$f":"IF('sem1'!AJ51=\"\",\"\",'sem1'!AJ51)","v":""},{"$f":"IF('sem2'!AJ51=\"\",\"\",'sem2'!AJ51)","v":""},"",{"$f":"IF('sem1'!AM51=\"\",\"\",'sem1'!AM51)","v":""},{"$f":"IF('sem2'!AM51=\"\",\"\",'sem2'!AM51)","v":""},"",{"$f":"IF('sem1'!AP51=\"\",\"\",'sem1'!AP51)","v":""},{"$f":"IF('sem2'!AP51=\"\",\"\",'sem2'!AP51)","v":""},"",{"$f":"IF('sem1'!AS51=\"\",\"\",'sem1'!AS51)","v":""},{"$f":"IF('sem2'!AS51=\"\",\"\",'sem2'!AS51)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A58=\"\",\"\",info!$A58)","v":""},{"$f":"IF($A53=\"\",\"\",info!$F58)","v":""},{"$f":"IF($A53=\"\",\"\",info!$C58)","v":""},{"$f":"IF('sem1'!V52=\"\",\"\",'sem1'!V52)","v":""},{"$f":"IF('sem2'!V52=\"\",\"\",'sem2'!V52)","v":""},"",{"$f":"IF('sem1'!Y52=\"\",\"\",'sem1'!Y52)","v":""},{"$f":"IF('sem2'!Y52=\"\",\"\",'sem2'!Y52)","v":""},"",{"$f":"IF('sem1'!AD52=\"\",\"\",'sem1'!AD52)","v":""},{"$f":"IF('sem2'!AD52=\"\",\"\",'sem2'!AD52)","v":""},"",{"$f":"IF('sem1'!AG52=\"\",\"\",'sem1'!AG52)","v":""},{"$f":"IF('sem2'!AG52=\"\",\"\",'sem2'!AG52)","v":""},"",{"$f":"IF('sem1'!AJ52=\"\",\"\",'sem1'!AJ52)","v":""},{"$f":"IF('sem2'!AJ52=\"\",\"\",'sem2'!AJ52)","v":""},"",{"$f":"IF('sem1'!AM52=\"\",\"\",'sem1'!AM52)","v":""},{"$f":"IF('sem2'!AM52=\"\",\"\",'sem2'!AM52)","v":""},"",{"$f":"IF('sem1'!AP52=\"\",\"\",'sem1'!AP52)","v":""},{"$f":"IF('sem2'!AP52=\"\",\"\",'sem2'!AP52)","v":""},"",{"$f":"IF('sem1'!AS52=\"\",\"\",'sem1'!AS52)","v":""},{"$f":"IF('sem2'!AS52=\"\",\"\",'sem2'!AS52)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A59=\"\",\"\",info!$A59)","v":""},{"$f":"IF($A54=\"\",\"\",info!$F59)","v":""},{"$f":"IF($A54=\"\",\"\",info!$C59)","v":""},{"$f":"IF('sem1'!V53=\"\",\"\",'sem1'!V53)","v":""},{"$f":"IF('sem2'!V53=\"\",\"\",'sem2'!V53)","v":""},"",{"$f":"IF('sem1'!Y53=\"\",\"\",'sem1'!Y53)","v":""},{"$f":"IF('sem2'!Y53=\"\",\"\",'sem2'!Y53)","v":""},"",{"$f":"IF('sem1'!AD53=\"\",\"\",'sem1'!AD53)","v":""},{"$f":"IF('sem2'!AD53=\"\",\"\",'sem2'!AD53)","v":""},"",{"$f":"IF('sem1'!AG53=\"\",\"\",'sem1'!AG53)","v":""},{"$f":"IF('sem2'!AG53=\"\",\"\",'sem2'!AG53)","v":""},"",{"$f":"IF('sem1'!AJ53=\"\",\"\",'sem1'!AJ53)","v":""},{"$f":"IF('sem2'!AJ53=\"\",\"\",'sem2'!AJ53)","v":""},"",{"$f":"IF('sem1'!AM53=\"\",\"\",'sem1'!AM53)","v":""},{"$f":"IF('sem2'!AM53=\"\",\"\",'sem2'!AM53)","v":""},"",{"$f":"IF('sem1'!AP53=\"\",\"\",'sem1'!AP53)","v":""},{"$f":"IF('sem2'!AP53=\"\",\"\",'sem2'!AP53)","v":""},"",{"$f":"IF('sem1'!AS53=\"\",\"\",'sem1'!AS53)","v":""},{"$f":"IF('sem2'!AS53=\"\",\"\",'sem2'!AS53)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A60=\"\",\"\",info!$A60)","v":""},{"$f":"IF($A55=\"\",\"\",info!$F60)","v":""},{"$f":"IF($A55=\"\",\"\",info!$C60)","v":""},{"$f":"IF('sem1'!V54=\"\",\"\",'sem1'!V54)","v":""},{"$f":"IF('sem2'!V54=\"\",\"\",'sem2'!V54)","v":""},"",{"$f":"IF('sem1'!Y54=\"\",\"\",'sem1'!Y54)","v":""},{"$f":"IF('sem2'!Y54=\"\",\"\",'sem2'!Y54)","v":""},"",{"$f":"IF('sem1'!AD54=\"\",\"\",'sem1'!AD54)","v":""},{"$f":"IF('sem2'!AD54=\"\",\"\",'sem2'!AD54)","v":""},"",{"$f":"IF('sem1'!AG54=\"\",\"\",'sem1'!AG54)","v":""},{"$f":"IF('sem2'!AG54=\"\",\"\",'sem2'!AG54)","v":""},"",{"$f":"IF('sem1'!AJ54=\"\",\"\",'sem1'!AJ54)","v":""},{"$f":"IF('sem2'!AJ54=\"\",\"\",'sem2'!AJ54)","v":""},"",{"$f":"IF('sem1'!AM54=\"\",\"\",'sem1'!AM54)","v":""},{"$f":"IF('sem2'!AM54=\"\",\"\",'sem2'!AM54)","v":""},"",{"$f":"IF('sem1'!AP54=\"\",\"\",'sem1'!AP54)","v":""},{"$f":"IF('sem2'!AP54=\"\",\"\",'sem2'!AP54)","v":""},"",{"$f":"IF('sem1'!AS54=\"\",\"\",'sem1'!AS54)","v":""},{"$f":"IF('sem2'!AS54=\"\",\"\",'sem2'!AS54)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A61=\"\",\"\",info!$A61)","v":""},{"$f":"IF($A56=\"\",\"\",info!$F61)","v":""},{"$f":"IF($A56=\"\",\"\",info!$C61)","v":""},{"$f":"IF('sem1'!V55=\"\",\"\",'sem1'!V55)","v":""},{"$f":"IF('sem2'!V55=\"\",\"\",'sem2'!V55)","v":""},"",{"$f":"IF('sem1'!Y55=\"\",\"\",'sem1'!Y55)","v":""},{"$f":"IF('sem2'!Y55=\"\",\"\",'sem2'!Y55)","v":""},"",{"$f":"IF('sem1'!AD55=\"\",\"\",'sem1'!AD55)","v":""},{"$f":"IF('sem2'!AD55=\"\",\"\",'sem2'!AD55)","v":""},"",{"$f":"IF('sem1'!AG55=\"\",\"\",'sem1'!AG55)","v":""},{"$f":"IF('sem2'!AG55=\"\",\"\",'sem2'!AG55)","v":""},"",{"$f":"IF('sem1'!AJ55=\"\",\"\",'sem1'!AJ55)","v":""},{"$f":"IF('sem2'!AJ55=\"\",\"\",'sem2'!AJ55)","v":""},"",{"$f":"IF('sem1'!AM55=\"\",\"\",'sem1'!AM55)","v":""},{"$f":"IF('sem2'!AM55=\"\",\"\",'sem2'!AM55)","v":""},"",{"$f":"IF('sem1'!AP55=\"\",\"\",'sem1'!AP55)","v":""},{"$f":"IF('sem2'!AP55=\"\",\"\",'sem2'!AP55)","v":""},"",{"$f":"IF('sem1'!AS55=\"\",\"\",'sem1'!AS55)","v":""},{"$f":"IF('sem2'!AS55=\"\",\"\",'sem2'!AS55)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A62=\"\",\"\",info!$A62)","v":""},{"$f":"IF($A57=\"\",\"\",info!$F62)","v":""},{"$f":"IF($A57=\"\",\"\",info!$C62)","v":""},{"$f":"IF('sem1'!V56=\"\",\"\",'sem1'!V56)","v":""},{"$f":"IF('sem2'!V56=\"\",\"\",'sem2'!V56)","v":""},"",{"$f":"IF('sem1'!Y56=\"\",\"\",'sem1'!Y56)","v":""},{"$f":"IF('sem2'!Y56=\"\",\"\",'sem2'!Y56)","v":""},"",{"$f":"IF('sem1'!AD56=\"\",\"\",'sem1'!AD56)","v":""},{"$f":"IF('sem2'!AD56=\"\",\"\",'sem2'!AD56)","v":""},"",{"$f":"IF('sem1'!AG56=\"\",\"\",'sem1'!AG56)","v":""},{"$f":"IF('sem2'!AG56=\"\",\"\",'sem2'!AG56)","v":""},"",{"$f":"IF('sem1'!AJ56=\"\",\"\",'sem1'!AJ56)","v":""},{"$f":"IF('sem2'!AJ56=\"\",\"\",'sem2'!AJ56)","v":""},"",{"$f":"IF('sem1'!AM56=\"\",\"\",'sem1'!AM56)","v":""},{"$f":"IF('sem2'!AM56=\"\",\"\",'sem2'!AM56)","v":""},"",{"$f":"IF('sem1'!AP56=\"\",\"\",'sem1'!AP56)","v":""},{"$f":"IF('sem2'!AP56=\"\",\"\",'sem2'!AP56)","v":""},"",{"$f":"IF('sem1'!AS56=\"\",\"\",'sem1'!AS56)","v":""},{"$f":"IF('sem2'!AS56=\"\",\"\",'sem2'!AS56)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A63=\"\",\"\",info!$A63)","v":""},{"$f":"IF($A58=\"\",\"\",info!$F63)","v":""},{"$f":"IF($A58=\"\",\"\",info!$C63)","v":""},{"$f":"IF('sem1'!V57=\"\",\"\",'sem1'!V57)","v":""},{"$f":"IF('sem2'!V57=\"\",\"\",'sem2'!V57)","v":""},"",{"$f":"IF('sem1'!Y57=\"\",\"\",'sem1'!Y57)","v":""},{"$f":"IF('sem2'!Y57=\"\",\"\",'sem2'!Y57)","v":""},"",{"$f":"IF('sem1'!AD57=\"\",\"\",'sem1'!AD57)","v":""},{"$f":"IF('sem2'!AD57=\"\",\"\",'sem2'!AD57)","v":""},"",{"$f":"IF('sem1'!AG57=\"\",\"\",'sem1'!AG57)","v":""},{"$f":"IF('sem2'!AG57=\"\",\"\",'sem2'!AG57)","v":""},"",{"$f":"IF('sem1'!AJ57=\"\",\"\",'sem1'!AJ57)","v":""},{"$f":"IF('sem2'!AJ57=\"\",\"\",'sem2'!AJ57)","v":""},"",{"$f":"IF('sem1'!AM57=\"\",\"\",'sem1'!AM57)","v":""},{"$f":"IF('sem2'!AM57=\"\",\"\",'sem2'!AM57)","v":""},"",{"$f":"IF('sem1'!AP57=\"\",\"\",'sem1'!AP57)","v":""},{"$f":"IF('sem2'!AP57=\"\",\"\",'sem2'!AP57)","v":""},"",{"$f":"IF('sem1'!AS57=\"\",\"\",'sem1'!AS57)","v":""},{"$f":"IF('sem2'!AS57=\"\",\"\",'sem2'!AS57)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A64=\"\",\"\",info!$A64)","v":""},{"$f":"IF($A59=\"\",\"\",info!$F64)","v":""},{"$f":"IF($A59=\"\",\"\",info!$C64)","v":""},{"$f":"IF('sem1'!V58=\"\",\"\",'sem1'!V58)","v":""},{"$f":"IF('sem2'!V58=\"\",\"\",'sem2'!V58)","v":""},"",{"$f":"IF('sem1'!Y58=\"\",\"\",'sem1'!Y58)","v":""},{"$f":"IF('sem2'!Y58=\"\",\"\",'sem2'!Y58)","v":""},"",{"$f":"IF('sem1'!AD58=\"\",\"\",'sem1'!AD58)","v":""},{"$f":"IF('sem2'!AD58=\"\",\"\",'sem2'!AD58)","v":""},"",{"$f":"IF('sem1'!AG58=\"\",\"\",'sem1'!AG58)","v":""},{"$f":"IF('sem2'!AG58=\"\",\"\",'sem2'!AG58)","v":""},"",{"$f":"IF('sem1'!AJ58=\"\",\"\",'sem1'!AJ58)","v":""},{"$f":"IF('sem2'!AJ58=\"\",\"\",'sem2'!AJ58)","v":""},"",{"$f":"IF('sem1'!AM58=\"\",\"\",'sem1'!AM58)","v":""},{"$f":"IF('sem2'!AM58=\"\",\"\",'sem2'!AM58)","v":""},"",{"$f":"IF('sem1'!AP58=\"\",\"\",'sem1'!AP58)","v":""},{"$f":"IF('sem2'!AP58=\"\",\"\",'sem2'!AP58)","v":""},"",{"$f":"IF('sem1'!AS58=\"\",\"\",'sem1'!AS58)","v":""},{"$f":"IF('sem2'!AS58=\"\",\"\",'sem2'!AS58)","v":""},"","","","","","",""]
[{"$f":"IF(info!$A65=\"\",\"\",info!$A65)","v":""},{"$f":"IF($A60=\"\",\"\",info!$F65)","v":""},{"$f":"IF($A60=\"\",\"\",info!$C65)","v":""},{"$f":"IF('sem1'!V59=\"\",\"\",'sem1'!V59)","v":""},{"$f":"IF('sem2'!V59=\"\",\"\",'sem2'!V59)","v":""},"",{"$f":"IF('sem1'!Y59=\"\",\"\",'sem1'!Y59)","v":""},{"$f":"IF('sem2'!Y59=\"\",\"\",'sem2'!Y59)","v":""},"",{"$f":"IF('sem1'!AD59=\"\",\"\",'sem1'!AD59)","v":""},{"$f":"IF('sem2'!AD59=\"\",\"\",'sem2'!AD59)","v":""},"",{"$f":"IF('sem1'!AG59=\"\",\"\",'sem1'!AG59)","v":""},{"$f":"IF('sem2'!AG59=\"\",\"\",'sem2'!AG59)","v":""},"",{"$f":"IF('sem1'!AJ59=\"\",\"\",'sem1'!AJ59)","v":""},{"$f":"IF('sem2'!AJ59=\"\",\"\",'sem2'!AJ59)","v":""},"",{"$f":"IF('sem1'!AM59=\"\",\"\",'sem1'!AM59)","v":""},{"$f":"IF('sem2'!AM59=\"\",\"\",'sem2'!AM59)","v":""},"",{"$f":"IF('sem1'!AP59=\"\",\"\",'sem1'!AP59)","v":""},{"$f":"IF('sem2'!AP59=\"\",\"\",'sem2'!AP59)","v":""},"",{"$f":"IF('sem1'!AS59=\"\",\"\",'sem1'!AS59)","v":""},{"$f":"IF('sem2'!AS59=\"\",\"\",'sem2'!AS59)","v":""},"","","","","","",""]