{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["DATA","777","1","2","3","4","5","6"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"DATA","index":0,"n_rows":51,"n_cols":27,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[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,"الترحيل يعتمد على عمود 27"]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,"اسم الزبون"]
[{"$f":"IF(D4=\"\",\"\",SUBTOTAL(3,$D$4:D4))","v":1},5001,1010,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D5=\"\",\"\",SUBTOTAL(3,$D$4:D5))","v":2},5002,1015,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D6=\"\",\"\",SUBTOTAL(3,$D$4:D6))","v":3},5003,1020,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D7=\"\",\"\",SUBTOTAL(3,$D$4:D7))","v":4},5004,1025,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D8=\"\",\"\",SUBTOTAL(3,$D$4:D8))","v":5},5005,1030,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D9=\"\",\"\",SUBTOTAL(3,$D$4:D9))","v":6},5006,1035,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D10=\"\",\"\",SUBTOTAL(3,$D$4:D10))","v":7},5007,1040,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عدنان"]
[{"$f":"IF(D11=\"\",\"\",SUBTOTAL(3,$D$4:D11))","v":8},5008,1045,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D12=\"\",\"\",SUBTOTAL(3,$D$4:D12))","v":9},5009,1050,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D13=\"\",\"\",SUBTOTAL(3,$D$4:D13))","v":10},5010,1055,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D14=\"\",\"\",SUBTOTAL(3,$D$4:D14))","v":11},5011,1060,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D15=\"\",\"\",SUBTOTAL(3,$D$4:D15))","v":12},5012,1065,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D16=\"\",\"\",SUBTOTAL(3,$D$4:D16))","v":13},5013,1070,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عدنان"]
[{"$f":"IF(D17=\"\",\"\",SUBTOTAL(3,$D$4:D17))","v":14},5014,1075,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D18=\"\",\"\",SUBTOTAL(3,$D$4:D18))","v":15},5015,1080,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D19=\"\",\"\",SUBTOTAL(3,$D$4:D19))","v":16},5016,1085,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D20=\"\",\"\",SUBTOTAL(3,$D$4:D20))","v":17},5017,1090,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D21=\"\",\"\",SUBTOTAL(3,$D$4:D21))","v":18},5018,1095,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D22=\"\",\"\",SUBTOTAL(3,$D$4:D22))","v":19},5019,1100,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عدنان"]
[{"$f":"IF(D23=\"\",\"\",SUBTOTAL(3,$D$4:D23))","v":20},5020,1105,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D24=\"\",\"\",SUBTOTAL(3,$D$4:D24))","v":21},5021,1110,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D25=\"\",\"\",SUBTOTAL(3,$D$4:D25))","v":22},5022,1115,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D26=\"\",\"\",SUBTOTAL(3,$D$4:D26))","v":23},5023,1120,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D27=\"\",\"\",SUBTOTAL(3,$D$4:D27))","v":24},5024,1125,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D28=\"\",\"\",SUBTOTAL(3,$D$4:D28))","v":25},5001,1010,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D29=\"\",\"\",SUBTOTAL(3,$D$4:D29))","v":26},5002,1015,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D30=\"\",\"\",SUBTOTAL(3,$D$4:D30))","v":27},5003,1020,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D31=\"\",\"\",SUBTOTAL(3,$D$4:D31))","v":28},5004,1025,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D32=\"\",\"\",SUBTOTAL(3,$D$4:D32))","v":29},5005,1030,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D33=\"\",\"\",SUBTOTAL(3,$D$4:D33))","v":30},5006,1035,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D34=\"\",\"\",SUBTOTAL(3,$D$4:D34))","v":31},5007,1040,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عدنان"]
[{"$f":"IF(D35=\"\",\"\",SUBTOTAL(3,$D$4:D35))","v":32},5008,1045,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D36=\"\",\"\",SUBTOTAL(3,$D$4:D36))","v":33},5009,1050,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D37=\"\",\"\",SUBTOTAL(3,$D$4:D37))","v":34},5010,1055,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D38=\"\",\"\",SUBTOTAL(3,$D$4:D38))","v":35},5011,1060,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D39=\"\",\"\",SUBTOTAL(3,$D$4:D39))","v":36},5012,1065,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D40=\"\",\"\",SUBTOTAL(3,$D$4:D40))","v":37},5013,1070,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عدنان"]
[{"$f":"IF(D41=\"\",\"\",SUBTOTAL(3,$D$4:D41))","v":38},5014,1075,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D42=\"\",\"\",SUBTOTAL(3,$D$4:D42))","v":39},5015,1080,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D43=\"\",\"\",SUBTOTAL(3,$D$4:D43))","v":40},5016,1085,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D44=\"\",\"\",SUBTOTAL(3,$D$4:D44))","v":41},5017,1090,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D45=\"\",\"\",SUBTOTAL(3,$D$4:D45))","v":42},5018,1095,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]
[{"$f":"IF(D46=\"\",\"\",SUBTOTAL(3,$D$4:D46))","v":43},5019,1100,"مصطفى1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عدنان"]
[{"$f":"IF(D47=\"\",\"\",SUBTOTAL(3,$D$4:D47))","v":44},5020,1105,"مصطفى2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد"]
[{"$f":"IF(D48=\"\",\"\",SUBTOTAL(3,$D$4:D48))","v":45},5021,1110,"مصطفى3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"طارق"]
[{"$f":"IF(D49=\"\",\"\",SUBTOTAL(3,$D$4:D49))","v":46},5022,1115,"مصطفى4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عبد الله"]
[{"$f":"IF(D50=\"\",\"\",SUBTOTAL(3,$D$4:D50))","v":47},5023,1120,"مصطفى5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مصطفى"]
[{"$f":"IF(D51=\"\",\"\",SUBTOTAL(3,$D$4:D51))","v":48},5024,1125,"مصطفى6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"حسين"]

{"sheet":"777","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"ثانيا","اولا",null,"ثالثا",4]
[null,null,null,"فرز من أ الى ي","فرز من أ الى ي",null,"فرز من الاكبر الى الاصغر","هنا فرز الكود من الاصغر الى الاكبر بعد التوزيع"]
[]
["#","رقم الحساب","المورد","اسم الزبون",null,null,"التوزيع","#"]
[1,5013,1070,"مصطفى1","عدنان",null,179,1]
[2,5007,1040,"مصطفى1","عدنان",null,177,1]
[3,5019,1100,"احمد","عدنان",null,175,1]
[4,5013,1070,"مصطفى1","عدنان",null,173,1]
[5,5007,1040,"مصطفى1","عدنان",null,171,2]
[6,5010,1055,"مصطفى4","عبد الله",null,169,2]
[7,5004,1025,"محمود","عبد الله",null,167,2]
[8,5022,1115,"مصطفى4","عبد الله",null,165,2]
[9,5016,1085,"مصطفى4","عبد الله",null,163,3]
[10,5010,1055,"مصطفى4","عبد الله",null,161,3]
[11,5004,1025,"سليم","عبد الله",null,159,3]
[12,5021,1110,"مصطفى3","طارق",null,157,3]
[13,5015,1080,"مصطفى3","طارق",null,155,4]
[14,5009,1050,"مصطفى3","طارق",null,153,4]
[15,5003,1020,"اسلام","طارق",null,151,4]
[16,5021,1110,"مصطفى3","طارق",null,149,4]
[17,5015,1080,"مصطفى3","طارق",null,147,5]
[18,5009,1050,"مصطفى3","طارق",null,145,5]
[19,5003,1020,"نصر","طارق",null,143,5]
[20,5020,1105,"مصطفى2","محمد",null,141,5]
[21,5014,1075,"مصطفى2","محمد",null,139,6]
[22,5008,1045,"مصطفى2","محمد",null,137,6]
[23,5002,1015,"مصطفى","محمد",null,135,6]
[24,5001,1010,"مصطفى1","محمد",null,133,6]
[25,5020,1105,"مصطفى2","محمد",null,131,7]
[26,5014,1075,"مصطفى2","محمد",null,129,7]
[27,5008,1045,"مصطفى2","محمد",null,127,{"$f":"INT((ROWS($A$1:A27)-1)/4)+1","v":7}]
[28,5002,1015,"مصطفى2","محمد",null,125,{"$f":"INT((ROWS($A$1:A28)-1)/4)+1","v":7}]
[29,5001,1010,"مصطفى1","محمد",null,123,{"$f":"INT((ROWS($A$1:A29)-1)/4)+1","v":8}]

{"sheet":"1","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد","اسم الزبون"]
[1,5001,1010,"مصطفى1","محمد"]
[2,5002,1015,"مصطفى2","محمد"]
[3,5008,1045,"مصطفى2","محمد"]
[4,5014,1075,"مصطفى2","محمد"]
[5,5020,1105,"مصطفى2","محمد"]
[6,5001,1010,"مصطفى1","محمد"]
[7,5002,1015,"مصطفى2","محمد"]
[8,5008,1045,"مصطفى2","محمد"]
[9,5014,1075,"مصطفى2","محمد"]
[10,5020,1105,"مصطفى2","محمد"]

{"sheet":"2","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد","اسم الزبون"]
[1,5003,1020,"مصطفى3","طارق"]
[2,5009,1050,"مصطفى3","طارق"]
[3,5015,1080,"مصطفى3","طارق"]
[4,5021,1110,"مصطفى3","طارق"]
[5,5003,1020,"مصطفى3","طارق"]
[6,5009,1050,"مصطفى3","طارق"]
[7,5015,1080,"مصطفى3","طارق"]
[8,5021,1110,"مصطفى3","طارق"]

{"sheet":"3","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد","اسم الزبون"]
[1,5004,1025,"مصطفى4","عبد الله"]
[2,5010,1055,"مصطفى4","عبد الله"]
[3,5016,1085,"مصطفى4","عبد الله"]
[4,5022,1115,"مصطفى4","عبد الله"]
[5,5004,1025,"مصطفى4","عبد الله"]
[6,5010,1055,"مصطفى4","عبد الله"]
[7,5016,1085,"مصطفى4","عبد الله"]
[8,5022,1115,"مصطفى4","عبد الله"]

{"sheet":"4","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد","اسم الزبون"]
[1,5005,1030,"مصطفى5","مصطفى"]
[2,5011,1060,"مصطفى5","مصطفى"]
[3,5017,1090,"مصطفى5","مصطفى"]
[4,5023,1120,"مصطفى5","مصطفى"]
[5,5005,1030,"مصطفى5","مصطفى"]
[6,5011,1060,"مصطفى5","مصطفى"]
[7,5017,1090,"مصطفى5","مصطفى"]
[8,5023,1120,"مصطفى5","مصطفى"]

{"sheet":"5","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد","اسم الزبون"]
[1,5006,1035,"مصطفى6","حسين"]
[2,5012,1065,"مصطفى6","حسين"]
[3,5018,1095,"مصطفى6","حسين"]
[4,5024,1125,"مصطفى6","حسين"]
[5,5006,1035,"مصطفى6","حسين"]
[6,5012,1065,"مصطفى6","حسين"]
[7,5018,1095,"مصطفى6","حسين"]
[8,5024,1125,"مصطفى6","حسين"]

{"sheet":"6","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ت","رقم الفاتورة","رقم الحساب","المورد","اسم الزبون"]
[1,5007,1040,"مصطفى1","عدنان"]
[2,5013,1070,"مصطفى1","عدنان"]
[3,5019,1100,"مصطفى1","عدنان"]
[4,5007,1040,"مصطفى1","عدنان"]
[5,5013,1070,"مصطفى1","عدنان"]
[6,5019,1100,"مصطفى1","عدنان"]