{"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":[[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],[0,1,0,9],[3,8,4,8],[11,2,11,3],[11,4,11,9],[12,1,12,2]]}
[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"]
[null,"实际结束日期","2014-05-21"]
[null,"状态评价"]
[null,"评价","△",null,"项目进度和工作量异常。详情参见重大偏差分析。"]
[null,null,null,"描述"]
[null,"进度","△","[评价]",{"$f":"'2.进度'!D2","v":"进度评价：里程碑进度偏差达17%，进度滞后。"}]
[null,"工作量","△","[评价]",{"$f":"'3.工作量'!D2","v":"截至本周，项目累计工作量偏差达到13.4%，超出计划工作量。"}]
[null,"质量",{"$f":"'4.质量'!B2","v":"○"},"[评价]",{"$f":"'4.质量'!D2","v":"截止目前，暂无质量数据；"}]
[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]]}
["项目进度"]
["评价","△","描述","进度评价：里程碑进度偏差达17%，进度滞后。"]
{"$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}]
[{"$nulls":4},{"$f":"D28-C28","v":0},{"$f":"E28/(C28-B28)","v":{"$error":"#DIV/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]]}
["工作量情况"]
["评价","△","描述","截至本周，项目累计工作量偏差达到13.4%，超出计划工作量。"]
{"$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]
[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,{"$f":"IF(B35=\"\",\"\",(C35-B35)/B35)","v":""},{"$nulls":8},0.1,-0.1]
[null,null,null,"",{"$nulls":8},0.1,-0.1]
[null,null,null,{"$f":"IF(B37=\"\",\"\",(C37-B37)/B37)","v":""},{"$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]
[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、Bug状况"]
[" Bug数(件)","每周发现","每周修改","累计"]
["每周",null,null,"总数","修改数","残余数"]
[{"$nulls":5},{"$f":"D12-E12","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},{"$f":"D15-E15","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
["2、缺陷密度"]
["(说明：该表填写时间为一个测试阶段结束，达成率在0.8~1.2之间均为正常）"]
["BUG状况","BUG总数（件）","代码行（KL）","缺陷密度（件/KL）","项目目标","目标达成率"]
["发现阶段"]
[null,null,null,{"$f":"(B24/C24)*1000","v":{"$error":"#DIV/0!"}},null,{"$f":"D24/E24","v":{"$error":"#DIV/0!"}}]
[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,"□项目估算"]
["异常原因分析及影响说明","进度延迟的原因主要２方面：\n1、 由于大屏图表需求是新增需求，此部分需求与用户没有充分沟通，导致设计工作存在返工。\n2、大屏图表需要在现场实地调试大屏确认详细参数，而现场的大屏在用户工作时间不能使用，所以基本上只能晚上使用，影响工作效率。\n"]
[]
["应对措施","1、 催促客户确认基本设计方针。\n2、 增加现场调试人员，通过白班和晚班交班的形式加快大屏联调的进度。\n"]
[]
["高层项目经理意见","1、 给项目增加2名开发人员，按照确认完毕的基本设计方针修改。\n2、 对于此次的教训，应分析在下次如何能够避免或者缓解。另外，把这次在设计前期未能发现的问题整理，补充到Checklist或者注意事项中，防止下次再犯同类问题。"]
[]
["解决状况","1、 5月12日已确认基本设计方针。\n2、 为了确保可以按期交付，需要增补2名人员按照确认完毕的基本设计方针修改，预计到8月20日结束。项目组其他人员继续按照原计划作业。\n"]