{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["个人工作台需求模板","报检异常","报关异常","流向分拨统计","流向完结","新客户新货类订单","清货完结损耗异常","仓储业务量统计表","入库货物完结溢短统计报表","累计应付未回票","分客服组到货统计表","本模板规则","通关时效表","到货统计","货量到港统计"],"not_rendered":{"charts":0,"images":23,"macros":0,"external_links":0,"defined_names":1,"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":1838,"n_cols":11,"rows_kept":1838,"cut":false,"hidden":false,"merged":[[3,10,9,10]]}
["分来","事项\n（或者报表标题）","统计范围\n(用于财务报表)","频度","推送方式","推送角色\n(请参考模板规则)","备注\n（用于补充\\备注。如果有多推送方式，也可在这备注）","验收记录","完成情况","过程","job"]
["预警提醒","报关异常",null,"每天","系统在线","客服经理","ATA目的港日期后3工作天，“海关放行时间”为空的，发送提醒（报关异常：工作单号XXXX、通关收货人、货名、毛重XX吨）","未能转跳至“报关”页面",null,"已开发"]
["预警提醒","报检异常",null,"每天","系统在线","客服经理","ATA目的港日期后3工作天，“商检调离时间”或“口岸批调运时间”或“商检放行日期”为空的，发送提醒（报检异常：工作单号XXXX、通关收货人、货名、毛重XX吨）","未能转跳至“报检”页面",null,"已开发"]
["预警提醒","损耗异常",null,"每天","系统在线","客服经理","单票业务单，清货完结当天，出库总重量-入库总重量>0.1%，发送提醒（损耗异常：工作单号XXXX、货权方、货名、损耗XX吨、仓库）","待验证",null,"V_SUNHAOEXCEPTION",1605]
["每日业务一览","新建订单",null,"每天","系统在线","客服经理","包括新客户、旧客户的所有新订单合计票数，可展开查看业务单号明细，点击业务单号时转跳至对应单号的“提单详情”页面","未能跳转至“提单详情”"]
["每日业务一览","新客户/货类订单",null,"每天","系统在线","客服经理","新客户订单或旧客户新货类订单合计票数，可展开查看业务单号明细，点击业务单号时转跳至对应单号的“提单详情”页面","部分业务单号未能转跳到正确的页面；"]
["每日业务一览","流向完结",null,"每天","系统在线","客服经理","每天17:00前状态变为“流向完结”的业务单号合计票数，可展开查看业务单号明细，点击业务单号时转跳至对应单号的“流向分拨”页面","流向分拨页面增加计划柜量合计、计划重量合计"]
["每日业务一览","清货完结损耗异常",null,"每天","系统在线","客服经理","每天17:00前状态变为“清货完结”的业务单号合计票数，可展开查看业务单号明细，点击业务单号时转跳至对应单号的“流向分拨”页面","未能跳转至“流向分拨”页面，或转跳后显示为空白"]
["每日业务一览","货量到港统计",null,"每天","系统在线","客服经理","每天17:00前统计ATA目的港当天到货总量（分集装箱、散船；分区域）","统计总数与明细重量不对应；增加显示合计数",null,"P_add_WEIXIN_KEFUTUISONG"]
["每日业务一览","流向分拨统计",null,"每天","系统在线","客服经理","每天17:00前统计当天流向分拨总量（分集装箱、散船；分库区；分入库类和出库类）","入库统计表里不应显示出库统计数据"]
[null,"货权异常报表",null,"每天","系统在线","客服经理","过车业务时，因实际入库数未能及时录入系统，导致无法录入货权转移，汇总显示未录入货权转移但已开出库单的任务号，以便控货人员跟进补录货权转移情况，补录后实时刷新异常记录","新需求"]
[null,"短信开单报表",null,"每天","系统在线","客服经理","汇总显示短信开单（客户未补书面）的出入库指令报表，以便控货人员跟踪客户补书面指令，收到书面指令后能在报表中剔除对应的短信开单记录，剔除后实时刷新异常记录","新需求",null,"personal_work_space/feeCollect1/msg_bill_order/msg_bill_order"]
["我的报表","累计应付未回票",null,null,"系统在线","客服经理","每周发送累计应付未回票（结算单位、工作单号、通关收货人、金额）","增加显示具体费目对应的付款申请人；按付款申请人区分欠票归属部门，以便跟踪本部门欠票情况",null,"所有版块"]
["我的报表","到货统计",null,null,"系统在线","客服经理","每月第一个自然天统计上月到货，ATA目的港为统计依据，分维度（客户、货名）对比当月销售预测；以客服组为单位统计当月到货总量（分散船、集装箱）与预设到货量达标线对比结果","需增加转跳功能或下拉展开功能，对比图显示不正确，需增加合计功能",null,"客服组提醒"]
["我的报表","通关时效统计",null,null,"系统在线","客服经理","每月第一个自然天统计上月实际到货，ATA目的港为统计依据，通关异常合计票数，可生成通关时效图，点击对应的业务单号时转跳至对应单号的“提单详情”页面","通关用时计算有问题？",null,"已开发"]
["我的报表","分客服组到货量统计",null,null,"系统在线","客服经理","每周统计各客服组累计到货量，ATA目的港为统计依据，从以下几个维度体现统计结果（集装箱、散船各合计到货量；不同货名合计到货；不同口岸合计到货），统计结果按客服组分开体现","显示数量与业务单详情不一致；码头需显示中文；查询后货名显示为空白；"]
["我的报表","入库货物完结溢短统计报表",null,null,"系统在线","客服经理","每月第一个自然天统计上月清货完结业务单的溢短情况，溢短统计图表（集装箱分拨类型：仓库入库、拆箱装卡、外拖倒拆柜装船、仓库过车、码头倒拆柜装船、码头过车、码头内拆、卸船入库、移库），涉及以上分拨类型的业务单，清货完结后统计溢短率；","取消入库的业务信息，不应带入统计报表里；溢短标注显示不同颜色"]
["我的报表","仓储业务量统计表",null,null,"系统在线","客服经理",null,"部分计划放货重量未能正常带出"]
{"$rows_empty":1594}
[{"$nulls":5},"鲅鱼圈项目人力行政专员"]
[{"$nulls":5},"鲅鱼圈项目业务经理"]
[{"$nulls":5},"鲅鱼圈项目业务员"]
[{"$nulls":5},"鲅鱼圈项目总经理"]
[{"$nulls":5},"北海元亨副总经理"]
[{"$nulls":5},"北海元亨人力行政专员"]
[{"$nulls":5},"北海元亨商务员"]
[{"$nulls":5},"北海元亨调度员"]
[{"$nulls":5},"北海元亨外勤"]
[{"$nulls":5},"财务总监"]
[{"$nulls":5},"仓储部经理"]
[{"$nulls":5},"仓储部专员"]
[{"$nulls":5},"仓储财务经理"]
[{"$nulls":5},"仓储出纳"]
[{"$nulls":5},"仓储会计"]
[{"$nulls":5},"船代财务经理"]
[{"$nulls":5},"船代出纳"]
[{"$nulls":5},"船代会计"]
[{"$nulls":5},"船代-结算提醒"]
[{"$nulls":5},"船代事业部风控"]
[{"$nulls":5},"船代事业部副总经理"]
[{"$nulls":5},"船代事业部商务"]
[{"$nulls":5},"船代事业部市场专员"]
[{"$nulls":5},"船代事业部调度"]
[{"$nulls":5},"船代事业部外勤"]
[{"$nulls":5},"船代事业部总经理"]
[{"$nulls":5},"东北项目人力行政专员"]
[{"$nulls":5},"东北项目业务经理"]
[{"$nulls":5},"东北项目业务员"]
[{"$nulls":5},"东北项目总经理"]
[{"$nulls":5},"东莞元亨副总经理"]
[{"$nulls":5},"东莞元亨人力行政专员"]
[{"$nulls":5},"东莞元亨商务员"]
[{"$nulls":5},"东莞元亨调度员"]
[{"$nulls":5},"东莞元亨外勤"]
[{"$nulls":5},"防城港元亨副总经理"]
[{"$nulls":5},"防城港元亨人力行政专员"]
[{"$nulls":5},"防城港元亨商务员"]
[{"$nulls":5},"防城港元亨调度员"]
[{"$nulls":5},"防城港元亨外勤"]
[{"$nulls":5},"供应商管理（仓储）"]
[{"$nulls":5},"供应商管理（车队）"]
[{"$nulls":5},"供应商管理（船代）"]
[{"$nulls":5},"供应商管理（船公司）"]
[{"$nulls":5},"供应商管理（检验公司、报关报检）"]
[{"$nulls":5},"供应商管理（码头、堆场）"]
[{"$nulls":5},"供应商管理（消毒公司）"]
[{"$nulls":5},"供应商管理（运输）"]
[{"$nulls":5},"供应商结算"]
[{"$nulls":5},"股份财务经理"]
[{"$nulls":5},"股份出纳"]
[{"$nulls":5},"股份公司副总经理"]
[{"$nulls":5},"股份公司总经理"]
[{"$nulls":5},"股份会计"]
[{"$nulls":5},"股份资金经理"]
[{"$nulls":5},"广西侨益副总经理"]
[{"$nulls":5},"广西侨益人力行政专员"]
[{"$nulls":5},"广西侨益业务经理"]
[{"$nulls":5},"广西侨益业务员"]
[{"$nulls":5},"广西侨益总经理"]
[{"$nulls":5},"广西悦达人力行政专员"]
[{"$nulls":5},"广西悦达业务经理"]
[{"$nulls":5},"广西悦达业务员"]
[{"$nulls":5},"广西悦达总经理"]
[{"$nulls":5},"广州惠安茅岗仓仓管"]
[{"$nulls":5},"广州惠安茅岗仓经理"]
[{"$nulls":5},"广州惠安明珠仓仓管"]
[{"$nulls":5},"广州惠安明珠仓经理"]
[{"$nulls":5},"广州惠安南沙仓仓管"]
[{"$nulls":5},"广州惠安南沙仓经理"]
[{"$nulls":5},"广州惠安人力行政专员"]
[{"$nulls":5},"广州惠安市场部经理"]
[{"$nulls":5},"广州惠安市场部专员"]
[{"$nulls":5},"广州惠安信华仓仓管"]
[{"$nulls":5},"广州惠安信华仓经理"]
[{"$nulls":5},"广州惠安总经理"]
[{"$nulls":5},"广州惠安总经理助理"]
[{"$nulls":5},"广州侨益办单专员"]
[{"$nulls":5},"广州侨益报价员"]
[{"$nulls":5},"广州侨益操作经理"]
[{"$nulls":5},"广州侨益发卡专员"]
[{"$nulls":5},"广州侨益副总经理"]
[{"$nulls":5},"广州侨益黄埔通关内勤"]
[{"$nulls":5},"广州侨益客服经理"]
[{"$nulls":5},"广州侨益客服主管"]
[{"$nulls":5},"广州侨益控货复核"]
[{"$nulls":5},"广州侨益控货专员"]
[{"$nulls":5},"广州侨益联运经理"]
[{"$nulls":5},"广州侨益联运专员"]
[{"$nulls":5},"广州侨益南沙通关内勤"]
[{"$nulls":5},"广州侨益人力行政经理"]
[{"$nulls":5},"广州侨益人力行政专员"]
[{"$nulls":5},"广州侨益商务经理"]
[{"$nulls":5},"广州侨益商务主管"]
[{"$nulls":5},"广州侨益商务专员"]
[{"$nulls":5},"广州侨益市场经理"]
[{"$nulls":5},"广州侨益市场专员"]
[{"$nulls":5},"广州侨益通关经理"]
[{"$nulls":5},"广州侨益总经理"]
[{"$nulls":5},"广州侨益总经理助理"]
[{"$nulls":5},"广州生生驳船"]
[{"$nulls":5},"广州生生航运经理"]
[{"$nulls":5},"广州生生航运调度"]
[{"$nulls":5},"广州生生汽运经理"]
[{"$nulls":5},"广州生生汽运调度"]
[{"$nulls":5},"广州生生人力行政经理"]
[{"$nulls":5},"广州生生人力行政专员"]
[{"$nulls":5},"广州生生市场经理"]
[{"$nulls":5},"广州生生市场专员"]
[{"$nulls":5},"广州生生司机"]
[{"$nulls":5},"广州生生装卸经理"]
[{"$nulls":5},"广州生生装卸专员"]
[{"$nulls":5},"广州生生总经理"]
[{"$nulls":5},"广州元亨船务部经理"]
[{"$nulls":5},"广州元亨副总经理"]
[{"$nulls":5},"广州元亨人力行政专员"]
[{"$nulls":5},"广州元亨商务经理"]
[{"$nulls":5},"广州元亨商务员"]
[{"$nulls":5},"广州元亨市场经理"]
[{"$nulls":5},"广州元亨市场专员"]
[{"$nulls":5},"广州元亨调度经理"]
[{"$nulls":5},"广州元亨调度员"]
[{"$nulls":5},"广州元亨外勤"]
[{"$nulls":5},"广州元亨外勤经理"]
[{"$nulls":5},"广州元亨总经理"]
[{"$nulls":5},"广州悦达人力行政专员"]
[{"$nulls":5},"广州悦达业务经理"]
[{"$nulls":5},"广州悦达业务员"]
[{"$nulls":5},"广州悦达总经理"]
[{"$nulls":5},"黄埔报关报检员"]
[{"$nulls":5},"黄埔通关外勤"]
[{"$nulls":5},"黄埔主管"]
[{"$nulls":5},"货代财务经理"]
[{"$nulls":5},"货代出纳"]
[{"$nulls":5},"货代会计"]
[{"$nulls":5},"货代事业部客服专员"]
[{"$nulls":5},"货代事业部商务专员"]
[{"$nulls":5},"货代事业部市场专员"]
[{"$nulls":5},"货代事业部通关专员"]
[{"$nulls":5},"货代事业部总经理"]
[{"$nulls":5},"货代物料管理专员"]
[{"$nulls":5},"检验鉴定员"]
[{"$nulls":5},"客服1组"]
[{"$nulls":5},"客服2组"]
[{"$nulls":5},"客服3组"]
[{"$nulls":5},"客服4组"]
[{"$nulls":5},"客服5组"]
[{"$nulls":5},"客户资料审核人"]
[{"$nulls":5},"老港报关供应商"]
[{"$nulls":5},"老港操作外勤"]
[{"$nulls":5},"南沙报关报检员"]
[{"$nulls":5},"南沙操作外勤"]
[{"$nulls":5},"南沙通关外勤"]
[{"$nulls":5},"南沙主管"]
[{"$nulls":5},"南通侨益副总经理"]
[{"$nulls":5},"南通侨益人力行政专员"]
[{"$nulls":5},"南通侨益业务经理"]
[{"$nulls":5},"南通侨益业务员"]
[{"$nulls":5},"南通侨益总经理"]
[{"$nulls":5},"南通元亨副总经理"]
[{"$nulls":5},"南通元亨人力行政专员"]
[{"$nulls":5},"南通元亨商务员"]
[{"$nulls":5},"南通元亨调度员"]
[{"$nulls":5},"南通元亨外勤"]
[{"$nulls":5},"南通元亨总经理"]
[{"$nulls":5},"内部审计"]
[{"$nulls":5},"企发经理"]
[{"$nulls":5},"企发专员"]
[{"$nulls":5},"企发总监"]
[{"$nulls":5},"钦州元亨副总经理"]
[{"$nulls":5},"钦州元亨人力行政专员"]
[{"$nulls":5},"钦州元亨商务员"]
[{"$nulls":5},"钦州元亨调度员"]
[{"$nulls":5},"钦州元亨外勤"]
[{"$nulls":5},"人力行政经理"]
[{"$nulls":5},"人力行政专员"]
[{"$nulls":5},"人力行政总监"]
[{"$nulls":5},"厦门鑫侨益报关报检员"]
[{"$nulls":5},"厦门鑫侨益操作经理"]
[{"$nulls":5},"厦门鑫侨益操作专员"]
[{"$nulls":5},"厦门鑫侨益客服专员"]
[{"$nulls":5},"厦门鑫侨益人力行政专员"]
[{"$nulls":5},"厦门鑫侨益业务经理"]
[{"$nulls":5},"厦门鑫侨益总经理"]
[{"$nulls":5},"深圳元亨船务经理"]
[{"$nulls":5},"深圳元亨单证经理"]
[{"$nulls":5},"深圳元亨单证员"]
[{"$nulls":5},"深圳元亨外勤"]
[{"$nulls":5},"深圳元亨总经理"]
[{"$nulls":5},"生生西江业务经理"]
[{"$nulls":5},"生生西江业务员"]
[{"$nulls":5},"市场专员"]
[{"$nulls":5},"市场总监"]
[{"$nulls":5},"市场总监助理"]
[{"$nulls":5},"新港报关供应商"]
[{"$nulls":5},"新港操作外勤"]
[{"$nulls":5},"新沙报关报检员"]
[{"$nulls":5},"新沙通关外勤"]
[{"$nulls":5},"新沙主管"]
[{"$nulls":5},"元亨国际副总经理"]
[{"$nulls":5},"元亨国际人力行政专员"]
[{"$nulls":5},"元亨国际业务员"]
[{"$nulls":5},"岳阳侨益人力行政专员"]
[{"$nulls":5},"岳阳侨益业务经理"]
[{"$nulls":5},"岳阳侨益业务员"]
[{"$nulls":5},"岳阳侨益总经理"]
[{"$nulls":5},"运输财务经理"]
[{"$nulls":5},"运输出纳"]
[{"$nulls":5},"运输会计"]
[{"$nulls":5},"湛江元亨副总经理"]
[{"$nulls":5},"湛江元亨人力行政专员"]
[{"$nulls":5},"湛江元亨商务员"]
[{"$nulls":5},"湛江元亨调度员"]
[{"$nulls":5},"湛江元亨外勤"]
[{"$nulls":5},"重庆侨益人力行政专员"]
[{"$nulls":5},"重庆侨益业务经理"]
[{"$nulls":5},"重庆侨益业务员"]
[{"$nulls":5},"重庆侨益总经理"]
[{"$nulls":5},"珠海侨益副总经理"]
[{"$nulls":5},"珠海侨益人力行政专员"]
[{"$nulls":5},"珠海侨益业务员"]
[{"$nulls":5},"珠海元亨副总经理"]
[{"$nulls":5},"珠海元亨人力行政专员"]
[{"$nulls":5},"珠海元亨商务员"]
[{"$nulls":5},"珠海元亨调度员"]
[{"$nulls":5},"珠海元亨外勤"]

{"sheet":"报检异常","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"报关异常","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"流向分拨统计","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"流向完结","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"新客户新货类订单","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"清货完结损耗异常","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"仓储业务量统计表","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"入库货物完结溢短统计报表","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"累计应付未回票","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"分客服组到货统计表","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"本模板规则","index":11,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["分类","报表统计范围","频度","推送方式","推送角色"]
["消息通知","股份合并、事业部、单体","每次","微信","财务总监"]
["待办事项","股份合并","每小时","短信","股份财务经理"]
["预警提醒","事业部","每天","系统在线","股份出纳"]
["每日业务一览","单体","每周",null,"股份公司副总经理"]
["我的报表",null,"每月",null,"股份公司总经理"]
["知识窗口",null,"每季度",null,"股份会计"]
[null,null,"每年",null,"股份资金经理"]
[{"$nulls":4},"广州侨益办单专员"]
[{"$nulls":4},"广州侨益报价员"]
[{"$nulls":4},"广州侨益操作经理"]
[{"$nulls":4},"广州侨益发卡专员"]
[{"$nulls":4},"广州侨益副总经理"]
[{"$nulls":4},"广州侨益黄埔通关内勤"]
[{"$nulls":4},"广州侨益客服经理"]
[{"$nulls":4},"广州侨益客服主管"]
[{"$nulls":4},"广州侨益控货复核"]
[{"$nulls":4},"广州侨益控货专员"]
[{"$nulls":4},"广州侨益联运经理"]
[{"$nulls":4},"广州侨益联运专员"]
[{"$nulls":4},"广州侨益南沙通关内勤"]
[{"$nulls":4},"广州侨益人力行政经理"]
[{"$nulls":4},"广州侨益人力行政专员"]
[{"$nulls":4},"广州侨益商务经理"]
[{"$nulls":4},"广州侨益商务主管"]
[{"$nulls":4},"广州侨益商务专员"]
[{"$nulls":4},"广州侨益市场经理"]
[{"$nulls":4},"广州侨益市场专员"]
[{"$nulls":4},"广州侨益通关经理"]
[{"$nulls":4},"广州侨益总经理"]
[{"$nulls":4},"广州侨益总经理助理"]
[{"$nulls":4},"广州悦达人力行政专员"]
[{"$nulls":4},"广州悦达业务经理"]
[{"$nulls":4},"广州悦达业务员"]
[{"$nulls":4},"广州悦达总经理"]
[{"$nulls":4},"黄埔报关报检员"]
[{"$nulls":4},"黄埔通关外勤"]
[{"$nulls":4},"黄埔主管"]
[{"$nulls":4},"货代财务经理"]
[{"$nulls":4},"货代出纳"]
[{"$nulls":4},"货代会计"]
[{"$nulls":4},"检验鉴定员"]
[{"$nulls":4},"客服1组"]
[{"$nulls":4},"客服2组"]
[{"$nulls":4},"客服3组"]
[{"$nulls":4},"客服4组"]
[{"$nulls":4},"客服5组"]
[{"$nulls":4},"老港报关供应商"]
[{"$nulls":4},"老港操作外勤"]
[{"$nulls":4},"南沙报关报检员"]
[{"$nulls":4},"南沙操作外勤"]
[{"$nulls":4},"南沙通关外勤"]
[{"$nulls":4},"南沙主管"]
[{"$nulls":4},"内部审计"]
[{"$nulls":4},"市场专员"]
[{"$nulls":4},"市场总监"]
[{"$nulls":4},"市场总监助理"]
[{"$nulls":4},"新港报关供应商"]
[{"$nulls":4},"新港操作外勤"]
[{"$nulls":4},"新沙报关报检员"]
[{"$nulls":4},"新沙通关外勤"]
[{"$nulls":4},"新沙主管"]

{"sheet":"通关时效表","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"到货统计","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"货量到港统计","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}