The QI Macros Painless Excelbased Software for Lean Six Sigma, SPC

1
The QI Macros Painless Excel-based Software for
Lean Six Sigma, SPC Process Improvement by Jay
Arthur
2
Reducing Delay, Defects and Variation Requires
Statistical Tools
Order Defects
Release 1
2 Sigma
Release 2
Pats Per Million
3 Sigma
Aug
July
June
May
Apr
Mar
Oct
Sep
Nov
Date
3
You're in Charge of Reducing Costs and Boosting
Profits

Increase Profits
Reduce Costs

4
But Who Has The Time To Become A Statistician?
5
The Right Tools at the Right Price Can Accelerate
Improvement
Line Graph
Pareto
Countermeasures Matrix
Flowchart
Fishbone
6
Get the QI Macrosan Easy-to-Use Toolkit for
Performance Improvement
7
The QI Macros are Easy to Use.
8
The QI Macros Have Three Parts
Charts
Fill-in-the-Blanks Templates
Statistical Tools
9
20 Charts on the Pull Down Menu.
10
Step 1 Select Your Data
11
Step 2 Choose a Chart
12
Step 3 QI Macros Will Do the Math and Draw The
Graph!
13
Over 60 Fill-in-the-Blank Templates
14
Just Enter Your Data and Charts Grow
Automatically!
15
Fishbones and Flowcharts
16
Just Copy Paste Boxes Text
17
The QI Macros Templates Have Tools for MSA DFSS
Too!
Design of Experiments
Quality Function Deployment
MSA - Gage RR
18
Front Ends Excels Statistical Tools
19
Step 1 Select Your Data
20
Step 2 Choose a Statistical Tool
21
Step 3 QI Macros Will Do the Rest
22
You Dont Have to be a Statistician or Geek to
Use the QI Macros.
23
Even Front Line Workers Can Use The QI Macros
24
QI Macros Use Pull-down Menus to Get Charts,
Templates and Statistics
25
Choosing Control Charts is Hard
Defects
Attribute
People
(counted)
Events
Sample Size
Type of
1 time/project
Data
XmR Individuals
Individual
Time Length Weight Money
Variable (measured)
2-10 diameters, lengths
XbarR
Averages
11-25 diameters, lengths
XandS
26
The Macros Control Chart Wizard Will Choose the
Right Chart Automatically!
27
Wizard Chooses Based On Your Data
c Chart
XmR Chart
XbarR Chart
p Chart
28
The Macros Do All the Math Calculate UCL and
LCL
29
The Macros Draw the Chart with 1, 2, 3
sigma lines
30
The Macros Show Instability in Red
31
You Can Even Show Process Changes
32
And Stair Step Limits
33
You Can Do Capability Studies With The Histogram
Macros and Templates!
34
You Don't Have to Spend a Fortune To Get The
Tools You Need!
35
QI Macros are the Most Inexpensive SPC Software.
36
No Maintenance FeesPerpetual Use License
37
Optional Annual Upgrade
38
Optional Quarterly Update
39
139 for Single Copies
40
Quantity Discounts for 2
41
Enterprise Licenses for 299 Users
42
Train anyone in 5 minutes
43
Click-and-Drag To Select Your Data
44
Point-and-Click The Chart You Want
45
Fill-in-the-Blanks for the Front Line
46
Box and Whisker Chart
47
Dot Plot
48
Frequency Histogram
49
Histogram
50
Anom Chart
51
c Chart
52
Cusum Chart
53
EWMA Chart
54
Hotelling T2 Chart
55
Levey Jennings Control Chart
56
Moving Average Control Chart
57
Matrix Plot
58
Multivari Chart
59
np Control Chart
60
p Control Chart
61
Pareto Chart
62
Run Chart
63
Scatter Chart
64
u Control Chart
65
XmR (Individuals) Control Chart
66
XbarR Chart Chart
67
XbarS Control Chart
68
XmedianR Control Chart
69
Will You Have The Tools to Make Improvement
Successful?
70
Get the QI Macrosan easy-to-use toolkit for Lean
Six Sigma.
CD with 80 Free Lean Six Sigma ebooks
36 page User Guide
FREE Lessons on Line just email
qimacros_at_aweber.com
71
Start Improving Immediately With The QI Macros!
Profits Productivity
Delay
Defects
Variation
72
The QI Macros Affordable Tools for the
Statistically Challenged
KnowWare International Inc. dba LifeStar 2253 S
Oneida St Ste 3D Denver, CO 80224 303-756-9144
888-468-1537 www.qimacros.com lifestar_at_rmi.net
Testimonials http//www.qimacros.com/testimonials
.html