Export the XLS to PDF. Present the summary to supplier management. The CAP sheet is already populated with non-conformances. Assign responsible parties and due dates immediately.

As you continue, the XLS’s summary dashboard updates automatically. You see current compliance at 82% (Yellow). You know you are borderline. Focus on critical process controls.

Use the XLS to tick through documents required by CQI-27. For Clause 2.1.4 (Material verification), you ask for melt logs. The supplier shows a spreadsheet. You record in the XLS: “Compliant – logs complete.”

Go to the Dashboard. Select “High Pressure Die Casting” (Section 2). Enter audit scope: Melting, shot end, trimming, and X-ray inspection.

Check Clause 2.3.6 (Shot speed and intensification pressure). The machine’s digital display shows parameters out of range. You mark “Non-Compliant” in the drop-down. The XLS auto-flags the finding in red. You type the evidence: “Shot speed setpoint drift; closed-loop control not functioning.”

Introduction: Why CQI-27 Matters More Than Ever In the world of automotive and industrial manufacturing, casting defects are not merely a nuisance—they are a liability. Porosity, inclusions, cold shuts, and dimensional inaccuracies can lead to catastrophic product failures, costly recalls, and damaged brand reputations. Recognizing this, the Automotive Industry Action Group (AIAG) developed the CQI-27 Casting System Assessment (CSA) . This standard is not a casual checklist; it is a rigorous, process-based auditing system designed to ensure that suppliers of castings (whether iron, steel, or aluminum) maintain consistent quality and process control.

| Clause ID | Process Step | Requirement (from AIAG) | Finding / Observation | Compliance (Drop-down) | Evidence Reference | Action Required | Due Date | |-----------|--------------|-------------------------|----------------------|----------------|--------------------|------------------|-----------| | 2.1.1 | Melting | Furnace temperature uniformity ±15°C | Thermocouple calibration overdue | Non-Compliant | Cal log p.42 | Calibrate by 6/15 | 6/15/2025 | | 2.2.3 | Pouring | Tundish preheat temp logged daily | No log for shift 2 | Requires Action | Shift reports missing | Implement log sheet | 6/10/2025 |

However, implementing CQI-27 effectively without the right tools is like navigating a labyrinth without a map. This is where a well-structured (Excel spreadsheet) becomes invaluable. This article will dissect the CQI-27 standard, explain why an Excel-based assessment tool is the industry’s preferred solution, and provide a roadmap to creating or using an XLS file that drives real, measurable improvement. Section 1: What is CQI-27? A Refresher on the Standard The CQI-27 standard is part of the AIAG’s "Continuous Quality Improvement" (CQI) series, analogous to CQI-9 (Heat Treat) and CQI-12 (Coating). It specifically targets special processes related to casting.