{"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,"2020.12.24","智慧水务一体化APP1.0需求",null,null,null,"朱当义"]
{"$rows_empty":13}
[null,"版权所有 侵权必究"]

{"sheet":"Product Backlog","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,9],[9,2,10,2]]}
[null,"Product Backlog"]
[null,"终端","模块","故事ID","User Story","Status","规模","Sprint","优先级","备注"]
[null,"移动","登录","U1","登录管理：\nAPP帐号由平台设置，并根据设置的权限登录展示对应的功能。\nAPP登录支持手机短信验证码登录。","Planned",null,"Sprint5.0","高"]
[null,"移动","导航","U2","【导航菜单】模块：\n根据平台配置的菜单权限，显示导航界面的功能菜单：数据总览、综合调度、运维管理\n综合调度下属二级菜单：水务地图、生产调度、管网管理、漏损控制、二次供水、视频监控等板块","Planned",null,"Sprint5.0","高"]
[null,"移动","数据总览","U3","【数据总览】模块：\n1.原水-制水-取水情况：展示从水源地到水龙头的整体供水情况，包括总取水量、总制水信息、管网水情况、总供水量、产销差及计划供水完成情况等信息\n2.运维工单：展示当日运维工单执行情况，未派单、已派单、处理中、已完成、已关闭等各种状态工单的数量\n3.水厂制水：展示各个水厂当日制水量信息\n4.漏损排名：展示漏损率排名前十的分区信息，包括名称、月供水量、月售水量、漏损率等信息\n5.泵站供水排名：展示供水量排名前十的泵站信息\n6.管网水质：展示管网各个水质监测点的供水水质合格率信息，主要展示PH、余氯、浊度的合格率","Planned",null,null,"中"]
[null,"移动","水务地图","U4","【水务地图】模块：\n1. 地图上可显示水源、水厂、加压站、管网、压力、流量、水质、DMA等信息；\n2. 点击对应的设备，可展示设备核心要素信息，并可链接到设备详情界面","Planned",null,null,"中"]
[null,"移动","生产调度","U5","【生产调度】模块：\n1. 水源地列表的查询、水源地的工艺图查看、水源地设备的运行参数查看、报警信息查看；\n2. 水厂列表的查询、水厂的工艺图查看、水厂相关设备的运行参数查看、报警信息查看；","Planned",null,null,"中"]
[null,"移动","管网管理","U6","【管网管理】模块：\n1. 管网资产的查询统计；\n2. 压力，水质、流量等数据的统计分析；","Planned",null,null,"中"]
[null,"移动","二次供水","U7","【二次供水】模块：\n1. 加压站列表的查询、加压站的工艺图查看、加压站相关设备的运行参数查看、报警信息查看。","Planned",null,null,"中"]
[null,"移动","运维管理","U8","我的任务：\n1. 待处理：展示所有待处理的巡检任务和运维工单信息，点击跳转到任务信息处理界面，对任务进行处理\n2. 所有任务：展示所有用户处理过的任务和工单信息，点击可查看任务的详细信息\n3. 工单详情：在地图上展示该任务/工单的具体地点，展示任务的基本信息、派单信息、完成信息等数据\n4. 巡检人员管理：运维人员在工作过程中，会实时上报行动轨迹，方便管理人员进行管理","Planned",null,"Sprint5.0","高"]
[null,"移动",null,"U9","事件上报：\n可选择事件地址、时间、详情等信息进行设备故障、突发事件的信息上报；","Planned",null,"Sprint5.0","高"]
[null,"移动","消息中心","U10","1.报警：根据用户的权限，进行设备报警信息的提示；\n2.运维：用户待处理的巡检任务/运维工单提示\n3.通知：平台通知信息的提示，已读/未读消息的展示","Planned",null,"Sprint5.0","高"]
[null,"移动","个人中心","U11","【个人中心】模块：\n个人信息、头像的查看和修改；","Planned",null,"Sprint5.0","高"]

{"sheet":"sprint5.0需求列表","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,12],[3,2,8,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]
[1,"PC","菜单","菜单","在菜单管理中设置APP的菜单，可对APP的功能菜单进行管控；\n一级菜单：数据总览、综合调度、运维管理\n二级菜单：\n运维管理：我的任务、事件上报","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U1","规划中"]
[2,"移动","APP","登录","APP帐号由平台设置，并根据设置的权限登录展示对应的功能；APP登录支持短信验证码登录。","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U1","规划中"]
[3,"移动",null,"首页","APP首页展示各个模块(数据总览、综合调度、运维管理等)的入口和消息提示信息","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U2","规划中"]
[4,"移动",null,"个人中心","登录的账号的信息，软件版本号，退出登录等","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U11","规划中"]
[5,"移动",null,"消息中心","展示报警、任务、通知等三大类消息","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U10","规划中"]
[6,"移动",null,"我的任务","1. 待处理：展示所有待处理的巡检任务和运维工单信息，点击跳转到任务信息处理界面，对任务进行处理\n2. 所有任务：展示所有我处理过的任务和工单信息，点击可查看任务的详细信息","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U8","规划中"]
[7,"移动",null,"事件上报"," 设备故障、突发事件信息上报；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U9","规划中"]

{"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,"",""]