{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["البيانات","سجل الترحيل"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":284,"n_cols":18,"rows_kept":284,"cut":false,"hidden":false,"merged":[[4,9,11,23]]}
[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,86,null,null,null,null,"ناجح"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"له دور ثان"]
["ت","اسم التلميذ","النتيجة","القيد","الجنس","النتيجة"]
[{"$f":"IF(B5=\"\",\"\",ROW()-4)","v":1},"اسماء1","راسب",null,null,null,null,null,{"$f":"IF(E5=$E$2,1,2)","v":2},"السلام عليكم بالبحث وجدت هذا الكود للأستاذ ياسر خليل ارجو إضافة على الكود ، الكود هنا يقوم بترحيل البينات على حسب عدد البيانات من شيت البيانات ويرحلها الى شيت سجل الترحيل ويقسم البيانات الى نصفين لحد هنا جميل جدا المطلوب التعديل على ان يرحل البيانات الى نصفين على حسب الاختيار من خلية F2 ثم يرحل النتائج الى شيت سجل الترحيل مثلا اخترت من القائمة المنسدلة ناجح يرحل كل بيانات الناجح وهكذا ان اخترت راسب يرحل الراسبون"]
[2,"اسماء2","ناجح",null,null,null,null,null,2]
[3,"اسماء3","له دور ثان",null,null,null,null,null,2]
[4,"اسماء4","راسب",null,null,null,null,null,2]
[5,"اسماء5","ناجح",null,null,null,null,null,2]
[6,"اسماء6","ناجح",null,null,null,null,null,2]
[7,"اسماء7","ناجح",null,null,null,null,null,2]
[8,"اسماء8","ناجح",null,null,null,null,null,2]
[9,"اسماء9","له دور ثان",null,null,null,null,null,2]
[10,"اسماء10","راسب",null,null,null,null,null,2]
[11,"اسماء11","ناجح",null,null,null,null,null,2]
[12,"اسماء12","له دور ثان",null,null,null,null,null,2]
[13,"اسماء13","راسب",null,null,null,null,null,2]
[14,"اسماء14","ناجح",null,null,null,null,null,2]
[15,"اسماء15","ناجح",null,null,null,null,null,2]
[16,"اسماء16","راسب",null,null,null,null,null,2]
[17,"اسماء17","ناجح",null,null,null,null,null,2]
[18,"اسماء18","ناجح",null,null,null,null,null,2]
[19,"اسماء19","راسب",null,null,null,null,null,2]
[20,"اسماء20","ناجح",null,null,null,null,null,2]
[21,"اسماء21","ناجح",null,null,null,null,null,2]
[22,"اسماء22","راسب",null,null,null,null,null,2]
[23,"اسماء23","ناجح",null,null,null,null,null,2]
[24,"اسماء24","ناجح",null,null,null,null,null,2]
[25,"اسماء25","راسب",null,null,null,null,null,2]
[26,"اسماء26","ناجح",null,null,null,null,null,2]
[27,"اسماء27","له دور ثان",null,null,null,null,null,2]
[28,"اسماء28","له دور ثان",null,null,null,null,null,2]
[29,"اسماء29","ناجح",null,null,null,null,null,2]
[30,"اسماء30","له دور ثان",null,null,null,null,null,2]
[31,"اسماء31","له دور ثان",null,null,null,null,null,2]
[32,"اسماء32","ناجح",null,null,null,null,null,2]
[33,"اسماء33","له دور ثان",null,null,null,null,null,{"$f":"IF(E37=$E$2,1,2)","v":2}]
[34,"اسماء34","ناجح",null,null,null,null,null,2]
[35,"اسماء35","ناجح",null,null,null,null,null,2]
[36,"اسماء36","له دور ثان",null,null,null,null,null,2]
[37,"اسماء37","راسب",null,null,null,null,null,2]
[38,"احمد1","ناجح",null,null,null,null,null,2]
[39,"احمد2","له دور ثان",null,null,null,null,null,2]
[40,"احمد3","راسب",null,null,null,null,null,2]
[41,"احمد4","ناجح",null,null,null,null,null,2]
[42,"احمد5","له دور ثان",null,null,null,null,null,2]
[43,"احمد6","راسب",null,null,null,null,null,2]
[44,"احمد7","ناجح",null,null,null,null,null,2]
[45,"احمد8","له دور ثان",null,null,null,null,null,2]
[46,"احمد9","راسب",null,null,null,null,null,2]
[47,"احمد10","ناجح",null,null,null,null,null,2]
[48,"احمد11","له دور ثان",null,null,null,null,null,2]
[49,"احمد12","راسب",null,null,null,null,null,2]
[50,"احمد13","ناجح",null,null,null,null,null,2]
[51,"احمد14","ناجح",null,null,null,null,null,2]
[52,"احمد15","راسب",null,null,null,null,null,2]
[53,"احمد16","ناجح",null,null,null,null,null,2]
[54,"احمد17","له دور ثان",null,null,null,null,null,2]
[55,"احمد18","ناجح",null,null,null,null,null,2]
[56,"احمد19","ناجح",null,null,null,null,null,2]
[57,"احمد20","له دور ثان",null,null,null,null,null,2]
[58,"احمد21","راسب",null,null,null,null,null,2]
[59,"احمد22","ناجح",null,null,null,null,null,2]
[60,"احمد23","له دور ثان",null,null,null,null,null,2]
[61,"احمد24","راسب",null,null,null,null,null,2]
[62,"احمد25","ناجح",null,null,null,null,null,2]
[63,"احمد26","له دور ثان",null,null,null,null,null,2]
[64,"احمد27","راسب",null,null,null,null,null,2]
[{"$f":"IF(B69=\"\",\"\",ROW()-4)","v":65},"احمد28","ناجح",null,null,null,null,null,{"$f":"IF(E69=$E$2,1,2)","v":2}]
[66,"احمد29","له دور ثان",null,null,null,null,null,2]
[67,"احمد30","راسب",null,null,null,null,null,2]
[68,"احمد31","ناجح",null,null,null,null,null,2]
[69,"احمد32","له دور ثان",null,null,null,null,null,2]
[70,"احمد33","راسب",null,null,null,null,null,2]
[71,"احمد34","ناجح",null,null,null,null,null,2]
[72,"احمد35","له دور ثان",null,null,null,null,null,2]
[73,"احمد36","راسب",null,null,null,null,null,2]
[74,"احمد37","ناجح",null,null,null,null,null,2]
[75,"احمد38","له دور ثان",null,null,null,null,null,2]
[76,"احمد39","راسب",null,null,null,null,null,2]
[77,"احمد40","ناجح",null,null,null,null,null,2]
[78,"احمد41","له دور ثان",null,null,null,null,null,2]
[79,"احمد42","راسب",null,null,null,null,null,2]
[80,"احمد43","ناجح",null,null,null,null,null,2]
[81,"احمد44","له دور ثان",null,null,null,null,null,2]
[82,"احمد45","راسب",null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,{"$f":"IF(E101=$E$2,1,2)","v":2}]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
["",null,null,null,null,null,null,null,2]
[""]
[""]
[{"$f":"IF(B133=\"\",\"\",ROW()-4)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B197=\"\",\"\",ROW()-4)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B261=\"\",\"\",ROW()-4)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"سجل الترحيل","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,12,10,16],[6,12,6,16],[11,12,11,17],[12,12,12,16],[7,12,7,16],[8,12,8,16],[9,12,9,16]]}
["إدارة","             سجل الترحيل",null,"العدد:  1                "]
["مدرسة ","                 للعام الدراسي 2015-2016",null,"مجموع تلاميذ الصف :(     )"]
["المختلطة",null,"الناجحون من الصف ( الاول) للعام 2015-2016 الى الصف (   الثاني  ) للعام 2016-2017                        "]
["ت","اسم التلميذ","ت","اسم التلميذ"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"المطلوب ان يقوم بتقسيم البيانات هنا الى نصفين بحيث يقوم "]
[null,null,null,null,null,null,null,null,null,null,null,null,"بوضع 41طالب هنا من عمود E:A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"وهنا يضع 41 طالبا من عمود J:F"]
[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 طالب يقوم بترحيلهم وتقسيمهم الى نصفين"]