{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["APQP Guide ","APQP Tracking sheet","Ranking","PND Guide","ActionPlan","Historie"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":5,"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":"APQP Guide ","index":0,"n_rows":167,"n_cols":10,"rows_kept":167,"cut":false,"hidden":false,"merged":[[144,0,144,10],[145,0,145,10],[146,0,146,10],[161,0,161,10],[164,0,164,10],[139,0,139,10],[140,0,140,10],[141,0,141,10],[142,0,142,10],[143,0,143,10],[129,0,129,10],[130,0,130,10],[137,0,137,10],[138,0,138,10],[128,0,128,10],[104,0,104,10],[105,1,105,10],[125,0,125,10],[126,0,126,10],[127,0,127,10],[92,0,93,10],[94,0,94,10],[47,0,47,10],[95,0,95,10],[48,0,48,10],[49,0,49,10],[50,0,50,10],[51,0,51,10],[45,0,45,10],[46,0,46,10],[87,0,90,10],[42,0,42,10],[43,0,43,10],[44,0,44,10],[20,0,21,0],[20,1,20,2],[21,1,21,10],[34,0,34,10],[22,0,23,0],[23,1,23,10],[25,0,25,10],[26,0,26,10],[27,0,27,10],[28,0,28,10],[29,0,29,10],[30,0,30,10],[31,0,31,10],[32,0,32,10],[33,0,33,10],[0,0,0,10],[1,0,3,10],[6,0,9,10],[11,0,12,10],[13,0,13,10],[14,0,14,10],[16,0,17,0],[17,1,17,10],[18,0,19,0],[19,1,19,10],[18,1,18,4]]}
["     Supplier APQP Tracker Template"]
["Guidelines"]
[]
[]
["TEN Document n°",null,null,"P06_35_7.2","Revision:",{"$f":"Historie!G5","v":"8a"},"Revision date:",{"$f":"Historie!L5","v":"2021-10-28"},null,{"$f":"Historie!O5","v":"Purchasing"}]
["Purpose :"]
["The Supplier APQP tracker Template summarizes the component status and provides an assessment at a Milestone level. Suppliers should provide APQP status reports for a new product to meet the program quality, cost, performance and timing objectives. Similar components can be reported as a group if agreed by the Tenneco Application buyer and/or SDE/SQE assigned."]
[]
[]
[]
[]
["All Suppliers will use this form for Program tracking in alignment with the TITAN c-folders.  The APQP Tracker Template should be uploaded into the TITAN C-folder by the Supplier.  This APQP Tracking Sheet can be found in the Supplier Quality Manual.  "]
[]
["Supplier APQP Process"]
["The Tenneco Supplier APQP process is using 4 Project-Phases. By selecting the project phase, the sheet will highlight Milestones and/or Elements which needs to be completed within this project phase.  The supplier should rate only the elements which are highlighted in bold."]
[]
["Phase 1","Supplier Kick-Off"]
[null,"The Kick-Off Phase starts after the supplier has been awarded the business. Tenneco and the Supplier define the Key Milestones, Project Timing and establish the deliverables and expectations from the supplier for the component and program. In the event \"Design Validation Plan (DVP)\" is submitted by the supplier and signature approved by Tenneco Engineering. The signed DVP must be uploaded into Titan."]
["Phase 2","Product/Process Development"]
[null,"Supplier completes designs for his tooling, assembly lines/cells, gauging required to manufacture the component/material. The supplier shall collect data to assure that the manufactured items meet drawing, specification and capacity requirements.This phase ends with the approval of the tooling, assembly equipment and gauging at the supplier’s facility."]
["Phase 3","Pre-PPAP"]
[null,"In this phase the supplier is doing a serial production trial run using production tooling, assembly equipment and gauging. The important activity during this phase is the first part inspection by the supplier, and subsequent tuning of the process to produce components that conform to the drawings and specification.This Phase ends with the completion of the PPAP production run."]
["Phase 4","Product/Process Validation & Launch"]
[null,"This is the last phase of APQP. During this phase the supplier has to complete and submit a Production Product Approval Process (PPAP) package to the Tenneco approval plant. By end of this Phase all additional project Milestones need to be completed. The suppliers should have records to demonstrate the successful completion of the APQP process (Lessons Learned).  "]
[]
["Program - Timing"]
["Program Need Date"]
["The Program Need Dates for each Project Milestone needs to be established by the Supplier at the beginning of the program. It shows the date by which the Milestone must be completed to support the whole project timing. These dates can be modified with approval by Tenneco to ensure that any impact on the critical path of the program is understood and controlled.  "]
["Supplier Timing Date"]
["The Supplier Timing Date is the commitment date established by the supplier in order to support the project timing. The Supplier Timing Date is determined by your organization’s internal APQP process and resources. Any Supplier Timing Date that exceed the Program Needs Date shall be addressed with the Tenneco Team and supported with an action plan."]
["Program - Rating and Assessment"]
["The Rating is based on a \"green - yellow - red\" status towards the successful completion of the APQP Milestone"]
["The \"G-Y-R\" status of the overall rating shows the status of the program in terms of quality and timing. "]
[]
["Definitions/Risk factors for \"Green - Yellow - Red\" are listed in the table below"]
[]
[]
[]
[]
[]
[]
[]
["Milestones  - Rating and Assessment"]
["To indicate the actual status for each Milestone towards the Program Need date, the \"G-Y-R\" rating as per Ranking sheet needs to be used. "]
["Program Need Date is the last possible date a Milestone needs to be completed without negative impact to quality or timing of the program. "]
["Additional Milestones need to be tracked and reported as requested by Tenneco. In doubt, please ask the Tenneco Application buyer and/or the assigned SDE/SQE."]
["Reporting frequency / Status update"]
["The Supplier will upload the  APQP Tracker Template into c-folder of TITAN and send a copy to the dedicated Tenneco Program buyer, assigned SDS and to the Plant SQE. The reporting frequency should be as follows:"]
["• Immediately, if project timing and/or deliverables are in danger (APQP Risk is red)\n• Monthly for all tooling with Lead time ≥ 4 weeks\n• Weekly for all tooling with Lead time < 4 weeks (or if APQP risk is yellow)\n• Weekly, if program timing is ≤ 4 weeks prior PPAP\n"]
["Frequency can be adjusted depending on direction from Program Buyer and/or SDS/SQE request."]
["How to name  the APQP Tracking Status File"]
["Saved as an exel-file using the Part Number-Program Name in File name."]
[]
["See below details on how to use this file."]
[]
["\"APQP Tracking Sheet\" Tab"]
["1) Click on     ",null,null,"to initiate this form - displays the screen below"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Project Category"]
["\"New Technology\" choose this icon if the Supplier is \"design responsible\" or a portion of within the development."]
["\"Early Supplier Involvement\" choose this icon if Supplier is involved in the design verification with Tenneco."]
["\"Build to print\" choose this icon if Supplier is not involved in the design phase and will build to print supplied."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The Program Need Date (PND) is transferred from the PND Worksheet, but the \"Date Committed\" is manually entered.  This date is a date the Supplier commits to the deliverable - this date must be the same or prior to the PND date."]
[]
[]
[]
[]
[]
[]
[]
[]
["\"Ranking\" Tab automatically displays when milestone step is clicked on."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Once the first two milestones are completed then you are able to initiate the next APQP Phase."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The above steps repeat until all 4 Phases and the associated milestones are completed.   "]
[]
["The APQP Tracking Sheet Tab which is linked to the \"Ranking Tab\" must be completed."]
["The \"Action Plan\" Tab must be used to track any actions that are required to keep program on track"]
["The \"PND Guide\" Tab (Program Need Date Guide) is optional if your company has an established tool to develop program timing/APQP tool.  If the PND Guide is used then the dates for Need Date will be pulled from this tab.  If this tab is not used then the Need date will be pulled from the Supplier's APQP program timing."]
[]
["\"PND GUIDE\" TAB (PROGRAM NEED DATE GUIDE)"]
["The PND Guide starts at the PPAP required date and the Supplier adds in the number of days  required for each task"]
["This form will calulate the Need date for each milestone to ensure on time PPAP."]
["The need dates will automatically transfer over to the APQP "]

{"sheet":"APQP Tracking sheet","index":1,"n_rows":90,"n_cols":12,"rows_kept":90,"cut":false,"hidden":false,"merged":[[13,8,13,11],[20,7,21,7],[16,2,16,4],[16,6,16,7],[18,9,18,11],[21,10,21,11],[21,2,21,3],[3,7,3,11],[2,7,2,11],[25,1,25,2],[26,1,26,2],[11,6,11,7],[7,1,7,3],[14,2,14,4],[14,6,14,7],[15,6,15,7],[15,2,15,4],[17,1,17,11],[19,10,19,11],[20,2,20,3],[20,10,20,11],[22,1,22,11],[12,1,12,2],[0,0,0,12],[14,8,16,11],[10,8,11,11],[9,2,9,7],[10,6,10,7],[1,1,1,11],[8,7,8,11],[13,6,13,7],[2,2,2,5],[12,8,12,11],[10,2,10,4],[3,2,3,5],[4,2,4,5],[5,2,5,5],[5,7,5,11],[13,2,13,4],[4,7,4,11],[9,8,9,11],[11,2,11,4],[46,3,46,11],[45,1,45,2],[41,1,41,2],[44,1,44,11],[45,3,45,8],[46,1,46,2],[42,1,42,2],[43,1,43,11],[45,10,45,11],[29,1,29,2],[23,8,23,11],[18,1,18,7],[40,1,40,2],[39,1,39,2],[30,1,30,2],[33,1,33,2],[34,1,34,2],[38,1,38,7],[37,1,37,2],[36,1,36,2],[35,1,35,2],[24,1,24,2],[23,1,23,7],[19,2,19,3],[31,1,31,2],[32,1,32,2],[27,1,27,2],[28,1,28,2]]}
[]
[null," Supplier APQP Tracking Sheet                           P06_35_7_6Rev8.xlsm"]
[null,"PPAP Req No.",null,null,null,null,"Program/Project"]
[null,"Part No.:",null,null,null,null,"Part Name:"]
[null,"Drawing No.:",null,null,null,null,"User Plant:"]
[null,"Rev Level: ",null,null,null,null,"Risk level"]
[]
[null,"TEN Document n°",null,null,"P06_35_7.2","Revision",{"$f":"Historie!G5","v":"8a"},"Revision date",null,{"$f":"Historie!L5","v":"2021-10-28"},null,{"$f":"Historie!O5","v":"Purchasing"}]
[null,"Supplier Information"]
[null,"Name:",null,null,null,null,null,null,"APQP Phase"]
[null,"Contact Name",null,null,null,"phone",null,null,"Supplier Kick-Off"]
[null,"e-mail",null,null,null,"fax"]
[null,"Tenneco Contact Information",null,null,null,null,null,null,"APQP Overall Status"]
[null,"Application Buyer",null,null,null,"phone",null,null,"(To override automatic ranking double click cell below)"]
[null,"e-mail",null,null,null,"fax"]
[null,"TEN SQE",null,null,null,"phone"]
[null,"e-mail",null,null,null,"fax"]
[]
[null,"                                 \"Project Timing Infomation\"",null,null,null,null,null,null,null,"PPAP Requirements"]
[null,null,"Prototype parts",null,"Off Tool parts","Off Process parts","PPAP","SOP (pick up date)",null,"PPAP \"TYP\"","AIAG"]
[null,"Quantity",null,null,null,null,null,null,null,"PPAP Level",3]
[null,"Due date",null,null,null,null,null,null,null,"PPAP Ship to:"]
[]
[null,"                                                  Provide \"Supplier APQP Plan Dates\" →"]
[null,"APQP Milestones Status \nGYR - Status",null,null,"Step 1","Step 2","Step 3","Step 4",null,"Program Need Date","Date Commited","Close Date"]
[null,"(0) Design & Development",null,null,"Statement of Work (SOW) Reviewed","Statement of Requirements(SOR) Reviewed","Design Established","Product Assurance plan established"]
[null,"(1) Design Verification & Validation / Product & Process Design & Development",null,null,"Product Validation","Design and Specifications Confirmed","PV Prototype Tooling, Build and Validation","Product & Process Validated"]
[null,"(2) Drawing / Spec Information Available",null,null,"Drwg/Specs Recv'd","Manufacturing Feasibility Completed","Manufacturing Feasibility Confirmed","Project Timing reviewed & Confirmed "]
[null,"(3) Manufacturing Process Mapping",null,null,"Initial Flow Available","Equipment and /or Facilities requirements","Operators Identified","Flow Chart Complete"]
[null,"(4) Sub Contractor APQP/PPAP",null,null,"Sub Contractor selected","Timeline established","Sub Contractor APQP status","Component PPAP approved"]
[null,"(5) Process FMEA Progress",null,null,"Initial FMEA Available","High RPNs Identified","High RPNs Action Taken","Final FMEA Complete"]
[null,"(6) Production Control Plan Progress",null,null,"Initial Control Plan Available","Ties to PFMEA","Supports High RPN Action","Final Control Plan Complete"]
[null,"(7) Tooling & Gauge Progress",null,null,"Tools/Gauges Identified","Tools/Gauges Ordered","Tools/Gauges Received","Tools/Gauges Inspection Accepted"]
[null,"(8) Measurement System Evaluation Progress",null,null,"Control Plan / PFMEA Gauge link","MSA Plan Identified","Gauge R&R Acceptable","MSA Complete"]
[null,"(9) Operator Process Instruction Progress",null,null,"Aligned with  Process Flow","Aligned with Control Plan","Operators Trained","Training Plan Complete"]
[null,"(A6) Off-Tool Parts Progress",null,null,"Tool Inspected upon Receipt","Sufficient Material Available","Tool Capability Analyzed","Off-Tool parts Inspection Accepted"]
[null,"(10) Significant Production Run",null,null,"Mat'l Available for Trial","Aligned with Process Flow","Process Capability Analyzed","Part Inspection Accepted"]
[null,"(11) PPAP Submission",null,null,"All Requirements Identified","Production Timeline Finalized","PPAP Submitted to Plant","PPAP \"Warrant\" Approved"]
[null,"Additional Milestones"]
[null,"(A1)  Launch Containment",null,null,"Launch Containment criteria identified","Instructions established","Launch Containment organized","Launch Containment implemented"]
[null,"(A5) Packaging Plan Proposal - Approval",null,null,"Packing Plan Proposed","Packaging Mat'l Available","Packaging Trial Completed","Packaging Plan Approved"]
[null,"(A2) Run@Rate Data Submission",null,null,"Capacity requirements identified","Run@Rate defined","Run @ Rate Detail Provided","Run at Rate Approved"]
[null,"(A11) Customer specifics requirements",null,null,"Customer specific requirements reviewed","CQI-x documentation available and uploaded","Bill of Material available and uploaded","Documents final reviewed and uploaded"]
[]
[]
[null,"Supplier Submitted by : ",null,null,null,null,null,null,null,"Date:"]
[null,"Supplier Comments: "]
[null,null,null,null,null,null,null,"file: P06_35_7_2.xls"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2013-11-05T21:11:49"]
[]
[]
[]
[]
[null,1]

{"sheet":"Ranking","index":2,"n_rows":212,"n_cols":6,"rows_kept":212,"cut":false,"hidden":false,"merged":[[0,0,0,12],[142,2,142,3]]}
[]
["TENNECO APQP Milestone Evaluation Checklist"]
["No.",null,"Question","Questions to ask and what to look for","Comments","Status"]
["(0) Design & Development "]
["0.1","Statement of Work (SOW) Reviewed","Has the SOW been reviewed with Tenneco and are expectations and deliverables clearly defined and in-line with the supplier capabilities ?","Per SOW; Tenneco Sourcing Team"]
["0.2","Statement of Requirements(SOR) Reviewed","Has the supplier completed the NT Supplier Feasibility Assessment, been assessed, actions are either closed or underway to completion? SOR been reviewed with Tenneco and are expectations clearly defined and in-line with the supplier capabilities ? ","Per SOR                                                                                                                                                                           NT Supplier Feasibility Assessment Score, NTI Process Deliverable 6.2.2"]
["0.3","Statement of Requirements(SOR) Reviewed","Has the supplier provided their DVP per SOR? DV and PV plan with timing established.","The Supplier DVP Template, NTI Process Deliverable6.4.2"]
["0.4","Design & Development","Design FMEA established ?","- Design Goals clearly defined ?\n- Preliminary feasibility protocol ?\n- Has a multiple functional team approach been used to confirm the requirements\n- Are historical warranty issues and quality information on similar products investigated ?\n- Similar designs already industrialized ?"]
["0.5","Design & Development","Engineering design release drawings (including Math Data)."]
["0.6","Design & Development","Confirmation of Design Release from Tenneco"]
["0.7","Design & Development","Has there been a Team Feasibility Commitment Review?","Tenneco Sourcing Team"]
["0.8","Design & Development","Has there been a Design for Manufacturability and Assembly Review? Does the supplier have a process in place to manufacture and or assembly component / assembly?","- NT Supplier Feasibility Assessment                                                                                                                -Supplier DVP"]
["0.9","Design & Development","Has a software / Circuit schematic review been complete?","Tenneco \"Controls\" Engineering Team"]
["0.10","Design & Development","Has DV level prototypes tooling PO been placed, confirm timing.","Tenneco Sourcing Team"]
["0.11","Design & Development","Prototype and/or Pre-Launch Control Plan (including Error-Proofing) and results available? What level B or C?","Tenneco SQE"]
["0.12","Design Established","Are DVP&R (Design Verification )Test results signed off by engineering ","DV Test reports"]
["0.13","Design Established","Has PV Design been released and provided to supplier?","Tenneco Engineering"]
["0.14","Design Established","Has tooling for PV serial production PO been placed?","Tenneco Advance Sourcing"]
["0.15","Product Assurance plan established","Preliminary drawings and specifications created?","Team sign off"]
["0.16","Customer Directed Supplier","Is this a customer directed / nominated supplier? If so, are there any Pass Through Characteristics?","- Include customer in print review\n- define inspection criteria"]
[]
["(1) Design Verification & Validation / Process Design & Development"]
["1.1","Product Validation","Has there been FMEA walk (from dFMEA)? And Special Process Characteristics been identified? ","- D-FMEA\n- Drawing & Specifications\n- Reliability and Quality goals established"]
["1.2","Product Validation","Are PV Test results signed off by engineering; From supplier's production intent process? ","DVP Results"]
["1.3","Design and Specifications Confirmed","Preliminary drawings and specifications confirmed?","Team sign off"]
["1.4","PV Prototype Tooling, Build and Validation","Has Prototype Tooling proved and validated","Print review, process capability review"]
["1.5","Product & Process Validation","Has there been a ProtoType Control Plan review?","Tenneco SQE                                                                                                                                         Prototype Control Plan / pFMEA 3 in 1; NTI Deliverable Process; 6.3.2"]
["1.6","Product & Process Validation","Has there been a preliminary pFMEA review: Poka - yoke and RPN reduction review (1st review) & Preliminary Process Flow been reviewed","Tenneco SQE                                                                                                                                         Prototype Control Plan / pFMEA 3 in 1; NTI Deliverable Process; 6.3.2"]
["1.7","Product & Process Validation","Process preliminary Capability Analysis Plan been identified from prototypes?"]
["1.8","Product & Process Validated","Has MSA evaluation been established & gauges / Testing equipment been identified, Preliminary Inspection \"Product Assurance\" Plan established & sign off","Production run / process review, MSA…Type 1 Gauge Study \nGR&R (Attribute / Variable)\nDefine master part \npictorial of how the part is measured after a successful GR & R\nDimensional verification"]
["1.9","Product & Process Validation","Preliminary Bill of Material established"]
[]
["(2) Drawing / Spec Information Available"]
["2.1","Drwg/Specs Recv'd","Does the supplier have all engineering documents to the latest official released status? (Including latest quality standards, welding specifications,)","* Drawings, CAD Data, Math Models, etc.\n* Specifications / contamination / appearance\n* BOM"]
["2.2","Drwg/Specs Recv'd","Are functional requirements from the SOR noted on drawing?","Per SOR"]
["2.3","Drwg/Specs Recv'd","Has there been an engineering Change request from supplier? In case of mass production tooling/process change, the actual tooling/process check must be conducted based on the change need date. Has inventory been considered to understand the clean date?","Is there a ECM?  Is there a drawing change?"]
["2.4","Drwg/Specs Recv'd","Is the drawing clear with applicable size definitions with respect to burrs, cleanliness, surface, color, prevention of mix parts?","specifications, SOR, Industry standards"]
["2.5","Manufacturing Feasibility Completed","Are all dimensions and tolerances understood on the drawing ?","* Significant characteristics\n* GD&T understood"]
["2.6","Manufacturing Feasibility Completed","Are all dimensions and tolerances manufacturable and measurable ?","* Process capability / inspection concept\n'* MSA / gage R&R / Attribute gage R&R\n* Visual aids\n* agreed measuring protocol with Tenneco"]
["2.7","Manufacturing Feasibility Confirmed","Can the supplier comply to all items indicated on the material  specification?","* Is material properly specified for the component application and function? \n* Is the material as specified properly suitable for the supplier's process ?"]
["2.8","Manufacturing Feasibility Confirmed","Can the supplier confirm all drawing notes, engineering specifications ?","* Relevant norms are known and available at the Supplier\n* Feasibility confirmation available "]
["2.9","Project Timing reviewed & Confirmed ","Can the supplier meet required Milestone dates ?","* Feasibility Review status (Red, Yellow, Green)\n* Gantt Chart provided?"]
["2.10","Project Timing reviewed & Confirmed ","Are there any known engineering changes pending and do they impact timing ?"]
[2.11,"CANA ONLY - Packaging Proposal Reviewed and Approved","Packing Plan Proposal Form is completed?\nUnderstand the Labeling requirements per Supplier Manual?\nReturnable container management plan, if required?\nHas Tenneco approved the packaging plan?","Review Packaging Proposal Form? (per Supplier manual Link Sheet Section 6 & 7)\nReview Container Management Plan.\n"]
["(3) Manufacturing Process Flow Chart Progress"]
["3.1","Initial Flow Available","Is there a Flow Chart available?","* Prototype process, pre-production. production"]
["3.2","Initial Flow Available","Does the supplier understand the impact of the component on the TENNECO manufacturing process ?","* design of welding fixture\n* design & position of clamps\n* compatibility of component with TEN process aids\n* function of the part"]
["3.3","Equipment and /or Facilities requirements","Is equipment status specified ?","* Is machine(s) available and defined. "]
["3.4","Equipment and /or Facilities requirements","Does the process flow demonstrate adequate Tooling/equipment  capacity to meet the quantities needed ?","* Tooling capacity vs estimated volume\n* Volume Ramp-up plan\n* Carry over tooling / machines"]
["3.5","Operators Identified","Are required operator's defined and skill matrix reviewed ?","* Training Matrix\n* Training Records\n* New employee orientation training\n* Adequate manning and personnel allocation"]
["3.6","Flow Chart Complete","Is Production Flow Chart available?","* Does Process Flow Chart meet AIAG standards?\n* Does the Process Flow document identify all steps of the process?"]
[]
["(4) Sub contractor APQP/PPAP"]
["4.1","Sub Contractor selected","Are  the purchased component suppliers identified ?","* Sourcing matrix (BOM)\n* Approved supplier list"]
["4.2","Sub Contractor selected","Are all components for the project key milestones and requirements defined and confirmed by the supplier ?","* Project time plan\n* Capacity confirmation"]
["4.3","Timeline established","Feasibility , Timings and Capacity #confirmed by the suppliers ?\n","* Feasibility documents\n* Supplier nomination"]
["4.4","Sub Contractor APQP status","Is there a status review established with the supplier ?","* APQP timing and status reports\n* Visit reports\n* Escalation process"]
["4.5","Sub Contractor APQP status","Are there any components with RED APQP status ? ","* APQP reports\n* Escalation process"]
["4.6","Component PPAP approved","Are all component PPAPs approved?","* IMDS data submitted\n* Process capabilities verified for SC's & CC's\n* Supplier/Subcontractor PPAP review"]
[4.7,"Sub Contractor - Special Processes","If required - Are special processes identified and validated at the sub-contractor (CQI's) \n- CQI-9 Special Process: Heat Treat System Assessment\n- CQI-11 Special Process: Plating System Assessment\n- CQI-27 Special Process: Casting System Assessment\n- Ford Specific - Machining Special Assessment\n- CQI-12 Special Process: Coating System Assessment\n- CQI-15 Special Process: Welding System Assessment\n- CQI-17 Special Process: Soldering System Assessment\n\n","* CQI reviewed for special process - completed on annual basis\n* Ford requirement - Machining special process- completed on annual basis\n* Latest CQI included A10 TITAN C-folder (Supplier/Subcontactor PPAP info)"]
["(5) Process FMEA Progress"]
["5.1","Initial FMEA Available","Is there a PFMEA available?","* Prototype process, pre-production. production"]
["5.2","Initial FMEA Available","Is the FMEA team cross-functional compiled?"]
["5.3","High RPNs Identified","Does your Severity ranking coincide with DFMEA ?","* Have the RPNs been formulated per AIAG guideline?\n* Does the occurrence and Detection reflect the production process?"]
["5.4","High RPNs Identified","Steps in process flow are linked to PFMEA?","*Review process flow vs. PFMEA"]
["5.5","High RPNs Identified","Are the occurrences and Detections defined ?","* Have the RPNs been formulated per AIAG guideline?\n* Does the occurrence and Detection reflect the production process?"]
["5.6","High RPNs Action Taken","Have recommended actions been documented on the PFMEA ?","* PFMEA review"]
["5.7","High RPNs Action Taken","Are actions in progress and/or documented ?","*  Action log… are high rankings documented at tie back to pFMEA                                                                                                                         • PFMEA review."]
["5.8","Final FMEA Complete"," Is the Final PFMEA available ?","* Are all known failures been identified?\n* Was a multi functional team utilize to identify potential failures?\n* Does the PFMEA link to the Process Flow Diagram and Control Plan?\n* Have poke-yokes been developed and identified?"]
["5.9","Final FMEA Complete","Are severity >8 have mistake proofing in place or engineering sign off in writing","*Evidence shown on every item shown on PFMEA"]
["5.10","Final FMEA Complete","Was the dFMEA considered when this pFMEA was created?","dFMEA to pFMEA linkage based on Severities, Occurances and Detections."]
["5.11","Significant and Critical Characteristics identified","• Supplier to post Quality Awareness\" at significant characteristics (Severity of 5-8 AND Occurrence of 4-10  and critical characteristic (Severity of 9,10) process area. If applicable\n\n","See notes from lessons learn, previous quality issues (if applicable)                                                                                                           Appropriate correction action applied for high RPN, CC & SCs                   applicable if eMRR / CS1"]
["5.12","Pass Through Characteristics","Are PTC included in the pFMEA? Has all Pass Through Characteristics (PTC) being identified?, ie; studs, chemistry, threaded holes, potential special characteristics, torque values, …","*Evidence shown on every item shown on PFMEA"]
[]
["(6) Production Control Plan Progress"]
["6.1","Initial Control Plan Available","Is there a control plan developed according to the AIAG methodology ?","* Prototype process, pre-production. production"]
["6.2","Initial Control Plan Available","Are all special product and process characteristics included in the control plan and are they properly controlled? ?","* Drawing review protocol\n* PFMEA review"]
["6.3","Launch Containment","Has the APQP team reviewed the drawing for risk and identified features that should be included within the supplier's launch containment","APQP drawing review with Tenneco Supplier Quality, Supplier, Plant Quality and the Tenneco Engineering."]
["6.4","Ties to PFMEA","Is the Control Plan linked to the Process flow diagram and P-FMEA ?","* document review"]
["6.5","Ties to PFMEA","Is the Control plan linked with similar Products / Processes?"]
["6.6","Supports High RPN Action","Is mistake proofing / fail-safe considered in the tooling and equipment design","* upper/lower tool half\n* Tooling\n* 100% automatic inspections"]
["6.7","Final Control Plan Complete","Have all the controls identified in the PFMEA being included in the control plan ?","* Alignment of RPNs between dFMEA and pFMEA\n* Severity greater than 8 , poka-yoke required or sign off by engineering"]
["6.8","Final Control Plan Complete","Assure Poka Yokes are in place to prevent mixing similar parts…. Left . Right? ","Review boundary parts to clarify similarities.                                         Is there a check fixture?"]
["6.9","Final Control Plan Complete","Does the supplier understand the impact of the component on the TENNECO manufacturing process?"]
["6.10","Final Control Plan Complete","Were any non conformities identified during a prototype process or with similar parts considered to finalize the control plan ?","* lessons learned out of prototype, preproduction build phase, customer complain"]
["6.11","Final Control Plan Complete","Is the rework process documented in the Control Plan?  ","If potential rework to be done review the rework process and ensure documented in Control Plan.\nAre there good controls in place?  Are reworked parts identified?"]
["6.12","Final Control Plan Complete","Is the annual layout requirements listed on the Control Plan?"]
["6.13","Pass Through Characteristics","Are PTC included in the pFMEA & Control Plan?","*Evidence shown on every item shown on Process Flow & PFMEA"]
["(7) Tooling & Gauges Progress"]
["7.1","Tools/Gauges Identified","Have tooling/Gauging requirement analysis and design been completed?","Design Reviews and tooling/Gauging needs analysis "]
["7.2","Tools/Gauges Identified","Are there any known engineering changes pending and do they impact timing ?"]
["7.3","Tools/Gauges Identified","Are new tools necessary?"]
["7.4","Tools/Gauges Identified","Are new gauges necessary?"]
["7.5","Tools/Gauges Identified","Did supplier receive a purchase order form Tenneco?"]
["7.6","Tools/Gauges Identified","Does the Supplier have a detailed schedule that shows timing for all tooling, equipment, and gauges ?","* Project Management plan"]
["7.7","Tools/Gauges Identified","Does the tool / gauge concept timing meet the project timing?","* Customer Need Dates available\n* Volume Ramp-up plan"]
["7.8","Tools/Gauges Identified","Does the tool concept meet product requirements?"]
["7.9","Tools/Gauges Identified","Is the checking gauge matching  the control plan?","Dimensions called out on the control plan are covered by the gages?"]
["7.10","Tools/Gauges Ordered","Were tools ordered and/or in process of being made?"]
["7.11","Tools/Gauges Ordered","Are gauges ordered and/or in process of being made?"]
["7.12","Tools/Gauges Ordered","Is a tool development plan established and being monitored ?"]
["7.13","Tools/Gauges Ordered","Are all data related to design and production of the gauges and equipment submitted to the tool shop?"]
["7.14","Tools/Gauges Received","Are all tools available?","Tools on site "]
["7.15","Tools/Gauges Received","Are all gauges available?"]
["7.16","Tools/Gauges Received","Are gauges according planned layout?"]
["7.17","Tools/Gauges Received","Did the tool manufacturer provide proper documentation? ","Layout of tool and/or gages? Prints as required?"]
["7.18","Tools/Gauges Received","Are all gauges and tools identified","Tool/job and/or part number identifying tool?  Ownership properly marked on tool?"]
["7.19","Tools/Gauges Inspection Accepted","Tooling and Gauging Dimensional layouts available ?","Gauge R&R and Production tooling results comply with requirements"]
["7.20","Tools/Gauges Inspection Accepted","Gauge R&R and Production tooling runoffs and validations ?"]
["7.21","Tools/Gauges Inspection Accepted","Are tools / equipment are according planned layout approved ?","- part marking by tool is readable and correct to requirements"]
[]
["(8) Measurement System Evaluation Progress"]
["8.1","Control Plan / PFMEA Gauge link","Do the gauges on the Control Plan track back through the PFMEA?","* Detection method called out on PFMEA  is carried over to control plan"]
["8.2","Control Plan / PFMEA Gauge link","If gauges are being used in more the one location, is a gauge design comparison done and the gauge design agreed ?"]
["8.3","MSA Plan Identified","Does the documented MSA plan meet the Tenneco requirements for technique and method?","*Review the documented gauging plan.\n* Have gauge instructions been forwarded and reviewed by the Tenneco plant?\n* Does the plan protect the Tenneco plant and their customer(s)?"]
["8.4","Gauge R&R Acceptable","Are the results of the attribute gauge R&R acceptable to the AIAG and Tenneco guidelines?","* Review GR&R results per the Tenneco plant requirements."]
["8.5","Gauge R&R Acceptable","Are the results of the variable gauge R&R acceptable to the AIAG and Tenneco guidelines?","* Review GR&R results per the Tenneco plant requirements."]
["8.6","MSA Complete","Have all aspects of gauging been documented?","* Do all gauges identified on the Control Plan have an acceptable GR&R?"]
["8.7","MSA Complete","If gauges are being used in more than one location, has the gage correlation study been completed?","*Review gauge R&R study"]
[]
["(9) Operator Process Instruction Progress"]
["9.1","Aligned with  Process Flow","Is there a description of the process flow ?"]
["9.2","Aligned with  Process Flow","Are all operations clearly described ?"]
["9.3","Aligned with  Process Flow","Is each key process step identified in the process flow ?"]
["9.4","Aligned with  Process Flow","Are all operations affecting special characteristics appropriately identified on the process flow chart ?"]
["9.5","Aligned with  Process Flow","Is there evidence that changes have been made in the process flow to reduce potential process variability ?"]
["9.6","Aligned with  Process Flow","Are all Process Instructions accessible and visible at the work station ?  / 1st Piece Approval Samples","* First Off / last Off process"]
["9.7","Aligned with Control Plan","Does the Process instructions list the requirements for inspection, testing, gaging and recording results, with adequate sample size and frequency ?"]
["9.8","Aligned with Control Plan","Does the Process instructions specify monitoring of special characteristics ?"]
["9.9","Aligned with Control Plan","Does the Process instructions specify application of statistical methods required by control plans?"]
["9.10","Aligned with Control Plan","Does the Process instructions document the identification and handling of non-conforming material ?"]
["9.11","Aligned with Control Plan","Does the Process instructions list the required tools and gages with calibration requirements, job set-up and tool change intervals."]
["9.12","Aligned with Control Plan","Is the process instruction specify how to yearly re-qualify the product ?"]
["9.13","Operators Trained","Are all Operators needed for each steps identified ?"]
["9.14","Operators Trained","Are evidence of training available regarding all process steps ?","including setup operations"]
["9.15","Operators Trained","Are evidence of training available regarding key product and process Characteristics ?"]
["9.16","Operators Trained","Are evidence of training available regarding key process control ?"]
["9.17","Operators Trained","Are visual aids available to support operator training ?"]
["9.18","Operators Trained","Rework work Instructions established ?","Customer approval for rework available "]
["9.19","Training Plan Complete","Are all planned training completed , including rework operations ?"]
["9.20","Training Plan Complete","Are Job Training Matrix available, completed and up to date ?","including setup operations"]
[]
["(10) Significant Production Run","Significant Production Run","PPAP Production using final developed process & equipment"]
["10.1","Mat'l Available for Trial","Are all components PPAP approved ?"]
["10.2","Mat'l Available for Trial","Are all components available for the production trial which covers a significant production volume ?","Minimum of 3 hours production, or as agreed with the customer"]
["10.3","Mat'l Available for Trial","Is all material ordered for serial production?"]
["10.4","Aligned with Process Flow","Are all productions machine/tools available ?"]
["10.5","Aligned with Process Flow","Are all control gauges available and qualified for the trial run ?"]
["10.6","Aligned with Process Flow","Are all work instruction available and at the final revision ?"]
["10.7","Aligned with Process Flow","Are all operators trained and ready for the trial ?"]
["10.8","Aligned with Process Flow","Is the launch Containment in place with I Chart data collection defined?"]
["10.9","Process Capability Analyzed","Are all control limits identified ?"]
["10.10","Process Capability Analyzed","Does the capability study show a capable process - normal data and achieve expected CPK/PPK Level?"]
["10.11","Process Capability Analyzed","Are 100% containment in place for non capable process?"]
["10.12","Process Capability Analyzed","Does the supplier need to plan a new trial run ?"]
["10.13","Process Capability Analyzed","Is the planned OEE achieved ?"]
["10.14","Process Capability Analyzed","Has the supplier applied for a deviation and submitted an action plan for those dimensions that are not currently within the specification \"PCN\"?"]
["10.15","Part Inspection Accepted","Are all dimensions measured and according to the customer Specifications ?"]
["10.16","Part Inspection Accepted","Are all relevant tests (PV, DV, Contamination,..) performed and approved?"]
["10.17","Part Inspection Accepted","Is a Customer on-site PPAP approval required and planned ?"]
["10.18","Part Inspection Accepted","Is there a dedicated area for launch containment with necessary tools & equipment?"]
["10.19","Part Inspection Accepted","PPAP Master sample identified, maintained and accessible","* Boundary sample clearly showing similarities of similar parts to prevent mixing…. Left and Right parts.\n* Supplier Quality Department for Master and boundary parts "]
["10.20","Part Inspection Accepted","Quality Planning review  of PPAP documentation and process approval by Tenneco SQE for high risk components","Tenneco SQE"]
[]
["(11) PPAP Submission","PPAP Submission"]
["11.1","All Requirements Identified","Does the supplier have the latest version of the required PPAP / PPA guide and understand the process?"]
["11.2","All Requirements Identified","Are all the PPAP / PPA  requirements fulfilled including customer specific and Tenneco specific requirements ?"]
["11.3","All Requirements Identified","Are the requested sample quantities  produced and measured / tested?  PPAP run performed on standard production equipment with proper labeling per Tenneco?"]
["11.4","All Requirements Identified","If parts are being carried over from a previous program has the PPAP / PPA submission level been agreed with the supplier?"]
["11.5","All Requirements Identified","Is the Vendor Tooling Registration Form ready according Tenneco and End customer requirements ?"]
["11.6","All Requirements Identified","Is the Appearance Approval Report completed and signed when applicable? ","* Are the inspection criteria for appearance approval defined and agreed "]
["11.7","All Requirements Identified","Has the supplier entered all the necessary data into the IMDS?","* The supplier should have received an accepted notification for all parts he has supplied\n* The supplier should download the PDF file of the IMDS approval for all parts\n* IMDS number recorded on Warrant?\n"]
["11.8","All Requirements Identified","Has the supplier received an accepted notification on all parts to be supplied?"]
["11.9","All Requirements Identified","PPAP master samples identified, maintained and accessible?","PPAP masters identified by revision and PPAP approval date?"]
["11.10","Production Timeline Finalized","Is the Time chart completed for the First production ramp up ?"]
["11.11","Production Timeline Finalized","Are all materials planned and ordered for production ramp up ?"]
["11.12","Production Timeline Finalized","Has a capacity evaluation exercise been scheduled / completed at the ship point location?"]
["11.13","Production Timeline Finalized","Has timing been agreed for the submission of interim and final PPAP documents and samples?"]
["11.14","PPAP Submitted to Plant","Has all pre-agreed timing been met for the submission of the final PPAP documents and samples? If no, is there a clear agreement plan in place?"]
["11.15","PPAP Submitted to Plant","Is the PPAP submitted through Titan or Local systems ?"]
["11.16","PPAP Submitted to Plant","Has the supplier reached the volume and quality targets required to pass the capacity evaluation?"]
["11.17","PPAP Submitted to Plant","Are the parts shipped to the receiving plant ?","- conforms to TEN plant requirements\n* clearly identified according TEN requirements"]
["11.18","PPAP Submitted to Plant","Are the gauges when applicable submitted to the receiving plant ?"]
["11.19","PPAP Submitted to Plant","Has all pre-agreed timing been met for the submission of the final PPAP documents and samples? If no, is there a clear agreement plan in place?"]
["11.20","PPAP \"Warrant\" Approved","Has the Supplier received PPAP Approval information from Tenneco ?"]
[]
[null,"(A1)  Launch Containment"]
["A1.1","Launch Containment criteria identified","Does the Supplier understand the minimum time frame for launch containment and understand the exit criteria?\nDoes the Supplier understand the label requirement to identify launch containment?  (Ref Supplier Quality Manual)","Review the launch containment plan."]
["A1.2","Instructions established","Are the inspection instructions completed? Are gages being used and if so are the gage instructions completed if needed?","Review the inspection instructions, gage instructions and gage R&R if applicable."]
["A1.3","Launch Containment organized","Is the Launch Containment Process away from the production area?","Review the launch containment area to ensure proper lighting, material handling flow, visual aides as needed, proper gages supplied and overall organization of area."]
["A1.4","Launch Containment implemented","Are the I charts available and filled out daily?  How is the data being analyzed?","Review the I - chart data and see if any actions are being taken to eliminate any failures in launch containment."]
[]
[null,"(A6) Off-Tool Parts Progress"]
["A6.1","Tool Inspected upon Receipt","How is the tool qualified when received in?","Look at inspections/dimensional results to ensure tool meets drawing.  Review check sheet for tools -(for example correct water lines, correct material, vacuum lines, component of tools adequate to meet the process and life expectancy.)"]
["A6.2","Sufficient Material Available","Is the Material ordered for the tool trial?","Confirm tool trial size, is there enough material?"]
["A6.3","Tool Capability Analyzed","Off-Tool parts Inspection and are dimensionally accepted ?","Was an adequate number of parts ran to produce a capability study?\nAre all cavities being validated per the print?  \nPreliminary capability study reviewed?"]
["A6.4","Off-Tool parts Inspection Accepted","All defined characteristics are inspected and according specification","Dimensional reports\nDeviation requests for all characteristics outside specification established"]
[]
[null,"(A5) Packaging Plan Proposal - Approval"]
["A5.1","Packing Plan Proposed","Packing Plan Proposal Form is completed?\nUnderstand the Labeling requirements per Supplier Manual?\nReturnable container management plan, if required","Review Packaging Proposal Form? (per Supplier manual Link Sheet Section 6 & 7)\nReview Container Management Plan."]
["A5.2","Packaging Mat'l Available","Are the returnable or expendable packing available on site?","Confirm containers are available."]
["A5.3","Packaging Trial Completed","Is a Packaging Trial required?","Plant contact  confirmed for packaging trial?"]
["A5.4","Packaging Plan Approved","Is form completed?","Form uploaded into TITAN?"]
[]
[null,"(A2) Run@Rate Data Submission"]
["A2.1","Capacity requirements identified","Is the capacity verification form  completed?  Are the quoted volumes understood including potential uplift volumes?\n ","Review Capacity form for all areas completed.\nCan the Supplier meet the capacity requirements?"]
["A2.2","Run@Rate defined","Is the minimum amt of time and/or parts required defined?\nIs there any additional requirements such as Ford Phase Run at Rate?\nIs Customer on-site run at rate required?","Confirm with buyers and plants to ensure correct qty and requirements.\nConfirm that Customer specifics are reviewed."]
["A2.3","Run @ Rate Detail Provided","Constraints and shared processes identified?","Review run at rate requirements."]
["A2.4","Run at Rate Approved","Did the run at rate results meet the capacity requirements?","Review the run at rate data to ensure run at rate passes."]
["A11.1","Customer specific requirements reviewed","Customer specifc requirements analyzed and understood"]
["A11.2","CQI-x documentation available and uploaded","If required - Are special processes identified and lastest CQI's report is uploaded into C-folder\nremeber CQI Audit needs to be conducted anually \n- CQI-9 Special Process: Heat Treat System Assessment\n- CQI-11 Special Process: Plating System Assessment\n- CQI-27 Special Process: Casting System Assessment\n- CQI-12 Special Process: Coating System Assessment\n- CQI-15 Special Process: Welding System Assessment\n- CQI-17 Special Process: Soldering System Assessment\n- Ford Specific - Machining Special Assessment","CQI reviewed for special process - completed on annual basis\nFord requirement - Machining special process- completed on annual basis\nLatest CQI included A11 TITAN C-folder "]
["A11.3","Bill of Material available and uploaded","Ist the Bill of material template filled and uploaded","Refer to Tenneco PPAP guideline"]

{"sheet":"PND Guide","index":3,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,1,21,3],[20,7,21,7],[12,8,13,10],[14,0,15,0],[14,1,15,3],[14,7,15,7],[16,7,17,7],[12,0,13,0],[16,0,17,0],[16,1,17,3],[5,1,5,3],[6,1,8,3],[2,6,2,7],[3,0,3,4],[6,7,8,7],[4,1,4,3],[6,0,8,0],[9,0,10,0],[22,0,26,0],[22,1,26,3],[22,7,26,7],[27,0,31,0],[27,1,31,3],[27,7,31,7],[9,7,10,7],[9,1,10,3],[11,1,11,3],[12,1,13,3],[12,7,13,7],[18,0,19,0],[18,1,19,3],[18,7,19,7],[20,0,21,0]]}
[]
[]
[]
["APQP Milestone",null,null,null,null,null,"Day's","PND"]
[11,"PPAP Submission",null,null,"11.1","How many days are needed to ship PPAP parts & PPAP documentation to Tenneco plant ?",null,{"$f":"IF(ISNUMBER(G3),$G$3-G5,\"\")","v":""}]
[10,"IMDS Material Information","IMDS Material Information Progress","IMDS Material Information Progress","10.1","How many day's are needed to add material information into the IMDS database ?",null,{"$f":"IF(ISNUMBER(H5),H5-G6,\"\")","v":""}]
[9,"Production Trial Run","Production Trial PPAP Run","Production Trial PPAP Run","9.3","How many days are needed to review PPAP package prior submission to Customer ?",null,{"$f":"IF(ISNUMBER(H6),H6-(G7+G8+G9),\"\")","v":""}]
[null,null,null,null,"9.2","How many days are needed to prepare full PPAP documentation, including sub supplier PPAP capacity information, etc  ?"]
[null,null,null,null,"9.1","How many day's are needed to analyse process capability data from the production trail run ?"]
[8,"Operator Process Instructions Progress",null,null,"8.2","How many day's are needed to produce the PPAP parts ?",null,{"$f":"IF(ISNUMBER(H7),H7-(G10+G11),\"\")","v":""}]
[null,null,null,null,"8.1","How many days are needed to do try-outs /optimization work to approve tooling and test equipment ?"]
[7,"Measurement System Evaluation Progress","Measurement System Evaluation Progress","Measurement System Evaluation Progress","7.1","How many days are needed to train  operators and to verify training results ?",null,{"$f":"IF(ISNUMBER(H10),H10-(G12),\"\")","v":""}]
[6,"Tooling & Gauges Progress ",null,null,"6.2","How many days are needed to verify functionality of gauges / test equipment and to approve them ?",null,{"$f":"IF(ISNUMBER(H12),H12-(G13+G14),\"\")","v":""}]
[null,null,null,null,"6.1","How many day's are needed to produce the PPAP parts ?"]
[5,"Production Control Plan Progress","Production Control Plan Progress","Production Control Plan Progress","5.2","How many days are needed to define control gauges, including all elements of the production control plan  ?",null,{"$f":"IF(ISNUMBER(H13),H13-(G15+G16),\"\")","v":""}]
[null,null,null,null,"5.1","If requested, how many days are needed for customer review ?"]
[4,"Process FMEA Progress",null,null,"4.2","How many days are needed to finalize design of all tooling and test equipment   ?",null,{"$f":"IF(ISNUMBER(H15),H15-(G17+G18),\"\")","v":""}]
[null,null,null,null,"4.1","How many days are needed to develop a Production Control Plan, including PFMEA expects as well as considering all special characteristics to ensure customer requirement fullfillment ?"]
[3,"Manufacturing Process Flow Chart Progress",null,null,"3.2","How manny days are needed to develop a Process FMEA including all elements of the Manufacturing Process flow and considering all special characteristics ?",null,{"$f":"IF(ISNUMBER(H17),H17-(G19+G20),\"\")","v":""}]
[null,null,null,null,"3.1","How many days are needed by the supplier to review drawings & specifications and do a feasibility analyse ?"]
[2,"Drawing / Spec Information Available",null,null,"2.2","How many days are needed by the supplier to define a robust manufacturing process flow in order to achive all customer expectations ?",null,{"$f":"IF(ISNUMBER(H19),H19-(G21+G22),\"\")","v":""}]
[null,null,null,null,"2.1","How many days are needed by the supplier to review drawings & specifications and confirm feasibility ?"]
[1,"Design Verification & Validation / Product & Process Design & Development",null,null,1.5,"How many days to develop the Process Design?",null,{"$f":"IF(ISNUMBER(H21),H21-(G23+G24+G25+G26+G27),\"\")","v":""}]
[null,null,null,null,1.4,"How many days Tenneco Engineering would need to (Product) \"Validate Design\" & provide DVP&R?"]
[null,null,null,null,1.3,"How many days Supplier Engineering would need to  (Product) \"Validate Design\" & provide DPV&R from production intent process?"]
[null,null,null,null,1.2,"Timing for serial tooling for PV testing: all components"]
[null,null,null,null,1.1000000000000001,"How many days will the PV (Product Validate) design Release (by Tenneco) take?  "]
[0,"Design & Development",null,null,0.5,"How many days will a software schematic review take to complete (Tenneco & Supplier)",null,{"$f":"IF(ISNUMBER(H23),H23-(G28+G29+G30+G31+G32),\"\")","v":""}]
[null,null,null,null,0.4,"How many days to DV (Design Validation) Test Results"]
[null,null,null,null,0.3,"DV Level: How many days to provide parts from prototype tooling"]
[null,null,null,null,0.2,"How many days to Design Release (Tenneco / Supplier)"]
[null,null,null,null,0.1,"How many days to review and align the SOW & SOR between Tenneco and supplier"]

{"sheet":"ActionPlan","index":4,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,3],[2,4,2,7],[2,8,2,9],[2,10,2,11],[6,8,6,9],[6,10,6,11],[3,1,5,3],[3,4,5,7],[6,1,6,3],[6,4,6,7],[3,8,3,9],[3,10,3,11],[4,8,4,9],[4,10,4,11],[5,8,5,9],[5,10,5,11],[8,8,8,9],[10,3,10,4],[10,5,10,7],[10,8,10,9],[9,2,9,3],[10,1,10,2],[10,10,10,11],[7,10,7,11],[9,10,9,11],[9,5,9,9],[14,3,14,5],[14,10,14,11],[11,3,11,5],[11,10,11,11],[12,10,12,11],[12,3,12,5],[8,10,8,11],[7,5,7,7],[7,8,7,9],[7,2,7,3],[8,2,8,3],[8,5,8,7],[13,3,13,5],[13,10,13,11],[18,3,18,5],[18,10,18,11],[15,3,15,5],[15,10,15,11],[16,3,16,5],[16,10,16,11],[17,3,17,5],[17,10,17,11],[19,3,19,5],[19,10,19,11],[23,3,23,5],[23,10,23,11],[22,3,22,5],[22,10,22,11],[20,3,20,5],[20,10,20,11],[26,3,26,5],[26,10,26,11],[21,3,21,5],[21,10,21,11],[24,3,24,5],[24,10,24,11],[25,3,25,5],[25,10,25,11]]}
[]
[null,"Action Register"]
[null,"Project",null,null,"Supplier",null,null,null,"TEN Part Description"]
[null,null,null,null,null,null,null,null,"TEN Part number"]
[null,null,null,null,null,null,null,null,"Revision"]
[]
[null,"Project responsible person",null,null,"Supplier responsible person",null,null,null,"Action Register - N°:"]
[null,"Contact:",null,null,"Contact:",null,null,null,"Last update:"]
[null,"phone-n°:",null,null,"phone-n°:",null,null,null,"Next update:"]
[null,"e-mail:",null,null,"e-mail:"]
[]
[null,"Ref n°","Date started","Action item",null,null,"Resp.","Target date","Closing date","Status","Comments / ref docs / ref mails"]

{"sheet":"Historie","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[22,2,22,12],[22,13,22,15],[23,2,23,12],[23,13,23,15],[20,2,20,12],[20,13,20,15],[21,2,21,12],[21,13,21,15],[18,2,18,12],[18,13,18,15],[14,2,14,12],[14,13,14,15],[19,2,19,12],[19,13,19,15],[16,2,16,12],[16,13,16,15],[17,2,17,12],[17,13,17,15],[15,2,15,12],[15,13,15,15],[8,2,8,12],[8,13,8,15],[9,2,9,12],[9,13,9,15],[10,2,10,12],[10,13,10,15],[11,2,11,12],[11,13,11,15],[12,2,12,12],[12,13,12,15],[13,2,13,12],[13,13,13,15],[5,0,5,15],[6,0,6,15],[7,2,7,12],[7,13,7,15],[0,2,0,15],[1,0,3,15],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,10],[4,11,4,12]]}
[null,null," Supplier APQP Tracking Sheet"]
["History"]
[]
[]
["TEN Document n°",null,"P06_35_7.2",null,"Revision:",null,"8a",null,"Revision date:",null,null,"2021-10-28",null,null,"Purchasing"]
["Document Revision History :"]
[]
["INDEX","DATE","Change",null,null,null,null,null,null,null,null,null,null,"Author"]
[1,"2006-05-31","Creation",null,null,null,null,null,null,null,null,null,null,"Dan Stelzer"]
[2,"2006-09-01","General modification",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
[3,"2007-05-31","Functions added",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
[4,"2008-11-07","PND template modified",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
[5,"2014-04-24","Complete modification",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
["6d","2014-11-24","Bug fixes , APQP Element Rating added ",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
["6e","2014-12-10","A1,A2,A5 &A6 questions updated, spelling errors fixed",null,null,null,null,null,null,null,null,null,null,"Joanne Halstead"]
["6f","2014-12-14","Functional updates",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
["6g","2015-02-20","Bug fixes ; Functional updates",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
[6,"2015-03-30","APQP Guidelines finalized.  ",null,null,null,null,null,null,null,null,null,null,"Joanne Halstead"]
[7,"2016-12-05","Updates the New Technology Design phases and included APQP details",null,null,null,null,null,null,null,null,null,null,"Darrell Spencer"]
["7a","2017-06-23","Bug fixes ; Functional updates",null,null,null,null,null,null,null,null,null,null,"Michael Wind"]
[8,"2020-11-11","Added special requirements in A11",null,null,null,null,null,null,null,null,null,null,"Joanne Halstead"]
["8a","2021-10-28","Added 2.11 -CANA ONLY - Packaging Proposal Reviewed and Approved",null,null,null,null,null,null,null,null,null,null,"John Nally"]