{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["进度 (2)","NTF修改要求","Sheet1","表-AMResults"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"进度 (2)","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"G客户产品NTF&FPY等合格率统计讨论"]
["序号","任务","目前状态及处理方法","责任人","完成时间","备注"]
[1,"统计增加区分：产线，日期，批次，Model，尺寸（FSN)，白夜班","通过FSN，提取批次号，查询出Model，尺寸等信息，并保存本地和数据库。夜班日期的定义0-5点算昨天的日期。按小时统计数据。","江工","2021-07-30"]
[2,"Model，尺寸等信息查询","查询接口由IT同事开发。通过SN查询，返回批次号，MODEL，尺寸等。","IT刘工","2021-07-22"]
[3,"更新NTF统计的数据库字段","NTF统计方法更新，IT同事评估增加数据库字段。TestHour，ODF，TwiceFail，SPY，RPY，YieldRate，NTF_SN，Model，Dimension。","IT李工","2021-07-22"]
[4,"重流机另外算新机进行统计","FSN保存本地，检查是否同一个SN，当前SN与上次测试的SN不同时，插入新记录，相同则直接更新。","江工","Done"]
[5,"按工站进行区分统计","由测试项目改为工站名称，增加工站列表","江工","2021-07-23"]
[6,"Hipot,数据抄写，WBA，Audio，外观检查，目前还未做统计","增加工站：\nHipot,工程徐工开发，已完成\n数据抄写，待研发同事开发，暂定8/18\nWBA，已有，更新算法即可，已完成\nAudio，客户软件，待讨论增加统计和接口，暂定8/18","江阳生\n徐工\n研发同事","2021-08-18"]
[7,"电脑日期同步","已修改好软件，直接应用即可","江工","Done"]
[8,"相同项目多条记录的情况","为清空操作引起的，删除清空的操作。","江工","Done"]
[9,"WCL记录数据差异大","主要是WCL复位前检查漏测的情况，改为不计入NTF。","江工","Done"]
[10,"统计数据准确度","核对系统和人工记录的数据，统计排查差异。","江工/宾工","Done"]
[11,"IT开发一个展示界面，显示各项统计信息","与IT协商中。\n查询条件：产线，日期，批次，Model，尺寸（FSN)，白夜班。\n展示界面：表格显示与导出，增加合计功能，按批次，月份等","IT李工","开发中"]
[12,"展示界面","QA给出展示界面的报表格式需求","QA宾工","Done"]

{"sheet":"NTF修改要求","index":1,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["上次记录的SN","统计合格率",null,"本地记录"]
["DGG001254","PrintLabel;50.00%;75.00%",null,null,null,"重流记录"]
["ODF","SN","FirstTest","2nd","FinalTest","Remark","DateTime",{"$nulls":7},"工站"]
["DGG001","null","PASS","PASS","PASS","Input-1","2021-07-02T16:50:25",{"$nulls":6},"Hipot","Hipot"]
["DGG001","null1","PASS","PASS","PASS","Input-1","2021-07-03T16:50:25",{"$nulls":6},"DataBurning","DataBurning"]
["DGG001","null2","FAIL","PASS","PASS","Input-1","2021-07-04T16:50:25","1.统计增加区分：产线，日期，批次，Model，尺寸（FSN)，白夜班",{"$nulls":5},"Wifi-BT","Wifi-BT-HDMI2","HDMI2"]
["DGG001","null3","FAIL","PASS","FAIL","Input-1","2021-07-05T16:50:25","2.重流机另外算新机进行统计，检查是否同一个SN，SN寄存器",{"$nulls":5},"LabelPrint","LabelPrint"]
["DGG002","null","PASS","PASS","PASS","重流记录","2021-07-06T16:50:25","3.按工站进行区分统计",{"$nulls":5},"WBA","WBA"]
["DGG002","null1","FAIL","PASS","FAIL",null,"2021-07-07T16:50:25","4.增加工站：Hipot,数据抄写，WBA，Audio,",{"$nulls":5},"HDMI1","HDMI1"]
["DGG002","null2","FAIL","PASS","FAIL",null,"2021-07-08T16:50:25","5.电脑日期同步",{"$nulls":5},"HDMI3","HDMI3"]
["DGG002","null3","FAIL","PASS","PASS",null,"2021-07-09T16:50:25","6.IT开发一个操作界面，显示各项统计信息",{"$nulls":5},"HDMI4","HDMI4-IRB-Key","IRB-Key"]
[{"$nulls":7},"7.统计数据准确度,WCL",null,null,null,"NTF计算方法",null,"TV","TV"]
[{"$nulls":7},"8.删除清空的操作。",null,"一次测试合格率","FPY","OncePass/Total",null,"Audio","Audio"]
[{"$nulls":7},"每周更新两次进度",null,"两次内测试合格率","SPY","(OncePass+NTF)/Total",null,"MIC_OFF","MIC_OFF"]
[{"$nulls":9},"实际合格率","RPY","1-RealFail/Total",null,"MIC_ON","MIC_ON-I2S","I2S"]
["重流机另算新机统计：",{"$nulls":8},"去除重码实际合格率","YieldRate","1-FinalFail/Total",null,"Basic","Basic-RGBled","RGB_LED"]
["本地记录增加保存上一个SN（第二行第一列），检查SN前后是否相同:",{"$nulls":12},"WCL","WCL-RST"]
["1 相同更新记录，查询SN，Remark=NULL",{"$nulls":12},"RFID","RFID"]
["2 不同则新增记录：搜索SN列是否有相同SN，有则更新记录中SN的Remark状态，并插入新的记录。查无记录，则插入新记录。"]
[]
[]
["数据库表"]
[null,"表名"]
["旧表不用","AMYield","Line","TestItem","NTF","FPY","FristPass","FinaPass","RealFail","Total","FailDSN","TestDate",null,"Remark"]
[]
[]
["新表1-AMYields","统计每小时合格率","查询条件",{"$nulls":9},"投入数"]
["字段名称","TestDate","TestHour","Line","Station","ODF","DeviceNum","Model"," Dimension","OncePass","NTF","TwiceFail","RealFail","Total","FPY","SPY","RPY","YieldRate","Remark","NTF_SN","Fail_SN"]
[null,"日期班次","小时","线体","工站","批次","机架编号","机型","尺寸","一次PASS数量","第二次才测试PASS的数量","连续两次测试FAIL","实际FAIL数量","测试产品总数","一次测试合格率","两次内测试合格率","实际合格率","去除重码实际合格率","备注","NTF记录FSN","实际FAIL记录SN"]
["字符长度",50,"数字",30,30,20,10,30,20,10,10,10,10,10,10,10,10,10,100,500,500]
["例","2021-07-15白班","T303-1","HDMI1","DGG7507978","PC1","43D2000","43inch",680,2,1,2,685,{"$f":"I31/$M$31","v":0.99270072992700731},{"$f":"(I31+J31)/$M$31","v":0.99562043795620436},{"$f":"(M31-K31)/$M$31","v":0.99854014598540142},{"$f":"(M31-L31)/$M$31","v":0.99708029197080295},null,"SN1;SN2","SN3"]
[{"$nulls":5},"仅Insert一次，Update不修改:机型，批次，尺寸",{"$nulls":10},"清空记录状态"]
[null,"2021-07-20:0~23",null,null,null,"OncePass","一次PASS数量",null,"NTF计算方法","一次测试合格率","FPY","OncePass/Total",null,null,"FPY","SPY","RPY","YieldRate"]
[{"$nulls":5},"NTF","第二次才测试PASS的数量",null,null,"两次内测试合格率","SPY","(OncePass+NTF)/Total",null,null,"OncePass/Total","(OncePass+NTF)/Total","1-RealFail/Total","1-FinalFail/Total"]
[{"$nulls":5},"TwiceFail","连续两次测试FAIL",null,null,"实际合格率","RPY","1-RealFail/Total"]
[{"$nulls":5},"RealFail","实际FAIL数量",null,null,"去除重码实际合格率","YieldRate","1-FinalFail/Total去重复"]
[{"$nulls":5},"Total","测试产品总数"]
["新表2：","AMResult","直接上传本地记录"]
["表名","日期班次","线体","工站","机型","尺寸","测试时间","小时","批次","条码","首次测试结果 ","二次测试结果 ","最终测试结果","结果类型","不良描述","重流标识","备注"]
["AMResult","TestDate","Line","Station","Model"," Dimension","TestTime","TestHour","ODF","SN","Test01","Test02","FinalTest","ResultType","ErrorMsg","ReDo","Remark"]
["字段长度",50,20,30,30,30,30,"数字",20,30,10,10,10,20,300,100,100]
[null,"2021-07-20:20",null,"WCL","Model","尺寸","测试时间",null,null,"DGG75087272107000628","PASS","NULL","PASS","OncePass","一次PASS",0,"当前测试"]
[null,"2021-07-20:20",null,"WCL",{"$nulls":5},"DGG75087272107000629","FAIL","PASS","PASS","NTF","1st:Fail;2nd:PASS",1,"第一次投入"]
[null,"2021-07-20:20",null,"WCL",{"$nulls":5},"DGG75087272107000630","FAIL","FAIL","PASS","FinalPass","最终PASS",2,"第二次投入"]
[null,"2021-07-20:20",null,"WCL",{"$nulls":5},"DGG75087272107000621","FAIL","FAIL","FAIL","TwiceFail","连续两次FAIL",3,"第三次投入"]
[null,"2021-07-20:20",null,"WCL",{"$nulls":5},"DGG75087272107000622","PASS","FAIL","PASS","FinalPass","最终PASS","...","......"]
[null,"2021-07-20:20",null,"WCL",{"$nulls":5},"DGG75087272107000623","FAIL","NULL","FAIL","OnceFail","仅测试一次且FAIL"]
[null,"2021-07-20:21",null,"WCL",{"$nulls":5},"DGG75087272107000623","FAIL","PASS ","FAIL","FinalFail","最终FAIL"]
[{"$nulls":10},"PASS","FAIL","FAIL","FinalFail"]
["Web接口","通过SN获取Model，尺寸，批次，BOM"]
["地址：","http://10.126.124.85:8002/SAPService.asmx?op=GetMaInfo"]
["输入参数格式：","<?xml version=\"1.0\" encoding=\"utf-8\"?>"]
["XML","<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">"]
[null,"  <soap:Body>"]
[null,"    <GetMaInfo xmlns=\"http://tempuri.org/\">"]
[null,"      <sn>%s</sn>"]
[null,"    </GetMaInfo>"]
[null,"  </soap:Body>"]
[null,"</soap:Envelope>"]

{"sheet":"Sheet1","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[21,3,21,7],[22,3,22,7],[4,6,5,6],[6,6,7,6],[9,6,10,6],[12,6,13,6],[15,6,18,6]]}
[]
[]
[null,null,"NTF结果类型说明"]
[]
[null,null,"首次测试结果 ","第二次测试结果 ","最终测试结果","结果类型","结果类型说明"]
[null,null,"Test01","Test02","FinalTest","ResultType"]
[null,null,"PASS","NULL","PASS","OncePass","仅测一次"]
[null,null,"FAIL","NULL","FAIL","OnceFail"]
[]
[null,null,"FAIL","PASS","PASS","NTF","至少两次，且前两次为FAIL和PASS"]
[null,null,"FAIL","PASS","FAIL","FinalFail"]
[]
[null,null,"FAIL","FAIL","PASS","FinalPass","至少两次且前两次FAIL"]
[null,null,"FAIL","FAIL","FAIL","TwiceFail"]
[]
[null,null,"PASS","PASS","PASS","FinalPass","至少两次，非常规操作"]
[null,null,"PASS","FAIL","PASS","FinalPass"]
[null,null,"PASS","FAIL","FAIL","FinalFail"]
[null,null,"PASS","PASS","FAIL","FinalFail"]
[null,null,"一般只允许连接测试两次，有不良则打出维修，等待重流。不过新产线有时会多测几次。"]
[]
[null,"说明","OncePass","当Test01和Final Test都为PASS，且Test02为NULL，表示OncePASS"]
[null,null,"OnceFail","当Test01和Final Test都为FAIL，且Test02为NULL，表示OnceFAIL"]
[null,null,"NTF","当Test01为Fail，Test02和FinalTest均为PASS，表示NTF"]
[null,null,"TwiceFail","Test01，Test02，FinalResult均为FAIL，表示TwiceFail"]
[]
[null,null,"当以上四种情况不满足时，则看FinalTest的结果来判定下面两种类型："]
[null,null,"FinalPass"]
[null,null,"FinalFail"]

{"sheet":"表-AMResults","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,4,19,8]]}
["字段名","字段类型","描述",null,"ResultType   ","Test01","Test02","FinalTest","说明     "]
["TestDate","date  NOT ","日期班次 ",null,"OncePass","PASS","NULL","PASS","有且只有一次测试：\nTest01=FinalTest=PASS & Test02=NULL"]
["TestHour","int  NOT ","小时 ",null,"OnceFail","FAIL","NULL","FAIL","有且只有一次测试：\nTest01=FinalTest=FAIL & Test02=NULL"]
["Line","varchar(30)","线体：UI界面或配置文件提供 ",null,"NTF","FAIL","PASS","PASS","2次或2次以上：\nTest01=FAIL & Test02=FinalTest=PASS"]
["Station","varchar(30)","工站：UI界面或配置文件提供，\n抄写工具固定为：DataBurning",null,"TwiceFail","FAIL","FAIL","FAIL","2次或2次以上：\nTest01=Test02=FinalTest=FAIL"]
["Model","varchar(30)","机型：HTTP接口获取 ",null,"FinalPass","PASS","PASS","PASS","2次或2次以上：\nTest01=Test02=FinalTest=PASS"]
["Dimension","varchar(20)","尺寸：HTTP接口获取 ",null,"FinalFail ","PASS","FAIL","FAIL","2次或2次以上：\nTest01=PASS & Test02=FinalTest=FAIL"]
["TestTime","varchar(30)","测试时间 ",null,"FinalPass","PASS","FAIL","PASS","3次及以上：\nTest01=FinalTest=PASS & Test02=FAIL"]
["ODF","varchar(20)","批次：HTTP接口获取 ",null,"FinalFail ","PASS","PASS","FAIL","3次及以上：\nTest01=Test02=PASS & FinalTest=FAIL"]
["SN","varchar(30)","本次抄写SN ",null,"FinalFail ","FAIL","PASS","FAIL","3次及以上：\nTest01=Test02=PASS & FinalTest=FAIL"]
["ErrorMsg","varchar(300)","抄写失败描述 "]
["ReDo","varchar(10)","重流标识 "]
["Remark","varchar(100)","备注：一般用于重流标记 "]
["Test01","varchar(10)","首次测试结果 "]
["Test02","varchar(10)","第二次测试结果 "]
["FinalTest","varchar(10)","最后一次的测试结果"]
["ResultType","varchar(20)","结果类型：OncePass、OnceFail、\nNTF、TwiceFail、FinalPass、FinalFail ",null,"说明：在ReDo、SN、Station相同的情况下，连续抄写；\n使用触发器更新ResultType最好，但由于数据库是由IT部门处理的，且工程部那边也需要修改程序，目前无法使用触发器处理"]
["DSN","varchar(20)","本次抄写DSN "]