{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["10 项目计划"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":3,"defined_names":8,"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":"10 项目计划","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[21,1,22,1]]}
["合同签订日期","2019-08-11"]
[]
["任务名称","工期（自然天）","开始时间","完成时间","实际开始时间","实际完成时间","当前计划进度%","当前实际进度%","偏差天数","参与人数","工作量","成果物","资源要求","备注"]
["1.项目定义阶段",23,{"$f":"B1+1","v":"2019-08-12"},{"$f":"C4+B4","v":"2019-09-04"},{"$nulls":6},99,null,"设备环境要求：投影仪\n人员要求：各相关岗位负责人","对用户的需求进行调研及分析，形成需求调研文档，双方签字确认。"]
["   1.1-进行调研准备",1,{"$f":"C4","v":"2019-08-12"},{"$f":"C5+B5-1","v":"2019-08-12"},{"$nulls":5},3,{"$f":"J5*B5","v":3},"《项目总体计划》\n《项目阶段计划》\n《需求调研计划》",null,"安排项目团队，制定项目计划，准备调研资料及调研计划。"]
["   1.2-需求调研现场启动，工具培训",5,{"$f":"D5+1","v":"2019-08-13"},"2019-08-17",{"$nulls":5},2,10,null,null,"项目组抵达用户现场，召开项目启动会，宣讲系统特点，讲解需求调研计划及需求调研培训"]
["   1.3-需求调研及文档整理",14,{"$f":"D6+1","v":"2019-08-18"},"2019-08-31",{"$nulls":5},2,28,null,null,"保证双方对需求理解的一致性；整理调研记录并进行用户确认"]
["   1.4-需求用户讲解及确认",2,"2019-09-01","2019-09-02",{"$nulls":5},2,4,"《需求调研记录》\n《需求跟踪矩阵》\n《业务流程图》\n《需求规格说明书》\n《阶段确认意见书-需求调研阶段》",null,"更新需求调研文档，针对用户进行讲解，沟通确认理解的需求完整性；让用户进行签字确认。 客户需要对需求有详细明确的认识。"]
["   1.5-阶段总结",1,"2019-09-03",{"$f":"C9+B9","v":"2019-09-04"},{"$nulls":5},5,5,"《项目定义阶段总结》",null,"调研完成后，公司相关专家进行需求评审，对调研阶段进行阶段总结。 "]
["2.项目现场实现阶段",45,{"$f":"D4+1","v":"2019-09-05"},"2019-10-20",{"$nulls":6},1073,null,null,"对用户需求进行系统设计，生成设计文档并经评审"]
["   2.1系统分析",5,{"$f":"C10","v":"2019-09-05"},{"$f":"C11+B11-1","v":"2019-09-09"},{"$nulls":6},60,null,null,"项目组内对系统需求进行讲解分析，产品设计及编码人员了解需求情况"]
["      2.1.1-系统需求分析",3,{"$f":"C10","v":"2019-09-05"},"2019-09-07",{"$nulls":5},3,{"$f":"J12*B12","v":9},null,null,"需求调研人员，对系统设计人员及编码人员进行用户需求的讲解，完成需求完整传递； 对系统需求进行产品化差异分析并进行系统分析"]
["   2.2-系统设计",9,{"$f":"D11+1","v":"2019-09-10"},"2019-09-19",{"$nulls":6},115,null,null,"项目设计人员依据需求进行项目设计"]
["      2.2.1-数据仓库设计",3,{"$f":"C13","v":"2019-09-10"},"2019-09-12",{"$nulls":5},2,6,"《系统设计说明书》",null,"对系统进行总体设计，包括数据库设计、功能及界面设计、整理总体设计说明书.\n进行详细设计，包括功能设计、界面设计、数据库设计，整理详细设计说明书。 "]
["      2.2.2-数据集设计",3,{"$f":"D14+1","v":"2019-09-13"},"2019-09-15",{"$nulls":5},5,15,"《评审问题处理记录》",null,"对系统设计文档进行评审，项目经理负责跟踪关闭问题 "]
["      2.2.3-主题看板设计",3,{"$f":"D15+1","v":"2019-09-16"},{"$f":"C16+B16-1","v":"2019-09-18"},{"$nulls":5},5,{"$f":"J16*B16","v":15},"《评审问题处理记录》",null,"对系统设计文档进行评审，项目经理负责跟踪关闭问题 "]
["   2.3-系统编码",25,{"$f":"D13+1","v":"2019-09-20"},{"$f":"C17+B17-1","v":"2019-10-14"},{"$nulls":6},640,null,null,"完成编码及内部测试工作"]
["      2.3.1-数据仓库建设",15,{"$f":"C17","v":"2019-09-20"},{"$f":"C18+B18-1","v":"2019-10-04"},{"$nulls":5},8,{"$f":"J18*B18","v":120},null,null,"进行编码，每天上传CVS，以保证工作成果，防止本地意外造成不必要的损失，"]
["      2.3.2-主题看板开发、关键小组使用",10,{"$f":"D18+1","v":"2019-10-05"},"2019-10-14",{"$nulls":5},5,{"$f":"J19*B19","v":50},"《问题处理记录表》",null,"组内单元测试，保证编码质量"]
["   2.4-系统测试",12,{"$f":"D17+1","v":"2019-10-15"},"2019-10-26",{"$nulls":6},258,null,null,"进行系统测试。 "]
["      2.4.1-数据主题看板确认",4,{"$f":"C20","v":"2019-10-15"},"2019-10-18",{"$nulls":5},5,{"$f":"J21*B21","v":20},null,null,"编写集成测试用例"]
["      2.4.2-关键用户培训",7,"2019-10-19","2019-10-25",{"$nulls":5},5,{"$f":"J22*B22","v":35},"《问题处理记录表》\n《集成测试报告》",null,"按照既定的方案和测试用例执行测试，并记录BUG，以及BUG发现的版本，保证系统完整性"]
["      2.4.3-数据准确性校验",null,{"$f":"D21+1","v":"2019-10-19"},{"$f":"C22+B22-1","v":"2019-10-25"},{"$nulls":5},5,{"$f":"J23*B23","v":0},"《系统操作说明书》",null,"完成系统操作说明书编写"]
["      2.4.4-系统测试总结",1,{"$f":"D23+1","v":"2019-10-26"},{"$f":"C24+B24-1","v":"2019-10-26"},{"$nulls":5},5,{"$f":"J24*B24","v":5},"《项目实现阶段总结》",null,"测试通过，测试负责人组织对测试情况进行总结，质检放行"]
["3.运行及交付",30,{"$f":"D20+1","v":"2019-10-27"},{"$f":"C25+B25-1","v":"2019-11-25"},{"$nulls":6},600,null,"\n设备环境要求：投影仪，服务器、网络环境\n人员要求：各相关岗位负责人","进行项目实施：包括系统安装调试、用户培训、试运行工作"]
["      3.1.1-系统试运行及确认",{"$nulls":8},5,{"$f":"J26*B26","v":0},"《现场实施计划》\n《用户培训计划》\n《系统培训PPT》",null,"根据软件的情况，策划后续实施的任务安排，并得到审批和用户确认；对现场实施条件是否具备进行确认；项目组制定相关实施文档（支持材料、培训文档、代码数据、初始化数据等）；给用户讲解实施的计划安排，培训计划的安排，争取各部门的配合；"]
["      3.1.2-系统正式运行及确认",{"$nulls":8},5,{"$f":"J27*B27","v":0},"《安装调测确认表》",null,"搭建系统环境，安装部署，取得安装调测确认表签字 "]
["      3.1.3-系统正式运行跟踪",{"$nulls":8},5,{"$f":"J28*B28","v":0},"《问题跟踪处理记录》",null,"系统正式运行跟踪，记录系统运行bug，并进行跟踪解决。"]
["      3.1.4-项目验收",{"$nulls":8},3,{"$f":"J29*B29","v":0},"《项目验收报告》",null,"完成系统验收。"]
["5.进入系统维护阶段",{"$nulls":12},"系统验收后，进入到维护阶段。"]