{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Validation","RevHistory","MAPP INSTRUCTIONS","SECTIONS 1, 2, 6 & 7 - MAPP","SECTION 3 - ASSESSMENT","SECTION 4 - SUPPLIER PFD","SECTION 5 - CONTACT LIST","SECTION 8 - APQP OPEN ISSUES","SECTION 9 APQP Timeline","Coating & Plating ","Diecast Aluminum  & Magnesium","Diecast Zinc","Ductile Iron","Electrical ","Fastener ","Machined Part ","Plastic Molding ","Powdered Metal","Press Fit","Projection Welding ","Rubber ","Squeeze Cast","Grey Iron","Stamping  1 of 2","Stamping  2 of 2","Forging","Steel Quality","SECTION 10 Capacity Plan "],"not_rendered":{"charts":1,"images":17,"macros":1,"external_links":3,"defined_names":113,"comments":4,"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":"Validation","index":0,"n_rows":31,"n_cols":32,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["DETCL1","DETCL2","DETSTD",null,"PROCL1","PROCL4","PROCL3",null,"DEFCL1","DEFCL2","DEFCL3",null,"CI-100V",null,"CI-100V","CI-DR","QS-100V","QS-DR","STD4-8","STD1-3","KPC","CL1","CL2","CL3","CL4","CL5","CL1-CMR","CL2-CMR","CL3-CMR","CL4-CMR","CL5-CMR","Detection Values"]
[1,1,1,null,1,1,1,null,"A","A","A",null,"CI-DR",null,"1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1"]
[2,2,2,null,2,2,2,null,null,"B","B",null,"QS-100V",null,"2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2"]
[3,3,3,null,3,3,3,null,null,null,"C",null,"QS-DR",null,"3","3","3","3","3","3","3","3","3","3","3","3","3","3","3","3","3","3"]
[4,4,4,null,4,4,4,null,null,null,null,null,"STD1-3",null,"4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4"]
[null,5,5,null,null,5,5,null,null,null,null,null,"STD4-8",null,"5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A","5A"]
[null,6,6,null,null,6,6,null,null,null,null,null,"KPC",null,"5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B","5B"]
[null,7,7,null,null,null,7,null,null,null,null,null,"CL1",null,"6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A","6A"]
[null,null,8,null,null,null,null,null,null,null,null,null,"CL2",null,"6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B","6B"]
[null,null,9,null,null,null,null,null,null,null,null,null,"CL3",null,"7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A","7A"]
[null,null,10,null,null,null,null,null,null,null,null,null,"CL4",null,"7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B","7B"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CL5",null,"8","8","8","8","8","8","8","8","8","8","8","8","8","8","8","8","8","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CL1-CMR",null,"9","9","9","9","9","9","9","9","9","9","9","9","9","9","9","9","9","9"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CL2-CMR",null,"10","10","10","10","10","10","10","10","10","10","10","10","10","10","10","10","10","10"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CL3-CMR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Process Control Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CL4-CMR",null,"1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CL5-CMR",null,"2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3","3","3","3","3","3","3","3","3","3","3","3","3","3","3","3","3","3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5","5","5","5","5","5","5","5","5","5","5","5","5","5","5","5","5","5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6","6","6","6","6","6","6","6","6","6","6","6","6","6","6","6","6","6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7","7","7","7","7","7","7","7","7","7","7","7","7","7","7","7","7","7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defect Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B","B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Verification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100% Verification","Per Control Plan","100% Verification","Per Control Plan","Per Control Plan","Per Control Plan","Per Control Plan","100% Verification","100% Verification","Per Control Plan","100% Verification","Per Control Plan","100% Verification","100% Verification","Per Control Plan","100% Verification","Per Control Plan","100% Verification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Control Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demonstrate Upon Request"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]

{"sheet":"RevHistory","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"LOOKUP(2,1/(B:B<>\"\"),B:B)","v":32}]
["Date","Revision","Changes"]
["Initial Release",1,"Adopted by Nexteer Automotive Corporation 9/16/2010"]
["2010-09-30",2,"Corrected cell protection issues"]
["2010-10-05",3,"Various formatting changes to prepare for implementation"]
["2010-10-14",4,"Added Diecast Aluminum & Magnesium Technical Supplement Questions.\nRemoved Aluminum casting Technical Supplement & General Casting Technical Supplement\nAdded Question in Team Feasibility -- Can all of the drawing dimensions/requirements and product specifications be met?"]
["2010-11-18",5,"Added clarification to question #29 -- Stress relieve capability of \"production part\" - Die cast Aluminum & Magnesium Supplement Tab "]
["2010-11-24",6,"Removed Item #4 & #12 on the Machine Part Technical Supplement.  Questions are not applicable to machined parts."]
["2010-12-03",7,"Remove Conditional Formatting in Supplier Response - Section 2"]
["2011-02-28",8,"Added Revisions to the following Technical Supplements: \n     Aluminum & Magnesium Technical Supplement.  \n     Rubber Technical Supplement\n     Plastic Molding Supplement\nSection 3 - Qualification Plan for PPAP; \n     Variable Gages:  All variable gages study plan changed to 10 x 3 x 3 plan.   \n     Attribute Gages:  All attribute gage study plan changed to 50 x 3 x 3. Attribute Gage \n     Analysis"]
["2011-02-28",9,"Added clarification to Section 7 to number each signature section - (7A, 7B, 7C, 7D) "]
["2011-02-28",10,"Section 6 - Removed requirements indicating when Buyer fills out Kick-Off and Contact Information"]
["2011-02-28",11,"Section 6 - Definitions clarified"]
["2011-02-28",12,"MAPP Instructions -- Clarification was added.  \n    STEP 4 -- If the print is not road mapped by Nexteer,  the Supplier is required to \n    manually road map the print.\n    STEP 10 -- New Instruction added -- Nexteer Buyer or AQE will notify the Supplier of any \n    updates that are required after the original MAPP submission by the\n    Supplier."]
["2011-04-20",13,"Section 3 - Removed reference to \"Required upon Nexteer Request\" in Section 3 Title\n\nSection 7 A & Section 7C - Removed Supplier Operations signature being required.  This was redundant to Manufacturing signature.  Updated Title Block in Section 7A -- Removed \"Unless Directed by Nexteer\""]
["2011-05-02",14,"Added column to Section 3 - \"Required Capability Study -- Yes or No\""]
["2011-05-04",15,"MAPP Instruction Sheet:\nStep 4 - Section 3 Take out \"the Buyer will notify you if this section is required\"\nStep 5- Section 4 Take out \"the Buyer will notify you if this section is required\""]
["2011-06-17",16,"Section 2 - Added question  - \"Have Lessons Learned been reviewed between Nexteer and Supplier (i.e., for similar parts and processes)?\"\n---------------------------------------\nAdded the following Technical Supplements (Far right Tabs on MAPP Template):  \n* Squeezecast\n* Diecast\n* Ductile Iron\n* Grey Iron\n* Updates to Machining Process\n---------------------------------------\nSection 6 - Clarification was added to Quoted Tool Capacity -- 100 working hours is based on a 5 day work week.\n---------------------------------------\nEntire MAPP Template - Changed Nexteer \"Customer Specific Requirements\" to Nexteer \"Supplier Requirements\"\n---------------------------------------\nSection 7 - Consolidated Section 7 to allow one set of signature approvals for Nexteer and one set of signature approvals for Supplier.\n---------------------------------------\nSection 6  - Renamed,  \"Key Date Information\" from \"Kick-Off Information\"\n---------------------------------------\nUpdated MAPP Instruction Tab to reflect Section 7 Signature Requirement changes."]
["2011-10-12",17,"Added Section 9:  APQP Timing Plan\n--------------------------------------------------------\nInstructions updated to include Section 9 - APQP Timing Plan\n--------------------------------------------------------\nUpdated Diecast & Aluminum Technical Supplement Questions #22 & #23:\n    22) How many dies and cavities per die are planned? How many slides and core pulls?\n    23) How many pieces per day are expected for one die / machine?\n--------------------------------------------------------\nAdded Numbering Scheme to Line Items for easy identification in Sections 1 & 2.\n--------------------------------------------------------\nAdded Line Item 2.48, Section 2 - Technical Supplement Drop-Down Box Feature.  Supplier can select the required Technical Supplement Questionnaire from a Drop-Down Box. (Note:  Supplements are \"hidden\" within the MAPP Template.  Only the required ones will appear once selected from the Drop-Down Box)"]
["2012-02-24",18,"Section 1 - added definition to question 1.10 - scheduling lead time\n                - Row 3, added comments in the Part Number, Revision, and Part Description (Part Name) fields to describe the File Name and \n                  Saving Feature:  The Part Number, Revision, and Part Description must be filled out in order for the file save function to work \n                  properly.  If these fields are not filled out, then the other option, upon saving this file, is to remove all brackets from the auto-\n                  populated file name, in order to properly save this file. \n--------------------------------------------------------\nSection 3 - changed PPK and CPK to =/> vs. = 1.67 and = 1.33\n                - Column header titled \"Description of Control or Verification Method\" was enhanced to add examples of Xbar&R, Variable/Attribute \n                  Gage Description \n                - Column header titled \"General Comments & Mitigation Plan\" was enhanced to add more description such as Sampling Plan, Size & \n                   Frequency\n                - Column E, titled \"Class\", QCI was removed from the drop down menu\n--------------------------------------------------------\nSection 10 - New section titled Capacity Plan was added to determine the plan from a tooling, machine, and cycle time standpoint\n--------------------------------------------------------\nMAPP Instruction Tab - Added that the U.S. English language version of this document shall be the official version.  Any translations of this document will be for reference only.\n--------------------------------------------------------"]
["2012-10-01",19,"Supplement Section - Updated the Die Cast Supplement to add questions 21 and 25\nGeneral - Implemented the use of ISO8601 common date format\nSection 1 - Added new question 1.1\n                - Added clarification to question 1.9; material fab and raw material\n                - Added question 1.13 on financial stability (question was previously located in section 2)\nSection 2  - Added question 2.4 concerning improvement recommendations   \n                - Added question 2.26 concerning duplicate gages for potential correlation issues\n                - Reviised question 2.32 to ask scorecard color and action plans\n                - Revised question 2.36 concerning traceability                                                  \nSection 3 - Allowed for the ability to insert rows \n                - Added Pass Through dimension column; PE to fill out at Supplier Capability & Selection Review\nSection 7B-PC&L sign-off indicates verification of question 1.1 and any necessary notification to the Trade Compliance Manager"]
["2013-02-26","020","Instructions Tab - Updated Flawless Launch to Perfect Launch\nSection 1 - Removed Covisint references and replaced with Intelex\n                - Updated question 1.4 to include Nexteer Automotive Global Supplier Packaging Manual\n                - Updated question 1.12 to include a reference to the Nexteer Label Template and provided the link to the Portal page.\nSection 2 - Updated question 2.36 for lot size and traceability\n                - Updated question 2.15 to include AIAG CQI process assessment verification\nSection 9 - Updated Item 22 to remove reference to Appendix 39 and replace with F1058 Process Audit Production Readiness Form\nGeneral - Updated links within document to new Nexteer Supplier Portal, Intelex, or other areas of existing document"]
["2013-05-28","021","Section 1 - Updated question 1.9 to clarify the 2+2 material commitment\nSection 2 - Updated question 2.12 to have supplier provide external lab name, if applicable.                \nSection 3 - Moved to a separate tab to allow for a pull from engineering and allow for sorting\n                - Moved \"Required Process Indicies\", \"Required Control or Verification\" and \"Qualification Plan for PPAP\" columns to end of data table \n                  (right of Status) to allow for sorting when document is locked.\nSection 6 - Removed reference to \"QTC\" and \"Quoted\".  \n                - Added new field to calculate the 15% over Annual Tool Capacity\n                - Updated comments to show the Annual Tool Capacity field should be populated by the buyer.\n                - Changed \"Timing Confirmation\" to read \"Nexteer Timing Confirmation\" to clarify that the dates entered are Nexteer Timing \n                  Requirements"]
["2013-10-01",22,"Section 1 - Eliminated question 1.11 concerning 10 day leadtime to match new NSRs.\nSection 2 - Updated question 2.2 to efficiently handle material substitution requests\n                - Added new question 2.3 to help with the efficiency of material substitution requests.\n                - Separated question 2.36 into two questions to separate traceability requirements from lot size control\nSection 3 - Separated column \"Sampling plan, size & frequency; General Comments and/or Mitigation Plan\" into 2 different columns: \n                  \"Sample Size & Frequency of Inspection\" and \"General Comments and/or Mitigation Plans\"\n                - Added 3 new columns: \"Detection Control\", \"Process Control\", \"Defect Handling\"\n                - Added new classes into \"Classes\" column dropdown to reflect QCL classes.\n                - Updated Control or Verification Columns for new available classes\n                - Renamed \"Required Control or Verification\" column to \"Control Verification\"\n                - Renamed \"Process Indices\" column to \"Initial Process Indices\"\n                - Added hyperlinks to easily navigate to attachments B (product characteristic and control levels chart), C (detection control table), \n                  D (process control table) and E (defect handling table) from the NSR's\nSection 9 - Updated to create a true Gantt chart. Supplier must now enter when the event will happen and how long the event will take.\nSection 10 - Corrected name formulas to pull correct fields from Sections 1, 2, 6 & 7 tab\n                  - Locked Days per week field to not allow a number more than 5 to be entered\n                  - Added new field for mitigation capacity plan if the supplier needs more than the allowed 5 days or 100 hours per week.\n                  - Net Available Time field will highlight Red if calculated to be higher than 100\n- Updated Instructions Tab\n- Eliminated \"MAPP EXAMPLE\" tab\n- Added electronic signature anchors on signature page to allow for Docusign to be used"]
["2013-12-01",23,"Instructions Tab:       - Updated to account for the DSS. Note: The DSS may be sent out as an attachment in the Ariba RFQ, by the Buyer.\n                                  - Updated Step 4 to add a link to a \"help guide\" that will have the needed attachments B through E.\n                                  - Added a link to a completed DSS as an example.\n                                  - Updated Step 10 on signing the MAPP to comprehend Docusign.\nSection 1 - Reworded question 1.2 due to timing of registration to Intelex as new suppliers will be unable to register at time of MAPP.\nSection 2 - Eliminated question 2.46 (PPAP Lead Time) as it is comprehended on Section 9.\n                - Updated question 2.41, 2.43 and 2.44.\nSection 3 - Updated Attachment E \"Defect Handling Table\" to remove reference to internal Nexteer procedures.\n                - Added a link in upper left corner to an example of a properly completed Section 3.\n                - Corrected error on Drawing Revision field for auto-population from Section 1.\nSection 6 - Rephrased \"Off Tool Samples\" to \"MQ1\" for consistency with other GSM documents and systems.\nSection 7 - Updated 7A to comprehend Docusign in Supplier Signature area.\nSection 9 - Clarified Column C header to indicate \"# of days after kick-off for START of activity\".\n                - Modified questions for clarification and consistency with the new APQP document\nSection 10 - Clarified \"Process Description\" to specify only the Processes that change the part.\nTechnical Supplements - Updated Technical Supplements for Diecast Aluminum & Magnesium, Stamping 1 of 2, Rubber, and Plastic Molding"]
["2014-05-07",24,"Section 2 - Eliminated steel technical supplement as MAPP is not performed on bulk steel\n               - Combined question 2.28 and 2.29 regarding test equipment into one question\n               - Created new question for Reliability Testing.\nSeciton 3 - Comment added to Required Initial Process Indices column T\n               - Column U, Control Verification, has been corrected for CL2 and CL4 to be 100% Verification.\nSection 10 - Capacity Plan now comprehends duplicate machines within the same process\nProduct Characteristics Control Level Chart (Attachment B) was updated to eliminate the Nexteer Use only column titled \"Statistical Design Target\"\n6.19.2014 -- Minor update to definitions of Maximum Tool Capacity vs Annual Tool Capacity on Section 6 (no rev change required)\n7.22.2014 -- Minor correction to Detection (section 3) for STD2-8 to add 7B as an option."]
["2014-11-24",25,"Section 3 - On a Class Standard of 9-10 and Class Standard 2-8, which are defined as Pass Through, the Required Initial Process Indicies\n                  (Column T) now defaults to a Ppk=/>1.33 (was 1.00)\n                - On a Class Standard of 9-10 and Class Standard 2-8, which are defined as Pass Through, the Qualification Plan for PPAP\n                  (Column V) now defaults to PPAP Checksheet, 5 pc. dimensional layout & capability/gage studies"]
["2015-02-16",26,"Instructions Tab - Updated 11\"x17\" Product Characteristics Help Guide\nSection 1 - Updated question 1.8 to change from ANSIX-12 to EDIFACT\n                - Updated question 1.11 for label specifications\nSection 2 - Added question 2.3 concerning design responsibility\n                - Renumbered remaining questions in Section 2 for addition of question 2.3\n                - Added technical supplement to question 2.51 for Steel Quality Requirement for Specification 33200011\n                - Added technical supplement to question 2.51 for Press Fit \nSection 3 - Updated section for changes to G1331 procedure dated 06FE2015\n                - Added CL3 class\n               - Eliminated STD9-10 from class\n               - Updated CL5, CI-DR, QS-DR, & KPC classes to default to \"Per Control Plan\" for Column U (Control Verification)\n               - Updated Attachment B & Attachment E\nSection 7B - Added questions for ensuring alternative control strategies to G1331 are captured and approved on G1331 Approval Form (X1331)\n                    and that approved form is attached in PMD by AQE/SQE."]
["2015-03-26",27,"Instructions Tab - Updated Section 3 Screen shot due to changes to columns\n                          - Add information on Step 4 for completion of \"Control Verification\" column in Section 3\nSection 3 - Removed default values from \"Control Verification\" column to allow alternative choices to be selected per dropdown\n                - Added red highlight condition if a non-allowable or alternative choice is made in \"Control Verfication\", \"Detection Control\", \n                   \"Process Control\" & \"Defect Handling\" columns. \n               - Eliminated STD2-8 from class\n               - Added STD1-3 and STD4-8 classes"]
["2016-01-20",28,"Section 1 - Updated Question 1.1 to clarify Red highlight on Supplier's \"No\" answer.\n                - Updated Question 1.6 to add note regarding approved SPI submission with any future PPAPs as required.\nSection 2 - Removed Heat Treat Supplement from MAPP, removing it from 2.54 \n               - Added Question 2.1 to read \"Do you understand ASME Y14.5 Geometric Dimensioning and Tolerancing (GD&T) standard?\"\n               - Added Question 2.2 to read \"Have you received the Design Severity & Sensitivity (DSS) document from Nexteer?\"\n               - Added Question 2.9 regarding MCA Open Items and Improvement verfiication\n               - All Section 2 questions have been renumbered with addition of new questions\n               - Modified Question 2.7 regarding Lessons Learned, to include confirmation of review on Global Look Across alerts \n                    and Intelex Problem Cases\n               - Modified Question 2.20 regarding CQI special process assessments\nSection 5 - Updated Supplier Contacts titles to match Nexteer terminology\nSection 10 - Corrected error on dropdown for Dedicated vs. Shared\nMachined Parts Technical Supplement added question 24\nForgings Technical Supplement updated to correspond with MCA survey\nDie Cast Aluminum Technical Supplement added questions and removed non-pertinent questions."]
["2016-05-04",29,"Section 3 - Updated the Required Initial Process Indices (Cpk & Ppk values) for CL1, CL2, CL4, CL5 and Standard classes to be consistent with\n                 the Nexteer Supplier Requirements (revision date March 1, 2016)\nStampings 1 of 2 Technical Supplement - added questions 2 & 3, and renumbered remaining questions\nStampings 2 of 2 Technical Supplement - added reference to QCL's, gage description, eliminated Hole Sizes and Processing Note 2"]
["2016-08-03",30,"Sections 1 & 2 - Defined internal Nexteer acronyms to eliminate confusion throughout the document\nSection 2 - Updated comments in question 2.54 Technical Supplement to require Steel Quality Technical Supplement if the drawing requires\n                 specification #33200011\nSection 3 - Updated Product Characteristic Charts Attachments B, C, D, and E based on changes to procedure (G-1331) dated 01JL16\n               - Updated Qualification Plan for PPAP for CL3 class to include the words \"If required\" for capability studies\n               - Corrected Conditional formatting for values in Column T for the STD classes\nStampings 2 of 2 Technical Supplement - Reworded die sensoring proposal statement to require the proposal be submitted by the supplier and \n                                                            approved by the Nexteer AQE prior to the award of business\n                                                          - Reworded die strip diagram statement to indicate that concept die strip layouts are required to be \n                                                             submitted by the supplier and approved by the Nexteer AQE prior to technical review.\nInstructions Tab - Corrected Technical Supplement Question reference to be more dynamic to allow for future changes to MAPP\n                        - Updated Product Characteristic Control Level chart link to reflect changes to procedure (G-1331) dated 01JL16"]
["2017-10-18",31,"Section 2 - Added question 2.8 \"If part is outsourced from Nexteer, have ME lessons learned from the part development been shared with \n                 your organization?  Have the following part documents also been shared (WI, PFD, PFMEA, CP, LSR, fixture and gaging details)?\"\n               - Added question 2.14 \"Will all capital and tooling be in your final plant location(s) at the time of PPAP submission?\"\n               - Added question 2.22 \"Is this part being outsourced from Nexteer (meaning has this part been manufactured in a Nexteer plant \n                 prior to this MAPP being completed)?\"\n               - Added question 2.23 \"If part is outsourced from Nexteer, has a Nexteer manufacturing plant site process walk and Nexteer \n                  PFMEA/Control Plan Review been scheduled?  Note: The Nexteer ME is the most knowledgeable in the effected part(s)\n                  manufacturing process history and must participate in the detailed MAPP review.\"\n               - Added question 2.24 \"If part is outsourced from Nexteer, has an exit PPAP been provided from the Nexteer plant?\"\n               - Updated question 2.38 (now 2.43) to include IATF16949 Cert option and ISO9001 Cert only Plan requirement\n               - Updated question 2.41 (now 2.46) to include traceability records system evidence requirement prior to PPAP (per G1783)\n               - Added question 2.55 \"Have you been directed by Nexteer to use a particular supplier for sub-components?\"\n               - Updated 2.50 (now 2.56)  to include a requirement for the supplier to provide a Product & Component Risk \n                 Assessment for Sub-Suppliers\n               - Updated 2.52 (now 2.58) to require a team composition and workload percentage document for the Nexteer program.\nSection 3 - Updated comment box on Column R (Required Capability Study) to add the comment: \"Note: If a Capability Study is \n                 not required, it is still expected that the required initial process indices shown in Column U would be met.\"\n               - Updated comment box on Column V (Qualification Plan for PPAP) to correct the comment regarding number of pieces \n                  required for dimension layout\n               - Added 5 more Classes in the dropdown on Column E (Class) for Customer Manufacturing Requirements \n                 (CL1-CMR through CL5-CMR) to coordinate to changes on G1331\n               - Updated comment box in Column E (Class) and Column M (Sample Size & Frequency of Inspection) to comprehend \n                  the CMRs (Customer Manufacturing Requirements)\nSection 7b - Updated to include Buyer and Program Manager signature if question 2.13 is answered NO\n                - Removed note regarding notification to Trade Compliance Manager by PC&L representative. Per PC&L procedure update, \n                  responsibility transferred to Global Vendor Master Setup Team.\nInstructions Tab - Added comment before Step 5 to comprehend the CMRs (Customer Manufacturing Requirements)"]
["2018-04-06",32,"Section 1 - Added column for Mitigation Plan Owner Name to be populated if a Mitigation Plan is required. An actual name should be used.\nSection 2 - Added column for Mitigation Plan Owner Name to be populated if a Mitigation Plan is required. An actual name should be used.\n                - Added question 2.10, \"In the drawing block (in the lower right hand corner) is a template number populated? If no, contact your \n                  Nexteer AQE immediately. Examples of template numbers: CISTMPxxxx, HSTMPxxx, EPSTMPxxx, HPSTMPxxx, \n                  HPSGTMPxxxx, etc.\" to ensure the Nexteer AQE compares the template with applications drawing to review for \n                  differences if no template number provided.\n                - Added technical supplement for Powdered Metal to question 2.60 (now 2.61)\nSection 3 - Added column for Mitigation Plan Owner Name to be populated if a Mitigation Plan is required. An actual name should be used.\n                - Removed Comments in Column W and defaulted file to all 335 rows being expanded due to protection issues\n                - Added column for tracking if feature or dimension is included in the Early Production Containment (EPC) Plan.\n                - Updated Column G (Pass Through) to allow for answers of N (No), Y-Audit (Yes with Audit Check), and \n                  Y-Error Proof (Yes with Error Proofing)\nSection 7 - Added ME Signature line. ME is required to sign the MAPP if question 2.22 (now 2.23) is answered \"Yes\"\n                - Clarified required AQE/SQE signature line as AQE/SQE in region of Supplier Manufacturing Location \n                - Added optional signature line for AQE/SQE in region of Nexteer Receiving Plant                \n                - Added a note below all signatures to ensure that changes to approved MAPP are reapproved by the AQE and affected\n                  team member(s)\nSection 8 - Added column for Mitigation Plan Owner Name to be populated if a Mitigation Plan is required. An actual name should be used."]

{"sheet":"MAPP INSTRUCTIONS","index":2,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[22,0,22,3],[28,0,28,3],[74,0,74,3],[75,0,75,3],[66,0,66,3],[70,0,70,3],[54,0,54,3],[56,0,56,3],[53,0,53,4],[23,5,26,8],[29,5,32,8],[35,5,38,8],[82,0,82,3],[76,0,76,3],[77,0,77,3],[80,0,80,3],[81,0,81,3],[68,0,68,3],[62,0,62,4],[40,0,41,3],[54,5,54,8],[62,5,62,8],[43,5,48,8],[40,5,40,8],[60,0,60,3],[12,5,12,8],[41,5,41,8],[2,5,2,8],[72,0,72,3],[34,0,34,3],[4,3,6,3],[8,0,8,3],[64,5,64,8],[10,0,10,3],[64,0,64,3],[12,0,12,3],[18,0,18,3],[16,0,16,3],[60,5,60,8],[14,0,14,3],[18,5,21,8]]}
[null,null,null,"The                        MAPP to a PERFECT LAUNCH "]
[]
[null,null,null,"MAPP = Manufacturability Assessment and Process Plan",null,"Link to Frequently Asked Questions"]
[]
[null,null,null,"The MAPP is a document used to communicate Nexteer's expectations to the supplier and to guide the Supplier and Nexteer to a PERFECT LAUNCH by identifying risk and documenting mitigation plans to reduce risk.  It requires the Supplier to consider each dimension, feature or requirement on the drawing and document how it will be manufactured, measured and controlled in production.  MAPP is to be completed for one part number/revision level.  Multiple part numbers will not be accepted on a MAPP Template submission, unless they are part of a charted drawing. (Example:  Multiple part numbers on a drawing).  The U.S. English language version of this document shall be the official version.  Any translations of this document will be for reference only."]
[]
[]
[]
["It is Nexteer's expectation that there will be open items in the MAPP and many changes to the drawing to develop the best cost, highest quality part.  These open items, however, are expected to be addressed and resolved prior to authorizing the supplier to begin tooling for PPAP. "]
[]
["How is the MAPP used?"]
[]
["The MAPP Template and Design Severity and Sensitivity (DSS) Assessment (if available) is sent out with the RFQ.  The MAPP is required to be returned to the buyer prior to any technical review. In the case where the DSS is not available, please contact the appropriate Nexteer Supplier Quality Engineer.",null,null,null,null,"Link to Example DSS Document"]
[]
["The Supplier is required to complete the MAPP for the Supplier Capability & Selection Review (Initial Tech Review)."]
[]
["It is used throughout the sourcing process.  Open issues should be closed prior to tooling for production."]
[]
["It is not a PPAP document but it contains a high level process flow diagram and should be used to develop the Control Plan.",null,null,null,null,"Use the Links below to go to the appropriate section on the form"]
[]
["Supplier Instructions:"]
[]
["STEP 1:  Enter the Part Name, Part Number, Drawing Revision, Supplier Name and Date in the MAPP workbook tab Section 1."]
[null,null,null,null,null,"Link to Enter Information"]
[]
[]
[]
[]
["STEP 2:  Answer the Team Feasibility Questions (Section 1 - Team Feasibility) by selecting Yes or No in the Commitment to Meet Requirements column.  Note any comments in the Supplier Comments column."]
[null,null,null,null,null,"Link to Team Feasibility"]
[]
[]
[]
[]
["STEP 3:  Answer the Supplier Assessment questions (Section 2 - Supplier Assessment) by answering each question in the Supplier Response column. Note that the last question in Section 2 requires the correct technical supplement(s) to be filled out."]
[null,null,null,null,null,"Link to Supplier Assessment"]
[]
[]
[]
[]
["STEP 4:  Complete the Manufacturability Assessment and Process Plan (Section 3 - Manufacturability Assessment) for each dimension, feature or requirement on the drawing and, if applicable, each product specification.  Each dimension, feature or requirement must be referenced by either the road mapping that is provided as part of the Nexteer drawing or will need to be manually road mapped on the print by the Supplier.  After establishing the process flow for the part, list each operation and create a line item for each road mapped requirement on the print.  The DSS document is to be used for completing information to fill out the \"Class\" column. For the \"Detection Control\" column, Attachment C defines the allowable detection methods. For the \"Process Control\" column, use Attachment D to select the proper control method allowed for the characteristic class. For the \"Defect Handling\" column, use Attachment E for the proper handling method allowed for the characteristic class.  For the \"Control Verification\" column, use Attachment B for the proper verification method allowed for the characteristic class. These 4 columns will need further discussion with the Nexteer Advanced Quality Engineer if an alternative choice is made (as evidenced by the cell highlighted in red).",null,null,null,null,"Link to Manufacturability Assessment"]
[null,null,null,null,null,"Link to Product Characteristic\nHelp Guide\n(Attachments B, C, D, E)\nnote: must be printed on 11x17"]
[]
[null,null,null,null,null,"Link to Manufacturability Assessment"]
[]
[]
[]
[]
[]
[null,"Mouse over each heading cell to view detailed instructions:"]
[]
[]
[]
["***In the case where a CMR (Customer Manufacturing Requirement) follows a CL on the drawing (eg. CL5-CMR), then refer to the drawing for the required control to be implemented."]
["STEP 5:   Attach a high level process flow diagram in the SUPPLIER PFD workbook tab (SECTION 4).  This can be a handwritten .pdf file pasted into the workbook tab.  ",null,null,null,null,"Link to Supplier Process Flow"]
[]
["STEP 6:  Review last question in Section 2 and select the appropriate technical supplement(s) if applicable. Completion of the Technical Supplement may be required for the Supplier Capability & Selection Review.  "]
["STEP 7:  Review Section 9, APQP Timing Plan and be prepared to discuss timing plans at the Supplier Capability and Selection Review"]
[]
[]
["STEP 8:  Enter the required Supplier Contact Information in Section 5 - Contact List workbook tab.   ",null,null,null,null,"Link to Supplier Contact List"]
[]
["STEP 9:  Fill in Section 10, Capacity Plan, based on the Operating Pattern for the specific part.",null,null,null,null,"Link to Capacity Plan"]
[]
["STEP 10:  Acceptable forms of signature (in Section 7A): DocuSign electronic signature, Physical signature or an email indicating your agreement to:\n1) The dates listed in Section 6  \n2) Ownership of Mitigation Plans associated with any Open Status Issues listed in Sections 1, 2 & 3.   \n\nNote:  One authorized signature is acceptable on behalf of the entire Supplier Organization provided that Section 5 Contact Information is completed. ",null,null,null,null,"Link to Supplier Contact List"]
[]
["STEP 11:  Save the file as:  \"PN A Rev B C MAPP_dd/mm/yy\" where A = eight digit part number, B = part revision, C = part name, and dd/mm/yy is the date the file was saved.  Email the entire excel file to your Nexteer Buyer by the required date."]
[]
["STEP 12:  THE NEXTEER BUYER OR SUPPLIER QUALITY ENGINEER WILL NOTIFY YOU IF ANY UPDATE IS REQUIRED TO THIS DOCUMENTATION AFTER THE ORIGINAL MAPP SUBMISSION."]
[]
["This information must be completed before any Nexteer reviews and your company will not be considered for the business if this form is not submitted."]
[]
["Frequently Asked Questions"]
[]
["What is the Supplier Capability and Selection Review?"]
["Participants:  GSM, PE, PC&L, Supplier (this is the first time a supplier and Nexteer discuss the part)"]
["Output:  Nexteer to name a Target Supplier "]
["Comments:  There is typically only one meeting with each supplier and only some of the suppliers will be invited to participate in this meeting.  Buyer gets quotes (MAPP not required) and determines who to bring in for the Supplier Capability and Selection Review.  The invitees are required to provide the MAPP prior to this meeting.  After all Supplier Capability & Selection Review meetings are complete the Nexteer Buyer, AQE, PC&L and PE agree upon a Target Supplier."]
[" "]
["What is the Design and Supplier Process Collaboration Activity?"]
["Participants:  GSM, PE & the Target Supplier"]
["Output:  A design and process that is defined, is manufacturable and can be measured and controlled in a production environment."]
["Comments:  This is simply the ongoing meetings we have with the Target Supplier, once one is selected, to prepare for kickoff.  "]

{"sheet":"SECTIONS 1, 2, 6 & 7 - MAPP","index":3,"n_rows":122,"n_cols":19,"rows_kept":122,"cut":false,"hidden":false,"merged":[[117,11,117,12],[119,11,119,12],[56,11,56,14],[57,11,57,14],[46,11,46,14],[58,11,58,14],[59,11,59,14],[60,11,60,14],[61,11,61,14],[62,11,62,14],[14,13,14,14],[15,13,15,14],[16,11,16,14],[17,11,17,14],[18,11,18,14],[19,11,19,14],[20,11,20,14],[27,11,27,14],[28,11,28,14],[23,11,23,14],[24,11,24,14],[25,11,25,14],[5,13,5,14],[6,13,6,14],[7,13,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,13,12,14],[13,13,13,14],[100,4,100,5],[84,2,84,3],[99,4,99,5],[86,4,86,5],[71,9,71,10],[70,1,70,7],[71,1,71,7],[29,11,29,14],[30,11,30,14],[31,11,31,14],[32,11,32,14],[33,11,33,14],[34,11,34,14],[35,11,35,14],[36,11,36,14],[37,11,37,14],[38,11,38,14],[39,11,39,14],[40,11,40,14],[41,11,41,14],[42,11,42,14],[43,11,43,14],[44,11,44,14],[63,11,63,14],[86,0,86,1],[107,0,109,7],[73,0,73,7],[73,9,73,10],[97,0,97,1],[97,2,97,3],[28,1,28,7],[29,1,29,7],[30,1,30,7],[57,1,57,7],[29,9,29,10],[51,1,51,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[61,1,61,7],[53,1,53,7],[56,1,56,7],[101,7,101,13],[56,9,56,10],[67,9,67,10],[69,9,69,10],[55,1,55,7],[75,9,75,10],[75,11,75,14],[76,11,76,14],[73,11,73,14],[80,0,80,17],[28,9,28,10],[59,9,59,10],[59,1,59,7],[78,9,78,10],[31,1,31,7],[31,9,31,10],[74,1,74,7],[74,9,74,10],[64,11,64,14],[65,11,65,14],[45,11,45,14],[47,11,47,14],[48,11,48,14],[49,11,49,14],[50,11,50,14],[51,11,51,14],[52,11,52,14],[53,11,53,14],[54,11,54,14],[55,11,55,14],[60,9,60,10],[60,1,60,7],[58,9,58,10],[66,11,66,14],[67,11,67,14],[68,11,68,14],[69,11,69,14],[70,11,70,14],[71,11,71,14],[64,9,64,10],[68,1,68,7],[62,1,62,7],[63,1,63,7],[63,9,63,10],[62,9,62,10],[69,1,69,7],[65,1,65,7],[65,9,65,10],[97,4,97,5],[95,4,95,5],[72,1,72,7],[77,1,77,7],[78,1,78,7],[76,9,76,10],[86,7,86,13],[93,2,93,3],[79,1,79,7],[75,1,75,7],[76,1,76,7],[72,9,72,10],[86,2,86,3],[95,7,95,13],[93,0,93,1],[88,2,88,3],[84,7,84,13],[88,7,88,13],[77,11,77,14],[78,11,78,14],[79,11,79,14],[97,7,97,13],[72,11,72,14],[74,11,74,14],[55,9,55,10],[42,1,42,7],[51,9,51,10],[58,1,58,7],[54,1,54,7],[50,1,50,7],[39,1,39,7],[40,1,40,7],[41,1,41,7],[52,1,52,7],[50,9,50,10],[44,9,44,10],[48,9,48,10],[49,9,49,10],[53,9,53,10],[52,9,52,10],[39,9,39,10],[45,9,45,10],[47,1,47,7],[40,9,40,10],[41,9,41,10],[46,9,46,10],[42,9,42,10],[47,9,47,10],[122,0,122,7],[101,0,101,1],[101,2,101,3],[116,0,116,1],[117,0,117,1],[113,0,113,1],[101,4,101,5],[114,0,114,1],[113,3,113,7],[103,4,103,5],[115,0,115,1],[103,0,103,1],[103,2,103,3],[103,7,103,13],[106,0,106,17],[112,11,112,17],[111,11,111,15],[110,11,110,17],[107,11,109,17],[110,0,112,7],[121,0,121,17],[99,0,99,1],[99,2,99,3],[88,0,88,1],[46,0,46,7],[84,0,84,1],[95,2,95,3],[93,4,93,5],[93,7,93,13],[84,4,84,5],[99,7,99,13],[77,9,77,10],[88,4,88,5],[95,0,95,1],[48,1,48,7],[67,1,67,7],[49,1,49,7],[61,9,61,10],[64,1,64,7],[66,1,66,7],[54,9,54,10],[57,9,57,10],[70,9,70,10],[66,9,66,10],[68,9,68,10],[0,18,2,18],[13,1,13,7],[19,9,19,10],[2,0,2,1],[7,9,7,10],[7,11,7,12],[2,9,2,10],[2,2,2,5],[3,9,3,10],[3,11,3,12],[6,9,6,10],[6,11,6,12],[3,0,3,7],[5,1,5,7],[5,9,5,10],[5,11,5,12],[16,0,16,7],[19,1,19,7],[18,9,18,10],[4,1,4,7],[6,1,6,7],[7,1,7,7],[3,13,3,14],[4,13,4,14],[4,9,4,10],[4,11,4,12],[8,9,8,10],[8,11,8,12],[12,11,12,12],[13,11,13,12],[13,9,13,10],[11,11,11,12],[14,9,14,10],[14,11,14,12],[12,9,12,10],[11,9,11,10],[10,9,10,10],[10,11,10,12],[9,9,9,10],[9,11,9,12],[37,9,37,10],[43,9,43,10],[37,1,37,7],[38,1,38,7],[35,9,35,10],[32,9,32,10],[25,1,25,7],[25,9,25,10],[23,9,23,10],[33,9,33,10],[34,1,34,7],[32,1,32,7],[33,1,33,7],[34,9,34,10],[27,1,27,7],[27,9,27,10],[36,1,36,7],[26,1,26,7],[26,9,26,10],[24,1,24,7],[30,9,30,10],[38,9,38,10],[35,1,35,7],[36,9,36,10],[21,9,21,10],[17,9,17,10],[15,9,15,10],[26,11,26,14],[8,1,8,7],[9,1,9,7],[12,1,12,7],[14,1,14,7],[20,1,20,7],[11,1,11,7],[10,1,10,7],[15,1,15,7],[17,1,17,7],[18,1,18,7],[24,9,24,10],[23,1,23,7],[15,11,15,12],[16,9,16,10],[22,1,22,7],[21,11,21,14],[22,11,22,14],[22,9,22,10],[20,9,20,10],[21,1,21,7]]}
[{"$f":"\"Version: \"&TEXT(RevHistory!E1,\"0##\")","v":"Version: 032"},null,null,null,null,null,null,null,null,"Manufacturability Assessment and Process Plan",null,null,null,null,null,null,null,null,"Useful\nLinks & Tips"]
[]
["Part Description:",null,"[Enter Part Name Here]",null,null,null,null,"Part   Number:",null,"[Enter PN Here]",null,"Drwg Rev:","[Enter Drwg Rev Here]","Supplier Name:","[Enter Supplier Name Here]","   MAPP     \nRev Date:                         ",null,"[Enter Date]"]
["SECTION 1:  TEAM FEASIBILITY\nCOMPLETED BY SUPPLIER FOR SUPPLIER CAPABILITY & SELECTION REVIEW",null,null,null,null,null,null,null,null,"Category",null,"Commitment to Meet Requirement",null,"Supplier Comments",null,"Mitigation Plan","Mitigation Plan Owner","Status\n(Buyer)","◄ See comments"]
[1.1000000000000001,"My Company will manufacture this part in a facility currently providing parts to Nexteer.",null,null,null,null,null,null,null,"Commercial"]
[1.2,"My company is a current Direct Material Supplier to Nexteer AND my quoted manufacturing location is registered to the Nexteer Problem Case Management System through Intelex. Registration to the system can only occur after business is awarded. (Both conditions must be true to provide a response of \"Yes\")",null,null,null,null,null,null,null,"Commercial",null,null,null,null,null,null,null,null,"Link to Intelex"]
[1.3,"My Company is capable of the Electronic Funds Transfer.",null,null,null,null,null,null,null,"Commercial"]
[1.4,"My Company has reviewed the Nexteer Supplier Requirements (NSR) and the Nexteer Automotive Global Supplier Packaging Manual on the Nexteer Supplier Portal.",null,null,null,null,null,null,null,"Commercial",null,null,null,null,null,null,null,null,"Link to Nexteer Supplier Portal"]
[1.5,"My Company will meet and agree to all of the Nexteer Supplier Requirements (NSR). ",null,null,null,null,null,null,null,"Commercial",null,null,null,null,null,null,null,null,"Link to NSR's"]
[1.6,"The Nexteer Supplier Packaging Information (SPI) Form is complete and submitted to the Nexteer Buyer with this quote. \nNote: The Nexteer approved SPI will need to be submitted with any future PPAPs, as required.",null,null,null,null,null,null,null,"Logistics"]
[1.7,"There are no minimum order quantities required other than the standard pack size.",null,null,null,null,null,null,null,"Logistics"]
[1.8,"My Company is electronic communication capable (EDIFACT or web-EDI).",null,null,null,null,null,null,null,"Logistics"]
[1.9,"My company agrees to the Nexteer Standard terms to authorize suppliers to manufacture 2 weeks of material and procure/manufacture an additional 2 weeks of raw material/work-in-process (material authorization will total 4 weeks). All information beyond 4 weeks is for planning purposes only.  ",null,null,null,null,null,null,null,"Logistics"]
["1.10","My Company agrees to ship to releases.",null,null,null,null,null,null,null,"Logistics"]
[1.1100000000000001,"My Company can meet the Nexteer Label specification available at http://www.nexteer.com/supplier-portal/processes/shipping-and-labeling/.  A Sample label will be submitted for evaluation",null,null,null,null,null,null,null,"Logistics",null,null,null,null,null,null,null,null,"Link to Nexteer Label Requirements"]
[1.1200000000000001,"Are you financially stable?  Are you able to provide your current Financial Statement?  (e.g., Balance Sheet, Income Statement and Cash flow)",null,null,null,null,null,null,null,"Financial Stability"]
["SECTION 2:  SUPPLIER ASSESSMENT\nCOMPLETED BY SUPPLIER FOR SUPPLIER CAPABILITY & SELECTION REVIEW",null,null,null,null,null,null,null,null,"Category",null,"Supplier Response",null,null,null,"Mitigation Plan","Mitigation Plan Owner","Status\n(AQE/Buyer)","◄ See comments"]
[2.1,"Do you understand ASME Y14.5 Geometric Dimensioning and Tolerancing (GD&T) standard?",null,null,null,null,null,null,null,"Design"]
[2.2000000000000002,"Have you received the Design Severity & Sensitivity (DSS) document from Nexteer?",null,null,null,null,null,null,null,"Design"]
[2.2999999999999998,"Is the product adequately defined?  Have all technical specifications and documents been provided by Nexteer?",null,null,null,null,null,null,null,"Design"]
[2.4,"Can all of the drawing dimensions/requirements and product/material specifications be met?",null,null,null,null,null,null,null,"Design"]
[2.5,"Is your organization responsible for the design of this part?  If this part is a gray box design, identify the design items for which your organization is responsible vs. the design items for which Nexteer is responsible. Note: Your organization is fully responsible for any costs or damages attributed to flaws in your design items.",null,null,null,null,null,null,null,"Design"]
[2.6,"If applicable, will material certificate(s) have the standard and grade matching what is on the drawing?  If not, an Application Form of Material Substitution will be submitted for Nexteer review and approval. Form is located at http://www.nexteer.com/supplier-portal/processes/quality/",null,null,null,null,null,null,null,"Design"]
[2.7,"Have Intelex Problem Case Lessons Learned been reviewed between Nexteer AQE/SQE and your organization (i.e., for similar parts and processes), including any Global Look Across alerts?",null,null,null,null,null,null,null,"Design"]
[2.8,"If part is outsourced from Nexteer, have ME lessons learned from the part development been shared with your organization?  Have the following part documents also been shared (WI, PFD, PFMEA, CP, LSR, fixture and gaging details)?",null,null,null,null,null,null,null,"Design"]
[2.9,"Do you have any recommendations for improvements that may enhance the design, manufacturability, quality or value stream? ",null,null,null,null,null,null,null,"Design"]
["2.10","In the drawing block (in the lower right hand corner) is a template number populated? If no, contact your Nexteer AQE immediately. Examples of template numbers: CISTMPxxxx, HSTMPxxx, EPSTMPxxx, HPSTMPxxx, HPSGTMPxxxx, etc.",null,null,null,null,null,null,null,"Design"]
[2.11,"Has your organization's Manufacturing Capability Assessment (MCA) open items and action plans been included as additional considerations for this MAPP? Has the MCA been updated to reflect Nexteer AQE/SQE verification of improvements completed since the original MCA? \nNote: MCAs must be green (>=90 score) by PPAP time to AQE/SQE",null,null,null,null,null,null,null,"Quality System/Process"]
[2.12,"Where will you be manufacturing these parts (city/state/country)? ",null,null,null,null,null,null,null,"Manufacturing Facility"]
[2.13,"Is your manufacturing facility existing, expanding, new, or not built yet?   If existing or new, how long has this facility been in production?  If not built or expanding, when will construction be complete?",null,null,null,null,null,null,null,"Manufacturing Facility"]
[2.14,"Do you have adequate production capacity to produce the part? Adequate floor space?  Will you have to hire additional staff to support this program?",null,null,null,null,null,null,null,"Manufacturing Facility"]
[2.15,"Will all capital and tooling be in your final plant location(s) at the time of PPAP submission? If answer is No, provide a copy of the proposed plan for Nexteer review and agreement.**",null,null,null,null,null,null,null,"Manufacturing Facility"]
[2.16,"Is your workforce existing, expanding, new (but experienced) or new (inexperienced)? ",null,null,null,null,null,null,null,"Manufacturing Facility"]
[2.17,"Is your workforce affiliated with a Union?  If so, please state the Union Name and your Contract Agreement expiration.",null,null,null,null,null,null,null,"Manufacturing Facility"]
[2.1800000000000002,"Are these parts similar to other product that you currently make in production?",null,null,null,null,null,null,null,"Supplier Capability","Supplier Capability"]
[2.19,"Can you provide data (ie: capability studies) on similar parts that are in production?",null,null,null,null,null,null,null,"Supplier Capability","Supplier Capability"]
["2.20","Can you test the material as received or will it be done at an independent lab? If answer is No, external lab name should be nominated by supplier.",null,null,null,null,null,null,null,"Raw Material","Raw Material"]
[2.21,"Is standard material that you use in your plant?  Will special orders be required?  What is the lead time for the material required?",null,null,null,null,null,null,null,"Raw Material","Raw Material"]
[2.2200000000000002,"How do you manage different material in your plant?  What quality checks and/or controls do you have in place to ensure you use the right material?",null,null,null,null,null,null,null,"Raw Material","Raw Material"]
[2.23,"Is this part being outsourced from Nexteer (meaning has this part been manufactured in a Nexteer plant prior to this MAPP being completed)?  ",null,null,null,null,null,null,null,"Manufacturing"]
[2.2400000000000002,"If part is outsourced from Nexteer, has a Nexteer manufacturing plant site process walk and Nexteer PFMEA/Control Plan Review been scheduled?  Note: The Nexteer ME is the most knowledgeable in the effected part(s) manufacturing process history and must participate in the detailed MAPP review.",null,null,null,null,null,null,null,"Manufacturing"]
[2.25,"If part is outsourced from Nexteer, has an exit PPAP been provided from the Nexteer plant?",null,null,null,null,null,null,null,"Manufacturing"]
[2.2599999999999998,"If parts require heat treating, plating, coating/painting, casting, welding, soldering, or molding are the AIAG CQI special process assessments current as required in the NSRs? Complete any associated Technical Supplement(s) in question 2.54 as a part of this MAPP document. Provide the CQI documents to the AQE/SQE for review and verification in advance of the formal MAPP review.",null,null,null,null,null,null,null,"Processing","Outside Processing"]
[2.27,"Do you utilize an external source for any heat treating, plating, coating/painting or other finishing?  Is this source currently Approved by Nexteer?  Note that Nexteer may require our approval of a source. ",null,null,null,null,null,null,null,"Outside Processing","Outside Processing"]
[2.2799999999999998,"If applicable, how will the defined level of corrosion protection that is required be achieved?  Define the method.",null,null,null,null,null,null,null,"Corrosion Protection","Corrosion Protection"]
[2.29,"Do parts require cleaning?  What is your planned process?",null,null,null,null,null,null,null,"Part Cleanliness","Part Cleanliness"]
["SECTION 2:  SUPPLIER ASSESSMENT - CONTINUED\nCOMPLETED BY SUPPLIER FOR SUPPLIER CAPABILITY & SELECTION REVIEW",null,null,null,null,null,null,null,null,"Category",null,"Supplier Response",null,null,null,"Mitigation Plan","Mitigation Plan Owner","Status\n(AQE/Buyer)","◄ See comments"]
["2.30","What equipment will be required to process this part?  Is it dedicated or shared?  Is it existing, new, used, or rebuilt/refurbished? ",null,null,null,null,null,null,null,"Capital Equipment","Equipment"]
[2.31,"Will equipment be made in-house or at a sub-tier?  Where will it be made?",null,null,null,null,null,null,null,"Capital Equipment","Equipment"]
[2.3199999999999998,"What tooling will be required to make this part?",null,null,null,null,null,null,null,"Tooling","Tooling"]
[2.33,"Will tooling be made in-house or at a sub-tier?  Where will it be made?",null,null,null,null,null,null,null,"Tooling","Tooling"]
[2.34,"Are all of your gages in metric?  If not, is there a plan to get all gages in metric?",null,null,null,null,null,null,null,"Gages","Gages"]
[2.35,"Are there non-standard gages required to inspect & control this part?  If yes, identify these special gages in the \"Description of Control or Verification Method\" section below.",null,null,null,null,null,null,null,"Gages","Gages"]
[2.36,"Will gages be made in-house or at a sub-tier?  Where will it be made?",null,null,null,null,null,null,null,"Gages","Gages"]
[2.37,"Are there part specific gages that will need to be duplicated at your plant and at Nexteer in order to avoid potential measurement correlation issues?",null,null,null,null,null,null,null,"Gages","Gages"]
[2.38,"What test equipment will be required to test this part?  Is it special, existing, new, used, or rebuilt/refurbished? Describe the equipment and how it will be used & calibrated. If new or rebuilt, add lead time in time plan.",null,null,null,null,null,null,null,"Serial Test Equipment","Test Equipment"]
[2.39,"Is Design Validation (DV), Process Validation (PV) or Reliability testing equipment required at Supplier? If yes, what test equipment will be required to test this part? It is special, existing, new, used, or rebuilt/refurbished? If new or rebuilt, add lead time in timing plan",null,null,null,null,null,null,null,"DV, PV or Reliability Test Equipment","Test Equipment"]
["2.40","Describe the material handling that will be utilized during the manufacturing process; noting any potential risk to quality and traceability.",null,null,null,null,null,null,null,"Material Handling"]
[2.41,"Do you understand SoC IMDS reporting requirements?",null,null,null,null,null,null,null,"General","General",null,null,null,null,null,null,null,"Link to SoC Information"]
[2.42,"Do you have the ability to provide prototypes?  Manufactured in-house?  Do you have dedicated source that you can manage to provide prototypes?  If yes, describe your working relationship with your prototype source.",null,null,null,null,null,null,null,"Prototyping","Prototyping"]
[2.4300000000000002,"What is your scorecard color? Note: If Yellow or Red, be prepared to show evidence of your Quality Improvement Plan.                                                                                                                                                    ",null,null,null,null,null,null,null,"Quality"]
[2.44,"Are you ISO9001, TS16949, or IATF16949 registered?  When does your certification expire?  If not registered, do you have an adequate plan to be registered? If ISO9001 only, do you have a plan to meet IATF requirements? (Note: TS16949 Certs are only accepted until September 14, 2018)",null,null,null,null,null,null,null,"Quality Certification","Quality Certification"]
[2.4500000000000002,"Are there auditors that have the required qualifications to complete the mandatory AIAG assessments?",null,null,null,null,null,null,null,"Quality Certification","Quality Certification"]
[2.46,"Are the conditions (ie: temperature) in a measurement environment kept at a constant level?",null,null,null,null,null,null,null,"Quality Control","Quality Control"]
[2.4700000000000002,"If drawing or any referenced specification identify traceability requirements, what is your plan to comply to these requirements? The traceability plan, including evidence of the records system, must be fully established, available and approved by the Nexteer AQE prior to PPAP.",null,null,null,null,null,null,null,"Quality Control","Quality Control"]
[2.48,"What is the plan for lot size control?  (Please reference the Nexteer Supplier Requirements Manual).",null,null,null,null,null,null,null,"Quality Control","Quality Control"]
[2.4900000000000002,"Do you plan to rework or repair parts in production?  If yes, what rework or repair will you do?  How is this managed in your plant?  Any rework or repair procedure must be approved by Nexteer.",null,null,null,null,null,null,null,"Quality Control","Quality Control"]
["2.50","If parts are sent to an outside supplier for processing, what checks will be done on incoming parts?",null,null,null,null,null,null,null,"Quality Control","Quality Control"]
[2.5099999999999998,"Nexteer's goal is to use PPAP level parts for our initial machine run off (MQ1).  How much lead time will you require to be able to provide parts off of the production process (include lead time for raw material)? Note: Response should correspond with the timing entered in Section 9",null,null,null,null,null,null,null,"Timing","Timing"]
[2.52,"Confirm your lead time from Nexteer kickoff  to PPAP submission.  Does your lead time include time for debug and tooling rework / grooming loops? Note: Response should correspond with the timing entered in Section 9",null,null,null,null,null,null,null,"Timing","Timing"]
[2.5299999999999998,"What is your lead time for gage design, build, and completion of Measurement System Analysis (MSA)? Note: Response should correspond with the timing entered in Section 9",null,null,null,null,null,null,null,"Timing","Timing"]
[2.54,"What is your lead time for equipment/tooling/gage?  What is the long lead item? Note: Response should correspond with the timing entered in Section 9",null,null,null,null,null,null,null,"Timing","Timing"]
[2.5499999999999998,"What is your lead time for debug and tooling rework?",null,null,null,null,null,null,null,"Timing","Timing"]
["SECTION 2:  SUPPLIER ASSESSMENT - CONTINUED\nCOMPLETED BY SUPPLIER FOR SUPPLIER CAPABILITY & SELECTION REVIEW",null,null,null,null,null,null,null,null,"Category",null,"Supplier Response",null,null,null,"Mitigation Plan","Mitigation Plan Owner","Status\n(AQE/Buyer)","◄ See comments"]
[2.56,"Have you been directed by Nexteer to use a particular supplier for sub-components?",null,null,null,null,null,null,null,"Program Management","Program Management"]
[2.57,"Do you have a process and staff assigned to manage your suppliers?  Do you require a PPAP from all of your suppliers?  Provide a risk assessment for each supplier (product component and process) including PPAP level, timing for MAPP or equivalent, Nexteer support, etc....)",null,null,null,null,null,null,null,"Program Management","Program Management"]
[2.58,"Provide a site organizational chart available for review.",null,null,null,null,null,null,null,"Program Management","Program Management"]
[2.59,"Do you have the resources to support this business?  Are they dedicated or shared?   Do you have other new customer programs that you are managing that may affect your ability to manage this program? For this Nexteer program, provide a team composition and for each team member, the workload percentage.",null,null,null,null,null,null,null,"Program Management","Program Management"]
["2.60","What is the percent impact that this quoted business have on your capacity:  No impact, less than 20%, 20-50% or > than 50%?",null,null,null,null,null,null,null,"Program Management","Program Management"]
[2.61,"Complete all appropriate Technical Supplements for your commodity/process by selecting each individual supplement from the drop down box to the right.  Return to this drop down list for each selection"]
["SECTION 6:  KEY DATE INFORMATION\nTO BE COMPLETED/UPDATED BY BUYER "]
[]
["Tool Capacity Confirmation"]
[]
["Annual Tool Capacity",null,null,null,"Remarks","Remarks",null,null,null,null,null,null,null,null,null,"Annual Tool Capacity Definition"]
[]
["15% over Annual Tool Capacity",null,{"$f":"IF(ISBLANK(C85),\"\",C85*1.15)","v":""},null,"Remarks","Remarks",null,null,null,null,null,null,null,null,null,"15% over Annual Tool Capacity Definition"]
[]
["Nexteer Working Days per Year",null,null,null,"Remarks","Remarks",null,null,null,null,null,null,null,null,null,"Nexteer Working Days (per Year) Definition"]
[]
[]
["Nexteer Timing Confirmation"]
[]
["Kickoff Date",null,null,null,"Special Requirements",null,null,null,null,null,null,null,null,null,null,"Kickoff Date Definition"]
[]
["MQ1 Required Date",null,null,null,"Special Requirements",null,null,null,null,null,null,null,null,null,null,"MQ1/MQ2 Definition"]
[]
["Due Date for PPAP Submission to AQE",null,null,null,"Special Requirements",null,null,null,null,null,null,null,null,null,null,"Due Date for PPAP Definition"]
[]
["Run at Rate Date(s)\n(on or before)",null,null,null,"Special Requirements",null,null,null,null,null,null,null,null,null,null,"Run-at-Rate Definition"]
[]
["Nexteer Start of Production (SOP) Date",null,null,null,"Special Requirements",null,null,null,null,null,null,null,null,null,null,"Nexteer Start of Production Definition"]
[]
["Early Production Containment Exit Date",null,null,null,"Special Requirements",null,null,null,null,null,null,null,null,null,null,"EPC Definition"]
[]
[]
["SECTION 7:  SUPPLIER & NEXTEER APPROVALS"]
["▼Supplier Approvals▼",null,null,null,null,null,null,null,null,null,null,"▼ Nexteer Approvals ▼"]
[]
[]
["7A - Supplier Sign-off: Key Dates & Exception Approval\n\nSignature below signifies that Supplier agrees to the dates listed in Section 6 and will close any Open Status Issues listed in Sections 1, 2, 3 & 9 with Mitigation Plans owned by the Supplier.   Note:  One authorized signature is acceptable on behalf of the entire Supplier Organization provided that Section 5 Contact Information is completed.  Acceptable forms of signature: DocuSign electronic signature, Physical signature or approval email.",null,null,null,null,null,null,null,null,null,null,"7B - Nexteer Sign-off\n\nSignifies that Supplier is capable for sourcing and any open status issues have an acceptable mitigation plan\n**Note: If supplier answered \"No\" to question 2.14, Buyer and Program Manager sign-off is required."]
[null,null,null,null,null,null,null,null,null,null,null,"Does this MAPP contain any alternative control strategies to G1331 Attachment B?",null,null,null,null,null,"⍔"]
[null,null,null,null,null,null,null,null,null,null,null,"If Yes, AQE/SQE signature below signifies that a G1331 Approval Form (X1331) is completed, approved and attached to PMD by the AQE/SQE."]
["Title",null,"Name","Date",null,null,null,null,null,null,null,"Buyer** (sig)",null,null,"Buyer** (name)",null,"Buyer** (date)"]
["Sales (sig)",null,null,"Sales (name)",null,null,null,"Sales (date)",null,null,null,"Program Mgr** (sig)",null,null,"Program Mgr** (name)",null,"Program Mgr** (date)"]
["Quality (sig)",null,null,"Quality (name)",null,null,null,"Quality (date)",null,null,null,"PC&L (sig)",null,null,"PC&L (name)",null,"PC&L (date)"]
["Engineering (sig)",null,null,"Eng. (name)",null,null,null,"Eng. (date)",null,null,null,"Engr. (sig)",null,null,"Engr. (name)",null,"Engr. (date)"]
["Manufacturing (sig)",null,null,"Mfg (name)",null,null,null,"Mfg. (date)",null,null,null,"AQE/SQE in region of Supplier Mfg Location (sig)",null,null,"AQE/SQE in region of Supplier Mfg Location (name)",null,"AQE/SQE in region of Supplier Mfg Location (date)"]
[null,null,null,null,null,null,null,null,null,null,null,"ME (sig)",null,null,"ME (name)",null,"ME (date)"]
[null,null,null,null,null,null,null,null,null,null,"Optional Signature:","AQE/SQE in region of Nexteer Receiving Plant (sig)",null,null,"AQE/SQE in region of Nexteer Rec'g Plant (name)",null,"AQE/SQE in region of Nexteer Rec'g Plant (date)"]
[]
["NOTE: By signing this document, you are agreeing to ALL the details documented within this MAPP. Any changes to this agreement must be reviewed and reapproved by the AQE and the affected team member(s). (ie; changes to gaging, control methods, or sample size and frequency of inspection, etc. must be approved by the AQE and the PE)"]

{"sheet":"SECTION 3 - ASSESSMENT","index":4,"n_rows":335,"n_cols":25,"rows_kept":335,"cut":false,"hidden":false,"merged":[[4,16,5,16],[0,24,2,24],[2,0,2,1],[2,2,2,5],[2,9,2,10],[2,20,2,21],[2,12,2,13],[0,3,0,6],[4,10,5,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[3,0,3,23],[4,17,5,17],[2,17,2,19],[4,19,5,19],[4,20,5,20],[4,23,5,23],[4,22,5,22],[4,21,5,21],[4,18,5,18],[4,11,5,11],[4,15,5,15],[4,14,5,14],[4,12,4,13],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,9,5,9]]}
[{"$f":"\"Version: \"&TEXT(RevHistory!E1,\"0##\")","v":"Version: 032"},null,null,"Click here for an example of Section 3 completed appropriately",null,null,null,null,null,"Manufacturability Assessment and Process Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Useful\nLinks & Tips"]
[]
["  Part Description:",null,{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!C3:F3","v":"[Enter Part Name Here]"},null,null,null,null,"Part   Number:",null,{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!J3:K3","v":"[Enter PN Here]"},null,"Drwg Rev:",{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!M3","v":"[Enter Drwg Rev Here]"},null,null,null,null,"Supplier Name:",null,null,{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!O3","v":"[Enter Supplier Name Here]"},null,"   MAPP     \nRev Date:                         ",{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!R3","v":"[Enter Date]"}]
["SECTION 3:  MANUFACTURABILITY ASSESSMENT \nCOMPLETED BY SUPPLIER FOR SUPPLIER CAPABILITY & SELECTION REVIEW"]
["OP #","Process Concept / Process Steps","Road\nMap\nPrint #","Requirement / Dimension","Class","Special Char\n# on Drwg","Pass Through","Manufacturing Process Feasibility",null,"In-House or\nSub-Supplier Process","Commitment to Meet Required Process Indices","Description of Control or Verification Method\n(e.g. Xbar&R, Variable/Attribute Gage Description)","Detection Activity",null,"Process Control","Defect Handling","General Comments and/or Mitigation Plan(s)","Mitigation Plan(s) Owner Name","Included in EPC Plan?\nY/N","Required Capability Study\nY/N","Status","Control Verification","Required Initial Process Indices","Qualification Plan for PPAP"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sample Size & Frequency of Inspection","Detection Control"]
[null," "," "," ",null,null,null,null,{"$f":"IF(H7=\"Experience & Within Std Process Capabilities\",\"G\",(IF(H7=\"No Experience & Beyond Std Process Capabilities\",\"R\",(IF(H7=\"No Experience & Within Std Process Capabilities\",\"Y\",(IF(H7=\"Experience & Beyond Std Process Capabilities\",\"Y\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E7=\"STD4-8\",G7=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E7,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E7=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E7,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E7=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E7=\"STD4-8\",G7=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E7,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E7=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E7=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E8=\"STD4-8\",G8=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E8,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E8=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E8,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E8=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E8=\"STD4-8\",G8=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E8,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E8=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E8=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,{"$f":"IF(H71=\"Experience & Within Std Process Capabilities\",\"G\",(IF(H71=\"No Experience & Beyond Std Process Capabilities\",\"R\",(IF(H71=\"No Experience & Within Std Process Capabilities\",\"Y\",(IF(H71=\"Experience & Beyond Std Process Capabilities\",\"Y\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E72=\"STD4-8\",G72=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E72,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E72=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E72,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E72=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E72=\"STD4-8\",G72=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E72,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E72=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E72=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,{"$f":"IF(H135=\"Experience & Within Std Process Capabilities\",\"G\",(IF(H135=\"No Experience & Beyond Std Process Capabilities\",\"R\",(IF(H135=\"No Experience & Within Std Process Capabilities\",\"Y\",(IF(H135=\"Experience & Beyond Std Process Capabilities\",\"Y\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E136=\"STD4-8\",G136=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E136,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E136=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E136,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E136=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E136=\"STD4-8\",G136=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E136,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E136=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E136=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,{"$f":"IF(H199=\"Experience & Within Std Process Capabilities\",\"G\",(IF(H199=\"No Experience & Beyond Std Process Capabilities\",\"R\",(IF(H199=\"No Experience & Within Std Process Capabilities\",\"Y\",(IF(H199=\"Experience & Beyond Std Process Capabilities\",\"Y\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E200=\"STD4-8\",G200=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E200,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E200=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E200,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E200=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E200=\"STD4-8\",G200=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E200,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E200=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E200=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,{"$f":"IF(H263=\"Experience & Within Std Process Capabilities\",\"G\",(IF(H263=\"No Experience & Beyond Std Process Capabilities\",\"R\",(IF(H263=\"No Experience & Within Std Process Capabilities\",\"Y\",(IF(H263=\"Experience & Beyond Std Process Capabilities\",\"Y\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E264=\"STD4-8\",G264=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E264,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E264=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E264,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E264=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E264=\"STD4-8\",G264=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E264,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E264=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E264=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,{"$f":"IF(H327=\"Experience & Within Std Process Capabilities\",\"G\",(IF(H327=\"No Experience & Beyond Std Process Capabilities\",\"R\",(IF(H327=\"No Experience & Within Std Process Capabilities\",\"Y\",(IF(H327=\"Experience & Beyond Std Process Capabilities\",\"Y\",\"\")))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E328=\"STD4-8\",G328=\"Yes\"),\"Cpk =/> 1.67    Ppk =/> 1.33\",IF(LEFT(E328,3)=\"STD\",\"Cpk > 1.33    Ppk > 1.33\",(IF(E328=\"CL3\",\"Cpk =/> 1.33    Ppk =/> 1.33\",IF(LEFT(E328,2)=\"CL\",\"Cpk =/> 1.67    Ppk =/> 1.67\",IF(E328=\"\",\" \",\"Cpk =/> 1.67    Ppk =/> 1.33\"))))))","v":" "},{"$f":"IF(AND(E328=\"STD4-8\",G328=\"Yes\"),\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\",IF(LEFT(E328,3)=\"STD\",\"PPAP Checksheet & 5 pc dimensional layout\",IF(E328=\"CL3\",\"PPAP Checksheet, 5pc dimensional layout, gage studies & capability studies, if required\",IF(E328=\"\",\" \",\"PPAP Checksheet, 5 pc dimensional layout & capability/gage studies\"))))","v":" "}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]

{"sheet":"SECTION 4 - SUPPLIER PFD","index":5,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,13,0,15]]}
["SECTION 4:  SUPPLIER PROCESS FLOW DIAGRAM\nCOMPLETED BY SUPPLIER FOR SUPPLIER CAPABILITY & SELECTION REVIEW",null,null,null,null,null,null,null,null,null,null,null,null,"Return to Instructions"]
[]
["Paste sketch of the proposed Process Flow Diagram"]

{"sheet":"SECTION 5 - CONTACT LIST","index":6,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,0,3,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[7,0,7,3],[4,3,5,3],[34,1,34,3],[35,1,35,3],[31,0,31,3],[32,1,32,3],[33,1,33,3]]}
[null,null,null,"Return to Instructions"]
[]
[null,null,"Part Number:",{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!J3","v":"[Enter PN Here]"}]
["Section 5: APQP Project Contact List"]
[null,null,null,"Required for Supplier Capability & Selection Review"]
["Supplier Information - Completed for Supplier Capabilty & Selection Review"]
[]
["Manufacturing Location Information"]
["Supplier Name"]
["Supplier Mfg DUNS Code"]
["Manufacturing Address"]
["Supplier Contacts\nEnter (N/A) if not applicable","Supplier Name and Title","Supplier E-Mail Address","Supplier Office & Cell Phone Numbers"]
["Sales Contact"]
["Quality/APQP Contact"]
["Process Engineer"]
["Product Engineer"]
["Program Manager"]
["Plant Manager"]
["Plant Quality Manager"]
["Plant Quality Engineer"]
["1st Shift Contact"]
["2nd Shift Contact"]
["3rd Shift Contact"]
["Production Control & Logistics Contact"]
["Intelex Problem Case Responsibility"]
["Other:"]
["Other:"," "]
["Other:",null," "]
[]
["Nexteer Information - Completed by Buyer during the Design & Supplier Process Collaboration Activity"]
[]
["Nexteer Manufacturing Location Information"]
["Nexteer Plant Information"]
["Manufacturing Address"]
["PPAP Documents Submission","Documents to be submitted electronically to the AQE"]
["PPAP Part Shipping Information"]
["Nexteer Contacts\nEnter (N/A) if not applicable","Nexteer Name and Title","Nexteer E-Mail Address","Nexteer Office & Cell Phone Numbers"]
["Buyer"]
["AQE/SQE"]
["Purchasing Program Manager"]
["Product Engineer"]
["Program Manager"]
["Advanced PC&L"]
["Other:"]

{"sheet":"SECTION 8 - APQP OPEN ISSUES","index":7,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[7,9,7,10],[7,12,7,13],[3,2,3,4],[4,2,4,4],[5,2,5,4],[7,2,7,4],[7,5,7,6],[7,7,7,8],[8,2,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[9,2,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[10,2,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[11,2,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[12,2,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[13,2,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[14,2,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[15,2,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[16,2,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[17,2,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[18,2,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[19,2,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[20,2,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,2,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,2,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,2,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,2,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[25,2,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[26,2,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,2,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,2,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[29,2,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,2,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,2,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,2,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[33,2,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[34,2,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[35,2,35,4],[35,5,35,6],[35,7,35,8],[35,9,35,10],[36,2,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[37,2,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[38,2,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[39,2,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[40,2,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[41,2,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[44,2,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,2,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[46,2,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10]]}
["Section 8: APQP Open Issues"]
[]
[]
[null,"Supplier Mfg Location:",null,null,null,null,"Part Number(s):"]
[null,"Supplier Contact:",null,null,null,null,"Program(s):"]
[null,"SQE Contact:",null,null,null,null,"Part Name:"]
[]
["Issue No.","Issue Origin/Date","Issues \nDescription and/or Sketch",null,null,"Issue Owner Name",null,"Assigned Date/Status Date",null,"Action Plan",null,"Forecast Completion Date","Progress"]
[1,null,null,null,null,null,null,null,null,null,null,null,"Issue Identified","►"]
[2,null,null,null,null,null,null,null,null,null,null,null,"Action Plan Proposed","►►"]
[3,null,null,null,null,null,null,null,null,null,null,null,"Action Plan Implemented","►►►"]
[4,null,null,null,null,null,null,null,null,null,null,null,"Issue Resolved","►►►►"]
[5,null,null,null,null,null,null,null,null,null,null,null,null," "]
[6,null,null,null,null,null,null,null,null,null,null,null,null," "]
[7,null,null,null,null,null,null,null,null,null,null,null,null," "]
[8,null,null,null,null,null,null,null,null,null,null,null,null," "]
[9,null,null,null,null,null,null,null,null,null,null,null,null," "]
[10,null,null,null,null,null,null,null,null,null,null,null,null," "]
[11,null,null,null,null,null,null,null,null,null,null,null,null," "]
[12,null,null,null,null,null,null,null,null,null,null,null,null," "]
[13,null,null,null,null,null,null,null,null,null,null,null,null," "]
[14,null,null,null,null,null,null,null,null,null,null,null,null," "]
[15,null,null,null,null,null,null,null,null,null,null,null,null," "]
[16,null,null,null,null,null,null,null,null,null,null,null,null," "]
[17,null,null,null,null,null,null,null,null,null,null,null,null," "]
[18,null,null,null,null,null,null,null,null,null,null,null,null," "]
[19,null,null,null,null,null,null,null,null,null,null,null,null," "]
[20,null,null,null,null,null,null,null,null,null,null,null,null," "]
[21,null,null,null,null,null,null,null,null,null,null,null,null," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null," "]
[24,null,null,null,null,null,null,null,null,null,null,null,null," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null," "]
[29,null,null,null,null,null,null,null,null,null,null,null,null," "]
[30,null,null,null,null,null,null,null,null,null,null,null,null," "]
[31,null,null,null,null,null,null,null,null,null,null,null,null," "]
[32,null,null,null,null,null,null,null,null,null,null,null,null," "]
[33,null,null,null,null,null,null,null,null,null,null,null,null," "]
[34,null,null,null,null,null,null,null,null,null,null,null,null," "]
[35,null,null,null,null,null,null,null,null,null,null,null,null," "]
[36,null,null,null,null,null,null,null,null,null,null,null,null," "]
[37,null,null,null,null,null,null,null,null,null,null,null,null," "]
[38,null,null,null,null,null,null,null,null,null,null,null,null," "]
[39,null,null,null,null,null,null,null,null,null,null,null,null," "]
[40,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"SECTION 9 APQP Timeline","index":8,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,1,2,3]]}
[]
["Section 9:  APQP Timeline"]
[null,"NOTE TO SUPPLIER:  Please be prepared to discuss at the Supplier Capability and Selection Review"]
[null,"MAPP APQP TIMING EVENTS","# of days after Kickoff for START of activity","Duration (in days, 5 day work week)",null,"Weekly Duration (Calculated)"]
["1)","APQP Kickoff Meeting (Establish Program Review Frequency as established in the Supplier Kickoff Meeting)",null,null,{"$f":"C5+D5","v":0},{"$f":"IF(ISBLANK(D5),\"\",D5/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["2)","Lessons Learned Deep Dive (Including Prototype)",null,null,{"$f":"C6+D6","v":0},{"$f":"IF(ISBLANK(D6),\"\",D6/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["3)","Submit Final Packaging Proposal (Nexteer SPI Form) ",null,null,0,{"$f":"IF(ISBLANK(D7),\"\",D7/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["4)","Submit Substance Of Concern Documentation",null,null,{"$f":"C9+D9","v":0},{"$f":"IF(ISBLANK(D9),\"\",D9/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["5)","Compare DFMEA to initial Supplier PFMEA concept",null,null,0,""]
["6)","Design Review - Preliminary Special Characteristic Summary (SCS) ",null,null,0,""]
["7)","Raw Material Lead Time",null,null,0,""]
["8)","Review Preliminary PFD & PFMEA",null,null,0,""]
["9)","Review Preliminary Control Plan",null,null,0,""]
["10)","Review Subcontractor APQP Status (If applicable)",null,null,0,""]
["11)","Finalize Machinery Equipment Tool Design & Build (include Lead times for debug & tooling reworks/grooming loops)",null,null,0,""]
["12)","Gage Reviews- Design, Build, & Measure System Analysis (MSA)  ",null,null,0,""]
["13)","Finalize Supplier Operator Work Instructions & complete operator training ",null,null,0,""]
["14)","Build & Ship MQ1 Parts (Machine Qualification on Nexteer Equipment Vendor Floor)",null,null,0,""]
["15)","Finalize PFMEA  ",null,null,0,""]
["16)","Finalize Early Production Containment Plan",null,null,0,""]
["17)","Finalize Pre-Launch & Production Control Plan",null,null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(#REF!),\"\",#REF!/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":{"$error":"#REF!"}}]
["18)","Manufacture and Ship PPAP Parts & MQ2 Parts (Machine qualification on Nexteer Plant Floor)",null,null,{"$f":"C23+D23","v":0},{"$f":"IF(ISBLANK(D23),\"\",D23/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["19)","Complete Process Capability Studies",null,null,{"$f":"C24+D24","v":0},{"$f":"IF(ISBLANK(D24),\"\",D24/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["20)","Submit Supplier PPAP (Part of Phase 3)",null,null,{"$f":"C25+D25","v":0},{"$f":"IF(ISBLANK(D25),\"\",D25/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["21)","Conduct Run @ Rate (Determine Supplier or Nexteer Monitored)",null,null,{"$f":"C26+D26","v":0},{"$f":"IF(ISBLANK(D26),\"\",D26/(MAX($D$5:$D$26)/((MAX($E$5:$E$25))/5)))","v":""}]
["22)","Launch Readiness Audit (F1058 Process Audit Production Readiness Form)"]

{"sheet":"Coating & Plating ","index":9,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,null,"Coating & Plating Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Are you familiar with the OEM's specifications?"]
[2,"Do you certify each lot of material will meet these specifications?"]
[3,"What finishing specification can you adhere to?"]
[4,"Is the lab you use certified? To what certification?"]
[5,"How often do you send parts out for certification?"]
[6,"What type of cleaning process do you utilize?"]
[7,"Do you utilize automatic processing equipment?"]
[8,"Are temperature controllers automatic? "]
[9,"What internal testing capabilities do you have for:"]
["9a","Chemical concentrations"]
["9b","Bath temperatures"]
["9c","Oven/furnace temperatures"]
["9d","Product thickness"]
["9e","Adhesion"]
["9f","Salt Spray"]
["9g","Coating weight"]
[10,"Do you have calibration procedures for all test equipment?"]
[11,"Is your equipment calibrated using NIST traceable standards?"]
[12,"Are your calibration records available for the last twelve months?"]
[13,"Are process control charts (i.e., trend charts) used as tool to control the process?"]
[14,"How do you record the data?"]
[15,"Can your operators interpret the method of recording the data?"]
[16,"Who reviews the data and how often?"]
[17,"Do you have a written process specification?"]
[18,"Does the specification describe the current process?"]
[19,"How do you communicate changes to specifications within your organization?"]
[20,"Are you aware that ANY changes to the process must be pre-approved by Nexteer?"]
[21,"Do you have an equipment preventive maintenance program?"]
[22,"Does the PM specify frequency and requirements?"]
[23,"Does the PM include calibration for pyrometers and testing equipment?"]
[24,"How often are consumable tanks replaced?"]
[25,"How is this determined when consumable tanks should be replaced?"]
[26,"How often are process tanks cleaned?"]
[27,"Are there records to verify tank cleaning?"]
[28,"Is there a plan to identify and contain material in process for equipment malfunctions?"]
[29,"Is there a procedure to contain non-conforming material?"]
[30,"Is everyone aware of the material specification?"]
[31,"Is there a clearly identified containment area? Is it under lock and key?"]
[32,"Who has the key to the containment area?"]
[33,"How is scrap identified and disposed from the process?"]
[34,"How is material identified at all steps in the process? - especially incoming mat'l?"]
[35,"How often is material inspected during the process?"]
[36,"What parameters are monitored? Who does the monitoring?"]
[37,"Are job instruction guides posted for each task in the process?"]
[38,"Is there a training program documented?"]
[39,"Are training records available?"]
[40,"Are there regular employee meetings held?"]
[41,"How are changes communicated to all employees?"]
[42,"Do you have a contingency plan in place for equipment failure?"]
[43,"Have you received any environmental violations?"]
[44,"How do you dispose of hazardous waste?"]
[45,"Can the supplier that disposes hazardous waste be contacted?"]
[46,"What municipality do you discharge to?"]
[47,"Can the municipality be contacted?"]

{"sheet":"Diecast Aluminum  & Magnesium","index":10,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[null,null,"Diecast Aluminum & Magnesium Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Is there a possibility of mixing alloys in this facility? How do you segregate the alloys to prevent a mix?"]
[2,"How is charge and re-melt segregated?"]
[3,"How is incoming material checked? Is it certified?"]
[4,"What type of melting furnace is used and how many? How is the temperature and chemistry controlled?"]
[5,"How is the metal transferred to a holding furnace at the diecast machines (ladle, launder, etc.)?"]
[6,"How is the chemistry checked at the holding furnace? Whatis the frequency?"]
[7,"How is the microstructure checked? Are the lab and operator(s) qualified?"]
[8,"How are mechanical properties checked? Are test bars cast or machined? Is data stored and readily available?"]
[9,"How are casting lots defined? Nexteer requires one shift maximum"]
[10,"How is melt de-gassed/fluxed? How is the process verified i.e. density check, sectioning?"]
[11,"How is metal transferred to diecast machine shot sleeve (ladle, pump, etc.)? What is done to minimize inclusions?"]
[12,"What type of diecast machine will be used - horizontal or vertical / cold or hot chamber? "]
["12a","Do you plan on doing a partial PPAP (X-ray samples/strength testing if applicable/EPC) for each diecast machine used?"]
[13,"What tonnage diecast machine will be used? "]
["13a","What is max. shot intensification pressure / cavity pressure?"]
["13b","Provide calculation for machine size."]
["13c","Provide PQ^2 chart."]
[14,"Is the machine fully automated such as metal ladling, die lube, casting extraction and trim?"]
["14a","For the die lube application is a fixed manifold or flexible nozzles used?"]
["14b","Are shot parameters monitored i.e. cycle time, slow shot velocity, fast shot velocity, intensification pressure, biscuit length, slow shot distance, and intensification rise time?"]
["14c","For critical shot part parameters out of specification is the shot automatically scrapped? Is there a limit set to stop the process for continuous rejects?"]
["14d","How many shots are auto discarded for cold shots at the start of the process? How many shots are auto discarded for significant stoppages? How were these numbers arrived at?"]
["14e","Are castings water quenched or ait cooled prior to trimming?"]
["14f","Describe your mold release agent application system and controls."]
["14g","After shot extraction from the mold is the presence of the vents, runner system & cavities checked on the shot so as not to damage the mold in the next shot? If not present is the diecast machine automatically shut down?"]
[15,"How is biscuit length controlled?"]
[16,"Do you have vacuum assist capability? Will it be applied to this part?"]
[17,"Do you have squeeze pin capability? Will it be applied to this part?"]
[18,"Are dies designed and built in house or outside?"]
["18a","If outside what type of die certification (material, heat treatment & dimensional) do you get from the die shop?"]
[19,"Do you have a die concept design and has it been reviewed for manufacturablity / durability prior to build?"]
[20,"Has the casting machined finish stock been reviewed and optimized for minimum amount to reduce exposed porosity?"]
[21,"What die material is used? What is the expected die life in shots?"]
[22,"How many dies and cavities per die are planned? How many slides and core pulls?"]
[23,"How many net pieces per day are expected for one die / machine?"]
[24,"What casting identification will be on the part (cavity number, shift, date etc.)?"]
[25,"Are you planning on using core interlocks? Are you planning on inserting any areas of the mold for PM purposes?"]
[26,"What simulation reports are you doing for this part? i.e. mold filling gare velocity plots & animation, temperature plots & animation, air pressure/entrapment plots, fraction solid plots & aniimaiton, porosity plots, solidification time plots, evidence that casting  anomalies/residual tensile stresses do not overlay FEA high stress regions and evidence that casting distortion plots do not result in dimensional non-conformances."]
[27,"Are gate, ejector pins and vent locations defined?"]
[28,"What type of die cooling system is used (water, oil or combined)? If water is used is it treated? What type of die temperature methods / controls are used? Are flow meters used in each water line?"]
[29,"How is tooling managed? What are the typical number of shots for inspection, re-furbish and replacement molds? How were replacement dies quoted?"]
[30,"For all dies utilizing gage elements (i.e. balls or cones), is the die inserted in these areas to provide for easy maintenance?"]
[31,"Do you have x-ray capability in house? If done on the outside what is the frequency and turn around time?"]
["31a","Are you planning on using it during the development of the PPAP process?"]
["31b","Are you going to use it in production?"]
["31c","Are operator(s) certified to a standard i.e. NA ASNT-TC-1A or EN 45013 and EN 473?"]
["31d","Describe your plan for the image settings and porosity detection."]
["31e","Do you have image retention capability?"]
[33,"Do you have stress relieve/heat treating capability in house or outside?"]
[34,"Do you have shot blast capability? Was it included in the quote?"]
[35,"Do you have leak test capability (air decay, water dunk) with a master? Was it included in the quote for this part if applicable?"]
[36,"Are you planning on using impregnation in your process? If yes, why?"]
[37,"Are there scrap reconciliation records for the entire process?"]
[38,"Are you planning on doing a DOE to optimize the critical shot parameters for this part?"]
["38a","Are you planning on doing a verification run on shot parameter limits?"]
[39,"Are you planning on using a dedicated die cast machine? If not, what are your plans?"]
[40,"In the trimming operation is there a sensor to determine if the part(s) is located properly?"]
["40a","How is scrap removed from the trim tool and how is it verified to assure proper operation?"]
[41,"Are you planning on utilizing a die penetrant with black light inspectiion for cracked parts during the launch phase?"]

{"sheet":"Diecast Zinc","index":11,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,null,"Diecast Zinc Technical Supplement"]
[null,null," "]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"What alloys do you typically cast? Do you have experience with Accuzinc?"]
[2,"How is the charge material, re-melt and different alloys segregated?"]
[3,"How is incoming material checked? Is it certified?"]
[4,"What type of melting furnace / process is used?"]
[5,"How is metal transferred to holding furnace at the diecast machines (ladle, launder, etc.)?"]
[6,"How is chemistry checked at melting furnace and diecast machines? What frequency and is it SPC charted?"]
[7,"How are mechanical properties checked? Are test bars cast or machined? Is data stored and readily available?"]
[8,"How are casting lots defined (hours, pieces, shift)?"]
[9,"What tonnage diecast machine will be used? What type horizontal or vertical / cold or hot chamber? Is it fully automated such as die lube and casting extraction and trim? If not automated is die lube manual, fixed manifold or flexible nozzles? "]
[10,"What is done to prevent damage from ejection?"]
[11,"How is metal transferred to diecast machine shot sleeve (ladle, pump, etc.)? What is done to minimize inclusions?"]
[12,"What is the max. shot intensification pressure and cavity pressure?"]
[13,"How is the biscuit length controlled?"]
[14,"Are dies designed and built in house or outside?"]
[15,"Do you have tooling layout, casting layout and inspection capability using math data and 2D drawings? What type of CMM is used?"]
[16,"What die cavity material is used?"]
[17,"How many cavities are planned and number of slides and core pulls?"]
[18,"What casting identification will be on the part (cavity number, shift, date etc.)?"]
[19,"Do you have core interlock capability? Do you have cast insert capability?"]
[20,"Do you have die fill simulation capability in house or outside? Will it be applied to this part?"]
[21,"Are gate and vent locations defined?"]
[22,"What type of die cooling system is used (water, oil or combined)? If water is used is it treated? What type of die temperature methods / controls are used? Are flow meters used?"]
[23,"How is tooling controlled? What are the typical number of shots for inspection, re-furbish and new? How was replacement dies quoted?"]
[24,"Do you have x-ray capability in house or outside? Is it certified? Is it film, digital or real time?"]

{"sheet":"Ductile Iron","index":12,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,null,"Ductile Iron Technical Supplement"]
[null,null," "]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"What type of charge material is used? What type of checks are made? Is the material certified? How is it segregated? Is de-sulfurization required after melting?"]
[2,"What type of melting unit and system is used?"]
[3,"What method is used for magnesium inoculation (sandwich, tundish ladle, Fischer process etc.)? Do you monitor Mg residual?"]
[4,"What control / system is used for fade prevention (such as timer, nodularity coupon etc.)? What is your control limit for % nodularity? What traceability system and documentation is used? How is rejected material controlled and disposed of?"]
[5,"What type of pouring system is used? What method is used for post inoculant (Fe, Si). What is used to control head height? How is pour temperature controlled?"]
[6,"How is chemistry controlled at melt, holding and pour furnace? Are SPC charts used? Is data readily available? What  is used for traceability?"]
[7,"How is microstructure checked and where in the process?"]
[8,"What tests are performed and how for mechanical properties? Are test bars cast or machined?"]
[9,"How are lots defined?"]
[10,"What type of molding process is used (greensand or shell)?"]
[11,"What type of molding equipment is used (Disa, SPO, Osborne etc.)? "]
[12,"How is sand monitored and controlled? Are sand checks documented and available for problem solving?"]
[13,"Do you have coremaking and core setting capability? What type of coremaking (coldbox, hotbox etc.)?"]
[14,"Is a core required or planned for this part? If yes are the coreprints designed to maintain dimensional control?"]
[15,"Is tooling designed and built in house or outside? What material is used for the patterns? How many cycles are planned for maintenance, re-furb and new?"]
[16,"Do you have tooling layout, casting layout and inspection capability using math data and 2D drawings? What type of CMM is used?"]
[17,"How many cavities are planned for this part (both pattern and corebox if required)?"]
[18,"What casting identification will be on the part (pattern number, core number, shift, date etc.)?"]
[19,"Do you have mold fill and solidification simulation capability. Was it applied to this part?"]
[20,"Has the gating system been defined along with gate locations? Are filters used?"]
[21,"What method / system is used for gate and fin removal?"]
[22,"Do you have x-ray capability in-house or outside? What type film, digital or realtime?"]
[23,"Do you have heat treat capability?"]
[24,"If heat treat is required what process is used and how is it controlled and monitored? How are lots defined?"]
[25,"How often and where are BHN checks made?"]

{"sheet":"Electrical ","index":13,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,null,"Electrical Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Is the environment appropriate in keeping the machine accuracy(vibration, heat, dust, etc.)?"]
[2,"Will the product get damaged when put in the shooter?"]
[3,"Is tooling controlled by the person in charge of the line or centrally controlled?"]
[4,"Contamination:"]
[5,"* What is the required level of cleanliness?"]
[6,"* How do you plan to avoid contamination?"]
[7,"* What are the possible sources of contamination?"]
[8,"Are there any noise issues?"]
[9,"Are there any test connectors?"]
[10,"Will there be repairs?"]
[11,"How will sharp edges be addressed?  If parts will be deburred is bending a potential?"]

{"sheet":"Fastener ","index":14,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,null,"Fastener Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Is the cutting process of the material fully understood and controlled? How is the cutter maintained?"]
[2,"How do you keep track of the quality of the first trial product?"]
[3,"How and what do you inspect for incoming materials?"]
[4,"Is the environment appropriate in keeping the machine accuracy(vibration, heat, dust, etc.)?"]
[5,"How is tooling controlled and maintained(by person in charge of the line) or centrally controlled?"]
[6,"Doyou have two and three dimensional stamping technology?"]
[7,"Are there any built-in systems that can detect cracks or defects in the punch or tooling?  Is so, how do you verify that the systems are working properly? Who does the system inspection, and how often?"]
[8,"Do you sort the final product for mixed fasteners and other defects?"]
[9,"How is the tooling maintained?"]

{"sheet":"Machined Part ","index":15,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,null,"Machined Part Technical Supplement"]
[null,null," "]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Do you understand that PPAP is machine specific?"]
[2,"Where do you buy raw materials?"]
[3,"How are incoming materials inspected?"]
[4,"Is capitol equipment dedicated for this part? If equipment is existing, what will be the added % usage? How much time will be required for changeover? "]
[5,"How many different kinds of products can be manufactured in the same line?"]
[6,"Do you produce similar parts today with similar tolerances?"]
[7,"What is your FTQ on similar parts? What is your customer PPM?"]
[8,"Define in the Process Flow Diagram how many machines are required for each operation."]
[9,"How many fixtures are there for each machine and load?"]
[10,"How is traceability attained for each machine, fixture and date?"]
[11,"Provide machining sequence chart for each operation."]
[12,"Is the environment appropriate in keeping the machine accuracy (vibration, heat, dust, etc.)? Is thermal compensation required and used?"]
[13,"Is the cutting process of the material fully understood and controlled? How is the cutter maintained?"]
[14,"What is the expected cutter exchange cycle?"]
[15,"Do you expect part distortion due to clamping?"]
[16,"How will machining chips be removed from the part?"]
[17,"How will you provide a burr free part if required?"]
[18,"How will you apply rust inhibitor for a ferrous part?"]
[19,"How will you provide a dry part?"]
[20,"What porosity specification will be used to evaluate parts after machining?"]
[21,"Is the temperature of the measurement room controlled appropriately if applicable?"]
[22,"Do you have a roundness measurement machine?"]
[23,"Is leak test required? If yes what type will be used (air decay, water dunk)?"]
[24,"In machining fixtures, is there a part seated sensor (back checked in logic for an off condition) to make sure the part is located correctly in the fixture prior to machining?"]

{"sheet":"Plastic Molding ","index":16,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,"Plastic Molding Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"What are your in house testing abilities (i.e. material analysis and molded part analysis)? Is an outside accredited lab used for any testing that is required?"]
[2,"For Resins and Polymers, are Tier II suppliers certified?"]
[3,"What percent of regrind is used? If the percent is not on the Nexteer drawing, then the proposed percent needs to be evaluated prior to PPAP. How will the regrind material be handled and stored?"]
[4,"How do you keep track of the quality of the first trial product?  Are first trail samples retained during APQP for later MSA/GR&R ppap purposes?"]
[5,"Is the environment appropriate in keeping the machine accuracy(vibration, heat, dust, etc.)?"]
[6,"What is the % of yield rate?"]
[7,"Is the material and material supplier currently approved for the Nexteer print material spec.?"]
[8,"Is the process for removing products from the machines automated?"]
[9,"What is the percentage of in-house versus outsourcing of tooling design and concept?"]
[10,"How is tooling controlled and maintained(by person in charge of the line or centrally controlled?)"]
[11,"Are there a lot of burrs on the product? (relates to insert molding)"]
[12,"What is the current condition/status of the equipment?"]
[13,"Do you have the ability to shape using two or more kinds of materials?"]
[14,"How is damage to product prevented from ejection? Packaging?"]
[15,"What are the raw material drying controls to ensure that the material is dry enough? Is the moisture content checked after drying? How is the dryer system set up (i.e. centralized, shared or dedicated)?"]
[16,"How many materials(compounds) does the supplier handle?"]
[17,"Are you capable of manufacturing products with inserts?"]
[18,"Will cavity pressure sensors be implemented for this product at PPAP?"]
[19,"What type(s) of equipment error-proofing is to be implemented for PPAP?  Please detail."]
[20,"For multiple assembly operations, will all processes be fully in place for the initial PPAP submission date?"]
[21,"Are quick mold change practices utilized?"]
[22,"What controls or monitoring techniques are in place to ensure that the melt is at the proper temperature in the barrel, at the nozzle, and in the mold cavity?"]

{"sheet":"Powdered Metal","index":17,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,null,"Powdered Metal Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"How do you prevent contamination of powder material in the hopper?"]
[2,"Is there continuous flow of powder from the hopper to the tube and press?"]
[3,"Does the powder shoe receive regular maintenance?  "]
[4,"Is there a possibililty that could cause green cracks from press to ejection, to conveyor, to deburr operation?"]
[5,"At compacting operation how do you that confirm density requirements are met?"]
[6,"Prior to sintering are there controls in place to minimize or protect against green cracks during part handling, part staging, in process dunnage, etc"]
[7,"Is there a method/system to ensure the proper copper wafer or ring is installed and installed correctly?"]
[8,"If copper infiltration is required, do you have a back up sinter belt"]
[9,"How do you control distortion or flatness in the sinter furnace?"]
[10,"Do you have a recent CQI-9 assessment or similar process certification for the sintering process?"]
[11,"How is flatness controlled?"]
[12,"How do you control the part density throughout the part thickness?  Is there a process to pull samples for each location?  Is the frequency adequate?  Is there a reaction plan for out of print conditions"]
[13,"How do you control the net formed features? "]
[14,"Is there a method used to check for green cracks?"]
[15,"If you perform Magnetic Particle inspection did you verify that the inspector has passed a vision and color blindness test. "]
[16,"Do you check for residual magnetism?"]
[17,"Do you have a method to ensure that no tumbling media is lodged in the part?"]

{"sheet":"Press Fit","index":18,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,null," Press Fit Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Does error proofing exist for the presence & orientation if applicable for all parts? Look for the error proofing masters and a check sheet for their function."]
[2,"Does the equipment check and record the press load and displacement  profile for each assembly? Look for the record. If not present then the load and displacement profile must be added for all parts with a severity of 9 or 10. For severities of less than 9 other methods may be used."]
[3,"Is data for critical dimensions retained for length of program +5 years on customers except for BMW which requires +15 years? Look for stored data by date.If not present for parts with severities of 8, 9 or 10, then it must be added."]
[4,"For displacement monitoring how is it calibrated and how often? Look for displacement masters and frequency of checking."]
[5,"How is the load cell calibrated and how often? Look for method(another certified load cell) and frequency(100,000 cycles or as suggested from load cell manufacturer) on the contol plan"]
[6,"How are defective parts handled? Refer to G-1331 attachment E in the MAPP document."]
[7,"Are rejected assemblies reworked? On rejected parts no rework is permitted unless G-1331 Attachment E allows it. Rework must be approved by the Nexteer AQE/SQE."]
[8,"If the machine cycle is interrupted are parts rejected? In the case of a cycle interruption the parts are not to be reused unless G-1331 Attachment E allows it. Rework must be approved by the Nexteer AQE/SQE."]
[9,"For situations that may involve bearing cracking or peeling during the pressing operation do you use a video camera or other method to monitor the operation?"]

{"sheet":"Projection Welding ","index":19,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,null,"Projecting Welding Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Do you have process Limits on the weld current? ( Not just a target value) "]
[2,"Do you have process limits on the weld time?  (Not just a target value)"]
[3,"Do you use a weld monitor for the applied power?  "]
[4,"Do you use a weld signature with ramp up, min, max and ramp down?"]
[5,"If set to max power (current) at max time, will it create a burn through condition?"]
[6,"Is the electrode design documented on a tooling print?"]
[7,"Is the electrode replacement / resurfacing tied to specific number of welds?  (10,000 is a good starting point if nothing else is known)"]
[8,"Is the position of the component nests and weld fixtures controlled within limits?"]
[9,"Are component nests and weld fixtures documented on tooling prints?"]
[10,"Do you use visual scoring or equivalent for the heat affected zone?"]
[11,"Is there a nondestructive method to view both sides of the weld?  "]
[12,"Is a weld section analysis done at set up and every hour there after?  "]
[13,"Is there an in-process gauge to check the as welded position of the subassembly?   "]
[14,"Do you maintain an FTQ chart for weld rejects?"]
[15,"Are FTQ Alarm limits set to \"1\" reject piece for non-chronic failures?"]
[16,"Do you routinely do tear down analysis of good parts looking for variation?"]
[17,"If the welded assembly carries fluid, is the subassembly 100% leak tested?"]
[18,"Is the leak test done prior to plating or coating ?"]
[19,"Do you have a divisional technical center or product development center with additional resources?  If so, what types of equipment and testing capabilities do you have and what types of technical personnel do you have?"]
[20,"Explain what you define as a “lot” of material for the various areas of their process (incoming lot of material, lot of heat treat, etc)."]
[21,"Do you currently produce any structural components for Nexteer or other customers?"]
[22,"What types of error proofing are used?"]
[23,"Do you have a CQI-15 welding assessment?"]

{"sheet":"Rubber ","index":20,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,null,"Rubber Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Who will be mixing the rubber material and at what location? Are the curatives added to the compound at the molding site?"]
[2,"What is the traceability system that is used from the mixing process to the shipping of the final product to the customer?"]
[3,"Do you have a test facility for rubber (both raw and finished material)? What type of testing is done? What is the frequency of testing?"]
[4,"Do you have the ability to check parts for mechanical properties (hardness, elongation, modulus, etc.) at the manufacturing site?"]
[5,"Do you have equipment to check the rubber parts for IRHDM hardness? (Required when part section is 3mm or less)"]
[6,"Is there a shelf life of the material?  Also explain control of material expiration and how you follow the FIFO system for this material."]
[7,"What kind of error proofing is in place to make sure that right material/ ingredient is used?"]
[8,"What type of molding process will be used (i.e. injection molding, compression molding, etc)? If compression molding, will loading boards be used?"]
[9,"How do you eliminate voids/burns/excessive flash?"]
[10,"What kind of controls are in place to alert the operator should there be excessive temperature variation in the mold?"]
[11,"Are cleaning and other PM work done in house? If not where?"]
[12,"Do you utilize a quick tool change over process?"]
[13,"How do you deflash the parts?"]
[14,"Do you have equipment error proofing installed for the initial PPAP run through production?"]
[15,"Does the proposed compound flow well in the tool?  Is the material sensitive to scorching?"]
[16,"Can the compound ingredients be obtained from more than one source?"]
[17,"Does this part require a post cure operation?"]

{"sheet":"Squeeze Cast","index":21,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,null,"Squeeze Cast Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"What alloys do you typically cast and heat treat?"]
[2,"How is charge material, re-melt and different alloys segregated?"]
[3,"How is incoming material checked? Is it certified?"]
[4,"What type of melting furnace / process is used?"]
[5,"How is metal transferred to holding furnace at squeeze cast machines (ladle, launder, etc.)?"]
[6,"How is chemistry checked at melting furnace and squeeze cast machines? What frequency and is it SPC charted?"]
[7,"How is microstructure checked? Is the lab and operator(s) certified?"]
[8,"How are mechanical properties checked? Are test bars cast or machined? Is data stored and readily available?"]
[9,"How are casting lots defined (hours, pieces, shift)?"]
[10,"How is the melt de-gassed? How and when is density checked?"]
[11,"What tonnage squeeze cast machine will be used? What type horizontal or vertical / cold or hot chamber? Is it fully automated such as die lube and casting extraction and trim? If not automated is die lube manual, fixed manifold or flexible nozzles? Are castings air cooled or quenched?"]
[12,"How is metal transferred to squeeze cast machine shot sleeve (ladle, pump, etc.)? What is done to minimize inclusions?"]
[13,"What is max. shot intensification pressure and cavity pressure?"]
[14,"How is biscuit length controlled?"]
[15,"What type of die lubricant is used? What will be done to prevent die lube inclusions? Do you plan on a fixed lube manifold? Is the die lube abrasive and if yes what controls will be in place to monitor nozzle wear?"]
[16,"Do you have squeeze pin capability? Will it be applied to this part?"]
[17,"Are dies designed and built in house or outside?"]
[18,"Do you have tooling layout, casting layout and inspection capability using math data and 2D drawings? What type of CMM is used?"]
[19,"What die cavity material is used?"]
[20,"How many cavities are planned and number of slides and core pulls?"]
[21,"What casting identification will be on the part (cavity number, shift, date etc.)?"]
[22,"Do you have die fill simulation capability in house or outside? Will it be applied to this part?"]
[23,"Are gate and vent locations defined?"]
[24,"What type of die cooling system is used (water, oil or combined)? If water is used is it treated? What type of die temperature methods / controls are used?"]
[25,"How is tooling controlled? What are the typical number of shots for inspection, re-furbish and new? How was replacement dies quoted?"]
[26,"Do you have x-ray capability in house or outside? Is it certified? Is it film, digital or real time?"]
[27,"Do you have heat treat capability in house or outside? Do you have a metallurgist on site?"]
[28,"What studies have been done to optimize mechanical properties? What is the audit frequency and part selection plan? What error proofing is in place for each step in the heat treat process?"]
[29,"What traceability is used for heat treat lots. What size are lots?"]
[30,"How often is the temperature profile of the furnaces checked?"]
[31,"Do you have die penetrant capability such as Zyglo?"]
[32,"Do you have shot blast capability? Was it included in the quote?"]
[33,"Do you have leak test capability (air decay, water dunk)?"]
[34,"Do you have impregnation capability? Is it planned for this part and if yes why?"]

{"sheet":"Grey Iron","index":22,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,null,"Grey Iron Technical Supplement"]
[null,null," "]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"What type of charge material is used? What type of checks are made? Is the material certified? How is it segregated? "]
[2,"What type of melting unit and system is used?"]
[3,"What type of pouring system is used? What method is used for post inoculant (Fe, Si). What is used to control head height? How is pour temperature contolled?"]
[4,"How is chemistry controlled at melt, holding and pour furnace? Are SPC charts run? Is data readily available? What is used for traceability?"]
[5,"How is microstructure checked and where in the process?"]
[6,"What tests are performed and how for mechanical properties? Are test bars cast or machined?"]
[7,"How are lots defined?"]
[8,"What type of molding process is used (greensand or shell)?"]
[9,"What type of molding equipment is used (Disa, SPO, Osborne etc.)? "]
[10,"How is sand monitored and controlled? Are sand checks documented and available for problem solving?"]
[11,"Do you have coremaking and core setting capability? What type of coremaking (coldbox, hotbox etc.)?"]
[12,"Is a core required or planned for this part? If yes are the coreprints designed to maintain dimensional control?"]
[13,"Is tooling designed and built in house or outside? What material is used for the patterns? How many cycles are planned for maintenance, re-furb and new?"]
[14,"Do you have tooling layout, casting layout and inspection capability using math data and 2D drawings? What type of CMM is used?"]
[15,"How many cavities are planned for this part (both pattern and corebox if required)?"]
[16,"What casting identification will be on the part (pattern number, core number, shift, date etc.)?"]
[17,"Do you have mold fill and solidification simulation capability. Was it applied to this part?"]
[18,"Has gating system been defined along with gate locations? Are filters used?"]
[19,"What method / system is used for gate and fin removal?"]
[20,"Do you have x-ray capability in-house or outside? What type film, digital or realtime?"]
[21,"Do you have heat treat capability?"]
[22,"If heat treat is required what process is used and how is it controlled and monitored? What defines a lot?"]
[23,"How often and where are BHN checks made?"]

{"sheet":"Stamping  1 of 2","index":23,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,null,"Stamping Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Do you use a single or progressive die?"]
[2,"Is the Die a multiple part out Die (ie. Two parts per stroke)?"]
[3,"In the multiple part out die, is the part marked so that you know which position the part is from inside the die?"]
[4,"What is the press tonnage and how many of that size are in the  facility?"]
[5,"What variable gaging will be used?"]
[6,"What is your contingency plan when the machines/presses break down?  Will the replacement press be bigger?  Smaller?  Will they plan to PPAP it as a back-up?"]
[7,"Will you keep the first and last piece and web until the next run?"]
[8,"Do you have the ability to contain parts properly until the batch is \"certified\"?"]
[9,"Discuss the direction of the punching in the die and in the tapping operation if applicable. Will burrs be an issue?"]
[10,"How will sharp edges be addressed?  If parts are deburred is bending a potential?"]
[11,"Do current products have a lot of burr issues? "]
[12,"How many different kinds of products can be produced on the same line?"]
[13,"What % of your products are welded assemblies? What % are stampings only? "]
[14,"If welding is not performed, why not?"]
[15,"Is the stamping process of the material fully understood and controlled? How is the cutting edges maintained?"]
[16,"How do you keep track of the quality of the first trial product?"]
[17,"How and what do you inspect for incoming materials?"]
[18,"Is the environment appropriate in keeping the machine accuracy(vibration, heat, dust, etc.)?"]
[19,"What is the typical % of yield rate?"]
[20,"Where do you buy their raw materials?"]
[21,"Is the process for removing products from the machines automated?"]
[22,"What is the percentage of in-house versus outsourcing of tooling design and concept?"]
[23,"How is tooling controlled and maintained(by person in charge of the line or centrally controlled)?"]
[24,"Where do you buy your equipment? "]
[25,"What is the current condition of your equipment?"]

{"sheet":"Stamping  2 of 2","index":24,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[26,2,26,7],[4,2,4,7],[16,2,16,7],[19,2,19,7],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[20,2,20,7],[24,2,24,7]]}
[]
[]
["STAMPING  GAGE  &  PROCESSING  GUIDELINE"]
[null,"KPC’s, QCI’s, and QCL's "]
[null,null,"è  Supplier needs to recommend reduced tolerance attribute gages for process control with timing and any comments:"]
[null,null,"Gage Description",null,null,"Leadtime (wks)",null,"Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tooth Forms"]
[null,null,"è  Comparator checking method required at 75% of tolerance "]
[]
[null,"Processing Note "]
[null,null,"è   If heat treating is required for a given component then green state process monitoring and post heat treat process monitoring is required in the format of full SPC charting."]
[]
["DIE SENSORING GUIDELINE"]
[]
[null,"KPC’s, QCI’s, QCL's and Pass-Thru Features"]
[null,null,"è   In die sensoring proposals are preferred prior to the technical review in order to determine the best cost effective method. In die sensoring proposals are required to be submitted to and approved by the Nexteer AQE prior to the award of business."]
[]
[null,null,"è   Concept die strip layouts are required to be submitted to and approved by the Nexteer AQE prior to technical review. The die strip diagram shall demonstrate how the datum structure is translated from the print to the die, and illustrate where the severity ≥ 7 characteristics are formed."]

{"sheet":"Forging","index":25,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[null,null,"Forging Technical Supplement"]
[]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Do you have chemical analysis capabliity?"]
[2,"Do you have hardness testing capability?"]
[3,"Do you have any mechanical testing capability?"]
[4,"Do you have a documented process for maintaining the identity of the heat code throughout the process? Do you comply with the process?"]
[5," Do you document and provide the receiving facility with the Mill cert and heat code associated with the forged parts being manufactured? Do you comply with this process?"]
[6,"Do you have a documented process for material storage using the FIFO methodology? Do you comply wih this process?"]
[7,"Do you have documented Packaging specifications for each Nexteer Automotive Part? Do you comply with this process?"]
[8,"Do you have a documented process to review the cut or sheared faces at set-up for defects? Do you comply with this process?"]
[9,"Do you have documented process limits for cold shearing based on steel grade and bar diameter? Do you comply with this process?"]
[10,"Do you have a documented process to inspect billets for squareness? Do you comply with this process?"]
[11,"Do you have a predictive/prevantative maintenance process for shear tooling? Do you comply with this process?"]
[12,"Do you have a documented process for control of the mult/billet size? Do you comply with this process?"]
[13,"How often do you weigh the mults? "]
[14,"Document your heating process and equipment"]
[15,"Do you have a documented process to handle Variations in the Heating process associated with Breaks, machine downtime, shift change, etc? Do you comply with this process? "]
[16,"Do you have infrared temperature monitoring?"]
[17,"If Pyrometer is utilized in the system is it multi wave length?"]
[18,"If Single frequency, how is emissitivity set?"]
[19,"Do you have a documented process to measure the temperature of each mult prior to forging? Do you comply with this process?"]
[20,"If Induction heating is being utilized do you have a documented process for power monitoring and process feedback? Do you comply with this process?"]
[21,"Do you have a documented process to Calibrate the Temperature/ Power Monitoring Equipment? Do you comply with this process?"]
[22,"Do you have a documented process for calibration of all gages on instrument panels?  Do you comply with this process?"]
[23,"Do you have a documented process to reject Mults outside the established range for temperature and/or time? Do you comply with this process?"]
[24,"Are all heat treat (Both captive & Outsourced Sources) qualified per ES-HT-FW0025?"]
[25,"Are all heat treat (Both captive & Outsourced Sources) qualified per CQI -9 Requirements?"]
[26,"Do you have a documented Process/Procedure for the pre-heating of dies? Do you comply with this process?"]
[27,"Do you have a documented process for Die Storage (a place for everything and everything in its place)? Do you comply with this process?"]
[28,"Do you have a predictive/preventative maintenance process for Dies?  Do you comply with this process?"]
[29,"Do you have a documented process for die review after the completion of production run? Do you comply with this process?"]
[30,"Do you have a documented process for Press Set Up? Do you comply with this process? "]
[31,"Do you have a documented process for review of the Press Tonnage during the set-up process? Do you comply with this process?"]
[32,"Do you have a documented process for the calibration of the load cells? Do you comply with this process?"]
[33,"Are the set up checks based on air or water cooling of parts? \n(If water cooled how do you validate that no additional hardening is occurring)"]
[34,"Do you have a documented process for Die Change over? Do you comply with this process?"]
[35,"What is the average time for Die Change over?  \n(Information Only)"]
[36,"Do you have a documented process for prevention and detection of Cracks? Do you comply with this process?"]
[37,"Do you have a documented process for prevention and detection of Laps? Do you comply with this process?"]
[38,"Do you have a documented process for preventing and detecting Embedded Scale or Excess Scale? Do you comply with this process?"]
[39,"Do you have a documented process for managing Legibility? Do you comply with this process?"]
[40,"Do you have a documented process for preventing and detecting Improper Grain Flow? Do you comply with this process?"]
[41,"Do you have a documented process for controlling forging temperature and time at heat? Do you comply with this process?"]
[42,"Do you have a documented process for cleaning scale from forged parts? Do you comply with this process?"]
[43,"Do you have a documented process for maintaining the cleaning abrasive and shot blast equipment? Do you comply with this process?"]
[44,"Do you have a documented process for the method of validating hardenability? Do you comply with this process?"]
[45,"Do you have a documented process for Heat Code Assignment? Do you comply with this process? (Minimum of an annual review)"]
[46,"Do you have a documented process for review of the Micro structure of the forged parts being produced? Do you comply with this process?"]
[47,"Do you have a documented process for cooling the product? Do you comply with this process?"]
[48,"Do all coatings that the supplier utilizes meet the Nexteer Automotive Specifications and Requirements?"]
[49,"Do you have a documented process for part dimensional inspection? Do you comply with this process?"]
[50,"Do you have a documented process to Calibrate the Dimensional Inspection Equipment? Do you comply with this process?"]
[51,"Do you Have a Documented Process for Re-work/Salvage? Do you comply with this process?"]
[52,"If this part is subject to magnetic particle inspection requirements do they meet or exceed the requirements per the ASTM?"]

{"sheet":"Steel Quality","index":26,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":true,"merged":[[34,0,34,2]]}
[null,null,"Steel Quality Technical Supplement"]
[null,null,"for conformance to Material Specification 33200011"]
["Item #","Nexteer Requirement","Supplier Response"]
[1,"Who is the supplier of the raw steel and their location? If there are multiple suppliers list them all and if each supplier has multiple locations list all that apply."]
[2,"Do you understand that any changes in the steel manufacturing process requires a Supplier Change Request (SCR) to Nexteer Supplier Quality through the Supplier website? Refer to Nexteer.com -> Suppliers to review the Nexteer Supplier Requirements (NSR) in the section \"Doing Business with Nexteer\". Refer to the Change Management of the NSR for further information."]
[3,"What is the type of furnace used? Look for EAF, BOF, etc."]
[4,"Is scrap used in the melting furnace? If yes, what % used is scrap? What are the scrap quality types used? Scrap quality types are type I and type II."]
[5,"Is the heat number control in place? Check the process control plan."]
[6,"Is secondary melting practiced? Look for VAR or ESR."]
[7,"How is one heat of material defined? Look for the total weight."]
[8,"Is this material deoxidized? If yes, what is the primary de-oxidizing element(Al or Si)? What oxygen levels(ppm) are typical of this grade? Generally oxygen levels are less than 25 ppm for everyting except for axle bar and gear steel which should be less than 20 ppm and bearings should be less than 12 ppm."]
[9,"Is degassing performed for ths material? If yes, what is the degassing type?  What is the degassing time(minutes) and vacuum level(tor)? Look for degassing types of RH, VTD, etc."]
[10,"What casting method is used to produce the material? Look for continuous or an ingot process."]
[11,"What is the reduction ratio between the as cast size and final size? Should be 8:1 minimum."]
[12,"How is the liquid metal protected from the atomsphere during the manufacturing process? Is the ladle to tundish transfer shrouded? If yes, with what? Is the tundish to mold transfer shrouded? If yes, with what? Typical shrouding is a combination of ceramic and gas."]
[13,"How are heat numbers segregated when consecutive heats are cast? Look for what length is cut."]
[14,"Are any dams, wiers, baffles, stops employed in the tundish? If yes, which ones? Some features should be used in the tundish, if nothing is used need explanation as to why not?"]
[15,"What is the tundish size (weight) and residence time (seconds or minutes)?"]
[16,"What is the minimum superheat temperature required between ladle tap temperature and the steel liquidus temperature? Should be controlled such that no additional heat is added after the Ladle Furnace, no reheating at the caster is permitted"]
[17,"Is mold oscillation practiced? If yes, what is the control method? Control method should be fixed or dynamic control by computer system"]
[18,"Is electromagnetic stirring practiced? Required to be yes"]
[19,"How is the casting speed monitored and controlled? Should be computer controlled and monitored."]
[20,"How is the solidifying billet/bloom cooled? Should have several sections of water sprays, controls in place to ensure all sprays are on and working as expected"]
[21,"How is slag entrapment in the cast product prevented? Vortex detection is preferred, other methods are allowed such as UT inspection of finished products or controlling the liquid levels to ensure no vortexing."]
[22,"What is the typical Mn:S ratio (Ref. Section 6.2). 30:1 minimum for forgings, higher numbers are preferred."]
[23,"What is the grain refining method? And how is it measured? (Ref. Section 6.3). Method can be Aluminum or microalloy (V, Nb, Ti), measured via apparent, McQuaid-Ehn or other austenitic methods."]
[24,"If hardenability is required how is it measured? (Ref. Section 6.4). Jominy or calculated"]
[25,"What are typical macroetch results for this grade? (Ref. Section 6.5). 3S2R2C or better, lower numbers are better results "]
[26,"What are the typical microcleanliness results? (Ref. Section 6.5) See tables in 33200011 for expected results, again lower numbers are better."]
[27,"How is decarburization controlled? (Ref. Section 6.7) Preferred answer would be control over the reheat furance time and rolling schedule."]
[28,"Does your NDT process have the abililty to detect the maximum allowable discontinuity sizes given for this product? (Ref. Section 6.8) If yes, probabilty of detection data for support is preferred."]
[29,"What are the detection limits for each NDT method used? (Ref Section 6.8) Example: For ultrasonic: size detectable is 0.4mm x 12.7 mm, for eddy current, depth detectable is 0.25 mm."]
[30,"Does this material have a special quality requirement? (Ref Section 7). "]
[31,"Are any additional measures being taken to ensure this quality level is met?"]
["Note: For any non conformances to this survey please request exceptions form X-3484b from the Nexteer AQE.  After filling out the form, submit the completed form to the Nexteer AQE for review and approval."]

{"sheet":"SECTION 10 Capacity Plan ","index":27,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,1,6,4],[33,3,33,4],[34,3,34,4],[28,1,28,4],[8,2,8,4],[20,3,20,4],[22,3,22,4],[31,3,31,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[29,3,29,4],[25,3,25,4],[26,3,26,4],[13,3,13,4],[0,0,0,13],[2,6,2,7],[2,2,2,4],[4,6,5,6],[4,7,5,7],[4,8,5,8],[32,3,32,4],[18,3,18,4],[19,3,19,4],[15,3,15,4],[7,1,7,4],[14,3,14,4]]}
["Manufacturability Assessment and Process Plan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!A3:A3","v":"Part Description:"},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!C3:C3","v":"[Enter Part Name Here]"},null,null,{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!H3","v":"Part   Number:"},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!J3:J3","v":"[Enter PN Here]"},null,{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!L3","v":"Drwg Rev:"},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!M3","v":"[Enter Drwg Rev Here]"},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!N3","v":"Supplier Name:"},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!O3","v":"[Enter Supplier Name Here]"},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!P3","v":"   MAPP     \nRev Date:                         "},{"$f":"'SECTIONS 1, 2, 6 & 7 - MAPP'!R3","v":"[Enter Date]"}]
[null,null,null,null,null,null,"Annual Quoted Tool Capacity","Nexteer Working Days per Year","Weekly Requirement"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK('SECTIONS 1, 2, 6 & 7 - MAPP'!C85:C85),\"-\",'SECTIONS 1, 2, 6 & 7 - MAPP'!C85:C85)","v":"-"},{"$f":"IF(ISBLANK('SECTIONS 1, 2, 6 & 7 - MAPP'!C89:C89),\"-\",'SECTIONS 1, 2, 6 & 7 - MAPP'!C89:C89)","v":"-"},{"$f":"IF(OR(G5=\"-\",H5=\"-\"),\"-\",(G5/H5)*5)","v":"-"}]
[]
[null,"Operating pattern for the specific part",null,null,null,"Process 1","Process 2","Process 3","Process 4","Process 5","Process 6","Process 7"]
[null,"Process description (those that change the part)"]
[null,null,"Dedicated or Shared process  (for shared process, \nshow only the operating pattern for the specific part)"]
[null,null,"A","Shifts/day"]
[null,null,"B","Total hours/shift"]
[null,null,"C1","Personal breaks: lunch, breaks    (minutes/shift)"]
[null,null,"C2","Planned Maintenance    (minutes/shift)"]
[null,null,"D","Days/week"]
[null,null,"E","Net available time   (production hours/week)  \n[A*(B-((C1+C2)/60))*D]",null,{"$f":"IF((F10*(F11-(F12+F13)/60))*F14>0,(F10*(F11-(F12+F13)/60))*F14,\"-\")","v":"-"},"-","-","-","-","-","-"]
[null,null,null,"Mitigation Capacity Plan\n(if more than 5 days or over 100 hours for QTC)"]
[]
[null,null,"Projected Downtime"]
[null,null,"F","Scheduled Downtime/Shift\n(minutes)"]
[null,null,"G","Breakdowns / shift  (unscheduled downtime)   (minutes)"]
[null,null,"H","Total projected downtime/week (hours)      [((F+G)*A)*D)/60]",null,{"$f":"IF(F14>0,((F19+F20)*F10)*F14/60,\"-\")","v":"-"},"-","-","-","-","-","-"]
[]
[null,null,"I","Equipment Availability   [(E-H)/E]",null,{"$f":"IF(F15=\"-\",\"-\",(F15-F21)/F15)","v":"-"},"-","-","-","-","-","-"]
[]
[null,null,"Projected Quality Rate (%)"]
[null,null,"J1","Projected percent of parts scrapped and/or reworked\n"]
[null,null,"J2","Projected Quality Rate (%)",null,{"$f":"IF(F15=\"-\",\"-\",IF(F26=\"\",1,(1-F26)))","v":"-"},"-","-","-","-","-","-"]
[]
[null,"Planned Cycle time / Capacity"]
[null,null,"K","Planned Cycle Time\n(Seconds)"]
[]
[null,null,"L","Parts per Cycle"]
[null,null,"M","Number of Machines"]
[null,null,"N","Adjusted Cycle Time\n(Seconds)\n(K/L)+((K/L*(1-I)+(((K/L)*J1))))",null,{"$f":"IF(OR(ISBLANK(F32),ISBLANK(F30),F27=\"-\",F23=\"-\",ISBLANK(F33)),\"-\",(F30/(F32*F33))+((F30/(F32*F33))*(1-F23)+(((F30/(F32*F33))*F26))))","v":"-"},"-","-","-","-","-","-"]
[null,null,"O","Hours to produce weekly capacity",null,{"$f":"IF(OR(F34=\"-\",$I$5=\"-\"),\"-\",(F34*$I$5)/3600)","v":"-"},{"$f":"IF(OR(G34=\"-\",$I$5=\"-\"),\"-\",(G34*$I$5)/3600)","v":"-"},"-","-","-","-","-"]