QI Macros Lesson 3 Fill-in-the-Blank-Templates

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

In this Issue

• Fill-in-the-Blanks Templates
• Templates for Charts
• Design for Six Sigma - QFD, DOE, FMEA, EMEA
• AIAG PPAP, Gage R&R and More
• Templates for Your Quality Improvement Efforts

  Fill-in-the-Blanks Templates

Excel 2003 and previous versions	Excel 2007-2010

Fill-in-the-Blank Templates for Charts

The QI Macros contain templates for control charts, histograms, Cp and Cpk, probability plots, box and whisker, cusum, scatter and pareto charts. Just cut and paste or input data directly into the yellow shaded area. The charts will populate as data is input.

Control Chart Templates - contain different templates for control charts with rolling data, median charts, short run charts and charts with horizontal data. When you open a control chart template, look for these options within the various worksheets of each template.

Control Chart menu features on templates - include add data to chart, add text to point, ghost point and analyze stability. To access these features, click on a control chart. You should see dark boxes at the corners to indicate the chart is selected, then click on the item in the QI Macros pull down menu.

Delete point and show process change work differently on templates than on charts created with macros. Click on each item for more information.

Choosing which points to plot - Each template defaults to 50 data points. If you have fewer than 50 points and only want to show the points with data, click on the arrow in cell B1. This will bring up a pull down menu. Select "non-blanks" to plot only the points with data.





X chart templates contain a histogram and probability plot of your data.



Input the spec limits in the yellow shaded area between the control charts and histogram.

Design For Six Sigma Templates

• QFD House of Quality
• Design of Experiments (DOE)
• Failure Modes and Effects Analysis (FMEA)

AIAG PPAP, Gage R&R and More

• PPAP Forms
• Control Plans
• Gage R&R - for more information on Gage R&R see our Gage R&R Whitepaper or Watch a Gage RR Video

Templates for Your Quality improvement Efforts

• Focus your improvement efforts using the Balanced Scorecard, Voice of the Customer Matrix or Cost of Quality template.
• Analyze and Improve using the Ishikawa or Fishbone Diagram, Countermeasures Matrix.
• Reduce delay using the Flowchart, Value Added Flow Analysis, Value Stream Map and Takt Time templates.
• Project management and planning - Gantt Chart, ROI Calculator and Project Management tools like the Earned Value Managment Formulas.

In Lesson #4 we will cover Anova and Other Statistical Tools.

View previous lesson .............View next lesson

To sign up for this series tell your friends to send an email to qimacros@aweber.com

Try QI Macros
FREE
For 30-Days

Or Buy It Now!