{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Source","Cerificats"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Data","index":0,"n_rows":16,"n_cols":36,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,4,3,9],[3,22,3,27],[3,28,3,33],[1,4,1,21],[1,22,1,25],[3,10,3,15],[3,16,3,21]]}
[]
[null,null,null,null,"مسودة رصد الاختبارات الشهرية والنهائية للفصلين للعام الدراسي ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-2020",null,null,null,"للصف",null,null,"الأول",null,null,null,null,null,"للصف ( الأول )"]
[]
["م","اسم الطالب","النوع ","الجنسية ","القرآن الكريم ",null,null,null,null,null,"التربية الإسلامية ",null,null,null,null,null,"اللغة العربية ",null,null,null,null,null,"الرياضيات ",null,null,null,null,null,"العلوم"]
[null,null,null,null,"اكتوبر","نوفمبر","نهائي الفصل","يناير","فبراير","نهائي العام","اكتوبر","نوفمبر","نهائي الفصل","يناير","فبراير","نهائي العام","اكتوبر","نوفمبر","نهائي الفصل","يناير","فبراير","نهائي العام","اكتوبر","نوفمبر","نهائي الفصل","يناير","فبراير","نهائي العام","اكتوبر","نوفمبر","نهائي الفصل","يناير","فبراير","نهائي العام"]
[null,null,null,null,100,100,30,100,100,30,100,100,30,100,100,30,100,100,30,100,100,30,100,100,30,100,100,30,100,100,30,100,100,30]
[1,"تالين وهبي محمد الصهيبي","أنثى","يمنية ",70,66,30,null,null,null,74,66,30,null,null,null,95,96,30,null,null,null,63,72,30,null,null,null,84,71,30]
[2,"حسين زبن الله حسين دوح","ذكر","يمني ",90,61,30,null,null,null,68,74,30,null,null,null,85,65,30,null,null,null,60,83,30,null,null,null,72,82,30]
[3,"حنين ناصر علي معيض","أنثى","يمنية ",95,100,30,null,null,null,94,81,30,null,null,null,84,81,30,null,null,null,92,62,30,null,null,null,60,88,30]
[4,"رؤى صالح سالم معيض","أنثى","يمنية ",78,95,28,null,null,null,66,81,25,null,null,null,95,73,30,null,null,null,68,96,30,null,null,null,89,87,28]
[5,"سعيد محمد سالم بجنف","ذكر","يمني",96,82,30,null,null,null,96,82,30,null,null,null,98,75,30,null,null,null,93,97,30,null,null,null,71,79,30]
[6,"سند عبدالله صالح لنقس","ذكر","يمني",98,85,30,null,null,null,77,99,30,null,null,null,100,96,30,null,null,null,99,77,29,null,null,null,99,81,28]
[7,"طالب أنور حامد معيض","ذكر","يمني",80,91,30,null,null,null,93,85,30,null,null,null,74,95,30,null,null,null,66,86,30,null,null,null,77,100,30]
[8,"عماد ماجد مبارك حقروص","ذكر","يمني",67,79,30,null,null,null,69,95,30,null,null,null,60,78,30,null,null,null,92,63,29,null,null,null,92,61,30]
[9,"ناصر أحمد ناصر جلعوم","ذكر","يمني",76,78,25,null,null,null,89,98,30,null,null,null,76,99,30,null,null,null,64,89,29,null,null,null,70,100,28]
[10,"يوسف محمد سعيد حقروص","ذكر","يمني",84,70,30,null,null,null,68,72,27,null,null,null,91,83,30,null,null,null,85,64,30,null,null,null,71,63,30]

{"sheet":"Source","index":1,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,17,6,17],[5,18,7,18],[5,22,7,22],[3,3,4,15],[5,0,7,0],[5,1,7,1],[5,2,5,4],[5,5,5,7],[5,8,5,10],[5,11,5,13],[5,14,5,16]]}
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[]
[]
[null,null,null,"كشوفات رصد درجات أعمال وامتحانات الفصل الدراسي الأول في المرحلة الأساسية للعام الدراسي 2020 - 2021م "]
[]
["رقم مسلسل","اســـــــم الطالـــب ","القرآن الكريم ",null,null,"التربية الإسلامية ",null,null,"اللغة العربية ",null,null,"الرياضيات ",null,null,"العلوم ",null,null,"المجموع الكلي","نتيجة الفصل الأول",null,null,null,"الملاحظات "]
[null,null,"محصلة الفصل الأول","امتحان الفصل الأول","المجموع","محصلة الفصل الأول","امتحان الفصل الأول","المجموع","محصلة الفصل الأول","امتحان الفصل الأول","المجموع","محصلة الفصل الأول","امتحان الفصل الأول","المجموع","محصلة الفصل الأول","امتحان الفصل الأول","المجموع",null,null,null,null,"الترتيب"]
[null,null,20,30,50,20,30,50,20,30,50,20,30,50,20,30,50,250]
[1,{"$f":"Data!B7","v":"تالين وهبي محمد الصهيبي"},{"$f":"(Data!E7+Data!F7)/10","v":13.6},{"$f":"(Data!F7+Data!G7)/10","v":9.6},{"$f":"SUM(C9:D9)","v":23.2},{"$f":"(Data!K7+Data!L7)/10","v":14},{"$f":"(Data!L7+Data!M7)/10","v":9.6},{"$f":"SUM(F9:G9)","v":23.6},{"$f":"(Data!Q7+Data!R7)/10","v":19.100000000000001},{"$f":"(Data!R7+Data!S7)/10","v":12.6},{"$f":"SUM(I9:J9)","v":31.700000000000003},{"$f":"(Data!W7+Data!X7)/10","v":13.5},{"$f":"(Data!X7+Data!Y7)/10","v":10.199999999999999},{"$f":"SUM(L9:M9)","v":23.7},{"$f":"(Data!AC7+Data!AD7)/10","v":15.5},{"$f":"(Data!AD7+Data!AE7)/10","v":10.1},{"$f":"SUM(O9:P9)","v":25.6},{"$f":"SUM(Q9,N9,K9,H9,E9)","v":127.8},{"$f":"IF(AND(Q9>=25,N9>=25,K9>=25,H9>=25,E9>=25),\"ناجح\",\"راسب\")","v":"راسب"},null,{"$f":"SUMPRODUCT((R9<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":8},{"$f":"IF(S9=\"راسب\",\"راسب\",Order_Salim(U9))","v":"راسب"}]
[2,{"$f":"Data!B8","v":"حسين زبن الله حسين دوح"},{"$f":"(Data!E8+Data!F8)/10","v":15.1},{"$f":"(Data!F8+Data!G8)/10","v":9.1},{"$f":"SUM(C10:D10)","v":24.2},{"$f":"(Data!K8+Data!L8)/10","v":14.2},{"$f":"(Data!L8+Data!M8)/10","v":10.4},{"$f":"SUM(F10:G10)","v":24.6},{"$f":"(Data!Q8+Data!R8)/10","v":15},{"$f":"(Data!R8+Data!S8)/10","v":9.5},{"$f":"SUM(I10:J10)","v":24.5},{"$f":"(Data!W8+Data!X8)/10","v":14.3},{"$f":"(Data!X8+Data!Y8)/10","v":11.3},{"$f":"SUM(L10:M10)","v":25.6},{"$f":"(Data!AC8+Data!AD8)/10","v":15.4},{"$f":"(Data!AD8+Data!AE8)/10","v":11.2},{"$f":"SUM(O10:P10)","v":26.6},{"$f":"SUM(Q10,N10,K10,H10,E10)","v":125.50000000000001},{"$f":"IF(AND(Q10>=25,N10>=25,K10>=25,H10>=25,E10>=25),\"ناجح\",\"راسب\")","v":"راسب"},null,{"$f":"SUMPRODUCT((R10<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":9},{"$f":"IF(S10=\"راسب\",\"راسب\",Order_Salim(U10))","v":"راسب"}]
[3,{"$f":"Data!B9","v":"حنين ناصر علي معيض"},{"$f":"(Data!E9+Data!F9)/10","v":19.5},{"$f":"(Data!F9+Data!G9)/10","v":13},32.5,{"$f":"(Data!K9+Data!L9)/10","v":17.5},{"$f":"(Data!L9+Data!M9)/10","v":11.1},28.6,{"$f":"(Data!Q9+Data!R9)/10","v":16.5},{"$f":"(Data!R9+Data!S9)/10","v":11.1},27.6,{"$f":"(Data!W9+Data!X9)/10","v":15.4},{"$f":"(Data!X9+Data!Y9)/10","v":9.1999999999999993},24.6,{"$f":"(Data!AC9+Data!AD9)/10","v":14.8},{"$f":"(Data!AD9+Data!AE9)/10","v":11.8},26.6,139.9,"راسب",null,{"$f":"SUMPRODUCT((R11<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":6},"راسب"]
[4,{"$f":"Data!B10","v":"رؤى صالح سالم معيض"},{"$f":"(Data!E10+Data!F10)/10","v":17.3},{"$f":"(Data!F10+Data!G10)/10","v":12.3},29.6,{"$f":"(Data!K10+Data!L10)/10","v":14.7},{"$f":"(Data!L10+Data!M10)/10","v":10.6},25.299999999999997,{"$f":"(Data!Q10+Data!R10)/10","v":16.8},{"$f":"(Data!R10+Data!S10)/10","v":10.3},27.1,{"$f":"(Data!W10+Data!X10)/10","v":16.399999999999999},{"$f":"(Data!X10+Data!Y10)/10","v":12.6},29,{"$f":"(Data!AC10+Data!AD10)/10","v":17.600000000000001},{"$f":"(Data!AD10+Data!AE10)/10","v":11.5},29.1,140.1,"ناجح",null,{"$f":"SUMPRODUCT((R12<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":5},"الخامس"]
[5,{"$f":"Data!B11","v":"سعيد محمد سالم بجنف"},{"$f":"(Data!E11+Data!F11)/10","v":17.8},{"$f":"(Data!F11+Data!G11)/10","v":11.2},29,{"$f":"(Data!K11+Data!L11)/10","v":17.8},{"$f":"(Data!L11+Data!M11)/10","v":11.2},29,{"$f":"(Data!Q11+Data!R11)/10","v":17.3},{"$f":"(Data!R11+Data!S11)/10","v":10.5},27.8,{"$f":"(Data!W11+Data!X11)/10","v":19},{"$f":"(Data!X11+Data!Y11)/10","v":12.7},31.7,{"$f":"(Data!AC11+Data!AD11)/10","v":15},{"$f":"(Data!AD11+Data!AE11)/10","v":10.9},25.9,143.39999999999998,"ناجح",null,{"$f":"SUMPRODUCT((R13<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":4},"الرّابع"]
[6,{"$f":"Data!B12","v":"سند عبدالله صالح لنقس"},{"$f":"(Data!E12+Data!F12)/10","v":18.3},{"$f":"(Data!F12+Data!G12)/10","v":11.5},29.8,{"$f":"(Data!K12+Data!L12)/10","v":17.600000000000001},{"$f":"(Data!L12+Data!M12)/10","v":12.9},30.5,{"$f":"(Data!Q12+Data!R12)/10","v":19.600000000000001},{"$f":"(Data!R12+Data!S12)/10","v":12.6},32.200000000000003,{"$f":"(Data!W12+Data!X12)/10","v":17.600000000000001},{"$f":"(Data!X12+Data!Y12)/10","v":10.6},28.200000000000003,{"$f":"(Data!AC12+Data!AD12)/10","v":18},{"$f":"(Data!AD12+Data!AE12)/10","v":10.9},28.9,149.60000000000002,"ناجح",null,{"$f":"SUMPRODUCT((R14<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":1},"الأوّل"]
[7,{"$f":"Data!B13","v":"طالب أنور حامد معيض"},{"$f":"(Data!E13+Data!F13)/10","v":17.100000000000001},{"$f":"(Data!F13+Data!G13)/10","v":12.1},29.200000000000003,{"$f":"(Data!K13+Data!L13)/10","v":17.8},{"$f":"(Data!L13+Data!M13)/10","v":11.5},29.3,{"$f":"(Data!Q13+Data!R13)/10","v":16.899999999999999},{"$f":"(Data!R13+Data!S13)/10","v":12.5},29.4,{"$f":"(Data!W13+Data!X13)/10","v":15.2},{"$f":"(Data!X13+Data!Y13)/10","v":11.6},26.799999999999997,{"$f":"(Data!AC13+Data!AD13)/10","v":17.7},{"$f":"(Data!AD13+Data!AE13)/10","v":13},30.7,145.4,"ناجح",null,{"$f":"SUMPRODUCT((R15<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":2},"الثّاني"]
[8,{"$f":"Data!B14","v":"عماد ماجد مبارك حقروص"},{"$f":"(Data!E14+Data!F14)/10","v":14.6},{"$f":"(Data!F14+Data!G14)/10","v":10.9},25.5,{"$f":"(Data!K14+Data!L14)/10","v":16.399999999999999},{"$f":"(Data!L14+Data!M14)/10","v":12.5},28.9,{"$f":"(Data!Q14+Data!R14)/10","v":13.8},{"$f":"(Data!R14+Data!S14)/10","v":10.8},24.6,{"$f":"(Data!W14+Data!X14)/10","v":15.5},{"$f":"(Data!X14+Data!Y14)/10","v":9.1999999999999993},24.7,{"$f":"(Data!AC14+Data!AD14)/10","v":15.3},{"$f":"(Data!AD14+Data!AE14)/10","v":9.1},24.4,128.1,"راسب",null,{"$f":"SUMPRODUCT((R16<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":7},"راسب"]
[9,{"$f":"Data!B15","v":"ناصر أحمد ناصر جلعوم"},{"$f":"(Data!E15+Data!F15)/10","v":15.4},{"$f":"(Data!F15+Data!G15)/10","v":10.3},25.700000000000003,{"$f":"(Data!K15+Data!L15)/10","v":18.7},{"$f":"(Data!L15+Data!M15)/10","v":12.8},31.5,{"$f":"(Data!Q15+Data!R15)/10","v":17.5},{"$f":"(Data!R15+Data!S15)/10","v":12.9},30.4,{"$f":"(Data!W15+Data!X15)/10","v":15.3},{"$f":"(Data!X15+Data!Y15)/10","v":11.8},27.1,{"$f":"(Data!AC15+Data!AD15)/10","v":17},{"$f":"(Data!AD15+Data!AE15)/10","v":12.8},29.8,144.5,"ناجح",null,{"$f":"SUMPRODUCT((R17<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":3},"الثّالث"]
[10,{"$f":"Data!B16","v":"يوسف محمد سعيد حقروص"},{"$f":"(Data!E16+Data!F16)/10","v":15.4},{"$f":"(Data!F16+Data!G16)/10","v":10},25.4,{"$f":"(Data!K16+Data!L16)/10","v":14},{"$f":"(Data!L16+Data!M16)/10","v":9.9},23.9,{"$f":"(Data!Q16+Data!R16)/10","v":17.399999999999999},{"$f":"(Data!R16+Data!S16)/10","v":11.3},28.7,{"$f":"(Data!W16+Data!X16)/10","v":14.9},{"$f":"(Data!X16+Data!Y16)/10","v":9.4},24.3,{"$f":"(Data!AC16+Data!AD16)/10","v":13.4},{"$f":"(Data!AD16+Data!AE16)/10","v":9.3000000000000007},22.700000000000003,125,"راسب",null,{"$f":"SUMPRODUCT((R18<=$R$9:$R$18)/COUNTIF($R$9:$R$18,$R$9:$R$18))","v":10},"راسب"]
[]
[null,"راجعه وصحح الأسماء والدرجات ",null,null,null,null,null,"مدير المدرسة ",null,null,null,null,null,null,null,"يعتمد / مدير إدارة التربية والتعليم  م/ عتق"]
[]
[null,null,null,null,null,null,null,"الختم والتوقيع ",null,null,null,null,null,null,null,null,"الختم والتوقيع "]

{"sheet":"Cerificats","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,4,17,5],[17,6,17,7],[4,1,4,7],[8,7,10,7],[13,2,13,5]]}
[null,null,null,null,null,null,null,"Choose Name"]
[]
[null,null,null,null,null,null,null,null,null,null,"سعيد محمد سالم بجنف"]
[]
[null,"اشعار بنتيجة الطالبــ / ــة للفصل الدراسي الأول للعام 2020 - 2021 م"]
[]
[null,"اسم الطالبــ / ــة",{"$f":"$K$3","v":"سعيد محمد سالم بجنف"},null,null,null,"الصف",{"$f":"Data!AD2","v":"الأول"}]
[]
[null,"المواد الدراسية ","القرآن الكريم ","التربية الإسلامية ","اللغة العربية ","الرياضيات ","العلوم ","المجموع "]
[null,20,{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),1),0)","v":18},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),4),0)","v":18},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),7),0)","v":17},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),10),0)","v":19},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),13),0)","v":15}]
[null,30,{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),2),0)","v":11},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),5),0)","v":11},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),8),0)","v":11},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),11),0)","v":13},{"$f":"ROUND(INDEX(Source!$C$9:$Q$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0),14),0)","v":11}]
[null,50,{"$f":"SUM(C10:C11)","v":29},{"$f":"SUM(D10:D11)","v":29},28,32,{"$f":"SUM(C12:F12)","v":118},{"$f":"INDEX(Source!$R$9:$R$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0))","v":143.39999999999998}]
[]
[null,"المجموع كتابة"]
[null,"النتيجة ",{"$f":"INDEX(Source!$S$9:$S$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0))","v":"ناجح"},null,null,null,"الترتيب",{"$f":"INDEX(Source!$V$9:$V$18,MATCH(Cerificats!$K$3,Source!$B$9:$B$100,0))","v":"الرّابع"}]
[]
[]
[null,"توقيع ولي الأمر ",null,null,"توقيع مربي الصف",null,"ختم المدرسة "]