{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["项目详细进度计划","参数"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":1,"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":132,"n_cols":13,"rows_kept":132,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["江苏广靖锡澄高速公路营运管理平台项目详细进度计划"]
["项目名称: ",{"$nulls":6},{"$f":"COUNT(#REF!)","v":0}]
["当前状态","WBS","任务说明","参与人员","计划\n开始日期","计划\n完成日期","计划工作量\n(人时)","实际\n开始日期","实际\n结束日期","实际工作量\n(人时)","进度偏差\n(天)","工作量偏差\n(人时)","Remark"]
[{"$f":"IF(AND(B4=\"\",C4=\"\"),\"\",IF(H4=\"\",\"Wait\",IF(I4=\"\",\"Processing\",\"Finished\")))","v":"Finished"},"需求调研与分析",null,null,{"$f":"IF(COUNTA(E5:E11)>0,MIN(E5:E11),\"\")","v":"2014-04-09"},{"$f":"IF(COUNTA(F5:F11)>0,MAX(F5:F11),\"\")","v":"2014-04-25"},{"$f":"SUM(G5:G11)","v":388},{"$f":"IF(COUNTA(H5:H11)>0,MIN(H5:H11),\"\")","v":"2014-04-09"},{"$f":"IF(COUNTA(I5:I11)>0,MAX(I5:I11),\"\")","v":"2014-04-25"},{"$f":"SUM(J5:J11)","v":376.5},{"$f":"SUM(K5:K16)","v":22},{"$f":"SUM(L5:L16)","v":145.5}]
["Finished",null,"需求调研","肖敏，王晖，朱红军","2014-04-09","2014-04-14",120,"2014-04-09","2014-04-14",120,{"$f":"IF(OR(F5=0,I5=0),0,I5-F5)","v":0},0]
["Finished",null,"编制调研报告","肖敏，王晖，朱红军","2014-04-15","2014-04-16",48,"2014-04-14","2014-04-15",48,-1,0]
["Finished",null,"与客户确认调研报告","肖敏，王晖，朱红军，业主","2014-04-17","2014-04-18",48,"2014-04-17","2014-04-18",48,0,0]
["Finished",null,"需求分析，编写需求规格说明书","肖敏,王晖，朱红军","2014-04-21","2014-04-22",48,"2014-04-21","2014-04-22",48,0,0]
["Finished",null,"评审需求规格说明书","项目团队，业主","2014-04-23","2014-04-23",96,"2014-04-23","2014-04-23",85.5,0,-10.5]
["Finished",null,"需求规格说明书评审意见修改及定稿","肖敏,王晖，朱红军","2014-04-24","2014-04-24",24,"2014-04-24","2014-04-24",24,0,0]
["Finished",null,"发布需求基线","袁晓冬，肖敏","2014-04-25","2014-04-25",4,"2014-04-25","2014-04-25",3,0,-1]
["Finished","系统设计",null,null,{"$f":"IF(COUNTA(E13:E21)>0,MIN(E13:E21),\"\")","v":"2014-04-28"},{"$f":"IF(COUNTA(F13:F21)>0,MAX(F13:F21),\"\")","v":"2014-05-15"},{"$f":"SUM(G13:G21)","v":562},{"$f":"IF(COUNTA(H13:H21)>0,MIN(H13:H21),\"\")","v":"2014-04-28"},{"$f":"IF(COUNTA(I13:I21)>0,MAX(I13:I21),\"\")","v":"2014-05-21"},{"$f":"SUM(J13:J21)","v":728},{"$f":"SUM(K13:K21)","v":24}]
["Finished",null,"概要设计","肖敏，徐永刚","2014-04-28","2014-05-04",80,"2014-04-28","2014-05-01",64,{"$f":"IF(OR(F13=0,I13=0),0,I13-F13)","v":-3},-16]
[{"$f":"IF(AND(B14=\"\",C14=\"\"),\"\",IF(H14=\"\",\"Wait\",IF(I14=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"技术框架决策分析","肖敏，朱玲，徐永刚","2014-05-05","2014-05-05",12,"2014-05-02","2014-05-02",15,{"$f":"IF(OR(F14=0,I14=0),0,I14-F14)","v":-3},{"$f":"IF(OR(G14=0,J14=0),0,J14-G14)","v":3}]
["Finished",null,"详细设计","全体开发人员","2014-05-06","2014-05-12",250,"2014-05-06","2014-05-17",416,{"$f":"IF(OR(F15=0,I15=0),0,I15-F15)","v":5},{"$f":"IF(OR(G15=0,J15=0),0,J15-G15)","v":166}]
[{"$f":"IF(AND(B16=\"\",C16=\"\"),\"\",IF(H16=\"\",\"Wait\",IF(I16=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"设计过程中提出的需求变更处理","袁晓冬，肖敏","2014-05-08","2014-05-10",8,"2014-05-08","2014-05-10",12,{"$f":"IF(OR(F16=0,I16=0),0,I16-F16)","v":0},{"$f":"IF(OR(G16=0,J16=0),0,J16-G16)","v":4}]
["Finished",null,"建立模块开发管理表","肖敏","2014-05-06","2014-05-06",2,"2014-05-06","2014-05-06",3,{"$f":"IF(OR(F17=0,I17=0),0,I17-F17)","v":0},{"$f":"IF(OR(G17=0,J17=0),0,J17-G17)","v":1}]
["Finished",null,"评审设计文档","项目团队","2014-05-13","2014-05-13",96,"2014-05-19","2014-05-20",104,{"$f":"IF(OR(F18=0,I18=0),0,I18-F18)","v":7},{"$f":"IF(OR(G18=0,J18=0),0,J18-G18)","v":8}]
["Finished",null,"设计文档评审意见修改及定稿","全体开发人员","2014-05-14","2014-05-15",106,"2014-05-20","2014-05-21",106,{"$f":"IF(OR(F19=0,I19=0),0,I19-F19)","v":6},{"$f":"IF(OR(G19=0,J19=0),0,J19-G19)","v":0}]
["Finished",null,"发布设计基线","袁晓冬，肖敏","2014-05-15","2014-05-15",4,"2014-05-21","2014-05-21",4,6,0]
["Finished",null,"编制需求与设计里程碑报告","肖敏","2014-05-15","2014-05-15",4,"2014-05-21","2014-05-21",4,6,0]
["Finished","编码与测试",null,null,{"$f":"IF(COUNTA(E23:E56)>0,MIN(E23:E56),\"\")","v":"2014-05-16"},{"$f":"IF(COUNTA(F23:F56)>0,MAX(F23:F56),\"\")","v":"2014-08-31"},{"$f":"SUM(G23:G56)","v":3633},{"$f":"IF(COUNTA(H23:H56)>0,MIN(H23:H56),\"\")","v":"2014-05-21"},{"$f":"IF(COUNTA(I23:I56)>0,MAX(I23:I56),\"\")","v":"2014-08-31"},{"$f":"SUM(J23:J56)","v":3606},{"$f":"SUM(K23:K56)","v":7}]
["Finished",null,"制定编码规范","徐永刚","2014-05-16","2014-05-16",8,"2014-05-21","2014-05-21",4,{"$f":"IF(OR(F23=0,I23=0),0,I23-F23)","v":5},-4]
["Finished",null,"测试用例设计","朱玲，秦洁","2014-05-16","2014-06-13",300,"2014-05-21","2014-06-13",288,{"$f":"IF(OR(F24=0,I24=0),0,I24-F24)","v":0},{"$f":"IF(OR(G24=0,J24=0),0,J24-G24)","v":-12}]
[{"$f":"IF(AND(B25=\"\",C25=\"\"),\"\",IF(H25=\"\",\"Wait\",IF(I25=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"测试用例评审","肖敏，徐永刚，朱玲，秦洁","2014-06-16","2014-06-18",96,"2014-06-16","2014-06-18",92,{"$f":"IF(OR(F25=0,I25=0),0,I25-F25)","v":0},{"$f":"IF(OR(G25=0,J25=0),0,J25-G25)","v":-4}]
[{"$f":"IF(AND(B26=\"\",C26=\"\"),\"\",IF(H26=\"\",\"Wait\",IF(I26=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"测试用例修改及定稿","朱玲，秦洁","2014-06-19","2014-06-20",32,"2014-06-19","2014-06-20",32,{"$f":"IF(OR(F26=0,I26=0),0,I26-F26)","v":0},{"$f":"IF(OR(G26=0,J26=0),0,J26-G26)","v":0}]
["Finished",null,"页面设计","顾丽郡","2014-05-16","2014-05-31",80,"2014-05-21","2014-06-02",88,{"$f":"IF(OR(F27=0,I27=0),0,I27-F27)","v":2},8]
["Finished",null,"编码-M6-F05-基础支撑功能","侍凡","2014-05-16","2014-06-13",130,"2014-05-21","2014-06-13",135,0,5]
[{"$f":"IF(AND(B29=\"\",C29=\"\"),\"\",IF(H29=\"\",\"Wait\",IF(I29=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编码-M6-F03-GIS公共服务支撑","肖敏","2014-05-16","2014-06-13",64,"2014-05-21","2014-06-12",56,-1,-8]
["Finished",null,"编码-M1-F01-交通运行状态监测","陈继伟","2014-05-16","2014-06-13",130,"2014-05-21","2014-06-14",132,1,2]
["Finished",null,"编码-M1-F02-运行监测配置管理","高宇庭","2014-05-16","2014-06-13",130,"2014-05-21","2014-06-12",122,-1,-8]
["Finished",null,"编码-M2-F01-情报板管理","徐永刚","2014-05-19","2014-06-06",96,"2014-05-22","2014-06-06",96,{"$f":"IF(OR(F32=0,I32=0),0,I32-F32)","v":0},{"$f":"IF(OR(G32=0,J32=0),0,J32-G32)","v":0}]
["Finished",null,"编码-M3-F02-事件填报","徐永刚","2014-06-09","2014-06-13",32,"2014-06-09","2014-06-13",32,0,0]
["Finished",null,"编码-M6-F01-视频组件服务","潘彩侠","2014-05-16","2014-06-13",130,"2014-05-21","2014-06-13",132,0,2]
["Finished",null,"编码-M6-F02-统一权限管理服务","曹碧蓉","2014-05-16","2014-06-13",130,"2014-05-21","2014-06-13",125,0,-5]
["Finished",null,"第一阶段编译集成","徐永刚","2014-06-16","2014-06-16",4,"2014-06-16","2014-06-16",4,{"$f":"IF(OR(F36=0,I36=0),0,I36-F36)","v":0},{"$f":"IF(OR(G36=0,J36=0),0,J36-G36)","v":0}]
["Finished",null,"第一阶段测试","朱玲，秦洁","2014-06-16","2014-06-30",168,"2014-06-16","2014-06-30",168,{"$f":"IF(OR(F37=0,I37=0),0,I37-F37)","v":0},{"$f":"IF(OR(G37=0,J37=0),0,J37-G37)","v":0}]
["Finished",null,"第一阶段缺陷修复","全体开发人员","2014-06-18","2014-06-30",200,"2014-06-16","2014-06-30",200,0,0]
["Finished",null,"编码-M2-F02-号角广播管理","侍凡","2014-07-01","2014-08-01",150,"2014-07-01","2014-08-04",144,{"$f":"IF(OR(F39=0,I39=0),0,I39-F39)","v":3},{"$f":"IF(OR(G39=0,J39=0),0,J39-G39)","v":-6}]
[{"$f":"IF(AND(B40=\"\",C40=\"\"),\"\",IF(H40=\"\",\"Wait\",IF(I40=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编码-M2-F03-服务区AP信息推送","侍凡","2014-08-04","2014-08-15",64,"2014-08-05","2014-08-15",56,0,-8]
["Finished",null,"编码-M3-F01-事件接入","徐永刚","2014-07-01","2014-07-11",55,"2014-07-01","2014-07-10",48,-1,-7]
["Finished",null,"编码-M3-F03-事件处置","徐永刚","2014-07-14","2014-07-25",128,"2014-07-11","2014-07-25",136,0,8]
["Finished",null,"编码-M3-F04-事件评估","徐永刚","2014-07-28","2014-08-08",128,"2014-07-28","2014-08-07",128,-1,0]
["Finished",null,"编码-M3-F05-事件归档","徐永刚","2014-08-11","2014-08-15",32,"2014-08-08","2014-08-15",40,0,8]
["Finished",null,"编码-M3-F06-预案管理","高宇庭","2014-07-01","2014-08-01",150,"2014-07-01","2014-08-01",156,{"$f":"IF(OR(F45=0,I45=0),0,I45-F45)","v":0},{"$f":"IF(OR(G45=0,J45=0),0,J45-G45)","v":6}]
["Finished",null,"编码-M3-F07-知识管理","高宇庭","2014-08-04","2014-08-15",64,"2014-08-04","2014-08-15",64,0,0]
["Finished",null,"编码-M4-F01-值班辅助管理","潘彩侠","2014-07-01","2014-08-01",150,"2014-07-01","2014-08-01",144,0,-6]
["Finished",null,"编码-M4-F02-业务辅助管理","潘彩侠","2014-08-04","2014-08-15",64,"2014-08-04","2014-08-15",64,0,0]
["Finished",null,"编码-M4-F03-辅助决策","陈继伟","2014-07-01","2014-08-15",215,"2014-07-01","2014-08-15",224,0,9]
["Finished",null,"编码-M5-F01-清排障车辆GPS信息管理","肖敏","2014-07-01","2014-08-15",120,"2014-07-01","2014-08-15",108,0,-12]
["Finished",null,"编码-M6-F04-统一通信与软交换服务","曹碧蓉","2014-07-01","2014-08-15",215,"2014-07-01","2014-08-15",216,0,1]
["Finished",null,"整体编译集成","徐永刚","2014-08-18","2014-08-18",4,"2014-08-18","2014-08-18",4,0,0]
["Finished",null,"整体测试","朱玲，秦洁","2014-08-18","2014-08-31",140,"2014-08-18","2014-08-31",140,0,0]
["Finished",null,"测试缺陷修复","全体开发人员","2014-08-20","2014-08-31",200,"2014-08-20","2014-08-31",200,0,0]
[{"$f":"IF(AND(B55=\"\",C55=\"\"),\"\",IF(H55=\"\",\"Wait\",IF(I55=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"用户手册编写","秦洁","2014-08-25","2014-08-29",20,"2014-08-25","2014-08-29",24,{"$f":"IF(OR(F55=0,I55=0),0,I55-F55)","v":0},{"$f":"IF(OR(G55=0,J55=0),0,J55-G55)","v":4}]
["Finished",null,"编制开发里程碑报告","肖敏","2014-08-31","2014-08-31",4,"2014-08-31","2014-08-31",4,0,0]
["Finished","交付与验收",null,null,{"$f":"IF(COUNTA(E58:E66)>0,MIN(E58:E66),\"\")","v":"2014-09-01"},{"$f":"IF(COUNTA(F58:F66)>0,MAX(F58:F66),\"\")","v":"2015-01-05"},{"$f":"SUM(G58:G66)","v":242},{"$f":"IF(COUNTA(H58:H66)>0,MIN(H58:H66),\"\")","v":"2014-09-01"},{"$f":"IF(COUNTA(I58:I66)>0,MAX(I58:I66),\"\")","v":"2014-09-19"},{"$f":"SUM(J58:J66)","v":186},{"$f":"SUM(K58:K66)","v":0}]
[{"$f":"IF(AND(B58=\"\",C58=\"\"),\"\",IF(H58=\"\",\"Wait\",IF(I58=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"系统部署","肖敏，徐永刚","2014-09-01","2014-09-05",20,"2014-09-01","2014-09-05",20,{"$f":"IF(OR(F58=0,I58=0),0,I58-F58)","v":0},{"$f":"IF(OR(G58=0,J58=0),0,J58-G58)","v":0}]
["Finished",null,"系统联调","肖敏，徐永刚","2014-09-08","2014-09-12",120,"2014-09-08","2014-09-12",120,{"$f":"IF(OR(F59=0,I59=0),0,I59-F59)","v":0},{"$f":"IF(OR(G59=0,J59=0),0,J59-G59)","v":0}]
["Finished",null,"客户培训","肖敏，王晖，朱红军","2014-09-15","2014-09-17",30,"2014-09-15","2014-09-17",30,0,0]
["Finished",null,"初验","肖敏,业主","2014-09-18","2014-09-19",8,"2014-09-18","2014-09-19",8,{"$f":"IF(OR(F61=0,I61=0),0,I61-F61)","v":0},{"$f":"IF(OR(G61=0,J61=0),0,J61-G61)","v":0}]
[{"$f":"IF(AND(B62=\"\",C62=\"\"),\"\",IF(H62=\"\",\"Wait\",IF(I62=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"发布交付基线","袁晓冬，肖敏","2014-09-19","2014-09-19",4,"2014-09-19","2014-09-19",4,{"$f":"IF(OR(F62=0,I62=0),0,I62-F62)","v":0},{"$f":"IF(OR(G62=0,J62=0),0,J62-G62)","v":0}]
[{"$f":"IF(AND(B63=\"\",C63=\"\"),\"\",IF(H63=\"\",\"Wait\",IF(I63=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编制交付里程碑报告","肖敏","2014-09-19","2014-09-19",4,"2014-09-19","2014-09-19",4,0,0]
["Wait",null,"试运行","肖敏，徐永刚","2014-09-22","2014-12-31",20,null,null,null,{"$f":"IF(OR(F64=0,I64=0),0,I64-F64)","v":0},{"$f":"IF(OR(G64=0,J64=0),0,J64-G64)","v":0}]
[{"$f":"IF(AND(B65=\"\",C65=\"\"),\"\",IF(H65=\"\",\"Wait\",IF(I65=\"\",\"Processing\",\"Finished\")))","v":"Wait"},null,"第三方测试","肖敏，检测中心","2014-11-01","2014-11-30",20,null,null,null,{"$f":"IF(OR(F65=0,I65=0),0,I65-F65)","v":0},{"$f":"IF(OR(G65=0,J65=0),0,J65-G65)","v":0}]
["Wait",null,"终验","肖敏，业主","2015-01-03","2015-01-05",16,null,null,null,{"$f":"IF(OR(F66=0,I66=0),0,I66-F66)","v":0},{"$f":"IF(OR(G66=0,J66=0),0,J66-G66)","v":0}]
["Finished","项目管理及其他",null,null,{"$f":"IF(COUNTA(E68:E129)>0,MIN(E68:E129),\"\")","v":"2014-04-07"},{"$f":"IF(COUNTA(F68:F129)>0,MAX(F68:F129),\"\")","v":"2014-09-21"},{"$f":"SUM(G68:G129)","v":590},{"$f":"IF(COUNTA(H68:H129)>0,MIN(H68:H129),\"\")","v":"2014-04-07"},{"$f":"IF(COUNTA(I68:I129)>0,MAX(I68:I129),\"\")","v":"2014-09-21"},{"$f":"SUM(J68:J129)","v":583},{"$f":"SUM(K68:K69)","v":0}]
[{"$f":"IF(AND(B68=\"\",C68=\"\"),\"\",IF(H68=\"\",\"Wait\",IF(I68=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编写项目开工报告","肖敏","2014-04-07","2014-04-08",4,"2014-04-07","2014-04-08",2,{"$f":"IF(OR(F68=0,I68=0),0,I68-F68)","v":0},{"$f":"IF(OR(G68=0,J68=0),0,J68-G68)","v":-2}]
["Finished",null,"项目估算","肖敏、施展、徐永刚","2014-04-09","2014-04-10",4,"2014-04-09","2014-04-10",5,0,1]
["Finished",null,"制定项目整体计划","肖敏，袁晓冬","2014-04-11","2014-04-14",10,"2014-04-11","2014-04-14",8,0,-2]
["Finished",null,"评审项目整体计划","项目团队，领导，业主","2014-04-15","2014-04-15",40,"2014-04-15","2014-04-15",36,0,-4]
[{"$f":"IF(AND(B72=\"\",C72=\"\"),\"\",IF(H72=\"\",\"Wait\",IF(I72=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"系统框架培训","全体开发人员","2014-05-05","2014-05-05",28,"2014-05-05","2014-05-06",28,{"$f":"IF(OR(F72=0,I72=0),0,I72-F72)","v":1},{"$f":"IF(OR(G72=0,J72=0),0,J72-G72)","v":0}]
[{"$f":"IF(AND(B73=\"\",C73=\"\"),\"\",IF(H73=\"\",\"Wait\",IF(I73=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"超图培训","全体开发人员","2014-05-16","2014-05-16",6,"2014-05-16","2014-05-16",6,{"$f":"IF(OR(F73=0,I73=0),0,I73-F73)","v":0},{"$f":"IF(OR(G73=0,J73=0),0,J73-G73)","v":0}]
[{"$f":"IF(AND(B74=\"\",C74=\"\"),\"\",IF(H74=\"\",\"Wait\",IF(I74=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"系统业务流程培训、项目规范培训","项目团队","2014-04-28","2014-04-28",24,"2014-04-28","2014-04-28",24,{"$f":"IF(OR(F74=0,I74=0),0,I74-F74)","v":0},{"$f":"IF(OR(G74=0,J74=0),0,J74-G74)","v":0}]
["Finished",null,"维护详细进度计划","肖敏","2014-04-09","2014-09-21",null,"2014-04-09","2014-09-21",null,0,0]
["Finished",null,"  第1周","肖敏","2014-04-11","2014-04-11",0.5,"2014-04-11","2014-04-11",0.5,{"$f":"IF(OR(F76=0,I76=0),0,I76-F76)","v":0},{"$f":"IF(OR(G76=0,J76=0),0,J76-G76)","v":0}]
["Finished",null,"  第2周","肖敏","2014-04-18","2014-04-18",1,"2014-04-18","2014-04-18",1,0,0]
[{"$f":"IF(AND(B78=\"\",C78=\"\"),\"\",IF(H78=\"\",\"Wait\",IF(I78=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  第3周","肖敏","2014-04-25","2014-04-25",0.5,"2014-04-25","2014-04-25",0.5,{"$f":"IF(OR(F78=0,I78=0),0,I78-F78)","v":0},{"$f":"IF(OR(G78=0,J78=0),0,J78-G78)","v":0}]
["Finished",null,"  第4周","肖敏","2014-04-30","2014-04-30",1,"2014-05-04","2014-05-04",1,4,0]
["Finished",null,"  第5周","肖敏","2014-05-09","2014-05-09",1.5,"2014-05-09","2014-05-09",1.5,0,0]
[{"$f":"IF(AND(B81=\"\",C81=\"\"),\"\",IF(H81=\"\",\"Wait\",IF(I81=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  第6周","肖敏","2014-05-16","2014-05-16",1,"2014-05-16","2014-05-16",1,{"$f":"IF(OR(F81=0,I81=0),0,I81-F81)","v":0},{"$f":"IF(OR(G81=0,J81=0),0,J81-G81)","v":0}]
["Finished",null,"  第7周","肖敏","2014-05-23","2014-05-23",1,"2014-05-23","2014-05-23",1,0,0]
["Finished",null,"  第8周","肖敏","2014-05-30","2014-05-30",0.5,"2014-05-30","2014-05-30",0.5,0,0]
["Finished",null,"  第9周","肖敏","2014-06-06","2014-06-06",0.5,"2014-06-06","2014-06-06",0.5,0,0]
["Finished",null,"  第10周","肖敏","2014-06-13","2014-06-13",0.5,"2014-06-13","2014-06-13",0.5,0,0]
["Finished",null,"  第11周","肖敏","2014-06-20","2014-06-20",0.5,"2014-06-20","2014-06-20",0.5,0,0]
[{"$f":"IF(AND(B87=\"\",C87=\"\"),\"\",IF(H87=\"\",\"Wait\",IF(I87=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  第12周","肖敏","2014-06-27","2014-06-27",0.5,"2014-06-27","2014-06-27",0.5,{"$f":"IF(OR(F87=0,I87=0),0,I87-F87)","v":0},{"$f":"IF(OR(G87=0,J87=0),0,J87-G87)","v":0}]
["Finished",null,"  第13周","肖敏","2014-07-04","2014-07-04",1,"2014-07-04","2014-07-04",1,0,0]
["Finished",null,"  第14周","肖敏","2014-07-11","2014-07-11",1,"2014-07-11","2014-07-11",1,0,0]
["Finished",null,"  第15周","肖敏","2014-07-18","2014-07-18",0.5,"2014-07-18","2014-07-18",0.5,0,0]
["Finished",null,"  第16周","肖敏","2014-07-25","2014-07-25",0.5,"2014-07-25","2014-07-25",0.5,0,0]
["Finished",null,"  第17周","肖敏","2014-08-01","2014-08-01",0.5,"2014-08-01","2014-08-01",0.5,0,0]
["Finished",null,"  第18周","肖敏","2014-08-08","2014-08-08",0.5,"2014-08-08","2014-08-08",0.5,0,0]
["Finished",null,"  第19周","肖敏","2014-08-15","2014-08-15",0.5,"2014-08-15","2014-08-15",0.5,0,0]
["Finished",null,"  第20周","肖敏","2014-08-22","2014-08-22",0.5,"2014-08-22","2014-08-22",0.5,0,0]
["Finished",null,"  第21周","肖敏","2014-08-29","2014-08-29",0.5,"2014-08-29","2014-08-29",0.5,0,0]
["Finished",null,"  第22周","肖敏","2014-09-05","2014-09-05",0.5,"2014-09-05","2014-09-05",0.5,0,0]
["Finished",null,"  第23周","肖敏","2014-09-12","2014-09-12",0.5,"2014-09-12","2014-09-12",0.5,0,0]
[{"$f":"IF(AND(B99=\"\",C99=\"\"),\"\",IF(H99=\"\",\"Wait\",IF(I99=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  第24周","肖敏","2014-09-21","2014-09-21",0.5,"2014-09-21","2014-09-21",0.5,{"$f":"IF(OR(F99=0,I99=0),0,I99-F99)","v":0},{"$f":"IF(OR(G99=0,J99=0),0,J99-G99)","v":0}]
["Finished",null,"项目状态报告（编制报告，召开例会）","项目团队，领导，业主","2014-04-09","2014-09-21",null,"2014-04-09","2014-09-21",null,0,0,"每次开会前先完成当前阶段的状态报告"]
["Finished",null,"  第2周","项目团队，领导，业主","2014-04-17","2014-04-18",30,"2014-04-17","2014-04-18",28,{"$f":"IF(OR(F101=0,I101=0),0,I101-F101)","v":0},{"$f":"IF(OR(G101=0,J101=0),0,J101-G101)","v":-2}]
["Finished",null,"  第4周","项目团队，领导，业主","2014-05-04","2014-05-04",24,"2014-05-04","2014-05-04",24,0,0]
["Finished",null,"  第6周","项目团队，领导，业主","2014-05-15","2014-05-16",24,"2014-05-15","2014-05-16",24,0,0]
["Finished",null,"  第8周","项目团队，领导，业主","2014-05-29","2014-05-30",28,"2014-05-29","2014-05-30",28,0,0]
["Finished",null,"  第10周","项目团队，领导，业主","2014-06-12","2014-06-13",30,"2014-06-12","2014-06-13",31,0,1]
["Finished",null,"  第12周","项目团队，领导，业主","2014-06-26","2014-06-27",32,"2014-06-26","2014-06-27",32,0,0]
["Finished",null,"  第14周","项目团队，领导，业主","2014-07-10","2014-07-11",32,"2014-07-10","2014-07-11",33,0,1]
["Finished",null,"  第16周","项目团队，领导，业主","2014-07-24","2014-07-25",33,"2014-07-24","2014-07-25",33,0,0]
["Finished",null,"  第18周","项目团队，领导，业主","2014-08-07","2014-08-08",30,"2014-08-07","2014-08-08",30,0,0]
["Finished",null,"  第20周","项目团队，领导，业主","2014-08-21","2014-08-22",30,"2014-08-21","2014-08-22",30,0,0]
["Finished",null,"  第22周","项目团队，领导，业主","2014-09-04","2014-09-05",27,"2014-09-04","2014-09-05",27,0,0]
["Finished",null,"  第24周","项目团队，领导，业主","2014-09-20","2014-09-21",30,"2014-09-20","2014-09-21",30,0,0]
["Finished",null,"识别及管理项目风险","肖敏","2014-04-09","2014-09-19",null,"2014-04-09","2014-09-19",null,0,0]
["Finished",null,"  需求及设计里程碑阶段","肖敏","2014-04-09","2014-05-15",10,"2014-04-09","2014-05-15",10,{"$f":"IF(OR(F114=0,I114=0),0,I114-F114)","v":0},{"$f":"IF(OR(G114=0,J114=0),0,J114-G114)","v":0}]
["Finished",null,"  开发里程碑阶段","肖敏","2014-05-16","2014-08-31",5,"2014-05-16","2014-08-31",5,0,0]
["Finished",null,"  交付里程碑阶段","肖敏","2014-09-01","2014-09-19",5,"2014-09-01","2014-09-19",5,0,0]
["Finished",null,"识别及管理项目问题","肖敏","2014-04-09","2014-09-21",null,"2014-04-09","2014-09-21",null,0,0]
["Finished",null,"  需求阶段","肖敏","2014-04-09","2014-04-25",8,"2014-04-09","2014-04-25",8,{"$f":"IF(OR(F118=0,I118=0),0,I118-F118)","v":0},{"$f":"IF(OR(G118=0,J118=0),0,J118-G118)","v":0}]
["Finished",null,"  设计阶段","肖敏","2014-04-28","2014-05-15",4,"2014-04-28","2014-05-15",4,0,0]
["Finished",null,"  开发阶段","肖敏","2014-05-16","2014-08-31",24,"2014-05-16","2014-08-31",24,0,0]
["Finished",null,"  交付阶段","肖敏","2014-09-01","2014-09-21",4,"2014-09-01","2014-09-21",4,0,0]
["Finished",null,"收集和整理度量数据","肖敏","2014-04-09","2014-09-21",null,"2014-04-09","2014-09-21",null,0,0]
["Finished",null,"  需求阶段","肖敏","2014-04-09","2014-04-25",2,"2014-04-09","2014-04-25",2,{"$f":"IF(OR(F123=0,I123=0),0,I123-F123)","v":0},{"$f":"IF(OR(G123=0,J123=0),0,J123-G123)","v":0}]
["Finished",null,"  设计阶段","肖敏","2014-04-28","2014-05-15",2,"2014-04-28","2014-05-15",2,0,0]
["Finished",null,"  开发阶段","肖敏","2014-05-16","2014-08-31",12,"2014-05-16","2014-08-31",12,0,0]
["Finished",null,"  交付阶段","肖敏","2014-09-01","2014-09-21",4,"2014-09-01","2014-09-21",4,0,0]
["Finished",null,"配置项状态稽核","袁晓冬","2014-04-09","2014-09-21",12,"2014-04-09","2014-09-21",12,0,0]
["Finished",null,"项目总结报告","肖敏","2014-09-20","2014-09-21",8,"2014-09-20","2014-09-21",8,0,0]
["Finished",null,"项目资料整理","肖敏","2014-09-20","2014-09-21",8,"2014-09-20","2014-09-21",8,0,0]
[{"$f":"IF(AND(B130=\"\",C130=\"\"),\"\",IF(H130=\"\",\"Wait\",IF(I130=\"\",\"Processing\",\"Finished\")))","v":"Wait"},"维护",null,null,{"$f":"IF(COUNTA(E131:E132)>0,MIN(E131:E132),\"\")","v":"2015-01-05"},{"$f":"IF(COUNTA(F131:F132)>0,MIN(F131:F132),\"\")","v":"2017-01-04"},{"$f":"SUM(G131:G132)","v":160},{"$f":"IF(COUNTA(H131:H132)>0,MIN(H131:H132),\"\")","v":""},{"$f":"IF(COUNTA(I131:I132)>0,MAX(I131:I132),\"\")","v":""},{"$f":"SUM(J131:J132)","v":0},{"$f":"SUM(K131:K132)","v":0}]
[{"$f":"IF(AND(B131=\"\",C131=\"\"),\"\",IF(H131=\"\",\"Wait\",IF(I131=\"\",\"Processing\",\"Finished\")))","v":"Wait"},null,"运行维护","高宇庭","2015-01-05","2017-01-04",160,null,null,null,{"$f":"IF(OR(F131=0,I131=0),0,I131-F131)","v":0},0]
[{"$f":"IF(AND(B132=\"\",C132=\"\"),\"\",IF(H132=\"\",\"Wait\",IF(I132=\"\",\"Processing\",\"Finished\")))","v":""},{"$nulls":9},0,0]

{"sheet":"参数","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["阶段",null,"工作分类"]
["需求调研与分析",null,"需求"]
["系统设计",null,"设计"]
["编码与测试",null,"编码"]
["交付与验收",null,"测试"]
["维护",null,"其他"]
["项目管理及其他"]