{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Source","Target"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Source","index":0,"n_rows":299,"n_cols":18,"rows_kept":299,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[4,6,4,8],[3,7,3,8],[0,6,0,7],[1,6,1,7],[2,6,2,7]]}
[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,"العام الدراسى","2020/2019",null,null,"السن فى اول اكتوبر ",null,"2020-10-01",null,null,null,null,null,null,null,null,"المحافظة","ضعيف"]
[null,null,null,null,null,null,"السن فى أول اكتوبر",null,null,null,null,null,null,null,null,null,"الصف"]
["مسلسل","اسم التلميذ","الرقم القومي","المحافظة","الصف ","تاريخ الميلاد","يوم","شهر","سنة","النوع","الديانة","التقدير"]
[1,"ابراهيم اشرف احمد مصطفى",31112020104059,{"$f":"A_ID(C7,1)","v":"القاهرة"},"الاول",{"$f":"A_ID(C7,2)","v":"2011/12/02"},{"$f":"IF($C7=\"\",\"\",DATEDIF($F7,$H$4,\"md\"))","v":29},{"$f":"IF($C7=\"\",\"\",DATEDIF($F7,$H$4,\"ym\"))","v":9},{"$f":"IF($C7=\"\",\"\",DATEDIF($F7,$H$4,\"y\"))","v":8},{"$f":"A_ID(C7,3)","v":"ذكر"},"مسلم","ضعيف"]
[2,"ابراهيم حسين محمود محمد",26407052800537,{"$f":"A_ID(C8,1)","v":"أسوان"},"الثانى",{"$f":"A_ID(C8,2)","v":"1964/07/05"},{"$f":"IF($C8=\"\",\"\",DATEDIF($F8,$H$4,\"md\"))","v":26},{"$f":"IF($C8=\"\",\"\",DATEDIF($F8,$H$4,\"ym\"))","v":2},{"$f":"IF($C8=\"\",\"\",DATEDIF($F8,$H$4,\"y\"))","v":56},"ذكر","مسلم","جيد"]
[3,"ابراهيم محمد هاشم سلامه",26112282801672,"أسوان","الثالث","1961/12/28",3,9,58,"ذكر","مسلم","امتياز"]
[4,"ابو القاسم محمد على عبدالله",26703170100939,"القاهرة","الثانى","1967/03/17",14,6,53,"ذكر","مسلم","جيد جيدا",null,"القاهرة"]
[5,"ابو عبيده رجب على محمد",25712302800655,"أسوان","الرابع","1957/12/30",1,9,62,"ذكر","مسلم","امتياز"]
[6,"احمد حسن محمد مصطفى",27510042800317,"أسوان","الخامس","1975/10/04",27,11,44,"ذكر","مسلم","ضعيف"]
[7,"احمد سامح بكرى مهران",26710042800527,"أسوان","الاول","1967/10/04",27,11,52,"انثى","مسلم","امتياز"]
[8,"احمد سيد ابراهيم احمد",27706212800297,"أسوان","الاول","1977/06/21",10,3,43,"ذكر","مسلم","جيد"]
[9,"احمد محمد احمد بكرى",26509130200397,"الإسكندرية","الاول","1965/09/13",18,0,55,"ذكر","مسلم","جيد جيدا"]
[10,"اشرف رمضان عمر دياب",25112272800852,"أسوان","الثانى","1951/12/27",4,9,68,"ذكر","مسلم","امتياز"]
[11,"الحسن ريان محمود محمد",28509032801068,"أسوان","الثالث","1985/09/03",28,0,35,"انثى","مسلم","جيد جيدا"]
[12,"الحسن عبد الحميد سيد دياب",26807212800375,"أسوان","الثانى","1968/07/21",10,2,52,"ذكر","مسلم","ضعيف"]
[13,"الحسين عبد الحميد سيد دياب",31112020104075,"القاهرة","الرابع","2011/12/02",29,9,8,"ذكر","مسلم","جيد"]
[14,"الحسيني مصطفى احمد حامد",31108212800418,{"$f":"A_ID(C20,1)","v":"أسوان"},"الخامس",{"$f":"A_ID(C20,2)","v":"2011/08/21"},10,1,9,"ذكر","مسلم","امتياز"]
[15,"اريج محمدصالح عبد الولى ",31206242801208,"أسوان","الرابع","2012/06/24",7,3,8,"انثى","مسلمة","جيد جيدا"]
[16,"اسراء فرح سالم محمود",31207222801003,"أسوان","الاول","2012/07/22",9,2,8,"انثى","مسلمة","امتياز"]
[17,"اسماء حسن عبدالستار احمد",31202052801044,"أسوان","الاول","2012/02/05",26,7,8,"انثى","مسلمة","ضعيف"]
[18,"اشرقت سعيد عبد الوهاب حسن",31203222800761,"أسوان","الثانى","2012/03/22",9,6,8,"انثى","مسلمة","امتياز"]
[19,"الزهراء محمد سيد دياب",31202192801281,"أسوان","الثالث","2012/02/19",12,7,8,"انثى","مسلمة","جيد"]
[20,"ام هاشم مصطفى عبد السلام ",31204292800781,"أسوان","الثانى","2012/04/29",2,5,8,"انثى","مسلمة","جيد جيدا"]
[21,"امنيه محمد صلاح ابراهيم",31204042801405,"أسوان","الرابع","2012/04/04",27,5,8,"انثى","مسلمة","امتياز"]
[22,"بسمة حجازى محمود محمد",31108142800806,"أسوان","الخامس","2011/08/14",17,1,9,"انثى","مسلمة","جيد جيدا"]
[23,"بسمله حسين عبدالستار احمد",31209202800283,"أسوان","الرابع","2012/09/20",11,0,8,"انثى","مسلمة","ضعيف"]
[24,"بسمه حسين عبدالستار احمد",31209202800267,"أسوان","الخامس","2012/09/20",11,0,8,"انثى","مسلمة","جيد"]
[25,null,null,{"$f":"A_ID(C31,1)","v":""},null,{"$f":"A_ID(C31,2)","v":""},"","","",{"$f":"A_ID(C31,3)","v":""}]
[26,null,null,"",null,"","","","",""]
[27,null,null,"",null,"","","","",""]
[28,null,null,"",null,"","","","",""]
[29,null,null,"",null,"","","","",""]
[30,null,null,"",null,"","","","",""]
[31,null,null,"",null,"","","","",""]
[32,null,null,"",null,"","","","",""]
[33,null,null,"",null,"","","","",""]
[34,null,null,"",null,"","","","",""]
[35,null,null,"",null,"","","","",""]
[36,null,null,"",null,"","","","",""]
[37,null,null,"",null,"","","","",""]
[38,null,null,"",null,"","","","",""]
[39,null,null,"",null,"","","","",""]
[40,null,null,"",null,"","","","",""]
[41,null,null,"",null,"","","","",""]
[42,null,null,"",null,"","","","",""]
[43,null,null,"",null,"","","","",""]
[44,null,null,"",null,"","","","",""]
[45,null,null,"",null,"","","","",""]
[46,null,null,"",null,"","","","",""]
[47,null,null,"",null,"","","","",""]
[48,null,null,"",null,"","","","",""]
[49,null,null,"",null,"","","","",""]
[50,null,null,"",null,"","","","",""]
[51,null,null,"",null,"","","","",""]
[52,null,null,"",null,"","","","",""]
[53,null,null,"",null,"","","","",""]
[54,null,null,"",null,"","","","",""]
[55,null,null,"",null,"","","","",""]
[56,null,null,"",null,"","","","",""]
[57,null,null,"",null,"","","","",""]
[58,null,null,"",null,"","","","",""]
[59,null,null,"",null,"","","","",""]
[60,null,null,"",null,"","","","",""]
[61,null,null,"",null,"","","","",""]
[62,null,null,"",null,"","","","",""]
[63,null,null,"",null,"","","","",""]
[64,null,null,"",null,"","","","",""]
[65,null,null,"",null,"","","","",""]
[66,null,null,"",null,"",{"$f":"IF($C72=\"\",\"\",DATEDIF($F72,$H$4,\"md\"))","v":""},{"$f":"IF($C72=\"\",\"\",DATEDIF($F72,$H$4,\"ym\"))","v":""},{"$f":"IF($C72=\"\",\"\",DATEDIF($F72,$H$4,\"y\"))","v":""},""]
[67,null,null,"",null,"","","","",""]
[68,null,null,"",null,"","","","",""]
[69,null,null,"",null,"","","","",""]
[70,null,null,"",null,"","","","",""]
[71,null,null,"",null,"","","","",""]
[72,null,null,"",null,"","","","",""]
[73,null,null,"",null,"","","","",""]
[74,null,null,"",null,"","","","",""]
[75,null,null,"",null,"","","","",""]
[76,null,null,"",null,"","","","",""]
[77,null,null,"",null,"","","","",""]
[78,null,null,"",null,"","","","",""]
[79,null,null,"",null,"","","","",""]
[80,null,null,"",null,"","","","",""]
[81,null,null,"",null,"","","","",""]
[82,null,null,"",null,"","","","",""]
[83,null,null,"",null,"","","","",""]
[84,null,null,"",null,"","","","",""]
[85,null,null,"",null,"","","","",""]
[86,null,null,"",null,"","","","",""]
[87,null,null,"",null,"","","","",""]
[88,null,null,"",null,"","","","",""]
[89,null,null,{"$f":"A_ID(C95,1)","v":""},null,{"$f":"A_ID(C95,2)","v":""},"","","",{"$f":"A_ID(C95,3)","v":""}]
[90,null,null,"",null,"","","","",""]
[91,null,null,"",null,"","","","",""]
[92,null,null,"",null,"","","","",""]
[93,null,null,"",null,"","","","",""]
[94,null,null,"",null,"","","","",""]
[95,null,null,"",null,"","","","",""]
[96,null,null,"",null,"","","","",""]
[97,null,null,"",null,"","","","",""]
[98,null,null,"",null,"","","","",""]
[99,null,null,"",null,"","","","",""]
[100,null,null,"",null,"","","","",""]
[101,null,null,"",null,"","","","",""]
[102,null,null,"",null,"","","","",""]
[103,null,null,"",null,"","","","",""]
[104,null,null,"",null,"","","","",""]
[105,null,null,"",null,"","","","",""]
[106,null,null,"",null,"","","","",""]
[107,null,null,"",null,"","","","",""]
[108,null,null,"",null,"","","","",""]
[109,null,null,"",null,"","","","",""]
[110,null,null,"",null,"","","","",""]
[111,null,null,"",null,"","","","",""]
[112,null,null,"",null,"","","","",""]
[113,null,null,"",null,"","","","",""]
[114,null,null,"",null,"","","","",""]
[115,null,null,"",null,"","","","",""]
[116,null,null,"",null,"","","","",""]
[117,null,null,"",null,"","","","",""]
[118,null,null,"",null,"","","","",""]
[119,null,null,"",null,"","","","",""]
[120,null,null,"",null,"","","","",""]
[121,null,null,"",null,"","","","",""]
[122,null,null,"",null,"","","","",""]
[123,null,null,"",null,"","","","",""]
[124,null,null,"",null,"","","","",""]
[125,null,null,"",null,"","","","",""]
[126,null,null,"",null,"","","","",""]
[127,null,null,"",null,"","","","",""]
[128,null,null,"",null,"","","","",""]
[129,null,null,"",null,"","","","",""]
[130,null,null,"",null,"",{"$f":"IF($C136=\"\",\"\",DATEDIF($F136,$H$4,\"md\"))","v":""},{"$f":"IF($C136=\"\",\"\",DATEDIF($F136,$H$4,\"ym\"))","v":""},{"$f":"IF($C136=\"\",\"\",DATEDIF($F136,$H$4,\"y\"))","v":""},""]
[131,null,null,"",null,"","","","",""]
[132,null,null,"",null,"","","","",""]
[133,null,null,"",null,"","","","",""]
[134,null,null,"",null,"","","","",""]
[135,null,null,"",null,"","","","",""]
[136,null,null,"",null,"","","","",""]
[137,null,null,"",null,"","","","",""]
[138,null,null,"",null,"","","","",""]
[139,null,null,"",null,"","","","",""]
[140,null,null,"",null,"","","","",""]
[141,null,null,"",null,"","","","",""]
[142,null,null,"",null,"","","","",""]
[143,null,null,"",null,"","","","",""]
[144,null,null,"",null,"","","","",""]
[145,null,null,"",null,"","","","",""]
[146,null,null,"",null,"","","","",""]
[147,null,null,"",null,"","","","",""]
[148,null,null,"",null,"","","","",""]
[149,null,null,"",null,"","","","",""]
[150,null,null,"",null,"","","","",""]
[151,null,null,"",null,"","","","",""]
[152,null,null,"",null,"","","","",""]
[153,null,null,{"$f":"A_ID(C159,1)","v":""},null,{"$f":"A_ID(C159,2)","v":""},"","","",{"$f":"A_ID(C159,3)","v":""}]
[154,null,null,"",null,"","","","",""]
[155,null,null,"",null,"","","","",""]
[156,null,null,"",null,"","","","",""]
[157,null,null,"",null,"","","","",""]
[158,null,null,"",null,"","","","",""]
[159,null,null,"",null,"","","","",""]
[160,null,null,"",null,"","","","",""]
[161,null,null,"",null,"","","","",""]
[162,null,null,"",null,"","","","",""]
[163,null,null,"",null,"","","","",""]
[164,null,null,"",null,"","","","",""]
[165,null,null,"",null,"","","","",""]
[166,null,null,"",null,"","","","",""]
[167,null,null,"",null,"","","","",""]
[168,null,null,"",null,"","","","",""]
[169,null,null,"",null,"","","","",""]
[170,null,null,"",null,"","","","",""]
[171,null,null,"",null,"","","","",""]
[172,null,null,"",null,"","","","",""]
[173,null,null,"",null,"","","","",""]
[174,null,null,"",null,"","","","",""]
[175,null,null,"",null,"","","","",""]
[176,null,null,"",null,"","","","",""]
[177,null,null,"",null,"","","","",""]
[178,null,null,"",null,"","","","",""]
[179,null,null,"",null,"","","","",""]
[180,null,null,"",null,"","","","",""]
[181,null,null,"",null,"","","","",""]
[182,null,null,"",null,"","","","",""]
[183,null,null,"",null,"","","","",""]
[184,null,null,"",null,"","","","",""]
[185,null,null,"",null,"","","","",""]
[186,null,null,"",null,"","","","",""]
[187,null,null,"",null,"","","","",""]
[188,null,null,"",null,"","","","",""]
[189,null,null,"",null,"","","","",""]
[190,null,null,"",null,"","","","",""]
[191,null,null,"",null,"","","","",""]
[192,null,null,"",null,"","","","",""]
[193,null,null,"",null,"","","","",""]
[194,null,null,"",null,"",{"$f":"IF($C200=\"\",\"\",DATEDIF($F200,$H$4,\"md\"))","v":""},{"$f":"IF($C200=\"\",\"\",DATEDIF($F200,$H$4,\"ym\"))","v":""},{"$f":"IF($C200=\"\",\"\",DATEDIF($F200,$H$4,\"y\"))","v":""},""]
[195,null,null,"",null,"","","","",""]
[196,null,null,"",null,"","","","",""]
[197,null,null,"",null,"","","","",""]
[198,null,null,"",null,"","","","",""]
[199,null,null,"",null,"","","","",""]
[200,null,null,"",null,"","","","",""]
[201,null,null,"",null,"","","","",""]
[202,null,null,"",null,"","","","",""]
[203,null,null,"",null,"","","","",""]
[204,null,null,"",null,"","","","",""]
[205,null,null,"",null,"","","","",""]
[206,null,null,"",null,"","","","",""]
[207,null,null,"",null,"","","","",""]
[208,null,null,"",null,"","","","",""]
[209,null,null,"",null,"","","","",""]
[210,null,null,"",null,"","","","",""]
[211,null,null,"",null,"","","","",""]
[212,null,null,"",null,"","","","",""]
[213,null,null,"",null,"","","","",""]
[214,null,null,"",null,"","","","",""]
[215,null,null,"",null,"","","","",""]
[216,null,null,"",null,"","","","",""]
[217,null,null,{"$f":"A_ID(C223,1)","v":""},null,{"$f":"A_ID(C223,2)","v":""},"","","",{"$f":"A_ID(C223,3)","v":""}]
[218,null,null,"",null,"","","","",""]
[219,null,null,"",null,"","","","",""]
[220,null,null,"",null,"","","","",""]
[221,null,null,"",null,"","","","",""]
[222,null,null,"",null,"","","","",""]
[223,null,null,"",null,"","","","",""]
[224,null,null,"",null,"","","","",""]
[225,null,null,"",null,"","","","",""]
[226,null,null,"",null,"","","","",""]
[227,null,null,"",null,"","","","",""]
[228,null,null,"",null,"","","","",""]
[229,null,null,"",null,"","","","",""]
[230,null,null,"",null,"","","","",""]
[231,null,null,"",null,"","","","",""]
[232,null,null,"",null,"","","","",""]
[233,null,null,"",null,"","","","",""]
[234,null,null,"",null,"","","","",""]
[235,null,null,"",null,"","","","",""]
[236,null,null,"",null,"","","","",""]
[237,null,null,"",null,"","","","",""]
[238,null,null,"",null,"","","","",""]
[239,null,null,"",null,"","","","",""]
[240,null,null,"",null,"","","","",""]
[241,null,null,"",null,"","","","",""]
[242,null,null,"",null,"","","","",""]
[243,null,null,"",null,"","","","",""]
[244,null,null,"",null,"","","","",""]
[245,null,null,"",null,"","","","",""]
[246,null,null,"",null,"","","","",""]
[247,null,null,"",null,"","","","",""]
[248,null,null,"",null,"","","","",""]
[249,null,null,"",null,"","","","",""]
[250,null,null,"",null,"","","","",""]
[251,null,null,"",null,"","","","",""]
[252,null,null,"",null,"","","","",""]
[253,null,null,"",null,"","","","",""]
[254,null,null,"",null,"","","","",""]
[255,null,null,"",null,"","","","",""]
[256,null,null,"",null,"","","","",""]
[257,null,null,"",null,"","","","",""]
[258,null,null,"",null,"",{"$f":"IF($C264=\"\",\"\",DATEDIF($F264,$H$4,\"md\"))","v":""},{"$f":"IF($C264=\"\",\"\",DATEDIF($F264,$H$4,\"ym\"))","v":""},{"$f":"IF($C264=\"\",\"\",DATEDIF($F264,$H$4,\"y\"))","v":""},""]
[259,null,null,"",null,"","","","",""]
[260,null,null,"",null,"","","","",""]
[261,null,null,"",null,"","","","",""]
[262,null,null,"",null,"","","","",""]
[263,null,null,"",null,"","","","",""]
[264,null,null,"",null,"","","","",""]
[265,null,null,"",null,"","","","",""]
[266,null,null,"",null,"","","","",""]
[267,null,null,"",null,"","","","",""]
[268,null,null,"",null,"","","","",""]
[269,null,null,"",null,"","","","",""]
[270,null,null,"",null,"","","","",""]
[271,null,null,"",null,"","","","",""]
[272,null,null,"",null,"","","","",""]
[273,null,null,"",null,"","","","",""]
[274,null,null,"",null,"","","","",""]
[275,null,null,"",null,"","","","",""]
[276,null,null,"",null,"","","","",""]
[277,null,null,"",null,"","","","",""]
[278,null,null,"",null,"","","","",""]
[279,null,null,"",null,"","","","",""]
[280,null,null,"",null,"","","","",""]
[281,null,null,{"$f":"A_ID(C287,1)","v":""},null,{"$f":"A_ID(C287,2)","v":""},"","","",{"$f":"A_ID(C287,3)","v":""}]
[282,null,null,"",null,"","","","",""]
[283,null,null,"",null,"","","","",""]
[284,null,null,"",null,"","","","",""]
[285,null,null,"",null,"","","","",""]
[286,null,null,"",null,"","","","",""]
[287,null,null,"",null,"","","","",""]
[288,null,null,"",null,"","","","",""]
[289,null,null,"",null,"","","","",""]
[290,null,null,"",null,"","","","",""]
[291,null,null,"",null,"","","","",""]
[292,null,null,"",null,"","","","",""]
[293,null,null,"",null,"","","","",""]

{"sheet":"Target","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,13,8,15],[0,4,2,4],[0,6,3,6]]}
[null,null,null,null,"ترتيب على حسب التقدير","امتياز","ترتيب على حسب النوع","ذكر"]
[null,"الاول","الصف",null,null,"جيد جيدا",null,"انثى"]
[null,null,null,null,null,"جيد",null,null,null,null,null,null,null,"نشكر المنتدى الرائع والأستاذ سليم الرجل المحترم الذى ساعدنى في هذا الشيت لجلب البيانات على حسب الاختيار من القائمة المنسدلة في نقطة إضافة نريد عمل كود ترتيب بشرطين عند اختيار الصف نريد ترتيب البيانات على حسب البيانات الموضوعه من الخلية F4:F1 وترتيب على حسب النوع المكتوب فى H2:H1"]
[null,null,null,null,null,"ضعيف"]
[]
["مسلسل","اسم التلميذ","الرقم القومي","المحافظة","الصف ","تاريخ الميلاد","يوم","شهر","سنة","النوع","الديانة","التقدير"]
[1,"ابراهيم اشرف احمد مصطفى",31112020104059,"القاهرة","الاول","2011-12-02",29,9,8,"ذكر","مسلم","ضعيف"]
[7,"احمد سامح بكرى مهران",26710042800527,"أسوان","الاول","1967-10-04",27,11,52,"انثى","مسلم","امتياز"]
[8,"احمد سيد ابراهيم احمد",27706212800297,"أسوان","الاول","1977-06-21",10,3,43,"ذكر","مسلم","جيد"]
[9,"احمد محمد احمد بكرى",26509130200397,"الإسكندرية","الاول","1965-09-13",18,0,55,"ذكر","مسلم","جيد جيدا"]
[16,"اسراء فرح سالم محمود",31207222801003,"أسوان","الاول","2012-07-22",9,2,8,"انثى","مسلمة","امتياز"]
[17,"اسماء حسن عبدالستار احمد",31202052801044,"أسوان","الاول","2012-02-05",26,7,8,"انثى","مسلمة","ضعيف"]