{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["طباعة الشهادة (4)","الكشوفات","طباعة الشهادة (3)","طباعة الشهادة (2)","طباعة الشهادة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"طباعة الشهادة (4)","index":0,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[33,0,33,3],[33,7,33,8],[33,12,33,15],[34,0,44,26],[31,1,31,4],[31,7,31,8],[31,9,31,11],[31,14,31,24],[32,1,32,4],[32,6,32,10],[32,14,32,24],[27,16,27,17],[27,18,27,24],[28,16,28,17],[28,18,28,24],[29,0,29,26],[30,4,30,8],[30,10,30,15],[30,16,30,17],[30,18,30,24],[24,16,24,17],[24,18,24,24],[25,16,25,17],[25,18,25,24],[26,16,26,17],[26,18,26,24],[20,0,20,26],[21,16,21,17],[21,18,21,24],[22,16,22,17],[22,18,22,24],[23,16,23,17],[23,18,23,24],[13,16,16,20],[14,21,17,23],[17,0,19,0],[17,1,19,4],[17,6,19,10],[17,12,19,16],[18,21,19,23],[10,1,12,2],[10,5,12,6],[10,8,12,10],[10,12,12,14],[10,16,12,23],[13,0,16,0],[13,1,16,2],[13,6,16,6],[13,8,16,10],[13,12,16,14],[6,1,6,6],[6,7,6,16],[6,24,6,26],[7,0,9,0],[7,1,9,2],[7,5,9,6],[7,8,9,10],[7,12,9,14],[7,16,9,23],[7,24,19,26],[3,6,3,12],[4,1,4,5],[4,8,4,10],[4,11,4,26],[5,1,5,2],[5,14,5,16],[5,18,5,26],[0,7,0,14],[1,1,1,2],[1,8,1,11],[1,16,1,26],[1,32,1,34],[2,8,2,9]]}
[null,null,{"$f":"الكشوفات!C1","v":0},{"$f":"الكشوفات!D1","v":0},{"$f":"الكشوفات!E1","v":0}]
[null,{"$f":"$E$1","v":0},null,null,null,null,null,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":"MAX(الكشوفات!A4:A7)","v":4},"مجموع عدد الطلاب "]
[]
[null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,4))","v":"2022/2021"}]
[null,{"$f":"$C$1","v":0}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,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,4,"رقم الشهادة"]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,3))","v":"حبيب ابراهيم حسن محسن الجلال"}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,7))","v":"ذكر"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,10))","v":"2002\\12\\28"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,11))","v":0}]
[]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,2))","v":4}]
[]
[]
[null,null,null,null,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":"$AC$6","v":4}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,12))","v":1},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,13))","v":1},null,{"$f":"SUM(C22,E22)","v":2},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,14))","v":1},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,15))","v":1},null,{"$f":"SUM(K22,M22)","v":2},null,{"$f":"SUM(O22,G22)","v":4}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,17))","v":1},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,18))","v":1},null,{"$f":"SUM(C23,E23)","v":2},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,19))","v":1},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,20))","v":20},null,{"$f":"SUM(K23,M23)","v":21},null,{"$f":"SUM(O23,G23)","v":23}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,22))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,23))","v":20},null,35,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,24))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,25))","v":20},null,35,null,70]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",IF(B6=\"الثالث\",\"\",IF(B6=\"الرابع\",\"\",IF(B6=\"الخامس\",\"\",IF(B6=\"السادس\",\"\",INDEX(طباعة,$AC21,27))))))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,28)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(C25,E25))","v":""},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,29)))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,30)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(K25,M25))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(O25,G25))","v":""}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,32))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,33))","v":19},null,34,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,34))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,35))","v":20},null,35,null,69]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,37))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,38))","v":18},null,34,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,39))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,40))","v":18},null,34,null,68]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,42))))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,43))))","v":0},null,{"$f":"IF(C28=\"\",\"\",SUM(C28,E28))","v":0},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,44))))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,45))))","v":0},null,{"$f":"IF(K28=\"\",\"\",SUM(K28,M28))","v":0},null,{"$f":"IF(K28=\"\",\"\",SUM(O28,G28))","v":0}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,47))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,48))","v":18},null,34,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,49))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,50))","v":5},null,20,null,54]
[]
[null,null,{"$f":"SUM(Q22:R29)","v":288},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:R29)","v":288}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,56))","v":"راسب"},null,null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,53))","v":0.49}]

{"sheet":"الكشوفات","index":1,"n_rows":16,"n_cols":56,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,38,15,47],[1,36,1,40],[1,41,1,45],[1,0,2,0],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,1,2,1],[1,55,2,55],[1,6,2,6],[1,7,2,7],[1,9,2,9],[1,10,2,10],[1,8,2,8],[1,46,1,50],[1,51,2,51],[1,52,2,52],[1,53,2,53],[1,54,2,54],[1,11,1,15],[1,16,1,20],[1,21,1,25],[1,26,1,30],[1,31,1,35]]}
[1,2,null,null,null,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
["م","الرقم المدرسي","الاسم","العام الدراسي","الصف","الشعبة","الجنس","الجنسية","الديانة","تاريخ الميلاد","محل الميلاد","القرآن الكريم",null,null,null,null,"التربية الإسلامية",null,null,null,null,"اللغة العربية",null,null,null,null,"اللغة الإنجليزية",null,null,null,null,"الرياضيات",null,null,null,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","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج","م1","ف1","م2","ف2","مج"]
[{"$f":"IF(C4=\"\",\"\",1)","v":1},1,"علي محمد محمد الجندي","2023/2022","الأول","أ","ذكر","يمني","مسلم","2002\\12\\25",null,17,24,14,26,81,17,24,14,27,82,16,22,16,30,84,null,null,null,null,null,15,23,16,25,79,15,22,14,25,76,null,null,null,null,"",15,25,16,30,86,{"$f":"SUM(AY4,AT4,AO4,AJ4,AE4,Z4,U4,P4)","v":488},{"$f":"IF(C4=\"\",\"\",AVERAGE(AY4,AO4,AJ4,,Z4,U4,P4)/100)","v":0.69714285714285706},{"$f":"IF(C4=\"\",\"\",IF(BA4>=0.9,\"ممتاز\",IF(BA4>=0.8,\"جيد جداً\",IF(BA4>=0.65,\"جيد\",IF(BA4>=0.5,\"مقبول\",\"ضعيف\")))))","v":"جيد"},null,{"$f":"IF(C4=\"\",\"\",IF(MIN(O4,T4,Y4,AI4,AN4,AX4)=0,\"غائب\",IF(MIN(AY4,AO4,AJ4,Z4,U4,P4)>=50,\"ناجح\",\"راسب\")))","v":"ناجح"}]
[{"$f":"IF(C5=\"\",\"\",A4+1)","v":2},2,"بدر عبدالرزاق علي احمد الشامي","2022/2021","الثاني","أ","ذكر","يمني","مسلم","2002\\12\\26",null,12,15,12,15,54,11,16,12,15,54,11,15,15,15,56,null,null,null,null,null,13,15,14,15,57,12,15,12,15,54,null,null,null,null,"",12,15,15,15,57,{"$f":"SUM(AY5,AT5,AO5,AJ5,AE5,Z5,U5,P5)","v":332},{"$f":"IF(C5=\"\",\"\",AVERAGE(AY5,AO5,AJ5,,Z5,U5,P5)/100)","v":0.47428571428571431},{"$f":"IF(C5=\"\",\"\",IF(BA5>=0.9,\"ممتاز\",IF(BA5>=0.8,\"جيد جداً\",IF(BA5>=0.65,\"جيد\",IF(BA5>=0.5,\"مقبول\",\"ضعيف\")))))","v":"ضعيف"},null,{"$f":"IF(C5=\"\",\"\",IF(MIN(O5,T5,Y5,AI5,AN5,AX5)=0,\"غائب\",IF(MIN(AY5,AO5,AJ5,Z5,U5,P5)>=50,\"ناجح\",\"راسب\")))","v":"ناجح"}]
[{"$f":"IF(C6=\"\",\"\",A5+1)","v":3},3,"سمير صالح خالد الصبري","2022/2021","الثالث","أ","ذكر","يمني","مسلم","2002\\12\\27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(AY6,AT6,AO6,AJ6,AE6,Z6,U6,P6)","v":0},{"$f":"IF(C6=\"\",\"\",AVERAGE(AY6,AO6,AJ6,,Z6,U6,P6)/100)","v":0},"ضعيف",null,"غائب"]
[4,4,"حبيب ابراهيم حسن محسن الجلال","2022/2021","الرابع","أ","ذكر","يمني","مسلم","2002\\12\\28",null,1,1,1,1,1,1,1,1,20,66,15,20,15,20,70,null,null,null,null,null,15,19,15,20,69,16,18,16,18,68,null,null,null,null,"",16,18,15,5,69,343,0.49,"ضعيف",null,"راسب"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"المطلوب اضافة كود طباعة وعدم طباعة \nطباعة شهادات الناجحين فقط اذا كان الطالب راسب او غائب يتم الغاء طباعة شهادته "]

{"sheet":"طباعة الشهادة (3)","index":2,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[33,0,33,3],[33,7,33,8],[33,12,33,15],[34,0,44,26],[31,1,31,4],[31,7,31,8],[31,9,31,11],[31,14,31,24],[32,1,32,4],[32,6,32,10],[32,14,32,24],[27,16,27,17],[27,18,27,24],[28,16,28,17],[28,18,28,24],[29,0,29,26],[30,4,30,8],[30,10,30,15],[30,16,30,17],[30,18,30,24],[24,16,24,17],[24,18,24,24],[25,16,25,17],[25,18,25,24],[26,16,26,17],[26,18,26,24],[20,0,20,26],[21,16,21,17],[21,18,21,24],[22,16,22,17],[22,18,22,24],[23,16,23,17],[23,18,23,24],[13,16,16,20],[14,21,17,23],[17,0,19,0],[17,1,19,4],[17,6,19,10],[17,12,19,16],[18,21,19,23],[10,1,12,2],[10,5,12,6],[10,8,12,10],[10,12,12,14],[10,16,12,23],[13,0,16,0],[13,1,16,2],[13,6,16,6],[13,8,16,10],[13,12,16,14],[6,1,6,6],[6,7,6,16],[6,24,6,26],[7,0,9,0],[7,1,9,2],[7,5,9,6],[7,8,9,10],[7,12,9,14],[7,16,9,23],[7,24,19,26],[3,6,3,12],[4,1,4,5],[4,8,4,10],[4,11,4,26],[5,1,5,2],[5,14,5,16],[5,18,5,26],[0,7,0,14],[1,1,1,2],[1,8,1,11],[1,16,1,26],[1,32,1,34],[2,8,2,9]]}
[null,null,{"$f":"الكشوفات!C1","v":0},{"$f":"الكشوفات!D1","v":0},{"$f":"الكشوفات!E1","v":0}]
[null,{"$f":"$E$1","v":0},null,null,null,null,null,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":"MAX(الكشوفات!A4:A7)","v":4},"مجموع عدد الطلاب "]
[]
[null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,4))","v":"2022/2021"}]
[null,{"$f":"$C$1","v":0}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,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,3,"رقم الشهادة"]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,3))","v":"سمير صالح خالد الصبري"}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,7))","v":"ذكر"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,10))","v":"2002\\12\\27"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,11))","v":0}]
[]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,2))","v":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,{"$f":"$AC$6","v":3}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,12))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,13))","v":0},null,{"$f":"SUM(C22,E22)","v":0},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,14))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,15))","v":0},null,{"$f":"SUM(K22,M22)","v":0},null,{"$f":"SUM(O22,G22)","v":0}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,17))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,18))","v":0},null,{"$f":"SUM(C23,E23)","v":0},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,19))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,20))","v":0},null,{"$f":"SUM(K23,M23)","v":0},null,{"$f":"SUM(O23,G23)","v":0}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,22))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,23))","v":0},null,0,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,24))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,25))","v":0},null,0,null,0]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",IF(B6=\"الثالث\",\"\",IF(B6=\"الرابع\",\"\",IF(B6=\"الخامس\",\"\",IF(B6=\"السادس\",\"\",INDEX(طباعة,$AC21,27))))))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,28)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(C25,E25))","v":""},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,29)))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,30)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(K25,M25))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(O25,G25))","v":""}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,32))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,33))","v":0},null,0,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,34))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,35))","v":0},null,0,null,0]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,37))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,38))","v":0},null,0,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,39))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,40))","v":0},null,0,null,0]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,42))))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,43))))","v":0},null,{"$f":"IF(C28=\"\",\"\",SUM(C28,E28))","v":0},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,44))))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,45))))","v":0},null,{"$f":"IF(K28=\"\",\"\",SUM(K28,M28))","v":0},null,{"$f":"IF(K28=\"\",\"\",SUM(O28,G28))","v":0}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,47))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,48))","v":0},null,0,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,49))","v":0},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,50))","v":0},null,0,null,0]
[]
[null,null,{"$f":"SUM(Q22:R29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:R29)","v":0}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,56))","v":"غائب"},null,null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,53))","v":0}]

{"sheet":"طباعة الشهادة (2)","index":3,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[33,0,33,3],[33,7,33,8],[33,12,33,15],[34,0,44,26],[31,1,31,4],[31,7,31,8],[31,9,31,11],[31,14,31,24],[32,1,32,4],[32,6,32,10],[32,14,32,24],[27,16,27,17],[27,18,27,24],[28,16,28,17],[28,18,28,24],[29,0,29,26],[30,4,30,8],[30,10,30,15],[30,16,30,17],[30,18,30,24],[24,16,24,17],[24,18,24,24],[25,16,25,17],[25,18,25,24],[26,16,26,17],[26,18,26,24],[20,0,20,26],[21,16,21,17],[21,18,21,24],[22,16,22,17],[22,18,22,24],[23,16,23,17],[23,18,23,24],[13,16,16,20],[14,21,17,23],[17,0,19,0],[17,1,19,4],[17,6,19,10],[17,12,19,16],[18,21,19,23],[10,1,12,2],[10,5,12,6],[10,8,12,10],[10,12,12,14],[10,16,12,23],[13,0,16,0],[13,1,16,2],[13,6,16,6],[13,8,16,10],[13,12,16,14],[6,1,6,6],[6,7,6,16],[6,24,6,26],[7,0,9,0],[7,1,9,2],[7,5,9,6],[7,8,9,10],[7,12,9,14],[7,16,9,23],[7,24,19,26],[3,6,3,12],[4,1,4,5],[4,8,4,10],[4,11,4,26],[5,1,5,2],[5,14,5,16],[5,18,5,26],[0,7,0,14],[1,1,1,2],[1,8,1,11],[1,16,1,26],[1,32,1,34],[2,8,2,9]]}
[null,null,{"$f":"الكشوفات!C1","v":0},{"$f":"الكشوفات!D1","v":0},{"$f":"الكشوفات!E1","v":0}]
[null,{"$f":"$E$1","v":0},null,null,null,null,null,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":"MAX(الكشوفات!A4:A7)","v":4},"مجموع عدد الطلاب "]
[]
[null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,4))","v":"2022/2021"}]
[null,{"$f":"$C$1","v":0}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,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,2,"رقم الشهادة"]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,3))","v":"بدر عبدالرزاق علي احمد الشامي"}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,7))","v":"ذكر"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,10))","v":"2002\\12\\26"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,11))","v":0}]
[]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,2))","v":2}]
[]
[]
[null,null,null,null,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":"$AC$6","v":2}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,12))","v":12},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,13))","v":15},null,{"$f":"SUM(C22,E22)","v":27},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,14))","v":12},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,15))","v":15},null,{"$f":"SUM(K22,M22)","v":27},null,{"$f":"SUM(O22,G22)","v":54}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,17))","v":11},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,18))","v":16},null,{"$f":"SUM(C23,E23)","v":27},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,19))","v":12},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,20))","v":15},null,{"$f":"SUM(K23,M23)","v":27},null,{"$f":"SUM(O23,G23)","v":54}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,22))","v":11},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,23))","v":15},null,26,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,24))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,25))","v":15},null,30,null,56]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",IF(B6=\"الثالث\",\"\",IF(B6=\"الرابع\",\"\",IF(B6=\"الخامس\",\"\",IF(B6=\"السادس\",\"\",INDEX(طباعة,$AC21,27))))))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,28)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(C25,E25))","v":""},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,29)))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,30)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(K25,M25))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(O25,G25))","v":""}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,32))","v":13},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,33))","v":15},null,28,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,34))","v":14},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,35))","v":15},null,29,null,57]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,37))","v":12},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,38))","v":15},null,27,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,39))","v":12},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,40))","v":15},null,27,null,54]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,42))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,43))))","v":""},null,{"$f":"IF(C28=\"\",\"\",SUM(C28,E28))","v":""},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,44))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,45))))","v":""},null,{"$f":"IF(K28=\"\",\"\",SUM(K28,M28))","v":""},null,{"$f":"IF(K28=\"\",\"\",SUM(O28,G28))","v":""}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,47))","v":12},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,48))","v":15},null,27,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,49))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,50))","v":15},null,30,null,57]
[]
[null,null,{"$f":"SUM(Q22:R29)","v":332},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:R29)","v":332}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,56))","v":"ناجح"},null,null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,53))","v":0.47428571428571431}]

{"sheet":"طباعة الشهادة","index":4,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,1,4,5],[4,8,4,10],[4,11,4,26],[5,1,5,2],[5,14,5,16],[5,18,5,26],[1,32,1,34],[3,6,3,12],[0,7,0,14],[1,1,1,2],[1,8,1,11],[1,16,1,26],[2,8,2,9],[6,1,6,6],[6,7,6,16],[6,24,6,26],[7,0,9,0],[7,1,9,2],[7,5,9,6],[7,8,9,10],[7,12,9,14],[7,16,9,23],[7,24,19,26],[10,1,12,2],[10,5,12,6],[10,8,12,10],[10,12,12,14],[10,16,12,23],[13,16,16,20],[14,21,17,23],[17,0,19,0],[17,1,19,4],[17,6,19,10],[17,12,19,16],[18,21,19,23],[13,0,16,0],[13,1,16,2],[13,6,16,6],[13,8,16,10],[13,12,16,14],[21,18,21,24],[22,16,22,17],[22,18,22,24],[30,4,30,8],[30,10,30,15],[30,16,30,17],[30,18,30,24],[24,16,24,17],[24,18,24,24],[25,16,25,17],[25,18,25,24],[26,16,26,17],[26,18,26,24],[27,16,27,17],[27,18,27,24],[28,16,28,17],[23,16,23,17],[23,18,23,24],[20,0,20,26],[21,16,21,17],[34,0,44,26],[31,1,31,4],[31,7,31,8],[31,9,31,11],[31,14,31,24],[32,1,32,4],[32,6,32,10],[32,14,32,24],[28,18,28,24],[29,0,29,26],[33,0,33,3],[33,7,33,8],[33,12,33,15]]}
[null,null,{"$f":"الكشوفات!C1","v":0},{"$f":"الكشوفات!D1","v":0},{"$f":"الكشوفات!E1","v":0}]
[null,{"$f":"$E$1","v":0},null,null,null,null,null,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":"MAX(الكشوفات!A4:A7)","v":4},"مجموع عدد الطلاب "]
[]
[null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,4))","v":"2023/2022"}]
[null,{"$f":"$C$1","v":0}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,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,1,"رقم الشهادة"]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,3))","v":"علي محمد محمد الجندي"}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,7))","v":"ذكر"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,10))","v":"2002\\12\\25"}]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,11))","v":0}]
[]
[]
[]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,2))","v":1}]
[]
[]
[null,null,null,null,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":"$AC$6","v":1}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,12))","v":17},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,13))","v":24},null,{"$f":"SUM(C22,E22)","v":41},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,14))","v":14},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,15))","v":26},null,{"$f":"SUM(K22,M22)","v":40},null,{"$f":"SUM(O22,G22)","v":81}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,17))","v":17},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,18))","v":24},null,{"$f":"SUM(C23,E23)","v":41},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,19))","v":14},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,20))","v":27},null,{"$f":"SUM(K23,M23)","v":41},null,{"$f":"SUM(O23,G23)","v":82}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,22))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,23))","v":22},null,38,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,24))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,25))","v":30},null,46,null,84]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",IF(B6=\"الثالث\",\"\",IF(B6=\"الرابع\",\"\",IF(B6=\"الخامس\",\"\",IF(B6=\"السادس\",\"\",INDEX(طباعة,$AC21,27))))))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,28)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(C25,E25))","v":""},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,29)))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF($C$25=\"\",\"\",INDEX(طباعة,$AC21,30)))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(K25,M25))","v":""},null,{"$f":"IF($C$25=\"\",\"\",SUM(O25,G25))","v":""}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,32))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,33))","v":23},null,38,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,34))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,35))","v":25},null,41,null,79]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,37))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,38))","v":22},null,37,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,39))","v":14},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,40))","v":25},null,39,null,76]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,42))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,43))))","v":""},null,{"$f":"IF(C28=\"\",\"\",SUM(C28,E28))","v":""},null,null,null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,44))))","v":""},null,{"$f":"IF($AC21>$AF$2,\"\",IF(B6=\"الأول\",\"\",IF(B6=\"الثاني\",\"\",INDEX(طباعة,$AC21,45))))","v":""},null,{"$f":"IF(K28=\"\",\"\",SUM(K28,M28))","v":""},null,{"$f":"IF(K28=\"\",\"\",SUM(O28,G28))","v":""}]
[null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,47))","v":15},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,48))","v":25},null,40,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,49))","v":16},null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,50))","v":30},null,46,null,86]
[]
[null,null,{"$f":"SUM(Q22:R29)","v":488},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:R29)","v":488}]
[null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,56))","v":"ناجح"},null,null,null,null,null,null,null,{"$f":"IF($AC21>$AF$2,\"\",INDEX(طباعة,$AC21,53))","v":0.69714285714285706}]