{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["目录 ","驳船历史运价表","调度中心-调优"],"not_rendered":{"charts":0,"images":2,"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":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["序号","需求模块","说明","数据来源","备注"]
[1,"前十大客户粘性分析","卸货量、卸货完成时间、货类、业务类型、客户","陆运利润表\n驳船利润表","可参考船代的"]
[2,"驳船历史运价表","见附件","驳运应收批量管理\n驳运应付批量管理"]
[3,"驳船船期表","待提供","驳船动态跟踪"]
[4,"潜在业务机会（散船）","1、见【散船-潜在业务机会】\n只需要散船（饲料、粮食）的业务类型","出库跟踪表"]
[5,"潜在业务机会（集装箱）","1、见【集装箱-潜在业务机会】\n只需要【自提、公路运输配送】的分拨类型","货代派单管理"]
[6,"客户贡献度分析","见附件","陆运利润表\n驳船利润表\n内贸利润表\n仓储服务"]
[7,"各业务类型占比","按收入/毛利/业务量分别分析\n目前的业务类型有：航运、陆运、新会科润仓、集运业务","陆运利润表\n驳船利润表\n内贸利润表\n仓储服务"]

{"sheet":"驳船历史运价表","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["查询条件：船名、货名、装货港、卸货港、时间区间"]
[]
["驳船名","卸货完成时间","货名","装货港","卸货港","应收结算单位","应收单价","应付单价","平均应收单价","平均应付单价"]
[]
[]
[]
[]
[]
["说明：应收单价、应付单价，取【水路运费、代理运费】的值"]
["      平均应收单价，取所查询数据的应收单价平均值"]
["      平均应付单价，取所查询数据的应付单价平均值"]

{"sheet":"调度中心-调优","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["查询条件：船名、载重吨（A级/B级）区间"]
[]
["驳船名","重吉","常做航线","载重吨（A级）","载重吨（B级）","常做货类"]
{"$rows_empty":9}
["说明：1、常做航线、载重吨的数据来自驳船档案"]
["      2、在【驳船档案】增加字段（常做货类）"]
["      3、在找船平台（右图）显示上述列表"]
["      4、重吉的逻辑，当【驳船运输动态跟踪】的（卸货完成时间+1天内），显示为吉船，否则为重船"]
["         如驳船运输动态跟踪没有该船，默认为【未知】"]