{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["封面","Product Backlog","sprint1.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.21","智慧水务一体化平台框架1.0需求",null,null,null,"朱当义"]
[null,null,1.1,"2020.10.17","根据评审结果修改需求列表",null,null,null,"朱当义"]
{"$rows_empty":12}
[null,"版权所有 侵权必究"]

{"sheet":"Product Backlog","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,9],[4,2,16,2]]}
[null,"Product Backlog"]
[null,"终端","模块","故事ID","User Story","Status","规模","Sprint","优先级","备注"]
[null,"PC","登录","U0","一体化平台需要统一登录界面，登录后可根据权限，通过导航界面操作相应的平台系统（包括第三方系统）；\n系统的登录需要做安全识别，需要帐号绑定人员的手机验证码登录；\n一个账号只能在一个浏览器登录，重新登录时，原登录需强制登出；\n支持水司、厂商等用户注册申请；","Planned",null,null,"高"]
[null,"PC","导航界面","U1","导航界面依次展示:用户中心、综合调度、运维管理、营业收费、客户服务、计量集抄、物联网、大数据等系统；\n管理员增加显示系统管理导航菜单","Planned",null,null,"高"]
[null,"PC","用户中心","U2","顶部功能列表：依次展示LOGO、系统名称、用户信息、退出，点击进入功能模块实现各功能模块的页面展示。","Planned",null,null,"高"]
[null,"PC",null,"U3","功能菜单：租户管理、用户管理、机构管理、角色管理、菜单管理、字典管理、短信管理、日志管理、系统设置、注册申请","Planned",null,null,"高"]
[null,"PC",null,"U4","用户设置功能：用户基本信息、头像、密码修改、退出等功能。","Planned",null,null,"高"]
[null,"PC",null,"U5","用户管理：\n支持用户基本信息的管理，所属机构管理，一个用户需要绑定一个手机号码（必须要使用手机+验证码登录平台）；\n上级用户能操作修改下级用户的信息和权限；","Planned",null,null,"高"]
[null,"PC",null,"U6","机构管理:\n机构分为公司和部门两种类型，公司下能添加子公司和部门，部门下只能添加部门；\n上级机构能管理下级机构的数据信息；","Planned",null,null,"高"]
[null,"PC",null,"U7","角色管理：\n支持配置各种管理角色，角色需设置数据权限，可配置菜单功能权限;","Planned",null,null,"高"]
[null,"PC",null,"U8","菜单管理：功能模块化\n能自由配置各个系统拥有哪些功能菜单，\n能配置功能菜单的父级菜单、图片、排序、链接、功能码等信息","Planned",null,null,"高"]
[null,"PC",null,"U9","字典管理：统一管理平台所有数据字典信息，可自由配置数据字段","Planned",null,null,"中"]
[null,"PC",null,"U10","短信管理：管理平台所有发送的短信信息（需要分权限）","Planned",null,null,"低"]
[null,"PC",null,"U11","日志管理：管理平台所有角色操作产生的日志信息（需要分权限）","Planned",null,null,"中"]
[null,"PC",null,"U12","系统设置：\n1.登录设置：设置登录时的手机验证码码获取规则，是否允许一个账号多地登录；","Planned",null,null,"高"]
[null,"PC",null,"U13","注册申请：\n查询用户注册申请信息，支持数据导出；","Planned",null,null,"低"]
[null,"PC",null,"U14","租户管理：\n支持集团设置多租户并进行管控，各个租户能独立管理自己的数据信息，一个租户数据故障不会影响其他租户的数据","Planned",null,null,"高"]
[null,"PC","数据存储","U15","平台能监控各个水司的数据存储量（数据库数据，和上传的文件、图片、视频等数据），达到配额的80%时进行提示预警","Removed"]
[null,"PC","资源占用","U16","平台需要监控每个水司客户使用系统时占用的资源大小（CPU，内存等），以便根据用户占用的资源多少进行区分计费","Removed"]

{"sheet":"sprint1.0需求列表","index":2,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,2,3,2],[4,2,6,2],[7,2,12,2],[13,2,15,2],[16,2,19,2],[20,2,23,2],[24,2,27,2],[28,2,32,2],[33,2,35,2],[36,2,39,2],[40,2,42,2],[43,2,44,2],[46,2,48,2]]}
["需求列表"]
["序号","终端","模块/子模块","功能","需求/问题详细描述","类型","来源","提出人","提出日期","优先级","重要性","关联用户故事ID","处理状态"]
[1,"PC","登录","用户登录","一体化平台需要统一登录界面，登录后可根据权限，通过导航界面操作所有的平台系统（包括第三方系统）；\n1.获取验证码：输入手机号后，手机号逻辑判断，获取验证码，获取验证码规则根据系统设置的规则获取；\n2.登录：手机号码、短信验证码验证通过后允许登录","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U0","规划中"]
[2,"PC",null,"用户注册","支持水司、厂商、运营商等用户注册申请；\n输入姓名、手机号、用户角色等信息提交注册申请；","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U0","规划中"]
[3,"PC","系统导航","架构","导航页面依次展示用户中心、综合调度、运维管理、营业收费、客户服务、计量集抄、物联网、大数据等系统；\n点击相应系统，新打开一个页面，进入该系统；若没有系统功能权限，提示“无系统操作权限”信息","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U1","规划中"]
[4,"PC",null,"系统规则","用户中心常用规则：\n1. 系统报错进行页面提示；\n2. 强制下线机制判断；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U1","规划中"]
[5,"PC",null,"退出","点击退出按钮，退出到登录界面；\n其他地方登录/修改手机号/禁用账号等操作时，强制用户登出到登录页面；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U1","规划中"]
[6,"PC","用户中心菜单","顶部菜单","顶部功能列表：依次展示LOGO、系统名称、用户信息、退出，点击进入功能模块实现各功能模块的页面展示。","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U2","规划中"]
[7,"PC",null,"用户信息","点击用户信息，跳转到“修改用户”页面，可对用户信息进行修改；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U4","规划中"]
[8,"PC",null,"退出","点击退出按钮，退出到登录页面；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U4","规划中"]
[9,"PC",null,"一级菜单","租户管理、用户管理、机构管理、角色管理、菜单管理、字典管理、短信管理、日志管理、系统设置、注册申请","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U3","规划中"]
[10,"PC",null,"二级菜单","用户管理：用户信息、用户组\n日志管理：登录日志、操作日志","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U3","规划中"]
[11,"PC",null,"导航菜单","显示已经打开的页面，一个功能菜单(左侧的功能菜单)对应一个导航窗口；可关闭已经打开的导航菜单，系统默认载入页面无法关闭（全部关闭时，页面跳转到系统默认载入页面）","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U3","规划中"]
[12,"PC","租户管理","查询","支持对租户名称进行模糊查询；","新增","产品经理","朱当义","2020-10-16","高","重要紧急","U14","规划中"]
[13,"PC",null,"列表","1.列表：logo、租户名称、租户管理员、手机号、租户类型\n2.操作：修改、删除\n点击“修改”跳转到【修改租户】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该租户，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-16","高","重要紧急","U14","规划中"]
[14,"PC",null,"新增","点击“新增”，跳转到【新增租户】页面；\n1. 字段：租户名称、租户管理员、手机号、租户类型、logo、域名、租户菜单；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条租户信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-16","高","重要紧急","U14","规划中"]
[15,"PC","用户管理","查询","支持对用户名/手机号进行模糊查询、对所属机构进行筛选查询；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U5","规划中"]
[16,"PC",null,"列表","1.列表：全选、用户名、手机号、公司、部门、状态、操作；\n2.状态：启用、停用两种状态，启用状态可登陆系统，停用状态不可登陆系统；\n3.操作：修改、删除\n点击“修改”跳转到【修改用户】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该用户，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U5","规划中"]
[17,"PC",null,"增加","点击“新增”，跳转到【新增用户】页面；\n1. 字段：所属公司、所属部门、用户名、头像、手机号码、邮箱、状态、用户类型、角色、备注；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条用户信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U5","规划中"]
[18,"PC",null,"删除","在列表中勾选用户后，点击“删除”弹窗提示是否删除，点击“是”删除该用户，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U5","规划中"]
[19,"PC","用户组","查询","支持对用户组名称进行模糊查询；","新增","产品经理","朱当义","2020-10-17","中","重要不紧急","U5","规划中"]
[20,"PC",null,"查询列表","1.列表：全选、用户组名称、用户列表、状态、操作；\n2.状态：启用、停用两种状态，启用状态可登陆系统，停用状态不可登陆系统；\n3.用户列表：点击弹窗显示用户组的用户列表信息，并可操作加入/移出用户；\n3.操作：修改、删除\n点击“修改”跳转到【修改用户组】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该用户组，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-17","中","重要不紧急","U5","规划中"]
[21,"PC",null,"新增","点击“新增”，跳转到【新增用户组】页面；\n1. 字段：用户组名称、状态、角色、备注；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条用户信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-10-17","中","重要不紧急","U5","规划中"]
[22,"PC",null,"删除","在列表中勾选用户组后，点击“删除”弹窗提示是否删除，点击“是”删除该用户，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-10-17","中","重要不紧急","U5","规划中"]
[23,"PC","机构管理","查询","支持对机构名称进行模糊查询；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U6","规划中"]
[24,"PC",null,"机构树","树形结构展示所有机构信息；\n点击机构名称，页面右侧显示“机构详情”页面，可对机构信息进行修改；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U6","规划中"]
[25,"PC",null,"增加","点击“新增”，跳转到【新增机构】页面；\n1. 字段：机构类型、上级机构、所属区域、机构名称、状态、负责人、手机号码、性别、邮箱、备注；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回并刷新页面，机构树上新增一条机构信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U6","规划中"]
[26,"PC",null,"删除","在列表中勾选用户后，点击“删除”弹窗提示是否删除，点击“是”删除该用户，点击\"否\"，关闭提示窗口；\n删除机构需进行逻辑验证：机构自身及下属机构有用户时，无法删除；删除成功时要删除机构自身及下属机构","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U6","规划中"]
[27,"PC","角色管理","查询","支持对角色名称进行模糊查询、对所属机构进行筛选查询；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U7","规划中"]
[28,"PC",null,"列表","1.列表：全选、名称、用户列表、状态、操作；\n2.用户列表：点击用户列表的数字，弹出显示详细用户列表信息；\n3.状态：启用、停用两种状态；\n4.操作：修改、删除、权限设置:\n点击“修改”跳转到【修改角色】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该角色，点击\"否\"，关闭提示窗口；删除角色需判断角色是否绑定用户，已绑定用户的角色无法删除；\n点击“修改”跳转到【权限设置】页面；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U7","规划中"]
[29,"PC",null,"增加","点击“新增”，跳转到【新增角色】页面；\n1. 字段：角色名称、角色描述、状态、数据权限；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回列表并刷新页面，新增一条用户信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U7","规划中"]
[30,"PC",null,"删除","在列表中勾选用户后，点击“删除”弹窗提示是否删除，点击“是”删除该角色，点击\"否\"，关闭提示窗口；删除角色需判断角色是否绑定用户，已绑定用户的角色无法删除；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U7","规划中"]
[31,"PC",null,"权限设置","在列表中勾选用户后，点击“权限设置”跳转到权限设置页面；\n1.功能菜单树展示登录的账号下所有可配置的功能菜单信息，用户可为角色配置自己权限范围内的功能；\n2. 点击“保存”，给角色配置相应勾选的菜单功能，返回列表并刷新页面；\n3. 点击“返回”，返回列表并刷新页面；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U7","规划中"]
[32,"PC","菜单管理","菜单树","树形结构展示所有功能菜单信息；\n点击菜单名称，页面右侧显示“菜单详情”页面，可对菜单信息进行修改；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U8","规划中"]
[33,"PC",null,"增加","点击“新增”，跳转到【新增菜单】页面；\n1. 字段：上级菜单、名称、排序、链接、图标、功能码、状态、备注；带*为必填字段；\n2. 点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后关闭页面，返回并刷新页面，机构树上新增一条菜单信息；\n3. 点击“返回”，关闭该页面返回前页；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U8","规划中"]
[34,"PC",null,"删除","在菜单树种勾选菜单后，点击“删除”，弹窗提示是否删除，点击“是”删除该用户，点击\"否\"，关闭提示窗口；\n删除机构需进行逻辑验证：删除菜单时需要逐级删除，有下级菜单时无法删除成功","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U8","规划中"]
[35,"PC","字典管理","查询","支持对资料代码/资料名称进行模糊查询；","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U9","规划中"]
[36,"PC",null,"列表","1.列表：全选、资料代码、资料名称、备注、操作；\n2.操作：修改、删除\n点击“修改”跳转到【修改字典】页面；\n点击“删除”弹窗提示是否删除，点击“是”删除该字典，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U9","规划中"]
[37,"PC",null,"增加","点击“新增”，跳转到【新增字典】页面；\n1. 基本信息：对字典的基本字段信息管理\n字段：资料代码、资料名称、备注；带*为必填字段；\n点击“保存”，对必填项进行规则校验，错误进行相应提示；校验成功后提示成功，刷新该页面；\n点击“返回”，关闭该页面返回前页；\n2.键值信息：对当前的资料代码进行键值的查询、新增、删除","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U9","规划中"]
[38,"PC",null,"删除","在列表中勾选用户后，点击“删除”弹窗提示是否删除，点击“是”删除该字典，点击\"否\"，关闭提示窗口；","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U9","规划中"]
[39,"PC","短信管理","查询","支持对手机号进行模糊查询，对所属机构、发送状态、发送时间进行筛选查询；","新增","产品经理","朱当义","2020-09-29","低","不重要不紧急","U10","规划中"]
[40,"PC",null,"列表","1.列表：全选、手机号、公司、部门、发送时间、状态、短信内容；\n2.状态：已发送、未发送","新增","产品经理","朱当义","2020-09-29","低","不重要不紧急","U10","规划中"]
[41,"PC",null,"导出","在列表中勾选短信后，点击导出，可导出所有勾选的短信信息；","新增","产品经理","朱当义","2020-09-29","低","不重要不紧急","U10","规划中"]
[42,"PC","日志管理","登录日志","提供登录日志的查询、导出等功能。\n1.查询：支持对用户名/手机号进行模糊查询，对所属机构、登录时间进行筛选查询；\n2.列表：全选、账号、用户名、手机号、所属公司、所属部门、登录类型、时间、IP；\n3.导出：在列表中勾选后，点击导出，可导出所有勾选的日志信息；","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U11","规划中"]
[43,"PC",null,"操作日志","提供操作日志的查询、导出等功能。\n1.查询：支持对用户名/手机号进行模糊查询，对所属机构、操作时间进行筛选查询；\n2.列表：全选、账号、用户名、手机号、所属公司、所属部门、操作菜单、操作资料表、操作类型、时间；\n3.导出：在列表中勾选后，点击导出，可导出所有勾选的日志信息；","新增","产品经理","朱当义","2020-09-29","中","重要不紧急","U11","规划中"]
[44,"PC","系统设置","登录设置","通过系统配置文件配置系统相关规则：\n设置登录时的手机验证码码获取规则，是否允许一个账号多地登录；\n设置超时登出规则；","新增","产品经理","朱当义","2020-09-29","高","重要紧急","U12","规划中"]
[45,"PC","注册申请","查询","支持对姓名/手机号进行模糊查询，对注册时间进行筛选查询；","新增","产品经理","朱当义","2020-09-29","低","不重要不紧急","U13","规划中"]
[46,"PC",null,"列表","列表：全选、姓名、手机号、用户类型、注册时间；","新增","产品经理","朱当义","2020-09-29","低","不重要不紧急","U13","规划中"]
[47,"PC",null,"导出","在列表中勾选后，点击导出，可导出所有勾选的用户注册信息；","新增","产品经理","朱当义","2020-09-29","低","不重要不紧急","U13","规划中"]

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