{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["工作总结","不符合问题分析"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":2,"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":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["工作总结"]
[1,"项目级QA工作"]
[null,"项目名称","本月计划检查项个数","本月实际检查项个数","通过的检查项个数","未通过的检查项个数","通过率","本月检查日期","下月计划检查项个数","检查人","下月计划检查日期"]
[null,"广靖锡澄",58,58,55,3,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.94827586206896552},"2014-06-27",45,"汤柏龄","2014-07-25"]
[null,"长江隧道",55,55,52,3,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.94545454545454544},"2014-06-27",50,"汤柏龄","2014-07-25"]
[null,"港口安全",55,55,54,1,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.98181818181818181},"2014-06-27",53,"汤柏龄","2014-07-25"]
[{"$nulls":6},{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":{"$error":"#DIV/0!"}}]
[{"$nulls":6},{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":{"$error":"#DIV/0!"}}]
[]
[2,"组织级QA工作"]
[null,"检查对象","本月计划检查项个数","本月实际检查项个数","通过的检查项个数","未通过的检查项个数","通过率","本月检查日期","下月计划检查项个数","检查人","下月计划检查日期"]
[null,"持续改进",40,40,37,2,{"$f":"(表1[[#This Row],[本月实际检查项个数]]-表1[[#This Row],[未通过的检查项个数]])/表1[[#This Row],[本月实际检查项个数]]","v":0.95},"2014-06-30",0,"张扬清"]
[null,"质量保证",18,18,16,2,{"$f":"(表1[[#This Row],[本月实际检查项个数]]-表1[[#This Row],[未通过的检查项个数]])/表1[[#This Row],[本月实际检查项个数]]","v":0.88888888888888884},"2014-06-30",0,"纪蓉"]
[null,"组织培训",20,20,16,3,{"$f":"(表1[[#This Row],[本月实际检查项个数]]-表1[[#This Row],[未通过的检查项个数]])/表1[[#This Row],[本月实际检查项个数]]","v":0.85},"2014-06-30",0,"汤柏龄"]
[]
[]
[]
[]
[3,"QA工作问题汇报"]
[null,"日期","问题描述","解决方案","当前状态","解决情况","备注"]

{"sheet":"不符合问题分析","index":1,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[45,15,46,15],[0,1,1,11],[45,1,46,1],[53,1,53,4],[53,5,54,5],[45,2,45,14]]}
[null,"不符合问题分析"]
[]
[1,"问题分类统计分析"]
{"$rows_empty":41}
[null,"项目问题统计"]
[null,"项目名称","不符合问题分布",{"$nulls":12},"不符合问题总数"]
[null,null,"PP","PMC","IPM","RSKM","REQM","RD","TS","PI","VER","VAL","MA","CM","DAR"]
[null,"广靖锡澄",0,0,0,1,1,0,0,0,1,0,0,0,0,{"$f":"SUM(C48:O48)","v":3}]
[null,"长江隧道",0,0,0,0,1,0,0,0,1,0,1,0,0,{"$f":"SUM(C49:O49)","v":3}]
[null,"港口安全",0,0,0,1,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C50:O50)","v":1}]
[null,"总计",{"$f":"SUM(C48:C50)","v":0},0,0,2,2,0,0,0,2,0,1,0,0,7]
[]
[null,"组织问题统计"]
[null,"过程不符合问题分布",null,null,null,"总数"]
[null,"OPF","OPD","OT","PPQA"]
[null,1,1,2,1,{"$f":"SUM(B56:E56)","v":5}]
[]
[2,"当前未解决不符合问题列表"]
[null,"编号","级别","项目名称","发现日期","发现人","问题描述","对应过程","责任人","解决措施","预计解决日期","当前状态"]
[null,"140627-01","项目级","广靖锡澄","2014-06-27","汤柏龄","风险的跟踪记录不完整","RSKM","肖敏","更新跟踪记录","2014-07-04","解决中"]
[null,"140627-02","项目级","广靖锡澄","2014-06-27","汤柏龄","模块开发管理表中，测试用例的追溯关系不完整","REQM","肖敏","补充完整","2014-07-04","解决中"]
[null,"140627-03","项目级","广靖锡澄","2014-06-27","汤柏龄","测试结果记录不完整，只记录了测试发现BUG的CASE执行结果","VER","肖敏","补充完整的测试记录","2014-07-04","解决中"]
[null,"140627-04","项目级","长江隧道","2014-06-27","汤柏龄","模块开发管理表中，测试用例的追溯关系不完整","REQM","高才驰","补充完整","2014-07-04","解决中"]
[null,"140627-05","项目级","长江隧道","2014-06-27","汤柏龄","度量表中，本周累计工作量信息统计错误","MA","高才驰","确认错误原因，更正数据","2014-07-04","解决中"]
[null,"140627-06","项目级","长江隧道","2014-06-27","汤柏龄","缺陷记录不完整","VER","高才驰","更新缺陷记录","2014-07-04","解决中"]
[null,"140627-07","项目级","港口安全","2014-06-27","汤柏龄","风险的跟踪记录不完整","RSKM","黄陈","补充完整","2014-07-04","解决中"]
[null,"140630-01","组织级",null,"2014-06-30","张扬清","“建立质量考核标准”改进课题没有时间规划","OPF","纪蓉","补充时间规划","2014-07-15","解决中"]
[null,"140630-02","组织级",null,"2014-06-30","张扬清","实际没有设置存取权限，所有人均可读写","OPD","袁晓冬","按照资产库管理要求设置不同角色的权限","2014-07-04","解决中"]
[null,"140630-03","组织级",null,"2014-06-30","汤柏龄","MYSQL培训未填写培训效果说明","OT","张扬清","补充效果说明","2014-07-04","解决中"]
[null,"140630-04","组织级",null,"2014-06-30","汤柏龄","在培训工作目录下未见到5月份月报","OT","张扬清","确认是否6月份未提交报告","2014-07-04","解决中"]
[null,"140630-05","组织级",null,"2014-06-30","纪蓉","不符合问题表中部分不符合项没有当前状态","PPQA","汤柏龄","更新不符合项状态","2014-07-11","解决中"]