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:


How to Create a Control Plan

  1. 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.
    control plan on QI Macros menu
  2. The template will open with a tab for each of the three options shown above.
  3. Input production control plan, and other high level information in the top sections of the template.
  4. 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
    • Specifications/tolerances
    • 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?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free