A standard CQI-27 XLS file is typically divided into several critical sections: 1. Management Responsibility and Quality Planning
The CQI-27 Excel tool is not a simple checklist; it is a specialized spreadsheet architecture designed to mirror the three primary sections of the official CQI-27 standard: , Process Table B (Low Pressure/Semi-Permanent Mold) , and Process Table C (Gravity Casting) . The XLS assessment tool systematically converts subjective observations into quantifiable scores. It typically features interactive drop-down menus for scoring criteria (e.g., “Acceptable,” “Needs Improvement,” “Non-compliant”), automated traffic-light color coding, and embedded calculation fields for determining overall compliance percentages. By using conditional formatting, the spreadsheet instantly flags high-risk nonconformances without requiring the auditor to perform manual arithmetic.
The AIAG CQI-27 standard divides different casting types into specific Process Tables. Your XLS file should contain dedicated sheets for the tables relevant to your facility: Sand Casting (Iron/Steel) Process Table B: Centrifugal Casting (Iron/Steel) Process Table C: Investment Casting (Iron/Steel) Process Table D: High-Pressure Die Casting (Aluminum/Zinc)
Caution: Without a deep understanding of CQI-27 clauses, self-built sheets often miss critical requirements like “lift truck furnace charging safety interlocks.” cqi-27 casting system assessment xls
Key objectives of CQI-27:
You have three options:
Assessment of the machinery. It ensures that melting furnaces, holding furnaces, and casting machines are maintained and calibrated. 4. Job Audit A standard CQI-27 XLS file is typically divided
Let’s walk through a real-world scenario: You are a quality engineer auditing an aluminum die casting supplier. You have your open on a laptop.
Back at the foundry, the Plant Manager, "Big Sal," was skeptical.
Weight certain clauses as “Critical” (e.g., Clauses related to safety-critical casting integrity). Use a multiplier so that failure on a critical clause automatically fails the entire assessment, regardless of total score. Your XLS file should contain dedicated sheets for
Raj began navigating the tabs.
Developed by the Automotive Industry Action Group (AIAG), CQI-27 is a specialized assessment designed to evaluate and improve the control of casting processes. Unlike general quality standards, it focuses specifically on the common failure modes—like porosity, leakage, and cracks—that lead to non-conforming parts.