{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Company Information","Capability","Quality Questionnaire","Business Questionnaire","Revision Control","Questionnaire Score"],"not_rendered":{"charts":1,"images":7,"macros":1,"external_links":0,"defined_names":8,"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":"Company Information","index":0,"n_rows":140,"n_cols":21,"rows_kept":140,"cut":false,"hidden":false,"merged":[[20,1,20,2],[22,1,22,2],[24,9,24,10],[20,9,20,10],[22,9,22,10],[24,1,24,2],[25,1,25,2],[46,3,46,6],[28,3,28,6],[23,12,23,14],[62,4,62,8],[73,1,73,5],[68,0,68,2],[66,0,66,2],[64,0,64,2],[64,4,64,8],[66,4,66,8],[68,4,68,8],[24,11,24,14],[24,3,24,6],[48,1,48,2],[48,3,48,6],[42,1,42,2],[42,3,42,6],[44,3,44,6],[30,3,30,6],[26,1,26,2],[28,1,28,2],[26,3,26,6],[34,3,34,6],[36,3,36,6],[32,1,32,2],[38,3,38,6],[18,11,18,14],[13,13,13,14],[13,3,13,9],[16,3,16,6],[18,3,18,6],[16,9,16,10],[4,13,5,14],[20,3,20,6],[22,3,22,6],[20,11,20,14],[22,11,22,14],[139,3,139,6],[124,9,124,10],[135,1,135,2],[135,3,135,6],[126,5,126,10],[124,2,124,5],[137,3,137,6],[129,1,131,14],[124,12,124,13],[139,9,139,11],[137,9,137,11],[133,3,133,6],[122,12,122,13],[118,9,118,10],[122,9,122,10],[114,9,114,10],[133,13,133,15],[133,9,133,11],[112,12,112,13],[110,12,110,13],[116,9,116,10],[118,12,118,13],[50,1,50,2],[50,3,50,6],[46,1,46,2],[58,0,58,2],[54,1,54,2],[102,12,102,13],[34,13,34,15],[36,13,36,15],[38,13,38,15],[56,4,56,8],[58,4,58,8],[60,4,60,8],[83,3,83,5],[40,13,40,15],[48,8,48,11],[34,8,34,11],[38,8,38,11],[40,8,40,11],[44,8,44,11],[36,8,36,11],[44,13,44,15],[48,13,48,15],[75,1,75,14],[81,1,81,2],[99,1,99,2],[62,0,62,2],[53,1,53,2],[56,0,56,2],[91,1,91,2],[60,0,60,2],[76,1,79,14],[70,1,72,16],[83,8,83,9],[87,4,87,6],[89,4,89,6],[85,1,85,2],[87,1,87,2],[89,1,89,2],[91,3,91,4],[85,4,85,6],[1,3,1,5],[106,12,106,13],[120,12,120,13],[116,12,116,13],[114,12,114,13],[106,9,106,10],[100,9,100,10],[100,12,100,13],[101,12,101,13],[102,9,102,10],[120,9,120,10],[112,9,112,10],[110,9,110,10],[104,9,104,10],[104,12,104,13],[40,3,40,6],[3,2,4,12],[5,2,5,12],[16,1,16,2],[18,1,18,2],[18,9,18,10],[14,1,14,2],[13,1,13,2],[16,11,16,14]]}
[null,null,null,"Today's Date"]
[null,null,null,{"$f":"TODAY()","v":"2022-08-05"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,"Supplier Quality Capability Assessment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NEXTØ"]
[]
[]
[]
[null,"DIRECTIONS:"]
[null,1,"Unless directed otherwise by RTA, please complete the entire questionnaire, regardless of 3rd party certifications."]
[null,2,"Save the file and return it by e-mail within 10 working days."]
[null,3,"Please include a copy of your certifications in the e-mail (i.e. AS9100 certificate)."]
[]
[null,"Company Name:*",null,null,null,null,null,null,null,null,null,null,"Vendor ID Assigned by RTA QA"]
[null,"Ship to Address"]
[]
[null,"Street:*",null,null,null,null,null,null,null,"Street:*"]
[]
[null,"City/Town:*",null,null,null,null,null,null,null,"City/Town:*"]
[]
[null,"State/County:*",null,null,null,null,null,null,null,"State/County:*"]
[]
[null,"Zip/Post Code:*",null,null,null,null,null,null,null,"Zip/Post Code:*"]
[]
[null,"Country:*",null,null,null,null,null,null,null,"Country:*"]
[]
[null,"Phone No.:*"]
[]
[null,"Fax No.:"]
[]
[null,null,"Web Site:"]
[]
[null,"Company Organization"]
[]
[null,null,"Name:",null,null,null,null,"Title:",null,null,null,null,"Phone No.:"]
[]
[null,null,"Name:",null,null,null,null,"Title:",null,null,null,null,"Phone No.:"]
[]
[null,null,"Name:",null,null,null,null,"Title:",null,null,null,null,"Phone No.:"]
[]
[null,null,"Sales Contact:*",null,null,null,null,"Title:*",null,null,null,null,"Phone No.:*"]
[]
[null,"E-mail Address:*"]
[]
[null,null,"Quality Contact*",null,null,null,null,"Title:*",null,null,null,null,"Phone No.:*"]
[]
[null,"E-mail Address:*"]
[]
[null,"Document Control Contact:","Quality Contact:",null,null,null,null,"Title:",null,null,null,null,"Phone No.:"]
[]
[null,"E-mail Address:"]
[]
[]
[null,"Primary Type of Business*",null,"(Please provide more information in Capability tab)"]
[null,"   (select all that apply)"]
[null,null,null,"( X )",null,null,null,null,null,"( X )"]
["MFG to Customer Design",null,null,null,"Original Equipment MFG (OEM)",null,null,"Design/Manufacturer own parts"]
[]
["Design to Customer Specifications",null,null,null,"FAA/CAA Approved Repair Station"]
[]
["Assembly Shop",null,null,null,"Distribution"]
[]
["Composite Shop",null,null,null,"Agent"]
[]
["Metal Machine Shop",null,null,null,"Test Laboratory"]
[]
["Electrical Components / Wiring",null,null,null,"Calibration"]
[]
["Special Processes (see below)",null,null,null,"Raw Materials"]
[]
[null,"Special Processes includes but is not limited to: Heat Treatment, Chemical Conversion (Alodine), Anodize, Cadmium Plating, Mag Particle Inspection, Welding, Oxygen Cleaning, Shot Peening, Pressure Testing, Flammability, Calibration, Chemical Analysis, and Non-Distructive testing: Dye Penetrant, Radiographic, Ultrasonic, Eddy Current or any other process that cannot be confirmed through physical inspection."]
[]
[]
[]
[]
[null,"Summary of Product(s) / Services / Processes:"]
[]
[" "]
[]
[]
[]
[null,"Facility/ Staff",null,"(please include each employee once)"]
[]
[null,null,"Size:",null,null,null,"square feet","or",null,null,"square meters"]
[null,null,null,"qty",null,null,null,"qty"]
[null,"Production",null,null,"Certification Staff"]
[]
[null,"Quality",null,null,"Administration"]
[]
[null,"Purchasing",null,null,"Engineering"]
[]
[null,"Total Employees"]
[]
[null,null,null,"How Many Shifts are you running?"]
[]
[null,null,null,"How many days a week are you working?"]
[]
[null,null,null,"Unionized facility (Y/N)?"]
[]
[null,"Quality System",null,"(check all that applies)"]
[null,"Please send certification",null,null,null,"Compliant",null,"Certified",null,"Certification Number*",null,null,"Certification is valid until:*",null,null," "]
[null,null,null,null,null,"( X )",null,"( X )",null,null,null,null,"Date:"]
[null,"ISO-9001 or ISO-9002"]
[]
[null,"AS9100"]
[]
[null,"AS9120"]
[]
[null,null,"First Article AS9102"]
[]
[null,"Boeing D6-82479"]
[]
[null,"Non-Us Civil Aviation Authority"]
[]
[null,"MIL-Q-9858"]
[]
[null,"MIL-I-45208A"]
[]
[null,"NADCAP"]
[]
[null,"Boeing D1-4426"]
[]
[null,"ASA-100 or FAA 00-56A"]
[]
[null,"FAA "]
[]
[null,"Current RTA Supplier (specify site)"]
[]
[]
[null,"It is my understanding that the responses to this Supplier Questionnaire are subject to verification by RTA Quality Assurance personnel.  I certify the information supplied is true and complete."]
[]
[]
[]
[null,null,"Name:*",null,null,null,null,null,"Title:*",null,null,null,"Date:*"]
[]
[null,"E-mail address:*"]
[]
[null,null,"RTA Reviewed by**",null,null,null,null,null,"Date:**",null,null,null,null,null,"* Required Field"]
[]
[null,null,"RTA Reviewed by**",null,null,null,null,null,"Date:**",null,null,null,null,"** To be Assigned by RTA-QA"]

{"sheet":"Capability","index":1,"n_rows":102,"n_cols":28,"rows_kept":102,"cut":false,"hidden":false,"merged":[[80,1,80,3],[67,1,67,3],[78,1,78,3],[5,1,5,24],[18,1,18,24],[31,1,31,24],[58,1,58,24],[80,8,80,22],[76,1,76,24],[48,1,48,3],[50,1,50,3],[54,1,54,3],[69,1,69,24],[65,1,65,3],[59,1,59,3],[32,5,32,6],[8,8,8,22],[10,8,10,22],[61,8,61,22],[47,4,47,6],[59,8,59,22],[52,1,52,3],[46,1,46,3],[42,1,42,3],[38,1,38,3],[14,8,14,22],[27,8,27,22],[21,8,21,22],[25,8,25,22],[25,1,25,3],[29,8,29,22],[19,8,19,22],[27,1,27,3],[14,1,14,3],[29,1,29,3],[32,1,32,3],[101,8,101,22],[99,1,99,3],[101,1,101,3],[95,8,95,22],[99,8,99,22],[97,8,97,22],[34,1,34,3],[70,8,70,22],[97,1,97,3],[56,1,56,3],[63,1,63,3],[46,8,46,22],[34,5,34,6],[56,8,56,22],[72,8,72,22],[40,8,40,22],[52,11,52,22],[63,8,63,22],[48,11,48,22],[38,8,38,22],[50,11,50,22],[40,1,40,3],[36,8,36,22],[36,1,36,3],[95,1,95,3],[67,8,67,22],[44,8,44,22],[42,8,42,22],[93,8,93,22],[93,1,93,3],[91,8,91,22],[89,8,89,22],[89,1,89,3],[91,1,91,3],[87,1,87,3],[87,8,87,22],[78,8,78,22],[85,5,85,13],[83,8,83,22],[83,1,83,3],[74,8,74,22],[82,1,82,24],[44,1,44,3],[74,1,74,3],[70,1,70,3],[72,1,72,3],[61,1,61,3],[65,8,65,22],[1,21,1,22],[2,2,2,20],[23,1,23,3],[16,8,16,22],[21,1,21,3],[23,8,23,22],[6,1,6,3],[6,8,6,22],[16,1,16,3],[3,4,4,6],[19,1,19,3],[12,8,12,22],[12,1,12,3],[1,12,1,17],[1,19,1,20],[1,9,1,11],[4,8,4,22],[3,21,3,22],[3,18,3,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,"Vendor Name:",null,null,{"$f":"IF('Company Information'!D14=\"\",\"\",'Company Information'!D14)","v":""},null,null,null,null,null,null,"Vendor ID**",null,{"$f":"IF('Company Information'!N14=\"\",\"\",'Company Information'!N14)","v":""}]
[null,null,"In House Capability"]
[null,null,null,null,"Mark \"X\" if you are internally capable",null,null,null,null,null,null,null,null,null,null,null,null,null,"×BACK",null,null,"NEXTØ"]
[null,null,null,null,null,null,null,null,"Comments"]
[null,"Distributor"]
[null,"Distributor of Standard Aerospace Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: If you distribute customer proprietary parts, please complete as a manufacturer."]
[]
[null,null,null,"Adhesives Distributor"]
[]
[null,null,null,"Paint Distributor"]
[]
[null,"Aircraft Fasteners"]
[]
[null,"Raw Materials-Nonmetallic"]
[]
[null,"Raw Materials-Metallic"]
[]
[null,"Additional Special Processes (not included in the \"Special Processing\" section)"]
[null,"Oxygen Cleaning"]
[]
[null,"Aerospace Welding"]
[]
[null,"Pressure Testing"]
[]
[null,"Flammability",null,"Flamability"]
[]
[null,"Anodize"]
[]
[null,"Calibration"]
[]
[null,"Metal Shops (Please indicate available capacity in hours per week in comments field)"]
[null,"What typical lengths of parts do you deal with?",null,null,null,null,null,null,"(in inches)"]
[]
[null,"How long of a part can you work with?",null,null,null,null,null,null,"(in inches)"]
[]
[null,"Machining Plate"]
[]
[null,"Sheet Metal/ Stamping"]
[]
[null,"Bending / Forming"]
[]
[null,"Tubes"]
[]
[null,"Metal Machine Shop"]
[]
[null,"  Metal CNC Machines"]
[null,null,null,null,"Quantity"]
[null,"3 Axis"]
[]
[null,"4 Axis"]
[]
[null,"5 Axis"]
[]
[null,"Water Jet"]
[]
[null,"Placards"]
[]
[null,"Composites"]
[null,"Composites-Flat Panel"]
[]
[null,"Composites-Shapes"]
[]
[null,"Plastic/Rubber/Foam & Test Sample (Outside Panel)"]
[]
[null,"CNC Router (Panels, Bonded)"]
[]
[null,"Number of Routing Stations"]
[]
[null,"Electrical/ Cables"]
[null,"Electrical/ Electromechanical"]
[]
[null,"Raw Wire"]
[]
[null,"Cable Assy's"]
[]
[null,"Assembly"]
[]
[null,"Large"]
[]
[null,"Small"]
[]
[null,"Misc"]
[null,"Manufacture of Aerospace Hardware/Fasteners"]
[]
[]
[]
[null,"Vendor Managed Inventory, Currently Doing "]
[]
[null,"Capable"]
[]
[null,"Currently, for?"]
[]
[null,"Aerospace Upholstery"]
[]
[null,"Paint"]
[]
[null,"Extrusion"]
[]
[null,"Electronic Inspection"]
[]
[null,"Other, Please Specify"]

{"sheet":"Quality Questionnaire","index":2,"n_rows":159,"n_cols":59,"rows_kept":159,"cut":false,"hidden":false,"merged":[[134,3,134,4],[144,3,144,4],[66,3,66,4],[42,3,42,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[119,3,119,4],[120,3,120,4],[121,3,121,4],[78,3,78,4],[89,3,89,4],[94,3,94,4],[97,3,97,4],[98,3,98,4],[83,3,83,4],[75,3,75,4],[81,3,81,4],[68,3,68,4],[63,3,63,4],[70,3,70,4],[53,3,53,4],[91,3,91,4],[95,3,95,4],[140,9,148,9],[89,9,92,9],[94,9,99,9],[123,9,129,9],[156,9,158,9],[150,9,152,9],[117,9,121,9],[133,9,138,9],[49,3,49,4],[111,9,114,9],[58,1,58,9],[131,1,131,9],[102,9,109,9],[45,9,49,9],[60,9,63,9],[76,9,79,9],[71,3,71,4],[69,3,69,4],[60,3,60,4],[65,9,68,9],[69,9,72,9],[74,9,75,9],[92,3,92,4],[72,3,72,4],[3,3,3,4],[6,3,6,4],[4,1,4,9],[6,9,18,9],[12,3,12,4],[16,3,16,4],[14,3,14,4],[22,3,22,4],[20,3,20,4],[21,3,21,4],[3,0,3,2],[7,3,7,4],[20,9,22,9],[18,3,18,4],[8,3,8,4],[11,3,11,4],[9,3,9,4],[10,3,10,4],[13,3,13,4],[81,9,84,9],[39,3,39,4],[24,3,24,4],[30,3,30,4],[37,3,37,4],[24,9,30,9],[74,3,74,4],[65,3,65,4],[82,3,82,4],[62,3,62,4],[45,3,45,4],[77,3,77,4],[67,3,67,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[38,3,38,4],[43,3,43,4],[41,3,41,4],[61,3,61,4],[26,3,26,4],[51,3,51,4],[52,3,52,4],[32,3,32,4],[158,3,158,4],[150,3,150,4],[154,3,154,4],[148,3,148,4],[136,3,136,4],[112,3,112,4],[138,3,138,4],[137,3,137,4],[129,3,129,4],[142,3,142,4],[157,3,157,4],[116,3,116,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[140,3,140,4],[118,3,118,4],[117,3,117,4],[124,3,124,4],[125,3,125,4],[126,3,126,4],[128,3,128,4],[127,3,127,4],[143,3,143,4],[1,1,1,9],[99,3,99,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[105,3,105,4],[156,3,156,4],[151,3,151,4],[152,3,152,4],[123,3,123,4],[141,3,141,4],[133,3,133,4],[135,3,135,4],[86,9,87,9],[37,9,39,9],[54,3,54,4],[56,3,56,4],[79,3,79,4],[76,3,76,4],[87,3,87,4],[84,3,84,4],[86,3,86,4],[15,3,15,4],[101,3,101,4],[108,3,108,4],[113,3,113,4],[114,3,114,4],[25,3,25,4],[17,3,17,4],[35,3,35,4],[106,3,106,4],[109,3,109,4],[111,3,111,4],[90,3,90,4],[96,3,96,4],[107,3,107,4],[33,3,33,4],[34,3,34,4]]}
[null,null,null,{"$f":"IF('Company Information'!D14:J14=\"\",\"\",'Company Information'!D14:J14)","v":""},null,null,null,null,null,null,"Y",null,null,null,null,null,"RTA Score",3,2,1,0,null,null,null,null,null,null,"Y"]
[null,"Quality Self Assessment",null,null,null,null,null,null,null,null,"N",null,null,null,null,null,"% earned",1,0.66,0.33,0,null,null,null,null,null,null,"N"]
[null,null,null,null,"For an Answer to be Yes a company must be able to provide objective evidence. \"N/A\" responses must be justified, e.g. an exclusion stated within the supplier's quality manual. Lines highlighted red are mandatory for the Collins Aerospace Supply Chain.","Required Fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Y, N, N/A",null,null,"Question",null,"Procedure or Document Reference",null,"RTA Audit Score",null,"Comments",null,"Question Weights","Self Score1"]
[null,"Quality Management System"]
["General",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M7:M19)","v":0},{"$f":"SUM(N7:N19)","v":0},{"$f":"(N6/SUM(O7:O19))*(IF(M6>0,1,0))","v":0},null,null,{"$f":"(SUM(R13:R19))","v":0},{"$f":"(R6/SUM(S13:S19))*(IF(R6>0,1,0))","v":0},null,null,null,null,null,null,null,null,"TOTALS",null,null,null,null,null,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":"(SUM(BF7:BF19))/BG6","v":0},{"$f":"SUM(BG7:BG19)","v":9}]
[null,null,null,"How long has your company been working in the Aerospace Industry?"]
[null,null,null,"Is the Quality Management System compliant to AS9100 / AS9120? (If yes but not yet certified, indicate your goal for certification in the comments) ",null,null,null,null,null,null,null,5,{"$f":"(IF(C8=\"Y\",1,(IF(C8=\"N\",0,(IF(C8=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M8=\"n/a\",0,(IF(C8=\"N\",0,(IF(C8=\"Y\",1,0))*L8))))","v":0},{"$f":"(IF(C8=\"n/a\",0,1))*L8","v":5},null,{"$f":"(IF(C8=\"Y\",1,(IF(C8=\"N\",0,(IF(C8=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H8=3,S8*$R$2,IF(H8=2,S8*$S$2,IF(H8=1,S8*$T$2,0)))","v":0},{"$f":"(IF(C8=\"n/a\",0,1))*L8","v":5}]
[null,null,null,"If certified compliant to AS9100 or AS9120, is the certifying body accredited by the IAQG? Please indicate the CB for your certificate. In the comments field.",null,null,null,null,null,null,null,5,0,0,5,null,0,0,5]
[null,null,null,"Confirm that your company grants permission for RTA to access all OASIS (and Nadcap if applicable) data. ",null,null,null,null,null,null,null,5,0,0,5,null,0,{"$f":"IF(H10=3,S10*$R$2,IF(H10=2,S10*$S$2,IF(H10=1,S10*$T$2,0)))","v":0},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C10=\"Y\",3,(IF(C10=\"N\",0,(IF(C10=\"N/A\",\"N/A\",0)))))","v":0},{"$f":"IF(BF10=\"n/a\",0,1)","v":1}]
[null,null,null,"Does your company agree to inform RTA of any changes in its certification, registration, or accreditation within 48 hours of receiving notification of the change?",null,null,null,null,null,null,null,5,0,0,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,"Does your company have the ability to communicate in English, and are all relevant quality documents available in English?",null,null,null,null,null,null,null,5,0,0,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,"Is there a Quality Manual in use and does it describe the management of quality-related subjects?",null,null,null,null,null,null,null,5,0,0,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,"Are customer and applicable statutory and regulatory QMS requirements addressed within your company's QMS?",null,null,null,null,null,null,null,5,0,0,5,null,0,{"$f":"IF(H14=3,S14*$R$2,IF(H14=2,S14*$S$2,IF(H14=1,S14*$T$2,0)))","v":0},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BF14=\"n/a\",0,1)","v":1}]
[null,null,null,"Does the quality system include: responsibility, authorities, and a description of the facility?",null,null,null,null,null,null,null,5,0,0,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,"Have top management appointed a management representative? Please identify this person in the comments section.",null,null,null,null,null,null,null,5,{"$f":"(IF(C16=\"Y\",1,(IF(C16=\"N\",0,(IF(C16=\"N/A\",\"N/A\",0))))))*L16","v":0},0,5,null,0,{"$f":"IF(H16=3,S16*$R$2,IF(H16=2,S16*$S$2,IF(H16=1,S16*$T$2,0)))","v":0},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(BF16=\"n/a\",0,1)","v":1}]
[null,null,null,"Are the quality objectives and policy documented?",null,null,null,null,null,null,null,5,{"$f":"(IF(C17=\"Y\",1,(IF(C17=\"N\",0,(IF(C17=\"N/A\",\"N/A\",0))))))*L17","v":0},0,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,"Are periodic Management Reviews conducted on a regular basis, and do the contents meet the requirements of AS9100 Rev D?",null,null,null,null,null,null,null,5,{"$f":"(IF(C18=\"Y\",1,(IF(C18=\"N\",0,(IF(C18=\"N/A\",\"N/A\",0))))))","v":0},0,5,null,0,{"$f":"IF(H18=3,S18*$R$2,IF(H18=2,S18*$S$2,IF(H18=1,S18*$T$2,0)))","v":0},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
[null,null,null,"Are all mandatory documented procedures in place?",null,null,null,null,null,null,null,5,{"$f":"(IF(C19=\"Y\",1,(IF(C19=\"N\",0,(IF(C19=\"N/A\",\"N/A\",0))))))","v":0},0,5,null,0,0,5]
["Quality Records",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M21:M23)","v":0},{"$f":"SUM(N21:N23)","v":9},{"$f":"N20/SUM(O21:O23)*(IF(M20>0,1,0))","v":0},null,null,{"$f":"SUM(R21:R23)","v":0},{"$f":"(R20/SUM(S21:S23))*(IF(R20>0,1,0))","v":0}]
[null,null,null,"Are quality records kept? ",null,null,null,null,null,null,null,5,{"$f":"(IF(C21=\"Y\",1,(IF(C21=\"N\",0,(IF(C21=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M21=\"n/a\",0,(IF(C21=\"N\",0,1))*L21))","v":5},{"$f":"(IF(C21=\"n/a\",0,1))*L21","v":5},null,{"$f":"(IF(C21=\"Y\",1,(IF(C21=\"N\",0,(IF(C21=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H21=3,S21*$R$2,IF(H21=2,S21*$S$2,IF(H21=1,S21*$T$2,0)))","v":0},{"$f":"(IF(C21=\"n/a\",0,1))*L21","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C21=\"Y\",3,(IF(C21=\"N\",0,(IF(C21=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"If yes, at a minimum, how long are records maintained? (Minimum requirement is 10 years)",null,null,null,null,null,null,null,2,{"$f":"IF(C22=\"indefinite\",1,(IF(C22>=7,1,(IF(AND(C22<=6,4<=C22),0.75,(IF(AND(C22<=3,1<=C22),0.5,(IF(C22=\"N/A\",\"N/A\",0)))))))))","v":0},2,2,null,{"$f":"(IF(C22=\"Y\",1,(IF(C22=\"N\",0,(IF(C22=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H22=3,S22*$R$2,IF(H22=2,S22*$S$2,IF(H22=1,S22*$T$2,0)))","v":0},{"$f":"(IF(C22=\"n/a\",0,1))*L22","v":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,null,null,null,null,null,{"$f":"IF(C22>=7,3,(IF(C22<=6,1,(IF(C22=0,0,(IF(C22=\"N/A\",\"N/A\",0)))))))","v":1}]
[null,null,null,"Does the organization contact the customer before quality documents are destroyed?",null,null,null,null,null,null,null,2,0,2,2,null,{"$f":"(IF(C23=\"Y\",1,(IF(C23=\"N\",0,(IF(C23=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H23=3,S23*$R$2,IF(H23=2,S23*$S$2,IF(H23=1,S23*$T$2,0)))","v":0},{"$f":"(IF(C23=\"n/a\",0,1))*L23","v":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,null,null,null,null,null,{"$f":"IF(C23=\"Y\",3,(IF(C23=\"N\",0,(IF(C23=\"N/A\",\"N/A\",0)))))","v":0}]
["Quality Measurements",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:M31)","v":0},{"$f":"SUM(N25:N31)","v":28},{"$f":"N24/SUM(O25:O31)*(IF(M24>0,1,0))","v":0},null,null,{"$f":"SUM(R25:R31)","v":0},{"$f":"(R24/SUM(S25:S31))*(IF(R24>0,1,0))","v":0}]
[null,null,null,"Have adequate resources been allocated to maintain the quality management system and measure its effectiveness?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C25=\"Y\",1,(IF(C25=\"N\",0,(IF(C25=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H25=3,S25*$R$2,IF(H25=2,S25*$S$2,IF(H25=1,S25*$T$2,0)))","v":0},{"$f":"(IF(C25=\"n/a\",0,1))*L25","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C25=\"Y\",3,(IF(C25=\"N\",0,(IF(C25=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the company monitor customer satisfaction, including quality performance, on-time delivery, and corrective action requests, and ensure actions are identified and implemented for performance improvement?",null,null,null,null,null,null,null,4,{"$f":"(IF(C26=\"Y\",1,(IF(C26=\"N\",0,(IF(C26=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M26=\"n/a\",0,(IF(C26=\"N\",0,1))*L26))","v":4},{"$f":"(IF(C26=\"n/a\",0,1))*L26","v":4},null,{"$f":"(IF(C26=\"Y\",1,(IF(C26=\"N\",0,(IF(C26=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H26=3,S26*$R$2,IF(H26=2,S26*$S$2,IF(H26=1,S26*$T$2,0)))","v":0},{"$f":"(IF(C26=\"n/a\",0,1))*L26","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C26=\"Y\",3,(IF(C26=\"N\",0,(IF(C26=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the organization monitor and measure stated quality objectives for improvement?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C27=\"Y\",3,(IF(C27=\"N\",0,(IF(C27=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the organization monitor the effectiveness of value add processes?",null,null,null,null,null,null,null,2,0,2,2,null,0,0,2]
[null,null,null,"Does the organization monitor on time delivery and quality performance?",null,null,null,null,null,null,null,3,0,3,3,null,0,0,3]
[null,null,null,"Is action taken to improve quality if planned results are not or will not be acheived?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5]
[null,null,null,"Is action taken to improve on time delivery if planned results are not or will not be acheived?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C31=\"Y\",3,(IF(C31=\"N\",0,(IF(C31=\"N/A\",\"N/A\",0)))))","v":0}]
["Risk Management",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M33:M36)","v":0},{"$f":"SUM(N33:N36)","v":20},{"$f":"(N32/SUM(O33:O36))*(IF(M32>0,1,0))","v":0},null,null,{"$f":"SUM(R33:R36)","v":0},{"$f":"(R32/SUM(S33:S36))*(IF(R32>0,1,0))","v":0}]
[null,null,null,"Does your company have established processes for managing risk within the organization that includes assignment of responsibilities and definitions, including acceptance crietria?",null,null,null,null,null,null,null,5,{"$f":"(IF(C33=\"Y\",1,(IF(C33=\"N\",0,(IF(C33=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M33=\"n/a\",0,(IF(C33=\"N\",0,1))*L33))","v":5},{"$f":"(IF(C33=\"n/a\",0,1))*L33","v":5},null,{"$f":"(IF(C33=\"Y\",1,(IF(C33=\"N\",0,(IF(C33=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H33=3,S33*$R$2,IF(H33=2,S33*$S$2,IF(H33=1,S33*$T$2,0)))","v":0},{"$f":"(IF(C33=\"n/a\",0,1))*L33","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C33=\"Y\",3,(IF(C33=\"N\",0,(IF(C33=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is process variation and risk assessed, reduced and managed using PFMEA (Process Failure Mode and Effects Analysis), control plans, and other process control methods (please specify)?",null,null,null,null,null,null,null,5,{"$f":"(IF(C34=\"Y\",1,(IF(C34=\"N\",0,(IF(C34=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M34=\"n/a\",0,(IF(C34=\"N\",0,1))*L34))","v":5},{"$f":"(IF(C34=\"n/a\",0,1))*L34","v":5},null,{"$f":"(IF(C34=\"Y\",1,(IF(C34=\"N\",0,(IF(C34=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H34=3,S34*$R$2,IF(H34=2,S34*$S$2,IF(H34=1,S34*$T$2,0)))","v":0},{"$f":"(IF(C34=\"n/a\",0,1))*L34","v":5}]
[null,null,null,"Does your company comply with the requirements of AS9146 for FOD Prevention Programs, and include cleanliness of manufacturing programs?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C35=\"Y\",1,(IF(C35=\"N\",0,(IF(C35=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H35=3,S35*$R$2,IF(H35=2,S35*$S$2,IF(H35=1,S35*$T$2,0)))","v":0},{"$f":"(IF(C35=\"n/a\",0,1))*L35","v":5}]
[null,null,null,"Does your company operate process that could potentially induce residual magnetism in ferrous material? If so, are controls in place to maintain levels within +/- 3 Gauss?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C36=\"Y\",1,(IF(C36=\"N\",0,(IF(C36=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H36=3,S36*$R$2,IF(H36=2,S36*$S$2,IF(H36=1,S36*$T$2,0)))","v":0},{"$f":"(IF(C36=\"n/a\",0,1))*L36","v":5}]
["Signatures and Authority",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M38:M40)","v":0},{"$f":"SUM(N38:N40)","v":14},{"$f":"(N37/SUM(O38:O40))*(IF(M37>0,1,0))","v":0},null,null,{"$f":"SUM(R38:R40)","v":0},{"$f":"(R37/SUM(S38:S40))*(IF(R37>0,1,0))","v":0}]
[null,null,null,"Are procedures in place that require signatures to be rendered in ink, controlled stamps, or computer generated?",null,null,null,null,null,null,null,5,0,{"$f":"(IF(M38=\"n/a\",0,(IF(C38=\"N\",0,1))*L38))","v":5},{"$f":"(IF(C38=\"n/a\",0,1))*L38","v":5},null,{"$f":"(IF(C38=\"Y\",1,(IF(C38=\"N\",0,(IF(C38=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H38=3,S38*$R$2,IF(H38=2,S38*$S$2,IF(H38=1,S38*$T$2,0)))","v":0},{"$f":"(IF(C38=\"n/a\",0,1))*L38","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C38=\"Y\",3,(IF(C38=\"N\",0,(IF(C38=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is inspection authority defined?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C39=\"Y\",1,(IF(C39=\"N\",0,(IF(C39=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H39=3,S39*$R$2,IF(H39=2,S39*$S$2,IF(H39=1,S39*$T$2,0)))","v":0},{"$f":"(IF(C39=\"n/a\",0,1))*L39","v":5}]
[null,null,null,"Is the process for qualifying inspectors defined?",null,null,null,null,null,null,null,4,0,4,4,null,{"$f":"(IF(C40=\"Y\",1,(IF(C40=\"N\",0,(IF(C40=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H40=3,S40*$R$2,IF(H40=2,S40*$S$2,IF(H40=1,S40*$T$2,0)))","v":0},{"$f":"(IF(C40=\"n/a\",0,1))*L40","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C40=\"Y\",3,(IF(C40=\"N\",0,(IF(C40=\"N/A\",\"N/A\",0)))))","v":0}]
["Prohibited Practices",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M42:M44)","v":0},{"$f":"SUM(N42:N44)","v":15},{"$f":"(N41/SUM(O42:O44))*(IF(M41>0,1,0))","v":0},null,null,{"$f":"SUM(R42:R44)","v":0},{"$f":"(R41/SUM(S42:S44))*(IF(R41>0,1,0))","v":0}]
[null,null,null,"Does the organization ensure that conflict materials such as Tantalum, Tin,  &Gold are suitably sourced & controlled & that RTA is informed of their inclusion in any supplied product?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C42=\"Y\",1,(IF(C42=\"N\",0,(IF(C42=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H42=3,S42*$R$2,IF(H42=2,S42*$S$2,IF(H42=1,S42*$T$2,0)))","v":0},{"$f":"(IF(C42=\"n/a\",0,1))*L42","v":5}]
[null,null,null,"Is there a procedure to prevent the introduction of counterfeit materials or products into the production process or supply chain?",null,null,null,null,null,null,null,5,{"$f":"(IF(C43=\"Y\",1,(IF(C43=\"N\",0,(IF(C43=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M43=\"n/a\",0,(IF(C43=\"N\",0,1))*L43))","v":5},{"$f":"(IF(C43=\"n/a\",0,1))*L43","v":5},null,{"$f":"(IF(C43=\"Y\",1,(IF(C43=\"N\",0,(IF(C43=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H43=3,S43*$R$2,IF(H43=2,S43*$S$2,IF(H43=1,S43*$T$2,0)))","v":0},{"$f":"(IF(C43=\"n/a\",0,1))*L43","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C43=\"Y\",3,(IF(C43=\"N\",0,(IF(C43=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does this procedure ensure that the supplier, and all members of it's supply chain including distributors, comply with the requirements of AS6174?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C44=\"Y\",1,(IF(C44=\"N\",0,(IF(C44=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H44=3,S44*$R$2,IF(H44=2,S44*$S$2,IF(H44=1,S44*$T$2,0)))","v":0},{"$f":"(IF(C44=\"n/a\",0,1))*L44","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C44=\"Y\",3,(IF(C44=\"N\",0,(IF(C44=\"N/A\",\"N/A\",0)))))","v":0}]
["AS9102 First Article Inspection Report",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M46:M50)","v":0},{"$f":"SUM(N46:N50)","v":21},{"$f":"(N45/SUM(O46:O50))*(IF(M45>0,1,0))","v":0},null,null,{"$f":"SUM(R46:R50)","v":0},{"$f":"(R45/SUM(S46:S50))*(IF(R45>0,1,0))","v":0}]
[null,null,null,"Are all production parts confirmed using AS9102 First Article Inspection Reports?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C46=\"Y\",1,(IF(C46=\"N\",0,(IF(C46=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H46=3,S46*$R$2,IF(H46=2,S46*$S$2,IF(H46=1,S46*$T$2,0)))","v":0},{"$f":"(IF(C46=\"n/a\",0,1))*L46","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C46=\"Y\",3,(IF(C46=\"N\",0,(IF(C46=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Do FAI reports include a replication of part marking (e.g. a photograph or sample)?",null,null,null,null,null,null,null,4,{"$f":"(IF(C47=\"Y\",1,(IF(C47=\"N\",0,(IF(C47=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M47=\"n/a\",0,(IF(C47=\"N\",0,1))*L47))","v":4},{"$f":"(IF(C47=\"n/a\",0,1))*L47","v":4},null,{"$f":"(IF(C47=\"Y\",1,(IF(C47=\"N\",0,(IF(C47=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H47=3,S47*$R$2,IF(H47=2,S47*$S$2,IF(H47=1,S47*$T$2,0)))","v":0},{"$f":"(IF(C47=\"n/a\",0,1))*L47","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C47=\"Y\",3,(IF(C47=\"N\",0,(IF(C47=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"For assembly FAIs, does the company ensure that all lower level and detail FAIs have been completed and have been included within the report supplied to RTA?",null,null,null,null,null,null,null,4,0,4,4,null,{"$f":"(IF(C48=\"Y\",1,(IF(C48=\"N\",0,(IF(C48=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H48=3,S48*$R$2,IF(H48=2,S48*$S$2,IF(H48=1,S48*$T$2,0)))","v":0},{"$f":"(IF(C48=\"n/a\",0,1))*L48","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does the supplier ensure that each characteristic the type of inspection/measuring equipment, and the individual making the measurement/observation is recorded?",null,null,null,null,null,null,null,4,0,4,4,null,{"$f":"(IF(C49=\"Y\",1,(IF(C49=\"N\",0,(IF(C49=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H49=3,S49*$R$2,IF(H49=2,S49*$S$2,IF(H49=1,S49*$T$2,0)))","v":0},{"$f":"(IF(C49=\"n/a\",0,1))*L49","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are FAI's redone after revision changes, substantial changes to the facility or process, or if parts have not been produced within the last 2 years?",null,null,null,null,null,null,null,4,0,4,4,null,{"$f":"(IF(C50=\"Y\",1,(IF(C50=\"N\",0,(IF(C50=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H50=3,S50*$R$2,IF(H50=2,S50*$S$2,IF(H50=1,S50*$T$2,0)))","v":0},{"$f":"(IF(C50=\"n/a\",0,1))*L50","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Competence, Awareness and Training",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M52:M55)","v":0},{"$f":"SUM(N52:N55)","v":14},{"$f":"(N51/SUM(O52:O55))*(IF(M51>0,1,0))","v":0},null,null,{"$f":"SUM(R52:R55)","v":0},{"$f":"(R51/SUM(S52:S55))*(IF(R51>0,1,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are personnel who perform work affecting product quality evaluated based on appropriate education, training, skills, and experience?",null,null,null,null,null,null,null,5,{"$f":"(IF(C52=\"Y\",1,(IF(C52=\"N\",0,(IF(C52=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M52=\"n/a\",0,(IF(C52=\"N\",0,1))*L52))","v":5},{"$f":"(IF(C52=\"n/a\",0,1))*L52","v":5},null,{"$f":"(IF(C52=\"Y\",1,(IF(C52=\"N\",0,(IF(C52=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H52=3,S52*$R$2,IF(H52=2,S52*$S$2,IF(H52=1,S52*$T$2,0)))","v":0},{"$f":"(IF(C52=\"n/a\",0,1))*L52","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C52=\"Y\",3,(IF(C52=\"N\",0,(IF(C52=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the documented procedure ensure that competence is verified?",null,null,null,null,null,null,null,3,0,3,3,null,{"$f":"(IF(C53=\"Y\",1,(IF(C53=\"N\",0,(IF(C53=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H53=3,S53*$R$2,IF(H53=2,S53*$S$2,IF(H53=1,S53*$T$2,0)))","v":0},{"$f":"(IF(C53=\"n/a\",0,1))*L53","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does the company ensure that all personnel are aware of the QMS, QMS changes, their contribution to company performance (including health & safety), and the importance of etical behaviour?",null,null,null,null,null,null,null,3,0,3,3,null,{"$f":"(IF(C54=\"Y\",1,(IF(C54=\"N\",0,(IF(C54=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H54=3,S54*$R$2,IF(H54=2,S54*$S$2,IF(H54=1,S54*$T$2,0)))","v":0},{"$f":"(IF(C54=\"n/a\",0,1))*L54","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are training/skill requirements reviewed against process and capacity requirements, especially after any significant changes either to the business or the QMS?",null,null,null,null,null,null,null,3,0,3,3,null,{"$f":"(IF(C55=\"Y\",1,(IF(C55=\"N\",0,(IF(C55=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H55=3,S55*$R$2,IF(H55=2,S55*$S$2,IF(H55=1,S55*$T$2,0)))","v":0},{"$f":"(IF(C55=\"n/a\",0,1))*L55","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Certification Basis",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M57)","v":0},{"$f":"SUM(N57)","v":1},{"$f":"(N56/SUM(O57))*(IF(N56>0,1,0))","v":1},null,null,{"$f":"SUM(R57:R59)","v":0},{"$f":"IF(Q57=\"N/A\", 1,((R56/SUM(S57:S59))*(IF(R56>0,1,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does supplier hold PMA, TSO or PC on products supplied to RTA?",null,null,null,null,null,null,null,1,0,1,1,null,{"$f":"(IF(C57=\"Y\",1,(IF(C57=\"N\",0,(IF(C57=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H57=3,S57*$R$2,IF(H57=2,S57*$S$2,IF(H57=1,S57*$T$2,0)))","v":0},{"$f":"(IF(C57=\"n/a\",0,1))*L57","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Product Realization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(IF(C59=\"Y\",1,(IF(C59=\"N\",0,(IF(C59=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H59=3,S59*$R$2,IF(H59=2,S59*$S$2,IF(H59=1,S59*$T$2,0)))","v":0},{"$f":"(IF(C59=\"n/a\",0,1))*L59","v":0}]
["Contract Review",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M61:M64)","v":0},{"$f":"SUM(N61:N64)","v":19},{"$f":"(N60/SUM(O61:O64))*(IF(M60>0,1,0))","v":0},null,null,{"$f":"SUM(R61:R64)","v":0},{"$f":"(R60/SUM(S61:S64))*(IF(R60>0,1,0))","v":0}]
[null,null,null,"Are customer quality requirements accounted for prior to acceptance of work?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C61=\"Y\",1,(IF(C61=\"N\",0,(IF(C61=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H61=3,S61*$R$2,IF(H61=2,S61*$S$2,IF(H61=1,S61*$T$2,0)))","v":0},{"$f":"(IF(C61=\"n/a\",0,1))*L61","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C61=\"Y\",3,(IF(C61=\"N\",0,(IF(C61=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the organization determine product and regulatory requirements prior to accepting the RTA PO?",null,null,null,null,null,null,null,4,0,4,4,null,{"$f":"(IF(C62=\"Y\",1,(IF(C62=\"N\",0,(IF(C62=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H62=3,S62*$R$2,IF(H62=2,S62*$S$2,IF(H62=1,S62*$T$2,0)))","v":0},{"$f":"(IF(C62=\"n/a\",0,1))*L62","v":4}]
[null,null,null,"Does the organization confirm that it can supply all certifications and documentation as required by the RTA PO and product specification documents prior to accepting the order?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C63=\"Y\",1,(IF(C63=\"N\",0,(IF(C63=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H63=3,S63*$R$2,IF(H63=2,S63*$S$2,IF(H63=1,S63*$T$2,0)))","v":0},{"$f":"(IF(C63=\"n/a\",0,1))*L63","v":5}]
[null,null,null,"Where the organization cannot meet the requirements of the PO does it ensure that this is communicated to RTA and written RTA approval is received prior to acceptance of the PO?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C64=\"Y\",1,(IF(C64=\"N\",0,(IF(C64=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H64=3,S64*$R$2,IF(H64=2,S64*$S$2,IF(H64=1,S64*$T$2,0)))","v":0},{"$f":"(IF(C64=\"n/a\",0,1))*L64","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C64=\"Y\",3,(IF(C64=\"N\",0,(IF(C64=\"N/A\",\"N/A\",0)))))","v":0}]
["Purchasing and Flow down Requirements",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M66:M73)","v":0},{"$f":"SUM(N66:N73)","v":30},{"$f":"(N65/SUM(O66:O73))*(IF(M65>0,1,0))","v":0},null,null,{"$f":"SUM(R66:R73)","v":0},{"$f":"(R65/SUM(S66:S73))*(IF(R65>0,1,0))","v":0}]
[null,null,null,"Is an approved supplier list including, questionnaires, audit reports, and certifications maintained?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C66=\"Y\",1,(IF(C66=\"N\",0,(IF(C66=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H66=3,S66*$R$2,IF(H66=2,S66*$S$2,IF(H66=1,S66*$T$2,0)))","v":0},{"$f":"(IF(C66=\"n/a\",0,1))*L66","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C66=\"Y\",3,(IF(C66=\"N\",0,(IF(C66=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the company ensure that all of its suppliers are compliant to the applicable requirements of RTA's Supplier Quality Manual, and AS9100/AS9120?",null,null,null,null,null,null,null,4,{"$f":"(IF(C67=\"Y\",1,(IF(C67=\"N\",0,(IF(C67=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M67=\"n/a\",0,(IF(C67=\"N\",0,1))*L67))","v":4},{"$f":"(IF(C67=\"n/a\",0,1))*L67","v":4},null,{"$f":"(IF(C67=\"Y\",1,(IF(C67=\"N\",0,(IF(C67=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H67=3,S67*$R$2,IF(H67=2,S67*$S$2,IF(H67=1,S67*$T$2,0)))","v":0},{"$f":"(IF(C67=\"n/a\",0,1))*L67","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C67=\"Y\",3,(IF(C67=\"N\",0,(IF(C67=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the organization audit suppliers?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are suppliers approved for a defined length of time?",null,null,null,null,null,null,null,3,0,3,3,null,0,0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are all special processes suppliers described on sheet 1 'Company Information' ILAC registered and / or certified to AS9100, D1-4426 or NADCAP AC7004? ",null,null,null,null,null,null,null,3,0,3,3,null,0,0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are all agreements & instructions only accepted in writing? (e.g. purchase order, PO supplements/amendments). Verbal agreements/instructions cannot be construed as approval or authorisation).",null,null,null,null,null,null,null,3,{"$f":"(IF(C71=\"Y\",1,(IF(C71=\"N\",0,(IF(C71=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M71=\"n/a\",0,(IF(C71=\"N\",0,1))*L71))","v":3},{"$f":"(IF(C71=\"n/a\",0,1))*L71","v":3},null,{"$f":"(IF(C71=\"Y\",1,(IF(C71=\"N\",0,(IF(C71=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H71=3,S71*$R$2,IF(H71=2,S71*$S$2,IF(H71=1,S71*$T$2,0)))","v":0},{"$f":"(IF(C71=\"n/a\",0,1))*L71","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C71=\"Y\",3,(IF(C71=\"N\",0,(IF(C71=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are all documents referenced on a Purchase Order or Drawing maintained including current revision changes?",null,null,null,null,null,null,null,3,0,3,3,null,0,0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Is a System in place to ensure all requirements are flowed down to sub-tier sources?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Receiving Inspection",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M75:M80)","v":0},{"$f":"SUM(N75:N80)","v":27},{"$f":"(N74/SUM(O75:O80))*(IF(M74>0,1,0))","v":0},null,null,{"$f":"SUM(R75:R80)","v":0},{"$f":"(R74/SUM(S75:S80))*(IF(R74>0,1,0))","v":0}]
[null,null,null,"Is inspection criteria defined to ensure product conformity when material is procured for production?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C75=\"Y\",1,(IF(C75=\"N\",0,(IF(C75=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H75=3,S75*$R$2,IF(H75=2,S75*$S$2,IF(H75=1,S75*$T$2,0)))","v":0},{"$f":"(IF(C75=\"n/a\",0,1))*L75","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C75=\"Y\",3,(IF(C75=\"N\",0,(IF(C75=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"When parts are received, are they segregated until acceptance has been established?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does procedure ensure raw material is received and validated to original manufacturer's certifications and test reports?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Do you routinely use third party validation tests to ensure raw material conformity?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Do you routinely use raw material hardness test to ensure raw material conformity?",null,null,null,null,null,null,null,4,{"$f":"(IF(C79=\"Y\",1,(IF(C79=\"N\",0,(IF(C79=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M79=\"n/a\",0,(IF(C79=\"N\",0,1))*L79))","v":4},{"$f":"(IF(C79=\"n/a\",0,1))*L79","v":4},null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does your company have a process for the on-going verification of visual acuity and colour vision of individuals performing product inspection?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Traceability",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M82:M85)","v":0},{"$f":"SUM(N82:N85)","v":20},{"$f":"(N81/SUM(O82:O85))*(IF(M81>0,1,0))","v":0},null,null,{"$f":"SUM(R82:R85)","v":0},{"$f":"(R81/SUM(S82:S85))*(IF(R81>0,1,0))","v":0}]
[null,null,null,"Is a process in place that ensures all parts are traceable to the raw material they are manufactured from?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C82=\"Y\",1,(IF(C82=\"N\",0,(IF(C82=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H82=3,S82*$R$2,IF(H82=2,S82*$S$2,IF(H82=1,S82*$T$2,0)))","v":0},{"$f":"(IF(C82=\"n/a\",0,1))*L82","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C82=\"Y\",3,(IF(C82=\"N\",0,(IF(C82=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is there a system in place that demonstrates full traceability where raw material has been used, and that the source is an authorised supplier?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C83=\"Y\",1,(IF(C83=\"N\",0,(IF(C83=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H83=3,S83*$R$2,IF(H83=2,S83*$S$2,IF(H83=1,S83*$T$2,0)))","v":0},{"$f":"(IF(C83=\"n/a\",0,1))*L83","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C83=\"Y\",3,(IF(C83=\"N\",0,(IF(C83=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are all raw material certs being filed in a retrievable manner?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C84=\"Y\",1,(IF(C84=\"N\",0,(IF(C84=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H84=3,S84*$R$2,IF(H84=2,S84*$S$2,IF(H84=1,S84*$T$2,0)))","v":0},{"$f":"(IF(C84=\"n/a\",0,1))*L84","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C84=\"Y\",3,(IF(C84=\"N\",0,(IF(C84=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is there a documented FIFO system in place?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C85=\"Y\",1,(IF(C85=\"N\",0,(IF(C85=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H85=3,S85*$R$2,IF(H85=2,S85*$S$2,IF(H85=1,S85*$T$2,0)))","v":0},{"$f":"(IF(C85=\"n/a\",0,1))*L85","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C85=\"Y\",3,(IF(C85=\"N\",0,(IF(C85=\"N/A\",\"N/A\",0)))))","v":0}]
["Buyer Furnished Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M87:M88)","v":0},{"$f":"SUM(N87:N88)","v":10},{"$f":"IF(M86=0,0,((N86/SUM(O87:O88))*(IF(M86>0,1,0))))","v":0},null,null,{"$f":"SUM(R87:R88)","v":0},{"$f":"IF(R86=0,0,((R86/SUM(S87:S88))*(IF(R86>0,1,0))))","v":0}]
[null,null,null,"Does procedure ensure that all customer furnished product and tooling is identified as such?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C87=\"Y\",1,(IF(C87=\"N\",0,(IF(C87=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H87=3,S87*$R$2,IF(H87=2,S87*$S$2,IF(H87=1,S87*$T$2,0)))","v":0},{"$f":"(IF(C87=\"n/a\",0,1))*L87","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C87=\"Y\",3,(IF(C87=\"N\",0,(IF(C87=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does procedure ensure that customer furnished product and tooling is controlled and appropriate actions are taken to ensure its proper use?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C88=\"Y\",1,(IF(C88=\"N\",0,(IF(C88=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H88=3,S88*$R$2,IF(H88=2,S88*$S$2,IF(H88=1,S88*$T$2,0)))","v":0},{"$f":"(IF(C88=\"n/a\",0,1))*L88","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C88=\"Y\",3,(IF(C88=\"N\",0,(IF(C88=\"N/A\",\"N/A\",0)))))","v":0}]
["Document and Drawing Control",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M90:M93)","v":0},{"$f":"SUM(N90:N93)","v":20},{"$f":"(N89/SUM(O90:O93))*(IF(M89>0,1,0))","v":0},null,null,{"$f":"SUM(R90:R93)","v":0},{"$f":"(R89/SUM(S90:S93))*(IF(R89>0,1,0))","v":0}]
[null,null,null,"Are drawings and revisions thereof controlled?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C90=\"Y\",1,(IF(C90=\"N\",0,(IF(C90=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H90=3,S90*$R$2,IF(H90=2,S90*$S$2,IF(H90=1,S90*$T$2,0)))","v":0},{"$f":"(IF(C90=\"n/a\",0,1))*L90","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C90=\"Y\",3,(IF(C90=\"N\",0,(IF(C90=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are pertinent revisions of drawings available at the necessary work and quality locations?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C91=\"Y\",1,(IF(C91=\"N\",0,(IF(C91=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H91=3,S91*$R$2,IF(H91=2,S91*$S$2,IF(H91=1,S91*$T$2,0)))","v":0},{"$f":"(IF(C91=\"n/a\",0,1))*L91","v":5}]
[null,null,null,"Does your company prevent the unintended use of obsolete documented information by removal or by other suitable controls if kept for any purpose (please specify)?",null,null,null,null,null,null,null,5,{"$f":"(IF(C92=\"Y\",1,(IF(C92=\"N\",0,(IF(C92=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M92=\"n/a\",0,(IF(C92=\"N\",0,1))*L92))","v":5},{"$f":"(IF(C92=\"n/a\",0,1))*L92","v":5},null,{"$f":"(IF(C92=\"Y\",1,(IF(C92=\"N\",0,(IF(C92=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H92=3,S92*$R$2,IF(H92=2,S92*$S$2,IF(H92=1,S92*$T$2,0)))","v":0},{"$f":"(IF(C92=\"n/a\",0,1))*L92","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C92=\"Y\",3,(IF(C92=\"N\",0,(IF(C92=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Has an individual within the organization been given the responsibility to ensure all documents are adequately controlled?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C93=\"Y\",1,(IF(C93=\"N\",0,(IF(C93=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H93=3,S93*$R$2,IF(H93=2,S93*$S$2,IF(H93=1,S93*$T$2,0)))","v":0},{"$f":"(IF(C93=\"n/a\",0,1))*L93","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C93=\"Y\",3,(IF(C93=\"N\",0,(IF(C93=\"N/A\",\"N/A\",0)))))","v":0}]
["Configuration and Change Management",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M95:M100)","v":0},{"$f":"SUM(N95:N100)","v":27},{"$f":"(N94/SUM(O95:O100))*(IF(M94>0,1,0))","v":0},null,{"$f":"SUM(Q95:Q100)","v":0},{"$f":"SUM(R95:R100)","v":0},{"$f":"(R94/SUM(S95:S100))*(IF(R94>0,1,0))","v":0}]
[null,null,null,"Is a system in place for review of customer changes?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C95=\"Y\",1,(IF(C95=\"N\",0,(IF(C95=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H95=3,S95*$R$2,IF(H95=2,S95*$S$2,IF(H95=1,S95*$T$2,0)))","v":0},{"$f":"(IF(C95=\"n/a\",0,1))*L95","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C95=\"Y\",3,(IF(C95=\"N\",0,(IF(C95=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does your company's processes ensure that documented information is maintained consistent with the actual attributes  of the products and services provided?",null,null,null,null,null,null,null,4,{"$f":"(IF(C96=\"Y\",1,(IF(C96=\"N\",0,(IF(C96=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M96=\"n/a\",0,(IF(C96=\"N\",0,1))*L96))","v":4},{"$f":"(IF(C96=\"n/a\",0,1))*L96","v":4},null,{"$f":"(IF(C96=\"Y\",1,(IF(C96=\"N\",0,(IF(C96=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H96=3,S96*$R$2,IF(H96=2,S96*$S$2,IF(H96=1,S96*$T$2,0)))","v":0},{"$f":"(IF(C96=\"n/a\",0,1))*L96","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C96=\"Y\",3,(IF(C96=\"N\",0,(IF(C96=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is there an impact analysis on manufacturing, tooling, sub tiers suppliers, quality, etc?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C97=\"Y\",3,(IF(C97=\"N\",0,(IF(C97=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is the impact reviewed and approved by all affected parties?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4]
[null,null,null,"Does the organization have a procedure managing transfers of work, that includes informing RTA prior to changes being made? This includes changes in location and subcontracted suppliers.",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5]
[null,null,null,"Does the organization flow this requirement down to sub tier and subcontracted suppliers?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C100=\"Y\",3,(IF(C100=\"N\",0,(IF(C100=\"N/A\",\"N/A\",0)))))","v":0}]
["Manufacturing Controls",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M103:M110)","v":0},{"$f":"SUM(N103:N110)","v":40},{"$f":"(N101/SUM(O103:O110))*(IF(M101>0,1,0))","v":0},null,{"$f":"SUM(Q103:Q110)","v":0},{"$f":"SUM(R103:R110)","v":0},{"$f":"(R101/SUM(S103:S110))*(IF(R101>0,1,0))","v":0}]
[null,null,null,"Do instructions (work order or like document) for all product manufactured include the following:"]
[null,null,null,"Manufacturing sequence steps?",null,null,null,null,null,null,null,5,{"$f":"(IF(C103=\"Y\",1,(IF(C103=\"N\",0,(IF(C103=\"N/A\",\"N/A\",0))))))","v":0},5,5,null,{"$f":"(IF(C103=\"Y\",1,(IF(C103=\"N\",0,(IF(C103=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H103=3,S103*$R$2,IF(H103=2,S103*$S$2,IF(H103=1,S103*$T$2,0)))","v":0},{"$f":"(IF(C103=\"n/a\",0,1))*L103","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C103=\"Y\",3,(IF(C103=\"N\",0,(IF(C103=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Lot or batch number traceability for raw material?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Routings for Special Processes required and approved Special Process Houses?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Part number and drawing revision?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are work instructions and the revisions thereof reviewed, approved, controlled and documented?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are product / parts and the inspection status thereof identifiable throughout the manufacturing cycle?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Is a system in place that ensures no substitutions for required raw material are used unless granted by customer's engineering?",null,null,null,null,null,null,null,5,{"$f":"(IF(C109=\"Y\",1,(IF(C109=\"N\",0,(IF(C109=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M109=\"n/a\",0,(IF(C109=\"N\",0,1))*L109))","v":5},{"$f":"(IF(C109=\"n/a\",0,1))*L109","v":5},null,{"$f":"(IF(C109=\"Y\",1,(IF(C109=\"N\",0,(IF(C109=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H109=3,S109*$R$2,IF(H109=2,S109*$S$2,IF(H109=1,S109*$T$2,0)))","v":0},{"$f":"(IF(C109=\"n/a\",0,1))*L109","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C109=\"Y\",3,(IF(C109=\"N\",0,(IF(C109=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does your company have defined storage requirements for production equipment or tooling in storage, including periodic preservation or condition checks?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Preservation of Product",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M112:M115)","v":0},{"$f":"SUM(N112:N115)","v":20},{"$f":"(N111/SUM(O112:O115))*(IF(M111>0,1,0))","v":0},null,null,{"$f":"SUM(R112:R115)","v":0},{"$f":"(R111/SUM(S112:S115))*(IF(R111>0,1,0))","v":0}]
[null,null,null,"Are appropriate methods used to prevent part damage or contamination? For example, does the company employ the 5S methodology (or equivalent) for industrial housekeeping?",null,null,null,null,null,null,null,5,0,{"$f":"(IF(M112=\"n/a\",0,(IF(C112=\"N\",0,1))*L112))","v":5},{"$f":"(IF(C112=\"n/a\",0,1))*L112","v":5},null,{"$f":"(IF(C112=\"Y\",1,(IF(C112=\"N\",0,(IF(C112=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H112=3,S112*$R$2,IF(H112=2,S112*$S$2,IF(H112=1,S112*$T$2,0)))","v":0},{"$f":"(IF(C112=\"n/a\",0,1))*L112","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C112=\"Y\",3,(IF(C112=\"N\",0,(IF(C112=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are age sensitive products / parts / materials identified and controlled?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C113=\"Y\",1,(IF(C113=\"N\",0,(IF(C113=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H113=3,S113*$R$2,IF(H113=2,S113*$S$2,IF(H113=1,S113*$T$2,0)))","v":0},{"$f":"(IF(C113=\"n/a\",0,1))*L113","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C113=\"Y\",3,(IF(C113=\"N\",0,(IF(C113=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are special environmental controls utilized in manufacturing, assembly, and inspection areas when warranted?",null,null,null,null,null,null,null,5,{"$f":"(IF(C114=\"Y\",1,(IF(C114=\"N\",0,(IF(C114=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M114=\"n/a\",0,(IF(C114=\"N\",0,1))*L114))","v":5},{"$f":"(IF(C114=\"n/a\",0,1))*L114","v":5},null,{"$f":"(IF(C114=\"Y\",1,(IF(C114=\"N\",0,(IF(C114=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H114=3,S114*$R$2,IF(H114=2,S114*$S$2,IF(H114=1,S114*$T$2,0)))","v":0},{"$f":"(IF(C114=\"n/a\",0,1))*L114","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C114=\"Y\",3,(IF(C114=\"N\",0,(IF(C114=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the company appropriately identify product for delivery, including safety warnings and cautions?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C115=\"Y\",1,(IF(C115=\"N\",0,(IF(C115=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H115=3,S115*$R$2,IF(H115=2,S115*$S$2,IF(H115=1,S115*$T$2,0)))","v":0},{"$f":"(IF(C115=\"n/a\",0,1))*L115","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C115=\"Y\",3,(IF(C115=\"N\",0,(IF(C115=\"N/A\",\"N/A\",0)))))","v":0}]
["Control of Monitoring and Measuring Devices",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M118:M122)","v":0},{"$f":"SUM(N118:N122)","v":21},{"$f":"(N116/SUM(O118:O122))*(IF(M116>0,1,0))","v":0},null,null,{"$f":"SUM(R118:R122)","v":0},{"$f":"(R116/SUM(S118:S122))*(IF(R116>0,1,0))","v":0}]
[null,null,null,"Has your company ensured that all necessary measurement resources are available to verify all required variable and attribute data associated with products and services provided?",null,null,null,null,null,null,null,4,{"$f":"(IF(C117=\"Y\",1,(IF(C117=\"N\",0,(IF(C117=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M117=\"n/a\",0,(IF(C117=\"N\",0,1))*L117))","v":4},{"$f":"(IF(C117=\"n/a\",0,1))*L117","v":4},null,{"$f":"(IF(C117=\"Y\",1,(IF(C117=\"N\",0,(IF(C117=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H117=3,S117*$R$2,IF(H117=2,S117*$S$2,IF(H117=1,S117*$T$2,0)))","v":0},{"$f":"(IF(C117=\"n/a\",0,1))*L117","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C117=\"Y\",3,(IF(C117=\"N\",0,(IF(C117=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"If applicable, does your company have a process that ensures production tools are managed and  calibrated per National Institute of Standards (NIST) or international equivalent?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"If applicable, does your company have a process that ensures inspection tools are managed and calibrated per NIST or international equivalent?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does the supplier ensure that their calibration control process (or if sub-contracted, the supplier's system) meets the requirements of one of the following; ISO10012, ISO17025, or ANSI/NCSL Z540.3?",null,null,null,null,null,null,null,4,{"$f":"(IF(C120=\"Y\",1,(IF(C120=\"N\",0,(IF(C120=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M120=\"n/a\",0,(IF(C120=\"N\",0,1))*L120))","v":4},{"$f":"(IF(C120=\"n/a\",0,1))*L120","v":4},null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are tools used for production or inspection labeled with a unique identifier and a minimum of the due date for the next calibration?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does the supplier perform an impact review whenever monitoring and measuring equipment is identified with a significant out of tolerance condition?",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Packaging & Shipping",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M124:M130)","v":0},{"$f":"SUM(N124:N130)","v":29},{"$f":"(N123/SUM(O124:O130))*(IF(M123>0,1,0))","v":0},null,null,{"$f":"SUM(R124:R132)","v":0},{"$f":"(R123/SUM(S124:S132))*(IF(R123>0,1,0))","v":0}]
[null,null,null,"Does procedure ensure that all shipped product is appropriately wrapped to protect it while shipping?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C124=\"Y\",1,(IF(C124=\"N\",0,(IF(C124=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H124=3,S124*$R$2,IF(H124=2,S124*$S$2,IF(H124=1,S124*$T$2,0)))","v":0},{"$f":"(IF(C124=\"n/a\",0,1))*L124","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C124=\"Y\",3,(IF(C124=\"N\",0,(IF(C124=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the supplier ensure that all packaging is suitable for the product? i.e. acid free paper is used for metallic items.",null,null,null,null,null,null,null,5,0,{"$f":"(IF(M125=\"n/a\",0,(IF(C125=\"N\",0,1))*L125))","v":5},{"$f":"(IF(C125=\"n/a\",0,1))*L125","v":5},null,0,0,5]
[null,null,null,"Does the supplier ensure that packaging does not increase FOD control requirements? E.g. The supplier does not use polystyrene pellets within packages.",null,null,null,null,null,null,null,4,0,4,4,null,0,0,4]
[null,null,null,"Does the supplier perform any testing on packaging (e.g. drop testing) to ensure that items are adequately protected in transit?",null,null,null,null,null,null,null,3,0,3,3,null,0,0,3]
[null,null,null,"Does the supplier ensure that all packages are, where possible, maintained below 25kg, or if not able to keep under this limit, are appropriately marked?",null,null,null,null,null,null,null,3,0,{"$f":"(IF(M128=\"n/a\",0,(IF(C128=\"N\",0,1))*L128))","v":3},{"$f":"(IF(C128=\"n/a\",0,1))*L128","v":3},null,0,0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C128=\"Y\",3,(IF(C128=\"N\",0,(IF(C128=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Is there a documented procedure to ensure that all import paperwork (Commercial Invoice, Cert of Origin, etc.) will be prepared correctly for UK import? (N/A for UK suppliers)",null,null,null,null,null,null,null,4,{"$f":"(IF(C129=\"Y\",1,(IF(C129=\"N\",0,(IF(C129=\"N/A\",\"N/A\",0))))))","v":0},4,4,null,0,0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C129=\"Y\",3,(IF(C129=\"N\",0,(IF(C129=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Have shipping label requirements been adequately identified to ensure all RTA product is appropriately identified?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C130=\"Y\",3,(IF(C130=\"N\",0,(IF(C130=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Measurement, Analysis and Improvement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Nonconforming Product",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M134:M139)","v":0},{"$f":"SUM(N134:N139)","v":30},{"$f":"(N133/SUM(O134:O139))*(IF(M133>0,1,0))","v":0},null,null,{"$f":"SUM(R134:R139)","v":0},{"$f":"(R133/SUM(S134:S139))*(IF(R133>0,1,0))","v":0}]
[null,null,null,"When nonconforming product is identified during manufacturing, is it immediately identified and removed?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C134=\"Y\",1,(IF(C134=\"N\",0,(IF(C134=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H134=3,S134*$R$2,IF(H134=2,S134*$S$2,IF(H134=1,S134*$T$2,0)))","v":0},{"$f":"(IF(C134=\"n/a\",0,1))*L134","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C134=\"Y\",3,(IF(C134=\"N\",0,(IF(C134=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does procedure ensure that all product found to be nonconforming is identified and protected to ensure it is not used inadvertently in production (MRB)?",null,null,null,null,null,null,null,5,{"$f":"(IF(C135=\"Y\",1,(IF(C135=\"N\",0,(IF(C135=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M135=\"n/a\",0,(IF(C135=\"N\",0,1))*L135))","v":5},{"$f":"(IF(C135=\"n/a\",0,1))*L135","v":5},null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does procedure ensure that RTA are informed within 24 hours of discovery of suspect non-conforming product having been shipped, regardless of destination?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Has a documented procedure been established to define controls, responsibilities and authorities for dealing with nonconforming product and the necessary records?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Is a system in place that ensures \"repairs\" or \"use as is\" are not preformed unless granted by the customer in writing?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does procedure ensure that all resubmitted product is labeled as \"replacement\", \"reworked\", or \"repaired\"?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Internal Audits and Corrective Action (CA/PA)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M141:M149)","v":0},{"$f":"SUM(N141:N149)","v":45},{"$f":"(N140/SUM(O141:O149))*(IF(M140>0,1,0))","v":0},null,null,{"$f":"SUM(R141:R149)","v":0},{"$f":"(R140/SUM(S141:S149))*(IF(R140>0,1,0))","v":0}]
[null,null,null,"Is there an internal auditing program to verify compliance with established policies and procedures?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C141=\"Y\",1,(IF(C141=\"N\",0,(IF(C141=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H141=3,S141*$R$2,IF(H141=2,S141*$S$2,IF(H141=1,S141*$T$2,0)))","v":0},{"$f":"(IF(C141=\"n/a\",0,1))*L141","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C141=\"Y\",3,(IF(C141=\"N\",0,(IF(C141=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are results of internal audits reported to management and are the audits used for improvement of the system/product?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does procedure ensure that nonconformities are addressed with Corrective and Preventative actions?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Are procedures in place to ensure that Corrective / Preventative actions include: containment action, root cause analysis, corrective / preventative action plan, and verification?",null,null,null,null,null,null,null,5,{"$f":"(IF(C144=\"Y\",1,(IF(C144=\"N\",0,(IF(C144=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"(IF(M144=\"n/a\",0,(IF(C144=\"N\",0,1))*L144))","v":5},{"$f":"(IF(C144=\"n/a\",0,1))*L144","v":5},null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Is the company's root cause and corrective action process consistent with the 8D methodology in AS13000?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Upon implementation of corrective action, to ensure effectiveness, does the supplier have a documented process that ensures 100% over-inspection for at least the next 3 consecutive production lots?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C146=\"Y\",1,(IF(C146=\"N\",0,(IF(C146=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H146=3,S146*$R$2,IF(H146=2,S146*$S$2,IF(H146=1,S146*$T$2,0)))","v":0},{"$f":"(IF(C146=\"n/a\",0,1))*L146","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C146=\"Y\",3,(IF(C146=\"N\",0,(IF(C146=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Does the company flow down the corrective action requirements to an external provider when it is determined that the external provider is responsible for the nonconformity?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does the company take appropriate action when either timely correction is not taken, or the actions taken prove to be ineffective?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Does the company have an established continual improvement program that includes monitors that evaluate the effectiveness of the results?",null,null,null,null,null,null,null,5,0,5,5,null,0,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Inspection",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M151:M153)","v":0},{"$f":"SUM(N151:N153)","v":14},{"$f":"(N150/SUM(O151:O153))*(IF(M150>0,1,0))","v":0},null,null,{"$f":"SUM(R151:R153)","v":0},{"$f":"(R150/SUM(S151:S153))*(IF(R150>0,1,0))","v":0}]
[null,null,null,"Are in process inspections performed?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C151=\"Y\",1,(IF(C151=\"N\",0,(IF(C151=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H151=3,S151*$R$2,IF(H151=2,S151*$S$2,IF(H151=1,S151*$T$2,0)))","v":0},{"$f":"(IF(C151=\"n/a\",0,1))*L151","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C151=\"Y\",3,(IF(C151=\"N\",0,(IF(C151=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are final inspections performed to ensure that all product conforms to applicable drawing and PO requirements prior to being released to your customer (including current rev of dwg)?",null,null,null,null,null,null,null,4,0,4,4,null,{"$f":"(IF(C152=\"Y\",1,(IF(C152=\"N\",0,(IF(C152=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H152=3,S152*$R$2,IF(H152=2,S152*$S$2,IF(H152=1,S152*$T$2,0)))","v":0},{"$f":"(IF(C152=\"n/a\",0,1))*L152","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C152=\"Y\",3,(IF(C152=\"N\",0,(IF(C152=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are inspections performed according to approved Quality Assurance Plans / Checklists? Are Quality Plans revised based on drawing revisions, change in customer requirements etc.?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C153=\"Y\",1,(IF(C153=\"N\",0,(IF(C153=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H153=3,S153*$R$2,IF(H153=2,S153*$S$2,IF(H153=1,S153*$T$2,0)))","v":0},{"$f":"(IF(C153=\"n/a\",0,1))*L153","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C153=\"Y\",3,(IF(C153=\"N\",0,(IF(C153=\"N/A\",\"N/A\",0)))))","v":0}]
["Statistical Techniques",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M155)","v":0},{"$f":"SUM(N155)","v":3},{"$f":"(N154/SUM(O155))*(IF(M154>0,1,0))","v":0},null,null,{"$f":"SUM(R155)","v":0},{"$f":"(R154/SUM(S155))*(IF(R154>0,1,0))","v":0}]
[null,null,null,"Do you use a documented Statistical program to ensure Quality requirements are met? (please indicate in Comment field which standard it is compliant to i.e. ANSI/ASQC Z1.4-1993)",null,null,null,null,null,null,null,3,0,3,3,null,{"$f":"(IF(C155=\"Y\",1,(IF(C155=\"N\",0,(IF(C155=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H155=3,S155*$R$2,IF(H155=2,S155*$S$2,IF(H155=1,S155*$T$2,0)))","v":0},{"$f":"(IF(C155=\"n/a\",0,1))*L155","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C155=\"Y\",3,(IF(C155=\"N\",0,(IF(C155=\"N/A\",\"N/A\",0)))))","v":0}]
["Certificate of Conformance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M157:M159)","v":0},{"$f":"SUM(N157:N159)","v":15},{"$f":"(N156/SUM(O157:O159))*(IF(M156>0,1,0))","v":0},null,null,{"$f":"SUM(R157:R159)","v":0},{"$f":"(R156/SUM(S157:S159))*(IF(R156>0,1,0))","v":0}]
[null,null,null,"Does your Certificate of Conformance include: part number, revision, raw material, special processes, quantity, trace information, shipping reference, and customer PO number?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C157=\"Y\",1,(IF(C157=\"N\",0,(IF(C157=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H157=3,S157*$R$2,IF(H157=2,S157*$S$2,IF(H157=1,S157*$T$2,0)))","v":0},{"$f":"(IF(C157=\"n/a\",0,1))*L157","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C157=\"Y\",3,(IF(C157=\"N\",0,(IF(C157=\"N/A\",\"N/A\",0)))))","v":0}]
[null,null,null,"Are all certificates of conformance signed by an authorized person within the organization?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C158=\"Y\",1,(IF(C158=\"N\",0,(IF(C158=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H158=3,S158*$R$2,IF(H158=2,S158*$S$2,IF(H158=1,S158*$T$2,0)))","v":0},{"$f":"(IF(C158=\"n/a\",0,1))*L158","v":5}]
[null,null,null,"Are records maintained to indicate the person(s) authorizing release of product?",null,null,null,null,null,null,null,5,0,5,5,null,{"$f":"(IF(C159=\"Y\",1,(IF(C159=\"N\",0,(IF(C159=\"N/A\",\"N/A\",0))))))","v":0},{"$f":"IF(H159=3,S159*$R$2,IF(H159=2,S159*$S$2,IF(H159=1,S159*$T$2,0)))","v":0},{"$f":"(IF(C159=\"n/a\",0,1))*L159","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(C159=\"Y\",3,(IF(C159=\"N\",0,(IF(C159=\"N/A\",\"N/A\",0)))))","v":0}]

{"sheet":"Business Questionnaire","index":3,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,3,1,7],[3,0,3,2],[3,3,3,4],[4,1,4,7],[6,3,6,4],[6,7,11,7],[7,3,7,4],[8,3,8,4],[9,3,9,4],[11,3,11,4],[10,3,10,4],[13,7,16,7],[16,3,16,4],[18,3,18,4],[18,7,20,7],[19,3,19,4],[20,3,20,4],[14,3,14,4],[15,3,15,4],[13,3,13,4],[23,3,23,4],[32,7,34,7],[33,3,33,4],[34,3,34,4],[29,3,29,4],[29,7,30,7],[30,3,30,4],[32,3,32,4],[24,3,24,4],[25,3,25,4],[22,7,24,7],[25,7,27,7],[26,3,26,4],[27,3,27,4],[22,3,22,4],[39,7,40,7],[40,3,40,4],[35,3,35,4],[35,7,37,7],[36,3,36,4],[37,3,37,4],[39,3,39,4]]}
[null,null,null,{"$f":"IF('Company Information'!D14:J14=\"\",\"\",'Company Information'!D14:J14)","v":""},null,null,null,null,"Y"]
[null,null,null,"Business Questionnaire",null,null,null,null,"N"]
[null,null,null,null,"For an Answer to be Yes a company must be able to provide objective evidence. \"N/A\" responses must be justified, e.g. an exclusion stated within the supplier's quality manual.","Required Fields",null,"×BACK"]
["Y, N, N/A",null,null,"Question",null,"Procedure or Document Reference",null,"Comments"]
[null,"Organization, Finance & Legal"]
["Organization, HR, Finance & Legal"]
[null,null,null,"Are organizational charts available that define roles and responsibilities?"]
[null,null,null,"Are future business plans available?"]
[null,null,null,"Have there been any strikes, lock outs, laobor disputes within last 3 years?"]
[null,null,null,"Does the organization have R&D facilities?"]
[null,null,null,"Does the organization have a disaster recovery plan?"]
[null,null,null,"Has the supplier signed a non-disclosure agreement?"]
["Design & Engineering"]
[null,null,null,"Are there in house CAD, CAM, Prototyping capabilities?"]
[null,null,null,"Does the supplier have access to necessary government and industry regulations?"]
[null,null,null,"Are there testing (dynamic, static, cycle, functional) capabilities?"]
[null,null,null,"If the design is outsourced, what is the supplier's control mechanism for outsourced design?"]
["Tooling facilities"]
[null,null,null,"Does the supplier have in-house tool design and manufacturing capabilities?"]
[null,null,null,"If the tooling is outsourced, what is the supplier's control mechanism for outsourced tooling?"]
[null,null,null,"Are tool designs accessible to customers?"]
["Manufacturing facilities"]
[null,null,null,"Does the supplier carry out all critical operations in-house. Are the machinery and equipment suitable for the associated design requirements?"]
[null,null,null,"Is material handling equipment suitable for RTA ordered parts / assemblies?"]
[null,null,null,"Is the supplier monitoring level of scrap or waste generated?"]
[null,null,null,"Is there proper storage facilities for raw material, work-in-progress, finished goods, tooling and consumables that will maintain these in good condition?"]
[null,null,null,"Is the supplier following any world class manufacturing practices like TPM, 5S, JIT etc.?"]
[null,null,null,"Is there spare capacity available for RTA orders (Present and future)?"]
["Safety and Environment"]
[null,null,null,"Does the supplier maintain a record of safety incidents?"]
[null,null,null,"Does the supplier have Safety, Health and Environment certifications?"]
["Purchasing and Flow down Requirements"]
[null,null,null,"Does the supplier have a goods return / warranty policy"]
[null,null,null,"Is the supplier open for exercising VMI (Vendor Managed Inventory) concept?"]
[null,null,null,"Does the supplier have EDI (Electronic Data Interface) facilities?"]
[null,null,null,"Does the supplier possess JIT (Just-In-Time) capability?",null,"Demonstrating this already"]
[null,null,null,"Does supplier have returnable packaging capability?"]
[null,null,null,"Does the supplier possess barcode facilities?"]
["Continuous Improvement"]
[null,null,null,"Is the supplier practicing continuous improvement techniques like Kaizen, Six Sigma or Lean Initiatives?",null,"Lean activities are implemented"]
[null,null,null,"Can the supplier demonstrate that Continuous Improvement metrics are in practice and are effective?",null,"Refer to CSIP"]

{"sheet":"Revision Control","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,2,13,3],[0,0,0,7],[7,0,7,7],[2,0,2,2],[11,2,11,3],[12,2,12,3],[3,0,3,2],[4,0,4,2],[5,0,5,2],[9,2,9,3]]}
["RTA International Inc."]
[]
["FORM NO:",null,null,2001]
["TITLE: ",null,null,"Supplier Quality Capability Assessment"]
["REVISION:",null,null,"E"]
["ISSUE DATE: ",null,null,"22nd February 2019"]
[]
["REVISION HISTORY:"]
[]
["Rev","Tabs Effected:","Description",null,"Changed by:","Page Status","Approved","Date"]
[]
["C","ALL","Complete re-write and reformat in line with AS9100",null,"D Hannon","All","L Pento","27-Jan-15"]
["D","Company information","Unless otherwise directed by RTA,…\" to note 1 to allow for form use with Priority 2 suppliers.",null,"D Hannon","Single","L Pento","9-Feb-15"]
["E","Company information\nQuality Questionnaire","AS9120 added to company information.\nVarious items amended and added to the quality questionnaire in line with AS9100 and customer requirement updates.",null,"D Hannon","Two","L Pento","22-Feb-19"]

{"sheet":"Questionnaire Score","index":5,"n_rows":1155,"n_cols":46,"rows_kept":1155,"cut":false,"hidden":true,"merged":[[52,24,52,26],[52,5,52,12],[53,5,53,12],[51,1,51,2],[49,5,49,12],[50,5,50,12],[52,1,52,2],[50,1,50,2],[52,19,53,20],[52,21,53,21],[53,1,53,2],[58,19,61,29],[55,25,56,29],[55,19,56,24],[60,5,60,12],[59,5,59,12],[55,5,55,12],[39,19,40,22],[50,19,50,20],[51,19,51,20],[48,24,48,26],[51,24,51,26],[49,24,50,26],[41,19,45,29],[46,19,47,27],[48,19,48,20],[49,19,49,20],[49,27,50,27],[33,5,33,6],[33,9,33,10],[35,1,36,11],[31,26,31,31],[35,16,39,16],[35,20,35,29],[36,21,36,29],[36,19,36,20],[38,1,38,6],[39,1,40,3],[40,5,40,12],[38,20,38,29],[35,13,39,13],[35,14,39,14],[35,15,39,15],[37,20,37,29],[46,1,46,2],[48,1,48,2],[47,1,47,2],[48,5,48,12],[54,1,54,2],[49,1,49,2],[54,5,54,12],[42,1,42,2],[41,1,41,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[35,17,39,17],[68,13,68,14],[44,5,44,12],[45,5,45,12],[56,5,56,12],[57,5,57,12],[58,5,58,12],[62,5,62,12],[47,5,47,12],[61,5,61,12],[51,5,51,12],[41,5,41,12],[46,5,46,12],[42,5,42,12],[43,5,43,12],[63,5,63,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTA International Inc.,  Supplier Assessment"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Company Information'!D14=\"\",\"\",'Company Information'!D14)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audit Prepared by:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Company Information'!D138=\"\",\"\",'Company Information'!D138)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Company Information'!D140=\"\",\"\",'Company Information'!D140)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Contacts:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Company Information'!D$41=\"\",\"\",'Company Information'!D$41)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Company Information'!$D$45=\"\",\"\",'Company Information'!$D$45)","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,"Default","Distributor","Raw Material Distributor","Assembly","Manufacturing","Special Process"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTA Supplier Assessment Scorecard",null,null,null,null,null,null,null,null,null,null,"Date of Audit:","2019-03-05",null,null,null,null,null,null,null,null,null,null,null,1,"General",3,2,2,2,2,2]
[null,null,null,null,null,"Self Score",null,null,null,"RTA Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Quality Records",3,3,3,1,1,1]
[null,"Company:",null,null,null,{"$f":"IF(V49=\"x\",SUM(Q41:Q64)/M65,IF((SUM(Q41:Q64)/N65)-0.15<0,\"\",(SUM(Q41:Q64)/N65)-0.15))","v":""},null,null,null,{"$f":"IF(SUM(R41:R64)/M65=\"\",\"\",IF(V49=\"x\",SUM(R41:R64)/M65,IF((SUM(R41:R64)/M65)-0.15<0,\"\",SUM(R41:R64)/M65-0.15)))","v":""},null,null,null,null,null,null,null,null,null,"General Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Quality Measurements",3,1,2,2,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,null,null,null,null,null,4,"Risk Management",3,2,2,2,2,2]
[null,{"$f":"IF('Company Information'!$D$14=\"\",\"\",'Company Information'!$D$14)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Weight","% of Total Weight",null,"Supplier Self Score","RTA Quality Rating",null,{"$f":"IF('Company Information'!D92=\"\",0,'Company Information'!D92)","v":0},"Total Number of Employees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Signatures and Authority",3,3,2,2,2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Company Information'!D84","v":0},null,{"$f":"'Company Information'!B84","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Prohibited Practices",3,0,0,3,3,1]
[null,"Intended Supplier Utilization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Quality Questionnaire'!C7","v":0},{"$f":"'Quality Questionnaire'!D7","v":"How long has your company been working in the Aerospace Industry?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"AS9102 First Article Inspection Report",3,0,0,2,2,1]
[null,"Default",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Quality Questionnaire'!C8=\"\",\"\",'Quality Questionnaire'!C8)","v":""},"Compliant to AS9100",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Competence, Awareness and Training",3,2,2,2,2,2]
[null,"Primary Business:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Contract Review",3,3,3,2,2,1]
[null,null,null,null,1,"General","General","General","General","General","General","General","General",{"$f":"HLOOKUP($B$39,$AO$31:$AT$54,AM33,FALSE)","v":3},{"$f":"N41/$N$65","v":4.1666666666666664E-2},null,{"$f":"VLOOKUP(F41,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F41,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Purchasing and Flow down Requirements",3,2,3,3,3,2]
[null,{"$f":"'Company Information'!A57","v":"MFG to Customer Design"},null,{"$f":"IF('Company Information'!D57=\"X\",'Company Information'!D57,\"\")","v":""},2,"Quality Records","Quality Records","Quality Records","Quality Records","Quality Records","Quality Records","Quality Records","Quality Records",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F42,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F42,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,{"$f":"IF('Company Information'!B77=\"\",\"\",'Company Information'!B77)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Receiving Inspection",3,3,3,3,3,3]
[null,{"$f":"'Company Information'!A59","v":"Design to Customer Specifications"},null,{"$f":"IF('Company Information'!D59=\"X\",'Company Information'!D59,\"\")","v":""},3,"Quality Measurements","Quality Measurements","Quality Measurements","Quality Measurements","Quality Measurements","Quality Measurements","Quality Measurements","Quality Measurements",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F43,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F43,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Traceability",3,0,0,1,1,1]
[null,{"$f":"'Company Information'!A61","v":"Assembly Shop"},null,{"$f":"IF('Company Information'!D61=\"X\",'Company Information'!D61,\"\")","v":""},4,"Risk Management","Signatures and Authority","Signatures and Authority","Signatures and Authority","Signatures and Authority","Signatures and Authority","Signatures and Authority","Signatures and Authority",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F44,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F44,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Buyer Furnished Equipment",3,0,0,3,3,2]
[null,{"$f":"'Company Information'!A63","v":"Composite Shop"},null,{"$f":"IF('Company Information'!D63=\"X\",'Company Information'!D63,\"\")","v":""},5,"Signatures and Authority","Prohibited Practices","Prohibited Practices","Prohibited Practices","Prohibited Practices","Prohibited Practices","Prohibited Practices","Prohibited Practices",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F45,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F45,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Document and Drawing Control",3,1,1,2,2,1]
[null,{"$f":"'Company Information'!A65","v":"Metal Machine Shop"},null,{"$f":"IF('Company Information'!D65=\"X\",'Company Information'!D65,\"\")","v":""},6,"Prohibited Practices","AS9102 First Article Inspection Report","AS9102 First Article Inspection Report","AS9102 First Article Inspection Report","AS9102 First Article Inspection Report","AS9102 First Article Inspection Report","AS9102 First Article Inspection Report","AS9102 First Article Inspection Report",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F46,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F46,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Change Management",3,2,1,3,3,1]
[null,{"$f":"'Company Information'!A67","v":"Electrical Components / Wiring"},null,{"$f":"IF('Company Information'!D67=\"X\",'Company Information'!D67,\"\")","v":""},7,"AS9102 First Article Inspection Report","Competence, Awareness and Training","Competence, Awareness and Training","Competence, Awareness and Training","Competence, Awareness and Training","Competence, Awareness and Training","Competence, Awareness and Training","Competence, Awareness and Training",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F47,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F47,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"Certifications",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Manufacturing Controls",3,2,1,2,2,1]
[null,{"$f":"'Company Information'!A69","v":"Special Processes (see below)"},null,{"$f":"IF('Company Information'!D69=\"X\",'Company Information'!D69,\"\")","v":""},8,"Competence, Awareness and Training","Contract Review","Contract Review","Contract Review","Contract Review","Contract Review","Contract Review","Contract Review",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F48,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F48,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Preservation of Product",3,0,1,2,2,2]
[null,{"$f":"'Company Information'!E57","v":"Original Equipment MFG (OEM)"},null,{"$f":"IF('Company Information'!J57=\"X\",'Company Information'!J57,\"\")","v":""},9,"Contract Review","Purchasing and Flow down Requirements","Purchasing and Flow down Requirements","Purchasing and Flow down Requirements","Purchasing and Flow down Requirements","Purchasing and Flow down Requirements","Purchasing and Flow down Requirements","Purchasing and Flow down Requirements",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F49,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F49,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"AS9100*",null,{"$f":"IF('Company Information'!H105=\"\",\"\",'Company Information'!H105)","v":""},null,null,"Boeing D6-82479",null,null,{"$f":"IF('Company Information'!H111=\"\",\"\",'Company Information'!H111)","v":""},null,null,null,null,null,null,null,null,null,null,18,"Control of Monitoring and Measuring Devices",3,1,2,2,2,2]
[null,{"$f":"'Company Information'!E59","v":"FAA/CAA Approved Repair Station"},null,{"$f":"IF('Company Information'!J59=\"X\",'Company Information'!J59,\"\")","v":""},10,"Purchasing and Flow down Requirements","Receiving Inspection","Receiving Inspection","Receiving Inspection","Receiving Inspection","Receiving Inspection","Receiving Inspection","Receiving Inspection",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F50,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F50,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"ISO-9000",null,{"$f":"IF('Company Information'!H103=\"\",\"\",'Company Information'!H103)","v":""},null,null,"Non-US FAA equivalent",null,null,{"$f":"IF('Company Information'!H113=\"\",\"\",'Company Information'!H113)","v":""},null,null,null,null,null,null,null,null,null,null,19,"Packaging",3,2,2,3,3,2]
[null,{"$f":"'Company Information'!E61","v":"Distribution"},null,{"$f":"IF('Company Information'!J61=\"X\",'Company Information'!J61,\"\")","v":""},11,"Receiving Inspection","Traceability","Traceability","Traceability","Traceability","Traceability","Traceability","Traceability",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F51,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F51,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"NADCAP",null,{"$f":"IF('Company Information'!H119=\"\",\"\",'Company Information'!H119)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Nonconforming Product",3,1,1,2,2,1]
[null,{"$f":"'Company Information'!E63","v":"Agent"},null,{"$f":"IF('Company Information'!J63=\"X\",'Company Information'!J63,\"\")","v":""},12,"Traceability","Buyer Furnished Equipment","Buyer Furnished Equipment","Buyer Furnished Equipment","Buyer Furnished Equipment","Buyer Furnished Equipment","Buyer Furnished Equipment","Buyer Furnished Equipment",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F52,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F52,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"Boeing D1-4426",null,{"$f":"IF('Company Information'!H121=\"\",\"\",'Company Information'!H121)","v":""},null,null,"MIL-Q-9858",null,null,{"$f":"IF('Company Information'!H115=\"\",\"\",'Company Information'!H115)","v":""},null,null,null,null,null,null,null,null,null,null,21,"Corrective Action and Preventative Action",3,2,2,2,2,2]
[null,{"$f":"'Company Information'!E65","v":"Test Laboratory"},null,{"$f":"IF('Company Information'!J65=\"X\",'Company Information'!J65,\"\")","v":""},13,"Buyer Furnished Equipment","Document and Drawing Control","Document and Drawing Control","Document and Drawing Control","Document and Drawing Control","Document and Drawing Control","Document and Drawing Control","Document and Drawing Control",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F53,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F53,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"ASA-100/FAA 00-56A",null,{"$f":"IF('Company Information'!H123=\"\",\"\",'Company Information'!H123)","v":""},null,null,"MIL-I-45208A",null,null,{"$f":"IF('Company Information'!H117=\"\",\"\",'Company Information'!H117)","v":""},null,null,null,null,null,null,null,null,null,null,22,"Inspection",3,3,2,1,1,1]
[null,{"$f":"'Company Information'!E67","v":"Calibration"},null,{"$f":"IF('Company Information'!J67=\"X\",'Company Information'!J67,\"\")","v":""},14,"Document and Drawing Control","Change Management","Change Management","Change Management","Change Management","Change Management","Change Management","Change Management",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F54,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F54,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Statistical Techniques",3,3,2,2,2,2]
[null,{"$f":"'Company Information'!E69","v":"Raw Materials"},null,{"$f":"IF('Company Information'!J69=\"X\",'Company Information'!J69,\"\")","v":""},15,"Configuration and Change Management","Manufacturing Controls","Manufacturing Controls","Manufacturing Controls","Manufacturing Controls","Manufacturing Controls","Manufacturing Controls","Manufacturing Controls",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F55,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F55,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Certificate of Conformance",3,3,2,2,2,2]
[null,null,null,null,16,"Manufacturing Controls","Preservation of Product","Preservation of Product","Preservation of Product","Preservation of Product","Preservation of Product","Preservation of Product","Preservation of Product",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F56,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F56,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,"Current RTA Supplier For:",null,null,null,null,null,{"$f":"IF('Company Information'!F127=\"\",\"N/A\",'Company Information'!F127)","v":"N/A"}]
[null,null,null,null,17,"Preservation of Product","Control of Monitoring and Measuring Devices","Control of Monitoring and Measuring Devices","Control of Monitoring and Measuring Devices","Control of Monitoring and Measuring Devices","Control of Monitoring and Measuring Devices","Control of Monitoring and Measuring Devices","Control of Monitoring and Measuring Devices",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F57,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F57,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0}]
[null,null,null,null,18,"Control of Monitoring and Measuring Devices","Packaging","Packaging","Packaging","Packaging","Packaging","Packaging","Packaging",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F58,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F58,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0}]
[null,null,null,null,19,"Packaging & Shipping","Nonconforming Product","Nonconforming Product","Nonconforming Product","Nonconforming Product","Nonconforming Product","Nonconforming Product","Nonconforming Product",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F59,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F59,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Required",0]
[null,null,null,null,20,"Nonconforming Product","Corrective Action and Preventative Action","Corrective Action and Preventative Action","Corrective Action and Preventative Action","Corrective Action and Preventative Action","Corrective Action and Preventative Action","Corrective Action and Preventative Action","Corrective Action and Preventative Action",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F60,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F60,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required",1]
[null,null,null,null,21,"Internal Audits and Corrective Action (CA/PA)","Inspection","Inspection","Inspection","Inspection","Inspection","Inspection","Inspection",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F61,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F61,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required and Important",2]
[null,null,null,null,22,"Inspection","Statistical Techniques","Statistical Techniques","Statistical Techniques","Statistical Techniques","Statistical Techniques","Statistical Techniques","Statistical Techniques",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F62,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F62,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical",3]
[null,null,null,null,23,"Statistical Techniques","Certificate of Conformance","Certificate of Conformance","Certificate of Conformance","Certificate of Conformance","Certificate of Conformance","Certificate of Conformance","Certificate of Conformance",3,4.1666666666666664E-2,null,{"$f":"VLOOKUP(F63,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F63,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0}]
[null,null,null,null,24,"Certificate of Conformance",null,null,null,null,null,null,null,{"$f":"HLOOKUP($B$39,$AO$31:$AT$55,AM54,FALSE)","v":3},{"$f":"N64/$N$65","v":4.1666666666666664E-2},null,{"$f":"VLOOKUP(F64,'Quality Questionnaire'!$A:$R,15,FALSE)","v":0},{"$f":"VLOOKUP(F64,'Quality Questionnaire'!$A:$Y,19,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N41:N64,\">0\")","v":24},{"$f":"SUM(N41:N64)","v":72},{"$f":"SUM(O41:O63)","v":0.95833333333333293}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality",null,{"$f":"J34","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B36","v":""}]
[]
[]
[]
[]
[]
[null,"Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Observations"]
[]
[]
[]
[]
[]
[]
[null,"Findings"]
[]
[]
[]
[]
[]
[]
[null,"Recommendations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Y"]
[null,"N"]
[null,"N/A"]