Cqi27 Casting System Assessment Xls Upd

File Name: cqi27_casting_system_assessment.xls Version: Updated (UPD) Applicable Standard: AIAG CQI-27, 2nd Edition (or current revision)

The updated CQI27_Assessment_Template_v2.xls (or similar naming) includes the following enhancements compared to legacy versions:

| Feature | Old version | Updated (2024/2025) | |--------|------------|--------------------------| | 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 | cqi27 casting system assessment xls upd

📥 Download the updated XLS file here: [Internal link / shared drive / contact quality team]

Used to verify process adherence on specific production jobs. File Name: cqi27_casting_system_assessment

This replicates the official checklist. Typical columns:

| Process Step | Requirement Clause | Acceptance Criteria | Evidence/Method | Score (0/5/10) | Findings | Corrective Action | Due Date | Status | |--------------|--------------------|---------------------|----------------|----------------|-----------|--------------------|----------|--------| Used to verify process adherence on specific production jobs

  • Automated conditional alerts for scores <5.

    • The updated XLS includes a dynamic CAP tracker. For each nonconformance, you must:

    Once all questions are answered, click the "Calculate Final Score" button (if macro-enabled). The tool will present: