{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["البيانات","سجل الترحيل","AAA"],"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,86,null,null,null,null,"ناجح"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"له دور ثان"]
["ت","اسم التلميذ","النتيجة","القيد","الجنس","النتيجة"]
[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]
[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]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"سجل الترحيل","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,12,12,16],[6,12,6,16],[7,12,7,16],[8,12,8,16],[9,12,9,16],[10,12,10,16],[11,12,11,17]]}
["إدارة","             سجل الترحيل",null,"العدد:  1                "]
["مدرسة ","                 للعام الدراسي 2015-2016",null,"مجموع تلاميذ الصف :(     )"]
["المختلطة",null,"الناجحون من الصف ( الاول) للعام 2015-2016 الى الصف (   الثاني  ) للعام 2016-2017                        "]
["ت","اسم التلميذ","ت","اسم التلميذ"]
[null,"اسماء3",null,"احمد8"]
[null,"اسماء9",null,"احمد11"]
[null,"اسماء12",null,"احمد17",null,null,null,null,null,null,null,null,"المطلوب ان يقوم بتقسيم البيانات هنا الى نصفين بحيث يقوم "]
[null,"اسماء27",null,"احمد20",null,null,null,null,null,null,null,null,"بوضع 41طالب هنا من عمود E:A"]
[null,"اسماء28",null,"احمد23"]
[null,"اسماء30",null,"احمد26",null,null,null,null,null,null,null,null,"وهنا يضع 41 طالبا من عمود J:F"]
[null,"اسماء31",null,"احمد29",null,null,null,null,null,null,null,null,"ويبقى نفس التسلسل لكل طالب"]
[null,"اسماء33",null,"احمد32",null,null,null,null,null,null,null,null,"ويكون الكود مطاطياً بحيث تتغير اعداد التلاميذ وكذلك يقوم بترحيلها الى ورقة الناجحون"]
[null,"اسماء36",null,"احمد35",null,null,null,null,null,null,null,null,"لو كان عدد الطلاب 100 طالب يقوم بترحيلهم وتقسيمهم الى نصفين"]
[null,"احمد2",null,"احمد38"]
[null,"احمد5",null,"احمد41"]
[null,null,null,"احمد44"]

{"sheet":"AAA","index":2,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["ت","اسم التلميذ","النتيجة","القيد","الجنس","النتيجة"]
[{"$f":"IF(B5=\"\",\"\",COUNTA($B$5:B5))","v":1},"اسماء3","له دور ثان"]
[{"$f":"IF(B6=\"\",\"\",COUNTA($B$5:B6))","v":2},"اسماء9","له دور ثان"]
[{"$f":"IF(B7=\"\",\"\",COUNTA($B$5:B7))","v":3},"اسماء12","له دور ثان"]
[{"$f":"IF(B8=\"\",\"\",COUNTA($B$5:B8))","v":4},"اسماء27","له دور ثان"]
[{"$f":"IF(B9=\"\",\"\",COUNTA($B$5:B9))","v":5},"اسماء28","له دور ثان"]
[{"$f":"IF(B10=\"\",\"\",COUNTA($B$5:B10))","v":6},"اسماء30","له دور ثان"]
[{"$f":"IF(B11=\"\",\"\",COUNTA($B$5:B11))","v":7},"اسماء31","له دور ثان"]
[{"$f":"IF(B12=\"\",\"\",COUNTA($B$5:B12))","v":8},"اسماء33","له دور ثان"]
[{"$f":"IF(B13=\"\",\"\",COUNTA($B$5:B13))","v":9},"اسماء36","له دور ثان"]
[{"$f":"IF(B14=\"\",\"\",COUNTA($B$5:B14))","v":10},"احمد2","له دور ثان"]
[{"$f":"IF(B15=\"\",\"\",COUNTA($B$5:B15))","v":11},"احمد5","له دور ثان"]
[{"$f":"IF(B16=\"\",\"\",COUNTA($B$5:B16))","v":12},"احمد8","له دور ثان"]
[{"$f":"IF(B17=\"\",\"\",COUNTA($B$5:B17))","v":13},"احمد11","له دور ثان"]
[{"$f":"IF(B18=\"\",\"\",COUNTA($B$5:B18))","v":14},"احمد17","له دور ثان"]
[{"$f":"IF(B19=\"\",\"\",COUNTA($B$5:B19))","v":15},"احمد20","له دور ثان"]
[{"$f":"IF(B20=\"\",\"\",COUNTA($B$5:B20))","v":16},"احمد23","له دور ثان"]
[{"$f":"IF(B21=\"\",\"\",COUNTA($B$5:B21))","v":17},"احمد26","له دور ثان"]
[{"$f":"IF(B22=\"\",\"\",COUNTA($B$5:B22))","v":18},"احمد29","له دور ثان"]
[{"$f":"IF(B23=\"\",\"\",COUNTA($B$5:B23))","v":19},"احمد32","له دور ثان"]
[{"$f":"IF(B24=\"\",\"\",COUNTA($B$5:B24))","v":20},"احمد35","له دور ثان"]
[{"$f":"IF(B25=\"\",\"\",COUNTA($B$5:B25))","v":21},"احمد38","له دور ثان"]
[{"$f":"IF(B26=\"\",\"\",COUNTA($B$5:B26))","v":22},"احمد41","له دور ثان"]
[{"$f":"IF(B27=\"\",\"\",COUNTA($B$5:B27))","v":23},"احمد44","له دور ثان"]
[{"$f":"IF(B28=\"\",\"\",COUNTA($B$5:B28))","v":""}]
[{"$f":"IF(B29=\"\",\"\",COUNTA($B$5:B29))","v":""}]
[{"$f":"IF(B30=\"\",\"\",COUNTA($B$5:B30))","v":""}]
[{"$f":"IF(B31=\"\",\"\",COUNTA($B$5:B31))","v":""}]
[{"$f":"IF(B32=\"\",\"\",COUNTA($B$5:B32))","v":""}]
[{"$f":"IF(B33=\"\",\"\",COUNTA($B$5:B33))","v":""}]
[{"$f":"IF(B34=\"\",\"\",COUNTA($B$5:B34))","v":""}]
[{"$f":"IF(B35=\"\",\"\",COUNTA($B$5:B35))","v":""}]
[{"$f":"IF(B36=\"\",\"\",COUNTA($B$5:B36))","v":""}]
[{"$f":"IF(B37=\"\",\"\",COUNTA($B$5:B37))","v":""}]
[{"$f":"IF(B38=\"\",\"\",COUNTA($B$5:B38))","v":""}]
[{"$f":"IF(B39=\"\",\"\",COUNTA($B$5:B39))","v":""}]
[{"$f":"IF(B40=\"\",\"\",COUNTA($B$5:B40))","v":""}]
[{"$f":"IF(B41=\"\",\"\",COUNTA($B$5:B41))","v":""}]
[{"$f":"IF(B42=\"\",\"\",COUNTA($B$5:B42))","v":""}]
[{"$f":"IF(B43=\"\",\"\",COUNTA($B$5:B43))","v":""}]
[{"$f":"IF(B44=\"\",\"\",COUNTA($B$5:B44))","v":""}]
[{"$f":"IF(B45=\"\",\"\",COUNTA($B$5:B45))","v":""}]
[{"$f":"IF(B46=\"\",\"\",COUNTA($B$5:B46))","v":""}]
[{"$f":"IF(B47=\"\",\"\",COUNTA($B$5:B47))","v":""}]
[{"$f":"IF(B48=\"\",\"\",COUNTA($B$5:B48))","v":""}]
[{"$f":"IF(B49=\"\",\"\",COUNTA($B$5:B49))","v":""}]
[{"$f":"IF(B50=\"\",\"\",COUNTA($B$5:B50))","v":""}]
[{"$f":"IF(B51=\"\",\"\",COUNTA($B$5:B51))","v":""}]
[{"$f":"IF(B52=\"\",\"\",COUNTA($B$5:B52))","v":""}]
[{"$f":"IF(B53=\"\",\"\",COUNTA($B$5:B53))","v":""}]
[{"$f":"IF(B54=\"\",\"\",COUNTA($B$5:B54))","v":""}]
[{"$f":"IF(B55=\"\",\"\",COUNTA($B$5:B55))","v":""}]
[{"$f":"IF(B56=\"\",\"\",COUNTA($B$5:B56))","v":""}]
[{"$f":"IF(B57=\"\",\"\",COUNTA($B$5:B57))","v":""}]
[{"$f":"IF(B58=\"\",\"\",COUNTA($B$5:B58))","v":""}]
[{"$f":"IF(B59=\"\",\"\",COUNTA($B$5:B59))","v":""}]
[{"$f":"IF(B60=\"\",\"\",COUNTA($B$5:B60))","v":""}]
[{"$f":"IF(B61=\"\",\"\",COUNTA($B$5:B61))","v":""}]
[{"$f":"IF(B62=\"\",\"\",COUNTA($B$5:B62))","v":""}]
[{"$f":"IF(B63=\"\",\"\",COUNTA($B$5:B63))","v":""}]
[{"$f":"IF(B64=\"\",\"\",COUNTA($B$5:B64))","v":""}]
[{"$f":"IF(B65=\"\",\"\",COUNTA($B$5:B65))","v":""}]
[{"$f":"IF(B66=\"\",\"\",COUNTA($B$5:B66))","v":""}]
[{"$f":"IF(B67=\"\",\"\",COUNTA($B$5:B67))","v":""}]
[{"$f":"IF(B68=\"\",\"\",COUNTA($B$5:B68))","v":""}]
[{"$f":"IF(B69=\"\",\"\",COUNTA($B$5:B69))","v":""}]
[{"$f":"IF(B70=\"\",\"\",COUNTA($B$5:B70))","v":""}]
[{"$f":"IF(B71=\"\",\"\",COUNTA($B$5:B71))","v":""}]
[{"$f":"IF(B72=\"\",\"\",COUNTA($B$5:B72))","v":""}]
[{"$f":"IF(B73=\"\",\"\",COUNTA($B$5:B73))","v":""}]
[{"$f":"IF(B74=\"\",\"\",COUNTA($B$5:B74))","v":""}]
[{"$f":"IF(B75=\"\",\"\",COUNTA($B$5:B75))","v":""}]
[{"$f":"IF(B76=\"\",\"\",COUNTA($B$5:B76))","v":""}]
[{"$f":"IF(B77=\"\",\"\",COUNTA($B$5:B77))","v":""}]
[{"$f":"IF(B78=\"\",\"\",COUNTA($B$5:B78))","v":""}]
[{"$f":"IF(B79=\"\",\"\",COUNTA($B$5:B79))","v":""}]
[{"$f":"IF(B80=\"\",\"\",COUNTA($B$5:B80))","v":""}]
[{"$f":"IF(B81=\"\",\"\",COUNTA($B$5:B81))","v":""}]
[{"$f":"IF(B82=\"\",\"\",COUNTA($B$5:B82))","v":""}]
[{"$f":"IF(B83=\"\",\"\",COUNTA($B$5:B83))","v":""}]
[{"$f":"IF(B84=\"\",\"\",COUNTA($B$5:B84))","v":""}]
[{"$f":"IF(B85=\"\",\"\",COUNTA($B$5:B85))","v":""}]
[{"$f":"IF(B86=\"\",\"\",COUNTA($B$5:B86))","v":""}]
[{"$f":"IF(B87=\"\",\"\",COUNTA($B$5:B87))","v":""}]
[{"$f":"IF(B88=\"\",\"\",COUNTA($B$5:B88))","v":""}]
[{"$f":"IF(B89=\"\",\"\",COUNTA($B$5:B89))","v":""}]
[{"$f":"IF(B90=\"\",\"\",COUNTA($B$5:B90))","v":""}]
[{"$f":"IF(B91=\"\",\"\",COUNTA($B$5:B91))","v":""}]
[{"$f":"IF(B92=\"\",\"\",COUNTA($B$5:B92))","v":""}]
[{"$f":"IF(B93=\"\",\"\",COUNTA($B$5:B93))","v":""}]
[{"$f":"IF(B94=\"\",\"\",COUNTA($B$5:B94))","v":""}]
[{"$f":"IF(B95=\"\",\"\",COUNTA($B$5:B95))","v":""}]
[{"$f":"IF(B96=\"\",\"\",COUNTA($B$5:B96))","v":""}]
[{"$f":"IF(B97=\"\",\"\",COUNTA($B$5:B97))","v":""}]
[{"$f":"IF(B98=\"\",\"\",COUNTA($B$5:B98))","v":""}]
[{"$f":"IF(B99=\"\",\"\",COUNTA($B$5:B99))","v":""}]
[{"$f":"IF(B100=\"\",\"\",COUNTA($B$5:B100))","v":""}]