{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["项目计划","项目管理说明"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":188,"n_cols":12,"rows_kept":188,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[4,2,4,11],[7,2,7,11],[10,2,10,11],[12,2,12,11],[95,2,95,11],[171,2,171,11],[176,2,176,11],[179,2,179,11],[184,2,184,6],[184,8,184,9],[185,2,185,6],[185,8,185,9],[186,2,186,6],[186,8,186,9],[187,2,187,6],[187,8,187,9],[4,0,9,0],[10,0,167,0],[171,0,178,0],[179,0,182,0]]}
["智慧供水一体化平台-综合调度-生产调度、二次供水和视频监控模块项目管理计划表_V1.0"]
["项目进度"]
[]
["阶段","完成","工作任务","难度","工时","开始时间","结束时间","实际结束时间","阶段成果","负责人","参与成员","备注"]
["需求阶段",null,"需求确认&分析"]
[null,1,"需求设计与确认",null,null,"2020-11-02","2020-11-12","2020-11-12","需求规格说明书&产品原型","朱当义"]
[null,1,"项目需求评审会议",null,null,"2020-11-13","2020-11-13","2020-11-13","会议纪要","朱当义"]
[null,null,"UI设计"]
[null,1,"UI设计稿",null,null,"2020-11-14","2020-11-23","2020-11-23","规范&效果图","蒋小英"]
[null,1,"UI设计评审",null,null,"2020-11-24","2020-11-24","2020-11-24",null,"蒋小英"]
["系统实现",null,"详细设计"]
[null,1,"详细设计评审",null,null,"2020-11-30","2020-11-30","2020-12-01","详细设计说明书","王杨杨"]
[null,null,"web前端任务"]
[null,1,"二供监测--在线监测--地图展示--图层管理(展示泵站一级场景)",null,2,"2020.12.1","2020.12.1",null,null,"李易"]
[null,1,"二供监测--在线监测--地图展示--地图展示",null,6,"2020.12.1","2020.12.1",null,null,"李易"]
[null,1,"二供监测--在线监测--地图展示--场景信息监测信息展示",null,4,"2020.12.2","2020.12.2",null,null,"李易"]
[null,1,"二供监测--在线监测--地图展示--泵房供水量展示",null,4,"2020.12.2","2020.12.2",null,null,"李易"]
[null,1,"二供监测--在线监测--列表展示（列表状态信息）",null,4,"2020.12.1","2020.12.1",null,null,"邹文英"]
[null,1,"二供监测--在线监测--列表展示（实时报警分类饼状图）",null,4,"2020.12.1","2020.12.1",null,null,"邹文英"]
[null,1,"二供监测--在线监测--列表展示（报警信息）",null,4,"2020.12.2","2020.12.2",null,null,"邹文英"]
[null,1,"二供监测--工艺图--展示（现场图片）",null,8,"2020.12.3","2020.12.3",null,null,"李易"]
[null,1,"二供监测--工艺图--添加标签",null,4,"2020.12.4","2020.12.4",null,null,"李易"]
[null,1,"二供监测--工艺图--添加标记",null,4,"2020.12.4","2020.12.4",null,null,"李易"]
[null,1,"二供监测--工艺图--标签标记编辑",null,2,"2020.12.7","2020.12.7",null,null,"李易"]
[null,1,"二供监测--工艺图--标签标记保存",null,2,"2020.12.7","2020.12.7",null,null,"李易"]
[null,1,"二供监测--工艺图--标签标记展示",null,4,"2020.12.7","2020.12.7",null,null,"李易"]
[null,1,"二供监测--工艺图--隐藏数据",null,1,"2020.12.8","2020.12.8",null,null,"李易"]
[null,1,"二供监测--工艺图--今日供水量及耗电量展示",null,1,"2020.12.8","2020.12.8",null,null,"李易"]
[null,1,"二供监测--工艺图--二级场景展示（中上）",null,1,"2020.12.8","2020.12.8",null,null,"李易"]
[null,1,"二供监测--工艺图--标签数据展示",null,2,"2020.12.8","2020.12.8",null,null,"李易"]
[null,0.9,"二供监测--统计分析--报表--日报（按场景）",null,8,"2020.12.2","2020.12.3",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--报表--月报（按场景）",null,2,"2020.12.3","2020.12.3",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--报表--年报（按场景）",null,2,"2020.12.3","2020.12.3",null,null,"邹文英"]
[null,0,"二供监测--统计分析--设备分析（泵房运行状态）",null,6,"2020.12.4","2020.12.4",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--设备分析（泵房报警分析）",null,6,"2020.12.7","2020.12.7",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--图表（按场景）",null,6,"2020.12.8","2020.12.8",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--对比（能耗对比）按日月年",null,4,"2020.12.9","2020.12.9",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--对比（水质对比）按日月年",null,4,"2020.12.9","2020.12.9",null,null,"邹文英"]
[null,0.9,"二供监测--统计分析--对比（报警对比）按日月年",null,4,"2020.12.10","2020.12.10",null,null,"邹文英"]
[null,1,"二供监测--工艺图--视频监控",null,2,"2020.12.7","2020.12.7",null,null,"罗加宝"]
[null,1,"水厂监测--在线监测--地图展示--图层管理(展示水厂一级场景)",null,2,"2020.12.9","2020.12.9",null,null,"李易"]
[null,1,"水厂监测--在线监测--地图展示--地图展示",null,2,"2020.12.9","2020.12.9",null,null,"李易"]
[null,1,"水厂监测--在线监测--地图展示--场景信息监测信息展示",null,2,"2020.12.9","2020.12.9",null,null,"李易"]
[null,1,"水厂监测--在线监测--地图展示--水厂供水量展示",null,2,"2020.12.9","2020.12.9",null,null,"李易"]
[null,1,"水厂监测--在线监测--列表展示（列表状态信息）",null,2,"2020.12.10","2020.12.10",null,null,"李易"]
[null,1,"水厂监测--在线监测--列表展示（实时报警分类饼状图）",null,2,"2020.12.10","2020.12.10",null,null,"李易"]
[null,1,"水厂监测--在线监测--列表展示（报警信息）",null,2,"2020.12.10","2020.12.10",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图（现场图）",null,2,"2020.12.8","2020.12.8",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--添加标签",null,2,"2020.12.10","2020.12.10",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--添加标记",null,2,"2020.12.10","2020.12.10",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--标签标记编辑",null,2,"2020.12.11","2020.12.11",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--标签标记保存",null,2,"2020.12.11","2020.12.11",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--标签标记展示",null,2,"2020.12.11","2020.12.11",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--隐藏数据",null,2,"2020.12.11","2020.12.11",null,null,"李易"]
[null,1,"水厂监测--工艺图/鸟瞰图--今日进水量/供水量/耗药量及耗电量展示",null,2,"2020.12.11","2020.12.11",null,null,"李易"]
[null,0.9,"水厂监测--统计分析--报表--日报（按场景）",null,2,"2020.12.10","2020.12.10",null,null,"邹文英"]
[null,0.9,"水厂监测--统计分析--报表--月报（按场景）",null,2,"2020.12.10","2020.12.10",null,null,"邹文英"]
[null,0.9,"水厂监测--统计分析--报表--年报（按场景）",null,2,"2020.12.11","2020.12.11",null,null,"邹文英"]
[null,0.9,"水厂监测--统计分析--图表（按场景）",null,2,"2020.12.11","2020.12.11",null,null,"邹文英"]
[null,0.9,"水厂监测--统计分析--对比（能耗对比）按日月年",null,2,"2020.12.11","2020.12.11",null,null,"邹文英"]
[null,0.9,"水厂监测--统计分析--对比（水质对比）按日月年",null,2,"2020.12.11","2020.12.11",null,null,"邹文英"]
[null,0.9,"水厂监测--统计分析--对比（报警对比）按日月年",null,2,"2020.12.14","2020.12.14",null,null,"邹文英"]
[null,0,"水厂监测--统计分析--设备分析（泵房运行状态）",null,2,"2020.12.14","2020.12.14",null,null,"邹文英",null,"需技术预研，延后处理"]
[null,0.9,"水厂监测--统计分析--设备分析（设备报警分析）",null,2,"2020.12.14","2020.12.14",null,null,"邹文英"]
[null,1,"水厂监测--工艺图--视频监控",null,0,"2020.12.7","2020.12.7",null,null,"罗加宝"]
[null,1,"水源监测--在线监测--地图展示--图层管理(展示水源井一级场景)",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--在线监测--地图展示--地图展示",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--在线监测--地图展示--场景信息监测信息展示",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--在线监测--地图展示--水源井取水量展示",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--在线监测--列表展示（列表状态信息）",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--在线监测--列表展示（实时报警分类饼状图）",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--在线监测--列表展示（报警信息）",null,2,"2020.12.14","2020.12.14",null,null,"李易"]
[null,1,"水源监测--工艺图--添加标签",null,2,"2020.12.15","2020.12.15",null,null,"李易"]
[null,1,"水源监测--工艺图--添加标记",null,2,"2020.12.15","2020.12.15",null,null,"李易"]
[null,1,"水源监测--工艺图--标签标记编辑",null,2,"2020.12.15","2020.12.15",null,null,"李易"]
[null,1,"水源监测--工艺图--标签标记保存",null,2,"2020.12.15","2020.12.15",null,null,"李易"]
[null,1,"水源监测--工艺图--标签标记展示",null,2,"2020.12.15","2020.12.15",null,null,"李易"]
[null,1,"水源监测--工艺图--隐藏数据",null,2,"2020.12.15","2020.12.15",null,null,"李易"]
[null,1,"水源监测--工艺图--今日取水量及耗电量展示",null,2,"2020.12.14","2020.12.14",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--报表--日报（按场景）",null,2,"2020.12.14","2020.12.14",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--报表--月报（按场景）",null,2,"2020.12.14","2020.12.14",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--报表--年报（按场景）",null,2,"2020.12.15","2020.12.15",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--图表（按场景--设备）",null,2,"2020.12.15","2020.12.15",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--对比（能耗对比）按日月年",null,2,"2020.12.15","2020.12.15",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--对比（水质对比）按日月年",null,2,"2020.12.15","2020.12.15",null,null,"邹文英"]
[null,0.9,"水源监测--统计分析--对比（报警对比）按日月年",null,2,"2020.12.15","2020.12.15",null,null,"邹文英"]
[null,1,"水源监测-工艺图--视频监控",null,0,"2020.12.7","2020.12.7",null,null,"罗加宝"]
[null,1,"视频监控--实时视频(截屏、录像、回放)",null,4,"2020.12.7","2020.12.7",null,null,"罗加宝"]
[null,1,"视频监控--摄像头管理添加",null,4,"2020.12.2","2020.12.2",null,null,"罗加宝"]
[null,1,"视频监控--摄像头管理修改",null,4,"2020.12.3","2020.12.3",null,null,"罗加宝"]
[null,1,"视频监控--摄像头管理查询",null,4,"2020.12.3","2020.12.3",null,null,"罗加宝"]
[null,1,"视频监控--摄像头管理删除",null,4,"2020.12.4","2020.12.4",null,null,"罗加宝"]
[null,1,"场景管理-设备列表-参数设置",null,4,"2020.12.4","2020.12.4",null,null,"李易"]
[null,1,"地图保存",null,4,"2020.12.4","2020.12.4",null,null,"李易"]
[null,0]
[null,null,"web后端任务"]
[null,1,"二供监测--在线监测--地图展示--图层管理(展示泵站一级场景)",null,2,"2020.12.1","2020.12.1",null,null,"岳佳瑛"]
[null,1,"二供监测--在线监测--地图展示--场景信息监测信息展示",null,4,"2020.12.1","2020.12.1",null,null,"岳佳瑛"]
[null,1,"二供监测--在线监测--地图展示--泵房供水量展示",null,4,"2020.12.1","2020.12.2",null,null,"岳佳瑛"]
[null,1,"二供监测--在线监测--列表展示（列表状态信息）",null,4,"2020.12.2","2020.12.2",null,null,"岳佳瑛"]
[null,1,"二供监测--在线监测--列表展示（实时报警分类饼状图）",null,2,"2020.12.2","2020.12.3",null,null,"岳佳瑛"]
[null,1,"二供监测--在线监测--列表展示（报警信息）",null,2,"2020.12.3","2020.12.3",null,null,"岳佳瑛"]
[null,1,"二供监测--工艺图--添加标签",null,2,"2020.12.2","2020.12.2",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--添加标记",null,2,"2020.12.2","2020.12.2",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--标签标记编辑",null,2,"2020.12.2","2020.12.2",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--标签标记保存",null,2,"2020.12.2","2020.12.2",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--标签标记查询（按场景及单个）",null,2,"2020.12.3","2020.12.3",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--今日供水量及耗电量展示",null,4,"2020.12.8","2020.12.8",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--二级场景展示（中上）",null,2,"2020.12.9","2020.12.9",null,null,"王杨杨"]
[null,1,"二供监测--工艺图--标签数据查询（包含监测点数据）",null,2,"2020.12.9","2020.12.9",null,null,"王杨杨"]
[null,1,"二供监测--工艺图/视频监控",null,2,"2020.12.2","2020.12.2",null,null,"何玉敏"]
[null,1,"二供监测--统计分析--报表--日报（按场景查询、导出）",null,6,"2020.12.7","2020.12.7",null,null,"王杨杨"]
[null,1,"二供监测--统计分析--报表--月报（按场景查询、导出）",null,6,"2020.12.7","2020.12.7",null,null,"王杨杨"]
[null,1,"二供监测--统计分析--报表--年报（按场景查询、导出）",null,6,"2020.12.7","2020.12.7",null,null,"王杨杨"]
[null,0,"二供监测--统计分析--设备分析（泵房运行状态）",null,8,"2020.12.11","2020.12.11",null,null,"岳佳瑛"]
[null,1,"二供监测--统计分析--设备分析（泵房报警分析）",null,8,"2020.12.14","2020.12.14",null,null,"岳佳瑛"]
[null,1,"二供监测--统计分析--图表（按场景）",null,16,"2020.12.7","2020.12.8",null,null,"王力"]
[null,1,"二供监测--统计分析--对比（能耗对比）按日月年",null,8,"2020.12.11","2020.12.11",null,null,"王力"]
[null,1,"二供监测--统计分析--对比（水质对比）按日月年",null,8,"2020.12.14","2020.12.14",null,null,"王力"]
[null,1,"二供监测--统计分析--对比（报警对比）按日月年",null,8,"2020.12.15","2020.12.15",null,null,"王力"]
[null,1,"水厂监测--在线监测--地图展示--图层管理(展示水厂一级场景)",null,2,"2020.12.3","2020.12.3",null,null,"岳佳瑛"]
[null,1,"水厂监测--在线监测--地图展示--场景信息监测信息展示",null,4,"2020.12.4","2020.12.4",null,null,"岳佳瑛"]
[null,1,"水厂监测--在线监测--地图展示--水厂供水量展示",null,4,"2020.12.7","2020.12.7",null,null,"岳佳瑛"]
[null,1,"水厂监测--在线监测--列表展示（列表状态信息）",null,4,"2020.12.7","2020.12.7",null,null,"岳佳瑛"]
[null,1,"水厂监测--在线监测--列表展示（实时报警分类饼状图）",null,2,"2020.12.8","2020.12.8",null,null,"岳佳瑛"]
[null,1,"水厂监测--在线监测--列表展示（报警信息）",null,2,"2020.12.8","2020.12.8",null,null,"岳佳瑛"]
[null,1,"水厂监测--工艺图/鸟瞰图--添加标签",null,1,"2020.12.3","2020.12.3",null,null,"王杨杨"]
[null,1,"水厂监测--工艺图/鸟瞰图--添加标记",null,1,"2020.12.3","2020.12.3",null,null,"王杨杨"]
[null,1,"水厂监测--工艺图/鸟瞰图--标签标记编辑",null,1,"2020.12.3","2020.12.3",null,null,"王杨杨"]
[null,1,"水厂监测--工艺图/鸟瞰图--标签标记保存",null,1,"2020.12.3","2020.12.3",null,null,"王杨杨"]
[null,1,"水厂监测--工艺图/鸟瞰图--标签标记展示",null,1,"2020.12.3","2020.12.3",null,null,"王杨杨"]
[null,1,"水厂监测--工艺图/鸟瞰图--今日进水量/供水量/耗药量及耗电量展示",null,4,"2020.12.2","2020.12.2",null,null,"王杨杨"]
[null,1,"水厂监测--工艺图/视频监控",null,2,"2020.12.2","2020.12.2",null,null,"何玉敏"]
[null,1,"水厂监测--统计分析--报表--日报（按场景查询、导出）",null,2,"2020.12.7","2020.12.7",null,null,"王杨杨"]
[null,1,"水厂监测--统计分析--报表--月报（按场景查询、导出）",null,2,"2020.12.7","2020.12.7",null,null,"王杨杨"]
[null,1,"水厂监测--统计分析--报表--年报（按场景查询、导出）",null,2,"2020.12.7","2020.12.7",null,null,"王杨杨"]
[null,1,"水厂监测--统计分析--图表（按场景）",null,8,"2020.12.9","2020.12.9",null,null,"王力"]
[null,1,"水厂监测--统计分析--对比（能耗对比）按日月年",null,4,"2020.12.16","2020.12.16",null,null,"王力"]
[null,1,"水厂监测--统计分析--对比（水质对比）按日月年",null,4,"2020.12.16","2020.12.16",null,null,"王力"]
[null,1,"水厂监测--统计分析--对比（报警对比）按日月年",null,4,"2020.12.17","2020.12.17",null,null,"王力"]
[null,0,"水厂监测--统计分析--设备分析（泵房运行状态）",null,4,"2020.12.15","2020.12.15",null,null,"岳佳瑛",null,"需技术预研，延后处理"]
[null,1,"水厂监测--统计分析--设备分析（设备报警分析）",null,4,"2020.12.15","2020.12.15",null,null,"岳佳瑛"]
[null,1,"水源监测--在线监测--地图展示--图层管理(展示水源井一级场景)",null,2,"2020.12.8","2020.12.8",null,null,"岳佳瑛"]
[null,1,"水源监测--在线监测--地图展示--场景信息监测信息展示",null,4,"2020.12.9","2020.12.9",null,null,"岳佳瑛"]
[null,1,"水源监测--在线监测--地图展示--水源井取水量展示",null,4,"2020.12.9","2020.12.9",null,null,"岳佳瑛"]
[null,1,"水源监测--在线监测--列表展示（列表状态信息）",null,4,"2020.12.10","2020.12.10",null,null,"岳佳瑛"]
[null,1,"水源监测--在线监测--列表展示（实时报警分类饼状图）",null,2,"2020.12.10","2020.12.10",null,null,"岳佳瑛"]
[null,1,"水源监测--在线监测--列表展示（报警信息）",null,2,"2020.12.10","2020.12.10",null,null,"岳佳瑛"]
[null,1,"水源监测--工艺图--添加标签",null,1,"2020.12.4","2020.12.4",null,null,"王杨杨"]
[null,1,"水源监测--工艺图--添加标记",null,1,"2020.12.4","2020.12.4",null,null,"王杨杨"]
[null,1,"水源监测--工艺图--标签标记编辑",null,1,"2020.12.4","2020.12.4",null,null,"王杨杨"]
[null,1,"水源监测--工艺图--标签标记保存",null,1,"2020.12.4","2020.12.4",null,null,"王杨杨"]
[null,1,"水源监测--工艺图--标签标记展示",null,1,"2020.12.4","2020.12.4",null,null,"王杨杨"]
[null,1,"水源监测--工艺图/视频监控",null,2,"2020.12.2","2020.12.2",null,null,"何玉敏"]
[null,1,"水源监测--工艺图--今日取水量及耗电量展示",null,4,"2020.12.8","2020.12.8",null,null,"王杨杨"]
[null,1,"水源监测--统计分析--报表--日报（按场景查询、导出）",null,2,"2020.12.9","2020.12.9",null,null,"王杨杨"]
[null,1,"水源监测--统计分析--报表--月报（按场景查询、导出）",null,2,"2020.12.9","2020.12.9",null,null,"王杨杨"]
[null,1,"水源监测--统计分析--报表--年报（按场景查询、导出）",null,2,"2020.12.9","2020.12.9",null,null,"王杨杨"]
[null,1,"水源监测--统计分析--图表（按场景--设备）",null,8,"2020.12.10","2020.12.10",null,null,"王力"]
[null,1,"水源监测--统计分析--对比（能耗对比）按日月年",null,4,"2020.12.17","2020.12.17",null,null,"王力"]
[null,1,"水源监测--统计分析--对比（水质对比）按日月年",null,4,"2020.12.18","2020.12.18",null,null,"王力"]
[null,1,"水源监测--统计分析--对比（报警对比）按日月年",null,4,"2020.12.18","2020.12.18",null,null,"王力"]
[null,1,"设备实时数据保存；",null,8,"2020.12.1","2020.12.1",null,null,"王力"]
[null,1,"设备监测点离线报表生成；",null,24,"2020.12.2","2020.12.4",null,null,"王力"]
[null,1,"视频监控--摄像头管理添加",null,2,"2020.11.30","2020.11.30",null,null,"何玉敏"]
[null,1,"视频监控--摄像头管理修改",null,2,"2020.11.30","2020.11.30",null,null,"何玉敏"]
[null,1,"视频监控--摄像头管理删除",null,2,"2020.11.30","2020.11.30",null,null,"何玉敏"]
[null,1,"视频监控--摄像头管理查询",null,4,"2020.12.3","2020.12.3",null,null,"何玉敏"]
[null,1,"场景管理-设备列表-参数设置",null,4,"2020.12.4","2020.12.4",null,null,"王杨杨"]
[null,1,"地图保存",null,4,"2020.12.4","2020.12.4",null,null,"岳佳瑛"]
[null,null,"模拟数据",null,8,"2020.12.14","2020.12.14",null,null,"王力"]
["系统测试",null,"系统测试"]
[null,1,"测试用例",null,null,"2020.12.1","2020.12.10","2020.12.10","测试用例"]
[null,1,"测试用例评审",null,null,"2020.12.11","2020.12.11","2020.12.11"]
[null,0.6,"平台测试",null,null,"2020.12.18","2020.12.23"]
[null,0,"测试报告",null,null,"2020.12.24","2020.12.24",null,"测试报告"]
[null,null,"系统BUG修改"]
[null,0,"web前端BUG修改",null,null,"xx月xx日","xx月xx日","xx月xx日","源代码"]
[null,0,"web后端BUG修改",null,null,"xx月xx日","xx月xx日","xx月xx日","源代码"]
["系统验收&上线",null,"正式发版"]
[null,0,"项目验收（产品&UI）",null,null,"xx月xx日","xx月xx日","xx月xx日"]
[null,0,"系统环境配置",null,null,"xx月xx日","xx月xx日","xx月xx日"]
[null,0,"服务部署",null,null,"xx月xx日","xx月xx日","xx月xx日","发版说明"]
[]
["风险","风险级别","风险描述",{"$nulls":4},"状态","应对措施",null,"提出时间","责任人"]
[1,"中","研发评估的开发工时超过了整体项目计划制定的时间，可能造成项目延期",{"$nulls":4},"关闭","根据实际研发情况，统计报表模块的部分功能可放到以后的版本完善",null,"2020.12.4","朱当义"]
[2,"高","物联网平台传输设备数据时，一整个水厂的数据当做一个设备进行传输，无法区分每个设备具体在哪个场景使用",{"$nulls":4},"已发生","需要讨论由物联网平台或综合调度这边去对数据进行区分标记，将其切分为不同的设备，对应到不同的场景",null,"2020.12.18","朱当义"]
[3,"中","系统中展示固定字段时，不同公司的设备传输过来的字段名称不同，在使用时无法区分哪个字段是需要展示的字段",{"$nulls":4},"已发生","需要对所有需要展示的字段进行标记",null,"2020.12.18","朱当义"]

{"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、产品经理根据实际情况，采取适当的方式对用户进行产品使用培训。"]
["九、其他项目管理"]
["根据不同项目需要灵活调整管理方式，如远程会议、每日站立会等。"]