{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Lists","Rev. history","Instructions","Justification","Rating","Questionnaire","Non Conformities","Aux","Comments","Supplement"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":48,"comments":5,"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":"Lists","index":0,"n_rows":243,"n_cols":21,"rows_kept":243,"cut":false,"hidden":true,"merged":[]}
["Product Division","IDCO","Commodity","Country","Supplier Facility Type ","Supplier Type","Assessment Reason","Certifications",null,"Regions","PL","Cables & Components","Mechanics","Electricals & Power","Electronics & PCBA","Systems & system components","Utility systems (DC/MV)",{"$f":"Justification!$E$22","v":0},null,"Comments "]
["Direct Materials","Stack","Electronics","Afghanistan","Manufacturing","New Potential  supplier","SMA - Onboarding","ISO 9001",null,"Europe, Middle East & Africa","Residential","Cables & cable harnesses","Cabinets","Stacks & power modules","Active electronic components","Systems & system components","Transformers",{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""},{"$f":"COUNTIF(R2:R27,\"<>0\")","v":26},1," "]
["OEM","Power Modules","Electricals & Power","Albania","Distribution","Current Supplier","SMA - TSM","ISO 14001",null,"Americas","Commercial","Connection parts","Aluminum die casting","Inductors","Passive electronic components","Wireless communication","Medium voltage turnkey systems",{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""},null,2,"In order for assessment to be considered valid, justification of rating is to be included in observations field."]
[null,"Inductors Utility","Cables & Components","Algeria","Broker/Agent/Sales office",null,"Supplier - Self-assessment","ISO 45001",null,"Asia Pacific","Utility","Small parts mechanical","Sheet metal parts","Switches & contactors","Current transformers","Data management systemes","Accessories & customized parts for MVS",{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""},null,3,"In order for assessment to be considered valid, justification of rating is to be included in observations field."]
[null,"Power Supplies","Mechanics","American Samoa",null,null,null,"ISO 50001",null,null,null,"Packaging","Busbars","Fuses","Ferrites","Inverter","Medium voltage switchgears",{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""},null,4,"In order for assessment to be considered valid, justification of rating is to be included in comments field."]
[null,"Inductors Residential, Commercial","PCB & Systems","Andorra",null,null,null,"IATF 16949",null,null,null,"Documentation & labeling","Heat sinks","Power supplies","Electromechanical components (on PCB)","Charging systems & components","DC-Combiner",{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""},null,5," "]
[null,"Fans ","Utility","Angola",null,null,null,"ISO / TS 22163",null,null,null,"Plastic components","Deep drawn parts","Fans & climate components","Printed circuit boards (PCB)",null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Climate Components",null,"Anguilla",null,null,null,"AS/EN 9100",null,null,null,null,"Laser welding metal parts","Displays","Printed circuit board assemblies (PCBA)",null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Switches",null,"Antarctica",null,null,null,null,null,null,null,null,null,"Customized batteries & storage",null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Contactors",null,"Antigua and Barbuda",null,null,null,null,null,null,null,null,null,"Capacitors (ex PCB)",null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Fuses",null,"Argentina",null,null,null,null,null,null,null,null,null,"Measure components",null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Aluminum die casting",null,"Armenia",null,null,null,null,null,null,null,null,null,"Shunts (ex PCB)",null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Busbars",null,"Aruba",null,null,null,null,null,null,null,null,null,"Connectors (ex PCB)",null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Cabinets",null,"Australia",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Sheet metal",null,"Austria",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Heat sinks",null,"Azerbaijan",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Active parts catalogue",null,"Bahamas",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Passive parts catalogue",null,"Bahrain",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Sensors / Curren-, Measure-, Control-, Monitoring-Units",null,"Bangladesh",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Inductive (PCB) / Relays / Capacitors",null,"Barbados",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Ferrits",null,"Belarus",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Cables and cable harnesses",null,"Belgium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Connection parts",null,"Belize",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Documentation and labeling",null,"Benin",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Packaging",null,"Bermuda",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Plastic components",null,"Bhutan",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Small parts mechanical",null,"Bolivia",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($R$1=0,\"\",HLOOKUP(Justification!$E$22,$L$1:$Q$27,ROW(),0))","v":""}]
[null,"Assembly services",null,"Bosnia and Herzegovina"]
[null,"PCB",null,"Botswana"]
[null,"PCBA",null,"Bouvet Island"]
[null,"Utility",null,"Brazil"]
[null,"Residential",null,"British Indian Ocean Territory"]
[null,"Battery and System",null,"Brunei Darussalam"]
[null,"Hardware, HMI etc.",null,"Bulgaria"]
[null,"MV transformers",null,"Burkina Faso"]
[null,"HV transformers",null,"Burundi"]
[null,"Transformer compact stations (TCS)",null,"Cambodia"]
[null,"MV stations",null,"Cameroon"]
[null,"Integrated skids",null,"Canada"]
[null,"Container",null,"Cape Verde"]
[null,"Platforms and oil containment",null,"Cayman Islands"]
[null,"Accessories and customized parts for MV systems",null,"Central African Republic"]
[null,"MV switchgears",null,"Chad"]
[null,"other materials medium voltage systems",null,"Chile"]
[null,"DC combiner box",null,"China"]
[null,"LV transformers",null,"Christmas Island"]
[null,null,null,"Cocos (Keeling) Islands"]
[null,null,null,"Colombia"]
[null,null,null,"Comoros"]
[null,null,null,"Congo"]
[null,null,null,"Congo, The Democratic Rebublic of The"]
[null,null,null,"Cook Islands"]
[null,null,null,"Costa Rica"]
[null,null,null,"Côte D'Ivoire"]
[null,null,null,"Croatia"]
[null,null,null,"Cuba"]
[null,null,null,"Cyprus"]
[null,null,null,"Czech Republic"]
[null,null,null,"Denmark"]
[null,null,null,"Djibouti"]
[null,null,null,"Dominica"]
[null,null,null,"Dominican Republic"]
[null,null,null,"East Timor"]
[null,null,null,"Ecuador"]
[null,null,null,"Egypt"]
[null,null,null,"El Salvador"]
[null,null,null,"Equatorial Guinea"]
[null,null,null,"Eritrea"]
[null,null,null,"Estonia"]
[null,null,null,"Ethiopia"]
[null,null,null,"Falkland Islands (Malvinas)"]
[null,null,null,"Faroe Islands"]
[null,null,null,"Fiji"]
[null,null,null,"Finland"]
[null,null,null,"France"]
[null,null,null,"France, Metropolitan"]
[null,null,null,"French Guiana"]
[null,null,null,"French Polynesia"]
[null,null,null,"French Southern Territories"]
[null,null,null,"Gabon"]
[null,null,null,"Gambia"]
[null,null,null,"Georgia"]
[null,null,null,"Germany"]
[null,null,null,"Ghana"]
[null,null,null,"Gibraltar"]
[null,null,null,"Greece"]
[null,null,null,"Greenland"]
[null,null,null,"Grenada"]
[null,null,null,"Guadeloupe"]
[null,null,null,"Guam"]
[null,null,null,"Guatemala"]
[null,null,null,"Guinea"]
[null,null,null,"Guinea-Bissau"]
[null,null,null,"Guyana"]
[null,null,null,"Haiti"]
[null,null,null,"Heard Island and McDonald Islands"]
[null,null,null,"Holy See (Vatican City State)"]
[null,null,null,"Honduras"]
[null,null,null,"Hong Kong"]
[null,null,null,"Hungary"]
[null,null,null,"Iceland"]
[null,null,null,"India"]
[null,null,null,"Indonesia"]
[null,null,null,"Iran, Islamic Republic Of"]
[null,null,null,"Iraq"]
[null,null,null,"Ireland"]
[null,null,null,"Israel"]
[null,null,null,"Italy"]
[null,null,null,"Jamaica"]
[null,null,null,"Japan"]
[null,null,null,"Jordan"]
[null,null,null,"Kazakhstan"]
[null,null,null,"Kenya"]
[null,null,null,"Kiribati"]
[null,null,null,"Korea, Democratic People's Republic of"]
[null,null,null,"Korea, Republic of"]
[null,null,null,"Kuwait"]
[null,null,null,"Kyrgyzstan"]
[null,null,null,"Lao People's Democratic Republic"]
[null,null,null,"Latvia"]
[null,null,null,"Lebanon"]
[null,null,null,"Lesotho"]
[null,null,null,"Liberia"]
[null,null,null,"Libyan Arab Jamahiriya"]
[null,null,null,"Liechtenstein"]
[null,null,null,"Lithuania"]
[null,null,null,"Luxembourg"]
[null,null,null,"Macao"]
[null,null,null,"Macedonia, The Former Yugoslav Republic of"]
[null,null,null,"Madagascar"]
[null,null,null,"Malawi"]
[null,null,null,"Malaysia"]
[null,null,null,"Maldives"]
[null,null,null,"Mali"]
[null,null,null,"Malta"]
[null,null,null,"Marshall Islands"]
[null,null,null,"Martinique"]
[null,null,null,"Mauritania"]
[null,null,null,"Mauritius"]
[null,null,null,"Mayotte"]
[null,null,null,"Mexico"]
[null,null,null,"Micronesia, Federated States of"]
[null,null,null,"Moldova, Republic of"]
[null,null,null,"Monaco"]
[null,null,null,"Mongolia"]
[null,null,null,"Montserrat"]
[null,null,null,"Morocco"]
[null,null,null,"Mozambique"]
[null,null,null,"Myanmar"]
[null,null,null,"Namibia"]
[null,null,null,"Nauru"]
[null,null,null,"Nepal"]
[null,null,null,"Netherlands"]
[null,null,null,"Netherlands Antilles"]
[null,null,null,"Neutral Zone"]
[null,null,null,"New Caledonia"]
[null,null,null,"New Zealand"]
[null,null,null,"Nicaragua"]
[null,null,null,"Niger"]
[null,null,null,"Nigeria"]
[null,null,null,"Niue"]
[null,null,null,"Norfolk Island"]
[null,null,null,"Northern Mariana Islands"]
[null,null,null,"Norway"]
[null,null,null,"Occupied Palestinian Territory"]
[null,null,null,"Oman"]
[null,null,null,"Pakistan"]
[null,null,null,"Palau"]
[null,null,null,"Panama"]
[null,null,null,"Papua New Guinea"]
[null,null,null,"Paraguay"]
[null,null,null,"Peru"]
[null,null,null,"Philippines"]
[null,null,null,"Pitcairn"]
[null,null,null,"Poland"]
[null,null,null,"Portugal"]
[null,null,null,"Puerto Rico"]
[null,null,null,"Qatar"]
[null,null,null,"Réunion"]
[null,null,null,"Romania"]
[null,null,null,"Russian Federation"]
[null,null,null,"Rwanda"]
[null,null,null,"Saint Helena"]
[null,null,null,"Saint Kitts and Nevis"]
[null,null,null,"Saint Lucia"]
[null,null,null,"Saint Pierre and Miquelon"]
[null,null,null,"Saint Vincent and the Grenadines"]
[null,null,null,"Samoa"]
[null,null,null,"San Marino"]
[null,null,null,"Sao Tome and Principe"]
[null,null,null,"Saudi Arabia"]
[null,null,null,"Senegal"]
[null,null,null,"Serbia and Montenegro"]
[null,null,null,"Seychelles"]
[null,null,null,"Sierra Leone"]
[null,null,null,"Singapore"]
[null,null,null,"Slovakia"]
[null,null,null,"Slovenia"]
[null,null,null,"Solomon Islands"]
[null,null,null,"Somalia"]
[null,null,null,"South Africa"]
[null,null,null,"South Georgia and the South Sandwich Islands"]
[null,null,null,"Spain"]
[null,null,null,"Sri Lanka"]
[null,null,null,"Sudan"]
[null,null,null,"Suriname"]
[null,null,null,"Svalbard and Jan Mayen"]
[null,null,null,"Swaziland"]
[null,null,null,"Sweden"]
[null,null,null,"Switzerland"]
[null,null,null,"Syrian Arab Republic"]
[null,null,null,"Taiwan, Province of China"]
[null,null,null,"Tajikistan"]
[null,null,null,"Tanzania, United Republic of"]
[null,null,null,"Thailand"]
[null,null,null,"Togo"]
[null,null,null,"Tokelau"]
[null,null,null,"Tonga"]
[null,null,null,"Trinidad and Tobago"]
[null,null,null,"Tunisia"]
[null,null,null,"Turkey"]
[null,null,null,"Turkmenistan"]
[null,null,null,"Turks and Caicos Islands"]
[null,null,null,"Tuvalu"]
[null,null,null,"Uganda"]
[null,null,null,"Ukraine"]
[null,null,null,"United Arab Emirates"]
[null,null,null,"United Kingdom"]
[null,null,null,"United States"]
[null,null,null,"United States Minor Outlying Islands"]
[null,null,null,"Uruguay"]
[null,null,null,"Uzbekistan"]
[null,null,null,"Wallis and Futuna Islands"]
[null,null,null,"Vanuatu"]
[null,null,null,"Venezuela"]
[null,null,null,"Western Sahara"]
[null,null,null,"Viet Nam"]
[null,null,null,"Virgin Islands (British)"]
[null,null,null,"Virgin Islands, U.S."]
[null,null,null,"Yemen"]
[null,null,null,"Zambia"]
[null,null,null,"Zimbabwe"]
[null,null,null,"Åland Islands"]

{"sheet":"Rev. history","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["1","Revision","Date of implementation","Introduced by","Description of change",null,{"$f":"MAX(A:A)","v":9},"Current rev",{"$f":"VLOOKUP(G1,A:B,2,FALSE)","v":"070518"}]
[{"$f":"A1+1","v":2},160416,"2016-04-16","M.Grzesiak","Sheet protection against unauthorized changes enabled"]
[3,180416,"2016-04-18","M.Grzesiak","Exclamation box added to the questionnaire sheet as a remainder to provide comments"]
[{"$f":"A3+1","v":4},260416,"2016-04-26","M.Grzesiak","Observation/Comments remainder added to the questionnaire\nResult will not be generated if comments are missing\nExclamation box deleted"]
[5,300816,"2016-08-30","M.Grzesiak","Rating sheet was hid. Hide/Unhide buttons added. Formatting of NA cells changed. NC and comments list generation corrected"]
[6,"241016","2016-10-24","M.Grzesiak","Distributors/Sales office scope limiter added.\nSustainability questions added\nSection status added"]
[7,271016,"2016-10-27","M.Grzesiak","Supplier id + dtae added to actionlist"]
[8,"010318","2018-03-01","M.Grzesiak","Questions 3.0d,m; 4.0d; 9.0f,j deleted\nA number of questions revised\nJustification sheet changed (certifications, commodity)"]
[9,"070518","2018-05-07","L.Knapik","Release"]

{"sheet":"Instructions","index":2,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,9,20,12],[20,6,20,8],[20,3,20,5],[19,9,19,12],[19,3,19,5],[13,2,13,3],[17,1,17,15],[10,5,10,7],[11,5,11,7],[12,5,12,7],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[0,1,0,16],[2,1,2,16],[5,1,5,15],[7,1,7,15],[9,5,9,7],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[24,3,24,5],[24,6,24,8],[24,9,24,12],[15,1,15,15],[13,8,13,10],[13,5,13,7],[22,9,22,12],[21,9,21,12],[21,6,22,8],[21,3,22,5],[19,6,19,8],[23,6,23,8],[23,9,23,12],[23,3,23,5],[21,2,22,2],[21,1,22,1]]}
[]
[null,"> PURPOSE"]
[null,"The purpose of the Vendor Quality Evaluation (VQE) Questionnaire is to establish levels of competence and suitability of potential suppliers to SMA."]
[]
[null,"> USE"]
[null,"The questionnaire contains a list of questions, which shall be evaluated by the supplier through marking an appropriate score in the respective checkbox. \nIf a particular Question is not applicable to the organization - the \"N/A\" shall be marked and an extensive justification needs to be provided in the in the \"Assesor comments\" field, why the question is not applicable. The \"Assesor comments\" fields shall be extensively used to link supplier answer to its internal system or procedure. All comments/observations must be submitted in English.  It is essential that all supporting documents are attached by the Supplier in course of completing the VQE self-assessment. All of the questions need to be addressed to gain an overal rating result - othervise assessment is considered invalid."]
[]
[null,"Process Audit - Question Answering and Scoring:"]
[]
[null,null,"Question response",null,"Score","Rationale",null,null,"CAR"]
[null,null,"NO",null,0,"Required, but not included in Management System.",null,null,"Yes - Non Conformances need to be addressed"]
[null,null,"YES BUT",null,1,"In the Management System but execution requires improvement",null,null,"Non Conformances need to be addressed unless otherwise indicated by SMA"]
[null,null,"YES",null,2,"In the Management System with implementation well executed",null,null,"No"]
[null,null,"NA",null,"-","Not applicable for this item",null,null,"-"]
[]
[null,"Corrective Action Response = Corrective Action Required \n(Once the corrective actions for the respective non-conformances are verified, the audit score shall be re-calculated)"]
[]
[null,"The result of the audit will be calculated as a percentage of the maximum applicable scoring. The supplier classification shall be assessed as follows:"]
[]
[null,null,"RATING","STATUS",null,null,"CRITERIA",null,null,"EXPLANATION"]
[null,null,null,"Acceptable",null,null,"≥ 80% on all sections with the exception of (minimum ≥ 85% for section 3)",null,null,"A supplier, which conforms to audit requirements. The supplier displays excellence in discipline and execution of the process management system."]
[null,null,null,"Unacceptable\n(Improvement necessary)",null,null,"< 80% on some or all sections with the exception of (minimum < 85% for section 3)",null,null,"A process management system, which reflects minor/major non-conformance to assessment requirements."]
[null,null,null,null,null,null,null,null,null,"The supplier should not be considered suitable for further business until corrective actions are validated by SMA."]
[null,null,"Not scored","Not scored",null,null,"Audit not completed",null,null,"One or more questions not scored.\nAll Questions must be scored (2,1,0,N/A) \nto receive an overall rating."]
[null,null,"No comments added","No comments added",null,null,"Audit not completed",null,null,"One or more questions missing required comment.\nAll Questions rated less than 2 must be addressed with comment to receive an overall rating."]

{"sheet":"Justification","index":3,"n_rows":58,"n_cols":27,"rows_kept":58,"cut":false,"hidden":false,"merged":[[51,5,51,10],[27,5,27,10],[29,5,29,10],[33,5,33,10],[42,6,42,8],[42,10,42,12],[44,6,44,8],[46,6,46,8],[44,10,44,12],[46,10,46,12],[37,5,37,10],[0,2,0,18],[4,17,4,18],[6,17,6,18],[53,5,53,10],[55,5,55,10],[23,4,23,9],[21,4,21,9],[35,17,35,18],[31,17,31,18],[37,17,37,18],[31,5,31,10],[35,5,35,10],[39,5,39,10],[50,14,50,18],[33,17,33,18],[29,17,29,18],[1,2,1,18],[2,4,2,18],[11,17,11,18],[13,17,13,18],[15,17,15,18],[9,5,9,10],[11,5,11,10]]}
["This is secret code"]
[null,null,"Vendor Quality Evaluation - VQE"]
[null,null,"revision:","2023-11-23"]
[]
[{"$f":"IF(B5=\">\",1,0)","v":0},null,"General Information:",null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Name:"]
[]
[{"$f":"IF(B7=\">\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Self assesment/ Audit Date:"]
[0]
[0]
[0,null,"Assessment No."]
[0]
[0,null,"Assessment Responsible:",null,null,null,null,null,null,null,null,null,null,null,null,"Auditors:"]
[]
[]
[0]
[]
[]
[]
[null,null,"Production Profile:"]
[]
[0]
[0,null,"Category:"]
[]
[0,null,"Commodity:"]
[0]
[0,null,"Company Quality Contact Details:"]
[0]
[0,null,"Contact person:"]
[0]
[0,null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,"Country:",null,null,null,null,null,null,{"$f":"IF(F30=\"\",\"\",F30)","v":""}]
[]
[0,null,"City:",null,null,null,null,null,null,null,null,null,null,null,null,"Postal Code:",null,null,null,null,null,null,{"$f":"IF(F32=\"\",\"\",F32)","v":""},{"$f":"IF(W32=\"\",W30,IF(W30=\"\",W32,W30&\", \"&W32))","v":""}]
[]
[0,null,"Province/State/Region: ",null,null,null,null,null,null,null,null,null,null,null,null,"Region:",null,null,null,null,null,null,{"$f":"IF(F34=\"\",\"\",F34)","v":""},{"$f":"IF(W34=\"\",X32,IF(X32=\"\",W34,X32&\", \"&W34))","v":""}]
[0]
[0,null,"Phone No:",null,null,null,null,null,null,null,null,null,null,null,null,"Email:"]
[]
[0,null,"Mobile No:",null,null,null,null,null,null,null,null,null,null,null,null,"Web address:"]
[]
[0,null,"Fax No:"]
[]
[null,null,"Available certifications:"]
[]
[]
[]
[]
[]
[]
[0]
[0,null,"Assessment Details:"]
[0]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"Supplier Type:"]
[]
[{"$f":"IF(B52=\">\",1,0)","v":0},null,"Supplier Facility Type: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(W54=FALSE,0,1)","v":0},"None",{"$f":"IF(W54=FALSE,\"\",Y54)","v":""},{"$f":"IF(Z54=\"\",\"\",Z54)","v":""}]
[]
[{"$f":"IF(B54=\">\",1,0)","v":0},null,"Assessment Reason:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(W56=FALSE,0,1)","v":0},"ISO 9001",{"$f":"IF(W56=FALSE,\"\",Y56)","v":""},{"$f":"IF(Z56=\"\",AA54,IF(AA54=\"\",Z56,AA54&\", \"&Z56))","v":""}]
[]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}}]

{"sheet":"Rating","index":4,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":true,"merged":[[32,2,32,4],[13,6,13,12],[16,3,16,4],[7,10,7,12],[9,10,9,12],[11,10,11,12],[15,3,15,4],[18,3,18,4],[13,2,14,4],[4,6,4,12],[32,5,32,12],[44,9,44,12],[46,9,46,12],[4,2,4,3],[7,2,7,3],[19,3,19,4],[22,3,22,4],[20,3,20,4],[31,2,31,4],[23,3,23,4],[21,3,21,4],[26,6,26,8],[26,10,26,12],[28,3,28,4],[31,5,31,12]]}
[]
[{"$f":"SUM(A3:A99)","v":{"$error":"#REF!"}},null,"Vendor Quality Evaluation - VQE"]
[null,null,"revision:",{"$f":"Justification!D3","v":"2023-11-23"}]
[null,null,"Company name:",null,null,null,"Commodity:"]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""},null,null,null,{"$f":"IF(Justification!$E$24=\"\",\"\",Justification!$E$24)","v":""}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"Purpose of Assessment:",null,null,null,null,null,null,null,"Auditors:"]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,{"$f":"IF(Justification!$F$56=\"\",\"\",Justification!$F$56)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Justification!$R12=\"\",\"\",Justification!$R12)","v":""}]
[]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R14=\"\",\"\",Justification!$R14)","v":""}]
[]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R16=\"\",\"\",Justification!$R16)","v":""}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"Assessment area",null,null,null,"SCORES"]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,"Max",null,"Applicable",null,"Actual",null,"%",0.8,null,"Not scored","Unacceptable","Acceptable"]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"1.0",{"$f":"Questionnaire!D6","v":"STRATEGY AND PLANNING"},null,null,{"$f":"Questionnaire!D22","v":24},null,{"$f":"Questionnaire!D23","v":24},null,{"$f":"Questionnaire!G24","v":0},null,{"$f":"IF(I16=0,\"NA\",Questionnaire!H26)","v":0},0.8,null,{"$f":"Aux!C35","v":0},{"$f":"IF(R16=0,1,0)","v":1},{"$f":"IF(Aux!C$34=Aux!C$37,1,IF($M16>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"2.0",{"$f":"Questionnaire!D32","v":"PURCHASING AND SUPPLIER MANAGEMENT"},null,null,{"$f":"Questionnaire!D42","v":12},null,{"$f":"Questionnaire!D43","v":12},null,{"$f":"Questionnaire!G44","v":0},null,{"$f":"IF(I17=0,\"NA\",Questionnaire!H46)","v":0},0.8,null,{"$f":"Aux!D35","v":0},{"$f":"IF(R17=0,1,0)","v":1},{"$f":"IF(Aux!D$34=Aux!D$37,1,IF($M17>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"3.0",{"$f":"Questionnaire!D51","v":"CONTROL OF PRODUCTION"},null,null,{"$f":"Questionnaire!D69","v":28},null,{"$f":"Questionnaire!D70","v":28},null,{"$f":"Questionnaire!G71","v":0},null,{"$f":"IF(I18=0,\"NA\",Questionnaire!H73)","v":0},0.85,null,{"$f":"Aux!E35","v":0},1,{"$f":"IF(Aux!E$34=Aux!E$37,1,IF($M18>=85%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"4.0",{"$f":"Questionnaire!D79","v":"MONITORING AND MEASUREMENT"},null,null,{"$f":"Questionnaire!D95","v":24},null,{"$f":"Questionnaire!D96","v":24},null,{"$f":"Questionnaire!G97","v":0},null,{"$f":"IF(I19=0,\"NA\",Questionnaire!H99)","v":0},0.8,null,{"$f":"Aux!F35","v":0},1,{"$f":"IF(Aux!F$34=Aux!F$37,1,IF($M19>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"5.1/2/3",{"$f":"Questionnaire!D105","v":"IDENTIFICATION AND TRACEABILITY / MATERIALS MANAGEMENT / PERSONNEL AND TRAINING"},null,null,{"$f":"Questionnaire!D119","v":14},null,{"$f":"Questionnaire!D120","v":14},null,{"$f":"Questionnaire!G121","v":0},null,{"$f":"IF(I20=0,\"NA\",Questionnaire!H123)","v":0},0.8,null,{"$f":"Aux!G35","v":0},1,{"$f":"IF(Aux!G$34=Aux!G$37,1,IF($M20>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"6.0",{"$f":"Questionnaire!D129","v":"MAINTENANCE"},null,null,{"$f":"Questionnaire!D138","v":10},null,{"$f":"Questionnaire!D139","v":10},null,{"$f":"Questionnaire!G140","v":0},null,{"$f":"IF(I21=0,\"NA\",Questionnaire!H142)","v":0},0.8,null,{"$f":"Aux!H35","v":0},1,{"$f":"IF(Aux!H$34=Aux!H$37,1,IF($M21>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"7.0",{"$f":"Questionnaire!D148","v":"CALIBRATION"},null,null,{"$f":"Questionnaire!D160","v":14},null,{"$f":"Questionnaire!D161","v":14},null,{"$f":"Questionnaire!G162","v":0},null,{"$f":"IF(I22=0,\"NA\",Questionnaire!H164)","v":0},0.8,null,{"$f":"Aux!I35","v":0},1,{"$f":"IF(Aux!I$34=Aux!I$37,1,IF($M22>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"8.0",{"$f":"Questionnaire!D171","v":"DOCUMENTATION CONTROL AND RECORD MANAGEMENT"},null,null,{"$f":"Questionnaire!D181","v":12},null,{"$f":"Questionnaire!D182","v":12},null,{"$f":"Questionnaire!G183","v":0},null,{"$f":"IF(I23=0,\"NA\",Questionnaire!H185)","v":0},0.8,null,{"$f":"Aux!J35","v":0},1,{"$f":"IF(Aux!J$34=Aux!J$37,1,IF($M23>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,"9.0",{"$f":"Questionnaire!D188","v":"CORRECTIVE ACTION AND IMPROVEMENT"},null,null,{"$f":"Questionnaire!D199","v":14},null,{"$f":"Questionnaire!D200","v":14},null,{"$f":"Questionnaire!G201","v":0},null,{"$f":"IF(I24=0,\"NA\",Questionnaire!H203)","v":0},0.8,null,{"$f":"Aux!K35","v":0},1,{"$f":"IF(Aux!K$34=Aux!K$37,1,IF($M24>=80%,1,0))","v":0}]
[{"$f":"IF(#REF!=\">\",1,0)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUM(G16:G24)","v":152},{"$f":"SUM(H16:H24)","v":0},{"$f":"SUM(I16:I24)","v":152},null,{"$f":"SUM(K16:K24)","v":0},null,{"$f":"IF(ISERROR(K25/I25),0,K25/I25)","v":0},0.8,null,{"$f":"SUM(P16:P24)","v":0},{"$f":"SUM(Q16:Q24)","v":9},{"$f":"SUM(R16:R24)","v":0}]
[]
[null,null,null,null,null,null,"RATING",null,null,null,{"$f":"IF(P25>0,P15,IF(Aux!M32<Aux!N32,\"No comments added\",IF(Q25>0,Q15,IF(R25>0,R15,\"ERR\"))))","v":"No comments added"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not scored","B","A"]
[null,null,10,{"$f":"Questionnaire!D206","v":"ENVIRONMENT, HEALTH, AND SAFETY / SUSTAINABILITY"},null,null,{"$f":"Questionnaire!D223","v":22},null,{"$f":"Questionnaire!D224","v":22},null,{"$f":"Questionnaire!G225","v":0},null,{"$f":"IF(I29=0,\"NA\",IF(ISERROR(K29/I29),0,K29/I29))","v":0},null,null,{"$f":"Aux!L35","v":0},{"$f":"IF(R29=0,IF($M29>0%,1,0),0)","v":0},{"$f":"IF($M29>=80%,1,0)","v":0}]
[]
[]
[null,null,"Corrective action plan required by:"]
[null,null,"Follow Up Date:",null,null,{"$f":"IF(F32=\"\",\"\",F32+100)","v":""}]
[]
[null,null,null,"The quality system has been assessed on a sample basis."]
[]
[null,null,null,"In every section, part of the question content involves elements that are connected "]
[null,null,null,"with other significant items and organizational process area."]
[]
[null,null,null,"(SMA may perfrom a survey to evaluate the CAR implementation within 4 months)"]
[]
[]
[]
[]
[null,null,"Date :",null,null,null,"Signatures:",null,"SMA :"]
[]
[null,null,null,{"$f":"IF(Justification!R8=\"\",\"\",Justification!R8)","v":""},null,null,null,null,"Supplier :"]

{"sheet":"Questionnaire","index":5,"n_rows":227,"n_cols":21,"rows_kept":227,"cut":false,"hidden":false,"merged":[[223,3,223,6],[207,2,208,2],[207,3,207,6],[222,3,222,6],[52,3,52,6],[189,2,190,2],[189,3,189,6],[95,3,95,6],[80,2,81,2],[52,2,53,2],[198,3,198,6],[199,3,199,6],[180,3,180,6],[181,3,181,6],[172,3,172,6],[150,2,151,2],[1,0,1,8],[33,2,34,2],[33,3,33,6],[5,3,5,7],[21,3,21,6],[22,3,22,6],[7,2,8,2],[7,3,7,6],[4,3,4,6],[9,1,20,1],[31,3,31,7],[159,3,159,6],[160,3,160,6],[150,3,150,6],[130,3,130,6],[137,3,137,6],[138,3,138,6],[147,3,147,7],[94,3,94,6],[50,3,50,7],[78,3,78,7],[104,3,104,7],[128,3,128,7],[41,3,41,6],[42,3,42,6],[80,3,80,6],[68,3,68,6],[69,3,69,6],[106,2,107,2],[118,3,118,6],[119,3,119,6],[106,3,106,6],[130,2,131,2],[210,1,221,1],[191,1,197,1],[132,1,136,1],[152,1,158,1],[35,1,40,1],[54,1,67,1],[82,1,93,1],[109,1,117,1],[170,3,170,7],[187,3,187,7],[205,3,205,7],[209,3,209,7],[174,1,179,1],[172,2,173,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,0,1,0,{"$f":"CONCATENATE(M3,N3,O3,P3,Q3,R3)","v":"200010"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,0,1,1,{"$f":"CONCATENATE(M4,N4,O4,P4,Q4,R4)","v":"200011"},null,"2 points no comment needed"]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""},null,null,null,0,1,0,0,0,1,{"$f":"CONCATENATE(M5,N5,O5,P5,Q5,R5)","v":"010001"},null,"1 p observation needed"]
[null,null,"SECT. 1","STRATEGY AND PLANNING",null,null,null,null,null,null,null,null,0,0,1,0,0,1,"001001",null,"0 p observation needed"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,1,0,"000110",null,"NA comment needed"]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS",null,null,null,2,1,0,"NA","O","C","Combination","suitable?"]
[null,null,null,2,1,0,"NA","0;1",2]
["1.0a",{"$f":"IF(H22>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T10:T21)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Is organization capable to commit to contractual quality agreement (CAQ) (e.g. signed CAQ with current cusotmers) ? ","o","o","o","o",null,null,null,{"$f":"IF(COUNTIF(D10:G10,\"n\")<1,\"Please assess this question\",IF(AND(COUNTIF(E10:F10,\"n\")>0,H10=\"\"),\"Please place an observation\",IF(AND(G10=\"n\",I10=\"\"),\"Please place a comment\",IF(AND(OR(D10=\"n\",G10=\"n\"),H10<>\"\"),\"Please delete the observation\",IF(AND(OR(E10=\"n\",F10=\"n\"),I10<>\"\"),\"Please delete the comment\",\"\")))))","v":"Please assess this question"},{"$f":"IF(OR(F10=\"n\",E10=\"n\"),\"CAR\",IF(AND(D10=\"n\",I10<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D10=\"n\",2,0)","v":0},{"$f":"IF(E10=\"n\",1,0)","v":0},{"$f":"IF(F10=\"n\",1,0)","v":0},{"$f":"IF(G10=\"n\",1,0)","v":0},{"$f":"IF(H10=\"\",1,0)","v":1},{"$f":"IF(I10=\"\",1,0)","v":1},{"$f":"CONCATENATE(M10,N10,O10,P10,Q10,R10)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S10,$S$3:$S$7,0),1000)","v":1000}]
["1.0b",null,"Have commited objectives been analyzed and action taken where the targets are not being achieved?","o","o","o","o",null,null,null,{"$f":"IF(COUNTIF(D11:G11,\"n\")<1,\"Please assess this question\",IF(AND(COUNTIF(E11:F11,\"n\")>0,H11=\"\"),\"Please place an observation\",IF(AND(G11=\"n\",I11=\"\"),\"Please place a comment\",IF(AND(OR(D11=\"n\",G11=\"n\"),H11<>\"\"),\"Please delete the observation\",IF(AND(OR(E11=\"n\",F11=\"n\"),I11<>\"\"),\"Please delete the comment\",\"\")))))","v":"Please assess this question"},{"$f":"IF(OR(F11=\"n\",E11=\"n\"),\"CAR\",IF(AND(D11=\"n\",I11<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D11=\"n\",2,0)","v":0},{"$f":"IF(E11=\"n\",1,0)","v":0},{"$f":"IF(F11=\"n\",1,0)","v":0},{"$f":"IF(G11=\"n\",1,0)","v":0},{"$f":"IF(H11=\"\",1,0)","v":1},{"$f":"IF(I11=\"\",1,0)","v":1},"000011",{"$f":"_xlfn.IFNA(MATCH(S11,$S$3:$S$7,0),1000)","v":1000}]
["1.0c",null,"Is there a system (including improvement actions) to establish quality metrics that monitor internal failures, external failures, prevention, and appraisal?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0d",null,"Have specific improvement projects been identified and measured appropriately in 1.0c?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0e",null,"Is documented process (including reponsibilities) for New Part Development/Introduction established and adhered to?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0f",null,"Is there a process to submit first production samples (PPAP) with fully compliant documentation as requested by customer (e.g. specific level of PPAP (acc. AIAG))? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0g",null,"Is there documented process to ensure customer specifications and changes to them are being reviewed and communicated to the functions concerned?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0h",null,"Is there documented process for communicating changes to customer for products and processes where these potentially affect the form, fit or function of the product (incl. approval prior to change being introduced) ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0i",null,"How does the organization manage communication with sub-suppliers for changes that may adversely affect customer's products and vice-versa?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0j",null,"Are PFMEAs and Control Plans documented, utilized and updated accordingly including input from all relevant departments?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0k",null,"Is there evidence of corrective action implementation resulting from PFMEAs and that such Risks and are appropriate documents updated and re-issued to reflect product or process change?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["1.0l",null,"Is there established organization business continuity plan addresing eg. fire, flood, machinery breakdown, supplier disruption, pandemic ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A10:A21)*2","v":24},null,null,null,{"$f":"IF(D22/2<>COUNTIF(D10:G21,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D22/2-COUNTIF(G10:G21,\"n\"))*2","v":24}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D10:D21,\"n\")*2","v":0},{"$f":"COUNTIF(E10:E21,\"n\")","v":0},"Total",{"$f":"SUM(D24:E24)","v":0}]
[]
[null,null,null,null,null,null,"Section 1 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G24/D23),0,G24/D23)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 2","PURCHASING AND SUPPLIER MANAGEMENT"]
[null,null," "]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["2.0a",{"$f":"IF(H42>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T36:T41)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Is there evidenced process for supplier selection and qualification that assesses their quality system and performance capability?","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F36=\"n\",E36=\"n\"),\"CAR\",IF(AND(D36=\"n\",I36<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D36=\"n\",2,0)","v":0},{"$f":"IF(E36=\"n\",1,0)","v":0},{"$f":"IF(F36=\"n\",1,0)","v":0},{"$f":"IF(G36=\"n\",1,0)","v":0},{"$f":"IF(H36=\"\",1,0)","v":1},{"$f":"IF(I36=\"\",1,0)","v":1},{"$f":"CONCATENATE(M36,N36,O36,P36,Q36,R36)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S36,$S$3:$S$7,0),1000)","v":1000}]
["2.0b",null,"Is there evidenced approval / validation process of  parts and where necessary, processes prior to production start at the supplier’s facility?","o","o","o","o",null,null,null,"Please assess this question","",{"$f":"IF(D37=\"n\",2,0)","v":0},{"$f":"IF(E37=\"n\",1,0)","v":0},{"$f":"IF(F37=\"n\",1,0)","v":0},{"$f":"IF(G37=\"n\",1,0)","v":0},{"$f":"IF(H37=\"\",1,0)","v":1},{"$f":"IF(I37=\"\",1,0)","v":1},"000011",{"$f":"_xlfn.IFNA(MATCH(S37,$S$3:$S$7,0),1000)","v":1000}]
["2.0c",null,"Is there evidenced continuous monitoring process  of supplier performance with performance feedback to the supplier?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["2.0d",null,"Is there a closed loop Corrective Action System with suppliers (e.g. Supplier Corrective Action Request, 8D, etc) and evidence of its use and effectiveness?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["2.0e",null,"Is there purchasing process to ensure  documented confirmation of sub supplier purchase order requirements (e.g. part I.D., revision, quantity, delivery date, etc.) with evidenced effectiveness? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["2.0f",null,"Does the organization manage forecast and/or inventory with sub suppliers and can this be demonstrated? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A34:A42)*2","v":12},null,null,null,{"$f":"IF(D42/2<>COUNTIF(D36:G41,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D42/2-COUNTIF(G36:G41,\"n\"))*2","v":12}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D36:D41,\"n\")*2","v":0},{"$f":"COUNTIF(E36:E41,\"n\")","v":0},"Total",{"$f":"SUM(D44:E44)","v":0}]
[]
[null,null,null,null,null,null,"Section 2 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G44/D43),0,G44/D43)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 3","CONTROL OF PRODUCTION"]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["3.0a",{"$f":"IF(H69>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T55:T68)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Are procedures and work instructions defining manufacturing operations in use to communicate requirements to all people involved?","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F55=\"n\",E55=\"n\"),\"CAR\",IF(AND(D55=\"n\",I55<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D55=\"n\",2,0)","v":0},{"$f":"IF(E55=\"n\",1,0)","v":0},{"$f":"IF(F55=\"n\",1,0)","v":0},{"$f":"IF(G55=\"n\",1,0)","v":0},{"$f":"IF(H55=\"\",1,0)","v":1},{"$f":"IF(I55=\"\",1,0)","v":1},{"$f":"CONCATENATE(M55,N55,O55,P55,Q55,R55)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S55,$S$3:$S$7,0),1000)","v":1000}]
["3.0b",null,"Are process flow charts available and do these reflect actual process layouts and controls?","o","o","o","o",null,null,null,"Please assess this question","",{"$f":"IF(D56=\"n\",2,0)","v":0},{"$f":"IF(E56=\"n\",1,0)","v":0},{"$f":"IF(F56=\"n\",1,0)","v":0},{"$f":"IF(G56=\"n\",1,0)","v":0},{"$f":"IF(H56=\"\",1,0)","v":1},{"$f":"IF(I56=\"\",1,0)","v":1},{"$f":"CONCATENATE(M56,N56,O56,P56,Q56,R56)","v":"000011"},1000]
["3.0c",null,"Do procedures/work instructions/control plans specify requirements for the operation, inspection, testing, gauging and recording results available (including processes with special characteristics) ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0d",null,"Do employees perform operations in accordance with work instructions and other relevant requirements?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0e",null,"Are special/critical processes identified and subjected to process validation?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0f",null,"Are appropriate controls and criteria specified, implemented and recorded for production start-up as well as product, tooling and process changes?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0g",null,"Are appropriate resources for normal/ special/critical processes available?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0h",null,"Is work environment clean and well organized?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0i",null,"Are statistical methods implemented to monitor process performance against specifications?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0j",null,"Are special causes of variation investigated, appropriate action taken and records of such maintained?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0k",null,"Where statistical methods are employed, is the required process capability index (e.g. CPK>1.67/1.33) met on all significant/relevant characteristics?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0l",null,"Are environmental conditions within the production steps apropriate to protect the product against damages (e.g. excessive heat, moisture exposure, electrostatic discharge)? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0m",null,"Are there written procedures for handling, storage, packaging, delivery, and preservation of product?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["3.0n",null,"Does organization control packaging processes properly to ensure product conformance to specifications?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A55:A68)*2","v":28},null,null,null,{"$f":"IF(D69/2<>COUNTIF(D55:G68,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D69/2-COUNTIF(G55:G68,\"n\"))*2","v":28}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D55:D68,\"n\")*2","v":0},{"$f":"COUNTIF(E55:E68,\"n\")","v":0},"Total",{"$f":"SUM(D71:E71)","v":0}]
[]
[null,null,null,null,null,null,"Section 3 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G71/D70),0,G71/D70)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 4","MONITORING AND MEASUREMENT"]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["4.0a",{"$f":"IF(H95>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T83:T94)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Is there a process to guarantee supplier conformance of incoming material to specifications?","o","o","o","o",null,null,null,{"$f":"IF(COUNTIF(D83:G83,\"n\")<1,\"Please assess this question\",IF(AND(COUNTIF(E83:F83,\"n\")>0,H83=\"\"),\"Please place an observation\",IF(AND(G83=\"n\",I83=\"\"),\"Please place a comment\",IF(AND(OR(D83=\"n\",G83=\"n\"),H83<>\"\"),\"Please delete the observation\",IF(AND(OR(E83=\"n\",F83=\"n\"),I83<>\"\"),\"Please delete the comment\",\"\")))))","v":"Please assess this question"},{"$f":"IF(OR(F83=\"n\",E83=\"n\"),\"CAR\",IF(AND(D83=\"n\",I83<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D83=\"n\",2,0)","v":0},{"$f":"IF(E83=\"n\",1,0)","v":0},{"$f":"IF(F83=\"n\",1,0)","v":0},{"$f":"IF(G83=\"n\",1,0)","v":0},{"$f":"IF(H83=\"\",1,0)","v":1},{"$f":"IF(I83=\"\",1,0)","v":1},{"$f":"CONCATENATE(M83,N83,O83,P83,Q83,R83)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S83,$S$3:$S$7,0),1000)","v":1000}]
["4.0b",null,"If incoming product is released for urgent production purposes, are products identified and recorded in order to permit immediate recall and replacement due to non-conformance to specified requirements?","o","o","o","o",null,null,null,"Please assess this question","",{"$f":"IF(D84=\"n\",2,0)","v":0},{"$f":"IF(E84=\"n\",1,0)","v":0},{"$f":"IF(F84=\"n\",1,0)","v":0},{"$f":"IF(G84=\"n\",1,0)","v":0},{"$f":"IF(H84=\"\",1,0)","v":1},{"$f":"IF(I84=\"\",1,0)","v":1},{"$f":"CONCATENATE(M84,N84,O84,P84,Q84,R84)","v":"000011"},1000]
["4.0c",null,"Are documented procedures in use to control in process/final inspection and testing (including special process parameters)?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0d",null,"Is evidenced process in place to disposition nonconform/on-hold materials, supplies and/or product?  ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0e",null,"Is the material appropriately segregated to prevent unintended usage? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0f",null,"Is suspected material removed in a timely manner from  production area? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0g",null,"Are product audits performed and findings followed up and validated?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0h",null,"Is identification of inspection and test results, including special processes, maintained throughout to ensure that only conforming goods are released for use?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0i",null,"Are there records that all products passed inspections and tests, as defined by the acceptance criteria including identification of responsible authority for the release of the product?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0j",null,"Are internal products On Hold, recall/rework procedures and instructions used in the event that the organization's part specs are found to be outside of specified requirements?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0k",null,"Has organization established an evidenced (including responsibilitiy) recall procedure or process to notify customers of  potentially non-conforming material ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["4.0l",null,"Has organization established process to ensure that customer's authorization is received prior to non-conforming material is shipped? (e.g. deviation permit)","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A81:A95)*2","v":24},null,null,null,{"$f":"IF(D95/2<>COUNTIF(D83:G94,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D95/2-COUNTIF(G83:G94,\"n\"))*2","v":24}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D83:D94,\"n\")*2","v":0},{"$f":"COUNTIF(E83:E94,\"n\")","v":0},"Total",{"$f":"SUM(D97:E97)","v":0}]
[]
[null,null,null,null,null,null,"Section 4 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G97/D96),0,G97/D96)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 5.1/2/3","IDENTIFICATION AND TRACEABILITY / MATERIALS MANAGEMENT / PERSONNEL AND TRAINING"]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
[null,null,"IDENTIFICATION AND TRACEABILITY"]
["5.1a",{"$f":"IF(H119>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T110:T118)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Has a formal traceability system been established to identify product and it's components at all stages from receipt through shipment?","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F110=\"n\",E110=\"n\"),\"CAR\",IF(AND(D110=\"n\",I110<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D110=\"n\",2,0)","v":0},{"$f":"IF(E110=\"n\",1,0)","v":0},{"$f":"IF(F110=\"n\",1,0)","v":0},{"$f":"IF(G110=\"n\",1,0)","v":0},{"$f":"IF(H110=\"\",1,0)","v":1},{"$f":"IF(I110=\"\",1,0)","v":1},{"$f":"CONCATENATE(M110,N110,O110,P110,Q110,R110)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S110,$S$3:$S$7,0),1000)","v":1000}]
["5.1b",null,"Is product flow secured against a chance of mix up between process and finished material at a work station (incl. shift change)?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"MATERIALS MANAGEMENT","o","o","o","o"]
["5.2a",null,"Are appropriate systems in place to ensure that product and associated materials are properly stored at all production stages including the use of 'First-in, First-out' (FIFO) systems where appropriate?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["5.2b",null,"Is material sufficiently segrated and identified to prevent accidental use of wrong components in the assembly process","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"PERSONNEL AND TRAINING","o","o","o","o"]
["5.3a",null,"Has a system been established to identify training needs and conduct training of all personnel performing activities affecting quality?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["5.3b",null,"Is personnel qualification based on evidence of appropriate education, training and/or experience? If applicable is certification renewed on apropriate routine/frequncy/method? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["5.3c",null,"Are responsibilities for specific activities defined. Is interchangeability of employees defined and documented ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A107:A119)*2","v":14},null,null,null,{"$f":"IF(D119/2<>COUNTIF(D110:G111,\"n\")+COUNTIF(D113:G114,\"n\")+COUNTIF(D116:G118,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D119/2-COUNTIF(G110:G111,\"n\")-COUNTIF(G113:G114,\"n\")-COUNTIF(G116:G118,\"n\"))*2","v":14}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D113:D114,\"n\")*2+COUNTIF(D116:D118,\"n\")*2+COUNTIF(D110:D111,\"n\")*2","v":0},{"$f":"COUNTIF(E113:E114,\"n\")+COUNTIF(E116:E118,\"n\")+COUNTIF(E110:E111,\"n\")","v":0},"Total",{"$f":"SUM(D121:E121)","v":0}]
[]
[null,null,null,null,null,null," Section 5.1/2/3 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G121/D120),0,G121/D120)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 6","MAINTENANCE"]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["6.0a",{"$f":"IF(H138>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T133:T137)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Is there a planned maintenance system including a maintenance schedule, defined maintenance criteria, assigned responsibilities and records ?","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F133=\"n\",E133=\"n\"),\"CAR\",IF(AND(D133=\"n\",I133<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D133=\"n\",2,0)","v":0},{"$f":"IF(E133=\"n\",1,0)","v":0},{"$f":"IF(F133=\"n\",1,0)","v":0},{"$f":"IF(G133=\"n\",1,0)","v":0},{"$f":"IF(H133=\"\",1,0)","v":1},{"$f":"IF(I133=\"\",1,0)","v":1},{"$f":"CONCATENATE(M133,N133,O133,P133,Q133,R133)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S133,$S$3:$S$7,0),1000)","v":1000}]
["6.0b",null,"Is maintenance conducted at defined frequencies for all equipment?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["6.0c",null,"Has efficiency monitoring been established for maintenance system ?   ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["6.0d",null,"Is there an efficiency target specified (6.0c) with potential deviations investigated and documented adequately to evidence improvement ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["6.0e",null,"Are replacement parts identified and available for key manufacturing equipment?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A131:A138)*2","v":10},null,null,null,{"$f":"IF(D138/2<>COUNTIF(D133:G137,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D138/2-COUNTIF(G133:G137,\"n\"))*2","v":10}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D133:D137,\"n\")*2","v":0},{"$f":"COUNTIF(E133:E137,\"n\")","v":0},"Total",{"$f":"SUM(D140:E140)","v":0}]
[]
[null,null,null,null,null,null,"Section 6 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G140/D139),0,G140/D139)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 7","CALIBRATION"]
[]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["7.0a",{"$f":"IF(H160>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T153:T159)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Has acceptance criteria for inspection, measuring, and test equipment (including software when appropriate) been established to assure apropriate accuracy and precision?","o","o","o","o",null,null,null,{"$f":"IF(COUNTIF(D153:G153,\"n\")<1,\"Please assess this question\",IF(AND(COUNTIF(E153:F153,\"n\")>0,H153=\"\"),\"Please place an observation\",IF(AND(G153=\"n\",I153=\"\"),\"Please place a comment\",IF(AND(OR(D153=\"n\",G153=\"n\"),H153<>\"\"),\"Please delete the observation\",IF(AND(OR(E153=\"n\",F153=\"n\"),I153<>\"\"),\"Please delete the comment\",\"\")))))","v":"Please assess this question"},{"$f":"IF(OR(F153=\"n\",E153=\"n\"),\"CAR\",IF(AND(D153=\"n\",I153<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D153=\"n\",2,0)","v":0},{"$f":"IF(E153=\"n\",1,0)","v":0},{"$f":"IF(F153=\"n\",1,0)","v":0},{"$f":"IF(G153=\"n\",1,0)","v":0},{"$f":"IF(H153=\"\",1,0)","v":1},{"$f":"IF(I153=\"\",1,0)","v":1},{"$f":"CONCATENATE(M153,N153,O153,P153,Q153,R153)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S153,$S$3:$S$7,0),1000)","v":1000}]
["7.0b",null,"Is Measurement System Analysis (MSA) conducted for  gages, measuring and test equipment?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["7.0c",null,"Have criteria (e.g. VDA/AIAG) used for acceptance of measuring systems been established ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["7.0d",null," Does system ensure that calibration is traceable to National/International Standards?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["7.0e",null,"Are the inspection, measuring, and test equipment (including software when appropriate) calibrated at prescribed intervals, in the correct environmental  conditions?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["7.0f",null,"Is inspection, measurement, and test equipment properly handled, preserved, and stored to maintain calibration and fitness for use?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["7.0g",null,"Are appropriate actions, including customer's notification, taken on both product and process when inspection, measurement, or test equipment is found to be out of calibration?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A151:A160)*2","v":14},null,null,null,{"$f":"IF(D160/2<>COUNTIF(D153:G159,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D160/2-COUNTIF(G153:G159,\"n\"))*2","v":14}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D153:D159,\"n\")*2","v":0},{"$f":"COUNTIF(E153:E159,\"n\")","v":0},"Total",{"$f":"SUM(D162:E162)","v":0}]
[]
[null,null,null,null,null,null,"Section 7 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G162/D161),0,G162/D161)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 8","DOCUMENTATION CONTROL AND RECORD MANAGEMENT"]
[null,null," "]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["8.0a",{"$f":"IF(H181>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T174:T180)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete – Please rate all the questions"},"Does system for document control include review, approval, issue dating and distribution of documents and procedures? (this must include control of relevant computer software, masters, and customer's furnished drawings)","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F175=\"n\",E175=\"n\"),\"CAR\",IF(AND(D175=\"n\",I175<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D175=\"n\",2,0)","v":0},{"$f":"IF(E175=\"n\",1,0)","v":0},{"$f":"IF(F175=\"n\",1,0)","v":0},{"$f":"IF(G175=\"n\",1,0)","v":0},{"$f":"IF(H175=\"\",1,0)","v":1},{"$f":"IF(I175=\"\",1,0)","v":1},{"$f":"CONCATENATE(M175,N175,O175,P175,Q175,R175)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S175,$S$3:$S$7,0),1000)","v":1000}]
["8.0b",null,"Has an evidenced system been implemented to handle engineering and process changes to ensure that they have been properly approved, implemented and validated?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["8.0c",null,"Are obsolete documents immediately withdrawn from all points of use?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["8.0d",null,"Has organization established and maintained procedures for identification, collection, indexing, filing, storage, maintenance, and disposition of records affecting product and system quality ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["8.0e",null,"Are retention times for records established and recorded?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["8.0f",null,"Is  system in place to ensure records are available when applicable (per year, product, test type, etc.)  for review upon request?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A173:A181)*2","v":12},null,null,null,{"$f":"IF(D181/2<>COUNTIF(D175:G180,\"n\"),1,0)","v":1}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D181/2-COUNTIF(G175:G180,\"n\"))*2","v":12}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D175:D180,\"n\")*2","v":0},{"$f":"COUNTIF(E175:E180,\"n\")","v":0},"Total",{"$f":"SUM(D183:E183)","v":0}]
[]
[null,null,null,null,null,null,"Section 8 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G183/D182),0,G183/D182)","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 9","CORRECTIVE ACTION AND IMPROVEMENT"]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
["9.0a",{"$f":"IF(H199>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T192:T198)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete - Missing comments"},"Have procedures been established, and documents maintained for investigating the cause of non-conformance and the corrective action needed to prevent recurrence?","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F192=\"n\",E192=\"n\"),\"CAR\",IF(AND(D192=\"n\",I192<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D192=\"n\",2,0)","v":0},{"$f":"IF(E192=\"n\",1,0)","v":0},{"$f":"IF(F192=\"n\",1,0)","v":0},{"$f":"IF(G192=\"n\",1,0)","v":0},{"$f":"IF(H192=\"\",1,0)","v":1},{"$f":"IF(I192=\"\",1,0)","v":1},{"$f":"CONCATENATE(M192,N192,O192,P192,Q192,R192)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S192,$S$3:$S$7,0),1000)","v":1000}]
["9.0b",null,"Are the causes of non-conformances investigated and the results documented? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["9.0c",null,"Are appropriate corrective actions developed to eliminate the causes of the non-conformance?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["9.0d",null,"Does organization use a disciplined problem solving methods?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["9.0e",null,"Is the effectiveness of corrective action verified?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["9.0f",null,"Are customer's returned parts analyzed and corrective actions initiated as appropriate?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["9.0g",null,"Are non-conformance reports, e.g. product quality, deviation, audit results, quality records, etc. used to develop preventive actions?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A192:A198)*2","v":14}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D199/2-COUNTIF(G192:G198,\"n\"))*2","v":14}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D192:D198,\"n\")*2","v":0},{"$f":"COUNTIF(E192:E198,\"n\")","v":0},"Total",{"$f":"SUM(D201:E201)","v":0}]
[]
[null,null,null,null,null,null,"Section 9 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G201/D200),0,G201/D200)","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"SECT. 10.1/2","ENVIRONMENT, HEALTH, AND SAFETY / SUSTAINABILITY"]
[]
[null,null,"QUESTION","SCORE",null,null,null,"ASSESSOR OBSERVATIONS","ASSESSOR COMMENTS"]
[null,null,null,2,1,0,"NA","0;1",2]
[null,null,"ENVIRONMENT, HEALTH, AND SAFETY"]
["10.1a",{"$f":"IF(H223>0,\"Section incomplete – Please rate all the questions\",IF(SUM(T211:T222)>100,\"Section incomplete - Missing comments\",\"Section complete\"))","v":"Section incomplete - Missing comments"},"Does supplier have an official EHS policy to commit to regulatory compliance, continuous improvement, and pollution prevention ?","o","o","o","o",null,null,null,{"$f":"IF(COUNTIF(D211:G211,\"n\")<1,\"Please assess this question\",IF(AND(COUNTIF(E211:F211,\"n\")>0,H211=\"\"),\"Please place an observation\",IF(AND(G211=\"n\",I211=\"\"),\"Please place a comment\",IF(AND(OR(D211=\"n\",G211=\"n\"),H211<>\"\"),\"Please delete the observation\",IF(AND(OR(E211=\"n\",F211=\"n\"),I211<>\"\"),\"Please delete the comment\",\"\")))))","v":"Please assess this question"},{"$f":"IF(OR(F211=\"n\",E211=\"n\"),\"CAR\",IF(AND(D211=\"n\",I211<>\"\"),\"CO\",\"\"))","v":""},{"$f":"IF(D211=\"n\",2,0)","v":0},{"$f":"IF(E211=\"n\",1,0)","v":0},{"$f":"IF(F211=\"n\",1,0)","v":0},{"$f":"IF(G211=\"n\",1,0)","v":0},{"$f":"IF(H211=\"\",1,0)","v":1},{"$f":"IF(I211=\"\",1,0)","v":1},{"$f":"CONCATENATE(M211,N211,O211,P211,Q211,R211)","v":"000011"},{"$f":"_xlfn.IFNA(MATCH(S211,$S$3:$S$7,0),1000)","v":1000}]
["10.1b",null,"Is there evidence available on implementation, monitoring, and reporting of health & safety risks and mitigation plans?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.1c",null,"Is there evidence available on implementation, monitoring, and reporting of concept / plan to reduce energy consumption ?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.1e",null,"Is supplier’s management system aligned (e.g. certified) to the EHS standards of ISO  14001, ISO 45001, and ISO 50001? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SUSTAINABILITY","o","o","o","o"]
["10.2a",null,"Does your company have a documented and released sustainability program?","o","o","o","o",null,null,null,"Please assess this question",{"$f":"IF(OR(F216=\"n\",E216=\"n\"),\"CAR\",IF(AND(D216=\"n\",I216<>\"\"),\"CO\",\"\"))","v":""},0,0,0,0,1,1,"000011",1000]
["10.2b",null,"Does your company publish a sustainability or environmental report?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.2c",null,"Does your company sign Code of Conduct (acc. branch association, UN Global Compact, ILO, OECD) with your direct material suppliers?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.2d",null,"Do you have a written labor standard for your workforce?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.2e",null,"Is there evidence available on implementation, monitoring, and reporting of greenhouse gas emissions and waste management ? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.2f",null,"Are all materials that your company delivers to customers, compliant with RoHS and REACH regulations?","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
["10.2g",null,"Are all materials that your company delivers to customers, free of conflict minerals (acc. to Dodd Frank Act)? ","o","o","o","o",null,null,null,"Please assess this question","",0,0,0,0,1,1,"000011",1000]
[null,null,"SECTION MAX SCORE",{"$f":"COUNTA(A211:A222)*2","v":22}]
[null,null,"SECTION APPLICABLE SCORE",{"$f":"(D223/2-COUNTIF(G211:G222,\"n\"))*2","v":22}]
[null,null,"SECTION ACHIEVED SCORE",{"$f":"COUNTIF(D211:D214,\"n\")*2+COUNTIF(D216:D222,\"n\")*2","v":0},{"$f":"COUNTIF(E211:E214,\"n\")+COUNTIF(E216:E222,\"n\")","v":0},"Total",{"$f":"SUM(D225:E225)","v":0}]
[]
[null,null,null,null,null,null,"Section 10 assessment result = (achieved score/ applicable score) *100 = ",{"$f":"IF(ISERROR(G225/D224),0,G225/D224)","v":0}]

{"sheet":"Non Conformities","index":6,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,1,6,8],[4,1,4,13],[6,10,6,14]]}
[]
[null,null,null,"Supplier Name:",null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[]
[null,null,null,"Self assesment/ Audit Date:",null,null,null,null,{"$f":"IF(Justification!$R$7=\"\",\"\",Justification!$R$7)","v":""}]
[]
[null,null,null,null,"Supplier Issues","Supplier Issues","Supplier Issues","Supplier Issues"]
[null,"to be completed by auditor",null,null,null,null,null,null,null,null,"to be completed by the organization (mandatory)"]
[null,"Section/\nPos.",null,"Description",null,null,null,null,"Weakness / Findings","Assessment matrix","Corrective Action \n(against identified issue)","Person responsible (name / company)","Planned Start Date","Planned Finish Date","Comments / Notes ","% completion","Actual Finish Date","Closure verification date by SMA"]
[null,"1.0b",null,"Have the trends in meeting the above objectives been analyzed and action taken where the targets are not being achieved?"]
[null,"1.0d",null,"Have specific improvement projects been identified and measured appropriately in 1.0c?"]
[null,"1.0e",null,"Is responsbility for New Part Development Introduction clearly assigned to a specific position? Is this position organizationally capable to lead the program efficiently e.g. manager, leader)?"]
[null,"1.0f",null,"Is there a process to submit first production samples (PPAP) with fully compliant documentation as requested by customer (e.g. specific level of PPAP (acc. AIAG))? "]
[null,"1.0i",null,"How does the organization manage communications with sub-suppliers for changes that may adversely affect customer's products and vice-versa?"]
[null,"2.0b",null,"Is there an effective system for approval / validation of parts and where necessary, processes prior to commencement of production at the supplier’s facility?"]
[null,"2.0c",null,"Is there an effective system for ongoing monitoring of supplier performance and a means of communicating performance back to the supplier?"]
[null,"2.0d",null,"Is there a closed loop Corrective Action System with suppliers (e.g. Supplier Corrective Action Request, 8D, etc) and evidence of its use and effectiveness?"]
[null,"2.0e",null,"Does the purchasing process ensure  documented confirmation of sub supplier purchase order requirements (e.g. part I.D., revision, quantity, delivery date, etc.) and can evidence be provided demonstrating effectiveness?"]
[null,"3.0b",null,"Do available procedures/work instructions/control plans specify requirements for the operation, inspection, testing, gauging and recording results, including processes with special characteristics?"]
[null,"3.0c",null,"Are process flow charts available and do they reflect actual process layouts and controls?"]
[null,"3.0f",null,"Are appropriate controls and criteria specified, implemented and recorded for production start-up as well as product, tooling and process changes?"]
[null,"3.0g",null,"Are the required resources for normal/ special processes available and are they appropriate for the type of work being accomplished?"]
[null,"3.0h",null,"Is the work environment clean and well organized?"]
[null,"4.0a",null,"Is a process in place to guarantee supplier conformance of incoming material to specifications?"]
[null,"4.0b",null,"If incoming product is released for urgent production purposes, are products identified and recorded in order to permit immediate recall and replacement due to non-conformance to specified requirements?"]
[null,"4.0c",null,"Are written procedures in use to control in process/final inspection and testing (including special process parameters)?"]
[null,"5.2a",null,"Are appropriate systems in place to ensure that product and associated materials are properly stored at all production stages including the use of 'First-in, First-out' (FIFO) systems where appropriate?"]
[null,"5.2b",null,"Is material sufficiently segrated and identified to prevent inadvertant use of wrong components in the assembly process"]
[null,"7.0b",null,"Is Measurement System Analysis (MSA) conducted for all gages, measuring , and test equipment, noted on the control plan?"]
[null,"7.0d",null,"Do systems ensure that calibration is traceable to National/International Standards?"]

{"sheet":"Aux","index":7,"n_rows":127,"n_cols":14,"rows_kept":127,"cut":false,"hidden":true,"merged":[[37,0,37,7],[0,2,0,11]]}
[null,null,"SECTIONS"]
[null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"Questionnaire!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Score"]
[2,1,{"$f":"COUNTIF(C$3:C$20,$B31)","v":0},{"$f":"COUNTIF(D$3:D$20,$B31)","v":0},0,0,0,0,0,0,0,0,"\"No comments\" count","Cells qty."]
[1,2,{"$f":"COUNTIF(C$3:C$20,$B32)","v":0},{"$f":"COUNTIF(D$3:D$20,$B32)","v":0},0,0,0,0,0,0,0,0,{"$f":"COUNTBLANK(Questionnaire!K10:K222)","v":126},213]
[0,3,{"$f":"COUNTIF(C$3:C$20,$B33)","v":0},0,0,0,0,0,0,0,0,0]
["N/A",4,{"$f":"COUNTIF(C$3:C$20,$B34)","v":0},0,0,0,0,0,0,0,0,0]
["Not Scored",5,{"$f":"COUNTIF(C$3:C$20,$B35)+COUNTIF(C$3:C$20,\"0\")","v":0},{"$f":"COUNTIF(D$3:D$20,$B35)+COUNTIF(D$3:D$20,\"0\")","v":0},{"$f":"COUNTIF(E$3:E$20,$B35)+COUNTIF(E$3:E$20,\"0\")","v":0},0,0,0,0,0,0,0]
["N/A+N/S",null,{"$f":"SUM(C34:C35)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(L34:L35)","v":0}]
["All",null,{"$f":"COUNTA(C3:C20)","v":12},{"$f":"COUNTA(D3:D20)","v":6},14,12,7,5,7,6,8,12]
["QUESTIONS"]
["1.0a","Have Annual Quality Targets been agreed with customer/s? (e.g Supplier Agreement)"]
["1.0b","Have the trends in meeting the above objectives been analyzed and action taken where the targets are not being achieved?"]
["1.0c","Is there a system to establish quality metrics that monitor internal failures, external failures, prevention, and appraisal?"]
["1.0d","Have specific improvement projects been identified and measured appropriately in 1.0c?"]
["1.0e","Is responsbility for New Part Development Introduction clearly assigned to a specific position? Is this position organizationally capable to lead the program efficiently e.g. manager, leader)?"]
["1.0f","Is there a process to submit first production samples (PPAP) with fully compliant documentation as requested by customer (e.g. specific level of PPAP (acc. AIAG))? "]
["1.0g","Is there an evidenced process for ensuring customer specifications and changes to them are reviewed and communicated to the functions concerned?"]
["1.0h","Does an evidenced process exist for communicating changes to customer for products and processes where these can potentially affect the form, fit or function of the product (incl. approval prior to change being introduced) ?"]
["1.0i","How does the organization manage communications with sub-suppliers for changes that may adversely affect customer's products and vice-versa?"]
["1.0j","Are PFMEAs and Control Plans prepared and utilized (after definition of process flow) with input from all relevant departments?"]
["1.0k","Is there evidence of corrective action implementation resulting from PFMEAs and that such Risks and are appropriate documents updated and re-issued to reflect product or process change?"]
["1.0l","Are the organization's processes capable of meeting customer's specifications and are they demonstrated by measureable results?"]
["2.0a","Does a documented process (with evidence available) exist for supplier selection and qualification that assesses their quality system and performance capability?"]
["2.0b","Is there an effective system for approval / validation of parts and where necessary, processes prior to commencement of production at the supplier’s facility?"]
["2.0c","Is there an effective system for ongoing monitoring of supplier performance and a means of communicating performance back to the supplier?"]
["2.0d","Is there a closed loop Corrective Action System with suppliers (e.g. Supplier Corrective Action Request, 8D, etc) and evidence of its use and effectiveness?"]
["2.0e","Does the purchasing process ensure  documented confirmation of sub supplier purchase order requirements (e.g. part I.D., revision, quantity, delivery date, etc.) and can evidence be provided demonstrating effectiveness?"]
["2.0f","Does the organization effectively manage forecast and/or inventory with sub suppliers and can this be demonstrated?"]
["3.0a","Are procedures and work instructions defining manufacturing operations in use that communicate requirements to all people involved in this process?"]
["3.0b","Do available procedures/work instructions/control plans specify requirements for the operation, inspection, testing, gauging and recording results, including processes with special characteristics?"]
["3.0c","Are process flow charts available and do they reflect actual process layouts and controls?"]
["3.0d","Do employees perform operations in accordance with work instructions and other relevant requirements?"]
["3.0e","Are special/critical processes identified and subjected to process validation when the resulting output cannot be verified by subsequent monitoring or measurement to ensure product specifications are met?"]
["3.0f","Are appropriate controls and criteria specified, implemented and recorded for production start-up as well as product, tooling and process changes?"]
["3.0g","Are the required resources for normal/ special processes available and are they appropriate for the type of work being accomplished?"]
["3.0h","Is the work environment clean and well organized?"]
["3.0i","Are statistical methods implemented to monitor process performance against specifications?"]
["3.0j","Are special causes of variation investigated, appropriate action taken and records of such maintained?"]
["3.0k","Where statistical methods are employed, is the required process capability index (e.g. CPK>1.67/1.33) met on all significant/relevant characteristics?"]
["3.0l","Is the product protected from, excessive heat, moisture exposure, corosive or caustic materials, excessive rework, electronic discharge, mechanical damage (from dropping, other materials, product, or supplies falling onto product, etc.), hand or skin oils, etc."]
["3.0m","Are there written procedures for handling, storage, packaging, delivery, and preservation of product?"]
["3.0n","Does the organization control packaging processes properly to ensure product conformance to specifications?"]
["4.0a","Is a process in place to guarantee supplier conformance of incoming material to specifications?"]
["4.0b","If incoming product is released for urgent production purposes, are products identified and recorded in order to permit immediate recall and replacement due to non-conformance to specified requirements?"]
["4.0c","Are written procedures in use to control in process/final inspection and testing (including special process parameters)?"]
["4.0d","Does the organization have a documented Material Review Board process to disposition nonconform/on-hold materials, supplies and/or product?  "]
["4.0e","Is the material appropriately segregated to prevent unintended usage? "]
["4.0f","Is suspected material removed in a timely manner from the production area? "]
["4.0g","Are product audits performed and findings utilized towards corrective action/ continuous improvement?"]
["4.0h","Is the identification of inspection and test results, including special processes, maintained throughout to ensure that only conforming goods are released for use?"]
["4.0i","Are there records that all product has passed the inspections and tests as defined by the acceptance criteria and is the authority identified who is responsible for the release of the product?"]
["4.0j","Are internal products On Hold and recall/rework procedures and instructions used in the event that the organization's part specs are found to be outside of specified requirements?"]
["4.0k","Has the organization established a recall procedure or process to notify customers of  potentially non-conforming material ?"]
["4.0l","Does the organization have a process to ensure that customer's authorization is received prior to non-conforming material is shipped? (e.g. Deviation)"]
["5.1a","Has a formal traceability system been established to identify product and it's constituent components at all stages from receipt through shipment?"]
["5.1b","Is product flow secured against a chance of mix up between process and finished material at a work station (incl. Shift change)?"]
["5.2a","Are appropriate systems in place to ensure that product and associated materials are properly stored at all production stages including the use of 'First-in, First-out' (FIFO) systems where appropriate?"]
["5.2b","Is material sufficiently segrated and identified to prevent inadvertant use of wrong components in the assembly process"]
["5.3a","Has a system been established to identify training needs and conduct training of all personnel performing activities affecting quality?"]
["5.3b","Are personnel performing specific assigned tasks qualified on the basic of appropriate education, training and/or experience? "]
["5.3c","Are there defined responsibilities for specific activities (e.g.APQP, PPAP, 8D, etc)?"]
["6.0a","Is there a planned maintenance system including a maintenance schedule, defined maintenance criteria, assigned responsibilities and records ?"]
["6.0b","Is maintenance conducted at the prescribed frequencies for all equipment?"]
["6.0c","Have efficiency monitoring been established for maintenance system ?"]
["6.0d","Is there an efficiency target specified (6.0c) with eventual deviations investigated and documented adequately to evidence improvement ?"]
["6.0e","Are replacement parts identified and available for key manufacturing equipment?"]
["7.0a","Has inspection, measuring, and test equipment (including software when appropriate) been provided that is capable of the required accuracy and precision?"]
["7.0b","Is Measurement System Analysis (MSA) conducted for all gages, measuring , and test equipment, noted on the control plan?"]
["7.0c","Have criteria (e.g. VDA/AIAG) used for acceptance of measuring systems been established ?"]
["7.0d","Do systems ensure that calibration is traceable to National/International Standards?"]
["7.0e","Are the inspection, measuring, and test equipment (including software when appropriate) calibrated at prescribed intervals, in the correct environmental  conditions?"]
["7.0f","Are inspection, measurement, and test equipment properly handled, preserved, and stored to maintain calibration and fitness for use?"]
["7.0g","Are appropriate actions, including customer's notification, taken on both product and process when inspection, measurement, or test equipment is found to be out of calibration?"]
["8.0a","Does the system for document control Include review, approval, issue dating and distribution of documents and procedures? (this must include control of relevant computer software, masters, and customer's furnished drawings)"]
["8.0b","Has an evidenced system been implemented to handle engineering and process changes to ensure that they have been properly approved, implemented and validated ?"]
["8.0c","Are obsolete documents immediately withdrawn from all points of use?"]
["8.0d","Has the organization established and maintained procedures for identification, collection, indexing, filing, storage, maintenance, and disposition of all records affecting product and system quality ?"]
["8.0e","Are retention times for records established and recorded?"]
["8.0f","Is a system applied to ensure that records are available when applicable (per year, product, test type, etc.)  for review upon request?"]
["9.0a","Have procedures been established, and documents maintained for investigating the cause of non-conformance and the corrective action needed to prevent recurrence?"]
["9.0b","Are the causes of non-conformances investigated and the results documented? "]
["9.0c","Is analysis and corrective action implemented and recorded for problems identified on statistical charts or in capability studies?"]
["9.0d","Are appropriate corrective actions developed to eliminate the causes of the non-conformance?"]
["9.0e","Does the organization use a disciplined problem solving methods?"]
["9.0f","Is the effectiveness of corrective action verified?"]
["9.0g","Are customer's returned parts  analyzed and are corrective actions initiated as appropriate?"]
["9.0h","Are non-conformance reports, e.g. product quality, deviation, audit results, quality records, etc. used to develop preventive actions?"]
["10.1a","Does supplier have official EHS policy on commitment to regulatory compliance, continuous improvement, and pollution prevention ?"]
["10.1b","Is there objective evidence available on implementation, monitoring, and reporting of health & safety risks and mitigation plans?"]
["10.1c","Is there objective evidence available on implementation, monitoring, and reporting of concept / plan to reduce energy consumption ?"]
["10.1d","Is there objective evidence available on implementation, monitoring, and reporting of environmental impact and mitigation plans ?"]
["10.1e","Is supplier’s management system aligned (e.g. certified) to the EHS standards of ISO  14001, OHSAS 18000, and ISO 500001? "]
["10.2a","Does your company have a documented and released sustainability program?"]
["10.2b","Does your company publish a sustainability or environmental report?"]
["10.2c","Does Your company sign Code of Conduct (acc. branch association, UN Global Compact, ILO, OECD) with Your direct material suppliers?"]
["10.2d","Do you have a written labor standard for your workforce?"]
["10.2e","Is there objective evidence available on implementation, monitoring, and reporting of greenhouse gas emissions and waste management ? "]
["10.2f","Are all materials that your company delivers to customers, compliant with RoHS and REACH regulations?"]
["10.2g","Are all materials that your company delivers to customers, free of conflict minerals (acc. To Dodd Frank Act)? "]

{"sheet":"Comments","index":8,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,1,6,8],[4,0,4,12],[6,9,6,13]]}
[]
[null,null,null,"Supplier Name:",null,null,null,null,{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,null,"Self assesment/ Audit Date:",null,null,null,null,{"$f":"IF(Justification!$R$7=\"\",\"\",Justification!$R$7)","v":""}]
[]
[]
[null,null,null,null,"Electrolux Issues","Electrolux Issues","Electrolux Issues","Electrolux Issues"]
[null,"to be completed by auditor",null,null,null,null,null,null,null,"to be completed by the organization (optional)"]
[null,"Section/Pos.",null,"Description","Assessment Matrix",null,null,null,"Observations","Corrective Action \n(against identified issue)","Person responsible (name / company)","Planned Start Date","Planned Finish Date","Comments / Notes ","% completion","Actual Finish Date","Closure verification date by SMA"]

{"sheet":"Supplement","index":9,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,1,6],[6,1,6,6],[4,1,4,6],[7,1,7,2],[7,3,7,7]]}
[]
[]
[null,null,"Supplier Name:",{"$f":"IF(Justification!$R$5=\"\",\"\",Justification!$R$5)","v":""}]
[null,null,"Self assesment/ Audit Date:",{"$f":"IF(Justification!$R$7=\"\",\"\",Justification!$R$7)","v":""}]
[]
[]
[null,"Any additional supplier quality system requirements as regards eventual intrinsic specific points (…ex. Quality problems): to be verified onsite"]
[null,"to be completed by auditor",null,"to be completed by the organization"]
[null,"Points arisen","Assessor Notes/Comments","Corrective Action \n(against identified issue)","Person responsible (name / company)","Planned Start Date","Planned Finish Date","Comments / Notes ","% completion","Actual Finish Date","Closure verification date by SMA"]