{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","表1","表2","表3"],"not_rendered":{"charts":7,"images":2,"macros":0,"external_links":4,"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":"Sheet1","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,4,0],[5,0,6,0],[7,0,8,0],[1,1,2,1],[3,1,4,1],[5,1,6,1],[7,1,8,1],[10,1,11,1],[7,2,8,2],[7,8,8,8]]}
["序号","需求方向","目的","BI需求","数据来源","备注",null,null,"是否完成开发"]
[1,"市场开发","图像化展示市场调研的数据分析结果","以地图上点标注现有及潜在客户的地理分布、每个点按产量（需求量）以饼状图形式显示区分大小以及我司现有份额。","调研数据表","产量还需要更加细分","后期：经纬度，地图，参考监控中心，数据源模板",null,"不能开发"]
[null,null,"CRM数据分析，用于客户关系维护统计、部门市场人员KPI统计，以及主要是市场人员精力分布","按客户、类型、业务员和时间维度显示客户拜访维护次数，并可下选具体每次拜访的拜访记录","CRM数据","是否可以标注新客户、未成交","展现实际数据，饼状图，表格形式导入",null,"不能开发"]
[2,"现有客户行为分析","通过监控业务量、收入、毛利、单吨毛利来对客户进行分级，并对客户行为进行跟踪，调查客户满意度","以客户、货类、库区三个维度，关联显示对应维度业务量、收入、毛利、单吨毛利的总占比、同比以及环比数据","WMS和LFS","1.收入区分装卸及堆存，业务量区分自然吨和操作吨\n2.客户是否可以按排名显示","三个板块","order_head/wms_inout_work/fee_det","已开发（在修改）"]
[null,null,"RFM模型标记客户潜在流失概率","按照最近一次订单入库时间和今年的下单次数维度，显示客户位置","LFS",null,"xy轴，展现客户的下单量，和最近一次下单时间","order_head","不能开发"]
[3,"部门管理","根据应收账款进度，督促业务员的催收进度。","采用财务版本，并标记到对应负责人",null,"（伟哥在做）",null,null,"未完成"]
[null,null,"部门预算数据","市场部的成本预算完成情况","预算表和财务系统",null,null,null,"已完成开发（数据代调整）"]
[4,"展示给客户","图像化显示","库存及出入库数据","WMS和LFS",null,null,"wms_work_inout","与用户沟通，延后开发"]
[null,null,null,"超期库存提示、所占比例","WMS和LFS",null,"入库当天到30天之后提示下业务量，比例库存/入库","wms_work_inout"]
[5,"商务结算","图像化显示月收入成本情况","根据每月客户收入情况、供应商成本汇总（如表1）","LFS或财务/商务报表","1、客户收入汇总含：货类、入库量、出库量、装卸费、堆存费、仓储服务费、费用合计（备注：钢材还需转入转出量，数据分吨数及件数两维度显示）；            2、成本汇总含：供应商、成本费用名称、费用合计","时间维度/计算单吨成本","fee_det/order_head","已驳回无法开发"]
[6,"内部分析","数据汇总反馈","以表格数据形式汇总各仓库每日出入库作业量（如表2）","wms",null,null,"wms_work_inout","未开发"]
[7,null,"汇报PPT数据分析","对月度、季度、半年度、年度进行经营分析需求的数据分析（如表3)",null,"操作量、自然吨、仓容利用率、周转率等",null,null,"已开发（数据核对）"]

{"sheet":"表1","index":1,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,14],[43,0,43,1],[63,0,63,14],[66,0,66,11],[77,0,77,11],[1,0,42,0],[44,0,52,0],[54,0,57,0],[2,1,3,1],[7,1,11,1],[13,1,36,1],[44,1,51,1],[54,1,57,1]]}
["2019年9月汇总表"]
["明珠","结算单位","经营单位","船名","货物名称","入库作业量（吨）","出库作业量（吨）","结存重量（吨）","装卸费用(元）","堆存费用（元）","其他费用（元）","备注","储备利费（元）","毛利","备注"]
[null,"自营","美豆",null,"大豆",3912.97,8771.85,1441.188,0,110939.41,70198.32,"过磅409.64元，电费67830.35元，水费602.64元，转仓1355.7元",null,181137.73]
[null,null,"广麦",null,"大豆",334.72,0,0,0,0,4686.08,null,null,4686.08]
[null,"自营小计",null,null,null,4247.69,8771.85,1441.188,0,110939.41,74884.4,null,0,185823.81]
[null,"新港","新港","光明上海","大麦",6890.645,0,18029.595,68906.45,270000,null,null,null,338906.45]
[null,"新港小计",null,null,null,6890.645,0,18029.595,68906.45,270000,0,null,0,338906.45]
[null,"货代","厦门建发物产有限公司",null,"菜籽粕",0,111.33,0,1224.63,988.63,null,null,null,2213.26]
[null,null,"安徽安粮国际发展有限公司",null,"鸡肉粉",0,99.9,467.5,1398.6,7897.56,null,null,null,9296.16]
[null,null,"通威集团有限公司",null,"鸡肉粉",240.6,238.23,436.77,9590.82,6853.59,null,null,null,16444.41]
[null,null,"深圳广大科技发展有限公司",null,"紫花苜蓿草颗粒",0,190.55,728.13,2667.7,11322.6,null,null,null,13990.3]
[null,null,"江苏国泰华博进出口有限公司",null,"木薯淀粉",0,54.36,0,761.04,402.26,null,null,null,1163.3]
[null,"货代小计",null,null,null,240.6,694.37,1632.4,15642.79,27464.64,0,null,0,43107.43]
[null,"市粮","越秀",null,"美白",0,856.704,0,12850.56,15536.81,null,null,null,28387.37]
[null,null,"海珠",null,"2018小麦",0,0,2535.182,0,47534.66,null,null,null,47534.66]
[null,null,"越秀",null,"13.5加麦",0,2760.54,1446.084,41408.1,79891.41,null,null,null,121299.51]
[null,null,"市本级",null,"13.5加麦",0,0,3438.72,0,85968,null,null,null,85968]
[null,null,"海珠",null,"13.0加麦",0,2516.732,0,37750.98,56827.85,null,null,null,94578.83]
[null,null,"市本级",null,"13.8加麦",0,1889.454,3055.946,28341.81,123288.03,null,null,null,151629.84]
[null,null,"市本级","穗海韵187","13.0加麦",0,307.6,2694.056,4614,51205.65,null,null,null,55819.65]
[null,null,"市本级","新通和3303","13.8加麦",0,0,4974.334,0,124358.35,null,null,null,124358.35]
[null,null,"市本级","万兴6889","美软红",0,699.086,0,10486.29,1461.25,null,null,null,11947.54]
[null,null,"越秀","桂平宏远7899","加麦",0,0,4074.865,0,100841.88,null,null,null,100841.88]
[null,null,"市本级","粤鼎湖货6638","加麦",0,0,1976.461,0,37058.64,null,null,null,37058.64]
[null,null,"越秀区","考提丝","13.8加麦",0,0,5325.154,0,99846.64,null,null,null,99846.64]
[null,null,"越秀区","考提丝","13.5加麦",0,0,5325.375,0,99850.78,null,null,null,99850.78]
[null,null,"市本级","考提丝","13.5加麦",0,0,2989.625,0,56055.47,null,null,null,56055.47]
[null,null,"越秀区","巨富","13.8加麦",0,0,5367.876,0,100647.68,null,null,null,100647.68]
[null,null,"海珠区","巨富","13.8加麦",0,0,2423.378,0,45438.34,null,null,null,45438.34]
[null,null,"市本级","巨富","13.8加麦",0,0,7858.072,0,147338.85,null,null,null,147338.85]
[null,null,"市本级",null,"江苏红麦",0,0,5081.086,0,95270.36,null,null,null,95270.36]
[null,null,"越秀区",null,"江苏红麦",0,0,5205.4,0,97601.25,null,null,null,97601.25]
[null,null,"市本级","嘉汇9","山东9023白麦",0,0,5078.176,0,95215.8,null,null,null,95215.8]
[null,null,"越秀区",null,"济麦22",3699.16,0,4493.56,55487.4,42460.28,null,null,null,97947.68]
[null,null,"海珠区",null,"02-1小麦",3049.5,0,4044.06,45742.5,48523.25,null,null,null,94265.75]
[null,null,"市本级",null,"津强",4010.39,0,4010.39,60155.85,31120.97,null,null,null,91276.82]
[null,null,"越秀区",null,"苏白",1347,0,1347,20205,3030.75,0,"熏蒸费用",null,23235.75]
[null,"市粮小计",null,null,null,12106.05,9030.116,82744.8,317042.49,1686372.95,0,null,0,2003415.44]
[null,"合计",null,null,null,23484.985,18496.336,103847.983,401591.73,2094777,74884.4,null,0,2571253.13]
[null,"市本级",null,null,"小麦",{"$nulls":7},795000,795000]
[null,"黄埔区",null,null,"小麦",{"$nulls":7},892000,892000]
[null,"海珠区",null,null,"小麦",{"$nulls":7},408000,408000]
[null,"合计",{"$nulls":10},2095000,2095000]
["明珠合计",{"$nulls":4},23484.985,18496.336,103847.983,401591.73,2094777,74884.4,null,2095000,4666253.13]
["五矿","货代","福州建发实业有限公司","QYIC19030066F01","米糠",0,108.89,14.54,1524.46,1242.95,null,null,null,2767.41]
[null,null,"福州建发实业有限公司","QYIC19030193F01","米糠",0,423.63,208.55,5930.82,8441.46,null,null,null,14372.28]
[null,null,"福州建发实业有限公司","QYIC19040033F01","米糠",0,0,685.24,0,10278.6,null,null,null,10278.6]
[null,null,"福州建发实业有限公司","QYIC19040042F01","米糠",0,0,666.7,0,10000.5,null,null,null,10000.5]
[null,null,"青岛瑞港集团有限公司",null,"甜菜粕",37.17,121.3,7.55,2447.58,351.77,null,null,null,2799.35]
[null,null,"通威集团有限公司","QYD19080058TH01","鸡肉粉",285.18,0,285.18,7414.68,3965.89,1600,null,null,12980.57]
[null,null,"湖南宇腾有色金属有限公司",null,"银精矿",6838.66,6827.71,0,136663.7,8530.41,26200,null,null,171394.11]
[null,null,"大连华玺贸易有限公司",null,"鱼粉",714.31,486,648.32,16804.34,11760.18,null,null,null,28564.52]
[null,"货代小计",null,null,null,7875.32,7967.53,2516.08,170785.58,54571.76,27800,0,null,253157.34]
["五矿小计",{"$nulls":4},7875.32,7967.53,2516.08,170785.58,54571.76,27800,0,null,253157.34]
["广浚","货代","中化河北有限公司","QYIB19080030F01","棕榈仁粕",1107.84,661.9,445.94,30935.4,1407.73,null,null,null,32343.13]
[null,null,"通威集团有限公司",null,"鸡肉粉",136.78,0,136.78,3556.28,1402.34,null,null,null,4958.62]
[null,null,"厦门建发物产有限公司","QYDC19090012F01","菜籽粕",28.21,28.42,0,651.14,51.16,null,null,null,702.3]
[null,null,"深圳广大科技发展有限公司",null,"紫花苜蓿草颗粒",386.28,0,696.42,10043.28,6992,null,null,null,17035.28]
["广浚小计",{"$nulls":4},1659.11,690.32,1279.14,45186.1,9853.23,0,0,null,55039.33]
["全通","货代","中国国投国际贸易有限公司",null,"木薯淀粉",0,813.9,659.438,11394.6,{"$nulls":4},11394.6]
["全通小计",{"$nulls":4},0,813.9,659.438,11394.6,0,0,0,null,11394.6]
["总计",{"$nulls":4},9534.43,9471.75,4454.658,227366.28,64424.99,27800,0,null,319591.27]
["总计",{"$nulls":4},33019.415,27968.086,108302.641,628958.01,2159201.99,102684.4,0,2095000,4985844.4]
["制表人：苏淑钿                       审核人："]
[]
[]
["2019年9月明珠仓成本汇总表"]
["结算单位","货物名称","港口作业费（元）","熏蒸费（元）","运输费（元）","检测费（元）","电费（元）","水费（元）","代理费（元）","本月费用调减（元）","总费用合计","备注"]
["生生运输","小麦",null,null,4016.64,{"$nulls":5},{"$f":"SUM(C69:J69)","v":4016.64}]
["新港","小麦/大麦/大豆",41466,{"$nulls":7},41466]
["粮科杀虫公司","小麦",null,0,{"$nulls":6},0]
["明珠仓美豆","大豆",{"$nulls":4},67830.35,602.64,null,null,68432.99]
["省粮油检测中心","小麦",{"$nulls":8},0]
["其他代缴费用","小麦",{"$nulls":8},0]
["其他",{"$nulls":9},0]
["储备粮成本","小麦",{"$nulls":8},0]
["合计",null,{"$f":"SUM(C69:C76)","v":41466},0,4016.64,0,67830.35,602.64,0,0,113915.63]
["制表人：苏淑钿          审核人：          "]

{"sheet":"表2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"表3","index":3,"n_rows":120,"n_cols":21,"rows_kept":120,"cut":false,"hidden":false,"merged":[[3,7,12,7]]}
[]
[{"$nulls":7},"客户","货名","收入（元）","操作吨（吨）","周转粮概念确认"]
[{"$nulls":7},"市粮","小麦",6751386,44116]
[{"$nulls":7},"货代","矿",668951,53645]
[{"$nulls":8},"棕榈粕",178778,11983]
[{"$nulls":8},"米糠",133930,1052]
[{"$nulls":8},"鱼粉",94322,5773]
[{"$nulls":8},"鸡肉粉",92753,2396]
[{"$nulls":8},"紫花苜蓿草颗粒",79220,1835]
[{"$nulls":8},"大豆",35418,0]
[{"$nulls":8},"木薯淀粉",33199,1752]
[{"$nulls":8},"菜籽粕",26390,1095]
[{"$nulls":8},"其他",68617,653]
[{"$nulls":7},"美豆","大豆",406241,27708]
[{"$nulls":7},"新港","大麦",925157,36695]
[{"$nulls":7},"新港","玉米",245939,15320]
[{"$nulls":7},"华壬","小麦",40473,6879]
[{"$nulls":7},"其他",null,19375,465]
[{"$nulls":7},"合计",null,9800149,211367]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"仓库系统表容积表/肖工要"]
{"$rows_empty":15}
[{"$nulls":8},"货物名称","操作吨（吨）","自然吨（吨）","order_head/wms_work_inout"]
[{"$nulls":8},"鱼粉",106023,60650]
[{"$nulls":8},"胶粒",7437,4460]
[{"$nulls":8},"菜籽粕",6225,3926]
[{"$nulls":8},"鸡肉粉",5096,1451]
[{"$nulls":8},"矿",1785,1668]
[{"$nulls":8},"米糠",981,46]
[{"$nulls":8},"乳清粉",937,604]
[{"$nulls":8},"棉籽粕",467,240]
[{"$nulls":8},"甜菜粕",436,262]
[{"$nulls":8},"木薯淀粉",434]
[{"$nulls":8},"其他",456,372]
[{"$nulls":8},"合计",130277,73679]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"1月","2月","3月","4月","5月","6月","7月","8月","9月"]
[{"$nulls":8},"茅岗",14198,7702,19567,15659,16372,13369,13370,17486,16463]
[{"$nulls":8},"信华",6609,3841,9497,8540,7737,6950,8306,8970,8062]
[{"$nulls":8},"南沙龙穴岛（含双朋仓）",4646,5710,4138,6228,6060,2872,2838,3785,10883]
[{"$nulls":8},"鱼珠",2389,2018,6466,5364,2236,1778,4814,4209,2895]
[{"$nulls":8},"南洲",{"$nulls":5},7444,2353,604,2142]
[{"$nulls":8},"洪梅",{"$nulls":7},8790,14475]
[{"$nulls":8},"合计",27842,19271,39668,35791,32405,32413,31681,43844,54920]
[]
[]
[]
[{"$nulls":7},"除明珠仓之外","order_head/wms_work_inout"]
[]
[]
[]
[]
[{"$nulls":10},"1月","2月","3月","4月","5月","6月","7月","8月","9月"]
[{"$nulls":9},"茅岗",88.55,80.44,87.33,120.53,139.62,141.29,129,131.86,124.26]
[{"$nulls":9},"信华",80.37,73.45,65.41,70.9,89.49,104.77,98.52,91.69,103.44]
[{"$nulls":9},"南沙龙穴岛",135.83,178.51,192.68,149.38,68.76,36.47,83.25,123.63,141.14]
[{"$nulls":9},"鱼珠",35.12,54.19,57.24,91.74,100.71,79.05,81.47,76.98,88.42]
[{"$nulls":9},"南洲",0,0,0,0,0,103.07,114.51,104.55,90.17]
[{"$nulls":9},"洪梅",0,0,0,0,0,0,0,32.78,96.02]
[{"$nulls":9},"双朋仓",0,0,0,0,0,0,0,0,54.11]
[]
[]
[{"$nulls":9},"仓库系统表容积表/肖工要"]
[]
[]
[]
[]
[]
[{"$nulls":11},"自然吨/最大仓容"]
[]
[{"$nulls":12},"1月","2月","3月","4月","5月","6月","7月","8月","9月"]
[{"$nulls":11},"茅岗",0.45,0.24,0.62,0.5,0.52,0.42,0.42,0.53,0.52]
[{"$nulls":11},"信华",0.34,0.2,0.49,0.44,0.4,0.36,0.43,0.47,0.42]
[{"$nulls":11},"南沙",0.58,0.71,0.51,0.78,0.76,0.36,0.35,0.47,0.88]
[{"$nulls":11},"鱼珠",0.3,0.25,0.8,0.67,0.28,0.22,0.24,0.53,0.36]
[{"$nulls":11},"南洲",{"$nulls":5},0.18,0.24,0.06,0.21]
[{"$nulls":11},"洪梅",{"$nulls":7},0.44,0.72]
[{"$nulls":11},"南洲",{"$nulls":8},0.32]
{"$rows_empty":16}
[null,null,"仓库系统表容积表/肖工要"]
[{"$nulls":16},"龙头山库区"]