{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["到货体积统计","拆单订单汇总","仓库拆分订单明细表","异常订单汇总","仓库保税备货订单明细表","仓库保税展示订单明细表","仓储面积统计","自采耗材客户使用统计表","客户使用我司纸箱的订单","仓库理货数据统计表","E码头仓库增值服务2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"到货体积统计","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["到货体积统计"]
["序号","客户名称","到货日期","托盘尺寸（m)","到货体积（m³）","托盘数量","备注"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]

{"sheet":"拆单订单汇总","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,1,3,1],[4,1,5,1],[6,1,7,1],[8,1,10,1],[11,1,12,1]]}
["****年**月份拆单订单汇总表"]
["序号","系统快递单号","拆分快递单号","第三方订单号","客户","承运商","重量（KG）","送达地","日期","箱号","备注"]
[1,"3101858392515","3101858392515","583146269801","天虹商场","韵达",6.36,"广东","2018-08-03","原箱"]
[2,null,"1901834464976",null,"天虹商场","韵达",5.16,"广东","2018-08-03","原箱"]
[3,"3101858392457","3101858392457","590148912201","天虹商场","韵达",5.36,"广东","2018-08-03","原箱"]
[4,null,"1901834464434",null,"天虹商场","韵达",5.13,"广东","2018-08-03","原箱"]
[5,"3101858392871","3101858392871","07720180809160552386982","前海东阳光","韵达",4.18,"广东","2018-08-10"]
[6,null,"1901834464978",null,"前海东阳光","韵达",4.58,"广东","2018-08-10"]
[7,"3101858392870","3101858392870","07720180809160722544228","前海东阳光","韵达",4.61,"广东","2018-08-10"]
[8,null,"1901834464977",null,"前海东阳光","韵达",3.93,"广东","2018-08-10"]
[9,null,"1901834464979",null,"前海东阳光","韵达",4.58,"广东","2018-08-10"]
[10,"3101908479044","3101908479044","s592268267801","天虹商场","韵达",5.04,"广东","2018-08-29","原箱"]
[11,null,"1901834464986",null,"天虹商场","韵达",6.73,"广东","2018-08-29","原箱"]

{"sheet":"仓库拆分订单明细表","index":2,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["E码头仓库拆分订单明细表"]
["序号","客户","拆分快递单号","第三方订单号","承运商","重量（KG）","送达地","日期","箱号","备注"]
[1,"天虹商场","1901834464976","583146269801","韵达",6.36,"广东","2018-08-03","原箱"]
[2]
[3]

{"sheet":"异常订单汇总","index":3,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["****年**月份异常订单汇总"]
["序号","系统快递单号","原第三方单号","退回快递单号","补发/更改快递单号","客户","快递公司","重量(KG)","省份","日期","备注","费用承担人"]
[1,"3101908478336","590780275101",null,null,"天虹","韵达",2.39,"广东","2018-08-20","系统异常订单、IT重新推单发货"]

{"sheet":"仓库保税备货订单明细表","index":4,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["E码头仓库保税备货订单明细表"]
["序号","第三方订单号","商户名称","保税模式","快递公司","快递单号","订单重量 KG","交货人姓名","交货人手机","发货时间","纸箱代码"]
[1,"593113849901","天虹商场","保税备货模式","韵达速递","3101938270346",0.709,"汪海云","13915520945","2018-08-31 15:29:29","ISTH02"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"仓库保税展示订单明细表","index":5,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["E码头仓库保税展示订单明细表"]
["序号","第三方订单号","商户名称","保税模式","快递公司","快递单号","订单重量 KG","交货人姓名","交货人手机","发货时间","商户门店","纸箱代码","备注"]
[1,"593013095101","天虹商场","保税展示","韵达速递","3101938270339",1.745,"林琼芬","13632720720","2018-08-31 15:25:18","后海天虹","003"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"仓储面积统计","index":6,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["仓储面积统计"]
["序号","统计日期","客户名","货架占用组数","置地区占用托盘数","耗材占用托盘数","备注"]
[1,"2018.09.01","天虹商场",79,30,19,"2018.06.29返区110箱/2018.07.25上架 (增加5托5组)"]
[2,"2018.09.01","沱沱河",1,1,4]
[3,"2018.09.01","东阳光",8,20,5]
[4,"2018.09.01","新恒泰",9,0,2]
[5,"2018.09.01","海岛号",0,2,1]
[6,"2018.09.01","甄选壹品",0,1,1]
[7,"2018.09.01","前海星光",0,6,5]
[8,"2018.09.01","全惠康",0,10,0]
[9,"2018.09.01","前海环太",0,10,0]
[10,"2018.09.01","中网科技乔治",0,6,0]
[11,"2018.09.01","恒康达",0,2,0]
[12,"2018.09.01","欧美雅",60,37,0,"2018.08.24上架完成（4托不良）"]
[13,"2018.09.01","合一和润","1 (留仓销售)",0,2]
[14,"2018.09.01","上海蒙泰",0,20,0,"2017.12.21入仓"]
[15,"2018.09.01","海集汇",0,66,0]
[16,"2018.09.01","聚优汇转中网科技",1,0,0]
[17,"2018.09.01","中网科技（阿普莱兹）",1,0,0]
[18,"2018.09.01","顺丰优选",1,4,0,"8.24退港4托奶粉"]
[19,"2018.09.01","野兽派",6,0,0,"2018.08.31进货"]

{"sheet":"自采耗材客户使用统计表","index":7,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["e码头自采耗材客户使用统计表"]
["序号","月份","品名","规格","月初库存","进货","月末库存","数量    天虹商场","数量     顺丰电子","数量   沱沱河","当月使用合计"]
[1,"2018、08","1#化妆盒","16*10.8*9.6",2252,null,1847,387,2,5,{"$f":"SUM(H3:J3)","v":394}]
[2,"2018、08","2#化妆盒"]
[3,"2018、08","3#化妆盒"]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"客户使用我司纸箱的订单","index":8,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["E码头仓库客户使用我司纸箱的订单"]
["序号","第三方订单号","商户名称","保税模式","快递公司","快递单号","订单重量 KG","交货人姓名","交货人手机","发货时间","纸箱代码"]
[1,"593113806601","天虹商场","保税备货模式","韵达速递","3101938270345",4.802,"叶黎云","15279687210","2018-08-31 15:28:36","N2"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]

{"sheet":"仓库理货数据统计表","index":9,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["E码头仓库理货数据统计表"]
["序号","客户名称","UPC","SKU","名称","数量","时间","备注"]
[1,"天虹商场",8712045031476,"ISTH01000787","幼儿奶粉",507,20170323]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]

{"sheet":"E码头仓库增值服务2","index":10,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["E码头仓库增值服务2"]
["序号","客户","系统单号","快递单号","SKU","UPC","数量","非常规增值操作类型","增值操作次数","备注"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]