Assessment Xls - Cqi-27 Casting System

The CQI-27 Special Process: Casting System Assessment (2nd Edition) is a common process requirement developed by the AIAG to ensure foundries consistently produce high-quality automotive castings. It is designed to evaluate a foundry's ability to meet customer requirements and is typically required for self-assessment at least once a year. Assessment Structure & Components

The assessment is structured around several key sections, typically provided in an Excel (XLS) format to facilitate documentation:

Management Systems: Evaluates overall quality management, including operator training, maintenance, and documentation effectiveness.

Process Controls: Focuses on critical parameters such as melting temperatures, pouring conditions, and solidification control.

Casting Design & Tooling: Covers requirements for design software, stress analysis (FEA), casting simulations, and tool maintenance. cqi-27 casting system assessment xls

Process Tables (A-J): Specific requirements tailored to different casting methods: Table A: Sand Casting (Iron/Steel) Table B/C: Centrifugal Castings & Liners Table D: Investment Casting (Iron/Steel) Table E: Aluminum Semi-Permanent Mold (Cylinder Heads) Table G: Aluminum Metal Mold Table H: Aluminum High-Pressure Die Casting Table J: Zinc High-Pressure Die Casting Scoring and Documentation Guidelines

When completing the XLS template, the following rules generally apply for each line item:

Conforming: Mark if requirements and customer-specific standards are met. Non-Conforming: Requires a detailed corrective action plan. Not Applicable (N/A):

Enter a score of "3" if the element is N/A and there is no current risk. The CQI-27 Special Process: Casting System Assessment (2nd

Enter a score of "2" if the element is N/A but has potential future risk.

Notes: Always provide supporting records or explanations for actual conditions, especially if minimum requirements are not met. How to Obtain the Assessment

Official copies and the accompanying Excel file are proprietary and must be purchased directly from the AIAG Store. Some foundries use third-party platforms like TopQM-Systems for specialized support and training. CQI-27 Casting System Assessment - TopQM-Systems

4.1 Using an Outdated Excel Version

CQI-27 was updated in 2022 (CQI-27 3rd Edition). Older XLS files (2nd edition) are obsolete. Verify your XLS includes new requirements like: Digital process monitoring (Section 1

12. Continuous Improvement

❌ Trap 4: No Password Protection for Formulas

If your XLS is unprotected, a user can accidentally delete a scoring formula, breaking the assessment. Solution: Lock all cells except data entry fields. Use password protect for the workbook structure.

Section 6: Advanced Features – Taking Your XLS to the Next Level

A basic CQI-27 spreadsheet is good. A truly advanced XLS tool is a game-changer. Consider adding:

Part 6: Where to Download a Premium CQI-27 Casting System Assessment XLS

Not all Excel templates are equal. Here are your options:

Step 1: Pre-Audit Preparation