Go to the Dashboard. Select “High Pressure Die Casting” (Section 2). Enter audit scope: Melting, shot end, trimming, and X-ray inspection.
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. cqi-27 casting system assessment xls
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.” Go to the Dashboard
| 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 | Export the XLS to PDF
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.