{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["项目整体WBS","开发需求说明"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"项目整体WBS","index":0,"n_rows":89,"n_cols":16,"rows_kept":89,"merged":[[7,7,25,7]],"flags":["formulas_cached_only"]}
["WBS","KEY","工作任务（Work Packages）","人天（Man/Day）","投入资源名称","计划开始时间\n（Start Date）","计划完成时间\n（Finish Date）","交付文档（Deliverable）","阶段",{"$nulls":5},86,86]
[1,null,"项目启动",2,null,"2023-06-28","2023-06-30",null,"启动"]
[1.1,null,"制定整体实施计划",0.5,"项目经理","2023-06-28","2023-06-28","《项目实施计划》","启动"]
[1.3,null,"制定项目启动大会议程和PPT",0.5,"项目经理","2023-06-28","2023-06-28","《项目启动会议程》\n《项目启动大会PPT》","启动"]
[1.2,null,"成立项目组织团队",0.5,"项目经理","2023-06-29","2023-06-29","《项目组织设置建议》\n《项目组成员通讯录》","启动"]
[1.4," ★","召开项目启动大会",0.5,"项目经理","2023-06-29","2023-06-29",null,"启动"]
[2,null,"需求调研",21,{"$nulls":4},"需求"]
["2.1",null,"基础数据收集模板准备",0.5,"实施顾问","2023-06-30","2023-06-30","《调研计划》\n《业务调研表》\n《开发功能清单》\n","需求"]
["2.2",null,"调研问卷准备、下发业务单位",0.5,"实施顾问","2023-06-30","2023-06-30",null,"需求"]
["2.3",null,"调研问卷收集",0.5,"实施顾问","2023-07-03","2023-07-03",null,"需求"]
["2.4",null,"组织管理调研问卷分析",0.5,"实施顾问","2023-07-04","2023-07-04",null,"需求"]
["2.5",null,"员工管理调研问卷分析",0.5,"实施顾问","2023-07-04","2023-07-04",null,"需求"]
["2.6",null,"假勤管理调研问卷分析",0.5,"实施顾问","2023-07-05","2023-07-05",null,"需求"]
["2.7",null,"绩效管理调研问卷分析",0.5,"实施顾问","2023-07-06","2023-07-06"]
["2.8",null,"薪酬管理调研问卷分析",0.5,"实施顾问","2023-07-07","2023-07-07",null,"需求"]
["2.9",null,"组织管理需求调研",0.5,"项目经理","2023-07-08","2023-07-08",null,"需求"]
["2.10",null,"员工管理需求调研",0.5,"项目经理","2023-07-09","2023-07-09",null,"需求"]
["2.11",null,"绩效管理需求调研",0.5,"项目经理","2023-07-10","2023-07-10"]
["2.10",null,"假勤管理需求调研",0.5,"项目经理","2023-07-11","2023-07-11",null,"需求"]
["2.11",null,"薪酬管理需求调研",0.5,"项目经理","2023-07-12","2023-07-12",null,"需求"]
["2.12",null,"需求调研纪要整理",2,"实施顾问","2023-07-13","2023-07-13",null,"需求"]
["2.13",null,"组织管理数据整理和流程优化",2,"实施顾问","2023-07-14","2023-07-14",null,"需求"]
["2.14",null,"员工管理数据整理和流程优化",2,"实施顾问","2023-07-15","2023-07-15",null,"需求"]
["2.15",null,"假勤管理规则梳理和流程优化",2,"实施顾问","2023-07-16","2023-07-16",null,"需求"]
["2.16",null,"绩效管理规则梳理和流程优化",2,"实施顾问","2023-07-17","2023-07-17"]
["2.17",null,"薪酬管理规则梳理和流程优化",2,"实施顾问","2023-07-18","2023-07-18",null,"需求"]
["2.18",null,"集成对接调研",2,"开发顾问","2023-07-19","2023-07-19","《需求调研报告》","需求"]
["2.19",null,"调研纪要确认",0.5,"项目经理","2023-07-20","2023-07-20","《业务调研报告》","需求"]
["2.20",null,"第三方系统集成",8,"开发顾问","不知道是否加在这里","请彭老师指正"]
[3,null,"蓝图设计",16.5,null,"2023-07-21","2023-07-21",null,"方案"]
["3.1",null,"蓝图设计编写（组织管理）",1,"项目经理","2023-07-22","2023-07-22",null,"方案"]
["3.2",null,"蓝图设计编写（员工管理）",1,"项目经理","2023-07-23","2023-07-23",null,"方案"]
["3.3",null,"蓝图设计编写（假勤管理）",1,"项目经理","2023-07-24","2023-07-24",null,"方案"]
["3.4",null,"蓝图设计编写（薪酬管理）",1,"项目经理","2023-07-25","2023-07-25",null,"方案"]
["3.5",null,"蓝图设计编写（绩效管理）",1,"项目经理","2023-07-26","2023-07-26"]
["3.6",null,"蓝图设计编写（集成对接）",1,"项目经理","2023-07-27","2023-07-27",null,"方案"]
["3.7",null,"定制化开发需求说明书",3,"开发顾问","2023-07-28","2023-07-28","《定制功能需求说明书》","方案"]
["3.8",null,"系统演示",1,"实施顾问","2023-07-29","2023-07-29",null,"方案"]
["3.9",null,"蓝图沟通确认方案",2,"项目经理","2023-07-30","2023-07-30",null,"方案"]
["3.10",null,"蓝图调整、反馈",4,"项目经理","2023-07-31","2023-07-31","《业务蓝图》","方案"]
["3.11","  ★","蓝图方案汇报及签订",0.5,"项目经理","2023-08-01","2023-08-01","《业务蓝图汇报PPT》\n《业务蓝图确认单》","方案"]
[4,null,"构建",17,null,"2023-08-02","2023-08-02",null,"构建"]
["4.1",null,"组织人事数据导入",1,"实施顾问","2023-08-03","2023-08-03",null,"构建"]
["4.2",null,"组织人事视图及操作用例验证",1,"实施顾问","2023-08-04","2023-08-04",null,"构建"]
["4.3",null,"假期业务设置及验证",1,"实施顾问","2023-08-05","2023-08-05",null,"构建"]
["4.4",null,"考勤业务设置及验证",1,"实施顾问","2023-08-06","2023-08-06",null,"构建"]
["4.5",null,"假期考勤工作流配置验证",1,"实施顾问","2023-08-07","2023-08-07",null,"构建"]
["4.6",null,"绩效业务数据准备与导入",1,"实施顾问","2023-08-08","2023-08-08"]
["4.7",null,"绩效业务设置及验证",1,"实施顾问","2023-08-09","2023-08-09"]
["4.8",null,"薪酬业务数据准备与导入",2,"实施顾问","2023-08-10","2023-08-10",null,"构建"]
["4.9",null,"薪酬业务配置及验证",2,"实施顾问","2023-08-11","2023-08-11",null,"构建"]
["4.10",null,"薪酬核算方案与考勤绩效联测验证",2,"实施顾问","2023-08-12","2023-08-12",null,"构建"]
["4.11",null,"薪酬工作流配置验证",2,"实施顾问","2023-08-13","2023-08-13",null,"构建"]
["4.12",null,"薪酬报表设计和查询方案配置验证",2,"实施顾问","2023-08-14","2023-08-14",null,"构建"]
[5,null,"测试",21,null,"2023-08-15","2023-08-15",null,"测试"]
["5.1",null,"组织管理培训",1,"实施顾问","2023-08-16","2023-08-16",null,"测试"]
["5.2",null,"员工管理培训",1,"实施顾问","2023-08-17","2023-08-17",null,"测试"]
["5.3",null,"假勤管理培训",1,"实施顾问","2023-08-18","2023-08-18",null,"测试"]
["5.4",null,"绩效管理培训",1,"实施顾问","2023-08-19","2023-08-19"]
["5.5",null,"薪酬核算培训",1,"实施顾问","2023-08-20","2023-08-20",null,"测试"]
["5.6",null,"培训考核（关键用户）",1,"实施顾问","2023-08-21","2023-08-21",null,"测试"]
["5.7",null,"搭建UAT环境",1,"实施顾问","2023-08-22","2023-08-22",null,"测试"]
["5.8",null,"UAT测试计划",1,"实施顾问","2023-08-23","2023-08-23",null,"测试"]
["5.9",null,"测试用例编写",2,"实施顾问","2023-08-24","2023-08-24","《测试用例清单》","测试"]
["5.10",null,"系统模拟测试",7,"实施顾问","2023-08-25","2023-08-25","《测试报告》","测试"]
["5.11",null,"辅导关键用户/编写操作手册",4,"实施顾问","2023-08-26","2023-08-26","《系统操作手册》","测试"]
[6,null,"上线",21,null,"2023-08-27","2023-09-11",null,"上线"]
["6.1",null,"制定上线方案、上线计划",2,"项目经理","2023-08-28","2023-08-28",null,"上线"]
["6.2",null,"上线数据准备",1,"项目经理","2023-08-29","2023-08-29","《上线检查表》","上线"]
["6.3",null,"上线环境准备",1,"项目经理","2023-08-30","2023-08-30",null,"上线"]
["6.4",null,"组织管理数据初始化",1,"实施顾问","2023-08-31","2023-08-31",null,"上线"]
["6.5",null,"员工管理数据初始化",1,"实施顾问","2023-09-01","2023-09-01",null,"上线"]
["6.6",null,"绩效管理数据初始化",1,"实施顾问","2023-09-02","2023-09-02"]
["6.6",null,"假勤管理数据初始化",1,"实施顾问","2023-09-03","2023-09-03",null,"上线"]
["6.7",null,"薪酬核算数据初始化",1,"实施顾问","2023-09-04","2023-09-04",null,"上线"]
["6.8",null,"业务流程迁移",2,"实施顾问","2023-09-05","2023-09-05",null,"上线"]
["6.9",null,"用户权限分配",1,"实施顾问","2023-09-06","2023-09-06",null,"上线"]
["6.10",null,"定制化功能布署",2.5,"实施顾问","2023-09-07","2023-09-07",null,"上线"]
["6.11",null,"系统全局参数设置",1.5,"实施顾问","2023-09-08","2023-09-08",null,"上线"]
["6.12",null,"各项数据再次检查",2,"实施顾问","2023-09-09","2023-09-09",null,"上线"]
["6.13",null,"业务系统上线辅导",2,"实施顾问","2023-09-10","2023-09-10",null,"上线"]
["6.13","★","系统上线确认",1,"项目经理","2023-09-11","2023-09-11","《上线确认单》","上线"]
[7,null,"验收",23,null,"2023-09-11","2023-09-11",null,"验收"]
["7.1",null,"系统日常维护",8,"项目经理","2023-09-12","2023-09-12",null,"验收"]
["7.2",null,"系统问题跟踪处理",7,"实施顾问","2023-09-13","2023-09-13","《s-HR验收问题清单》","验收"]
["7.3",null,"系统使用情况统计",4,"实施顾问","2023-09-14","2023-09-14",null,"验收"]
["7.4",null,"项目验收汇报会（含文档整理）",2,"项目经理","2023-09-15","2023-09-15",null,"验收"]
["7.6","  ★","签订项目验收单、实施交接转服务",2,"项目经理","2023-09-16","2023-09-16",null,"验收"]
[{"$nulls":5},"2023-09-17","2023-09-17"]

{"sheet":"开发需求说明","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[2,1,4,1],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,1,38,1],[5,3,5,4],[6,2,7,2],[6,3,7,3],[8,2,13,2],[11,3,13,3],[14,2,20,2],[14,3,16,3],[21,2,32,2],[21,3,28,3],[29,3,32,3],[33,2,38,2],[35,3,38,3]],"flags":["formulas_cached_only"]}
["编号","阶段","功能模块","子功能模块","概要任务清单","备注"]
[]
[1,"调研\n阶段","需求调研","各模块需求调研/规划/分析/讨论"]
[2,null,"需求文档","按调研需求进行功能分解及详细描述说明/各种阶段文档整理、讨论与确认"]
[3,null,"需求确认","确认最终需求，明确后期开发要点（开发需求确认单）"]
[4,"正式开发阶段","开发计划确认","双方确认计划的可执行性"]
[5,null,"EIP与HR系统\n单点登录，集成主数据","数据集成","shr组织架构、岗位和人员信息同步到OA","因为涉及到集团oa的统一管理，oa不一定能支持到这种模式的同步"]
[6,{"$nulls":3},"从蓝凌OA单点登录进入到shr系统"]
[11,null,"人事单据对接","调动单","从OA发起调动申请，审批通过后，写入到s-HR，生成调动单。"]
[12,null,null,"转正单","从OA发起调动申请，审批通过后，写入到s-HR，生成转正单。 提供接口检测非试用期员工不允许提交转正单"]
[{"$nulls":3},"离职单","从OA发起调动申请，审批通过后，写入到s-HR，生成离职单"]
[{"$nulls":3},"合同","1合同新签流程在OA审批通过后，在s-HR生成新签合同记录"]
[{"$nulls":4},"2合同续签流程在OA审批通过后，在s-HR生成续签合同记录"]
[{"$nulls":4},"3合同变更，终止流程在OA审批通过后，在s-HR生成变更，终止合同记录"]
[14,null,"假期考勤单据对接","请假单","1、假期类型，假期额度接口给oa调用"]
[15,{"$nulls":3},"2、根据请假开始和结束时长获取请假天数"]
[16,{"$nulls":3},"3、请假单oa审批通过后，写入到s-HR，生成请假单"]
[{"$nulls":3},"签卡单","在OA审批通过签卡单后，写入到s-HR，生成签卡单"]
[{"$nulls":3},"加班单","1、提供接口给oa,判断加班填写时间是否正确（工作日时段不能允许填写）。\n2、在OA审批通过加班单后，写入到s-HR，生成加班单"]
[{"$nulls":3},"出差单","在OA审批通过出差单后，写入到s-HR，生成出差单"]
[{"$nulls":3},"打卡记录对接","从考勤平台取打卡记录到s-HR"]
[24,null,"激励奖金前端\n数据收集提报","项目负责人填报奖金核算数据，提交至项目奖金核算表","创建行政组织数据同步功能"]
[25,{"$nulls":3},"查询未同步的行政组织数据"]
[26,{"$nulls":3},"调用数据中台接口"]
[27,{"$nulls":3},"发送整理完成的组织数据到数据中台"]
[28,{"$nulls":3},"创建职位数据同步功能"]
[29,{"$nulls":3},"查询未同步的职位数据"]
[30,{"$nulls":3},"调用数据中台接口"]
[31,{"$nulls":3},"发送整理完成的职位数据到数据中台"]
[32,null,null,"奖金数据台账区分期间，标记表单状态，如提交，审核等","创建人员数据同步接口"]
[33,{"$nulls":3},"查询人员的基本信息、联系方式、用工关系、职业信息等数据"]
[34,{"$nulls":3},"调用数据中台接口"]
[35,{"$nulls":3},"发送整理完成的人员数据到数据中台"]
[null,null,"薪酬单据对接","定薪单","在OA审批通过后，写入到s-HR，生成定薪单"]
[38,null,null,"调薪单","在OA审批通过后，写入到s-HR，生成调薪单"]
[67,null,null,"薪酬查询","创建薪酬OSF查询接口"]
[68,{"$nulls":3},"查询指定员工、月份的基本工资"]
[69,{"$nulls":3},"查询员工指定月份，十二个月以内的实际发放工资"]
[70,{"$nulls":3},"整理数据格式，返回薪酬数据"]
[74,"部署阶段","代码部署"]
[91,null,"上线问题跟踪处理"]