{"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":128,"n_cols":13,"rows_kept":128,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["南京长江隧道管养信息系统项目详细进度计划"]
[]
["当前状态","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-02-26"},{"$f":"IF(COUNTA(F5:F11)>0,MAX(F5:F11),\"\")","v":"2014-04-10"},{"$f":"SUM(G5:G11)","v":300},{"$f":"IF(COUNTA(H5:H11)>0,MIN(H5:H11),\"\")","v":"2014-02-26"},{"$f":"IF(COUNTA(I5:I11)>0,MAX(I5:I11),\"\")","v":"2014-04-10"},{"$f":"SUM(J5:J11)","v":314},{"$f":"SUM(K5:K14)","v":52},{"$f":"SUM(L5:L14)","v":30}]
["Finished",null,"需求调研","高才驰，戴鹏飞，孙强，张雁飞","2014-02-26","2014-03-18",120,"2014-02-26","2014-03-18",128,{"$f":"IF(OR(F5=0,I5=0),0,I5-F5)","v":0},8]
["Finished",null,"编制调研报告","高才驰，戴鹏飞，王晓勇","2014-03-17","2014-03-20",40,"2014-03-17","2014-03-19",32,-1,-8]
["Finished",null,"与客户确认调研报告","高才驰，戴鹏飞，王晓勇，业主","2014-03-21","2014-03-21",12,"2014-03-20","2014-03-20",12,-1,0]
["Finished",null,"需求分析，编写需求规格说明书","高才驰,戴鹏飞，王晓勇","2014-03-24","2014-04-03",60,"2014-03-21","2014-04-03",64,0,4]
["Finished",null,"评审需求规格说明书","项目团队，业主","2014-04-04","2014-04-04",40,"2014-04-04","2014-04-04",40,0,0]
["Finished",null,"需求规格说明书评审意见修改及定稿","高才驰,戴鹏飞，王晓勇","2014-04-07","2014-04-09",24,"2014-04-07","2014-04-09",32,0,8]
[{"$f":"IF(AND(B11=\"\",C11=\"\"),\"\",IF(H11=\"\",\"Wait\",IF(I11=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"发布需求基线","袁晓冬，高才驰","2014-04-10","2014-04-10",4,"2014-04-10","2014-04-10",6,{"$f":"IF(OR(F11=0,I11=0),0,I11-F11)","v":0},{"$f":"IF(OR(G11=0,J11=0),0,J11-G11)","v":2}]
["Finished","系统设计",null,null,{"$f":"IF(COUNTA(E13:E19)>0,MIN(E13:E19),\"\")","v":"2014-04-01"},{"$f":"IF(COUNTA(F13:F19)>0,MAX(F13:F19),\"\")","v":"2014-04-25"},{"$f":"SUM(G13:G19)","v":476},{"$f":"IF(COUNTA(H13:H19)>0,MIN(H13:H19),\"\")","v":"2014-04-01"},{"$f":"IF(COUNTA(I13:I19)>0,MAX(I13:I19),\"\")","v":"2014-05-04"},{"$f":"SUM(J13:J19)","v":484},{"$f":"SUM(K13:K19)","v":46}]
["Finished",null,"系统设计","高才驰，马英虎，孙强","2014-04-01","2014-04-17",360,"2014-04-01","2014-04-25",376,{"$f":"IF(OR(F13=0,I13=0),0,I13-F13)","v":8},16]
[{"$f":"IF(AND(B14=\"\",C14=\"\"),\"\",IF(H14=\"\",\"Wait\",IF(I14=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"技术框架决策分析","高才驰，孙强，马英虎","2014-04-04","2014-04-04",16,"2014-04-04","2014-04-04",16,{"$f":"IF(OR(F14=0,I14=0),0,I14-F14)","v":0},{"$f":"IF(OR(G14=0,J14=0),0,J14-G14)","v":0}]
["Finished",null,"建立模块开发管理表","高才驰","2014-04-07","2014-04-07",4,"2014-04-07","2014-04-07",4,{"$f":"IF(OR(F15=0,I15=0),0,I15-F15)","v":0},{"$f":"IF(OR(G15=0,J15=0),0,J15-G15)","v":0}]
[{"$f":"IF(AND(B16=\"\",C16=\"\"),\"\",IF(H16=\"\",\"Wait\",IF(I16=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"评审设计文档","项目团队","2014-04-18","2014-04-18",40,"2014-04-28","2014-04-28",40,{"$f":"IF(OR(F16=0,I16=0),0,I16-F16)","v":10},{"$f":"IF(OR(G16=0,J16=0),0,J16-G16)","v":0}]
["Finished",null,"设计文档评审意见修改及定稿","高才驰，马英虎","2014-04-21","2014-04-24",48,"2014-04-29","2014-05-04",40,{"$f":"IF(OR(F17=0,I17=0),0,I17-F17)","v":10},{"$f":"IF(OR(G17=0,J17=0),0,J17-G17)","v":-8}]
["Finished",null,"发布设计基线","袁晓东，高才驰","2014-04-25","2014-04-25",4,"2014-05-04","2014-05-04",4,9,0]
[{"$f":"IF(AND(B19=\"\",C19=\"\"),\"\",IF(H19=\"\",\"Wait\",IF(I19=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编制需求及设计里程碑报告","高才驰","2014-04-25","2014-04-25",4,"2014-05-04","2014-05-04",4,{"$f":"IF(OR(F19=0,I19=0),0,I19-F19)","v":9},{"$f":"IF(OR(G19=0,J19=0),0,J19-G19)","v":0}]
["Finished","编码与测试",null,null,{"$f":"IF(COUNTA(E21:E47)>0,MIN(E21:E47),\"\")","v":"2014-04-28"},{"$f":"IF(COUNTA(F21:F47)>0,MAX(F21:F47),\"\")","v":"2014-07-25"},{"$f":"SUM(G21:G47)","v":2508},{"$f":"IF(COUNTA(H21:H47)>0,MIN(H21:H47),\"\")","v":"2014-04-28"},{"$f":"IF(COUNTA(I21:I47)>0,MAX(I21:I47),\"\")","v":"2014-07-25"},{"$f":"SUM(J21:J47)","v":2516},{"$f":"SUM(K21:K47)","v":15}]
["Finished",null,"制定编码规范","马英虎","2014-04-28","2014-04-28",8,"2014-04-28","2014-04-30",6,{"$f":"IF(OR(F21=0,I21=0),0,I21-F21)","v":2},-2]
[{"$f":"IF(AND(B22=\"\",C22=\"\"),\"\",IF(H22=\"\",\"Wait\",IF(I22=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"搭建开发环境","马英虎","2014-04-29","2014-04-30",16,"2014-05-05","2014-05-05",10,5,-6]
["Finished",null,"测试用例设计","高才驰，马英虎，殷萍","2014-05-19","2014-05-30",200,"2014-05-19","2014-05-30",216,{"$f":"IF(OR(F23=0,I23=0),0,I23-F23)","v":0},{"$f":"IF(OR(G23=0,J23=0),0,J23-G23)","v":16}]
[{"$f":"IF(AND(B24=\"\",C24=\"\"),\"\",IF(H24=\"\",\"Wait\",IF(I24=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"测试用例评审","高才驰，马英虎，朱玲，殷萍","2014-06-02","2014-06-02",16,"2014-06-02","2014-06-02",16,{"$f":"IF(OR(F24=0,I24=0),0,I24-F24)","v":0},{"$f":"IF(OR(G24=0,J24=0),0,J24-G24)","v":0}]
[{"$f":"IF(AND(B25=\"\",C25=\"\"),\"\",IF(H25=\"\",\"Wait\",IF(I25=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"测试用例修改及定稿","马英虎，殷萍","2014-06-03","2014-06-06",16,"2014-06-03","2014-06-06",16,{"$f":"IF(OR(F25=0,I25=0),0,I25-F25)","v":0},{"$f":"IF(OR(G25=0,J25=0),0,J25-G25)","v":0}]
["Finished",null,"页面设计","潘虎","2014-05-04","2014-05-23",120,"2014-05-04","2014-05-23",120,{"$f":"IF(OR(F26=0,I26=0),0,I26-F26)","v":0},0]
["Finished",null,"编码-M3-F01-系统登录","孙强","2014-05-04","2014-05-09",40,"2014-05-06","2014-05-12",48,3,8]
["Finished",null,"编码-M3-F01-系统主界面","陈飞","2014-05-04","2014-05-09",40,"2014-05-06","2014-05-09",32,0,-8]
["Finished",null,"编码-M3-F03-人员、机构、权限、系统参数维护","马英虎","2014-05-04","2014-05-06",24,"2014-05-06","2014-05-08",24,{"$f":"IF(OR(F29=0,I29=0),0,I29-F29)","v":2},{"$f":"IF(OR(G29=0,J29=0),0,J29-G29)","v":0}]
["Finished",null,"编码-M1-F01-设施设备管理","马英虎","2014-05-07","2014-05-09",24,"2014-05-09","2014-05-11",24,{"$f":"IF(OR(F30=0,I30=0),0,I30-F30)","v":2},{"$f":"IF(OR(G30=0,J30=0),0,J30-G30)","v":0}]
[{"$f":"IF(AND(B31=\"\",C31=\"\"),\"\",IF(H31=\"\",\"Wait\",IF(I31=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编码-M1-F02-巡检标准维护","马英虎","2014-05-12","2014-05-16",40,"2014-05-12","2014-05-16",40,0,0]
["Finished",null,"编码-M1-F03-巡检任务管理","马英虎","2014-05-19","2014-05-23",40,"2014-05-19","2014-05-23",40,0,0]
["Finished",null,"编码-M1-F04-二维码管理","马英虎","2014-05-26","2014-05-30",40,"2014-05-26","2014-05-30",40,0,0]
["Finished",null,"编码-M1-F05-设施设备评价体系管理","马英虎","2014-06-02","2014-06-06",40,"2014-06-02","2014-06-06",40,0,0]
[{"$f":"IF(AND(B35=\"\",C35=\"\"),\"\",IF(H35=\"\",\"Wait\",IF(I35=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编码-M1-F03-巡检任务实施管理（web+安卓app）","孙强","2014-05-12","2014-05-16",40,"2014-05-13","2014-05-17",40,{"$f":"IF(OR(F35=0,I35=0),0,I35-F35)","v":1},{"$f":"IF(OR(G35=0,J35=0),0,J35-G35)","v":0}]
["Finished",null,"编码-M2-F01-数据查询与展现","陈飞","2014-06-02","2014-06-06",40,"2014-06-02","2014-06-06",40,0,0]
["Finished",null,"编码-M2-F02-与档案系统交互","高才驰","2014-05-26","2014-05-30",40,"2014-05-26","2014-05-30",40,{"$f":"IF(OR(F37=0,I37=0),0,I37-F37)","v":0},{"$f":"IF(OR(G37=0,J37=0),0,J37-G37)","v":0}]
[{"$f":"IF(AND(B38=\"\",C38=\"\"),\"\",IF(H38=\"\",\"Wait\",IF(I38=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编码-M2-F02-高级查询及展现（基于搜索引擎）","孙强","2014-05-19","2014-05-23",40,"2014-05-19","2014-05-23",40,{"$f":"IF(OR(F38=0,I38=0),0,I38-F38)","v":0},{"$f":"IF(OR(G38=0,J38=0),0,J38-G38)","v":0}]
[{"$f":"IF(AND(B39=\"\",C39=\"\"),\"\",IF(H39=\"\",\"Wait\",IF(I39=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编码-M3-F02-数据交换","孙强","2014-05-26","2014-05-30",40,"2014-05-26","2014-05-30",40,{"$f":"IF(OR(F39=0,I39=0),0,I39-F39)","v":0},{"$f":"IF(OR(G39=0,J39=0),0,J39-G39)","v":0}]
["Finished",null,"代码编译集成","马英虎","2014-06-10","2014-06-11",8,"2014-06-10","2014-06-11",8,0,0]
[{"$f":"IF(AND(B41=\"\",C41=\"\"),\"\",IF(H41=\"\",\"Wait\",IF(I41=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"功能测试","高才驰，孙强，马英虎，殷萍","2014-06-11","2014-07-01",360,"2014-06-11","2014-07-01",360,{"$f":"IF(OR(F41=0,I41=0),0,I41-F41)","v":0},{"$f":"IF(OR(G41=0,J41=0),0,J41-G41)","v":0}]
[{"$f":"IF(AND(B42=\"\",C42=\"\"),\"\",IF(H42=\"\",\"Wait\",IF(I42=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"缺陷修复","全体开发人员","2014-06-11","2014-07-01",480,"2014-06-11","2014-07-01",480,{"$f":"IF(OR(F42=0,I42=0),0,I42-F42)","v":0},{"$f":"IF(OR(G42=0,J42=0),0,J42-G42)","v":0}]
["Finished",null,"系统测试版本发布","马英虎","2014-07-02","2014-07-03",8,"2014-07-02","2014-07-03",8,0,0]
["Finished",null,"系统测试","高才驰，孙强，马英虎，殷萍","2014-07-04","2014-07-20",260,"2014-07-04","2014-07-20",260,0,0]
["Finished",null,"测试缺陷修复","全体开发人员","2014-07-04","2014-07-25",480,"2014-07-04","2014-07-25",480,0,0]
[{"$f":"IF(AND(B46=\"\",C46=\"\"),\"\",IF(H46=\"\",\"Wait\",IF(I46=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"用户手册编写","王晓勇","2014-07-14","2014-07-25",40,"2014-07-14","2014-07-25",40,{"$f":"IF(OR(F46=0,I46=0),0,I46-F46)","v":0},{"$f":"IF(OR(G46=0,J46=0),0,J46-G46)","v":0}]
["Finished",null,"编制开发里程碑报告","高才驰","2014-07-25","2014-07-25",8,"2014-07-25","2014-07-25",8,0,0]
["Finished","交付与验收",null,null,{"$f":"IF(COUNTA(E49:E55)>0,MIN(E49:E55),\"\")","v":"2014-07-25"},{"$f":"IF(COUNTA(F49:F55)>0,MAX(F49:F55),\"\")","v":"2014-10-31"},{"$f":"SUM(G49:G55)","v":220},{"$f":"IF(COUNTA(H49:H55)>0,MIN(H49:H55),\"\")","v":"2014-07-25"},{"$f":"IF(COUNTA(I49:I55)>0,MAX(I49:I55),\"\")","v":"2014-08-15"},{"$f":"SUM(J49:J55)","v":170},{"$f":"SUM(K49:K55)","v":0}]
[{"$f":"IF(AND(B49=\"\",C49=\"\"),\"\",IF(H49=\"\",\"Wait\",IF(I49=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"系统部署","高才驰，马英虎","2014-07-25","2014-07-30",96,"2014-07-25","2014-07-30",88,{"$f":"IF(OR(F49=0,I49=0),0,I49-F49)","v":0},{"$f":"IF(OR(G49=0,J49=0),0,J49-G49)","v":-8}]
["Finished",null,"客户培训","高才驰，戴鹏飞，王晓勇","2014-07-28","2014-08-01",40,"2014-07-28","2014-08-01",32,{"$f":"IF(OR(F50=0,I50=0),0,I50-F50)","v":0},{"$f":"IF(OR(G50=0,J50=0),0,J50-G50)","v":-8}]
["Finished",null,"初验","高才驰,业主","2014-08-04","2014-08-15",24,"2014-08-04","2014-08-15",40,{"$f":"IF(OR(F51=0,I51=0),0,I51-F51)","v":0},{"$f":"IF(OR(G51=0,J51=0),0,J51-G51)","v":16}]
[{"$f":"IF(AND(B52=\"\",C52=\"\"),\"\",IF(H52=\"\",\"Wait\",IF(I52=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"发布交付基线","袁晓东，高才驰","2014-08-15","2014-08-15",4,"2014-08-15","2014-08-15",4,{"$f":"IF(OR(F52=0,I52=0),0,I52-F52)","v":0},{"$f":"IF(OR(G52=0,J52=0),0,J52-G52)","v":0}]
[{"$f":"IF(AND(B53=\"\",C53=\"\"),\"\",IF(H53=\"\",\"Wait\",IF(I53=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编制交付里程碑报告","高才驰","2014-08-15","2014-08-15",8,"2014-08-15","2014-08-15",6,0,-2]
["Processing",null,"试运行","高才驰，马英虎","2014-08-18","2014-10-30",40,"2014-08-18",null,null,{"$f":"IF(OR(F54=0,I54=0),0,I54-F54)","v":0},{"$f":"IF(OR(G54=0,J54=0),0,J54-G54)","v":0}]
["Wait",null,"终验","高才驰，业主","2014-10-31","2014-10-31",8,null,null,null,{"$f":"IF(OR(F55=0,I55=0),0,I55-F55)","v":0},{"$f":"IF(OR(G55=0,J55=0),0,J55-G55)","v":0}]
["Finished","项目管理及其他",null,null,{"$f":"IF(COUNTA(E57:E125)>0,MIN(E57:E125),\"\")","v":"2014-02-20"},{"$f":"IF(COUNTA(F57:F125)>0,MAX(F57:F125),\"\")","v":"2014-08-15"},{"$f":"SUM(G57:G125)","v":426},{"$f":"IF(COUNTA(H57:H125)>0,MIN(H57:H125),\"\")","v":"2014-02-20"},{"$f":"IF(COUNTA(I57:I125)>0,MAX(I57:I125),\"\")","v":"2014-08-15"},{"$f":"SUM(J57:J125)","v":453},{"$f":"SUM(K57:K58)","v":0}]
[{"$f":"IF(AND(B57=\"\",C57=\"\"),\"\",IF(H57=\"\",\"Wait\",IF(I57=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"编写项目开工报告","高才驰","2014-02-20","2014-02-21",4,"2014-02-20","2014-02-21",4,{"$f":"IF(OR(F57=0,I57=0),0,I57-F57)","v":0},{"$f":"IF(OR(G57=0,J57=0),0,J57-G57)","v":0}]
["Finished",null,"项目估算","高才驰、马英虎、孙强","2014-02-21","2014-02-22",4,"2014-02-21","2014-02-22",4,0,0]
["Finished",null,"制定项目整体计划","高才驰，袁晓冬","2014-02-22","2014-02-24",8,"2014-02-22","2014-02-24",10,0,2]
["Finished",null,"评审项目整体计划","项目团队，领导，业主","2014-02-25","2014-02-25",16,"2014-02-25","2014-02-25",16,0,0]
[{"$f":"IF(AND(B61=\"\",C61=\"\"),\"\",IF(H61=\"\",\"Wait\",IF(I61=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"隧道设施设备编码规则培训","李红卫、王晓勇、高才驰、马英虎、孙强、陈飞、潘虎","2014-03-24","2014-03-24",6,"2014-03-24","2014-03-24",6,{"$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-04-21","2014-04-21",6,"2014-04-21","2014-04-21",6,{"$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-04-30","2014-04-30",8,"2014-04-30","2014-04-30",8,{"$f":"IF(OR(F63=0,I63=0),0,I63-F63)","v":0},{"$f":"IF(OR(G63=0,J63=0),0,J63-G63)","v":0}]
[{"$f":"IF(AND(B64=\"\",C64=\"\"),\"\",IF(H64=\"\",\"Wait\",IF(I64=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"安卓开发培训","肖常衍、马英虎、潘虎、孙强、陈飞","2014-05-26","2014-05-26",8,"2014-05-26","2014-05-26",8,{"$f":"IF(OR(F64=0,I64=0),0,I64-F64)","v":0},{"$f":"IF(OR(G64=0,J64=0),0,J64-G64)","v":0}]
["Finished",null,"维护详细进度计划","高才驰","2014-02-20","2014-08-15",null,"2014-02-20","2014-08-15",null,0,0]
["Finished",null,"  第1周","高才驰","2014-02-21","2014-02-21",3,"2014-02-21","2014-02-21",3]
["Finished",null,"  第2周","高才驰","2014-02-28","2014-02-28",2,"2014-02-28","2014-02-28",2,{"$f":"IF(OR(F67=0,I67=0),0,I67-F67)","v":0},{"$f":"IF(OR(G67=0,J67=0),0,J67-G67)","v":0}]
["Finished",null,"  第3周","高才驰","2014-03-07","2014-03-07",2,"2014-03-07","2014-03-07",2,0,0]
["Finished",null,"  第4周","高才驰","2014-03-14","2014-03-14",2,"2014-03-14","2014-03-14",2,0,0]
["Finished",null,"  第5周","高才驰","2014-03-21","2014-03-21",2,"2014-03-21","2014-03-21",2,0,0]
["Finished",null,"  第6周","高才驰","2014-03-28","2014-03-28",2,"2014-03-28","2014-03-28",2,0,0]
["Finished",null,"  第7周","高才驰","2014-04-04","2014-04-04",2,"2014-04-04","2014-04-04",2,0,0]
["Finished",null,"  第8周","高才驰","2014-04-11","2014-04-11",2,"2014-04-11","2014-04-11",2,0,0]
["Finished",null,"  第9周","高才驰","2014-04-18","2014-04-18",2,"2014-04-18","2014-04-18",2,0,0]
["Finished",null,"  第10周","高才驰","2014-04-25","2014-04-25",2,"2014-04-25","2014-04-25",2,0,0]
["Finished",null,"  第11周","高才驰","2014-05-02","2014-05-02",2,"2014-05-04","2014-05-04",2,2,0]
["Finished",null,"  第12周","高才驰","2014-05-09","2014-05-09",2,"2014-05-09","2014-05-09",2,0,0]
["Finished",null,"  第13周","高才驰","2014-05-16","2014-05-16",2,"2014-05-16","2014-05-16",2,0,0]
["Finished",null,"  第14周","高才驰","2014-05-23","2014-05-23",2,"2014-05-23","2014-05-23",2,0,0]
["Finished",null,"  第15周","高才驰","2014-05-30","2014-05-30",2,"2014-05-30","2014-05-30",2,0,0]
["Finished",null,"  第16周","高才驰","2014-06-06","2014-06-06",2,"2014-06-06","2014-06-06",2,0,0]
["Finished",null,"  第17周","高才驰","2014-06-13","2014-06-13",2,"2014-06-13","2014-06-13",2,0,0]
["Finished",null,"  第18周","高才驰","2014-06-20","2014-06-20",1.5,"2014-06-20","2014-06-20",1.5,0,0]
["Finished",null,"  第19周","高才驰","2014-06-27","2014-06-27",1.5,"2014-06-27","2014-06-27",1.5,0,0]
["Finished",null,"  第20周","高才驰","2014-07-04","2014-07-04",1.5,"2014-07-04","2014-07-04",1.5,0,0]
["Finished",null,"  第21周","高才驰","2014-07-11","2014-07-11",1.5,"2014-07-11","2014-07-11",1.5,0,0]
["Finished",null,"  第22周","高才驰","2014-07-18","2014-07-18",1.5,"2014-07-18","2014-07-18",2,0,0.5]
["Finished",null,"  第23周","高才驰","2014-07-25","2014-07-25",1.5,"2014-07-25","2014-07-25",2,0,0.5]
["Finished",null,"  第24周","高才驰","2014-08-01","2014-08-01",1.5,"2014-08-01","2014-08-01",1.5,0,0]
["Finished",null,"  第25周","高才驰","2014-08-08","2014-08-08",1.5,"2014-08-08","2014-08-08",1.5,0,0]
["Finished",null,"  第26周","高才驰","2014-08-15","2014-08-15",1,"2014-08-15","2014-08-15",1,0,0]
["Finished",null,"项目状态报告（编制报告，召开例会）","项目团队，领导，业主","2014-02-20","2014-08-15",null,"2014-02-20","2014-08-15",null,0,0]
[{"$f":"IF(AND(B93=\"\",C93=\"\"),\"\",IF(H93=\"\",\"Wait\",IF(I93=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  第2周","项目团队，领导，业主","2014-02-28","2014-02-28",20,"2014-02-28","2014-02-28",24,0,4]
["Finished",null,"  第4周","项目团队，领导，业主","2014-03-14","2014-03-14",16,"2014-03-14","2014-03-14",16,0,0]
["Finished",null,"  第6周","项目团队，领导，业主","2014-03-28","2014-03-28",16,"2014-03-28","2014-03-28",18,0,2]
["Finished",null,"  第8周","项目团队，领导，业主","2014-04-11","2014-04-11",16,"2014-04-11","2014-04-11",16,0,0]
["Finished",null,"  第10周","项目团队，领导，业主","2014-04-25","2014-04-25",16,"2014-04-25","2014-04-25",20,0,4]
["Finished",null,"  第12周","项目团队，领导，业主","2014-05-09","2014-05-09",16,"2014-05-09","2014-05-09",20,0,4]
["Finished",null,"  第14周","项目团队，领导，业主","2014-05-23","2014-05-23",16,"2014-05-23","2014-05-23",28,0,12]
["Finished",null,"  第16周","项目团队，领导，业主","2014-06-06","2014-06-06",16,"2014-06-06","2014-06-06",16,0,0]
["Finished",null,"  第18周","项目团队，领导，业主","2014-06-20","2014-06-20",16,"2014-06-20","2014-06-20",14,0,-2]
[{"$f":"IF(AND(B102=\"\",C102=\"\"),\"\",IF(H102=\"\",\"Wait\",IF(I102=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  第20周","项目团队，领导，业主","2014-07-04","2014-07-04",16,"2014-07-04","2014-07-04",16,{"$f":"IF(OR(F102=0,I102=0),0,I102-F102)","v":0},{"$f":"IF(OR(G102=0,J102=0),0,J102-G102)","v":0}]
["Finished",null,"  第22周","项目团队，领导，业主","2014-07-18","2014-07-18",16,"2014-07-18","2014-07-18",16,0,0]
["Finished",null,"  第24周","项目团队，领导，业主","2014-08-01","2014-08-01",16,"2014-08-01","2014-08-01",16,0,0]
["Finished",null,"  第26周","项目团队，领导，业主","2014-08-15","2014-08-15",20,"2014-08-15","2014-08-15",20,0,0]
["Finished",null,"识别及管理项目风险","高才驰","2014-02-20","2014-08-15",null,"2014-02-20","2014-08-15",null,{"$f":"IF(OR(F106=0,I106=0),0,I106-F106)","v":0},{"$f":"IF(OR(G106=0,J106=0),0,J106-G106)","v":0}]
["Finished",null,"  需求及设计里程碑阶段","高才驰","2014-02-20","2014-04-25",12,"2014-02-20","2014-04-25",12,0,0]
["Finished",null,"  开发里程碑阶段","高才驰","2014-04-26","2014-07-25",8,"2014-04-26","2014-07-25",8,0,0]
["Finished",null,"  交付里程碑阶段","高才驰","2014-07-26","2014-08-15",4,"2014-07-26","2014-08-15",4,0,0]
["Finished",null,"识别及管理项目问题","高才驰","2014-02-20","2014-08-15",null,"2014-02-20","2014-08-15",null,0,0]
["Finished",null,"  需求与调研分析阶段","高才驰","2014-02-20","2014-04-10",5,"2014-02-20","2014-04-10",5,0,0]
["Finished",null,"  系统设计阶段","高才驰","2014-04-11","2014-04-25",2,"2014-04-11","2014-04-25",2,0,0]
["Finished",null,"  编码及测试阶段","高才驰","2014-04-26","2014-07-25",12,"2014-04-26","2014-07-25",12,0,0]
["Finished",null,"  交付与验收阶段","高才驰","2014-07-26","2014-08-15",5,"2014-07-26","2014-08-15",5,0,0]
["Finished",null,"收集和整理度量数据","高才驰","2014-02-20","2014-08-15",null,"2014-02-20","2014-08-15",null,0,0]
[{"$f":"IF(AND(B116=\"\",C116=\"\"),\"\",IF(H116=\"\",\"Wait\",IF(I116=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"  需求与调研分析阶段","高才驰","2014-02-20","2014-04-10",3,"2014-02-20","2014-04-10",3,0,0]
["Finished",null,"  系统设计阶段","高才驰","2014-04-11","2014-04-25",1,"2014-04-11","2014-04-25",1,0,0]
["Finished",null,"  编码及测试阶段","高才驰","2014-04-26","2014-07-25",5,"2014-04-26","2014-07-25",5,0,0]
["Finished",null,"  交付与验收阶段","高才驰","2014-07-26","2014-08-15",3,"2014-07-26","2014-08-15",3,0,0]
["Finished",null,"配置项状态稽核","马英虎","2014-02-20","2014-08-15",6,"2014-02-20","2014-08-15",6,0,0]
["Finished",null,"需求变更引起的需求文档修改","王晓勇，高才驰","2014-05-15","2014-05-16",8,"2014-05-15","2014-05-16",8,0,0]
["Finished",null,"需求变更引起的设计文档修改","王晓勇，高才驰","2014-05-15","2014-05-16",8,"2014-05-15","2014-05-16",8,0,0]
[{"$f":"IF(AND(B123=\"\",C123=\"\"),\"\",IF(H123=\"\",\"Wait\",IF(I123=\"\",\"Processing\",\"Finished\")))","v":"Finished"},null,"变更管理与跟踪","高才驰，袁晓冬","2014-05-15","2014-05-17",4,"2014-05-15","2014-05-17",4,{"$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-08-14","2014-08-15",8,"2014-08-14","2014-08-15",8,0,0]
["Finished",null,"项目资料整理","高才驰","2014-08-14","2014-08-15",8,"2014-08-14","2014-08-15",8,0,0]
[{"$f":"IF(AND(B126=\"\",C126=\"\"),\"\",IF(H126=\"\",\"Wait\",IF(I126=\"\",\"Processing\",\"Finished\")))","v":"Wait"},"维护",null,null,{"$f":"IF(COUNTA(E127:E128)>0,MIN(E127:E128),\"\")","v":"2014-11-01"},{"$f":"IF(COUNTA(F127:F128)>0,MIN(F127:F128),\"\")","v":"2016-10-31"},{"$f":"SUM(G127:G128)","v":240},{"$f":"IF(COUNTA(H127:H128)>0,MIN(H127:H128),\"\")","v":""},{"$f":"IF(COUNTA(I127:I128)>0,MAX(I127:I128),\"\")","v":""},{"$f":"SUM(J127:J128)","v":0},{"$f":"SUM(K127:K128)","v":0}]
[{"$f":"IF(AND(B127=\"\",C127=\"\"),\"\",IF(H127=\"\",\"Wait\",IF(I127=\"\",\"Processing\",\"Finished\")))","v":"Wait"},null,"运行维护","孙强","2014-11-01","2016-10-31",240,null,null,null,{"$f":"IF(OR(F127=0,I127=0),0,I127-F127)","v":0},0]
[{"$f":"IF(AND(B128=\"\",C128=\"\"),\"\",IF(H128=\"\",\"Wait\",IF(I128=\"\",\"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,"其他"]
["项目管理及其他"]