{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["هوامش","التفاصيل","المسودة","القائمة"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":18,"defined_names":481,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"هوامش","index":0,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["المفتاح","نوع الدرجة","الدرجة","السعي","الأهمية","النقص","مجموع القرار","مواد الإكمال","متشابه",null,"الرصيد","الترفيع","الإكمال","الغياب","متشابه","النتيجة",null,"لا تحذف هذه الصفحة ولا تخفيها"]
[3,0,"غ",15,2,50,{"$f":"IF(F2=\"\",\"\",IF(AND(SUM(F$2:F2)>0,SUM(F$2:F2)<=5),SUM(F$2:F2),\"\"))","v":""},{"$f":"IF(AND(C2<50,G2=\"\"), 1,\"\")","v":""},{"$f":"IF(AND(OR(AND(C2=C3,D2=D3,J2=J3),AND(C2=C1,D2=D1,J2=J1)),B2=0,$P$2=\"مكمل\"),1,\"\")","v":""},{"$f":"IF(G2=\"\",J1,G2)","v":0},{"$f":"التفاصيل!A1-IF(P2<>\"راسب\",MAX(G:G),0)","v":5},{"$f":"COUNT(G:G)","v":0},{"$f":"SUM(H:H)","v":3},{"$f":"SUMPRODUCT(ISTEXT(C2:C9)*1)","v":4},{"$f":"SUM(I:I)","v":0},{"$f":"IF(M2+N2>التفاصيل!A3,\"راسب\",IF(M2>0,\"مكمل\",IF(N2>0,\"مكمل\",\"ناجح\")))","v":"راسب"}]
[8,0,36,20,8,14,{"$f":"IF(F3=\"\",\"\",IF(AND(SUM(F$2:F3)>0,SUM(F$2:F3)<=5),SUM(F$2:F3),\"\"))","v":""},{"$f":"IF(AND(C3<50,G3=\"\"), 1,\"\")","v":1},{"$f":"IF(AND(OR(AND(C3=C4,D3=D4,J3=J4),AND(C3=C2,D3=D2,J3=J2)),B3=0,$P$2=\"مكمل\"),1,\"\")","v":""},{"$f":"IF(G3=\"\",J2,G3)","v":0}]
[4,0,35,25,1,15,{"$f":"IF(F4=\"\",\"\",IF(AND(SUM(F$2:F4)>0,SUM(F$2:F4)<=5),SUM(F$2:F4),\"\"))","v":""},1,"",0]
[2,0,35,30,5,15,{"$f":"IF(F5=\"\",\"\",IF(AND(SUM(F$2:F5)>0,SUM(F$2:F5)<=5),SUM(F$2:F5),\"\"))","v":""},1,"",0]
[7,1,"مجاز",25,7,50,{"$f":"IF(F6=\"\",\"\",IF(AND(SUM(F$2:F6)>0,SUM(F$2:F6)<=5),SUM(F$2:F6),\"\"))","v":""},"","",0]
[5,1,"غياب",20,3,50,{"$f":"IF(F7=\"\",\"\",IF(AND(SUM(F$2:F7)>0,SUM(F$2:F7)<=5),SUM(F$2:F7),\"\"))","v":""},"","",0]
[1,1,"غ",20,6,50,{"$f":"IF(F8=\"\",\"\",IF(AND(SUM(F$2:F8)>0,SUM(F$2:F8)<=5),SUM(F$2:F8),\"\"))","v":""},"","",0]
[6,2,50,25,4,null,{"$f":"IF(F9=\"\",\"\",IF(AND(SUM(F$2:F9)>0,SUM(F$2:F9)<=5),SUM(F$2:F9),\"\"))","v":""},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G10=\"\",J9,G10)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,1]

{"sheet":"التفاصيل","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[5,"درجة القرار",null,"المفتاح","المادة","اختصارها","درجة النجاح","الدرجة النهائية","الأهمية"]
[{"$f":"COUNT(D:D)","v":8},"عدد المواد",null,1,"التربية الإسلامية","اسلامية",50,null,6]
[2,"أقصى مواد الإكمال والغياب",null,2,"اللغة العربية","عربية",50,null,5]
[null,null,null,3,"اللغة الإنكليزية","انكليزي",50,null,2]
[25,"أدنى صفوف لصفحة القائمة",null,4,"الرياضيات","رياضيات",50,null,1]
[null,null,null,5,"العلوم","علوم",50,null,3]
[null,null,null,6,"الا جتماعيات","اجتماعيات",50,null,4]
[null,null,null,7,"الفنية والنشيد","فنية",50,null,7]
[null,null,null,8,"التربية الرياضية","رياضة",50,null,8]

{"sheet":"المسودة","index":2,"n_rows":27,"n_cols":43,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,9,0,10],[0,0,2,0],[0,2,2,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,1,2,1],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,0,18],[0,21,0,22],[0,23,0,24],[0,37,2,37],[0,38,2,38],[0,39,2,39],[0,25,0,26],[0,27,0,28],[0,29,0,30],[0,31,0,32],[0,33,0,34],[0,35,0,36]]}
["ت ","رقم القبول","الاســم ","اسلامية",null,"عربية",null,"انكليزي",null,"رياضيات",null,"علوم",null,"اجتماعيات",null,"فنية",null,"رياضة",null,null,null,"اسلامية",null,"عربية",null,"انكليزي",null,"رياضيات",null,"علوم",null,"اجتماعيات",null,"فنية",null,"رياضة",null,"النتيجة","الباقي","الملاحظات"]
[null,null,null,"درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية","درجة السعي","الدرجة النهائية",null,null,"الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية","الدرجة الأصل","الدرجة النهائية"]
[null,null,null,50,100,50,100,50,100,50,100,50,100,50,100,50,100,50,100,null,null,50,100,50,100,50,100,50,100,50,100,50,100,50,100,50,100]
[1,101,"احمد 1 ",25,"غائب",25,"غائب",20,"غائب",20,"غائب",20,"غائب",22,"غائب",22,"غائب",33,"غائب",0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"راسب"]
[2,102,"احمد 2 ",25,47,30,49,24,49,49,49,0,49,44,60,44,49,10,48,2,0,null,47,49,50,49,50,49,50,49,50,null,60,49,50,null,48,"مكمل في رياضة اسلامية بعد ترفيعه بقرار في علوم انكليزي عربية فنية رياضيات",0,null,null,null,50]
[3,103,"احمد 3",30,"مجاز",25,"مجاز",25,"مجاز",20,"مجاز",20,"مجاز",20,"مجاز",40,"مجاز",33,"مجاز",0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"راسب"]
[4,104,"احمد 4",25,49,25,49,20,48,20,48,20,48,33,50,22,49,33,49,3,5,null,49,null,49,null,48,null,48,null,48,null,50,null,49,null,49,"راسب"]
[5,105,"احمد 5",30,50,25,46,25,46,25,46,30,45,44,88,44,88,31,49,3,5,null,50,null,46,null,46,null,46,null,45,null,88,null,88,null,49,"راسب"]
[6,106,"احمد 6",30,47,30,47,30,47,30,49,30,50,22,66,22,66,20,60,2,1,null,47,null,47,47,50,49,50,null,50,null,66,null,66,null,60,"مكمل في عربية اسلامية بعد ترفيعه بقرار في رياضيات انكليزي",1,"سعي متشابه في انكليزي عربية اسلامية"]
[7,107,"احمد 7",25,50,30,50,25,45,49,49,30,47,44,49,44,49,30,50,2,2,null,50,null,50,null,45,49,50,null,47,49,50,49,50,null,50,"مكمل في علوم انكليزي بعد ترفيعه بقرار في اجتماعيات فنية رياضيات",2]
[8,108,"احمد 8",22,66,20,60,40,60,25,50,25,55,30,50,30,"غ",25,65,0,5,null,66,null,60,null,60,null,50,null,55,null,50,null,null,null,65,"مكمل في فنية",5]
[9,109,"احمد 9",20,35,15,30,24,34,20,32,10,38,18,36,18,36,20,39,8,5,null,35,null,30,null,34,null,32,null,38,null,36,null,36,null,39,"راسب"]
[10,110,"احمد 10",25,50,25,55,30,50,25,45,30,45,22,66,22,66,20,60,1,0,null,50,null,55,null,50,45,50,null,45,null,66,null,66,null,60,"مكمل في علوم بعد ترفيعه بقرار في رياضيات",0]
[11,111,"احمد 11",30,48,30,60,30,60,30,50,30,50,44,88,44,88,30,50,0,3,48,50,null,60,null,60,null,50,null,50,null,88,null,88,null,50,"ناجح بعد ترفيعه بقرار في اسلامية"]
[12,112,"احمد 12",25,65,30,70,25,40,49,99,40,89,44,74,44,74,30,70,1,5,null,65,null,70,null,40,null,99,null,89,null,74,null,74,null,70,"مكمل في انكليزي",5]
[13,113,"احمد 13",30,60,20,60,30,60,20,60,40,60,33,60,33,60,30,60,0,5,null,60,null,60,null,60,null,60,null,60,null,60,null,60,null,60,"ناجح"]
[14,114,"احمد 14",25,65,30,70,32,47,25,40,40,89,44,74,44,74,30,70,1,2,null,65,null,70,47,50,null,40,null,89,null,74,null,74,null,70,"مكمل في رياضيات بعد ترفيعه بقرار في انكليزي",2]
[15,115,"احمد 15",20,60,40,60,33,60,20,70,33,60,44,88,44,88,33,73,0,5,null,60,null,60,null,60,null,70,null,60,null,88,null,88,null,73,"ناجح"]
[16,116,"احمد 16",30,75,30,63,40,65,40,60,5,35,30,35,30,35,25,55,3,5,null,75,null,63,null,65,null,60,null,35,null,35,null,35,null,55,"راسب"]
[17,117,"احمد 17",20,60,40,60,33,60,20,70,33,60,44,88,44,88,33,73,0,5,null,60,null,60,null,60,null,70,null,60,null,88,null,88,null,73,"ناجح"]
[18,118,"احمد 18",25,40,10,35,30,65,40,65,30,60,22,66,22,66,16,32,3,5,null,40,null,35,null,65,null,65,null,60,null,66,null,66,null,32,"راسب"]
[19,119,"احمد 19",30,60,20,46,20,46,26,46,30,50,44,88,44,88,33,46,3,5,null,60,null,46,null,46,null,46,null,50,null,88,null,88,null,46,"راسب"]
[20,120,"احمد 20",20,39,30,35,15,30,25,35,20,35,25,50,25,39,20,36,7,5,null,39,null,35,null,30,null,35,null,35,null,50,null,39,null,36,"راسب"]
[21,121,"احمد 20",20,"غ",30,35,15,null,25,35,20,"غياب",25,50,25,"مجاز",20,36,3,5,null,null,null,35,null,null,null,35,null,null,null,50,null,null,null,36,"راسب"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,21]

{"sheet":"القائمة","index":3,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2],[34,11,34,14],[35,11,35,14],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13]]}
[null,null,null,"            قائمة درجات نهاية السنة للعام الدراسي",null,null,null,null,null,null,null,null,null,"الصف :",null,"الخامس"]
["مدرسة ....",null,null,"2021 - 2022",null,null,null,null,null,null,null,null,null,"الشعبة :",null,"أ"]
[]
[]
["ت","رقم القبول","الاسم الثلاثي","التربية الإسلامية","اللغة العربية","اللغة الإنكليزية","الرياضيات","العلوم","الا جتماعيات","الفنية والنشيد","التربية الرياضية","المجموع رقما","المجموع كتابة",null,null,"النتيجة",null,"النتيجة ومواد الإكمال والترفيع","باقي القرار","الملاحظات"]
[1,101,"احمد 1 ","غائب","غائب","غائب","غائب","غائب","غائب","غائب","غائب",null,null,null,null,"راسب",null,"راسب"]
[2,102,"احمد 2 ","47","50 49","50 49","50 49","50 49","60","50 49","48",null,null,null,null,"مكمل",null,"مكمل في رياضة اسلامية بعد ترفيعه بقرار في علوم انكليزي عربية فنية رياضيات",0]
[3,103,"احمد 3","مجاز","مجاز","مجاز","مجاز","مجاز","مجاز","مجاز","مجاز",null,null,null,null,"راسب",null,"راسب"]
[4,104,"احمد 4","49","49","48","48","48","50","49","49",null,null,null,null,"راسب",null,"راسب"]
[5,105,"احمد 5","50","46","46","46","45","88","88","49",null,null,null,null,"راسب",null,"راسب"]
[6,106,"احمد 6","47","47","50 47","50 49","50","66","66","60",null,null,null,null,"مكمل",null,"مكمل في عربية اسلامية بعد ترفيعه بقرار في رياضيات انكليزي",1,"سعي متشابه في انكليزي عربية اسلامية"]
[7,107,"احمد 7","50","50","45","50 49","47","50 49","50 49","50",null,null,null,null,"مكمل",null,"مكمل في علوم انكليزي بعد ترفيعه بقرار في اجتماعيات فنية رياضيات",2]
[8,108,"احمد 8","66","60","60","50","55","50","غ","65",null,null,null,null,"مكمل",null,"مكمل في فنية",5]
[9,109,"احمد 9","35","30","34","32","38","36","36","39",null,null,null,null,"راسب",null,"راسب"]
[10,110,"احمد 10","50","55","50","50 45","45","66","66","60",null,null,null,null,"مكمل",null,"مكمل في علوم بعد ترفيعه بقرار في رياضيات",0]
[11,111,"احمد 11","50 48","60","60","50","50","88","88","50",496,"أربعمائة وست وتسعون",null,null,"ناجح",null,"ناجح بعد ترفيعه بقرار في اسلامية"]
[12,112,"احمد 12","65","70","40","99","89","74","74","70",null,null,null,null,"مكمل",null,"مكمل في انكليزي",5]
[13,113,"احمد 13","60","60","60","60","60","60","60","60",480,"أربعمائة وثمانون",null,null,"ناجح",null,"ناجح"]
[14,114,"احمد 14","65","70","50 47","40","89","74","74","70",null,null,null,null,"مكمل",null,"مكمل في رياضيات بعد ترفيعه بقرار في انكليزي",2]
[15,115,"احمد 15","60","60","60","70","60","88","88","73",559,"خمسمائة وتسع وخمسون",null,null,"ناجح",null,"ناجح"]
[16,116,"احمد 16","75","63","65","60","35","35","35","55",null,null,null,null,"راسب",null,"راسب"]
[17,117,"احمد 17","60","60","60","70","60","88","88","73",559,"خمسمائة وتسع وخمسون",null,null,"ناجح",null,"ناجح"]
[18,118,"احمد 18","40","35","65","65","60","66","66","32",null,null,null,null,"راسب",null,"راسب"]
[19,119,"احمد 19","60","46","46","46","50","88","88","46",null,null,null,null,"راسب",null,"راسب"]
[20,120,"احمد 20","39","35","30","35","35","50","39","36",null,null,null,null,"راسب",null,"راسب"]
[21,121,"احمد 20","غ","35","غ","35","غياب","50","مجاز","36",null,null,null,null,"راسب",null,"راسب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"راسب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"راسب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مكمل في انكليزي بعد ترفيعه بقرار في اسلامية",3]
[null,null,null,null,null,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":"IFERROR(F33*100/D33,\"\")","v":""},{"$f":"F33+F34","v":0}]
["اناث",null,"اناث",null,"اناث",null,"اناث",null,"اناث",null,"اناث",null,"اناث",{"$f":"IFERROR(F34*100/D34,\"\")","v":""}]
[]
[null,null,"مرشد/ة الصف",null,null,null,null,null,null,null,null,"مدير المدرسة"]