{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Coversheet","Questionnaire","Assessment matrix","CA","Questionnaire_VDA","Assessment matrix_VDA","CA_VDA"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Coversheet","index":0,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[36,2,36,5],[36,8,36,11],[37,2,37,5],[37,8,37,11],[77,2,77,4],[76,8,76,10],[77,8,77,10],[76,2,76,4],[72,2,72,11],[73,2,73,11],[74,2,74,11],[39,8,39,11],[40,8,40,11],[41,8,41,11],[61,2,61,11],[66,2,66,11],[25,8,25,10],[6,2,6,11],[7,2,7,11],[34,8,34,11],[35,8,35,11],[28,3,28,4],[18,3,18,4],[19,3,19,4],[8,2,8,11],[27,9,27,11],[28,9,28,11],[29,9,29,11],[31,2,31,11],[32,2,32,11],[34,2,34,5],[35,2,35,5],[0,3,3,12],[13,2,13,11],[12,2,12,11],[10,2,10,3],[9,2,9,4],[9,8,9,11],[65,2,65,11],[64,2,64,11],[63,2,63,11],[59,2,59,3],[59,4,59,7],[62,2,62,11],[39,2,39,5],[40,2,40,5],[41,2,41,5],[56,4,56,7],[58,4,58,7],[56,2,56,3],[57,2,57,3],[58,2,58,3],[57,4,57,7]]}
[null,null,null,"SUPPLIER AUDIT REPORT"]
[]
[]
[]
[null,"GENERAL INFORMATION:"]
[null,null,null,null,null,null,null,null,null,null,"SAP vendor No.:"]
[null,"Company Name:"]
[null,"Company Address:"]
[]
[null,"Contact Person:",null,null,null,null,null,"Function:"]
[null,"No. of Employees:"]
[]
[null,"Commodity(-ies):"]
[null,"Mfg. Process(-es):"]
[]
[null,"QMS Certificate(-s):","ISO 9001",null,null,null,"Certificate No.:",null,null,null,"Valid till:"]
[null,null,"IATF 16949",null,null,null,"Certificate No.:",null,null,null,"Valid till:"]
[null,null,"ISO 14001",null,null,null,"Certificate No.:",null,null,null,"Valid till:"]
[null,null,"Other: ",null,null,null,"Certificate No.:",null,null,null,"Valid till:"]
[null,null,null,null,null,null,"Certificate No.:",null,null,null,"Valid till:"]
[]
[null,"Last Audit Result:",null,"Classification:",null,null,"Score:",null,null,null,"Audit Date:"]
[]
[null,"AUDIT INFORMATION:"]
[]
[null,"Audit Purpose:","Initial audit",null,"new source       existing source",null,null,"Audit Type:","QMS & Process audit"]
[null,null,"Surveillance audit"]
[null,null,"Follow up audit",null,null,null,null,{"$f":"IF($I$26=\"Process audit per VDA 6.3\",\"Audited mfg. process(-es):\",\"\")","v":""},{"$f":"IF($I$26=\"Process audit per VDA 6.3\",\"PS1\",\"\")","v":""}]
[null,null,"Other:",null,null,null,null,null,{"$f":"IF($I$26=\"Process audit per VDA 6.3\",\"PS2\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($I$26=\"Process audit per VDA 6.3\",\"PS3\",\"\")","v":""}]
[]
[null,"Audit Reason/ Criteria:"]
[null,"Audit Scope"]
[]
[null,"Lead Auditor:",null,null,null,null,null,"Function:"]
[null,"Audit Team:",null,null,null,null,null,"Function:"]
[null,null,null,null,null,null,null,"Function:"]
[null,null,null,null,null,null,null,"Function:"]
[]
[null,"Supplier's Rep.:",null,null,null,null,null,"Function:"]
[null,null,null,null,null,null,null,"Function:"]
[null,null,null,null,null,null,null,"Function:"]
[]
[null,"AUDIT SUMMARY:"]
[]
[null,"Categories:",null,null,"Score:",null,null,null,null,null,"Audit Date:"]
[{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!B7,'Assessment matrix'!B9)","v":1},{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!C7,'Assessment matrix'!C9)","v":"General requirements"},null,null,{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!AM9,'Assessment matrix'!AM9))","v":"n/a"},null,null,null,null,null,"Duration:"]
[{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!B11,'Assessment matrix'!B12)","v":2},{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!C11,'Assessment matrix'!C12)","v":"Design and development of products and processes"},null,null,{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!AM14,'Assessment matrix'!AM12))","v":"n/a"}]
[{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!B16,'Assessment matrix'!B15)","v":3},{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!C16,'Assessment matrix'!C15)","v":"Supplier management"},null,null,{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!AM19,'Assessment matrix'!AM15))","v":"n/a"}]
[{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!B23,'Assessment matrix'!B18)","v":4},{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!C23,'Assessment matrix'!C18)","v":"Process analysis / Production"},null,null,{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!AM23,'Assessment matrix'!AM18))","v":"n/a"}]
[{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!B25,'Assessment matrix'!B21)","v":5},{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!C25,'Assessment matrix'!C21)","v":"Product Safety Management"},null,null,{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!AM37,'Assessment matrix'!AM21))","v":"n/a"}]
[{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!B44,'Assessment matrix'!B24)","v":6},{"$f":"IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!C44,'Assessment matrix'!C24)","v":"Customer support / Customer satisfaction / Service"},null,null,{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!AM44,'Assessment matrix'!AM24))","v":"n/a"}]
[null,null,null,"Overall score:",{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!U50,'Assessment matrix'!U30))","v":"n/a"}]
[null,null,null,{"$f":"\"Classification\"&IF(AND(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!X53<>'Assessment matrix_VDA'!X50),\" (downgraded)\",IF(AND(I26=\"QMS & Process audit\",'Assessment matrix'!X33<>'Assessment matrix'!X30),\" (downgraded)\",\"\"))&\":\"","v":"Classification:"},{"$f":"IF(I26=\"\",\"\",IF(I26=\"Process audit per VDA 6.3\",'Assessment matrix_VDA'!X53,'Assessment matrix'!X33))","v":"n/a"}]
[]
[null,"Evaluation & Assessment Matrix:"]
[null,"Result [%]","Classification",null,"Description of the classification"]
[null,{"$f":"IF(I26=\"Process audit per VDA 6.3\",\"score ≥ 90\",\"score ≥ 85\")","v":"score ≥ 85"},"A",null,"Quality-capable"]
[null,{"$f":"IF(I26=\"Process audit per VDA 6.3\",\"80 ≤ score < 90\",\"70 ≤ score < 85\")","v":"70 ≤ score < 85"},"B",null,"Conditionally quality-capable"]
[null,{"$f":"IF(I26=\"Process audit per VDA 6.3\",\"score < 80\",\"score < 70\")","v":"score < 70"},"C",null,"Not quality-capable"]
[]
[null,"Strengths:"]
[]
[]
[null,"Opportunities:"]
[]
[]
[]
[null,"AUDIT CONCLUSION:"]
[null,null,{"$f":"IF($E$54=\"A\",TRUE,FALSE)","v":false},null,null,{"$f":"IF($E$54=\"B\",TRUE,FALSE)","v":false},null,null,null,{"$f":"IF($E$54=\"C\",TRUE,FALSE)","v":false}]
[null,"Team Decision:","Approved",null,null,"Conditional Approval",null,null,null,"Not approved"]
[]
[null,"Comments:"]
[]
[]
[]
[]
[null,null,"Auditor signature",null,null,"Date",null,null,"Supplier Signature",null,null,"Date"]

{"sheet":"Questionnaire","index":1,"n_rows":121,"n_cols":6,"rows_kept":121,"cut":false,"hidden":false,"merged":[[1,2,3,2]]}
[]
[null,null,"     AUDIT QUESTIONNAIRE","Company:",{"$f":"IF(Coversheet!I26=\"QMS & Process audit\",IF(Coversheet!C7=\"\",\"\",Coversheet!C7),\"\")","v":""}]
[null,null,null,"Audit Date:",{"$f":"IF(Coversheet!I26=\"QMS & Process audit\",IF(Coversheet!L46=\"\",\"\",Coversheet!L46),\"\")","v":""}]
[]
["NO.",null,"QUESTION","SCORE","AUDIT FINDING(-S)","CA"]
["1.",null,"General requirements",null,null,{"$f":"\"Score: \"&IF('Assessment matrix'!AM9=\"n/a\",\"n/a\",ROUND('Assessment matrix'!AM9,2)*100&\"%\")","v":"Score: n/a"}]
["1.1","*","Are the customer requirements regarding Quality Management System ensured?","n/a",{"$f":"IF(D7=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D7=10,D7=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Automotive supplier shall be IATF 16949 and non-automotive ISO 9001 certified.\nA Quality Policy exists that addresses customer satisfaction. Quality Objectives at relevant functions, levels and processes within the organization are consistent with Quality Policy.\nProcesses needed for the QMS and their application throughout the organization are determined.\nThe actual QMS performance is monitored and corrective actions are in place assuring processes are delivering their intended outputs.","Look for…","QMS certificates\nQuality Policy\nQuality Objectives\nProcess Mapping\nQuality goals (yield/ scrap rate, customer scorecards, CoPQ, CIP, etc.)\nKPI's/ Metrics\nPDCA with risk-based thinking"]
["1.2",null,"Is there a system to track customer, applicable statutory and regulatory requirements? Are they communicated through the organization?","n/a",{"$f":"IF(D9=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D9=10,D9=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Supplier has a process assuring customer, applicable statutory and regulatory requirements are determined, understood and consistently met. That also includes technical documentation, special processes, etc. Any non-achievable requirement must be reviewed, documented and specially agreed with the customer.\nLegal regulations are considered with each new product and process development and launch.\nThe employees in the organization are aware about such requirements and demonstrate the effort on fulfilment.","Look for…","SQM sign-off\nQuality agreements\nLocal laws and regulations\nLegislations (country-specific)\nDefinition of responsibilities\n"]
["1.3",null,"Does the organization comply with EHS requirements? Are they being reviewed regularly and maintained?","n/a",{"$f":"IF(D11=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D11=10,D11=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Company is familiar with environmental requirements and maintains ISO 14001 certification. Specific customer EHS requirements are known, acknowledged and fulfilled.\nThere is a responsible person in the organization maintaining environmental management system.\nPollution Control Systems are in place and in use (i.e. waste water treatment, air scrubbers, noise dampening, special chemical storage, etc.).","Look for…","ISO 14001 certificate\nWaste treatment procedure/ records\nContracts with outsourced service providers\nLegal EHS regulations\nCustomer EHS requirements\nRoles and Responsibilities"]
["1.4","*","Have the materials used for supplied product been declared to the customer? Are the reports available and submitted as requested?","n/a",{"$f":"IF(D13=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D13=10,D13=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"There is a process in place to declare materials to the customer and meet the requirement. An access to external systems such as IMDS, IPC is available.\nThe verification of supplied raw materials is ensured either by third-party lab after receipt or receiving results from the raw material producer (certificate of compliance, conformity records, etc.).\nIt is ensured that the organization is not sourcing any metals from conflict mineral regions of the world.","Look for…","IMDS/ IPC reports\nREACH/ RoHS/ ICP declarations\nCoC reports\nList of possible sources for conflict minerals"]
["1.5",null,"Are there any program defined, driving Continuous Improvement? Is the performance measured and verified?","n/a",{"$f":"IF(D15=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D15=10,D15=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"There are CI projects, under control of Top Management, aligned with the Company Policy and focused on customer satisfaction. These should include, but not limit to:\n- Cost reduction (Six Sigma, Lean Enterprise, Value Analysis/Value Engineering, Value Stream Mapping);\n- Variation reduction (Six Sigma, Standardized Work, Statistical Process Control);\n- Factory Reorganization (5S Program, Single Unit or Cellular Manufacturing, Kaizen events);\n- Inventory reduction (Kanban system, Single Unit or Cellular Manufacturing, Supermarket Pull);\n- Yield improvement (improvements to Equipment Uptime/Downtime, First Pass Yield, Rework reduction, Scrap improvement, On-Time Delivery);\n- Non-manufacturing Process Improvement (Customer Service, Accounting, Warranty returns, Quality control)\nCorrective actions are in place for CI activities that do not meet the plan or deliverables.","Look for…","Continuous improvement process\nCI project list and status\nSix Sigma implementation\n5S program\nCI reports/ reviews/ meeting minutes\nCustomer satisfaction records"]
["1.6",null,"Has the financial risk been evaluated and financial stability secured?","n/a",{"$f":"IF(D17=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D17=10,D17=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"An organization should demonstrate a detailed understanding of their costs and how to control them (i.e. Activity-Based Costing model or similar).\nThe Cost of Poor Quality (CoPQ) is being measured for internal and/or external scrap, rework, RMA/ Field returns, FPY, Premium Freight, etc.\nThe company demonstrates financial stability through providing financial reports, or it is clearly evident that they are reinvesting back into the company through plant expansion, process modernization and new equipment.\n","Look for…","Cost Model\nFinancial KPI's and their status\nCoPQ goals\nLong term contracts\nFinancial assessment reports (e.g. BvD, etc.)"]
["1.7",null,"Are the various means of security assured inside the organization?","n/a",{"$f":"IF(D19=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D19=10,D19=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"The system of identifying employees from visitors and temporary workers are implemented? All visitors are required to sign in and out before entering and leaving the facility.\nThe performance of background checks is performed prior to employment. Records on termination are kept with emphasis on IT and any other access removal/ change.\nWritten procedures are in place regarding overage & shortage reporting.\nThe physical infrastructure includes following:\n- Perimeter Fencing\n- Monitored Gates and Gate Houses\n- Employee/visitor parking away from cargo loading area\n- Locking Devices and Key Controls on windows and/or doors\n- Alarms Systems and/or Video Surveillance Cameras\n","Look for…","Physical security\nPersonnel security\nProcedural controls\nInfrastructure\nContracts with service providers"]
["1.8","*","Are the labor and ethics policies and social responsibility ensured? Does it comply with customer Code of Conduct?","n/a",{"$f":"IF(D21=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D21=10,D21=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"It must be ensured that all employment inside the organization is freely chosen and forced labor or child labor are never used. The Social Policy prevents discrimination, inhumane treatment, harsh disciplinary practices and also allow workers to communicate openly with the management regarding working conditions. The number of working hours within the work week is governed by the local law.\nThe organization prevents corruption, extortion, or embezzlement and ensures bribes or other means of obtaining advantage are not offered or accepted?\nConfidentiality and protection of workers that report suspected violations of ethical misconduct is highly secured.\nThere should be no EHS issues that can cause immediate danger to life or serious injury?\nThe organization complies with EICC or other equivalent social responsibility regulations (i.e. SA8000).","Look for…","Customer Code of Conduct acknowledgment\nCompliance to local employment rules and regulations\nLabor and ethics policy\nThird party audit reports\nInternal Code of Conduct and Code of Ethics\nCompany Core Values"]
["2.",null,"Design and development of products and processes",null,null,{"$f":"\"Score: \"&IF('Assessment matrix'!AM12=\"n/a\",\"n/a\",ROUND('Assessment matrix'!AM12,2)*100&\"%\")","v":"Score: n/a"}]
["2.1",null,"Is a project management established within the organization? Are tasks, responsibilities and authorities specified for the team leader and team members?  ","n/a",{"$f":"IF(D24=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D24=10,D24=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"A process for project management exist, clearly defining phases for new business evaluation, product/ process development and implementation, mass production and project closure.\nThe responsibilities and authority of the project leader and team members are clear and meet customer requirements. The team members of the project are qualified to carry out their tasks.\nAll the expertise required for project execution and successful implementation is established.\nThe external suppliers are involved and early-engaged in project management.","Look for…","Roles and responsibilities for the project leader and project team\nProject organization chart\nEvidence of employee skill, competence evaluation and qualification\nCustomer requirements for project management"]
["2.2","*","Are the product and process requirements available? Has the manufacturing feasibility been assessed according to the product and process requirements?","n/a",{"$f":"IF(D26=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D26=10,D26=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"All requirements regarding the product to be developed are known.\nThe organization has a process for identifying customer requirements. If the requirements cannot be achieved, the customer must be informed and deviations documented and agreed.\nSpecial characteristics must be identified on the basis of in-house requirements, customer requirements, legal requirements, production technology and characteristics arising from the application.\nThe procedure for checking the contract, enquiry and assessing manufacturing feasibility must be defined and controlled. All areas involved must confirm the feasibility of the customer requirements (Buying, Development, Production Planning, Production, QM Planning, Logistics, etc.).","Look for…","Technical requirements, specifications, drawings\nCustomer requirements\nLegal requirements\nRegulations, standards, legislation requirements\nLogistics requirements (JIT, JIS, on consignment)\nTiming plans and delivery conditions\nAccess to portals (customer / supplier)\nProduct / process characteristics\nEnvironmental aspects\nFeasibility study records\nCapacities, manufacturing facilities, production locations\nTools, production, test and inspection equipment; auxiliary tools, laboratory facilities, transport facilities, containers, stores"]
["2.3",null,"Has the risk assessment (FMEA) been drawn up? Is it up-dated and are corrective actions laid down?","n/a",{"$f":"IF(D28=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D28=10,D28=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"In the development phase it must be ensured by means of FMEAs that the product and process meet the customer requirements in terms of function, reliability, etc. \nChanges to the product and process must be evaluated afresh. If appropriate, a new analysis should be carried out in agreement with the project team and project manager.\nThe execution of FMEAs must be controlled. Interfaces to customer and suppliers are defined.\nSpecial characteristics (SCs) are identified, highlighted in the FMEA and secured by appropriate actions.","Look for…","Customer requirements, special characteristics, important parameters\nEnvironmental aspects\nLegal requirements\nExperience from previous projects/ similar products already in serial production\nProduct-specific actions from the Process FMEA\nProcess-specific actions from the Product FMEA (Design FMEA)\nTracking actions\nChange records"]
["2.4",null,"Are the resources required for the project implementation planned and available?","n/a",{"$f":"IF(D30=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D30=10,D30=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Resource planning for project management is established and implemented, taking into account customer requirements.\nThe necessary project budget is planned, management approved and released.\nThe technical personnel, with the relevant qualifications, are available at the right time. The work-load of personnel are taken into account in the project planning.","Look for…","Resource planning\nProject budget\nEmployee qualification matrix\nResources for specific technologies (equipment, specialists, etc.)"]
["2.5",null,"Is there a project plan that meets customer requirements/ milestones? Has it been agreed with the customer and regularly reviewed?","n/a",{"$f":"IF(D32=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D32=10,D32=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"The project plan meets customer requirements. All in-house and customer milestones are fully included in the project plan and are regularly adjusted to take account of changes.\nProcurement activities shall be listed in details and integrated into the project plan.\nThe critical path is generated from the project plan and mitigation actions are carried out effectively.","Look for…","Customer project plan/ timing/ milestones\nProject plan with milestones\nProcurement activities\nSpecific customer requirements regarding technologies"]
["2.6",null,"Does project planning include activities for purchased products and services? Are they implemented and monitored for compliance?","n/a",{"$f":"IF(D34=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D34=10,D34=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"A process must be implemented to plan and check essential supplier activities. The level of activity depends on the risk classification of procured scope of suppliers. These include the supplier selection and award criteria, award amount and delivery target date.\nThe transfer of customer requirements in the supply chain is ensured, including customer required suppliers (directed suppliers) as stated within the agreement.\nThe suppliers for facilities, machinery, tools, test and measurement systems as well as services are integrated.\nDates for the assessment, supplier milestones and release have been laid down in the plan and coordinated with the overall schedule and the progress is monitored.","Look for…","Make vs buy decision\nAnalysis of the supply market\nRisk appraisal of each supplier\nList of approved suppliers for the project\nComponent classification\nSuppliers of services (development, laboratory, maintenance, etc.)"]
["2.7","*","Is change management within the project ensured? Are the responsible personnel clearly defined and involved in change control?","n/a",{"$f":"IF(D36=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D36=10,D36=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Changes are documented using a defined process, highlighted at the right time, communicated internally and agreed with the customer.\nSuppliers are actively involved in change management (for critical aspects).\nPersons responsible for change management and their representatives in the organization, in the customer organization and at the suppliers are defined.\nCustomer requirements for handling changes are complied with or specifically controlled and documented.","Look for…","Change management\nSpecified responsibilities\nTime schedule\nChange request form\nChange records\nAssessment of changes and change approvals"]
["2.8",null,"Is there an escalation process established within the project management organization and is it implemented effectively?","n/a",{"$f":"IF(D38=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D38=10,D38=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"An escalation process for the project is described and established. It takes into account of specific customer requirements.\nThe criteria for escalation are specified and responsibilities & authorities are regulated.\nIf special risks have been identified for technologies suppliers or special processes, this must also be taken into account in escalation management.","Look for…","Escalation procedure\nEscalation criteria and paths\nContact personnel\n"]
["2.9","*","Are the necessary evidence and releases available for the various phases? Is the transfer of the project to mass production controlled in order to secure safe product launch?","n/a",{"$f":"IF(D40=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D40=10,D40=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Releases/ evidence of suitability must be produced for all parts, sub-assemblies and bought-in items, in accordance with the development timing plans.\nProduction part approval process must have been carried out. PPAP release is the final verification of the product and if positive, results in release for serial production.\nReference parts and products from sample submissions must be retained in accordance with the customer requirements.\nThere must be a controlled process for the structured transfer of responsibility between the development team and production. Proof is available of machine capability studies to cover all special characteristics. Tools, test, measurement and inspection equipment are available in sufficient quantities.","Look for…","Product trial reports\nTest/ inspection reports\nTrial samples\nPre-production parts\nProof of capability of significant product/ process characteristics\nDevelopment releases from the customer\nProduction acceptance check report\nIdentification of parts from the launch phase"]
["3.",null,"Supplier management",null,null,{"$f":"\"Score: \"&IF('Assessment matrix'!AM15=\"n/a\",\"n/a\",ROUND('Assessment matrix'!AM15,2)*100&\"%\")","v":"Score: n/a"}]
["3.1","*","Are only approved and quality-capable suppliers selected and used? Are the quality agreements available with suppliers?","n/a",{"$f":"IF(D43=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D43=10,D43=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Sub-supplier qualification, approval and selection process shall be available. An assessment of suppliers' QMS certification, 2nd party or 3rd party audit must be obtained.\nEvidence must be retained for selecting and assessing new suppliers, based on selection criteria.\nFor serial production it must be ensured that only capable suppliers are used.\nRisks in the supply chain must be determined and assessed and must be reduced by appropriate actions (strategy for emergencies).\nIt must be ensured that the sub-suppliers have sufficient capacities – this also applies to changes in quantities.\nTarget agreements must be agreed and implemented with suppliers to cover quality and delivery performance, to ensure the continuous improvement of products and processes.","Look for…","Supplier qualification and selection criteria\nEvaluation of QM systems – e.g., audit results / suppliers' certificates\nQuality capability assessments (self-assessment, audits)\nSupplier release records\nMeasurable targets for quality, delivery, price & service"]
["3.2",null,"Are the customer requirements taken into account in the supply chain?","n/a",{"$f":"IF(D45=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D45=10,D45=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Suppliers in the supply chain must be controlled and monitored in terms of their engagements and performance (depending on the risk classification of the product).\nThe forwarding of customer requirements must be controlled and traceable.\nChange management must also be taken into account.","Look for…","Transmission of requirements (tolerances, timing tracks, process acceptance checks, releases, complaints)\nContract documents\nQM agreements and other relevant regulatory documents\nEvidence of other regular communication"]
["3.3","*","Are the necessary releases available for the purchased products and services?","n/a",{"$f":"IF(D47=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D47=10,D47=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"An approval / release must be issued for all out-sourced products and services before they are used in serial production. Records shall be maintained and shared with the customer, as requested.\nIn case of deviation, it must be assured that temporal approval is issued, corrective actions are drawn and monitored till completion. Parts with conditional status have to be properly identified and traceability assured.\nEvidence must therefore be provided of comprehensive change management, from the customer to the sub-supplier.","Look for…","Approvals/releases samples, trials\nPPAP/ qualification reports\nEvidence of capability for special characteristics\nCompliance safety data sheets material declarations (REACH, RoHS, IMDS, etc.)"]
["3.4","*","Is the quality of the purchased products and services ensured? Are the actions defined in case of deviation?","n/a",{"$f":"IF(D49=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D49=10,D49=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"The capabilities and performance of a supplier must be checked at defined intervals and the results must be logged and evaluated. In the event of negative results, improvement programs must be laid down. Evidence must be provided that the actions have been implemented and verified effective.\nRequalification checks are carried out to meet customer requirements.\nTest, inspection and measurement equipment must be stored in an orderly manner and associated work stations must be laid out appropriately (to prevent damage, contamination noise and to ensure good lighting conditions, tidiness, order and, if relevant, air conditioning).","Look for…","Supplier problem list\n8D reports\nScorecard reports\nAlignment of test / inspection procedures, processes and frequencies\nRequalification checks/ reports\nImprovement programs"]
["3.5",null,"Are personnel qualified for the various tasks and are responsibilities defined?","n/a",{"$f":"IF(D51=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D51=10,D51=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"A description must be provided of what responsibilities, tasks and authority the employees have in their relevant task areas.\nA job description must be available for functions.\nTraining needs must be determined for each employee in terms of the task and qualification must be provided accordingly.\nKnowledge is available of previous complaints regarding relevant out-sourcing requirements.","Look for…","Specialized knowledge of product characteristics\nStandards / legislation\nAssessment methods (audits, statistics)\nQuality techniques (8D method, cause & effect diagrams)\nForeign languages\nQualification plan"]
["4.",null,"Process analysis / Production",null,null,{"$f":"\"Score: \"&IF('Assessment matrix'!AM18=\"n/a\",\"n/a\",ROUND('Assessment matrix'!AM18,2)*100&\"%\")","v":"Score: n/a"}]
["4.1",null,"Are incoming goods stored appropriately and are suspect/ block material separated and its status identified?","n/a",{"$f":"IF(D54=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D54=10,D54=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Incoming materials and goods must be placed in storing location in accordance with their release status so that they cannot be damaged or mixed up. \"Suspect\" and quarantined products must be stored securely to prevent access to them.\nFIFO and batch traceability are ensured when the materials and goods are processed further.\nMaterial stock in storing location matches the stock level in the ERP system.","Look for…","ERP system for inventory management\nCleanliness and tidiness\nClimatic conditions\nProtection against damage, dirt, corrosion\nIdentification (traceability, inspection status, work sequence, usage status)\nQuarantine areas\nFIFO (first-in first-out)"]
["4.2",null,"Are the necessary identifications/ records/ approvals available for the incoming materials?","n/a",{"$f":"IF(D56=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D56=10,D56=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Released incoming materials must be clearly identified and recognizable. The release status must be clear from the identification. The release identification on bundles, batches, load containers and parts must be specified.\nCustomer specific regulations for the release of products must be taken into account. It must be ensured that only released materials / parts are forwarded to production.\nTraceability of releases must be ensured across the entire process chain, from sub-supplier to the customer.","Look for…","Identification and traceability\nProcess for the release of products / materials\nRecords of releases\nTraceability system / concept\nProduction control plan"]
["4.3","*","Are all the relevant details listed in the production and inspection documents are in accordance with production control plan? Are operations checked and data logged?","n/a",{"$f":"IF(D58=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D58=10,D58=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"The production and control/ inspection documents (production control plan, work plan, manufacturing instructions) must be available at the work place and inspection station. Control/ inspection characteristics, facilities, methods, frequencies and must be described and defined in these documents.\nProcess parameters with tolerances, influencing product characteristics and/or quality, must be fully stated.\nThe control limits in process control charts must be specified, recognizable and traceable.\nNon-compliances and actions taken regarding process requirements and inspection characteristics must be documented.\nConditions for rework allowance are specified, agreed with the customer and secured within the process (parts identification, additional checks, etc.).","Look for…","Production control plans\nProcess parameters (pressures, temperatures, times, speeds, etc.)\nData regarding machines / tools / auxiliary aids (tool and machine numbers)\nControl limits in process control charts\nMachine and process capability certification\nOperating instructions, handling instructions\nWork instructions\nChecking/inspection instructions\nInformation on current problems\nMaintenance instructions"]
["4.4",null,"Can the product requirements be satisfied with the production facilities used?","n/a",{"$f":"IF(D60=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D60=10,D60=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"It must be shown that the processes are implemented to the customer requirements with the existing production facilities and that the resulting products comply with the customer specifications.\nThe production facilities, machines and equipment must be able to maintain the specified tolerances for the relevant characteristics. Process capability must be determined for significant product / process characteristics.\nCleanliness requirements for production are defined and implemented by reference to the product risk.\nThere is sufficient production capacity, taking into account levels of scrap and rework.","Look for…","Machine process capability\nPoka Yoke solutions\nInspection process capability\nMeasurement equipment capability\nResults of product audits\nReplacement tools, spare parts\nMaintenance/ overhaul level of tools/ plant/ machines\nEmergency plans"]
["4.5","*","Are significant characteristics controlled in production?","n/a",{"$f":"IF(D62=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D62=10,D62=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Significant product characteristics and process parameters are identified in the production control plan and are monitored systematically (SPC). Control limits are defined and effective control action is taken in the event of deviations.\nRecords are maintained of non-compliances and corrective actions. Non-compliances affecting the characteristics of the product must be approved by the customer.\nQuality records are specified for significant characteristics (type and duration of archiving) and are agreed with the customer.","Look for…","Product FMEA / Process FMEA\nProduction control plan\nQuality records\nSPC charts"]
["4.6",null,"Are setup parts, production scrap or rework parts are identified and kept separately? Is the flow of materials secured against mixing?","n/a",{"$f":"IF(D64=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D64=10,D64=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Non-released parts, defective parts and/or parts with defective characteristics must be separated and documented. They must be securely removed from production operations. Containers for scrap and rework must be appropriately identified.\nQuarantine stores and quarantine areas must be clearly recognizable (unauthorized access must be prevented).\nAn appropriate and optimum flow of parts and materials must ensure that mixing between similar items cannot occur. Poka Yoke or other methods may be used for this.\nThere must be a clearly controlled process for handling residual quantities, parts which have been separated out (for example, stacked up because of a machine problem), re-used parts from product audits, checking parts, etc. Containers and parts must be adequately, appropriately and securely identified. The process and/or inspection status must be clearly visible.","Look for…","Identification of scrap, rework and setting parts\nIdentification of containers for scrap, rework and setting parts\nQuarantine stores & areas\nIdentification of internal residual quantities, including storage\nRecords of rework and scrap\nPoka Yoke actions\nBatch identification, traceability\nWork papers with master data for parts"]
["4.7",null,"Are the operators able to carry out their allotted tasks and are their qualifications kept up-to-date?","n/a",{"$f":"IF(D66=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D66=10,D66=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"There must be a job description for each workstation, including a requirements profile.\nTraining needs must be determined individually for each operator based on the task and an appropriate personnel development plan drawn up. A record must be kept of who is qualified for what tasks and activities.\nAll employees are trained in the consequences of carrying out work incorrectly. Training in health & safety at work and work related environment aspects is provided regularly.\nThere must be evidence of suitability to meet requirements regarding activities (e.g., forklift driver license; welding certificate, soldering certificate, eye test, hearing test, etc.). Induction plans must be available for new employees, replacement and temporary personnel.","Look for…","Induction, training, qualification certification\nTraining in health & safety\nCertificates of suitability – e.g., welder's certificate, eye test, driving license for forklifts\nImprovement proposals\nVoluntary special actions (training; quality circles)\nInformation flow; organizational implementation\nWorkshops"]
["4.8",null,"Is there a personnel employment plan?","n/a",{"$f":"IF(D68=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D68=10,D68=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"When planning the employment of personnel the qualifications of the employees must be taken into account (qualifications matrix).\nAbsentee levels (sickness, holidays, training) are included in the employment planning.\nIn the case of replacement personnel and personnel transferred on loan, it is important to ensure that they have the necessary qualifications.\nRules regarding deputies are documented and are derived from the qualifications matrix for the relevant production operations.","Look for…","Qualification matrix\nInformation flow; organizational implementation\nDocumented rules regarding deputies"]
["4.9",null,"Are the maintenance of production facilities/ machinery/ tools properly controlled?  ","n/a",{"$f":"IF(D70=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D70=10,D70=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Plant, equipment, machines and tools required for the operation are identified and appropriate preventive maintenance intervals are allocated to them.\nResources to carry out essential maintenance work are available. Maintenance is systematically planned and carried out.\nPreventive maintenance of machines, plant and tools is carried out, documented and controlled.\nAvailability of spares for production facilities is assured.\nA process has been effectively implemented to analyze and optimize downtimes, machine loadings and the life of tools. Tools are managed containing identification of usage status (OK / NOK / under repair), tool tracking card with all the changes made to the tool, tool operating times, protection from damages, ownership details for the tool","Look for…","Planned regular maintenance activities\nAvailability of spare parts\nPlanned vs actual amount of maintenance hours\nQualifications of employees involved\nContracts to external companies to carry out maintenance work \nAvailability and use of associated technical documentation\nPreventive tool exchange program for units subject to greater wear\nQuality of execution of maintenance work"]
["4.10","*","Can the quality requirements be monitored effectively with the test, inspection and measurement equipment?","n/a",{"$f":"IF(D72=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D72=10,D72=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"The test, inspection and measurement equipment are suitable for the purpose. They are included in the production control plan. Employees are trained in the use of measurement equipment.\nCapability studies are carried out on the measurement devices and measurement systems employed. The accuracy of this equipment is appropriate for the purpose and for the characteristics to be checked.\nCertification is available covering the calibration of the inspection equipment (inspection plates).\nThere is an identification system for measurement and inspection equipment. Measurement and inspection equipment accessories having an influence on measurement accuracy and the measurement result are monitored in the same way.","Look for…","Production control plan\nProof of the capability\nData logging\nEvidence of the calibration of inspection equipment"]
["4.11",null,"Are tools, equipment and test / inspection equipment stored correctly?","n/a",{"$f":"IF(D74=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D74=10,D74=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Tools, equipment and test/ inspection devices not in use and/or not yet released are properly tagged.\nAll tools, equipment and test/inspection devices are identified with their current status and change level (released; under maintenance; maintenance required; not in use).\nStorage is provided where the equipment is protected against damage and environmental effects, and cleanliness and tidiness are ensured.","Look for…","Stored conditions\nCleanliness and tidiness\nDefined storage location\nEnvironmental influences\nStatus identification\nIdentification showing customer property"]
["4.12",null,"Are target requirements set for product and process?","n/a",{"$f":"IF(D76=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D76=10,D76=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Process and product metrics are defined and logged in order to control and monitor the organization's processes. A regular comparison is made between specified and actual results.\nProcess specific targets are laid down, monitored and communicated (quantities produced; quality metrics such as failure rates, audit results, through-times and process effectiveness figures (Cpk).\nNon-conformances are analyzed and subjected to suitable action leading to improvements to the product and process.\nThe potential for improvement must be determined continuously from previous experience regarding quality, costs and service.\nMonitoring the metrics is ensured through regular management reviews and reported in associated committees.","Look for…","Criteria for establishing metrics\nQuantities produced\nRework; scrap\nQuality metrics (e.g., failure rates, audit results)\nNon-conformances\nProcess metrics\nReduction of waste (e.g., scrap and rework, energy and process materials)\nStock level"]
["4.13","*","In the case of deviations from product and process requirements, are the causes analyzed and the corrective actions checked for effectiveness?","n/a",{"$f":"IF(D78=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D78=10,D78=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"If deviations from product and process requirements occur, immediate containment actions must be taken to comply with the requirements, until the causes of failure are eliminated and evidence has been provided of the effectiveness of the corrective actions.\nMethods used for the analysis of causes are defined and in use.\nCorrective actions are derived, their implementation is monitored and effectiveness is verified. In this, production control plans and FMEAs are taken into account and are extended and up-dated if required.","Look for…","Cause & effects diagram\nFMEA\nQuality control records\n8D reports/ PDCA\nAnalytical assessment methods\nProblem log and status"]
["4.14",null,"Are processes and products audited regularly?","n/a",{"$f":"IF(D80=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D80=10,D80=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Audit plans (process audits, product audits) must be available for the product and its production processes.\nDeviation reports must be issued to those responsible and improvement actions must be tracked. If quality requirements are not met (internal / external) additional audits referring to the specific events must be carried out.","Look for…","Audit plans\nRequirements for product audits\nAudit results; audit reports\nCorrective actions and their status\nAuditor qualifications."]
["4.15",null,"Are finish products packed and stored appropriately? Are the necessary records and releases available?","n/a",{"$f":"IF(D82=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D82=10,D82=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Parts must be protected from damage by suitable storage and packing. Customer specific packing instructions must be available.\nThe positioning of parts must ensure secure storage at the workplace, including handling. Storage points/ containers must meet essential requirements for cleanliness & tidiness. This includes the parts at the workplace itself (no over-filling). Specified storage times must be monitored. Parts must be protected against environmental and climatic influences during storage and processing.\nReleases for the shipment of products to the customer or the next process must be identifiable and documented. Special releases and releases under deviation must be traceable by appropriate identification and documentation.\nTraceability of releases, including documentation, must be generally guaranteed. The customer requirements must be taken into account in determining archiving regulations and periods.","Look for…","Quantities in store\nProtection from damage\nCleanliness, tidiness, over-filling\nMonitoring of storage periods\nEnvironmental and climatic influences\nCustomer specific packing instructions (inc. packing supplied by the customer)\nDocumentation matrix for storage times for various documents and records"]
["4.16","*","Are changes to the product or process in serial production tracked and documented?","n/a",{"$f":"IF(D84=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D84=10,D84=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"The progress of a change from the initial change request through to implementation must be clearly described and responsibilities must be controlled. A process regulating the change release must be implemented.\nChanges must be agreed, approved and released with the customer. Documentation of change levels must be fully traceable throughout.\nCharacteristics subject to special documentary and archiving requirements must be tracked and documented accordingly. It is ensured that only current / valid documents are present at work stations.","Look for…","Change management process\nTrack the level of implementation of the change\nDocumented change records\nVerification and validation of changes, including documentation\nChange levels of test/inspection equipment, gauges, tools and drawings"]
["5.",null,"Product Safety Management",null,null,{"$f":"\"Score: \"&IF('Assessment matrix'!AM21=\"n/a\",\"n/a\",ROUND('Assessment matrix'!AM21,2)*100&\"%\")","v":"Score: n/a"}]
["5.1","*","Does the organization/ plant has Product Safety Policy in place? Is there a product safety representative with defined responsibilities and authorities?","n/a",{"$f":"IF(D87=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D87=10,D87=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Where applicable, the organization shall develop and maintain product safety policy, as part of the quality management system.\nProduct safety policy describes liability in which manufacturers, distributors, suppliers, retailers, and others who make products available to the public are held responsible for the injuries those products cause.\nProduct liability insurance is in place protecting the business from claims to the manufacture or sale of products to the public. It covers the cost of damage to the people or the equipment.\nProduct recall insurance reimburse the cost required to remove a defective product from the field and restore a safe one, either by repair or replacement.\nSupplier has qualified product safety representative. Its responsibilities and authorities are clearly defined.","Look for…","Product Safety Policy\nProduct liability conditions\nLiability and recall insurance certificates\nOrg. chart with product safety ownership\nIs the Product Safety Policy available to employees?"]
["5.2",null,"Is there training program for product safety? Does it cover customer effects and product liability?","n/a",{"$f":"IF(D89=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D89=10,D89=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Training program shall include product safety, customer effects and product liability. Training is provided to all associates, e.g. operators, engineers, buyers, union, etc.\n","Look for…","Employees training plan\nTraining records"]
["5.3",null,"Are product safety issues managed through the 8D process?","n/a",{"$f":"IF(D91=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D91=10,D91=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Problem solving methods shall highlight severity of safety critical aspects with clear requirements and guidelines for containment, issue resolution and escalation. Action status is tracked and monitored.","Look for…","8D reports relative to a product safety complaints\nHistorical log with product safety related issues"]
["5.4",null,"Does the supplier use lessons learned based on product safety incidents and are these considered when developing new products and/or processes?","n/a",{"$f":"IF(D93=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D93=10,D93=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Visibility and access to product safety failures are assured within supplier organization. Product safety failures from old and/or existing designs are addressed in new design developments.","Look for…","Product safety lessons learned records\nPFMEA and Control plan updated based on lessons learned"]
["5.5","*","Is there a procedure to review and validate customer drawing/ specification requirements related to product safety? Are the inputs cascaded down within supplier base?","n/a",{"$f":"IF(D95=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D95=10,D95=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Process is in place to identify, review, validate and acknowledge safety critical characteristics of product or design. It also covers the reduction of high safety RPN's during design review as per failure modes and FTA (fault tree analysis). Sub-suppliers are early engaged for compliance evaluation and risk mitigation.\nGovernment regulations are known and considered during design phase.","Look for…","Design review procedure\nType of testing conducted and its frequency\nFeasibility records of sub-suppliers\nValidation records"]
["5.6",null,"Are product safety characteristics identified in core documents, such as Process Flow Chart, PFMEA, Control Plan, Work Instructions, etc.? Is a special symbol used for identification?","n/a",{"$f":"IF(D97=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D97=10,D97=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Product safety characteristics are clearly identified within design, process and control documentation, including incoming inspection cards, work instructions, etc.  Characteristic marking matches between different documents and records.","Look for…","Process Flow Chart\nPFMEA and highest RPN mitigation actions\nControl plan\nIncoming inspection records\nWork instructions"]
["5.7",null,"Is there a documented process to maintain all information related to traceability (material, machine, process and operator)?","n/a",{"$f":"IF(D99=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D99=10,D99=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Traceability records are stored for 15 yrs. Traceability is identified on finished parts, sub-components and raw materials. FIFO is assured and final product serially controlled.\nSystem assures back to day of production, manufacturing cell, rework and operator.","Look for…","Traceability records\nLinkage of finish product to material and production order\nFIFO compliance"]
["6.",null,"Customer support / Customer satisfaction / Service",null,null,{"$f":"\"Score: \"&IF('Assessment matrix'!AM24=\"n/a\",\"n/a\",ROUND('Assessment matrix'!AM24,2)*100&\"%\")","v":"Score: n/a"}]
["6.1",null,"Are customer requirements regarding product and process fulfilled and is customer service guaranteed?","n/a",{"$f":"IF(D102=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D102=10,D102=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Customer requirements for annual requalification, spare part supply, RMA procedure are understood and implemented.\nCommunication in a language which the customer understands is essential.\nCustomer support is also a measurement of active creative cooperation. The supplier has the obligation to examine his products at all stages of the creation and implementation stages and to improve them in agreement with the customer.","Look for…","SMQ sign-off\nQuality agreements\nConditions for supply of spare parts\nKnowledge of the product application\nNotification of improvement actions\nWorld-wide customer service\nCustomer information in the case of non-compliance with the requirements"]
["6.2","*","Is the supply of parts ensured? Are possible risks identified and reaction plan introduced?","n/a",{"$f":"IF(D104=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D104=10,D104=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Supplies are ensured including emergency/ contingency/ recovery plans.\nThese concepts must always be kept up-to-date in the serial production delivery phases and must apply to in-house processes and also the suppliers' processes.\nProcedures must be in place which guarantee that the organization informs the customer immediately when supply bottlenecks are detected. The information must include the expected duration and extent of the bottlenecks and the actions which have been taken.\nThe actions must be taken at the right time and in accordance with the customer requirements.","Look for…","Contingency plans (e.g., for alternative production, suppliers, transport)\nCapacity evaluation\nUse of external capacity\nSpares for assembly lines"]
["6.3","*","In case of deviations from quality requirements, are failure/ defect analysis carried out and corrective actions implemented effectively?","n/a",{"$f":"IF(D106=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D106=10,D106=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"Independent detection and analysis of deviations from quality requirements, with the rapid introduction of corrective actions are in place. Timings agreed with the customer following complaints or rejects must be maintained. Non-conformances must be communicated.\nDeviations and the associated corrective actions must be placed in order of priority and integrated in existing risk analyses (e.g., FMEAs). The process for analyzing defective parts from the field is implemented.\nTest / inspection planning must be carried out. The characteristics to be checked and the specification for the checks must be documented and agreed with the customer.\nMetrics for the field failures analysis process must be tracked in order to measure effectiveness. The standard reporting system for reporting on analyses (8D) and quality reports must be agreed with the customer.","Look for…","PARETO analysis of failure characteristics (internal / external)\nInvolvement of all areas affected (internal / external)\nUse of problem solving methods\nChecks on effectiveness\nProduct observation and improvement\nKnowledge data base, \"lessons learned\"\nTest / checking equipment and specialist personnel for analyzing failures\nMetrics for analyzing defective parts (e.g., by average detection time)\n8D reports\nQuality reports (including Pareto diagrams, Paynter charts)"]
["6.4",null,"Are personnel qualified for the various tasks and are responsibilities defined?","n/a",{"$f":"IF(D108=10,$A$114,$A$115)","v":"Enter explanation"},{"$f":"IF(OR(D108=10,D108=\"n/a\"),\"\",\"x\")","v":""}]
["Requirement",null,"A description must be provided, setting out the responsibilities, tasks and authority of personnel in their respective task areas.\nA job description, including requirements profile, must be provided for each function.\nTraining needs must be determined for each person, depending on the task and appropriate personnel development planning must be drawn up and implemented.","Look for…","Product / specifications / special customer requirements\nStandards / legislation\nProcessing / usage\nAssessment methods (e.g., audits, statistics)\nQuality techniques (e.g., Pareto, 8D method, Ishikawa cause and effect diagrams)\nKnowledge of foreign languages in the following areas\nQualification plan"]
[]
["Minimum questions to be answered: "]
["Minimum questions to be answered for each step: "]
["Questions answered: "]
["No weeknesses identified"]
["Enter explanation"]
[10]
[8]
[6]
[4]
[2]
["n/a"]

{"sheet":"Assessment matrix","index":2,"n_rows":46,"n_cols":47,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,46,35,48],[29,46,29,48],[30,29,30,45],[30,46,30,48],[31,29,31,45],[31,46,31,48],[34,46,34,48],[32,29,32,45],[32,46,32,48],[33,29,33,45],[33,46,33,48],[17,38,17,39],[20,38,20,39],[29,20,31,22],[1,31,1,48],[2,31,2,48],[11,38,11,39],[14,38,14,39],[5,37,6,40],[8,38,8,39],[0,4,3,26],[29,23,31,25],[23,38,23,39],[29,29,29,45],[41,3,41,9],[42,3,42,9],[40,3,40,9],[35,29,35,45],[32,23,34,25],[34,29,34,45],[44,3,44,9],[45,3,45,9],[46,3,46,9],[46,10,46,11],[43,3,43,9]]}
[null,null,null,null,"ASSESSMENT MATRIX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company:",{"$f":"IF(Coversheet!I26=\"QMS & Process audit\",IF(Coversheet!C7=\"\",\"\",Coversheet!C7),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audit Date:",{"$f":"IF(Coversheet!I26=\"QMS & Process audit\",IF(Coversheet!L46=\"\",\"\",Coversheet!L46),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level of\ncompliance [%]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1*","1.2","1.3","1.4*","1.5","1.6","1.7","1.8*"]
[null,1,{"$f":"Questionnaire!C6","v":"General requirements"},null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire!D7","v":"n/a"},{"$f":"Questionnaire!D9","v":"n/a"},{"$f":"Questionnaire!D11","v":"n/a"},{"$f":"Questionnaire!D13","v":"n/a"},{"$f":"Questionnaire!D15","v":"n/a"},{"$f":"Questionnaire!D17","v":"n/a"},{"$f":"Questionnaire!D19","v":"n/a"},{"$f":"Questionnaire!D21","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E1",{"$f":"IF(COUNTIF(N9:U9,\"n/a\")=8,\"n/a\",(SUM(N9:U9)/COUNT(N9:U9)/10))","v":"n/a"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1","2.2*","2.3","2.4","2.5","2.6","2.7*","2.8","2.9*"]
[null,2,{"$f":"Questionnaire!C23","v":"Design and development of products and processes"},null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire!D24","v":"n/a"},{"$f":"Questionnaire!D26","v":"n/a"},{"$f":"Questionnaire!D28","v":"n/a"},{"$f":"Questionnaire!D30","v":"n/a"},{"$f":"Questionnaire!D32","v":"n/a"},{"$f":"Questionnaire!D34","v":"n/a"},{"$f":"Questionnaire!D36","v":"n/a"},{"$f":"Questionnaire!D38","v":"n/a"},{"$f":"Questionnaire!D40","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E2",{"$f":"IF(COUNTIF(N12:V12,\"n/a\")=9,\"n/a\",(SUM(N12:V12)/COUNT(N12:V12)/10))","v":"n/a"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3.1*","3.2","3.3*","3.4*","3.5"]
[null,3,{"$f":"Questionnaire!C42","v":"Supplier management"},null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire!D43","v":"n/a"},{"$f":"Questionnaire!D45","v":"n/a"},{"$f":"Questionnaire!D47","v":"n/a"},{"$f":"Questionnaire!D49","v":"n/a"},{"$f":"Questionnaire!D51","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E3",{"$f":"IF(COUNTIF(N15:R15,\"n/a\")=5,\"n/a\",(SUM(N15:R15)/COUNT(N15:R15)/10))","v":"n/a"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4.1","4.2","4.3*","4.4","4.5*","4.6","4.7","4.8","4.9","4.10*","4.11","4.12","4.13*","4.14","4.15","4.16*"]
[null,4,{"$f":"Questionnaire!C53","v":"Process analysis / Production"},null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire!D54","v":"n/a"},{"$f":"Questionnaire!D56","v":"n/a"},{"$f":"Questionnaire!D58","v":"n/a"},{"$f":"Questionnaire!D60","v":"n/a"},{"$f":"Questionnaire!D62","v":"n/a"},{"$f":"Questionnaire!D64","v":"n/a"},{"$f":"Questionnaire!D66","v":"n/a"},{"$f":"Questionnaire!D68","v":"n/a"},{"$f":"Questionnaire!D70","v":"n/a"},{"$f":"Questionnaire!D72","v":"n/a"},{"$f":"Questionnaire!D74","v":"n/a"},{"$f":"Questionnaire!D76","v":"n/a"},{"$f":"Questionnaire!D78","v":"n/a"},{"$f":"Questionnaire!D80","v":"n/a"},{"$f":"Questionnaire!D82","v":"n/a"},{"$f":"Questionnaire!D84","v":"n/a"},null,null,null,null,null,null,null,null,"E4",{"$f":"IF(COUNTIF(N18:AC18,\"n/a\")=16,\"n/a\",(SUM(N18:AC18)/COUNT(N18:AC18)/10))","v":"n/a"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5.1*","5.2","5.3","5.4","5.5*","5.6","5.7"]
[null,5,{"$f":"Questionnaire!C86","v":"Product Safety Management"},null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire!D87","v":"n/a"},{"$f":"Questionnaire!D89","v":"n/a"},{"$f":"Questionnaire!D91","v":"n/a"},{"$f":"Questionnaire!D93","v":"n/a"},{"$f":"Questionnaire!D95","v":"n/a"},{"$f":"Questionnaire!D97","v":"n/a"},{"$f":"Questionnaire!D99","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E5",{"$f":"IF(COUNTIF(N21:T21,\"n/a\")=7,\"n/a\",(SUM(N21:T21)/COUNT(N21:T21)/10))","v":"n/a"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6.1","6.2*","6.3*","6.4"]
[null,6,{"$f":"Questionnaire!C101","v":"Customer support / Customer satisfaction / Service"},null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire!D102","v":"n/a"},{"$f":"Questionnaire!D104","v":"n/a"},{"$f":"Questionnaire!D106","v":"n/a"},{"$f":"Questionnaire!D108","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E6",{"$f":"IF(COUNTIF(N24:Q24,\"n/a\")=4,\"n/a\",(SUM(N24:Q24)/COUNT(N24:Q24)/10))","v":"n/a"}]
[]
[]
[]
[null,"Overall compliance EG:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classification:"]
[null,null,null,"Total points awarded for the relevant questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N9:U9,N12:V12,N15:R15,N18:AC18,N21:T21,N24:Q24)","v":0},null,{"$f":"IF(ISERROR(AVERAGE(AM9,AM12,AM15,AM18,AM21,AM24)),\"n/a\",ROUND(S30/S32,2))","v":"n/a"},null,null,{"$f":"IF(U30=\"n/a\",\"n/a\",IF(U30<70%%,\"C\",IF(AND(U30>=70%%,U30<85%),\"B\",IF(U30>=85%,\"A\",))))","v":"n/a"},null,null,null,null,null,"Reasons for down-grading from \"A\" to \"B\" despite the achievement level:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision"]
[null,"EG [%]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At least one process element < 70%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AM9<70%,AM12<70%,AM15<70%,AM18<70%,AM21<70%,AM24<70%),\"yes\",\"no\")","v":"no"}]
[null,null,null,"Total possible number of points for the relevant questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(COUNTIF(N9:U9,\"<>n/a\"),COUNTIF(N12:V12,\"<>n/a\"),COUNTIF(N15:R15,\"<>n/a\"),COUNTIF(N18:AC18,\"<>n/a\"),COUNTIF(N21:T21,\"<>n/a\"),COUNTIF(N24:Q24,\"<>n/a\"))*10","v":0},null,null,null,null,null,null,null,null,null,null,"At least one (*) question scored 4 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N9=4,Q9=4,U9=4,O12=4,T12=4,V12=4,N15=4,P15=4,Q15=4,P18=4,R18=4,W18=4,Z18=4,AC18=4,N21=4,R21=4,O24=4,P24=4),\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(X30=\"A\",X30=\"B\"),OR(AU35=\"yes\",AU36=\"yes\")),\"C\",IF(AND(X30=\"A\",OR(AU31=\"yes\",AU32=\"yes\",AU33=\"yes\")),\"B\",X30))","v":"n/a"},null,null,null,null,null,"At least one question scored 0 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N9=0,O9=0,P9=0,Q9=0,R9=0,S9=0,T9=0,U9=0,N12=0,O12=0,P12=0,Q12=0,R12=0,S12=0,T12=0,U12=0,V12=0,N15=0,O15=0,P15=0,Q15=0,R15=0,N18=0,O18=0,P18=0,Q18=0,R18=0,S18=0,T18=0,U18=0,V18=0,W18=0,X18=0,Y18=0,Z18=0,AA18=0,AB18=0,AC18=0,N21=0,O21=0,P21=0,Q21=0,R21=0,S21=0,T21=0,N24=0,O24=0,P24=0,Q24=0),\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reasons for down-grading to \"C\" despite the achievement level:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downgraded to:",null,null,null,null,null,null,"At least one process element < 60%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AM9<60%,AM12<60%,AM15<60%,AM18<60%,AM21<60%,AM24<60%),\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At least one (*) question scored 0 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N9=0,Q9=0,U9=0,O12=0,T12=0,V12=0,N15=0,P15=0,Q15=0,P18=0,R18=0,W18=0,Z18=0,AC18=0,N21=0,R21=0,O24=0,P24=0),\"yes\",\"no\")","v":"no"}]
[null,"At least 2/3 of questions must be answered for each evaluated process element and sub element",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Down grading rules must be applied to the classification results (A, B. C). This must be checked by the auditor! "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"level achieved",null,0.6,null,0.7,null,0.8,null,0.9,null,1]
[null,null,null,"Assessment elements",null,null,null,null,null,null,null,"[%]"]
[null,null,null,{"$f":"C9","v":"General requirements"},null,null,null,null,null,null,{"$f":"B9","v":1},{"$f":"IF(AM9=\"n/a\",\"n/a\",AM9*100)","v":"n/a"}]
[null,null,null,{"$f":"C12","v":"Design and development of products and processes"},null,null,null,null,null,null,{"$f":"B12","v":2},{"$f":"IF(AM12=\"n/a\",\"n/a\",AM12*100)","v":"n/a"}]
[null,null,null,{"$f":"C15","v":"Supplier management"},null,null,null,null,null,null,{"$f":"B15","v":3},{"$f":"IF(AM15=\"n/a\",\"n/a\",AM15*100)","v":"n/a"}]
[null,null,null,{"$f":"C18","v":"Process analysis / Production"},null,null,null,null,null,null,{"$f":"B18","v":4},{"$f":"IF(AM18=\"n/a\",\"n/a\",AM18*100)","v":"n/a"}]
[null,null,null,{"$f":"C21","v":"Product Safety Management"},null,null,null,null,null,null,{"$f":"B21","v":5},{"$f":"IF(AM21=\"n/a\",\"n/a\",AM21*100)","v":"n/a"}]
[null,null,null,{"$f":"C24","v":"Customer support / Customer satisfaction / Service"},null,null,null,null,null,null,{"$f":"B24","v":6},{"$f":"IF(AM24=\"n/a\",\"n/a\",AM24*100)","v":"n/a"}]

{"sheet":"CA","index":3,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,2,3,5],[1,7,1,9],[2,7,2,9]]}
[null,null,"IMPROVEMENT PROGRAM/\nACTION PLAN"]
[null,null,null,null,null,null,"Company:",{"$f":"IF(Coversheet!I26=\"QMS & Process audit\",IF(Coversheet!C7=\"\",\"\",Coversheet!C7),\"\")","v":""}]
[null,null,null,null,null,null,"Audit Date:",{"$f":"IF(Coversheet!I26=\"QMS & Process audit\",IF(Coversheet!L46=\"\",\"\",Coversheet!L46),\"\")","v":""}]
[]
["ITEM","NO.","AUDIT FINDING(-S)","SCORE","IMMEDIATE\nACTION","ROOT CAUSE(-S)","CORRECTIVE ACTION(-S)","DUE\nDATE","ACTUAL\nDATE","RESPONSIBLE","EFFECTI-\nVENESS"]
[{"$f":"IF(COUNTIF(Questionnaire!F7:F21,\"x\")>0,Questionnaire!A6,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire!F7:F21,\"x\")>0,Questionnaire!C6,\"\")","v":""}]
[{"$f":"IF(Questionnaire!F7=\"x\",1,\"\")","v":""},{"$f":"Questionnaire!A7","v":"1.1"},{"$f":"Questionnaire!E7","v":"Enter explanation"},{"$f":"Questionnaire!D7","v":"n/a"},{"$f":"IF(OR(D7=0,D7=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F9=\"x\",MAX($A$7:A7)+1,\"\")","v":""},{"$f":"Questionnaire!A9","v":"1.2"},{"$f":"Questionnaire!E9","v":"Enter explanation"},{"$f":"Questionnaire!D9","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F11=\"x\",MAX($A$7:A8)+1,\"\")","v":""},{"$f":"Questionnaire!A11","v":"1.3"},{"$f":"Questionnaire!E11","v":"Enter explanation"},{"$f":"Questionnaire!D11","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F13=\"x\",MAX($A$7:A9)+1,\"\")","v":""},{"$f":"Questionnaire!A13","v":"1.4"},{"$f":"Questionnaire!E13","v":"Enter explanation"},{"$f":"Questionnaire!D13","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F15=\"x\",MAX($A$7:A10)+1,\"\")","v":""},{"$f":"Questionnaire!A15","v":"1.5"},{"$f":"Questionnaire!E15","v":"Enter explanation"},{"$f":"Questionnaire!D15","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F17=\"x\",MAX($A$7:A11)+1,\"\")","v":""},{"$f":"Questionnaire!A17","v":"1.6"},{"$f":"Questionnaire!E17","v":"Enter explanation"},{"$f":"Questionnaire!D17","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F19=\"x\",MAX($A$7:A12)+1,\"\")","v":""},{"$f":"Questionnaire!A19","v":"1.7"},{"$f":"Questionnaire!E19","v":"Enter explanation"},{"$f":"Questionnaire!D19","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F21=\"x\",MAX($A$7:A13)+1,\"\")","v":""},{"$f":"Questionnaire!A21","v":"1.8"},{"$f":"Questionnaire!E21","v":"Enter explanation"},{"$f":"Questionnaire!D21","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire!F24:F40,\"x\")>0,Questionnaire!A23,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire!F24:F40,\"x\")>0,Questionnaire!C23,\"\")","v":""}]
[{"$f":"IF(Questionnaire!F24=\"x\",MAX($A$7:A15)+1,\"\")","v":""},{"$f":"Questionnaire!A24","v":"2.1"},{"$f":"Questionnaire!E24","v":"Enter explanation"},{"$f":"Questionnaire!D24","v":"n/a"},{"$f":"IF(OR(D16=0,D16=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F26=\"x\",MAX($A$7:A16)+1,\"\")","v":""},{"$f":"Questionnaire!A26","v":"2.2"},{"$f":"Questionnaire!E26","v":"Enter explanation"},{"$f":"Questionnaire!D26","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F28=\"x\",MAX($A$7:A17)+1,\"\")","v":""},{"$f":"Questionnaire!A28","v":"2.3"},{"$f":"Questionnaire!E28","v":"Enter explanation"},{"$f":"Questionnaire!D28","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F30=\"x\",MAX($A$7:A18)+1,\"\")","v":""},{"$f":"Questionnaire!A30","v":"2.4"},{"$f":"Questionnaire!E30","v":"Enter explanation"},{"$f":"Questionnaire!D30","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F32=\"x\",MAX($A$7:A19)+1,\"\")","v":""},{"$f":"Questionnaire!A32","v":"2.5"},{"$f":"Questionnaire!E32","v":"Enter explanation"},{"$f":"Questionnaire!D32","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F34=\"x\",MAX($A$7:A20)+1,\"\")","v":""},{"$f":"Questionnaire!A34","v":"2.6"},{"$f":"Questionnaire!E34","v":"Enter explanation"},{"$f":"Questionnaire!D34","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F36=\"x\",MAX($A$7:A21)+1,\"\")","v":""},{"$f":"Questionnaire!A36","v":"2.7"},{"$f":"Questionnaire!E36","v":"Enter explanation"},{"$f":"Questionnaire!D36","v":"n/a"},{"$f":"IF(OR(D22=0,D22=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F38=\"x\",MAX($A$7:A22)+1,\"\")","v":""},{"$f":"Questionnaire!A38","v":"2.8"},{"$f":"Questionnaire!E38","v":"Enter explanation"},{"$f":"Questionnaire!D38","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F40=\"x\",MAX($A$7:A23)+1,\"\")","v":""},{"$f":"Questionnaire!A40","v":"2.9"},{"$f":"Questionnaire!E40","v":"Enter explanation"},{"$f":"Questionnaire!D40","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire!F43:F51,\"x\")>0,Questionnaire!A42,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire!F43:F51,\"x\")>0,Questionnaire!C42,\"\")","v":""}]
[{"$f":"IF(Questionnaire!F43=\"x\",MAX($A$7:A25)+1,\"\")","v":""},{"$f":"Questionnaire!A43","v":"3.1"},{"$f":"Questionnaire!E43","v":"Enter explanation"},{"$f":"Questionnaire!D43","v":"n/a"},{"$f":"IF(OR(D26=0,D26=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F45=\"x\",MAX($A$7:A26)+1,\"\")","v":""},{"$f":"Questionnaire!A45","v":"3.2"},{"$f":"Questionnaire!E45","v":"Enter explanation"},{"$f":"Questionnaire!D45","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F47=\"x\",MAX($A$7:A27)+1,\"\")","v":""},{"$f":"Questionnaire!A47","v":"3.3"},{"$f":"Questionnaire!E47","v":"Enter explanation"},{"$f":"Questionnaire!D47","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F49=\"x\",MAX($A$7:A28)+1,\"\")","v":""},{"$f":"Questionnaire!A49","v":"3.4"},{"$f":"Questionnaire!E49","v":"Enter explanation"},{"$f":"Questionnaire!D49","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F51=\"x\",MAX($A$7:A29)+1,\"\")","v":""},{"$f":"Questionnaire!A51","v":"3.5"},{"$f":"Questionnaire!E51","v":"Enter explanation"},{"$f":"Questionnaire!D51","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire!F54:F84,\"x\")>0,Questionnaire!A53,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire!F54:F84,\"x\")>0,Questionnaire!C53,\"\")","v":""}]
[{"$f":"IF(Questionnaire!F54=\"x\",MAX($A$7:A31)+1,\"\")","v":""},{"$f":"Questionnaire!A54","v":"4.1"},{"$f":"Questionnaire!E54","v":"Enter explanation"},{"$f":"Questionnaire!D54","v":"n/a"},{"$f":"IF(OR(D32=0,D32=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F56=\"x\",MAX($A$7:A32)+1,\"\")","v":""},{"$f":"Questionnaire!A56","v":"4.2"},{"$f":"Questionnaire!E56","v":"Enter explanation"},{"$f":"Questionnaire!D56","v":"n/a"},{"$f":"IF(OR(D33=0,D33=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F58=\"x\",MAX($A$7:A33)+1,\"\")","v":""},{"$f":"Questionnaire!A58","v":"4.3"},{"$f":"Questionnaire!E58","v":"Enter explanation"},{"$f":"Questionnaire!D58","v":"n/a"},{"$f":"IF(OR(D34=0,D34=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F60=\"x\",MAX($A$7:A34)+1,\"\")","v":""},{"$f":"Questionnaire!A60","v":"4.4"},{"$f":"Questionnaire!E60","v":"Enter explanation"},{"$f":"Questionnaire!D60","v":"n/a"},{"$f":"IF(OR(D35=0,D35=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F62=\"x\",MAX($A$7:A35)+1,\"\")","v":""},{"$f":"Questionnaire!A62","v":"4.5"},{"$f":"Questionnaire!E62","v":"Enter explanation"},{"$f":"Questionnaire!D62","v":"n/a"},{"$f":"IF(OR(D36=0,D36=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F64=\"x\",MAX($A$7:A36)+1,\"\")","v":""},{"$f":"Questionnaire!A64","v":"4.6"},{"$f":"Questionnaire!E64","v":"Enter explanation"},{"$f":"Questionnaire!D64","v":"n/a"},{"$f":"IF(OR(D37=0,D37=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F66=\"x\",MAX($A$7:A37)+1,\"\")","v":""},{"$f":"Questionnaire!A66","v":"4.7"},{"$f":"Questionnaire!E66","v":"Enter explanation"},{"$f":"Questionnaire!D66","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F68=\"x\",MAX($A$7:A38)+1,\"\")","v":""},{"$f":"Questionnaire!A68","v":"4.8"},{"$f":"Questionnaire!E68","v":"Enter explanation"},{"$f":"Questionnaire!D68","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F70=\"x\",MAX($A$7:A39)+1,\"\")","v":""},{"$f":"Questionnaire!A70","v":"4.9"},{"$f":"Questionnaire!E70","v":"Enter explanation"},{"$f":"Questionnaire!D70","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F72=\"x\",MAX($A$7:A40)+1,\"\")","v":""},{"$f":"Questionnaire!A72","v":"4.10"},{"$f":"Questionnaire!E72","v":"Enter explanation"},{"$f":"Questionnaire!D72","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F74=\"x\",MAX($A$7:A41)+1,\"\")","v":""},{"$f":"Questionnaire!A74","v":"4.11"},{"$f":"Questionnaire!E74","v":"Enter explanation"},{"$f":"Questionnaire!D74","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F76=\"x\",MAX($A$7:A42)+1,\"\")","v":""},{"$f":"Questionnaire!A76","v":"4.12"},{"$f":"Questionnaire!E76","v":"Enter explanation"},{"$f":"Questionnaire!D76","v":"n/a"},{"$f":"IF(OR(D43=0,D43=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F78=\"x\",MAX($A$7:A43)+1,\"\")","v":""},{"$f":"Questionnaire!A78","v":"4.13"},{"$f":"Questionnaire!E78","v":"Enter explanation"},{"$f":"Questionnaire!D78","v":"n/a"},{"$f":"IF(OR(D44=0,D44=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F80=\"x\",MAX($A$7:A44)+1,\"\")","v":""},{"$f":"Questionnaire!A80","v":"4.14"},{"$f":"Questionnaire!E80","v":"Enter explanation"},{"$f":"Questionnaire!D80","v":"n/a"},{"$f":"IF(OR(D45=0,D45=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F82=\"x\",MAX($A$7:A45)+1,\"\")","v":""},{"$f":"Questionnaire!A82","v":"4.15"},{"$f":"Questionnaire!E82","v":"Enter explanation"},{"$f":"Questionnaire!D82","v":"n/a"},{"$f":"IF(OR(D46=0,D46=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F84=\"x\",MAX($A$7:A46)+1,\"\")","v":""},{"$f":"Questionnaire!A84","v":"4.16"},{"$f":"Questionnaire!E84","v":"Enter explanation"},{"$f":"Questionnaire!D84","v":"n/a"},{"$f":"IF(OR(D47=0,D47=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire!F87:F99,\"x\")>0,Questionnaire!A86,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire!F87:F99,\"x\")>0,Questionnaire!C86,\"\")","v":""}]
[{"$f":"IF(Questionnaire!F87=\"x\",MAX($A$7:A48)+1,\"\")","v":""},{"$f":"Questionnaire!A87","v":"5.1"},{"$f":"Questionnaire!E87","v":"Enter explanation"},{"$f":"Questionnaire!D87","v":"n/a"},{"$f":"IF(OR(D49=0,D49=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F89=\"x\",MAX($A$7:A49)+1,\"\")","v":""},{"$f":"Questionnaire!A89","v":"5.2"},{"$f":"Questionnaire!E89","v":"Enter explanation"},{"$f":"Questionnaire!D89","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F91=\"x\",MAX($A$7:A50)+1,\"\")","v":""},{"$f":"Questionnaire!A93","v":"5.4"},{"$f":"Questionnaire!E93","v":"Enter explanation"},{"$f":"Questionnaire!D91","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F93=\"x\",MAX($A$7:A51)+1,\"\")","v":""},{"$f":"Questionnaire!A93","v":"5.4"},{"$f":"Questionnaire!E93","v":"Enter explanation"},{"$f":"Questionnaire!D93","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F95=\"x\",MAX($A$7:A52)+1,\"\")","v":""},{"$f":"Questionnaire!A95","v":"5.5"},{"$f":"Questionnaire!E95","v":"Enter explanation"},{"$f":"Questionnaire!D95","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F97=\"x\",MAX($A$7:A53)+1,\"\")","v":""},{"$f":"Questionnaire!A97","v":"5.6"},{"$f":"Questionnaire!E97","v":"Enter explanation"},{"$f":"Questionnaire!D97","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire!F99=\"x\",MAX($A$7:A54)+1,\"\")","v":""},{"$f":"Questionnaire!A99","v":"5.7"},{"$f":"Questionnaire!E99","v":"Enter explanation"},{"$f":"Questionnaire!D99","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire!F102:F108,\"x\")>0,Questionnaire!A101,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire!F102:F108,\"x\")>0,Questionnaire!C101,\"\")","v":""}]
[{"$f":"IF(Questionnaire!F102=\"x\",MAX($A$7:A56)+1,\"\")","v":""},{"$f":"Questionnaire!A102","v":"6.1"},{"$f":"Questionnaire!E102","v":"Enter explanation"},{"$f":"Questionnaire!D102","v":"n/a"},{"$f":"IF(OR(D57=0,D57=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F104=\"x\",MAX($A$7:A57)+1,\"\")","v":""},{"$f":"Questionnaire!A104","v":"6.2"},{"$f":"Questionnaire!E104","v":"Enter explanation"},{"$f":"Questionnaire!D104","v":"n/a"},{"$f":"IF(OR(D58=0,D58=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F106=\"x\",MAX($A$7:A58)+1,\"\")","v":""},{"$f":"Questionnaire!A106","v":"6.3"},{"$f":"Questionnaire!E106","v":"Enter explanation"},{"$f":"Questionnaire!D106","v":"n/a"},{"$f":"IF(OR(D59=0,D59=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire!F108=\"x\",MAX($A$7:A59)+1,\"\")","v":""},{"$f":"Questionnaire!A108","v":"6.4"},{"$f":"Questionnaire!E108","v":"Enter explanation"},{"$f":"Questionnaire!D108","v":"n/a"},{"$f":"IF(OR(D60=0,D60=4),\"yes\",\"no\")","v":"no"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"  "]

{"sheet":"Questionnaire_VDA","index":4,"n_rows":148,"n_cols":8,"rows_kept":148,"cut":false,"hidden":true,"merged":[[1,2,3,2],[122,3,122,5],[4,3,4,5],[63,3,63,5],[5,3,5,5],[48,3,48,5]]}
[]
[null,null,"     AUDIT QUESTIONNAIRE",null,null,"Company:",{"$f":"IF(Coversheet!I26=\"Process audit per VDA 6.3\",IF(Coversheet!C7=\"\",\"\",Coversheet!C7),\"\")","v":""}]
[null,null,null,null,null,"Audit Date:",{"$f":"IF(Coversheet!I26=\"Process audit per VDA 6.3\",IF(Coversheet!L46=\"\",\"\",Coversheet!L46),\"\")","v":""}]
[]
["NO.",null,"QUESTION","SCORE",null,null,"AUDIT FINDING(-S)","CA"]
["P2",null,"Project Management","General",null,null,{"$f":"$A$135&'Assessment matrix_VDA'!BB9&\"\n\"&$A$137&'Assessment matrix_VDA'!BA9&\" / 7\"","v":"Minimum questions to be answered: 5\nQuestions answered: 0 / 7"},{"$f":"\"Score: \"&IF('Assessment matrix_VDA'!AM9=\"n/a\",\"n/a\",('Assessment matrix_VDA'!AM9)*100&\"%\")","v":"Score: n/a"}]
["2.1",null,"Is a project management established with a project organization?","n/a",null,null,{"$f":"IF(D7=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D7=10,D7=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"A process for project management exists.\nAn interdisciplinary project organization is specified and contracts are defined.\nThe responsibilities and authority of the project leader and team members are defined.\nThe team members of the project are qualified to carry out their tasks.\nThe project organization meets the customer requirements.\nSuppliers are involved in project management",null,"Look for…",null,"Defined roles, tasks, competence and responsibilities of the project leader/technical expert\nProject interface in multi-site projects\nProject organizational chart\nComposition of the project team\nEvidence of qualifications\nSpecial customer requirements for project management"]
["2.2",null,"Are all resources required for the project implementation planned and available and are changes reported?","n/a",null,null,{"$f":"IF(D9=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D9=10,D9=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"Resource planning takes the customer requirements into account and is based on the contract covering the project.\nResource planning for project members is established and implemented. The staff workload has to be considered.\nReview and where necessary adjustment of resource planning is carried out when changes occur (dates, scope of development, performance, etc.). This applies to changes that are triggered by the customer as well as internal changes or supplier changes.\nThe critical path is given special consideration within the resource planning.\nThe necessary project budget for personnel and equipment (e.g. test and laboratory equipment) is planned and released.\nChanges in the project organization (interface with customer) are reported.",null,"Look for…",null,"Evidence of resource planning (taking other projects into account)\nResource planning for equipment (e.g. development test stand)"]
["2.3",null,"Is there a project plan and has this been agreed with the customer?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D11=10,D11=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"The project plan meets the specific customer requirements.\nAll internal and customer defined milestones are fully incorporated in the project plan.\nA review is carried out at the milestones defined in the project plan to check that all planned activities are carried out and that the level of maturity required is achieved.\nIf a statutory authorization procedure for a product is specifically required, the duration of this procedure is included in the project plan.\nIn-house communication is ensured when changes are made to the project plan. Changes made to the project plan which affect the customer are coordinated with the customer.\nThe critical path is generated from the project plan and takes account of critical delivery items.\nDetailed quality-related project activities must be part of the project plan. This may be in a separate document (QM Plan) that is referred to from the project plan. The plan must take prototypes and pre-launch parts into account.\nThe project plan must include the detailed activities concerning procurement. Detail plans may be in a separate document referred to in the project plan.",null,"Look for…",null,"Project plan with milestones\nSpecific customer requirements regarding technologies and/or product groups\nCustomer's project plan\nCustomer's deadlines\nCustomer's milestones\nCustomer's targets (measurements within the individual milestones)\nMilestone assessments (reviews)\nQuality Plan (e.g. from VDA, MLA or APQP)\nCountry specific certification requirements (ECE, SAE, DOT, CCC, …)\nLegal and regulatory approvals process of critical systems (electroplating, paint, ...)"]
["2.4",null,"Is the advanced product quality planning implemented within the project and monitored for compliance?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D13=10,D13=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"Quality-related project activities must meet the specific customer requirements.\nBoth product and process assurance measures are part of the advanced product quality planning.\nVerification and validation of the customer requirements are contained within the quality related planning.\nThe planning also addresses critical components and scope of supply (internal and external suppliers).\nThe planning is regularly monitored for compliance and for target achievements.",null,"Look for…",null,"Project plan\nCustomer milestones\nCustomer requirements in regard to quality plans\nCustomer specifications"]
["2.5","*","Are the procurement activities of the project implemented and monitored for compliance?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D15=10,D15=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"The activities have to ensure that only approved and quality-capable suppliers are used in production.\nThe level of activity depends on the risk classification of procured scope of suppliers.\nThese include the supplier selection and award criteria, award amount and delivery target date.\nThe transfer of customer requirements in the supply chain is ensured.\nThe activities also include customer required suppliers (directed suppliers) as stated within the agreement.\nThe suppliers for facilities, machinery, tools, test and measurement systems as well as services are integrated.\nThe appointment of suppliers must be traceable through appropriate documentation.\nDates for the assessment, supplier milestones and release have been laid down in the plan and coordinated with the overall schedule and the progress is monitored.",null,"Look for…",null,"Make or buy decisions\nSupplier selection criteria\nSupplier development plan\nList of suppliers for the project\nList of approved suppliers\nRisk appraisal of each supplier\nQuality agreement for directed suppliers\nComponent classification\nSuppliers for services such as development, laboratories and maintenance etc."]
["2.6","*","Is change management within the project ensured by the project organization?  ","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D17=10,D17=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"Is change management within the project meets the customer's specific requirements?\nChanges (initiated by the supplier, internally or by the customer) must be evaluated and if necessary the project plan must be adapted. This evaluation must include the risk assessment for the product quality as well as the deadlines.\nSuppliers (critical supplies) are actively involved in change management.\nChanges are reported in a timely manner and are agreed upon with the customer.\nAdherence to defined design freeze steps must be ensured. Exceptions must be agreed upon and documented between the customer and the supplier.\nAll changes must be documented.\nThe persons responsible for change management are defined for the customer, internally and to suppliers. ",null,"Look for…",null,"Time schedules\nProcess description\nChange management\nChange forms\nChange history for the product and the process\nEvaluation of change\nApprovals of changes"]
["2.7",null,"Is there an escalation process established and is this effectively implemented?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D19=10,D19=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"The escalation process in the project meets the specific customer requirements.\nAn escalation model (risk management) must be available for deviations in the project affecting the overall schedule. Project risks are identified, assessed and reduced through appropriate measures.\nThe criteria for escalation are defined, responsibilities and authorities are regulated and measures derived when deviations occur.\nIf risks have been identified in technologies, suppliers and supplied countries, these risks have to be considered within the escalation management.",null,"Look for…",null,"Time periods for escalation depending on the risk have been agreed upon\nContact personnel/decision makers in the escalation process are defined\nEscalation criteria and paths of communication are defined\nProtocols of milestone reviews including measures"]
["P3",null,"Planning the Product & Process Development","Product","Process",null,{"$f":"$A$135&'Assessment matrix_VDA'!BB14&\" (product)\"&\"\n\"&$A$137&'Assessment matrix_VDA'!BA14&\" / 5\"&\"\n\"&$A$135&'Assessment matrix_VDA'!BH14&\" (process)\"&\"\n\"&$A$137&'Assessment matrix_VDA'!BG14&\" / 5\"","v":"Minimum questions to be answered: 4 (product)\nQuestions answered: 0 / 5\nMinimum questions to be answered: 4 (process)\nQuestions answered: 0 / 5"},{"$f":"\"Score: \"&IF('Assessment matrix_VDA'!AM14=\"n/a\",\"n/a\",('Assessment matrix_VDA'!AM14)*100&\"%\")","v":"Score: n/a"}]
["3.1",null,"Are the specific product and process requirements available?","n/a","n/a",null,{"$f":"IF(AND(D22=10,E22=10),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D22<10,E22<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"All requirements regarding the product to be developed are known.\nFor products with embedded software, the requirements at interfaces between hardware and software are defined. Requirements management is implemented for this.\nThe organization must determine the logistical requirements and the statutory and regulatory requirements relevant for the product that are necessary to meet specific customer requirements.\nThe organization must take into account and use requirements on the product and the process known from previous experience.\nSpecial characteristics must be identified on the basis of their own requirements, customer requirements, legal requirements, manufacturing technology and characteristics that arise from the purpose/use of the product.\nThe quality requirements from the customer for the product and the process must be available.\nInquiry and contract documents are checked for completeness.\nIf customer requirements cannot be fulfilled, the customer must be notified or deviations \"allowed\"/approved by the customer (if the contract has been awarded).\nCustomer requirements regarding the selection of suppliers or purchased materials must be documented.\nQuality agreements with directed suppliers are available.",null,"Look for…",null,"Inquiry documents\nContract documents\nRequirement specifications (product, process)\nCustomer requirements\nLegal requirements\nPurchasing conditions\nQM specific requirements\nQuality agreements\nRequirements for documentation\nLogistics requirements (JIT, JIS, on consignment)\nSchedules, technical delivery conditions\nAccess to portals/information platform in the internet\nDefinition of responsibilities for suppliers (e.g. qualification, sample submissions, approval, testing…)\nTest regulations\nCatalogue of characters tics/boundary samples for decorative surfaces\nExperience with previous projects\nProduct/process characteristics\nOrder documents with item lists and schedules\nLegislation/regulations\nEnvironmental aspects, recycling requirements\nProof of capability\n\nProduct development\nSpecifications, technical drawings, special characteristics\n\nProcess development\nSuitability of facilities, tools and test and inspection equipment\nLayout of work and test facilities\nHandling, packaging, storage and identification"]
["3.2","*","Is the feasibility comprehensively evaluated according to the product and process requirements?*","n/a","n/a",null,{"$f":"IF(AND(D24=10,E24=10),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D24<10,E24<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"An interdisciplinary procedure for evaluating the feasibility must be used.\nAll determined product and process specific requirements (technology, function, quality, logistics, software, ...) must be checked for feasibility.\nMaterial and personnel resources must be considered in the feasibility study.\nThe results of the feasibility study must be available before tendering.\nThe feasibility of critical purchased parts must be ensured.\nIf customer requirements cannot be fulfilled the customer must be notified or deviations \"allowed\"/approved by the customer (if the contract has been awarded).",null,"Look for…",null,"Product/process development\nCustomer specifications and standards\nSchedules, timeframes\nRegulations, standards, legislation, environmental impact\nRequirements from product liability\nBuildings, premises\nCAM, CAQ\nProduct/process innovation\nInterdisciplinary feasibility analysis (for example, sales, development, purchasing, production planning, production, QM planning, logistics)\n\nProduct development\nLaboratory/test equipment\n\nProcess development\nCapacity monitoring\nAvailability of incoming materials\nManufacturing possibilities, manufacturing sites\nEquipment, tools, production/test equipment, auxiliary materials, laboratory facilities, transport, container, storage"]
["3.3",null,"Are the activities for the product and process development planned in detail?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D26<10,E26<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"When planning the product and process development the level of details is dependent on the component, software and complexity of the process.\nIn the development phase, suitable methods must be used to secure the product and process development so that when the product foes into serial production it fulfils the operational conditions (function, reliability, safety). This must be considered in the planning.\nRisk analysis (Product FMEA and process FMEA or similar methods) are part of the planning.\nAt the planning stage, the development of new products and processes should take into account the requirements of the product operational conditions.\nThe time schedules contain all information for product and process development (including deadlines and length of time, milestones within the overall project plan, performance testing, PPA-date, Software standards...).\nMethods for development release meet customer requirements and must be clarified with the customer if deviations occur.\nActivities related to the procurement scope are planned and are consistent with the overall schedule.\nOutsourced processes and services are part of the project planning.",null,"Look for…",null,"Product/process development\nOverall project plan including all deadlines\nCustomer requirements\nInspection planning for the layout inspection\nCustomer schedule\nLead times\nDeadlines for the procurement release, supplier approval and change stop\nMethods used to minimize risk (QFD, FMEA, statistical test plan e.g. DoE, Shainin, Taguchi)\nDetailed plans for prototypes/pre-launch planning\nRegular status checks on the progress of the development (reviews)\nProject plans for investment items (facilities and equipment)\nLogistics planning for all phases of the of product and process development including packaging\nConcept for spare parts\n\nProduct development\nDetailed planning for reliability testing, functional testing, trial plan\nDeadline for development phase samples\n\nProcess development\nDeadlines for the performance test, tool timing plans (off tool parts)\nDetailed planning for inspection plans, test equipment plans and maintenance plans including spare parts management"]
["3.4",null,"Are the activities planned for customer care / customer satisfaction / customer service and field failure analysis?","n/a","n/a",null,{"$f":"IF(AND(D28=10,E28=10),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D28<10,E28<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The customer requirements for the supply of parts across the product life cycle are taken into account in the planning.\nConcepts to continually ensure series supply including a contingency plan are provided in the planning phase.\nA fallback concept is provided for product and process innovation.\nThe analysis for 0-km and field complaints is planned for delivery. The customer requirements are taken into account for field failure analysis.\nWhen introducing new technologies and products, employee training and the creation of the necessary infrastructure are provided also in customer service.",null,"Look for…",null,"Product/process development\nTraining plan\nQualification matrix\nInvestment planning\n\nProcess development\nInspection planning for standard and stress testing\nTriggering criteria are defined\nNTF process\nConcept for the supply of spare parts\nContingency plans"]
["3.5",null,"Have the necessary resources been taken into account for the product and process development?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D30<10,E30<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The procedure for determining resources is implemented.\nDetermination of resources refers to the availability of qualified personnel, budget, infrastructure such as building, test and inspection equipment (hardware and software), laboratory facilities, machines and equipment...\nCapacity for the implementation of prototypes and prototype construction, pilot-run, performance test and serial production must be planned and considered.\nThe resource planning is regularly adapted to changes in the project and potential bottlenecks are to be considered.",null,"Look for…",null,"Product/process development\nCAx equipment\nAvailability of qualified personnel for respective tasks\nCapacity planning for all the resources\n\nProduct development\nTest/inspection/laboratory equipment (internal & external)\n\nProcess development\nProduction sites, tools, production and test equipment"]
["P4",null,"Implementation of the Product & Process Development","Product","Process",null,{"$f":"$A$135&'Assessment matrix_VDA'!BB19&\" (product)\"&\"\n\"&$A$137&'Assessment matrix_VDA'!BA19&\" / 6\"&\"\n\"&$A$135&'Assessment matrix_VDA'!BH19&\" (process)\"&\"\n\"&$A$137&'Assessment matrix_VDA'!BG19&\" / 8\"","v":"Minimum questions to be answered: 4 (product)\nQuestions answered: 0 / 6\nMinimum questions to be answered: 6 (process)\nQuestions answered: 0 / 8"},{"$f":"\"Score: \"&IF('Assessment matrix_VDA'!AM19=\"n/a\",\"n/a\",('Assessment matrix_VDA'!AM19)*100&\"%\")","v":"Score: n/a"}]
["4.1","*","Are the actions from the product and process development plans implemented?","n/a","n/a",null,{"$f":"IF(AND(D33=10,E33=10),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D33<10,E33<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Methods for the product and process development defined in the development planning are applied and implemented in such a way as to ensure fulfillment of requirements (function, reliability, safety).\nIn the development phase a risk analysis (such as FMEA) must be used to ensure that the product and process comply with requirements of the customer in terms of function, reliability, etc. When carrying out a risk analysis (for example a product FMEA) the proposed manufacturing site for the production must be involved.\nSpecial characteristics are defined and identified in the relevant documents (FMEAs, etc.) and necessary action is taken to ensure conformity.\nIn the overall plan, a test plan must be included for the components, assemblies, subassemblies, components, software and materials. The overall plan must also include manufacturing processes from prototype and pre-launch phase.\nAll purchased products and services are taken into account. The implementation of product and process development is ensured in the supply chain.\nThe documentation of lessons learned from the prototype phase and the pre-launch phase are available for reference in the series phase.\nThe requirements for test equipment are defined and implemented.",null,"Look for…",null,"Product/process development\nMethods to minimize risk (QFD, FMEA)\nDesign of experiments (e.g. Shainin, Taguchi…)\nPoka-Yoke principles\n\nProduct development\nTest planning\nAssembly test and system test\nA, B, C samples\nAutomotive SPICE\nEndurance tests\nEnvironmental simulation test (e.g. salt spray test)\n\nProcess development\nControl plan/inspection plan"]
["4.2",null,"Are personnel resources available and are they qualified to ensure the start of the serial production?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D35<10,E35<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"A staff schedule must be available.\nPersonnel must be qualified for their respective tasks. This also applied to the staff of external service providers. Appropriate evidence must be available.\nNeeds assessment will be carried out regularly during product and process development with regard to possible emerging bottleneck and additional requirements.\nQualified workforce resources are available for prototype building and sample building. Workforce resources for pre-launch, production start-up and serial production are planned and personnel are qualified in accordance with the project plan.\nProcesses that have been outsourced must be considered.",null,"Look for…",null,"Product/process development\nCustomer requirements\nRequirements profile for the relevant positions\nDetermination of the need for training\nEvidence of training\nKnowledge of methods and foreign languages"]
["4.3",null,"Are the material resources available and suitable to ensure the start of the serial production?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D37<10,E37<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"A process to determine resources has been implemented.\nResource determination refers to the availability of measuring and test equipment, laboratory equipment, machinery, equipment, and the utilization of the machinery and equipment. Supporting processes must be considered.\nWithin the resource determination the necessary infrastructure is taken into account.\nRegular need assessment must be carried out during product and process development with regard to possible emerging bottlenecks and additional needs.\nMaterial resources for the realization of prototypes and sample building are available. Material resources for pre-production, series start and serial production is planned and provided in accordance with the project plan.\nOutsourced processes must be considered.\nThe resources must be available with a suitable lead time before the start of customer's serial production.",null,"Look for…",null,"Product/process development\nCustomer requirements\nTechnical interface to customer and suppliers\n\nProduct development\nTest planning\n\nProcess development\nFacility planning\nFacility layout\nMachinery and equipment planning\nQuantities and throughput times\nTransport routes\nTransport, containers, storage\nCapacity before series start (initial stock)\nSupporting processes for example from logistics und IT"]
["4.4","*","Are the required approvals and releases for the product and process development available?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D39<10,E39<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The release and verification of suitability is demonstrated for all the items, assemblies, software versions and purchased products and services in accordance with development schedule.\nThe material data is confirmed and released.\nThe actions from the risk analysis (for example FMEA) have been implemented and confirmed in their effectiveness.\nThe production process and product approval (PPA) must be available on the agreed date. For products with embedded software an additional software test report is available.\nReference parts from sampling must be kept for at least the time laid down in the customer requirements.\nThe verification and validation of the product and process are ensured before the customer SOP.",null,"Look for…",null,"Product/process development\nTest reports, protocols\nEvidence related to purchased parts/suppliers\nSampling results\n\nProduct development\nSpecifications, technical drawings, requirement specifications\nFMEA\nIMDS, REACH, RoHS\nProduct test (e.g. assembly test, function test, endurance test, environmental simulation)\nPrototypes\nConfirmation of conformity with legal requirements\nDevelopment releases from customers\n\nProcess development\nLogistics concept (e.g. suitability of packaging through sample shipping)\nProof of capability of special characteristics\nCapacity studies\nTool approvals"]
["4.5",null,"Are the manufacturing and inspection specifications derived from the product and process development and are they implemented?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D41<10,E41<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The manufacturing and inspection specifications contain all characteristics from the product and process development (including serial characteristics). These must take into account all the components, assemblies, subassemblies, parts, software and materials including the processes for manufacturing of products.\nResults from the risk analysis are considered.\nThe specifications include information for product control, manufacturing process control, methods and reaction plans and corrective actions.\nProduct audits, layout inspection and functional testing are defined.\nThe specifications must be available for all phases: prototype phase (if required by the customer), pre-launch and series phase.",null,"Look for…",null,"Product development\nRisk analysis (FMEA, FTA, etc.)\nControl plan (prototypes pre-launch)\n\nProcess development\nRisk analysis (FMEA, FTA etc.)\nControl plan (pre-series, series)\nProduct audit plan\nInspection instruction\nReaction plan\nLayout inspection planning\nSeries release (first and last piece)\nIn-line inspections"]
["4.6",null,"Is a performance test carried out under series conditions for the series release?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D43<10,E43<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"A performance test must be carried out in time to assess all production factors and influences and if necessary corrections must be done.\nThe performance test has provided evidence that the quality capability of the entire production process is given under serial production conditions (tools, equipment, cycle time, personnel, manufacturing and inspection specifications, measuring and test and inspection equipment...).\nNote: Depending on the time of the audit some parts of the relevant production test could still be at the planning stage!\nThe questions is not relevant for the product development (n/a - not applicable)!",null,"Look for…",null,"Process development\nCustomer requirements\nDetermination of minimum quantities (intended production rate and flexibility as agreed upon)\nProcess capability study\nMeasurement capability\nCapability of measurement processes\nEquipment and infrastructure are ready for start of serial production (measurement reports)\nStaff concept for serial production\nWork/inspection instructions\nPackaging requirements\nProcess validation"]
["4.7",null,"Are the processes established for securing customer care / customer satisfaction / customer service as well as the field failure analysis?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D45<10,E45<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The customer requirements for the supply of parts during the product lifecycle are established in the processes.\nThe planned processes for the continuous series supply including safety margins for emergencies are available.\nThe analysis process for 0-km and field complains is established for the scope of delivery. The customer requirements for field failure analysis are taken into account.\nThe requirements for the analysis capability at the site have been agreed with the customer.\nIf external sites are used for analysis, the interfaces are defined and evidence of the presence of the required equipment and capacity is available.\nNew technologies and products are also taken into account in customer support.\nThe employees designated for these processes are qualified. The infrastructure is available.\nThe questions is not relevant for the product development (n/a - not applicable)!",null,"Look for…",null,"Process Development\nEvidence of training\nQualification matrix\nExistence of infrastructure and test equipment\nService agreements with external analysis sites\nEquipment for standard and stress tests\nTriggering criteria are defined\nNTF process\nConcept to ensure supply of spare parts\nContingency plans"]
["4.8","*","Is there a controlled method for the product handover from development to serial production?","n/a","n/a",null,"Enter explanation",{"$f":"IF(OR(D47<10,E47<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"A process exists for transferring work results from the project to the production.\nFor products with the embedded software, the results of the development (including the intermediate results and their documentation) are documented.\nPrerequisite for project delivery is a successful internal PPA process. Prerequisite for a series delivery release is the successful customer approval. Resulting actions from the internal and external releases are implemented on time.\nProof of capability can be shown for all special characteristics.\nThe personnel resources are available in accordance with the planning and are qualified.\nThe material resources include buildings, test facilities, laboratory facilities, equipment, facilities, etc.\nThese are available and have been released.\nReleases for procurement volumes are available.\nMeasures to secure the production start-up are specified and introduced when necessary.",null,"Look for…",null,"Product/process development\nCustomer requirements\nHandover protocols/ checklists with handover criteria\nAcceptance reports\nControl plan\nInspection instructions\nPart history\nA method has been determined to carry out failure analysis and to introduce corrective actions\nProduction metrics such as OEE, rejects, ...\nExperience from the ongoing project\nMeasurement capability\nCapability of Measurement process"]
["P5",null,"Supplier Management","General",null,null,{"$f":"$A$135&'Assessment matrix_VDA'!BB23&\"\n\"&$A$137&'Assessment matrix_VDA'!BA23&\" / 7\"","v":"Minimum questions to be answered: 5\nQuestions answered: 0 / 7"},{"$f":"\"Score: \"&IF('Assessment matrix_VDA'!AM23=\"n/a\",\"n/a\",('Assessment matrix_VDA'!AM23)*100&\"%\")","v":"Score: n/a"}]
["5.1",null,"Are only approved and quality-capable suppliers used?","n/a",null,null,{"$f":"IF(D50=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D50=10,D50=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"In serial production it must be ensured that only approved suppliers are used. An evaluation of suppliers using defined criteria for the qualification capability must be available.\nAn analysis of the quality performance of existing suppliers has to be considered.\nRisks in the supply chain have been identified, evaluated and reduced using suitable measures (contingency strategy).",null,"Look for…",null,"Defined and documented criteria are used for supplier selection\nEvidence of a qualification program for suppliers who did not meet the selection criteria\nEvaluation of the quality capability (QM-System, Process) for example self assessment, audit results, supplier certificates\nResults of the potential analysis\n\nCan also be used for:\nResearch and development suppliers/prototype suppliers\nSuppliers of intangible products such as software\nSuppliers of equipment, machinery, tools\nService providers (e.g. sorting companies)\nExternal test labs\nSuppliers in outsourced processes\nTransmission of requirements, tolerances, time schedule, process releases, releases, complaints etc. with ensuring change management\nQuality agreement\nQAA (quality assurance agreements)\nLegal and regulatory requirements"]
["5.2",null,"Are customer requirements taken into account in the supply chain?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D52=10,D52=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"The communication of customer requirements must be regulated and traceable.\nCustomer requirements also include requirements from technical drawings, components, software or component specifications, from QM agreements and other valid standards.\nChange management must also be considered during serial production.\nInterfaces are identified and secured.",null,"Look for…",null,"Transmission of requirements, tolerances, time schedule, process releases, releases, complaints etc. with ensuring change management\nQuality agreement\nQAA (quality assurance agreements)\nLegal and regulatory requirements"]
["5.3",null,"Have target agreements for supplier performance been agreed upon and implemented?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D54=10,D54=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"Target agreements have been made with all suppliers throughout the supply chain for products and\nprocesses. These agreements have been agreed upon and implemented.\nSupplier output must be checked and evaluated within defined periods.\nIf deviations occur actions must be agreed upon and their implementation including deadlines is to be monitored.",null,"Look for…",null,"Measurable targets for quality, delivery quantity (batches), punctuality, for example to: reduce the ppm rates with in the 0-failure strategy\nQM agreements including escalation mechanisms\nAvoidance of extra tours\nReduction of rejects\nReduction of the work in progress"]
["5.4","*","Are the necessary releases/approvals available for purchased products and services?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D56=10,D56=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"A release must be available for all purchased products and services before serial production of new/changed products/processes.\nUnless otherwise specified, the supplier for the supply of modules has the full quality control responsibility for all individual components.",null,"Look for…",null,"Specifications/standards/test instructions\nPPA-Reports when necessary with software test reports\nProof of capability for special characteristics\nLegal/country specific requirements (e.g. CCC, Inmetro, IMDS, REACH)\nQualification tests/reports\nModel releases\nChange management in the supply chain\nApproval agreements for the scope of small batches and individual requirements"]
["5.5","*","Is the agreed upon quality of the purchased products and services ensured?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D58=10,D58=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"To monitor the quality of purchased products and services, regular checks are carried out, documented and evaluated.\nDeviations from the supplier quality are processed through a standard complaint process.\nLayout inspections are carried out according to customer requirements.\nTest and measuring equipment must be sufficiently available to check purchased products. The equipment must be stored in an orderly manner and associated work-stations must be laid out appropriately (e.g. climate control, lighting conditions, cleanliness, and protection against damage and contamination).",null,"Look for…",null,"Coordination of test/inspection procedures, processes and frequencies\nReference parts\nSample size (e.g. Skip Lot)\nEvaluation of main failures\nppm evaluations, 8D reports\nAgreement and tracking of improvement programs\nTest possibilities (internal and external laboratories and test facilities, testing in accordance with ISO/IEC 17025) for raw materials (material certificates) and finished parts\nGauges/fixtures\nTechnical drawings/specifications\nOrdering and packaging specifications\nProof of capability\nLayout inspections/reports\nTest certificates"]
["5.6",null,"Are incoming goods delivered and stored appropriately?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D60=10,D60=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"Incoming materials and loading equipment must be stored in accordance with their release status so that they cannot be damaged or mixed.\nFor materials that could be damaged by temperature, humidity, vibration, etc. and affect the quality of the final product, the transport and storage conditions must be defined and evidence shown.\nTerms of transport should be determined for critical incoming materials.\n\"Suspect\"/quarantined products must be stored securely to prevent unauthorized access to them.\nFIFO and batch traceability are to be ensured when the materials and goods are further processed.\nMaterial stock figures in the inventory control agree with the quantities actually in stock.\nStorage conditions conform to the product requirements.",null,"Look for…",null,"Packing\nInventory control\nLabelling (traceability/test status/work sequence/use status)\nQuarantine stores; quarantine areas\nFIFO\nBatch-related use\nShelf life requirements\nClimatic conditions\nProtection against damage/contamination/corrosion\nOrder and cleanliness\nPrecautions to prevent mixing/mistakes\nRemaining quantities from production"]
["5.7",null,"Are personnel qualified for their respective tasks and are responsibilities defined?","n/a",null,null,"Enter explanation",{"$f":"IF(OR(D62=10,D62=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"A description must be given of what responsibilities, tasks and authority the employees have in their relevant work areas (e.g. for incoming inspection, complaint processing, supplier management, supplier audit).\nQualification requirements must be determined for each employee in relation to their tasks and qualifications carried out accordingly.\nKnowledge of previous complaints is available when appropriate for purchased products and services.",null,"Look for…",null,"Product/specifications/customer requirements\nKnowledge about product features and production process for the individual parts of modules\nStandards/legislation\nPackaging requirements\nAssessment methods (e.g. audits, statistics)\nQuality procedures (e.g. 8D method, cause/effect diagram)\nComplaints and corrective action\nJob/function descriptions\nQualification matrix\nForeign languages\nQualification of supplier auditors"]
["P6",null,"Process Analysis / Production","Process steps",null,null,{"$f":"$A$136&'Assessment matrix_VDA'!BB29&\"\n\"&$A$138&'Assessment matrix_VDA'!BA29&\" / 26\"&\"\n\"&IF(E65=\"\",\"\",$A$139&'Assessment matrix_VDA'!BA31&\" / 26\")&\"\n\"&IF(F65=\"\",\"\",$A$140&'Assessment matrix_VDA'!BA33&\" / 26\")","v":"Minimum questions to be answered for each step: 17\nQuestions answered PS1: 0 / 26\nQuestions answered PS2: 0 / 26\nQuestions answered PS3: 0 / 26"},{"$f":"\"Score: \"&IF('Assessment matrix_VDA'!AM37=\"n/a\",\"n/a\",('Assessment matrix_VDA'!AM37)*100&\"%\")","v":"Score: n/a"}]
["6.1",null,"What goes into the process? (Process input)",{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$28=\"\",\"\",Coversheet!$I$28))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$29=\"\",\"\",Coversheet!$I$29))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$30=\"\",\"\",Coversheet!$I$30))","v":false}]
["6.1.1",null,"Has the project been transferred from development to serial production and is a reliable start guaranteed?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D66=10,E66=10,F66=10),AND(D66=10,E66=\"\",F66=\"\"),AND(D66=10,E66=10,F66=\"\"),AND(D66=10,E66=\"\",F66=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D66<10,E66<10,F66<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The project transfer to serial production has been carried out. If necessary, unresolved issues are followed up on and implemented on schedule. The responsibilities for the entire handover process are regulated and acknowledged.\nA complete production process and product release (PPA) including the documentation required must take place before the first production shipment.\nMeasures are taken to secure the launch of production.\nThe updating and further development of the risk analysis (e.g. process FMEA/product FMEA) is ensured.\nTools, test and measuring equipment are available in the necessary quantities.",null,"Look for…",null,"Project status reports\nTransfer reports\nMilestone reports\nDefined actions with implementation schedule\nProcess FMEA and actions\nProduct FMEA and actions\nProduction release report\nMachine and process capability examination\nMeasurement capability\nCapability of measurement process\nProduction test/performance test and evidence\nTransport planning process\nPPA documents including customer release and reference sample\nNon-conformity permission when necessary\nReleased software standard"]
["6.1.2",null,"Are the necessary quantities/production batch sizes of incoming materials available at the agreed upon time and at the correct storage location/work-station?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D68=10,E68=10,F68=10),AND(D68=10,E68=\"\",F68=\"\"),AND(D68=10,E68=10,F68=\"\"),AND(D68=10,E68=\"\",F68=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D68<10,E68<10,F68<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The correct product (incoming material, part, component etc.) must be provided to the agreed quality, in the correct quantity and the correct packing, with the correct documentation, at the agreed time and at the agreed place. Parts/components must be available at defined storage areas/work-stations.\nAt the workplace, parts and materials are provided as needed, taking into account the order quantity/lot size (for example, KANBAN, Just in time, FIFO). Upstream processes are taken into account.\nAfter order completion, the return of unneeded parts (surplus) including their quantity is regulated.",null,"Look for…",null,"Sufficient and appropriate transport facilities\nDefined storage points\nKANBAN\nJust in time/just in sequence\nInventory control\nChange status\nExchange of information to the return of unnecessary components/surplus\nInventory\nProduction levels tailored to the customer's requirements\nSpecial requirements for components and containers (ESD-protection for electronic components, residue etc.)"]
["6.1.3",null,"Are incoming materials stored appropriately and are the means of transport/packing facilities suitable for the special characteristics of the incoming materials?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D70=10,E70=10,F70=10),AND(D70=10,E70=\"\",F70=\"\"),AND(D70=10,E70=10,F70=\"\"),AND(D70=10,E70=\"\",F70=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D70<10,E70<10,F70<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Packaging requirements must be consistently taken into account/implemented (also in the production stages).\nDuring manufacture and internal transport and also when being transported to and from service companies, suitable transport units must be used to protect the products from damage and contamination.\nStore areas/work-stations/containers must be appropriate for the tidiness and cleanliness required for the parts/products. Cleaning cycles are defined and monitored.\nThe supply of parts/materials at the work-station/on the assembly line must allow for safe handling.\nSpecified storage times and use-by dates for special materials/parts must be monitored by appropriate methods (maximum and minimum storage times, specified interim storage times).\nCritical operating and consumable materials for plant and machinery with a direct effect on the product/product quality must be monitored accordingly.\nParts/incoming materials/critical operating and consumable materials must be protected against environmental and climatic influences.",null,"Look for…",null,"Stock quantities\nStorage conditions\nReleased special and standard transport containers\nPackaging requirements\nIn-house transport containers\nProtection against damage\nPositioning of parts in the workplace\nCleanliness, order\nOver-filling (bins and containers)\nMonitoring of storage times"]
["6.1.4",null,"Are the necessary identifications/records/releases available and allocated appropriately to the incoming materials?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D72=10,E72=10,F72=10),AND(D72=10,E72=\"\",F72=\"\"),AND(D72=10,E72=10,F72=\"\"),AND(D72=10,E72=\"\",F72=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D72<10,E72<10,F72<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Released incoming materials must be clearly identified and recognizable. The release status must be identifiable and the release identification on bundles/batches/load containers/parts must be defined.\nIt must be ensured that only released materials/parts are forwarded to production/the next process stage and used.\nThe traceability of the units produced must be ensured within a reasonable framework (e.g., documentation, batch installation).\nDepending on the product risk, traceability must be guaranteed across the entire process chain, from sub-supplier to the customer.\nCustomer identification and traceability requirements must be taken into account.\nLegal and regulatory requirements are taken into account.\nTest results of characteristics with special requirements for documentation and archiving are recorded accordingly.",null,"Look for…",null,"Customer specifications\nCustomer requirements for labelling and tracing\nLegal requirements, product liability legislation\nIdentification of replacement parts\nProcess for the release of parts/materials\nIdentification of released parts/materials (stickers, labels, issue slips,...)\nRecords of approvals\nTraceability system/concept\nDocumentation of concessions (number, duration, type of identification,...)"]
["6.1.5","*","Are changes to the product or process in the course of serial production tracked and documented? ","n/a","n/a","n/a",{"$f":"IF(OR(AND(D74=10,E74=10,F74=10),AND(D74=10,E74=\"\",F74=\"\"),AND(D74=10,E74=10,F74=\"\"),AND(D74=10,E74=\"\",F74=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D74<10,E74<10,F74<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Change management, meaning from the change request to the implementation, must be clearly documented. Responsibilities must be regulated.\nAccording to customer requirements changes to the product and process are to be agreed upon, approved and released by the customer (including software changes). If necessary a new PPA must be carried out. Documentation of change status must be fully traceable.\nIt must be ensured that, at all times, the correct design level of the incoming materials or software is used and the correct design level of the finished product is manufactured and shipped to the customer.",null,"Look for…",null,"Trigger matrix in accordance with VDA Volume 2\nChange release by the organization and the customer (feasibility, interface to components, effect on costs and schedules etc.)\nInformation about changes is passed onto process development, production areas, stores or to sub-suppliers\nThe level of implementation of the change is tracked (overview with status)\nDocumented change record (part life history)\nUpdate of documentation involved (technical drawings, instructions)\nUpdates of the FMEA (Product and Process)\nVerification and validation of changes including documentation\nControlled introduction of changes and modified products/parts\nLayout production before major changes or relocations which require a production stop. Lead times from changes (customer requirements etc.)\nChange levels of test/inspection equipment, gauges, tools and technical drawings\nParameter changes\nSoftware"]
["6.2",null,"Are all production process controlled? (Process management)",{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$28=\"\",\"\",Coversheet!$I$28))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$29=\"\",\"\",Coversheet!$I$29))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$30=\"\",\"\",Coversheet!$I$30))","v":false}]
["6.2.1",null,"Are the requirements of the control plan complete and have they been effectively implemented?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D77=10,E77=10,F77=10),AND(D77=10,E77=\"\",F77=\"\"),AND(D77=10,E77=10,F77=\"\"),AND(D77=10,E77=\"\",F77=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D77<10,E77<10,F77<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The production and test documents are complete and available and based on the control plan. Inspection characteristics, facilities, methods, test frequencies, test cycles and layout inspections must be defined.\nAccess to these documents must be available at all times.\nProcess parameters influencing product characteristics/quality must be fully stated. Tolerances must be given for process parameters and inspection characteristics.\nThe control limits in process control charts are defined, identifiable and plausible.\nDeviations and actions taken regarding process requirements and inspection characteristics are to be documented.\nRequired measures (response plan) for process disturbances are known and initiated and documented by the responsible employees.\nFor products with specific requirements on the manufacturing process the appropriate data about machinery/tools/resources must be noted in the control plan and/or the manufacturing and inspection documents.\nConditions governing rework are specified and secured within the process (parts identification; rechecking/inspection etc.).",null,"Look for…",null,"Evidence of machine and process capability\nProcess parameters and tolerances (pressure, temperatures, times, speeds etc..)\nInspection specifications (special characteristics, attributive characteristics, measurement equipment, methods, test frequency)\nData regarding machines/tools/auxiliary aids (identification numbers)\nGuidelines regarding measurement fixtures/reference points\nWork instructions including reworking\nInspection instructions\nSpecific requirements on the manufacturing technology, e.g. sampling relevant assignment of machines and plants"]
["6.2.2",null,"Does a repeat release for the restart of production take place?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D79=10,E79=10,F79=10),AND(D79=10,E79=\"\",F79=\"\"),AND(D79=10,E79=10,F79=\"\"),AND(D79=10,E79=\"\",F79=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D79<10,E79<10,F79<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The production repeat release is the order-related approval for production start-up.\nCriteria for triggering a production repeat release must be defined e.g. after an interruption of production.\nA repeat release is necessary for product and process and must be carried out and documented by authorized employees using acceptance criteria. Deviations and measures taken are to be documented.\nA repeat release inspection must be carried out using clear inspection instructions (quantity and method).\nIf production is continued after collection of samples, parts should be isolated until the samples are approved.\nAt the time of release the necessary reference and tolerance samples must be available.",null,"Look for…",null,"Release of a batch\nRelease of reworked parts\nFirst piece release/first part release\nTooling diagrams/reference parts/installation parts (e.g. defect identification)\nPossible triggering criteria for a repeat release:\n  *Production interruption (e.g. night time in two shift operations, tool changes, material/batch/product change)\n  *Repair, tool change\n  *Setting data"]
["6.2.3","*","Are special characteristics managed in the production?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D81=10,E81=10,F81=10),AND(D81=10,E81=\"\",F81=\"\"),AND(D81=10,E81=10,F81=\"\"),AND(D81=10,E81=\"\",F81=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D81<10,E81<10,F81<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Special product characteristics and process parameters that affect the special characteristics are marked in the control plan and systematically monitored.\nRecords are maintained of non-compliances and corrective actions. Deviations affecting the characteristics of the product must be approved by the customer.\nQuality records are specified for significant characteristics (duration and type of archiving) and are coordinated with the customer.",null,"Look for…",null,"Product FMEA/process FMEA\nControl plan\nQuality records\nStatistical evaluations\nSPC evaluations\nQuality control charts\nProof of capability Cpk, Cmk, machine capability checks etc.\nCapability of measurement processes analyses\nInspection results\nTechnical drawings\nSpecial characteristics"]
["6.2.4","*","Are non-approved and/or defective parts managed?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D83=10,E83=10,F83=10),AND(D83=10,E83=\"\",F83=\"\"),AND(D83=10,E83=10,F83=\"\"),AND(D83=10,E83=\"\",F83=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D83<10,E83<10,F83<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Non-approved parts and/or parts with defective characteristics (scrap and rework parts) must be separated and recorded or when necessary safely removed from the production process.\nThese parts are to be either directly marked or marked on their container.\nReworking criteria including testing are defined, known and implemented.\nStorage areas for blocked stock and restricted areas must be clearly labelled. Accidental use of restricted parts must be excluded.\nSetting masters, setup and reference parts must be labelled and protected against accidental use.",null,"Look for…",null,"Labelling of scrap, rework, reference and setting parts\nLabelling of containers for scrap, rework and setting parts\nDefined scrap/rework stations in production\nStorage areas for blocked stock and restricted areas\nRecords of rework and scrap"]
["6.2.5",null,"Is the flow of materials and parts secured against mixing/wrong items?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D85=10,E85=10,F85=10),AND(D85=10,E85=\"\",F85=\"\"),AND(D85=10,E85=10,F85=\"\"),AND(D85=10,E85=\"\",F85=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D85<10,E85<10,F85<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"A mix of materials or the use of wrong materials, software or components must be ruled out.\nAppropriate measures and checks must be taken to ensure the early detection and ejection of incorrectly installed items. Associated topics and actions must be included and examined in the risk analysis (process FMEA and, if appropriate, in the product FMEA).\nThe process and/or inspection status of parts must be clearly visible.\nThe reuse of residual quantities, separated parts, reworked parts, reusable parts from product audits, inspected items etc. must be clearly defined (including regulations for traceability).\nRegulations for reintroducing parts of outsourced processes (e.g. sorting service) must be available.",null,"Look for…",null,"*Material and parts flow\n*Product/process FMEA\n*Poka Yoke actions\n*Checks and tests in production facilities\n*Parts identification\n*Identification of work, inspection and usage status\n*Batch identification, traceability of the installation of batches or the production of batches\n*Removal of invalid labelling\n*Working papers with master data for parts/production\n*Design status\n*Material flow analysis\n*Value stream\n*Regulations for reworking"]
["6.3",null,"What functions support the process? (Personnel resources)",{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$28=\"\",\"\",Coversheet!$I$28))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$29=\"\",\"\",Coversheet!$I$29))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$30=\"\",\"\",Coversheet!$I$30))","v":false}]
["6.3.1","*","Are the employees able to fulfil their given tasks?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D88=10,E88=10,F88=10),AND(D88=10,E88=\"\",F88=\"\"),AND(D88=10,E88=10,F88=\"\"),AND(D88=10,E88=\"\",F88=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D88<10,E88<10,F88<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"A description of tasks with an appropriate job profile must be available for employees. A qualification program me (if necessary) is derived from this profile.\nWho is qualified for each task and activity must be documented.\nTrainings, instruction, briefings/proof of qualifications that have been performed must be documented.\nEmployees must be instructed in the handling and treatment of products with special characteristics.\nSuitable evidence of qualification for each activity must be present (e.g. forklift driving license, welding certificate, soldering certificate, vision test, hearing test).\nEmployees responsible for measuring and testing must be trained in the correct use of measuring equipment.\nTrainings/instructions are given at changes to the product/process and these are documented.\nThe requirements apply to both internal and external temporary employees.",null,"Look for…",null,"Training/qualification evidence\nQualification matrix\nInitial training plan with evidence\nKnowledge about the product and failures that have occurred\nHandling of measuring equipment\nTraining in work safety/environmental aspects\nTraining in special characteristics\nSuitable evidence of qualification (e.g. welding certificate, vision test results, driving license for forklift trucks)\nProduct training"]
["6.3.2",null,"Do the employees know their responsibilities and authority in the monitoring of the product and process quality?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D90=10,E90=10,F90=10),AND(D90=10,E90=\"\",F90=\"\"),AND(D90=10,E90=10,F90=\"\"),AND(D90=10,E90=\"\",F90=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D90<10,E90<10,F90<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Responsibilities, duties and authority of the employees in their task areas are described and implemented (e.g. process release, first piece inspection, employee self-inspections, stopping the process).\nThe employees know the consequences of faulty workmanship (which tasks/functions the product has and what happens when they are no longer guaranteed due to faulty installation etc.).\nEmployees receive regular information on the current standard of quality reached, both internally and with the customer (complaints).\nThe requirements apply to both internal and external temporary employees.",null,"Look for…",null,"WorWinspection instructions\nQualifications matrix\nJob descriptions\nEmployee self-inspections\nProcess release (setup release, first piece inspection, last piece inspection)\nProcess control (interpretation of control charts)\nAuthority to stop and start the process\nOrder and cleanliness\nRepair and maintenance is carried out or when necessary, arranged for\nParts supply/storage\nProvision and adjustment of test/measuring equipment is carried out or when necessary, arranged for\nTraining about the product\nQuality information (target/actual values)\nProduct safety/product liability trainings"]
["6.3.3",null,"Are the necessary personnel resources available?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D92=10,E92=10,F92=10),AND(D92=10,E92=\"\",F92=\"\"),AND(D92=10,E92=10,F92=\"\"),AND(D92=10,E92=\"\",F92=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D92<10,E92<10,F92<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The required number of qualified employees is available for all shifts. Employee qualifications need to be considered when scheduling staff (e.g. qualification matrix).\nRules exist for supporting areas that are not continually in use (e.g. laboratory, measurement room).\nFluctuations in customer orders and workforce absences (e.g. illness, holidays, training) are taken into account in the workforce schedule.\nThe requirements also apply to internal and external temporary employees.",null,"Look for…",null,"Shift plan\nEvidence of qualifications (qualification matrix)\nDocumented absence management rules\nWorkforce scheduling"]
["6.4",null,"What means are used to implement the process? (Material resources)",{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$28=\"\",\"\",Coversheet!$I$28))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$29=\"\",\"\",Coversheet!$I$29))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$30=\"\",\"\",Coversheet!$I$30))","v":false}]
["6.4.1","*","Can the product-specific requirements from the customer be met with the manufacturing equipment?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D95=10,E95=10,F95=10),AND(D95=10,E95=\"\",F95=\"\"),AND(D95=10,E95=10,F95=\"\"),AND(D95=10,E95=\"\",F95=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D95<10,E95<10,F95<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Evidence must be shown that the processes are implemented in accordance with the customer requirements using the existing production facilities and that the resulting products meet the customer specifications.\nThe production facilities, machinery and equipment must be able to comply with the specified tolerances for the respective product and process characteristics.\nProcess capability must be determined for selected product and process characteristics and their performance verified.\nThe process capability must meet the customer requirements. For long term process capability the minimum requirement of CRpkR ≥ 1,33 must be met. In the case of significant characteristics where no capability level can be proven, 100% inspection is required.\nLayout and condition of the equipment, tools, fixtures and handling facilities meet the requirements under real production conditions.",null,"Look for…",null,"Evidence of machine/process capability for special characteristics or process determining parameters (e.g. pressure, time, temperature)\nOutput/production capacities\nWarning at deviations from limit specifications/parameters (e.g. an alarm, lamp, automatic shutdown, unloading)\nFeed and removal systems\nCapability of replacement tools\nReproducibility of gauges, fixtures etc.\nCleanliness requirements"]
["6.4.2",null,"Is the maintenance of the manufacturing equipment and tools controlled?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D97=10,E97=10,F97=10),AND(D97=10,E97=\"\",F97=\"\"),AND(D97=10,E97=10,F97=\"\"),AND(D97=10,E97=\"\",F97=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D97<10,E97<10,F97<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Maintenance activities (maintenance, inspection and repair) are determined and implemented for all installations, equipment, machines and tools.\nMaintenance activities that have been carried out (scheduled and unplanned) are documented and analyzed for improvement measures.\nA process for the analysis and optimization of downtime, machine utilization and tool life is implemented effectively.\nThe key processes and bottleneck machines are identified and appropriate maintenance activities (preventative or predictive) are carried out and documented in terms of a risk-based maintenance program.\nThe availability of replacement parts must be ensured.\nResources needed to carry out necessary maintenance measures are available.\nTools undergo a tool management which includes the following:\n*Status indication (e.g. OK, NOK)\n*Tool life cycle including all changes made to the tool\n*Tool life\n*Tool ownership (e.g. customer ownership)",null,"Look for…",null,"Availability/use of the appropriate technical documents\nMaintenance plan and maintenance tasks\nWeak-point analysis\nPreventative tool exchange program for units subject to increased wear and tear\nStorage and retrieval machines/equipment for transport and storage etc.\nAvailability of spare parts at production facilities producing key products\nAdherence to the prescribed maintenance intervals\nDocumentation of maintenance activities\nRegular plausibility check of the scheduled maintenance intervals\nHiring of external service companies to carry out maintenance"]
["6.4.3","*","Can the quality requirements be effectively monitored with the measurement and test facilities in use?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D99=10,E99=10,F99=10),AND(D99=10,E99=\"\",F99=\"\"),AND(D99=10,E99=10,F99=\"\"),AND(D99=10,E99=\"\",F99=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D99<10,E99<10,F99<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Test and measuring equipment/facilities used are suitable for the planned purpose and handling in production. They are included in the control plan.\nCapability studies are carried out on the test and measuring equipment/facilities employed. There is an\nidentification system for test and measuring equipment. Administration of this equipment is based on\nthe identification.\nA process for the periodic monitoring of measurement and inspection equipment is installed and implemented (responsibility for collection and return is defined). This process also takes into account the calibration of process-integrated measurement technology with an influence on the product characteristics.\nAuxiliary equipment for measuring and test equipment that have an influence the measurement result are monitored in the same way.",null,"Look for…",null,"Control plan\nCapability of test equipment\nCapability of measuring equipment\nCapability of measurement process\nData collection and interpretability\nEvidence of the calibration of inspection equipment\nComparison of inspection equipment/measurement processes with the customer (e.g. inter-laboratory comparisons)\nInspection stickers or certificates\nReference component/setup parts (e.g. error test pieces)"]
["6.4.4",null,"Are the work and inspection stations appropriate for the needs?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D101=10,E101=10,F101=10),AND(D101=10,E101=\"\",F101=\"\"),AND(D101=10,E101=10,F101=\"\"),AND(D101=10,E101=\"\",F101=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D101<10,E101<10,F101<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Conditions for the workplaces and their surroundings are appropriate for the products and the work carried out, in order to prevent or eliminate contamination, damage, mixing-up of parts and misinterpretations.\nThis also applies to permanent and temporary established rework, sorting and inspection stations.\nIn addition, the workplace layout is adapted ergonomically to the work to be carried out.",null,"Look for…",null,"Lighting\nCleanliness and tidiness\nClimate control\nNoise pollution\nClean rooms\nWorkplace lay-out\nSurroundings/handling parts at the workplace\nWork safety"]
["6.4.5",null,"Are tools, equipment and test equipment stored properly?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D103=10,E103=10,F103=10),AND(D103=10,E103=\"\",F103=\"\"),AND(D103=10,E103=10,F103=\"\"),AND(D103=10,E103=\"\",F103=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D103<10,E103<10,F103<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Tools, equipment and test equipment (including gauges) must be stored and managed properly. This also applies for tools, equipment and test equipment not in use or not yet released.\nAll tools, equipment and test equipment are identified with their current status and all changes are documented (change history).\nStorage is provided where the equipment is protected against damage and environmental effects. Cleanliness and tidiness are ensured.\nThe issue and use of this equipment is controlled and documented.",null,"Look for…",null,"Stored protected against damage\nCleanliness and tidiness\nDefined storage location\nEnvironmental influences\nStatus identification\nIdentification showing customer's property, products/tools/devices provided on loan\nDefined release status and change level\nStorage and retrieval machines/equipment for transport and storage etc.\nReference component/setup parts (e.g. error test pieces)"]
["6.5",null,"How effective is the process being carried out? (Effectiveness, efficiency, waste avoidance)",{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$28=\"\",\"\",Coversheet!$I$28))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$29=\"\",\"\",Coversheet!$I$29))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$30=\"\",\"\",Coversheet!$I$30))","v":false}]
["6.5.1",null,"Are there targets set for the manufacturing process?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D106=10,E106=10,F106=10),AND(D106=10,E106=\"\",F106=\"\"),AND(D106=10,E106=10,F106=\"\"),AND(D106=10,E106=\"\",F106=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D106<10,E106<10,F106<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Process-specific targets are defined, monitored and communicated (e.g. quantities produced; quality metrics/failure rates, audit results, throughput times, defect costs and process effectiveness figures/Cpk).\nTarget requirements are agreed upon and achievable; they are guaranteed to be up to date.\nCustomer requirements are taken into account when setting targets.\nA regular comparison is made between specified and actual results.",null,"Look for…",null,"Availability of installations and machines\nNumber of parts produced per unit of time\nRework, scrap\nProduction runs with no reworking, first passes, first time through quality, first pass yield\nQuality metrics (e.g., failure rates, audit results)\nProcess metrics (process capability)\nReduction of waste (e.g., scrap and rework, energy and process materials)"]
["6.5.2",null,"Is quality and process data collected in a way that allows analysis?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D108=10,E108=10,F108=10),AND(D108=10,E108=\"\",F108=\"\"),AND(D108=10,E108=10,F108=\"\"),AND(D108=10,E108=\"\",F108=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D108<10,E108<10,F108<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"To demonstrate compliance with the requirements and objectives which are needed for the evidence of product conformity, it is necessary to define and document quality and process parameters (target values) and record the actual data.\nIt must be ensured that data can be evaluated.\nSpecial incidents are documented (shift/equipment book).\nThe recorded data can be related to a product and process, the data is available, legible, accessible and archived as specified. Requirements for traceability are respected.\nThe collected data is analyzed and appropriate action for improvement is initiated.\nThe potential for improvement must be continuously determined from findings on quality, costs, and services.\nEvents that result in a change to the process or to the product must be documented in the appropriate risk analysis (e.g. FMEA) and the respective measures taken are recorded.",null,"Look for…",null,"Defect collection charts\nControl charts\nSpecial characteristics\nProcess parameters (temperature, time, pressure etc.)\nFactory data collection\nFault signals (e.g. plant standstill, power failure, program error message)\nParameter changes\nError type/error frequencies\nError costs (non-conformity)\nRejects/reworking\nBlocking message/sorting actions\nCycle times, through-put times\nSPC\nPareto analyses\nCause and effect diagrams\nRisk analysis (FMEA, FTA etc.)\nTraceability concept"]
["6.5.3","*","In the case of deviations from product and process requirements, are the causes analyzed and the corrective actions checked for effectiveness?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D110=10,E110=10,F110=10),AND(D110=10,E110=\"\",F110=\"\"),AND(D110=10,E110=10,F110=\"\"),AND(D110=10,E110=\"\",F110=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D110<10,E110<10,F110<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"If deviations from product and process requirements occur, immediate containment actions must be taken to comply with the requirements, until the causes of failure are eliminated and evidence has been provided of the effectiveness of the corrective actions.\nThese actions are known by the employees.\nSuitable methods for root cause analysis are in use.\nCorrective actions are derived, their implementation is monitored and the effectiveness verified.\nControl plan and risk analysis (e.g. FMEA) are updated as needed.\nNon-conformities that affect the properties of the delivered product are communicated to the customer.",null,"Look for…",null,"8 D method\nCause and effects diagram\nTaguchi, Shainin\n5 Why method\nFMEA/error analysis\nProcess capability analysis\nQuality control circles/quality circle\nAnalytical assessment methods\nInformation flow to the customer\nProduct FMEA and process FMEA\nWaivers/concessions\nAdditional dimensional material, functional and endurance checks and tests"]
["6.5.4",null,"Are processes and products audited regularly?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D112=10,E112=10,F112=10),AND(D112=10,E112=\"\",F112=\"\"),AND(D112=10,E112=10,F112=\"\"),AND(D112=10,E112=\"\",F112=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D112<10,E112<10,F112<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The audit programs for process and product audits are available and implemented. Customer requirements are taken into account.\nThe process and product audits carried out are suitable to identify specific risks and weak points and implement corrective action.\nA root cause analysis is carried out when deviations occur. Corrective actions are derived, their implementation is monitored and the effectiveness is verified.\nProduct audits are periodically carried out and documented. Scope of the audit is the end product and where necessary intermediate products. In the product audit specified characteristics are examined and tested according to defined specifications.\nNon-conformities that affect the properties of the delivered product are communicated to the customer.",null,"Look for…",null,"Product and process audit\nSpecifications\nSpecial characteristics\nAudit program for product and process audits including scheduled and event-based audits\nFrequency of audits\nAudit requirements\nAudit results, audit reports\nAuditor qualification\n\nProcess audit\nProcess parameter/capability\n\nProduct audit\nLabelling, packaging\nCapacity of the test equipment\nSoftware version"]
["6.6",null,"What should the process produce ? (Process result (output))",{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$28=\"\",\"\",Coversheet!$I$28))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$29=\"\",\"\",Coversheet!$I$29))","v":false},{"$f":"IF(Coversheet!$I$26=\"Process audit per VDA 6.3\",IF(Coversheet!$J$30=\"\",\"\",Coversheet!$I$30))","v":false}]
["6.6.1",null,"Do the quantities/production batch sizes match needs and are they systematically directed to the next process step?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D115=10,E115=10,F115=10),AND(D115=10,E115=\"\",F115=\"\"),AND(D115=10,E115=10,F115=\"\"),AND(D115=10,E115=\"\",F115=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D115<10,E115<10,F115<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"Parts/components must be forwarded to defined storage/holding points using suitable means of transport.\nAttention must be given to the order quantity/batch size so that only the required quantity of parts/materials is moved to the stipulated workstation.\nThe current state of the component (OK parts, reworked parts, scrap etc.) must be evident from the labelling (component, container).\nVarying change statuses of the component must be taken into account.\nIt is ensured that a further processing/forwarding of NOK parts is not possible.",null,"Look for…",null,"Adequate, appropriate means of transport\nDefined storage points\nKANBAN\nFIFO\nJust in time/just in sequence\nStores management\nChange status\nStock\nProduction quantities tailored to the customer’s needs\nSpecial requirements for components and containers (ESD-protection for electronic components, residual dirt etc.)"]
["6.6.2",null,"Are products/components stored in an appropriate manner and are transport facilities/packing arrangements suitable for the special characteristics of the products/components?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D117=10,E117=10,F117=10),AND(D117=10,E117=\"\",F117=\"\"),AND(D117=10,E117=10,F117=\"\"),AND(D117=10,E117=\"\",F117=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D117<10,E117<10,F117<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The products/components must be protected from damage by suitable storage and packing.\nInternal and customer-specific packing instructions are known and implemented.\nStorage points/containers must meet requirements for cleanliness.\nSpecified storage times must be monitored (specified maximum, minimum and interim storage times).\nParts must be protected against environmental and climatic influences during storage and processing.\nThese requirements are valid for the handling within the production process as well as the delivery.",null,"Look for…",null,"Protection from damage\nPositioning of parts\nCleanliness, tidiness, overfilling (storage points & containers)\nMonitoring of storage periods/quantities stored\nEnvironmental and climatic influences\nInternal and customer specific packing instructions\nCustomer specific packaging instructions (incl. packing supplied by the customer)\nInformation on available stock levels\nSubstitute packaging\nRequirements for cleaning packaging\nSufficient amount of package materials"]
["6.6.3",null,"Are the necessary records/releases retained?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D119=10,E119=10,F119=10),AND(D119=10,E119=\"\",F119=\"\"),AND(D119=10,E119=10,F119=\"\"),AND(D119=10,E119=\"\",F119=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D119<10,E119<10,F119<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The labelling of the release status on containers/batches/carriers/components must be specified.\nReleased products/components must be clearly marked and the release status must be visible.\nConcessions/deviation approvals must be traceable by appropriate identification and documentation. The documentation must cover the period and/or quantity of parts involved. These details are documented including the identification on the component/carrier.\nInternal specifications and customer requirements for the labelling of reworked parts must be implemented\nand documented (e.g. amount/quantity/labelling/part history/use).\nThe traceability of units produced must be ensured.\nFor archiving requirements and duration, the customer requirements are taken into account.\nTest results of characteristics with special requirements for documentation and archiving are recorded accordingly.",null,"Look for…",null,"Customer specifications\nSpecial characteristics\nCustomer's identification requirements\nCustomer’s requirements for archiving time limits\nArchiving requirements/regulations (EDP, paper, fire protection, legibility etc..)\nLast piece inspection\nPart history\nIdentification of concessions"]
["6.6.4","*","Are the customer requirements met at the delivery of the final product?","n/a","n/a","n/a",{"$f":"IF(OR(AND(D121=10,E121=10,F121=10),AND(D121=10,E121=\"\",F121=\"\"),AND(D121=10,E121=10,F121=\"\"),AND(D121=10,E121=\"\",F121=10)),$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D121<10,E121<10,F121<10),\"x\",\"\")","v":""}]
["Minimum requirement",null,"The customer specific requirements of the final product (delivery reliability, quality goals, quality performance etc.) are known and monitored.\nIf deviations occur, corrective actions are defined and implemented.\nFinal products are shipped in accordance with the customer requirements.\nThe handling of supplied products is regulated and implemented.\nCustomers should be informed of delivery stops which affect them and further procedure should be coordinated with them.",null,"Look for…",null,"Quality agreements with the customer\nCustomer specific requirements\nCustomer requirements for the identification of special characteristics\nShipping audit\nStorage/recall processing/parts supply/shipping\nTarget agreements"]
["P7",null,"Customer Care / Customer Satisfaction / Service","General",null,null,{"$f":"$A$135&'Assessment matrix_VDA'!BB44&\"\n\"&$A$137&'Assessment matrix_VDA'!BA44&\" / 5\"","v":"Minimum questions to be answered: 4\nQuestions answered: 0 / 5"},{"$f":"\"Score: \"&IF('Assessment matrix_VDA'!AM44=\"n/a\",\"n/a\",('Assessment matrix_VDA'!AM44)*100&\"%\")","v":"Score: n/a"}]
["7.1",null,"Are all requirements related to QM System, product and process fulfilled?","n/a",null,null,{"$f":"IF(D124=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D124=10,D124=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"The internal and customer specific requirements on the quality management system are fulfilled.\nLayout inspection and a functional verification checks are carried out according to the customer requirements.\nThe customer requirements for the supply of spare parts during and after the production phase must be implemented.\nCustomer requirements for the return of parts and their recycling must be implemented.",null,"Look for…",null,"Quality agreements with the customer\nLayout inspection concept e.g. carried out product audits, function tests, endurance tests\nInclusion of suppliers for the supply of spare parts\nSupply guarantee after serial production\nCertification of the QM system"]
["7.2",null,"Is customer service guaranteed?","n/a",null,null,{"$f":"IF(D126=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D126=10,D126=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"It must be ensured that competent contact personnel are available for the various areas in the customer's organization. Communication is ensured in accordance with the customer specifications.\nThe monitoring of the product in the field is ensured.\nAccess to customer portals in accordance with the customer specific agreement is ensured.",null,"Look for…",null,"Knowledge of the product application\nKnowledge of problems with the product and complaints regarding the product or transport\nImplementation of new requirements\nNotification of improvement actions\nWorld-wide customer service\nCustomer information in the case of non-compliance with the requirements"]
["7.3","*","Is the supply of parts guaranteed?","n/a",null,null,{"$f":"IF(D128=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D128=10,D128=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"Contingency concepts and concepts to ensure supplies are available and up to date. Not only internal processes but also the processes of suppliers are to be considered.\nProcedures must be in place which guarantees that the organization informs the customer immediately when supply shortages are detected. The information must include the expected duration and extent of the shortages, the reason and the actions which have been taken.",null,"Look for…",null,"Contingency plans (e.g. for alternative production, suppliers, transport)\nCapacity and reaction time for sorting actions\nUse of external capacity\nCommunication regarding supply shortages\nRegulations covering authority to make decisions/escalation paths when introducing special actions\nBlocking of parts"]
["7.4","*","If there are deviations from quality requirements or complaints, are failure analyses carried out and corrective actions implemented effectively?","n/a",null,null,{"$f":"IF(D130=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D130=10,D130=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"A complaint process that meets the customer requirements (e.g. 8D) is used for 0-km and field complaints.\nProcedures for failure analysis are defined. The necessary personnel and material resources are available to ensure punctual processing. The customer has to be informed when deviations to the agreed upon time limits occur.\nIn the case of field complaints a failure analysis is to be carried out according to customer requirements (e.g. VDA Volume Field Failure Analysis).",null,"Look for…",null,"Process for processing complaints\n8D process\nInternal/external analysis facilities (laboratories, test and inspection facilities, personnel)\nUse of problem solving methods\nPerformance tests\nFlow of information to the customer in the case of deviations\nKnowledge store, lessons learned\nQuality control loop\nFMEA\nAccess to the necessary release documents (PPA etc.)\nTest concept for defective parts in the field (standard test/stress test/NTF test)\nNTF guidelines\nPerformance indicators for processing of complaints"]
["7.5",null,"Are personnel qualified for their respective tasks and are responsibilities defined?","n/a",null,null,{"$f":"IF(D132=10,$A$141,$A$142)","v":"Enter explanation"},{"$f":"IF(OR(D132=10,D132=\"n/a\"),\"\",\"x\")","v":""}]
["Minimum requirement",null,"It must be determined which responsibilities, duties and authorizations each employee has in their respective area of responsibility.\nTraining needs must be determined individually and implemented for each person, depending on their tasks.\nThe employees know the product and the consequences of faulty workmanship for the supply of parts and the quality of the final product.",null,"Look for…",null,"Organizational chart\nEvidence of knowledge of the product/specifications/customer requirements\nStandards/legislation (product liability)\nProcessing/use\nFailure analysis\nEvaluation methods (e.g. audits, statistics)\nQuality techniques (e.g. Pareto, 8D Method, cause and effect diagram, Ishikawa)\nForeign language skills"]
[]
["Minimum questions to be answered: "]
["Minimum questions to be answered for each step: "]
["Questions answered: "]
["Questions answered PS1: "]
["Questions answered PS2: "]
["Questions answered PS3: "]
["No weeknesses identified"]
["Enter explanation"]
[10]
[8]
[6]
[4]
[2]
["n/a"]

{"sheet":"Assessment matrix_VDA","index":5,"n_rows":69,"n_cols":68,"rows_kept":69,"cut":false,"hidden":true,"merged":[[52,23,54,25],[0,4,3,26],[49,46,49,48],[49,29,49,45],[53,46,53,48],[53,29,53,45],[50,46,50,48],[50,29,50,45],[51,46,51,48],[52,46,52,48],[54,46,54,48],[54,29,54,45],[52,29,52,45],[51,29,51,45],[40,26,40,27],[40,31,40,32],[64,30,64,36],[65,30,65,36],[66,30,66,36],[62,3,62,9],[63,3,63,9],[64,3,64,9],[65,3,65,9],[66,3,66,9],[59,30,59,36],[60,30,60,36],[61,30,61,36],[62,30,62,36],[63,30,63,36],[49,20,51,22],[49,23,51,25],[13,10,13,11],[13,23,13,24],[13,38,13,39],[18,12,18,13],[18,25,18,26],[18,38,18,39],[34,2,34,32],[25,18,25,22],[25,37,26,40],[33,1,33,31],[32,38,32,39],[25,2,25,6],[25,8,25,12],[25,14,25,16],[25,24,25,27],[25,29,25,32],[40,5,40,6],[40,11,40,12],[40,15,40,16],[40,21,40,22],[68,3,68,9],[59,3,59,9],[60,3,60,9],[61,3,61,9],[67,3,67,9],[55,46,55,48],[55,29,55,45],[46,44,47,48],[36,38,36,39],[1,31,1,48],[2,31,2,48],[22,38,22,39],[8,38,8,39],[25,41,25,48],[28,38,28,39],[30,38,30,39],[5,37,6,40],[40,47,40,48],[43,38,43,39]]}
[null,null,null,null,"ASSESSMENT MATRIX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company:",{"$f":"IF(Coversheet!I26=\"Process audit per VDA 6.3\",IF(Coversheet!C7=\"\",\"\",Coversheet!C7),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audit Date:",{"$f":"IF(Coversheet!I26=\"Process audit per VDA 6.3\",IF(Coversheet!L46=\"\",\"\",Coversheet!L46),\"\")","v":""}]
[]
[]
["A","Development",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level of\ncompliance [%]"]
[null,"P2",{"$f":"Questionnaire_VDA!C6","v":"Project Management"}]
[null,null,"2.1","2.2","2.3","2.4","2.5*","2.6*","2.7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act."]
[null,null,{"$f":"Questionnaire_VDA!D7","v":"n/a"},{"$f":"Questionnaire_VDA!D9","v":"n/a"},{"$f":"Questionnaire_VDA!D11","v":"n/a"},{"$f":"Questionnaire_VDA!D13","v":"n/a"},{"$f":"Questionnaire_VDA!D15","v":"n/a"},{"$f":"Questionnaire_VDA!D17","v":"n/a"},{"$f":"Questionnaire_VDA!D19","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EP2",{"$f":"IF((BA9>=BB9),ROUND(BD9/BC9,2),AZ8)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(C9:I9,\">-\")","v":7},{"$f":"COUNT(C9:I9)","v":0},5,{"$f":"IF((BA9>=BB9),BA9*10,\"--\")","v":"--"},{"$f":"IF((BA9>=BB9),SUM(C9:I9),\"--\")","v":"--"}]
[]
[null,"P3",{"$f":"Questionnaire_VDA!C21","v":"Planning the Product & Process Development"}]
[null,null,{"$f":"Questionnaire_VDA!D21","v":"Product"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire_VDA!E21","v":"Process"}]
[null,null,"3.1","3.2*","3.3","3.4","3.5",null,null,null,null,null,null,null,null,"3.1","3.2*","3.3","3.4","3.5",null,null,null,null,null,null,null,null,"3.1","3.2*","3.3","3.4","3.5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act.",null,"n/a","Act.","Target","Max.","Act.",null,"n/a","Act.","Target","Max.","Act."]
[null,null,{"$f":"Questionnaire_VDA!D22","v":"n/a"},{"$f":"Questionnaire_VDA!D24","v":"n/a"},{"$f":"Questionnaire_VDA!D26","v":"n/a"},{"$f":"Questionnaire_VDA!D28","v":"n/a"},{"$f":"Questionnaire_VDA!D30","v":"n/a"},null,null,"EPdP",{"$f":"IF((BA14>=BB14),ROUND(BD14/BC14,2),AZ13)","v":"n/a"},null,null,null,null,{"$f":"Questionnaire_VDA!E22","v":"n/a"},{"$f":"Questionnaire_VDA!E24","v":"n/a"},{"$f":"Questionnaire_VDA!E26","v":"n/a"},{"$f":"Questionnaire_VDA!E28","v":"n/a"},{"$f":"Questionnaire_VDA!E30","v":"n/a"},null,null,"EPcP",{"$f":"IF((BG14>=BH14),ROUND(BJ14/BI14,2),BF13)","v":"n/a"},null,null,null,null,{"$f":"IF(AND(C14=$AZ$13,P14=$BF$13),$BL$13,IF(AND(C14=\"--\",P14=\"--\"),\"--\",IF(COUNT(C14,P14)>0,ROUND(AVERAGE(C14,P14),2),\"/\")))","v":"n/a"},{"$f":"IF(AND(D14=$AZ$13,Q14=$BF$13),$BL$13,IF(AND(D14=\"--\",Q14=\"--\"),\"--\",IF(COUNT(D14,Q14)>0,ROUND(AVERAGE(D14,Q14),2),\"/\")))","v":"n/a"},{"$f":"IF(AND(E14=$AZ$13,R14=$BF$13),$BL$13,IF(AND(E14=\"--\",R14=\"--\"),\"--\",IF(COUNT(E14,R14)>0,ROUND(AVERAGE(E14,R14),2),\"/\")))","v":"n/a"},{"$f":"IF(AND(F14=$AZ$13,S14=$BF$13),$BL$13,IF(AND(F14=\"--\",S14=\"--\"),\"--\",IF(COUNT(F14,S14)>0,ROUND(AVERAGE(F14,S14),2),\"/\")))","v":"n/a"},{"$f":"IF(AND(G14=$AZ$13,T14=$BF$13),$BL$13,IF(AND(G14=\"--\",T14=\"--\"),\"--\",IF(COUNT(G14,T14)>0,ROUND(AVERAGE(G14,T14),2),\"/\")))","v":"n/a"},null,null,null,null,"EP3",{"$f":"IF(AND(K14=AZ13,X14=BF13),AZ13,ROUND(BP14/BO14,2))","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(C14:G14,\">-\")","v":5},{"$f":"COUNT(C14:G14)","v":0},4,{"$f":"IF((BA14>=BB14),BA14*10,\"--\")","v":"--"},{"$f":"IF((BA14>=BB14),SUM(C14:G14),\"--\")","v":"--"},null,{"$f":"COUNTIF(P14:T14,\">-\")","v":5},{"$f":"COUNT(P14:T14)","v":0},4,{"$f":"IF((BG14>=BH14),BG14*10,\"--\")","v":"--"},{"$f":"IF((BG14>=BH14),SUM(P14:T14),\"--\")","v":"--"},null,{"$f":"COUNTIF(AC14:AG14,\">-\")","v":5},{"$f":"COUNT(AC14:AG14)","v":0},4,{"$f":"IF((BM14>=BN14),BM14*10,\"--\")","v":"--"},{"$f":"IF((BM14>=BN14),SUM(AC14:AG14),\"--\")","v":"--"}]
[]
[null,"P4",{"$f":"Questionnaire_VDA!C32","v":"Implementation of the Product & Process Development"}]
[null,null,{"$f":"Questionnaire_VDA!D32","v":"Product"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire_VDA!E32","v":"Process"}]
[null,null,"4.1*","4.2","4.3","4.4*","4.5","4.6","4.7","4.8*",null,null,null,null,null,"4.1*","4.2","4.3","4.4*","4.5","4.6","4.7","4.8*",null,null,null,null,null,"4.1*","4.2","4.3","4.4*","4.5","4.6","4.7","4.8*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act.",null,"n/a","Act.","Target","Max.","Act.",null,"n/a","Act.","Target","Max.","Act."]
[null,null,{"$f":"Questionnaire_VDA!D33","v":"n/a"},{"$f":"Questionnaire_VDA!D35","v":"n/a"},{"$f":"Questionnaire_VDA!D37","v":"n/a"},{"$f":"Questionnaire_VDA!D39","v":"n/a"},{"$f":"Questionnaire_VDA!D41","v":"n/a"},{"$f":"Questionnaire_VDA!D43","v":"n/a"},{"$f":"Questionnaire_VDA!D45","v":"n/a"},{"$f":"Questionnaire_VDA!D47","v":"n/a"},null,"EPdR",{"$f":"IF((BA19>=BB19),ROUND(BD19/BC19,2),AZ18)","v":"n/a"},null,null,{"$f":"Questionnaire_VDA!E33","v":"n/a"},{"$f":"Questionnaire_VDA!E35","v":"n/a"},{"$f":"Questionnaire_VDA!E37","v":"n/a"},{"$f":"Questionnaire_VDA!E39","v":"n/a"},{"$f":"Questionnaire_VDA!E41","v":"n/a"},{"$f":"Questionnaire_VDA!E43","v":"n/a"},{"$f":"Questionnaire_VDA!E45","v":"n/a"},{"$f":"Questionnaire_VDA!E47","v":"n/a"},null,"EPcR",{"$f":"IF((BG19>=BH19),ROUND(BJ19/BI19,2),BF18)","v":"n/a"},null,null,{"$f":"IF(AND(C19=$AZ$18,P19=$BF$18),$BL$18,IF(AND(C19=\"--\",P19=\"--\"),\"--\",IF(COUNT(C19,P19)>0,ROUND(AVERAGE(C19,P19),2),\"/\")))","v":"n/a"},{"$f":"IF(AND(D19=$AZ$18,Q19=$BF$18),$BL$18,IF(AND(D19=\"--\",Q19=\"--\"),\"--\",IF(COUNT(D19,Q19)>0,ROUND(AVERAGE(D19,Q19),2),\"/\")))","v":"n/a"},"n/a","n/a","n/a","n/a","n/a","n/a",null,"EP4",{"$f":"IF(AND(M19=AZ18,Z19=BF18),AZ18,ROUND(BP19/BO19,2))","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(C19:J19,\">-\")","v":8},{"$f":"COUNT(C19:J19)","v":0},4,{"$f":"IF((BA19>=BB19),BA19*10,\"--\")","v":"--"},{"$f":"IF((BA19>=BB19),SUM(C19:J19),\"--\")","v":"--"},null,{"$f":"COUNTIF(P19:W19,\">-\")","v":8},{"$f":"COUNT(P19:W19)","v":0},6,{"$f":"IF((BG19>=BH19),BG19*10,\"--\")","v":"--"},{"$f":"IF((BG19>=BH19),SUM(P19:W19),\"--\")","v":"--"},null,{"$f":"COUNTIF(AC19:AJ19,\">-\")","v":8},{"$f":"COUNT(AC19:AJ19)","v":0},6,{"$f":"IF((BM19>=BN19),BM19*10,\"--\")","v":"--"},{"$f":"IF((BM19>=BN19),SUM(AC19:AJ19),\"--\")","v":"--"}]
[]
["B","Serial production"]
[null,null,null,null,null,null,null,null,null,"5.1","5.2","5.3","5.4*","5.5*","5.6","5.7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act."]
[null,"P5",{"$f":"Questionnaire_VDA!C49","v":"Supplier Management"},null,null,null,null,null,null,{"$f":"Questionnaire_VDA!D50","v":"n/a"},{"$f":"Questionnaire_VDA!D52","v":"n/a"},{"$f":"Questionnaire_VDA!D54","v":"n/a"},{"$f":"Questionnaire_VDA!D56","v":"n/a"},{"$f":"Questionnaire_VDA!D58","v":"n/a"},{"$f":"Questionnaire_VDA!D60","v":"n/a"},{"$f":"Questionnaire_VDA!D62","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EP5",{"$f":"IF((BA23>=BB23),ROUND(BD23/BC23,2),AZ22)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(J23:P23,\">-\")","v":7},{"$f":"COUNT(J23:P23)","v":0},5,{"$f":"IF((BA23>=BB23),BA23*10,\"--\")","v":"--"},{"$f":"IF((BA23>=BB23),SUM(J23:P23),\"--\")","v":"--"}]
[]
[null,"P6",{"$f":"Questionnaire_VDA!C64","v":"Process Analysis / Production"}]
[null,null,"1. Process input",null,null,null,null,null,"2. Process management",null,null,null,null,null,"3. Process support",null,null,null,"4. Material resources",null,null,null,null,null,"5. Effectiveness of the process",null,null,null,null,"6. Process result/ output",null,null,null,null,null,null,null,null,null,null,null,"7. Transport and part handling"]
[null,null,"6.1.1","6.1.2","6.1.3","6.1.4","6.1.5*",null,"6.2.1","6.2.2","6.2.3*","6.2.4*","6.2.5",null,"6.3.1*","6.3.2","6.3.3",null,"6.4.1*","6.4.2","6.4.3*","6.4.4","6.4.5",null,"6.5.1","6.5.2","6.5.3*","6.5.4",null,"6.6.1","6.6.2","6.6.3","6.6.4*",null,null,null,null,null,null,null,null,"6.1.2","6.1.3","6.1.4","6.2.4","6.2.5","6.6.1","6.6.2","6.6.3"]
[null,null,"Process step 1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act."]
[null,{"$f":"IF(Coversheet!J28<>\"\",\"x\",\"\")","v":""},{"$f":"Questionnaire_VDA!D66","v":"n/a"},{"$f":"Questionnaire_VDA!D68","v":"n/a"},{"$f":"Questionnaire_VDA!D70","v":"n/a"},{"$f":"Questionnaire_VDA!D72","v":"n/a"},{"$f":"Questionnaire_VDA!D74","v":"n/a"},null,{"$f":"Questionnaire_VDA!D77","v":"n/a"},{"$f":"Questionnaire_VDA!D79","v":"n/a"},{"$f":"Questionnaire_VDA!D81","v":"n/a"},{"$f":"Questionnaire_VDA!D83","v":"n/a"},{"$f":"Questionnaire_VDA!D85","v":"n/a"},null,{"$f":"Questionnaire_VDA!D88","v":"n/a"},{"$f":"Questionnaire_VDA!D90","v":"n/a"},{"$f":"Questionnaire_VDA!D92","v":"n/a"},null,{"$f":"Questionnaire_VDA!D95","v":"n/a"},{"$f":"Questionnaire_VDA!D97","v":"n/a"},{"$f":"Questionnaire_VDA!D99","v":"n/a"},{"$f":"Questionnaire_VDA!D101","v":"n/a"},{"$f":"Questionnaire_VDA!D103","v":"n/a"},null,{"$f":"Questionnaire_VDA!D106","v":"n/a"},{"$f":"Questionnaire_VDA!D108","v":"n/a"},{"$f":"Questionnaire_VDA!D110","v":"n/a"},{"$f":"Questionnaire_VDA!D112","v":"n/a"},null,{"$f":"Questionnaire_VDA!D115","v":"n/a"},{"$f":"Questionnaire_VDA!D117","v":"n/a"},{"$f":"Questionnaire_VDA!D119","v":"n/a"},{"$f":"Questionnaire_VDA!D121","v":"n/a"},null,null,null,null,"E1",{"$f":"IF(AND((B29=\"x\"),(BA29>=BB29)),ROUND(BD29/BC29,2),AZ28)","v":"n/a"},null,null,{"$f":"D29","v":"n/a"},{"$f":"E29","v":"n/a"},{"$f":"F29","v":"n/a"},{"$f":"L29","v":"n/a"},{"$f":"M29","v":"n/a"},{"$f":"AD29","v":"n/a"},{"$f":"AE29","v":"n/a"},{"$f":"AF29","v":"n/a"},null,null,{"$f":"COUNTIF(C29:AG29,\">-\")","v":26},{"$f":"COUNT(C29:AG29)","v":0},17,{"$f":"IF((BA29>=BB29),BA29*10,\"--\")","v":"--"},{"$f":"IF((BA29>=BB29),SUM(C29:AG29),\"--\")","v":"--"}]
[null,null,"Process step 2:"]
[null,{"$f":"IF(Coversheet!J29<>\"\",\"x\",\"\")","v":""},{"$f":"IF(Questionnaire_VDA!E66=\"\",\"n/a\",Questionnaire_VDA!E66)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E68=\"\",\"n/a\",Questionnaire_VDA!E68)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E70=\"\",\"n/a\",Questionnaire_VDA!E70)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E72=\"\",\"n/a\",Questionnaire_VDA!E72)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E74=\"\",\"n/a\",Questionnaire_VDA!E74)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!E77=\"\",\"n/a\",Questionnaire_VDA!E77)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E79=\"\",\"n/a\",Questionnaire_VDA!E79)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E81=\"\",\"n/a\",Questionnaire_VDA!E81)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E83=\"\",\"n/a\",Questionnaire_VDA!E83)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E85=\"\",\"n/a\",Questionnaire_VDA!E85)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!E88=\"\",\"n/a\",Questionnaire_VDA!E88)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E90=\"\",\"n/a\",Questionnaire_VDA!E90)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E92=\"\",\"n/a\",Questionnaire_VDA!E92)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!E95=\"\",\"n/a\",Questionnaire_VDA!E95)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E97=\"\",\"n/a\",Questionnaire_VDA!E97)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E99=\"\",\"n/a\",Questionnaire_VDA!E99)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E101=\"\",\"n/a\",Questionnaire_VDA!E101)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E103=\"\",\"n/a\",Questionnaire_VDA!E103)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!E106=\"\",\"n/a\",Questionnaire_VDA!E106)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E108=\"\",\"n/a\",Questionnaire_VDA!E108)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E110=\"\",\"n/a\",Questionnaire_VDA!E110)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E112=\"\",\"n/a\",Questionnaire_VDA!E112)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!E115=\"\",\"n/a\",Questionnaire_VDA!E115)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E117=\"\",\"n/a\",Questionnaire_VDA!E117)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E119=\"\",\"n/a\",Questionnaire_VDA!E119)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!E121=\"\",\"n/a\",Questionnaire_VDA!E121)","v":"n/a"},null,null,null,null,"E2",{"$f":"IF(AND((B29=\"x\"),(BA31>=BB31)),ROUND(BD31/BC31,2),AZ28)","v":"n/a"},null,null,{"$f":"D31","v":"n/a"},{"$f":"E31","v":"n/a"},{"$f":"F31","v":"n/a"},{"$f":"L31","v":"n/a"},{"$f":"M31","v":"n/a"},{"$f":"AD31","v":"n/a"},{"$f":"AE31","v":"n/a"},{"$f":"AF31","v":"n/a"},null,null,{"$f":"COUNTIF(C31:AG31,\">-\")","v":26},{"$f":"COUNT(C31:AG31)","v":0},17,{"$f":"IF((BA31>=BB31),BA31*10,\"--\")","v":"--"},{"$f":"IF((BA31>=BB31),SUM(C31:AG31),\"--\")","v":"--"}]
[null,null,"Process step 3:"]
[null,{"$f":"IF(Coversheet!J30<>\"\",\"x\",\"\")","v":""},{"$f":"IF(Questionnaire_VDA!F66=\"\",\"n/a\",Questionnaire_VDA!F66)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F68=\"\",\"n/a\",Questionnaire_VDA!F68)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F70=\"\",\"n/a\",Questionnaire_VDA!F70)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F72=\"\",\"n/a\",Questionnaire_VDA!F72)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F74=\"\",\"n/a\",Questionnaire_VDA!F74)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!F77=\"\",\"n/a\",Questionnaire_VDA!F77)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F79=\"\",\"n/a\",Questionnaire_VDA!F79)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F81=\"\",\"n/a\",Questionnaire_VDA!F81)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F83=\"\",\"n/a\",Questionnaire_VDA!F83)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F85=\"\",\"n/a\",Questionnaire_VDA!F85)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!F88=\"\",\"n/a\",Questionnaire_VDA!F88)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F90=\"\",\"n/a\",Questionnaire_VDA!F90)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F92=\"\",\"n/a\",Questionnaire_VDA!F92)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!F95=\"\",\"n/a\",Questionnaire_VDA!F95)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F97=\"\",\"n/a\",Questionnaire_VDA!F97)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F99=\"\",\"n/a\",Questionnaire_VDA!F99)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F101=\"\",\"n/a\",Questionnaire_VDA!F101)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F103=\"\",\"n/a\",Questionnaire_VDA!F103)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!F106=\"\",\"n/a\",Questionnaire_VDA!F106)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F108=\"\",\"n/a\",Questionnaire_VDA!F108)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F110=\"\",\"n/a\",Questionnaire_VDA!F110)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F112=\"\",\"n/a\",Questionnaire_VDA!F112)","v":"n/a"},null,{"$f":"IF(Questionnaire_VDA!F115=\"\",\"n/a\",Questionnaire_VDA!F115)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F117=\"\",\"n/a\",Questionnaire_VDA!F117)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F119=\"\",\"n/a\",Questionnaire_VDA!F119)","v":"n/a"},{"$f":"IF(Questionnaire_VDA!F121=\"\",\"n/a\",Questionnaire_VDA!F121)","v":"n/a"},null,null,null,null,"E3",{"$f":"IF(AND((B29=\"x\"),(BA33>=BB33)),ROUND(BD33/BC33,2),AZ28)","v":"n/a"},null,null,{"$f":"D33","v":"n/a"},{"$f":"E33","v":"n/a"},{"$f":"F33","v":"n/a"},{"$f":"L33","v":"n/a"},{"$f":"M33","v":"n/a"},{"$f":"AD33","v":"n/a"},{"$f":"AE33","v":"n/a"},{"$f":"AF33","v":"n/a"},null,null,{"$f":"COUNTIF(C33:AG33,\">-\")","v":26},{"$f":"COUNT(C33:AG33)","v":0},17,{"$f":"IF((BA33>=BB33),BA33*10,\"--\")","v":"--"},{"$f":"IF((BA33>=BB33),SUM(C33:AG33),\"--\")","v":"--"}]
[]
[null,null,"Assessment of sub-elements in the process analysis (mean value stages 1 - n)"]
[null,null,"6.1.1","6.1.2","6.1.3","6.1.4","6.1.5*",null,"6.2.1","6.2.2","6.2.3*","6.2.4*","6.2.5",null,"6.3.1*","6.3.2","6.3.3",null,"6.4.1*","6.4.2","6.4.3*","6.4.4","6.4.5",null,"6.5.1","6.5.2","6.5.3*","6.5.4",null,"6.6.1","6.6.2","6.6.3","6.6.4*",null,null,null,null,null,null,null,null,"6.1.2","6.1.3","6.1.4","6.2.4","6.2.5","6.6.1","6.6.2","6.6.3",null,null,"n/a","Act.","Target","Max.","Act."]
[null,null,{"$f":"IF(ISERROR(AVERAGE(C29:C33)),$AZ$36,ROUND(AVERAGE(C29:C33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(D29:D33)),$AZ$36,ROUND(AVERAGE(D29:D33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(E29:E33)),$AZ$36,ROUND(AVERAGE(E29:E33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(F29:F33)),$AZ$36,ROUND(AVERAGE(F29:F33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(G29:G33)),$AZ$36,ROUND(AVERAGE(G29:G33),2))","v":"n/a"},null,{"$f":"IF(ISERROR(AVERAGE(I29:I33)),$AZ$36,ROUND(AVERAGE(I29:I33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(J29:J33)),$AZ$36,ROUND(AVERAGE(J29:J33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(K29:K33)),$AZ$36,ROUND(AVERAGE(K29:K33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(L29:L33)),$AZ$36,ROUND(AVERAGE(L29:L33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(M29:M33)),$AZ$36,ROUND(AVERAGE(M29:M33),2))","v":"n/a"},null,{"$f":"IF(ISERROR(AVERAGE(O29:O33)),$AZ$36,ROUND(AVERAGE(O29:O33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(P29:P33)),$AZ$36,ROUND(AVERAGE(P29:P33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(Q29:Q33)),$AZ$36,ROUND(AVERAGE(Q29:Q33),2))","v":"n/a"},null,{"$f":"IF(ISERROR(AVERAGE(S29:S33)),$AZ$36,ROUND(AVERAGE(S29:S33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(T29:T33)),$AZ$36,ROUND(AVERAGE(T29:T33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(U29:U33)),$AZ$36,ROUND(AVERAGE(U29:U33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(V29:V33)),$AZ$36,ROUND(AVERAGE(V29:V33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(W29:W33)),$AZ$36,ROUND(AVERAGE(W29:W33),2))","v":"n/a"},null,{"$f":"IF(ISERROR(AVERAGE(Y29:Y33)),$AZ$36,ROUND(AVERAGE(Y29:Y33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(Z29:Z33)),$AZ$36,ROUND(AVERAGE(Z29:Z33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(AA29:AA33)),$AZ$36,ROUND(AVERAGE(AA29:AA33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(AB29:AB33)),$AZ$36,ROUND(AVERAGE(AB29:AB33),2))","v":"n/a"},null,{"$f":"IF(ISERROR(AVERAGE(AD29:AD33)),$AZ$36,ROUND(AVERAGE(AD29:AD33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(AE29:AE33)),$AZ$36,ROUND(AVERAGE(AE29:AE33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(AF29:AF33)),$AZ$36,ROUND(AVERAGE(AF29:AF33),2))","v":"n/a"},{"$f":"IF(ISERROR(AVERAGE(AG29:AG33)),$AZ$36,ROUND(AVERAGE(AG29:AG33),2))","v":"n/a"},null,null,null,null,"EP6",{"$f":"IF(COUNTIF(AM29:AN33,$AZ$36)=3,$AZ$36,ROUND(BD37/BC37,2))","v":"n/a"},null,null,{"$f":"D37","v":"n/a"},{"$f":"E37","v":"n/a"},{"$f":"F37","v":"n/a"},{"$f":"L37","v":"n/a"},{"$f":"M37","v":"n/a"},{"$f":"AD37","v":"n/a"},{"$f":"AE37","v":"n/a"},{"$f":"AF37","v":"n/a"},null,null,{"$f":"SUM(AZ29:AZ33)","v":78},{"$f":"SUM(BA29:BA33)","v":0},{"$f":"SUM(E39,K39,O39,U39,Z39,AE39)","v":0},{"$f":"COUNT(C37:AG37)*10","v":0},{"$f":"SUM(C37:AG37)","v":0}]
[null,null,null,"Act.","Target","Max.","Act.",null,null,"Act.","Target","Max.","Act.","Act.","Target","Max.","Act.",null,null,"Act.","Target","Max.","Act.",null,"Act.","Target","Max.","Act.",null,"Act.","Target","Max.","Act.",null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act."]
[null,null,null,{"$f":"COUNT(C29:G33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*5/3*2,0)","v":0},{"$f":"IF((D39>=E39),D39*10,\"--\")","v":0},{"$f":"IF((D39>=E39),SUM(C29:G33),\"--\")","v":0},null,null,{"$f":"COUNT(I29:M33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*5/3*2,0)","v":0},{"$f":"IF((J39>=K39),J39*10,\"--\")","v":0},{"$f":"IF((J39>=K39),SUM(I29:M33),\"--\")","v":0},{"$f":"COUNT(O29:Q33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*3/3*2,0)","v":0},{"$f":"IF((N39>=O39),N39*10,\"--\")","v":0},{"$f":"IF((N39>=O39),SUM(O29:Q33),\"--\")","v":0},null,null,{"$f":"COUNT(S29:W33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*5/3*2,0)","v":0},{"$f":"IF((T39>=U39),T39*10,\"--\")","v":0},{"$f":"IF((T39>=U39),SUM(S29:W33),\"--\")","v":0},null,{"$f":"COUNT(Y29:AB33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*4/3*2,0)","v":0},{"$f":"IF((Y39>=Z39),Y39*10,\"--\")","v":0},{"$f":"IF((Y39>=Z39),SUM(Y29:AB33),\"--\")","v":0},null,{"$f":"COUNT(AD29:AG33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*4/3*2,0)","v":0},{"$f":"IF((AD39>=AE39),AD39*10,\"--\")","v":0},{"$f":"IF((AD39>=AE39),SUM(AD29:AG33),\"--\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AP37:AW37,\">-\")","v":8},{"$f":"COUNT(AP29:AW33)","v":0},{"$f":"ROUNDUP(COUNTIF($B$29:$B$33,\"X\")*8/3*2,0)","v":0},{"$f":"IF(AND($B48,AT39>=AU39),COUNTIF(AP37:AW37,\"<>\"&AS38)*10,\"--\")","v":0},{"$f":"IF(AND($B48,AT39>=AU39),SUM(AP37:AW37),\"--\")","v":0}]
[]
[null,null,null,null,"Eu1",{"$f":"IF((E39=0),$AZ$36,IFERROR(ROUND(G39/F39,2),$AZ$36))","v":"n/a"},null,null,null,null,"Eu2",{"$f":"IF((K39=0),$AZ$36,IFERROR(ROUND(M39/L39,2),$AZ$36))","v":"n/a"},null,null,"Eu3",{"$f":"IF((O39=0),$AZ$36,IFERROR(ROUND(Q39/P39,2),$AZ$36))","v":"n/a"},null,null,null,null,"Eu4",{"$f":"IF((U39=0),$AZ$36,IFERROR(ROUND(W39/V39,2),$AZ$36))","v":"n/a"},null,null,null,"Eu5",{"$f":"IF((Z39=0),$AZ$36,IFERROR(ROUND(AB39/AA39,2),$AZ$36))","v":"n/a"},null,null,null,"Eu6",{"$f":"IF((AE39=0),$AZ$36,IFERROR(ROUND(AG39/AF39,2),$AZ$36))","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eu7",{"$f":"IF((AU39=0),$AZ$36,IFERROR(ROUND(AW39/AV39,2),$AZ$36))","v":"n/a"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7.1","7.2","7.3*","7.4*","7.5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n/a","Act.","Target","Max.","Act."]
[null,"P7",{"$f":"Questionnaire_VDA!C123","v":"Customer Care / Customer Satisfaction / Service"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Questionnaire_VDA!D124","v":"n/a"},{"$f":"Questionnaire_VDA!D126","v":"n/a"},{"$f":"Questionnaire_VDA!D128","v":"n/a"},{"$f":"Questionnaire_VDA!D130","v":"n/a"},{"$f":"Questionnaire_VDA!D132","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EP7",{"$f":"IF((BA44>=BB44),ROUND(BD44/BC44,2),AZ43)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(P44:T44,\">-\")","v":5},{"$f":"COUNT(P44:T44)","v":0},4,{"$f":"IF((BA44>=BB44),BA44*10,\"--\")","v":"--"},{"$f":"IF((BA44>=BB44),SUM(P44:T44),\"--\")","v":"--"}]
[]
[]
[]
[null,"Overall compliance EG:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classification:"]
[null,null,null,"Total points awarded for the relevant questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BD9,BP14,BP19,BD23,BD37,BD44)","v":0},null,{"$f":"IF(ISERROR(AVERAGE(AM9,AM14,AM19,AM23,AM37,AM44)),$AZ$8,ROUND(S50/S52,2))","v":"n/a"},null,null,{"$f":"IF(U50=\"n/a\",\"n/a\",IF(U50<80%%,\"C\",IF(AND(U50>=80%%,U50<90%),\"B\",IF(U50>=90%,\"A\",))))","v":"n/a"},null,null,null,null,null,"Reasons for down-grading from \"A\" to \"B\" despite the achievement level:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision"]
[null,"EG [%]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At least one process element P2-P7 (P6.1-P6.7 included) or sub-element E1-En < 80%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AM9<80%,AM14<80%,AM19<80%,AM23<80%,AM29<80%,AM31<80%,AM33<80%,AM37<80%,F41<80%,L41<80%,P41<80%,V41<80%,AA41<80%,AF41<80%,AV41<80%,AM44<80%),\"yes\",\"no\")","v":"no"}]
[null,null,null,"Total possible number of points for the relevant questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BC9,BO14,BO19,BC23,BC37,BC44)","v":0},null,null,null,null,null,null,null,null,null,null,"At least one (*) question scored 4 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G9=4,H9=4,D14=4,Q14=4,C19=4,F19=4,J19=4,P19=4,S19=4,W19=4,M23=4,N23=4,G29=4,K29=4,L29=4,O29=4,S29=4,U29=4,AA29=4,AG29=4,G31=4,K31=4,L31=4,O31=4,S31=4,U31=4,AA31=4,AG31=4,G33=4,K33=4,L33=4,O33=4,S33=4,U33=4,AA33=4,AG33=4,G37=4,K37=4,L37=4,O37=4,S37=4,U37=4,AA37=4,AG37=4,R44=4,S44=4),\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(X50=\"A\",X50=\"B\"),OR(AU55=\"yes\",AU56=\"yes\")),\"C\", IF(AND(X50=\"A\",OR(AU51=\"yes\",AU52=\"yes\",AU53=\"yes\")),\"B\",X50))","v":"n/a"},null,null,null,null,null,"At least one question scored 0 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D9=0,G9=0,I9=0,D14=0,Q14=0,G19=0,T19=0,J23=0,M23=0,N23=0,C29=0,I29=0,K29=0,L29=0,P29=0,T29=0,AA29=0,AB29=0,AD29=0,C31=0,I31=0,K31=0,L31=0,P31=0,T31=0,AA31=0,AB31=0,AD31=0,D33=0,J33=0,L33=0,M33=0,Q33=0,U33=0,AB33=0,AE33=0,P44=0,R44=0,C9=0,E9=0,F9=0,H9=0,C14=0,E14=0,F14=0,G14=0,P14=0,R14=0,S14=0,T14=0,C19=0,D19=0,E19=0,F19=0,H19=0,I19=0,J19=0,C33=0,P19=0,Q19=0,R19=0,S19=0,U19=0,V19=0,W19=0,K23=0,L23=0,O23=0,P23=0,D29=0,E29=0,F29=0,G29=0,J29=0,M29=0,I33=0,O29=0,Q29=0,S29=0,U29=0,V29=0,Y29=0,Z29=0,AE29=0,AF29=0,AG29=0,D31=0,E31=0,F31=0,G31=0,J31=0,M31=0,O33=0,O31=0,Q31=0,S31=0,U31=0,V31=0,Y31=0,Z31=0,AE31=0,AF31=0,AG31=0,E33=0,F33=0,G33=0,K33=0,S33=0,P33=0,T33=0,V33=0,W33=0,Z33=0,AA33=0,AF33=0,AG33=0,Q44=0,S44=0,T44=0,W29=0,W31=0,Y33=0,AD33=0),\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reasons for down-grading to \"C\" despite the achievement level:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downgraded to:",null,null,null,null,null,null,"At least one process element P2-P7 or sub-element E1-En < 70%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AM9<70%,AM14<70%,AM19<70%,AM23<70%,AM29<70%,AM31<70%,AM33<70%,AM37<70%,AM44<70%),\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At least one (*) question scored 0 points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G9=0,H9=0,D14=0,Q14=0,C19=0,F19=0,J19=0,P19=0,S19=0,W19=0,M23=0,N23=0,G29=0,K29=0,L29=0,O29=0,S29=0,U29=0,AA29=0,AG29=0,G31=0,K31=0,L31=0,O31=0,S31=0,U31=0,AA31=0,AG31=0,G33=0,K33=0,L33=0,O33=0,S33=0,U33=0,AA33=0,AG33=0,G37=0,K37=0,L37=0,O37=0,S37=0,U37=0,AA37=0,AG37=0,R44=0,S44=0),\"yes\",\"no\")","v":"no"}]
[null,"At least 2/3 of questions must be answered for each evaluated process element and sub element",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Down grading rules must be applied to the classification results (A, B. C). This must be checked by the auditor! "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"level achieved",null,0.6,null,0.7,null,0.8,null,0.9,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"level achieved",null,0.6,null,0.7,null,0.8,null,0.9,null,1]
[null,null,null,"Assessment elements /\nProcess steps",null,null,null,null,null,null,null,"[%]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment\nsub-elements",null,null,null,null,null,null,null,"[%]"]
[null,null,null,{"$f":"C7","v":"Project Management"},null,null,null,null,null,null,{"$f":"B7","v":"P2"},{"$f":"IF(AM9=\"n/a\",\"n/a\",AM9*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C26","v":"1. Process input"},null,null,null,null,null,null,"EE1",{"$f":"IF(F41=\"n/a\",\"n/a\",F41*100)","v":"n/a"}]
[null,null,null,{"$f":"C11","v":"Planning the Product & Process Development"},null,null,null,null,null,null,{"$f":"B11","v":"P3"},{"$f":"IF(AM14=\"n/a\",\"n/a\",AM14*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I26","v":"2. Process management"},null,null,null,null,null,null,"EE2",{"$f":"IF(L41=\"n/a\",\"n/a\",L41*100)","v":"n/a"}]
[null,null,null,{"$f":"C16","v":"Implementation of the Product & Process Development"},null,null,null,null,null,null,{"$f":"B16","v":"P4"},{"$f":"IF(AM19=\"n/a\",\"n/a\",AM19*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O26","v":"3. Process support"},null,null,null,null,null,null,"EE3",{"$f":"IF(P41=\"n/a\",\"n/a\",P41*100)","v":"n/a"}]
[null,null,null,{"$f":"C23","v":"Supplier Management"},null,null,null,null,null,null,{"$f":"B23","v":"P5"},{"$f":"IF(AM23=\"n/a\",\"n/a\",AM23*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S26","v":"4. Material resources"},null,null,null,null,null,null,"EE4",{"$f":"IF(V41=\"n/a\",\"n/a\",V41*100)","v":"n/a"}]
[null,null,null,{"$f":"C25","v":"Process Analysis / Production"},null,null,null,null,null,null,{"$f":"B25","v":"P6"},{"$f":"IF(AM37=\"n/a\",\"n/a\",AM37*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y26","v":"5. Effectiveness of the process"},null,null,null,null,null,null,"EE5",{"$f":"IF(AA41=\"n/a\",\"n/a\",AA41*100)","v":"n/a"}]
[null,null,null,{"$f":"C44","v":"Customer Care / Customer Satisfaction / Service"},null,null,null,null,null,null,{"$f":"B44","v":"P7"},{"$f":"IF(AM44=\"n/a\",\"n/a\",AM44*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD26","v":"6. Process result/ output"},null,null,null,null,null,null,"EE6",{"$f":"IF(AF41=\"n/a\",\"n/a\",AF41*100)","v":"n/a"}]
[null,null,null,{"$f":"IF(Coversheet!J28=\"\",\"\",Coversheet!J28)","v":""},null,null,null,null,null,null,{"$f":"Coversheet!I28","v":""},{"$f":"IF(AM29=\"n/a\",\"n/a\",AM29*100)","v":"n/a"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP26","v":"7. Transport and part handling"},null,null,null,null,null,null,"EE7",{"$f":"IF(AV41=\"n/a\",\"n/a\",AV41*100)","v":"n/a"}]
[null,null,null,{"$f":"IF(Coversheet!J29=\"\",\"\",Coversheet!J29)","v":""},null,null,null,null,null,null,{"$f":"Coversheet!I29","v":""},{"$f":"IF(AM31=\"n/a\",\"n/a\",AM31*100)","v":"n/a"}]
[null,null,null,{"$f":"IF(Coversheet!J30=\"\",\"\",Coversheet!J30)","v":""},null,null,null,null,null,null,{"$f":"Coversheet!I30","v":""},{"$f":"IF(AM33=\"n/a\",\"n/a\",AM33*100)","v":"n/a"}]

{"sheet":"CA_VDA","index":6,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,2,3,5],[1,7,1,9],[2,7,2,9]]}
[null,null,"IMPROVEMENT PROGRAM/\nACTION PLAN"]
[null,null,null,null,null,null,"Company:",{"$f":"IF(Coversheet!I26=\"Process audit per VDA 6.3\",IF(Coversheet!C7=\"\",\"\",Coversheet!C7),\"\")","v":""}]
[null,null,null,null,null,null,"Audit Date:",{"$f":"IF(Coversheet!I26=\"Process audit per VDA 6.3\",IF(Coversheet!L46=\"\",\"\",Coversheet!L46),\"\")","v":""}]
[]
["ITEM","NO.","AUDIT FINDING(-S)","SCORE","IMMEDIATE\nACTION","ROOT CAUSE(-S)","CORRECTIVE ACTION(-S)","DUE\nDATE","ACTUAL DATE","RESPONSIBLE","EFFECTI-\nVENESS"]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H7:H19,\"x\")>0,Questionnaire_VDA!A6,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H7:H19,\"x\")>0,Questionnaire_VDA!C6,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H7=\"x\",MAX($A$6:A6)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A7","v":"2.1"},{"$f":"Questionnaire_VDA!G7","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D7","v":"n/a"},{"$f":"IF(OR(D7=0,D7=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H9=\"x\",MAX($A$6:A7)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A9","v":"2.2"},{"$f":"Questionnaire_VDA!G9","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D9","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H11=\"x\",MAX($A$6:A8)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A11","v":"2.3"},{"$f":"Questionnaire_VDA!G11","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D11","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H13=\"x\",MAX($A$6:A9)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A13","v":"2.4"},{"$f":"Questionnaire_VDA!G13","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D13","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H15=\"x\",MAX($A$6:A10)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A15","v":"2.5"},{"$f":"Questionnaire_VDA!G15","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D15","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H17=\"x\",MAX($A$6:A11)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A17","v":"2.6"},{"$f":"Questionnaire_VDA!G17","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D17","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H19=\"x\",MAX($A$6:A12)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A19","v":"2.7"},{"$f":"Questionnaire_VDA!G19","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D19","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H22:H30,\"x\")>0,Questionnaire_VDA!A21,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H22:H30,\"x\")>0,Questionnaire_VDA!C21,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H22=\"x\",MAX($A$6:A14)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A22","v":"3.1"},{"$f":"Questionnaire_VDA!G22","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D22=\"n/a\",Questionnaire_VDA!E22=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D22:E22))","v":"n/a"},{"$f":"IF(OR(D15=0,D15=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H24=\"x\",MAX($A$6:A15)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A24","v":"3.2"},{"$f":"Questionnaire_VDA!G24","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D24=\"n/a\",Questionnaire_VDA!E24=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D24:E24))","v":"n/a"},{"$f":"IF(OR(D16=0,D16=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H26=\"x\",MAX($A$6:A16)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A26","v":"3.3"},{"$f":"Questionnaire_VDA!G26","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D26=\"n/a\",Questionnaire_VDA!E26=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D26:E26))","v":"n/a"},{"$f":"IF(OR(D17=0,D17=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H28=\"x\",MAX($A$6:A17)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A28","v":"3.4"},{"$f":"Questionnaire_VDA!G28","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D28=\"n/a\",Questionnaire_VDA!E28=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D28:E28))","v":"n/a"},{"$f":"IF(OR(D18=0,D18=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H30=\"x\",MAX($A$6:A18)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A30","v":"3.5"},{"$f":"Questionnaire_VDA!G30","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D30=\"n/a\",Questionnaire_VDA!E30=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D30:E30))","v":"n/a"},{"$f":"IF(OR(D19=0,D19=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H33:H48,\"x\")>0,Questionnaire_VDA!A32,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H33:H48,\"x\")>0,Questionnaire_VDA!C32,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H33=\"x\",MAX($A$6:A20)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A33","v":"4.1"},{"$f":"Questionnaire_VDA!G33","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D33=\"n/a\",Questionnaire_VDA!E33=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D33:E33))","v":"n/a"},{"$f":"IF(OR(D21=0,D21=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H35=\"x\",MAX($A$6:A21)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A35","v":"4.2"},{"$f":"Questionnaire_VDA!G35","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D35=\"n/a\",Questionnaire_VDA!E35=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D35:E35))","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H37=\"x\",MAX($A$6:A22)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A37","v":"4.3"},{"$f":"Questionnaire_VDA!G37","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D37=\"n/a\",Questionnaire_VDA!E37=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D37:E37))","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H39=\"x\",MAX($A$6:A23)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A39","v":"4.4"},{"$f":"Questionnaire_VDA!G39","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D39=\"n/a\",Questionnaire_VDA!E39=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D39:E39))","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H41=\"x\",MAX($A$6:A24)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A41","v":"4.5"},{"$f":"Questionnaire_VDA!G41","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D41=\"n/a\",Questionnaire_VDA!E41=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D41:E41))","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H43=\"x\",MAX($A$6:A25)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A43","v":"4.6"},{"$f":"Questionnaire_VDA!G43","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D43=\"n/a\",Questionnaire_VDA!E43=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D43:E43))","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H45=\"x\",MAX($A$6:A26)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A45","v":"4.7"},{"$f":"Questionnaire_VDA!G45","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D45=\"n/a\",Questionnaire_VDA!E45=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D45:E45))","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H47=\"x\",MAX($A$6:A27)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A47","v":"4.8"},{"$f":"Questionnaire_VDA!G47","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D47=\"n/a\",Questionnaire_VDA!E47=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D47:E47))","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H50:H62,\"x\")>0,Questionnaire_VDA!A49,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H50:H62,\"x\")>0,Questionnaire_VDA!C49,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H50=\"x\",MAX($A$6:A29)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A50","v":"5.1"},{"$f":"Questionnaire_VDA!G50","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D50","v":"n/a"},{"$f":"IF(OR(D30=0,D30=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H52=\"x\",MAX($A$6:A30)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A52","v":"5.2"},{"$f":"Questionnaire_VDA!G52","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D52","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H54=\"x\",MAX($A$6:A31)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A54","v":"5.3"},{"$f":"Questionnaire_VDA!G54","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D54","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H56=\"x\",MAX($A$6:A32)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A56","v":"5.4"},{"$f":"Questionnaire_VDA!G56","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D56","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H58=\"x\",MAX($A$6:A33)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A58","v":"5.5"},{"$f":"Questionnaire_VDA!G58","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D58","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H60=\"x\",MAX($A$6:A34)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A60","v":"5.6"},{"$f":"Questionnaire_VDA!G60","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D60","v":"n/a"},"no"]
[{"$f":"IF(Questionnaire_VDA!H62=\"x\",MAX($A$6:A35)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A62","v":"5.7"},{"$f":"Questionnaire_VDA!G62","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D62","v":"n/a"},"no"]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H66:H121,\"x\")>0,Questionnaire_VDA!A64,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H66:H121,\"x\")>0,Questionnaire_VDA!C64,\"\")","v":""}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H66:H74,\"x\")>0,Questionnaire_VDA!A65,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H66:H74,\"x\")>0,Questionnaire_VDA!C65,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H66=\"x\",MAX($A$6:A38)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A66","v":"6.1.1"},{"$f":"Questionnaire_VDA!G66","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D66=\"n/a\",Questionnaire_VDA!E66=\"n/a\",Questionnaire_VDA!F66=\"n/a\",),\"n/a\",MIN(Questionnaire_VDA!D66:F66))","v":0},{"$f":"IF(OR(D39=0,D39=4),\"yes\",\"no\")","v":"yes"}]
[{"$f":"IF(Questionnaire_VDA!H68=\"x\",MAX($A$6:A39)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A68","v":"6.1.2"},{"$f":"Questionnaire_VDA!G68","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D68=\"n/a\",Questionnaire_VDA!E68=\"n/a\",Questionnaire_VDA!F68=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D68:F68))","v":"n/a"},{"$f":"IF(OR(D40=0,D40=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H70=\"x\",MAX($A$6:A40)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A70","v":"6.1.3"},{"$f":"Questionnaire_VDA!G70","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D70=\"n/a\",Questionnaire_VDA!E70=\"n/a\",Questionnaire_VDA!F70=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D70:F70))","v":"n/a"},{"$f":"IF(OR(D41=0,D41=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H72=\"x\",MAX($A$6:A41)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A72","v":"6.1.4"},{"$f":"Questionnaire_VDA!G72","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D72=\"n/a\",Questionnaire_VDA!E72=\"n/a\",Questionnaire_VDA!F72=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D72:F72))","v":"n/a"},{"$f":"IF(OR(D42=0,D42=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H74=\"x\",MAX($A$6:A42)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A74","v":"6.1.5"},{"$f":"Questionnaire_VDA!G74","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D74=\"n/a\",Questionnaire_VDA!E74=\"n/a\",Questionnaire_VDA!F74=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D74:F74))","v":"n/a"},{"$f":"IF(OR(D43=0,D43=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H77:H85,\"x\")>0,Questionnaire_VDA!A76,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H77:H85,\"x\")>0,Questionnaire_VDA!C76,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H77=\"x\",MAX($A$6:A44)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A77","v":"6.2.1"},{"$f":"Questionnaire_VDA!G77","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D77=\"n/a\",Questionnaire_VDA!E77=\"n/a\",Questionnaire_VDA!F77=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D77:F77))","v":"n/a"},{"$f":"IF(OR(D45=0,D45=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H79=\"x\",MAX($A$6:A45)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A79","v":"6.2.2"},{"$f":"Questionnaire_VDA!G79","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D79=\"n/a\",Questionnaire_VDA!E79=\"n/a\",Questionnaire_VDA!F79=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D79:F79))","v":"n/a"},{"$f":"IF(OR(D46=0,D46=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H81=\"x\",MAX($A$6:A46)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A81","v":"6.2.3"},{"$f":"Questionnaire_VDA!G81","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D81=\"n/a\",Questionnaire_VDA!E81=\"n/a\",Questionnaire_VDA!F81=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D81:F81))","v":"n/a"},{"$f":"IF(OR(D47=0,D47=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H83=\"x\",MAX($A$6:A47)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A83","v":"6.2.4"},{"$f":"Questionnaire_VDA!G83","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D83=\"n/a\",Questionnaire_VDA!E83=\"n/a\",Questionnaire_VDA!F83=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D83:F83))","v":"n/a"},{"$f":"IF(OR(D48=0,D48=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H85=\"x\",MAX($A$6:A48)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A85","v":"6.2.5"},{"$f":"Questionnaire_VDA!G85","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D85=\"n/a\",Questionnaire_VDA!E85=\"n/a\",Questionnaire_VDA!F85=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D85:F85))","v":"n/a"},{"$f":"IF(OR(D49=0,D49=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H88:H92,\"x\")>0,Questionnaire_VDA!A87,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H88:H92,\"x\")>0,Questionnaire_VDA!C87,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H88=\"x\",MAX($A$6:A50)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A88","v":"6.3.1"},{"$f":"Questionnaire_VDA!G88","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D88=\"n/a\",Questionnaire_VDA!E88=\"n/a\",Questionnaire_VDA!F88=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D88:F88))","v":"n/a"},{"$f":"IF(OR(D51=0,D51=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H90=\"x\",MAX($A$6:A51)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A90","v":"6.3.2"},{"$f":"Questionnaire_VDA!G90","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D90=\"n/a\",Questionnaire_VDA!E90=\"n/a\",Questionnaire_VDA!F90=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D90:F90))","v":"n/a"},{"$f":"IF(OR(D52=0,D52=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H92=\"x\",MAX($A$6:A52)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A92","v":"6.3.3"},{"$f":"Questionnaire_VDA!G92","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D92=\"n/a\",Questionnaire_VDA!E92=\"n/a\",Questionnaire_VDA!F92=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D92:F92))","v":"n/a"},{"$f":"IF(OR(D53=0,D53=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H95:H103,\"x\")>0,Questionnaire_VDA!A94,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H95:H103,\"x\")>0,Questionnaire_VDA!C94,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H95=\"x\",MAX($A$6:A54)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A95","v":"6.4.1"},{"$f":"Questionnaire_VDA!G95","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D95=\"n/a\",Questionnaire_VDA!E95=\"n/a\",Questionnaire_VDA!F95=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D95:F95))","v":"n/a"},{"$f":"IF(OR(D55=0,D55=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H97=\"x\",MAX($A$6:A55)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A97","v":"6.4.2"},{"$f":"Questionnaire_VDA!G97","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D97=\"n/a\",Questionnaire_VDA!E97=\"n/a\",Questionnaire_VDA!F97=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D97:F97))","v":"n/a"},{"$f":"IF(OR(D56=0,D56=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H99=\"x\",MAX($A$6:A56)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A99","v":"6.4.3"},{"$f":"Questionnaire_VDA!G99","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D99=\"n/a\",Questionnaire_VDA!E99=\"n/a\",Questionnaire_VDA!F99=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D99:F99))","v":"n/a"},{"$f":"IF(OR(D57=0,D57=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H103=\"x\",MAX($A$6:A57)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A103","v":"6.4.5"},{"$f":"Questionnaire_VDA!G103","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D103=\"n/a\",Questionnaire_VDA!E103=\"n/a\",Questionnaire_VDA!F103=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D103:F103))","v":"n/a"},{"$f":"IF(OR(D58=0,D58=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H106:H112,\"x\")>0,Questionnaire_VDA!A105,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H106:H112,\"x\")>0,Questionnaire_VDA!C105,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H106=\"x\",MAX($A$6:A59)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A106","v":"6.5.1"},{"$f":"Questionnaire_VDA!G106","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D106=\"n/a\",Questionnaire_VDA!E106=\"n/a\",Questionnaire_VDA!F106=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D106:F106))","v":"n/a"},{"$f":"IF(OR(D60=0,D60=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H108=\"x\",MAX($A$6:A60)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A108","v":"6.5.2"},{"$f":"Questionnaire_VDA!G108","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D108=\"n/a\",Questionnaire_VDA!E108=\"n/a\",Questionnaire_VDA!F108=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D108:F108))","v":"n/a"},{"$f":"IF(OR(D61=0,D61=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H110=\"x\",MAX($A$6:A61)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A110","v":"6.5.3"},{"$f":"Questionnaire_VDA!G110","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D110=\"n/a\",Questionnaire_VDA!E110=\"n/a\",Questionnaire_VDA!F110=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D110:F110))","v":"n/a"},{"$f":"IF(OR(D62=0,D62=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H112=\"x\",MAX($A$6:A62)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A112","v":"6.5.4"},{"$f":"Questionnaire_VDA!G112","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D112=\"n/a\",Questionnaire_VDA!E112=\"n/a\",Questionnaire_VDA!F112=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D112:F112))","v":"n/a"},{"$f":"IF(OR(D63=0,D63=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H115:H121,\"x\")>0,Questionnaire_VDA!A114,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H115:H121,\"x\")>0,Questionnaire_VDA!C114,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H115=\"x\",MAX($A$6:A64)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A115","v":"6.6.1"},{"$f":"Questionnaire_VDA!G115","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D115=\"n/a\",Questionnaire_VDA!E115=\"n/a\",Questionnaire_VDA!F115=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D115:F115))","v":"n/a"},{"$f":"IF(OR(D65=0,D65=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H117=\"x\",MAX($A$6:A65)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A117","v":"6.6.2"},{"$f":"Questionnaire_VDA!G117","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D117=\"n/a\",Questionnaire_VDA!E117=\"n/a\",Questionnaire_VDA!F117=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D117:F117))","v":"n/a"},{"$f":"IF(OR(D66=0,D66=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H119=\"x\",MAX($A$6:A66)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A119","v":"6.6.3"},{"$f":"Questionnaire_VDA!G119","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D119=\"n/a\",Questionnaire_VDA!E119=\"n/a\",Questionnaire_VDA!F119=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D119:F119))","v":"n/a"},{"$f":"IF(OR(D67=0,D67=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H121=\"x\",MAX($A$6:A67)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A121","v":"6.6.4"},{"$f":"Questionnaire_VDA!G121","v":"Enter explanation"},{"$f":"IF(AND(Questionnaire_VDA!D121=\"n/a\",Questionnaire_VDA!E121=\"n/a\",Questionnaire_VDA!F121=\"n/a\"),\"n/a\",MIN(Questionnaire_VDA!D121:F121))","v":"n/a"},{"$f":"IF(OR(D68=0,D68=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(COUNTIF(Questionnaire_VDA!H124:H133,\"x\")>0,Questionnaire_VDA!A123,\"\")","v":""},{"$f":"IF(COUNTIF(Questionnaire_VDA!H124:H133,\"x\")>0,Questionnaire_VDA!C123,\"\")","v":""}]
[{"$f":"IF(Questionnaire_VDA!H124=\"x\",MAX($A$6:A69)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A124","v":"7.1"},{"$f":"Questionnaire_VDA!G124","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D124","v":"n/a"},{"$f":"IF(OR(D70=0,D70=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H126=\"x\",MAX($A$6:A70)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A126","v":"7.2"},{"$f":"Questionnaire_VDA!G126","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D126","v":"n/a"},{"$f":"IF(OR(D71=0,D71=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H128=\"x\",MAX($A$6:A71)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A128","v":"7.3"},{"$f":"Questionnaire_VDA!G128","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D128","v":"n/a"},{"$f":"IF(OR(D72=0,D72=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H130=\"x\",MAX($A$6:A72)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A130","v":"7.4"},{"$f":"Questionnaire_VDA!G130","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D130","v":"n/a"},{"$f":"IF(OR(D73=0,D73=4),\"yes\",\"no\")","v":"no"}]
[{"$f":"IF(Questionnaire_VDA!H132=\"x\",MAX($A$6:A73)+1,\"\")","v":""},{"$f":"Questionnaire_VDA!A132","v":"7.5"},{"$f":"Questionnaire_VDA!G132","v":"Enter explanation"},{"$f":"Questionnaire_VDA!D132","v":"n/a"},{"$f":"IF(OR(D74=0,D74=4),\"yes\",\"no\")","v":"no"}]