{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["3L5Y - Blank Master","1 Pg - Cheat Sheet","Cheat Sheet Details","Containment Worksheet","Quality Alert","Supporting Documents","3L5W Review Minutes","Detection","Severity","Occurrence","Product Severity Rank","Revision tracker"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":1,"defined_names":35,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"3L5Y - Blank Master","index":0,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,1,0,9],[47,7,47,9],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,9],[33,1,34,2],[37,1,38,2],[39,1,40,2],[41,1,42,2],[15,1,16,2],[15,5,15,6],[1,1,2,9],[10,7,10,9],[35,0,46,0],[35,1,36,2],[35,3,46,4],[35,5,35,6],[35,7,46,9],[36,5,46,6],[43,1,44,2],[45,1,46,2],[47,0,50,0],[47,1,47,2],[47,3,47,4],[47,5,47,6],[49,3,50,9],[49,2,50,2],[23,0,34,0],[23,1,24,2],[23,3,34,4],[23,5,23,6],[23,7,34,9],[24,5,34,6],[25,1,26,2],[27,1,28,2],[29,1,30,2],[31,1,32,2],[3,0,10,0],[5,2,6,2],[10,1,10,2],[10,3,10,4],[10,5,10,6],[5,3,6,9],[7,6,7,9],[8,6,9,9],[11,0,22,0],[11,1,12,2],[11,3,22,4],[11,7,22,9],[13,1,14,2],[17,1,18,2],[19,1,20,2],[21,1,22,2],[16,5,22,6],[11,5,14,6]]}
[null,"Form: 15-1-5-F6  Rev. Date:  6 October, 2017:    Read \"Pop Up\" instructions in each box.   All White areas need to be filled in.   Grey areas are for Nexteer use only.  "]
[null,"Note:  Within each Leg,  develop as many legs as necessary (for instance in Nexteer, at supplier etc). If it is too complex, you can develop a 3L5Y for each area (Nexteer Internal/ Supplier/ Sub-tier Supplier)"]
[]
[null,"Nexteer Plant","Part Number","Part Name and /or Process Name","Date of Occurrence","Formal Customer Complaint (FCC), and/or, Product Safety & Compliance Council (PSCC) ","Nexteer Plant Tracking Number","OEM Customer","FCC Qty of Pcs in the complaint","Date 3L5Y Submitted"]
[null," ",null,null,null," "]
[null,"Intelex #  (if applicable)","Detailed Problem Definition: "]
[]
[null,"PFMEA Summary","Severity #","Occurrence #","Detection #","RPN #","PFMEA Background information"]
[null,"Before: ",null,null,null,{"$f":"C9*D9*E9","v":0}]
[null,"After:",null,null,null,{"$f":"C10*D10*E10","v":0}]
[null,"3 Legged 5 Why",null,"Picture and Description of Current State",null,"Containment /QA Alert/ Owner / Target Date",null,"Picture and Description of Corrected State"]
["SPECIFIC Leg #1 - Why did it occur in our process?\n","Problem Statement:  ",null,null,null," "]
[]
[null,"Why did it occur:  "]
[]
[null,"Why did it occur:",null,null,null,"Corrective Actions / Owner / Target Date"]
[]
[null,"Why did it occur:"]
[]
[null,"Why did it occur:"]
[]
[null,"Why did it occur:"]
[]
["DETECTION Leg #2 -Why did problem reach customer?\n","Why was it not detected:  ",null,null,null,"Corrective Actions / Owner / Target Date"]
[]
[null,"Why not detected:  "]
[]
[null,"Why not detected:  "]
[]
[null,"Why not detected:"]
[]
[null,"Why not detected:"]
[]
[null,"Why not detected:"]
[]
["SYSTEMIC  LEG #3 -Why did system allow problem to occur?\n","Why did the system allow the problem to occur (what was the weakness in the system):",null,null,null,"Corrective Actions / Owner / Target Date"]
[]
[null,"Why:"]
[]
[null,"Why:"]
[]
[null,"Why:"]
[]
[null,"Why:"]
[]
[null,"Why:"]
[]
[null,"OEM Customer Complaint Number (If applicable)",null,"Affected OEM Customer Locations:",null,"Supplier Name/Location:",null,"Nexteer and / or Supplier Contact Name:"]
[]
[null,"Supplier  Look Across #","Lessons Learned:"]
[null," "]

{"sheet":"1 Pg - Cheat Sheet","index":1,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Cheat Sheet Details","index":2,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Note:  The  items listed are \"general guidelines\" of items to look for.  They may, or, may not all apply for your particular situation."]
[]
["3L5Y:  Leg 1 - Specific Problem",null,null,null,null,null,null,null,null,"3L5Y:  Leg 2 - Detection",null,null,null,null,null,null,null,null,"3L5Y:  Leg 3 - Systemic"]
["Specific - Why did it occur in our process?",null,null,null,null,null,null,null,null,"Detection - Why did the problem reach the customer?",null,null,null,null,null,null,null,null,"Systemic - Why did our system allow it to occur?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Containment Worksheet","index":3,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[28,5,28,6],[28,7,28,8],[29,1,29,2],[29,3,29,4],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,7,43,8],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[41,1,41,2],[41,3,41,4],[41,5,41,6],[41,7,41,8],[42,1,42,2],[42,3,42,4],[42,5,42,6],[29,5,29,6],[29,7,29,8],[11,8,12,8],[54,3,54,8],[50,7,50,8],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[50,3,50,4],[50,5,50,6],[53,1,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[28,3,28,4],[51,1,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[52,1,52,2],[52,3,52,4],[52,5,52,6],[52,7,52,8],[45,5,45,6],[45,7,45,8],[45,1,45,2],[45,3,45,4],[50,1,50,2],[42,7,42,8],[38,1,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[40,1,40,2],[40,3,40,4],[40,5,40,6],[40,7,40,8],[39,1,39,2],[39,3,39,4],[39,5,39,6],[39,7,39,8],[16,2,16,5],[23,0,23,8],[24,0,24,8],[30,7,30,8],[37,1,37,2],[37,3,37,4],[37,5,37,6],[37,7,37,8],[34,1,34,2],[34,3,34,4],[34,5,34,6],[34,7,34,8],[35,1,35,2],[35,3,35,4],[35,5,35,6],[35,7,35,8],[36,1,36,2],[36,3,36,4],[36,5,36,6],[36,7,36,8],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[25,1,25,2],[25,3,25,4],[25,5,25,6],[25,7,25,8],[26,1,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[33,1,33,2],[33,3,33,4],[33,5,33,6],[33,7,33,8],[30,1,30,2],[30,3,30,4],[30,5,30,6],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[31,1,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[28,1,28,2],[5,2,5,8],[4,6,4,8],[4,1,4,5],[9,3,9,8],[10,4,10,8],[10,0,10,3],[3,0,3,8],[15,0,15,8],[11,0,12,0],[11,1,12,3],[13,1,13,3],[6,0,7,8],[11,4,12,7],[13,4,13,7],[14,4,14,7],[14,1,14,3]]}
["***Please Fill Out This Containment Worksheet, or, Attach a Contaiment Worksheet your plant would Normally use for Containment."]
["** Note:  If Containment was not needed for your 3L5Y, you do not have to fill out a containment form."]
[" ",null,null,null,"Nexteer Form #:   15-1-5-XXX",null,null,"Form Revision date:  September 20, 2017"]
[" CONTAINMENT WORKSHEET - NONCONFORMING PRODUCT "]
["Date:","Name Responsible  Person Containing:"]
["Location where Concern was Discovered:"]
["Defect Description (including part number/part description):"]
[]
["Sort Method / Sort Criteria: ","Hand Gage:",null,"CMM:",null,"Visual:","Mating Part:",null,"Other:"]
["ID (Marking) Method for sorted  conforming parts:",null,null," "]
["ID (Marking) Method for sorted \"BAD\" Non conforming parts:",null,null,null," "]
["Total Quantity Defective Parts found at:","(1). Parts @ OEM Customer = _____ parts",null,null,"(2). At Nexteer: (a). Nexteer Incoming  _____parts, (b). Partially Asm Nexteer_____parts,  (c ). Final Asm Nexteer_____parts",null,null,null,"(3). At Supplier _______parts"]
[]
["Total Qty  non-conforming  parts returned to supplier:",null,null,null,"Total Qty  non-conforming  parts scrapped at Nexteer:"]
["Total Qty of Good + Bad  parts returned to supplier",null,null,null,"Total Qty of Good + Bad  parts scrapped at Nexteer"]
["Breakpoints (when were first and last non-conforming part produced)?"]
["Total Qty Sorted:",null,"Engineering permit # (if necessary):",null,null,null,null,"Hold Tag #'s:"]
[]
["Notifications (Email or Other):"]
["Operators/ Team Leaders",null,null,"Production Mgr",null,null,null,"Supplier Quality "]
["Supervisor/Group Leader",null,null,"Operations Mgr",null,null,null,"PC&L"]
["Quality Engineer",null,null,"Metallurgist",null,null,null,"Customer Quality Contacts"]
["Purchased Parts Administration"]
[]
["PRODUCT CONTAINMENT:     IDENTIFY ALL AREAS WHERE SUSPECT PRODUCT COULD BE LOCATED"]
["LOCATION","POTENTIAL SUSPECT QTY.",null,"QUANTITY SORTED",null,"NON - CONFORMING\nQTY FOUND?",null,"Comments"]
["In Manufacturing Cell:"]
["In Process containers, loaders, trays"]
["In Shipping:"]
["In Receiving:"]
["Outside Processing (plating, etc)"]
["WIP Storage Area"]
["Laboratory"]
["Engineers Desks"]
["Scrap bins or Scrap areas"]
["Rework Areas"]
["Shipping Dock"]
["In Transit:"]
["At Heat Treater or Painter"]
["Induction Hardeners "]
["Staging Areas (Incoming / Outgoing)"]
["Service Parts Operations"]
["Repair or teardown area"]
["Pilot Build Areas"]
["Containment / Hold Areas "]
["Between Departments"]
["Between Plants"]
["At warehouse or Distrabution center"]
["At Service Parts"]
["At Suppliers or sequencers"]
["At Nexteer"]
["At OEM Customer"]
["GP-12 Area"]
["Teardown"]
["Update Documents:  ","Post Quality Alert",null,"Layered Process Audit Sheets necessary"]
["List other deparments or plants that are possibly at risk and include who was notified?"]
[]
[]
[]
["Signatures:   Originator",null,"Manufacturing Supervisor",null,null,null,"Quality Engineer"]

{"sheet":"Quality Alert","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["(1).  Quality Alert  -  Attach a copy of the Quality Alert you posted in your plant."]
["(2). Signatures:   Attach a copy of the Signatures of Employees who reviewed the quality alert.  Include all workers assembling the product.  This is to verify all workers and suppervisors on all shifts read and understand the quality alert."]

{"sheet":"Supporting Documents","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Supporting Documents - Attach your supporting documents - additional pictures, DOE components swaps, Error proofing added, ect."]

{"sheet":"3L5W Review Minutes","index":6,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[12,7,13,8],[2,5,5,6],[2,7,7,7],[7,0,7,1],[7,2,7,3],[9,0,9,7],[25,0,25,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[35,8,37,8],[35,9,37,9],[38,8,40,8],[38,9,40,9],[1,0,1,4],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[32,8,33,8],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1]]}
[]
["Optional Worksheet is for documenting 3L5W review meetings"]
[null,null,null,null,null,"Attendance:"]
[]
[]
[]
[]
["3L5W TO REVIEW:"]
[]
["NOTE: IF PSCC RELATED or REJECT QUANTITY EQUAL OR GREATER THAN 8, FINAL APPROVAL MUST COME FROM GLOBAL TEAM"]
[]
[]
[]
[]
["DATE OF REVIEW",null,"ACTION ITEM","ACTION OWNER","ACTION REQUESTER","DATE OPENED","TARGET CLOSE DATE","ACTION TAKEN","OVERALL\nSTATUS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Approved?"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Yes"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Final Approval date"]

{"sheet":"Detection","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,0,11,0],[9,1,11,1],[0,0,0,2],[0,3,0,4],[5,0,6,0],[5,1,6,1],[7,0,8,0],[7,1,8,1]]}
["SAE J1739 / AIAG 4th Edition",null,null,"DSS Control Strategy Levels"]
["Rank","Category\n(Process)","PFMEA Criteria:\n\nLikelihood of Detection by Process Control","Category\n(Process)\nRanking*","PFMEA Criteria (Breakdown)"]
[10,"Absolute Uncertainty","No current process control; Cannot detect or is not analyzed",10,"No current process control"]
[9,"Difficult to Detect","Defect (Failure Mode) and/or Error (Cause) is not easily detected (e.g. Random audits)",9,"Random audit performed"]
[8,"Defect Detection Post Processing","Defect (Failure Mode) detection post-processing by operator through visual/tactile/audible means.",8,"Visual/tactile/audible detection of defect (failure mode) later in process (downstream operation)"]
[7,"Defect Detection at Source","Defect (Failure Mode) detection in-station by operator through visual/tactile/audible means or","7b","Visual/tactile/audible detection of defect (failure mode) at operation"]
[null,null,"Defect (Failure Mode) detection post-processing through use of attribute gauging (go/no-go, manual torque check/clicker wrench, etc.)","7a","Attribute gauge detects defect (failure mode) later in process (downstream operation)"]
[6,"Defect Detection Post Processing","Defect (Failure Mode) detection post-processing by operator through use of variable gauging or","6b","Variable gauge detects defect (failure mode) later in process (downstream operation)"]
[null,null,"Defect (Failure Mode) detection in-station by operator through use of attribute gauging (go/no go, manual torque check/clicker wrench, etc.)","6a","Attribute gauge detects defect (failure mode) at operation"]
[5,"Defect Detection at Source","Gauging performed on setup and first-piece check (for set-up causes only)","5c","Gauging performed on setup & 1st piece check (set-up causes only)"]
[null,null,"Defect (Failure Mode) or Error (Cause) detection in-station by operator through use of variable gauging","5b","Variable gauge detects error (cause) or defect (failure mode) at operation"]
[null,null,"Defect (Failure Mode) or Error (Cause) detection by automated controls in-station that will detect discrepant part and notify operator (light, buzzer, etc.)","5a","Automated controls in-station detect discrepant part (defect/failure mode) and notify operator (light, buzzer, etc.)"]
[4,"Defect Detection Post Processing","Defect (Failure Mode) detection post-processing by automated controls that will detect discrepant part and lock part to prevent further processing.",4,"Automated controls detect discrepant part (defect/failure mode) and lock part to prevent further processing later in process (downstream operation) (Includes bar code or RFID defect pass/fail tracking)"]
[3,"Defect Detection at Source","Defect (Failure Mode) detection in-station by automated controls that will detect discrepant part and automatically lock part in station to prevent further processing.",3,"Automated controls detect discrepant part  (defect/failure mode) and lock part to prevent further processing at operation (Includes automatic movement of part from station to detection device)"]
[2,"Error Detection and/or Defect Prevention","Error (Cause) detection in-station by automated controls that will detect error and prevent discrepant part from being made",2,"Automated controls detect error (cause) and prevent discrepant part from being made at operation (process monitoring)"]
[1,"Detection not applicable; Error Prevention","Error (Cause) prevention as a result of fixture design, machine design or part design.",1,"Error (cause) prevention as a result of fixture design, machine design or part design"]
[null,null,null,"*See DSS Control Chart"]

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

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

{"sheet":"Product Severity Rank","index":10,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,2]]}
["Severity","Rank","Typical XXXXX Effects"]
["Hazardous "]
["Hazardous, without warning",10,"XXXXX"]
["Hazardous, with warning",9,"XXXXX"]
["Performance"]
["Very High",8,"XXXXX"]
["High",7,"XXXXX"]
["Moderate",6,"XXXXX"]
["Low",5,"XXXXX"]
["Annoyance"]
["Very Low\n(Noticeable by more than 75% of customers)",4,"Noise, cosmetic corrosion"]
["Minor\n(Noticeable by 50% of customers)",3,"Noise, cosmetic corrosion"]
["Very Minor\n(Noticeable by less than 25% of customers)",2,"Noise, cosmetic corrosion"]
["No Effect"]
["None",1,"No discernible effect on assembly or vehicle"]
[]
["Severity rankings are based on Nexteer Automotive Ranking Charts published in the G1346 FMEA Global Procedure."]

{"sheet":"Revision tracker","index":11,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Description of Changes made","Who Made Changes"]
["July 31, 2017","First Release of \"NEW\" 3l5Y training  - Rev. Date:  31 July, 2017:  F1043 & G1738 combined. ","David Berg & Dan Ancel"]
["August 11, 2017","Updates made per ideas and recommendations from 3L5Y training feedback","David Berg  "]
["August 14, 2017","Updates made per ideas from August 11 meeting with Frederique Mira and Troy Daenzer.","David Berg"]
["August 16, 2017","Meeting with Frederique - made several updates to pop up boxes and verbage on 3L5Y form","David Berg"]
["August 21, 2017","Updates added that were suggested by Dan Ancel, Emily Fitzko, and Frederique Mira .  Also updated \"pop up\" boxes with better descriptions.","David Berg"]
["August 22, 2017","Updates from August 22 meeting with Frederique, Linda Haskins, Dan Ancel, Troy Denzer, and Emily Fitzko, David Berg","David Berg"]
["August 28, 2017","Minor verbage updates made to drop downs, and new 3L5Y Form number added ending in XXX (needs release)","David Berg"]
["August 30, 2017","Removed the CN# and follow-up Corrective Action boxes.  Troy Daenzer will add follow-up corrective actions to eQMS.","David Berg"]
["September 20, 2017","Removed the suggestions from people.  Greyed in the OEM customer information for Nexteer use.","David Berg"]
["October 6, 2017","Added the Form number 15-1-5-6F1 to the 3L5Y","David Berg"]