{"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. 报警统计：统计设备报警次数和报警时长信息\n3. 报警明细：详细记录设备每次报警的信息","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":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,"",""]