A compliant and highly functional CQI-27 XLS workbook contains several dedicated tabs. Each tab serves a specific purpose in the assessment lifecycle. 1. Cover Sheet & General Information
designed to provide common process requirements for foundry suppliers of automotive castings. The assessment is typically completed using a downloadable Excel file that serves as the reporting tool for the audit. Core Structure of the Assessment
The "Control Plan" sheet was where the spreadsheet showed teeth. For each process step it listed critical characteristics, control methods, measurement frequency, acceptable ranges, and immediate containment actions. For "Pouring Temperature" the spec read 1250±10°C, with a real-time thermocouple and an automated alarm tied to the furnace PLC. A separate column recorded the calibration cycle and the last calibration date. A red flag in the sheet highlighted a calibration overdue by two days—small, fixable, and worth calling maintenance on now.
If you supply cast parts—whether aluminum, magnesium, iron, or steel—to major OEMs (Original Equipment Manufacturers) like Ford, GM, or Stellantis, CQI-27 compliance is typically a mandatory contractual requirement. Why Use an XLS (Excel) Format for CQI-27?
In this article, we will provide an overview of the CQI-27 Casting System Assessment, its importance in ensuring casting quality, and a step-by-step guide on how to use the XLS format to conduct an assessment. We will also discuss the benefits of using the CQI-27 assessment and XLS format, as well as common challenges and best practices for implementation.
Auditors can easily take Excel sheets onto the shop floor using tablets or laptops.
Whether you want help building for scoring.
Captures high-level information about the foundry being assessed, including facility details, assessment dates, and final scoring results.