{"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,"广靖锡澄",78,78,56,4,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.94871794871794868},"2014-04-25",54,"汤柏龄","2014-05-30"]
[null,"长江隧道",78,78,70,4,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.94871794871794868},"2014-04-25",57,"汤柏龄","2014-05-30"]
[null,"港口安全",78,78,70,1,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.98717948717948723},"2014-04-25",57,"汤柏龄","2014-05-30"]
[{"$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,0]
[null,"质量保证",0,0,0,0,{"$f":"工作总结!$E14/工作总结!$D14","v":{"$error":"#DIV/0!"}},null,0]
[null,"组织培训",0,0,0,0,{"$f":"工作总结!$E15/工作总结!$D15","v":{"$error":"#DIV/0!"}},null,0]
[]
[]
[]
[]
[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,"广靖锡澄",1,2,0,0,0,0,0,0,0,0,1,0,0,{"$f":"SUM(C48:O48)","v":4}]
[null,"长江隧道",2,2,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C49:O49)","v":4}]
[null,"港口安全",1,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C50:O50)","v":1}]
[null,"总计",{"$f":"SUM(C48:C50)","v":4},4,0,0,0,0,0,0,0,0,1,0,0,9]
[]
[null,"组织问题统计"]
[null,"过程不符合问题分布",null,null,null,"总数"]
[null,"OPF","OPD","OT","PPQA"]
[null,0,0,0,0,0]
[]
[2,"当前未解决不符合问题列表"]
[null,"编号","级别","项目名称","发现日期","发现人","问题描述","对应过程","责任人","解决措施","预计解决日期","当前状态"]
[null,"140425-01","项目级","广靖锡澄","2014-04-25","汤柏龄","项目状态报告中仅汇报了工程活动的进展和下周规划，未包含管理及支持类工作","PMC","肖敏","状态报告中应包含项目所有类型工作的完成情况","2014-05-09","解决中"]
[null,"140425-02","项目级","广靖锡澄","2014-04-25","汤柏龄","详细进度表中，部分已完成的任务没有更新实际完成情况","PMC","肖敏","更新这些任务的状态，并在后面的工作中注意","2014-05-09","解决中"]
[null,"140425-03","项目级","广靖锡澄","2014-04-25","汤柏龄","项目度量表中，每周累计工作量信息统计错误","MA","肖敏","确认错误原因，修正度量数据","2014-05-09","解决中"]
[null,"140425-04","项目级","广靖锡澄","2014-04-25","汤柏龄","详细进度表的各阶段工作量划分与估算结果出入较大","PMC","肖敏","分析偏差原因，再确认是修改估算还是修改进度计划","2014-05-09","解决中"]
[null,"140425-05","项目级","长江隧道","2014-04-25","汤柏龄","未见到本月的会议纪要","PMC","高才驰","补充本月会议纪要","2014-05-09","解决中"]