{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["WI","Summary","Overview Dealers","Questions - Dealer&Distributor","Overview","Questions - Manufacturing","Riepilogo Dealer","Riepilogo","Info and attachments (pdf)"],"not_rendered":{"charts":5,"images":9,"macros":1,"external_links":0,"defined_names":54,"comments":0,"pivot_tables":2},"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":"WI","index":0,"n_rows":96,"n_cols":14,"rows_kept":96,"cut":false,"hidden":false,"merged":[[50,9,74,9],[75,9,99,9],[0,12,0,14],[1,13,1,14],[2,9,2,14],[8,9,12,9],[13,9,35,9],[36,9,49,9]]}
["         ",null,null,null,null,null,null,null,null,null,null,null,"Mod PG 06.02-06"]
["         ",null,null,null,null,null,null,null,null,null,null,null,null,"Rev. 02"]
[null,null,null,null,null,null,null,null,null,"Supplier Onboarding Form"]
["This audit form is meant to have a first self-assesment on supplier's quality system management according to ISO 9001:2015 and to fulfill the Quality part of the onboarding provcedure SP06-01."]
["Please, in order to avoid code errors, download the file and save it on your computer/in a folder."]
["Once you open it, enable macros."]
[]
["Picture",null,null,null,null,null,null,null,null,"Owner","Instruction"]
[null,null,null,null,null,null,null,null,null,"Modine SQA","At the moment of the onboarding or for a 2nd party periodic audit,"]
[null,null,null,null,null,null,null,null,null,null,"Modine SQA picks up the audit form from the Sharepoint and "]
[null,null,null,null,null,null,null,null,null,null,"Renames it As \"Supplier code_Supplier Name_Year_Modine Plant\"."]
[null,null,null,null,null,null,null,null,null,null,"Then he/she opens the form and enables the macros."]
[null,null,null,null,null,null,null,null,null,null,"He/She clicks on \"Summary\" at the bottom left of the workbook."]
[null,null,null,null,null,null,null,null,null,"Modine SQA","He/She chooses the supplier category (manufacturing or dealer&distributor) from the "]
[null,null,null,null,null,null,null,null,null,null,"dropdown list where it's written \"Choose Supplier type."]
[null,null,null,null,null,null,null,null,null,null,"Two worksheets become visible according to the choice made:"]
[null,null,null,null,null,null,null,null,null,null,"Manufacturing: ",null,"\"Questions - Manufacturing\" and \"Overview\""]
[null,null,null,null,null,null,null,null,null,null,"Dealer&Distributor:",null,"\"Questions - Dealer&Distributor\" and \"Overview Dealers\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"He/she Fills up the Region (e.g. EMEA, NA),the Business Unit (e.g. CIS), the plant"]
[null,null,null,null,null,null,null,null,null,null,"(E.g. Modine Torreglia)."]
[null,null,null,null,null,null,null,null,null,null,"He/She fills up the supplier details and the purpose of the visit."]
[null,null,null,null,null,null,null,null,null,null,"Then he saves and sends the audit form to the supplier who has to conduct the self-"]
[null,null,null,null,null,null,null,null,null,null,"assessment"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Supplier","The supplier shall save the file in a folder, open it and enable macros."]
[null,null,null,null,null,null,null,null,null,null,"He/she checks the data in the summary sheet."]
[null,null,null,null,null,null,null,null,null,null,"Then he clicks on the sheet label with the word \"Questions\" in it."]
[null,null,null,null,null,null,null,null,null,null,"He/she shall put an \"X\" in the appropriate cell of the column \"Supplier Self-"]
[null,null,null,null,null,null,null,null,null,null,"Assessment\"."]
[null,null,null,null,null,null,null,null,null,null,"As can be seen, each question has 4 possible outcomes from which to choose:"]
[null,null,null,null,null,null,null,null,null,null,"N/A (Grey) "]
[null,null,null,null,null,null,null,null,null,null,"0 (Red)"]
[null,null,null,null,null,null,null,null,null,null,"1 (Yellow)"]
[null,null,null,null,null,null,null,null,null,null,"2 (Green)"]
[null,null,null,null,null,null,null,null,null,null,"3 (Green)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Supplier","To see the results he must click on the worksheet containing the word  \"Overview\"."]
[null,null,null,null,null,null,null,null,null,null,"The supplier looks at his/her evaluation."]
[null,null,null,null,null,null,null,null,null,null,"The total can be seen at the bottom of the page. On the right he will find his/her"]
[null,null,null,null,null,null,null,null,null,null,"self-assessment chart. He/she saves the form and sends it back to the SQA."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Modine SQA","The SQA download the form as stated in the previous paragraphs. In this case, "]
[null,null,null,null,null,null,null,null,null,null,"the worksheets that regard the category of the supplier are already unhidden."]
[null,null,null,null,null,null,null,null,null,null,"He performs the audit (possibly in place)."]
[null,null,null,null,null,null,null,null,null,null,"He writes down his/her findings and remarks."]
[null,null,null,null,null,null,null,null,null,null,"At the end, he/she checks the score in the \"Overview\" worksheets, where he/she"]
[null,null,null,null,null,null,null,null,null,null,"also compares his indications with the supplier self-assessment."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"The audit criteria are written both at the bottom of the summary sheet and at the "]
[null,null,null,null,null,null,null,null,null,null,"bottom right of the overview sheet. "]
[null,null,null,null,null,null,null,null,null,null,"Pass and fail criteria change according to the supplier category."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"For any issue please contact: manuel.roat@modine.com"]

{"sheet":"Summary","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,2,4,5],[5,8,5,10],[11,8,11,10],[14,6,14,7],[12,6,12,7],[14,2,14,5],[11,6,11,7],[11,2,11,5],[12,8,12,10],[13,8,13,10],[13,6,13,7],[11,0,11,1],[17,2,18,5],[6,0,6,1],[6,2,6,5],[5,2,5,5],[15,0,15,1],[0,8,0,10],[2,5,2,10],[20,2,20,4],[20,7,20,10],[1,9,1,10],[9,0,9,10],[10,0,10,1],[10,6,10,7],[10,8,10,10],[10,2,10,5],[7,9,7,10],[7,7,7,8],[4,7,4,10],[3,8,3,10],[5,0,5,1],[4,0,4,1],[20,0,20,1],[21,7,21,10],[21,0,21,1],[21,2,21,4],[13,2,13,5],[13,0,13,1],[15,6,15,7],[15,8,15,10],[15,2,15,5],[17,0,17,1],[14,0,14,1],[17,6,17,7],[17,8,18,10],[24,0,32,10],[3,0,3,1],[14,8,14,10],[43,3,43,5],[44,3,44,5],[42,3,42,5],[40,4,40,5],[34,0,34,5],[38,4,38,5],[39,4,39,5],[36,3,37,5],[33,0,33,10],[36,6,36,7],[19,0,19,10],[12,2,12,5],[23,0,23,10]]}
["         ",null,null,null,null,null,null,null,"Mod PG 06.02-06"]
["         ",null,null,null,null,null,null,null,null,"Rev. 02"]
[null,null,null,null,null,"Supplier Onboarding Form"]
["Supplier category",null,1,null,null,null,{"$f":"VLOOKUP(C4,Riepilogo!$S$5:$T$7,2,FALSE)","v":"Choose Supplier Type"},null,"According to ISO 9001:2015 "]
["Region",null,null,null,null,null,null,{"$f":"concatenastringhe(G4)","v":""}]
["Business Unit",null,null,null,null,null,{"$f":"VLOOKUP(C7,Riepilogo!$S$11:$T$16,2,FALSE)","v":{"$error":"#N/A"}},"Date"]
["Modine's Plant"]
[]
[]
["Supplier Details"]
["Name",null,null,null,null,null,"Contact Person"]
["Address",null,null,null,null,null,"Position"]
[null,null,null,null,null,null,"Telephone"]
[null,null,null,null,null,null,"e-mail"]
["Telephone",null,null,null,null,null,"Certification"]
["Web site",null,null,null,null,null,"Certification number"]
[]
["Main Products",null,null,null,null,null,"Main Processes"]
[]
[]
["Compiled by",null,null,null,null,null,"Telephone"]
["Position",null,null,null,null,null,"e-mail"]
[]
["Purpose of Visit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Assessment results"]
["Criteria"]
[null,null,null,"Overall rating",null,null,"Assessment"]
[null,null,null,null,null,null,"Yellow","Red"]
[null,null,null,1,"Barred supplier",null,{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!N30,Overview!N32)","v":"More than 14"},{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!P30,Overview!P32)","v":"From 1"},null,null,null," "]
[null,null,null,2,"Controlled supplier",null,{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!N31,Overview!N33)","v":"Max 14"},{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!P31,Overview!P33)","v":"None"}]
[null,null,null,3,"Approved supplier",null,{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!N32,Overview!N34)","v":"Max 7"},{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!P32,Overview!P34)","v":"None"}]
["Results"]
[null,null,null,"Audit results",null,null,"Score [%]","Result"]
[null,null,null,"Supplier's self-assessment ",null,null,{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!D36,Overview!D61)","v":0},{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!F36,Overview!F61)","v":"To do"}]
[null,null,null,"Modine's assessment",null,null,{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!D37,Overview!D62)","v":0},{"$f":"IF($H$5=\"Dealer&Distributor\",'Overview Dealers'!F37,Overview!F62)","v":"To do"}]
["Notes"]

{"sheet":"Overview Dealers","index":2,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":true,"merged":[[30,13,30,14],[31,13,31,14],[1,12,2,12],[1,13,2,16],[3,13,3,16],[27,11,28,12],[27,13,27,15],[28,13,28,14],[29,13,29,14],[34,7,34,8],[35,7,35,8],[36,7,36,8],[28,1,31,1],[1,2,2,2],[1,3,2,9],[3,3,3,9]]}
[null,null,null,null,null,null,null,{"$f":"Summary!I1","v":"Mod PG 06.02-06"},{"$f":"Summary!J2","v":"Rev. 02"},null,null,null,null,null,null,{"$f":"Summary!I1","v":"Mod PG 06.02-06"},{"$f":"Summary!J2","v":"Rev. 02"}]
[null,null,"Dealer&Distributor ",null,null,null,null,null,null,null,null,null,"Dealer&Distributor ",{"$f":"IF(Summary!C11=0,\"\",Summary!C11)","v":""}]
[]
[null,null,"Date",{"$f":"IF(Summary!I6=0,\"\",Summary!I6)","v":""},null,null,null,null,null,null,null,null,"Date",{"$f":"IF(Summary!I6=0,\"\",Summary!I6)","v":""}]
[]
[]
["Nr.","ISO 9001:2015","Element / Topic"]
[null,null,"Quality management system","Supplier Self-assessment",null,"Modine assessment",null,"Findings","Remarks"]
[{"$f":"'Questions - Manufacturing'!$A$13","v":1},{"$f":"'Questions - Manufacturing'!$B$13","v":"8.4.1"},{"$f":"'Questions - Manufacturing'!$C$13","v":"Certification status "},{"$f":"'Riepilogo Dealer'!I2","v":"-"},{"$f":"'Riepilogo Dealer'!H2","v":""},{"$f":"'Riepilogo Dealer'!L2","v":"-"},{"$f":"'Riepilogo Dealer'!K2","v":""},{"$f":"IF('Riepilogo Dealer'!M2=0,\"\",'Riepilogo Dealer'!M2)","v":""},{"$f":"IF('Riepilogo Dealer'!N2=0,\"\",'Riepilogo Dealer'!N2)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$18","v":2},{"$f":"'Questions - Dealer&Distributor'!$B$18","v":"5.3 & 6.2"},{"$f":"'Questions - Manufacturing'!$C$18","v":"organizational Roles, responsibilities and Authorities, Quality Objectives and planning to achieve them"},{"$f":"'Riepilogo Dealer'!I3","v":"-"},{"$f":"'Riepilogo Dealer'!H3","v":""},{"$f":"'Riepilogo Dealer'!L3","v":"-"},{"$f":"'Riepilogo Dealer'!K3","v":""},{"$f":"IF('Riepilogo Dealer'!M3=0,\"\",'Riepilogo Dealer'!M3)","v":""},{"$f":"IF('Riepilogo Dealer'!N3=0,\"\",'Riepilogo Dealer'!N3)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$23","v":3},{"$f":"'Questions - Dealer&Distributor'!$B$23","v":"7.5.3"},{"$f":"'Questions - Manufacturing'!$C$23","v":"Control of documented information"},{"$f":"'Riepilogo Dealer'!I4","v":"-"},{"$f":"'Riepilogo Dealer'!H4","v":""},{"$f":"'Riepilogo Dealer'!L4","v":"-"},{"$f":"'Riepilogo Dealer'!K4","v":""},{"$f":"IF('Riepilogo Dealer'!M4=0,\"\",'Riepilogo Dealer'!M4)","v":""},{"$f":"IF('Riepilogo Dealer'!N4=0,\"\",'Riepilogo Dealer'!N4)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$28","v":4},{"$f":"'Questions - Dealer&Distributor'!$B$28","v":"8.3.4"},{"$f":"'Questions - Manufacturing'!$C$28","v":"Design and development changes"},{"$f":"'Riepilogo Dealer'!I5","v":"-"},{"$f":"'Riepilogo Dealer'!H5","v":""},{"$f":"'Riepilogo Dealer'!L5","v":"-"},{"$f":"'Riepilogo Dealer'!K5","v":""},{"$f":"IF('Riepilogo Dealer'!M5=0,\"\",'Riepilogo Dealer'!M5)","v":""},{"$f":"IF('Riepilogo Dealer'!N5=0,\"\",'Riepilogo Dealer'!N5)","v":""}]
[null,null,"Total quality management system",{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$8,'Riepilogo Dealer'!H:H,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C8,'Riepilogo Dealer'!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$8,'Riepilogo Dealer'!K:K,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C8,'Riepilogo Dealer'!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Contract review process"]
[{"$f":"'Questions - Dealer&Distributor'!A34","v":5},{"$f":"'Questions - Dealer&Distributor'!B34","v":"8.2.1"},{"$f":"'Questions - Dealer&Distributor'!C34","v":"Requirements for Products & services"},{"$f":"'Riepilogo Dealer'!I6","v":"-"},{"$f":"'Riepilogo Dealer'!H6","v":""},{"$f":"'Riepilogo Dealer'!L6","v":"-"},{"$f":"'Riepilogo Dealer'!K6","v":""},{"$f":"IF('Riepilogo Dealer'!M6=0,\"\",'Riepilogo Dealer'!M6)","v":""},{"$f":"IF('Riepilogo Dealer'!N6=0,\"\",'Riepilogo Dealer'!N6)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A39","v":6},{"$f":"'Questions - Dealer&Distributor'!B39","v":"8.3.4"},{"$f":"'Questions - Dealer&Distributor'!C39","v":"Design and development controls"},{"$f":"'Riepilogo Dealer'!I7","v":"-"},{"$f":"'Riepilogo Dealer'!H7","v":""},{"$f":"'Riepilogo Dealer'!L7","v":"-"},{"$f":"'Riepilogo Dealer'!K7","v":""},{"$f":"IF('Riepilogo Dealer'!M7=0,\"\",'Riepilogo Dealer'!M7)","v":""},{"$f":"IF('Riepilogo Dealer'!N7=0,\"\",'Riepilogo Dealer'!N7)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A44","v":7},{"$f":"'Questions - Dealer&Distributor'!B44","v":"8.5.4 & 8.5.5"},{"$f":"'Questions - Dealer&Distributor'!C44","v":"Preservation"},{"$f":"'Riepilogo Dealer'!I8","v":"-"},{"$f":"'Riepilogo Dealer'!H8","v":""},{"$f":"'Riepilogo Dealer'!L8","v":"-"},{"$f":"'Riepilogo Dealer'!K8","v":""},{"$f":"IF('Riepilogo Dealer'!M8=0,\"\",'Riepilogo Dealer'!M8)","v":""},{"$f":"IF('Riepilogo Dealer'!N8=0,\"\",'Riepilogo Dealer'!N8)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A49","v":8},{"$f":"'Questions - Dealer&Distributor'!B49","v":"8.6"},{"$f":"'Questions - Dealer&Distributor'!C49","v":"Release of Products & services"},{"$f":"'Riepilogo Dealer'!I9","v":"-"},{"$f":"'Riepilogo Dealer'!H9","v":""},{"$f":"'Riepilogo Dealer'!L9","v":"-"},{"$f":"'Riepilogo Dealer'!K9","v":""},{"$f":"IF('Riepilogo Dealer'!M9=0,\"\",'Riepilogo Dealer'!M9)","v":""},{"$f":"IF('Riepilogo Dealer'!N9=0,\"\",'Riepilogo Dealer'!N9)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A54","v":9},{"$f":"'Questions - Dealer&Distributor'!B54","v":"8.5.6"},{"$f":"'Questions - Dealer&Distributor'!C54","v":"Release of Products & services"},{"$f":"'Riepilogo Dealer'!I10","v":"-"},{"$f":"'Riepilogo Dealer'!H10","v":""},{"$f":"'Riepilogo Dealer'!L10","v":"-"},{"$f":"'Riepilogo Dealer'!K10","v":""},{"$f":"IF('Riepilogo Dealer'!M10=0,\"\",'Riepilogo Dealer'!M10)","v":""},{"$f":"IF('Riepilogo Dealer'!N10=0,\"\",'Riepilogo Dealer'!N10)","v":""}]
[null,null,"Total Design & Development for product and process",{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$14,'Riepilogo Dealer'!H:H,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C14,'Riepilogo Dealer'!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$14,'Riepilogo Dealer'!K:K,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C14,'Riepilogo Dealer'!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Supplier Management & Quality"]
[{"$f":"'Questions - Dealer&Distributor'!A60","v":10},{"$f":"'Questions - Dealer&Distributor'!B60","v":"8.6"},{"$f":"'Questions - Dealer&Distributor'!C60","v":"Release of Products & services"},{"$f":"'Riepilogo Dealer'!I11","v":"-"},{"$f":"'Riepilogo Dealer'!H11","v":""},{"$f":"'Riepilogo Dealer'!L11","v":"-"},{"$f":"'Riepilogo Dealer'!K11","v":""},{"$f":"IF('Riepilogo Dealer'!M11=0,\"\",'Riepilogo Dealer'!M11)","v":""},{"$f":"IF('Riepilogo Dealer'!N11=0,\"\",'Riepilogo Dealer'!N11)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A65","v":11},{"$f":"'Questions - Dealer&Distributor'!B65","v":"8.5.6"},{"$f":"'Questions - Dealer&Distributor'!C65","v":"Release of Products & services"},{"$f":"'Riepilogo Dealer'!I12","v":"-"},{"$f":"'Riepilogo Dealer'!H12","v":""},{"$f":"'Riepilogo Dealer'!L12","v":"-"},{"$f":"'Riepilogo Dealer'!K12","v":""},{"$f":"IF('Riepilogo Dealer'!M12=0,\"\",'Riepilogo Dealer'!M12)","v":""},{"$f":"IF('Riepilogo Dealer'!N12=0,\"\",'Riepilogo Dealer'!N12)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A70","v":12},{"$f":"'Questions - Dealer&Distributor'!B70","v":"8.4.1"},{"$f":"'Questions - Dealer&Distributor'!C70","v":"Control of externally provided Processes, Products and Services"},{"$f":"'Riepilogo Dealer'!I13","v":"-"},{"$f":"'Riepilogo Dealer'!H13","v":""},{"$f":"'Riepilogo Dealer'!L13","v":"-"},{"$f":"'Riepilogo Dealer'!K13","v":""},{"$f":"IF('Riepilogo Dealer'!M13=0,\"\",'Riepilogo Dealer'!M13)","v":""},{"$f":"IF('Riepilogo Dealer'!N13=0,\"\",'Riepilogo Dealer'!N13)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A75","v":13},{"$f":"'Questions - Dealer&Distributor'!B75","v":"8.4.2"},{"$f":"'Questions - Dealer&Distributor'!C75","v":"Verification of purchased product"},{"$f":"'Riepilogo Dealer'!I14","v":"-"},{"$f":"'Riepilogo Dealer'!H14","v":""},{"$f":"'Riepilogo Dealer'!L14","v":"-"},{"$f":"'Riepilogo Dealer'!K14","v":""},{"$f":"IF('Riepilogo Dealer'!M14=0,\"\",'Riepilogo Dealer'!M14)","v":""},{"$f":"IF('Riepilogo Dealer'!N14=0,\"\",'Riepilogo Dealer'!N14)","v":""}]
[{"$f":"'Questions - Dealer&Distributor'!A80","v":14},{"$f":"'Questions - Dealer&Distributor'!B80","v":"10.2"},{"$f":"'Questions - Dealer&Distributor'!C80","v":"Preventive and corrective actions"},{"$f":"'Riepilogo Dealer'!I15","v":"-"},{"$f":"'Riepilogo Dealer'!H15","v":""},{"$f":"'Riepilogo Dealer'!L15","v":"-"},{"$f":"'Riepilogo Dealer'!K15","v":""},{"$f":"IF('Riepilogo Dealer'!M15=0,\"\",'Riepilogo Dealer'!M15)","v":""},{"$f":"IF('Riepilogo Dealer'!N15=0,\"\",'Riepilogo Dealer'!N15)","v":""}]
[null,null,"Total Production",{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$21,'Riepilogo Dealer'!H:H,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C21,'Riepilogo Dealer'!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$21,'Riepilogo Dealer'!K:K,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C21,'Riepilogo Dealer'!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Material planning & Logistics",null,null,null,null,null,null,null,null,"Overall rating",null,"Assessment"]
[{"$f":"'Questions - Dealer&Distributor'!A86","v":15},{"$f":"'Questions - Dealer&Distributor'!B86","v":"8.5.1"},{"$f":"'Questions - Dealer&Distributor'!C86","v":"Inhouse Order Process"},{"$f":"'Riepilogo Dealer'!I16","v":"-"},{"$f":"'Riepilogo Dealer'!H16","v":""},{"$f":"'Riepilogo Dealer'!L16","v":"-"},{"$f":"'Riepilogo Dealer'!K16","v":""},{"$f":"IF('Riepilogo Dealer'!M16=0,\"\",'Riepilogo Dealer'!M16)","v":""},{"$f":"IF('Riepilogo Dealer'!N16=0,\"\",'Riepilogo Dealer'!N16)","v":""},null,null,null,null,"Yellow",null,"Red"]
[{"$f":"'Questions - Dealer&Distributor'!A91","v":16},null,{"$f":"'Questions - Dealer&Distributor'!C91","v":"Lead Time"},{"$f":"'Riepilogo Dealer'!I17","v":"-"},{"$f":"'Riepilogo Dealer'!H17","v":""},{"$f":"'Riepilogo Dealer'!L17","v":"-"},{"$f":"'Riepilogo Dealer'!K17","v":""},{"$f":"IF('Riepilogo Dealer'!M17=0,\"\",'Riepilogo Dealer'!M17)","v":""},{"$f":"IF('Riepilogo Dealer'!N17=0,\"\",'Riepilogo Dealer'!N17)","v":""},null,null,1,"Barred supplier","More than 7",null,"From 1"]
[{"$f":"'Questions - Dealer&Distributor'!A96","v":17},null,{"$f":"'Questions - Dealer&Distributor'!C96","v":"Supply Chain\nEfficiency"},{"$f":"'Riepilogo Dealer'!I18","v":"-"},{"$f":"'Riepilogo Dealer'!H18","v":""},{"$f":"'Riepilogo Dealer'!L18","v":"-"},{"$f":"'Riepilogo Dealer'!K18","v":""},{"$f":"IF('Riepilogo Dealer'!M18=0,\"\",'Riepilogo Dealer'!M18)","v":""},{"$f":"IF('Riepilogo Dealer'!N18=0,\"\",'Riepilogo Dealer'!N18)","v":""},null,null,2,"Controlled supplier","Max 7",null,"None"]
[{"$f":"'Questions - Dealer&Distributor'!A101","v":18},null,{"$f":"'Questions - Dealer&Distributor'!C101","v":"Supply Chain\nEfficiency"},{"$f":"'Riepilogo Dealer'!I19","v":"-"},{"$f":"'Riepilogo Dealer'!H19","v":""},{"$f":"'Riepilogo Dealer'!L19","v":"-"},{"$f":"'Riepilogo Dealer'!K19","v":""},{"$f":"IF('Riepilogo Dealer'!M19=0,\"\",'Riepilogo Dealer'!M19)","v":""},{"$f":"IF('Riepilogo Dealer'!N19=0,\"\",'Riepilogo Dealer'!N19)","v":""},null,null,3,"Approved supplier","Max 4",null,"None"]
[null,null,"Total Production Control & Logistics",{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$28,'Riepilogo Dealer'!H:H,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C28,'Riepilogo Dealer'!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS('Riepilogo Dealer'!H:H,'Riepilogo Dealer'!A:A,\"=\"&'Overview Dealers'!$C$28,'Riepilogo Dealer'!K:K,\">=\"&0)/(3*COUNTIFS('Riepilogo Dealer'!A:A,'Overview Dealers'!C28,'Riepilogo Dealer'!K:K,\">=\"&0)),0)","v":0}]
[]
[null,null,"Total","Score [%]",null,"Result",null,"Warning for NA answers number >= 3"]
[null,null,"Supplier's self-assessment",{"$f":"(SUMIF('Riepilogo Dealer'!H2:H42,\">=\"&0,'Riepilogo Dealer'!H2:H42)/(3*COUNTIF('Riepilogo Dealer'!B2:B42,\">=\"&0)))","v":0},null,{"$f":"DRossoGialloVerde('Riepilogo Dealer'!H:H)","v":"To do"},null,{"$f":"IF(nacount('Riepilogo Dealer'!H:H)=\"\",\"Score can be computed\",\"Score should be computed due to the fact that more than 3 answers are NA\")","v":"Score can be computed"}]
[null,null,"Modine's assessment",{"$f":"(SUMIF('Riepilogo Dealer'!K2:K42,\">=\"&0,'Riepilogo Dealer'!K2:K42)/(3*COUNTIF('Riepilogo Dealer'!B2:B42,\">=\"&0)))","v":0},null,{"$f":"DRossoGialloVerde('Riepilogo Dealer'!K:K)","v":"To do"},null,{"$f":"IF(nacount('Riepilogo Dealer'!K:K)=\"\",\"Score can be computed\",\"Score should not be computed due to the fact that more than 3 answers are NA\")","v":"Score can be computed"}]

{"sheet":"Questions - Dealer&Distributor","index":3,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":true,"merged":[[65,9,68,9],[60,9,63,9],[54,9,57,9],[49,9,52,9],[44,9,47,9],[101,9,104,9],[96,9,99,9],[91,9,94,9],[86,9,89,9],[80,9,83,9],[1,3,2,3],[1,4,2,10],[59,0,63,0],[59,1,63,1],[59,2,63,2],[60,10,63,10],[48,0,52,0],[48,1,52,1],[48,2,52,2],[49,10,52,10],[53,0,57,0],[53,1,57,1],[53,2,57,2],[54,10,57,10],[43,0,47,0],[43,1,47,1],[64,0,68,0],[64,1,68,1],[64,2,68,2],[65,10,68,10],[100,0,104,0],[100,2,104,2],[101,10,104,10],[85,1,104,1],[85,0,89,0],[85,2,89,2],[86,10,89,10],[90,0,94,0],[90,2,94,2],[91,10,94,10],[95,0,99,0],[95,2,99,2],[96,10,99,10],[79,0,83,0],[79,1,83,1],[79,2,83,2],[80,10,83,10],[69,0,73,0],[69,1,73,1],[69,2,73,2],[70,10,73,10],[74,0,78,0],[74,1,78,1],[74,2,78,2],[75,10,78,10],[75,9,78,9],[70,9,73,9],[43,2,47,2],[44,10,47,10],[38,0,42,0],[38,1,42,1],[38,2,42,2],[39,10,42,10],[39,9,42,9],[22,0,26,0],[22,1,26,1],[22,2,26,2],[23,10,26,10],[33,0,37,0],[33,1,37,1],[33,2,37,2],[34,10,37,10],[27,0,31,0],[27,1,31,1],[27,2,31,2],[28,10,31,10],[34,9,37,9],[28,9,31,9],[23,9,26,9],[17,0,21,0],[17,1,21,1],[17,2,21,2],[18,10,21,10],[18,9,21,9],[6,0,9,10],[12,0,16,0],[12,1,16,1],[12,2,16,2],[13,10,16,10],[13,9,16,9]]}
[]
[null,null,null,"Dealer&Distributor ",{"$f":"IF(Summary!C11=0,\"\",Summary!C11)","v":""}]
[]
[]
[null,null,null,"Date",null,null,null,null,null,null,{"$f":"IF(Summary!I6=0,\"\",Summary!I6)","v":""}]
[]
["WARNING: In case the Supplier is one in the dedicated Vendor List of Customers that require additional requirements to the ISO 9001 standard and or requires that the tier two supplier are deployed of such requirements,, the list of the additional requirements has to be attached to this check list (info and attachments - pdf) and all the questions has to be interpreted and evaluated taking in consideration all the additional requirements. The outcome of the Audit shall clearly identify the correspondence to those additional  requirement"]
[]
[]
[]
["Nr.","ISO9001:2015",null,"Question",null,"Supplier Self-assessment",null,"Modine assessment",null,"Findings","Remarks"]
[null,null,null,"Quality management system"]
[1,"8.4.1","Certification status ","Certification status of the Quality Management System?","N/A",null,{"$f":"IF(F13&F14&F15&F16&F17=\"\",\"\",IF(F13=\"x\",$E$13,SUM(G14:G17)))","v":""},null,{"$f":"IF(H13&H14&H15&H16&H17=\"\",\"\",IF(H13=\"x\",$E$13,SUM(I14:I17)))","v":""},null,{"$f":"fillthegap(F13,H13,F14:F17,H14:H17)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No certification to an international standard",null,null,{"$f":"IF(F14<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H14<>\"x\",\"\",0)","v":""}]
[null,null,null,"Other certification",null,null,{"$f":"IF(F15<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H15<>\"x\",\"\",1)","v":""}]
[null,null,null,"Certified according ISO 9001: 2015",null,null,{"$f":"IF(F16<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H16<>\"x\",\"\",2)","v":""}]
[null,null,null,"Certified according ISO 9001:2015 and ISO 14001:2015",null,null,{"$f":"IF(F17<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H17<>\"x\",\"\",3)","v":""}]
[{"$f":"A13+1","v":2},"5.3 & 6.2","Organizational Roles, responsibilities and Authorities, Quality Objectives and planning to achieve them","Have process oriented procedures been established, including required procedures which define quality related actions, responsibilities, deliverables and objectives?","N/A",null,{"$f":"IF(F18&F19&F20&F21&F22=\"\",\"\",IF(F18=\"x\",$E$18,SUM(G19:G22)))","v":""},null,{"$f":"IF(H18&H19&H20&H21&H22=\"\",\"\",IF(H18=\"x\",$E$18,SUM(I19:I22)))","v":""},null,{"$f":"fillthegap(F18,H18,F19:F22,H19:H22)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no clear definition of company process, quality assurance activities or responsibilities within the organization.",null,null,{"$f":"IF(F19<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H19<>\"x\",\"\",0)","v":""}]
[null,null,null,"The company processes, quality assurance activities and responsibilities, including process ownership,  are minimally defined. Process orientation with gaps.",null,null,{"$f":"IF(F20<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H20<>\"x\",\"\",1)","v":""}]
[null,null,null,"The company processes, quality assurance activities and responsibilities, including process ownership, are reasonably well defined, including reporting requirements and deliverables  for customer oriented processes. Procedures and Q-indicators are not all known.",null,null,{"$f":"IF(F21<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H21<>\"x\",\"\",2)","v":""}]
[null,null,null,"Quality assurance activities and responsibilities, including process ownership, are thoroughly defined with reporting requirements clearly indicated. Good awareness and proper execution of the personal regarding their responsibility and Q-indicators (deliverables). Adequate procedures are available, well defined and trained.",null,null,{"$f":"IF(F22<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H22<>\"x\",\"\",3)","v":""}]
[{"$f":"A18+1","v":3},"7.5.3","Control of documented information","Are records (quality, process etc.) kept and retained according to legal and customer requirements?","N/A",null,{"$f":"IF(F23&F24&F25&F26&F27=\"\",\"\",IF(F23=\"x\",$E$23,SUM(G24:G27)))","v":""},null,{"$f":"IF(H23&H24&H25&H26&H27=\"\",\"\",IF(H23=\"x\",$E$23,SUM(I24:I27)))","v":""},null,{"$f":"fillthegap(F23,H23,F24:F27,H24:H27)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no documented procedure in which way and how long quality and other relevant records are retained.",null,null,{"$f":"IF(F24<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H24<>\"x\",\"\",0)","v":""}]
[null,null,null,"There is a documented procedure identifying records to be retained. The procedure however does not identify all documents and is not considering all customer or legal requirements (critical characteristics).",null,null,{"$f":"IF(F25<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H25<>\"x\",\"\",1)","v":""}]
[null,null,null,"A documented procedure is identifying the process for storage and final disposal of records considering customer/ legal requirements including all computer data. Records are stored in orderly conditions and can easily be retrieved. ",null,null,{"$f":"IF(F26<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H26<>\"x\",\"\",2)","v":""}]
[null,null,null,"As before, records including electronic data are protected to prevent damage or deterioration. (i.e. safe, different building, etc.)",null,null,{"$f":"IF(F27<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H27<>\"x\",\"\",3)","v":""}]
[{"$f":"A23+1","v":4},"8.3.4","Design and Development controls","How is the distribution of drawings, specifications and associated documents controlled and expedited to assure the use of current information?","N/A",null,{"$f":"IF(F28&F29&F30&F31&F32=\"\",\"\",IF(F28=\"x\",$E$28,SUM(G29:G32)))","v":""},null,{"$f":"IF(H28&H29&H30&H31&H32=\"\",\"\",IF(H28=\"x\",$E$28,SUM(I29:I32)))","v":""},null,{"$f":"fillthegap(F28,H28,F29:F32,H29:H32)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No defined system at all.",null,null,{"$f":"IF(F29<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H29<>\"x\",\"\",0)","v":""}]
[null,null,null,"An acceptable system is in place, but there are relevant department/groups where the actual information (internal or external) is not in use. There is little knowledge of the procedure by the involved departments. A timely review of changed customer requirements is not tracked.",null,null,{"$f":"IF(F30<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H30<>\"x\",\"\",1)","v":""}]
[null,null,null,"An effective system for drawing, documents and specification control is documented and followed. Changes of customer requirements are tracked, but are not all completed in the defined timeframe. Most of involved personnel are aware of the process. There is no evidence of obsolete/ uncontrolled documents in use.",null,null,{"$f":"IF(F31<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H31<>\"x\",\"\",2)","v":""}]
[null,null,null,"All relevant drawings, documents and specifications are current, with an established system to sustain that status; All affected personnel is aware of the document control procedure. Changes are realized in the defined timeframe.",null,null,{"$f":"IF(F32<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H32<>\"x\",\"\",3)","v":""}]
[null,null,null,"Contract review process"]
[{"$f":"A28+1","v":5},"8.2.1","Requirements for Products & services","Is there a documented process to identify and coordinate the contract review activities prior to the submission of a tender or the acceptance of a contract?","N/A",null,{"$f":"IF(F34&F35&F36&F37&F38=\"\",\"\",IF(F34=\"x\",$E$34,SUM(G35:G38)))","v":""},null,{"$f":"IF(H34&H35&H36&H37&H38=\"\",\"\",IF(H34=\"x\",$E$34,SUM(I35:I38)))","v":""},null,{"$f":"fillthegap(F34,H34,F35:F38,H35:H38)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no documented process/ system to perform contract review activities prior to the submission of a tender or the acceptance of a contact. The process is mostly verbal in nature.",null,null,{"$f":"IF(F35<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H35<>\"x\",\"\",0)","v":""}]
[null,null,null,"A documented system for contract review activities is available; The activities are performed for some products and programs. ",null,null,{"$f":"IF(F36<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H36<>\"x\",\"\",1)","v":""}]
[null,null,null,"An adequate system to identify contract review activities is available, not all contracts are reviewed in cross-functional teams. Most evidence is conclusive and is documented in Feasibility Commitments signed by the team. ",null,null,{"$f":"IF(F37<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H37<>\"x\",\"\",2)","v":""}]
[null,null,null,"Contract review activities thoroughly defined (including handling of verbal orders and contract amendments) and performed in a cross-functional team. The documentation is conclusive. A checklist to perform the contract review activities is available. A team sign-off to meet the contractual requirements (Feasibility Commitment) is part of the system.",null,null,{"$f":"IF(F38<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H38<>\"x\",\"\",3)","v":""}]
[{"$f":"A34+1","v":6},"8.3.4","Design and development controls","Is there a documented Project Management process with regular cross-functional reviews established?","N/A",null,{"$f":"IF(F39&F40&F41&F42&F43=\"\",\"\",IF(F39=\"x\",$E$39,SUM(G40:G43)))","v":""},null,{"$f":"IF(H39&H40&H41&H42&H43=\"\",\"\",IF(H39=\"x\",$E$39,SUM(I40:I43)))","v":""},null,{"$f":"fillthegap(F39,H39,F40:F43,H40:H43)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There no conclusive Project Management process established. Project plans are mainly customer generated. Teams are not set up as cross-functional teams. No documented reviews.",null,null,{"$f":"IF(F40<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H40<>\"x\",\"\",0)","v":""}]
[null,null,null,"A Project Mgt. process is established incl. responsibilities. The process however is not completely implemented for all projects and changes. Project reviews are not in all cases properly documented (Due Dates/ Responsibility) including a clear project status and take place on an as needed basis.",null,null,{"$f":"IF(F41<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H41<>\"x\",\"\",1)","v":""}]
[null,null,null,"A Project Mgt. process is established incl. responsibilities. For all projects an updated project plan with milestones is available. Project reviews take place and are properly documented (Due Dates/ Responsibility). However not all actions are completed on time. ",null,null,{"$f":"IF(F42<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H42<>\"x\",\"\",2)","v":""}]
[null,null,null,"A conclusive Project Mgt. process with clear responsibilities is established. Regular status/ review meetings take place internally and also pro-actively with the customer. For all projects an updated project plans with milestones are available. Project reviews take place and are properly documented (Due Dates/ Responsible, etc).",null,null,{"$f":"IF(F43<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H43<>\"x\",\"\",3)","v":""}]
[{"$f":"A39+1","v":7},"8.5.4 & 8.5.5","Preservation","Is a comprehensive logistic concept including the component specific requirements determined during the development/implementation process?","N/A",null,{"$f":"IF(F44&F45&F46&F47&F48=\"\",\"\",IF(F44=\"x\",$E$44,SUM(G45:G48)))","v":""},null,{"$f":"IF(H44&H45&H46&H47&H48=\"\",\"\",IF(H44=\"x\",$E$44,SUM(I45:I48)))","v":""},null,{"$f":"fillthegap(F44,H44,F45:F48,H45:H48)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"The logistic requirements are not part of the advanced product quality process and are usually determined close to the initial sample release, if requested by the customer.",null,null,{"$f":"IF(F45<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H45<>\"x\",\"\",0)","v":""}]
[null,null,null,"Logistic requirements are not determined for all products as part of the advanced product quality process. They include mainly the capacity requirements of serial production and the comparison with the customer demand.",null,null,{"$f":"IF(F46<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H46<>\"x\",\"\",1)","v":""}]
[null,null,null,"A logistic concept is part of the advanced product quality process and considers beside serial production requirements also the sample production. The logistic concept includes packaging, labelling, transportation requirements. Traceability requirements are considered based on customer demand.",null,null,{"$f":"IF(F47<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H47<>\"x\",\"\",2)","v":""}]
[null,null,null,"The logistic concept considers serial production and sample requirements. It includes packaging, labelling, transportation requirements etc. Traceability requirements are considered for all products and harmonized with the customer demands. Packaging is being tested before being released.",null,null,{"$f":"IF(F48<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H48<>\"x\",\"\",3)","v":""}]
[{"$f":"A44+1","v":8},"8.6","Release of Products & services","Are initial samples and documentation prepared in accordance with the customer Requirements?","N/A",null,{"$f":"IF(F49&F50&F51&F52&F53=\"\",\"\",IF(F49=\"x\",$E$13,SUM(G50:G53)))","v":""},null,{"$f":"IF(H49&H50&H51&H52&H53=\"\",\"\",IF(H49=\"x\",$E$13,SUM(I50:I53)))","v":""},null,{"$f":"fillthegap(F49,H49,F50:F53,H50:H53)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Majority of Initial Samples submitted have major deficiencies and are rejected; Only little knowledge of PPAP requirements",null,null,{"$f":"IF(F50<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H50<>\"x\",\"\",0)","v":""}]
[null,null,null,"Majority of PPAP are approved but require one or more deviations.",null,null,{"$f":"IF(F51<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H51<>\"x\",\"\",1)","v":""}]
[null,null,null,"Most PPAP are fully approved, few require a deviation; Re-qualification is adequate. ",null,null,{"$f":"IF(F52<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H52<>\"x\",\"\",2)","v":""}]
[null,null,null,"Complete supporting data is available for each initial sample reviewed. There is documented evidence that a comprehensive PPAP program and re-qualification is followed for all customers. PPAP are submitted on-time",null,null,{"$f":"IF(F53<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H53<>\"x\",\"\",3)","v":""}]
[{"$f":"A49+1","v":9},"8.5.6","Release of Products & services","Are change management notified in accordance with the customer Requirements?","N/A",null,{"$f":"IF(F54&F55&F56&F57&F58=\"\",\"\",IF(F54=\"x\",$E$54,SUM(G55:G58)))","v":""},null,{"$f":"IF(H54&H55&H56&H57&H58=\"\",\"\",IF(H54=\"x\",$E$54,SUM(I55:I58)))","v":""},null,{"$f":"fillthegap(F54,H54,F55:F58,H55:H58)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Majority of Initial Samples submitted have major deficiencies and are rejected; Only little knowledge of PPAP requirements",null,null,{"$f":"IF(F55<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H55<>\"x\",\"\",0)","v":""}]
[null,null,null,"Majority of PPAP are approved but require one or more deviations.",null,null,{"$f":"IF(F56<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H56<>\"x\",\"\",1)","v":""}]
[null,null,null,"Most PPAP are fully approved, few require a deviation; Re-qualification is adequate. ",null,null,{"$f":"IF(F57<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H57<>\"x\",\"\",2)","v":""}]
[null,null,null,"Complete supporting data is available for each initial sample reviewed. There is documented evidence that a comprehensive PPAP program and re-qualification is followed for all customers. PPAP are submitted on-time",null,null,{"$f":"IF(F58<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H58<>\"x\",\"\",3)","v":""}]
[null,null,null,"Supplier management and quality"]
[{"$f":"A54+1","v":10},"8.6","Release of Products & services","Are initial samples and documentation prepared in accordance with the customer Requirements?","N/A",null,{"$f":"IF(F60&F61&F62&F63&F64=\"\",\"\",IF(F60=\"x\",$E$60,SUM(G61:G64)))","v":""},null,{"$f":"IF(H60&H61&H62&H63&H64=\"\",\"\",IF(H60=\"x\",$E$60,SUM(I61:I64)))","v":""},null,{"$f":"fillthegap(F60,H60,F61:F64,H61:H64)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Majority of Initial Samples submitted have major deficiencies and are rejected; Only little knowledge of PPAP requirements",null,null,{"$f":"IF(F61<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H61<>\"x\",\"\",0)","v":""}]
[null,null,null,"Majority of PPAP are approved but require one or more deviations.",null,null,{"$f":"IF(F62<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H62<>\"x\",\"\",1)","v":""}]
[null,null,null,"Most PPAP are fully approved, few require a deviation; Re-qualification is adequate. ",null,null,{"$f":"IF(F63<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H63<>\"x\",\"\",2)","v":""}]
[null,null,null,"Complete supporting data is available for each initial sample reviewed. There is documented evidence that a comprehensive PPAP program and re-qualification is followed for all customers. PPAP are submitted on-time",null,null,{"$f":"IF(F64<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H64<>\"x\",\"\",3)","v":""}]
[{"$f":"A60+1","v":11},"8.5.6","Release of Products & services","Is change management notified in accordance with the customer Requirements?","N/A",null,{"$f":"IF(F65&F66&F67&F68&F69=\"\",\"\",IF(F65=\"x\",$E$65,SUM(G66:G69)))","v":""},null,{"$f":"IF(H65&H66&H67&H68&H69=\"\",\"\",IF(H65=\"x\",$E$65,SUM(I66:I69)))","v":""},null,{"$f":"fillthegap(F65,H65,F66:F69,H66:H69)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Majority of Initial Samples submitted have major deficiencies and are rejected; Only little knowledge of PPAP requirements",null,null,{"$f":"IF(F66<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H66<>\"x\",\"\",0)","v":""}]
[null,null,null,"Majority of PPAP are approved but require one or more deviations.",null,null,{"$f":"IF(F67<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H67<>\"x\",\"\",1)","v":""}]
[null,null,null,"Most PPAP are fully approved, few require a deviation; Re-qualification is adequate. ",null,null,{"$f":"IF(F68<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H68<>\"x\",\"\",2)","v":""}]
[null,null,null,"Complete supporting data is available for each initial sample reviewed. There is documented evidence that a comprehensive PPAP program and re-qualification is followed for all customers. PPAP are submitted on-time",null,null,{"$f":"IF(F69<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H69<>\"x\",\"\",3)","v":""}]
[{"$f":"A65+1","v":12},"8.4.1","Control of externally provided Processes, Products and Services","Are suppliers and subcontractors selected by the use of a standardized evaluation method?","N/A",null,{"$f":"IF(F70&F71&F72&F73&F74=\"\",\"\",IF(F70=\"x\",$E$70,SUM(G71:G74)))","v":""},null,{"$f":"IF(H70&H71&H72&H73&H74=\"\",\"\",IF(H70=\"x\",$E$70,SUM(I71:I74)))","v":""},null,{"$f":"fillthegap(F70,H70,F71:F74,H71:H74)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No evidence of a standardized evaluation of sub-contractors",null,null,{"$f":"IF(F71<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H71<>\"x\",\"\",0)","v":""}]
[null,null,null,"Specific requirements for sub-suppliers have been established and are communicated. An on-site evaluation is conducted by the supplier's organization for critical suppliers. Most sourcing decisions, however, consider only commercial requirements.",null,null,{"$f":"IF(F72<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H72<>\"x\",\"\",1)","v":""}]
[null,null,null,"The initial sub-supplier evaluation is thorough. It is used to analyze the capability  of potential suppliers/sub-contractors, regarding quality, technical and commercial aspects. All aspects are considered in the sourcing decision.",null,null,{"$f":"IF(F73<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H73<>\"x\",\"\",2)","v":""}]
[null,null,null,"The initial sub-supplier evaluation is thorough and takes care of quality, technical and commercial aspects. All aspects are considered in the sourcing decision. For critical suppliers a specific development program is determined with scheduled follow up meetings",null,null,{"$f":"IF(F74<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H74<>\"x\",\"\",3)","v":""}]
[{"$f":"A70+1","v":13},"8.4.2","Verification of purchased product","How is the performance of sub-suppliers monitored and ensured in serial production including the respective complaint handling?","N/A",null,{"$f":"IF(F75&F76&F77&F78&F79=\"\",\"\",IF(F75=\"x\",$E$75,SUM(G76:G79)))","v":""},null,{"$f":"IF(H75&H76&H77&H78&H79=\"\",\"\",IF(H75=\"x\",$E$75,SUM(I76:I79)))","v":""},null,{"$f":"fillthegap(F75,H75,F76:F79,H76:H79)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"The performance of sub-suppliers is not monitored. Complaint handling is not working.",null,null,{"$f":"IF(F76<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H76<>\"x\",\"\",0)","v":""}]
[null,null,null,"Sub-suppliers are evaluated occasionally, mainly driven through actual problems with the suppliers.",null,null,{"$f":"IF(F77<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H77<>\"x\",\"\",1)","v":""}]
[null,null,null,"There is a basic supplier evaluation system counting supplier incidents/ ppm. The system however is not utilized to evaluate trends/ improvements. Complaints to sub-suppliers are communicated in writing, however only occasionally corrective actions are requested and usually they are not followed up.",null,null,{"$f":"IF(F78<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H78<>\"x\",\"\",2)","v":""}]
[null,null,null,"There supplier evaluation system considering logistics/ quality key indicators. The system is utilized to determine continuous improvement activities and serves as direct input for further sourcing decisions. Each complaint to sub-suppliers requires a written response in form of an 8D. Responses are tracked and analyzed",null,null,{"$f":"IF(F79<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H79<>\"x\",\"\",3)","v":""}]
[{"$f":"A75+1","v":14},"10.2","Preventive and corrective actions","What are the suppliers' formalized problem solving techniques to resolve both internally and externally identified problems?","N/A",null,{"$f":"IF(F80&F81&F82&F83&F84=\"\",\"\",IF(F80=\"x\",$E$80,SUM(G81:G84)))","v":""},null,{"$f":"IF(H80&H81&H82&H83&H84=\"\",\"\",IF(H80=\"x\",$E$80,SUM(I81:I84)))","v":""},null,{"$f":"fillthegap(F80,H80,F81:F84,H81:H84)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Problem solving activities are poorly documented by the supplier; quality concern communication is mostly verbal.",null,null,{"$f":"IF(F81<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H81<>\"x\",\"\",0)","v":""}]
[null,null,null,"Problem solving practices are partly successful in defining root causes, but corrective actions are not usually sufficient; A satisfactory quality concern communication system exists, but is not fully utilized.",null,null,{"$f":"IF(F82<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H82<>\"x\",\"\",1)","v":""}]
[null,null,null,"Problem solving practices are successful in defining root causes and corrective actions are sufficient; A satisfactory quality concern communication system exists and is fully utilized; The verification of the effectiveness of counter measures is not fully performed.",null,null,{"$f":"IF(F83<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H83<>\"x\",\"\",2)","v":""}]
[null,null,null,"Problem solving is working well; Effectiveness of measures are followed; Technical capabilities to analyze internal and external problems is demonstrated; Lessons learned activity properly applied.  Quality documentation updated as appropriate based on corrective actions taken (FMEA/control plan/WI, etc.)",null,null,{"$f":"IF(F84<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H84<>\"x\",\"\",3)","v":""}]
[null,null,null,"Material planning & Logistics"]
[{"$f":"A80+1","v":15},"8.5.1","Inhouse Order Process","Is a internal ordering plan established, followed and updated according to the customer demand and actual deliveries? ","N/A",null,{"$f":"IF(F86&F87&F88&F89&F90=\"\",\"\",IF(F86=\"x\",$E$86,SUM(G87:G90)))","v":""},null,{"$f":"IF(H86&H87&H88&H89&H90=\"\",\"\",IF(H86=\"x\",$E$86,SUM(I87:I90)))","v":""},null,{"$f":"fillthegap(F86,H86,F87:F90,H87:H90)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Not followed / updated ordering plan",null,null,{"$f":"IF(F87<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H87<>\"x\",\"\",0)","v":""}]
[null,null,null,"Actual ordering plan based on the time frame of the customer demand/forecast",null,null,{"$f":"IF(F88<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H88<>\"x\",\"\",1)","v":""}]
[null,null,null,"Ordering plan regularly updated (e.g. monthly or weekly) according to the backlog/inventory of finished goods",null,null,{"$f":"IF(F89<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H89<>\"x\",\"\",2)","v":""}]
[null,null,null,"Updated Ordering plan tracked, and active action plans in order to insure the order delivery deadlines",null,null,{"$f":"IF(F90<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H90<>\"x\",\"\",3)","v":""}]
[{"$f":"A86+1","v":16},null,"Lead Time","Is the Lead Time considered as a determinative planning data, source of improvement?","N/A",null,{"$f":"IF(F91&F92&F93&F94&F95=\"\",\"\",IF(F91=\"x\",$E$91,SUM(G92:G95)))","v":""},null,{"$f":"IF(H91&H92&H93&H94&H95=\"\",\"\",IF(H91=\"x\",$E$91,SUM(I92:I95)))","v":""},null,{"$f":"fillthegap(F91,H91,F92:F95,H92:H95)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No Lead Time defined or calculated",null,null,{"$f":"IF(F92<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H92<>\"x\",\"\",0)","v":""}]
[null,null,null,"Work In Process (WIP) planned and partially controlled in the storage area",null,null,{"$f":"IF(F93<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H93<>\"x\",\"\",1)","v":""}]
[null,null,null,"A Value Stream Map (VSM) has been done, the Dock-to-dock Lead Time and process cycle-times are regularly controlled",null,null,{"$f":"IF(F94<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H94<>\"x\",\"\",2)","v":""}]
[null,null,null,"Dock-to-dock Value Stream Mapping (VSM) including total Lead Time calculation; action plan established and on-going in order to reduce the Lead Time (material and production)",null,null,{"$f":"IF(F95<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H95<>\"x\",\"\",3)","v":""}]
[{"$f":"A91+1","v":17},null,"Supply Chain\nEfficiency","Is the Ordering Process calculated and practically improved (efficiency)?","N/A",null,{"$f":"IF(F96&F97&F98&F99&F100=\"\",\"\",IF(F96=\"x\",$E$96,SUM(G97:G100)))","v":""},null,{"$f":"IF(H96&H97&H98&H99&H100=\"\",\"\",IF(H96=\"x\",$E$96,SUM(I97:I100)))","v":""},null,{"$f":"fillthegap(F96,H96,F97:F100,H97:H100)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No availability or efficiency rate observed",null,null,{"$f":"IF(F97<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H97<>\"x\",\"\",0)","v":""}]
[null,null,null,"Bottlenecks are identified and their actual availability is tracked",null,null,{"$f":"IF(F98<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H98<>\"x\",\"\",1)","v":""}]
[null,null,null,"The tracking includes a distinction between planned and unplanned stops",null,null,{"$f":"IF(F99<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H99<>\"x\",\"\",2)","v":""}]
[null,null,null,"Inefficiency causes are categorized and analyzed; an action plan shows the corrective actions aiming to increase the machine efficiency",null,null,{"$f":"IF(F100<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H100<>\"x\",\"\",3)","v":""}]
[{"$f":"A96+1","v":18},null,"Supply Chain\nEfficiency","Is the Safety stock / Inventory Policy followed?","N/A",null,{"$f":"IF(F101&F102&F103&F104&F105=\"\",\"\",IF(F101=\"x\",$E$101,SUM(G102:G105)))","v":""},null,{"$f":"IF(H101&H102&H103&H104&H105=\"\",\"\",IF(H101=\"x\",$E$101,SUM(I102:I105)))","v":""},null,{"$f":"fillthegap(F101,H101,F102:F105,H102:H105)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No availability of safety stock or inventory policy observed",null,null,{"$f":"IF(F102<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H102<>\"x\",\"\",0)","v":""}]
[null,null,null,"Safety Stock or Inventory policy maintained as per customer demands",null,null,{"$f":"IF(F103<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H103<>\"x\",\"\",1)","v":""}]
[null,null,null,"The tracking includes a gap variance between planned and stock out situation",null,null,{"$f":"IF(F104<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H104<>\"x\",\"\",2)","v":""}]
[null,null,null,"Non-stock out situation causes are categorized and analyzed; an action plan shows the corrective actions aiming to increase the stock process efficiency",null,null,{"$f":"IF(F105<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H105<>\"x\",\"\",3)","v":""}]

{"sheet":"Overview","index":4,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":true,"merged":[[31,13,31,14],[32,13,32,14],[33,13,33,14],[1,13,2,16],[1,2,2,2],[1,12,2,12],[3,5,3,8],[29,11,30,12],[29,13,29,15],[30,13,30,14],[60,7,60,8],[61,7,61,8],[59,7,59,8],[1,3,2,9],[49,1,53,1]]}
[null,null,null,null,null,null,null,{"$f":"Summary!I1","v":"Mod PG 06.02-06"},{"$f":"Summary!J2","v":"Rev. 02"},null,null,null,null,null,null,{"$f":"Summary!I1","v":"Mod PG 06.02-06"},{"$f":"Summary!J2","v":"Rev. 02"}]
[null,null,"Manufacturing ",null,null,null,null,null,null,null,null,null,"Manufacturing",{"$f":"IF(Summary!C11=0,\"\",Summary!C11)","v":""}]
[]
[null,null,null,"Date",null,{"$f":"IF(Summary!I6=0,\"\",Summary!I6)","v":""},null,null,null,null,null,null,null,null,"Date",{"$f":"IF(Summary!I6=0,\"\",Summary!I6)","v":""}]
[]
[]
["Nr.","ISO 9001:2015","Element / Topic"]
[null,null,"Quality management system","Supplier Self-assessment",null,"Modine assessment",null,"Findings","Remarks"]
[{"$f":"'Questions - Manufacturing'!$A$13","v":1},{"$f":"'Questions - Manufacturing'!$B$13","v":"8.4.1"},{"$f":"'Questions - Manufacturing'!$C$13","v":"Certification status "},{"$f":"Riepilogo!I2","v":"-"},{"$f":"Riepilogo!H2","v":""},{"$f":"Riepilogo!L2","v":"-"},{"$f":"Riepilogo!K2","v":""},{"$f":"IF(Riepilogo!M2=0,\"\",Riepilogo!M2)","v":""},{"$f":"IF(Riepilogo!N2=0,\"\",Riepilogo!N2)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$18","v":2},{"$f":"'Questions - Manufacturing'!$B$18","v":"5.3 & 6.2"},{"$f":"'Questions - Manufacturing'!$C$18","v":"organizational Roles, responsibilities and Authorities, Quality Objectives and planning to achieve them"},{"$f":"Riepilogo!I3","v":"-"},{"$f":"Riepilogo!H3","v":""},{"$f":"Riepilogo!L3","v":"-"},{"$f":"Riepilogo!K3","v":""},{"$f":"IF(Riepilogo!M3=0,\"\",Riepilogo!M3)","v":""},{"$f":"IF(Riepilogo!N3=0,\"\",Riepilogo!N3)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$23","v":3},{"$f":"'Questions - Manufacturing'!$B$23","v":"7.5.3"},{"$f":"'Questions - Manufacturing'!$C$23","v":"Control of documented information"},{"$f":"Riepilogo!I4","v":"-"},{"$f":"Riepilogo!H4","v":""},{"$f":"Riepilogo!L4","v":"-"},{"$f":"Riepilogo!K4","v":""},{"$f":"IF(Riepilogo!M4=0,\"\",Riepilogo!M4)","v":""},{"$f":"IF(Riepilogo!N4=0,\"\",Riepilogo!N4)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$28","v":4},{"$f":"'Questions - Manufacturing'!$B$28","v":"8.3.6"},{"$f":"'Questions - Manufacturing'!$C$28","v":"Design and development changes"},{"$f":"Riepilogo!I5","v":"-"},{"$f":"Riepilogo!H5","v":""},{"$f":"Riepilogo!L5","v":"-"},{"$f":"Riepilogo!K5","v":""},{"$f":"IF(Riepilogo!M5=0,\"\",Riepilogo!M5)","v":""},{"$f":"IF(Riepilogo!N5=0,\"\",Riepilogo!N5)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$33","v":5},{"$f":"'Questions - Manufacturing'!$B$33","v":"8.3.4"},{"$f":"'Questions - Manufacturing'!$C$33","v":"Design and Development controls"},{"$f":"Riepilogo!I6","v":"-"},{"$f":"Riepilogo!H6","v":""},{"$f":"Riepilogo!L6","v":"-"},{"$f":"Riepilogo!K6","v":""},{"$f":"IF(Riepilogo!M6=0,\"\",Riepilogo!M6)","v":""},{"$f":"IF(Riepilogo!N6=0,\"\",Riepilogo!N6)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$38","v":6},{"$f":"'Questions - Manufacturing'!$B$38","v":"9.2"},{"$f":"'Questions - Manufacturing'!$C$38","v":"Internal audit"},{"$f":"Riepilogo!I7","v":"-"},{"$f":"Riepilogo!H7","v":""},{"$f":"Riepilogo!L7","v":"-"},{"$f":"Riepilogo!K7","v":""},{"$f":"IF(Riepilogo!M7=0,\"\",Riepilogo!M7)","v":""},{"$f":"IF(Riepilogo!N7=0,\"\",Riepilogo!N7)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$43","v":7},{"$f":"'Questions - Manufacturing'!$B$43","v":"10.3"},{"$f":"'Questions - Manufacturing'!$C$43","v":"Continual improvement"},{"$f":"Riepilogo!I8","v":"-"},{"$f":"Riepilogo!H8","v":""},{"$f":"Riepilogo!L8","v":"-"},{"$f":"Riepilogo!K8","v":""},{"$f":"IF(Riepilogo!M8=0,\"\",Riepilogo!M8)","v":""},{"$f":"IF(Riepilogo!N8=0,\"\",Riepilogo!N8)","v":""}]
[null,null,"Total quality management system",{"$f":"IFERROR(SUMIFS(Riepilogo!H:H,Riepilogo!A:A,\"=\"&Overview!$C$8,Riepilogo!H:H,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$8,Riepilogo!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS(Riepilogo!K:K,Riepilogo!A:A,\"=\"&Overview!$C$8,Riepilogo!K:K,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$8,Riepilogo!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Design & Development for product and process"]
[{"$f":"'Questions - Manufacturing'!$A$49","v":8},{"$f":"'Questions - Manufacturing'!B49","v":"8.2.1"},{"$f":"'Questions - Manufacturing'!$C$49","v":"Requirements for Products & services"},{"$f":"Riepilogo!I9","v":"-"},{"$f":"Riepilogo!H9","v":""},{"$f":"Riepilogo!L9","v":"-"},{"$f":"Riepilogo!K9","v":""},{"$f":"IF(Riepilogo!M9=0,\"\",Riepilogo!M9)","v":""},{"$f":"IF(Riepilogo!N9=0,\"\",Riepilogo!N9)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$54","v":9},{"$f":"'Questions - Manufacturing'!B54","v":"8.3.2"},{"$f":"'Questions - Manufacturing'!$C$54","v":"Design & Development planning"},{"$f":"Riepilogo!I10","v":"-"},{"$f":"Riepilogo!H10","v":""},{"$f":"Riepilogo!L10","v":"-"},{"$f":"Riepilogo!K10","v":""},{"$f":"IF(Riepilogo!M10=0,\"\",Riepilogo!M10)","v":""},{"$f":"IF(Riepilogo!N10=0,\"\",Riepilogo!N10)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$59","v":10},{"$f":"'Questions - Manufacturing'!B59","v":"8.3.4"},{"$f":"'Questions - Manufacturing'!$C$59","v":"Design and development controls"},{"$f":"Riepilogo!I11","v":"-"},{"$f":"Riepilogo!H11","v":""},{"$f":"Riepilogo!L11","v":"-"},{"$f":"Riepilogo!K11","v":""},{"$f":"IF(Riepilogo!M11=0,\"\",Riepilogo!M11)","v":""},{"$f":"IF(Riepilogo!N11=0,\"\",Riepilogo!N11)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$64","v":11},{"$f":"'Questions - Manufacturing'!B64","v":"8.3.3 / 8.3.5"},{"$f":"'Questions - Manufacturing'!$C$64","v":"Design and development inputs / outputs"},{"$f":"Riepilogo!I12","v":"-"},{"$f":"Riepilogo!H12","v":""},{"$f":"Riepilogo!L12","v":"-"},{"$f":"Riepilogo!K12","v":""},{"$f":"IF(Riepilogo!M12=0,\"\",Riepilogo!M12)","v":""},{"$f":"IF(Riepilogo!N12=0,\"\",Riepilogo!N12)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$69","v":12},{"$f":"'Questions - Manufacturing'!B69","v":"8.3.5 "},{"$f":"'Questions - Manufacturing'!$C$69","v":"Design and development Outputs "},{"$f":"Riepilogo!I13","v":"-"},{"$f":"Riepilogo!H13","v":""},{"$f":"Riepilogo!L13","v":"-"},{"$f":"Riepilogo!K13","v":""},{"$f":"IF(Riepilogo!M13=0,\"\",Riepilogo!M13)","v":""},{"$f":"IF(Riepilogo!N13=0,\"\",Riepilogo!N13)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$74","v":13},{"$f":"'Questions - Manufacturing'!B74","v":"8.5.4 & 8.5.5"},{"$f":"'Questions - Manufacturing'!$C$74","v":"Preservation"},{"$f":"Riepilogo!I14","v":"-"},{"$f":"Riepilogo!H14","v":""},{"$f":"Riepilogo!L14","v":"-"},{"$f":"Riepilogo!K14","v":""},{"$f":"IF(Riepilogo!M14=0,\"\",Riepilogo!M14)","v":""},{"$f":"IF(Riepilogo!N14=0,\"\",Riepilogo!N14)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$79","v":14},{"$f":"'Questions - Manufacturing'!B79","v":"8.6"},{"$f":"'Questions - Manufacturing'!$C$79","v":"Release of Products & services"},{"$f":"Riepilogo!I15","v":"-"},{"$f":"Riepilogo!H15","v":""},{"$f":"Riepilogo!L15","v":"-"},{"$f":"Riepilogo!K15","v":""},{"$f":"IF(Riepilogo!M15=0,\"\",Riepilogo!M15)","v":""},{"$f":"IF(Riepilogo!N15=0,\"\",Riepilogo!N15)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$84","v":15},{"$f":"'Questions - Manufacturing'!B84","v":"8.5.6"},{"$f":"'Questions - Manufacturing'!$C$84","v":"Release of Products & services"},{"$f":"Riepilogo!I16","v":"-"},{"$f":"Riepilogo!H16","v":""},{"$f":"Riepilogo!L16","v":"-"},{"$f":"Riepilogo!K16","v":""},{"$f":"IF(Riepilogo!M16=0,\"\",Riepilogo!M16)","v":""},{"$f":"IF(Riepilogo!N16=0,\"\",Riepilogo!N16)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$89","v":16},{"$f":"'Questions - Manufacturing'!B89","v":"8.4.1"},{"$f":"'Questions - Manufacturing'!$C$89","v":"Control of externally provided Processes, Products and  Services"},{"$f":"Riepilogo!I17","v":"-"},{"$f":"Riepilogo!H17","v":""},{"$f":"Riepilogo!L17","v":"-"},{"$f":"Riepilogo!K17","v":""},{"$f":"IF(Riepilogo!M17=0,\"\",Riepilogo!M17)","v":""},{"$f":"IF(Riepilogo!N17=0,\"\",Riepilogo!N17)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$94","v":17},{"$f":"'Questions - Manufacturing'!B94","v":"8.4.2"},{"$f":"'Questions - Manufacturing'!$C$94","v":"Type & Extent of control"},{"$f":"Riepilogo!I18","v":"-"},{"$f":"Riepilogo!H18","v":""},{"$f":"Riepilogo!L18","v":"-"},{"$f":"Riepilogo!K18","v":""},{"$f":"IF(Riepilogo!M18=0,\"\",Riepilogo!M18)","v":""},{"$f":"IF(Riepilogo!N18=0,\"\",Riepilogo!N18)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$99","v":18},{"$f":"'Questions - Manufacturing'!B99","v":"9.1"},{"$f":"'Questions - Manufacturing'!$C$99","v":"Monitoring, measurement,  analyzis and evaluation"},{"$f":"Riepilogo!I19","v":"-"},{"$f":"Riepilogo!H19","v":""},{"$f":"Riepilogo!L19","v":"-"},{"$f":"Riepilogo!K19","v":""},{"$f":"IF(Riepilogo!M19=0,\"\",Riepilogo!M19)","v":""},{"$f":"IF(Riepilogo!N19=0,\"\",Riepilogo!N19)","v":""}]
[null,null,"Total Design & Development for product and process",{"$f":"IFERROR(SUMIFS(Riepilogo!H:H,Riepilogo!A:A,\"=\"&Overview!$C$17,Riepilogo!H:H,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$17,Riepilogo!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS(Riepilogo!K:K,Riepilogo!A:A,\"=\"&Overview!$C$17,Riepilogo!K:K,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$17,Riepilogo!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Production",null,null,null,null,null,null,null,null,"Overall rating",null,"Assessment"]
[{"$f":"'Questions - Manufacturing'!$A$105","v":19},{"$f":"'Questions - Manufacturing'!B105","v":"7.1.3"},{"$f":"'Questions - Manufacturing'!$C$105","v":"Infrastructure"},{"$f":"Riepilogo!I20","v":"-"},{"$f":"Riepilogo!H20","v":""},{"$f":"Riepilogo!L20","v":"-"},{"$f":"Riepilogo!K20","v":""},{"$f":"IF(Riepilogo!M20=0,\"\",Riepilogo!M20)","v":""},{"$f":"IF(Riepilogo!N20=0,\"\",Riepilogo!N20)","v":""},null,null,null,null,"Yellow",null,"Red"]
[{"$f":"'Questions - Manufacturing'!$A$110","v":20},{"$f":"'Questions - Manufacturing'!B110","v":"7.1.3"},{"$f":"'Questions - Manufacturing'!$C$110","v":"Infrastructure"},{"$f":"Riepilogo!I21","v":"-"},{"$f":"Riepilogo!H21","v":""},{"$f":"Riepilogo!L21","v":"-"},{"$f":"Riepilogo!K21","v":""},{"$f":"IF(Riepilogo!M21=0,\"\",Riepilogo!M21)","v":""},{"$f":"IF(Riepilogo!N21=0,\"\",Riepilogo!N21)","v":""},null,null,1,"Barred supplier","More than 14",null,"From 1"]
[{"$f":"'Questions - Manufacturing'!$A$115","v":21},{"$f":"'Questions - Manufacturing'!B115","v":"7.1.4 & 8.2.3"},{"$f":"'Questions - Manufacturing'!$C$115","v":"Environment for the operation of processes "},{"$f":"Riepilogo!I22","v":"-"},{"$f":"Riepilogo!H22","v":""},{"$f":"Riepilogo!L22","v":"-"},{"$f":"Riepilogo!K22","v":""},{"$f":"IF(Riepilogo!M22=0,\"\",Riepilogo!M22)","v":""},{"$f":"IF(Riepilogo!N22=0,\"\",Riepilogo!N22)","v":""},null,null,2,"Controlled supplier","Max 14",null,"None"]
[{"$f":"'Questions - Manufacturing'!$A$120","v":22},{"$f":"'Questions - Manufacturing'!B120","v":"8.1 / 8.2.3 / 8.2.4"},{"$f":"'Questions - Manufacturing'!$C$120","v":"Requirements for Products and Services "},{"$f":"Riepilogo!I23","v":"-"},{"$f":"Riepilogo!H23","v":""},{"$f":"Riepilogo!L23","v":"-"},{"$f":"Riepilogo!K23","v":""},{"$f":"IF(Riepilogo!M23=0,\"\",Riepilogo!M23)","v":""},{"$f":"IF(Riepilogo!N23=0,\"\",Riepilogo!N23)","v":""},null,null,3,"Approved supplier","Max 7",null,"None"]
[{"$f":"'Questions - Manufacturing'!$A$125","v":23},{"$f":"'Questions - Manufacturing'!B125","v":"8.2.3"},{"$f":"'Questions - Manufacturing'!$C$125","v":"Validation of processes for production and service provision"},{"$f":"Riepilogo!I24","v":"-"},{"$f":"Riepilogo!H24","v":""},{"$f":"Riepilogo!L24","v":"-"},{"$f":"Riepilogo!K24","v":""},{"$f":"IF(Riepilogo!M24=0,\"\",Riepilogo!M24)","v":""},{"$f":"IF(Riepilogo!N24=0,\"\",Riepilogo!N24)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$130","v":24},{"$f":"'Questions - Manufacturing'!B130","v":"8.1 / 8.3.1"},{"$f":"'Questions - Manufacturing'!$C$130","v":"Quality plan"},{"$f":"Riepilogo!I25","v":"-"},{"$f":"Riepilogo!H25","v":""},{"$f":"Riepilogo!L25","v":"-"},{"$f":"Riepilogo!K25","v":""},{"$f":"IF(Riepilogo!M25=0,\"\",Riepilogo!M25)","v":""},{"$f":"IF(Riepilogo!N25=0,\"\",Riepilogo!N25)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$135","v":25},{"$f":"'Questions - Manufacturing'!B135","v":"8.4.2"},{"$f":"'Questions - Manufacturing'!$C$135","v":"Verification of purchased product"},{"$f":"Riepilogo!I26","v":"-"},{"$f":"Riepilogo!H26","v":""},{"$f":"Riepilogo!L26","v":"-"},{"$f":"Riepilogo!K26","v":""},{"$f":"IF(Riepilogo!M26=0,\"\",Riepilogo!M26)","v":""},{"$f":"IF(Riepilogo!N26=0,\"\",Riepilogo!N26)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$140","v":26},{"$f":"'Questions - Manufacturing'!B140","v":"8.7"},{"$f":"'Questions - Manufacturing'!$C$140","v":"Control of nonconformity"},{"$f":"Riepilogo!I27","v":"-"},{"$f":"Riepilogo!H27","v":""},{"$f":"Riepilogo!L27","v":"-"},{"$f":"Riepilogo!K27","v":""},{"$f":"IF(Riepilogo!M27=0,\"\",Riepilogo!M27)","v":""},{"$f":"IF(Riepilogo!N27=0,\"\",Riepilogo!N27)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$145","v":27},{"$f":"'Questions - Manufacturing'!B145","v":"10.2"},{"$f":"'Questions - Manufacturing'!$C$145","v":"Preventive and corrective actions"},{"$f":"Riepilogo!I28","v":"-"},{"$f":"Riepilogo!H28","v":""},{"$f":"Riepilogo!L28","v":"-"},{"$f":"Riepilogo!K28","v":""},{"$f":"IF(Riepilogo!M28=0,\"\",Riepilogo!M28)","v":""},{"$f":"IF(Riepilogo!N28=0,\"\",Riepilogo!N28)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$150","v":28},{"$f":"'Questions - Manufacturing'!B150","v":"8.5.2"},{"$f":"'Questions - Manufacturing'!$C$150","v":"Identification and traceability"},{"$f":"Riepilogo!I29","v":"-"},{"$f":"Riepilogo!H29","v":""},{"$f":"Riepilogo!L29","v":"-"},{"$f":"Riepilogo!K29","v":""},{"$f":"IF(Riepilogo!M29=0,\"\",Riepilogo!M29)","v":""},{"$f":"IF(Riepilogo!N29=0,\"\",Riepilogo!N29)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$155","v":29},{"$f":"'Questions - Manufacturing'!B155","v":"8.5.2"},{"$f":"'Questions - Manufacturing'!$C$155","v":"Identification and traceability"},{"$f":"Riepilogo!I30","v":"-"},{"$f":"Riepilogo!H30","v":""},{"$f":"Riepilogo!L30","v":"-"},{"$f":"Riepilogo!K30","v":""},{"$f":"IF(Riepilogo!M30=0,\"\",Riepilogo!M30)","v":""},{"$f":"IF(Riepilogo!N30=0,\"\",Riepilogo!N30)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$160","v":30},{"$f":"'Questions - Manufacturing'!B160","v":"8.7 / 10.2"},{"$f":"'Questions - Manufacturing'!$C$160","v":"Control of nonconforming product"},{"$f":"Riepilogo!I31","v":"-"},{"$f":"Riepilogo!H31","v":""},{"$f":"Riepilogo!L31","v":"-"},{"$f":"Riepilogo!K31","v":""},{"$f":"IF(Riepilogo!M31=0,\"\",Riepilogo!M31)","v":""},{"$f":"IF(Riepilogo!N31=0,\"\",Riepilogo!N31)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$165","v":31},{"$f":"'Questions - Manufacturing'!B165","v":"9.1.3"},{"$f":"'Questions - Manufacturing'!$C$165","v":"Monitoring and measurement of product"},{"$f":"Riepilogo!I32","v":"-"},{"$f":"Riepilogo!H32","v":""},{"$f":"Riepilogo!L32","v":"-"},{"$f":"Riepilogo!K32","v":""},{"$f":"IF(Riepilogo!M32=0,\"\",Riepilogo!M32)","v":""},{"$f":"IF(Riepilogo!N32=0,\"\",Riepilogo!N32)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$170","v":32},{"$f":"'Questions - Manufacturing'!B170","v":"9.1.3"},{"$f":"'Questions - Manufacturing'!$C$170","v":"Control of monitoring and measuring devices"},{"$f":"Riepilogo!I33","v":"-"},{"$f":"Riepilogo!H33","v":""},{"$f":"Riepilogo!L33","v":"-"},{"$f":"Riepilogo!K33","v":""},{"$f":"IF(Riepilogo!M33=0,\"\",Riepilogo!M33)","v":""},{"$f":"IF(Riepilogo!N33=0,\"\",Riepilogo!N33)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$175","v":33},{"$f":"'Questions - Manufacturing'!B175","v":"7.1.4 / 7.1.5"},{"$f":"'Questions - Manufacturing'!$C$175","v":"Work environment & control of production and service provision"},{"$f":"Riepilogo!I34","v":"-"},{"$f":"Riepilogo!H34","v":""},{"$f":"Riepilogo!L34","v":"-"},{"$f":"Riepilogo!K34","v":""},{"$f":"IF(Riepilogo!M34=0,\"\",Riepilogo!M34)","v":""},{"$f":"IF(Riepilogo!N34=0,\"\",Riepilogo!N34)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$180","v":34},{"$f":"'Questions - Manufacturing'!B180","v":"8.5.4"},{"$f":"'Questions - Manufacturing'!$C$180","v":"Preservation"},{"$f":"Riepilogo!I35","v":"-"},{"$f":"Riepilogo!H35","v":""},{"$f":"Riepilogo!L35","v":"-"},{"$f":"Riepilogo!K35","v":""},{"$f":"IF(Riepilogo!M35=0,\"\",Riepilogo!M35)","v":""},{"$f":"IF(Riepilogo!N35=0,\"\",Riepilogo!N35)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$185","v":35},{"$f":"'Questions - Manufacturing'!B185","v":"8.2.1"},{"$f":"'Questions - Manufacturing'!$C$185","v":"Customer communication"},{"$f":"Riepilogo!I36","v":"-"},{"$f":"Riepilogo!H36","v":""},{"$f":"Riepilogo!L36","v":"-"},{"$f":"Riepilogo!K36","v":""},{"$f":"IF(Riepilogo!M36=0,\"\",Riepilogo!M36)","v":""},{"$f":"IF(Riepilogo!N36=0,\"\",Riepilogo!N36)","v":""}]
[null,null,"Total Production",{"$f":"IFERROR(SUMIFS(Riepilogo!H:H,Riepilogo!A:A,\"=\"&Overview!$C$30,Riepilogo!H:H,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$30,Riepilogo!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS(Riepilogo!K:K,Riepilogo!A:A,\"=\"&Overview!$C$30,Riepilogo!K:K,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$30,Riepilogo!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Production Control & Logistics"]
[{"$f":"'Questions - Manufacturing'!$A$191","v":36},{"$f":"'Questions - Manufacturing'!B191","v":"8.5.1"},{"$f":"'Questions - Manufacturing'!$C$191","v":"Production Plan"},{"$f":"Riepilogo!I37","v":"-"},{"$f":"Riepilogo!H37","v":""},{"$f":"Riepilogo!L37","v":"-"},{"$f":"Riepilogo!K37","v":""},{"$f":"IF(Riepilogo!M37=0,\"\",Riepilogo!M37)","v":""},{"$f":"IF(Riepilogo!N37=0,\"\",Riepilogo!N37)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$196","v":37},null,{"$f":"'Questions - Manufacturing'!$C$196","v":"Material planning"},{"$f":"Riepilogo!I38","v":"-"},{"$f":"Riepilogo!H38","v":""},{"$f":"Riepilogo!L38","v":"-"},{"$f":"Riepilogo!K38","v":""},{"$f":"IF(Riepilogo!M38=0,\"\",Riepilogo!M38)","v":""},{"$f":"IF(Riepilogo!N38=0,\"\",Riepilogo!N38)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$201","v":38},null,{"$f":"'Questions - Manufacturing'!$C$201","v":"Lead Time"},{"$f":"Riepilogo!I39","v":"-"},{"$f":"Riepilogo!H39","v":""},{"$f":"Riepilogo!L39","v":"-"},{"$f":"Riepilogo!K39","v":""},{"$f":"IF(Riepilogo!M39=0,\"\",Riepilogo!M39)","v":""},{"$f":"IF(Riepilogo!N39=0,\"\",Riepilogo!N39)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$206","v":39},null,{"$f":"'Questions - Manufacturing'!$C$206","v":"Capacity Efficiency"},{"$f":"Riepilogo!I40","v":"-"},{"$f":"Riepilogo!H40","v":""},{"$f":"Riepilogo!L40","v":"-"},{"$f":"Riepilogo!K40","v":""},{"$f":"IF(Riepilogo!M40=0,\"\",Riepilogo!M40)","v":""},{"$f":"IF(Riepilogo!N40=0,\"\",Riepilogo!N40)","v":""}]
[{"$f":"'Questions - Manufacturing'!$A$211","v":40},null,{"$f":"'Questions - Manufacturing'!$C$211","v":"Supply Chain Efficiency"},{"$f":"Riepilogo!I41","v":"-"},{"$f":"Riepilogo!H41","v":""},{"$f":"Riepilogo!L41","v":"-"},{"$f":"Riepilogo!K41","v":""},{"$f":"IF(Riepilogo!M41=0,\"\",Riepilogo!M41)","v":""},{"$f":"IF(Riepilogo!N41=0,\"\",Riepilogo!N41)","v":""}]
[null,null,"Total Production Control & Logistics",{"$f":"IFERROR(SUMIFS(Riepilogo!H:H,Riepilogo!A:A,\"=\"&Overview!$C$49,Riepilogo!H:H,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$49,Riepilogo!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS(Riepilogo!K:K,Riepilogo!A:A,\"=\"&Overview!$C$49,Riepilogo!K:K,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$49,Riepilogo!K:K,\">=\"&0)),0)","v":0}]
[null,null,"Operational control"]
[{"$f":"'Questions - Manufacturing'!$A$217","v":41},{"$f":"'Questions - Manufacturing'!B217","v":"9.1.2 & 9.1.3"},{"$f":"'Questions - Manufacturing'!$C$217","v":"Key Performance Indicators"},{"$f":"Riepilogo!I42","v":"-"},{"$f":"Riepilogo!H42","v":""},{"$f":"Riepilogo!L42","v":"-"},{"$f":"Riepilogo!K42","v":""},{"$f":"IF(Riepilogo!M42=0,\"\",Riepilogo!M42)","v":""},{"$f":"IF(Riepilogo!N42=0,\"\",Riepilogo!N42)","v":""}]
[null,null,"Total Operational control",{"$f":"IFERROR(SUMIFS(Riepilogo!H:H,Riepilogo!A:A,\"=\"&Overview!$C$56,Riepilogo!H:H,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$56,Riepilogo!H:H,\">=\"&0)),0)","v":0},null,{"$f":"IFERROR(SUMIFS(Riepilogo!K:K,Riepilogo!A:A,\"=\"&Overview!$C$56,Riepilogo!K:K,\">\"&0)/(3*COUNTIFS(Riepilogo!A:A,Overview!$C$56,Riepilogo!K:K,\">=\"&0)),0)","v":0}]
[]
[null,null,"Total","Score [%]",null,"Result",null,"Warning for NA answers number >= 3"]
[null,null,"Supplier's self-assessment",{"$f":"(SUMIF(Riepilogo!H2:H42,\">=\"&0,Riepilogo!H2:H42)/(3*COUNT(Riepilogo!B2:B42,\">=\"&0)))","v":0},null,{"$f":"RossoGialloVerde(Riepilogo!H:H)","v":"To do"},null,{"$f":"IF(nacount(Riepilogo!H:H)=\"\",\"Score can be computed\",\"Score should not be computed due to the fact that more than 3 answers are NA\")","v":"Score can be computed"}]
[null,null,"Modine's assessment",{"$f":"(SUMIF(Riepilogo!K2:K42,\">=\"&0,Riepilogo!K2:K42)/(3*COUNT(Riepilogo!B2:B42,\">=\"&0)))","v":0},null,{"$f":"RossoGialloVerde(Riepilogo!K:K)","v":"To do"},null,{"$f":"IF(nacount(Riepilogo!K:K)=\"\",\"Score can be computed\",\"Score should not be computed due to the fact that more than 3 answers are NA\")","v":"Score can be computed"}]

{"sheet":"Questions - Manufacturing","index":5,"n_rows":221,"n_cols":11,"rows_kept":221,"cut":false,"hidden":true,"merged":[[160,9,163,9],[165,9,168,9],[217,9,220,9],[170,9,173,9],[175,9,178,9],[180,9,183,9],[185,9,188,9],[191,9,194,9],[196,9,199,9],[201,9,204,9],[206,9,209,9],[211,9,214,9],[159,2,163,2],[43,9,46,9],[49,9,52,9],[54,9,57,9],[59,9,62,9],[64,9,67,9],[69,9,72,9],[74,9,77,9],[79,9,82,9],[84,9,87,9],[89,9,92,9],[94,9,97,9],[99,9,102,9],[105,9,108,9],[110,9,113,9],[115,9,118,9],[120,9,123,9],[125,9,128,9],[130,9,133,9],[135,9,138,9],[140,9,143,9],[145,9,148,9],[150,9,153,9],[155,9,158,9],[48,2,52,2],[69,10,72,10],[73,2,77,2],[63,2,67,2],[28,10,31,10],[33,10,36,10],[38,10,41,10],[169,2,173,2],[155,10,158,10],[164,2,168,2],[83,2,87,2],[124,2,128,2],[129,2,133,2],[68,2,72,2],[54,10,57,10],[59,10,62,10],[43,10,46,10],[49,10,52,10],[84,10,87,10],[99,10,102,10],[105,10,108,10],[74,10,77,10],[79,10,82,10],[110,10,113,10],[170,10,173,10],[13,10,16,10],[135,10,138,10],[140,10,143,10],[18,10,21,10],[23,10,26,10],[160,10,163,10],[145,10,148,10],[150,10,153,10],[89,10,92,10],[94,10,97,10],[125,10,128,10],[130,10,133,10],[115,10,118,10],[48,1,52,1],[53,2,57,2],[58,2,62,2],[42,2,46,2],[64,10,67,10],[2,3,4,3],[2,4,4,10],[12,2,16,2],[17,2,21,2],[22,2,26,2],[27,2,31,2],[32,2,36,2],[37,2,41,2],[12,1,16,1],[13,9,16,9],[18,9,21,9],[23,9,26,9],[28,9,31,9],[33,9,36,9],[38,9,41,9],[6,0,9,10],[17,0,21,0],[17,1,21,1],[22,0,26,0],[22,1,26,1],[32,0,36,0],[27,0,31,0],[12,0,16,0],[37,0,41,0],[37,1,41,1],[32,1,36,1],[27,1,31,1],[217,10,220,10],[206,10,209,10],[184,1,188,1],[184,2,188,2],[211,10,214,10],[210,0,214,0],[210,2,214,2],[190,1,214,1],[216,0,220,0],[216,1,220,1],[216,2,220,2],[200,0,204,0],[200,2,204,2],[205,0,209,0],[205,2,209,2],[190,0,194,0],[190,2,194,2],[195,0,199,0],[195,2,199,2],[185,10,188,10],[191,10,194,10],[201,10,204,10],[196,10,199,10],[184,0,188,0],[174,2,178,2],[179,2,183,2],[175,10,178,10],[180,10,183,10],[78,0,82,0],[78,1,82,1],[88,0,92,0],[88,1,92,1],[88,2,92,2],[78,2,82,2],[139,2,143,2],[134,2,138,2],[104,0,108,0],[93,0,97,0],[93,1,97,1],[93,2,97,2],[98,2,102,2],[119,0,123,0],[119,1,123,1],[114,2,118,2],[104,1,108,1],[119,2,123,2],[114,0,118,0],[134,0,138,0],[114,1,118,1],[104,2,108,2],[154,2,158,2],[42,0,46,0],[42,1,46,1],[179,0,183,0],[179,1,183,1],[164,0,168,0],[164,1,168,1],[159,0,163,0],[159,1,163,1],[53,1,57,1],[53,0,57,0],[83,0,87,0],[83,1,87,1],[68,0,72,0],[124,1,128,1],[48,0,52,0],[134,1,138,1],[129,0,133,0],[129,1,133,1],[124,0,128,0],[58,0,62,0],[58,1,62,1],[68,1,72,1],[63,0,67,0],[63,1,67,1],[73,0,77,0],[98,0,102,0],[98,1,102,1],[120,10,123,10],[73,1,77,1],[165,10,168,10],[169,1,173,1],[174,0,178,0],[174,1,178,1],[154,0,158,0],[154,1,158,1],[109,0,113,0],[109,1,113,1],[109,2,113,2],[169,0,173,0],[144,0,148,0],[144,1,148,1],[149,0,153,0],[149,1,153,1],[144,2,148,2],[149,2,153,2],[139,0,143,0],[139,1,143,1]]}
[]
[]
[null,null,null,"Manufacturing ",{"$f":"IF(Summary!C11=0,\"\",Summary!C11)","v":""}]
[]
[]
[null,null,null,"Date",null,null,null,null,null,null,{"$f":"IF(Summary!I6=0,\"\",Summary!I6)","v":""}]
["WARNING: In case the Supplier is one in the dedicated Vendor List of Customers that require additional requirements to the ISO 9001 standard and or requires that the tier two supplier are deployed of such requirements,, the list of the additional requirements has to be attached to this check list (info and attachments - pdf) and all the questions has to be interpreted and evaluated taking in consideration all the additional requirements. The outcome of the Audit shall clearly identify the correspondence to those additional  requirement"]
[]
[]
[]
["Nr.","ISO9001:2015",null,"Question",null,"Supplier Self-assessment",null,"Modine assessment",null,"Findings","Remarks"]
[null,null,null,"Quality management system"]
[1,"8.4.1","Certification status ","Certification status of the Quality Management System?","N/A",null,{"$f":"IF(F13&F14&F15&F16&F17=\"\",\"\",IF(F13=\"x\",$E$13,SUM(G14:G17)))","v":""},null,{"$f":"IF(H13&H14&H15&H16&H17=\"\",\"\",IF(H13=\"x\",$E$13,SUM(I14:I17)))","v":""},null,{"$f":"fillthegap(F13,H13,F14:F17,H14:H17)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No certification to an international standard",null,null,{"$f":"IF(F14<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H14<>\"x\",\"\",0)","v":""}]
[null,null,null,"Other certification",null,null,{"$f":"IF(F15<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H15<>\"x\",\"\",1)","v":""}]
[null,null,null,"Certified according ISO 9001: 2015",null,null,{"$f":"IF(F16<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H16<>\"x\",\"\",2)","v":""}]
[null,null,null,"Certified according ISO 9001:2015 and ISO 14001:2015",null,null,{"$f":"IF(F17<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H17<>\"x\",\"\",3)","v":""}]
[2,"5.3 & 6.2","organizational Roles, responsibilities and Authorities, Quality Objectives and planning to achieve them","Have process oriented procedures been established, including required procedures which define quality related actions, responsibilities, deliverables and objectives?","N/A",null,{"$f":"IF(F18&F19&F20&F21&F22=\"\",\"\",IF(F18=\"x\",$E$18,SUM(G19:G22)))","v":""},null,{"$f":"IF(H18&H19&H20&H21&H22=\"\",\"\",IF(H18=\"x\",$E$18,SUM(I19:I22)))","v":""},null,{"$f":"fillthegap(F18,H18,F19:F22,H19:H22)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no clear definition of company process, quality assurance activities or responsibilities within the organization.",null,null,{"$f":"IF(F19<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H19<>\"x\",\"\",0)","v":""}]
[null,null,null,"The company processes, quality assurance activities and responsibilities, including process ownership,  are minimally defined. Process orientation with gaps.",null,null,{"$f":"IF(F20<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H20<>\"x\",\"\",1)","v":""}]
[null,null,null,"The company processes, quality assurance activities and responsibilities, including process ownership, are reasonably well defined, including reporting requirements and deliverables  for customer oriented processes. Procedures and Q-indicators are not all known.",null,null,{"$f":"IF(F21<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H21<>\"x\",\"\",2)","v":""}]
[null,null,null,"Quality assurance activities and responsibilities, including process ownership, are thoroughly defined with reporting requirements clearly indicated. Good awareness and proper execution of the personal regarding their responsibility and Q-indicators (deliverables). Adequate procedures are available, well defined and trained.",null,null,{"$f":"IF(F22<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H22<>\"x\",\"\",3)","v":""}]
[3,"7.5.3","Control of documented information","Are records (quality, process etc.) kept and retained according to legal and customer requirements?","N/A",null,{"$f":"IF(F23&F24&F25&F26&F27=\"\",\"\",IF(F23=\"x\",$E$23,SUM(G24:G27)))","v":""},null,{"$f":"IF(H23&H24&H25&H26&H27=\"\",\"\",IF(H23=\"x\",$E$23,SUM(I24:I27)))","v":""},null,{"$f":"fillthegap(F23,H23,F24:F27,H24:H27)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no documented procedure in which way and how long quality and other relevant records are retained.",null,null,{"$f":"IF(F24<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H24<>\"x\",\"\",0)","v":""}]
[null,null,null,"There is a documented procedure identifying records to be retained. The procedure however does not identify all documents and is not considering all customer or legal requirements (critical characteristics).",null,null,{"$f":"IF(F25<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H25<>\"x\",\"\",1)","v":""}]
[null,null,null,"A documented procedure is identifying the process for storage and final disposal of records considering customer/ legal requirements including all computer data. Records are stored in orderly conditions and can easily be retrieved. ",null,null,{"$f":"IF(F26<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H26<>\"x\",\"\",2)","v":""}]
[null,null,null,"As before, records including electronic data are protected to prevent damage or deterioration. (i.e. safe, different building, etc.)",null,null,{"$f":"IF(F27<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H27<>\"x\",\"\",3)","v":""}]
[4,"8.3.6","Design and development changes","Are process and design/ product changes communicated, authorized, and validated prior to the release of affected product?","N/A",null,{"$f":"IF(F28&F29&F30&F31&F32=\"\",\"\",IF(F28=\"x\",$E$28,SUM(G29:G32)))","v":""},null,{"$f":"IF(H28&H29&H30&H31&H32=\"\",\"\",IF(H28=\"x\",$E$28,SUM(I29:I32)))","v":""},null,{"$f":"fillthegap(F28,H28,F29:F32,H29:H32)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no or only a verbal system established for communication of process and design/ product changes. Evidence of process and design/ product changes without authorization is apparent.",null,null,{"$f":"IF(F29<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H29<>\"x\",\"\",0)","v":""}]
[null,null,null,"The supplier has and follows a process and design/ product change procedure. However, changes are not pre-approved (feasibility review) and/or communications are mainly \"after the fact\".",null,null,{"$f":"IF(F30<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H30<>\"x\",\"\",1)","v":""}]
[null,null,null,"A change communication procedure is being efficiently followed and includes review of potential failures (e.g. FMEA, risk analyze) and control plans update prior to implementation. The customer is informed in advance.",null,null,{"$f":"IF(F31<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H31<>\"x\",\"\",2)","v":""}]
[null,null,null,"Evidence of proactive and effective product / process changes well reviewed, developed, validated and approved internally and externally.",null,null,{"$f":"IF(F32<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H32<>\"x\",\"\",3)","v":""}]
[5,"8.3.4","Design and Development controls","How is the distribution of drawings, specifications and associated documents controlled and expedited to assure the use of current information?","N/A",null,{"$f":"IF(F33&F34&F35&F36&F37=\"\",\"\",IF(F33=\"x\",$E$33,SUM(G34:G37)))","v":""},null,{"$f":"IF(H33&H34&H35&H36&H37=\"\",\"\",IF(H33=\"x\",$E$33,SUM(I34:I37)))","v":""},null,{"$f":"fillthegap(F33,H33,F34:F37,H34:H37)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No defined system at all.",null,null,{"$f":"IF(F34<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H34<>\"x\",\"\",0)","v":""}]
[null,null,null,"An acceptable system is in place, but there are relevant department/groups where the actual information (internal or external) is not in use. There is little knowledge of the procedure by the involved departments. A timely review of changed customer requirements is not tracked.",null,null,{"$f":"IF(F35<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H35<>\"x\",\"\",1)","v":""}]
[null,null,null,"An effective system for drawing, documents and specification control is documented and followed. Changes of customer requirements are tracked, but are not all completed in the defined timeframe. Most of involved personnel are aware of the process. There is no evidence of obsolete/ uncontrolled documents in use.",null,null,{"$f":"IF(F36<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H36<>\"x\",\"\",2)","v":""}]
[null,null,null,"All relevant drawings, documents and specifications are current, with an established system to sustain that status; All affected personnel is aware of the document control procedure. Changes are realized in the defined timeframe.",null,null,{"$f":"IF(F37<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H37<>\"x\",\"\",3)","v":""}]
[6,"9.2","Internal audit","How is the suppliers' Quality System subjected to independent, objective internal review - Audits?","N/A",null,{"$f":"IF(F38&F39&F40&F41&F42=\"\",\"\",IF(F38=\"x\",$E$38,SUM(G39:G42)))","v":""},null,{"$f":"IF(H38&H39&H40&H41&H42=\"\",\"\",IF(H38=\"x\",$E$38,SUM(I39:I42)))","v":""},null,{"$f":"fillthegap(F38,H38,F39:F42,H39:H42)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no evidence for an internal review or audit. Reviews are mainly verbal in nature.",null,null,{"$f":"IF(F39<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H39<>\"x\",\"\",0)","v":""}]
[null,null,null,"Internal quality system reviews have been conducted; Results are not analyzed for corrective action assignments and effectiveness.",null,null,{"$f":"IF(F40<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H40<>\"x\",\"\",1)","v":""}]
[null,null,null,"The internal quality systems review is being conducted on a regular basis; Some corrective action has resulted from this, but is unsatisfactory.",null,null,{"$f":"IF(F41<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H41<>\"x\",\"\",2)","v":""}]
[null,null,null,"Corrective action assignments are based on regular audits; Subsequent assessment documentation shows these to be complete and efficient in addressing concerns as foundation for continuous improvement activities.",null,null,{"$f":"IF(F42<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H42<>\"x\",\"\",3)","v":""}]
[7,"10.3","Continual improvement","Is there a formalized, measurable approach for continuous improvement? ","N/A",null,{"$f":"IF(F43&F44&F45&F46&F47=\"\",\"\",IF(F43=\"x\",$E$43,SUM(G44:G47)))","v":""},null,{"$f":"IF(H43&H44&H45&H46&H47=\"\",\"\",IF(H43=\"x\",$E$43,SUM(I44:I47)))","v":""},null,{"$f":"fillthegap(F43,H43,F44:F47,H44:H47)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no objective evidence of a commitment to continuous improvement in quality or productivity.",null,null,{"$f":"IF(F44<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H44<>\"x\",\"\",0)","v":""}]
[null,null,null,"Continuous improvement plans for some programs are formalized with target dates and responsibilities, but the implementation is not been tracked. Some results are available but with insufficient evaluation of progress made.",null,null,{"$f":"IF(F45<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H45<>\"x\",\"\",1)","v":""}]
[null,null,null,"A quality improvement program has been implemented on key processes with results obtained (with e.g. through the use of statistically based variation reduction tools). Progress made is being tracked and evaluated.",null,null,{"$f":"IF(F46<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H46<>\"x\",\"\",2)","v":""}]
[null,null,null,"Comprehensive established Quality/ Productivity improvement projects have resulted in quality and productivity gains. Appraisal, prevention, and failure cost information is analyzed, reported, and monitored to a recognized standard (i.e., percentage of sales, labor costs, etc.)",null,null,{"$f":"IF(F47<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H47<>\"x\",\"\",3)","v":""}]
[null,null,null,"Design & Development for product and process"]
[{"$f":"A43+1","v":8},"8.2.1","Requirements for Products & services","Is there a documented process to identify and coordinate the contract review activities prior to the submission of a tender or the acceptance of a contract?","N/A",null,{"$f":"IF(F49&F50&F51&F52&F53=\"\",\"\",IF(F49=\"x\",$E$49,SUM(G50:G53)))","v":""},null,{"$f":"IF(H49&H50&H51&H52&H53=\"\",\"\",IF(H49=\"x\",$E$49,SUM(I50:I53)))","v":""},null,{"$f":"fillthegap(F49,H49,F50:F53,H50:H53)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no documented process/ system to perform contract review activities prior to the submission of a tender or the acceptance of a contact. The process is mostly verbal in nature.",null,null,{"$f":"IF(F50<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H50<>\"x\",\"\",0)","v":""}]
[null,null,null,"A documented system for contract review activities is available; The activities are performed for some products and programs. ",null,null,{"$f":"IF(F51<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H51<>\"x\",\"\",1)","v":""}]
[null,null,null,"An adequate system to identify contract review activities is available, not all contracts are reviewed in cross-functional teams. Most evidence is conclusive and is documented in Feasibility Commitments signed by the team. ",null,null,{"$f":"IF(F52<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H52<>\"x\",\"\",2)","v":""}]
[null,null,null,"Contract review activities thoroughly defined (including handling of verbal orders and contract amendments) and performed in a cross-functional team. The documentation is conclusive. A checklist to perform the contract review activities is available. A team sign-off to meet the contractual requirements (Feasibility Commitment) is part of the system.",null,null,{"$f":"IF(F53<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H53<>\"x\",\"\",3)","v":""}]
[{"$f":"A49+1","v":9},"8.3.2","Design & Development planning","Is a quality planning process in place for new products/processes or changes?","N/A",null,{"$f":"IF(F54&F55&F56&F57&F58=\"\",\"\",IF(F54=\"x\",$E$54,SUM(G55:G58)))","v":""},null,{"$f":"IF(H54&H55&H56&H57&H58=\"\",\"\",IF(H54=\"x\",$E$54,SUM(I55:I58)))","v":""},null,{"$f":"fillthegap(F54,H54,F55:F58,H55:H58)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no evidence of quality planning.",null,null,{"$f":"IF(F55<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H55<>\"x\",\"\",0)","v":""}]
[null,null,null,"Some elements of product quality planning are accomplished for certain products or programs, but responsibilities are not clearly defined or are not implemented in all areas. There is some evidence of quality planning.",null,null,{"$f":"IF(F56<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H56<>\"x\",\"\",1)","v":""}]
[null,null,null,"Quality planning is largely the responsibility of the supplier's Quality Department, with some involvement from other areas. Evidence of effective quality planning for most new/revised product launches exists.",null,null,{"$f":"IF(F57<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H57<>\"x\",\"\",2)","v":""}]
[null,null,null,"Quality planning efforts are of a company-wide cross-functional team approach. Quality planning responsibilities are well-defined and appropriately cross-functional. There is evidence of successful implementation, as well as thorough documentation of quality planning, indicating that the procedures are being followed.",null,null,{"$f":"IF(F58<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H58<>\"x\",\"\",3)","v":""}]
[{"$f":"A54+1","v":10},"8.3.4","Design and development controls","Is there a documented Project Management process with regular cross-functional reviews established?","N/A",null,{"$f":"IF(F59&F60&F61&F62&F63=\"\",\"\",IF(F59=\"x\",$E$59,SUM(G60:G63)))","v":""},null,{"$f":"IF(H59&H60&H61&H62&H63=\"\",\"\",IF(H59=\"x\",$E$59,SUM(I60:I63)))","v":""},null,{"$f":"fillthegap(F59,H59,F60:F63,H60:H63)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There no conclusive Project Management process established. Project plans are mainly customer generated. Teams are not set up as cross-functional teams. No documented reviews.",null,null,{"$f":"IF(F60<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H60<>\"x\",\"\",0)","v":""}]
[null,null,null,"A Project Mgt. process is established incl. responsibilities. The process however is not completely implemented for all projects and changes. Project reviews are not in all cases properly documented (Due Dates/ Responsibility) including a clear project status and take place on an as needed basis.",null,null,{"$f":"IF(F61<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H61<>\"x\",\"\",1)","v":""}]
[null,null,null,"A Project Mgt. process is established incl. responsibilities. For all projects an updated project plans with milestones is available. Project reviews take place and are properly documented (Due Dates/ Responsibility). However not all actions are completed on time. ",null,null,{"$f":"IF(F62<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H62<>\"x\",\"\",2)","v":""}]
[null,null,null,"A conclusive Project Mgt. process with clear responsibilities is established. Regular status/ review meetings take place internally and also pro-actively with the customer. For all projects an updated project plans with milestones are available. Project reviews take place and are properly documented (Due Dates/ Responsible, etc).",null,null,{"$f":"IF(F63<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H63<>\"x\",\"\",3)","v":""}]
[{"$f":"A59+1","v":11},"8.3.3 / 8.3.5","Design and development inputs / outputs","Are the results of the development process (products or processes) documented in drawings, specifications,  quality plans etc. and are they updated regularly?","N/A",null,{"$f":"IF(F64&F65&F66&F67&F68=\"\",\"\",IF(F64=\"x\",$E$64,SUM(G65:G68)))","v":""},null,{"$f":"IF(H64&H65&H66&H67&H68=\"\",\"\",IF(H64=\"x\",$E$64,SUM(I65:I68)))","v":""},null,{"$f":"fillthegap(F64,H64,F65:F68,H65:H68)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No process defined to document results of development. Mandatory documents are missing. If they exists, they are not updated.",null,null,{"$f":"IF(F65<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H65<>\"x\",\"\",0)","v":""}]
[null,null,null,"Results of the product and/ or process development are documented in drawings, specifications, process/ quality requirements. Data is reviewed on a case by case basis. Process/ Design FMEA or risk assessments / control plans are available for most products/ processes but do not include all changes made. ",null,null,{"$f":"IF(F66<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H66<>\"x\",\"\",1)","v":""}]
[null,null,null,"Results of the product and/ or process development are properly documented. Some documents don't represent the latest release level/ sample status/ change level. Process/ Design FMEA / control plans are available for all products/ processes.",null,null,{"$f":"IF(F67<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H67<>\"x\",\"\",2)","v":""}]
[null,null,null,"Results of the product and/ or process development are documented in drawings, process requirements, quality requirements. Data is regularly updated based on the test results and changes made in the development phase. The change management process is working effectively. Up to date Process/ Design FMEA/ control plans are available for all products/ processes.",null,null,{"$f":"IF(F68<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H68<>\"x\",\"\",3)","v":""}]
[{"$f":"A64+1","v":12},"8.3.5 ","Design and development Outputs ","How does the verification and release of the design and development work?","N/A",null,{"$f":"IF(F69&F70&F71&F72&F73=\"\",\"\",IF(F69=\"x\",$E$69,SUM(G70:G73)))","v":""},null,{"$f":"IF(H69&H70&H71&H72&H73=\"\",\"\",IF(H69=\"x\",$E$69,SUM(I70:I73)))","v":""},null,{"$f":"fillthegap(F69,H69,F70:F73,H70:H73)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There are no documented internal programs/ requirements to verify / release product or processes. Product/ process verifications / releases are based on experience.",null,null,{"$f":"IF(F70<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H70<>\"x\",\"\",0)","v":""}]
[null,null,null,"There is a documented internal test program for products/ processes. It does not correspond in all cases with the defined customer requirements (i.e. sample validation plans/ sample verification/ process capabilities/ run @ rates/ PPAP). Internal reviews take place occasionally to update the respective programs.",null,null,{"$f":"IF(F71<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H71<>\"x\",\"\",1)","v":""}]
[null,null,null,"The internal release program corresponds with the defined customer requirements (i.e. sample validation/ sample verification/ process capabilities/ run @ rates/ PPAP). Internal review meetings take place the customer is informed on an as needed basis.",null,null,{"$f":"IF(F72<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H72<>\"x\",\"\",2)","v":""}]
[null,null,null,"The documented product/ component release corresponds in all cases with the defined customer requirements and is as necessary enhanced with internal requirements. The customer is updated regularly about the release status and test results.",null,null,{"$f":"IF(F73<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H73<>\"x\",\"\",3)","v":""}]
[{"$f":"A69+1","v":13},"8.5.4 & 8.5.5","Preservation","Is a comprehensive logistic concept including the component specific requirements determined during the development/implementation process?","N/A",null,{"$f":"IF(F74&F75&F76&F77&F78=\"\",\"\",IF(F74=\"x\",$E$74,SUM(G75:G78)))","v":""},null,{"$f":"IF(H74&H75&H76&H77&H78=\"\",\"\",IF(H74=\"x\",$E$74,SUM(I75:I78)))","v":""},null,{"$f":"fillthegap(F74,H74,F75:F78,H75:H78)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"The logistic requirements are not part of the advanced product quality process and are usually determined close to the initial sample release, if requested by the customer.",null,null,{"$f":"IF(F75<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H75<>\"x\",\"\",0)","v":""}]
[null,null,null,"Logistic requirements are not determined for all products as part of the advanced product quality process. They include mainly the capacity requirements of serial production and the comparison with the customer demand.",null,null,{"$f":"IF(F76<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H76<>\"x\",\"\",1)","v":""}]
[null,null,null,"A logistic concept is part of the advanced product quality process and considers beside serial production requirements also the sample production. The logistic concept includes packaging, labelling, transportation requirements. Traceability requirements are considered based on customer demand.",null,null,{"$f":"IF(F77<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H77<>\"x\",\"\",2)","v":""}]
[null,null,null,"The logistic concept considers serial production and sample requirements. It includes packaging, labelling, transportation requirements etc. Traceability requirements are considered for all products and harmonized with the customer demands. Packaging is being tested before being released.",null,null,{"$f":"IF(F78<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H78<>\"x\",\"\",3)","v":""}]
[{"$f":"A74+1","v":14},"8.6","Release of Products & services","Are initial samples and documentation prepared in accordance with the customer Requirements?","N/A",null,{"$f":"IF(F79&F80&F81&F82&F83=\"\",\"\",IF(F79=\"x\",$E$79,SUM(G80:G83)))","v":""},null,{"$f":"IF(H79&H80&H81&H82&H83=\"\",\"\",IF(H79=\"x\",$E$79,SUM(I80:I83)))","v":""},null,{"$f":"fillthegap(F79,H79,F80:F83,H80:H83)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Majority of Initial Samples submitted have major deficiencies and are rejected; Only little knowledge of PPAP requirements",null,null,{"$f":"IF(F80<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H80<>\"x\",\"\",0)","v":""}]
[null,null,null,"Majority of PPAP are approved but require one or more deviations.",null,null,{"$f":"IF(F81<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H81<>\"x\",\"\",1)","v":""}]
[null,null,null,"Most PPAP are fully approved, few require a deviation; Re-qualification is adequate. ",null,null,{"$f":"IF(F82<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H82<>\"x\",\"\",2)","v":""}]
[null,null,null,"Complete supporting data is available for each initial sample reviewed. There is documented evidence that a comprehensive PPAP program and re-qualification is followed for all customers. PPAP are submitted on-time",null,null,{"$f":"IF(F83<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H83<>\"x\",\"\",3)","v":""}]
[{"$f":"A79+1","v":15},"8.5.6","Release of Products & services","Is change management notified in accordance with the customer Requirements?","N/A",null,{"$f":"IF(F84&F85&F86&F87&F88=\"\",\"\",IF(F84=\"x\",$E$84,SUM(G85:G88)))","v":""},null,{"$f":"IF(H84&H85&H86&H87&H88=\"\",\"\",IF(H84=\"x\",$E$84,SUM(I85:I88)))","v":""},null,{"$f":"fillthegap(F84,H84,F85:F88,H85:H88)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Majority of Initial Samples submitted have major deficiencies and are rejected; Only little knowledge of PPAP requirements",null,null,{"$f":"IF(F85<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H85<>\"x\",\"\",0)","v":""}]
[null,null,null,"Majority of PPAP are approved but require one or more deviations.",null,null,{"$f":"IF(F86<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H86<>\"x\",\"\",1)","v":""}]
[null,null,null,"Most PPAP are fully approved, few require a deviation; Re-qualification is adequate. ",null,null,{"$f":"IF(F87<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H87<>\"x\",\"\",2)","v":""}]
[null,null,null,"Complete supporting data is available for each initial sample reviewed. There is documented evidence that a comprehensive PPAP program and re-qualification is followed for all customers. PPAP are submitted on-time",null,null,{"$f":"IF(F88<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H88<>\"x\",\"\",3)","v":""}]
[{"$f":"A84+1","v":16},"8.4.1","Control of externally provided Processes, Products and  Services","Are suppliers and subcontractors selected by the use of a standardized evaluation method?","N/A",null,{"$f":"IF(F89&F90&F91&F92&F93=\"\",\"\",IF(F89=\"x\",$E$89,SUM(G90:G93)))","v":""},null,{"$f":"IF(H89&H90&H91&H92&H93=\"\",\"\",IF(H89=\"x\",$E$89,SUM(I90:I93)))","v":""},null,{"$f":"fillthegap(F89,H89,F90:F93,H90:H93)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No evidence of a standardized evaluation of subcontractors.",null,null,{"$f":"IF(F90<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H90<>\"x\",\"\",0)","v":""}]
[null,null,null,"Specific requirements for sub-suppliers have been established and are communicated. An on-site evaluation is conducted by the supplier's organization for critical suppliers. Most sourcing decisions however, consider only the commercial requirements.",null,null,{"$f":"IF(F91<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H91<>\"x\",\"\",1)","v":""}]
[null,null,null,"The initial sub-supplier evaluation is thorough. It is used to analyze the capability of potential supplier/subcontractor, regarding quality, technical and commercial aspects. All aspects are considered in the sourcing decision. ",null,null,{"$f":"IF(F92<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H92<>\"x\",\"\",2)","v":""}]
[null,null,null,"The initial sub-supplier evaluation is thorough and takes care of quality, technical and commercial aspects. All aspects are considered in the sourcing decision. For critical suppliers a specific development program is determined, with scheduled follow up meetings.",null,null,{"$f":"IF(F93<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H93<>\"x\",\"\",3)","v":""}]
[{"$f":"A89+1","v":17},"8.4.2","Type & Extent of control","Are preventive oriented systems used to assess suppliers or purchased materials conformance prior to production usage?","N/A",null,{"$f":"IF(F94&F95&F96&F97&F98=\"\",\"\",IF(F94=\"x\",$E$94,SUM(G95:G98)))","v":""},null,{"$f":"IF(H94&H95&H96&H97&H98=\"\",\"\",IF(H94=\"x\",$E$94,SUM(I95:I98)))","v":""},null,{"$f":"fillthegap(F94,H94,F95:F98,H95:H98)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Sub- suppliers are usually not involved in the development process. No evidence of a preventive system to ensure that the purchased components will meet the specifications.",null,null,{"$f":"IF(F95<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H95<>\"x\",\"\",0)","v":""}]
[null,null,null,"Some suppliers have been assessed prior of being sourced. Sub -supplier milestones are not included in the project plan. ",null,null,{"$f":"IF(F96<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H96<>\"x\",\"\",1)","v":""}]
[null,null,null,"For some suppliers a sub-supplier project tracking is being performed and included in the overall project plan. Sub-suppliers are assessed prior of being sourced.",null,null,{"$f":"IF(F97<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H97<>\"x\",\"\",2)","v":""}]
[null,null,null,"The sub-suppliers are assessed based on their technical capability and their capacity available prior sourcing. All suppliers/components are released prior SOP. ",null,null,{"$f":"IF(F98<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H98<>\"x\",\"\",3)","v":""}]
[{"$f":"A94+1","v":18},"9.1","Monitoring, measurement,  analyzis and evaluation","Is the gauging and measurement system used appropriate to the needs? ","N/A",null,{"$f":"IF(F99&F100&F101&F102&F103=\"\",\"\",IF(F99=\"x\",$E$99,SUM(G100:G103)))","v":""},null,{"$f":"IF(H99&H100&H101&H102&H103=\"\",\"\",IF(H99=\"x\",$E$99,SUM(I100:I103)))","v":""},null,{"$f":"fillthegap(F99,H99,F100:F103,H100:H103)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No measuring or monitoring devices are appropriate  (e.g. range vs. tolerance)",null,null,{"$f":"IF(F100<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H100<>\"x\",\"\",0)","v":""}]
[null,null,null,"Some measuring or monitoring devices are appropriate. Results are not analyzed and used for improvement",null,null,{"$f":"IF(F101<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H101<>\"x\",\"\",1)","v":""}]
[null,null,null,"All measuring and monitoring devices are appropriate. Results are used for improvement. Statistical methods are not used even if the need is there.",null,null,{"$f":"IF(F102<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H102<>\"x\",\"\",2)","v":""}]
[null,null,null,"Measuring or monitoring devices are appropriate and statistical method are used for analyze and improvement. ",null,null,{"$f":"IF(F103<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H103<>\"x\",\"\",3)","v":""}]
[null,null,null,"Production"]
[{"$f":"A99+1","v":19},"7.1.3","Infrastructure","Does the Supplier have a comprehensive Emergency planning?","N/A",null,{"$f":"IF(F105&F106&F107&F108&F109=\"\",\"\",IF(F105=\"x\",$E$105,SUM(G106:G109)))","v":""},null,{"$f":"IF(H105&H106&H107&H108&H109=\"\",\"\",IF(H105=\"x\",$E$105,SUM(I106:I109)))","v":""},null,{"$f":"fillthegap(F105,H105,F106:F109,H106:H109)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No plan for emergencies. Emergency activities are determined on an as needed basis.",null,null,{"$f":"IF(F106<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H106<>\"x\",\"\",0)","v":""}]
[null,null,null,"There is a basic emergency plan existing, mainly covering legal requirements. Key areas (i.e. IT systems; natural catastrophe; production equipment break down) are not considered. A responsible person has been named.",null,null,{"$f":"IF(F107<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H107<>\"x\",\"\",1)","v":""}]
[null,null,null,"There is an emergency plan considering Logistics (i.e. traceability, security stock), Production/ Manufacturing (Spare parts management for manufacturing, Spare equipment etc.). Teams are established for each area.",null,null,{"$f":"IF(F108<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H108<>\"x\",\"\",2)","v":""}]
[null,null,null,"There is an emergency plan considering Logistics (i.e. traceability, security stock), IT systems (Backup strategy, flash protection), Production Manufacturing (Spare parts management, Spare equipment etc.), Natural Catastrophe (Fire detection/ protection system; Associated company where parts can be produced etc.). Teams are established of each of these key areas.",null,null,{"$f":"IF(F109<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H109<>\"x\",\"\",3)","v":""}]
[{"$f":"A105+1","v":20},"7.1.3","Infrastructure","Does the organization have a process to adequately train their employees, evaluate competency, to deploy qualified resources  manufacturing processes including the new employee training?","N/A",null,{"$f":"IF(F110&F111&F112&F113&F114=\"\",\"\",IF(F110=\"x\",$E$110,SUM(G111:G114)))","v":""},null,{"$f":"IF(H110&H111&H112&H113&H114=\"\",\"\",IF(H110=\"x\",$E$110,SUM(I111:I114)))","v":""},null,{"$f":"fillthegap(F110,H110,F111:F114,H111:H114)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No training and skill matrix procedures, records exist.",null,null,{"$f":"IF(F111<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H111<>\"x\",\"\",0)","v":""}]
[null,null,null,"Skill Matrix requirements are partially available but no evidence for training and effectiveness monitoring system in place. ",null,null,{"$f":"IF(F112<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H112<>\"x\",\"\",1)","v":""}]
[null,null,null,"Skill Matrices are available for critical resources and for those a training effectiveness monitoring system is in place. ",null,null,{"$f":"IF(F113<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H113<>\"x\",\"\",2)","v":""}]
[null,null,null,"All business functions skill matrices in place. Annual training plan and execution system along with tracking mechanism in place. Verification process for training effectiveness and competency tracking system in order to include new employees.",null,null,{"$f":"IF(F114<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H114<>\"x\",\"\",3)","v":""}]
[{"$f":"A110+1","v":21},"7.1.4 & 8.2.3","Environment for the operation of processes ","Are all processes carried out under controlled conditions and do Job / Set-up Instructions detail the required process activity?","N/A",null,{"$f":"IF(F115&F116&F117&F118&F119=\"\",\"\",IF(F115=\"x\",$E$115,SUM(G116:G119)))","v":""},null,{"$f":"IF(H115&H116&H117&H118&H119=\"\",\"\",IF(H115=\"x\",$E$115,SUM(I116:I119)))","v":""},null,{"$f":"fillthegap(F115,H115,F116:F119,H116:H119)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No or only few work instructions exist and are accurate.",null,null,{"$f":"IF(F116<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H116<>\"x\",\"\",0)","v":""}]
[null,null,null,"Work Instructions and set-up instructions are available at the work station; If appropriate, statistical verification is used for some characteristics.",null,null,{"$f":"IF(F117<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H117<>\"x\",\"\",1)","v":""}]
[null,null,null,"Work and Set-up instructions are updated and in use; The instructions can be linked to the operation name and number; Job set-ups are verified through first-offs; All key process and product characteristics are monitored and are in control.",null,null,{"$f":"IF(F118<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H118<>\"x\",\"\",2)","v":""}]
[null,null,null,"Instructions are reviewed on a planned and regular basis for improved efficiency and to reduce process variation; The supplier can demonstrate a continuous improvement effort.",null,null,{"$f":"IF(F119<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H119<>\"x\",\"\",3)","v":""}]
[{"$f":"A115+1","v":22},"8.1 / 8.2.3 / 8.2.4","Requirements for Products and Services ","Do all processes considered unstable and / or incapable have controls implemented with verifiable reaction plans?","N/A",null,{"$f":"IF(F120&F121&F122&F123&F124=\"\",\"\",IF(F120=\"x\",$E$120,SUM(G121:G124)))","v":""},null,{"$f":"IF(H120&H121&H122&H123&H124=\"\",\"\",IF(H120=\"x\",$E$120,SUM(I121:I124)))","v":""},null,{"$f":"fillthegap(F120,H120,F121:F124,H121:H124)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Unstable processes are addressed for customer complaints only; A procedure for reacting to out-of-control processes exists but is not completely followed.",null,null,{"$f":"IF(F121<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H121<>\"x\",\"\",0)","v":""}]
[null,null,null,"Unstable processes are identified and short term fixes are implemented; No specific permanent actions are developed.",null,null,{"$f":"IF(F122<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H122<>\"x\",\"\",1)","v":""}]
[null,null,null,"There is proper identification of, and well-documented reaction to process instability in all observed examples; Effective containment actions and specific improvement plans exist for all incapable processes.",null,null,{"$f":"IF(F123<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H123<>\"x\",\"\",2)","v":""}]
[null,null,null,"Historical and thorough interpretation of data patterns exists; Evidence, also, shows that proven corrective actions are implemented on similar processes throughout the supplier's organization, if applicable.",null,null,{"$f":"IF(F124<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H124<>\"x\",\"\",3)","v":""}]
[{"$f":"A120+1","v":23},"8.2.3","Validation of processes for production and service provision","How are the important production parameters controlled?","N/A",null,{"$f":"IF(F125&F126&F127&F128&F129=\"\",\"\",IF(F125=\"x\",$E$125,SUM(G126:G129)))","v":""},null,{"$f":"IF(H125&H126&H127&H128&H129=\"\",\"\",IF(H125=\"x\",$E$125,SUM(I126:I129)))","v":""},null,{"$f":"fillthegap(F125,H125,F126:F129,H126:H129)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Important parameter are not defined and / or controlled.",null,null,{"$f":"IF(F126<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H126<>\"x\",\"\",0)","v":""}]
[null,null,null,"There is no process to determine key process parameters. Limits for process parameters are established on an as needed basis. Not all necessary equipment is safe guarded to protect from un-intended modification. Software utilized is not controlled and/ or there is no documentation available of changes made.",null,null,{"$f":"IF(F127<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H127<>\"x\",\"\",1)","v":""}]
[null,null,null,"Key process parameters are mainly determined according to customer requirements. Most equipment is safe guarded to prevent from not authorized changes. Control limits are determined but not all are documented and/ or followed. Not all changes made are properly documented.",null,null,{"$f":"IF(F128<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H128<>\"x\",\"\",2)","v":""}]
[null,null,null,"All key process parameters are documented with defined limits. They are determined according to customer requirements and internal requirements. Changes made are documented and authorized. Changes can only be made by authorized personnel.",null,null,{"$f":"IF(F129<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H129<>\"x\",\"\",3)","v":""}]
[{"$f":"A125+1","v":24},"8.1 / 8.3.1","Quality plan","Does the quality plan outline all designated characteristics and significant process parameters and are the required tests performed according to the quality plan?","N/A",null,{"$f":"IF(F130&F131&F132&F133&F134=\"\",\"\",IF(F130=\"x\",$E$130,SUM(G131:G134)))","v":""},null,{"$f":"IF(H130&H131&H132&H133&H134=\"\",\"\",IF(H130=\"x\",$E$130,SUM(I131:I134)))","v":""},null,{"$f":"fillthegap(F130,H130,F131:F134,H131:H134)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Quality plans are not existing",null,null,{"$f":"IF(F131<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H131<>\"x\",\"\",0)","v":""}]
[null,null,null,"Quality plans exist for some processes. Not all tests and verifications are performed as outlined in the quality plans. The control didn’t completely reflect the actual process flow. There is little knowledge of the quality plan by affected personnel and minimal monitoring of adherence to the plan.",null,null,{"$f":"IF(F132<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H132<>\"x\",\"\",1)","v":""}]
[null,null,null,"Quality plans exist for all processes but are not implemented in all areas. Several Quality plans where not updated and/ or didn’t reflect the current methods of control used in the process. Only key personnel have knowledge and use the Quality plan.  Monitoring of adherence to the plan is frequent but reactions for out of control conditions are not always appropriate.",null,null,{"$f":"IF(F133<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H133<>\"x\",\"\",2)","v":""}]
[null,null,null,"Quality plans are properly completed, current and in use by all affected personnel; All customer-designated characteristics and/or process parameters are statistically studied, with the addition of supplier-defined significant items; Monitoring of adherence to the plan is frequent and the reactions for out of control conditions are appropriate and conclusive.",null,null,{"$f":"IF(F134<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H134<>\"x\",\"\",3)","v":""}]
[{"$f":"A130+1","v":25},"8.4.2","Verification of purchased product","How is the performance of sub-suppliers monitored and ensured in serial production including the respective complaint handling?","N/A",null,{"$f":"IF(F135&F136&F137&F138&F139=\"\",\"\",IF(F135=\"x\",$E$135,SUM(G136:G139)))","v":""},null,{"$f":"IF(H135&H136&H137&H138&H139=\"\",\"\",IF(H135=\"x\",$E$135,SUM(I136:I139)))","v":""},null,{"$f":"fillthegap(F135,H135,F136:F139,H136:H139)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"The performance of sub-suppliers is not monitored. Complaint handling is not working.",null,null,{"$f":"IF(F136<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H136<>\"x\",\"\",0)","v":""}]
[null,null,null,"Sub-suppliers are evaluated occasionally, mainly driven through actual problems with the suppliers.",null,null,{"$f":"IF(F137<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H137<>\"x\",\"\",1)","v":""}]
[null,null,null,"There is a basic supplier evaluation system counting supplier incidents/ ppm. The system however is not utilized to evaluate trends/ improvements. Complaints to sub-suppliers are communicated in writing, however only occasionally corrective actions are requested and usually they are not followed up.",null,null,{"$f":"IF(F138<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H138<>\"x\",\"\",2)","v":""}]
[null,null,null,"There supplier evaluation system considering logistics/ quality key indicators. The system is utilized to determine continuous improvement activities and serves as direct input for further sourcing decisions. Each complaint to sub-suppliers requires a written response in form of an 8D. Responses are tracked and analyzed",null,null,{"$f":"IF(F139<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H139<>\"x\",\"\",3)","v":""}]
[{"$f":"A135+1","v":26},"8.7","Control of nonconformity","How is nonconforming material from the production process properly identified, securely segregated, and promptly re-supplied?","N/A",null,{"$f":"IF(F140&F141&F142&F143&F144=\"\",\"\",IF(F140=\"x\",$E$140,SUM(G141:G144)))","v":""},null,{"$f":"IF(H140&H141&H142&H143&H144=\"\",\"\",IF(H140=\"x\",$E$140,SUM(I141:I144)))","v":""},null,{"$f":"fillthegap(F140,H140,F141:F144,H141:H144)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Nonconforming materials, and/or their holding areas, are not properly identified; Procedure seems not to exist or is not applied at all.",null,null,{"$f":"IF(F141<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H141<>\"x\",\"\",0)","v":""}]
[null,null,null,"Nonconforming materials and the holding area are properly identified; Documentation of nonconforming material situations is inadequate (Pareto, analyzis, timely disposition, identification of repetitive problems etc.)",null,null,{"$f":"IF(F142<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H142<>\"x\",\"\",1)","v":""}]
[null,null,null,"Nonconforming material is identified and segregated in a well-marked hold area; Disposition does not occur always on a timely basis. Documentation of nonconforming material situations is adequate.",null,null,{"$f":"IF(F143<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H143<>\"x\",\"\",2)","v":""}]
[null,null,null,"All material found to be nonconforming are properly identified and removed from processing functions by segregation in identified holding areas; Disposition occur promptly. Documentation is indicating that progress has been made in reducing the frequency and volume of repetitive failures.",null,null,{"$f":"IF(F144<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H144<>\"x\",\"\",3)","v":""}]
[{"$f":"A140+1","v":27},"10.2","Preventive and corrective actions","What are the suppliers' formalized problem solving techniques to resolve both internally and externally identified problems?","N/A",null,{"$f":"IF(F145&F146&F147&F148&F149=\"\",\"\",IF(F145=\"x\",$E$145,SUM(G146:G149)))","v":""},null,{"$f":"IF(H145&H146&H147&H148&H149=\"\",\"\",IF(H145=\"x\",$E$145,SUM(I146:I149)))","v":""},null,{"$f":"fillthegap(F145,H145,F146:F149,H146:H149)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Problem solving activities are poorly documented by the supplier; quality concern communication is mostly verbal.",null,null,{"$f":"IF(F146<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H146<>\"x\",\"\",0)","v":""}]
[null,null,null,"Problem solving practices are partly successful in defining root causes, but corrective actions are not usually sufficient; A satisfactory quality concern communication system exists, but is not fully utilized.",null,null,{"$f":"IF(F147<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H147<>\"x\",\"\",1)","v":""}]
[null,null,null,"Problem solving practices are successful in defining root causes and corrective actions are sufficient; A satisfactory quality concern communication system exists and is fully utilized; The verification of the effectiveness of counter measures is not fully performed.",null,null,{"$f":"IF(F148<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H148<>\"x\",\"\",2)","v":""}]
[null,null,null,"Problem solving is working well; Effectiveness of measures are followed; Technical capabilities to analyze internal and external problems is demonstrated; Lessons learned activity properly applied.  Quality documentation updated as appropriate based on corrective actions taken (FMEA/control plan/WI, etc.)",null,null,{"$f":"IF(F149<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H149<>\"x\",\"\",3)","v":""}]
[{"$f":"A145+1","v":28},"8.5.2","Identification and traceability","Can finished goods be traced to raw materials and components through manufacturing dates or lots?","N/A",null,{"$f":"IF(F150&F151&F152&F153&F154=\"\",\"\",IF(F150=\"x\",$E$150,SUM(G151:G154)))","v":""},null,{"$f":"IF(H150&H151&H152&H153&H154=\"\",\"\",IF(H150=\"x\",$E$150,SUM(I151:I154)))","v":""},null,{"$f":"fillthegap(F150,H150,F151:F154,H151:H154)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no traceability system defined.",null,null,{"$f":"IF(F151<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H151<>\"x\",\"\",0)","v":""}]
[null,null,null,"A traceability system is defined, and implemented. The system does not incorporate purchased components. FIFO is not in all cases ensured.",null,null,{"$f":"IF(F152<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H152<>\"x\",\"\",1)","v":""}]
[null,null,null,"Tracing is possible in all reviewed cases. The system also roughly covers all major purchased items. Lot identification codes (including chipped lots) are traceable to actual date and/ or shift of manufacture. The FIFO principle is followed.",null,null,{"$f":"IF(F153<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H153<>\"x\",\"\",2)","v":""}]
[null,null,null,"All purchased components/ materials are assigned a lot or control number upon receipt to identify time periods and points of usage. The tracing to the individual finished product is possible.",null,null,{"$f":"IF(F154<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H154<>\"x\",\"\",3)","v":""}]
[{"$f":"A150+1","v":29},"8.5.2","Identification and traceability","How is the material identified as to its manufacturing stage, inspection, and/or test status throughout all phases of processing?","N/A",null,{"$f":"IF(F155&F156&F157&F158&F159=\"\",\"\",IF(F155=\"x\",$E$155,SUM(G156:G159)))","v":""},null,{"$f":"IF(H155&H156&H157&H158&H159=\"\",\"\",IF(H155=\"x\",$E$155,SUM(I156:I159)))","v":""},null,{"$f":"fillthegap(F155,H155,F156:F159,H156:H159)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"There is no defined and proper identification system in place.",null,null,{"$f":"IF(F156<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H156<>\"x\",\"\",0)","v":""}]
[null,null,null,"An acceptable material identification system exists, but physical it is not followed in all cases.",null,null,{"$f":"IF(F157<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H157<>\"x\",\"\",1)","v":""}]
[null,null,null,"A thorough material identification system is in place and followed in most instances. Some unsatisfactory conditions still exist, and a few items can be found that were inadequately identified.",null,null,{"$f":"IF(F158<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H158<>\"x\",\"\",2)","v":""}]
[null,null,null,"Procedures describing the method of in-process material identification are outlined and implemented; This includes provisions for material removed from the normal processing flow for any reason.",null,null,{"$f":"IF(F159<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H159<>\"x\",\"\",3)","v":""}]
[{"$f":"A155+1","v":30},"8.7 / 10.2","Control of nonconforming product","How is the rework of non-conforming product organized? Is it established in accordance to reclamation procedures and evaluated for conformance to all specifications?","N/A",null,{"$f":"IF(F160&F161&F162&F163&F164=\"\",\"\",IF(F160=\"x\",$E$160,SUM(G161:G164)))","v":""},null,{"$f":"IF(H160&H161&H162&H163&H164=\"\",\"\",IF(H160=\"x\",$E$160,SUM(I161:I164)))","v":""},null,{"$f":"fillthegap(F160,H160,F161:F164,H161:H164)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Rework activities take place but are not managed, compliance to spec is not ensured. Only verbal communication.",null,null,{"$f":"IF(F161<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H161<>\"x\",\"\",0)","v":""}]
[null,null,null,"Minimal reclamation procedures are drafted and utilized, but are still deficient. Reworked material is audited, but there is no official plan/ goal to reduce rework. Rework costs are not tracked. Traceability is not properly ensured.",null,null,{"$f":"IF(F162<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H162<>\"x\",\"\",1)","v":""}]
[null,null,null,"Rework operations are inspected 100%. Documented rework standards are available as needed and the planned rework processes are released; Parts are properly identified for traceability; A rework reduction plan (including costs) has been developed but is not completely implement;",null,null,{"$f":"IF(F163<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H163<>\"x\",\"\",2)","v":""}]
[null,null,null,"All repair and rework functions follow documented procedures, and customer approval of rework affecting designated characteristics is obtained prior to commencement. Rework integrity is verified to customer requirements through 100% inspection and/or testing. Rework reduction programs are being implemented and documented.",null,null,{"$f":"IF(F164<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H164<>\"x\",\"\",3)","v":""}]
[{"$f":"A160+1","v":31},"9.1.3","Monitoring and measurement of product","Are product and process verification results documented and can they be related to respective product / lots / production dates?","N/A",null,{"$f":"IF(F165&F166&F167&F168&F169=\"\",\"\",IF(F165=\"x\",$E$165,SUM(G166:G169)))","v":""},null,{"$f":"IF(H165&H166&H167&H168&H169=\"\",\"\",IF(H165=\"x\",$E$165,SUM(I166:I169)))","v":""},null,{"$f":"fillthegap(F165,H165,F166:F169,H166:H169)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Audit / inspection and/or test activity reports are not available for review.",null,null,{"$f":"IF(F166<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H166<>\"x\",\"\",0)","v":""}]
[null,null,null,"Some audit / inspection and/or test activity reports are available for review; but cannot be traced to specific lot or component.",null,null,{"$f":"IF(F167<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H167<>\"x\",\"\",1)","v":""}]
[null,null,null,"Internal procedure exists. Most audits / inspection and/or test activities are recorded and can be traced to specific lots or components.",null,null,{"$f":"IF(F168<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H168<>\"x\",\"\",2)","v":""}]
[null,null,null,"Evidence indicates that all product and process verifications are correctly performed and documented. Process audits reports are documented with respective corrective actions.",null,null,{"$f":"IF(F169<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H169<>\"x\",\"\",3)","v":""}]
[{"$f":"A165+1","v":32},"9.1.3","Control of monitoring and measuring devices","Is a timely calibration of all checking devices ensured and are respective records available?","N/A",null,{"$f":"IF(F170&F171&F172&F173&F174=\"\",\"\",IF(F170=\"x\",$E$170,SUM(G171:G174)))","v":""},null,{"$f":"IF(H170&H171&H172&H173&H174=\"\",\"\",IF(H170=\"x\",$E$170,SUM(I171:I174)))","v":""},null,{"$f":"fillthegap(F170,H170,F171:F174,H171:H174)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Procedure for the calibration of checking devices does not exist. Equipment is not verified.",null,null,{"$f":"IF(F171<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H171<>\"x\",\"\",0)","v":""}]
[null,null,null,"Procedure exist but not all the checking devices are not up to date. Interval for scheduled checks is not respected.",null,null,{"$f":"IF(F172<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H172<>\"x\",\"\",1)","v":""}]
[null,null,null,"Gage records are complete; In some instances, the equipment has not been calibrated at the scheduled intervals, but counter measures have been taken.",null,null,{"$f":"IF(F173<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H173<>\"x\",\"\",2)","v":""}]
[null,null,null,"Records indicate that all applicable measurement and test equipment is positively identified and calibrated with a national standards basis within prescribed time frames.",null,null,{"$f":"IF(F174<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H174<>\"x\",\"\",3)","v":""}]
[{"$f":"A170+1","v":33},"7.1.4 / 7.1.5","Work environment & control of production and service provision","Is the plant's work environment and maintenance activities conducive to quality improvements?","N/A",null,{"$f":"IF(F175&F176&F177&F178&F179=\"\",\"\",IF(F175=\"x\",$E$175,SUM(G176:G179)))","v":""},null,{"$f":"IF(H175&H176&H177&H178&H179=\"\",\"\",IF(H175=\"x\",$E$175,SUM(I176:I179)))","v":""},null,{"$f":"fillthegap(F175,H175,F176:F179,H176:H179)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Maintenance is not existing and / or work environment is not good. This may have a negative effect on the product quality.",null,null,{"$f":"IF(F176<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H176<>\"x\",\"\",0)","v":""}]
[null,null,null,"Supplier management has provided the necessary tools for environmental, housekeeping, and maintenance activities, but evidence indicates the implementation is inconsistent. (I.e. maintenance not conducted on time/ tools stored inappropriate conditions etc.)",null,null,{"$f":"IF(F177<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H177<>\"x\",\"\",1)","v":""}]
[null,null,null,"The environmental, house keeping, and maintenance activities are adequate; Programs, including the tracking of key indicators, have been established resulting in improvements in most areas.",null,null,{"$f":"IF(F178<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H178<>\"x\",\"\",2)","v":""}]
[null,null,null,"The environmental, house keeping, and maintenance activities are adequate; Programs including the tracking of key indicators have been established. It is visible that the work environment and related activities are a priority in the organization.",null,null,{"$f":"IF(F179<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H179<>\"x\",\"\",3)","v":""}]
[{"$f":"A175+1","v":34},"8.5.4","Preservation","Are the methods for handling, storage and delivery of material appropriate to ensure the product quality?","N/A",null,{"$f":"IF(F180&F181&F182&F183&F184=\"\",\"\",IF(F180=\"x\",$E$180,SUM(G181:G184)))","v":""},null,{"$f":"IF(H180&H181&H182&H183&H184=\"\",\"\",IF(H180=\"x\",$E$180,SUM(I181:I184)))","v":""},null,{"$f":"fillthegap(F180,H180,F181:F184,H181:H184)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"The suppliers' storage and handling conditions are inappropriate to ensure the product quality during storage, transport and delivery (i.e. multiple cases of damaged packaging in the storage/ production area; obsolete material in stores etc.)",null,null,{"$f":"IF(F181<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H181<>\"x\",\"\",0)","v":""}]
[null,null,null,"Appropriate processes have been established but there are some cases where the processes are not followed (excessive inventory, damaged packaging, no regular evaluation of storage conditions). The delivery performance of the supplier is not monitored/ or utilized for improvements.",null,null,{"$f":"IF(F182<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H182<>\"x\",\"\",1)","v":""}]
[null,null,null,"The suppliers' storage and handling conditions are appropriate. The condition of products/ material in the storage area is regularly evaluated. The delivery performance is monitored.",null,null,{"$f":"IF(F183<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H183<>\"x\",\"\",2)","v":""}]
[null,null,null,"The suppliers' storage and handling conditions are appropriate. The condition of products/ material in the storage area is regularly evaluated. Evaluations are used to minimize stock and to optimize inventory turns. The delivery performance is monitored and improvements are evident.",null,null,{"$f":"IF(F184<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H184<>\"x\",\"\",3)","v":""}]
[{"$f":"A180+1","v":35},"8.2.1","Customer communication","Can appropriate communication with the customer be assured by the supplier?","N/A",null,{"$f":"IF(F185&F186&F187&F188&F189=\"\",\"\",IF(F185=\"x\",$E$185,SUM(G186:G189)))","v":""},null,{"$f":"IF(H185&H186&H187&H188&H189=\"\",\"\",IF(H185=\"x\",$E$185,SUM(I186:I189)))","v":""},null,{"$f":"fillthegap(F185,H185,F186:F189,H186:H189)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"Basic communication systems exist (E-Mail, FAX). Some supplier's reference contacts speak basic English. Communication is mainly assured through an interpreter.",null,null,{"$f":"IF(F186<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H186<>\"x\",\"\",0)","v":""}]
[null,null,null,"Some required communication systems need still to be established (i.e. Logistics ordering systems/EDI capable, etc.). Not in all supplier's key departments (Logistics, Quality, Production, engineering, sales) the communication can be assured in English.",null,null,{"$f":"IF(F187<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H187<>\"x\",\"\",1)","v":""}]
[null,null,null,"Required communication systems at the supplier are established (i.e. CAD, Logistics ordering systems/EDI capable, etc.). In supplier's key departments (Logistics, Quality, Production, engineering, sales)  appropriate communication in English is assured. ",null,null,{"$f":"IF(F188<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H188<>\"x\",\"\",2)","v":""}]
[null,null,null,"Required communication systems at the supplier are established (i.e. CAD, Logistics ordering systems/EDI capable, etc.). In supplier's key departments (Logistics, Quality, Production, engineering, sales) appropriate communication in English is assured without interpreter also in the case when certain key contacts are not available.",null,null,{"$f":"IF(F189<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H189<>\"x\",\"\",3)","v":""}]
[null,null,null,"Production Control & Logistics"]
[{"$f":"A185+1","v":36},"8.5.1","Production Plan","Is a production plan established, followed and updated according to the customer demand and actual deliveries?/Is a internal ordering plan established, followed and updated according to the customer demand and actual deliveries? ","N/A",null,{"$f":"IF(F191&F192&F193&F194&F195=\"\",\"\",IF(F191=\"x\",$E$191,SUM(G192:G195)))","v":""},null,{"$f":"IF(H191&H192&H193&H194&H195=\"\",\"\",IF(H191=\"x\",$E$191,SUM(I192:I195)))","v":""},null,{"$f":"fillthegap(F191,H191,F192:F195,H192:H195)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No followed/updated production plan",null,null,{"$f":"IF(F192<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H192<>\"x\",\"\",0)","v":""}]
[null,null,null,"Actual production plan based on the time frame of the customer demand/forecast",null,null,{"$f":"IF(F193<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H193<>\"x\",\"\",1)","v":""}]
[null,null,null,"Production plan regularly updated (e.g. monthly or weekly) according to the backlog/inventory of finished goods",null,null,{"$f":"IF(F194<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H194<>\"x\",\"\",2)","v":""}]
[null,null,null,"Updated production plan tracked, and active action plans in order to insure the production deadlines",null,null,{"$f":"IF(F195<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H195<>\"x\",\"\",3)","v":""}]
[{"$f":"A191+1","v":37},null,"Material planning","Is a material planning process (order of raw material) in place, based on the production plan or based on the real consumption (pull flow)?","N/A",null,{"$f":"IF(F196&F197&F198&F199&F200=\"\",\"\",IF(F196=\"x\",$E$196,SUM(G197:G200)))","v":""},null,{"$f":"IF(H196&H197&H198&H199&H200=\"\",\"\",IF(H196=\"x\",$E$196,SUM(I197:I200)))","v":""},null,{"$f":"fillthegap(F196,H196,F197:F200,H197:H200)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No existing material planning or only based on the customer forecast",null,null,{"$f":"IF(F197<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H197<>\"x\",\"\",0)","v":""}]
[null,null,null,"Material planning based on the actual raw material inventory and the production plan or the actual customer demand",null,null,{"$f":"IF(F198<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H198<>\"x\",\"\",1)","v":""}]
[null,null,null,"Standard process for material procurement including warning system to prevent any material shortage",null,null,{"$f":"IF(F199<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H199<>\"x\",\"\",2)","v":""}]
[null,null,null,"Optimization of the raw material Lead Time (i.e. actions for shortening Lead Time); Pull flow in place for the standard material and/or procurement directly linked with the production plan (i.e. Just-In-Time supply)",null,null,{"$f":"IF(F200<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H200<>\"x\",\"\",3)","v":""}]
[{"$f":"A196+1","v":38},null,"Lead Time","Is the Lead Time considered as a determinative manufacturing data for flow improvement?","N/A",null,{"$f":"IF(F201&F202&F203&F204&F205=\"\",\"\",IF(F201=\"x\",$E$201,SUM(G202:G205)))","v":""},null,{"$f":"IF(H201&H202&H203&H204&H205=\"\",\"\",IF(H201=\"x\",$E$201,SUM(I202:I205)))","v":""},null,{"$f":"fillthegap(F201,H201,F202:F205,H202:H205)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No Lead Time defined or calculated",null,null,{"$f":"IF(F202<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H202<>\"x\",\"\",0)","v":""}]
[null,null,null,"Work In Process (WIP) planned and partially controlled in the production area; cycle times of the production steps are planned/estimated",null,null,{"$f":"IF(F203<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H203<>\"x\",\"\",1)","v":""}]
[null,null,null,"A Value Stream Map (VSM) has been done, the Dock-to-dock Lead Time and process cycle-times are regularly controlled",null,null,{"$f":"IF(F204<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H204<>\"x\",\"\",2)","v":""}]
[null,null,null,"Dock-to-dock Value Stream Mapping (VSM) including total Lead Time calculation; action plan established and on-going in order to reduce the Lead Time (material and production)",null,null,{"$f":"IF(F205<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H205<>\"x\",\"\",3)","v":""}]
[{"$f":"A201+1","v":39},null,"Capacity Efficiency","Is the production capacity calculated and practically improved (efficiency)?/Is the Ordering Process calculated and practically improved (efficiency)?","N/A",null,{"$f":"IF(F206&F207&F208&F209&F210=\"\",\"\",IF(F206=\"x\",$E$206,SUM(G207:G210)))","v":""},null,{"$f":"IF(H206&H207&H208&H209&H210=\"\",\"\",IF(H206=\"x\",$E$206,SUM(I207:I210)))","v":""},null,{"$f":"fillthegap(F206,H206,F207:F210,H207:H210)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No availability or efficiency rate observed",null,null,{"$f":"IF(F207<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H207<>\"x\",\"\",0)","v":""}]
[null,null,null,"Bottlenecks are identified and their actual availability is tracked",null,null,{"$f":"IF(F208<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H208<>\"x\",\"\",1)","v":""}]
[null,null,null,"The tracking includes a distinction between planned and unplanned stops",null,null,{"$f":"IF(F209<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H209<>\"x\",\"\",2)","v":""}]
[null,null,null,"Inefficiency causes are categorized and analyzed; an action plan shows the corrective actions aiming to increase the machine efficiency",null,null,{"$f":"IF(F210<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H210<>\"x\",\"\",3)","v":""}]
[{"$f":"A206+1","v":40},null,"Supply Chain Efficiency","Is the Safety stock / Inventory Policy followed?","N/A",null,{"$f":"IF(F211&F212&F213&F214&F215=\"\",\"\",IF(F211=\"x\",$E$211,SUM(G212:G215)))","v":""},null,{"$f":"IF(H211&H212&H213&H214&H215=\"\",\"\",IF(H211=\"x\",$E$211,SUM(I212:I215)))","v":""},null,{"$f":"fillthegap(F211,H211,F212:F215,H212:H215)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No availability of safety stock or inventory policy observed",null,null,{"$f":"IF(F212<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H212<>\"x\",\"\",0)","v":""}]
[null,null,null,"Safety Stock or Inventory policy maintained as per customer demands",null,null,{"$f":"IF(F213<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H213<>\"x\",\"\",1)","v":""}]
[null,null,null,"The tracking includes a gap variance between planned and stock out situation",null,null,{"$f":"IF(F214<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H214<>\"x\",\"\",2)","v":""}]
[null,null,null,"Non-stock out situation causes are categorized and analyzed; an action plan shows the corrective actions aiming to increase the stock process efficiency",null,null,{"$f":"IF(F215<>\"x\",\"\",3)","v":""},null,{"$f":"IF(H215<>\"x\",\"\",3)","v":""}]
[null,null,null,"Operational control"]
[{"$f":"A211+1","v":41},"9.1.2 & 9.1.3","Key Performance Indicators","Is a comprehensive Key Performance Indicator (KPI) set in place for controlling the operations?","N/A",null,{"$f":"IF(F217&F218&F219&F220&F221=\"\",\"\",IF(F217=\"x\",$E$217,SUM(G218:G221)))","v":""},null,{"$f":"IF(H217&H218&H219&H220&H221=\"\",\"\",IF(H217=\"x\",$E$217,SUM(I218:I221)))","v":""},null,{"$f":"fillthegap(F217,H217,F218:F221,H218:H221)","v":"Dear supplier, enter an x in the appropriate line"}]
[null,null,null,"No KPI properly defined and followed",null,null,{"$f":"IF(F218<>\"x\",\"\",0)","v":""},null,{"$f":"IF(H218<>\"x\",\"\",0)","v":""}]
[null,null,null,"Some Manufacturing KPIs defined and followed-up",null,null,{"$f":"IF(F219<>\"x\",\"\",1)","v":""},null,{"$f":"IF(H219<>\"x\",\"\",1)","v":""}]
[null,null,null,"Base of a structured KPI system; i.e. the chosen KPIs are set up in a consistent scheme",null,null,{"$f":"IF(F220<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H220<>\"x\",\"\",2)","v":""}]
[null,null,null,"Scorecards including all main functions (Production, Logistics, Quality, Purchasing, Development, Finance) are defined (definition of the indicators, targets) and followed",null,null,{"$f":"IF(F221<>\"x\",\"\",2)","v":""},null,{"$f":"IF(H221<>\"x\",\"\",3)","v":""}]

{"sheet":"Riepilogo Dealer","index":6,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Group","ID","Min group ID","Max group ID","Label","Topic","Score","Self-assessment","% self","Score","Actual","% Actual","Findings","Remarks",null,null,null,null,null,null,"Choose Audit step",null,"Row Labels","Supplier Self-assessment ","Modine assessment"]
["Quality management system",{"$f":"'Questions - Dealer&Distributor'!$A$13","v":1},{"$f":"_xlfn.MINIFS(B:B,A:A,\"=\"&A2)","v":1},{"$f":"_xlfn.MAXIFS(B:B,A:A,\"=\"&A2)","v":4},{"$f":"IF(C2=D2,CONCATENATE(A2,\" \",\"(\",C2,\")\"),CONCATENATE(A2,\" \",\"(\",C2,\"-\",D2,\")\"))","v":"Quality management system (1-4)"},{"$f":"'Questions - Dealer&Distributor'!$C$13","v":"Certification status "},{"$f":"'Questions - Dealer&Distributor'!$G$13","v":""},{"$f":"IF(G2=\"N/A\",-1,G2)","v":""},{"$f":"IF(H2=-1,\"-\",IF(COUNT(H2)>=1,H2/3,\"-\"))","v":"-"},{"$f":"'Questions - Dealer&Distributor'!$I$13","v":""},{"$f":"IF(J2=\"N/A\",-1,J2)","v":""},{"$f":"IF(K2=-1,\"-\",IF(COUNT(K2)>=1,K2/3,\"-\"))","v":"-"},{"$f":"'Questions - Dealer&Distributor'!J14","v":0},{"$f":"'Questions - Dealer&Distributor'!K14","v":0},null,null,null,null,null,null,"Self-assessment",null,1,0,0]
["Quality management system",{"$f":"'Questions - Dealer&Distributor'!$A$18","v":2},1,4,{"$f":"IF(C3=D3,CONCATENATE(A3,\" \",\"(\",C3,\")\"),CONCATENATE(A3,\" \",\"(\",C3,\"-\",D3,\")\"))","v":"Quality management system (1-4)"},{"$f":"'Questions - Dealer&Distributor'!$C$18","v":"Organizational Roles, responsibilities and Authorities, Quality Objectives and planning to achieve them"},{"$f":"'Questions - Dealer&Distributor'!$G$18","v":""},{"$f":"IF(G3=\"N/A\",-1,G3)","v":""},{"$f":"IF(H3=-1,\"-\",IF(COUNT(H3)>=1,H3/3,\"-\"))","v":"-"},{"$f":"'Questions - Dealer&Distributor'!$I$18","v":""},"",{"$f":"IF(K3=-1,\"-\",IF(COUNT(K3)>=1,K3/3,\"-\"))","v":"-"},{"$f":"'Questions - Dealer&Distributor'!J19","v":0},{"$f":"'Questions - Dealer&Distributor'!K19","v":0},null,null,null,null,null,null,"Audit",null,2,0,0]
["Quality management system",{"$f":"'Questions - Dealer&Distributor'!$A$23","v":3},1,4,"Quality management system (1-4)",{"$f":"'Questions - Dealer&Distributor'!$C$23","v":"Control of documented information"},{"$f":"'Questions - Dealer&Distributor'!$G$23","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$23","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J24","v":0},{"$f":"'Questions - Dealer&Distributor'!K24","v":0},null,null,null,null,null,null,null,null,3,0,0]
["Quality management system",{"$f":"'Questions - Dealer&Distributor'!$A$28","v":4},1,4,"Quality management system (1-4)",{"$f":"'Questions - Dealer&Distributor'!$C$28","v":"Design and Development controls"},{"$f":"'Questions - Dealer&Distributor'!$G$28","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$28","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J29","v":0},{"$f":"'Questions - Dealer&Distributor'!K29","v":0},null,null,null,null,null,null,null,null,4,0,0]
["Contract review process",{"$f":"'Questions - Dealer&Distributor'!$A$34","v":5},5,9,"Contract review process (5-9)",{"$f":"'Questions - Dealer&Distributor'!$C$34","v":"Requirements for Products & services"},{"$f":"'Questions - Dealer&Distributor'!$G$34","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$34","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J35","v":0},{"$f":"'Questions - Dealer&Distributor'!K35","v":0},null,null,null,null,null,null,null,null,5,0,0]
["Contract review process",{"$f":"'Questions - Dealer&Distributor'!$A$39","v":6},5,9,"Contract review process (5-9)",{"$f":"'Questions - Dealer&Distributor'!$C$39","v":"Design and development controls"},{"$f":"'Questions - Dealer&Distributor'!$G$39","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$39","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J40","v":0},{"$f":"'Questions - Dealer&Distributor'!K40","v":0},null,null,null,null,null,null,null,null,6,0,0]
["Contract review process",{"$f":"'Questions - Dealer&Distributor'!$A$44","v":7},5,9,"Contract review process (5-9)",{"$f":"'Questions - Dealer&Distributor'!$C$44","v":"Preservation"},{"$f":"'Questions - Dealer&Distributor'!$G$44","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$44","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J45","v":0},{"$f":"'Questions - Dealer&Distributor'!K45","v":0},null,null,null,null,null,null,null,null,7,0,0]
["Contract review process",{"$f":"'Questions - Dealer&Distributor'!$A$49","v":8},5,9,"Contract review process (5-9)",{"$f":"'Questions - Dealer&Distributor'!$C$49","v":"Release of Products & services"},{"$f":"'Questions - Dealer&Distributor'!$G$49","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$49","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J50","v":0},{"$f":"'Questions - Dealer&Distributor'!K50","v":0},null,null,null,null,null,null,null,null,8,0,0]
["Contract review process",{"$f":"'Questions - Dealer&Distributor'!$A$54","v":9},5,9,"Contract review process (5-9)",{"$f":"'Questions - Dealer&Distributor'!$C$54","v":"Release of Products & services"},{"$f":"'Questions - Dealer&Distributor'!$G$54","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$54","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J55","v":0},{"$f":"'Questions - Dealer&Distributor'!K55","v":0},null,null,null,null,null,null,null,null,9,0,0]
["Supplier Management & Quality",{"$f":"'Questions - Dealer&Distributor'!$A$60","v":10},10,14,"Supplier Management & Quality (10-14)",{"$f":"'Questions - Dealer&Distributor'!$C$60","v":"Release of Products & services"},{"$f":"'Questions - Dealer&Distributor'!$G$60","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$60","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J61","v":0},{"$f":"'Questions - Dealer&Distributor'!K61","v":0},null,null,null,null,null,null,null,null,10,0,0]
["Supplier Management & Quality",{"$f":"'Questions - Dealer&Distributor'!$A$65","v":11},10,14,"Supplier Management & Quality (10-14)",{"$f":"'Questions - Dealer&Distributor'!$C$65","v":"Release of Products & services"},{"$f":"'Questions - Dealer&Distributor'!$G$65","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$65","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J66","v":0},{"$f":"'Questions - Dealer&Distributor'!K66","v":0},null,null,null,null,null,null,null,null,11,0,0]
["Supplier Management & Quality",{"$f":"'Questions - Dealer&Distributor'!$A$70","v":12},10,14,"Supplier Management & Quality (10-14)",{"$f":"'Questions - Dealer&Distributor'!$C$70","v":"Control of externally provided Processes, Products and Services"},{"$f":"'Questions - Dealer&Distributor'!$G$70","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$70","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J71","v":0},{"$f":"'Questions - Dealer&Distributor'!K71","v":0},null,null,null,null,null,null,null,null,12,0,0]
["Supplier Management & Quality",{"$f":"'Questions - Dealer&Distributor'!$A$75","v":13},10,14,"Supplier Management & Quality (10-14)",{"$f":"'Questions - Dealer&Distributor'!$C$75","v":"Verification of purchased product"},{"$f":"'Questions - Dealer&Distributor'!$G$75","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$75","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J76","v":0},{"$f":"'Questions - Dealer&Distributor'!K76","v":0},null,null,null,null,null,null,null,null,13,0,0]
["Supplier Management & Quality",{"$f":"'Questions - Dealer&Distributor'!$A$80","v":14},10,14,"Supplier Management & Quality (10-14)",{"$f":"'Questions - Dealer&Distributor'!$C$80","v":"Preventive and corrective actions"},{"$f":"'Questions - Dealer&Distributor'!$G$80","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$80","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J81","v":0},{"$f":"'Questions - Dealer&Distributor'!K81","v":0},null,null,null,null,null,null,null,null,14,0,0]
["Material planning & Logistics",{"$f":"'Questions - Dealer&Distributor'!$A$86","v":15},15,18,"Material planning & Logistics (15-18)",{"$f":"'Questions - Dealer&Distributor'!$C$86","v":"Inhouse Order Process"},{"$f":"'Questions - Dealer&Distributor'!$G$86","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$86","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J87","v":0},{"$f":"'Questions - Dealer&Distributor'!K87","v":0},null,null,null,null,null,null,null,null,15,0,0]
["Material planning & Logistics",{"$f":"'Questions - Dealer&Distributor'!$A$91","v":16},15,18,"Material planning & Logistics (15-18)",{"$f":"'Questions - Dealer&Distributor'!$C$91","v":"Lead Time"},{"$f":"'Questions - Dealer&Distributor'!$G$91","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$91","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J92","v":0},{"$f":"'Questions - Dealer&Distributor'!K92","v":0},null,null,null,null,null,null,null,null,16,0,0]
["Material planning & Logistics",{"$f":"'Questions - Dealer&Distributor'!$A$96","v":17},15,18,"Material planning & Logistics (15-18)",{"$f":"'Questions - Dealer&Distributor'!$C$96","v":"Supply Chain\nEfficiency"},{"$f":"'Questions - Dealer&Distributor'!$G$96","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$96","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J97","v":0},{"$f":"'Questions - Dealer&Distributor'!K97","v":0},null,null,null,null,null,null,null,null,17,0,0]
["Material planning & Logistics",{"$f":"'Questions - Dealer&Distributor'!$A$101","v":18},15,18,"Material planning & Logistics (15-18)",{"$f":"'Questions - Dealer&Distributor'!$C$101","v":"Supply Chain\nEfficiency"},{"$f":"'Questions - Dealer&Distributor'!$G$101","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!$I$101","v":""},"","-",{"$f":"'Questions - Dealer&Distributor'!J102","v":0},{"$f":"'Questions - Dealer&Distributor'!K102","v":0},null,null,null,null,null,null,null,null,18,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",0,0]

{"sheet":"Riepilogo","index":7,"n_rows":43,"n_cols":24,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Group","ID","Min group ID","Max group ID","Label","Topic","Score","Self-assessment","% self","Score","Mod assessment","% Actual","Findings","Remarks",null,null,null,null,1,"Choose Audit step",null,"Row Labels","Supplier self-assessment","Modine assessment"]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$13","v":1},{"$f":"_xlfn.MINIFS(B:B,A:A,\"=\"&A2)","v":1},{"$f":"_xlfn.MAXIFS(B:B,A:A,\"=\"&A2)","v":7},{"$f":"IF(C2=D2,CONCATENATE(A2,\" \",\"(\",C2,\")\"),CONCATENATE(A2,\" \",\"(\",C2,\"-\",D2,\")\"))","v":"Quality management system (1-7)"},{"$f":"'Questions - Manufacturing'!$C$13","v":"Certification status "},{"$f":"'Questions - Manufacturing'!$G$13","v":""},{"$f":"IF(G2=\"N/A\",-1,G2)","v":""},{"$f":"IF(H2=-1,\"-\",IF(COUNT(H2)>=1,H2/3,\"-\"))","v":"-"},{"$f":"'Questions - Manufacturing'!$I$13","v":""},{"$f":"IF(J2=\"N/A\",-1,J2)","v":""},{"$f":"IF(K2=-1,\"-\",IF(COUNT(K2)>=1,K2/3,\"-\"))","v":"-"},{"$f":"'Questions - Manufacturing'!J14","v":0},{"$f":"'Questions - Manufacturing'!K14","v":0},null,null,null,null,2,"Supplier self-assessment",null,1,0,0]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$18","v":2},1,7,{"$f":"IF(C3=D3,CONCATENATE(A3,\" \",\"(\",C3,\")\"),CONCATENATE(A3,\" \",\"(\",C3,\"-\",D3,\")\"))","v":"Quality management system (1-7)"},{"$f":"'Questions - Manufacturing'!$C$18","v":"organizational Roles, responsibilities and Authorities, Quality Objectives and planning to achieve them"},{"$f":"'Questions - Manufacturing'!$G$18","v":""},{"$f":"IF(G3=\"N/A\",-1,G3)","v":""},{"$f":"IF(H3=-1,\"-\",IF(COUNT(H3)>=1,H3/3,\"-\"))","v":"-"},{"$f":"'Questions - Manufacturing'!$I$18","v":""},{"$f":"IF(J3=\"N/A\",-1,J3)","v":""},{"$f":"IF(K3=-1,\"-\",IF(COUNT(K3)>=1,K3/3,\"-\"))","v":"-"},{"$f":"'Questions - Manufacturing'!J19","v":0},{"$f":"'Questions - Manufacturing'!K19","v":0},null,null,null,null,3,"Modine assessment",null,2,0,0]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$23","v":3},1,7,"Quality management system (1-7)",{"$f":"'Questions - Manufacturing'!$C$23","v":"Control of documented information"},{"$f":"'Questions - Manufacturing'!$G$23","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$23","v":""},{"$f":"IF(J4=\"N/A\",-1,J4)","v":""},"-",{"$f":"'Questions - Manufacturing'!J24","v":0},{"$f":"'Questions - Manufacturing'!K24","v":0},null,null,null,null,null,null,null,3,0,0]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$28","v":4},1,7,"Quality management system (1-7)",{"$f":"'Questions - Manufacturing'!$C$28","v":"Design and development changes"},{"$f":"'Questions - Manufacturing'!$G$28","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$28","v":""},"","-",{"$f":"'Questions - Manufacturing'!J29","v":0},{"$f":"'Questions - Manufacturing'!K29","v":0},null,null,null,null,1,"Choose Supplier Type",null,4,0,0]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$33","v":5},1,7,"Quality management system (1-7)",{"$f":"'Questions - Manufacturing'!$C$33","v":"Design and Development controls"},{"$f":"'Questions - Manufacturing'!$G$33","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$33","v":""},"","-",{"$f":"'Questions - Manufacturing'!J34","v":0},{"$f":"'Questions - Manufacturing'!K34","v":0},null,null,null,null,2,"Manufacturing",null,5,0,0]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$38","v":6},1,7,"Quality management system (1-7)",{"$f":"'Questions - Manufacturing'!$C$38","v":"Internal audit"},{"$f":"'Questions - Manufacturing'!$G$38","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$38","v":""},"","-",{"$f":"'Questions - Manufacturing'!J39","v":0},{"$f":"'Questions - Manufacturing'!K39","v":0},null,null,null,null,3,"Dealer&Distributor",null,6,0,0]
["Quality management system",{"$f":"'Questions - Manufacturing'!$A$43","v":7},1,7,"Quality management system (1-7)",{"$f":"'Questions - Manufacturing'!$C$43","v":"Continual improvement"},{"$f":"'Questions - Manufacturing'!$G$43","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$43","v":""},"","-",{"$f":"'Questions - Manufacturing'!J44","v":0},{"$f":"'Questions - Manufacturing'!K44","v":0},null,null,null,null,null,null,null,7,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$49","v":8},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$49","v":"Requirements for Products & services"},{"$f":"'Questions - Manufacturing'!$G$49","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$49","v":""},"","-",{"$f":"'Questions - Manufacturing'!J50","v":0},{"$f":"'Questions - Manufacturing'!K50","v":0},null,null,null,null,null,null,null,8,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$54","v":9},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$54","v":"Design & Development planning"},{"$f":"'Questions - Manufacturing'!$G$54","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$54","v":""},"","-",{"$f":"'Questions - Manufacturing'!J55","v":0},{"$f":"'Questions - Manufacturing'!K55","v":0},null,null,null,null,1,"Plant",null,9,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$59","v":10},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$59","v":"Design and development controls"},{"$f":"'Questions - Manufacturing'!$G$59","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$59","v":""},"","-",{"$f":"'Questions - Manufacturing'!J60","v":0},{"$f":"'Questions - Manufacturing'!K60","v":0},null,null,null,null,2,"Modine Amaro",null,10,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$64","v":11},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$64","v":"Design and development inputs / outputs"},{"$f":"'Questions - Manufacturing'!$G$64","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$64","v":""},"","-",{"$f":"'Questions - Manufacturing'!J65","v":0},{"$f":"'Questions - Manufacturing'!K65","v":0},null,null,null,null,3,"Modine Pocenia",null,11,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$69","v":12},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$69","v":"Design and development Outputs "},{"$f":"'Questions - Manufacturing'!$G$69","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$69","v":""},"","-",{"$f":"'Questions - Manufacturing'!J70","v":0},{"$f":"'Questions - Manufacturing'!K70","v":0},null,null,null,null,4,"Modine Guadalajara",null,12,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$74","v":13},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$74","v":"Preservation"},{"$f":"'Questions - Manufacturing'!$G$74","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$74","v":""},"","-",{"$f":"'Questions - Manufacturing'!J75","v":0},{"$f":"'Questions - Manufacturing'!K75","v":0},null,null,null,null,5,"Modine Torreglia",null,13,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$79","v":14},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$79","v":"Release of Products & services"},{"$f":"'Questions - Manufacturing'!$G$79","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$79","v":""},"","-",{"$f":"'Questions - Manufacturing'!J80","v":0},{"$f":"'Questions - Manufacturing'!K80","v":0},null,null,null,null,6,"Modine Sodekoping",null,14,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$84","v":15},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$84","v":"Release of Products & services"},{"$f":"'Questions - Manufacturing'!$G$84","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$84","v":""},"","-",{"$f":"'Questions - Manufacturing'!J85","v":0},{"$f":"'Questions - Manufacturing'!K85","v":0},null,null,null,null,7,"Modine Sr. Mitrovica, Serbia",null,15,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$89","v":16},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$89","v":"Control of externally provided Processes, Products and  Services"},{"$f":"'Questions - Manufacturing'!$G$89","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$89","v":""},"","-",{"$f":"'Questions - Manufacturing'!J90","v":0},{"$f":"'Questions - Manufacturing'!K90","v":0},null,null,null,null,null,null,null,16,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$94","v":17},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$94","v":"Type & Extent of control"},{"$f":"'Questions - Manufacturing'!$G$94","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$94","v":""},"","-",{"$f":"'Questions - Manufacturing'!J95","v":0},{"$f":"'Questions - Manufacturing'!K95","v":0},null,null,null,null,null,null,null,17,0,0]
["Design & Development for product and process",{"$f":"'Questions - Manufacturing'!$A$99","v":18},8,18,"Design & Development for product and process (8-18)",{"$f":"'Questions - Manufacturing'!$C$99","v":"Monitoring, measurement,  analyzis and evaluation"},{"$f":"'Questions - Manufacturing'!$G$99","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$99","v":""},"","-",{"$f":"'Questions - Manufacturing'!J100","v":0},{"$f":"'Questions - Manufacturing'!K100","v":0},null,null,null,null,null,null,null,18,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$105","v":19},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$105","v":"Infrastructure"},{"$f":"'Questions - Manufacturing'!$G$105","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$105","v":""},"","-",{"$f":"'Questions - Manufacturing'!J106","v":0},{"$f":"'Questions - Manufacturing'!K106","v":0},null,null,null,null,null,null,null,19,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$110","v":20},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$110","v":"Infrastructure"},{"$f":"'Questions - Manufacturing'!$G$110","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$110","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$111","v":0},{"$f":"'Questions - Manufacturing'!$K$111","v":0},null,null,null,null,null,null,null,20,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$115","v":21},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$115","v":"Environment for the operation of processes "},{"$f":"'Questions - Manufacturing'!$G$115","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$115","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$111","v":0},{"$f":"'Questions - Manufacturing'!$K$116","v":0},null,null,null,null,null,null,null,21,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$120","v":22},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$120","v":"Requirements for Products and Services "},{"$f":"'Questions - Manufacturing'!$G$120","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$120","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$111","v":0},{"$f":"'Questions - Manufacturing'!$K$121","v":0},null,null,null,null,null,null,null,22,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$125","v":23},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$125","v":"Validation of processes for production and service provision"},{"$f":"'Questions - Manufacturing'!$G$125","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$125","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$111","v":0},{"$f":"'Questions - Manufacturing'!$K$126","v":0},null,null,null,null,null,null,null,23,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$130","v":24},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$130","v":"Quality plan"},{"$f":"'Questions - Manufacturing'!$G$130","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$130","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$111","v":0},{"$f":"'Questions - Manufacturing'!$K$131","v":0},null,null,null,null,null,null,null,24,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$135","v":25},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$135","v":"Verification of purchased product"},{"$f":"'Questions - Manufacturing'!$G$135","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$135","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$136","v":0},{"$f":"'Questions - Manufacturing'!$K$136","v":0},null,null,null,null,null,null,null,25,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$140","v":26},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$140","v":"Control of nonconformity"},{"$f":"'Questions - Manufacturing'!$G$140","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$140","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$141","v":0},{"$f":"'Questions - Manufacturing'!$K$141","v":0},null,null,null,null,null,null,null,26,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$145","v":27},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$145","v":"Preventive and corrective actions"},{"$f":"'Questions - Manufacturing'!$G$145","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$145","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$146","v":0},{"$f":"'Questions - Manufacturing'!$K$146","v":0},null,null,null,null,null,null,null,27,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$150","v":28},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$150","v":"Identification and traceability"},{"$f":"'Questions - Manufacturing'!$G$150","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$150","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$151","v":0},{"$f":"'Questions - Manufacturing'!$K$151","v":0},null,null,null,null,null,null,null,28,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$155","v":29},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$155","v":"Identification and traceability"},{"$f":"'Questions - Manufacturing'!$G$155","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$155","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$156","v":0},{"$f":"'Questions - Manufacturing'!$K$156","v":0},null,null,null,null,null,null,null,29,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$160","v":30},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$160","v":"Control of nonconforming product"},{"$f":"'Questions - Manufacturing'!$G$160","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$160","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$161","v":0},{"$f":"'Questions - Manufacturing'!$K$161","v":0},null,null,null,null,null,null,null,30,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$165","v":31},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$165","v":"Monitoring and measurement of product"},{"$f":"'Questions - Manufacturing'!$G$165","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$165","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$166","v":0},{"$f":"'Questions - Manufacturing'!$K$166","v":0},null,null,null,null,null,null,null,31,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$170","v":32},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$170","v":"Control of monitoring and measuring devices"},{"$f":"'Questions - Manufacturing'!$G$170","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$170","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$171","v":0},{"$f":"'Questions - Manufacturing'!$K$171","v":0},null,null,null,null,null,null,null,32,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$175","v":33},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$175","v":"Work environment & control of production and service provision"},{"$f":"'Questions - Manufacturing'!$G$175","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$175","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$176","v":0},{"$f":"'Questions - Manufacturing'!$K$176","v":0},null,null,null,null,null,null,null,33,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$180","v":34},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$180","v":"Preservation"},{"$f":"'Questions - Manufacturing'!$G$180","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$180","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$181","v":0},{"$f":"'Questions - Manufacturing'!$K$181","v":0},null,null,null,null,null,null,null,34,0,0]
["Production",{"$f":"'Questions - Manufacturing'!$A$185","v":35},19,35,"Production (19-35)",{"$f":"'Questions - Manufacturing'!$C$185","v":"Customer communication"},{"$f":"'Questions - Manufacturing'!$G$185","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$185","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$186","v":0},{"$f":"'Questions - Manufacturing'!$K$186","v":0},null,null,null,null,null,null,null,35,0,0]
["Production Control & Logistics",{"$f":"'Questions - Manufacturing'!$A$191","v":36},36,40,"Production Control & Logistics (36-40)",{"$f":"'Questions - Manufacturing'!$C$191","v":"Production Plan"},{"$f":"'Questions - Manufacturing'!$G$191","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$191","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$192","v":0},{"$f":"'Questions - Manufacturing'!$K$192","v":0},null,null,null,null,null,null,null,36,0,0]
["Production Control & Logistics",{"$f":"'Questions - Manufacturing'!$A$196","v":37},36,40,"Production Control & Logistics (36-40)",{"$f":"'Questions - Manufacturing'!$C$196","v":"Material planning"},{"$f":"'Questions - Manufacturing'!$G$196","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$196","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$197","v":0},{"$f":"'Questions - Manufacturing'!$K$197","v":0},null,null,null,null,null,null,null,37,0,0]
["Production Control & Logistics",{"$f":"'Questions - Manufacturing'!$A$201","v":38},36,40,"Production Control & Logistics (36-40)",{"$f":"'Questions - Manufacturing'!$C$201","v":"Lead Time"},{"$f":"'Questions - Manufacturing'!$G$201","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$201","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$202","v":0},{"$f":"'Questions - Manufacturing'!$K$202","v":0},null,null,null,null,null,null,null,38,0,0]
["Production Control & Logistics",{"$f":"'Questions - Manufacturing'!$A$206","v":39},36,40,"Production Control & Logistics (36-40)",{"$f":"'Questions - Manufacturing'!$C$206","v":"Capacity Efficiency"},{"$f":"'Questions - Manufacturing'!$G$206","v":""},"","-",{"$f":"'Questions - Manufacturing'!$I$206","v":""},"","-",{"$f":"'Questions - Manufacturing'!$J$207","v":0},{"$f":"'Questions - Manufacturing'!$K$207","v":0},null,null,null,null,null,null,null,39,0,0]
["Production Control & Logistics",{"$f":"'Questions - Manufacturing'!$A$211","v":40},36,40,"Production Control & Logistics (36-40)",{"$f":"'Questions - Manufacturing'!$C$211","v":"Supply Chain Efficiency"},{"$f":"'Questions - Manufacturing'!G$211","v":""},"","-",{"$f":"'Questions - Manufacturing'!I$211","v":""},"","-",{"$f":"'Questions - Manufacturing'!J$212","v":0},{"$f":"'Questions - Manufacturing'!K$212","v":0},null,null,null,null,null,null,null,40,0,0]
["Operational control",{"$f":"'Questions - Manufacturing'!$A$217","v":41},41,41,"Operational control (41)",{"$f":"'Questions - Manufacturing'!$C$217","v":"Key Performance Indicators"},{"$f":"'Questions - Manufacturing'!G$217","v":""},"","-",{"$f":"'Questions - Manufacturing'!I$217","v":""},"","-",{"$f":"'Questions - Manufacturing'!J$218","v":0},{"$f":"'Questions - Manufacturing'!K$218","v":0},null,null,null,null,null,null,null,41,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",0,0]

{"sheet":"Info and attachments (pdf)","index":8,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]