© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The QI Macros For Excel Lean Six Sigma
SPC Software
by Jay Arthur
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
People Evaluating SPC Software often ask:
Why does it feel like I need to be a statistician to use SPC Software? Why does it take 5 days to learn complex, expensive statistical software? Why can’t the software help me choose the right chart? Why do I have to import data into the software?
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Are You Doing Charts Like Most People?
How
Manually Home grown Excel files Complex Software
Issue
Slow Inaccurate Too busy charting to improve
Hard to Use
Impact
Mistakes Rework Waste Higher Costs Wrong Problem Solved Bad Decisions
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
What does it cost?
How many days per month do you spend drawing charts?
What is your daily wage? Cost per month
25% Savings 50% Savings 75% Savings
____ Days $____/Day $_____ $_____ $_____ $_____
Example 10 $100 $1,000 $250 $500 $750
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
What Problems Aren’t You Solving?
How many improve-ment projects don’t get
done because you’re too busy charting?
What is the value of
each project? Total Project Loss
25% Savings 50% Savings 75% Savings
__ Projects $______/Project $______ $______ $______ $______
Example 2 Projects $25,000 $50,000 $12,500 $25,000 $37,500
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
These Costs Have Nothing to Do With:
Competence Intelligence Attention to Detail Skill Statistical Knowledge Computer Savvy
(But everything to do with your tools!)
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
What Can the QI Macros Save You? The QI Macros save our clients an estimated 75% of their documentation time and cost. Joe Farina - PerformTech I find the QI Macros a real time saver, allowing me to focus more on the problems than on reporting them. Frank Duke, Sagem I just recently purchased QI Macros and I think it's fantastic! It has saved me a great deal of time in preparing monthly reports. Marc Robinson, Emergency Medical Associates I've been using your QI Macros since 1997 and they have saved me tremendous amounts of time. Mark E. Anderson, Business Analyst, Fairview Lakes Regional Health Care
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The Right Tools at the Right Price Can Accelerate Improvement
Action
Countermeasures
Matrix Fishbone
Pareto
Flowchart
Line Graph
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The QI Macros are Easy to Use.
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
QI Macros Use Pull-down Menus to Get Charts, Templates and Statistics
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The QI Macros Have Four Parts
Charts
Statistical Tools
Fill-in-the-Blanks Templates
Data Transformation Tools
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Three Main Kinds of Charts
Bar
(Categories)
Line
(Time Series) Dot
(Various)
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
30+ Charts on the Pull Down Menu
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Step 1: Click-and-Drag To Select Your Data
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Step 2: Point and Click to Choose a Chart
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Step 3: QI Macros Will Do the Math and Draw The Graph!
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Struggling with Choosing Control Charts?
Attribute
(counted)
Defects People Events
Type of Data
Variable (measured)
XmR Individuals
XbarR
XandS
Sample Size
1
time/project
2-10
diameters, lengths
11-25
diameters, lengths
Time
Length
Weight
Money Averages
Individual
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The Macros Control Chart Wizard Will Choose the Right Chart Automatically!
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Wizard Chooses Based On Your Data
c Chart XmR Chart
XbarR Chart p Chart
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The Macros Do All the Math Calculate UCL and LCL
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The Macros Draw the Chart with 1, 2, & 3 sigma lines
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The Macros Show Instability in Red
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
You Can Even Show Process Changes
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
And Stair Step Limits
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
You Can Do Capability Studies With The Histogram Macros and Templates!
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Over 90 Fill-in-the-Blank Templates
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Just Enter Your Data and Charts Grow Automatically!
Input fields are ivory in color
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Fishbones and Flowcharts
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Just Copy & Paste Boxes & Text
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The QI Macros Templates Have Tools for MSA & DFSS Too!
Quality Function Deployment
Design of Experiments
MSA - Gage R&R
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Simplifies Excel’s Statistical Tools
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Step 1: Select Your Data
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Step 2: Choose a Statistical Tool
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Step 3: QI Macros Will Do the Rest
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
You Don’t Have to be a Statistician or Geek to Use the QI Macros.
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Even Front Line Workers Can Use The QI Macros
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Transform and Analyze Your Data
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
PivotTable Wizard Analyzes Data
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
You Don't Have to Spend a Fortune To Get The Tools You Need!
The QI Macros
are only $229
per license
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
QI Macros Licensing
One License Per Computer
It’s okay to put the QI Macros on your home, office and laptop computer (we consider you to be one user),
just not your neighbor’s computer.
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Perpetual Use License
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Network Installation (Citrix)
Buy one license per user. Load the QI Macros into a folder on the server. Have individual users point Excel to an Alternate Startup folder. qimacros.com/support/network/
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Optional Annual Upgrade
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Optional Quarterly Update
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Quantity Discounts for 2+
QI Macros Discounted Price 2 - 9 $199
10 - 49 $179 50 - 99 $159 100+ $149
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Train anyone in minutes
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Will You Have The Tools to Make Improvement Successful?
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Start Improving Immediately With The QI Macros!
Delay Defects Deviation
Profits &
Productivity
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
Get the QI Macros—an easy-to-use toolkit for Lean Six Sigma.
36 page User Guide CD with Free Lean Six Sigma ebooks
FREE Lessons on Line just email [email protected]
© MMIX KnowWare International Inc. www.qimacros.com 888-468-1537
The QI Macros – Affordable Tools for the Statistically Challenged
KnowWare International Inc. dba LifeStar
303-756-9144 888-468-1537
www.qimacros.com
Testimonials: www.qimacros.com/clients-and-testimonials/