Cqi27 Casting System Assessment Xls Upd [updated] 〈TRENDING × RELEASE〉

Mastering CQI-27: Building an Updatable Excel Casting System Assessment Tool

Step 2 – Customize Drop-Down Lists

Use Excel Data Validation for:

3. The Update ("upd") – What’s New in 2024/2025?

AIAG released a silent but significant revision to the CQI-27 workbook. If you are using an old XLS file, you are likely missing these critical changes:

| Old Feature (Pre-2023) | New Update (cqi27 xls upd) | |------------------------|-----------------------------| | Manual calculation of section scores | Automated dynamic dashboard with pivots | | No validation for temperature logs | Mandatory real-time data entry with timestamp validation | | Single-level nonconformance reporting | Two-level: Minor vs. Major NCs with escalation rules | | No integration with IATF 16949 clauses | Cross-reference column linking each line to IATF clause number | | Basic risk scoring | Added FMEA (Failure Mode Effects Analysis) module for casting defects (porosity, cold shut, misrun) |

What is CQI-27 (brief)

CQI-27 is a standardized assessment that evaluates the robustness of casting processes and related controls — including melting, pouring, mold handling, heat treatment, machining, inspection, and transport — to ensure consistent part quality and reduced risk of defects. It documents process capability, preventive controls, training, and traceability across the casting workflow. cqi27 casting system assessment xls upd

Step 2: Scoring Tabs

The updated file contains 10 primary tabs. The most important are:

Step 4 – Lock Cells for Version Control

Protect sections containing formulas and historical scores. Use Review → Protect Sheet to prevent accidental overwrites.

1. Dynamic Dashboard

A summary sheet that automatically visualizes overall compliance percentage, section-by-section heat maps, and a red-yellow-green status indicator. Mastering CQI-27: Building an Updatable Excel Casting System

What is the CQI-27 Casting System Assessment?

CQI-27 is part of AIAG’s Special Process Series, which includes other critical standards like CQI-9 (Heat Treat), CQI-11 (Plating), and CQI-12 (Coating). It focuses exclusively on casting processes, covering:

The assessment is divided into three primary sections:

  1. Section 1 – Management Responsibility & Quality System Nonconformance ID Root cause (5 Whys

    • Equipment maintenance, training, and corrective action plans.
    • Verification of calibration records for furnaces and spectrometers.

  2. Section 2 – Process Control & Material Handling

    • Raw material verification (charge materials, alloys, fluxes).
    • Melt deck practices (degassing, temperature monitoring, chemistry checks).

  3. Section 3 – Specific Casting Process Control

    • Tooling maintenance, shot parameters (for die casters), mold coating, and core making.

Each section contains a series of questions. Suppliers are rated with a traffic light system: Green (Conforming), Yellow (Conforming with minor issues), Red (Non-Conforming). A red rating in a critical process stop often triggers an immediate corrective action.

Sheet 8 – Corrective Action Log