{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["1.总体评价","2.进度","3.工作量","4.质量","5.重大偏差分析"],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":2,"defined_names":54,"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":"1.总体评价","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,9],[3,8,4,8],[11,2,11,3],[11,4,11,9],[12,1,12,2],[21,2,25,9],[26,2,30,9],[21,1,25,1],[26,1,30,1],[2,1,2,9],[3,9,4,9],[3,2,3,3],[4,2,4,3],[10,1,10,9],[13,4,13,9],[14,4,14,9],[15,4,15,9],[12,3,12,9],[20,1,20,9]]}
[null,"总体评价"]
[]
[null,"项目基本信息"]
[null,"项目名称","江苏广靖锡澄高速公路营运管理平台",null,"项目经理","肖敏","高层经理","施展","当前里程碑","开发"]
[null,"当前阶段","开发",null,"测试经理","朱玲","PPQA"]
[null,"阶段","①需求与设计","②开发","③交付"]
[null,"计划开始日期","2014-04-09","2014-05-16","2014-09-01"]
[null,"计划结束日期","2014-05-15","2014-08-31","2014-09-19"]
[null,"实际开始日期","2014-04-09","2014-05-21"]
[null,"实际结束日期","2014-05-21","2014-08-31"]
[null,"状态评价"]
[null,"评价","○",null,"项目状态正常。"]
[null,null,null,"描述"]
[null,"进度","○","[评价]",{"$f":"'2.进度'!D2","v":"进度评价：本里程碑进度正常。"}]
[null,"工作量","○","[评价]",{"$f":"'3.工作量'!D2","v":"截至本周，项目累计工作量正常。"}]
[null,"质量",{"$f":"'4.质量'!B2","v":"○"},"[评价]",{"$f":"'4.质量'!D2","v":"1.截止目前，共发现198个缺陷，全部修复完毕。\n2.缺陷密度为5.12（个/千行代码）"}]
[null,"注: ","总体的质量和进度判定依据当周状况的最差判定结果为标准设定. "]
[null,"评价","○","△","×"]
[null,"对项目成功完成的影响","没有","有一定影响","严重"]
[]
[null,"经验总结"]
[null,"重大风险及问题检讨","无"]
[]
[]
[]
[]
[null,"下个里程碑工作注意事项及建议","交付期间要做好业主反馈记录。"]

{"sheet":"2.进度","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,3,1,7]]}
["项目进度"]
["评价","○","描述","进度评价：本里程碑进度正常。"]
{"$rows_empty":19}
["目的：跟踪项目目前的进展情况，确定是否有异常状况，是否需要调整项目计划。"]
["延迟率上限：",0.1,"(根据项目情况可作调整)"]
["延迟率下限：",-0.1,"(根据项目情况可作调整)"]
[]
["里程碑","计划开始日期","计划完成日期","实际完成日期","延迟天数","延迟率"]
["需求与设计","2014-04-09","2014-05-15","2014-05-21",{"$f":"D27-C27","v":6},{"$f":"E27/(C27-B27)","v":0.16666666666666666}]
["开发","2014-05-16","2014-08-31","2014-08-31",{"$f":"D28-C28","v":0},{"$f":"E28/(C28-B28)","v":0}]
[{"$nulls":4},{"$f":"D29-C29","v":0},{"$f":"E29/(C29-B29)","v":{"$error":"#DIV/0!"}}]

{"sheet":"3.工作量","index":2,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,3,1,9]]}
["工作量情况"]
["评价","○","描述","截至本周，项目累计工作量正常。"]
{"$rows_empty":16}
["目的：跟踪计划和实际的工作量，确定是否能按计划的工作量完成各项任务"]
["控制上限：",0.1,"(根据项目情况可作调整)"]
["控制下限：",-0.1,"(根据项目情况可作调整)"]
[]
["累计工作量："]
["截止日期","计划（人日）","实际（人日）","偏差率"]
["2014-04-18",34.25,33.375,{"$f":"IF(B25=\"\",\"\",(C25-B25)/B25)","v":-2.5547445255474453E-2},{"$nulls":8},{"$f":"$B$20","v":0.1},{"$f":"$B$21","v":-0.1}]
["2014-04-25",55.75,53.4375,-4.1479820627802692E-2,{"$nulls":8},{"$f":"$B$20","v":0.1},{"$f":"$B$21","v":-0.1}]
["2014-05-02",58.75,66.3125,0.12872340425531914,{"$nulls":8},0.1,-0.1]
["2014-05-09",74,70.1875,-5.1520270270270271E-2,{"$nulls":8},0.1,-0.1]
["2014-05-16",134.25,72.4375,-0.46042830540037244,{"$nulls":8},0.1,-0.1]
["2014-05-23",134.25,152.1875,0.13361266294227189,{"$nulls":8},0.1,-0.1]
["2014-05-30",134.25,152.1875,0.13361266294227189,{"$nulls":8},0.1,-0.1]
["2014-06-06",156.25,175.1875,0.1212,{"$nulls":8},0.1,-0.1]
["2014-06-13",287,286.4375,-1.9599303135888501E-3,{"$nulls":8},0.1,-0.1]
["2014-06-20",303.5,318.9375,5.0864909390444808E-2,{"$nulls":8},0.1,-0.1]
["2014-06-27",303.5,318.9375,{"$f":"IF(B35=\"\",\"\",(C35-B35)/B35)","v":5.0864909390444808E-2},{"$nulls":8},0.1,-0.1]
["2014-07-04",349.5,364.9375,4.4170243204577971E-2,{"$nulls":8},0.1,-0.1]
["2014-07-11",356.375,370.9375,{"$f":"IF(B37=\"\",\"\",(C37-B37)/B37)","v":4.0862855138547878E-2},{"$nulls":8},0.1,-0.1]
["2014-07-18",356.375,370.9375,4.0862855138547878E-2,{"$nulls":8},0.1,-0.1]
["2014-07-25",372.375,387.9375,4.1792547834843909E-2,{"$nulls":8},0.1,-0.1]
["2014-08-01",428.625,425.4375,-7.4365704286964126E-3,{"$nulls":8},0.1,-0.1]
["2014-08-08",444.625,459.4375,3.3314590947427607E-2,{"$nulls":8},0.1,-0.1]
["2014-08-15",541.375,555.9375,2.6899099515123526E-2,{"$nulls":8},0.1,-0.1]
["2014-08-22",541.875,556.4375,2.6874279123414072E-2,{"$nulls":8},0.1,-0.1]
["2014-08-29",544.375,559.4375,2.766934557979334E-2,{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[{"$nulls":12},0.1,-0.1]
[{"$nulls":12},0.1,-0.1]

{"sheet":"4.质量","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[21,2,22,2],[21,4,22,4],[21,5,22,5],[0,0,0,9],[1,3,1,9],[21,3,22,3],[9,7,9,8],[9,9,10,9],[9,1,10,1],[9,3,9,5],[9,2,10,2],[21,1,22,1]]}
["项目质量状况"]
["评价","○","描述","1.截止目前，共发现198个缺陷，全部修复完毕。\n2.缺陷密度为5.12（个/千行代码）"]
[]
[]
[]
[]
[]
[]
["1、Bug状况"]
[" Bug数(件)","每周发现","每周修改","累计"]
["每周",null,null,"总数","修改数","残余数"]
["2014-06-20",22,10,{"$f":"B12","v":22},{"$f":"C12","v":10},{"$f":"D12-E12","v":12}]
["2014-06-27",74,0,{"$f":"D12+B13","v":96},{"$f":"E12+C13","v":10},86]
["2014-07-04",0,86,{"$f":"D13+B14","v":96},96,0]
["2014-08-22",50,38,146,134,{"$f":"D15-E15","v":12}]
["2014-08-29",52,12,198,146,52]
["2014-08-31",0,52,198,198,0]
[]
[]
["2、缺陷密度"]
["(说明：该表填写时间为一个测试阶段结束，达成率在0.8~1.2之间均为正常）"]
["BUG状况","BUG总数（件）","代码行（KL）","缺陷密度（件/KL）","项目目标","目标达成率"]
["发现阶段"]
["整体测试",198,38703,{"$f":"(B24/C24)*1000","v":5.1158824897294783},5,{"$f":"D24/E24","v":1.0231764979458957}]
[null,null,null,{"$f":"IF(C25=\"\",\"\",#REF!/C25)","v":""}]

{"sheet":"5.重大偏差分析","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,0,4,5],[5,0,13,0],[5,3,13,3],[0,0,0,5],[20,0,21,0],[20,1,21,5],[14,0,15,0],[14,1,15,5],[16,0,17,0],[16,1,17,5],[18,0,19,0],[18,1,19,5]]}
["项目重大偏差分析"]
["若本里程碑延迟率或工作量偏差超过控制上下限,必须将问题及应对措施提报高层项目经理，请高层项目经理提出意见，并跟踪解决情况。"]
[]
["本里程碑未发生重大偏差。"]
["异常分析及解决"]
["发生异常的关键领域","□风险",null,"影响的流程","□项目管理"]
[null,"□客户约定",null,null,"□项目开发"]
[null,"□关键人员参与",null,null,"□风险管理"]
[null,"□需求变更",null,null,"□配置管理"]
[null,"□知识技能获取",null,null,"□采购管理"]
[null,"□生产力",null,null,"□质量保证"]
[null,"□资源获取",null,null,"□決策分析"]
[null,"□资料管理"]
[null,"□项目估算"]
["异常原因分析及影响说明"]
[]
["应对措施"]
[]
["高层项目经理意见"]
[]
["解决状况"]