Many quality managers convert the AIAG CQI-27 manual into a customized XLS spreadsheet to streamline the auditing process. A well-designed Excel workbook improves data entry efficiency, automates score calculations, and provides clear visual tracking. Workbook Architecture
The CQI-27 Casting System Assessment is a widely used methodology for evaluating and improving the quality of castings in the automotive and aerospace industries. The assessment is based on a set of criteria that evaluate the casting process, from design and material selection to production and inspection. One of the key tools used in the CQI-27 assessment is the XLS (eXcel) format, which provides a structured and standardized way to collect and analyze data.
This is where the "XLS" format becomes vital. CQI-27 uses specific for different casting methods. Each table lists the "Process Parameters" (like melt temperature, cycle time, or chemistry control) and the "Job Audit" requirements. Key Requirements for Compliance
This tab establishes the administrative baseline for the audit. It should include: Organization name and location. Auditor names, titles, and contact information. Date of the assessment.
For every non-conformance identified in the Excel sheet, generate a corrective action plan using root-cause analysis tools (like the 5 Whys or Fishbone diagrams). cqi-27 casting system assessment xls
The CQI-27 Casting System Assessment is important for several reasons:
Storage conditions for scrap, gates, risers, and primary ingots. 4. Process Tables (The Technical Core)
: A summary section indicating compliance levels and highlighting areas for improvement. Process Tables
Implement simple arithmetic formulas to calculate percentage compliance: Many quality managers convert the AIAG CQI-27 manual
The assessment tool typically includes several worksheets (tabs) that guide the user through the audit process: Cover Sheet
Material traceability from raw ingots or scrap metal to finished castings.
The process tables are highly specific to the type of casting being performed. They list the specific process parameters, tolerances, and frequencies required for control. Examples of process tables in CQI-27 include: Sand Casting (Molding, core making, pouring) Table B: Centrifugal Casting Table C: Permanent Mold / Gravity Die Casting Table D: Low-Pressure Die Casting Table E: High-Pressure Die Casting Table F: Investment Casting Why Use an XLS Template for CQI-27?
for various materials and methods, including sand casting, centrifugal casting, and high-pressure die casting. Structure of the Assessment The assessment is based on a set of
Note: If you have a specific CQI-27 Excel file you need help interpreting, you can describe its layout (e.g., “My sheet has tabs for ‘Process Table A’ and a ‘Scoring Summary’) and I can provide tailored feedback.
Specific requirements for different types of casting processes (e.g., Die Casting, Gravity Casting, Investment Casting). Using the XLS file allows for:
The CQI-27 Excel file is structured into a series of interconnected sheets. A blank template typically contains the following core sections:
This section evaluates whether leadership actively supports the casting quality management system. Key checklist items verify if the facility: