| Feature | Old version | | |--------|------------|--------------------------| | Process tables | 3 main sections | 5 process tables (separated heat treat annex) | | Scoring logic | Manual calculation | Automated scoring with conditional formatting | | Corrective action tracker | Separate sheet | Integrated within each section | | Heat treat annex | Generic | Aligned with CQI-9, 4th edition requirements | | Part approval linkage | None | Link to PPAP/ISIR references | | Digital signature fields | Missing | Added for supplier & customer approval | | Dropdown menus | Partial | Full dropdowns for N/A, conforming, nonconforming |
Use Excel Data Validation for:
Here's a basic example of what an XLS template for CQI-27 assessment could look like: cqi27 casting system assessment xls upd
Send to your customer’s quality engineer. Also, archive it locally for future IATF 16949 audits. cqi27 casting system assessment xls upd
The updated tables include more granular details on process controls that prevent catastrophic part failure. cqi27 casting system assessment xls upd