{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الدرجات","salim","Sapace"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"الدرجات","index":0,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["ت","رقم قيده","اسم التلميذ","الصف والشعبة","الجنس","الاسلامية*","العربية*","الرياضيات*","العلوم*","الفنية والنشيد*","الرياضة*","الاجتماعيات*","النتيجة*","المجموع*","مواد الرسوب*","الصف بدون شعبه ","النتيجة","التولد"]
[1,"83/5","احمد","الاول - أ","ذكر",10,10,10,10,10,10,null,{"$f":"IF(COUNTIF(F5:L5,\"<>\")<6,\"\",IF(COUNTIF(F5:L5,\"صفر\")>=6,IF($E5=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F5:L5,\"<5\")+COUNTIF(F5:L5,\"صفر\")>=3,IF($E5=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F5:L5,\"<5\")+COUNTIF(F5:L5,\"غائب\")=1,IF($E5=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F5:L5,\"<5\")+COUNTIF(F5:L5,\"غائب\")=2,IF($E5=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E5=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"ناجح"},{"$f":"IF(OR(M5=\"ناجح\",M5=\"راسب\",M5=\"ناجحة\",M5=\"راسبة\"),SUM(F5:L5),\"\")","v":60},{"$f":"IF(COUNTIF(F5:K5,\"<>\")<6,\"\",IF(M5=\"\",\"\",IF(OR(F5<5,F5=\"صفر\"),$F$4,\"\")&\" \"&IF(OR(G5<5,G5=\"صفر\"),$G$4,\"\")&\" \"&IF(OR(H5<5,H5=\"صفر\"),$H$4,\"\")&\" \"&IF(OR(I5<5,I5=\"صفر\"),$I$4,\"\")&\" \"&IF(OR(J5<5,J5=\"صفر\"),$J$4,\"\")&\" \"&IF(OR(K5<5,K5=\"صفر\"),$K$4,\"\")))","v":"     "},{"$f":"IF(OR(D5=$T$5,D5=$T$6,D5=$T$7,D5=$T$8),\"الاول\",IF(OR(D5=$T$9,D5=$T$10,D5=$T$11,D5=$T$12),\"الثاني\",IF(OR(D5=$T$13,D5=$T$14,D5=$T$15,D5=$T$16),\"الثالث\",IF(OR(D5=$T$17,D5=$T$18,D5=$T$19,D5=$T$20),\"الرابع\",\"\"))))","v":"الاول"},{"$f":"IF(C5=\"\",\"\",IF(M5=\"ناجحة\",\"ناجح\",IF(M5=\"راسبة\",\"راسب\",IF(M5=\"غائبة\",\"غائب\",IF(M5=\"مكملة\",\"مكمل\",M5)))))","v":"ناجح"},"2006-05-24",null,"الاول - أ"]
[2,"84/5","علي","الاول - أ","ذكر",10,10,10,10,10,10,null,{"$f":"IF(COUNTIF(F6:L6,\"<>\")<6,\"\",IF(COUNTIF(F6:L6,\"صفر\")>=6,IF($E6=\"ذكر\",\"غائب\",\"غائبة\"),IF(COUNTIF(F6:L6,\"<5\")+COUNTIF(F6:L6,\"صفر\")>=3,IF($E6=\"ذكر\",\"راسب\",\"راسبة\"),IF(COUNTIF(F6:L6,\"<5\")+COUNTIF(F6:L6,\"غائب\")=1,IF($E6=\"ذكر\",\"مكمل\",\"مكملة\"),IF(COUNTIF(F6:L6,\"<5\")+COUNTIF(F6:L6,\"غائب\")=2,IF($E6=\"ذكر\",\"مكمل\",\"مكملة\"),IF($E6=\"ذكر\",\"ناجح\",\"ناجحة\"))))))","v":"ناجح"},{"$f":"IF(OR(M6=\"ناجح\",M6=\"راسب\",M6=\"ناجحة\",M6=\"راسبة\"),SUM(F6:L6),\"\")","v":60},{"$f":"IF(COUNTIF(F6:K6,\"<>\")<6,\"\",IF(M6=\"\",\"\",IF(OR(F6<5,F6=\"صفر\"),$F$4,\"\")&\" \"&IF(OR(G6<5,G6=\"صفر\"),$G$4,\"\")&\" \"&IF(OR(H6<5,H6=\"صفر\"),$H$4,\"\")&\" \"&IF(OR(I6<5,I6=\"صفر\"),$I$4,\"\")&\" \"&IF(OR(J6<5,J6=\"صفر\"),$J$4,\"\")&\" \"&IF(OR(K6<5,K6=\"صفر\"),$K$4,\"\")))","v":"     "},{"$f":"IF(OR(D6=$T$5,D6=$T$6,D6=$T$7,D6=$T$8),\"الاول\",IF(OR(D6=$T$9,D6=$T$10,D6=$T$11,D6=$T$12),\"الثاني\",IF(OR(D6=$T$13,D6=$T$14,D6=$T$15,D6=$T$16),\"الثالث\",IF(OR(D6=$T$17,D6=$T$18,D6=$T$19,D6=$T$20),\"الرابع\",\"\"))))","v":"الاول"},{"$f":"IF(C6=\"\",\"\",IF(M6=\"ناجحة\",\"ناجح\",IF(M6=\"راسبة\",\"راسب\",IF(M6=\"غائبة\",\"غائب\",IF(M6=\"مكملة\",\"مكمل\",M6)))))","v":"ناجح"},"2006-06-04",null,"الاول - ب"]
[3,"85/5","صادق","الاول - أ","ذكر",10,10,10,10,10,10,null,"ناجح",60,"     ","الاول","ناجح","2006-04-14",null,"الاول - ج"]
[4,"86/5","جعفر","الاول - أ","ذكر",6,4,4,4,9,10,null,"راسب",37," العربية* الرياضيات* العلوم*  ","الاول","راسب","2006-03-19",null,"الاول - د"]
[5,"87/5","وليد","الاول - أ","ذكر",10,10,10,10,10,10,null,"ناجح",60,"     ","الاول","ناجح","2006-10-19",null,"الثاني - أ"]
[6,"88/5","سالم","الاول - ب","ذكر",10,10,8,9,10,10,null,"ناجح",57,"     ","الاول","ناجح","2006-03-18",null,"الثاني - ب"]
[7,"89/5","محمد","الاول - ب","ذكر",4,4,4,7,8,8,null,"راسب",35,"الاسلامية* العربية* الرياضيات*   ","الاول","راسب","2006-12-03",null,"الثاني - ج"]
[8,"90/5","هادي","الاول - ب","ذكر",5,5,5,7,8,8,null,"ناجح",38,"     ","الاول","ناجح","2005-10-12",null,"الثاني - د"]
[9,"91/5","خالد","الاول - ب","ذكر",4,4,4,7,8,8,null,"راسب",35,"الاسلامية* العربية* الرياضيات*   ","الاول","راسب","2006-04-12",null,"الثالث - أ"]
[10,"92/5","زيد","الاول - ب","ذكر",5,4,5,8,8,10,null,"مكمل",""," العربية*    ","الاول","مكمل","2006-09-01",null,"الثالث - ب"]
[11,"93/5","احمد 11","الثاني - أ","ذكر",7,4,6,8,8,9,null,"مكمل",""," العربية*    ","الثاني","مكمل","2006-03-07",null,"الثالث - ج"]
[12,"46/5","احمد 12","الثاني - أ","ذكر",7,5,5,7,9,10,null,"ناجح",43,"     ","الثاني","ناجح","2006-09-20",null,"الثالث - د"]
[13,"94/5","احمد 13","الثاني - أ","ذكر",10,10,10,10,10,10,null,"ناجح",60,"     ","الثاني","ناجح","2006-11-29",null,"الرابع - أ"]
[14,"74/5","احمد 14","الثاني - أ","ذكر",9,9,9,9,10,10,null,"ناجح",56,"     ","الثاني","ناجح","2006-11-10",null,"الرابع - ب"]
[15,"41/5","احمد 15","الثاني - أ","ذكر",7,6,7,8,9,10,null,"ناجح",47,"     ","الثاني","ناجح","2006-09-05",null,"الرابع - ج"]
[16,"96/5","احمد 16","الثاني - ب","ذكر",3,3,3,6,8,8,null,"راسب",31,"الاسلامية* العربية* الرياضيات*   ","الثاني","راسب","2006-06-24",null,"الرابع - د"]
[17,"97/5","احمد 17","الثاني - ب","ذكر",8,7,7,8,9,9,null,"ناجح",48,"     ","الثاني","ناجح","2005-04-20"]
[18,"98/5","احمد 18","الثاني - ب","ذكر",9,9,8,9,10,10,null,"ناجح",55,"     ","الثاني","ناجح","2006-01-04"]
[19,"9/5","احمد 19","الثاني - ب","ذكر",6,6,3,8,8,9,null,"مكمل","","  الرياضيات*   ","الثاني","مكمل","2007-01-30"]
[20,"100/5","احمد 20","الثاني - ب","ذكر",10,10,10,10,10,10,null,"ناجح",60,"     ","الثاني","ناجح","2006-09-04"]
[21,"101/5","احمد 21","الثالث - أ","ذكر",5,4,5,7,8,9,null,"مكمل",""," العربية*    ","الثالث","مكمل","2006-01-19"]
[22,"355/4","احمد 22","الثالث - أ","ذكر",6,5,5,8,8,9,null,"ناجح",41,"     ","الثالث","ناجح","2006-10-15"]
[23,"102/5","احمد 23","الثالث - أ","ذكر",10,10,10,10,10,10,null,"ناجح",60,"     ","الثالث","ناجح","2006-07-19"]
[24,"103/5","احمد 24","الثالث - أ","ذكر",5,4,4,7,8,9,null,"مكمل",""," العربية* الرياضيات*   ","الثالث","مكمل","2005-02-03"]
[25,"354/4","احمد 25","الثالث - أ","ذكر",8,8,8,8,10,10,null,"ناجح",52,"     ","الثالث","ناجح","2004-11-16"]
[26,"104/5","احمد 26","الثالث - ب","انثى",10,10,8,10,10,10,null,"ناجحة",58,"     ","الثالث","ناجح","2007-01-07"]
[27,"105/5","احمد 27","الثالث - ب","انثى",8,8,7,8,9,9,null,"ناجحة",49,"     ","الثالث","ناجح","2006-02-15"]
[28,"30/5","احمد 28","الثالث - ب","انثى",8,7,7,8,9,8,null,"ناجحة",47,"     ","الثالث","ناجح","2006-09-01"]
[29,"106/5","احمد 29","الثالث - ب","انثى",8,8,8,9,10,9,null,"ناجحة",52,"     ","الثالث","ناجح","2006-08-12"]
[30,"107/5","احمد 30","الثالث - ب","انثى",10,10,10,10,10,10,null,"ناجحة",60,"     ","الثالث","ناجح","2006-03-28"]
[31,"367/4","احمد 31","الرابع - أ","انثى",8,7,6,8,9,8,null,"ناجحة",46,"     ","الرابع","ناجح","2005-08-11"]
[32,"108/5","احمد 32","الرابع - أ","انثى",10,10,10,10,10,10,null,"ناجحة",60,"     ","الرابع","ناجح","2006-02-19"]
[33,"109/5","احمد 33","الرابع - أ","انثى",8,8,8,8,9,9,null,"ناجحة",50,"     ","الرابع","ناجح","2006-07-13"]
[34,"110/5","احمد 34","الرابع - أ","انثى",5,4,4,7,8,8,null,"مكملة",""," العربية* الرياضيات*   ","الرابع","مكمل","2005-02-22"]
[35,"111/5","احمد 35","الرابع - أ","انثى",5,4,5,7,8,8,null,"مكملة",""," العربية*    ","الرابع","مكمل","2006-05-09"]
[36,"112/5","احمد 36","الرابع - ب","انثى",7,7,6,8,9,9,null,"ناجحة",46,"     ","الرابع","ناجح","2006-09-11"]
[37,"113/5","احمد 37","الرابع - ب","انثى",10,10,10,10,10,10,null,"ناجحة",60,"     ","الرابع","ناجح","2006-09-07"]
[38,"114/5","احمد 38","الرابع - ب","انثى",10,10,10,10,10,10,null,"ناجحة",60,"     ","الرابع","ناجح","2006-03-06"]
[39,"115/5","احمد 39","الرابع - ب","انثى",7,6,5,8,9,10,null,"ناجحة",45,"     ","الرابع","ناجح","2005-04-08"]
[40,"116/5","احمد 40","الرابع - ب","انثى",10,9,10,10,10,10,null,"ناجحة",59,"     ","الرابع","ناجح","2006-05-23"]

{"sheet":"salim","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,11,19,15]]}
[null,null,null,null,null,null,null,null,null,null,null,"عدد الطلاب"]
[null,null,null,"مكمل",null,null,null,null,null,null,null,{"$f":"COUNT(A:A)+COUNT(F:F)","v":2}]
[null,null,"الصف","الاول"]
["ت","التولد","القيد","اسم التلميذ","الجنس","ت","التولد","القيد","اسم التلميذ","الجنس"]
[1,"2006-09-01","92/5","زيد","ذكر",2,"2006-09-01","92/5","زيد","ذكر"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الاول","ناجح"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الثاني","راسب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الثالث","مكمل"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الرابع"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"المطلوب جلب البيانات من شيت الدرجات حسب ما مطلوب من قائمة خلية D2 و D3 ……. ويتم توزيع الطلاب حسب مامطلوب من القائمتين  في جدول الترحيل يبدأ التسلسل في خلية A5 يكون رقم 1 وفي خلية F5 يكون التسلسل2 وعلى نفس هذا الترتيب تنازليا ً "]

{"sheet":"Sapace","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["التولد","رقم قيده","اسم التلميذ","الجنس"]
["2006-09-01","92/5","زيد","ذكر"]