To maximize utility, a CQI-27 XLS file must eliminate manual math. The standard requires questions to be graded as "Compliant," "Non-Compliant," or "Not Applicable."
A tracker to document any "Not Satisfactory" findings and the steps taken to resolve them. Best Practices for Using an XLS Template
A non-compliant finding is useless without a close-loop corrective action. This sheet should include: cqi-27 casting system assessment xls
All assessors and foundries use the same format.
Basic information about the facility, assessment date, and overall score. To maximize utility, a CQI-27 XLS file must
A standard CQI-27 XLS workbook is generally divided into several critical sections: 1. Management Responsibility & Quality Planning
Why not a web app, a paper form, or a PDF? Because Excel offers unique advantages for this specific assessment: This sheet should include: All assessors and foundries
Ultimate Guide to AIAG CQI-27: Implementing the Casting System Assessment
A good CSA XLS uses data validation to prevent errors. For example:
Controls for chemical composition, temperature, and pouring.
Chemical composition analysis frequencies (e.g., spectrometer testing). Degassing and molten metal treatment times. Die temperature layouts and cooling water flow rates. 6. Job Audit Template