{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Questionnaire","SYNTHESE"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Questionnaire","index":0,"n_rows":127,"n_cols":6,"rows_kept":127,"cut":false,"hidden":false,"merged":[[19,3,21,3],[82,1,102,1],[0,3,0,4],[69,1,69,3],[53,1,53,3],[43,1,43,3],[24,1,24,3],[81,1,81,3],[12,2,12,3],[2,1,2,5],[3,1,3,5],[114,1,114,3],[103,1,103,3],[104,1,113,1],[70,1,80,1],[54,1,68,1]]}
[null,null,null,"SUPPLIER QMS SELF ASSESSMENT FORM",null,{"$f":"D14&\" - \"&YEAR(D15)","v":" - 1900"}]
[]
[null,"The purpose of this questionnaire is to estimate whether your company meets the minimum requirements required by Amphenol Socapex (ASF) to be part of our list of qualified suppliers.\nThis assessment is based on the organization of your company, your activities, as well as your Quality and Environment management system."]
[null,"This document complements the document \"PR. PUR.0026\""]
[]
[]
[null,"IMPORTANT :","Any \"NON APPLICABLE\" Answer must be justified in the associated comment cell"]
[]
[]
[]
[null,"This questionnaire should be returned to your Purchasing Contact or to: purchasing@amphenolsocapexfr.onmicrosoft.com"]
[]
[null,null,"This form has been filled by : "]
[null,null,"COMPANY:"]
[null,null,"Date:"]
[null,null,"NAME:"]
[null,null,"FIRSTNAME:"]
[null,null,"Role:"]
[null,null,"E-mail"]
[null,null,"Comments"]
[null,"OUI"]
[null,"NON"]
[]
[null,"Chapter","Sub Section","Question","Answer","Comments"]
[null,"1 / MASTERING DOCUMENT"]
[null,null,null,"Do you keep an updated Product/Process folder, for each manufactured part, including : "]
[null,null,"1.1"," - The Customer (ASF) documents at latest revision (Drawing, Specifications, …) ?"]
[]
[null,null,"1.2"," - the product acceptance criterias ?"]
[]
[null,null,"1.3"," - the recording documents and the results of the controls and testings ?"]
[]
[null,null,"1.4"," - the relevant machine's programs ?"]
[]
[null,null,null,"are you able to provide the following elements if required by ASF purchase order ?"]
[null,null,"1.5"," - Raw material Certificate ?"]
[]
[null,null,"1.6"," - Dimensional report ?"]
[]
[null,null,"1.7"," - Special Process and relevant functional test report ?"]
[null,null,null,"   (If you are not able to perform any you would inform Amphenol at time of Order Acknowledgement)"]
[null,null,"1.8","Do you archive the records related to the sold product/process protected from deterioration or loss during 10 years ?"]
[]
[null,"2/ MASTERING PURCHASING"]
[null,null,"2.1","Do you maintain an up to date list of approved suppliers ?\n"]
[null,null,null,"   (ideally your system prevent the use of unqualified suppliers)"]
[null,null,"2.2","Do you have procurement inspection rules (sampling, frequency of control, etc.) ? "]
[null,null,null,"   (ideally, the sampling plan is justified on the basis of recognised statistical principles)"]
[null,null,"2.3","Do you flow up ASF requirements onto your own suppliers and subcontractors ?\n"]
[]
[null,null,"2.4","Do you comply with REACH and ROHS requirements?"]
[]
[null,null,"2.5","Do you monitor the quality and logistics performance of your suppliers?"]
[null,"3 / MASTERING PRODUCT DEVELOPMENT"]
[null,"3 / MAITRISE DE LA CONCEPTION",null,"(only applicable to companies handling design for ASF)"]
[]
[null,null,"3.1","Do you carry out design reviews for a technical and quality analysis of the offer?"]
[]
[null,null,"3.2","Do you assess the risks associated with design and development?"]
[]
[null,null,"3.3","Do you establish, document, and maintain a product configuration management system throughout its development?"]
[]
[null,null,"3.4","Do you plan design and development management?"]
[null,null,null,"indicate the milestones, the sequence of tasks, obligatory crossing points etc …"]
[]
[null,null,"3.5","Do you inform ASF about product changes ?"]
[]
[null,null,"3.6","Do you favor eco-design?"]
[]
[null,"4 / MASTERING TRACEABILITY"]
[null,"4 / MAITRISE DE LA TRACABILITE"]
[null,null,"4.1","Is the product identified throughout the production cycle with its inspection and test records?"]
[]
[null,null,"4.2","Is traceability recorded on products manufactured from the same batch of raw materials or the same batch of manufacture, as well as the destination (delivery, scrap)?"]
[]
[null,null,"4.3","Can you find the sequential documentation of the production (manufacturing, assembly, control) of a given product?"]
[]
[null,null,"4.4","Are modalities defined in a procedure, to alert your customers when you modify a product or process?"]
[]
[null,null,"4.5","Is fifo respected?"]
[]
[null,"5 / MASTERING MANUFACTURING AND CONTROL",null,"MAITRISE DE LA PRODUCTION ET DU CONTRÔLE"]
[null," 5 / MAITRISE DE LA PRODUCTION ET DU CONTRÔLE"]
[null,null,"5.1","Do you systematically perform contract reviews (verification of our documentation stated on the purchase order and the feasibility of performing this order)?"]
[]
[null,null,"5.2","Do you have documented and controlled work instructions?"]
[]
[null,null,"5.3","Do you create and provide a First Article folder (FAI or other) every time you manufacture an article for the first time? and do you keep it up to date? "]
[]
[null,null,"5.4","Do you preserve, by appropriate means, the product at each stage of your Process?"]
[]
[null,null,"5.5","Are the control activities performed by qualified persons and different from those who performed the manufacturing operations?"]
[]
[null,null,"5.6","Do you keep an up-to-date skill matrix table ? "]
[]
[null,null,"5.7","Do you have a system to provide objective evidence that all manufacturing and control operations have been performed as planned (Manufacturing tracking document, manufacturing range, etc.)?"]
[]
[null,null,"5.8","Do you have a method to ensure that the product is packaged and shipped according to the order and that all requirements are met?"]
[]
[null,null,"5.9","Do you have a system of periodic maintenance and preventive checks on production equipment and tools?"]
[]
[null,null,"5.10","Are the control means identified, listed and monitored? Are the periodic checks to be performed documented?"]
[]
[null,"6 / MASTERING NON CONFORM PRODUCT",null,"MAITRISE DU PRODUIT NON CONFORME"]
[null,"6 / MAITRISE DU PRODUIT NON CONFORME"]
[null,null,"6.1","Do you notify your customers if non-conform (or likely) parts are detected after delivery?"]
[]
[null,null,"6.2","Do you use waiver requests when detecting parts that do not meet the defined requirements ?"]
[]
[null,null,"6.3","Are the rules for dealing with non-conformities defined at each stage of the process and known by every operators?"]
[]
[null,null,"6.4","Do you have a methodology for recording and dealing with non-conformities?"]
[null,null,null,"(including at least: the description of the defect, its root causes and the corrective/preventive actions taken)"]
[]
[null,"7 / MASTERING CSR (Corporate Social Responsability)",null,"MAITRISE DU PRODUIT NON CONFORME"]
[]
[null,null,"7.1","Is the company's environmental responsibility (Ecological Impact) addressed at the level of the company's management (proof of the existence of a Declaration or action plan subject to an annual management review)"]
[]
[null,null,"7.2","Are there CSR criteria in the selection/qualification process of suppliers and subcontractors?"]
[]
[null,null,"7.3","If the company uses chemicals, is the risk to employee health and the environment under control?"]
[]
[]
[]
[null,"OUI"]
[null,"NON"]
[null,"NON APPLICABLE"]

{"sheet":"SYNTHESE","index":1,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":true,"merged":[[39,1,39,3],[48,1,48,3],[2,5,2,6],[2,1,2,3],[3,1,3,3],[12,1,12,3],[21,1,21,3],[30,1,30,3],[33,5,36,6]]}
[null,null,null,{"$f":"Questionnaire!F1","v":" - 1900"},null,"Supplier Self Assement Synthesis QUALITY SYSTEM ","FM.PUR.041"]
[]
[null,null,null,null,null,"Synthesis Table"]
[null,{"$f":"Questionnaire!B25","v":"1 / MASTERING DOCUMENT"},null,null,null,{"$f":"B4","v":"1 / MASTERING DOCUMENT"},{"$f":"DOC","v":0}]
[null,null,null,null,null,{"$f":"B13","v":"2/ MASTERING PURCHASING"},{"$f":"ACHATS","v":0}]
[null,null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!$E$27:$E$43,C6)","v":0},null,{"$f":"B22","v":"3 / MASTERING PRODUCT DEVELOPMENT"},{"$f":"CONCEPTION","v":0}]
[null,null,"NO/NON",{"$f":"COUNTIF(Questionnaire!$E$27:$E$43,C7)","v":0},null,{"$f":"B31","v":"4 / MASTERING TRACEABILITY"},{"$f":"TRACA","v":0}]
[null,null,"NOT APPLICABLE",{"$f":"COUNTIF(Questionnaire!$E$27:$E$43,C8)","v":0},null,{"$f":"B40","v":"5 / MASTERING MANUFACTURING AND CONTROL"},{"$f":"PRODUCTION","v":0}]
[null,null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!C27:C43)","v":8},null,{"$f":"B49","v":"6 / MASTERING NON CONFORM PRODUCT"},{"$f":"NC","v":0}]
[null,null,null,null,null,"OVERALL CONFIDENCE FACTOR",{"$f":"AVERAGE(G4:G9)","v":0}]
[null,null,"CONFIDENCE FACTOR",{"$f":"IF(D8=D9,\"NOT APPLICABLE\",D6/(D9-D8))","v":0},null,{"$f":"Questionnaire!B115","v":"7 / MASTERING CSR (Corporate Social Responsability)"},{"$f":"G56","v":0}]
[null,null,null,null,null,"Score <60% : too low to garanty the respect of ASF minimum requirements"]
[null,{"$f":"Questionnaire!B44","v":"2/ MASTERING PURCHASING"},null,null,null,"Score between 60% and 75%: poor result"]
[null,null,null,null,null,"Score >75% result validated"]
[null,null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!$E$45:$E$53,\"YES/OUI\")","v":0}]
[null,null,"NO/NON",{"$f":"COUNTIF(Questionnaire!$E$45:$E$53,\"NO/NON\")","v":0}]
[null,null,"NOT APPLICABLE"]
[null,null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!$C$45:$C$53)","v":5}]
[]
[null,null,"CONFIDENCE FACTOR",{"$f":"IF(D17=D18,\"NOT APPLICABLE\",D15/(D18-D17))","v":0}]
[]
[null,{"$f":"Questionnaire!B54","v":"3 / MASTERING PRODUCT DEVELOPMENT"}]
[]
[null,null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!$E$55:$E$69,C24)","v":0}]
[null,null,"NO/NON",{"$f":"COUNTIF(Questionnaire!$E$55:$E$69,C25)","v":0}]
[null,null,"NOT APPLICABLE",{"$f":"COUNTIF(Questionnaire!$E$55:$E$69,C26)","v":0}]
[null,null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!C55:C69)","v":6}]
[]
[null,null,"CONFIDENCE FACTOR",{"$f":"IF(D26=D27,\"NOT APPLICABLE\",D24/(D27-D26))","v":0}]
[]
[null,{"$f":"Questionnaire!B70","v":"4 / MASTERING TRACEABILITY"}]
[]
[null,null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!$E$71:$E$81,C33)","v":0},null,"Summary"]
[null,null,"NO/NON",{"$f":"COUNTIF(Questionnaire!$E$71:$E$81,C34)","v":0},null,{"$f":"IF(AND(G10>61%,G10<75%),\"Poor Result\",IF(G10>=75%,\"Satisfaying\",\"Unsatisfaying result to comply with ASF minimum requirement, Perform extra investigations!\"))","v":"Unsatisfaying result to comply with ASF minimum requirement, Perform extra investigations!"}]
[null,null,"NOT APPLICABLE",{"$f":"COUNTIF(Questionnaire!$E$71:$E$81,C35)","v":0}]
[null,null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!C71:C81)","v":5}]
[]
[null,null,"CONFIDENCE FACTOR",{"$f":"IF(D35=D36,\"NOT APPLICABLE\",D33/(D36-D35))","v":0}]
[]
[null,{"$f":"Questionnaire!B82","v":"5 / MASTERING MANUFACTURING AND CONTROL"},null,null,null,"Ceritifications :"]
[null,null,null,null,null,"ISO9001"]
[null,null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!$E$83:$E$103,C42)","v":0},null,"EN9100"]
[null,null,"NO/NON",{"$f":"COUNTIF(Questionnaire!$E$83:$E$103,C43)","v":0}]
[null,null,"NOT APPLICABLE",{"$f":"COUNTIF(Questionnaire!$E$83:$E$103,C44)","v":0}]
[null,null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!C83:C103)","v":10}]
[]
[null,null,"CONFIDENCE FACTOR",{"$f":"IF(D44=D45,\"NOT APPLICABLE\",D42/(D45-D44))","v":0}]
[]
[null,{"$f":"Questionnaire!B104","v":"6 / MASTERING NON CONFORM PRODUCT"},null,null,null,{"$f":"Questionnaire!B115","v":"7 / MASTERING CSR (Corporate Social Responsability)"}]
[]
[null,null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!$E$105:$E$114,C51)","v":0},null,"YES/OUI",{"$f":"COUNTIF(Questionnaire!E117:E121,F51)","v":0}]
[null,null,"NO/NON",{"$f":"COUNTIF(Questionnaire!$E$105:$E$114,C52)","v":0},null,"NO/NON",{"$f":"COUNTIF(Questionnaire!E117:E121,F52)","v":0}]
[null,null,"NOT APPLICABLE",{"$f":"COUNTIF(Questionnaire!$E$105:$E$114,C53)","v":0},null,"NOT APPLICABLE",{"$f":"COUNTIF(Questionnaire!E117:E121,F53)","v":0}]
[null,null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!C105:C114)","v":4},null,"TOTAL Possible",{"$f":"COUNTA(Questionnaire!C117:C121)","v":3}]
[]
[null,null,"CONFIDENCE FACTOR",{"$f":"IF(D53=D54,\"NOT APPLICABLE\",D51/(D54-D53))","v":0},null,"CONFIDENCE FACTOR",{"$f":"IF(G53=G54,\"NOT APPLICABLE\",G51/(G54-G53))","v":0}]
[]
[]
[]
[null,null,null,null,null,"1 / MAITRISE DOCUMENTAIRE",{"$f":"DOC","v":0}]
[null,null,null,null,null,"2 / MAITRISE DES ACHATS",{"$f":"ACHATS","v":0}]
[null,null,null,null,null,"3 / MAITRISE DE LA CONCEPTION",{"$f":"CONCEPTION","v":0}]
[null,null,null,null,null,"4 / MAITRISE DE LA TRACABILITE",{"$f":"TRACA","v":0}]
[null,null,null,null,null,"5 / MAITRISE DE LA PRODUCTION ET DU CONTRÔLE",{"$f":"PRODUCTION","v":0}]
[null,null,null,null,null,"6 / MAITRISE DU PRODUIT NO/NON CONFORME",{"$f":"NC","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"1 / MAITRISE DOCUMENTAIRE",{"$f":"DOC","v":0}]
[null,null,null,null,null,"2 / MAITRISE DES ACHATS",{"$f":"ACHATS","v":0}]
[null,null,null,null,null,"4 / MAITRISE DE LA TRACABILITE",{"$f":"TRACA","v":0}]
[null,null,null,null,null,"5 / MAITRISE DE LA PRODUCTION ET DU CONTRÔLE",{"$f":"PRODUCTION","v":0}]
[null,null,null,null,null,"6 / MAITRISE DU PRODUIT NO/NON CONFORME",{"$f":"NC","v":0}]