{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Instructions","Data","Submission plan","1-Design Record","2-Eng Change","3-Eng Approval","4-DFMEA","5-Process Flow","6-PFMEA","PFMEA Format","7-Control Plan","Control Plan Format","8-MSA","9-Dimensional","10-Material","10-Performance","11-Process Studies","(10)GageR&RWithinpartVar ","12-Lab Doc","16-Checking Aids","17-JVS Specific-Packaging","17-JVS Specific-Coatings SDS","17-JVS Specific-Chemicals","17-JVS Specific-Supplier Chain","18-PSW","Dispositioned PSW"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,0,16,1],[9,0,9,1],[1,0,1,1],[3,0,3,1],[5,0,5,1],[7,0,7,1],[14,0,14,1]]}
[null,"PPAP Workbook"]
["This workbook is to be used for Production Part Approval Process (PPAP) submissions to Jacobs Vehicle Systems (JVS)."]
[]
["Separate tabs are included for each section of the PPAP (as shown in the AIAG PPAP Manual, Fourth Edition)."]
[]
["For Ease of Use with the forms, you should enter all relevant information in the \"Data\" tab to avoid having to retype it. "]
[]
["The \"Submission Plan\" defines what sections are applicable for each level of PPAP.  "]
[]
["Supplier shall complete each tab.  Included are check boxes to be used if the tab is \"not applicable\".  If a document cannot be attached into the designated tab, please indicate in the designated tab and add a separate tab or submit as a separate .pdf document."]
[]
["Supplier shall fill in areas shaded \"yellow\"."]
["JVS uses sections shaded \"blue\"."]
[]
["On tab #18 (Part Submission Warrant), be sure to check off applicable boxes.  \"Data\" information auto fills, but other information requires your input, including reportable substances, for example.  The JVS Reportable substance list is available in the Supplier section at http://www.jacobsvehiclesystems.com/suppliers/jvs-ppap-workbook/."]
[]
["Upon completion, please submit your PPAP to JVS_PPAP@jakebrake.com or as requested in the PPAP purchase order or instruction from JVS Purchasing or Quality."]
[]
[]
[null,"Workbook Rev: 02-JUN-20"]

{"sheet":"Data","index":1,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,1],[22,0,22,1],[17,0,17,1]]}
["Part Information"]
["Part Name"]
["Part Number"]
["Revision"]
["Supplier Part Number (if applicable)"]
["Supplier Part Rev or Date (if applicable)"]
["Additional engineering changes"]
["Additional engineering change rev/date"]
["Shown on drawing number"]
["Deviation"]
["Deviation Approval Date"]
["Weight"]
["Application"]
["Purchase Order No"]
["Tooling Purchase Order"]
["JVS Buyer Name"]
[]
["Submission Information"]
["Submission Date"]
["Submission Level (see submission plan)"]
["Reason for PPAP submission"]
[]
["Supplier Information"]
["Supplier Name"]
["Street Address"]
["City"]
["State"]
["Postal Code"]
["Person responsible for PPAP submission"]
["Title"]
["Phone "]
["Fax"]
["e-mail"]

{"sheet":"Submission plan","index":2,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[18,7,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,10],[18,0,19,0],[20,0,21,0],[18,1,19,2],[20,1,21,2],[18,5,19,5],[18,3,19,3],[18,4,19,4],[27,13,30,13],[27,14,30,14],[27,15,30,15],[27,16,30,16],[21,13,26,13],[21,14,26,14],[21,15,26,15],[21,16,26,16],[15,13,17,13],[15,14,17,14],[15,15,17,15],[15,16,17,16],[1,16,10,16],[10,13,11,13],[12,13,13,13],[12,14,13,14],[12,15,13,15],[1,13,9,13],[1,14,10,14],[1,15,10,15],[29,1,29,2],[30,1,30,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[14,1,14,2],[22,1,22,2],[23,1,23,2],[15,1,15,2],[16,1,16,2],[28,1,28,2],[12,1,12,2],[0,3,0,12],[5,0,5,12],[3,2,3,12],[6,0,6,12],[1,2,1,8],[2,2,2,8],[8,11,9,11],[8,12,9,12],[10,1,10,2],[8,0,9,2],[8,9,9,9],[8,10,9,10],[8,3,8,8],[13,1,13,2],[17,1,17,2],[11,1,11,2],[18,6,19,6],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6]]}
[null,null,null,"PPAP Submission Plan"]
["Supplier",null,{"$f":"Data!B24","v":0},null,null,null,null,null,null,"Part Name",{"$f":"Data!B2","v":0},"Date of Submission",{"$f":"Data!B19","v":0}]
["Part Number",null,{"$f":"Data!B3","v":0},null,null,null,null,null,null,"Revision",{"$f":"Data!B4","v":0},"PPAP Level",{"$f":"Data!B20","v":0}]
["Reason for submission",null,{"$f":"Data!B21","v":0}]
[]
["JVS normally requires PPAP level 3, unless otherwise specified.  The PPAP P.O. takes precedence.\nJVS requires PPAP level 4* (see below) for commercially available product such as fasteners.  Item 10 should include material certs, grade certs, mechanical properties, unless otherwise specified.  The PPAP P.O. takes precedence."]
["This form represents a plan for the submission of requirements. Not all requirements may be applicable in every case.\nKey:  R - Retain at Supplier    S - Submit to JVS    W - Waived\nRefer to AIAG PPAP Manual, Fourth Edition, for further clarification."]
[]
["Requirement",null,null,"PPAP Level",null,null,null,null,null,"Submitted\nY/N","Supplier Comments","JVS Comments","Acceptable\nY/N"]
[null,null,null,1,2,3,4,"4*",5]
[1,"Design Record\nBallooned JVS Part Print",null,"R","S","S","*","S","R",null,null,null,null,"Comments"]
[2,"Engineering Change Documents, if any\nJVS Supplier Change Request or evidence of engineering approval (e.g. e-mail)",null,"S","S","S","*","S","R"]
[3,"Customer Engineering Approval\nJVS Supplier Deviation Request",null,"S","S","S","*","S","R",null,null,null,null,"Approved","Rejected","Interim/\nConditional"]
[4,"Design FMEA\nRequired, if design responsible.",null,"R","R","S","*","W","R"]
[5,"Process Flow Diagram",null,"R","R","S","*","W","R"]
[6,"Process FMEA",null,"R","R","S","*","W","R"]
[7,"Control Plan",null,"R","R","S","*","W","R"]
[8,"Measurement System Analysis Studies\nRequired for measurement devices used for special characteristics.",null,"R","R","S","*","W","R"]
[9,"Dimensional Results\nClearly identify dimensional data to the part(s) submitted in # 14.",null,"R","S","S","*","S","R"]
[null,null,null,null,null,null,null,null,null,null,null,"JVS Layout - ",null,"Date","Date","Date","Date"]
[10,"Material, Performance, Test Results\nTransfer data to form from certifications, including the specification limits, and attach copy of material and test certifications.",null,"R","S","S","*","S","R"]
[null,null,null,null,null,null,null,null,null,null,null,"Met Review - \nOther Testing - "]
[11,"Initial Process Study\nRequired for all special characteristics.\nInclude raw data, histogram, control chart and capability indices (PpK and CpK).",null,"R","R","S","*","W","R"]
[12,"Qualified Laboratory Documentation\nInclude copies of certifications (e.g. ISO9001, IATF16949, A2LA), as appropriate",null,"R","S","S","*","S","R"]
[13,"Appearance Approval Report\nNot applicable to JVS product",null,"W","W","W","W","W","W","N/A","Waived","Waived","N/A"]
[14,"Sample Product\nClearly identify part(s) used for the results submitted in # 9.  A minimum of 2 parts to be submitted (one for dimensional analysis and one for possible destructive testing), unless otherwise specified.",null,"R","S","S","*","S","R"]
[15,"Master Samples\nSample must be retained at the supplier.  Dimensional data for this piece should also be included in #9.",null,"R","R","R","*","R","R","N/A","To be retained at supplier","To be retained at supplier","N/A"]
[16,"Checking Aids\nList the checking aids with calibration status, as appropriate.",null,"R","R","R","*","W","R",null,null,null,null,"Product Engineer","Process Quality Engineer","Commodity Mgr/Buyer Planner","Supplier Quality Engineer"]
[17,"JVS Specific Requirements\nPackaging & Preservation\nCoatings (SDS)\nProcess Chemicals\nOutside processes",null,"S","S","S","S","S","R"]
[18,"Part Submission Warrant",null,"S","S","S","S","S","R"]
[19,"Bulk Material Checklist\nNot applicable to JVS product",null,"W","W","W","W","W","W","N/A","Waived","Waived","N/A"]

{"sheet":"1-Design Record","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Design Record"]

{"sheet":"2-Eng Change","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Engineering Change Document\n(Supplier Change Request)"]
["Identify approved change(s) not yet recorded on the design drawing, but which are incorporated in the product."]

{"sheet":"3-Eng Approval","index":5,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Engineering Approval\n(Supplier Deviation Request)"]
["Identify any deviation(s) from the design drawing (characteristics which do not meet the design requirement)."]

{"sheet":"4-DFMEA","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Design Failure Mode & Effects Analysis\n(DFMEA)"]

{"sheet":"5-Process Flow","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Process Flow Diagram"]

{"sheet":"6-PFMEA","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Process Failure Mode & Effects Analysis\n(PFMEA)"]

{"sheet":"PFMEA Format","index":9,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,13,5,17],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[1,2,1,8],[2,2,2,8],[3,2,3,8],[0,13,0,17],[1,13,1,17],[2,13,2,17],[3,13,3,17],[0,0,0,8]]}
["Process Failure Mode & Effects Analysis (PFMEA)",null,null,null,null,null,null,null,null,null,null,null,"PFMEA Number:"]
[null,"Key Contact / Phone:",null,null,null,null,null,null,null,null,null,null,"Part Number / Latest Change:"]
[null,"Prepared By:",null,null,null,null,null,null,null,null,null,null,"Orig Date:"]
[null,"Revised by:",null,null,null,null,null,null,null,null,null,null,"Rev Date:"]
[]
["Item","Potential Failure Mode","Potential Effect(s) of Failure","Sev","Class","Potential Cause(s)/ Mechanism(s) of Failure","Occur","Current Process Controls\nPrevention","Current Process Controls\nDetection","Detect","RPN","Recommended Action(s)","Responsibility & \nTarget Completion Date","Action Results"]
["Process Function/ Requirements",null,null,null,null,null,null,null,null,null,null,null,null,"Actions Taken","Sev","Occ","Det","RPN"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J8*G8*D8","v":0},null,null,null,null,null,null,{"$f":"Q8*P8*O8","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J9*G9*D9","v":0},null,null,null,null,null,null,{"$f":"Q9*P9*O9","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]

{"sheet":"7-Control Plan","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Control Plan"]

{"sheet":"Control Plan Format","index":11,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,13,6,13],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,5,5],[5,6,6,6],[5,7,5,12],[3,12,3,13],[2,2,2,7],[3,2,3,7],[0,0,0,8],[1,2,1,7],[0,12,0,13],[1,12,1,13],[2,12,2,13]]}
["Control Plan",null,null,null,null,null,null,null,null,null,null,"Control Plan Number:"]
[null,"Key Contact / Phone:",null,null,null,null,null,null,null,null,null,"Part Number / Latest Change:"]
[null,"Prepared By:",null,null,null,null,null,null,null,null,null,"Orig Date:"]
[null,"Revised by:",null,null,null,null,null,null,null,null,null,"Rev Date:"]
[]
["Part / Process Number","Process Name/Operation Description","Machine, Device, Jig, Tools for Mfg.","Characteristics",null,null,"Special Char. Class","Methods",null,null,null,null,null,"Reaction Plan"]
[null,null,null,"No.","Product","Process",null,"Specification / Tolerance","Evaluation / Measurement Technique","Error Proof","Sample Size","Sample Frequency","Control Method"]

{"sheet":"8-MSA","index":12,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Measurement System Analysis Studies"]

{"sheet":"9-Dimensional","index":13,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,7,6,9],[1,7,1,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[5,0,5,3],[6,0,6,3],[1,4,1,6],[2,4,2,6],[3,4,3,6],[5,4,5,6],[4,4,4,6],[6,4,6,6],[0,0,0,9],[8,1,10,1],[8,0,10,0],[8,2,8,6],[8,7,8,9],[7,0,7,9],[9,2,10,2],[9,3,9,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["Dimensional Results"]
["PART NAME",null,null,null,"PART NUMBER",null,null,"PART REV"]
[{"$f":"Data!B2","v":0},null,null,null,{"$f":"Data!B3","v":0},null,null,{"$f":"Data!B4","v":0}]
["SUPPLIER",null,null,null,"NAME OF SUPPLIER INSPECTOR",null,null,"DATE OF SUPPLIER INSP"]
[{"$f":"Data!B24","v":0}]
["PURCHASE ORDER",null,null,null,"NAME OF JVS INSPECTOR",null,null,"DATE OF JVS INSP"]
[{"$f":"Data!B14","v":0}]
["Inspection Method\nC=Calipers, DI=Drop Indicator, G=Gage Pins, I=Indicator, M=Micrometer, P=Profilometer, R=Rockwell Hardness Tester, S=Shadowgraph"]
["Item","Dimension / Specification","Supplier",null,null,null,null,"Jacobs"]
[null,null,"Inspection Method","Results",null,null,"A/R","Inspection Method","Results","A/R"]
[null,null,null,"Pc. 1","Pc. 2","Pc. 3\n (Retained at Supplier)"]

{"sheet":"10-Material","index":14,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,4,5,6],[4,4,4,6],[0,0,0,8],[2,0,2,8],[8,0,8,8],[4,0,4,1],[5,0,5,1],[4,2,4,3],[5,2,5,3],[4,7,4,8],[5,7,5,8]]}
["Material Test Results"]
[]
["Complete form and attach material certification below. Blanket statements of conformance are unacceptable for any test results."]
[]
["SUPPLIER",null,"PART NAME",null,"PART NUMBER",null,null,"REV"]
[{"$f":"Data!B24","v":0},null,{"$f":"Data!B2","v":0},null,{"$f":"Data!B3","v":0},null,null,{"$f":"Data!B4","v":0}]
[]
["MATERIAL SUPPLIER","NAME OF LABORATORY","MATERIAL SPEC./ CHARACTERISTIC","SPECIFICATION LIMITS","TEST DATE","QTY TESTED","SUPPLIER TEST RESULTS (DATA)","OK","NOT OK"]
["SAMPLE DATA"]
["METAL CO","METAL CO.","42CrMoS4\n% C","0.38 - 0.45","2010-06-06","Heat 425880 (2000 lbs)",0.44,"OK"]
["HT SUPPLIER","HT SUPPLIER","Core Hardness","56 - 60 HRC","2010-06-10",1,57.7,"OK"]

{"sheet":"10-Performance","index":15,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[8,0,8,7],[4,1,4,2],[5,1,5,2],[4,6,4,7],[5,6,5,7],[5,3,5,5],[4,3,4,5]]}
["Performance Test Results"]
[]
["Applies to performance tests such as fatigue testing, breakaway torque and mechanical properties.\nComplete form and attach test certification below (if applicable). Blanket statements of conformance are unacceptable for any test results."]
[]
["SUPPLIER","PART NAME",null,"PART NUMBER",null,null,"REV"]
[{"$f":"Data!B24","v":0},{"$f":"Data!B2","v":0},null,{"$f":"Data!B3","v":0},null,null,{"$f":"Data!B4","v":0}]
[]
["TEST LABORATORY","TEST SPEC./ CHARACTERISTIC","SPECIFICATION LIMITS","TEST DATE","QTY TESTED","SUPPLIER TEST RESULTS (DATA)","OK","NOT OK"]
["SAMPLE DATA"]
["AAA TEST LAB","Cycle test per ABC SPEC 1234","100,000 cycles without failure","2010-06-06",3,"1 pc broke at 214,000 cycles, 2 pcs test stopped at 250,000 cycles without failure","OK"]

{"sheet":"11-Process Studies","index":16,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Initial Process Studies"]
["Process Studies are required for all special (Critical and Major) characteristics.  Process Studies should be included, if possible, for all KCC/KPC\nInclude raw data, histogram, control chart and capability indices (PpK and CpK)"]

{"sheet":"(10)GageR&RWithinpartVar ","index":17,"n_rows":43,"n_cols":34,"rows_kept":43,"cut":false,"hidden":true,"merged":[[10,24,10,25],[10,7,10,9],[4,26,4,29],[6,26,6,29],[8,26,8,29],[10,26,10,27],[10,28,10,29],[4,22,4,25],[6,22,6,25],[8,22,8,25],[10,22,10,23],[8,19,8,21],[4,19,4,21],[6,19,6,21],[10,19,10,21],[4,13,4,18],[6,13,6,18],[8,13,8,18],[10,10,10,12],[10,13,10,15],[10,16,10,18],[4,0,4,6],[6,0,6,6],[8,0,8,6],[10,0,10,6],[4,7,4,12],[6,7,6,12],[8,7,8,12]]}
["GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET"]
["VARIABLE DATA RESULTS - INCLUDING WITHIN-PART VARIATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE DATA RESULTS"]
[]
["Part Number",null,null,null,null,null,null,"Gage Name",null,null,null,null,null,"Appraiser A",null,null,null,null,null,"Part Number",null,null,"Gage Name",null,null,null,"Appraiser A"]
[{"$f":"+Data!B3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A5","v":0},null,null,{"$f":"+H5","v":0},null,null,null,{"$f":"+N5","v":0}]
["Part Name",null,null,null,null,null,null,"Gage Number",null,null,null,null,null,"Appraiser B",null,null,null,null,null,"Part Name",null,null,"Gage Number",null,null,null,"Appraiser B"]
[{"$f":"+Data!B2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A7","v":0},null,null,{"$f":"+H7","v":0},null,null,null,{"$f":"+N7","v":0}]
["Characteristic/Specification",null,null,null,null,null,null,"Gage Type",null,null,null,null,null,"Appraiser C",null,null,null,null,null,"Characteristic/Specification",null,null,"Gage Type",null,null,null,"Appraiser C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A9","v":0},null,null,{"$f":"+H9","v":0},null,null,null,{"$f":"+N9","v":0}]
["Characteristic Classification",null,null,null,null,null,null,"Trials",null,null,"Parts",null,null,"Appraisers",null,null,"Date Performed",null,null,"Characteristic Classification",null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed"]
[null,null,null,null,null,null,null,{"$f":"COUNT(C16:C18)","v":0},null,null,{"$f":"COUNT(C16,F16,I16,L16,O16)","v":0},null,null,{"$f":"COUNT(C16,C21,C26)","v":0},null,null,null,null,null,{"$f":"+A11","v":0},null,null,{"$f":"H11","v":0},null,{"$f":"+K11","v":0},null,{"$f":"+N11","v":0},null,{"$f":"+Q11","v":0},null,null,null,null,"((XWIV + (RXwiv x K3)2 - (EVWIV)2/(nWIVr))1/2)/2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V36+((S33*2)^2-V39^2/(K11*H11))^0.5/2"]
[null,null,"PART",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measurement Unit Analysis",null,null,null,"% Total Variation (TV)"]
["APPRAISER/",null,null,1,null,null,2,null,null,3,null,null,4,null,null,5,null,"APPRAISER",null,"  Repeatability - Equipment Variation (EV)"]
["TRIAL #",null,"MAX","MIN","RGE","MAX","MIN","RGE","MAX","MIN","RGE","MAX","MIN","RGE","MAX","MIN","RGE","AVERAGE",null,"EV","=","R  x  K1",null,null,"Trials","K1","% EV","=","100 (EV/TV)"]
["1.  A",1,null,null,{"$f":"IF(C16<>\"\",C16-D16,\"\")","v":""},null,null,{"$f":"IF(F16<>\"\",F16-G16,\"\")","v":""},null,null,{"$f":"IF(I16<>\"\",I16-J16,\"\")","v":""},null,null,{"$f":"IF(L16<>\"\",L16-M16,\"\")","v":""},null,null,{"$f":"IF(O16<>\"\",O16-P16,\"\")","v":""},{"$f":"IF(OR(AND(E16<>\"\",E16>$S$36),AND(H16<>\"\",H16>$S$36),AND(K16<>\"\",K16>$S$36),AND(N16<>\"\",N16>$S$36),AND(Q16<>\"\",Q16>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(TEXT($S$34,\"0.000\"),\" x \",CHOOSE($H$11,0,4.56,3.05)),\"\")","v":""},null,null,2,4.5599999999999996,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"100(\",TEXT($V$17,\"0.000\"),\"/\",TEXT($V$43,\"0.000\"),\")\"),\"\")","v":""}]
[2,2,null,null,{"$f":"IF(C17<>\"\",C17-D17,\"\")","v":""},null,null,{"$f":"IF(F17<>\"\",F17-G17,\"\")","v":""},null,null,{"$f":"IF(I17<>\"\",I17-J17,\"\")","v":""},null,null,{"$f":"IF(L17<>\"\",L17-M17,\"\")","v":""},null,null,{"$f":"IF(O17<>\"\",O17-P17,\"\")","v":""},{"$f":"IF(OR(AND(E17<>\"\",E17>$S$36),AND(H17<>\"\",H17>$S$36),AND(K17<>\"\",K17>$S$36),AND(N17<>\"\",N17>$S$36),AND(Q17<>\"\",Q17>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,null,"=",{"$f":"IF(C16<>\"\",$S$34*CHOOSE($H$11,0,4.56,3.05),\"\")","v":""},null,null,3,3.05,null,"=",{"$f":"IF(C16<>\"\",100*($V$17/$V$43),\"\")","v":""}]
[{"$f":"A17+1","v":3},3,null,null,{"$f":"IF(C18<>\"\",C18-D18,\"\")","v":""},null,null,{"$f":"IF(F18<>\"\",F18-G18,\"\")","v":""},null,null,{"$f":"IF(I18<>\"\",I18-J18,\"\")","v":""},null,null,{"$f":"IF(L18<>\"\",L18-M18,\"\")","v":""},null,null,{"$f":"IF(O18<>\"\",O18-P18,\"\")","v":""},{"$f":"IF(OR(AND(E18<>\"\",E18>$S$36),AND(H18<>\"\",H18>$S$36),AND(K18<>\"\",K18>$S$36),AND(N18<>\"\",N18>$S$36),AND(Q18<>\"\",Q18>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,"  Reproducibility - Appraiser Variation (AV)"]
[{"$f":"A18+1","v":4},"AVE",null,{"$f":"IF(C16<>\"\",AVERAGE(C16:D17),\"\")","v":""}," ",null,{"$f":"IF(F16<>\"\",AVERAGE(F16:G17),\"\")","v":""},null,null,{"$f":"IF(I16<>\"\",AVERAGE(I16:J17),\"\")","v":""},null,null,{"$f":"IF(L16<>\"\",AVERAGE(L16:M17),\"\")","v":""},null,null,{"$f":"IF(O16<>\"\",AVERAGE(O16:P17),\"\")","v":""},null,"Xa=",{"$f":"IF(D19<>\"\",AVERAGE(D19:P19),\"\")","v":""},"AV","=","{(XDIFF x K2)2 - (EV2/nr)}1/2",null,null,null,null,"% AV","=","100 (AV/TV)"]
[{"$f":"A19+1","v":5},"R",{"$f":"IF(C16<>\"\",MAX(C16:C18)-MIN(C16:C18),\"\")","v":""},"","","","","","","","","","","","","","",null,null,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"{(\",TEXT($S$35,\"0.000\"),\" x \",CHOOSE($N$11,0,3.65,2.7),\")^2 - (\",TEXT($V$17,\"0.000\"),\" ^2/(\",$K$11,\" x \",$H$11,\"))}^1/2\"),\"\")","v":""},null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"100(\",TEXT($V$21,\"0.000\"),\"/\",TEXT($V$43,\"0.000\"),\")\"),\"\")","v":""}]
["6.  B",1,null,null,{"$f":"IF(C21<>\"\",C21-D21,\"\")","v":""},null,null,{"$f":"IF(F21<>\"\",F21-G21,\"\")","v":""},null,null,{"$f":"IF(I21<>\"\",I21-J21,\"\")","v":""},null,null,{"$f":"IF(L21<>\"\",L21-M21,\"\")","v":""},null,null,{"$f":"IF(O21<>\"\",O21-P21,\"\")","v":""},{"$f":"IF(OR(AND(E21<>\"\",E21>$S$36),AND(H21<>\"\",H21>$S$36),AND(K21<>\"\",K21>$S$36),AND(N21<>\"\",N21>$S$36),AND(Q21<>\"\",Q21>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,null,"=",{"$f":"IF(C16=\"\",\"\",IF(($S$35*CHOOSE($N$11,0,3.65,2.7))^2-$V$17^2/($K$11*$H$11)<0,0,(($S$35*CHOOSE($N$11,0,3.65,2.7))^2-$V$17^2/($K$11*$H$11))^(1/2)))","v":""},null,"Appraisers",2,3,null,"=",{"$f":"IF(C16<>\"\",100*($V$21/$V$43),\"\")","v":""}]
[7,2,null,null,{"$f":"IF(C22<>\"\",C22-D22,\"\")","v":""},null,null,{"$f":"IF(F22<>\"\",F22-G22,\"\")","v":""},null,null,{"$f":"IF(I22<>\"\",I22-J22,\"\")","v":""},null,null,{"$f":"IF(L22<>\"\",L22-M22,\"\")","v":""},null,null,{"$f":"IF(O22<>\"\",O22-P22,\"\")","v":""},{"$f":"IF(OR(AND(E22<>\"\",E22>$S$36),AND(H22<>\"\",H22>$S$36),AND(K22<>\"\",K22>$S$36),AND(N22<>\"\",N22>$S$36),AND(Q22<>\"\",Q22>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,null,null,null,null,"K2",3.65,2.7,"   n = number of parts"]
[{"$f":"A22+1","v":8},3,null,null,{"$f":"IF(C23<>\"\",C23-D23,\"\")","v":""},null,null,{"$f":"IF(F23<>\"\",F23-G23,\"\")","v":""},null,null,{"$f":"IF(I23<>\"\",I23-J23,\"\")","v":""},null,null,{"$f":"IF(L23<>\"\",L23-M23,\"\")","v":""},null,null,{"$f":"IF(O23<>\"\",O23-P23,\"\")","v":""},{"$f":"IF(OR(AND(E23<>\"\",E23>$S$36),AND(H23<>\"\",H23>$S$36),AND(K23<>\"\",K23>$S$36),AND(N23<>\"\",N23>$S$36),AND(Q23<>\"\",Q23>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,"  Repeatability & Reproducibility (R & R)",null,null,null,null,null,null,"   r = number of trials"]
[{"$f":"A23+1","v":9},"AVE",null,{"$f":"IF(C21<>\"\",AVERAGE(C21:D22),\"\")","v":""},null,null,{"$f":"IF(F21<>\"\",AVERAGE(F21:G22),\"\")","v":""},null,null,{"$f":"IF(I21<>\"\",AVERAGE(I21:J22),\"\")","v":""},null,null,{"$f":"IF(L21<>\"\",AVERAGE(L21:M22),\"\")","v":""},null,null,{"$f":"IF(O21<>\"\",AVERAGE(O21:P22),\"\")","v":""},null,"Xb=",{"$f":"IF(D24<>\"\",AVERAGE(D24:P24),\"\")","v":""},"R & R","=","{(EV2 + AV2)}1/2"]
[{"$f":"A24+1","v":10},"R",{"$f":"IF(C21<>\"\",MAX(C21:C23)-MIN(C21:C23),\"\")","v":""},"","","","","","","","","","","","","","",null,null,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"{(\",TEXT($V$17,\"0.000\"),\"^2 + \",TEXT($V$21,\"0.000\"),\"^2)}^1/2\"),\"\")","v":""},null,null,null,null,"% R&R","=","100 (R&R/TV)"]
["11.  C",1,null,null,{"$f":"IF(C26<>\"\",C26-D26,\"\")","v":""},null,null,{"$f":"IF(F26<>\"\",F26-G26,\"\")","v":""},null,null,{"$f":"IF(I26<>\"\",I26-J26,\"\")","v":""},null,null,{"$f":"IF(L26<>\"\",L26-M26,\"\")","v":""},null,null,{"$f":"IF(O26<>\"\",O26-P26,\"\")","v":""},{"$f":"IF(OR(AND(E26<>\"\",E26>$S$36),AND(H26<>\"\",H26>$S$36),AND(K26<>\"\",K26>$S$36),AND(N26<>\"\",N26>$S$36),AND(Q26<>\"\",Q26>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,null,"=",{"$f":"IF(C16<>\"\",($V$17^2+$V$21^2)^(1/2),\"\")","v":""},null,null,"Parts","K3",null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"100(\",TEXT($V$26,\"0.000\"),\"/\",TEXT($V$43,\"0.000\"),\")\"),\"\")","v":""}]
[12,2,null,null,{"$f":"IF(C27<>\"\",C27-D27,\"\")","v":""},null,null,{"$f":"IF(F27<>\"\",F27-G27,\"\")","v":""},null,null,{"$f":"IF(I27<>\"\",I27-J27,\"\")","v":""},null,null,{"$f":"IF(L27<>\"\",L27-M27,\"\")","v":""},null,null,{"$f":"IF(O27<>\"\",O27-P27,\"\")","v":""},{"$f":"IF(OR(AND(E27<>\"\",E27>$S$36),AND(H27<>\"\",H27>$S$36),AND(K27<>\"\",K27>$S$36),AND(N27<>\"\",N27>$S$36),AND(Q27<>\"\",Q27>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,"  Part Variation (PV)",null,null,null,null,2,3.65,null,"=",{"$f":"IF(C16<>\"\",100*($V$26/$V$43),\"\")","v":""}]
[{"$f":"A27+1","v":13},3,null,null,{"$f":"IF(C28<>\"\",C28-D28,\"\")","v":""},null,null,{"$f":"IF(F28<>\"\",F28-G28,\"\")","v":""},null,null,{"$f":"IF(I28<>\"\",I28-J28,\"\")","v":""},null,null,{"$f":"IF(L28<>\"\",L28-M28,\"\")","v":""},null,null,{"$f":"IF(O28<>\"\",O28-P28,\"\")","v":""},{"$f":"IF(OR(AND(E28<>\"\",E28>$S$36),AND(H28<>\"\",H28>$S$36),AND(K28<>\"\",K28>$S$36),AND(N28<>\"\",N28>$S$36),AND(Q28<>\"\",Q28>$S$36)),\"OUT OF CONTROL\",\"\")","v":""},null,"PV","=","RP x K3",null,null,3,2.7]
[{"$f":"A28+1","v":14},"AVE",null,{"$f":"IF(C26<>\"\",AVERAGE(C26:D27),\"\")","v":""},null,null,{"$f":"IF(F26<>\"\",AVERAGE(F26:G27),\"\")","v":""},null,null,{"$f":"IF(I26<>\"\",AVERAGE(I26:J27),\"\")","v":""},null,null,{"$f":"IF(L26<>\"\",AVERAGE(L26:M27),\"\")","v":""},null,null,{"$f":"IF(O26<>\"\",AVERAGE(O26:P27),\"\")","v":""},null,"Xc=",{"$f":"IF(D29<>\"\",AVERAGE(D29:P29),\"\")","v":""},null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(TEXT($S$32,\"0.000\"),\" x \",CHOOSE($K$11,0,3.65,2.7,2.3,2.08,1.93,1.82,1.74,1.67,1.62)),\"\")","v":""},null,null,4,2.2999999999999998,"% PV","=","100 (PV/TV)"]
[{"$f":"A29+1","v":15},"R",{"$f":"IF(C26<>\"\",MAX(C26:C28)-MIN(C26:C28),\"\")","v":""},"","","","","","","","","","","","","","","Ro=",{"$f":"IF(S19<>\"\",MAX(S19:S29)-MIN(S19:S29),\"\")","v":""},null,"=",{"$f":"IF(C16<>\"\",$S$32*CHOOSE($K$11,0,3.65,2.7,2.3,2.08,1.93,1.82,1.74,1.67,1.62),\"\")","v":""},null,null,5,2.08,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"100(\",TEXT($V$30,\"0.000\"),\"/\",TEXT($V$43,\"0.000\"),\")\"),\"\")","v":""}]
["16.  Part",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Within-Part Variation (WIV)",null,null,null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",100*($V$30/$V$43),\"\")","v":""}]
["       Ave  ( Xp )",null,null,{"$f":"IF(D19<>\"\",AVERAGE(D19,D24,D29),\"\")","v":""},null,null,{"$f":"IF(G19<>\"\",AVERAGE(G19,G24,G29),\"\")","v":""},null,null,{"$f":"IF(J19<>\"\",AVERAGE(J19,J24,J29),\"\")","v":""},null,null,{"$f":"IF(M19<>\"\",AVERAGE(M19,M24,M29),\"\")","v":""},null,null,{"$f":"IF(P19<>\"\",AVERAGE(P19,P24,P29),\"\")","v":""},null,"Rp=",{"$f":"IF(C16<>\"\",MAX(D32:P32)-MIN(D32:P32),\"\")","v":""}]
["17. Ave of Xwiv",null,{"$f":"IF(C19<>\"\",SUM(C19,C24,C29)/COUNT(C19,C24,C29),\"\")","v":""},null,{"$f":"IF(E16<>\"\",SUM(E16:E18,E21:E23,E26:E28)/COUNT(E16:E18,E21:E23,E26:E28),\"\")","v":""},{"$f":"IF(F19<>\"\",SUM(F19,F24,F29)/COUNT(F19,F24,F29),\"\")","v":""},null,{"$f":"IF(H16<>\"\",SUM(H16:H18,H21:H23,H26:H28)/COUNT(H16:H18,H21:H23,H26:H28),\"\")","v":""},{"$f":"IF(I19<>\"\",SUM(I19,I24,I29)/COUNT(I19,I24,I29),\"\")","v":""},null,{"$f":"IF(K16<>\"\",SUM(K16:K18,K21:K23,K26:K28)/COUNT(K16:K18,K21:K23,K26:K28),\"\")","v":""},{"$f":"IF(L19<>\"\",SUM(L19,L24,L29)/COUNT(L19,L24,L29),\"\")","v":""},null,{"$f":"IF(N16<>\"\",SUM(N16:N18,N21:N23,N26:N28)/COUNT(N16:N18,N21:N23,N26:N28),\"\")","v":""},{"$f":"IF(O19<>\"\",SUM(O19,O24,O29)/COUNT(O19,O24,O29),\"\")","v":""},null,{"$f":"IF(Q16<>\"\",SUM(Q16:Q18,Q21:Q23,Q26:Q28)/COUNT(Q16:Q18,Q21:Q23,Q26:Q28),\"\")","v":""},"RXwiv=",{"$f":"IF(C16<>\"\",MAX(C33:Q33)-MIN(C33:Q33),\"\")","v":""},"WIV","=","((XWIV + (RXwiv x K3)2 - (EVWIV)2/(nWIVr))1/2)/2",null,null,null,null,"% WIV","=","100 (WIV/TV)"]
[18,"RREPEAT = (SRANGE(LINES 5, 10, & 15))/(#RANGE READINGS) (MAX/MIN ONLY)=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RREP=",{"$f":"IF(C20<>\"\",SUM(C20:D20,F20:G20,I20:J20,L20:M20,O20:P20,C25:D25,F25:G25,I25:J25,L25:M25,O25:P25,C30:D30,F30:G30,I30:J30,L30:M30,O30:P30)/COUNT(C20:D20,F20:G20,I20:J20,L20:M20,O20:P20,C25:D25,F25:G25,I25:J25,L25:M25,O25:P25,C30:D30,F30:G30,I30:J30,L30:M30,O30:P30),\"\")","v":""},null,"=",{"$f":"IF(C16=\"\",\"\",V36+(((S33*CHOOSE(K11,0,3.65,2.7,2.3,2.08,1.93,1.82,1.74,1.67,1.62))^2-(V39^2/(K11*H11)))^0.5)/2)","v":""},null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"100(\",TEXT($V$34,\"0.000\"),\"/\",TEXT($V$43,\"0.000\"),\")\"),\"\")","v":""}]
[{"$f":"A34+1","v":19},"Xdiff = [ Max X ] - [Min X ] =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XDIFF=",{"$f":"IF(S19<>\"\",MAX(S19,S24,S29)-MIN(S19,S24,S29),\"\")","v":""},"XWIV","=","SXWIV(LINE 17)/# XWIV READINGS",null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",100*($V$34/$V$43),\"\")","v":""}]
[{"$f":"A35+1","v":20},"UCLR = R x D4* =",null,null,null,"D4=",{"$f":"IF(C16<>\"\",CHOOSE(H11,0,3.27,2.58),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"UCLR=",{"$f":"IF(E16<>\"\",G36*AVERAGE(E16:E18,H16:H18,K16:K18,N16:N18,Q16:Q18,E21:E23,H21:H23,K21:K23,N21:N23,Q21:Q23,E26:E28,H26:H28,K26:K28,N26:N28,Q26:Q28),\"\")","v":""},null,"=",{"$f":"IF(C16<>\"\",SUM(E33,H33,K33,N33,Q33)/COUNT(E33,H33,K33,N33,Q33),\"\")","v":""}]
[{"$f":"A36+1","v":21},"LCLR = R x D3* =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCLR=",{"$f":"IF(C16<>\"\",0,\"\")","v":""},"     WIV  =  # APPRAISERS,   r  =  # TRIALS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVWIV","=","K1 x SRRGE(LINES 5,10, & 15)/# RRGE READINGS"]
["* D4 =3.27 for 2 trials and 2.58 for 3 trials;  D3 = 0 for up to 7 trials.  UCLR represents the limit of individual R's.  Circle those that are",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",CHOOSE($H$11,0,4.56,3.05)*(SUM(C20:D20,F20:G20,I20:J20,L20:M20,O20:P20,C25:D25,F25:G25,I25:J25,L25:M25,O25:P25,C30:D30,F30:G30,I30:J30,L30:M30,O30:P30)/COUNT(C20:D20,F20:G20,I20:J20,L20:M20,O20:P20,C25:D25,F25:G25,I25:J25,L25:M25,O25:P25,C30:D30,F30:G30,I30:J30,L30:M30,O30:P30)),\"\")","v":""}]
["beyond this limit.  Identify the cause and correct.  Repeat these readings using the same appraiser and unit as originally used or dis-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Total Variation (TV)"]
["card values and re-average and recompute R and the limiting value from the remaining observations.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TV","=","{(R&R2 + PV2 + WIV2)}1/2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",CONCATENATE(\"{(\",TEXT($V$26,\"0.000\"),\"^2 + \",TEXT($V$30,\"0.000\"),\"^2 + \",TEXT($V$34,\"0.000\"),\"^2)}^1/2\"),\"\")","v":""}]
["Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(C16<>\"\",($V$26^2+$V$30^2+$V$34^2)^(1/2),\"\")","v":""}]

{"sheet":"12-Lab Doc","index":18,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Qualified Laboratory Documentation"]
[]
[]
[]
[]
[null,"Issue Date",null,"Expiration Date"]
[null,"Issue Date",null,"Expiration Date"]
[null,"Issue Date",null,"Expiration Date"]
[null,"Issue Date",null,"Expiration Date"]
[null,"Issue Date",null,"Expiration Date"]

{"sheet":"16-Checking Aids","index":19,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Checking Aids"]
[]
[]
["SUPPLIER","PART NAME","PART NUMBER","REV"]
[{"$f":"Data!B24","v":0},{"$f":"Data!B2","v":0},{"$f":"Data!B3","v":0},{"$f":"Data!B4","v":0}]
[]
["Checking aid number","Description of checking aid","Complies with revision above?\nY/N","Date of last calibration / verification"]

{"sheet":"17-JVS Specific-Packaging","index":20,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Packaging and Preservation"]
["Quantity per individual package/box"]
["Weight per individual package/box",null,null,null,"NOTE:  Over 25 pounds requires formal JVS approval"]
["Packaging Material Type"]
[null,"Outer packaging"]
[]
[]
[]
[]
[]
[null,"Inner packaging (Idenfify all applicable)"]

{"sheet":"17-JVS Specific-Coatings SDS","index":21,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["Coating SDS"]
["List any coatings on the product and attach SDS"]

{"sheet":"17-JVS Specific-Chemicals","index":22,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,4]]}
["Process Chemicals"]
["List any chemicals used for cleaning, degreasing, descaling, etching, acids or bases used in vibratory finishing, etc..\nAttach manufacturer's chemical specification for any such chemicals, as appropriate."]
[]
[]
["Brand Name and Manufacturer of Chemical","Process where chemical is used","Manufacturer's Spec Attached","MSDS Attached","Included under separate cover"]

{"sheet":"17-JVS Specific-Supplier Chain","index":23,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Outside Services"]
["Identify supplier for any outside processes or services (e.g. coating application, shot peen, grinding)"]
[]
[]
["Outside Service / Operation","Supplier Name","Supplier Location","Certifications and expiration dates\n(e.g. ISO 9001, TS16949, A2LA, ISO/IEC 7025)"]

{"sheet":"18-PSW","index":24,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[21,3,21,6],[47,15,47,17],[43,1,43,17],[46,6,46,13],[5,9,5,11],[5,16,5,17],[15,4,15,5],[22,2,22,11],[20,6,20,17],[9,1,9,7],[29,14,29,17],[21,10,21,11],[47,3,47,7],[45,7,45,17],[42,5,42,17],[41,1,41,17],[30,11,30,17],[42,1,42,4],[45,1,45,6],[47,8,47,9],[46,15,46,17],[47,10,47,12],[47,13,47,14],[53,11,53,17],[53,3,53,6],[53,8,53,9],[48,2,48,6],[48,9,48,17],[52,4,52,9],[52,11,52,17],[51,11,51,12],[51,13,51,17],[50,1,50,17],[4,14,4,15],[4,5,4,13],[11,1,11,4],[11,5,11,6],[7,1,7,7],[7,9,7,17],[9,9,9,17],[11,9,11,17],[46,1,46,5],[20,4,20,5],[21,7,21,9],[0,7,0,18],[6,1,6,7],[6,9,6,17],[3,1,3,3],[5,12,5,13],[5,4,5,8],[2,16,2,17],[2,3,2,8],[2,12,2,14],[2,9,2,11],[4,16,4,17],[3,16,3,17],[3,4,3,14]]}
[null,null,null,null,null,null,null,"Part Submission Warrant"]
[]
[null,"Part Name",null,{"$f":"Data!B2","v":0},null,null,null,null,null,"JVS Part Number",null,null,{"$f":"Data!B3","v":0},null,null,"Rev.",{"$f":"Data!B4","v":0}]
[null,"Supplier Part Number",null,null,{"$f":"Data!B5","v":0},null,null,null,null,null,null,null,null,null,null,"Rev.",{"$f":"Data!B6","v":0}]
[null,"Additional Engineering Changes",null,null,null,{"$f":"Data!B7","v":0},null,null,null,null,null,null,null,null,"Rev. / Date",null,{"$f":"Data!B8","v":0}]
[null,"Tooling P.O. Number",null,null,{"$f":"Data!B15","v":0},null,null,null,null,"Purchase Order No.",null,null,{"$f":"Data!B14","v":0},null,"Weight (kg)",null,{"$f":"Data!B12","v":0}]
[null,"ORGANIZATION MANUFACTURING INFORMATION",null,null,null,null,null,null,null,"SUBMISSION INFORMATION"]
[null,{"$f":"Data!B24","v":0},null,null,null,null,null,null,null,"JACOBS VEHICLE SYSTEMS"]
[null,"Supplier Name",null,null,null,null," "]
[null,{"$f":"Data!B25","v":0},null,null,null,null,null,null,null,{"$f":"Data!B16","v":0}]
[null,"Street Address",null,null,null,null,null,null,null,"JVS Purchasing or Buyer/Planner Contact"]
[null,{"$f":"Data!B26","v":0},null,null,null,{"$f":"Data!B27","v":0},null,{"$f":"Data!B28","v":0},null,{"$f":"Data!B13","v":0}]
[null,"City",null,null,null,"State",null,"Zip",null,"Application"]
[]
[null,null,"Does this part contain any restricted or reportable substances?"]
[null,null,null,null,"Verified by:"]
[]
[]
[]
[]
[null,null,null,null,"Explanation:"]
[null,null,"IMDS #:",null,null,null,null,"Date Accepted:"]
[null,null,"Are plastic parts identified with appropriate ISO marking codes? "]
[]
[null,"REASON FOR SUBMISSION"]
[]
[]
[]
[]
[]
[]
[]
[null,"REQUESTED SUBMISSION LEVEL (Check one)"]
[null,null,"Level 1 - Warrant only (and for designated appearance items, an Appearance Approval Report) submitted to customer."]
[null,null,"Level 2 - Warrant with product samples and limited supporting data submitted to customer."]
[null,null,"Level 3 - Warrant with product samples and complete supporting data submitted to customer."]
[null,null,"Level 4 - Warrant and other requirements as defined by customer."]
[null,null,"(check)"]
[null,null,"Level 5 - Warrant with product samples and complete supporting data reviewed at supplier's manufacturing location."]
[]
[null,"DECLARATION"]
[null,"I affirm that the samples represented by this warrant are representative of our parts and have been made to the applicable customer drawings and specifications and are made from specified materials on regular production tooling with no operations other than the regular production process.  I also certify that documented evidence of such compliance is on file and available for review."]
[null,"EXPLANATION/COMMENTS:",null,null,null,{"$f":"Data!B21","v":0}]
[]
[]
[null,"List Molds / Cavities / Production Processes"]
[null,"Organization Authorized Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Date",{"$f":"Data!B19","v":0}]
[null,"Print Name",null,{"$f":"Data!B29","v":0},null,null,null,null,"Phone No.",null,{"$f":"Data!B31","v":0},null,null,"Fax No.",null,{"$f":"Data!B32","v":0}]
[null,"Title",{"$f":"Data!B30","v":0},null,null,null,null,null,"E-Mail",{"$f":"Data!B33","v":0}]
[]
[null,"FOR JVS USE ONLY"]
[null,"PPAP Warrant Disposition",null,null,null,null,null,null,null,null,null,"Comments"]
[null,"Customer Signature"]
[null,"Print Name",null,null,null,null,null,"Date"]

{"sheet":"Dispositioned PSW","index":25,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Dispositioned PSW"]
["For JVS use only"]