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

{"sheet":"Product Backlog","index":1,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,2,6,2],[7,2,9,2],[10,2,12,2],[13,2,15,2],[16,2,17,2],[19,2,21,2],[22,2,30,2]]}
[null,"Product Backlog"]
[null,"终端","模块","故事ID","User Story","Status","规模","Sprint","优先级","备注"]
[null,"PC","顶部功能栏","U1","系统顶部功能列表：依次展示LOGO、系统名称、公司名称、帮助、消息、用户信息、退出，点击进入功能模块实现各功能模块的页面展示。","Planned",null,"sprint1.0","高"]
[null,"PC",null,"U2","功能菜单：管控决策、生产调度、官网GIS、漏损控制、二次供水、视频监控、系统管理","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U3","帮助功能：\n提供系统使用操作的FAQ内容或操作手册等，支持线上查看或下载；各个系统下载相应的操作手册。","Planned",null,"sprint2.0","低","潘熙协助"]
[null,"PC",null,"U4","消息管理功能：\n为系统用户提供设备报警消息的展示与提醒功能；\n1. 显示未读消息的数量，滚动进行消息提示，点击消息能跳转到消息列表页面，点击可查询消息具体内容；\n2. 设备报警消息，点击跳转到报警详情页面；","Planned",null,"sprint2.0","中","潘熙协助"]
[null,"PC",null,"U5","用户设置功能：\n用户基本信息、头像、退出等功能。","Planned",null,"sprint2.0","高"]
[null,"PC","管控决策","U6","【水务总览】模块：\n通过数据采集分析、建模计算，对水源地到水龙头的全流程数据进行可视化展示，并能通过概览的数据板块链接到系统各个核心功能模块；\n水源：取水量、取水/耗电对比、水质采样合格率\n水厂：制水量、制水/耗电/耗药对比、出厂水质合格率\n管网：管网长度、资产情况、压力合格率\n漏控：漏损率、DMA分区漏损情况\n二供：供水量、在线率、水质情况、供水/耗电对比\n户表：售水量、产销差\n报警：报警事件统计分析","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U7","【水务一张图】模块：\n构建基于水务的管控“一张图”，实现对供水运营的一体化全过程决策分析和实时监管；\n1. 监测：水源、水厂、管网、压力、流量、水质、DMA、二供、视频\n2. 模型：压力、水质、流量","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U8","【生产报表】模块：\n能一键生成水司的生产周报、月度、年报，支持报表导出","Planned",null,"sprint2.0","中"]
[null,"PC","生产调度","U9","【概览】模块：\n展示水司生产和调度的总体数据信息，展示取水、制水、调度水这些环节的主要数据；\n1.水源：水源列表、取水情况、水质情况、水位情况；\n2.水厂：水厂列表、制水情况、水质情况、设备情况、消耗产出情况","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U10","【水源监测】模块：\n1. 在线监测：在地图上展示水源地位置和报警信息，并支持查看水源地基础信息；\n2. 工艺图：以工艺图的形式展示水源地空间结构和水库水质、水位、设备运行参数等信息，能提示设备报警并进行远程操控；\n3. 视频监控：支持对水源地进行非法人员闯入报警并进行视频监测，保存视频信息；\n4. 统计分析：支持水源数据统计分析的设置；支持对库容、取水量、水质、水位等信息数据进行查询和分析；支持筛选异常报警数据","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U11","【水厂监测】模块：\n1. 在线监测：在地图上展示水厂地理位置和报警信息，并支持查看水厂的基础信息；\n2. 工艺图：以工艺图的形式展示水厂空间结构，并能进一步点击展示泵房、加药间、加氯间、清水池等设施的空间结构，在工艺图上展示压力、水质、流量、设备运行参数等信息，能提示设备报警，对水泵、加药泵、加氯泵、电动阀门等设备进行远程操控；\n3. 视频监控：支持对水厂重点区域进行非法人员闯入报警并进行视频监测，保存视频信息；\n4. 统计分析：支持水厂数据统计分析的设置；支持对制水量、耗药量、耗电量、水质、压力、流量等信息数据进行查询和分析；支持筛选异常报警数据","Planned",null,"sprint2.0","高"]
[null,"PC","管网GIS","U12","【概览】模块：\n展示管网设备资产信息及压力、流量、水质等信息；","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U13","【管网监测】模块：\n1. 在线监测：在地图上展示管网、窨井、消防栓、阀门、水质、压力、流量计等设备的位置和报警信息，并支持查看相关设备的基础信息；\n2. 设备监测：支持查询展示水质、水压、流量设备列表，并进行单点分析；\n3. 统计分析：支持管网数据统计分析的设置；支持对管网压力、流量、水质等信息数据进行查询和分析。","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U14","【GIS分析】模块：\n1.地图查询：支持输入经纬度查询，地址模糊查询\n2. 资产管理：支持查询区域内的设备数量和设备详细信息，对设备资产进行管理；\n3.空间分析：支持管网连通性分析、火灾分析、关阀预案分析、范围拆迁等常用分析功能；","Planned",null,"sprint2.0","高"]
[null,"PC","二次供水","U15","【概览】模块：\n展示加压站和二供泵站的供水信息,包括设备在线率、供水量分析、水质分析、能耗分析等；","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U16","【二供监测】模块：\n1. 在线监测：在地图上展示加压站地理位置和报警信息，并支持查看加压站的基础信息；\n2. 工艺图：以工艺图的形式展示加压站空间结构，在工艺图上展示水泵的运行参数信息，能提示设备报警，对水泵进行远程操控；\n3. 安全监测：支持对加压站进行非法人员闯入报警，烟感报警，并进行视频监测，保存视频信息；\n4. 统计分析：支持加压站数据统计分析的设置；支持对制水量、耗电量、水质等信息数据进行查询和分析。","Planned",null,"sprint2.0","高"]
[null,"PC","视频监控","U17","【视频管理】模块：\n1. 支持查看实时视频数据信息，多视频同时播放；\n2. 支持查看历史视频信息；\n3. 支持视频下载和存储。","Planned",null,"sprint2.0","高"]
[null,"PC","系统管理","U19","【系统设置】模块：\n1. 支持对系统各项运行参数进行配置，如：地图数据刷新频率、地图中心点城市、公司名称、地图设备悬浮信息是否显示等；\n2. 支持对地图GIS进行背景地图、管网地图、连通性分析、爆管分析、范围拆迁、模糊查询等功能接口配置。","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U20","【设备管理】模块：\n1. 对象管理：支持为公司各部门添加各种设施区域（水源、水厂、管网、加压站等），并在区域上配置设备；\n2. 设备管理：各水司根据权限，管理相应的设备；支持水泵、液位、水压、水质、流量、摄像头、门禁、烟感等设备的管理；\n3. 支持对象和设备的工艺图、照片、参数信息的配置。","Planned",null,"sprint2.0","高","设备需设置所属公司信息，可根据情况设置所属部门信息；\n在实际使用中，设备需要配置在某个区域中(实体区域或虚拟区域)"]
[null,null,null,"U21","【报警管理】模块：\n1. 报警设置：支持对不同设备进行不同报警参数设置，支持报警提醒设置；\n2. 报警详情：详细记录设备每次报警的信息","Planned",null,"sprint2.0","高"]
[null,"移动","水务APP","U23","登录管理：\nAPP帐号由平台设置，并根据设置的权限登录展示对应的功能。\nAPP登录支持账号密码登录/短信验证码登录。","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U24","【导航菜单】模块：\n根据平台配置的菜单权限，显示导航界面的功能菜单：综合调度、工单管理、计量集抄\n综合调度下属二级菜单：总览、水务地图、生产调度、管网GIS、漏损控制、二次供水、视频监控等板块","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U25","【总览】模块：\n1. 滚动提示报警信息；(需根据账号权限提示对应的设备报警信息)\n2. 生产、管网、漏控、二供等板块核心数据的可视化展示。(根据账号权限显示相应板块数据)","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U26","【水务地图】模块：\n1. 地图上可勾选显示水源、水厂、加压站、管网（管点、窨井、阀门、消防栓）、DMA等信息；\n2. 点击对应的设备，可展示设备核心要素信息，并可链接到设备详情界面","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U27","【生产调度】模块：\n1. 水源地列表的查询、水源地的工艺图查看、水源地设备的运行参数查看、报警信息查看；\n2. 水厂列表的查询、水厂的工艺图查看、水厂相关设备的运行参数查看、报警信息查看；","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U28","【管网GIS】模块：\n1. 管网资产的查询统计；\n2. 压力，水质、流量等数据的统计分析；","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U29","【二次供水】模块：\n1. 加压站列表的查询、加压站的工艺图查看、加压站相关设备的运行参数查看、报警信息查看。","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U30","【视频监控】模块：\n根据账号权限，可查看相应摄像头的实时视频信息、历史视频信息；","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U31","【个人中心】模块：\n1. 个人信息、头像的查看和修改；\n2. 登录密码的修改；\n3. APP版本的更新；\n4. 版权信息说明。","Planned",null,"sprint2.0","中"]

{"sheet":"sprint2.0需求列表","index":2,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,2,8,2],[10,2,13,2],[14,2,17,2],[18,2,21,2],[22,2,26,2],[27,2,30,2],[31,2,33,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]
[1,"PC","综合调度框架菜单","顶部菜单","顶部功能列表：依次展示LOGO、系统名称、公司名称、帮助、消息、用户信息、退出，点击进入功能模块实现各功能模块的页面展示。","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U1","规划中"]
[2,"PC",null,"用户信息","点击用户信息(图标)，跳转到“修改用户”页面，可对用户信息进行修改；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U5","规划中"]
[3,"PC",null,"退出","点击退出按钮，退出到登录页面；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U5","规划中"]
[4,"PC",null,"一级菜单","管控决策、生产调度、管网GIS、二次供水、视频监控、系统管理","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U2","规划中"]
[5,"PC",null,"二级菜单","系统管理：系统设置、设备管理、报警管理","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U2","规划中"]
[6,"PC",null,"三级菜单","设备管理：设备管理、对象管理、对象类型管理\n报警管理：报警管理、报警详情","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U2","规划中"]
[7,"PC",null,"导航菜单","显示已经打开的页面，一个功能菜单(左侧的功能菜单)对应一个导航窗口；可关闭已经打开的导航菜单，系统默认载入页面无法关闭（全部关闭时，页面跳转到系统默认载入页面）","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U2","规划中"]
[8,"PC","系统设置","设置","支持地图刷新频率、总览（概览）页数据刷新频率、地图悬浮参数设置、地图中心区域设置、地图比例尺设置、公司名称设置","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U19","规划中"]
[9,"PC","系统设置-GIS设置","查询","支持对服务类型进行模糊查询；","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U19","规划中"]
[10,"PC",null,"列表","1.列表：全选、服务类型、内网地址、外网地址、操作；\n3.操作：修改、删除\n点击“修改”跳转到【修改服务】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该服务，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U19","规划中"]
[11,"PC",null,"增加","点击“新增”，弹窗显示【新增服务】页面；\n1. 字段：服务类型、内网地址、外网地址；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条服务信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U19","规划中"]
[12,"PC",null,"删除","在列表中勾选服务后，点击“删除”弹窗提示是否删除，点击“是”删除该服务，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U19","规划中"]
[13,"PC","设备管理","查询","支持对设备名称/编号进行模糊查询，对设备类型、所属对象、设备状态进行筛选；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[14,"PC",null,"查询列表","1.列表：全选、设备编号、设备名称、设备类型、设备型号、所属公司、所属部门、所属对象、状态、地址、操作；\n2.状态：正常、故障两种状态；\n3.操作：绑定对象、修改、删除\n点击“绑定对象”弹窗显示绑定对象界面，选择一个对象，将该设备绑定到该对象；对象与设备为1:N的绑定关系；\n点击“编辑”弹窗到【修改设备】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该设备，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[15,"PC",null,"新增","点击“新增”，跳转到【新增设备】界面；\n1. 字段：设备编号、设备名称、设备类型、设备型号、所属机构、地址；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条用户信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[16,"PC",null,"删除","在列表中勾选用户组后，点击“删除”弹窗提示是否删除，点击“是”删除该设备，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[17,"PC","设备管理-对象类型管理","查询","支持对对象类型名称进行模糊查询；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[18,"PC",null,"对象类型树","树形结构展示所有对象类型信息；\n点击对象类型名称，页面右侧显示“对象类型详情”页面，可对对象类型信息进行修改；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[19,"PC",null,"增加","点击“新增”，跳转到【新增对象类型】页面；\n1. 字段：对象类型名称、上级对象类型；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回并刷新页面，机构树上新增一条对象类型信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[20,"PC",null,"删除","在列表中勾选用户后，点击“删除”弹窗提示是否删除，点击“是”删除该对象类型，点击\"否\"，关闭提示窗口；\n删除对象类型需进行逻辑验证：存在该类型的对象时，无法删除","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[21,"PC","设备管理-对象管理","查询","支持对对象名称进行模糊查询；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[22,"PC",null,"对象树","树形结构展示所有对象信息；\n点击对象名称，页面右侧显示“对象详情”页面，可对对象信息进行修改；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[23,"PC",null,"增加","点击“新增”，跳转到【新增对象】页面；\n1. 字段：对象名称、上级机构/对象、对象类型、状态、投运时间、地址、介绍、现场图片、工艺图、APP工艺图、鸟瞰图；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条对象信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[24,"PC",null,"删除","在列表中勾选对象后，点击“删除”弹窗提示是否删除，点击“是”删除该对象，点击\"否\"，关闭提示窗口；\n删除对象需逐层删除，先删除下级对象，才能删除上级对象；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[25,"PC",null,"对象设备列表","显示该对象所绑定的设备列表信息；\n1.查询：支持设备编号/名称模糊查询，对设备状态、设备类型进行筛选；\n2.列表：全选、设备编号、设备名称、设备类型、设备型号、所属公司、所属部门、所属对象、状态、操作；\n2. 操作：解除绑定；将设备从对象中移除；\n3. 点击“绑定设备”，弹窗显示绑定设备界面；\n4. 点击“参数设置”，弹窗显示参数设置界面；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U20","规划中"]
[26,"PC","报警管理","查询","支持对报警参数模糊查询，支持对所属对象进行筛选；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U21","规划中"]
[27,"PC",null,"查询列表","1.列表：全选、所属公司、所属部门、所属对象、设备名称、设备类型、报警类型、报警参数、 报警上限、报警下限、操作；\n2.操作：编辑、删除\n点击“编辑”弹窗到【编辑报警】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该报警参数，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U21","规划中"]
[28,"PC",null,"增加","点击“新增”，跳转到【新增报警】页面；\n1. 所属对象：先选择需要配置报警参数的对象\n2. 根据对象显示该对象下所属的设备信息\n3. 参数报警设置：显示该设备下配置的可选参数信息，设置报警上限和下限\n4. 状态报警设置：设置该设备离线报警时间和启用状态；\n5. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，关闭页面，刷新报警配置列表，新增N条报警配置信息；\n6. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U21","规划中"]
[29,"PC",null,"删除","点击“删除”，弹窗提示是否删除，点击“是”删除该报警配置，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-26","高","重要紧急","U21","规划中"]
[30,"PC","报警管理-报警详情","查询","支持对所属对象/设备名称进行模糊查询，支持对报警类型、处理状态进行筛选，对设备开始报警时间进行筛选；","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U21","规划中"]
[31,"PC",null,"列表","1.列表：全选、所属对象、设备名称、设备类型、报警类型、报警详情、地址、开始时间、结束时间、操作；\n2. 点击地址，弹窗在地图上显示报警地址；\n3.操作：挂起、恢复\n点击“挂起”，系统不再对该条报警的信息进行提醒；\n点击“恢复”，系统对该条报警的信息进行提醒；","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U21","规划中"]
[32,"PC",null,"导出","根据选择的信息，导出报警详情列表","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U21","规划中"]

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