{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["封面","Product Backlog","sprint5.0需求列表","字段与功能梳理","Release Plan"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":6,"defined_names":120,"comments":2,"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":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,2,15,10],[16,4,16,7],[17,4,17,7],[18,4,18,7],[19,4,19,7],[20,4,20,7],[31,1,31,11],[4,2,11,10]]}
[]
[]
[]
[]
[null,null,"PB"]
{"$rows_empty":10}
[null,null,"文档修订记录"]
[null,null,"版本号","修订日期","修订说明",null,null,null,"修订人","审核人","批准人"]
[null,null,1,"2021.01.06","智慧水务一体化综合展示系统1.0需求",null,null,null,"朱当义"]
{"$rows_empty":13}
[null,"版权所有 侵权必究"]

{"sheet":"Product Backlog","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,9]]}
[null,"Product Backlog"]
[null,"终端","模块","故事ID","User Story","Status","规模","Sprint","优先级","备注"]
[null,"PC","顶部功能栏","U1","系统顶部功能区域，依次展示：时间、名称、返回、退出等信息\n时间：显示当前时间\n名称：根据大屏的内容进行信息展示\n返回：点击返回上一层级，第一层级时隐藏返回按钮\n关闭：点击关闭大屏界面，回到导航菜单界面","Planned",null,"sprint5.0","高"]
[null,"PC","集团综合展示","U2","【综合展示】模块：\n综合展示总览主要搭配大屏显示系统进行建设，需要展示如下版本的内容：\n地图、生产经营情况、水源地取水情况、水厂制水情况、制水售水情况、集团投资情况、能耗分析、营收情况、水质安全、报警情况、运维情况\n","Planned",null,"sprint5.0","高"]
[null,"PC","子公司展示","U3","点击地图上的子公司图标，切换展示子公司的数据信息，展示的内容模块同集团的模块，数据改变为子公司的数据，地图改变为展示子公司的GIS地图，并可以在地图上选择展示水源、水厂、泵站、管网、压力、流量、水质等图层信息","Planned",null,"sprint5.0","高"]
[null,"PC","水源展示","U4","点击水源的工艺图和数据信息；","Planned",null,"sprint5.0","高"]
[null,"PC","水厂展示","U5","点击水厂的工艺图和数据信息；","Planned",null,"sprint5.0","高"]
[null,"PC","泵站展示","U6","点击泵站的工艺图和数据信息；","Planned",null,"sprint5.0","高"]

{"sheet":"sprint5.0需求列表","index":2,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,12],[14,0,25,0],[2,2,13,2],[14,2,25,2],[26,2,30,2],[31,2,35,2],[36,2,40,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]
[1,"PC","综合展示","顶部功能","系统顶部功能区域，依次展示：时间、名称、返回、退出等信息\n时间：显示当前时间\n名称：重庆水投集团智慧供水综合展示\n返回：点击返回上一层级，第一层级时隐藏返回按钮\n关闭：点击关闭大屏界面，回到导航菜单界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U1","规划中"]
[2,"PC",null,"地图","展示重庆市三维地图，可视化展示所有二级子公司的所在位置，并能展示单个子公司的详细经营数据，如取水量、制水量、售水量、产销差、用户数、抄表率、营收金额、实收金额等；","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[3,"PC",null,"生产经营情况","展示集团下属所有的二级子公司总体经营情况，主要展示取水量、制水量、售水量、营收金额、实收金额等指标数据；","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[4,"PC",null,"水源地取水情况","展示集团下属的所有二级子公司管理的水源地近6个月的取水情；","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[5,"PC",null,"水厂制水情况","展示集团下属的所有二级子公司管理的水厂近6个月的制水情况，并展示制水量变化曲线","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[6,"PC",null,"产销差分析","展示集团近半年的制水和售水的关系图，并能查看每个月的制水量、售水量、产销差等数据","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[7,"PC",null,"集团投资情况","展示集团所有的子公司数量、水源数量、水厂数量、管网总长、泵站总数、水表总数","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[8,"PC",null,"能耗分析","统计集团本日制水、耗电信息，并分析吨水耗电情况，展示近半年的制水、电耗对比情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[9,"PC",null,"营收情况","展示集团本月水费总收入和上月水费总收入，展示水费收入的来源（大用户和普通客户）占比，展示各二级子公司本月水费的回收率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[10,"PC",null,"水质安全","展示实时综合水质合格率信息，实时水质报警数量，分别展示原水、水厂出水、管网水、二次供水水质的合格率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[11,"PC",null,"报警情况","展示集团下属二级子公司所有水源、水厂、泵站、管网的实时报警信息","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[12,"PC",null,"运维情况","展示集团巡检、养护、测漏等巡检类任务的执行情况，展示本月运维工单的完结率信息","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U2","规划中"]
[13,"PC","二级公司展示","顶部功能","系统顶部功能区域，依次展示：时间、名称、返回、退出等信息\n时间：显示当前时间\n名称：显示二级子公司的名称\n返回：点击返回上一层级，第一层级时隐藏返回按钮\n关闭：点击关闭大屏界面，回到导航菜单界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U1","规划中"]
[null,"PC",null,"地图","地图改变为展示子公司的GIS地图，并可以在地图上选择展示水源、水厂、泵站、管网、压力、流量、水质等图层信息；\n鼠标移入，展示相应场景/设备的详细信息，点击可切换显示场景的详细界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"生产经营情况","展示二级子公司总体经营情况，主要展示取水量、制水量、售水量、营收金额、实收金额等指标数据；","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"水源地取水情况","展示二级子公司管理的水源地近6个月的取水情；","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"水厂制水情况","展示二级子公司管理的水厂近6个月的制水情况，并展示制水量变化曲线","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"产销差分析","展示子公司近半年的制水和售水的关系图，并能查看每个月的制水量、售水量、产销差等数据","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"集团投资情况","展示二级子公司数量、水源数量、水厂数量、管网总长、泵站总数、水表总数","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"能耗分析","统计二级子公司本日制水、耗电信息，并分析吨水耗电情况，展示近半年的制水、电耗对比情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"营收情况","展示二级子公司本月水费总收入和上月水费总收入，展示水费收入的来源（大用户和普通客户）占比，展示子公司近6个月水费的回收率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"水质安全","展示二级子公司实时综合水质合格率信息，实时水质报警数量，分别展示原水、水厂出水、管网水、二次供水水质的合格率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"报警情况","展示二级子公司所有水源、水厂、泵站、管网的实时报警信息","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[null,"PC",null,"运维情况","展示二级子公司巡检、养护、测漏等巡检类任务的执行情况，展示本月运维工单的完结率信息","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U3","规划中"]
[14,"PC","水源展示","顶部功能","系统顶部功能区域，依次展示：时间、名称、返回、退出等信息\n时间：显示当前时间\n名称：显示选中的水源名称\n返回：点击返回上一层级，第一层级时隐藏返回按钮\n关闭：点击关闭大屏界面，回到导航菜单界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U1","规划中"]
[15,"PC",null,"水源工艺图","加载水源工艺图界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U4","规划中"]
[16,"PC",null,"近30天取水情况","可视化展示水源地近30天的取水量情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U4","规划中"]
[17,"PC",null,"近30天水位变化","可视化展示水源地近30天的水位变化情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U4","规划中"]
[18,"PC",null,"合格率","展示水源地本月原水的浊度、PH、COD、压力等合格率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U4","规划中"]
[19,"PC","水厂展示","顶部功能","系统顶部功能区域，依次展示：时间、名称、返回、退出等信息\n时间：显示当前时间\n名称：显示选择的水厂名称\n返回：点击返回上一层级，第一层级时隐藏返回按钮\n关闭：点击关闭大屏界面，回到导航菜单界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U1","规划中"]
[20,"PC",null,"水厂工艺图","加载水厂工艺图界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U5","规划中"]
[21,"PC",null,"近30天制水情况","可视化展示水厂近30天的制水量情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U5","规划中"]
[22,"PC",null,"能耗分析","可视化展示水厂本月的电耗、制水单位电耗情况\n可视化展示水厂本月药耗情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U5","规划中"]
[23,"PC",null,"合格率","展示水厂本月出厂水的浊度、PH、COD、压力等合格率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U5","规划中"]
[24,"PC","泵站展示","顶部功能","系统顶部功能区域，依次展示：时间、名称、返回、退出等信息\n时间：显示当前时间\n名称：显示选择的泵站的名称\n返回：点击返回上一层级，第一层级时隐藏返回按钮\n关闭：点击关闭大屏界面，回到导航菜单界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U1","规划中"]
[25,"PC",null,"泵站工艺图","加载泵站工艺图界面","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U6","规划中"]
[26,"PC",null,"近30天供水情况","可视化展示泵站近30天的供水量情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U6","规划中"]
[27,"PC",null,"能耗分析","可视化展示泵站本月的电耗、制水单位电耗情况","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U6","规划中"]
[28,"PC",null,"合格率","展示泵站本月供水的浊度、PH、COD、压力等合格率","新增","产品经理","朱当义","2021-01-06","高","重要紧急","U6","规划中"]

{"sheet":"字段与功能梳理","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Release Plan","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[9,1,9,8]]}
[null,"产品增量计划"]
[]
[null,"增量","开始","结束","工期","规模","状态","发布时间","目标"]
[null,1,{"$nulls":4},"Ongoing"]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"注：增量计划用于变现多次Sprint迭代行程的版本计划，小项目不一定需要产品增量计划"]
[]
[null,"Sprint迭代计划"]
[]
[null,"Sprint","开始","结束","工期","规模","状态","发布时间","目标"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7,{"$f":"IF(AND(C20<>\"\",E20<>\"\",E21<>\"\"),C20+E20,\"\")","v":""},{"$f":"IF(AND(C21<>\"\",E21<>\"\"),C21+E21-1,\"\")","v":""}]
[null,8,"",""]
[null,9,"",""]
[null,10,"",""]
[null,11,"",""]
[null,12,"",""]