Vda 6.3 Audit Checklist | Excel 2023 !!top!!

Before building or buying a checklist, note the major changes from the 2016 edition:

| Metric | Value | |--------|-------| | Total possible points | =SUM(IF(D2:D100<>"N/A",10,0)) | | Achieved points | =SUM(D2:D100) | | Overall % | =achieved/total_possible | | Result | =IF(overall>=90,"A",IF(overall>=80,"B","C")) | If you want, I can provide an with the official 2023 question IDs and scoring formulas. Just let me know. vda 6.3 audit checklist excel 2023

approx. 58 P1: used separately for new supplier evaluation. 3. Excel Layout – Recommended Columns Create a worksheet for each P-element or one master sheet with filtering. Before building or buying a checklist, note the

| Column | Content | |--------|---------| | A | Question ID (e.g., P2.1, P6.1.2) | | B | Question text (exactly as in VDA 6.3:2023) | | C | Requirement / Explanation (e.g., “Project plan exists and is monitored”) | | D | Score (dropdown: 0, 4, 6, 8, 10) | | E | Finding / Remark (free text) | | F | Evidence / Document reference | | G | Auditor name | | H | Status (Open / Closed / Not applicable) | | I | Deg. (%) – for calculation later | 58 P1: used separately for new supplier evaluation

| Area | Change | |------|--------| | | Now includes minimum requirements for “virtual audits” and remote audit elements | | P2–P7 | Modified questions on digitalization , software development , and agile methods | | Scoring model | Unchanged (0/4/6/8/10 scoring), but some question wordings updated for clarity | | P4 – Production | Stronger focus on AI / machine learning / automated systems validation | | P6 – Process | Added sub-elements for cybersecurity in manufacturing execution systems (MES) | The official VDA 6.3:2023 red book is the only binding reference. Checklist templates must reflect this version. 2. Structure of the VDA 6.3 Excel Checklist Your Excel file should contain 7 process elements (P2–P7) + P1 (optional) .

| A | B | C | D | E | F | |---|---|---|---|---|---| | P2.1 | Is project management established? | Project plan, milestones, roles | 10 | OK | Project charter v1.2 |