Add a summary sheet with:
This is where the actual audit happens. Structure your columns as follows: vda 6.3 audit checklist excel 2023
For quality managers and auditors, transitioning to a format is essential for maintaining compliance and accurately calculating compliance levels across the supply chain. Key Changes in the 2023 Edition Add a summary sheet with: This is where
| Element | Name | # of questions | |---------|------|----------------| | P1 | Potential analysis (supplier selection) | ~36 | | P2 | Project management | 5 | | P3 | Product and process development planning | 5 | | P4 | Product and process development realization | 7 | | P5 | Supplier management | 5 | | P6 | Production process (6 sub-elements) | 26 | | P7 | Customer support / satisfaction | 4 | Most checklists start from P2 for the full process audit
You can use a conditional formatting rule on your "Average Score" cell:
Note: In the 2023 revision, P1 (Potential Analysis) is often separate. Most checklists start from P2 for the full process audit.
An effective audit checklist is more than a list of questions; it is a calculation tool. We recommend organizing your Excel workbook into .