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

{"sheet":"Product Backlog","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,2,6,2],[7,2,10,2],[11,2,14,2],[15,2,18,2],[19,2,23,2],[24,2,26,2],[28,2,30,2],[31,2,39,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","【指挥调度】：\n1.3D管网模型，在模型上显示管网实时压力、流量、水质\n2.展示当日供水营收目标及完成情况\n3.展示供水水质信息\n4.展示供水调度任务信息\n5.展示设备资产信息\n6.展示制水、管网、供水信息\n7.展示产销差和漏损率\n\n"]
[null,"PC",null,"U9","【生产报表】模块：\n能一键生成水司的生产周报、月度、年报，支持报表导出","Planned",null,"sprint2.0","中"]
[null,"PC","生产调度","U10","【概览】模块：\n展示水司生产和调度的总体数据信息，展示取水、制水、调度水这些环节的主要数据；\n1.水源：水源列表、取水情况、水质情况、水位情况；\n2.水厂：水厂列表、制水情况、水质情况、设备情况、消耗产出情况","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U11","【水源监测】模块：\n1. 在线监测：在地图上展示水源地位置和报警信息，并支持查看水源地基础信息；\n2. 工艺图：以工艺图的形式展示水源地空间结构和水库水质、水位、设备运行参数等信息，能提示设备报警并进行远程操控；\n3. 视频监控：支持对水源地进行非法人员闯入报警并进行视频监测，保存视频信息；\n4. 统计分析：支持水源数据统计分析的设置；支持对库容、取水量、水质、水位等信息数据进行查询和分析；支持筛选异常报警数据","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U12","【水厂监测】模块：\n1. 在线监测：在地图上展示水厂地理位置和报警信息，并支持查看水厂的基础信息；\n2. 工艺图：以工艺图的形式展示水厂空间结构，并能进一步点击展示泵房、加药间、加氯间、清水池等设施的空间结构，在工艺图上展示压力、水质、流量、设备运行参数等信息，能提示设备报警，对水泵、加药泵、加氯泵、电动阀门等设备进行远程操控；\n3. 视频监控：支持对水厂重点区域进行非法人员闯入报警并进行视频监测，保存视频信息；\n4. 统计分析：支持水厂数据统计分析的设置；支持对制水量、耗药量、耗电量、水质、压力、流量等信息数据进行查询和分析；支持筛选异常报警数据","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U13","【智慧调度】模块：\n1.日常在线调度系统：调度方案比选、在线优化调度、未来24小时预测调度\n2.计划调度系统：节假日调度预案、高峰供水调度预案、 水厂停产减产调度预案、规划调度\n3.应急调度系统爆管事故调度、消防事故调度\n4.历史调度方案查询，评估历史调度方案，辅助当前调度决策\n5.调度考核：对各个水厂的供水调度情况进行考核"]
[null,"PC","管网GIS","U14","【概览】模块：\n展示管网设备资产信息及压力、流量、水质等信息；","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U15","【管网监测】模块：\n1. 在线监测：在地图上展示管网、窨井、消防栓、阀门、水质、压力、流量计等设备的位置和报警信息，并支持查看相关设备的基础信息；\n2. 设备监测：支持查询展示水质、水压、流量设备列表，并进行单点分析；\n3. 统计分析：支持管网数据统计分析的设置；支持对管网压力、流量、水质等信息数据进行查询和分析。","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U16","【GIS分析】模块：\n1.地图查询：支持输入经纬度查询，地址模糊查询\n2. 资产管理：支持查询区域内的设备数量和设备详细信息，对设备资产进行管理；\n3.空间分析：支持管网连通性分析、火灾分析、关阀预案分析、范围拆迁等常用分析功能；","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U17","【水力模型】模块：\n1. 管网在线水力模型：压力、水质、流量模型\n2. 管网异常预警定位\n3. 压力检测点优化布置\n4. 计量分区评估和优化布置\n5. 管网用水调度模拟分析"]
[null,null,"漏损控制","U18","【概览】模块：\n展示漏损分区计量情况、最小流量变化、各DMA分区漏损排行、水量和压力分布情况等信息；"]
[null,null,null,"U19","DMA分区：\n支持根据实际情况，设置一级、二级、三级分区，并通过水力模型优化分区的设置；"]
[null,null,null,"U20","漏损监测：\n实时监测各分区的漏损情况，计算个分区的漏损率、产销差；"]
[null,null,null,"U21","异常预警：\n对异常漏损信息进行报警，并结合水力模型，定位漏损管网位置；"]
[null,null,null,"U22","绩效考核：\n支持检漏任务的设置，并通过实际测漏情况，对检漏任务进行绩效考核，输出检漏报告；"]
[null,"PC","二次供水","U23","【概览】模块：\n展示加压站和二供泵站的供水信息,包括设备在线率、供水量分析、水质分析、能耗分析等；","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U24","【二供监测】模块：\n1. 在线监测：在地图上展示加压站地理位置和报警信息，并支持查看加压站的基础信息；\n2. 工艺图：以工艺图的形式展示加压站空间结构，在工艺图上展示水泵的运行参数信息，能提示设备报警；\n3. 安全监测：支持对加压站进行非法人员闯入报警，烟感报警，并进行视频监测，保存视频信息；\n4. 统计分析：支持加压站数据统计分析的设置；支持对制水量、耗电量、水质等信息数据进行查询和分析，为水司的营业决策提供数据支持；","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U25","【二供调度】模块：\n1. 泵站调度：根据水力模型，计算各个管段的压力、流量，通过控制二供泵站的进出水量和压力，达到平衡管网压力和流量的目的；"]
[null,"PC","视频监控","U26","【视频管理】模块：\n1. 支持查看实时视频数据信息，多视频同时播放；\n2. 支持查看历史视频信息；\n3. 支持视频下载和存储。","Planned",null,"sprint2.0","高"]
[null,"PC","系统管理","U27","【系统设置】模块：\n1. 支持对系统各项运行参数进行配置，如：地图数据刷新频率、地图中心点城市、公司名称、地图设备悬浮信息是否显示等；\n2. 支持对地图GIS进行背景地图、管网地图、连通性分析、爆管分析、范围拆迁、模糊查询等功能接口配置。","Planned",null,"sprint2.0","高"]
[null,"PC",null,"U28","【设备管理】模块：\n1. 设施管理：支持为公司各部门添加各种设施区域（水源、水厂、管网、加压站等），并在区域上配置设备；\n2. 设备管理：各水司根据权限，管理相应的设备；支持水泵、液位、水压、水质、流量、摄像头、门禁、烟感等设备的管理；\n3. 支持对象和设备的工艺图、照片、参数信息的配置。","Planned",null,"sprint2.0","高","在实际使用中，设备需要配置在某个设施中；\n通过监控设施下属的物联网设备的各项参数，来监控设施的运行情况，建立设施的数据模型；"]
[null,null,null,"U29","【报警管理】模块：\n1. 报警设置：支持对不同设备进行不同报警参数设置，支持报警提醒设置；\n2. 报警详情：详细记录设备每次报警的信息","Planned",null,"sprint2.0","高"]
[null,"移动","水务APP","U30","登录管理：\nAPP帐号由平台设置，并根据设置的权限登录展示对应的功能。\nAPP登录支持账号密码登录/短信验证码登录。","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U31","【导航菜单】模块：\n根据平台配置的菜单权限，显示导航界面的功能菜单：综合调度、工单管理、计量集抄\n综合调度下属二级菜单：总览、水务地图、生产调度、管网GIS、漏损控制、二次供水、视频监控等板块","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U32","【总览】模块：\n1. 滚动提示报警信息；(需根据账号权限提示对应的设备报警信息)\n2. 生产、管网、漏控、二供等板块核心数据的可视化展示。(根据账号权限显示相应板块数据)","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U33","【水务地图】模块：\n1. 地图上可勾选显示水源、水厂、加压站、管网（管点、窨井、阀门、消防栓）、DMA等信息；\n2. 点击对应的设备，可展示设备核心要素信息，并可链接到设备详情界面","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U34","【生产调度】模块：\n1. 水源地列表的查询、水源地的工艺图查看、水源地设备的运行参数查看、报警信息查看；\n2. 水厂列表的查询、水厂的工艺图查看、水厂相关设备的运行参数查看、报警信息查看；","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U35","【管网GIS】模块：\n1. 管网资产的查询统计；\n2. 压力，水质、流量等数据的统计分析；","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U36","【二次供水】模块：\n1. 加压站列表的查询、加压站的工艺图查看、加压站相关设备的运行参数查看、报警信息查看。","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U37","【视频监控】模块：\n根据账号权限，可查看相应摄像头的实时视频信息、历史视频信息；","Planned",null,"sprint2.0","中"]
[null,"移动",null,"U38","【个人中心】模块：\n1. 个人信息、头像的查看和修改；\n2. 登录密码的修改；\n3. APP版本的更新；\n4. 版权信息说明。","Planned",null,"sprint2.0","中"]

{"sheet":"sprint2.0需求列表","index":2,"n_rows":33,"n_cols":13,"rows_kept":33,"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,32,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,"一级菜单","管控决策、生产调度、管网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.列表：全选、设备编号、设备名称、设备厂商、设备类型、设备型号、所属公司、所属部门、所属场景、状态、操作；\n3. 点击“参数设置”，弹窗显示参数设置界面；","新增","产品经理","朱当义","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","报警管理-报警详情","实时报警","支持对所属场景/设备名称进行模糊查询，支持对报警类型、处理状态进行筛选，对设备开始报警时间进行筛选；\n1.列表：全选、所属场景、设备名称、设备类型、报警类型、报警参数、当前数值、报警详情、地址、开始时间、操作；\n2. 点击地址，弹窗在地图上显示报警地址；\n3.操作：挂起、恢复\n点击“挂起”，系统不再对该条报警的信息进行提醒；\n点击“恢复”，系统对该条报警的信息进行提醒；\n4.导出：支持报警信息导出","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U21","规划中"]
[31,"PC",null,"历史报警","支持对所属场景/设备名称进行模糊查询，支持对报警类型进行筛选，对设备开始报警时间进行筛选；\n1.列表：全选、所属场景、设备名称、设备类型、报警类型、报警参数、报警规则、最大值、最小值、地址、开始时间、结束时间、持续时间；\n2. 点击地址，弹窗在地图上显示报警地址；\n3.导出：支持报警信息导出","新增","产品经理","朱当义","2020-10-26","中","重要不紧急","U21","规划中"]

{"sheet":"sprint3.0需求列表","index":3,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,2,4,2],[5,2,11,2],[12,2,14,2],[15,2,19,2],[20,2,24,2],[25,2,31,2],[32,2,36,2],[37,2,38,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]
[1,"PC","菜单配置","一级菜单","一级菜单：生产调度、二次供水、视频监控","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U2","规划中"]
[2,"PC",null,"二级菜单","生产调度：概览、水源监测、水厂监测\n二次供水：概览、二供监测\n视频监控：实时视频、历史视频","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U2","规划中"]
[3,"PC",null,"三级菜单","水源监测：在线监测、详情信息、统计分析\n水厂监测：在线监测、详情信息、统计分析\n二供监测：在线监测、详情信息、统计分析","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U2","规划中"]
[4,"PC","生产调度-概览","图形监测","在管网图形上显示各个水源、水厂的位置，并进行报警、地址、供水信息的展示，可通过详情链接，链接到水源、水厂的详细信息监控界面","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[5,"PC",null,"供水信息","可视化图表展示最近30天的供水信息\n展示原水瞬时流量、本日取水量、本月取水量、本年取水量\n展示供水瞬时流量、本日供水量、本月供水量、本年供水量","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[6,"PC",null,"出厂水质情况","可视化展示出厂水质情况\n展示余氯、PH、浊度、COD等参数的合格率指标","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[null,"PC",null,"压力分布","可视化展示各水源、水厂出水压力分布情况；\n展示压力最大值和最小值；","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[7,"PC",null,"实时报警信息","展示各水源、水厂的实时报警数量和分布的可视化图形","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[8,"PC",null,"制水排行","可视化展示今日水厂制水量的排行信息","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[9,"PC",null,"能耗分析","展示水厂制水/电耗/药耗对比变化曲线","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U9","规划中"]
[10,"PC","地图操作","图层操作","对地图进行画点、画线、画区、测距、框选、清除、放大、缩小、显示/隐藏等操作","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U10","规划中"]
[11,"PC",null,"地图保存","为用户保存当前地图中心点和比例尺，下次载入地图时，以保存的数据载入地图","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U10","规划中"]
[12,"PC",null,"点聚合","地图放大缩小时，以省-市-区的层级进行点聚合展示；","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U10","规划中"]
[13,"PC","生产调度-水源监测","在线监测","1. 水源树：展示登录账号权限下所有水源，勾选相应的水源，在地图上展示水源的图标和位置；\n2.在地图上展示各个水源地的位置信息、报警信息、水源地重要参数信息\n3.可视化展示各水源地取水量排行","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U10","规划中"]
[14,"PC",null,"水源列表","1.列表：水源名称、地址、今日取水量、今日耗电量、瞬时流量、PH、浊度、水位、取水水泵状态\n2.操作：详情，点击打开到详情信息页面；\n3.实时报警分类图形：可视化展示各个水源地的报警数量和百分百\n4.实时报警信息：滚动显示各水源地实时报警的详情信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U10","规划中"]
[15,"PC",null,"工艺图","1. 水源树：展示登录账号权限下所有水源，点击水源名称，右侧以工艺图的形式展示水源的详情信息\n2. 工艺图：\na.可依次展示水源及其下属场景的工艺图信息\nb.以可视化图形的方式展示水源当日的取水量、耗电量\nc.可对工艺图进行标签配置，在工艺图上展示水源的各项重要指标信息，并对报警的参数进行提示\nd.可对工艺图进行标记配置，在水源鸟瞰图上跳转到水源子场景的工艺图；\ne.可选择是否在工艺图上展示配置的标签和标记信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U10","规划中"]
[16,null,null,"视频监控","1.可实时查看水源及其下属场景所有的视频信息\n2.可选择同时展示视频的数量（一屏、四屏、九屏）\n3.视频界面显示摄像头的名称、监测时间\n4.支持视频的截图和录像，并下载保存图片或视频信息\n5.支持对摄像头进行远程控制，能移动摄像头的监控视角","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U10"]
[17,"PC",null,"统计分析","1.报表：支持对各个水源的生产情况进行数据统计，支持数据导出\na.水源树：以机构+水源的树形结构展示登录账号权限下所有水源，支持水源多选\nb.日期维度：支持日报、月报、年报的查询\nc.支持查询报表自定义，可配置需要展示的参数，及参数的统计类型（平均值、最大值、最小值、合计值、最新值等）\n2.图表：支持对各项设备参数进行可视化数据展示\na.水源树：以机构+水源的树形结构展示登录账号权限下所有水源，水源只能单选\nb.支持按日、按月、按年查询\n3.对比：支持对比不同水源的生产消耗、水质、报警灯情况信息","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U10","规划中"]
[18,"PC","生产调度-水厂监测","在线监测","1. 水厂树：展示登录账号权限下所有水厂，勾选相应的水厂，在地图上展示水厂的图标和位置；\n2.在地图上展示各个水厂的位置信息、报警信息、水厂重要参数信息\n3.可视化展示各水厂供水量排行\n4.地图保存：各个用户可在地图界面保存当前的地图中心点和比例尺，下次载入地图时，以保存的信息载入地图\n5.点聚合：地图放大缩小时，可进行地图水厂图标的点聚合展示","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U11","规划中"]
[19,"PC",null,"水厂列表","1.列表：水厂名称、地址、进水情况（今日进水量、PH、浊度）、供水情况（今日供水量、压力、PH、浊度、水位、余氯）、出水水泵状态\n2.操作：详情，点击打开水厂详情信息页面；\n3.实时报警分类图形：可视化展示各个水厂的报警数量和百分百\n4.实时报警信息：滚动显示各水厂实时报警的详情信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U11","规划中"]
[20,null,null,"工艺图","1. 水厂树：以机构+水厂的树形结构展示登录账号权限下所有水厂，点击水厂名称，右侧以工艺图的形式展示水厂的详情信息\n2. 工艺图：\na.可依次展示水厂及其下属场景的工艺图信息\nb.以可视化图形的方式展示水厂当日的进水量、供水量、耗电量、药耗量\nc.可对工艺图进行标签配置，在工艺图上展示水厂的各项重要指标信息，并对报警的参数进行提示\nd.可对工艺图进行标记配置，在水厂鸟瞰图上跳转到水厂子场景的工艺图；\ne.可选择是否在工艺图上展示配置的标签和标记信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U11"]
[21,"PC",null,"视频监控","1.可实时查看水厂及其下属场景所有的视频信息\n2.可选择同时展示视频的数量（一屏、四屏、九屏）\n3.视频界面显示摄像头的名称、监测时间\n4.支持视频的截图和录像，并下载保存图片或视频信息\n5.支持对摄像头进行远程控制，能移动摄像头的监控视角","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U11","规划中"]
[22,"PC",null,"统计分析","1.报表：支持对各个水厂的生产情况进行数据统计，支持数据导出\na.水厂树：以机构+水厂的树形结构展示登录账号权限下所有水厂，支持水厂多选\nb.日期维度：支持日报、月报、年报的查询\nc.支持查询报表自定义，可配置需要展示的参数，及参数的统计类型（平均值、最大值、最小值、合计值、最新值等）\n2.图表：支持对各项设备参数进行可视化数据展示\na.水厂树：以机构+水厂的树形结构展示登录账号权限下所有水厂，水厂只能单选\nb.支持按日、按月、按年查询\n3.对比：支持对比不同水厂的生产消耗、水质、报警灯情况信息\n4.设备分析：可视化的方式分析单个水厂的水泵运行状况，设备报警信息","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U11","规划中"]
[23,"PC","二次供水-概览","图形监测","在管网图形上显示各个泵站的位置，并进行报警、地址、供水信息的展示，可通过详情链接，链接到泵站详细信息界面","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[24,"PC",null,"供水信息","可视化图表展示最近30天的供水信息\n展示所有泵站供水瞬时流量、本日供水量、本月供水量、本年供水量","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[25,"PC",null,"水质情况","可视化展示水质情况\n展示余氯、PH、浊度、COD等参数的合格率指标及正常/异常泵站数量","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[null,"PC",null,"压力分布","可视化展示各水源、水厂出水压力分布情况；\n展示压力最大值和最小值；","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[26,"PC",null,"实时报警信息","展示各泵站的实时报警数量和百分百分布的可视化图形","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[27,"PC",null,"制水排行","可视化展示今日泵站供水量的排行信息","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[28,"PC",null,"能耗分析","展示泵站制水/电耗/药耗对比变化曲线","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U15","规划中"]
[29,"PC","二次供水-二供监测","在线监测","1. 泵站树：展示登录账号权限下所有泵站，勾选相应的泵站，在地图上展示泵站的图标和位置；\n2.在地图上展示各个泵站的位置信息、报警信息、泵站重要参数信息\n3.可视化展示各泵站供水量排行\n4.地图保存：各个用户可在地图界面保存当前的地图中心点和比例尺，下次载入地图时，以保存的信息载入地图\n5.点聚合：地图放大缩小时，可进行地图泵站图标的点聚合展示","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U16","规划中"]
[30,"PC",null,"泵站列表","1.列表：泵站名称、地址、进水情况（今日进水量、PH、浊度）、供水情况（今日供水量、压力、PH、浊度、水位、余氯）、出水水泵状态\n2.操作：详情，点击打开泵站详情信息页面；\n3.实时报警分类图形：可视化展示各个泵站的报警数量和百分百\n4.实时报警信息：滚动显示各泵站实时报警的详情信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U16","规划中"]
[31,"PC",null,"工艺图","1. 泵站树：展示登录账号权限下所有泵站，点击泵站名称，右侧以工艺图的形式展示泵站的详情信息\n2. 工艺图：\na.可依次展示泵站及其下属场景的工艺图信息\nb.以可视化图形的方式展示泵站当日的供水量、耗电量\nc.可对工艺图进行标签配置，在工艺图上展示泵站的各项重要指标信息，并对报警的参数进行提示\nd.可对工艺图进行标记配置，在泵站鸟瞰图上跳转到泵站子场景的工艺图；\ne.可选择是否在工艺图上展示配置的标签和标记信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U16","规划中"]
[32,"PC",null,"视频监控","1.可实时查看泵站及其下属场景所有的视频信息\n2.可选择同时展示视频的数量（一屏、四屏、九屏）\n3.视频界面显示摄像头的名称、监测时间\n4.支持视频的截图和录像，并下载保存图片或视频信息\n5.支持对摄像头进行远程控制，能移动摄像头的监控视角","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U16","规划中"]
[33,"PC",null,"统计分析","1.报表：支持对各个泵站的生产情况进行数据统计，支持数据导出\na.泵站树：展示登录账号权限下所有泵站，支持泵站多选\nb.日期维度：支持日报、月报、年报的查询\nc.支持查询报表自定义，可配置需要展示的参数，及参数的统计类型（平均值、最大值、最小值、合计值、最新值等）\n2.图表：支持对各项设备参数进行可视化数据展示\na.泵站树：以机构+泵站的树形结构展示登录账号权限下所有泵站，泵站只能单选\nb.支持按日、按月、按年查询\n3.对比：支持对比不同泵站的生产消耗、水质、报警灯情况信息\n4.设备分析：可视化的方式分析单个泵站的水泵运行状况，设备报警信息","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U16","规划中"]
[34,"PC","视频监控-实时视频","实时视频","1.视频展示窗口选择：可选择一屏、四屏、九屏展示视频数据；\n2.摄像头树：展示登录账号权限下所有摄像头，点击摄像头名称，在右侧的视频展示区域显示视频信息；\n3.视频区域：根据选择的视频展示方式，划分视频小区，每个小区可播放一个视频；\n4.视频控制：在视频区域点击选中视频窗口，在右侧显示该视频的详细信息，并可对该摄像头进行控制；\n5.图片和视频下载：点击截图和录像，可分别截图下载图片或录像下载视频信息；","新增","产品经理","朱当义","2020-11-09","高","重要紧急","U17","规划中"]
[35,"PC",null,"历史视频","1.查询：可根据摄像头名称模糊查询，可根据机构、场景、时间等信息进行数据筛选；\n2.列表：所属公司、所属部门、所属场景、设备名称、设备状态、开始时间、结束时间\n3.操作：播放、下载\n点击“播放”弹窗播放该段视频；\n点击“下载”将该段视频下载到本地；","新增","产品经理","朱当义","2020-11-09","中","重要不紧急","U17","规划中"]

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

{"sheet":"Release Plan","index":5,"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,"",""]