Cqi-27 Casting System Assessment Xls -

Good XLS templates include columns for “Target Value,” “Upper Limit,” and “Lower Limit.” Filling these turns the XLS from a checklist into a process capability tool. Solution: Enter actual limits (e.g., “Pour temp: 680°C ± 10°C”) so the audit is data-driven.

When you download or build a CQI-27 Excel assessment, ensure it includes the following mandatory sections:

If you meant you need help building or interpreting such an Excel file, or want me to generate a template outline / formula set for that feature, let me know and I can provide the Excel logic or structure.

CQI-27 Special Process: Casting System Assessment (CSA) is a standard published by the Automotive Industry Action Group (AIAG)

designed to provide common process requirements for foundry suppliers of automotive castings. The assessment is typically completed using a downloadable Excel file that serves as the reporting tool for the audit. Core Structure of the Assessment

The assessment is divided into several sections, primarily focusing on general system requirements and specific process tables:

AIAG CQI-27 Special Process: Casting System Assessment, 2nd Edition is Now Available for Stakeholder Review and Commenting

Feature: CQI-27 Casting System Assessment XLS

Description: The CQI-27 Casting System Assessment XLS is an Excel-based tool designed to support the automotive industry in assessing and improving the quality of casting systems. This feature enables users to evaluate and analyze casting system performance, identify areas for improvement, and implement corrective actions to enhance overall quality. cqi-27 casting system assessment xls

Key Benefits:

Key Features:

Target Audience:

System Requirements:

Support and Maintenance:

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. One-click summary report for management review

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.

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.

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 Good XLS templates include columns for “Target Value,”

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

Use the XLS to perform an internal audit 60 days before the customer audit. Insert a column called “Gap Action Owner” and assign deadlines.

Example mock audit result:

The CQI-27 Excel tool was designed to catch the invisible killers of casting quality. It didn't ask, "Is the part good?" It asked, "Is the environment controlled enough to ensure the part stays good?"

They scrolled to the section on Thermal Control. Question 2.3: "Is the die temperature monitored and recorded continuously for critical zones?" "We check it every hour," Sal said confidently. Raj read the requirement carefully. "It asks for continuous monitoring. We write it on a clipboard once an hour. That’s not continuous."

He clicked "Partial Compliance." The score in the sidebar dropped.

Then, the critical hit: Section 4 – Maintenance. Question 4.1: "Is there a preventive maintenance schedule for the shot sleeve and plunger tip based on shot count?" Sal froze. "We change them when they wear out. Or when the pressure spikes." "That’s reactive," Raj said, his stomach sinking. "CQI-27 requires predictive replacement based on historical data. We have no shot counter log tied to PM."

The spreadsheet calculated the final score. 61%. The failure mode was identified. The spreadsheet didn't care about Sal’s thirty years of experience; it cared about data traceability.

Raj looked at the "Corrective Action" tab at the bottom of the workbook. "We can’t just say we’ll fix it. The XLS forces us to assign an owner, a due date, and a root cause analysis."

If you are auditing a gravity permanent mold process but used Table A (Die Casting), your XLS will generate irrelevant questions, wasting time. Always match the table to the technology.