Many OEMs (Ford, GM, Stellantis) provide their own modified CQI-27 Excel sheets. Use these only for that customer’s audits, not as your master system.
A robust XLS tool will allow you to:
If you’d like, I can:
CQI-27 Special Process: Casting System Assessment (CSA) is a standard developed by the Automotive Industry Action Group (AIAG)
to ensure robust casting processes in the automotive supply chain. The assessment is typically managed via an Excel-based (.xls) tool
designed for foundries to conduct annual self-assessments or for OEMs to audit their suppliers. Key Features of the CQI-27 XLS Tool
The 2nd Edition (released in 2018) includes several enhancements for better usability and process coverage: Unlocked Sheets
: Unused columns, rows, and sheets are not protected, allowing users to perform standard Excel editing for internal reporting. Consolidated Requirements cqi-27 casting system assessment xls
: Similar requirements across different casting types have been merged to reduce redundancy. Comprehensive Coverage : Includes specific Process Tables (A through J)
for various materials and methods, including sand casting, centrifugal casting, and high-pressure die casting. Structure of the Assessment
The CQI-27 XLS is generally organized into these core sections: Cover Sheet
: Captures basic data about the casting organization, audited areas, and contact information for auditors and participants. Assessment Results
: A summary section indicating compliance levels and highlighting areas for improvement. Process Tables
: The heart of the document, containing detailed requirements for specific processes: : Sand Castings (Iron/Steel) : Investment Castings (Iron/Steel) : Aluminum High Pressure Die Cast : Magnesium High Pressure Die Cast Critical Audit Elements
The assessment focuses on common failure modes that lead to non-conforming castings. Key areas evaluated in the spreadsheet include: CQI-27 Casting System Assessment - TopQM-Systems Many OEMs (Ford, GM, Stellantis) provide their own
CQI-27 Special Process: Casting System Assessment (2nd Edition)
is a standardized framework used by the automotive industry to evaluate and improve casting processes. Released in March 2018 Automotive Industry Action Group (AIAG)
, 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
The CQI-27 assessment is structured into several sections and "Process Tables" that cover specific casting methods: Management Responsibility & Quality Planning
: Focuses on management support and the integration of quality standards like IATF 16949
: Verifies that specific parts are produced according to the established control plans and customer requirements. Process Tables
: Detailed checklists for various casting technologies, including: : Sand Casting (Iron/Steel) : Investment Casting (Iron/Steel) : Aluminium High-Pressure Die Casting : Zinc High-Pressure Die Casting Critical Audit Areas CQI-27 | Special Process: Casting System Assessment - AIAG If you’d like, I can:
The CQI-27 Special Process: Casting System Assessment provides requirements for foundry suppliers of OEM automotive castings.
2nd Edition CQI-27: Casting System Assessment is Now Available 28 Mar 2018 —
It sounds like you're referring to a CQI-27 Casting System Assessment spreadsheet (Excel) — part of the AIAG’s CQI-27 Special Process: Casting standard.
A valuable feature to add or request in such an Excel tool is:
A single XLS workbook can have tabs for:
You have three options:
You can create a basic cqi-27 casting system assessment xls using:
Caution: Without a deep understanding of CQI-27 clauses, self-built sheets often miss critical requirements like “lift truck furnace charging safety interlocks.”