If you are updating an Excel tool to match the 2023 standard, your spreadsheet should be restructured to remove P7 and adjust the specific questions. Below is the structural template used for the official checklists.
You can copy this structure into Excel:
| Column A | Column B | Column C | Column D | Column E | | :--- | :--- | :--- | :--- | :--- | | Process Element | Question No. | Question Text (Summary) | Audit Finding | Evidence / Remarks | | P1 Potential Analysis | 1.1 | Are the prerequisites for the quotation process fulfilled? | [Drop-down: Yes/No/NA] | | | P2 Project Management | 2.1 | Is there a project organization? | | | | | 2.2 | ... | | | | P3 Product/Process Dev | 3.1 | Are the product requirements defined? | | | | P4 Product/Process Dev | 4.1 | ... | | | | P5 Supplier Management | 5.1 | ... | | | | P6 Process Analysis | 6.1 | ... | | | | (Note: P7 is removed) | | | | |
Before building the sheet, you must understand what changed. If you are using an old 2016 sheet, your audit results will be invalid. The "Patch" involves the following structural changes:
A proper VDA 6.3 Excel checklist includes these formulas: