{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ورقة1","ورقة2","Sheet1","فاتورة تجارية"],"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":"ورقة1","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["اسم المستخدم","كلمة المرور"]
["عبدالباري",5490290]
[1,1]
["حسين","حسين"]

{"sheet":"ورقة2","index":1,"n_rows":23,"n_cols":57,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,56,2,56],[1,21,1,25],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,1,13],[1,28,1,32],[1,35,1,39],[1,42,1,46],[1,49,1,53],[16,8,21,17],[1,14,1,18],[1,0,2,0],[1,1,1,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[3,0,8,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[3,3,8,3],[3,1,8,1],[3,2,8,2],[22,0,23,1],[16,0,16,1],[17,0,17,1],[9,0,10,0],[17,4,18,6],[16,5,16,6],[18,0,20,1],[20,4,21,6]]}
[]
["Customer\nName","TOTAL GOODS IN",null,null,"Import\nContainer","Declaration No\nFZ Transit In","DATE\nIN","HS CODE","GOODS DESCRIPTION","ORIGIN","PKG -\nTYPE","DETAILS GOODS IN",null,null," DETAILS GOODS OUT 1",null,null,null,null,null,null,"DETAILS GOODS OUT 2",null,null,null,null,null,null,"DETAILS GOODS OUT 3",null,null,null,null,null,null,"DETAILS GOODS OUT 4",null,null,null,null,null,null,"DETAILS GOODS OUT 5",null,null,null,null,null,null,"DETAILS GOODS OUT 6",null,null,null,null,null,null,"COMMENTS"]
[null,"TOTAL\n CTN","TOTAL\n WT","TOTAL \nVALUE",null,null,null,null,null,null,null,"QTY","WT","VALUE","QTY","WT","VALUE","INVICE-\nNO","Export \nContainer","Declaration No\nFZ Transit out","DATE\nOUT","QTY","WT","VALUE","TRIP-\nNO","Export \ncontainer","Declaration No\nFZ Transit out","DATE\nOUT","QTY","WT","VALUE","TRIP-\nNO","Export \ncontainer","Declaration No\nFZ Transit out","DATE\nOUT","QTY","WT","VALUE","TRIP-\nNO","Export \ncontainer","Declaration No\nFZ Transit out","DATE\nOUT","QTY","WT","VALUE","TRIP-\nNO","Export \ncontainer","Declaration No\nFZ Transit out","DATE\nOUT","QTY","WT","VALUE","TRIP-\nNO","Export \ncontainer","Declaration No\nFZ Transit out","DATE\nOUT"]
["حاوية 1",{"$f":"L7+L8+L9+L6+L5+L4","v":6},{"$f":"M7+M8+M9+M6+M5+M4","v":3000},{"$f":"N7+N6+N5+N4+N8+N9","v":9239.8799999999992},4047894,"305-00190060-18","2018-02-26",84253900,"WEBBING BELT ACCESSORIES","CN","U",1,500,1539.98,1,{"$f":"M:M/L:L*O:O","v":500},{"$f":"N:N/L:L*O:O","v":1539.98},3834,"CCCU1520501","102-04244946-18","19/04/2018",null,{"$f":"M4/L4*V4","v":0},{"$f":"N4/L4*V4","v":0},null,null,null,null,null,{"$f":"M4/L4*AC4","v":0},{"$f":"N4/L4*AC4","v":0},null,null,null,null,null,{"$f":"M4/L4*AJ4","v":0},{"$f":"N4/L4*AJ4","v":0},null,null,null,null,null,{"$f":"M4/L4*AQ4","v":0},{"$f":"N4/L4*AQ4","v":0},null,null,null,null,null,{"$f":"M4/L4*AX4","v":0},{"$f":"N4/L4*AX4","v":0},null,null,null,null,{"$f":"L4-O4-V4-AC4-AJ4-AQ4-AX4","v":0}]
[null,null,null,null,4047894,"305-00190060-18","2018-02-26",73158900,"CHAINS AND CHAINS BLOCK","CN","KG",1,500,1539.98,1,{"$f":"M:M/L:L*O:O","v":500},{"$f":"N:N/L:L*O:O","v":1539.98},3834,"CCCU1520501","102-04244946-18","19/04/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"M5/L5*AJ5","v":0},{"$f":"N5/L5*AJ5","v":0},null,null,null,null,null,{"$f":"M5/L5*AQ5","v":0},{"$f":"N5/L5*AQ5","v":0},null,null,null,null,null,{"$f":"M5/L5*AX5","v":0},{"$f":"N5/L5*AX5","v":0},null,null,null,null,{"$f":"L5-O5-V5-AC5-AJ5-AQ5-AX5","v":0}]
[null,null,null,null,4047894,"305-00190060-18","2018-02-26",73121090,"STEEL WIRE ROPE ROPES","CN","KG",1,500,1539.98,1,{"$f":"M:M/L:L*O:O","v":500},{"$f":"N:N/L:L*O:O","v":1539.98},3834,"CCCU1520501","102-04244946-18","19/04/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
[null,null,null,null,4047894,"305-00190060-18","2018-02-26",73269060,"FITTINGS","CN","KG",1,500,1539.98,1,{"$f":"M:M/L:L*O:O","v":500},{"$f":"N:N/L:L*O:O","v":1539.98},3834,"CCCU1520501","102-04244946-18","19/04/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
[null,null,null,null,4047894,"305-00190060-18","2018-02-26",84311000,"HOIST SCALE","CN","KG",1,500,1539.98,1,{"$f":"M:M/L:L*O:O","v":500},{"$f":"N:N/L:L*O:O","v":1539.98},3834,"CCCU1520501","102-04244946-18","19/04/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
[null,null,null,null,4047894,"305-00190060-18","2018-02-26",82054000,"LIFTING TOOLS","CN","KG",1,500,1539.98,1,{"$f":"M:M/L:L*O:O","v":500},{"$f":"N:N/L:L*O:O","v":1539.98},3834,"CCCU1520501","102-04244946-18","19/04/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
["حاوية 2",{"$f":"L10+L11","v":1150},{"$f":"M10+M11","v":27500},{"$f":"N10+N11","v":130541.64},8842392,"302-04905285-18","2018-02-25",84101300,"WATER PUMP","IT","U",650,11650,61297.89,550,{"$f":"M:M/L:L*O:O","v":9857.6923076923085},{"$f":"N:N/L:L*O:O","v":51867.445384615385},3807,null,"303-03661769-18","10/03/2018",100,1792.3076923076924,9430.4446153846166,"TRNS",null,"502-02260575-18","2018-07-12",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
[null,null,null,null,8842392,"302-04905285-18","2018-02-25",39229000,"SHATTAF SET","DE","KG",500,15850,69243.75,500,{"$f":"M:M/L:L*O:O","v":15850},{"$f":"N:N/L:L*O:O","v":69243.75},3807,null,"303-03661769-18","10/03/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
["حاوية 3",{"$f":"L12","v":1107},{"$f":"M12","v":26514},{"$f":"N12","v":137304.89000000001},7932326,"302-04902408-18","2018-02-24",40092210,"BASIN HOSE","ES","KG",1107,26514,137304.89000000001,1107,{"$f":"M:M/L:L*O:O","v":26514.000000000004},{"$f":"N:N/L:L*O:O","v":137304.89000000001},3806,null,"303-03661769-18","10/03/2018",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
["حاوية 4",1752,14450,91125.92,6503831,"302-04894056-18","2018-02-19",94054090,"ELECTRICAL GOODS","CN","KG",1752,14450,91125.92,260,{"$f":"M:M/L:L*O:O","v":2144.4063926940639},{"$f":"N:N/L:L*O:O","v":13523.25296803653},"استلام التاجر",null,null,null,1492,12305.593607305935,77602.667031963472,3801,"OOLU8452196","303-03645748-18","2018-03-01",null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
["حاوية 5",{"$f":"L14","v":511},{"$f":"M14","v":7738.6},{"$f":"N14","v":71232.06},3115490,"302-04923154-18","2018-03-06",84818090,"FAUCET","DE","KG",511,7738.6,71232.06,511,{"$f":"M:M/L:L*O:O","v":7738.6},{"$f":"N:N/L:L*O:O","v":71232.06},3827,null,"303-03715821-18","04/04/2018",null,{"$f":"M:M/L:L*V:V","v":0},0,null,null,null,null,null,{"$f":"M14/L14*AC14","v":0},{"$f":"N14/L14*AC14","v":0},null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,null,0,0,null,null,null,null,0]
["TOTAL : ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,L4:L14)","v":4526},79202.600000000006,439444.39,2934,65104.698700386376,352411.27835265192,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V14)","v":1592},{"$f":"SUBTOTAL(9,W4:W14)","v":14097.901299613626},{"$f":"SUBTOTAL(9,X4:X14)","v":87033.111647348094},null,null,null,null,{"$f":"SUBTOTAL(9,AC4:AC14)","v":0},{"$f":"SUBTOTAL(9,AD4:AD14)","v":0},{"$f":"SUBTOTAL(9,AE4:AE14)","v":0},null,null,null,null,{"$f":"SUBTOTAL(9,AJ4:AJ14)","v":0},{"$f":"SUBTOTAL(9,AK4:AK14)","v":0},{"$f":"SUBTOTAL(9,AL4:AL14)","v":0},null,null,null,null,{"$f":"SUBTOTAL(9,AQ4:AQ14)","v":0},{"$f":"SUBTOTAL(9,AR4:AR14)","v":0},{"$f":"SUBTOTAL(9,AS4:AS14)","v":0},null,null,null,null,{"$f":"SUBTOTAL(9,AX4:AX14)","v":0},{"$f":"SUBTOTAL(9,AY4:AY14)","v":0},{"$f":"SUBTOTAL(9,AZ4:AZ14)","v":0},null,null,null,null,{"$f":"L15-O15-V15-AC15-AJ15-AQ15-AX15","v":0}]
[]
["قيم ثابتة لا تتغير- استيراد -",null,null,null,null,"\"على سبيل المثال\"",null,null,"المطلوب :\n\n إضافة كود او كبسة ترحيل \"على سبيل المثال\" للاكسل شيت يتم من خلالها نقل هذه البيانات حصراً عند التظليل عليها سواء كان المراد ترحيله من حاوية واحدة او من اكثرمن حاوية,وترحيلها تلقيائياً للفاتورة بشرط ان توضع  كل معلومة بمكانها المحدد في الفاتورة .\nباقي البيانات غير مهمة لهذا السبب لا اريد ادراجها بالفاتورة ."]
["قيم متغيرة - تصدير -",null,null,null,"عمل ترحيل للبيانات المولونة بالاحمر من الحاوية رقم 1 بالكامل لـ (فاتورة التجارية )"]
["القيم المراد نقلها للفاتورة من كل سطر عند اللزوم بدون حذفها من هنا"]
[]
[null,null,null,null,"هذه الفاتورة المطلوبة \" معبأة يدوية نسخ و لصق للتوضيح \""]
[]
["يتم إضافة حاويات يومياً بعدد اسطر مختلف"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"فاتورة تجارية","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,1,14,4],[14,7,14,8],[2,1,2,9],[4,8,4,9],[5,2,5,7],[5,8,5,9],[16,2,16,3]]}
[]
[]
[null,"INVOICE"]
[]
[]
[null,"Consignee Name :",null,null,null,null,null,null,"INVOICE NO : 3834\n     DATE :  متغير"]
[]
[null,"DESCRIPTION","H.S.CODE","ORIGIN","ITEM"," QTY -\nCtns","WEIGHT-\nUNIT","Declaration NO","  UNIT-\nPRICE  ","Total Amount \n( AED )"]
[null,"WEBBING BELT ACCESSORIES",84253900,"CN","U",1,500,"305-00190060-18",{"$f":"J9/F9","v":1539.98},1539.98]
[null,"CHAINS AND CHAINS BLOCK",73158900,"CN","KG",1,500,"305-00190060-18",1539.98,1539.98]
[null,"STEEL WIRE ROPE ROPES",73121090,"CN","KG",1,500,"305-00190060-18",1539.98,1539.98]
[null,"FITTINGS",73269060,"CN","KG",1,500,"305-00190060-18",1539.98,1539.98]
[null,"HOIST SCALE",84311000,"CN","KG",1,500,"305-00190060-18",1539.98,1539.98]
[null,"LIFTING TOOLS",82054000,"CN","KG",1,500,"305-00190060-18",{"$f":"J14/F14","v":1539.98},1539.98]
[null,null,null,null,null,{"$f":"SUM(F9:F14)","v":6},{"$f":"SUM(G9:G14)","v":3000},null,null,{"$f":"SUM(J9:J14)","v":9239.8799999999992}]
[]
[null,"Container No : ","CCCU1520501"]