{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["مسودة القرار من 5","القائمة المطلوبة","التفاصيل"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":18,"defined_names":481,"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":"مسودة القرار من 5","index":0,"n_rows":23,"n_cols":39,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,32,0,33],[0,34,0,35],[0,36,2,36],[0,37,2,37],[0,38,2,38],[0,1,2,1],[0,0,2,0],[0,30,0,31],[0,24,0,25],[0,20,0,21],[0,22,0,23],[0,26,0,27],[0,28,0,29]]}
["ت ","الاســم ","اسلامية ","اسلامية ","عربي","عربي","انكليزي","انكليزي","رياضيات","رياضيات","علوم","علوم","علوم","علوم","فنية","فنية","رياضة","رياضة",null,null,{"$f":"C1","v":"اسلامية "},null,{"$f":"E1","v":"عربي"},null,{"$f":"G1","v":"انكليزي"},null,{"$f":"I1","v":"رياضيات"},null,{"$f":"K1","v":"علوم"},null,{"$f":"M1","v":"علوم"},null,{"$f":"O1","v":"فنية"},null,{"$f":"Q1","v":"رياضة"},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,"احمد 1 ",null,47,null,49,null,48,null,48,null,48,null,49,null,60,null,50,3,1,null,47,null,49,null,48,null,48,null,48,null,49,null,60,null,50,"معيد من اسلامية  انكليزي رياضيات بعد ترفيعه بقرار من عربي علوم علوم ",1,"يرجى مراجعة اللجنة لوجود سعي متشابه"]
[2,"احمد 2 ",null,60,null,49,null,49,null,49,null,49,null,60,null,49,null,55,0,0,null,60,49,50,49,50,49,50,49,50,null,60,49,50,null,55,"ناجح بعد ترفيعه بقرار من عربي انكليزي رياضيات علوم فنية "]
[3,"احمد 3",null,49,null,45,null,45,null,45,null,45,null,45,null,77,null,48,5,2,null,49,null,45,null,45,null,45,null,45,null,45,null,77,null,48,"معيد من عربي انكليزي رياضيات علوم علوم بعد ترفيعه بقرار من اسلامية  رياضة ",2]
[4,"احمد 4",null,50,null,49,null,48,null,48,null,48,null,50,null,49,null,46,3,1,null,50,null,49,null,48,null,48,null,48,null,50,null,49,null,46,"معيد من انكليزي رياضيات رياضة بعد ترفيعه بقرار من عربي علوم فنية ",1,"يرجى مراجعة اللجنة لوجود سعي متشابه"]
[5,"احمد 5",null,47,null,46,null,46,null,46,null,45,null,88,null,88,null,50,4,2,null,47,null,46,null,46,null,46,null,45,null,88,null,88,null,50,"معيد من عربي انكليزي رياضيات علوم بعد ترفيعه بقرار من اسلامية  ",2]
[6,"احمد 6",null,50,null,47,null,47,null,49,null,50,null,66,null,66,null,50,1,1,null,50,null,47,47,50,49,50,null,50,null,66,null,66,null,50,"معيد من عربي بعد ترفيعه بقرار من انكليزي رياضيات ",1,"يرجى مراجعة اللجنة لوجود سعي متشابه"]
[7,"احمد 7",null,66,null,50,null,45,null,49,null,47,null,49,null,49,null,60,2,2,null,66,null,50,null,45,49,50,null,47,49,50,49,50,null,60,"معيد من انكليزي علوم بعد ترفيعه بقرار من رياضيات علوم فنية ",2]
[8,"احمد 8",null,35,null,60,null,60,null,50,null,55,null,50,null,50,null,39,2,5,null,35,null,60,null,60,null,50,null,55,null,50,null,50,null,39,"معيد من اسلامية  رياضة ",5]
[9,"احمد 9",null,50,null,30,null,34,null,32,null,38,null,36,null,36,null,60,6,5,null,50,null,30,null,34,null,32,null,38,null,36,null,36,null,60,"معيد من عربي انكليزي رياضيات علوم علوم فنية ",5]
[10,"احمد 10",null,48,null,55,null,50,null,45,null,45,null,66,null,66,null,50,2,3,48,50,null,55,null,50,null,45,null,45,null,66,null,66,null,50,"معيد من رياضيات علوم بعد ترفيعه بقرار من اسلامية  ",3]
[11,"احمد 11",null,65,null,60,null,60,null,50,null,50,null,88,null,88,null,65,0,5,null,65,null,60,null,60,null,50,null,50,null,88,null,88,null,65,"ناجح"]
[12,"احمد 12",null,60,null,70,null,40,null,99,null,89,null,74,null,74,null,60,1,5,null,60,null,70,null,40,null,99,null,89,null,74,null,74,null,60,"معيد من انكليزي ",5]
[13,"احمد 13",null,65,null,60,null,60,null,60,null,60,null,60,null,60,null,65,0,5,null,65,null,60,null,60,null,60,null,60,null,60,null,60,null,65,"ناجح"]
[14,"احمد 14",null,60,null,70,null,47,null,40,null,89,null,74,null,74,null,80,1,2,null,60,null,70,47,50,null,40,null,89,null,74,null,74,null,80,"معيد من رياضيات بعد ترفيعه بقرار من انكليزي ",2]
[15,"احمد 15",null,75,null,60,null,60,null,70,null,60,null,88,null,88,null,70,0,5,null,75,null,60,null,60,null,70,null,60,null,88,null,88,null,70,"ناجح"]
[16,"احمد 16",null,60,null,63,null,65,null,60,null,35,null,35,null,35,null,85,3,5,null,60,null,63,null,65,null,60,null,35,null,35,null,35,null,85,"معيد من علوم علوم فنية ",5]
[17,"احمد 17",null,40,null,60,null,60,null,70,null,60,null,88,null,88,null,30,2,5,null,40,null,60,null,60,null,70,null,60,null,88,null,88,null,30,"معيد من اسلامية  رياضة ",5]
[18,"احمد 18",null,60,null,35,null,65,null,65,null,60,null,66,null,66,null,46,1,1,null,60,null,35,null,65,null,65,null,60,null,66,null,66,46,50,"معيد من عربي بعد ترفيعه بقرار من رياضة ",1]
[19,"احمد 19",null,39,null,46,null,46,null,46,null,50,null,88,null,88,null,35,4,1,null,39,null,46,null,46,null,46,null,50,null,88,null,88,null,35,"معيد من اسلامية  عربي انكليزي رياضة بعد ترفيعه بقرار من رياضيات ",1,"يرجى مراجعة اللجنة لوجود سعي متشابه"]
[20,"احمد 20",null,39,null,35,null,30,null,35,null,35,null,50,null,39,null,35,7,5,null,39,null,35,null,30,null,35,null,35,null,50,null,39,null,35,"معيد من اسلامية  عربي انكليزي رياضيات علوم فنية رياضة ",5]

{"sheet":"القائمة المطلوبة","index":1,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,10],[0,12,0,13],[1,0,2,2],[1,3,1,11],[1,12,1,13],[34,11,34,14],[35,11,35,14],[31,10,31,11],[31,12,31,13],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9]]}
[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,"النتيجة"]
[1,null,"احمد 1 ","47","49","48","48","48","49","60","50",399,"ثلاثمائة وتسع وتسعون",null,null,"راسب"]
[2,null,"احمد 2 ","60","50 49","50 49","50 49","50 49","60","50 49","55",425,"أربعمائة وخمس وعشرون",null,null,"ناجح بعد ترفيعه بقرار من عربي انكليزي رياضيات علوم فنية "]
[3,null,"احمد 3","49","45","45","45","45","45","77","48",399,"ثلاثمائة وتسع وتسعون",null,null,"راسب"]
[4,null,"احمد 4","50","49","48","48","48","50","49","46",388,"ثلاثمائة وثماني وثمانون",null,null,"راسب"]
[5,null,"احمد 5","47","46","46","46","45","88","88","50",456,"أربعمائة وست وخمسون",null,null,"راسب"]
[6,null,"احمد 6","50","47","50 47","50 49","50","66","66","50",429,"أربعمائة وتسع وعشرون",null,null,"مكمل في عربي بعد ترفيعه بقرار من انكليزي رياضيات "]
[7,null,"احمد 7","66","50","45","50 49","47","50 49","50 49","60",418,"أربعمائة وثماني عشرة",null,null,"مكمل في انكليزي علوم بعد ترفيعه بقرار من رياضيات علوم فنية "]
[8,null,"احمد 8","35","60","60","50","55","50","50","39",399,"ثلاثمائة وتسع وتسعون",null,null,"مكمل في اسلامية  رياضة "]
[9,null,"احمد 9","50","30","34","32","38","36","36","60",316,"ثلاثمائة وست عشرة",null,null,"راسب"]
[10,null,"احمد 10","50 48","55","50","45","45","66","66","50",427,"أربعمائة وسبع وعشرون",null,null,"مكمل في رياضيات علوم بعد ترفيعه بقرار من اسلامية  "]
[11,null,"احمد 11","65","60","60","50","50","88","88","65",526,"خمسمائة وست وعشرون",null,null,"ناجح"]
[12,null,"احمد 12","60","70","40","99","89","74","74","60",566,"خمسمائة وست وستون",null,null,"مكمل في انكليزي "]
[13,null,"احمد 13","65","60","60","60","60","60","60","65",490,"أربعمائة وتسعون",null,null,"ناجح"]
[14,null,"احمد 14","60","70","50 47","40","89","74","74","80",537,"خمسمائة وسبع وثلاثون",null,null,"مكمل في رياضيات بعد ترفيعه بقرار من انكليزي "]
[15,null,"احمد 15","75","60","60","70","60","88","88","70",571,"خمسمائة وإحدى وسبعون",null,null,"ناجح"]
[16,null,"احمد 16","60","63","65","60","35","35","35","85",438,"أربعمائة وثماني وثلاثون",null,null,"راسب"]
[17,null,"احمد 17","40","60","60","70","60","88","88","30",496,"أربعمائة وست وتسعون",null,null,"مكمل في اسلامية  رياضة "]
[18,null,"احمد 18","60","35","65","65","60","66","66","50 46",467,"أربعمائة وسبع وستون",null,null,"مكمل في عربي بعد ترفيعه بقرار من رياضة "]
[19,null,"احمد 19","39","46","46","46","50","88","88","35",438,"أربعمائة وثماني وثلاثون",null,null,"راسب"]
[20,null,"احمد 20","39","35","30","35","35","50","39","35",298,"مائتان وثماني وتسعون",null,null,"راسب"]
[]
[]
[]
[]
[]
[]
["المشتركون",null,"الممتحنون",null,"الناجحون",null,"الراسبون",null,"الغياب",null,"المكملون",null,"النسبة %",null,null,{"$f":"IFERROR(O33*100/P33,\"\")","v":""}]
["ذكور",{"$f":"COUNT(AU6:AU17)+COUNTIF(AU6:AU17,\"ذكر\")","v":0},"ذكور",null,"ذكور",null,"ذكور",null,"ذكور",null,"ذكور",null,"ذكور",{"$f":"IFERROR(F33*100/D33,\"\")","v":""},{"$f":"F33+F34","v":0},{"$f":"D33+D34","v":0}]
["اناث",{"$f":"COUNT(AU6:AU17)+COUNTIF(AU6:AU17,\"انثى\")","v":0},"اناث",null,"اناث",null,"اناث",null,"اناث",null,"اناث",null,"اناث",{"$f":"IFERROR(F34*100/D34,\"\")","v":""}]
[]
[null,null,"مرشد/ة الصف",null,null,null,null,null,null,null,null,"مدير المدرسة"]

{"sheet":"التفاصيل","index":2,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["المفتاح","المادة","كنية",null,"مفتاح\nالآلية","آلية العمل",null,"المجموعة","المفتاح","المكون","درجة\nالإكمال","مفتاح\nالآلية","التفاصيل وآلية العمل"]
[1,"التربية الإسلامية","اسلامية",null,1,"تعطى للأقرب للنجاح",null,1,1,{"$f":"VLOOKUP(I2,$A$1:$C$9,3,FALSE)","v":"اسلامية"},45,1,{"$f":"VLOOKUP(L2,$E$1:$F$9,2,FALSE)","v":"تعطى للأقرب للنجاح"}]
[2,"اللغة العربية","عربية",null,2,"لدية سعي 65",null,1,2,{"$f":"VLOOKUP(I3,$A$1:$C$9,3,FALSE)","v":"عربية"},48,1,"تعطى للأقرب للنجاح"]
[3,"اللغة الإنكليزية","انكليزي",null,3,"لدية سعي 50 تعطى للأقل في السعي",null,2,5,"علوم",46,1,"تعطى للأقرب للنجاح"]
[4,"الرياضيات","رياضيات",null,4,"تعطى للمواد الثلاثة",null,2,4,"رياضيات",45,1,"تعطى للأقرب للنجاح"]
[5,"العلوم","علوم",null,5,"يبقى مكملا في تلك المادة",null,3,3,"انكليزي",45,2,"لدية سعي 65"]
[6,"الا جتماعيات","اجتماعيات",null,6,"لديه سعي 60 يعطى القرار للمادة الأهم وحسب",null,3,4,"رياضيات",45,3,"لدية سعي 50 تعطى للأقل في السعي"]
[7,"الفنية والنشيد","فنية",null,7,"لديه سعي 60 قرار ورأي اللجنة الامتحانية",null,4,5,"علوم",48,4,"تعطى للمواد الثلاثة"]
[8,"التربية الرياضية","رياضة",null,8,"50 يعطى له القرار",null,4,1,"اسلامية",48,4,"تعطى للمواد الثلاثة"]
[null,null,null,null,null,null,null,4,4,"رياضيات",49,4,"تعطى للمواد الثلاثة"]
[null,null,null,null,null,null,null,5,1,"اسلامية",45,5,"يبقى مكملا في تلك المادة"]
[null,null,null,null,null,null,null,5,5,"علوم",45,1,"تعطى للأقرب للنجاح"]
[null,null,null,null,null,null,null,6,1,"اسلامية",45,6,"لديه سعي 60 يعطى القرار للمادة الأهم وحسب"]
[null,null,null,null,null,null,null,6,5,"علوم",45,7,"لديه سعي 60 قرار ورأي اللجنة الامتحانية"]
[null,null,null,null,null,null,null,7,5,"علوم",47,8,"50 يعطى له القرار"]
[null,null,null,null,null,null,null,7,6,"اجتماعيات",48,8,"50 يعطى له القرار"]
[null,null,null,null,null,null,null,8,1,"اسلامية",46,8,"50 يعطى له القرار"]
[null,null,null,null,null,null,null,8,2,"عربية",49,8,"50 يعطى له القرار"]
[null,null,null,null,null,null,null,8,5,"علوم",45,5,"يبقى مكملا في تلك المادة"]