{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Revisions","SCS+Traceability+Gage-MSA Plan","EPC List","Dropdown"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":13,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Revisions","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Date","Form Revision","Name"]
["2006-10-23","Revised form title","D. Schuller"]
["2006-10-23","Revised heading title from \"KPC, QCI, or SEV\" to \"Class\"","D. Schuller"]
["2006-10-23","Added FTQ, LSR, EPC, Process Stability columns","D. Schuller"]
["2006-10-23","Added Sampling Plan","D. Schuller"]
["2007-04-12","Added \"PT\" column to indicate Pass-through characteristics","D. Schuller"]
["2007-07-24","Revised background formatting to ease editing; no change to form","D. Schuller"]
["2007-07-24","Removed FTQ, LSR, Process Characteristics","D. Schuller"]
["2008-06-23","Revised comment for PT","D. Schuller"]
["2008-06-23","Revised Spec Value column and comment","D. Schuller"]
["2008-06-23","Added pull-down values for several columns","D. Schuller"]
["2008-06-23","Revised Action Plan column and comment","D. Schuller"]
["2008-06-23","Revised Initial Capability section","D. Schuller"]
["2008-06-23","Revised Gage Study section","D. Schuller"]
["2008-07-15","STD was SEV","D. Schuller"]
["2008-09-02","Unlocked format for CLASS column","D. Schuller"]
["2009-10-20","Revised logo","D. Schuller"]
["2009-10-20","Revised comment for CLASS column","D. Schuller"]
["2011-03-01","Comment Field definition updates for Product Desc, Error proofing, Sampling Plan, Gage Capability, Cap Study Sample Size, Action Plan, etc…","C. Wilson"]
["2021-01-29","Added Tracebility, Measurement Correlation and MSA details.\nUpdated formats and made controlled form.","L. Villavicencio\nP. Huang"]
["2023-03-16","Added EPC list tab to create from SCS Tab.\nAdded Lessons Learned Input column\nAdded EPC Column\nMoved Required Measurement Correlation column","P. Huang\nP. Li\nK. Gamm"]

{"sheet":"SCS+Traceability+Gage-MSA Plan","index":1,"n_rows":10,"n_cols":47,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,28],[1,0,1,2],[0,29,0,46],[2,0,2,2],[3,0,3,3],[1,29,6,46],[1,4,1,15],[1,16,1,28],[7,29,7,46],[3,27,3,28],[6,0,6,3],[4,27,4,28],[5,27,5,28],[4,0,4,3],[5,0,5,3],[2,4,2,15],[3,4,3,15],[4,4,4,15],[5,4,5,15],[2,16,2,28],[3,16,3,26],[4,16,4,26],[5,16,5,26],[8,0,9,0],[8,1,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,9,9,9],[6,27,6,28],[8,21,8,27],[8,28,9,28],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,16,8,18],[6,4,6,15],[6,16,6,26],[8,45,9,45],[8,46,9,46],[10,1,10,2],[22,1,22,2],[34,1,34,2],[35,1,35,2],[8,30,9,30],[8,31,9,31],[8,32,8,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,15,9,15],[8,19,8,20],[8,29,9,29],[8,10,9,10],[8,11,9,11],[8,12,8,14],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[11,1,11,2],[314,1,314,2],[42,1,42,2],[71,1,71,2],[72,1,72,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[140,1,140,2],[141,1,141,2],[142,1,142,2],[313,1,313,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[321,1,321,2],[322,1,322,2],[323,1,323,2],[315,1,315,2],[316,1,316,2],[317,1,317,2],[318,1,318,2],[319,1,319,2],[320,1,320,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[21,1,21,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[32,1,32,2],[33,1,33,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[63,1,63,2],[64,1,64,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[70,1,70,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[96,1,96,2],[97,1,97,2],[98,1,98,2],[99,1,99,2],[100,1,100,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[105,1,105,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[119,1,119,2],[120,1,120,2],[111,1,111,2],[112,1,112,2],[113,1,113,2],[114,1,114,2],[115,1,115,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[130,1,130,2],[121,1,121,2],[122,1,122,2],[123,1,123,2],[124,1,124,2],[125,1,125,2],[136,1,136,2],[137,1,137,2],[138,1,138,2],[139,1,139,2],[143,1,143,2],[131,1,131,2],[132,1,132,2],[133,1,133,2],[134,1,134,2],[135,1,135,2],[149,1,149,2],[150,1,150,2],[151,1,151,2],[152,1,152,2],[153,1,153,2],[144,1,144,2],[145,1,145,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[159,1,159,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[163,1,163,2],[154,1,154,2],[155,1,155,2],[156,1,156,2],[157,1,157,2],[158,1,158,2],[169,1,169,2],[170,1,170,2],[171,1,171,2],[172,1,172,2],[173,1,173,2],[164,1,164,2],[165,1,165,2],[166,1,166,2],[167,1,167,2],[168,1,168,2],[179,1,179,2],[180,1,180,2],[181,1,181,2],[182,1,182,2],[183,1,183,2],[174,1,174,2],[175,1,175,2],[176,1,176,2],[177,1,177,2],[178,1,178,2],[189,1,189,2],[190,1,190,2],[191,1,191,2],[192,1,192,2],[193,1,193,2],[184,1,184,2],[185,1,185,2],[186,1,186,2],[187,1,187,2],[188,1,188,2],[199,1,199,2],[200,1,200,2],[201,1,201,2],[202,1,202,2],[203,1,203,2],[194,1,194,2],[195,1,195,2],[196,1,196,2],[197,1,197,2],[198,1,198,2],[209,1,209,2],[210,1,210,2],[211,1,211,2],[212,1,212,2],[213,1,213,2],[204,1,204,2],[205,1,205,2],[206,1,206,2],[207,1,207,2],[208,1,208,2],[219,1,219,2],[220,1,220,2],[221,1,221,2],[222,1,222,2],[223,1,223,2],[214,1,214,2],[215,1,215,2],[216,1,216,2],[217,1,217,2],[218,1,218,2],[229,1,229,2],[230,1,230,2],[231,1,231,2],[232,1,232,2],[233,1,233,2],[224,1,224,2],[225,1,225,2],[226,1,226,2],[227,1,227,2],[228,1,228,2],[239,1,239,2],[240,1,240,2],[241,1,241,2],[242,1,242,2],[243,1,243,2],[234,1,234,2],[235,1,235,2],[236,1,236,2],[237,1,237,2],[238,1,238,2],[249,1,249,2],[250,1,250,2],[251,1,251,2],[252,1,252,2],[253,1,253,2],[244,1,244,2],[245,1,245,2],[246,1,246,2],[247,1,247,2],[248,1,248,2],[259,1,259,2],[260,1,260,2],[261,1,261,2],[262,1,262,2],[263,1,263,2],[254,1,254,2],[255,1,255,2],[256,1,256,2],[257,1,257,2],[258,1,258,2],[269,1,269,2],[270,1,270,2],[271,1,271,2],[272,1,272,2],[273,1,273,2],[264,1,264,2],[265,1,265,2],[266,1,266,2],[267,1,267,2],[268,1,268,2],[279,1,279,2],[280,1,280,2],[281,1,281,2],[282,1,282,2],[283,1,283,2],[274,1,274,2],[275,1,275,2],[276,1,276,2],[277,1,277,2],[278,1,278,2],[289,1,289,2],[290,1,290,2],[291,1,291,2],[292,1,292,2],[293,1,293,2],[284,1,284,2],[285,1,285,2],[286,1,286,2],[287,1,287,2],[288,1,288,2],[299,1,299,2],[300,1,300,2],[301,1,301,2],[302,1,302,2],[303,1,303,2],[294,1,294,2],[295,1,295,2],[296,1,296,2],[297,1,297,2],[298,1,298,2],[309,1,309,2],[310,1,310,2],[311,1,311,2],[312,1,312,2],[304,1,304,2],[305,1,305,2],[306,1,306,2],[307,1,307,2],[308,1,308,2]]}
["SUPPLIER CHARACTERISTIC SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS - TRACEABILITY"]
["Part Number",null,null,"Rev Level","Supplier Contact (Quality Dept):",null,null,null,null,null,null,null,null,null,null,null,"AQE / SQE:"]
[]
["Part Name / Description",null,null,null,"Contact Phone:",null,null,null,null,null,null,null,null,null,null,null,"Project / Program:",null,null,null,null,null,null,null,null,null,null,"Date Created:"]
[]
["Supplier Name",null,null,null,"Supplier Manufacturing Location:",null,null,null,null,null,null,null,null,null,null,null,"EPC Launch Period:",null,null,null,null,null,null,null,null,null,null,"Date Revised:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traceability Information"]
["Road Map #","Product Characteristic\nDescription",null,"Dimension & Tolerance (with units)","Class","PT","Lesson Learn Input","EPC\n(Y/N)?\nDouble confirm with Signed MAPP","Require Measurement Correlation\n (Y/N)?","In DFMEA\n(Y, N or N/A)?","In PFD (Y/N)?","In PFMEA (Y/N)?","Error Proofing",null,null,"Device Manual or Automated?","Production Process Control Plan",null,null,"Measurement System Analysis",null,"Initial Capability Study Data\n(Variable Data)\nDouble confirm with Signed MAPP",null,null,null,null,null,null,"Action Plan to resolve issues identified for a characteristic in this form\n\n(include action, name, date, completed)","Traceability Type","Traceability Location","Marking Type","Marking Content",null,null,null,null,null,null,null,null,null,"Lot Size","Traceability\nRecord","Linkage to Traceability  System","Traceability Origin","REMARKS /\nAction Plan to resolve issues identified for a characteristic in this form"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Describe the 100% Error-Proofing Method (enter \"none\" if no EP is planned)","Error-Proof Verification Method/ Freq\n(or N/A)","P\nor\nD",null,"Measurement Device Name","Control Method","Sampling\nPlan","Variable\n(%)","Attribute\n(kappa)","Sample Size of Cap. Study","Chart Type","Process Stability\nDemonstrated on Control Chart Y/N?","Ppk","Pp","Cpk","Cp",null,null,null,null,"Characterisitic Results","Part Consecutive #","Production Time","Production Date","Production Shift","Machine / Line / Tool #","Tool Cavity #","Pass / Fail","Other (please Specifiy)","Not Applicable"]

{"sheet":"EPC List","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,4,8,4],[7,5,8,5],[7,6,8,6],[6,0,6,6],[0,0,5,6],[7,0,8,0],[7,1,8,2],[7,3,8,3]]}
["EPC List (Auto Populate from SCS List)"]
[]
[]
[]
[]
[]
["Note: \nCopy below Characteristic list into F1075 EPC workbook and follow up EPC activity in safe launch phase."]
["Road Map #","Product Characteristic\nDescription",null,"Dimension & Tolerance (with units)","Class","PT","Lesson Learn Input"]
[]
[{"$f":"_xlfn._xlws.FILTER('SCS+Traceability+Gage-MSA Plan'!A11:G324,'SCS+Traceability+Gage-MSA Plan'!H11:H324=\"Yes\",\"\")","v":""}]

{"sheet":"Dropdown","index":3,"n_rows":17,"n_cols":33,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,0,17,0]]}
["LIST NAME","Class","-","-","-","-","-","-","-",null,"-","-","T_Type","T_Location","Marking","M_Content","T_Record","ERP","T_Source",null,null,null,null,null,null,null,null,null,null,null,null,"lzvg2c",{"$f":"IF(IFERROR(FIND(\"Z\",AF1,1),IFERROR(FIND(\"z\",AF1,1),0))=2,TRUE,FALSE)","v":true}]
["QUESTION","Class","PT","In DFMEA\nY, N or N/A?","In PFD Y/N?","In PFMEA Y/N?","EPC Y/N?","Require Measurement Correlation Y/N?","P or D","Device Manual or Automated?","Chart type","Process Stability\nDemonstrated on Control Chart Y/N?","Traceability\nType","Traceability\nLocation","Marking\nType","Marking\nContent","Traceability\nRecord","Linkage to ERP\nTraceability \n System","Traceability \nSource(s)"]
["ANSWER","CL1",null,null,null,null,"Yes","Yes",null,"Manual",null,"Yes","Singular","Part","DMC","Yes","Electronic","Yes","Sub-Supplier"]
[null,"CL2","PT","N/A","No","No","No","No","P  ","Automated","x-bar and R","No","Lot","Part Label","RFID","No","Hard Copy","No","Production Equipment"]
[null,"CL3",null,"No","Yes","Yes",null,null,"D",null,"x-bar and s",null,"Other (Specify)","Box Label","Bar Code",null,"Other (Specify)",null,"EOL Tester"]
[null,"CL4",null,"Yes",null,null,null,null,null,null,"I and MR",null,"NA","Master Label","Serialization",null,"NA",null,"Operator Checks"]
[null,"CL5",null,null,null,null,null,null,null,null,null,null,null,"Other (Specify)","Warranty Mark",null,null,null,"Other (Specify)"]
[null,"CL1-CMR",null,null,null,null,null,null,null,null,null,null,null,"NA","Tooling Marks",null,null,null,"N/A"]
[null,"CL2-CMR",null,null,null,null,null,null,null,null,null,null,null,null,"Label Info"]
[null,"CL3-CMR",null,null,null,null,null,null,null,null,null,null,null,null,"Other (Specify)"]
[null,"CL4-CMR",null,null,null,null,null,null,null,null,null,null,null,null,"NA"]
[null,"CL5-CMR"]
[null,"CI-100V"]
[null,"CI-DR"]
[null,"QS-100V"]
[null,"QS-DR"]
[null,"KPC"]