{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["项目计划","项目管理说明","项目组人员"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"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":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[4,2,4,11],[10,2,10,11],[13,2,13,11],[19,2,19,11],[24,2,24,11],[27,2,27,11],[38,2,38,11],[62,2,62,11],[67,2,67,11],[70,2,70,11],[75,2,75,6],[75,8,75,9],[76,2,76,6],[76,8,76,9],[77,2,77,6],[77,8,77,9],[78,2,78,6],[78,8,78,9],[4,0,12,0],[13,0,23,0],[24,0,61,0],[62,0,69,0],[70,0,73,0]]}
["智慧水务一体化平台框架与用户中心系统1.0项目管理计划表_V1.0"]
["项目进度"]
[]
["阶段","完成","工作任务","难度","工时","开始时间","结束时间","实际结束时间","阶段成果","负责人","参与成员","备注"]
["立项阶段",null,"立项准备"]
[null,1,"行业和业务分析",null,null,"2020-07-06","2020-07-17","2020-07-17","水务行业分析","朱当义"]
[null,1,"框架设计",null,null,"2020-07-20","2020-07-24","2020-07-24","一体化平台框架思维导图","朱当义、潘熙"]
[null,1,"业务流程设计",null,null,"2020-07-20","2020-07-24","2020-07-24","运营管控平台供水业务流程图","朱当义"]
[null,1,"需求调研",null,null,"2020-07-27","2020-07-31","2020-07-30","需求调研报告","朱当义"]
[null,1,"竞品分析",null,null,"2020-07-30","2020-08-07","2020-08-07","竞品分析报告","朱当义"]
[null,null,"立项会议"]
[null,1,"立项报告",null,null,"2020-07-27","2020-08-11","2020-08-11","一体化平台立项报告","朱当义、潘熙"]
[null,1,"立项评审",null,null,"2020-08-17","2020-08-17","2020-08-20","一体化平台立项评审通过","朱当义、潘熙"]
["需求阶段",null,"需求确认&分析"]
[null,1,"业务架构设计与确认",null,null,"2020-09-01","2020-09-14","2020-09-23","一体化平台业务架构思维导图和原型图","朱当义、潘熙"]
[null,1,"需求PB整理",null,null,"2020-09-17","2020-09-24","2020-09-23","需求PB","朱当义"]
[null,1,"需求PB评审会议",null,null,"2020-09-25","2020-09-25","2020-09-24","会议纪要","朱当义"]
[null,1,"需求设计与确认",null,null,"2020-09-27","2020-09-30",null,"需求规格说明书&产品原型","朱当义","项目组成员"]
[null,1,"项目需求评审会议",null,null,"2020-10-09","2020-10-09","2020-10-16","会议纪要","朱当义",null,"重庆出差，参加给水排水大会，延误评审时间"]
[null,null,"UI设计"]
[null,1,"UI设计规范及框架界面",null,null,"2020-10-12","2020-10-16",null,"规范&效果图","任继伟"]
[null,1,"UI设计规范及框架界面评审",null,null,"2020-10-16","2020-10-16","2020-10-16",null,"任继伟","项目组成员"]
[null,1,"系统管理UI设计稿",null,null,"2020-10-19","2020-10-22",null,"效果图","蒋小英"]
[null,1,"系统管理UI设计评审",null,null,"2020-10-23","2020-10-23","2020-10-23",null,"蒋小英","项目组成员"]
["系统实现",null,"详细设计"]
[null,1,"用户中心详细设计",null,null,"2020-10-19","2020-10-22","2020-10-21","概要设计说明书、数据库设计说明书、详细设计说明书","何玉敏"]
[null,1,"详细设计评审",null,null,"2020-10-23","2020-10-23","2020-10-22",null,"何玉敏","项目组成员"]
[null,null,"web前端任务"]
[null,1,"系统导航",null,6,"2020-10-23","2020-10-23","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"用户中心菜单和框架",null,4,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"登录",null,2,"2020-10-23","2020-10-23","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"机构管理",null,8,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"角色管理",null,10,"2020-10-27","2020-10-27","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"菜单管理",null,10,"2020-10-28","2020-10-28","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"字典管理",null,8,"2020-10-29","2020-10-29","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"日志管理",null,6,"2020-10-30","2020-10-30","2020-11-05","联调时间：11月2日","邹文英"]
[null,1,"租户管理",null,6,"2020-10-29","2020-10-29","2020-11-05","联调时间：11月2日","李易"]
[null,1,"用户管理",null,10,"2020-10-30","2020-10-30","2020-11-05","联调时间：11月2日","李易"]
[null,null,"web后端任务"]
[null,1,"用户登录-登录接口",null,8,"2020-10-23","2020-10-23","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户登录-登出接口",null,2,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户登录-验证接口",null,4,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户登录-发送短信验证码接口",null,2,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户组-添加用户组",null,1.5,"2020-10-27","2020-10-27","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户组-修改用户组",null,1.5,"2020-10-27","2020-10-27","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户组-删除用户组",null,1.5,"2020-10-27","2020-10-27","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户组-查询用户组",null,1.5,"2020-10-27","2020-10-27","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"机构管理-添加",null,1.5,"2020-10-27","2020-10-27","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"机构管理-修改",null,1.5,"2020-10-28","2020-10-28","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"机构管理-删除",null,1.5,"2020-10-28","2020-10-28","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"机构管理-查询",null,1.5,"2020-10-28","2020-10-28","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"角色管理-添加角色",null,1.5,"2020-10-28","2020-10-28","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"角色管理-修改角色",null,1.5,"2020-10-28","2020-10-28","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"角色管理-删除角色",null,1.5,"2020-10-29","2020-10-29","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"角色管理-查询角色",null,1.5,"2020-10-29","2020-10-29","2020-11-05","联调时间：11月2日","何玉敏"]
[null,1,"用户管理-CRUD",null,8,"2020-10-23","2020-10-23","2020-11-05","联调时间：11月2日","王杨杨"]
[null,1,"租户管理-CRUD",null,4,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","王力"]
[null,1,"数据字典-CRUD",null,8,"2020-10-26","2020-10-26","2020-11-05","联调时间：11月2日","岳佳英"]
[null,1,"菜单管理-CRUD",null,8,"2020-10-26","2020-10-27","2020-11-05","联调时间：11月2日","王杨杨"]
[null,1,"日志管理-登录日志",null,8,"2020-10-29","2020-10-29","2020-11-05","联调时间：11月2日","王力"]
[null,1,"日志管理-操作日志",null,8,"2020-10-30","2020-10-30","2020-11-05","联调时间：11月2日","王力"]
[null,1,"联调",null,null,"2020-11-02","2020-11-03","2020-11-05"]
["系统测试",null,"系统测试"]
[null,1,"测试用例",null,40,"2020-10-26","2020-10-30","2020-10-30","测试用例","杜会"]
[null,1,"测试用例评审",null,null,"2020-11-02","2020-11-03","2020-11-03"]
[null,1,"平台测试",null,32,"2020-11-04","2020-11-06","2020-11-13",null,"杜会"]
[null,0,"测试报告",null,null,"2020-11-06","2020-11-06","2020-11-13","测试报告"]
[null,null,"系统BUG修改"]
[null,1,"web前端BUG修改",null,null,"2020-11-04","2020-11-06","2020-11-13","源代码"]
[null,1,"web后端BUG修改",null,null,"2020-11-04","2020-11-06","2020-11-13","源代码"]
["系统验收&上线",null,"正式发版"]
[null,0,"项目验收（产品&UI）",null,null,"2020-11-09","2020-11-09",null,"验收报告","朱当义"]
[null,0,"系统环境配置"]
[null,0,"服务部署",{"$nulls":5},"发版说明"]
[]
["风险","风险级别","风险描述",{"$nulls":4},"状态","应对措施",null,"提出时间","责任人"]
[1,"中","邹文英10月30日抽调去处理开鲁的计费系统，影响正常研发进度",{"$nulls":4},"已关闭","10月31日加班完成计划任务",null,"2020-10-30","邹文英"]
[2,"中","李易由于巴里坤项目影响，未按时完成前端工作任务",{"$nulls":4},"已关闭","10月31日加班完成计划任务",null,"2020-10-30","李易"]
[3,"高","前后端联调时间延期1天半完成",{"$nulls":4},"已转为问题，关闭","延期到12号验收",null,"2020-11-03","彭迪"]

{"sheet":"项目管理说明","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,2,5,4]]}
["项目管理要求",null,"项目里程碑交付件要求"]
["一、项目立项",null,"No.","内容"]
["1、 立项准备：产品经理进行市场调查与分析，确认产品的需求，进行产品研发立项，立项需提供市场需求文档（包括《竞品分析报告》《可行性分析》）、《项目立项报告》。",null,1,"项目文档或文件命名规范：项目名称_文件名称_文件版本_日期，如：水务云物联网平台2.0_产品原型_V1.0_20190915"]
["2、 立项会议：会议前，至少提前一天通过邮件方式通知相关人员会议的时间、地点、议程会议内容等细节，并将立项前准备资料邮件邮件附件方式发出。",null,2,"将各项工作及项目文档按照文件夹类别在SVN上进行分类归档。"]
["3、 会后推进：产品立项通过后，研发部门根据项目对资源的需求成立项目开发组，由部门和研发经理共同来确定具体项目配置、知识技能要求、团队成员及团队的角色等。",null,3,"任何工作或项目节点的文档及输出件要以邮件形式发出，发送直接相关人，并抄送上级领导。"]
["二、项目需求管理"]
["1、 搜集：通过PB进行项目需求管理，对各业务方（客户、市场人员等）反馈的需求进行整理，每周反馈部门经理，并入部门整体规划。",null,"No.","项目","输出文档"]
["2、 规划：每周五组织需求评审与沟通会议，由部门经理统筹安排开发资源。",null,1,"市场需求文档MRD","《竞品分析报告》《可行性分析》及相关竞品资料等"]
["3、 重要业务流确认：初期PB到业务流程方案的转化，需要与需求方、项目团队进行沟通评审后，再推进产品设计。",null,2,"项目立项与会议","《项目立项报告》《立项会会议纪要》"]
["三、项目计划管理",null,3,"项目管理","《项目管理计划》"]
["1、 计划制定：项目初期制定《项目管理计划表》的各项项目计划，推进需求、开发及测试的各项工作，以计划表内容进行管理推进。",null,4,"需求反馈与评审","《PB》《PB评审会议纪要》"]
["2、 计划管理：每周五组织项目周例会进行计划进度调整与反馈，根据计划完成情况反馈调整完成进度百分比，项目计划应及时根据项目实际交付要求进行调整与规划。",null,5,"产品设计与评审","《PRD》《产品原型》《需求及原型评审会议纪要》"]
["四、项目过程管理",null,6,"产品开发","《概要设计》《数据库设计》"]
["【禅道】管理：维护项目开发工作任务分配与进度、测试与BUG维护、线上问题与BUG提报等",null,7,"产品测试及评审","《测试用例》《缺陷清单》《测试报告》《用例评审会议纪要》"]
["五、项目评审管理",null,8,"产品验收","《验收报告》"]
["1、 评审发起：项目节点需根据各岗位职责，至少提前半天至1天通过邮件发起并组织评审，通知评审会议时间、地点与内容，并在邮件中添加评审文档附件。",null,9,"产品部署与发布","《部署文档》"]
["2、 评审结果：由会议发起人记录会议纪要（重点事项、变更事项与决议等），会后整理《会议纪要》，通过邮件发给会议参与人，抄送上级，并进行SVN归档。",null,10,"产品培训与推广","《操作手册》《产品介绍》《解决方案》《培训资料》等"]
["3、 评审事项修改：不涉及复杂的方案、功能与流程变更，需在半天内完成交付件修改并及时邮件发出与SVN归档。"]
["六、项目风险管理"]
["1、风险反馈：项目经理或产品经理在每周项目会议或每日站立会上，记录项目小组成员反馈的项目风险，并在项目情况反馈邮件中进行说明，特别是重要时间节点的延期风险需提前反馈。"]
["2、风险处理：项目经理或产品经理需积极协调各方面资源，处理解决风险带来的不利因素，降低风险对项目交付的影响；如无法规避风险，需及时向上级反馈。"]
["七、项目部署与交付"]
["1、部署：产品通过验收后，严格按照《部署文档》进行部署，线上产品务必在客户非集中使用时间发布，通过邮件发布公司内部共享信息，并及时反馈客户发布信息。"]
["2、交付：产品发布后，应同步发布与更新《产品介绍》《操作手册》等内容。"]
["八、用户培训"]
["1、由产品经理准备用户培训计划、培训手册。"]
["2、产品经理根据实际情况，采取适当的方式对用户进行产品使用培训。"]
["九、其他项目管理"]
["根据不同项目需要灵活调整管理方式，如远程会议、每日站立会等。"]

{"sheet":"项目组人员","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,1],[1,0,2,0],[3,0,8,0],[9,0,11,0],[13,0,14,0],[15,0,16,0],[1,2,2,2],[3,2,8,2],[9,2,11,2],[13,2,14,2],[15,2,16,2],[1,3,2,3],[3,3,8,3],[9,3,11,3],[13,3,14,3],[15,3,16,3],[1,4,2,4],[3,4,8,4],[9,4,11,4],[13,4,14,4],[15,4,16,4]]}
["职位","人员","全职数量","兼职数量","备注"]
["产品经理","朱当义",1,1]
[null,"潘熙(兼)"]
["后端","彭迪",5,1,"加2"]
[null,"何玉敏"]
[null,"王杨杨 \t\t\t"]
[null,"王  力\t\t\t"]
[null,"岳佳瑛"]
[null,"\t\t林庆伟(兼)\t"]
["前端","李  易\t\t\t",2,1]
[null,"陈龙(兼)"]
[null,"邹文英\t\t\t"]
["安卓","张  文\t\t\t",1]
["测试","杜  会",1,1,"加1"]
[null,"刘婷(兼)"]
["UI","蒋小英",1,1]
[null,"任继伟（兼）"]
["总计",null,{"$f":"SUM(C2:C17)","v":11},{"$f":"SUM(D2:D17)","v":5},{"$f":"SUM(C18:D18)","v":16}]