{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["BI需求（仓储事业部）"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"BI需求（仓储事业部）","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,11,0],[3,5,5,5]]}
["模块","BI需求","数据源","统计维度或方法","统计周期","详细说明","表现形式"]
["库区","分仓作业量统计（自然吨、操作吨、作业类型）\n-客户总作业量\n-按货类统计作业量","\n【仓储服务订单】\n","按【业务完结时间】各统计","每月、季度、年",null,"图表+数据"]
[null,"分仓出入库作业量统计\n-按客户统计作业量\n-按货类统计作业量","\n【仓储服务订单】\n","按【业务完结时间】各统计","每日、周、月、季度、年"]
[null,"库存存量&仓容利用率统计表","【仓库系统WMS--《货存利用率》】",null,"每日、月、季度、年",null,"图表+数据"]
[null,"平仓单票毛利分析\n-按货类","\n【仓储服务订单】\n","按【业务完结时间】各统计","每月、季度、年",null,"图表+数据"]
[null,"分仓工人作业成本分析","【应付计费（结算单位：远松）】","实际人工成本/当月操作吨","每月、年",null,"图表+数据"]
[null,"分仓油耗分析","【加油记录】","实际月份加油的成本/当月操作吨","每月、季度、年",null,"图表+数据"]
[null,"分仓五金配件、维修成本分析","【采购、维修记录】","实际月份配件、维修的成本/当月操作吨","每季度、年",null,"图表+数据"]
[null,"分仓固定、变动成本分析","【LFS业务系统其他成本费用、应付计费（结算单位：远松）】","按固定、变动成本费目来统计",null,"变动成本与操作吨之间的对比"]
[null,"分项目（仓）前十大客户及货类排名","【仓储服务订单】","按【业务完结】订单来统计","每季度、年",null,"图表+数据"]
[null,"结算效率\n-应收、应付计费\n-开票收款时效","【费目跟踪】","应收、应付计费：（计费时间-业务完结时间）与T+1对比\n开票与收款时效：收款核销时间-发票核销时","每月",null,"图表+数据"]
[null,"分仓盈亏利润分析",null,null,"每月、季度、年",null,"图表+数据"]