{"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,"广靖锡澄",54,54,52,2,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.96296296296296291},"2014-05-30",58,"汤柏龄","2014-06-27"]
[null,"长江隧道",57,57,54,3,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.94736842105263153},"2014-05-30",55,"汤柏龄","2014-06-27"]
[null,"港口安全",57,57,57,0,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":1},"2014-05-30",55,"汤柏龄","2014-06-27"]
[{"$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,"持续改进",0,0,0,0,{"$f":"工作总结!$E13/工作总结!$D13","v":{"$error":"#DIV/0!"}},null,40,"张扬清","2014-06-30"]
[null,"质量保证",0,0,0,0,{"$f":"工作总结!$E14/工作总结!$D14","v":{"$error":"#DIV/0!"}},null,18,"纪蓉","2014-06-30"]
[null,"组织培训",0,0,0,0,{"$f":"工作总结!$E15/工作总结!$D15","v":{"$error":"#DIV/0!"}},null,20,"汤柏龄","2014-06-30"]
[]
[]
[]
[]
[3,"QA工作问题汇报"]
[null,"日期","问题描述","解决方案","当前状态","解决情况","备注"]

{"sheet":"不符合问题分析","index":1,"n_rows":64,"n_cols":16,"rows_kept":64,"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,1,0,0,1,0,0,0,0,0,0,0,0,{"$f":"SUM(C48:O48)","v":2}]
[null,"长江隧道",0,0,0,0,2,0,1,0,0,0,0,0,0,{"$f":"SUM(C49:O49)","v":3}]
[null,"港口安全",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C50:O50)","v":0}]
[null,"总计",{"$f":"SUM(C48:C50)","v":0},1,0,0,3,0,1,0,0,0,0,0,0,5]
[]
[null,"组织问题统计"]
[null,"过程不符合问题分布",null,null,null,"总数"]
[null,"OPF","OPD","OT","PPQA"]
[null,0,0,0,0,0]
[]
[2,"当前未解决不符合问题列表"]
[null,"编号","级别","项目名称","发现日期","发现人","问题描述","对应过程","责任人","解决措施","预计解决日期","当前状态"]
[null,"140530-01","项目级","广靖锡澄","2014-05-30","汤柏龄","5月16日召开了项目例会，但未见会议纪要","PMC","肖敏","补充会议纪要","2014-06-06","解决中"]
[null,"140530-02","项目级","广靖锡澄","2014-05-30","汤柏龄","模块开发管理表中，设计的追溯关系不完整","REQM","肖敏","补充完整","2014-06-06","解决中"]
[null,"140530-03","项目级","长江隧道","2014-05-30","汤柏龄","模块开发管理表中，模块列表与最新的设计文档不一致","REQM","高才驰","确认那份文档中模块列表是最新的","2014-06-06","解决中"]
[null,"140530-04","项目级","长江隧道","2014-05-30","汤柏龄","模块开发管理表中，设计的追溯关系不完整","REQM","高才驰","补充完整","2014-06-06","解决中"]
[null,"140530-05","项目级","长江隧道","2014-05-30","汤柏龄","设计文档中接口数量和需求不一致","TS","高才驰","确认接口是否不一致，若不一致则需确认最新接口需求","2014-06-06","解决中"]