{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["封面 ","项目属性","人员","规模","工作量 ","进度","质量跟踪—测试BUG","质量跟踪—评审缺陷","质量跟踪-问题","质量跟踪—不符合项"],"not_rendered":{"charts":11,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"封面 ","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[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],[1,0,2,7]]}
[]
["上海柏维信息技术有限公司"]
[]
[]
["项目度量数据表"]
[]
[]
[{"$nulls":4},"文件编号：","MPM_DataSheet"]
[{"$nulls":4},"版本：","1.0"]
[{"$nulls":4},"用户：","内部员工"]
[{"$nulls":4},"分类：","模板"]
[]
[{"$nulls":4},"状态：","正式发布"]
[{"$nulls":4},"密级：","内部公开"]
[]
["文档信息"]
["创建日期：","2023-3-12",null,"更新日期：2023-3-12"]
["编制：","杨国强\n",null,"生效日期：2023-3-12"]
["审核：","胡志军\n",null,"批准：陆军"]
[]
["修订文档历史记录"]
["日期","版本号","修订说明",null,null,"修订人","审核人","批准人"]
["2023-3-12","1.0","创建",null,null,"胡志军\n","胡志军\n","陆军"]

{"sheet":"项目属性","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["项目属性"]
[]
["#","项目ID"]
[1,"项目名称"]
[2,"项目选用生命周期"]
[3,"应用领域"]
[4,"项目类型"]
[5,"客户"]
[6,"技术"]
[7,"软件类型"]
[8,"硬件平台"]
[9,"采用的语言"]
[10,"采用的数据库"]
[11,"项目所属部门"]
[12,"项目经理"]
[13,"项目组成员"]
[14,"项目工期"]
[15,"项目风险信息"]
[16,"项目概述"]
[17,"本报告制作及维护人"]
[18,"本报告初次填写时间"]
[19,"本报告末次填写时间"]

{"sheet":"人员","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,3],[15,0,15,2],[27,0,27,2]]}
["人员度量统计分析报告"]
[]
["度量一：各阶段参与人员数"]
["目的：度量各阶段开发人员数量，为计划时安排资源提供输入"]
["度量单位：阶段开发人员数（按人次计）"]
["阶段","计划人数","实际人数"]
["计划"]
["需求"]
["概设"]
["详设"]
["编码"]
["测试"]
["试运行"]
[]
["人员偏差分析说明："]
["无偏差"]
[]
["注：按人员最多时的人数计算"]
[]
["度量二：项目人员总数统计（按实际人员发生数计）"]
["目的：度量项目中人员分布情况，为项目配置合理的人力资源。"]
["度量单位：人数"]
["管理人员总数",null,{"$f":"B23/B26","v":{"$error":"#DIV/0!"}}]
["开发人员总数",null,{"$f":"B24/B26","v":{"$error":"#DIV/0!"}}]
["支持人员总数",null,0.33300000000000002]
["人员总数",{"$f":"SUM(B23:B25)","v":0}]
[]
["从本数据可以看出，项目管理人员较少，直接导致了项目控制有问题，项目计划编制，需求阶段的获取等等存在一定的计划问题，后续应该加强项目管理相关知识的培训，使得项目组成员有能力进行自我项目管理，提供项目执行的效率。"]
["注："]
["1、项目中，某人即担任项目经理又担任开发人员，则管理人员总数加1，开发人员总数加1，人员总数加1。"]
["2、项目中，某人担任项目经理，配置人员、开发人员三个角色，则管理人员总数加1，开发人员总数加1，人员总数加1。"]
["3、项目中，某人即担任配置人员，又担任开发人员二个角色，则管理人员总数加1，开发人员总数加1，人员总数加1。"]
["4、项目中，某人即担任需求调研人员又担任设计人员，则开发人员总数加1，人员总数加1。"]

{"sheet":"规模","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2],[15,0,15,4]]}
["规模度量统计分析报告"]
[]
["度量一：软件产品规模的度量"]
["目的：比较估计规模的准确性并用以调整计划。"]
["度量单位：功能点"]
["#","工作模块","计划","实际值","偏差"]
[1,null,null,null,{"$f":"IF(C7<>\"\",C7-D7,\"\")","v":""}]
[2,null,null,null,{"$f":"IF(C8<>\"\",C8-D8,\"\")","v":""}]
[3,null,null,null,""]
[4,null,null,null,""]
[5,null,null,null,""]
[6,null,null,null,""]
[7,null,null,null,""]
[8,null,null,null,""]
["偏差分析及改进措施：","数据库备份管理",{"$f":"SUM(C7:C14)","v":0},{"$f":"SUM(D7:D14)","v":0},0]
["经过分析，发现，基本都是模块的细分不够，模块相对比较复杂，还可以再进一步分解，这在WBS分解的时候就没有分解清楚，建议偏差项较多的时候可以采取再次估算的工作。"]

{"sheet":"工作量 ","index":4,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,13],[3,2,3,5],[12,0,15,13]]}
["阶段工作量分布"]
["目的：了解各阶段实际和计划工作量的偏差，衡量项目估算的准确性，为今后的项目估算带来历史数据。了解生命周期各阶段的工作量占整个项目工作量的百分比，从而为今后的项目划分工作量带来历史数据。"]
["度量单位：人天"]
["阈值：",0.20,"一旦项目工作量偏差大于20%，项目需要采取措施纠正偏差"]
[]
["阶段","计划","需求","详细设计","项目实现","测试","发布","合计"]
["阶段计划",{"$nulls":6},{"$f":"SUM(B7:G7)","v":0}]
["阶段实际",{"$nulls":6},{"$f":"SUM(B8:G8)","v":0}]
["偏差",{"$f":"B8-B7","v":0},0,0,0,0,0,0]
["偏差率",{"$f":"B9/B7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"H9/H8","v":{"$error":"#DIV/0!"}}]
[]
["各阶段偏差分析及改进措施："]
{"$rows_empty":34}
["数据来源：数据来源于《项目计划》及每周的周会记录，里程碑会议记录和里程碑报告"]

{"sheet":"进度","index":5,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["进度"]
["目的：控制项目的进度（瀑布型项目适用）"]
["度量单位：天"]
["阶段","计划开始时间","计划完成时间","实际开始时间","实际完成时间","偏差天数","偏差原因","纠正措施","纠正结果"]
["计划阶段",{"$nulls":4},{"$f":"E5-C5","v":0}]
["需求阶段",{"$nulls":4},0]
["详细设计",{"$nulls":4},0]
["项目实现",{"$nulls":4},0]
["测试阶段",{"$nulls":4},0]
["发布阶段",{"$nulls":4},0]
[]
["数据来源：数据来源于《项目计划》及每周的周会记录，里程碑会议记录和里程碑报告"]

{"sheet":"质量跟踪—测试BUG","index":6,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,17],[9,1,9,8],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[48,1,57,9]]}
[]
[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,"单元测试",{"$nulls":4},{"$f":"D16*4+E16*1+F16*0.5","v":0},{"$f":"G16","v":0},{"$f":"G16/规模!$D$15","v":{"$error":"#DIV/0!"}}]
[null,"集成测试",{"$nulls":4},{"$f":"D17*4+E17*1+F17*0.5","v":0},{"$f":"G17","v":0},{"$f":"G17/规模!$D$15","v":{"$error":"#DIV/0!"}}]
[null,"系统测试",{"$nulls":4},0,0,{"$f":"G18/规模!$D$15","v":{"$error":"#DIV/0!"}}]
[null,"试运行验收测试",{"$nulls":4},0,0,{"$f":"G19/规模!$D$15","v":{"$error":"#DIV/0!"}}]
[null,"合计",{"$nulls":4},{"$f":"SUM(G16:G19)","v":0},0,{"$f":"G20/规模!$D$15","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":19}
[null,"分析项：BUG密度"]
[]
[null,"目的：了解产品的缺陷情况，提高产品质量和掌握缺陷分布"]
[]
[null,"公式：BUG密度=BUG数/规模"]
[]
[]
[]
[]
[null,"结项分析：\n从测试的缺陷分布和严重等级表可以看出，在项目的生命周期内，BUG的总体发生情况可控，严重等级的BUG很少，说明项目质量稳定可靠；一般等级的缺陷占据大的百分比，说明项目中需要进行总结经验教训，减少BUG数。\n单元测试阶段BUG密度为0.05个/简单功能点，远小于度量目标中的0.5个/简单功能点，在允许范围之内。      \n集成测试阶段BUG密度为0.05个/简单功能点，远小于度量目标中的0.2个/简单功能点，在允许范围之内。      \n系统测试BUG密度为0.03个/简单功能点，远小于度量目标中的0.2个/简单功能点，在允许范围之内。        \n验收测试阶段BUG密度为0个/简单功能点，远小于度量目标中的0.1个/简单功能点，在允许范围之内。"]

{"sheet":"质量跟踪—评审缺陷","index":7,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,0,1,10],[10,1,10,9],[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],[43,1,43,2],[43,4,43,5],[44,1,44,2],[44,4,44,5],[45,1,45,2],[45,4,45,5],[46,1,46,2],[46,4,46,5],[47,1,47,2],[47,4,47,5],[48,1,48,2],[48,4,48,5],[49,1,49,2],[49,4,49,5],[50,1,50,2],[50,4,50,5],[51,1,51,2],[51,4,51,5],[81,1,81,9],[14,3,15,3],[41,3,42,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[41,6,42,6],[14,7,15,7],[41,7,42,7],[14,8,15,8],[41,8,42,8],[41,1,42,2],[41,4,42,5]]}
[]
["质量跟踪-评审缺陷"]
[]
[]
[null,"度量项：评审缺陷数"]
[]
[null,"目的：了解评审发现的缺陷个数、类型、严重程度及分布"]
[]
[null,"度量单位：个（缺陷个数）"]
[]
[null,"权重系数即换算标准：1个严重缺陷=2个一般缺陷； 1个轻微缺陷=0.5个一般缺陷；\n                   "]
[]
[null,"缺陷个数统计:"]
[]
[null,null,"缺陷级别","严重","一般","轻微","缺陷发现累计","缺陷关闭累计","缺陷密度"]
[null,"阶段"]
[null,"项目策划",{"$nulls":4},{"$f":"D17*2+E17+F17*0.5","v":0},{"$f":"G17","v":0},{"$f":"H17/119","v":0}]
[null,"需求阶段",{"$nulls":4},0,0,{"$f":"H18/119","v":0}]
[null,"设计阶段",{"$nulls":4},0,0,0]
[null,"编码阶段",{"$nulls":4},0,0,0]
[null,"测试阶段",{"$nulls":4},0,0,0]
[null,"试运行及验收阶段",{"$nulls":4},0,0,0]
[null,"合计",null,{"$f":"SUM(D17:D22)","v":0},{"$f":"SUM(E17:E22)","v":0},{"$f":"SUM(F17:F22)","v":0},0,23,{"$f":"H23/规模!$D$15","v":{"$error":"#DIV/0!"}}]
{"$rows_empty":16}
[null,"\n          "]
[]
[null,"评审的文档",null,"规模页数","花费的时间（评审前的时间+会议时间）小时",null,"缺陷","评审效率","评审效果"]
[]
[null,"项目计划书",null,16,14,null,3,{"$f":"D44/E44","v":1.1428571428571428},{"$f":"G44/E44","v":0.21428571428571427}]
[null,"需求跟踪矩阵",null,4,4,null,3,{"$f":"D45/E45","v":1},{"$f":"G45/E45","v":0.75}]
[null,"需求规格说明书",null,17,6,null,4,{"$f":"D46/E46","v":2.8333333333333335},0.66666666666666663]
[null,"用户需求说明书",null,11,4,null,4,2.75,1]
[null,"概要设计说明书",null,19,5,null,3,3.7999999999999998,0.59999999999999998]
[null,"详细设计说明书",null,49,8,null,2,6.125,0.25]
[null,"单元测试用例",null,3,4,null,1,0.75,0.25]
[null,"集成测试用例",null,3,4,null,2,0.75,0.5]
[null,"系统测试用例",null,3,4,null,1,0.75,0.25]
{"$rows_empty":20}
[null,"分析项：缺陷密度"]
[]
[null,"目的：了解产品的缺陷情况，提高产品质量和掌握缺陷分布"]
[]
[null,"公式：缺陷密度=缺陷数/规模"]
[]
[]
[]
[]
[null,"结论分析：\n从评审的缺陷分布和严重等级表可以看出，在项目的整个生命周期内缺陷的总体发生情况可控，严重等级的缺陷很少，说明整个项目稳定可控；编码阶段的缺陷较多，说明项目中编码过程出现较大偏差，需分析影响编码阶段的原因（需求不稳定、设计出现偏差、编码人员技术能力），说明项目中需要进行总结经验教训。\n项目策划阶段缺陷密度为0.02个/简单功能点，远小于度量目标中的0.1个/简单功能点，在允许范围之内。       \n需求阶段缺陷密度为0.03个/简单功能点，远小于度量目标中的0.1个/简单功能点，在允许范围之内。         \n设计阶段缺陷密度为0.03个/简单功能点，远小于度量目标中的0.1个/简单功能点，在允许范围之内。         \n编码阶段缺陷密度为0.10个/简单功能点，等于度量目标中的0.1个/简单功能点，在允许范围之内，但需要总结经验，分析缺陷产生的原因。         \n测试阶段缺陷密度为0.02个/简单功能点，远小于度量目标中的0.1个/简单功能点，在允许范围之内。         \n试运行及验收阶段缺陷密度为0.01个/简单功能点，远小于度量目标中的0.1个/简单功能点，在允许范围之内。\n\n\n\n\n\n\n\n\n\n\n\n"]

{"sheet":"质量跟踪-问题","index":8,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"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]]}
[]
[]
[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,"合计",null,{"$f":"SUM(D18:D24)*2+SUM(E18:E24)+SUM(F18:F24)*0.5","v":0},null,null,{"$f":"SUM(G18:G24)*2+SUM(H18:H24)+SUM(I18:I24)*0.5","v":0}]
{"$rows_empty":20}
[null,"结项分析：\n从数据中可以看出，项目中存在的问题主要集中在需求阶段。说明项目的需求调研占据着重要地位，因考虑采用更好的需求沟通方法"]

{"sheet":"质量跟踪—不符合项","index":9,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"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]]}
[]
[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,"合计",null,{"$f":"SUM(D18:D25)*2+SUM(E18:E25)+SUM(F18:F25)*0.5","v":0},null,null,{"$f":"SUM(G18:G25)*2+SUM(H18:H25)+SUM(I18:I25)*0.5","v":0},null,null,{"$f":"SUM(J18:J25)*2+SUM(K18:K25)+SUM(L18:L25)*0.5","v":0}]
{"$rows_empty":23}
[null,"结项分析：\n从数据分析图上可以看出，不符合项的主要产生阶段是在需求阶段和设计阶段。说明项目的需求调研占据着重要地位，因考虑采用更好的需求沟通方法。同时要增加设计人员的业务能力和技术能力。"]