{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Introduction","Supplier Information","GMAW Welding Requirements ","LBW Welding Requirements","Resistance Welding Requirements","FW Welding Requirements","Induction Welding Requirements","UT Implemetation Checklist","GMAW - Safe Launch","LBW - Safe Launch","Resistance - Safe Launch","Fastener Welding - Safe Launch","Spin Welding - Safe Launch","Induction Welding- Safe Launch ","Riveting - Safe Launch ","Revision History","Sheet1"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":43,"comments":0,"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":"Introduction","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,1,"Introduction"]
[null,null,"",null,null,null,null,null,null,null,null,2,"Supplier Information"]
[null,null,null,null,null,null,null,null,null,null,null,3,"GMAW Welding Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,4,"LBW Welding Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,5,"Resistance Welding Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,6,"FW Welding Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,7,"Induction Welding Requirements"]
[null,null,null,null,null,null,null,null,null,null,null,8,"UT Implementation Checklist"]
[null,null,null,null,null,null,null,null,null,null,null,9,"GMAW - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,10,"LBW - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,11,"Resistance - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,12,"Fastener Welding - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,13,"Spin Welding - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,14,"Induction Welding  - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,15,"Riveting - Safe Launch"]
[null,null,null,null,null,null,null,null,null,null,null,16,"Revision History"]

{"sheet":"Supplier Information","index":1,"n_rows":177,"n_cols":9,"rows_kept":177,"cut":false,"hidden":false,"merged":[[68,2,68,3],[69,2,69,3],[94,2,94,3],[95,2,95,3],[118,2,118,3],[96,2,96,3],[92,2,92,3],[116,2,116,3],[4,5,5,5],[34,5,44,8],[29,2,29,3],[30,2,30,3],[33,5,33,8],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[28,2,28,3],[20,4,20,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[120,2,120,3],[124,2,124,3],[134,2,134,3],[136,2,136,3],[119,2,119,3],[18,4,18,5],[19,4,19,5],[70,2,70,3],[6,4,7,4],[175,3,175,8],[162,2,162,3],[165,2,165,3],[166,2,166,3],[160,2,160,3],[171,1,171,3],[101,2,101,3],[108,2,108,3],[110,2,110,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[46,2,46,3],[47,2,47,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[174,3,174,8],[139,2,139,3],[140,2,140,3],[142,2,142,3],[146,2,146,3],[150,2,150,3],[144,2,144,3],[145,2,145,3],[169,2,169,3],[170,2,170,3],[6,5,7,5],[0,2,0,5],[176,3,176,8],[2,4,3,4],[2,5,3,5],[51,2,51,3],[58,2,58,3],[60,2,60,3],[63,2,63,3],[74,2,74,3],[82,2,82,3],[84,2,84,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[4,4,5,4]]}
[null,"Save File As:","Supplier Name_Site Code_Country_State_City_Year_Month_Day_Weld Assessment"]
[]
[null,"Supplier Name:","",null,"Current Status",{"$f":"(IF(F172>=1,\"RED\",IF(F5<0.9999,\"YELLOW\",IF(F5>=0.9999,\"GREEN\",\"\"))))","v":"YELLOW"},null,null,"CTQ Red"]
[null,"Street Address:",null,null,null,null,null,null,"CTQ Yellow"]
[null,"Country/City/State/ZIP Code",null,null,"% Compliance",{"$f":"_xlfn.AGGREGATE(5,6,B49,B72,B98,B122,B148)","v":0},null,null,"CTQ Green"]
[null,"Date of Initial Supplier Review"]
[null,"Date of Follow-up Supplier Review",null,null,"CTQ % Compliance",{"$f":"_xlfn.AGGREGATE(5,6,B51,B74,B100,B124,B150)","v":0}]
[null,"Site Code:"]
[null,"Parent Code:"]
[null,"Review Members","Title","Email Address","Phone"]
[]
[]
[]
[null,"Site Responsible Person / STA"]
[]
[null,"Supplier Contacts"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Personnel Trained:",{"$f":"COUNTA(B17:B26)","v":0}]
[]
[null,"Weld Classifications",null,null,null,"Ship To Location","Tier Level to Ford","Contact Name","Contact Information"]
[null,"Processes Used:"]
[null,"Welding Specifications Used:"]
[null,"Commodity Code"]
[]
[null,"Ford Part Number","Vehicle / Program","Product Information",null,"Overall Summary Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WELDING PROCESS","AREA",null,"% Compliance of Rated Elements","RED","YELLOW","GREEN","Total Red & Yellow"]
[null,"GMAW Overall","1. PART PRINT",null,{"$f":"1-I48/(I48+H48)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('GMAW Welding Requirements '!K8:K13,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!$K$8:K$13,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!$K$8:K$13,\"GREEN\")","v":0},{"$f":"SUM(F48:G48)","v":0}]
[null,{"$f":"1-SUM(F48:G48,F52:G52,F59:G59,F61:G61,F64:G67)/SUM(F48:H48,F52:H52,F59:H59,F61:H61,F64:H67)","v":{"$error":"#DIV/0!"}},null,"Weld Specification",{"$f":"'GMAW Welding Requirements '!K8","v":0},{"$f":"IF('GMAW Welding Requirements '!K8=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K8=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K8=\"green\",1,0)","v":0}]
[null,"GMAW CTQ",null,"Weld Identification",{"$f":"'GMAW Welding Requirements '!K9","v":0},{"$f":"IF('GMAW Welding Requirements '!K9=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K9=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K9=\"green\",1,0)","v":0}]
[null,{"$f":"1-SUM(F49:G51,F53:G58,F60:G60,F62:G63,F68:G68)/SUM(F49:H51,F53:H58,F60:H60,F62:H63,F68:H68)","v":{"$error":"#DIV/0!"}},null,"Weld Classification",{"$f":"'GMAW Welding Requirements '!K11","v":0},{"$f":"IF('GMAW Welding Requirements '!K11=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K11=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K11=\"green\",1,0)","v":0}]
[null,null,"2. CONTROL PLAN",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K15:K25,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K15:K25,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K15:K25,\"GREEN\")","v":0},{"$f":"SUM(F52:G52)","v":0}]
[null,null,null,"Weld Quality Inspection",{"$f":"'GMAW Welding Requirements '!K16","v":0},{"$f":"IF('GMAW Welding Requirements '!K16=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K16=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K16=\"green\",1,0)","v":0}]
[null,null,null,"Cut and Etch",{"$f":"'GMAW Welding Requirements '!K17","v":0},{"$f":"IF('GMAW Welding Requirements '!K17=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K17=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K17=\"green\",1,0)","v":0}]
[null,null,null,"Weld Identification in Control Plan","='GMAW Welding Requirements '!K19",{"$f":"IF('GMAW Welding Requirements '!K19=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K19=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K19=\"green\",1,0)","v":0}]
[null,null,null,"Weld Lot Containment",{"$f":"'GMAW Welding Requirements '!K20","v":0},{"$f":"IF('GMAW Welding Requirements '!K20=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K20=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K20=\"green\",1,0)","v":0}]
[null,null,null,"Control of Changes and Unplanned Events",{"$f":"'GMAW Welding Requirements '!K21","v":0},{"$f":"IF('GMAW Welding Requirements '!K21=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K21=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K21=\"green\",1,0)","v":0}]
[null,null,null,"Identification and Control of Nonconforming Parts",{"$f":"'GMAW Welding Requirements '!K24","v":0},{"$f":"IF('GMAW Welding Requirements '!K24=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K24=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K24=\"green\",1,0)","v":0}]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K27:K29,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K27:K29,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K27:K29,\"GREEN\")","v":0},{"$f":"SUM(F59:G59)","v":0}]
[null,null,null,"Destructive Testing Data",{"$f":"'GMAW Welding Requirements '!K27","v":0},{"$f":"IF('GMAW Welding Requirements '!K27=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K27=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K27=\"green\",1,0)","v":0}]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K31:K40,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K31:K40,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K31:K40,\"GREEN\")","v":0},{"$f":"SUM(F61:G61)","v":0}]
[null,null,null,"Weld Cross Section Examination",{"$f":"'GMAW Welding Requirements '!K33","v":0},{"$f":"IF('GMAW Welding Requirements '!K33=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K33=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K33=\"green\",1,0)","v":0}]
[null,null,null,"Cross Section Analysis Technique",{"$f":"'GMAW Welding Requirements '!K35","v":0},{"$f":"IF('GMAW Welding Requirements '!K35=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K35=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K35=\"green\",1,0)","v":0}]
[null,null,"5. REWORK PROCEDURE & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K42:K50,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K42:K50,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K42:K50,\"GREEN\")","v":0},{"$f":"SUM(F64:G64)","v":0}]
[null,null,"6. PARAMETER DOCUMENTATION",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K52:K71,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K52:K71,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K52:K71,\"GREEN\")","v":0},{"$f":"SUM(F65:G65)","v":0}]
[null,null,"7. MAINTENANCE RECORDS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K73:K79,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K73:K79,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K73:K79,\"GREEN\")","v":0},{"$f":"SUM(F66:G66)","v":0}]
[null,null,"8. SUSTAINABILITY",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('GMAW Welding Requirements '!K81:K82,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K81:K82,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K81:K82,\"GREEN\")","v":0},{"$f":"SUM(F67:G67)","v":0}]
[null,null,null,"Sustainability Prove Out",{"$f":"'GMAW Welding Requirements '!K81","v":0},{"$f":"IF('GMAW Welding Requirements '!K81=\"red\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K81=\"yellow\",1,0)","v":0},{"$f":"IF('GMAW Welding Requirements '!K81=\"green\",1,0)","v":0}]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS",null,null,{"$f":"COUNTIF('GMAW Welding Requirements '!K84:K89,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K84:K89,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K84:K89,\"GREEN\")","v":0},{"$f":"SUM(F69:G69)","v":0}]
[null,null,"10. OTHER",null,null,{"$f":"COUNTIF('GMAW Welding Requirements '!K91:K91,\"red\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K91:K91,\"YELLOW\")","v":0},{"$f":"COUNTIF('GMAW Welding Requirements '!K91:K91,\"GREEN\")","v":0},{"$f":"SUM(F70:G70)","v":0}]
[null,"LASER Overall","1. PART PRINT",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K8:K13,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K8:K13,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K8:K13,\"GREEN\")","v":0},{"$f":"SUM(F71:G71)","v":0}]
[null,{"$f":"1-SUM(F71:G71,F75:G75,F83:G83,F85:G85,F88:G90,F93:G93)/SUM(F71:H71,F75:H75,F83:H83,F85:H85,F88:H90,F93:H93)","v":{"$error":"#DIV/0!"}},null,"Welding Specifications",{"$f":"'LBW Welding Requirements'!K8","v":0},{"$f":"IF('LBW Welding Requirements'!K8=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K8=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K8=\"green\",1,0)","v":0}]
[null,"LASER CTQ",null,"Weld Identification",{"$f":"'LBW Welding Requirements'!K9","v":0},{"$f":"IF('LBW Welding Requirements'!K9=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K9=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K9=\"green\",1,0)","v":0}]
[null,{"$f":"1-SUM(F72:G74,F76:G82,F84:G84,F86:G87,F91:G92,F94:G94)/SUM(F72:H74,F76:H82,F84:H84,F86:H87,F91:H92,F94:H94)","v":{"$error":"#DIV/0!"}},null,"Weld Classification",{"$f":"'LBW Welding Requirements'!K11","v":0},{"$f":"IF('LBW Welding Requirements'!K11=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K11=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K11=\"green\",1,0)","v":0}]
[null,null,"2. CONTROL PLAN",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K15:K26,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K15:K26,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K15:K26,\"GREEN\")","v":0},{"$f":"SUM(F75:G75)","v":0}]
[null,null,null,"Weld Quality Inspection",{"$f":"'LBW Welding Requirements'!K16","v":0},{"$f":"IF('LBW Welding Requirements'!K16=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K16=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K16=\"green\",1,0)","v":0}]
[null,null,null,"Cut and Etch",{"$f":"'LBW Welding Requirements'!K17","v":0},{"$f":"IF('LBW Welding Requirements'!K17=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K17=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K17=\"green\",1,0)","v":0}]
[null,null,null,"Hardness Testing",{"$f":"'LBW Welding Requirements'!K18","v":0},{"$f":"IF('LBW Welding Requirements'!K18=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K18=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K18=\"green\",1,0)","v":0}]
[null,null,null,"Weld Identification in Control Plan",{"$f":"'LBW Welding Requirements'!K20","v":0},{"$f":"IF('LBW Welding Requirements'!K20=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K20=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K20=\"green\",1,0)","v":0}]
[null,null,null,"Weld Lot Containment",{"$f":"'LBW Welding Requirements'!K21","v":0},{"$f":"IF('LBW Welding Requirements'!K21=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K21=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K21=\"green\",1,0)","v":0}]
[null,null,null,"Control of Changes and Unplanned Events",{"$f":"'LBW Welding Requirements'!K22","v":0},{"$f":"IF('LBW Welding Requirements'!K22=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K22=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K22=\"green\",1,0)","v":0}]
[null,null,null,"Identification and Control of Nonconforming Parts",{"$f":"'LBW Welding Requirements'!K25","v":0},{"$f":"IF('LBW Welding Requirements'!K25=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K25=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K25=\"green\",1,0)","v":0}]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K28:K30,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K28:K30,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K28:K30,\"GREEN\")","v":0},{"$f":"SUM(F83:G83)","v":0}]
[null,null,null,"Destructive Testing Data",{"$f":"'LBW Welding Requirements'!K28","v":0},{"$f":"IF('LBW Welding Requirements'!K28=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K28=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K28=\"green\",1,0)","v":0}]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K32:K42,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K32:K42,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K32:K42,\"GREEN\")","v":0},{"$f":"SUM(F85:G85)","v":0}]
[null,null,null,"Weld Cross Section Examination",{"$f":"'LBW Welding Requirements'!K34","v":0},{"$f":"IF('LBW Welding Requirements'!K34=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K34=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K34=\"green\",1,0)","v":0}]
[null,null,null,"Cross Section Analysis Technique",{"$f":"'LBW Welding Requirements'!K36","v":0},{"$f":"IF('LBW Welding Requirements'!K36=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K36=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K36=\"green\",1,0)","v":0}]
[null,null,"5. REWORK PROCEDURE & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K44:K52,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K44:K52,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K44:K52,\"GREEN\")","v":0},{"$f":"SUM(F88:G88)","v":0}]
[null,null,"6. PARAMETER DOCUMENTATION",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K54:K90,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K54:K90,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K54:K90,\"GREEN\")","v":0},{"$f":"SUM(F89:G89)","v":0}]
[null,null,"7. MAINTENANCE RECORDS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K92:K100,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K92:K100,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K92:K100,\"GREEN\")","v":0},{"$f":"SUM(F90:G90)","v":0}]
[null,null,null,"Run Out Check of Fixture Rotators",{"$f":"'LBW Welding Requirements'!K97","v":0},{"$f":"IF('LBW Welding Requirements'!K97=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K97=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K97=\"green\",1,0)","v":0}]
[null,null,null,"Air Knife",{"$f":"'LBW Welding Requirements'!K98","v":0},{"$f":"IF('LBW Welding Requirements'!K98=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K98=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K98=\"green\",1,0)","v":0}]
[null,null,"8. SUSTAINABILITY",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('LBW Welding Requirements'!K102:K103,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K102:K103,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K102:K103,\"GREEN\")","v":0},{"$f":"SUM(F93:G93)","v":0}]
[null,null,null,"Weld Sustainability Prove Out",{"$f":"'LBW Welding Requirements'!K102","v":0},{"$f":"IF('LBW Welding Requirements'!K102=\"red\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K102=\"yellow\",1,0)","v":0},{"$f":"IF('LBW Welding Requirements'!K102=\"green\",1,0)","v":0}]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS \nLASER WELD MONITORING (SPL6.15)",null,null,{"$f":"COUNTIF('LBW Welding Requirements'!K105:K106,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K105:K106,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K105:K106,\"GREEN\")","v":0},{"$f":"SUM(F95:G95)","v":0}]
[null,null,"10. OTHER",null,null,{"$f":"COUNTIF('LBW Welding Requirements'!K108:K108,\"red\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K108:K108,\"YELLOW\")","v":0},{"$f":"COUNTIF('LBW Welding Requirements'!K108:K108,\"GREEN\")","v":0},{"$f":"SUM(F96:G96)","v":0}]
[null,"Resistance Overall","1. PART PRINT",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K8:K12,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K8:K12,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K8:K12,\"GREEN\")","v":0},{"$f":"SUM(F97:G97)","v":0}]
[null,{"$f":"1-SUM(F97:G97,F102:G102,F109:G109,F111:G111,F113:G117)/SUM(F97:H97,F102:H102,F109:H109,F111:H111,F113:H117)","v":{"$error":"#DIV/0!"}},null,"Welding Specifications",{"$f":"'Resistance Welding Requirements'!K8","v":0},{"$f":"IF('Resistance Welding Requirements'!K8=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K8=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K8=\"green\",1,0)","v":0}]
[null,"Resistance CTQ",null,"Weld Identification",{"$f":"'Resistance Welding Requirements'!K9","v":0},{"$f":"IF('Resistance Welding Requirements'!K9=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K9=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K9=\"green\",1,0)","v":0}]
[null,{"$f":"1-SUM(F98:G101,F103:G108,F110:G110,F112:G112,F116:G116,F118:G118)/SUM(F98:H101,F103:H108,F110:H110,F112:H112,F116:H116,F118:H118)","v":{"$error":"#DIV/0!"}},null,"Weld Classification",{"$f":"'Resistance Welding Requirements'!K11","v":0},{"$f":"IF('Resistance Welding Requirements'!K11=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K11=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K11=\"green\",1,0)","v":0}]
[null,null,null,"Weld Grouping",{"$f":"'Resistance Welding Requirements'!K12","v":0},{"$f":"IF('Resistance Welding Requirements'!K12=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K12=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K12=\"green\",1,0)","v":0}]
[null,null,"2. CONTROL PLAN",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K14:K25,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K14:K25,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K14:K25,\"GREEN\")","v":0},{"$f":"SUM(F102:G102)","v":0}]
[null,null,null,"Weld Quality Inspection",{"$f":"'Resistance Welding Requirements'!K15","v":0},{"$f":"IF('Resistance Welding Requirements'!K15=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I15=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I15=\"green\",1,0)","v":0}]
[null,null,null,"Destructive Testing ",{"$f":"'Resistance Welding Requirements'!K16","v":0},{"$f":"IF('Resistance Welding Requirements'!K16=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I16=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I16=\"green\",1,0)","v":0}]
[null,null,null,"Weld Identification in Control Plan",{"$f":"'Resistance Welding Requirements'!K19","v":0},{"$f":"IF('Resistance Welding Requirements'!K19=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I19=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I19=\"green\",1,0)","v":0}]
[null,null,null,"Weld Lot Containment",{"$f":"'Resistance Welding Requirements'!K20","v":0},{"$f":"IF('Resistance Welding Requirements'!K20=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I20=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I20=\"green\",1,0)","v":0}]
[null,null,null,"Control of Changes and Unplanned Events",{"$f":"'Resistance Welding Requirements'!K21","v":0},{"$f":"IF('Resistance Welding Requirements'!K21=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I21=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!I21=\"green\",1,0)","v":0}]
[null,null,null,"Identification and Control of Nonconforming Parts",{"$f":"'Resistance Welding Requirements'!K24","v":0},{"$f":"IF('Resistance Welding Requirements'!K24=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K24=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K24=\"green\",1,0)","v":0}]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K27:K29,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K27:K29,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K27:K29,\"GREEN\")","v":0},{"$f":"SUM(F109:G109)","v":0}]
[null,null,null,"Destructive Testing Data",{"$f":"'Resistance Welding Requirements'!K27","v":0},{"$f":"IF('Resistance Welding Requirements'!K27=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K27=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K27=\"green\",1,0)","v":0}]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K31:K39,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K31:K39,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K31:K39,\"GREEN\")","v":0},{"$f":"SUM(F111:G111)","v":0}]
[null,null,null,"Weld Attribute Measurements",{"$f":"'Resistance Welding Requirements'!K34","v":0},{"$f":"IF('Resistance Welding Requirements'!K34=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K34=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K34=\"green\",1,0)","v":0}]
[null,null,"5. REWORK PROCEDURE & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K41:K49,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K41:K49,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K41:K49,\"GREEN\")","v":0},{"$f":"SUM(F113:G113)","v":0}]
[null,null,"6. PARAMETER DOCUMENTATION",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K51:K76,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K51:K76,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K51:K76,\"GREEN\")","v":0},{"$f":"SUM(F114:G114)","v":0}]
[null,null,"7. MAINTENANCE RECORDS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K78:K86,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K78:K86,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K78:K86,\"GREEN\")","v":0},{"$f":"SUM(F115:G115)","v":0}]
[null,null,null,"Electrode Management",{"$f":"'Resistance Welding Requirements'!K85","v":0},{"$f":"IF('Resistance Welding Requirements'!K85=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K85=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K85=\"green\",1,0)","v":0}]
[null,null,"8. SUSTAINABILITY",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Resistance Welding Requirements'!K88:K90,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K88:K90,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K88:K90,\"GREEN\")","v":0},{"$f":"SUM(F117:G117)","v":0}]
[null,null,null,"Weld Sustainability Prove Out",{"$f":"'Resistance Welding Requirements'!K88","v":0},{"$f":"IF('Resistance Welding Requirements'!K88=\"red\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K88=\"yellow\",1,0)","v":0},{"$f":"IF('Resistance Welding Requirements'!K88=\"green\",1,0)","v":0},{"$f":"SUM(F118:G118)","v":0}]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS",null,null,{"$f":"COUNTIF('Resistance Welding Requirements'!K92:K92,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K92:K92,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K92:K92,\"GREEN\")","v":0},{"$f":"SUM(F119:G119)","v":0}]
[null,null,"10. OTHER",null,null,{"$f":"COUNTIF('Resistance Welding Requirements'!K94:K94,\"red\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K94:K94,\"YELLOW\")","v":0},{"$f":"COUNTIF('Resistance Welding Requirements'!K94:K94,\"GREEN\")","v":0},{"$f":"SUM(F120:G120)","v":0}]
[null,"Friction Overall","1. PART PRINT",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K8:K11,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K8:K11,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K8:K11,\"GREEN\")","v":0},{"$f":"SUM(F121:G121)","v":0}]
[null,{"$f":"1-SUM(F121:G121,F125:G125,F135:G135,F137:G137,F140:G141,F143:G143)/SUM(F121:H121,F125:H125,F135:H135,F137:H137,F140:H141,F143:H143)","v":{"$error":"#DIV/0!"}},null,"Welding Specifications",{"$f":"'FW Welding Requirements'!K8","v":0},{"$f":"IF('FW Welding Requirements'!K8=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K8=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K8=\"green\",1,0)","v":0}]
[null,"Friction CTQ",null,"Weld Identification",{"$f":"'FW Welding Requirements'!K9","v":0},{"$f":"IF('FW Welding Requirements'!K9=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K9=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K9=\"green\",1,0)","v":0}]
[null,{"$f":"1-SUM(F122:G124,F126:G134,F136:G136,F138:G139,F142:G142,F144:G144)/SUM(F122:H124,F126:H134,F136:H136,F138:H139,F142:H142,F144:H144)","v":{"$error":"#DIV/0!"}},null,"Weld Classification",{"$f":"'FW Welding Requirements'!K11","v":0},{"$f":"IF('FW Welding Requirements'!K11=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K11=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K11=\"green\",1,0)","v":0}]
[null,null,"2. CONTROL PLAN",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K13:K28,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K13:K28,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K13:K28,\"GREEN\")","v":0},{"$f":"SUM(F125:G125)","v":0}]
[null,null,null,"Weld Quality Inspection",{"$f":"'FW Welding Requirements'!K14","v":0},{"$f":"IF('FW Welding Requirements'!K14=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K14=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K14=\"green\",1,0)","v":0}]
[null,null,null,"Cut and Etch",{"$f":"'FW Welding Requirements'!K15","v":0},{"$f":"IF('FW Welding Requirements'!K15=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K15=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K15=\"green\",1,0)","v":0}]
[null,null,null,"Flow lines",{"$f":"'FW Welding Requirements'!K17","v":0},{"$f":"IF('FW Welding Requirements'!K17=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K17=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K17=\"green\",1,0)","v":0}]
[null,null,null,"Hardness Testing",{"$f":"'FW Welding Requirements'!K21","v":0},{"$f":"IF('FW Welding Requirements'!K21=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K21=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K21=\"green\",1,0)","v":0}]
[null,null,null,"Weld Identification in Control Plan",{"$f":"'FW Welding Requirements'!K22","v":0},{"$f":"IF('FW Welding Requirements'!K22=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K22=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K22=\"green\",1,0)","v":0}]
[null,null,null,"Destructive Testing ",{"$f":"'FW Welding Requirements'!K18","v":0},{"$f":"IF('FW Welding Requirements'!K18=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K18=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K18=\"green\",1,0)","v":0}]
[null,null,null,"Weld Lot Containment",{"$f":"'FW Welding Requirements'!K23","v":0},{"$f":"IF('FW Welding Requirements'!K23=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K23=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K23=\"green\",1,0)","v":0}]
[null,null,null,"Identification and Control of Nonconforming Parts",{"$f":"'FW Welding Requirements'!K27","v":0},{"$f":"IF('FW Welding Requirements'!K27=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K27=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K27=\"green\",1,0)","v":0}]
[null,null,null,"Control of Changes and Unplanned Events",{"$f":"'FW Welding Requirements'!K24","v":0},{"$f":"IF('FW Welding Requirements'!K24=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K24=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K24=\"green\",1,0)","v":0}]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K30:K32,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K30:K32,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K30:K32,\"GREEN\")","v":0},{"$f":"SUM(F135:G135)","v":0}]
[null,null,null,"Destructive Testing Data",{"$f":"'FW Welding Requirements'!K30","v":0},{"$f":"IF('FW Welding Requirements'!K30=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K30=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K30=\"green\",1,0)","v":0}]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K34:K43,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K34:K43,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K34:K43,\"GREEN\")","v":0},{"$f":"SUM(F137:G137)","v":0}]
[null,null,null,"Weld Cross Section Examination",{"$f":"'FW Welding Requirements'!K36","v":0},{"$f":"IF('FW Welding Requirements'!K36=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K36=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K36=\"green\",1,0)","v":0}]
[null,null,null,"Cross Section Analysis Technique",{"$f":"'FW Welding Requirements'!K38","v":0},{"$f":"IF('FW Welding Requirements'!K38=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K38=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K38=\"green\",1,0)","v":0}]
[null,null,"6. PARAMETER DOCUMENTATION",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K45:K71,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K45:K71,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K45:K71,\"GREEN\")","v":0},{"$f":"SUM(F140:G140)","v":0}]
[null,null,"7. MAINTENANCE RECORDS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K73:K78,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K73:K78,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K73:K78,\"GREEN\")","v":0},{"$f":"SUM(F141:G141)","v":0}]
[null,null,null,"Limit Verification",{"$f":"'FW Welding Requirements'!K76","v":0},{"$f":"IF('FW Welding Requirements'!K76=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K76=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K76=\"green\",1,0)","v":0}]
[null,null,"8. SUSTAINABILITY",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('FW Welding Requirements'!K80,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K80,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K80,\"GREEN\")","v":0},{"$f":"SUM(F143:G143)","v":0}]
[null,null,null,"Weld Sustainability Prove Out",{"$f":"'FW Welding Requirements'!K80","v":0},{"$f":"IF('FW Welding Requirements'!K80=\"red\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K80=\"yellow\",1,0)","v":0},{"$f":"IF('FW Welding Requirements'!K80=\"green\",1,0)","v":0}]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS",null,null,{"$f":"COUNTIF('FW Welding Requirements'!K82:K82,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K82:K82,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K82:K82,\"GREEN\")","v":0},{"$f":"SUM(F145:G145)","v":0}]
[null,null,"10. OTHER",null,null,{"$f":"COUNTIF('FW Welding Requirements'!K84:K84,\"red\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K84:K84,\"YELLOW\")","v":0},{"$f":"COUNTIF('FW Welding Requirements'!K84:K84,\"GREEN\")","v":0},{"$f":"SUM(F146:G146)","v":0}]
[null,"Induction Overall","1. PART PRINT",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Induction Welding Requirements'!$K8:$K11,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K8:$K11,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K8:$K11,\"green\")","v":0},{"$f":"SUM(F147:G147)","v":0}]
[null,{"$f":"1-SUM(F147:G147,F151:G151,F161:G161,F163:G163,F166:G168)/SUM(F147:H147,F151:H151,F161:H161,F163:H163,F166:H168)","v":{"$error":"#DIV/0!"}},null,"Weld Specification",{"$f":"'Induction Welding Requirements'!K8","v":0},{"$f":"IF('Induction Welding Requirements'!K8=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K8=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K8=\"Green\",1,0)","v":0}]
[null,"Induction CTQ",null,"Weld Identification",{"$f":"'Induction Welding Requirements'!K9","v":0},{"$f":"IF('Induction Welding Requirements'!K9=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K9=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K9=\"Green\",1,0)","v":0}]
[null,{"$f":"1-SUM(F148:G150,F152:G160,F162:G162,F164:G165,F169:G169)/SUM(F148:H150,F152:H160,F162:H162,F164:H165,F169:H169)","v":{"$error":"#DIV/0!"}},null,"Weld Classification",{"$f":"'Induction Welding Requirements'!K11","v":0},{"$f":"IF('Induction Welding Requirements'!K11=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K11=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K11=\"Green\",1,0)","v":0}]
[null,null,"2. CONTROL PLAN",null,{"$f":"1-I151/(I151+H151)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Induction Welding Requirements'!$K13:$K25,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K13:$K25,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K13:$K25,\"green\")","v":0},{"$f":"SUM(F151:G151)","v":0}]
[null,null,null,"Weld Quality Inspection",{"$f":"'Induction Welding Requirements'!K13","v":0},{"$f":"IF('Induction Welding Requirements'!K13=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K13=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K13=\"Green\",1,0)","v":0}]
[null,null,null,"Cut and Etch",{"$f":"'Induction Welding Requirements'!K14","v":0},{"$f":"IF('Induction Welding Requirements'!K14=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K14=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K14=\"Green\",1,0)","v":0}]
[null,null,null,"Flow lines",{"$f":"'Induction Welding Requirements'!K16","v":0},{"$f":"IF('Induction Welding Requirements'!K16=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K16=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K16=\"Green\",1,0)","v":0}]
[null,null,null,"Hardness Testing",{"$f":"'Induction Welding Requirements'!K19","v":0},{"$f":"IF('Induction Welding Requirements'!K19=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K19=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K19=\"Green\",1,0)","v":0}]
[null,null,null,"Weld Identification in Control Plan",{"$f":"'Induction Welding Requirements'!K20","v":0},{"$f":"IF('Induction Welding Requirements'!K20=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K20=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K20=\"Green\",1,0)","v":0}]
[null,null,null,"Destructive Testing ",{"$f":"'Induction Welding Requirements'!K17","v":0},{"$f":"IF('Induction Welding Requirements'!K17=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K17=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K17=\"Green\",1,0)","v":0}]
[null,null,null,"Weld Lot Containment",{"$f":"'Induction Welding Requirements'!K21","v":0},{"$f":"IF('Induction Welding Requirements'!K21=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K21=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K21=\"Green\",1,0)","v":0}]
[null,null,null,"Identification and Control of Nonconforming Parts",{"$f":"'Induction Welding Requirements'!K24","v":0},{"$f":"IF('Induction Welding Requirements'!K24=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K24=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K24=\"Green\",1,0)","v":0}]
[null,null,null,"Control of Changes and Unplanned Events",{"$f":"'Induction Welding Requirements'!K22","v":0},{"$f":"IF('Induction Welding Requirements'!K22=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K22=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K22=\"Green\",1,0)","v":0}]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA",null,{"$f":"1-I161/(I161+H161)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Induction Welding Requirements'!$K27:$K29,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K27:$K29,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K27:$K29,\"green\")","v":0},{"$f":"SUM(F161:G161)","v":0}]
[null,null,null,"Destructive Testing Data",{"$f":"'Induction Welding Requirements'!K27","v":0},{"$f":"IF('Induction Welding Requirements'!K27=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K27=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K27=\"Green\",1,0)","v":0}]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS",null,{"$f":"1-I163/(I163+H163)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Induction Welding Requirements'!$K31:$K40,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K31:$K40,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K31:$K40,\"green\")","v":0},{"$f":"SUM(F163:G163)","v":0}]
[null,null,null,"Weld Cross Section Examination",{"$f":"'Induction Welding Requirements'!K33","v":0},{"$f":"IF('Induction Welding Requirements'!K33=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K33=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K33=\"Green\",1,0)","v":0}]
[null,null,null,"Cross Section Analysis Technique",{"$f":"'Induction Welding Requirements'!K35","v":0},{"$f":"IF('Induction Welding Requirements'!K35=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K35=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K35=\"Green\",1,0)","v":0}]
[null,null,"6. PARAMETER DOCUMENTATION",null,{"$f":"1-I166/(I166+H166)","v":{"$error":"#DIV/0!"}},{"$f":"COUNTIF('Induction Welding Requirements'!$K42:$K56,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K42:$K56,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K42:$K56,\"green\")","v":0},{"$f":"SUM(F166:G166)","v":0}]
[null,null,"7. MAINTENANCE RECORDS",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Induction Welding Requirements'!$K58:$K60,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K58:$K60,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K58:$K60,\"green\")","v":0},0]
[null,null,"8. SUSTAINABILITY",null,{"$error":"#DIV/0!"},{"$f":"COUNTIF('Induction Welding Requirements'!K62,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!K62,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!K62,\"green\")","v":0},0]
[null,null,null,"Weld Sustainability Prove Out",{"$f":"'Induction Welding Requirements'!K62","v":0},{"$f":"IF('Induction Welding Requirements'!K62=\"red\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K62=\"Yellow\",1,0)","v":0},{"$f":"IF('Induction Welding Requirements'!K62=\"Green\",1,0)","v":0},0]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS",null,null,{"$f":"COUNTIF('Induction Welding Requirements'!$K64:$K64,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K64:$K64,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K64:$K64,\"green\")","v":0},0]
[null,null,"10. OTHER",null,null,{"$f":"COUNTIF('Induction Welding Requirements'!$K66:$K66,\"red\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K66:$K66,\"yellow\")","v":0},{"$f":"COUNTIF('Induction Welding Requirements'!$K66:$K66,\"green\")","v":0},0]
[null,"Summed",null,null,{"$f":"AVERAGE(E48:E143)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F48,F52,F59,F61,F64:F67,F71,F75,F83,F85,F88:F90,F93,F97,F102,F109,F111,F113,F114:F115,F117,F121,F125,F135,F137,F140:F141,F143,F147,F151,F161,F163,F166,F167,F168)","v":0},{"$f":"SUM(G48,G52,G59,G61,G64:G67,G71,G75,G83,G85,G88:G90,G93,G97,G102,G109,G111,G113,G114:G115,G117,G121,G125,G135,G137,G140:G141,G143,G147,G151,G161,G163,G166,G167,G168)","v":0},{"$f":"SUM(H48,H52,H59,H61,H64:H67,H71,H75,H83,H85,H88:H90,H93,H97,H102,H109,H111,H113,H114:H115,H117,H121,H125,H135,H137,H140:H141,H143,H147,H151,H161,H163,H166,H167,H168)","v":0},{"$f":"SUM(I48,I52,I59,I61,I64:I67,I71,I75,I83,I85,I88:I90,I93,I97,I102,I109,I111,I113,I114:I115,I117,I121,I125,I135,I137,I140:I141,I143,I147,I151,I161,I163,I166,I167,I169)","v":0}]
[]
[]
[null,"Red","Any RED Element","Does NOT meet the standard, needs immediate action.\nProcess review indicates that there is a risk of non-conforming product."]
[null,"Yellow","<100% GREEN -0- RED","Does NOT meet the standard, containment is in place.\nProcess review indicates that there is sufficient containment of non-conforming product."]
[null,"Green","100% GREEN","Meets the standard"]

{"sheet":"GMAW Welding Requirements ","index":2,"n_rows":91,"n_cols":21,"rows_kept":91,"cut":false,"hidden":false,"merged":[[89,2,89,3],[0,2,0,20],[71,2,71,3],[79,2,79,3],[2,7,2,9],[6,2,6,3],[13,2,13,3],[25,2,25,3],[29,2,29,3],[40,2,40,3],[50,2,50,3],[82,2,82,3]]}
[null,null,"                   Gas Metal Arc Welding Process Controls Checklist      "]
[]
[null,null,"","Assessor",{"$f":"'Supplier Information'!B11","v":0},null,"Welding Plant",{"$f":"'Supplier Information'!C3","v":""},null,null,null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Company)",null,null,"(Name - Location)"]
[]
[null,null,"Item No.","Area","Requirements","Char. Class. (min level)","Test / Inspection Frequencies (minimum)","Recommended Control Method","Initial Rating (R/Y/G) ","Evidence / Gap Identified","Current Status (R/Y/G) ","Additional Comments","Additional Information \nNOT TO BE RATED","Best Practice\nNOT TO BE RATED","Responsible Person","Management Champion","ICA","Proposed PCA","Open Date","Required Closure Date","Supplier Comments"]
[null,null,"1. PART PRINT (SPL 6.4)"]
[null,null,"1.","Welding Specifications","The latest revision of the welding specifications at the time of release shall be called out on the part print.  Black box components must follow industry or internal welding specifications.","CTQ","APQP","At PPAP",null,null,null,null,"Global Weld Spec:  WSBCPA-1B310-AA\nBody & Exterior: ESBM5A-1B310-AA  \nShocks: TBD"]
[null,null,"2.","Weld Identification","Welds shall be numbered uniquely for consistent tracking","CTQ","APQP","At PPAP",null,null,null,null,"Unique weld number in the tail of each welding symbol"]
[null,null,"3.","Weld Symbol Callout","The weld symbol shall contain the Joint type, weld ID number, welding classification,  process, total weld length.",null,"APQP","At PPAP",null,null,null,null,"Follow ISO 4063"]
[null,null,"4.","Weld Classification","Each weld number shall be assigned a classification","CTQ","APQP","At PPAP",null,null,null,null,"Any potential special characteristics related to the priority of each weld number should be defined on SCCAF"]
[null,null,"5.","Spatter Free Zones","Spatter free zones shall be identified",null,"APQP","At PPAP",null,null,null,null,"Cross hatch all spatter free zones"]
[null,null,"6.","Weld Size Requirements","Weld size shall be based off Governing Material Thickness (GMT)/Thinnest material (T1)",null,"APQP","At PPAP",null,null,null,null,"No conflicts between  the weld size on the print and the weld specification "]
[null,null,"2. CONTROL PLAN (SPL 6.3)"]
[null,null,"1.","Inline Visual Inspection","Welds shall be inspected for presence and appearance per visual acceptance criteria",null,"Each weld on each part","Suspect rework containment system or controls",null,null,null,null,"Visual aids or sample parts of welding defects"]
[null,null,"2.","Weld Quality Inspection","Presence, Appearance, Size, and Total Length per the welding specification and classification","CTQ","Per weld ES or 1 parts/fixture/shift minimum","Operator check sheets",null,null,null,null,"Collecting variable data on weld dimensions"]
[null,null,"3.","Cut and Etch","Performed per the weld specification and weld classification","CTQ","Per Weld ES                                                                                             or CC/s- 1part/stream/fixture/shift                                   S- 1part/stream/fixture/day                                         K- 1part/stream/fixture/week Minimum","Quality Reports / records",null,null,null,null,"Collecting variable data. Exceptions: Rotational fixturing may be approved with proven sustainability"]
[null,null,"4.","Destructive Testing ","Performed based off of the weld classification",null,"Per Weld ES or 1 part/fixture/shift Minimum","Quality Reports / records",null,null,null,null,null,"Performed on first and last piece off"]
[null,null,"5.","Weld Identification in Control Plan","Welding Special Characteristic Identification: CC/SC Welds shall be identified by weld number in the control plan per the Design Records/DFMEA/PFMEA/SCCAF","CTQ","APQP","At PPAP"]
[null,null,"6.","Weld Lot Containment","All  weld validation testing is performed prior to shipping components critical (CC) welds (Batch & Hold)","CTQ","Destruct first off per fixture",null,null,null,null,null,"Done with first and last off for batch control.  Exceptions should be approved by PD & STA"]
[null,null,"7.","Control of Changes and Unplanned Events","An event matrix shall be followed for events not listed in the control plan OR if changes are made","CTQ","Each change or event","Event matrix",null,null,null,null,"Need approved event matrix (see SPL)"]
[null,null,"8.","Prelaunch Control Plans","All welds follow safe launch plan prelaunch control plan based off of the welding safe launch plan, utilized from TT to MP",null,null,null,null,null,null,null,"Follow welding safe launch plan"]
[null,null,"9.","Production Part Traceability","Traceability to welding build date and weld fixture",null,"Each part","Visual part marking",null,null,null,null,null,"Bar coding"]
[null,null,"10.","Identification and Control of Nonconforming Parts","Physical separation and containment of Good and Reject Parts","CTQ","Each part","Part identification marking, tagging, containers/storage for Good and Reject Pars",null,null,null,null,null,"Tagging system and sensors in scrap bins linked to machine rejects. Internal auditing system to link machine rejects to actual scraped parts.  Lock box containment, Auto part destruction or disposal"]
[null,null,"11.","Setup Part Identification","Setup parts shall be marked for easy identification to prevent further processing or shipping",null,"Each setup part","Paint identification",null,null,null,null,"Mark or alter part before welding to prevent further processing"]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA (SPL 6.5)"]
[null,null,"1.","Destructive Testing Data","Destructive testing data retention shall have a defined time period. ","CTQ","Reverse Bend Test / Pull test/ Pushout Test","Quality Reports",null,null,null,null,"PER THE APPLICABLE WELD SPEC OR THE GLOBAL WELD SPEC(life of program + 12 years)  Inclusive of weld validation prove out at launch.  Archived data with weld image and measurement data"]
[null,null,"2.","Variable Data","Variable data shall be available and retained (actual measurements of cross sections)",null,"Each weld check","Quality Reports",null,null,null,null,"Weld length, Leg Size, Penetration, Throats"]
[null,null,"3.","Attribute Data","Attribute data shall be available and retained  (pass/fail)",null,"Each weld check","Quality Reports & Check sheets"]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS (SPL 6.6)"]
[null,null,"1.","Lab Technician Training","Personnel involved in weld inspection shall be qualified by the supplier as receiving adequate formal training on the recognition of weld defects, their cause, and effect on the product. ",null,"Each technician","Training Matrix"]
[null,null,"2.","Inspector Vision Acuity","Personnel designated as weld inspectors must have their vision reviewed annually by the supplier for compliance with recognized corrected levels of vision (minimum of 20/30 near and distance with corrective lenses).",null,"Annually / Each technician","Vision Acuity Test",null,null,null,null,"Jaeger J2 at 12\"."]
[null,null,"3.","Weld Cross Section Examination","Weld examination equipment shall provide adequate magnification to capture the entire cross section, showing the measurements of the features defined in the welding specification in one picture","CTQ","Each cross section",null,null,null,null,null,"Acid etched and reviewed under microscope with digital camera, 30X magnification maximum."]
[null,null,"4.","Weld Attribute Measurements","Per the welding specification, including (Leg size, root penetration, depth of fusion, throat, undercut, gaps)",null,"Each cross section","Per ES",null,null,null,null,"Weld Measurement Software Used (Paxit measurement software or equivalent recommended)"]
[null,null,"5.","Cross Section Analysis Technique","Cross section measurement technique shall be reviewed by weld area manager and approved and signed off by PD and STA","CTQ","Each joint type at PPAP","Per ES or Joint Type Visual Aid",null,null,null,null,"Posted for technician at point of use"]
[null,null,"6.","Cut and Etch Measuring System Effectiveness ","Attribute Gauge R&R",null,"PPAP and Annual","For each technician",null,null,null,null,"Variable Gauge R&R on each attribute."]
[null,null,"7."," Weld Cross Section Evaluation (Pass/Fail Determination)","Software formulas shall be utilized to calculate/generate pass/fail",null,"Each weld attribute","Quality Reports",null,null,null,null,"Excel formulas based off actual T1 thickness, utilizing conditional formatted Red/Yellow/Green regions.  Conditional formatting logic to be validated"]
[null,null,"8.","Control Limits","Control limits shall be utilized for controlling weld leg size",null,"Each cross section","Quality Reports",null,null,null,null,null,"SPC trend charting of leg length for weld location stability"]
[null,null,"9.","Weld Quality Traceability","Welds shall be tracked  per stream/fixture/weld#",null,"Cut and Etch / Destructive Torque","Quality Reports"]
[null,null,"10.","Visual Aids","Visual aids shall be available for cross section attributes, defects, and common failures modes",null,null,"Visual Aids",null,null,null,null,"Posted for technician"]
[null,null,"5. REWORK PROCEDURE & REPORTS                     (SPL 6.7 & 6.8) "]
[null,null,"1.","Repair Procedure (WPS)","Rework or repair welding shall have a customer approved procedure",null,"Each reworked part","PSW",null,null,null,null,"Written for each joint type  and failure mode"]
[null,null,"2.","Repair Qualification Records","Welding Procedure Specification (WPS),  Procedure Qualification Record (PQR), and Welder Qualification Record (WQR) shall be utilized ",null,"Each welder ","Qualification Record / Operator Training Matrix",null,null,null,null,"Qualification for joint and defect type of defect being repaired"]
[null,null,"3.","Inspection and Repair Visual Aids","Visual aids for welding defects and display acceptable repairs shall be posted per PFMEA",null,"Each joint type","Visual Aids",null,null,null,null,"Posted at inspection stations and repair stations"]
[null,null,"4.","Repair Welder Training","Repair welders shall undergo formal training and qualification",null,"Each weld operator","Qualification Record / Operator Training Matrix",null,null,null,null,"Class room training and hands on weld instruction"]
[null,null,"5.","FTT Data Collection (Spl )","Internal FTT shall be tracked by each operation exclusive of in line repair",null,"Each shift","Trend chart or P- Chart",null,null,null,null,"Pareto by fixture, weld number, and defect type"]
[null,null,"6.","Scrap Reports","Scrap shall be tracked by fixture, weld number, and defect code.",null,"Each shift","Scrap log",null,null,null,null,"Scrap pareto's used for continual improvements"]
[null,null,"7.","Scrap Codes","Scrap shall be tracked by codes for the failure modes listed in the PFMEA",null,"Each scrapped part","Scrap log",null,null,null,null,"Codes entered into electronic scrap tracking system"]
[null,null,"8.","Rework Data","Rework shall be tracked by fixture, weld number, and defect code.",null,"Each shift","Rework log",null,null,null,null,"Rework pareto's used for continual improvements"]
[null,null,"9.","Rework Part Traceability","Rework parts shall be identified and traceable",null,"Each part","Visual part marking",null,null,null,null,null,"Bar coding"]
[null,null,"6. PARAMETER DOCUMENTATION (SPL 6.9)"]
[null,null,"1.","Process Parameter Documentation","A controlled document shall contain all welding key process input variables and submitted at PPAP",null,"Start up","Check sheets",null,null,null,null,"Posted at cell and linked to startup check sheets"]
[null,null,"2.","Welding Parameters Controls","Welding parameter changes shall be password protected or gatekeeper controlled (quality manager, welding engineer)",null,null,"Key card lockouts",null,null,null,null,null,"Computer based auditing systems in place"]
[null,null,null,"Key Process Input Variables",null,null,"Each startup","Check sheet"]
[null,null,null,"Amperage"]
[null,null,null,"Voltage"]
[null,null,null,"Current Type / Polarity"]
[null,null,null,"Wire feed Speed"]
[null,null,null,"Pulse info/reference number"]
[null,null,null,"Contact tip to work distance"]
[null,null,null,"Electrode type, classification, and diameter"]
[null,null,null,"Travel Speed"]
[null,null,null,"Gas Composition and flow rate"]
[null,null,null,"Gas nozzle size and type"]
[null,null,null,"Arc start parameters"]
[null,null,null,"Arc end parameters"]
[null,null,null,"Wire burn back settings"]
[null,null,null,"Travel & Work Angle"]
[null,null,null,"Robot target location"]
[null,null,"3.","Parameter Changes","All parameter changes within specification shall be documented, changes outside of limits shall follow SREA process",null,"Each change","Parameter change log",null,null,null,null,"All parameter changes signed off on by welding engineer"]
[null,null,"4.","Setup Items/Tools","Setup tools shall be linked to startup check sheets or control plans",null,"Start of shift or Each setup","Check sheets",null,null,null,null,"Setup tools, checking shielding gas, running red rabbits, TCP check, changing contact tip…."]
[null,null,"7. MAINTENANCE RECORDS (SPL 6.10)"]
[null,null,"1.","Unplanned Downtime log","Maintenance reports shall be detailed to include technician identification, date, time, corrective action, and revalidation per the event matrix",null,"Each event","Recorded in downtime log sheet & audited to confirm compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.","Scheduled Preventative Maintenance (PM)","Established weld equipment PM per manufacturers recommendations",null,"Scheduled frequency","Evidence of compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.a","Torch Inner Liner","Torch inner liners shall changed before failure using defined pull test limit",null,"Pull test / Weekly","PM check sheets with defined control limit",null,null,null,null,null,"Pull test with fish scale"]
[null,null,"2.b","Contact Tip Changes","Contact tips shall be changed before failure based off of time/arc hours",null,"Scheduled frequency","PM check sheets with defined control limit",null,null,null,null,"Linked to arc hours/part count.  "]
[null,null,"2.c","Torch Reamer","Preventative maintenance of torch reamer shall include inspection of the cutter blade and jaws for wear and debris, and inspection of the robot programing to ensure torch is aligned with the reamer.",null,"Quarterly","PM check sheets "]
[null,null,"3","Validation of Tooling Details","All details checked for looseness, all non-pinned details torque checked and match marked",null,"Start up / daily ","Looseness check",null,null,null,null,"Weekly torque checks/ weld"]
[null,null,"4.","Part touching details, locating pins, fixture locators and tooling mating surfaces","All mating surfaces shall be free of spatter and debris",null,"Start up / Daily / Change over","Check sheets",null,null,null,null,"Part / tooling sensors linked to PLC to ensure alignment"]
[null,null,"8. SUSTAINABILITY (SPL 6.12)"]
[null,null,"1.","Weld Sustainability Prove Out","Shall have demonstrated at last PPAP, or can prove through 10 consecutive days of meeting the welding spec without adjustments.","CTQ","At launch or per event matrix","Health charts",null,null,null,null,"Following welding safe launch plan and documents in health chart"]
[null,null,"2.","Weld Effectiveness","Weld effectiveness shall be used as a key metric (good welds/total welds)",null,"Weekly","Health charts",null,null,null,null,"Weld effectiveness of 98% or greater should be targeted"]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS"]
[null,null,"1.","Weld Identification in Robot Teach Pendant","Part print ID, weld sequence, and weld length should be called out in the robot teach pendant"]
[null,null,"2.","Weld Process Mapping","Repair weld ID numbers should be linked to robot programming and part print weld ID numbers"]
[null,null,"3.","Robotic Pick and Place into Rack (Auto-Racking)","Parts should be visually inspected and repaired prior to racking of parts"]
[null,null,"4.","Dimensional Control","(Weld edges) Mating surface level 2 to print by die buy off (Level 1 is everything, level 2 50mm, level 3 200mm typ.)"]
[null,null,"5.","Dimensional Control","CC weld flange level 4 point where trim is made"]
[null,null,"6.","Equipment Debug","Establish minimum material runoff quantities for TTO at indegrator\n"]
[null,null,"10. Other"]
[null,null,"1."]

{"sheet":"LBW Welding Requirements","index":3,"n_rows":108,"n_cols":21,"rows_kept":108,"cut":false,"hidden":false,"merged":[[106,2,106,3],[103,2,103,3],[0,2,0,20],[90,2,90,3],[100,2,100,3],[6,2,6,3],[13,2,13,3],[26,2,26,3],[30,2,30,3],[42,2,42,3],[52,2,52,3],[2,7,2,9]]}
[null,null,"                   Laser Welding Process Controls Checklist      "]
[]
[null,null,"","Assessor",{"$f":"'Supplier Information'!B11","v":0},null,"Welding Plant",{"$f":"'Supplier Information'!C3","v":""},null,null,null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Company)",null,null,"(Name - Location)"]
[]
[null,null,"Item No.","Area","Requirements","Char. Class. (min level)","Test / Inspection Frequencies (minimum)","Recommended Control Method","Initial Rating (R/Y/G) ","Evidence / Gap Identified","Current Status (R/Y/G)","Additional Comments","Additional Information\nNOT TO BE RATED","Best Practice\nNOT TO BE RATED","Responsible Person","Management Champion","ICA","Proposed PCA","Open Date","Required Closure Date","Supplier Comments"]
[null,null,"1. PART PRINT (SPL 6.4)"]
[null,null,"1.","Welding Specifications","The latest revision of the welding specifications at the time of release shall be called out on the part print.  Black box components must follow industry or internal welding specifications.","CTQ","APQP","At PPAP",null,null,null,null,"Seats:  ES-7L1A-7861019-B_X Rev 1 Final  Body & Exterior: ESAU5A-1B313-AA Stitch or ES-5G1A-02508-A Laser Lap"]
[null,null,"2.","Weld Identification","Welds shall be numbered uniquely for consistent tracking","CTQ","APQP","At PPAP",null,null,null,null,"Unique weld number in the tail of each welding symbol"]
[null,null,"3.","Weld Symbol Callout","The weld symbol shall contain the Joint type, weld ID number, welding classification,  process, weld length.",null,"APQP","At PPAP",null,null,null,null,"Follow ISO 4063"]
[null,null,"4.","Weld Classification","Each weld number shall be assigned a classification","CTQ","APQP","At PPAP",null,null,null,null,"Any potential special characteristics related to the priority of each weld number should be defined on SCCAF"]
[null,null,"5.","Spatter Free Zones","Spatter free zones shall be identified",null,"APQP","At PPAP",null,null,null,null,"Cross hatch all spatter free zones"]
[null,null,"6.","Weld Size Requirements","Weld size shall be based off Governing Material Thickness (GMT)/Thinnest material (T1)",null,"APQP","At PPAP",null,null,null,null,"No conflicts between  the weld size on the print and the weld specification "]
[null,null,"2. CONTROL PLAN (SPL 6.3)"]
[null,null,"1.","Inline Visual Inspection","Welds shall be inspected for presence and appearance per visual acceptance criteria",null,"Each weld on each part","Suspect rework containment system or controls",null,null,null,null,"Visual aids or sample parts of welding defects"]
[null,null,"2.","Weld Quality Inspection","Presence, Appearance, Size, and Total Length per the welding specification and classification","CTQ","Per weld ES or 1 parts/fixture/shift minimum","Operator check sheets",null,null,null,null,"Collecting variable data on weld dimensions"]
[null,null,"3.","Cut and Etch","Performed per the weld specification and weld classification","CTQ","Per Weld ES                                                                                             or CC/s- 1part/stream/fixture/shift                                   SC/G- 1part/stream/fixture/day         ","Quality Reports / records",null,null,null,null,"Collecting variable data. Exceptions: Rotational fixturing may be approved with proven sustainability"]
[null,null,"4.","Hardness Testing","Transverse micro-hardness from parent material through weld checks shall be performed","CTQ","Per ES or Semi-annually","Quality reports"]
[null,null,"5.","Destructive Testing ","Performed based off of the weld classification",null,"Per Weld ES or 1 part/fixture/shift Minimum","Quality Reports / records",null,null,null,null,null,"Performed on first and last piece off"]
[null,null,"6.","Weld Identification in Control Plan","Welding Special Characteristic Identification: CC/SC Welds shall be identified by weld number in the control plan per the Design Records/DFMEA/PFMEA/SCCAF","CTQ","APQP","At PPAP"]
[null,null,"7.","Weld Lot Containment","All  weld validation testing is performed prior to shipping components critical (CC) welds (Batch & Hold)","CTQ","Destruct first off per fixture",null,null,null,null,null,"Done with first and last off for batch control.  Exceptions should be approved by PD & STA"]
[null,null,"8.","Control of Changes and Unplanned Events","An event matrix shall be followed for events not listed in the control plan OR if changes are made","CTQ","Each change or event","Event matrix",null,null,null,null,"Need approved event matrix (see SPL)"]
[null,null,"9.","Prelaunch Control Plans","All welds follow safe launch plan prelaunch control plan based off of the welding safe launch plan, utilized from TT to MP",null,null,null,null,null,null,null,"Follow welding safe launch plan"]
[null,null,"10.","Production Part Traceability","Traceability to welding build date and weld fixture",null,"Each part","Visual part marking",null,null,null,null,null,"Bar coding"]
[null,null,"11.","Identification and Control of Nonconforming Parts","Physical separation and containment of Good and Reject Parts","CTQ","Each part","Part identification marking, tagging, containers/storage for Good and Reject Pars",null,null,null,null,null,"Tagging system and sensors in scrap bins linked to machine rejects. Internal auditing system to link machine rejects to actual scraped parts.  Lock box containment, Auto part destruction or disposal"]
[null,null,"12.","Setup Part Identification","Setup parts shall be marked for easy identification to prevent further processing or shipping",null,"Each setup part","Paint identification",null,null,null,null,"Mark or alter part before welding to prevent further processing"]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA (SPL 6.5)"]
[null,null,"1.","Destructive Testing Data","Destructive testing data retention shall have a defined time period. ","CTQ","Reverse Bend Test / Pull test/ Pushout Test","Quality Reports",null,null,null,null,"PER THE APPLICABLE WELD SPEC OR THE GLOBAL WELD SPEC(life of program + 12 years)  Inclusive of weld validation prove out at launch.  Archived data with weld image and measurement data"]
[null,null,"2.","Variable Data","Variable data shall be available and retained (actual measurements of cross sections)",null,"Each weld check","Quality Reports",null,null,null,null,"Weld length, Leg Size, Penetration, Throats"]
[null,null,"3.","Attribute Data","Attribute data shall be available and retained  (pass/fail)",null,"Each weld check","Quality Reports & Check sheets"]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS (SPL 6.6)"]
[null,null,"1.","Lab Technician Training","Personnel involved in weld inspection shall be qualified by the supplier as receiving adequate formal training on the recognition of weld defects, their cause, and effect on the product. ",null,"Each technician","Training Matrix"]
[null,null,"2.","Inspector Vision Acuity","Personnel designated as weld inspectors must have their vision reviewed annually by the supplier for compliance with recognized corrected levels of vision (minimum of 20/30 near and distance with corrective lenses).",null,"Annually / Each technician","Vision Acuity Test",null,null,null,null,"Jaeger J2 at 12\"."]
[null,null,"3.","Weld Cross Section Examination","Weld examination equipment shall provide adequate magnification to capture the entire cross section, showing the measurements of the features defined in the welding specification in one picture","CTQ","Each cross section","Per ES",null,null,null,null,"Acid etched and reviewed under microscope with digital camera, 30X magnification maximum."]
[null,null,"4.","Weld Attribute Measurements","Per the welding specification, including (Leg size, root penetration, depth of fusion, throat, undercut, gaps)",null,"Each cross section","Per ES",null,null,null,null,"Weld Measurement Software Used (Paxit measurement software or equivalent recommended)"]
[null,null,"5.","Cross Section Analysis Technique","Cross section measurement technique shall be reviewed by weld area manager and approved and signed off by PD and STA","CTQ","Each joint type at PPAP","Per ES or Joint Type Visual Aid",null,null,null,null,"Posted for technician at point of use"]
[null,null,"6.","Cut and Etch Measuring System Effectiveness ","Attribute Gauge R&R",null,"PPAP and Annual","For each technician",null,null,null,null,"Variable Gauge R&R on each attribute."]
[null,null,"7."," Weld Cross Section Evaluation (Pass/Fail Determination)","Software formulas shall be utilized to calculate/generate pass/fail",null,"Each weld attribute","Quality Reports",null,null,null,null,"Excel formulas based off actual T1 thickness, utilizing conditional formatted Red/Yellow/Green regions.  Conditional formatting logic to be validated"]
[null,null,"8.","Control Limits","Control limits shall be utilized for controlling weld leg size",null,"Each cross section","Quality Reports",null,null,null,null,null,"SPC trend charting of penetration for weld location stability"]
[null,null,"9.","Weld Quality Traceability","Welds shall be tracked  per stream/fixture/weld#",null,"Cut and Etch / Destructive Torque","Quality Reports"]
[null,null,"10.","Traceability","Must have an in-process poke yoke (Bar Coding, Scanning, Etc..) that will prevent parts produced during machine interruption (weld setup, maintenance intervention, power outage...etc) from further processing or shipping.",null,"Each event"]
[null,null,"11.","Visual Aids","Visual aids shall be available for cross section attributes, defects, and common failures modes",null,null,"Visual Aids",null,null,null,null,"Posted for technician"]
[null,null,"5. REWORK PROCEDURE & REPORTS                                        (SPL 6.7 & 6.8) "]
[null,null,"1.","Repair Procedure (WPS)","Rework or repair welding shall have a customer approved procedure",null,"Each reworked part","PSW",null,null,null,null,"Written for each joint type  and failure mode"]
[null,null,"2.","Repair Qualification Records","Welding Procedure Specification (WPS),  Procedure Qualification Record (PQR), and Welder Qualification Record (WQR) shall be utilized ",null,"Each welder ","Qualification Record / Operator Training Matrix",null,null,null,null,"Qualification for joint and defect type of defect being repaired"]
[null,null,"3.","Inspection and Repair Visual Aids","Visual aids for welding defects and display acceptable repairs shall be posted per PFMEA",null,"Each joint type","Visual Aids",null,null,null,null,"Posted at inspection stations and repair stations"]
[null,null,"4.","Repair Welder Training","Repair welders shall undergo formal training and qualification",null,"Each weld operator","Qualification Record / Operator Training Matrix",null,null,null,null,"Class room training and hands on weld instruction"]
[null,null,"5.","FTT Data Collection (Spl )","Internal FTT shall be tracked by each operation exclusive of in line repair",null,"Each shift","Trend chart or P- Chart",null,null,null,null,"Pareto by fixture, weld number, and defect type"]
[null,null,"6.","Scrap Reports","Scrap shall be tracked by fixture, weld number, and defect code.",null,"Each shift","Scrap log",null,null,null,null,"Scrap pareto's used for continual improvements"]
[null,null,"7.","Scrap Codes","Scrap shall be tracked by codes for the failure modes listed in the PFMEA",null,"Each scrapped part","Scrap log",null,null,null,null,"Codes entered into electronic scrap tracking system"]
[null,null,"8.","Rework Data","Rework shall be tracked by fixture, weld number, and defect code.",null,"Each shift","Rework log",null,null,null,null,"Rework pareto's used for continual improvements"]
[null,null,"9.","Rework Part Traceability","Rework parts shall be identified and traceable",null,"Each part","Visual part marking",null,null,null,null,null,"Bar coding"]
[null,null,"6. PARAMETER DOCUMENTATION (SPL 6.9)"]
[null,null,"1.","Process Parameter Documentation","A controlled document shall contain all welding key process input variables and submitted at PPAP",null,"Start up","Check sheets",null,null,null,null,"Posted at cell and linked to startup check sheets"]
[null,null,"2.","Welding Parameters Controls","Welding parameter changes shall be password protected or gatekeeper controlled (quality manager, welding engineer)",null,null,"Key card lockouts",null,null,null,null,null,"Computer based auditing systems in place"]
[null,null,null,"Key Process Input Variables",null,null,"Each startup","Check sheet"]
[null,null,null,"Beam Quality"]
[null,null,null,"Cross Jet / Laser knife"]
[null,null,null,"Beam configuration"]
[null,null,null,"Focal length"]
[null,null,null,"Beam spot size"]
[null,null,null,"Gas tube angle"]
[null,null,null,"Optics purge gas"]
[null,null,null,"Mirror / optic cleanliness"]
[null,null,null,"Chiller flow rate"]
[null,null,null,"Chiller temperature"]
[null,null,null,"Fiber diameter"]
[null,null,null,"Fiber length"]
[null,null,null,"Bend radius"]
[null,null,null,"Power loss "]
[null,null,null,"Mirror coating"]
[null,null,null,"Optic and mirror cooling"]
[null,null,null,"Travel speed"]
[null,null,null,"Power output control"]
[null,null,null,"Power ramping"]
[null,null,null,"Power at work piece"]
[null,null,null,"Offset of beam to joint"]
[null,null,null,"Continuous or Pulse"]
[null,null,null,"Pulse parameters"]
[null,null,null,"Angle of incidence"]
[null,null,null,"Focal point"]
[null,null,null,"Weld direction"]
[null,null,null,"Beam quality"]
[null,null,null,"Plasma suppression"]
[null,null,null,"Preheat"]
[null,null,null,"Post weld heat treat"]
[]
[null,null,3,"Weld Failure Investigation Checklists","A welding failure investigation checklist shall be used prior to adjusting parameters",null,"Each event",null,null,null,null,null,"Linked to weld failure report"]
[null,null,"4.","Parameter Changes","All parameter changes within specification shall be documented, changes outside of limits shall follow SREA process",null,"Each change","Parameter change log",null,null,null,null,"All parameter changes signed off on by welding engineer"]
[null,null,"5.","Setup Tools","Setup tools shall be linked to startup check sheets or control plans",null,"Start of shift or Each setup","Check sheets",null,null,null,null,"Setup tools, checking shielding gas, running red rabbits, power checks, focal length gage, alignment check…."]
[null,null,"7. MAINTENANCE RECORDS (SPL 6.10)"]
[null,null,"1.","Unplanned Downtime log","Maintenance reports shall be detailed to include technician identification, date, time, corrective action, and revalidation per the event matrix",null,"Each event","Recorded in downtime log sheet & audited to confirm compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.","Scheduled Preventative Maintenance (PM)","Established weld equipment PM per manufacturers recommendations",null,"Scheduled frequency","Evidence of compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.a","Cover Lenses","Cover lenses shall be changed before failure",null,"Scheduled frequency","Check sheets",null,null,null,null,"Linked to PLC part count"]
[null,null,"2.b","Beam Power","Actual beam power at the work piece shall be checked",null,"Power meter / Scheduled frequency","Check sheets",null,null,null,null,"Power meter in cell, power verified at startup"]
[null,null,"2.c","Beam Quality","Actual beam quality shall be checked",null,"Power puck / Scheduled frequency","Check sheets",null,null,null,null,"Mode burns / Spacial Profiler"]
[null,null,"2.d","Run Out Check of Fixture Rotators","All fixtures verification to equipment OEM recommendations","CTQ","Scheduled frequency","Evidence of compliance",null,null,null,null,"Recorded in maintenance PM log"]
[null,null,"2.e","Air Knife","Air knife shall provide adequate flow to cover lenses and verified","CTQ","Scheduled frequency","Evidence of compliance"]
[null,null,"3.","Validation of Tooling Details","All details checked for looseness, all non-pinned details torque checked and match marked",null,"Start up / daily ","Looseness check",null,null,null,null,"Weekly torque checks/ weld"]
[null,null,"4.","Part touching details, locating pins, fixture locators and tooling mating surfaces","All mating surfaces shall be free of spatter and debris",null,"Start up / Daily / Change over","Check sheets",null,null,null,null,"Part / tooling sensors linked to PLC to ensure alignment"]
[null,null,"8. SUSTAINABILITY (SPL 6.12)"]
[null,null,"1.","Weld Sustainability Prove Out","Shall have demonstrated at last PPAP, or can prove through 10 consecutive days of meeting the welding spec without adjustments.","CTQ","At launch or per event matrix","Health charts",null,null,null,null,"Following welding safe launch plan and documents in health chart"]
[null,null,"2.","Weld Effectiveness","Weld effectiveness shall be used as a key metric (good welds/total welds)",null,"Weekly","Health charts",null,null,null,null,"Weld effectiveness of 98% or greater should be targeted"]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS \nLASER WELD MONITORING (SPL6.15)"]
[null,null,1,"Validation of Limits","Initial Validation shall be performed with a cause and effect study for the common welding failure modes, ongoing validation to be done with red rabbit testing",null,"At PPAP & Monthly"]
[null,null,2,"Re-referencing / Adjusting Limits","Only performed when all equipment PM is completed.  New limits validated though cut and etch as well as red rabbit testing",null,"Each event"]
[null,null,"10. Other"]
[null,null,1]

{"sheet":"Resistance Welding Requirements","index":4,"n_rows":94,"n_cols":21,"rows_kept":94,"cut":false,"hidden":false,"merged":[[92,2,92,3],[0,2,0,20],[76,2,76,3],[86,2,86,3],[6,2,6,3],[12,2,12,3],[25,2,25,3],[29,2,29,3],[39,2,39,3],[49,2,49,3],[2,7,2,9],[90,2,90,3]]}
[null,null,"                   Resistance Welding Process Controls Checklist      "]
[]
[null,null,"","Assessor",{"$f":"'Supplier Information'!B11","v":0},null,"Welding Plant",{"$f":"'Supplier Information'!C3","v":""},null,null,null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Company)",null,null,"(Name - Location)"]
[]
[null,null,"Item No.","Area","Requirements","Char. Class. (min level)","Test / Inspection Frequencies (minimum)","Recommended Control Method","Initial Rating (R/Y/G) ","Evidence / Gap Identified","Current Status (R/Y/G)","Additional Comments","Additional Information\nNOT TO BE RATED","Best Practice\nNOT TO BE RATED","Responsible Person","Management Champion","ICA","Proposed PCA","Open Date","Required Closure Date","Supplier Comments"]
[null,null,"1. PART PRINT (SPL 6.4)"]
[null,null,"1.","Welding Specifications","The latest revision of the welding specifications at the time of release shall be called out on the part print.  Black box components must follow industry or internal welding specifications.","CTQ","APQP","At PPAP",null,null,null,null,"Global Spot Weld Spec:  ESBM5A_1N261_AA  \nGlobal Projection Weld Spec: ESBM5A_1N265_AA    "]
[null,null,"2.","Weld Identification","Welds shall be numbered uniquely for consistent tracking","CTQ","APQP","At PPAP",null,null,null,null,"Unique weld number should be used in the spot pattern layout"]
[null,null,"3.","Weld Symbol Callout","The weld symbol shall contain the material stack up, weld ID number, welding classification.",null,"APQP","At PPAP",null,null,null,null,"Follow ISO 4063"]
[null,null,"4.","Weld Classification","Each weld number shall be assigned a classification","CTQ","APQP","At PPAP",null,null,null,null,"Any potential special characteristics related to the priority of each weld number should be defined on SCCAF"]
[null,null,"5.","Weld Grouping","All weld groups shall be defined in the spot pattern layout (SPL)","CTQ","APQP","At PPAP",null,null,null,null,"Welds in a group should be performed by multiple weld guns"]
[null,null,"2. CONTROL PLAN (SPL 6.3)"]
[null,null,"1.","Inline Visual Inspection","Welds shall be inspected for presence and appearance per visual acceptance criteria",null,"Each weld on each part","Suspect rework containment system or controls",null,null,null,null,"Visual aids or sample parts of welding defects"]
[null,null,"2.","Weld Quality Inspection","Presence, appearance, location, size, indentation, expulsion, cracks, porosity per the welding specification and classification","CTQ","Per weld ES or 1 parts/fixture/shift minimum","Operator check sheets"]
[null,null,"3.","Destructive Testing ","Performed based off of the weld classification","CTQ","Per weld ES or 1 part/fixture/shift Minimum","Quality Reports / records",null,null,null,null,"Performed on first and last piece off  Exceptions: Reduced tear down frequency may be approved upon successful implementation UT testing"]
[null,null,"4.","Pry Bar Testing","Performed based off of the welding specification and classification",null,"Per weld ES or middle of shift / fixture","Quality reports",null,null,null,null,null,"Middle & last/fixture/shift"]
[null,null,"5.","Ultrasonic Testing","Ultrasonic testing may be performed after  a correlation has been established and the SREA is approved (SPL 6.16)",null,"Per weld ES or 1 parts/fixture/shift","UT Quality reports",null,null,null,null,"Collecting variable data for weld size."]
[null,null,"6.","Weld Identification in Control Plan","Welding Special Characteristic Identification: CC/SC Welds shall be identified by weld number in the control plan per the Design Records/DFMEA/PFMEA/SCCAF","CTQ","APQP","At PPAP"]
[null,null,"7.","Weld Lot Containment","All  weld validation testing is performed prior to shipping components critical (CC) welds (Batch & Hold)","CTQ","Destruct first off per fixture",null,null,null,null,null,"Done with first and last off for batch control.  Exceptions should be approved by PD & STA"]
[null,null,"8.","Control of Changes and Unplanned Events","An event matrix shall be followed for events not listed in the control plan OR if changes are made","CTQ","Each change or event","Event matrix",null,null,null,null,"Need approved event matrix (see SPL)"]
[null,null,"9.","Prelaunch Control Plans","All welds follow safe launch plan prelaunch control plan based off of the welding safe launch plan, utilized from TT to MP.  100% Satisfactory button diameters required for Pre builds",null,null,null,null,null,null,null,"Follow welding safe launch plan.  Ensure 100% of weld meet satisfactory button diameter requirements"]
[null,null,"10.","Production Part Traceability","Traceability to welding build date and weld fixture",null,"Each part","Visual part marking",null,null,null,null,null,"Bar coding"]
[null,null,"11.","Identification and Control of Nonconforming Parts","Physical separation and containment of Good and Reject Parts","CTQ","Each part","Part identification marking, tagging, containers/storage for Good and Reject Pars",null,null,null,null,null,"Tagging system and sensors in scrap bins linked to machine rejects. Internal auditing system to link machine rejects to actual scraped parts.  Lock box containment, Auto part destruction or disposal"]
[null,null,"12.","Setup Part Identification","Setup parts shall be marked for easy identification to prevent further processing or shipping",null,"Each setup part","Paint identification",null,null,null,null,"Mark or alter part before welding to prevent further processing"]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA (SPL 6.5)"]
[null,null,"1.","Destructive Testing Data","Destructive testing data retention shall have a defined time period. ","CTQ","Peel Test","Quality Reports",null,null,null,null,"PER THE APPLICABLE WELD SPEC OR THE GLOBAL WELD SPEC(life of program + 12 years)  Inclusive of weld validation prove out at launch.  Archived data with weld image and measurement data"]
[null,null,"2.","Variable Data","Variable data shall be available and retained (actual measurements of average button diameter)",null,"Each weld check","Quality Reports"]
[null,null,"3.","Attribute Data","Attribute data shall be available and retained  (pass/fail)",null,"Each weld check","Quality Reports & Check sheets",null,null,null,null,"Where variable data is not achievable (pry bar testing, nondestructive toque testing)"]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS (SPL 6.6)"]
[null,null,"1.","Lab Technician Training","Personnel involved in weld inspection shall be qualified by the supplier as receiving adequate formal training on the recognition of weld defects, their cause, and effect on the product. ",null,"Each technician","Training Matrix"]
[null,null,"2.","Inspector Vision Acuity","Personnel designated as weld inspectors must have their vision reviewed annually by the supplier for compliance with recognized corrected levels of vision (minimum of 20/30 near and distance with corrective lenses).",null,"Annually / Each technician","Vision Acuity Test",null,null,null,null,"Jaeger J2 at 12\"."]
[null,null,"3.","Weld Examination","Weld examination equipment shall allow for adequate inspection of the features defined in the welding specification",null,"Each weld",null,null,null,null,null,null,"Data Mite Calipers"]
[null,null,"4.","Weld Attribute Measurements","Per the welding specification, including average button diameter, indentation","CTQ","Each weld","Per ES",null,null,null,null,null,"Data Mite Calipers"]
[null,null,"5.","Measuring System Effectiveness ","Variable gauge R&R on button diameter",null,"PPAP and Annual","For each technician"]
[null,null,"6.","Button Diameter Evaluation (Pass/Fail Determination)","Software formulas shall be utilized to calculate/generate pass/fail",null,"Each weld ","Quality Reports",null,null,null,null,"Excel formulas utilizing conditional formatted Red/Yellow/Green regions.  Conditional formatting logic to be validated"]
[null,null,"7.","Control Limits","Control limits shall be utilized for controlling button diameter",null,"Each weld","Quality Reports",null,null,null,null,null,"SPC trend charting of button diameter. 10% larger than the minimum satisfactory diameter "]
[null,null,"8.","Weld Quality Traceability","Welds shall be tracked  per stream/fixture/weld# on SPL",null,"Peel Test","Quality Reports"]
[null,null,"9.","Visual Aids","Visual aids shall be available for measurement technique, location, defects, and common failures modes",null,null,"Visual Aids",null,null,null,null,"Posted for technician"]
[null,null,"5. REWORK PROCEDURE & REPORTS                     (SPL 6.7 & 6.8) "]
[null,null,"1.","Repair Procedure (WPS)","Rework or repair welding shall have a customer approved procedure",null,"Each reworked part","PSW",null,null,null,null,"Written for each joint type  and failure mode"]
[null,null,"2.","Repair Qualification Records","Welding Procedure Specification (WPS),  Procedure Qualification Record (PQR), and Welder Qualification Record (WQR) shall be utilized ",null,"Each welder ","Qualification Record / Operator Training Matrix",null,null,null,null,"Qualification for material stack up and type of defect being repaired"]
[null,null,"3.","Inspection and Repair Visual Aids","Visual aids for welding defects and display acceptable repairs shall be posted per PFMEA",null,"Each joint type","Visual Aids",null,null,null,null,"Posted at inspection stations and repair stations"]
[null,null,"4.","Repair Welder Training","Repair welders shall undergo formal training and qualification",null,"Each weld operator","Qualification Record / Operator Training Matrix",null,null,null,null,"Class room training and hands on weld instruction"]
[null,null,"5.","FTT Data Collection (Spl )","Internal FTT shall be tracked by each operation exclusive of in line repair",null,"Each shift","Trend chart or P- Chart",null,null,null,null,"Pareto by fixture, weld number, and defect type"]
[null,null,"6.","Scrap Reports","Scrap shall be tracked by fixture, weld number, and defect code.",null,"Each shift","Scrap log",null,null,null,null,"Scrap pareto's used for continual improvements"]
[null,null,"7.","Scrap Codes","Scrap shall be tracked by codes for the failure modes listed in the PFMEA",null,"Each scrapped part","Scrap log",null,null,null,null,"Codes entered into electronic scrap tracking system"]
[null,null,"8.","Rework Data","Rework shall be tracked by fixture, weld number, and defect code.",null,"Each shift","Rework log",null,null,null,null,"Rework pareto's used for continual improvements"]
[null,null,"9.","Rework Part Traceability","Rework parts shall be identified and traceable",null,"Each part","Visual part marking",null,null,null,null,null,"Bar coding"]
[null,null,"6. PARAMETER DOCUMENTATION (SPL 6.9)"]
[null,null,"1.","Process Parameter Documentation","A controlled document shall contain all welding key process input variables and submitted at PPAP",null,"Start up","Check sheets",null,null,null,null,"Posted at cell and linked to startup check sheets"]
[null,null,"2.","Welding Parameters Controls","Welding parameter changes shall be password protected or gatekeeper controlled (quality manager, welding engineer)",null,null,"Key card lockouts",null,null,null,null,null,"Computer based auditing systems in place"]
[null,null,"3.","Key Process Input Variables",null,null,"Each startup","Check sheet"]
[null,null,null,"Actual tip force"]
[null,null,null,"Actual secondary amperage"]
[null,null,null,"Voltage"]
[null,null,null,"Power"]
[null,null,null,"Frequency"]
[null,null,null,"Pulse"]
[null,null,null,"Squeeze time"]
[null,null,null,"Weld time"]
[null,null,null,"Hold time"]
[null,null,null,"Quench time"]
[null,null,null,"Temper time"]
[null,null,null,"Upslope"]
[null,null,null,"Downslope"]
[null,null,null,"Electrode type"]
[null,null,null,"Electrode shape"]
[null,null,null,"Electrode face diameter"]
[null,null,null,"Stepper rate"]
[null,null,null,"Electrode dressing frequency"]
[null,null,null,"Electrode change frequency"]
[null,null,null,"Water flow"]
[null,null,null,"Water temperature"]
[null,null,"3.","Parameter Changes","All parameter changes within specification shall be documented, changes outside of limits shall follow SREA process",null,"Each change","Parameter change log",null,null,null,null,"All parameter changes signed off on by welding engineer"]
[null,null,"4.","Setup Tools","Setup tools shall be linked to startup check sheets or control plans",null,"Start of shift or Each setup","Check sheets",null,null,null,null,"Setup tools, , running red rabbits, changing tips, …."]
[null,null,"7. MAINTENANCE RECORDS (SPL 6.10)"]
[null,null,"1.","Unplanned Downtime log","Maintenance reports shall be detailed to include technician identification, date, time, corrective action, and revalidation per the event matrix",null,"Each event","Recorded in downtime log sheet & audited to confirm compliance",null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.","Scheduled Preventative Maintenance (PM)","Established weld equipment PM per manufacturers recommendations",null,"Scheduled frequency","Evidence of compliance",null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.a","Electrode Force","Actual tip force shall measured and recorded in PM",null,"Tip force gauge / Scheduled frequency","Check sheets",null,null,null,null,"Actual pressure gauge between electrodes with certified tip force gauge"]
[null,null,"2.b","Secondary Amperage","Actual secondary amperage shall be measured with an amp meter and documented in weld parameter sheet",null,"Secondary current meter / Scheduled frequency","Check sheets",null,null,null,null,"Validated with an additional secondary amperage meter in the secondary loop"]
[null,null,"2.c","Shunt Checks","Shunt checks shall be performed to insure shunts are in good condition",null,"Scheduled frequency","Check sheets",null,null,null,null,null,"Micro-Ohm check"]
[null,null,"2.d","Validation of Tooling Details","All details checked for looseness, all non-pinned details torque checked",null,"Scheduled frequency","Check sheets"]
[null,null,"3.","Part touching details, locating pins, fixture locators and tooling mating surfaces","All details checked for looseness, all non-pinned details torque checked and match marked",null,"Start up / daily ","Looseness check",null,null,null,null,"Weekly torque checks/ weld"]
[null,null,"4.","Electrode Management","The electrode change frequency, electrode handling, refinishing geometry, and setup height shall be controlled.  Electrode changes shall be poke yoked to ensure all electrodes are changed","CTQ","Scheduled frequency","Check sheets",null,null,null,null,"Examples: Servo gun verification, electrode lock boxes with sensors, tip change board)","Poke yoke servo detection to ensure electrodes were changed"]
[null,null,"5.","Part touching details, locating pins, fixture locators and tooling mating surfaces","All mating surfaces shall be free of spatter and debris",null,"Start up / Daily / Change over","Check sheets",null,null,null,null,"Part / tooling sensors linked to PLC to ensure alignment"]
[null,null,"8. SUSTAINABILITY (SPL 6.12)"]
[null,null,"1.","Weld Sustainability Prove Out","Shall have demonstrated at last PPAP, or can prove through 30 consecutive days of meeting the welding spec without adjustments.","CTQ","At launch or per event matrix","Health charts",null,null,null,null,"Following welding safe launch plan and documents in health chart"]
[null,null,"2.","Weld Effectiveness","Weld effectiveness shall be used as a key metric (good welds/total welds)",null,"Weekly","Health charts",null,null,null,null,"Weld effectiveness of 98% or greater should be targeted"]
[null,null,"3.","Validation of Welding Equipment and Parameters","Tip dressers and/or current steppers frequencies shall be proven out prior to launch",null,"APQP","Health charts"]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS"]
[null,null,"1.","Equipment Debug","Establish minimum material runoff quantities for TTO at indegrator\n"]
[null,null,"10. Other"]
[null,null,"1."]

{"sheet":"FW Welding Requirements","index":5,"n_rows":84,"n_cols":21,"rows_kept":84,"cut":false,"hidden":false,"merged":[[82,2,82,3],[0,2,0,20],[71,2,71,3],[78,2,78,3],[6,2,6,3],[11,2,11,3],[28,2,28,3],[32,2,32,3],[43,2,43,3],[2,7,2,9],[80,2,80,3]]}
[null,null,"                   Friction Welding Process Controls Checklist      "]
[]
[null,null,"","Assessor",{"$f":"'Supplier Information'!B11","v":0},null,"Welding Plant",{"$f":"'Supplier Information'!C3","v":""},null,null,null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Company)",null,null,"(Name - Location)"]
[]
[null,null,"Item No.","Area","Requirements","Char. Class. (min level)","Test / Inspection Frequencies (minimum)","Recommended Control Method","Initial Rating (R/Y/G) ","Evidence / Gap Identified","Current Status (R/Y/G)","Additional Comments"," Additional Information\nNOT TO BE RATED","Best Practice\nNOT TO BE RATED","Responsible Person","Management Champion","ICA","Proposed PCA","Open Date","Required Closure Date","Supplier Comments"]
[null,null,"1. PART PRINT (SPL 6.4)"]
[null,null,"1.","Welding Specifications","The latest revision of the welding specifications at the time of release shall be called out on the part print.  Black box components must follow industry or internal welding specifications.","CTQ","APQP","At PPAP",null,null,null,null,"Spin Welding: ESDU5A-1B323 AA"]
[null,null,"2.","Weld Identification","Welds shall be numbered uniquely for consistent tracking","CTQ","APQP","At PPAP",null,null,null,null,"Unique weld number in the tail of each welding symbol"]
[null,null,"3.","Weld Symbol Callout","The weld symbol shall contain the Joint type, weld ID number, welding classification,  process, weld length.",null,"APQP","At PPAP",null,null,null,null,"Follow ISO 4063"]
[null,null,"4.","Weld Classification","Each weld number shall be assigned a classification","CTQ","APQP","At PPAP",null,null,null,null,"Any potential special characteristics related to the priority of each weld number should be defined on SCCAF"]
[null,null,"2. CONTROL PLAN (SPL 6.3)"]
[null,null,"1.","Inline Visual Inspection","Welds shall be inspected for presence and appearance per visual acceptance criteria",null,"Each weld on each part","Suspect rework containment system or controls",null,null,null,null,"Visual aids or sample parts of welding defects"]
[null,null,"2.","Weld Quality Inspection","Gauging to ensure proper curl","CTQ","Per weld ES or 1 parts/fixture/shift minimum","Operator check sheets"]
[null,null,"3.","Cut and Etch","Performed per the weld specification and weld classification","CTQ","Per Weld ES                                                                                             or CC/s- 1part/stream/fixture/shift                                   SC- 1part/stream/fixture/week                                        HIC- 1part/stream/fixture/month Minimum","Quality Reports / records",null,null,null,null,"Collecting variable data."]
[null,null,"4.","Microstructure Evaluation","Microstructure evaluation documented",null,"PPAP"]
[null,null,"5.","Flow lines","Documented image depicting weld flow lines","CTQ","Documented at PPAP",null,null,null,null,null,"Adequate distance and angle from joint line. (not intersecting the joint line)"]
[null,null,"6.","Destructive Testing ","Performed based off of the weld classification","CTQ","Per Weld ES or 1 part/fixture/shift Minimum","Quality Reports / records",null,null,null,null,null,"Performed on first and last piece off.  Pedal testing/bend testing/torsion testing as applicable"]
[null,null,"7.","Twist or Deflection Testing","100% twist or deflection testing shall be performed in line ",null,"On each part","Suspect rework containment system or controls"]
[null,null,"8.","Ultrasonic / Magnetic particle Testing","Ultrasonic or magnetic particle testing shall be performed ",null,"Per Weld ES or 1 part/fixture/shift Minimum","Quality Reports / records",null,null,null,null,"100% inline inspection"]
[null,null,"9.","Hardness Testing","Micro transverse hardness from parent material through weld checks shall be performed","CTQ","Per ES or Semi-annually","Quality reports"]
[null,null,"10.","Weld Identification in Control Plan","Welding Special Characteristic Identification: CC/SC Welds shall be identified by weld number in the control plan per the Design Records/DFMEA/PFMEA/SCCAF","CTQ","APQP","At PPAP"]
[null,null,"11.","Weld Lot Containment","All  weld validation testing is performed prior to shipping components critical (CC) welds (Batch & Hold)","CTQ","Destruct first off per fixture",null,null,null,null,null,"Done with first and last off for batch control.  Exceptions should be approved by PD & STA"]
[null,null,"12.","Control of Changes and Unplanned Events","An event matrix shall be followed for events not listed in the control plan OR if changes are made","CTQ","Each change or event","Event matrix",null,null,null,null,"Need approved event matrix (see SPL)"]
[null,null,"13.","Prelaunch Control Plans","All welds follow safe launch plan / prelaunch control plan based off of the welding safe launch plan, utilized from TT to MP 2",null,null,null,null,null,null,null,"Follow welding safe launch plan"]
[null,null,"14.","Production Part Traceability","Traceability to welding build date and weld fixture",null,null,null,null,null,null,null,null,"Bar coding"]
[null,null,"15.","Identification and Control of Nonconforming Parts","Physical separation and containment of Good and Reject Parts","CTQ","Each part","Part identification marking, tagging, containers/storage for Good and Reject Pars",null,null,null,null,null,"Tagging system and sensors in scrap bins linked to machine rejects. Internal auditing system to link machine rejects to actual scraped parts.  Lock box containment, Auto part destruction or disposal"]
[null,null,"16.","Setup Part Identification","Setup parts shall be marked for easy identification to prevent further processing or shipping",null,"Each part","Paint identification"]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA (SPL 6.5)"]
[null,null,"1.","Destructive Testing Data","Destructive testing data retention shall have a defined time period. ","CTQ",null,"Quality Reports"]
[null,null,"2.","Variable Data","Variable data shall be available and retained (actual measurements of cross sections)",null,"Each weld check","Quality Reports",null,null,null,null,"Curl length, width/height (upset)."]
[null,null,"3.","Attribute Data","Attribute data shall be available and retained  (pass/fail)",null,"Each weld check","Quality Reports & Check sheets"]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS (SPL 6.6)"]
[null,null,"1.","Lab Technician Training","Personnel involved in weld inspection shall be qualified by the supplier as receiving adequate formal training on the recognition of weld defects, their cause, and effect on the product. ",null,"Each technician","Training Matrix"]
[null,null,"2.","Inspector Vision Acuity","Personnel designated as weld inspectors must have their vision reviewed annually by the supplier for compliance with recognized corrected levels of vision (minimum of 20/30 near and distance with corrective lenses).",null,"Annually / Each technician","Vision Acuity Test",null,null,null,null,"Jaeger J2 at 12\"."]
[null,null,"3.","Weld Cross Section Examination","Weld examination equipment shall provide adequate magnification to capture the entire cross section, showing the measurements of the features defined in the welding specification in one picture","CTQ","Each cross section","Quality Reports",null,null,null,null,"Acid etched and reviewed under microscope with digital camera, 30X magnification maximum."]
[null,null,"4.","Weld Attribute Measurements","Per the welding specification, including (weld curl)",null,"Each cross section","Per ES",null,null,null,null,"Weld Measurement Software Used (Paxit measurement software or equivalent recommended)"]
[null,null,"5.","Cross Section Analysis Technique","Cross section measurement technique shall be reviewed by weld area manager and approved and signed off by PD and STA","CTQ","Each joint type at PPAP","Per ES or Joint Type Visual Aid",null,null,null,null,"Posted for technician at point of use"]
[null,null,"6.","Cut and Etch Measuring System Effectiveness ","Attribute Gauge R&R",null,"PPAP and Annual","For each technician",null,null,null,null,"Variable Gauge R&R on each attribute."]
[null,null,"7."," Weld Cross Section Evaluation (Pass/Fail Determination)","Software formulas shall be utilized to calculate/generate pass/fail",null,"Each weld attribute","Quality Reports",null,null,null,null,"Excel formulas, utilizing conditional formatted Red/Yellow/Green regions.  Conditional formatting logic to be validated"]
[null,null,"8.","Control Limits","Control limits shall be utilized for controlling weld leg size",null,"Each cross section","Quality Reports",null,null,null,null,"SPC trend charting of curl length for weld location stability"]
[null,null,"9.","Weld Quality Traceability","Welds shall be tracked  per stream/fixture/weld#",null,"Cut and Etch / Destructive Torque","Quality Reports"]
[null,null,"10.","Visual Aids","Visual aids shall be available for cross section attributes, defects, and common failures modes",null,null,"Visual Aids",null,null,null,null,"Posted for technician"]
[null,null,"6. PARAMETER DOCUMENTATION (SPL 6.9)"]
[null,null,"1.","Process Parameter Documentation","A controlled document shall contain all welding key process input variables and submitted at PPAP",null,"Start up","Check sheets",null,null,null,null,"Posted at cell and linked to startup check sheets"]
[null,null,"2.","Welding Parameters Controls","Welding parameter changes shall be password protected or gatekeeper controlled (quality manager, welding engineer)",null,null,"Key card lockouts",null,null,null,null,null,"Computer based auditing systems in place"]
[null,null,"3.","Key Process Input Variables",null,null,"Each startup","Check sheet"]
[null,null,null,"Spindle speed"]
[null,null,null,"Spindle clamp pressure"]
[null,null,null,"Fixture clamp pressure"]
[null,null,null,"Part stickout"]
[null,null,null,"Preheat force"]
[null,null,null,"Preheat time/RPM"]
[null,null,null,"Preheat shortening"]
[null,null,null,"Weld force"]
[null,null,null,"Friction speed"]
[null,null,null,"Forging speed"]
[null,null,null,"Forging force"]
[null,null,null,"Forging time"]
[null,null,null,"Forging length"]
[null,null,null,"Forge delay"]
[null,null,null,"Upset distance"]
[null,null,null,"Shortening"]
[null,null,null,"Upset hold time"]
[null,null,null,"Upset rate"]
[null,null,null,"Brake setting"]
[null,null,null,"Brake force"]
[null,null,null,"Brake delay"]
[null,null,null,"Total shortening"]
[null,null,"4.","Parameter Changes","All parameter changes within specification shall be documented, changes outside of limits shall follow SREA process",null,"Each change","Parameter change log",null,null,null,null,"All parameter changes signed off on by welding engineer"]
[null,null,"5.","Setup Tools","Setup tools shall be linked to startup check sheets or control plans",null,"Start of shift or Each setup","Check sheets",null,null,null,null,"Setup tools, head alignment pin, running red rabbits,…."]
[null,null,"7. MAINTENANCE RECORDS (SPL 6.10)"]
[null,null,"1.","Unplanned Downtime log","Maintenance reports shall be detailed to include technician identification, date, time, corrective action, and revalidation per the event matrix",null,"Each event","Recorded in downtime log sheet & audited to confirm compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.","Scheduled Preventative Maintenance (PM)","Established weld equipment PM per manufacturers recommendations",null,"Scheduled frequency","Evidence of compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.a","Stopper/Chuck Condition",null,null,"Weekly"]
[null,null,"2.b","Limit Verification","Red rabbits shall be run to verify stroke limits pre and post weld ","CTQ","Scheduled frequency","Start up Sheets"]
[null,null,"3.","Validation of Tooling Details","All details checked for looseness, all non-pinned details torque checked and match marked",null,"Start up / daily ","Looseness check",null,null,null,null,"Weekly torque checks/ weld"]
[null,null,"4.","Part touching details, clamps, locating pins, fixture locators and tooling mating surfaces","All mating surfaces shall be free of spatter and debris",null,"Start up / Daily / Change over","Check sheets",null,null,null,null,"Part / tooling sensors linked to PLC to ensure alignment"]
[null,null,"8. SUSTAINABILITY (SPL 6.12)"]
[null,null,"1.","Weld Sustainability Prove Out","Shall have demonstrated at last PPAP, or can prove through 10 consecutive days of meeting the welding spec without adjustments.","CTQ","At launch or per event matrix","Health charts",null,null,null,null,"Following welding safe launch plan and documents in health chart"]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS"]
[null,null,"1."]
[null,null,"10. Other"]
[null,null,"1."]

{"sheet":"Induction Welding Requirements","index":6,"n_rows":66,"n_cols":21,"rows_kept":66,"cut":false,"hidden":false,"merged":[[64,2,64,3],[62,2,62,3],[40,2,40,3],[56,2,56,3],[60,2,60,3],[29,2,29,3],[0,2,0,20],[2,7,2,9],[6,2,6,3],[11,2,11,3],[25,2,25,3]]}
[null,null,"                   Induction Welding Process Controls Checklist      "]
[]
[null,null,"","Assessor",{"$f":"'Supplier Information'!B11","v":0},null,"Welding Plant",{"$f":"'Supplier Information'!C3","v":""},null,null,null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Company)",null,null,"(Name - Location)"]
[]
[null,null,"Item No.","Area","Requirements","Char. Class. (min level)","Test / Inspection Frequencies (minimum)","Recommended Control Method","Initial Rating (R/Y/G) ","Evidence / Gap Identified","Current Rating (R/Y/G/)","Additional Comments"," Additional Information\nNOT TO BE RATED","Best Practice\nNOT TO BE RATED","Responsible Person","Management Champion","ICA","Proposed PCA","Open Date","Required Closure Date","Supplier Comments"]
[null,null,"1. PART PRINT (SPL 6.4)"]
[null,null,"1.","Welding Specifications","The latest revision of the welding specification, if available, at the time of release should be called out on the part print.  Black box components should follow industry or internal welding specifications.","CTQ","APQP","At PPAP",null,null,null,null,"Induction Welding: "]
[null,null,"2.","Weld Identification","Welds shall be numbered uniquely for consistent tracking","CTQ","APQP","At PPAP",null,null,null,null,"Unique weld number in the tail of each welding symbol"]
[null,null,"3.","Weld Symbol Callout","The weld symbol shall contain the Joint type, weld ID number, welding classification,  process, weld length.",null,"APQP","At PPAP",null,null,null,null,"Follow ISO 4063"]
[null,null,"4.","Weld Classification","Each weld number shall be assigned a classification","CTQ","APQP","At PPAP",null,null,null,null,"Any potential special characteristics related to the priority of each weld number should be defined on SCCAF"]
[null,null,"2. CONTROL PLAN (SPL 6.3)"]
[null,null,"1.","Weld Quality Inspection","Gauging to ensure proper curl","CTQ","Per weld ES or 1 parts/fixture/shift minimum","Operator check sheets"]
[null,null,"2.","Cut and Etch","Performed per the weld specification and weld classification","CTQ","Per Weld ES and at Each setup                                                                                             and CC/s- 1part/stream/fixture/shift                                   SC- 1part/stream/fixture/week                                        HIC- 1part/stream/fixture/month Minimum","Quality Reports / records",null,null,null,null,"Collecting variable data."]
[null,null,"3.","Microstructure Evaluation","Microstructure evaluation documented",null,"PPAP"]
[null,null,"4.","Flow lines","Documented image depicting weld flow lines","CTQ","Documented at PPAP",null,null,null,null,null,"Adequate distance and angle from joint line. (not intersecting the joint line)"]
[null,null,"5.","Destructive Testing ","Performed based off of the weld classification","CTQ","Per Weld ES/Each setup\nPer Weld ES or 1 part/fixture/shift Minimum","Quality Reports / records",null,null,null,null,null,"Performed on first and last piece off.  Cone, Flare, 3 ball, flattening 0 and 90 deg. bend testing/torsion testing as applicable"]
[null,null,"6.","Eddy Current / Ultrasonic Testing","Eddy Current or Ultrasonic testing shall be performed and used to trigger the paint marking system",null,1,null,null,null,null,null,"100% inline inspection","Pyrometer as additional process control at the mill.  \nUse UT inspection for all finial dimension tubing or subjected DOM tubing to UT test after drawing"]
[null,null,"7.","Hardness Testing","Micro transverse hardness from parent material through weld checks shall be performed","CTQ","Per ES or Semi-annually","Quality reports"]
[null,null,"8.","Weld Identification in Control Plan","Welding Special Characteristic Identification: CC/SC Welds shall be identified by weld number in the control plan per the Design Records/DFMEA/PFMEA/SCCAF",null,"APQP","At PPAP"]
[null,null,"9.","Weld Lot Containment","All  weld validation testing is performed prior to shipping components critical (CC) welds (Batch & Hold)","CTQ","Destruct first off per fixture",null,null,null,null,null,"Done with first and last off for batch control.  Exceptions should be approved by PD & STA"]
[null,null,"10.","Control of Changes and Unplanned Events","An event matrix shall be followed for events not listed in the control plan OR if changes are made","CTQ","Each change or event","Event matrix",null,null,null,null,"Need approved event matrix (see SPL)"]
[null,null,"11.","Production Part Traceability","Traceability to welding build date and mill line"]
[null,null,"12.","Identification and Control of Nonconforming Parts","Physical separation and containment of Good and Reject Parts","CTQ","Each part","Automatic Paint Marking",null,null,null,null,null,"Automatic paint marking and shortened cutoff length"]
[null,null,"13.","Setup Part Identification","Setup parts shall be marked for easy identification to prevent further processing or shipping",null,"Each part","Automatic Paint Marking",null,null,null,null,null,"Automatic paint marking and shortened cutoff length"]
[null,null,"3. DESTRUCTIVE & NONDESTRUCTIVE TESTING DATA (SPL 6.5)"]
[null,null,"1.","Destructive Testing Data","Destructive testing data retention shall have a defined time period. ","CTQ",null,"Quality Reports"]
[null,null,"2.","Variable Data","Variable data shall be available and retained (actual measurements of cross sections)",null,"Each weld check","Quality Reports",null,null,null,null,"Curl length, width/height (upset)."]
[null,null,"3.","Attribute Data","Attribute data shall be available and retained  (pass/fail)",null,"Each weld check","Quality Reports & Check sheets"]
[null,null,"4. WELD QUALITY INSPECTION & REPORTS (SPL 6.6)"]
[null,null,"1.","Lab Technician Training","Personnel involved in weld inspection shall be qualified by the supplier as receiving adequate formal training on the recognition of weld defects, their cause, and effect on the product. ",null,"Each technician","Training Matrix"]
[null,null,"2.","Inspector Vision Acuity","Personnel designated as weld inspectors must have their vision reviewed annually by the supplier for compliance with recognized corrected levels of vision (minimum of 20/30 near and distance with corrective lenses).",null,"Annually / Each technician","Vision Acuity Test",null,null,null,null,"Jaeger J2 at 12\"."]
[null,null,"3.","Weld Cross Section Examination","Weld examination equipment shall provide adequate magnification to capture the entire cross section, showing the measurements of the features defined in the welding specification in one picture","CTQ","Each cross section",null,null,null,null,null,"Acid etched and reviewed under microscope with digital camera, 30X magnification maximum."]
[null,null,"4.","Weld Attribute Measurements","Per the welding specification, including presence of ferrite band for 100% of thickness and flow line angles for ID & OD of tube",null,"Each cross section","Per ES",null,null,null,null,"Weld Measurement Software Used (Paxit measurement software or equivalent recommended)"]
[null,null,"5.","Cross Section Analysis Technique","Cross section measurement technique shall be reviewed by weld area manager and approved and signed off PD and STA","CTQ","Each joint type at PPAP","Per ES or Joint Type Visual Aid",null,null,null,null,"Posted for technician at point of use"]
[null,null,"6.","Cut and Etch Measuring System Effectiveness ","Attribute Gauge R&R",null,"PPAP and Annual","For each technician",null,null,null,null,"Variable Gauge R&R on each attribute."]
[null,null,"7."," Weld Cross Section Evaluation (Pass/Fail Determination)","Software formulas shall be utilized to calculate/generate pass/fail",null,"Each weld attribute","Quality Reports",null,null,null,null,"Excel formulas, utilizing conditional formatted Red/Yellow/Green regions.  Conditional formatting logic to be validated"]
[null,null,"8.","Control Limits","Control limits shall be utilized ",null,"Each cross section","Quality Reports"]
[null,null,"9.","Weld Quality Traceability","Welds shall be tracked  per mill",null,"Cut and Etch / Destructive Torque","Quality Reports"]
[null,null,"10.","Visual Aids","Visual aids shall be available for cross section attributes, defects, and common failures modes",null,null,"Visual Aids",null,null,null,null,"Posted for technician"]
[null,null,"6. PARAMETER DOCUMENTATION (SPL 6.9)"]
[null,null,"1.","Process Parameter Documentation","A controlled document shall contain all welding key process input variables and submitted at PPAP",null,"Start up","Check sheets",null,null,null,null,"Posted at cell and linked to startup check sheets"]
[null,null,"2.","Welding Parameters Controls","Welding parameter changes shall be password protected or gatekeeper controlled (quality manager, welding engineer)",null,null,"Key card lockouts",null,null,null,null,null,"Computer based auditing systems in place"]
[null,null,"3.","Key Process Input Variables",null,null,"Each startup","Check sheet"]
[null,null,null,"Power (Secondary)"]
[null,null,null,"Frequency"]
[null,null,null,"Weld travel speed / Mill speed"]
[null,null,null,"System cooling coil / transformers, electrodes, etc."]
[null,null,null,"Coil change frequency"]
[null,null,null,"Tip/electrode/wheel/coil alignment"]
[null,null,null,"Electrode selection/type (material type etc.)"]
[null,null,null,"Electrode geometry"]
[null,null,null,"Induction coil geometry"]
[null,null,null,"Impeder / Consentrator"]
[null,null,"4.","Parameter Changes","All parameter changes within specification shall be documented, changes outside of limits shall follow SREA process",null,"Each change","Parameter change log",null,null,null,null,"All parameter changes signed off on by welding engineer"]
[null,null,"5.","Setup Tools","Setup tools shall be linked to startup check sheets or control plans",null,"Start of shift or Each setup","Check sheets",null,null,null,null,"Setup tools such as: roller gap checks, coil alignment gage for standoff distance"]
[null,null,"7. MAINTENANCE RECORDS (SPL 6.10)"]
[null,null,"1.","Unplanned Downtime log","Maintenance reports shall be detailed to include technician identification, date, time, corrective action, and revalidation per the event matrix",null,"Each event","Recorded in downtime log sheet & audited to confirm compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"2.","Scheduled Preventative Maintenance (PM)","Established weld equipment PM per manufacturers recommendations",null,"Scheduled frequency","Evidence of compliance",null,null,null,null,null,"Input into electronic maintenance tracking database"]
[null,null,"3.","Part touching details, clamps, locating pins, fixture locators and tooling mating surfaces","All mating surfaces shall be free of spatter and debris",null,"Start up / Daily / Change over","Check sheets",null,null,null,null,"Part / tooling sensors linked to PLC to ensure alignment"]
[null,null,"8. SUSTAINABILITY (6.12)"]
[null,null,"1.","Weld Sustainability Prove Out","Shall have demonstrated at last PPAP, or can prove through 10 consecutive days of meeting the welding spec without adjustments.","CTQ","At launch or per event matrix","Health charts"]
[null,null,"9. EQUIPMENT & ROBOTIC PROCESSING REQUIREMENTS"]
[null,null,"1."]
[null,null,"10. Other"]
[null,null,"1."]

{"sheet":"UT Implemetation Checklist","index":7,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,0,20],[6,2,6,3],[12,2,12,3],[2,7,2,9]]}
[null,null,"                   Ultrasonic Testing Implementation Checklist      "]
[]
[null,null,"","Assessor",{"$f":"'Supplier Information'!B11","v":0},null,"Welding Plant",{"$f":"'Supplier Information'!C3","v":""},null,null,null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Company)",null,null,"(Name - Location)"]
[]
[null,null,"Item No.","Area","Requirements","Char. Class. (min level)","Test / Inspection Frequencies (minimum)","Recommended Control Method","Initial Rating (R/Y/G) ","Evidence / Gap Identified","Current Rating (R/Y/G)","Additional Comments"," Additional Information\nNOT TO BE RATED","Best Practice \nNOT TO BE RATED","Responsible Person","Management Champion","ICA","Proposed PCA","Open Date","Required Closure Date","Supplier Comments"]
[null,null,"Pre-Implementation"]
[null,null,"1.","Overall Weld Effectiveness","The plant has demonstrated overall weld effectiveness greater than 98% per month for three consecutive months.  ",null,"Before implementation & ongoing","Health charts"]
[null,null,"2.","Gage R&R","For a valid study, a group of at least three OJT candidates must take part in the Gage R&R assessment. During the study, a Qualified L-II may substitute for a third L-I Trainee. A Study Variation of less than or equal to 20% is acceptable. Between 20% and 30% is marginal, and above 30% is unacceptable where the caliper measurement process needs improvement.",null,"Before implementation ","PPAP"]
[null,null,"3.","Vision Screening"," Each inspector (L-I) and coordinator (L-II) must pass a Near Vision Acuity test at the initial qualification stage and annually thereafter, as well as a Color Contrast Differentiation examination at the initial qualification stage and at five year intervals thereafter.",null,"Before implementation & annually","Training matrix"]
[null,null,"4.","NDT Level 3 Identification","Suppliers shall have a NDT Level III (L-III) person on staff or on retainer with responsibility for the NDT operations.",null,"Before implementation & ongoing"]
[null,null,"5.","Welding Assessment","Suppliers shall have a green rating on welding assessment"]
[null,null,"Implementation"]
[null,null,"1.","Level 1 - Classroom training","Classroom training time shall be 16 hours for basic UT technology and equipment.  Formal training may be a mix of classroom, practical and single point self-instruction and At the conclusion of the basic training class, each individual must pass a written assessment with a minimum of a 70% success rate",null,null,"Training matrix"]
[null,null,"2.","Level 1 - On the Job Training (OJT)","The 30 day OJT period shall include a minimum of 3000 production level welds with a minimum of 5% being discrepant (undersize, cold, defective). NDT results are to be recorded in a 30 Day Report spreadsheet.    ",null,null,"Training matrix"]
[null,null,"3.","Level 1 - Correlation Study","Satisfactory correlation is demonstrated by performing an Ultrasound correlation test with Alpha Error ≤ 5% and Beta Error ≤ 20%. ",null,null,"Training matrix"]
[null,null,"4.","Level 2 - Classroom training","Classroom training time shall be 8 hours for advanced UT technology and equipment.  Formal training may be a mix of classroom, practical and single point self-instruction and At the conclusion of the basic training class, each individual must pass a written assessment with a minimum of a 70% success rate",null,null,"Training matrix"]
[null,null,"5.","Level 2 - On the Job Training","An OJT period should last a minimum of 90 production days and shall be documented in a log and maintained by the Supplier",null,null,"Training matrix"]
[null,null,"6.","Sub Assembly Qualification","All initial qualifications shall complete the Correlation Test Process ",null,null,"Training matrix"]
[null,null,"7.","Finial Approval To Implement","Approved SREA and PPAP",null,"Before Reducing Tear Down Frequency's","SREA & PPAP"]

{"sheet":"GMAW - Safe Launch","index":8,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,0,29,0],[0,0,0,10],[2,0,2,1],[3,6,3,7],[20,0,24,0],[14,0,19,0],[9,0,13,0],[6,0,8,0],[6,3,6,10],[2,6,2,8]]}
["                        \nGMAW - Welding Safe Launch Guideline      "]
[]
["Assessor",null,"",null,null,"Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","SC / Sensitive \nSample Size","General / Key\nSample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified"," Additional Information\nNOT TO BE RATED","Best Practices \nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples","FOR SEATING COMPONENTS FOLLOW ES REQUIREMENTS"]
[null,1.1000000000000001,"Visual Inspection",1,1,1,1]
[null,1.2,"Cut and Etch","1 piece","1 piece","1 piece","1 piece",null,null,"Out of DV build"]
[2,null," TT- MP1 (Prelaunch Control Plan)"]
[null,2.1,"Visual Inspection",1,1,1,1,null,null,null,"200% Best practice"]
[null,2.2000000000000002,"Off Line Visual Inspection","3 pieces / fixture / lot","3 pieces / fixture / lot","3 pieces / fixture / lot","3 pieces / fixture / lot",null,null,"Welds to be measured and/or gauged"]
[null,2.2999999999999998,"Destruct Test","1 piece / fixture / lot","1 piece / fixture / lot","1 piece / fixture / lot","1 piece / fixture / lot",null,null,"Record results in health charts to prove out sustainability. Must have with 10 days/lots with consecutive \"Pass\" results with out changes.    "]
[null,2.4,"Cut and Etch","1 piece / fixture / lot","1 piece / fixture / lot","1 piece / fixture / lot","1 piece / fixture / lot",null,null,"Record results in health charts to prove out sustainability. Must have with 10 days/lots with consecutive \"Pass\" results with out changes.    For seating components follow ES"]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1,1,1,null,null,null,"200% Best practice"]
[null,3.2,"Off Line Visual Inspection (In quality area / check fixture)","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"Welds to be measured and/or gauged"]
[null,3.3,"Destruct Test","1 pieces / fixture","1 pieces / fixture","1 pieces / fixture","1 pieces / fixture",null,null,"Destruct test results to be recorded by weld number"]
[null,3.4,"Cut and Etch","2 pieces / fixture","2 pieces / fixture","2 pieces / fixture","2 pieces / fixture",null,null,"Record results in health charts to prove out sustainability. Must have with 10 days/lots with consecutive \"Pass\" results with out changes.    ","Effective weld length validated with cross sectional data for actual run in / run out"]
[null,3.5,"Micro hardness","1 piece","1 piece","1 piece","1 piece",null,null,"Based on material grade and welding parameters"]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1,1,1]
[null,4.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 piece / fixture / shift ","3 piece / fixture / shift ","3 piece / fixture / shift ",null,null,"Welds to be measured and/or gauged"]
[null,4.3,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Record results in health charts to prove out sustainability. Must have with 10 days/lots with consecutive \"Pass\" results with out changes.    "]
[null,4.4000000000000004,"Cut and Etch","1 pieces / fixture / shift","1 pieces / fixture / day","1 pieces / fixture / week","1 pieces / fixture / month",null,null,"Record results in health charts to prove out sustainability. Must have with 10 days/lots with consecutive \"Pass\" results with out changes.    "]
[5,null,"120 Days Post J1 - SREA for Rotational Fixture Sampling ",null,null,null,null,null,null,"Optional for Sustainable Process","Optional for Sustainable Process"]
[null,5.0999999999999996,"Visual Inspection",1,1,1,1]
[null,5.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 piece / fixture / shift ","3 piece / fixture / shift ","3 piece / fixture / shift ",null,null,"Welds to be measured and/or gauged"]
[null,5.3,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift"]
[null,5.4,"Cut and Etch","1 pieces / shift, rotating fixtures","1 pieces / day, rotating fixtures","1 pieces / fixture / week","1 pieces / fixture / month"]

{"sheet":"LBW - Safe Launch","index":9,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,0,32,0],[23,0,27,0],[0,0,0,9],[2,0,2,1],[3,5,3,6],[11,0,15,0],[16,0,22,0],[6,0,10,0],[6,3,6,9],[2,5,2,7]]}
["                        \nLBW - Welding Safe Launch Guideline      "]
[]
["Assessor",null,"",null,"Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","SC \nSample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified","Additional Information\nNOT TO BE RATED","Best Practices\nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples","FOR SEATING COMPONENTS FOLLOW ES REQUIREMENTS"]
[null,1.1000000000000001,"Visual Inspection",1,1,1]
[null,1.2,"Cut and Etch","1 piece","1 piece","1 piece",null,null,"Out of DV build"]
[null,1.3,"Die Penetrant Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Performed at a minimum of 24 hours after welding"]
[null,1.4,"Micro hardness Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Out of DV build"]
[2,null," TT- MP1 (Prelaunch Control Plan)"]
[null,2.1,"Visual Inspection",1,1,1,null,null,null,"200% Best practice"]
[null,2.2000000000000002,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Welds to be measured and/or gauged.  Visual inspection with magnification aid"]
[null,2.2999999999999998,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Destruct test results to be recorded by weld number"]
[null,2.4,"Cut and Etch","2 pieces / fixture / shift","2 pieces / fixture / shift","2 pieces / fixture / shift",null,null,"First off and Last Off.  Record results in health charts to prove out sustainability. Must have with 10 days/shifts with consecutive \"Pass\" results with out changes.    "]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1,1]
[null,3.2,"Off Line Visual Inspection","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"Welds to be measured and/or gauged"]
[null,3.3,"Destruct Test","1 pieces / fixture","1 pieces / fixture","1 pieces / fixture",null,null,"Destruct test results to be recorded by weld number"]
[null,3.4,"Cut and Etch","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"First/Middle/Last. Software formulas utilized for pass/fail results.  ","Effective weld length validated with cross sectional data for actual run in / run out"]
[null,3.5,"Die Penetrant Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Performed at a minimum of 24 hours after welding"]
[null,3.6,"Micro hardness Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Based on material grade and welding parameters"]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1,1]
[null,4.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift "]
[null,4.3,"Destruct Test","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift",null,null,"Prove out sustainability with 10 consecutive \"Pass\" results.  Record evidence in heath chart"]
[null,4.4000000000000004,"Cut and Etch","1 pieces / fixture / shift","1 pieces / fixture / day","1 pieces / fixture / week",null,null,"Prove out sustainability with 10 consecutive \"Pass\" results.  Record evidence in heath chart.  "]
[5,null,"120 Days Post J1 - SREA for Rotational Fixture Sampling ",null,null,null,null,null,"Optional for Sustainable Process","Optional for Sustainable Process"]
[null,5.0999999999999996,"Visual Inspection",1,1,1,null,null,1]
[null,5.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift ",null,null,"Welds to be measured and/or gauged"]
[null,5.3,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift"]
[null,5.4,"Cut and Etch","1 pieces / shift, rotating fixtures","1 pieces / day, rotating fixtures","1 pieces / fixture / week",null,null,"With approved event matrix","With approved event matrix"]

{"sheet":"Resistance - Safe Launch","index":10,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,0,27,0],[0,0,0,8],[2,0,2,1],[3,4,3,5],[9,0,13,0],[14,0,18,0],[19,0,22,0],[6,0,8,0],[2,4,2,6]]}
["                        \nResistance - Welding Safe Launch Guideline      "]
[]
["Assessor",null,"","Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified","Additional Information\nNOT TO BE RATED","Best Practices \nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples"]
[null,1.1000000000000001,"Visual Inspection",1,1]
[null,1.2,"Destruct Test","2 piece","2 piece",null,null,"As a minimum, one assembly from each tool shall be destructively tested in accordance with the applicable engineering specification at shift start, and one at the end of the production shift or shift, whichever occurs first. For prototype and pre-production assembly orders, a minimum of 5 assemblies or 5% of the total assemblies ordered (which ever is greater) shall be destructively tested. The 5 or 5% shall be evenly distributed throughout the order and must include the first and last assemblies. This is to be done for each tool building the assembly. Weld teardown unit shall have 100% weld verification. "]
[2,null," TT- MP1 (Prelaunch Control Plan)",null,null,null,null,null,null,"G"]
[null,2.1,"Visual Inspection",1,1,null,null,null,"200% Best practice","Y"]
[null,2.2000000000000002,"Off Line Visual Inspection","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Welds to be measured and/or gauged"]
[null,2.2999999999999998,"Pry bar ","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,null,null,"R"]
[null,2.4,"Destruct Test","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Weld teardown unit shall have 100% weld verification (NO GROUPING ALLOWANCES). If 100% is not achieved on the first unit, corrective actions shall be taken to address the undersize and/or discrepant welds.  All undersize and/or discrepant welds shall be reworked.  This process shall continue until 100% weld verification is achieved. The weld teardown unit(s) shall be retained, weld quality data shall be submitted with delivered assemblies."]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1]
[null,3.2,"Off Line Visual Inspection","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Welds to be measured and/or gauged"]
[null,3.3,"Pry bar ","1 pieces / hour","1 pieces / hour"]
[null,3.4,"Destruct Test","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Prove out sustainability with 10 consecutive \"Pass\" results.  Record evidence in heath chart.  "]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1]
[null,4.2,"Off Line Visual Inspection","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Welds to be measured and/or gauged"]
[null,4.3,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Record results in health charts to prove out sustainability. Must have with 10 days/shifts with consecutive \"Pass\" results with out changes.    "]
[5,null,"120 Days Post J1 - SREA for Implementing Ultrasonic Testing",null,null,null,"Optional for Sustainable Process"]
[null,5.0999999999999996,"Visual Inspection",1,1]
[null,5.2,"Off Line Visual Inspection","1 pieces / fixture / shift","1 pieces / fixture / shift"]
[null,5.3,"Destruct Test","1 pieces / fixture / week","1 pieces / fixture / week"]
[null,5.4,"Ultrasonic Testing","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Ultrasonic testing may be performed after  a correlation has been established and the SREA is approved (SPL 6.16)"]

{"sheet":"Fastener Welding - Safe Launch","index":11,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,0,19,0],[20,0,24,0],[25,0,29,0],[0,0,0,9],[2,0,2,1],[3,5,3,6],[6,0,9,0],[10,0,14,0],[2,5,2,7]]}
["                        \nFasteners - Welding Safe Launch Guideline      "]
[]
["Assessor",null,"",null,"Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","SC \nSample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified","Additional Information\nNOT TO BE RATED","Best Practices\nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples"]
[null,1.1000000000000001,"Visual Inspection",1,1,1]
[null,1.2,"Non-Destructive Testing","3 pieces","3 pieces","3 pieces",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,1.3,"Destruct Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Destruct test results to be recorded by weld number, May be torque or pushout"]
[2,null," TT- MP1 (Prelaunch Control Plan)"]
[null,2.1,"Visual Inspection",1,1,1]
[null,2.2000000000000002,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Welds to be measured and/or gauged.  Visual inspection with magnification aid"]
[null,2.2999999999999998,"Non-Destructive Testing","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,2.4,"Destruct Test","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Destruct test results to be recorded by weld number, May be torque or pushout"]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1,1,null,null,null,"200% Best practice"]
[null,3.2,"Off Line Visual Inspection","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"Welds to be measured and/or gauged"]
[null,3.3,"Non-Destructive Testing","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,3.4,"Destruct Test","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Destruct test results to be recorded by weld number, May be torque or pushout"]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1,1]
[null,4.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift "]
[null,4.3,"Non-Destructive Testing","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,4.4000000000000004,"Destruct Test","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift",null,null,"Prove out sustainability with 10 consecutive \"Pass\" results.  Record evidence in heath chart"]
[5,null,"120 Days Post J1 - SREA for Rotational Fixture Sampling ",null,null,null,null,null,"Optional for Sustainable Process"]
[null,5.0999999999999996,"Visual Inspection",1,1,1]
[null,5.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift ",null,null,"Welds to be measured and/or gauged"]
[null,5.3,"Non-Destructive Testing","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift"]
[null,5.4,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift"]

{"sheet":"Spin Welding - Safe Launch","index":12,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[18,0,24,0],[25,0,29,0],[30,0,34,0],[0,0,0,9],[2,0,2,1],[3,5,3,6],[6,0,11,0],[12,0,17,0],[2,5,2,7]]}
["                        \nSpin Welding - Welding Safe Launch Guideline      "]
[]
["Assessor",null,"",null,"Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","SC \nSample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified","Additional Information\nNOT TO BE RATED","Best Practices\nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples"]
[null,1.1000000000000001,"Visual Inspection",1,1,1]
[null,1.2,"Cut and Etch","1 piece","1 piece","1 piece",null,null,"Out of DV build"]
[null,null,"Non-Destructive Testing","3 pieces (first/middle/last)","3 pieces (first/middle/last)","3 pieces (first/middle/last)",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,null,"Destruct Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,1.4,"Micro hardness Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Out of DV build"]
[2,null," TT- MP1 (Prelaunch Control Plan)"]
[null,2.1,"Visual Inspection",1,1,1,null,null,"Visual indicator for weld presence and gross defects","200% Best practice"]
[null,2.2000000000000002,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Welds to be measured and/or gauged.  Visual inspection with magnification aid"]
[null,null,"Non-Destructive Testing","3 pieces (first/middle/last)","3 pieces (first/middle/last)","3 pieces (first/middle/last)",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,2.2999999999999998,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,2.4,"Cut and Etch","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift"]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1,1]
[null,3.2,"Off Line Visual Inspection","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"Welds to be measured and/or gauged"]
[null,null,"Non-Destructive Testing","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,3.3,"Destruct Test","1 pieces / fixture","1 pieces / fixture","1 pieces / fixture",null,null,"Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,3.4,"Cut and Etch","2 pieces / fixture","2 pieces / fixture","2 pieces / fixture",null,null,"First/Last. Software formulas utilized for pass/fail results.  "]
[null,3.6,"Micro hardness Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Based on material grade and welding parameters"]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1,1]
[null,4.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift "]
[null,null,"Non-Destructive Testing","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift",null,null,"Non-Destruct test results to be recorded by weld number, May be torque or pushout"]
[null,4.3,"Destruct Test","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift",null,null,"Prove out sustainability with 10 consecutive \"Pass\" results.  Record evidence in heath chart"]
[5,null,"120 Days Post J1 - SREA for Rotational Fixture Sampling ",null,null,null,null,null,"Optional for Sustainable Process"]
[null,5.0999999999999996,"Visual Inspection",1,1,1,null,null,1]
[null,5.2,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift ",null,null,"Welds to be measured and/or gauged"]
[null,null,"Non-Destructive Testing","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift"]
[null,5.3,"Destruct Test","1 pieces / fixture / weekly","1 pieces / fixture / weekly","1 pieces / fixture / monthly"]

{"sheet":"Induction Welding- Safe Launch ","index":13,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[19,0,25,0],[32,0,36,0],[0,0,0,9],[2,0,2,1],[2,5,2,7],[3,5,3,6],[6,0,12,0],[13,0,18,0],[26,0,31,0]]}
["                        \nInduction Welding - Welding Safe Launch Guideline      "]
[]
["Assessor",null,"",null,"Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","SC \nSample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified","Additional Information\nNOT TO BE RATED","Best Practices\nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples"]
[null,1.1000000000000001,"Visual Inspection",1,1,1,null,null,"Visual indicator for weld curl and gross defects"]
[null,1.2,"Eddy Current / Ultrasonic Testing",1,1,1,null,null,"Use UT inspection for all finial dimension tubing or subjected DOM tubing to UT test after drawing"]
[null,1.3,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift"]
[null,1.4,"Destruct Test","2 piece","2 piece","2 piece",null,null,"Performed on first and last piece off.  Cone, Flare, 3 ball, flattening 0 and 90 deg. bend testing/torsion testing as applicable"]
[null,1.5,"Cut and Etch","1 piece","1 piece","1 piece",null,null,"Out of DV build"]
[null,1.6,"Micro hardness Test","1  piece","1 piece","1 piece",null,null,"Out of DV build"]
[2,null," TT- MP1 (Prelaunch Control Plan)"]
[null,2.1,"Visual Inspection",1,1,1,null,null,"Visual indicator for weld curl and gross defects"]
[null,2.2000000000000002,"Eddy Current / Ultrasonic Testing",1,1,1,null,null,"Use UT inspection for all finial dimension tubing or subjected DOM tubing to UT test after drawing"]
[null,2.2999999999999998,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 pieces / fixture / shift"]
[null,2.4,"Destruct Test","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"Performed on first and last piece off.  Cone, Flare, 3 ball, flattening 0 and 90 deg. bend testing/torsion testing as applicable"]
[null,2.5,"Cut and Etch","1 pieces / fixture / shift","1 pieces / fixture / shift","1 pieces / fixture / shift"]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1,1,null,null,"Visual indicator for weld curl and gross defects"]
[null,3.2,"Eddy Current / Ultrasonic Testing",1,1,1,null,null,"Use UT inspection for all finial dimension tubing or subjected DOM tubing to UT test after drawing"]
[null,3.3,"Off Line Visual Inspection","3 pieces / fixture","3 pieces / fixture","3 pieces / fixture",null,null,"Welds to be measured and/or gauged"]
[null,3.5,"Destruct Test","1 pieces / fixture","1 pieces / fixture","1 pieces / fixture",null,null,"Performed on first and last piece off.  Cone, Flare, 3 ball, flattening 0 and 90 deg. bend testing/torsion testing as applicable"]
[null,3.6,"Cut and Etch","2 pieces / fixture","2 pieces / fixture","2 pieces / fixture",null,null,"First/Last. Software formulas utilized for pass/fail results.  "]
[null,3.7,"Micro hardness Test","1 piece, All welds","1 piece, All welds","1 piece, All welds",null,null,"Based on material grade and welding parameters"]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1,1,null,null,"Visual indicator for weld curl and gross defects"]
[null,4.2,"Eddy Current / Ultrasonic Testing",1,1,1,null,null,"Use UT inspection for all finial dimension tubing or subjected DOM tubing to UT test after drawing"]
[null,4.3,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift "]
[null,4.4000000000000004,"Destruct Test","1 pieces / fixture / Shift","1 pieces / fixture / Shift","1 pieces / fixture / Shift",null,null,"Performed on first and last piece off.  Cone, Flare, 3 ball, flattening 0 and 90 deg. bend testing/torsion testing as applicable"]
[null,4.5,"Cut and Etch","2 pieces / fixture","2 pieces / fixture","2 pieces / fixture",null,null,"First/Last. Software formulas utilized for pass/fail results.  "]
[5,null,"120 Days Post J1 - SREA for Rotational Fixture Sampling ",null,null,null,null,null,"Optional for Sustainable Process"]
[null,5.0999999999999996,"Visual Inspection",1,1,1,null,null,"Visual indicator for weld curl and gross defects"]
[null,5.2,"Eddy Current / Ultrasonic Testing",1,1,1]
[null,5.3,"Off Line Visual Inspection","3 pieces / fixture / shift","3 pieces / fixture / shift","3 piece / fixture / shift ",null,null,"Welds to be measured and/or gauged"]
[null,5.4,"Destruct Test","1 pieces / fixture / weekly","1 pieces / fixture / weekly","1 pieces / fixture / monthly",null,null,"Performed on first and last piece off.  Cone, Flare, 3 ball, flattening 0 and 90 deg. bend testing/torsion testing as applicable"]
[null,5.5,"Cut and Etch","2 pieces / fixture","2 pieces / fixture","2 pieces / fixture",null,null,"First/Last. Software formulas utilized for pass/fail results.  "]

{"sheet":"Riveting - Safe Launch ","index":14,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,0,19,0],[20,0,24,0],[25,0,29,0],[0,0,0,8],[2,0,2,1],[3,4,3,5],[6,0,9,0],[10,0,14,0],[2,4,2,6]]}
["                        \nSelf Piercing Rivets - Safe Launch Guideline      "]
[]
["Assessor",null,"","Supplier",{"$f":"'Supplier Information'!C3","v":""},null,null,"Date",{"$f":"'Supplier Information'!C6","v":"00:00:00"}]
[null,null,null,null,"(Name - Location)"]
[]
["Event","Item","Characteristics","Inverted Delta Sample Size","All Other \nSample Size","G/Y/R","Evidence or Gap identified"," Additional Information\nNOT TO BE RATED","Best Practices \nNOT TO BE RATED"]
[1,null,"DV - TT Test Samples"]
[null,1.1000000000000001,"Visual Inspection",1,1]
[null,1.2,"Flushness Check","1 / every 150 pieces","2 pieces / fixture / shift",null,null,"First & Last"]
[null,1.3,"Destruct Test","N/A","N/A"]
[2,null," TT- MP1 (Prelaunch Control Plan)",null,null,null,null,null,null,"G"]
[null,2.1,"Visual Inspection",1,1,null,null,null,null,"Y"]
[null,2.2000000000000002,"Off Line Visual Inspection","2 pieces / fixture / shift","2 pieces / fixture / shift",null,null,"First & Last - No cracks, not tumbled, no double rivets"]
[null,2.2999999999999998,"Flushness Check","1 / every 150 pieces","2 pieces / fixture / shift",null,null,"First & Last",null,"R"]
[null,2.4,"Destruct Test","N/A","N/A"]
[3,null,"PPAP - Production Run @ Rate (1 time event)"]
[null,3.1,"Visual Inspection",1,1]
[null,3.2,"Off Line Visual Inspection","2 pieces / fixture / shift","2 pieces / fixture / shift",null,null,"First & Last - No cracks, not tumbled, no double rivets"]
[null,3.3,"Flushness Check","1 / every 150 pieces","2 pieces / fixture / shift",null,null,"First & Last"]
[null,3.4,"Destruct Test","N/A","N/A"]
[4,null,"Production"]
[null,4.0999999999999996,"Visual Inspection",1,1]
[null,4.2,"Off Line Visual Inspection","2 pieces / fixture / shift","1 pieces / fixture / shift",null,null,"First & Last - No cracks, not tumbled, no double rivets"]
[null,4.3,"Flushness Check","1 / every 150 pieces","2 pieces / fixture / shift",null,null,"First & Last"]
[null,4.4000000000000004,"Destruct Test","N/A","N/A"]
[5,null,"120 Days Post J1 - SREA"]
[null,5.0999999999999996,"Visual Inspection",1,1]
[null,5.2,"Off Line Visual Inspection","2 pieces / fixture / shift","2 pieces / fixture / shift",null,null,"First & Last - No cracks, not tumbled, no double rivets"]
[null,5.3,"Flushness Check","1 / every 150 pieces","1 pieces / fixture / shift",null,null,"First & Last"]
[null,5.4,"Destruct Test","N/A","N/A"]

{"sheet":"Revision History","index":15,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[" Team Approved Date","Revision Type (New, Major, Minor, Administrative)","Summary of Change","Change Author","Publication Date"]
["2014-06-05","N/A","Initial Release","N/A","2014-06-05"]
["2014-12-14","Minor","","Travie Cruzan","2015-01-01"]
["2016-01-15","Major",null,"Mark Gutting","2016-01-15"]
["2017-01-13","New/Major/Administrative","Added numbering sequence 1-10 for each area of assessment.\nAdded GMAW 2.5 Weld Identification as a CTQ element.\nAdded TOTAL length as a requirement in all applicable sections.\nAdded requirement 4.10 in LBW section\nReleased revision 3.0\n","Mark Gutting","2017-01-03"]

{"sheet":"Sheet1","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}