{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["封面","指南","成本","工作量","进度","质量跟踪—评审缺陷","质量跟踪—测试BUG","质量跟踪-问题","质量跟踪—不符合项","纳入组织财富库清单"],"not_rendered":{"charts":7,"external_links":6,"defined_names":8,"comments":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"封面","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[2,0,2,7],[4,0,4,7],[16,1,16,2],[16,3,16,4],[16,5,16,7],[17,1,17,2],[17,3,17,4],[17,5,17,7],[18,1,18,2],[18,3,18,4],[18,5,18,7],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4]],"flags":["formulas_cached_only"]}
[]
[]
["上海柏维信息技术有限公司\n供应链QXH产品研发"]
[]
["项目总结报告"]
[]
[]
[{"$nulls":4},"文件编号：","ORG_PLAN-FinalReport"]
[{"$nulls":4},"版本：","1.0"]
[{"$nulls":4},"用户：","内部员工"]
[{"$nulls":4},"分类：","模板"]
[]
[{"$nulls":4},"状态：","正式发布"]
[{"$nulls":4},"密级：","内部公开"]
[]
["文档信息"]
["创建日期：","2023-03-12",null,"更新日期：2023-3-12"]
["编制：","杨国强\n",null,"生效日期：2023-3-12"]
["审核：","陆军",null,"批准：陆军"]
[]
["修订文档历史记录"]
["日期","版本号","修订说明",null,null,"修订人","审核人","批准人"]
["2023-03-12","1.0","创建",null,null,"杨国强\n","陆军","陆军"]

{"sheet":"指南","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"merged":[[2,1,2,6],[3,1,3,6],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,6]],"flags":["formulas_cached_only"]}
[]
[null,"[项目总结报告]"]
[null,"指南"]
[null,"1. 所有度量数据要正确和及时的填写..\n2. 这些度量数据是公司历史数据库的重要输入.\n3. 这些度量为PM提供依据对项目作出决定. \n4. PM利用合适的资源来收集分析度量数据.\n5. 项目结束后要有总结会和项目总结报告."]
[]
[null,"1. 概要"]
[null,"1.1 总述                                                                                                                                                     \n描述项目总体状况.                                                                                                                                                                               1.2 主要的提交物\n主要的提交物可以从项目计划中得到.\n1.3 主要的里程碑 \n主要的里程碑可以从项目计划中得到."]
[null,"2. 工时"]
[null,"2.1  项目估算\n估算项目工数值可以从每个项目的估算工数值中得到.\n2.2  项目实际\n项目工数从TimeSheet中取得.\n2.3  该SHEET在项目达到里程碑的时候从《项目状态报告》中直接拷贝获得。"]
[null,"3. 缺陷分析"]
[null,"3.1  质量跟踪-评审缺陷\n分析项目过程中评审缺陷个数，了解项目组的工作质量和工作能力。\n3.2  质量跟踪-测试缺陷\n收集项目组的相关数据，进行分析\n3.3 质量跟踪-不符合项\n分析项目组成员对于过程改进的个人参与力度。通过不符合项的分析加强对项目成员的管理。\n3.4 问题                                                                                                     分析项目存在问题，作为经经验财富管理，避免相同问题的发生\n"]
[null,"4.项目总结"]
[null,"4.1 项目过程改进的实施情况\n4.2公司过程财富库的更新\n4.3项目组成员的相关经验教训"]

{"sheet":"成本","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,1,1,9],[5,3,6,3],[5,4,6,4],[5,5,6,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[15,1,15,2],[24,1,24,7]],"flags":["formulas_cached_only"]}
[]
[null,"成本"]
[]
[null,"成本分布统计"]
[]
[null,null,"成本","实际成本","估计成本","成本偏差率"]
[null,"阶段"]
[null,"项目立项"]
[null,"项目策划"]
[null,"需求"]
[null,"设计"]
[null,"编码"]
[null,"测试"]
[null,"试运行及验收"]
[null,"结项"]
[null,"总成本"]
[]
[]
[null,"分析项：","成本偏差率"]
[]
[null,"目的：","作为成本方面进行项目监控的主要依据，从而提高项目策划的能力"]
[]
[null,"公式：","成本偏差率={|实际成本-计划成本|/实际成本}*100%"]

{"sheet":"工作量","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,1,1,9],[5,3,6,3],[5,4,6,4],[5,5,6,5],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[15,1,15,2],[24,1,24,7]],"flags":["formulas_cached_only"]}
[]
[null,"工作量"]
[]
[null,"工作量分布统计"]
[]
[null,null,"工作量","实际工作量","估计工作量","工作量偏差率"]
[null,"阶段"]
[null,"项目立项"]
[null,"项目策划"]
[null,"需求"]
[null,"设计"]
[null,"编码"]
[null,"测试"]
[null,"试运行及验收"]
[null,"结项"]
[null,"总工作量"]
[]
[]
[null,"分析项：","工作量偏差率"]
[]
[null,"目的：","作为工作量方面进行项目监控的主要依据，从而提高项目策划的能力"]
[]
[null,"公式：","工作量偏差率={|实际工作量-计划工作量|/实际工作量}*100%"]

{"sheet":"进度","index":4,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[1,1,1,9],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[16,1,16,8]],"flags":["formulas_cached_only"]}
[]
[null,"进度"]
[]
[null,"各阶段进度统计"]
[]
[null,null,"时间","计划开始时间","计划完成时间","实际开始时间","实际完成时间","偏差天数","进度偏差率"]
[null,"阶段",{"$nulls":3},"实际开始时间"]
[null,"立项阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"策划阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"需求阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"设计阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"编码阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"测试阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"验收阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]
[null,"结项阶段",{"$nulls":5},0,{"$error":"#DIV/0!"}]

{"sheet":"质量跟踪—评审缺陷","index":5,"n_rows":52,"n_cols":9,"rows_kept":52,"merged":[[1,0,1,10],[10,1,10,9],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[24,0,24,5],[54,1,54,9]],"flags":["formulas_cached_only"]}
[]
["质量跟踪-评审缺陷"]
[]
[]
[null,"度量项：评审缺陷数"]
[]
[null,"目的：了解评审发现的缺陷个数、类型、严重程度及分布"]
[]
[null,"度量单位：个（缺陷个数）"]
[]
[null,"权重系数即换算标准：1个严重缺陷=2个一般缺陷； 1个轻微缺陷=0.5个一般缺陷；\n                   "]
[]
[null,"缺陷个数统计:"]
[]
[null,null,"缺陷级别","严重","一般","轻微","缺陷发现累计","缺陷关闭累计","缺陷密度"]
[null,"阶段"]
[null,"项目策划"]
[null,"需求阶段"]
[null,"设计阶段"]
[null,"编码阶段"]
[null,"测试阶段"]
[null,"试运行及验收阶段"]
[null,"合计"]
{"$rows_empty":16}
[null,"\n          "]
[]
[]
[]
[]
[]
[null,"分析项：缺陷密度"]
[]
[null,"目的：了解产品的缺陷情况，提高产品质量和掌握缺陷分布"]
[]
[null,"公式：缺陷密度=缺陷数/规模"]
[]
[null,null,"缺陷密度"]

{"sheet":"质量跟踪—测试BUG","index":6,"n_rows":44,"n_cols":9,"rows_kept":44,"merged":[[1,1,1,17],[9,1,9,8],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[48,1,57,9]],"flags":["formulas_cached_only"]}
[]
[null,"质量跟踪-测试BUG"]
[]
[null,"度量项：测试BUG"]
[]
[null,"目的：了解各种测试的缺陷个数、类型、严重程度及分布"]
[]
[null,"度量单位：个（BUG个数）"]
[]
[null,"权重系数即换算标准：1个严重BUG=2个一般BUG；1个轻微BUG=0.5个一般BUG"]
[]
[null,"测试BUG分布统计"]
[]
[null,null,"缺陷严重程度","严重","一般","轻微","BUG发生累计","BUG关闭累计","BUG密度"]
[null,"测试类型"]
[null,"单元测试"]
[null,"集成测试"]
[null,"系统测试"]
[null,"验收测试"]
[null,"合计"]
{"$rows_empty":19}
[null,"分析项：BUG密度"]
[]
[null,"目的：了解产品的缺陷情况，提高产品质量和掌握缺陷分布"]
[]
[null,"公式：BUG密度=BUG数/规模"]

{"sheet":"质量跟踪-问题","index":7,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,2,2,18],[15,3,15,5],[15,6,15,8],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[24,3,24,5],[24,6,24,8],[45,1,54,9]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"质量跟踪-问题"]
[]
[]
[null,"度量项：问题"]
[]
[null,"目的：了解项目中发生问题的个数、类型、严重程度及分布"]
[]
[null,"度量单位：个（问题个数）"]
[]
[null,"权重系数即换算标准： 1个严重问题=2个一般问题； 1个轻微问题=0.5个一般问题"]
[]
[null,"项目问题分布"]
[]
[null,null,"问题类型","项目内部",null,null,"项目外部"]
[null,"阶段",null,"严重","一般","轻微","严重","一般","轻微"]
[null,"立项"]
[null,"项目策划"]
[null,"需求开发"]
[null,"设计阶段"]
[null,"编码阶段"]
[null,"测试阶段"]
[null,"产品发布阶段"]
[null,"合计"]

{"sheet":"质量跟踪—不符合项","index":8,"n_rows":26,"n_cols":12,"rows_kept":26,"merged":[[1,2,1,18],[15,3,15,5],[15,6,15,8],[15,9,15,11],[25,3,25,5],[25,6,25,8],[25,9,25,11],[27,1,27,2],[27,3,27,4],[28,1,28,2],[28,3,28,4],[29,1,29,2],[29,3,29,4],[49,1,58,9]],"flags":["formulas_cached_only"]}
[]
[null,null,"质量跟踪-不符合项"]
[]
[]
[null,"度量项：不符合项"]
[]
[null,"目的：了解QA发现的不符合项个数、类型、严重程度及分布"]
[]
[null,"度量单位：个（不符合项个数）"]
[]
[null,"权重系数即换算标准： 1个严重不符合项=2个一般不符合项； 1个轻微不符合项=0.5个一般不符合项"]
[]
[null,"不符合项个数统计"]
[]
[]
[null,null,"检查类别","过程检查",null,null,"产品检查",null,null,"配置审计"]
[null,"检查范围",null,"严重","一般","轻微","严重","一般","轻微","严重","一般","轻微"]
[null,"立项"]
[null,"项目策划"]
[null,"需求"]
[null,"设计"]
[null,"实现"]
[null,"测试"]
[null,"试运行及验收"]
[null,"结项"]
[null,"合计"]

{"sheet":"纳入组织财富库清单","index":9,"n_rows":12,"n_cols":4,"rows_kept":12,"flags":["formulas_cached_only"]}
[]
[]
[null,"阶段","工作产品","组织财富库"]
{"$rows_empty":8}
[null,"项目经验总结"]