{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["封面","Product Backlog","sprint3.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.09.23","智慧水务一体化工单管理平台1.0需求",null,null,null,"朱当义"]
{"$rows_empty":13}
[null,"版权所有 侵权必究"]

{"sheet":"Product Backlog","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,2,6,2],[13,2,16,2]]}
[null,"Product Backlog"]
[null,"终端","模块","故事ID","User Story","Status","规模","Sprint","优先级","备注"]
[null,"PC","顶部功能栏","U1","系统功能模块设计区域：依次展示LOGO、系统名称、菜单列表、公司名称、帮助、消息、用户设置，点击进入功能模块实现各功能模块的页面展示。","Planned",null,"sprint3.0","高"]
[null,"PC",null,"U2","功能菜单：地图概览、巡检管理、运维管理、绩效管理、流程管理、系统管理","Planned",null,"sprint3.0","高"]
[null,"PC",null,"U3","帮助功能：\n提供系统使用操作的FAQ内容或操作手册等，支持线上查看或下载；各个系统下载相应的操作手册。","Planned",null,"sprint3.0","低","潘熙协助"]
[null,"PC",null,"U4","消息管理功能：\n为系统用户提供消息的提醒和管理功能，能提供报警消息、巡检任务消息、工单消息等维度的消息推送与管理；\n1. 显示未读消息的数量，滚动进行消息提示，点击消息能跳转到消息列表页面，点击可查询消息具体内容；\n2. 报警消息，点击跳转到设备报警详情页面；（系统自检的设备报警消息，运维人员反馈的事件隐患消息）\n3. 巡检任务消息，点击跳转到巡检任务详情页面；（未派单的任务，已派单有巡检人员反馈结果的巡检任务消息）\n4. 工单消息，点击跳转到工单信息详情页面；（未派单的工单，已派单有运维人员反馈结果的工单消息）","Planned",null,"sprint3.0","中","潘熙协助"]
[null,"PC",null,"U5","用户设置功能：\n用户基本信息、头像、密码修改、退出等功能。","Planned",null,"sprint3.0","高"]
[null,"PC","地图概览","U6","【地图概览】模块：\n1. 在地图上展示运维人员地理位置和基本信息，展示任务和工单的地址和基本信息；\n2. 展示各个状态的任务的统计信息；\n3. 可视化展示不同类型的任务和工单的统计信息；","Planned",null,"sprint3.0","中"]
[null,"PC","巡检管理","U7","【巡检管理】模块：\n1. 支持制定巡检类任务计划，对任务计划进行查询、删除、修改、提交审核等操作；\n2. 支持对巡检类计划进行查询和审批，审批通过后生成巡检任务；\n3. 支持对巡检类任务进行查询和任务派发，并能监控任务的流程进度；\n4. 支持查看巡检人员的运动轨迹；\n5. 支持查询巡检类任务的完成情况和详细信息，支持数据导出。","Planned",null,"sprint3.0","高","任务分类：巡检、养护、测漏"]
[null,"PC","工单管理","U8","【工单管理】模块：\n1. 事件隐患管理：支持各种设备的报警信息提示，支持对APP端上传的隐患事件进行管理，支持手动录入隐患信息；对报警或隐患信息进行派单管理；\n2. 工单管理：支持管理工单的全流程信息；\n3. 运维统计：支持对运维工单的种类、状态、设备故障类型、数量等信息进行分析和统计。","Planned",null,"sprint3.0","高","维修任务分类：停/通水、漏水抢修、表务、违章跑水"]
[null,"PC","绩效管理","U9","【绩效管理】模块：\n1. 支持为每个员工设置月度考核指标；\n2. 支持根据员工工作完成情况对员工进行绩效考核；","Planned",null,"sprint3.0","低"]
[null,"PC","流程管理","U10","【流程管理】模块：\n1. 支持自定义巡检任务和运维工单的类型\n2. 支持巡检任务和运维工单的流程定义和管理\n3. 表单由业务系统定制","Planned",null,"sprint3.0","高"]
[null,"PC","系统管理","U11","【系统设置】模块：\n1. 支持对系统各项运行参数进行配置，如：地图数据刷新频率、地图中心点城市、公司名称、地图设备指标是否显示等；\n2. 支持巡检任务是否审核进行设置。","Planned",null,"sprint3.0","高"]
[null,"移动","水务APP","U13","登录管理：\nAPP帐号由平台设置，并根据设置的权限登录展示对应的功能；APP登录支持账号密码登录/短信验证码登录。\n工单系统配置的账号，登录APP后只能操作工单管理板块的内容，工单管理板块内容包括：巡检任务、运维工单、事件上报","Planned",null,"sprint3.0","高"]
[null,"移动",null,"U14","【巡检任务】模块：\n1.个人的巡检任务的查看、任务完成情况上报；\n2.历史巡检任务查询统计；","Planned",null,"sprint3.0","高"]
[null,"移动",null,"U15","【运维工单】模块：\n1. 运维工单的接单、拒单、分派等操作\n2. 运维工单完成情况的上报；\n3. 历史工单查询统计","Planned",null,"sprint3.0","高"]
[null,"移动",null,"U16","【事件上报】模块：\n 设备故障、突发事件信息上报；历史上报信息处理情况查询；","Planned",null,"sprint3.0","高"]

{"sheet":"sprint3.0需求列表","index":2,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,12],[3,2,5,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]

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