{"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,"广靖锡澄",45,45,44,1,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.97777777777777775},"2014-07-25",45,"汤柏龄","2014-08-29"]
[null,"长江隧道",50,50,48,2,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":0.96},"2014-07-25",51,"汤柏龄","2014-08-29"]
[null,"港口安全",53,53,53,0,{"$f":"(表2[[#This Row],[本月实际检查项个数]]-表2[[#This Row],[未通过的检查项个数]])/表2[[#This Row],[本月实际检查项个数]]","v":1},"2014-07-25",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!"}}]
[{"$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":"(表1[[#This Row],[本月实际检查项个数]]-表1[[#This Row],[未通过的检查项个数]])/表1[[#This Row],[本月实际检查项个数]]","v":{"$error":"#DIV/0!"}},null,0]
[null,"质量保证",0,0,0,0,{"$f":"(表1[[#This Row],[本月实际检查项个数]]-表1[[#This Row],[未通过的检查项个数]])/表1[[#This Row],[本月实际检查项个数]]","v":{"$error":"#DIV/0!"}},null,0]
[null,"组织培训",0,0,0,0,{"$f":"(表1[[#This Row],[本月实际检查项个数]]-表1[[#This Row],[未通过的检查项个数]])/表1[[#This Row],[本月实际检查项个数]]","v":{"$error":"#DIV/0!"}},null,0]
[]
[]
[]
[]
[3,"QA工作问题汇报"]
[null,"日期","问题描述","解决方案","当前状态","解决情况","备注"]

{"sheet":"不符合问题分析","index":1,"n_rows":62,"n_cols":16,"rows_kept":62,"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,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C48:O48)","v":1}]
[null,"长江隧道",0,1,0,1,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C49:O49)","v":2}]
[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},2,0,1,0,0,0,0,0,0,0,0,0,3]
[]
[null,"组织问题统计"]
[null,"过程不符合问题分布",null,null,null,"总数"]
[null,"OPF","OPD","OT","PPQA"]
[null,0,0,0,0,0]
[]
[2,"当前未解决不符合问题列表"]
[null,"编号","级别","项目名称","发现日期","发现人","问题描述","对应过程","责任人","解决措施","预计解决日期","当前状态"]
[null,"140725-01","项目级","广靖锡澄","2014-07-25","汤柏龄","详细进度表中，部分已完成的任务没有更新实际完成情况","PMC","肖敏","更新任务完成情况","2014-08-01","解决中"]
[null,"140725-02","项目级","长江隧道","2014-07-25","汤柏龄","风险的跟踪记录不完整","RSKM","高才驰","更新跟踪记录","2014-08-01","解决中"]
[null,"140725-03","项目级","长江隧道","2014-07-25","汤柏龄","详细进度表中，部分已完成的任务没有更新实际完成情况","PMC","高才驰","更新任务的实际完成情况","2014-08-01","解决中"]