{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TransPorter","التحميل"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":6,"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":"TransPorter","index":0,"n_rows":99,"n_cols":18,"rows_kept":99,"cut":false,"hidden":false,"merged":[[12,7,12,8],[12,9,12,11],[14,16,14,17],[15,15,15,16],[9,7,9,8],[9,9,9,10],[9,12,10,12],[10,7,10,8],[10,9,10,10],[11,7,11,8],[11,9,11,12],[2,6,2,7],[2,10,2,12],[3,6,3,8],[3,10,3,12],[5,7,5,8],[5,10,5,12],[3,15,3,16],[4,7,4,8],[4,9,4,12],[8,7,8,8],[8,9,8,11],[6,7,6,8],[6,10,6,12],[7,7,7,8]]}
[]
["الملفات المفتوحة","اوراق الملفات المفتوحة","الملفات المطلوبه",null,null,"A"]
[null,null,null,null,null,"B","من الملف:",null,"البودرة.xlsm","الى الملف:","البرنامج.xlsm",null,null,null,null,{"$f":"COUNTIF($A$1:$A$99,$I$3)>0","v":true},null,{"$f":"COUNTIF($A$1:$A$99,$K$3)>0","v":true}]
["البرنامج.xlsm","TransPorter",{"$f":"IF(COUNTIF($H$5:$I$13,B4)=0,B4,\"\")","v":"TransPorter"},null,null,"C","من الأوراق التاليه اسمائها",null,null,"الى ورقة:","التحميل",null,null,null,null,{"$f":"CONCATENATE(\"'\",$K$4,\"'!\",$L$10)","v":"'التحميل'!A"},null,{"$f":"IF($R$3,AND(NOT(ISERR(INDIRECT(CONCATENATE($P$4,ROW())))),SUMPRODUCT(($A$1:$A$99=$K$3)*($B$1:$B$99=$K$4))>0),FALSE)","v":true}]
["البرنامج.xlsm","التحميل",{"$f":"IF(AND(LEN(B5)>0,COUNTIF($H$5:$I$13,B5)=0),B5,\"\")","v":"التحميل"},null,null,"D",1,"بنزين",null,"تحديد تواريخ الفترة المطلوبة",null,null,null,null,null,{"$f":"IF($P$3,SUMPRODUCT(($A$1:$A$99=$I$3)*($B$1:$B$99=$H5))>0,FALSE)","v":true}]
[null,null,"",null,null,"E",2,"كاز",null,"من تاريخ:","2021-06-01",null,null,null,null,true,{"$f":"IF(ISERROR(VALUE(K6)),IF(ISERROR(VALUE(\"a\"&K6)),FALSE,VALUE(\"a\"&K6)),VALUE(K6))","v":44348},{"$f":"AND(SUM(Q6)>0,SUM(Q7)>0,SUM(Q6)<=SUM(Q7))","v":true}]
["البودرة.xlsm","بنزين","",null,null,"F",3,"نفط",null,"الى تاريخ:","2021-06-30",null,null,null,null,true,{"$f":"IF(ISERROR(VALUE(K7)),IF(ISERROR(VALUE(\"a\"&K7)),FALSE,VALUE(\"a\"&K7)),VALUE(K7))","v":44377},{"$f":"AND(SUM(Q6)>0,SUM(Q7)>0,SUM(Q6)<=SUM(Q7))","v":true}]
["البودرة.xlsm","كاز","",null,null,"G",4,null,null,"من العمود:","A","و العمود:","N",null,null,false]
["البودرة.xlsm","نفط","",null,null,"H",5,null,null,"عمود التاريخ لملف المصدر للبيانات:",null,null,"H",null,null,false]
[null,null,"",null,null,"I",6,null,null,"العمود الوجهه:",null,"A",{"$f":"L10&L11","v":"A63"},null,null,false]
[null,null,"",null,null,"J",7,null,null,"الصف الوجهه:",null,{"$f":"IF($R$4,COUNTA(INDIRECT(CONCATENATE($P$4,\"1:\",L10,55555)))+4,R4)","v":63},null,null,null,false,null,{"$f":"IF(NOT(ISERROR($J$12)),AND(LEN($J$12)<2,SUM($J$12)=0),FALSE)","v":false}]
[null,null,"",null,null,"K",8,null,null,{"$f":"INDIRECT(CONCATENATE(\"'\",$K$4,\"'!\",$M$10))","v":898344},null,null,null,null,null,false]
[null,null,"",null,null,"L",9,null,null,"مسح البيانات القديمة:",null,null,"لا",null,null,false,null,{"$f":"OR(P5,P6,P7,P8,P9,P10,P11,P12,P13)","v":true}]
[null,null,"",null,null,"M",null,null,null,null,null,null,null,null,null,"اكتمال البيانات:",{"$f":"AND(P3,R3,R4,R6,R7,R13)","v":true}]
[null,null,"",null,null,"N",null,null,null,null,null,null,null,null,null,"الرسالة:",{"$f":"CONCATENATE(IF(P3,\"\",CHAR(10)&G3),IF(R3,\"\",CHAR(10)&J3),IF(R4,\"\",CHAR(10)&J4),IF(R6,\"\",CHAR(10)&J6),IF(R7,\"\",CHAR(10)&J7),IF(R13,\"\",CHAR(10)&G4),IF(R11,\"\",CHAR(10)&J10&J11))","v":"\nالعمود الوجهه:الصف الوجهه:"}]
[null,null,"",null,null,"P",null,null,null,null,null,null,null,null,null,"مسح البيانات القديمة:",null,{"$f":"M13=\"نعم\"","v":false}]
[null,null,"",null,null,"Q"]
[null,null,"",null,null,"R"]
[null,null,"",null,null,"S"]
[null,null,"",null,null,"T"]
[null,null,"",null,null,"U"]
[null,null,"",null,null,"V"]
[null,null,"",null,null,"W"]
[null,null,"",null,null,"X"]
[null,null,"",null,null,"Y"]
[null,null,"",null,null,"Z"]
[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,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,{"$f":"IF(AND(LEN(B69)>0,COUNTIF($H$5:$I$13,B69)=0),B69,\"\")","v":""}]
[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,""]

{"sheet":"التحميل","index":1,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["رقم المستند","اسم السائق","رقم السياره","العائديه","رقم المستند","جهة التحميل","نوع المنتوج","تاريخ التحميل","تاريخ التفريغ","طبيعي","قياسي مجهز","قياسي مفرغ","نقص","الشركه"]
[870781,"محمد1",19,"مؤقت",870781,"مصفى","بنزين","2021-06-01","2021-06-02",36000,35090,35094,4,"العالمية"]
[870778,"محمد2",20,"مؤقت",870778,"مصفى","بنزين","2021-06-01","2021-06-02",36000,35091,35094,3,"العالمية"]
[870630,"محمد3",21,"مؤقت",870630,"مصفى","بنزين","2021-06-01","2021-06-02",36000,35129,35133,4,"العالمية"]
[870782,"محمد4",22,"مؤقت",870782,"مصفى","بنزين","2021-06-01","2021-06-02",36000,35138,35143,5,"العالمية"]
[870784,"محمد5",29,"مؤقت",870784,"مصفى","بنزين","2021-06-01","2021-06-02",34000,35091,35094,3,"العالمية"]
[994527,"س4",80,"مؤقت",994527,"مصفى","كاز","2021-06-02","2021-06-03",42000,41047,null,null,"العالمية"]
[898350,"س5",81,"مؤقت",898350,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[994526,"س6",82,"مؤقت",994526,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[994528,"س7",83,"مؤقت",994528,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[414768,"ناصر",87,"مؤقت",414768,"مصفى","نفط","2021-06-19","2021-06-20","",35365,null,null,"الشامية"]
[898349,"س1",77,"مؤقت",898349,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[994569,"س2",78,"مؤقت",994569,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[994570,"س3",79,"مؤقت",994570,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[994504,"س8",84,"مؤقت",994504,"مصفى","كاز","2021-06-02","2021-06-03",36000,34992,null,null,"العالمية"]
[898344,"س9",85,"مؤقت",898344,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"العالمية"]
[994560,"س10",86,"مؤقت",994560,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"الشامية"]
[994557,"س11",87,"مؤقت",994557,"مصفى","كاز","2021-06-02","2021-06-03",36000,35183,null,null,"الشامية"]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14}]
[]
[]
[]
[]
[]
[]
[]
[870778,"محمد2",20,"مؤقت",870778,"مصفى","بنزين",44348,44349,36000,35091,35094,3,"العالمية"]
[870630,"محمد3",21,"مؤقت",870630,"مصفى","بنزين",44348,44349,36000,35129,35133,4,"العالمية"]
[870782,"محمد4",22,"مؤقت",870782,"مصفى","بنزين",44348,44349,36000,35138,35143,5,"العالمية"]
[870784,"محمد5",29,"مؤقت",870784,"مصفى","بنزين",44348,44349,34000,35091,35094,3,"العالمية"]
[994569,"س2",78,"مؤقت",994569,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994570,"س3",79,"مؤقت",994570,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994527,"س4",80,"مؤقت",994527,"مصفى","كاز",44349,44350,42000,41047,null,null,"العالمية"]
[898350,"س5",81,"مؤقت",898350,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994526,"س6",82,"مؤقت",994526,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994528,"س7",83,"مؤقت",994528,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[870781,"محمد1",19,"مؤقت",870781,"مصفى","بنزين",44348,44349,36000,35090,35094,4,"العالمية"]
[870778,"محمد2",20,"مؤقت",870778,"مصفى","بنزين",44348,44349,36000,35091,35094,3,"العالمية"]
[870630,"محمد3",21,"مؤقت",870630,"مصفى","بنزين",44348,44349,36000,35129,35133,4,"العالمية"]
[870782,"محمد4",22,"مؤقت",870782,"مصفى","بنزين",44348,44349,36000,35138,35143,5,"العالمية"]
[870784,"محمد5",29,"مؤقت",870784,"مصفى","بنزين",44348,44349,34000,35091,35094,3,"العالمية"]
[898349,"س1",77,"مؤقت",898349,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994569,"س2",78,"مؤقت",994569,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994570,"س3",79,"مؤقت",994570,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994527,"س4",80,"مؤقت",994527,"مصفى","كاز",44349,44350,42000,41047,null,null,"العالمية"]
[898350,"س5",81,"مؤقت",898350,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994526,"س6",82,"مؤقت",994526,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994528,"س7",83,"مؤقت",994528,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994504,"س8",84,"مؤقت",994504,"مصفى","كاز",44349,44350,36000,34992,null,null,"العالمية"]
[870781,"محمد1",19,"مؤقت",870781,"مصفى","بنزين",44348,44349,36000,35090,35094,4,"العالمية"]
[870778,"محمد2",20,"مؤقت",870778,"مصفى","بنزين",44348,44349,36000,35091,35094,3,"العالمية"]
[870630,"محمد3",21,"مؤقت",870630,"مصفى","بنزين",44348,44349,36000,35129,35133,4,"العالمية"]
[870782,"محمد4",22,"مؤقت",870782,"مصفى","بنزين",44348,44349,36000,35138,35143,5,"العالمية"]
[870784,"محمد5",29,"مؤقت",870784,"مصفى","بنزين",44348,44349,34000,35091,35094,3,"العالمية"]
[898349,"س1",77,"مؤقت",898349,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994569,"س2",78,"مؤقت",994569,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994570,"س3",79,"مؤقت",994570,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994527,"س4",80,"مؤقت",994527,"مصفى","كاز",44349,44350,42000,41047,null,null,"العالمية"]
[898350,"س5",81,"مؤقت",898350,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994526,"س6",82,"مؤقت",994526,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994528,"س7",83,"مؤقت",994528,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994504,"س8",84,"مؤقت",994504,"مصفى","كاز",44349,44350,36000,34992,null,null,"العالمية"]
[898344,"س9",85,"مؤقت",898344,"مصفى","كاز",44349,44350,36000,35183,null,null,"العالمية"]
[994560,"س10",86,"مؤقت",994560,"مصفى","كاز",44349,44350,36000,35183,null,null,"الشامية"]
[994557,"س11",87,"مؤقت",994557,"مصفى","كاز",44349,44350,36000,35183,null,null,"الشامية"]
[414768,"ناصر",87,"مؤقت",414768,"مصفى","نفط",44366,44367,"",35365,null,null,"الشامية"]