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

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 

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

In addition to the charts listed on the pull down menu, the QI Macros contain over 90+ fill-in-the-blank templates.

To access these templates select Fill-in-the-Blanks Templates on the QI Macros pull down menu. Watch Template Overview Video

Excel 2003 and previous versions
Excel 2007-2010
QI Macros for Excel templates menu
QI Macros templates menu Excel 2007

Each template is designed for fill-in-the-blanks ease of use. Tools like the flow chart and fishbone diagram make use of Excel's drawing toolbar. To view Excel's Drawing Toolbar select View/Toolbars and click to the left of the word "Drawing."

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.

  control chart template

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.

select-points-to-chart

c chart-template

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

x chart template

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

Design For Six Sigma Templates

AIAG PPAP, Gage R&R and More

The QI Macros also contain many of the tools used by the AIAG. These tools are updated each time a new AIAG edition is published. Each template contains several different worksheets. Tools include:

Templates for Your Quality improvement Efforts

Complete list of fill-in-the-blank-templates with links to more information.

If you need more help understanding how to use these tools, consider the QI Macros Training CD or QI Macros Tools Example book.

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

QI Macros - One License Per Computer - Download with backup CD & User Guide (#230) $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199


If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.
 

Try QI Macros
FREE
For 30-Days


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 
home | products | services | search | sitemap | view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training