{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["封面","变更履历","概要","测试质量","测试工作量","遗留问题分析表","经验和教训","总体总结"],"not_rendered":{"charts":23,"images":1,"macros":0,"external_links":13,"defined_names":255,"comments":5,"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":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,27,7],[12,0,12,7],[14,0,14,7],[2,0,2,6],[3,0,3,4],[3,6,3,7],[10,0,10,7]]}
[]
[]
["文档编号："]
{"$rows_empty":7}
["质量保障平台v4.4产品化维护项目\n（SINYD_SW16004）"]
[]
["测试总结报告(版本v1.0)"]
{"$rows_empty":13}
["沈阳新一代信息技术有限公司\n研发中心  2016-4-7"]

{"sheet":"变更履历","index":1,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["模板变更履历"]
[]
[null,"时间","版本","作者","审核","变更内容"]
[null,"2016-09-30","V1.0","李秋香",null,"创建此文档"]

{"sheet":"概要","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[19,8,19,9],[26,3,26,7],[2,1,7,7],[8,1,11,7],[15,8,15,9],[14,8,14,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[31,8,31,9],[20,8,20,9],[21,8,21,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[28,8,28,9],[29,8,29,9],[27,1,27,9],[24,3,24,7],[25,3,25,7]]}
[]
[null,"1.目的目标"]
[null,"目的：\n1.规范编写测试用例模板、测试执行的流程\n2.做好计划工作，对测试策略、工作量、人员安排、其他部门的依赖、测试环境等做好准备\n3.根据计划，按时完成相应的工作，并记录实际完成时间\n4.保证测试工作顺利有效的进行，从而更好的保证项目质量\n5.根据计划和实际的对比情况，可以有效的对项目或测试阶段存在风险进行评估、处理",{"$nulls":7},"*模板颜色含义说明："]
[{"$nulls":9},"策划时填写"]
[{"$nulls":9},"跟踪时填写"]
[{"$nulls":9},"表格标题，不能修改"]
[{"$nulls":9},"固定数据，不能修改"]
[{"$nulls":9},"备注/说明等 (白色) ，策划、跟踪时都可填写"]
[null,"说明：\n测试资产保留请参考对应研发项目的配置管理计划。\n测试用例地址：http://192.168.1.206/svn/技术中心项目库\\03_质量保障平台V4.4产品化\\02_项目文档\\04_测试。\n缺陷存放地址：http://192.168.1.162:8080/redmine/projects/sw_-v4-4/issues/"]
[]
[]
[]
[]
[null,"2.日程安排",null,"工作量单位:人天"]
[null,"测试阶段","计划开始日期","计划结束日期","计划工作量","实际开始日期","实际结束日期","实际工作量","参加人员"]
[null,"需求理解","2016-04-20","2016-09-29",2,"2016-04-28","2016-08-17",1.5,"测试组"]
[null,"测试设计","2016-04-20","2016-09-30",7,"2016-04-28","2016-08-24",7,"测试组"]
[null,"环境部署","2016-04-20","2016-09-30",2,"2016-04-28","2016-09-29",3,"李秋香、王金铭"]
[null,"第一轮测试周期","2016-04-28","2016-09-30",25,"2016-05-04","2016-09-29",26.5,"测试组"]
[null,"会议及其他沟通","2016-04-20","2016-09-30",1,"2016-04-28","2016-09-29",1,"测试组"]
[null,"测试总结","2016-09-30","2016-10-08",2,"2016-09-30","2016-10-08",1,"李秋香"]
[null,"合计",null,null,{"$f":"SUM(E16:E21)","v":39},null,null,{"$f":"SUM(H16:H21)","v":40}]
[]
[null,"3.人员安排及工作量",null,"工作量单位:人天","每人天=",7.5]
[null,"角色","负责人","主要任务",{"$nulls":4},"备注"]
[null,"Tester Leader","李秋香","测试计划编写、需求评审、测试人员任务创建与分配、测试用例编写及评审、测试用例执行、提交缺陷任务并验证、编写测试总结报告。"]
[null,"Tester1","孙雪晶","测试用例编写及评审、测试用例执行、提交缺陷任务并验证"]
[]
[null,"人员","计划投入日期","计划脱离日期","计划工作量","实际投入日期","实际脱离日期","实际工作量","备注"]
[null,{"$f":"C26","v":"李秋香"},"2016-04-11","2016-10-08",29,"2016-04-28","2016-10-08",29]
[null,{"$f":"C27","v":"孙雪晶"},"2016-04-11","2016-09-30",10,"2016-05-04","2016-09-27",11]
[null,"合计",null,null,{"$f":"SUM(E30:E31)","v":39},null,null,{"$f":"SUM(H30:H31)","v":40}]

{"sheet":"测试质量","index":3,"n_rows":96,"n_cols":7,"rows_kept":96,"cut":false,"hidden":false,"merged":[[2,2,2,3],[4,2,4,3],[5,2,5,3],[9,2,9,3],[13,2,13,4],[10,2,10,3],[11,2,11,3],[8,2,8,3],[3,2,3,3],[95,2,99,6],[64,2,64,6],[57,2,60,4],[21,2,25,4],[28,2,28,4],[36,2,40,4],[43,2,43,4]]}
[null,"测试质量"]
[]
[]
[null,null,"提交bug总数",null,98]
[null,null,"有效bug总数",null,93]
[null,null,"bug有效率",null,{"$f":"E5/E4","v":0.94897959183673475}]
[]
[null,null,"关闭bug数",null,94]
[null,null,"遗留bug数",null,4]
[null,null,"遗留bug比率",null,{"$f":"E9/E5","v":4.3010752688172046E-2}]
[]
[null,null,"测试用例数",null,335]
[]
[null,null,"按问题等级统计数据"]
[null,null,"等级","bug数","比例"]
[null,null,"紧急",1,{"$f":"IF($D$21>0,D16/$D$21,\"\")","v":1.0752688172043012E-2}]
[null,null,"高级",26,0.27956989247311825]
[null,null,"中级",40,0.43010752688172044]
[null,null,"低级",20,0.21505376344086022]
[null,null,"建议",6,6.4516129032258063E-2]
[null,null,"合计",{"$f":"SUM(D16:D20)","v":93},1]
[null,null,"原因分析：\n此项目中级bug占比较大，主要是一些次级功能不满足等情况，由于涉及到后台分析的bug一般都为高级bug，所以高级问题也比较多，总体bug分布正常。"]
[]
[]
[]
[]
[]
[]
[null,null,"按问题类型统计数据"]
[null,null,"类型","bug数","比例"]
[null,null,"功能",83,{"$f":"IF($D$36>0,D31/$D$36,\"\")","v":0.89247311827956988}]
[null,null,"性能",0,0]
[null,null,"规范性",10,0.10752688172043011]
[null,null,"安全性",0,0]
[null,null,"需求问题",0,0]
[null,null,"合计",{"$f":"SUM(D31:D35)","v":93},1]
[null,null,"原因分析：\n此项目性能基本未测试；安全性测试主要针对系统访问权限，无问题；bug主要存在功能与规范性类型中，规范性问题主要是新增页面字段以及图表显示不规范，本次测试的重点还是针对功能进行全面测试，所以BUG相对集中"]
[]
[]
[]
[]
[]
[]
[null,null,"按系统模块统计数据"]
[null,null,"系统模块","bug数","比例"]
[null,null,"系统整体",4,{"$f":"IF($D$57>0,D46/$D$57,\"\")","v":4.3010752688172046E-2}]
[null,null,"业务端-系统管理",2,2.1505376344086023E-2]
[null,null,"业务端_水泥混凝土生产",8,8.6021505376344093E-2]
[null,null,"业务端-沥青混合料生产",23,0.24731182795698925]
[null,null,"业务端-改性沥青生产",1,1.0752688172043012E-2]
[null,null,"业务端-设备管理",4,4.3010752688172046E-2]
[null,null,"业务端-采购管理",1]
[null,null,"监控端-水泥混凝土监控",14,{"$f":"IF($D$57>0,D53/$D$57,\"\")","v":0.15053763440860216}]
[null,null,"监控端-沥青混合料监控",29,{"$f":"IF($D$57>0,D54/$D$57,\"\")","v":0.31182795698924731}]
[null,null,"监控端-综合监控",2,{"$f":"IF($D$57>0,D55/$D$57,\"\")","v":2.1505376344086023E-2}]
[null,null,"沥青后台分析",5,{"$f":"IF($D$57>0,D56/$D$57,\"\")","v":5.3763440860215055E-2}]
[null,null,"合计",{"$f":"SUM(D46:D56)","v":93},{"$f":"IF($D$57>0,D57/$D$57,\"\")","v":1}]
[null,null,"原因分析：\n本次主要修改的是沥青多数据源融合以及沥青生产预警相关的模块，所以bug大多数集中在此模块，水泥生产相关的bug主要是数据对比功能的修改和大数据过程曲线分析部分，其他模块主要是测试代码混淆时随机测试发现的问题。\n"]
[]
[]
[]
[]
[]
[]
[null,null,"按测试版本统计数据"]
[null,null,"版本号","提交bug数","比例","关闭bug数","比例"]
[null,null,"4.4.8.a",15,{"$f":"IF($D$95>0,D67/$D$95,\"\")","v":0.16129032258064516},1,{"$f":"IF($F$95>0,F67/$F$95,\"\")","v":1.1235955056179775E-2}]
[null,null,"4.4.8.b",7,7.5268817204301078E-2,14,0.15730337078651685]
[null,null,"4.4.8.c",1,1.0752688172043012E-2,7,7.8651685393258425E-2]
[null,null,"4.4.8.d",1,1.0752688172043012E-2,0,0]
[null,null,"4.4.8.e",4,4.3010752688172046E-2,2,2.247191011235955E-2]
[null,null,"4.4.8.f",1,1.0752688172043012E-2,4,4.49438202247191E-2]
[null,null,"4.4.8.g",0,0,1,1.1235955056179775E-2]
[null,null,"4.4.8.h",2,2.1505376344086023E-2,0,0]
[null,null,"4.4.8.i",6,6.4516129032258063E-2,2,2.247191011235955E-2]
[null,null,"4.4.8.j",0,0,5,5.6179775280898875E-2]
[null,null,"4.4.8.k",0,0,0,0]
[null,null,"4.4.8.l",4,4.3010752688172046E-2,3,3.3707865168539325E-2]
[null,null,"4.4.9.a",2,2.1505376344086023E-2,3,3.3707865168539325E-2]
[null,null,"4.4.9.b",0,0,1,1.1235955056179775E-2]
[null,null,"4.4.9.c",6,6.4516129032258063E-2,1,1.1235955056179775E-2]
[null,null,"4.4.9.d",1,1.0752688172043012E-2,3,3.3707865168539325E-2]
[null,null,"4.4.9.e",2,2.1505376344086023E-2,4,4.49438202247191E-2]
[null,null,"4.4.9.f",10,0.10752688172043011,3,3.3707865168539325E-2]
[null,null,"4.4.9.g",0,0,1,1.1235955056179775E-2]
[null,null,"4.4.10.a",8,8.6021505376344093E-2,4,4.49438202247191E-2]
[null,null,"4.4.10.b",2,2.1505376344086023E-2,6,6.741573033707865E-2]
[null,null,"4.4.10.c",0,0,3,3.3707865168539325E-2]
[null,null,"4.4.10.d",9,9.6774193548387094E-2,0,0]
[null,null,"4.4.10.e",3,3.2258064516129031E-2,10,0.11235955056179775]
[null,null,"4.4.10.f",2,2.1505376344086023E-2,3,3.3707865168539325E-2]
[null,null,"4.4.10.g",4,4.3010752688172046E-2,1,1.1235955056179775E-2]
[null,null,"4.4.10.h",0,0,5,5.6179775280898875E-2]
[null,null,"4.4.10.i",3,3.2258064516129031E-2,2,2.247191011235955E-2]
[null,null,"合计",{"$f":"SUM(D67:D94)","v":93},1,{"$f":"SUM(F67:F94)","v":89},1]
[null,null,"原因分析：\n此项目主要是4.4产品化的维护项目，4.4.8.x版本有新功能发布，所以前两个版本提交的bug较多，4.4.8.i版本增加数据对比功能，4.4.9.f版本修改了水泥和沥青的后台分析功能，4.4.10.a版本为第一个代码混淆版本，4.4.10.d版本新增了沥青级配超限指标，修改了后台分析，所以bug也较多；每次提交bug较多的下个版本通常为bug验证版本，所以关闭的bug较多；由于此项目为维护项目，所以bug版本分布不均，属正常现象。"]

{"sheet":"测试工作量","index":4,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,9,3,10],[3,13,3,14],[3,11,3,12],[4,11,4,12],[4,13,4,14],[8,1,8,14],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,3,9,14],[18,1,18,14],[19,1,19,14],[9,1,11,2],[14,1,14,2],[15,1,15,14],[12,1,12,2],[13,1,13,2],[0,1,0,12],[1,1,1,14],[7,1,7,14],[2,1,3,1],[3,3,3,4],[6,3,6,4],[3,5,3,6],[2,7,2,14],[2,2,2,6],[4,9,4,10],[6,5,6,6],[6,9,6,10],[6,11,6,12],[6,13,6,14],[4,3,4,4],[4,5,4,6],[5,3,5,4],[5,5,5,6],[5,9,5,10],[5,11,5,12],[5,13,5,14]]}
[null,"测试工作量"]
[null,"1、总表"]
[null,"测试人员","测试设计",{"$nulls":4},"测试执行"]
[null,null,"用例设计个数(条)","用例设计工作量\n(小时)",null,"用例设计效率\n(用例数/人日)",null,"提交Bug个数(个)","用例执行个数(条)","测试执行工作量\n(小时)",null,"BUG提交效率\n(BUG/人日)",null,"用例执行效率\n(用例数/人日)"]
[null,"李秋香",218,45.5,null,{"$f":"ROUND(C5/(D5/7.5),1)","v":35.9},null,59,218,135.5,null,{"$f":"ROUND(H5/(J5/8),1)","v":3.5},null,{"$f":"ROUND(I5/(J5/8),1)","v":12.9}]
[null,"孙雪晶",127,14,null,{"$f":"ROUND(C6/(D6/7.5),1)","v":68},null,34,127,71.599999999999994,null,{"$f":"ROUND(H6/(J6/8),1)","v":3.8},null,{"$f":"ROUND(I6/(J6/8),1)","v":14.2}]
[null,"合计",{"$f":"SUM(C5:C6)","v":345},{"$f":"SUM(D5:E6)","v":59.5},null,{"$f":"ROUND(C7/(D7/8),1)","v":46.4},null,{"$f":"SUM(H5:H6)","v":93},{"$f":"SUM(I5:I6)","v":345},{"$f":"SUM(J5:K6)","v":207.1},null,{"$f":"ROUND(H7/(J7/8),1)","v":3.6},null,{"$f":"ROUND(I7/(J7/8),1)","v":13.3}]
[]
[null,"2、Bug提交按级别统计"]
[null,"测试人员",null,"提交Bug个数及比例(个)"]
[null,null,null,"紧急",null,"高",null,"中",null,"低",null,"建议",null,"小计"]
[null,null,null,"个数","比例","个数","比例","个数","比例","个数","比例","个数","比例","个数","比例"]
[null,{"$f":"B5","v":"李秋香"},null,1,{"$f":"IF($D$15=0,0,D13/$D$15)","v":1},17,{"$f":"IF($F$15=0,0,F13/$F$15)","v":0.65384615384615385},30,{"$f":"IF($H$15=0,0,H13/$H$15)","v":0.75},9,{"$f":"IF($J$15=0,0,J13/$J$15)","v":0.45},2,{"$f":"IF($L$15=0,0,L13/$L$15)","v":0.33333333333333331},{"$f":"D13+F13+H13+J13+L13","v":59},{"$f":"IF($N$15=0,0,N13/$N$15)","v":0.63440860215053763}]
[null,{"$f":"B6","v":"孙雪晶"},null,0,{"$f":"IF($D$15=0,0,D14/$D$15)","v":0},9,{"$f":"IF($F$15=0,0,F14/$F$15)","v":0.34615384615384615},10,{"$f":"IF($H$15=0,0,H14/$H$15)","v":0.25},11,{"$f":"IF($J$15=0,0,J14/$J$15)","v":0.55000000000000004},4,{"$f":"IF($L$15=0,0,L14/$L$15)","v":0.66666666666666663},{"$f":"D14+F14+H14+J14+L14","v":34},{"$f":"IF($N$15=0,0,N14/$N$15)","v":0.36559139784946237}]
[null,"项目组汇总",null,{"$f":"SUM(D13:D14)","v":1},{"$f":"IF($D$15=0,0,D15/$D$15)","v":1},{"$f":"SUM(F13:F14)","v":26},{"$f":"IF($F$15=0,0,F15/$F$15)","v":1},{"$f":"SUM(H13:H14)","v":40},{"$f":"IF($H$15=0,0,H15/$H$15)","v":1},{"$f":"SUM(J13:J14)","v":20},{"$f":"IF($J$15=0,0,J15/$J$15)","v":1},{"$f":"SUM(L13:L14)","v":6},{"$f":"IF($L$15=0,0,L15/$L$15)","v":1},{"$f":"SUM(N13:N14)","v":93},{"$f":"IF($N$15=0,0,N15/$N$15)","v":1}]
[]
[]
[null,"3.工作量状况总体总结"]
[null,"总体总结（对上述工作量数据进行总体说明或分析）"]
[null,"1.本测试从需求分析阶段开始，即对需求进行学习后进行测试，因为没有准确的需求以及设计文档，在测试中反复沟通的时间花费较长；\n2.由于测试用例很多都是基于4.4产品化项目已有用例，新增用例数较少；\n3.由于测试人员分工不同，所以用例执行效率与bug的提交效率均不相同；\n\n\n"]

{"sheet":"遗留问题分析表","index":5,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,11,6,11]]}
[null,"遗留问题分析表"]
[]
[null,"序号","问题描述","等级","时机","频率","遗留原因","遗留确认人","遗留确认日期","遗留风险","后继措施","遗留问题原因总体分析"]
[null,11001,"【业务端-水泥混凝土生产】sys_upload_track表未按设备区分，当序号比当前上传大时， 导致不上传新的数据","建议","首次出现","操作即出现","sys_upload_track目前仅供大数据上传使用，因现场多为单一设备且目前试点已接近尾声，又因后续会将使用新传输框架，该问题出现几率较小，赞不修改此问题","王金茗","2016-09-30","一般","后续解决","遗留问题级别较低，有些是页面美观性问题，功能缺陷基本可以通过其他方式避免，可以遗留，在以后的项目里进行修改。"]
[null,9531,"【业务端-改性沥青生产】导出功能未按查询结果导出而是按查询条件导出（沥青混合料也有相同问题）","低级","首次出现","操作即出现",null,"王金茗","2016-09-30","轻微","后续解决"]
[null,9364,"【监控端-生产汇总】设置料仓为水泥仓和石粉仓设置为水泥，回收石粉仓设置为回收石粉，三个仓都插入数据，生产汇总页面，总量配比验证详情统计错误","中级","首次出现","操作即出现","此问题，已和业务达成一致，暂不做修改","刘长波","2016-09-30","一般","后续解决"]
[null,8853,"【生产施工-沥青混合料生产】预警指标设置页面行间距不一致，建议页面行间距保持一致、美观","建议","首次出现","操作即出现",null,"王金茗","2016-09-30","轻微","后续解决"]

{"sheet":"经验和教训","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"经验",null,"*推荐给组织的好的经验或做法"]
[null,"序号","内容描述","影响","特定环境及其它说明"]
[null,1,"测试过程从需求明确时开始进行","更有效的提高了工作效率，有利于测试人员更快更准确地理解并掌握需求的内容","需求暂时确定时测试人员学习并参加需求的评审会议"]
[null,2,"在其他项目基础上修改用例，只增加新功能部分，其他相关模块可以参考4.4项目","可以节省用例编写的时间"]
[null,3,"与需求及开发确认的细节问题记录到问题跟踪表","方便以后查找对应"]
[null,4]
[null,5]
[null,"教训",null,"*分享给组织的失败经历教训等"]
[null,"序号","内容描述","影响","特定环境及其它说明"]
[null,1,"需求不够细致，相关文档不全","导致测试浪费大量的时间去确认具体细节"]
[null,2,"测试环境较复杂，测试大数据时历史数据有影响","多次清库，导致历史数据较少，有些历史数据问题无法被发现"]

{"sheet":"总体总结","index":7,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,4],[11,1,15,6],[16,1,22,6],[2,1,2,3],[2,4,2,6],[0,1,0,6],[8,1,10,6],[7,2,7,3],[4,2,4,6],[7,5,7,6],[3,2,3,3],[3,5,3,6]]}
[null,"总体总结"]
[]
[null,"项目名称（项目编号）",null,null,{"$f":"封面!A11","v":"质量保障平台v4.4产品化维护项目\n（SINYD_SW16004）"}]
[null,"项目经理","王金茗",null,"测试组长","李秋香"]
[null,"参加测试人员","李秋香、孙雪晶"]
[null,"计划开始时间","2016-04-20","计划结束时间","2016-09-30","计划工作量",39]
[null,"实际开始时间","2016-04-28","实际结束时间","2016-10-08","实际工作量",40]
[null,"进度偏差",{"$f":"((E7-C7)-(E6-C6))/(E6-C6)","v":0},null,"工作量偏差",{"$f":"(G7-G6)/G6","v":2.564102564102564E-2}]
[null,"发布内容：\n本次发布版本号：5.0.0.0\n程序存放地址：http://192.168.1.206/svn/技术中心项目库/03_质量保障平台V4.4产品化/02_项目文档/05_发布/02_正式版本/5.0.0.0\n部署说明文件存放地址："]
[]
[]
[null,"软件综合评价：\n\n   质量保障平台4.4产品化维护项目在进行一轮系统测试后，系统基本实现需求中所要求的各功能且可以正常运行，性能方面过程数据分析传输速率有待加强。由于测试中使用的拌和站模拟软件，许多现场的情况无法模拟，所以开发的软件产品仍存在一定的潜在风险。"]
[]
[]
[]
[]
[null,"测试工作评价：\n\n    由于测试工作需要基于明确的需求以及开发环节的顺利进行，所以设计文档如果不完善必须由测试人员进行沟通、确认，所以沟通成本比预计的要多。\n    本次测试基本符合计划，进度和工作量基本无偏差。\n\n    总体来说： 在与各部门协调、协作之下完成了本项目测试工作产品基本满足需求，但是性能方面有一定的风险；项目中的沟通成本较大，需要在后续项目进行合理的控制。"]
[]
[]
[]
[]
[]
[]
[null,"项目经理：王金茗"]
[null,"开发组长：王金茗"]
[null,"测试组长：李秋香"]
[null,"测试成员：孙雪晶"]