{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["统计方式","数据库表格式","会议纪要2021.12.06"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,6],[16,1,24,6]]}
["试产线NTF统计方案"]
["序号","Test01","Test02","Test03","FinalTest","测试次数","结果类型","备注"]
[1,"PASS","NULL","NULL","PASS",1,"OncePASS"]
[2,"FAIL","NULL","NULL","FAIL",1,"RealFAIL"]
[3,"PASS","FAIL","NULL","FAIL",2,"RealFAIL"]
[4,"PASS","PASS","NULL","PASS",2,"OncePASS"]
[5,"FAIL","FAIL","NULL","FAIL",2,"RealFAIL"]
[6,"FAIL","PASS","NULL","FAIL",2,"RealFAIL","提示操作员再测一次，连续两次PASS才上传结果到AMTEST"]
[7,"PASS","PASS","PASS","PASS",3,"OncePASS"]
[8,"PASS","PASS","FAIL","FAIL",3,"RealFAIL"]
[9,"PASS","FAIL","PASS","PASS",3,"NTF","提示操作员再测一次，连续两次PASS才上传结果到AMTEST"]
[10,"PASS","FAIL","FAIL","FAIL",3,"RealFAIL"]
[11,"FAIL","PASS","PASS","PASS",3,"NTF"]
[12,"FAIL","PASS","FAIL","FAIL",3,"RealFAIL"]
[13,"FAIL","FAIL","PASS","PASS",3,"RealFAIL","累计2次出现FAIL，不允许继续测试"]
[14,"FAIL","FAIL","FAIL","FAIL",3,"RealFAIL","累计2次出现FAIL，不允许继续测试"]
[15,"注：1、测试结果都是PASS的，记为PASS，\n2、前三次测试出现一次FAIL，最终结果PASS的记为NTF\n3、测试结果出现出现Fail的时候，后面必须连续测试两次  PASS才会上传结果，否则下工位不能启动测试（弹框提示）\n4、累计两次测试结果为Fail，软件锁死不能继续测试。\n5、NTF的产品需要在线外连续测试20次，结果不用上传，有log即可"]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[]
[]
[]
[{"$nulls":7},"量产ResultType: OnecePass、OnceFail、TwiceFail、NTF、FinalFail、FinalPass"]
[{"$nulls":7},"试产ResultType:OncePass、NTF、RealFail"]

{"sheet":"数据库表格式","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,0,25,8],[26,0,26,8],[27,0,27,8],[28,0,28,8],[20,0,20,8],[21,0,21,8],[22,0,22,8],[23,0,23,8],[24,0,24,8],[17,0,17,3],[13,5,13,8],[4,4,4,8],[16,0,16,1],[15,0,15,1],[14,0,14,1],[4,0,4,1],[9,5,9,8],[10,5,10,8],[11,5,11,8],[12,5,12,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8]]}
[]
[]
[]
[]
["数据库表AMYields_TR",null,null,null,"数据库表AMResult_TR"]
["0nePass","ResultType中OnecePass的产品数量（含重码）",null,null,"FinalTest","最后一次测试结果"]
["NTF","ResultType中NTF数量（含重码）",null,null,"ResultType","三种类型：OnecePass，NTF，RealFail"]
["TwiceFail","累计两次测试FAIL数量","不处理。",null,"Test01","第一次测试结果"]
["RealFail","ResultType中RealFail数量（含重码）",null,null,"Test02","第二次测试结果"]
["Total","测试产品次数",null,null,"Test03","第三次测试结果"]
["FPY","一次通过率与大线定义一致(一次通过率)"]
["SPY","二次通过率与RPY一致"]
["RPY","实际通过率与大线定义一致"]
["YieldRate","去重码实际通过率"]
["FPY=OncePass\\Total*100%"]
["SPY=FPY+NTF%"]
["RPY=FPY+NTF%"]
["YieldRate=FinalPass/Yields*100%（去除重码的PASS的数量/去重码产品数量）"]
[]
[]
["\"重码\"术语：表示要统计AMResult表中包含ReDo!=0的SN记录，ReDo!=0的那些记录都是重流记录。"]
["OncePass：有2种统计，包含重码的和不包含重码的，即ReDo!=0和ReDo=0的记录。"]
["NTF：有2种统计，包含重码的和不包含重码的，即ReDo!=0和ReDo=0的记录。"]
["Total：有2种统计，包含重码的和不包含重码的，即ReDo!=0和ReDo=0的记录。"]
["RealFail：有2种统计，包含重码的和不包含重码的，即ReDo!=0和ReDo=0的记录。（百分比中并没有用到，不需要统计失败率）"]
["FPY = OncePass<含重码> / Total<含重码> * 100"]
["SPY = (OncePass<含重码> + NTF<含重码>) / Total<含重码> * 100"]
["RPY = (OncePass<含重码> + NTF<含重码>) / Total<含重码> * 100   （实际与SPY一样）"]
["YieldRate=（OncePass<去重码> + NTF<去重码>） / Total<去重码> * 100"]

{"sheet":"会议纪要2021.12.06","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,26,12]]}
["                                                                                           会议主题：G客户试产线NTF数据统计\n与会人员：钟锦棠，江阳生，马学勤，王剑峰，钱清鹏，刘晓敏，梁伟\n行动事项：\n1.如何区分试产工单量产工单（工单没有特殊区别）-----------------------新建一张表，BOM上查不到则用试产规则，                                                                                                        后期维护由IPL下发通知，维护人待定，建议提交OA单的方式进行\n\n2.数据抄写CMP接口只做写入更新-------------------------------------------王剑峰  完成时间2021.12.06下午下班前回复\n\n3.接口定义由王工梳理给出，晓敏按照需求提供-----------------------------王剑峰，刘晓敏\n\n4.第一次为FAIL，第二次PASS先不上传AMTEST结果，待第三次结果为PASS时再上传结果---------王剑峰"]