1 / 51

The QI Macros For Excel Lean Six Sigma SPC Software by Jay Arthur

The QI Macros For Excel Lean Six Sigma SPC Software by Jay Arthur. 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?

benard
Download Presentation

The QI Macros For Excel Lean Six Sigma SPC Software by Jay Arthur

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The QI Macros For ExcelLean Six Sigma SPCSoftware by Jay Arthur

  2. 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?

  3. How Manually Home grown Excel files Complex Software Issue Slow Inaccurate Too busy charting to improve Hard to Use Are You Doing Charts Like Most People? Impact Mistakes Rework Waste Higher Costs Wrong Problem Solved Bad Decisions

  4. How many days per month do you spend drawing charts? What is your daily wage? Cost per month 25% Savings 50% Savings 75% Savings What does it cost? Example 10 $100 $1,000 $250 $500 $750 ____ Days $____/Day $_____ $_____ $_____ $_____

  5. 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 What Problems Aren’t You Solving? Example 2 Projects $25,000 $50,000 $12,500 $25,000 $37,500 __ Projects $______/Project $______ $______ $______ $______

  6. These Costs Have Nothing to Do With: • Competence • Intelligence • Attention to Detail • Skill • Statistical Knowledge • Computer Savvy (But everything to do with your tools!)

  7. 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

  8. Action The Right Tools at the Right Price Can Accelerate Improvement Line Graph Pareto Countermeasures Matrix Flowchart Fishbone

  9. The QI Macros are Easy to Use.

  10. QI Macros Use Pull-down Menus to Get Charts, Templates and Statistics

  11. The QI Macros Have Four Parts Charts Fill-in-the-Blanks Templates Statistical Tools Data Transformation Tools

  12. Three Main Kinds of Charts Line (Time Series) Bar (Categories) Dot (Various)

  13. 30+ Charts on the Pull Down Menu

  14. Step 1: Click-and-Drag To Select Your Data

  15. Step 2: Point and Click to Choose a Chart

  16. Step 3: QI Macros Will Do the Math and Draw The Graph!

  17. Struggling with Choosing Control Charts? 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

  18. The Macros Control Chart Wizard Will Choose the Right Chart Automatically!

  19. Wizard Chooses Based On Your Data c Chart XmR Chart XbarR Chart p Chart

  20. The Macros Do All the Math Calculate UCL and LCL

  21. The Macros Draw the Chart with 1, 2, & 3 sigma lines

  22. The Macros Show Instability in Red

  23. You Can Even Show Process Changes

  24. And Stair Step Limits

  25. You Can Do Capability Studies With The Histogram Macros and Templates!

  26. Over 90 Fill-in-the-Blank Templates

  27. Just Enter Your Data and Charts Grow Automatically! Input fields are ivory in color

  28. Fishbones and Flowcharts

  29. Just Copy & Paste Boxes & Text

  30. The QI Macros Templates Have Tools for MSA & DFSS Too! Design of Experiments Quality Function Deployment MSA - Gage R&R

  31. Simplifies Excel’s Statistical Tools

  32. Step 1: Select Your Data

  33. Step 2: Choose a Statistical Tool

  34. Step 3: QI Macros Will Do the Rest

  35. You Don’t Have to be a Statistician or Geek to Use the QI Macros.

  36. Even Front Line Workers Can Use The QI Macros

  37. Transform and Analyze Your Data

  38. PivotTable Wizard Analyzes Data

  39. You Don't Have to Spend a Fortune To Get The Tools You Need! The QI Macros are only $199 per license

  40. 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.

  41. Perpetual Use License

  42. 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

  43. Optional Annual Upgrade

  44. Optional Quarterly Update

  45. $199 for Single Copies

  46. QI Macros Discounted Price 2 - 9 $179 10 - 49 $159 50 - 99 $149 100+ $139 Quantity Discounts for 2+

  47. Train anyone in minutes

  48. Will You Have The Tools to Make Improvement Successful?

  49. Start Improving Immediately With The QI Macros! Profits & Productivity Delay Defects Deviation

  50. 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

More Related