{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["船代","维度数据来源"],"not_rendered":{"charts":0,"images":8,"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":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,1,24,1],[4,2,8,2],[9,2,12,2],[13,2,15,2],[16,2,22,2],[23,2,24,2]]}
[]
[]
[]
[null,"看板","看板布局","二级指标","展示方式","分析维度","维度数据来源","度量数据来源（用户确认）（哪个报表哪个字段）","取数逻辑（it小组）","备注"]
[null,"船代","计划完成率","艘次目标完成率","仪表盘","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","当前艘次：lfs订单数    目标艘次：lfs预算编制表艘次数","lfs订单数/年度目标值","年度目标可从lfs中取，按两个维度来计算"]
[null,null,null,"货量目标完成率","仪表盘","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs货量数","lfs货量总数/年度目标值","年度目标可从lfs中取"]
[null,null,null,"收入目标完成率","仪表盘","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中营业收入","lfs营业收入总数/年度目标值","年度目标可从lfs中取，下钻到每个项目收入的组成"]
[null,null,null,"成本目标完成率","仪表盘","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中营业成本","lfs营业成本总数/年度目标值","年度目标可从lfs中取"]
[null,null,null,"毛利润预算完成率","仪表盘","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中毛利润","lfs毛利润总数/年度目标值","年度目标可从lfs中取，下钻到每个项目收入的组成"]
[null,null,"总体一览","代理艘次","文本框","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs订单数","求和"]
[null,null,null,"作业净吨","文本框","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs货量数","求和"]
[null,null,null,"营业收入","文本框","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中营业收入","求和"]
[null,null,null,"毛利润","文本框","时间范围内","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中毛利润","求和"]
[null,null,"业务部分","业务量、艘次、毛利","柱状图","时间范围内、板块、客户、货名、船名","时间按lfs系统权责点时间与ETA外锚地时间","lfs货量数","lfs货量总数","客户指推荐方，业务量、艘次和毛利按照不同分公司统计，可以分为广州、东莞、湛江、广西、南通、珠海、茂名和船代事业部"]
[null,null,null,"广州港船舶艘次货量各船代公司占比","扇形图","时间范围、板块、船代公司、","时间按lfs系统权责点时间与ETA外锚地时间","开通LFS接口，会定期上传统计后的数据"]
[null,null,null,"预报、在港、离港状态船舶数量","条形图","时间范围、船名","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶列表中船舶状态订单数","各状态订单数求和"]
[null,null,"财务部分","预算完成进度","柱状图","时间范围、板块、单位、客户","时间按lfs系统权责点时间与ETA外锚地时间","管理报表取实际数LFS取预算数"]
[null,null,null,"营业收入","柱状图","时间范围、板块、客户、货名、船名、订单","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中营业收入"]
[null,null,null,"营业成本","柱状图","时间范围、板块、客户、货名、船名、订单","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中营业成本"]
[null,null,null,"毛利润","柱状图","时间范围、板块、客户、货名、船名、订单","时间按lfs系统权责点时间与ETA外锚地时间","lfs船舶收入记录表中毛利润"]
[null,null,null,"应付账龄 港口费","表格","时间范围、供应商","时间按lfs系统申请日期","lfs应付费用结算-付款申请","金额按供应商及时间段求和"]
[null,null,null,"应收账龄","表格","时间范围、单位、委托方","时间按lfs寄单日期和开票日期两个维度","lfs","金额按客户及时间段求和"]
[null,null,null,"备用金分析","表格","时间范围、订单","时间按lfs系统报价建单日期","见维度数据来源",null,"添加备用金收取时效"]
[null,null,"客户部分","前30大客户","柱状","时间范围、艘次、货量、毛利","时间按lfs系统权责点时间与ETA外锚地时间","lfs货量数/艘次及毛利",null,"客户指推荐方，按照艘次、货量、毛利三种维度分别列出前30大客户，货量和毛利可下钻到具体船舶，如前30大客户不好展现，可以列出EXCEL形式查看"]
[null,null,null,"客户交易艘次、最近交易时间、贡献利润","散点图","时间范围、客户、板块、货名","时间按lfs系统权责点时间与ETA外锚地时间","货量前十大客户、毛利前十大客户",null,"根据两个不同维度做两个表"]
[]
[null,null,null,"备注："]
[null,null,null,"1、以上内容以2个口径展示，分别为财务和业务，业务取LFS中ETA外锚地时间，财务取LFS中权责点的时间"]
[null,null,null,"2、以上内容按船代事业部和不同分公司去展现数据，公司一项要实现可筛选"]
[null,null,null,"3、以上的数据可以实现任意公司数据的合并"]
[null,null,null,"4、加入货代部分"]
[null,null,null,"5、版面颜色的调整，颜色要清晰分明"]

{"sheet":"维度数据来源","index":1,"n_rows":145,"n_cols":1,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":144}
[15]