Control Plan Template in Excel
Compatible with AIAG Standards, Excel 2010-2019 and Office 365
Purpose of a control plan: To aid the manufacturing of quality products by using a structured approach to identify and implement value-added controls to minimize process and product variation.
QI Macros Add-in for Excel includes these Control Plan Templates
QI Macros SPC add-in for Excel also includes:
- APQP Checklists
- PPAP Forms
- MSA Gage R&R Templates
- Macros to draw control charts, histograms, paretos, fishbones and more with the click of a button
How to Create a Control Plan
- QI Macros adds a new menu to Excel's toolbar. Click on the QI Macros menu then the DOE, Gage RR, FMEA sub-menu and then Control Plan.
- The template will open with a tab for each of the three options shown above.
- Input production control plan, and other high level information in the top sections of the template.
- For all the steps in the manufacturing process that are relevant to the control of the product quality, identify:
- Processing equipment as precisely as possible (e.g., machine, device, jig, machine make, machine model number, asset #, etc.)
- Characteristic reference number, starting with 1. If process flow diagrams or FMEA’s are available, cross reference number in this column
- Special Product Characteristics
- Process Characteristics that have a cause and effect relationship with the Product Characteristic
- Measurement system: gages, fixtures, tools, and/or test equipment required to measure the part or process
- Sample size and frequency
- Control method: statistical process control, inspection, sampling
- Reaction plan to avoid producing nonconforming product
For more detailed instructions, see the Advanced Product Quality Planning and Control Plan manual published by the AIAG.
Control Plan - How to Video
Why Choose QI Macros Over Other SPC Software?
- Only $299 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free