: Verifies that specific parts are produced according to the established control plans and customer requirements. Process Tables
Not all Excel templates are equal. Here are your options:
| 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 |
Easy navigation between sections, checkboxes for compliance, and automated scoring.
The CQI-27 Special Process: Casting System Assessment provides requirements for foundry suppliers of OEM automotive castings. AIAG
The assessment is divided into three main sections, depending on the casting method:
If your XLS is unprotected, a user can accidentally delete a scoring formula, breaking the assessment. Lock all cells except data entry fields. Use password protect for the workbook structure.
Implement simple arithmetic formulas to calculate percentage compliance:
This section evaluates whether leadership supports the quality management system. The XLS sheet tracks items such as: Availability of dedicated quality personnel. Evidence of regular management reviews.
Always ensure you are using the most current version from the AIAG Store to avoid using outdated requirements. If you'd like, I can help further by:
The Automotive Industry Action Group (AIAG) publishes the CQI-27 Special Process: Casting System Assessment to provide a common approach to a casting management system for automotive production and service part organizations. Deploying this assessment via a structured spreadsheet (XLS) format allows organizations to efficiently evaluate their internal casting processes, drive continuous improvement, and ensure strict compliance with global OEM requirements. 1. What is the CQI-27 Assessment?
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.
Contains metadata such as facility name, assessment date, auditor names, overall compliance score, and a visual summary chart.
, it aims to eliminate common root causes of casting defects and minimize risks in automotive applications. The assessment is typically conducted via an Excel-based checklist that foundries must complete at least once a year. Https://Www.En-Standard.Eu Key Components of the Assessment
Helps foundries meet the "special process" requirements of their automotive customers.
مرجع تخصصی شبکه ایران ؛ جایی که دانش، تجربه و منابع ارزشمند دنیای شبکه به زبان ساده و کاربردی در اختیار علاقهمندان، دانشجویان و متخصصان این حوزه قرار میگیرد.
طراحی شده توسط تیم فوژان
: Verifies that specific parts are produced according to the established control plans and customer requirements. Process Tables
Not all Excel templates are equal. Here are your options:
| 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 |
Easy navigation between sections, checkboxes for compliance, and automated scoring.
The CQI-27 Special Process: Casting System Assessment provides requirements for foundry suppliers of OEM automotive castings. AIAG
The assessment is divided into three main sections, depending on the casting method:
If your XLS is unprotected, a user can accidentally delete a scoring formula, breaking the assessment. Lock all cells except data entry fields. Use password protect for the workbook structure.
Implement simple arithmetic formulas to calculate percentage compliance:
This section evaluates whether leadership supports the quality management system. The XLS sheet tracks items such as: Availability of dedicated quality personnel. Evidence of regular management reviews.
Always ensure you are using the most current version from the AIAG Store to avoid using outdated requirements. If you'd like, I can help further by:
The Automotive Industry Action Group (AIAG) publishes the CQI-27 Special Process: Casting System Assessment to provide a common approach to a casting management system for automotive production and service part organizations. Deploying this assessment via a structured spreadsheet (XLS) format allows organizations to efficiently evaluate their internal casting processes, drive continuous improvement, and ensure strict compliance with global OEM requirements. 1. What is the CQI-27 Assessment?
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.
Contains metadata such as facility name, assessment date, auditor names, overall compliance score, and a visual summary chart.
, it aims to eliminate common root causes of casting defects and minimize risks in automotive applications. The assessment is typically conducted via an Excel-based checklist that foundries must complete at least once a year. Https://Www.En-Standard.Eu Key Components of the Assessment
Helps foundries meet the "special process" requirements of their automotive customers.
