{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Blank Master","Severity","Occurrence","Detection","Product Severity Rank","Revision tracker"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":14,"comments":1,"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":"Blank Master","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[47,0,63,0],[48,7,48,9],[50,1,52,1],[5,9,6,9],[5,8,6,8],[23,7,34,9],[11,5,11,6],[15,5,15,6],[35,1,36,2],[12,5,14,6],[49,1,49,9],[35,0,46,0],[23,3,34,4],[35,3,46,4],[47,7,47,9],[47,5,47,6],[3,0,10,0],[27,1,28,2],[29,1,30,2],[8,1,9,1],[11,0,22,0],[23,0,34,0],[5,2,6,2],[11,3,22,4],[17,1,18,2],[11,1,12,2],[13,1,14,2],[10,3,10,4],[10,1,10,2],[5,3,6,7],[15,1,16,2],[19,1,20,2],[37,1,38,2],[39,1,40,2],[16,5,22,6],[31,1,32,2],[33,1,34,2],[23,1,24,2],[25,1,26,2],[21,1,22,2],[10,7,10,9],[11,7,22,9],[10,5,10,6],[7,7,7,9],[8,7,9,9],[1,1,2,9],[53,1,63,2],[23,5,23,6],[24,5,34,6],[35,5,35,6],[36,5,46,6],[48,1,48,2],[48,3,48,4],[47,1,47,2],[45,1,46,2],[50,2,52,9],[48,5,48,6],[47,3,47,4],[35,7,46,9],[41,1,42,2],[43,1,44,2]]}
[null,"F1043            "," Supplier Note: White areas must be completed/ Green area must not be modified/Gray areas are not required of suppliers"]
[null,"Within each Leg, you can develop as many legs as necessary (for instance in Nexteer, at supplier etc). If it is too complex, you may want to develop a 3L5Y for each area (Nexteer Internal/ Supplier/ Sub-tier Supplier)"]
[]
[null,"Nexteer Plant","Part Number","Product/Process Name","Date of Occurrence","Look Across #","Type of Look Across (Customer Complaint or PSCC):","OEM Customer","Plant Tracking\n number","Date 3L5Y Written"]
[null,null,null,null,null,null," "]
[null,"Intelex # / RMA #","Problem Definition: ",null,null,null,null,null,"Qty of pcs reported by Nexteer "]
[]
[null,"CN #, if applicable","PFMEA Summary","Severity #","Occurrence #","Detection #","RPN #","PFMEA Background information"]
[null,null,"Before: ",null,null,null,{"$f":"D9*E9*F9","v":0}]
[null,null,"After:",null,null,null,{"$f":"D10*E10*F10","v":0}]
[null,"3 Legged 5 Why",null,"Picture/Description of Current State",null,"Corrective Actions / Owner / Target Date",null,"Picture/Description of Corrected State"]
["nonconformance being Investigated","Problem Statement:  ",null,null,null,"Containment Actions/ Owner / Target Date"]
[]
[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:"]
[]
["Why not detected","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 root cause","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 Known",null,"Affected OEM Customer Locations:",null,"Supplier Name/Location:",null,"Nexteer Contact Name:"]
[]
[null,"Results of Verification of Corrective Action Measures:           Implemented                                     Not implemented                                          Follow-up required?   Yes    No            Verified by:"]
[null,"Lessons Learned:"]
[]
[]
[null,"Look Across Requirements:",null,null,"All Hydraulic Plants","     All EPS Plants","     All Column Plants","All H/S Plants"]
[null,null,null,"Within Plant","Plant 3","     Plant 65  Mexico","     Plant 6","Plant 4","                               Purchasing"]
[null,null,null,null,"Plant 7","     Plant 66 Mexico","     Plant 66","Plant 5","                                                 BOP - Nexteer Hdqtrs M.E."]
[null,null,null,null,"Plant 81 India","     Plant 51 China","     Plant 68","Plant 52 China","                                               BOD - Nexteer Prod. Eng"]
[null,null,null,null,"Plant 72 Australia","     Plant 53 China","     Plant 79 Gliwice Poland","Plant 54 China","                                         Prototype Operations"]
[null,null,null,null,"Plant 51 China","     Plant 56 China","     Plant 89 Brazil","Plant 66 Mexico","  "]
[null,null,null,null,"Plant 79 Gliwice Poland","     Plant 57 China","     Plant 81 India","Plant 81 India"]
[null,null,null,null,"Plant 89 Brazil","     Plant 58 China","     Plant 53 China","Plant 89 Brazil"]
[null,null,null,null,"      EPS Plants","     Plt 77 Tychy Poland","     Plant 72 Australia"]
[null,null,null,null," Plant 1","     Plt 79 Gliwice Poland"]
[null,null,null," "," Plant 3","     Plant 89 Brazil"]

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

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

{"sheet":"Detection","index":3,"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":"Product Severity Rank","index":4,"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":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}