Cqi27 Casting | System Assessment Xls Upd

| Pitfall | Solution in Updated XLS | |--------|--------------------------| | Forgetting to update N/A justification | N/A column requires a text explanation | | Missing furnace uniformity testing | Pre-filled reminder cells with due dates | | Heat treat not aligned with CQI-9 | Annex D links directly to CQI-9 checklist | | No evidence of internal audit | Separate tab for “Internal Audit History” | | Corrective actions not tracked to closure | Auto-expiring due date flags after 30 days |

CQI-27 is the AIAG Casting System Assessment (CSA), part of the CQI (Continuous Quality Improvement) series. It specifically applies to foundries (die casting, sand casting, investment casting, etc.) and ensures process control over: cqi27 casting system assessment xls upd

⚠️ Note: For pure heat treat operations (without casting), use CQI-9. For purely casting without heat treat, CQI-27 still applies but sections can be marked N/A. Scope & Scope Exclusions

After entering data, click the Generate Report button. The XLS upd will automatically: Assessment Checklist (mapped to CQI-27 clauses)

Open the XLS and enable macros. Navigate to the System Info tab. Enter:

Example formula for summary sheet:

=SUMIFS(Detailed!D:D, Detailed!A:A, ">=0") / (COUNTIF(Detailed!A:A, "Process Control")*10) *100