Assessment Xls ((new)) — Cqi-27 Casting System

Mastering the CQI-27 Casting System Assessment: A Complete Guide to Using the Excel (XLS) Tool

Option 3: Build Your Own (Time-consuming)

You can create a basic cqi-27 casting system assessment xls using:

• Dropdown validation (Data > Data Validation)
• Conditional formatting (Home > Conditional Formatting) to color-code scores.
• SUMIFS formulas to calculate weighted averages.

Caution: Without a deep understanding of CQI-27 clauses, self-built sheets often miss critical requirements like “lift truck furnace charging safety interlocks.” cqi-27 casting system assessment xls

9. Sample Assessment Checklist (Condensed)

Use this as a quick reference during walk‑the‑line observations. Mastering the CQI-27 Casting System Assessment: A Complete

• Furnace and melt records current and complete
• Melt chemistry within spec and corrective actions recorded
• Pouring temperature recorded and controlled
• Mold/core dimensions verified against print
• Coreboards, coreboxes, and tooling maintenance records
• Sand properties tested and in control (green compressive, moisture, grain size)
• Heat treatment charts logged and calibrated thermocouples
• Inspection plans and acceptance criteria available at process
• NDT equipment calibrated and operators certified
• NCRs recorded, segregated parts identified
• Preventive maintenance executed per schedule
• Training matrix up to date and personnel competency recorded
• Environmental and safety controls active and documented

4.2 Misapplying Process Tables

If you are auditing a gravity permanent mold process but used Table A (Die Casting), your XLS will generate irrelevant questions, wasting time. Always match the table to the technology. Caution: Without a deep understanding of CQI-27 clauses,