{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Main","AN","AN Report","AN_DB","Tare","Tare Report","LN Report","FN","FN Report","Target QTY"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":0,"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":"Main","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,3,3,9],[4,5,4,7],[8,1,8,3],[8,5,8,7],[8,9,8,11]]}
[]
[null,null,null,"Dispatch Tool (All In One)\nDispatch Section - Commercial Department"]
[]
[]
[null,null,null,null,null,"Main Menu"]
[]
[]
[]
[null,"Data Entry",null,null,null,"Messeges",null,null,null,"Reporting"]

{"sheet":"AN","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,3,15,4],[15,10,15,12],[16,3,16,4],[17,3,17,4],[18,3,18,4],[10,3,10,4],[10,9,10,11],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[4,3,4,5],[5,3,5,5],[5,9,5,10],[6,3,6,5],[7,3,7,5],[8,3,8,5],[8,6,8,11],[0,9,0,11],[1,3,1,5],[1,9,1,11],[2,3,2,5],[2,9,2,11],[3,3,3,5],[3,9,3,11]]}
[null,null,null,null,null,null,null,null,null,"26-03-2021 02:54:27 pm"]
[null,"Delivery",null,null,null,null,null,"Role No",null,null,null,null,"CEMI"]
[null,"AN Serial",null,null,null,null,null,"Loading note no",null,null,null,null,"CEMII"]
[null,"Loading Type",null,null,null,null,null,"Truck Type",null,null,null,null,"SRC"]
[null,"Truck Owner",null,null,null,null,null,null,null,null,null,null,"SRCU"]
[null,"Shipping Agent",null,null,null,null,null,"Driver License",null,null,null,null,"CEMII"]
[null,"Driver name",null,null,null,null,null,"Truck",null,null,null,null,"TYPEII"]
[null,"Driver request",null,null,null,null,null,"Trailer"]
[null,"Cutomer Number"]
[null,null,null,null,null,"QTY",null,"Item",null,"Statues"]
[null,"Coupons"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,202103250137]
[]
[]
[null,null,null,"Total"]

{"sheet":"AN Report","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,3,18,7],[20,3,20,7],[22,3,22,7],[12,3,12,7],[12,10,12,14],[14,3,14,7],[14,10,14,14],[16,3,16,7],[16,10,16,14],[6,3,6,7],[6,10,6,14],[8,3,8,7],[8,10,8,14],[10,3,10,7],[10,10,10,14],[0,4,0,6],[1,4,1,6],[1,10,1,12],[2,4,2,6],[3,3,3,8],[4,3,4,8]]}
[]
[null,null,null,null,"اذن وصول يدوى",null,null,null,null,null,{"$f":"NOW()","v":"2021-03-26T14:54:27.070"},null,null,"Print Date"]
[null,null,null,null,"Arrival Note"]
[null,null,null,{"$f":"AN!D3","v":0}]
[null,null,null,{"$f":"D4","v":0}]
[]
[null,"التاريخ",null,{"$f":"TEXT(AN!J1,\"dd-mm-yyyy hh:mm:mm\")","v":"26-03-2021 02:54:27 pm"},null,null,null,null,null,"رقم الدور",{"$f":"AN!J2","v":0}]
[]
[null,"نوع التحميل",null,{"$f":"AN!D4","v":0},null,null,null,null,null,"نوع السياره",{"$f":"AN!J4","v":0}]
[]
[null,"رقم السيارة",null,{"$f":"CONCATENATE(AN!J7,\" \",AN!K7)","v":" "},null,null,null,null,null,"ترخيص",{"$f":"AN!L7","v":0}]
[]
[null,"رقم المقطورة",null,{"$f":"CONCATENATE(AN!J8,\" \",AN!K8)","v":" "},null,null,null,null,null,"ترخيص",{"$f":"AN!L8","v":0}]
[]
[null,"رخصه  السائق",null,{"$f":"AN!J6","v":0},null,null,null,null,null,"ترخيص",{"$f":"AN!L6","v":0}]
[]
[null,"مالك السياره",null,{"$f":"AN!D5","v":0},null,null,null,null,null,"إسم الناقل"]
[]
[null,"إسم السائق",null,{"$f":"AN!D7","v":0}]
[]
[null,"رغبة السائق",null,{"$f":"AN!D8","v":0}]
[]
[null,"نوع التوصيل",null,{"$f":"IF(AN!D2=\"Delivery\",\"وصال\",\"ارض مصنع\")","v":"ارض مصنع"}]

{"sheet":"AN_DB","index":3,"n_rows":5,"n_cols":65,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Delivery","AN Serial","Loading Type","Truck Owner","Shipping Agent","Driver name","Driver request","Cutomer Number","Name","Role No","Loading note no","Truck Type","Driver License","Lic","Truck","Lic","Lic","Trailer","Lic","Lic","Coupons","qty","Coupons","qty","Coupons","qty","Coupons","qty","Coupons","qty","Coupons","qty","date","statues","qty","item","Tare","date","gross","fright","date","net","total","bags","m","l",null,"AN","Row","LN","Row",null,"s1","s2","s3","s4","s5","s6","s7","s8","s9","s10","s11","s12"]
[null,"Ex-Factory",202103250137,"معبا محلى","عبدالله هاشم",null,"زكى هاشم زكى",null,1100231,"شيماء مسعد مصطفى",1093,481951,"Flat",27909171700493,"المنوفية",9274,"م ى ع","مصر",9284,"م د ر","مصر","2021004224-2",10,null,null,null,null,null,null,null,null,null,null,"26-03-2021 01:56:34 pm","Dispatched",10,"SRC",21850,"26-03-2021 02:18:56 pm",31850,null,"26-03-2021 02:45:01 pm",10000,10,200,null,null,null,202103250137,{"$f":"MATCH(AW3,C:C,0)","v":3}]
[null,"Ex-Factory",202103250096,"معبا محلى","صلاح محمد محمد",null,"مصطفى العليمى مصيلحى",null,1100005,"شركة المصطفى لتجارة مواد البناء",1065,481889,"Flat",25106281701212,"المنوفية",3495,"م ب ق","مصر",8239,"م و ط","مصر","2021004352-4",60,null,null,null,null,null,null,null,null,null,null,"26-03-2021 02:10:18 pm","Dispatched",60,"CEMI",31550,"26-03-2021 02:39:02 pm",91650,null,"26-03-2021 02:52:00 pm",60100,60.1,1200,1,2,null,481889,{"$f":"MATCH(AW4,L:L,0)","v":4}]
[null,"Ex-Factory",202103260016,"سائب محلى","جنى طلعت امين",null,"حلمى محمد حافظ",null,1200523,"يحى محمد يحى محمد",2010,481953,"Silo",28302121700991,"المنوفية",4617,"ع و ط","مصر",8743,"م و ط","مصر","2021004157-4",60,null,null,null,null,null,null,null,null,null,null,"26-03-2021 02:17:22 pm","Under Packing",60,"SRCU",25600,"26-03-2021 02:43:11 pm"]

{"sheet":"Tare","index":4,"n_rows":12,"n_cols":50,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,3,4,5],[7,3,7,4],[11,3,11,5],[1,3,1,5],[1,6,1,7],[1,8,1,10],[2,3,2,5],[2,6,2,11],[3,3,3,5],[3,8,3,10]]}
[]
[null,"Loading note no"]
[null,"Cutomer Number"]
[null,"Driver name",null,null,null,null,null,null,"26-03-2021 02:43:19 pm",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,"Delivery"]
[null,"Cement Type"]
[]
[]
[null,"Driver License"]
[null,"Truck"]
[null,"Trailer"]
[]
[null,"Tare Weight"]

{"sheet":"Tare Report","index":5,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,4,13,5],[13,6,13,10],[15,4,15,5],[15,6,15,10],[17,6,17,10],[7,4,7,5],[7,6,7,10],[9,4,9,5],[9,6,9,10],[11,4,11,5],[11,6,11,10],[1,4,1,5],[1,6,1,10],[3,4,3,5],[3,6,3,10],[5,4,5,5],[5,6,5,10]]}
[]
[null,null,null,null,"التاريخ",null,"26-03-2021 02:43:11 pm"]
[]
[null,null,null,null,"الوزن الفارغ",null,25600]
[]
[null,null,null,null,"رقم الاذن",null,481953]
[]
[null,null,null,null,"إسم السائق",null,"حلمى محمد حافظ"]
[]
[null,null,null,null,"رقم السيارة",null,"4617ع و ط"]
[]
[null,null,null,null,"رقم المقطورة",null,"8743م و ط"]
[]
[null,null,null,null,"إسم السائق",null,{"$f":"AN!D2","v":0}]
[]
[null,null,null,null,"رغبة السائق",null,{"$f":"AN!D3","v":0}]
[]
[null,null,null,null,"نوع التوصيل",null,{"$f":"IF(AN!#REF!=\"Delivery\",\"وصال\",\"ارض مصنع\")","v":{"$error":"#REF!"}}]

{"sheet":"LN Report","index":6,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,15,46,18],[42,4,42,7],[42,14,42,15],[42,16,42,18],[43,14,43,15],[43,16,43,18],[44,4,44,7],[36,4,36,6],[36,10,36,16],[38,4,38,6],[38,10,38,16],[40,4,40,7],[40,13,40,14],[40,15,40,18],[31,4,31,6],[32,4,32,6],[32,10,32,11],[32,13,32,14],[32,15,32,19],[34,4,34,6],[34,10,34,16],[23,4,23,7],[24,13,25,16],[25,4,25,7],[29,1,30,2],[29,4,29,6],[29,8,29,10],[30,4,30,6],[30,8,30,10],[17,4,17,16],[18,4,18,16],[19,4,19,16],[20,13,20,16],[21,4,21,7],[21,13,21,16],[10,4,10,6],[10,10,10,16],[13,4,13,16],[14,4,14,16],[15,4,15,16],[16,4,16,16],[4,4,4,6],[4,13,4,16],[6,4,6,6],[6,10,6,16],[8,4,8,6],[8,10,8,16],[1,1,2,2],[1,4,1,6],[1,8,1,10],[2,4,2,6],[2,8,2,10],[3,4,3,6]]}
[]
[null,{"$f":"IF(OR(AN!H11=\"CEMI\",AN!H11=\"CEMIU\"),\" \",AN!H11)","v":0},null,null,"اذن تحميل يدوى",null,null,null,{"$f":"AN!$J$3","v":0}]
[null,null,null,null,"Loading Note",null,null,null,{"$f":"I2","v":0}]
[]
[null,null,"التاريخ",null,"26-03-2021 01:56:34 pm",null,null,null,"رقم الدور",null,{"$f":"AN!J2","v":0},"رقم اذن",null,{"$f":"AN!D3","v":0}]
[]
[null,null,"رقم العميل",null,{"$f":"AN!D9","v":0},null,null,null,"اسم العميل",null,{"$f":"AN!G9","v":0}]
[]
[null,null,"نوع العميل",null,null,null,null,null,"الجهة"]
[]
[null,null,"نوع التوصيل",null,{"$f":"IF(AN!D2=\"Delivery\",\"وصال\",\"ارض مصنع\")","v":"ارض مصنع"},null,null,null,"اسم السائق",null,{"$f":"AN!D7","v":0}]
[]
[null,null,"الكمية",null,"رقم الكوبون"]
[null,null,{"$f":"AN!F11","v":0},null,{"$f":"AN!D11","v":0}]
[null,null,{"$f":"AN!F12","v":0},null,{"$f":"AN!D12","v":0}]
[null,null,{"$f":"AN!F13","v":0},null,{"$f":"AN!D13","v":0}]
[null,null,{"$f":"AN!F14","v":0},null,{"$f":"AN!D14","v":0}]
[null,null,{"$f":"AN!F15","v":0},null,{"$f":"AN!D15","v":0}]
[null,null,{"$f":"AN!F16","v":0},null,{"$f":"AN!D16","v":0}]
[null,null,"اجمالى",null,{"$f":"SUM(C14:C19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"نوع الاسمنت",null,null,"عدد الشكائر"]
[null,null,"رقم السيارة",null,{"$f":"CONCATENATE(AN!J7,\" \",AN!K7)","v":" "},null,null,null,null,null,{"$f":"AN!H11","v":0},null,null,{"$f":"E20*20","v":0}]
[]
[null,null,"رقم المقطورة",null,{"$f":"CONCATENATE(AN!J8,\" \",AN!K8)","v":" "},null,null,null,null,null,null,null,null,"توقيع السائق"]
[]
[null,null,"رخصة السائق",null,{"$f":"AN!J6","v":0}]
[]
[]
[]
[null,null,null,null,"اذن تحميل يدوى",null,null,null,{"$f":"I2","v":0}]
[null,null,null,null,"Loading Note",null,null,null,{"$f":"I2","v":0}]
[]
[null,null,"التاريخ",null,{"$f":"E5","v":"26-03-2021 01:56:34 pm"},null,null,null,"رقم الدور",null,{"$f":"K5","v":0},null,null,"رقم اذن الوصول",null,{"$f":"N5","v":0}]
[]
[null,null,"رقم العميل",null,{"$f":"E9","v":0},null,null,null,"اسم العميل",null,{"$f":"K7","v":0}]
[]
[null,null,"نوع العميل",null,null,null,null,null,"الجهة"]
[]
[null,null,"نوع التوصيل",null,{"$f":"E11","v":"ارض مصنع"},null,null,null,"اسم السائق",null,{"$f":"K11","v":0}]
[]
[null,null,"رقم السيارة",null,{"$f":"E22","v":" "},null,null,null,null,null,"نوع الاسمنت",null,null,"عدد الشكائر"]
[null,null,null,null,null,null,null,null,null,null,null,"شيكارة",null,"طن"]
[null,null,"رقم المقطورة",null,{"$f":"E24","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,{"$f":"E26","v":0},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":"FN","index":7,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,1,9,2],[9,4,9,5],[5,1,5,2],[5,3,5,5],[6,1,6,2],[6,3,6,4],[7,1,7,2],[8,1,8,2],[3,1,3,2],[3,3,3,5],[3,6,3,11],[4,1,4,2],[4,3,4,5],[4,9,4,11],[1,1,1,2],[1,3,1,5],[1,10,1,11],[2,1,2,2],[2,3,2,5],[2,6,2,8],[2,9,2,11]]}
[]
[null,"Loading Note",null,null,null,null,null,"QTY",null,"Statues"]
[null,"Freight Note"]
[null,"Cutomer Number"]
[null,"Driver name",null,null,null,null,null,null,"Date","26-03-2021 14:53:55"]
[null,"Cement Type",null,null,null,null,"Packed"]
[null,"Driver License"]
[null,"Truck"]
[null,"Trailer",null,null,null,null,null,null,null,null,"No of bags"]
[null,"Tare Weight",null,null,"Gross Weight",null,null,"Net",null,null,"Machine"]
[null,null,null,null,null,null,null,"Total",null,"Ton","Lane"]
[]
[null,"Seal No"]

{"sheet":"FN Report","index":8,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,2,26,9],[27,3,27,10],[28,3,28,10],[31,8,32,10],[21,3,21,5],[23,3,23,5],[23,7,23,8],[23,9,23,12],[23,13,23,16],[24,3,24,5],[24,7,24,8],[24,9,24,12],[24,13,24,16],[17,3,17,6],[17,8,17,15],[19,3,19,5],[19,6,19,7],[20,3,20,5],[20,6,20,7],[12,3,12,15],[14,3,14,6],[14,8,14,15],[15,3,15,6],[15,8,15,15],[16,3,16,6],[16,8,16,15],[10,3,10,7],[10,8,10,10],[10,11,10,15],[11,3,11,7],[11,8,11,10],[11,11,11,15],[6,3,6,6],[6,8,6,15],[7,3,7,6],[7,8,7,15],[8,3,8,6],[8,8,8,15]]}
[]
[null,null,null,null,null,null,"سند شحن يدوى"]
[null,null,null,null,null,null,"Freight Note"]
[null,null,null,null,null,null,{"$f":"FN!D3","v":0}]
[null,null,null,null,null,null,{"$f":"G4","v":0}]
[]
[null,null,"التاريخ",{"$f":"FN!$J$5","v":"26-03-2021 14:53:55"},null,null,null,"رقم الاذن",{"$f":"FN!D2","v":0}]
[null,null,"رقم العميل",{"$f":"FN!D4","v":0},null,null,null,"اسم العميل",{"$f":"FN!G4","v":0}]
[null,null,"جهة الوصول","المصنع",null,null,null,"المنطقة"]
[]
[null,null,"الوزن بالطن","نوع الاسمنت",null,null,null,null,"التعبئة",null,null,"عدد الشكائر"]
[null,null,{"$f":"IF(LEN(FN!L9)=0,FN!G2,FN!I2)","v":0},{"$f":"IF(FN!D6=\"CEMI\",\"اسمنت بورتلاندى مواصفات اوروبيه معبأ رتبه 42.5\",IF(FN!D6=\"CEMIU\",\"اسمنت بورتلاندى مواصفات اوروبيه سائب رتبه 42.5\",IF(FN!D6=\"SRC\",\"اسمنت بورتلاندى مقاوم للكبريتات معبأ رتبه (42.5 SR5)\",IF(FN!D6=\"SRCU\",\"اسمنت بورتلاندى مقاوم للكبريتات سائب رتبه (42.5 SR5)\",\"اسمنت بورتلاندى حجر جيرى معبأ رتبه (N32.5)\"))))","v":"اسمنت بورتلاندى حجر جيرى معبأ رتبه (N32.5)"},null,null,null,null,{"$f":"IF(OR(FN!D6=\"CEMII\",FN!D6=\"SRC\",FN!D6=\"CEMI\"),\"معبأ محلى\",\"سائب محلى\")","v":"سائب محلى"},null,null,{"$f":"FN!L9","v":0}]
[null,null,"عنوان الوصول"]
[]
[null,null,"اسم السائق",{"$f":"FN!D5","v":0}]
[null,null,"رقم السيارة",{"$f":"CONCATENATE(FN!D8,\" \",FN!E8)","v":" "},null,null,null,"ترخيص",{"$f":"FN!F8","v":0}]
[null,null,"رقم المقطورة",{"$f":"CONCATENATE(FN!D9,\" \",FN!E9)","v":" "},null,null,null,"ترخيص",{"$f":"FN!F9","v":0}]
[null,null,"رخصة السائق",{"$f":"FN!D7","v":0},null,null,null,"ترخيص",{"$f":"FN!F7","v":0}]
[]
[null,null,"الوزن الفارغ",{"$f":"IF(I12=\"سائب محلى\",FN!D10/100,\"\")","v":0}]
[null,null,"الوزن القائم",{"$f":"IF(I12=\"سائب محلى\",FN!G10/100,\"\")","v":0}]
[null,null,"الصافى",{"$f":"IF(I12=\"سائب محلى\",D21-D20,\"\")","v":0}]
[null,null,"ارقم البرشام"]
[null,null,{"$f":"FN!C13","v":0},{"$f":"FN!D13","v":0},null,null,{"$f":"FN!E13","v":0},{"$f":"FN!F13","v":0},null,{"$f":"FN!G13","v":0},null,null,null,{"$f":"FN!H13","v":0}]
[null,null,{"$f":"FN!C14","v":0},{"$f":"FN!D14","v":0},null,null,{"$f":"FN!E14","v":0},{"$f":"FN!F14","v":0},null,{"$f":"FN!G14","v":0},null,null,null,{"$f":"FN!H14","v":0}]
[]
[null,null,"استلمت الكمية والوزن الموضحان بهذا السند وذلك لتسليمها اللى"]
[null,null,"السادة/",{"$f":"I8","v":0}]
[null,null,"نوع التوصيل",{"$f":"IF(D9=\"المصنع\",\"ارض مصنع\",\"وصال\")","v":"ارض مصنع"}]
[]
[null,null,null,null,null,null,null,null,"توقيع السائق"]

{"sheet":"Target QTY","index":9,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[[38,10,38,15],[44,1,47,2],[45,5,45,6],[45,7,45,8],[45,9,55,15],[46,5,46,6],[46,7,46,8],[47,5,47,6],[47,7,47,8],[34,10,34,15],[34,29,34,32],[34,33,34,38],[35,10,35,15],[36,10,36,15],[37,10,37,15],[32,10,32,15],[32,29,32,32],[32,33,32,38],[33,10,33,15],[33,29,33,32],[33,33,33,38],[30,1,33,3],[30,9,30,10],[30,19,30,20],[30,29,30,32],[30,33,30,38],[31,10,31,15],[31,17,31,18],[31,19,31,20],[31,29,31,32],[31,33,31,38],[27,29,27,32],[27,33,27,38],[28,29,28,32],[28,33,28,38],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,29,29,32],[29,33,29,38],[24,29,24,32],[24,33,24,38],[25,29,25,32],[25,33,25,38],[26,29,26,32],[26,33,26,38],[21,29,21,32],[21,33,21,38],[22,29,22,32],[22,33,22,38],[23,29,23,32],[23,33,23,38],[18,29,18,32],[18,33,18,38],[19,29,19,32],[19,33,19,38],[20,29,20,32],[20,33,20,38],[13,18,14,18],[13,19,14,20],[13,29,13,36],[14,29,16,38],[15,19,29,20],[16,0,16,3],[16,17,30,17],[17,0,22,0],[17,29,17,32],[17,33,17,38],[8,29,8,36],[9,0,9,3],[9,29,9,36],[10,0,15,0],[10,29,10,36],[11,17,12,17],[11,18,12,20],[11,29,11,36],[12,29,12,36],[13,17,15,17],[2,0,2,1],[2,29,2,36],[3,0,8,0],[3,29,3,36],[4,9,26,9],[4,29,4,36],[5,29,5,36],[6,29,6,36],[7,29,7,36],[8,22,8,23],[0,0,0,1],[0,2,0,3],[0,17,0,18],[0,19,0,20],[0,29,0,36],[1,29,1,36]]}
["Grand Target",null,8500,null,null,"SN",null,null,null,null,"CEMIU","SRCU","TYPEII","CEMI","DIS","SRC",null,"Contractor quota bulk",null,3000,null,null,null,null,null,null,null,null,null,"Hand by hand notes"]
[null,null,null,null,null,1,null,null,null,"Delivery Plan",{"$f":"SUM(K3:K4)","v":1980},360,0,120,60,0,{"$f":"SUM(K2:P2)","v":2520},"Code","Dispatch","Remain","Total",null,null,null,null,null,null,null,null,"تم تعديل ساعه Gross weight مع ساعه Arrival Note "]
["Breakup",null,null,"with del",null,2,null,null,null,"Contractor",{"$f":"960+900+60+60","v":1980},360,null,120,60,null,null,"CEMIU",null,420,{"$f":"T3+S3","v":420},null,null,null,null,null,null,null,null,"ظهور ميل السيستم بعد كسر الساعه بدقيقه لو حدث اى تاخير يبلغ أ عمرو"]
["Dispatch","BAG-CEMI",6417.35,null,null,3,null,null,null,"DIS",null,null,null,null,null,null,null,"SRCU",null,120,{"$f":"T4+S4","v":120},null,null,null,null,null,null,null,null,"اي تفويض موجود على السيستم ثلاثى الاسم يتم تصوير بطاقه المفوض و ارسالها إلى لرفعها فى فولدر التفويضات. \n"]
[null,"BAG-SRC",null,null,null,4,null,null,null,null,1140,180,null,120,60,null,null,"Del",null,480,{"$f":"T5+S5","v":480},null,null,null,null,null,null,null,null,"البونات هتنزل 60 بعد كده والفكه فى حاله تقديم السواق للنقله كامله و ارسال البون ل أ عمرو لفكه"]
[null,"(BAG)-CEMII ",null,null,null,5,null,null,null,null,60,null,null,null,null,null,null,"U/P"]
[null,"BLK-CEMIU",null,null,null,6,null,null,null,null,60,null,null,null,null,null,null,"Issued",null,null,{"$f":"T7+S7","v":0},null,null,null,null,null,null,null,null,"دخول العربيات الساعه 6:05 صباحا"]
[null,"BLK-SRCU",null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T8+S8","v":0},null,null,null,null,null,null,null,null,"عدم ابلاغ اى سائق بموعد دخوله و التزامه بسماع اسمه فى الميكروفون"]
[null,"BLK-TYPEII",null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(S3:S8)","v":0},{"$f":"SUM(T3:T8)","v":1020},{"$f":"SUM(U3:U8)","v":1020},null,null,null,null,null,null,null,null," الصفا  - ياسر عبد الفتاح (1100239) يوجد كود اخر باسم ياسر محمد عبدالفتاح ( 1100598 ) "]
[null,null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(S9:T9)","v":1020},null,null,null,null,null,null,null,null,null,null,"فى اى ميل فك بونات حط السيلز و السيلز ادمن"]
["U/P","BAG-CEMI",1075,null,null,10,null,null,null,null,null,null,null,null,null,null,null,"Remaining",{"$f":"T1-S10","v":1980},null,null,null,null,null,null,null,null,null,null,"عند ارسال ميل  فك بونات  الى ا/ عمرو يتم تبليغه على الوتس "]
[null,"BAG-SRC",null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,"Target",9000,null,null,null,null,null,null,null,null,null,null,"لا يتم عمل دور للسائق الذى يريد فك بونات"]
[null,"(BAG)-CEMII ",null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"اوليه بعد الساعه 1 صباحا عاده قديم "]
[null,"BLK-CEMIU",null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,"Grand Dispatch\nFrom 25-11 till yesterday","Daily","Remain",null,null,null,null,null,null,null,null,null,"دخول رشه الصبح عاده قديم لو موجود"]
[null,"BLK-SRCU",null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hold drivers"]
[null,"BLK-TYPEII",null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S12-T32","v":268.20000000000073}]
[null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,8731.7999999999993]
["WAITING","BAG-CEMI",null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Driver Name",null,null,null,"Reason"]
[null,"BAG-SRC",null,null,null,18,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,"ايقاف شهر من يوم 18-2"]
[null,"(BAG)-CEMII ",null,null,null,19,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,"محضر فقد رخص تالسياره مهله اسبوع من تاريخ 12/7الى 19/7"]
[null,"BLK-CEMIU",0,null,null,20,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,"BLK-SRCU",null,null,null,21,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,"BLK-TYPEII",null,null,null,22,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,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,null,"رخصه سائق منتهه من شهر 4 سماح شهر من 24-1-2021"]
["DEL",null,null,{"$f":"SUM(K29:P29)","v":900},{"$f":"D25/60","v":15},24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"عاطف محمود  09-11-2020",null,null,null,"تصريحه منتهى مهله الى اول الاسبوع 8/12/2020"]
["Total",null,{"$f":"SUM(C4:C23)+H29","v":7492.35},{"$f":"C26+D25","v":8392.35},null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد عبدالشافى 09-11-2020",null,null,null,"تصريحه منتهى"]
[null,null,null,null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"تامر معوض 17-11-2020",null,null,null,"رخصة منتهية"]
["Net Rem",null,{"$f":"C1-C26","v":1007.6499999999996},{"$f":"C1-D26","v":107.64999999999964},null,27,null,null,null,"Total Issued",{"$f":"SUM(K5:K27)","v":1260},180,0,120,60,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد فرج خليل 19-11",null,null,null,"رخصة منتهية"]
[null,null,"TRK",{"$f":"INT(D28/60)+1","v":2},null,null,null,{"$f":"SUM(H2:H28)","v":0},null,"Remaining",{"$f":"K2-K28","v":720},180,0,0,0,0,{"$f":"SUM(K29:P29)","v":900},null,null,null,null,null,null,null,null,null,null,null,null,"سالم معوض 25-11",null,null,null,"كل الرخص منتهية ورخصة السائق مضروبة"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K29/60","v":12},3,0,{"$f":"N29/60","v":0},{"$f":"O29/60","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"سعيد محمد محمد",null,null,null,"كل الرخص  ورخصة السائق مضروبة"]
[null,{"$f":"\"Current Booking \" & TEXT(TODAY(),\"dd-mm-yyyy\") & CHAR(10) &J33 & \"      \" &K33 & CHAR(10) &J34&\"         \"&K34&CHAR(10)&J35&\"       \" &K35 & CHAR(10) &J36&\"          \" &K36 & CHAR(10) &J37&\"         \" &K37& CHAR(10) &J38&\"      \" &K38& CHAR(10) & \"-------------------------------\" & CHAR(10) &J39&\"             \" &K39","v":"Current Booking 26-03-2021\n(BAG)-CEM.      7492.35\n(BAG)-SRC.         0\n(BAG)-CEMII        0\n(BLK)-CEM.          720\n(BLK)-SRC.         180\n(BLK)-TYPEII.      0\n-------------------------------\nTTL-CEM.             8392.35"},null,null,null,null,null,null,null,"Current Booking (SMS)",null,null,null,null,null,null,null,null,{"$f":"SUM(S16:S30)","v":0},null,null,null,null,null,null,null,null,null,null,"عوض حسين يوسف",null,null,null,"رخصه سائق منتهيا من شهر 4(تم تجديد الرخصه)"]
[null,null,null,null,null,null,null,null,null,"Type","Current day Qty",null,null,null,null,null,null,"TTL DIS & ISSUED",null,{"$f":"S31+R17","v":8731.7999999999993},null,null,null,null,null,null,null,null,null,"مصطفى امين على ",null,null,null,"رخصه سائق منتهيا من شهر 5"]
[null,null,null,null,null,null,null,null,null,"(BAG)-CEM.",{"$f":"SUM(C4,C11,C18,N29,O29,H29)","v":7492.35},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"رضا فهيم السيد",null,null,null,"رخصه سائق منتهيا من 11/2019"]
[null,null,null,null,null,null,null,null,null,"(BAG)-SRC.",{"$f":"SUM(C5,C12,C19,P29)","v":0},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,"(BAG)-CEMII ",{"$f":"SUM(C6+C13+C20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"محمد محمد عبدالعزيز",null,null,null,"رخصه منتهيه من 2019 سماح شهر من 24-01"]
[null,null,null,null,null,null,null,null,null,"(BLK)-CEM.",{"$f":"SUM(C7,C14,C21,K29)","v":720}]
[null,"Daily Quota","Packed ","Bulk",null,null,null,null,null,"(BLK)-SRC.",{"$f":"C8+C15+C22+L29","v":180}]
[null,"Dispatch",4440,1864.1,null,null,null,null,null,"(BLK)-TYPEII.",{"$f":"C9+C16+C23+M29","v":0}]
[null,"U/P",480,595,null,null,null,null,null,"TTL-CEM.",{"$f":"SUM(K33:P38)","v":8392.35}]
[null,"Issued",60,120]
[null,"Delivery Plan (Remain)",{"$f":"SUM(N29:O29)","v":0},{"$f":"SUM(K29:L29)","v":900},{"$f":"1080/60","v":18}]
[null,"TTL",{"$f":"SUM(C38:C41)","v":4980},{"$f":"SUM(D38:D41)","v":3479.1}]
[null,"Remaining",{"$f":"5000-C42","v":20},{"$f":"3500-D42","v":20.900000000000091}]
[null,"TRKS",{"$f":"C43/60","v":0.33333333333333331},{"$f":"D43/60","v":0.34833333333333483}]
[]
[null,null,null,null,null,"Daily canyon",null,352.6,null,{"$f":"\"Canyon dispatch figures: \"&  CHAR(10) & CHAR(10) &\"1- \"  &TEXT(TODAY()-1,\"dddd\")&\" \"&LEFT(TEXT(W2,\"dd-mm-yyyy\"),2)-1&\" \"&LEFT(TEXT(W2,\"mmmm\"),3)&\" = \"&H46&\" \"& \"Tons\" &  CHAR(10) & CHAR(10) & \"2- 01 \"&LEFT(TEXT(W2,\"mmmm\"),3) &\" To \" &LEFT(TEXT(W2,\"dd-mm-yyyy\"),2)-1&\" \"&LEFT(TEXT(W2,\"mmmm\"),3)&\" = \"&H47&\" \"& \"Tons\"  &  CHAR(10) & CHAR(10) &\"3- Total Monthly (Sewedy + Canyon) = \" &H48& \" Tons\"","v":"Canyon dispatch figures: \n\n1- Thursday -1 Jan = 352.6 Tons\n\n2- 01 Jan To -1 Jan = 1975.6 Tons\n\n3- Total Monthly (Sewedy + Canyon) = 179753.1 Tons"}]
[null,null,null,null,null,"Monthly canyon",null,1975.6]
[null,null,null,null,null,"(Sewedy + Canyon)",null,179753.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Tuesday"]