The QI Macros For Excel Lean Six Sigma

The QI Macros For Excel Lean Six Sigma SPC Software by Jay Arthur © MMIX Know. Ware 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 Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Are You Doing Charts Like Most People? How Issue Manually Slow Home grown Inaccurate Excel files Too busy charting to improve Complex Software © MMIX Know. Ware International Inc. Impact Mistakes Rework Waste Higher Costs Wrong Problem Solved Hard to Use Bad Decisions www. qimacros. com 888 -468 -1537

What does it cost? Example ____ Days 10 How many days per month do you spend drawing charts? What is your daily wage? $____/Day Cost per month $_____ 25% Savings 50% Savings 75% Savings © MMIX Know. Ware International Inc. $_____ www. qimacros. com $100 $1, 000 $250 $500 $750 888 -468 -1537

What Problems Aren’t You Solving? How many improvement 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 © MMIX Know. Ware International Inc. __ Projects Example 2 Projects $______/Project $______ $25, 000 $50, 000 $12, 500 $25, 000 $37, 500 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 Know. Ware 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 - Perform. Tech 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 Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The Right Tools at the Right Price Can Accelerate Improvement Line Graph Pareto Action Fishbone © MMIX Know. Ware International Inc. Countermeasures Matrix www. qimacros. com Flowchart 888 -468 -1537

The QI Macros are Easy to Use. © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

QI Macros Use Pull-down Menus to Get Charts, Templates and Statistics © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The QI Macros Have Four Parts Charts Statistical Tools © MMIX Know. Ware International Inc. Fill-in-the-Blanks Templates Data Transformation Tools www. qimacros. com 888 -468 -1537

Three Main Kinds of Charts Line (Time Series) © MMIX Know. Ware International Inc. Bar (Categories) www. qimacros. com Dot (Various) 888 -468 -1537

30+ Charts on the Pull Down Menu © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Step 1: Click-and-Drag To Select Your Data © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Step 2: Point and Click to Choose a Chart © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Step 3: QI Macros Will Do the Math and Draw The Graph! © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Struggling with Choosing Control Charts? Attribute (counted) Type of Data Time Length Variable Weight (measured) Money © MMIX Know. Ware International Inc. Defects People Events Individual Sample Size Xm. R Individuals Xbar. R 2 -10 diameters, lengths Xand. S 11 -25 diameters, lengths Averages www. qimacros. com 1 time/project 888 -468 -1537

The Macros Control Chart Wizard Will Choose the Right Chart Automatically! © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Wizard Chooses Based On Your Data c Chart Xm. R Chart Xbar. R Chart p Chart © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The Macros Do All the Math Calculate UCL and LCL © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The Macros Draw the Chart with 1, 2, & 3 sigma lines © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The Macros Show Instability in Red © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

You Can Even Show Process Changes © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

And Stair Step Limits © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

You Can Do Capability Studies With The Histogram Macros and Templates! © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Over 90 Fill-in-the-Blank Templates © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Just Enter Your Data and Charts Grow Automatically! Input fields are ivory in color © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Fishbones and Flowcharts © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Just Copy & Paste Boxes & Text © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The QI Macros Templates Have Tools for MSA & DFSS Too! Design of Experiments Quality Function Deployment MSA - Gage R&R © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Simplifies Excel’s Statistical Tools © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Step 1: Select Your Data © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Step 2: Choose a Statistical Tool © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Step 3: QI Macros Will Do the Rest © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

You Don’t Have to be a Statistician or Geek to Use the QI Macros. © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Even Front Line Workers Can Use The QI Macros © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Transform and Analyze Your Data © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Pivot. Table Wizard Analyzes Data © MMIX Know. Ware 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 $199 per license © MMIX Know. Ware 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 Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Perpetual Use License © MMIX Know. Ware 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/network. html © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Optional Annual Upgrade © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Optional Quarterly Update © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

$199 for Single Copies © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Quantity Discounts for 2+ QI Macros 2 -9 10 -49 50 -99 100+ Discounted Price $179 $159 $149 $139 © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Train anyone in minutes © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Will You Have The Tools to Make Improvement Successful? © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

Start Improving Immediately With The QI Macros! Profits & Productivity Delay Defects © MMIX Know. Ware International Inc. Deviation www. qimacros. com 888 -468 -1537

Get the QI Macros—an 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@aweber. com © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537

The QI Macros – Affordable Tools for the Statistically Challenged Know. Ware International Inc. dba Life. Star 2253 S Oneida St Ste 3 D Denver, CO 80224 303 -756 -9144 888 -468 -1537 www. qimacros. com lifestar@qimacros. com Testimonials: http: //www. qimacros. com/testimonials. html © MMIX Know. Ware International Inc. www. qimacros. com 888 -468 -1537