{"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.09.23","智慧水务一体化工单管理平台1.0需求",null,null,null,"朱当义"]
{"$rows_empty":13}
[null,"版权所有 侵权必究"]

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

{"sheet":"sprint5.0需求列表","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,2,8,2],[10,2,14,2],[15,2,16,2],[17,2,19,2],[20,2,21,2],[23,2,28,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]
[1,"PC","运维管理框架菜单","顶部菜单","顶部功能列表：展示导航菜单、用户信息、消息、退出，点击进入功能模块实现各功能模块的页面展示。","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U1","规划中"]
[2,"PC",null,"用户信息","点击用户信息(图标)，跳转到“修改用户”页面，可对用户信息进行修改；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U5","规划中"]
[3,"PC",null,"退出","点击退出按钮，退出到登录页面；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U5","规划中"]
[4,"PC",null,"消息","为系统用户提供消息的提醒和管理功能，能提供设备报警消息、事件上报、巡检任务消息、工单消息等维度的消息推送与管理；\n1. 显示未读消息的数量，滚动进行消息提示，点击消息能跳转到消息列表页面，点击可查询消息具体内容；\n2. 报警消息、事件上报消息，点击跳转到工单管理-事件隐患界面；\n3. 巡检任务消息，点击跳转到巡检管理-任务管理界面；\n4. 工单消息，点击跳转到工单管理-运维工单界面；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U4","规划中"]
[5,"PC",null,"一级菜单","一级菜单：运维概览、巡检管理、工单管理、流程管理","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U2","规划中"]
[6,"PC",null,"二级菜单","巡检管理：巡检计划、我的任务、统计分析\n工单管理：事件隐患、我的工单、统计分析","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U2","规划中"]
[7,"PC",null,"导航菜单","显示已经打开的页面，一个功能菜单(左侧的功能菜单)对应一个导航窗口；可关闭已经打开的导航菜单","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U2","规划中"]
[8,"PC","运维概览","运维地图","1. 在地图上展示运维人员地理位置，鼠标移入人员图标，浮窗展示人员的基本信息；点击人员图标，根据人员正在处理的巡检任务/运维工单，跳转到相关任务/工单的详情界面；\n2. 地图上展示工单事件的位置和处理状态，鼠标移入，浮窗显示事件基础信息\n3.点击未派单状态的工单，弹窗显示派单界面，可进行派单操作；点击其他状态的工单，打开工单详情界面\n4.左侧悬窗显示运维人员和运维工单的列表信息，点击工单列表按钮，可切换到运维工单列表界面；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U6","规划中"]
[9,"PC","巡检管理-巡检计划","查询","支持巡检任务编号模糊查询，支持创建时间筛选；\n根据用户权限，展示所有下级用户创建的巡检计划；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[10,"PC",null,"列表","1.列表：全选、任务编号、任务名称、任务类型、巡检人员、开始时间、结束时间、创建人员、创建时间、巡检区域、状态、操作；\n2.操作：提交、编辑、删除\n点击“提交”按钮，巡检任务按照配置的流程开始执行；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[11,"PC",null,"新增","点击“新增”，跳转到【新增任务】页面；\n1. 任务名称：设置巡检计划的任务名称\n2. 任务类型：巡检任务、测漏任务、养护任务；根据任务类型配置的任务流程进行巡检任务的流转\n3. 巡检人员：选择相关部门的巡检人员\n4. 巡检区域：在地图上设置区域和巡检点\n5. 巡检计划创建时，默认到创建人所属的机构","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[12,"PC",null,"提交审批","启动巡检任务流程，按照流程开始流转任务单","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[13,"PC",null,"删除","点击“删除”，弹窗提示是否删除，点击“是”删除该巡检任务，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[14,"PC","巡检管理-任务管理","所有任务","根据用户权限，展示所有下级用户创建的巡检任务；\n列表：全选、任务编号、任务名称、任务类型、巡检人员、开始时间、结束时间、创建人员、创建时间、巡检区域、状态、操作；\n操作：详情\n点击详情，展示巡检任务的基本信息、处理情况、流程图、任务流转记录；\n不属于用户处理的任务，用户只能查看，不能操作；\n租户管理员需配置终止权限按钮，可终止所有正在执行的任务；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[15,"PC",null,"待处理","展示所有处于用户处理节点的任务；\n列表：全选、任务编号、任务名称、任务类型、巡检人员、开始时间、结束时间、创建人员、创建时间、巡检区域、状态、操作；\n操作：详情\n点击详情，展示巡检任务的基本信息、处理情况、流程图、任务流转记录；\n用户根据处理的节点，配置相关的功能按钮；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U7","规划中"]
[16,"PC","工单管理-隐患事件","查询","支持工单编号模糊查询，支持事件类型、创建时间筛选；\n根据登录用户的权限，展示所有下级用户创建的隐患事件和运维上报的事件，展示权限范围内的设备产生的报警事件；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U8","规划中"]
[17,"PC",null,"列表","1.列表：全选、工单编号、工单描述、事件类型、创建人员、创建时间、地址、状态、操作；\n2.操作：派单\n点击“派单”按钮，选择工单类型、处理时间、紧急程度、运维人员等信息后，派发工单，工单按照配置的流程开始执行；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U8","规划中"]
[18,"PC",null,"新增","点击“新增”，跳转到【新增事件】页面；\n1. 联系人：设置上报事件的用户名称\n2. 联系电话：设置上报事件的用户联系方式\n3. 时间：设置事件上报事件\n4. 地址：设置事件地址\n5. 工单描述：对发送的事件进行描述","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U8","规划中"]
[19,"PC","工单管理-运维工单","所有工单","根据用户数据权限(机构)，展示所有下级用户创建的运维工单和权限范围内的设备产生的报警信息；\n列表：全选、工单编号、工单描述、事件类型、创建人员、创建时间、地址、状态、操作；\n操作：详情\n点击详情，展示运维工单的基本信息、派单信息、处理情况、流程图、任务流转记录；\n不属于用户处理的工单，用户只能查看，不能操作；\n租户管理员需配置终止权限按钮，可终止所有正在执行的工单；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U8","规划中"]
[20,"PC",null,"待处理","展示所有处于用户处理节点的工单；\n列表：全选、工单编号、工单描述、事件类型、创建人员、创建时间、地址、状态、操作；\n操作：详情\n点击详情，展示巡检任务的基本信息、处理情况、流程图、任务流转记录；\n用户根据处理的节点，配置相关的功能按钮；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U8","规划中"]
[21,"PC","流程管理","流程管理","1.可根据每个公司的业务类型，设置各个业务的相关流程\n2.支持流程名称模糊查询\n3.列表：名称、描述、业务类型、任务/工单类型、创建时间、状态、操作\n4.操作：流程设计、部署、编辑、删除\n流程设计：支持设置开始、结束、服务任务、用户任务、分支网关等节点，支持各节点用户设置、表单选择、功能按钮设置；\n","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U10","规划中"]
[22,"移动","APP","登录","APP帐号由平台设置，并根据设置的权限登录展示对应的功能；APP登录支持短信验证码登录。","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U11","规划中"]
[23,"移动",null,"首页","APP首页展示各个模块(数据总览、综合调度、运维管理等)的入口和消息提示信息","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U11","规划中"]
[24,"移动",null,"个人中心","登录的账号的信息，软件版本号，退出登录等","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U11","规划中"]
[25,"移动",null,"消息中心","展示报警、任务、通知等三大类消息","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U11","规划中"]
[26,"移动",null,"我的任务","1. 待处理：展示所有待处理的巡检任务和运维工单信息，点击跳转到任务信息处理界面，对任务进行处理\n2. 所有任务：展示所有我处理过的任务和工单信息，点击可查看任务的详细信息","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U12","规划中"]
[27,"移动",null,"事件上报"," 设备故障、突发事件信息上报；","新增","产品经理","朱当义","2020-12-09","高","重要紧急","U14","规划中"]

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