| 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 |
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.”
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.
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.”
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.
| 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 |
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.” cqi-27 casting system assessment xls
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. | Clause ID | Process Step | Requirement
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.” The XLS auto-flags the finding in red
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.