Upgrade to QI Macros 2011

QI Macros Version #

Description of Enhancements

New:

• Type 1 Gage R&R
• Funnel Plot template
• Added residuals and probability calculations to regression analysis.
  

New:

• Add Target Line, Spec Limits etc to Chart using the QI Macros chart menu
• Ability to refresh stability analysis after adding new data to control chart dashboards
  

New:

• Delta Chart Template
• Various performance enhancements
  

New:

• Westgard Rules added to Control Chart Rules for Levey Jennings Charts.
  

New:

• Skyline limits added to XbarR and XbarS charts.
  

New:

• Values Plot to analyze variation of individual points.
• Added ability to toggle between showing and hiding sigma lines on a control chart using the QI Macros chart menu
  

New:

• Chart Wizard that automatically decides what charts to run based on the data selected.
  

New:

• XmR Dashboard - added Precontrol Charts
• XbarR Dashboard with Precontrol Charts (new)
  

New:

• Lean Six Sigma "Money Belt" Training
  

Upgrade:

• Support for Macintosh 2011
• Support for Microsoft "Click to Run" installations of Excel 2010
• Pareto Chart will pivot a column of text, dates or numbers and draw a pareto chart of the result.
• Levey Jennings 10-20-30% control chart.
  

Enhancements:

• Statistics Wizard
  Automatically runs appropriate statistics: ANOVA, F test, t test, Levene's test, Chi-Squared and regression based on the data selected.
  

Enhancements:

• Stem and Leaf Plot template

Enhancements:

• Mind Mapping template

Enhancements:

• 8D Report template
• M Chart template
• Yamazumi Chart template

Enhancements:

• MSA 4th Edition

Enhancements:

• Enhanced QI Macros to work with Excel 2010 in 32-bit and 64-bit versions
• Enhanced Pareto to produce multiple charts from multiple columns of data and produce two or more paretos for comparison.

Enhancements:

• Enhanced Pareto chart to show up to three colors on top three main "bars" if pareto pattern exists.

Enhancements:

• Rewrote Anova and Analysis tools to be independent of Excel's Data analysis Toolpak. This should prevent translation conflicts with International Versions of Excel.
• Many Anova and statistical tests like the t tests now interpret the results for you by indicating whether you should accept or reject the null hypothesis.
• Added instructions sheet to control chart templates.

Enhancements:

• I-MR-R Chart (hybrid XbarR and XmR chart that shows within subgroup (R) and between subgroup (MR) variation.
• Cause Effect Matrix Template

Enhancements:

• Box and Whisker shows all outlier points

Enhancements:

• Histogram
  • Added ability to run charts on time formatted data
  • Added Cr and Skewness to metrics
• Added new p prime chart and u prime chart templates per request from healthcare community
• Data Transformation Tools
  • Added ability to turn quick keys off and on
  • Added ability to show or hide calculation sheets when running macro

Compatibility with Excel 2007 SP2

Improvements to prevent conflicts with other addins.

New and Enhanced Macros

• Automated Control Chart Dashboards for c, p, u, np and XmR charts
• USL/LSL added to XmR Dashboard
• Excel Charts: Bar and Column Charts
• XmR with Median R instead of Average R
• BoxWhisker chart - When only one value, no dot plotted that's visible (except at 400% magnification). Changed code to use Low outlier point to mark the single point
• Added subgroup size prompt to histogram and frequency histogram macro.
• Upgraded XmR, XbarR, XbarS, XMedianR to put both the X and R charts on the data sheet.
• Added new Healthcare rules to control chart rule options per request of IHI faculty
• Changed Stability Analysis to show out of control points as a diamond so that they will look different on black and white printers.
• Right-Click (shortcut) Chart Menu added

New and Enhanced Templates

• Breyfogle's 30,000 foot level control chart for Integrated Enterprise Excellence (IEE).
• Levey Jennings Template update to use 10-20-30% limits.
• Rolled Throughput Yield Calculator
• Rolling c, np, p, u, XmR, XbarR templates
• Tornado (Paired Bar) Chart
• Toyota's A3 Report for Problem Solving.

Anova and Analysis Tools

• Added Tukey Quick Test to Nonparametric tests
• Levene's Test for Variation of normal and non-normal data

Data Transformation Tools

• Unstack Matrix function

New and Enhanced Macros:

• Analysis of Means (ANOM) Chart
• Box Whisker chart - allows negative values now
• Control chart wizard - comma/decimal fix for International versions of Excel
• Macros - chart sheet name is automatically populated to match the chart title
• Multivari chart - Enhanced macro to do "multivariate" analysis of multiple columns of labels and create multivari and stdev charts
• p chart and u chart new format options (skyline vs wavy)

New Control Chart Menu Options

• Ghost Point - Remove point from calculations but keep it on the chart
• Add text Box to Point
• Show Process Change - allows more than one change per chart.

New and Enhanced Templates

• APQP 2nd edition updates of control plan, check list and checksheet
• DPMO Six Sigma Calculator Template
• FMEA 4th Edition - added new templates and checklists
• FMEA Template - Added Machinery FMEAs per SAE J1739
• PPAP - added input sheet for data common to all forms such as part name, part number etc.
• Project Management Tools: added
  • Earned Value Management Formulas Template
  • Work Breakdown Structure Template
• t chart (Time Between Rare Events) template
• Tornado chart template

Anova and Analysis Tools

• Descriptive Statistics: added box plot and confidence limits
• Proportions Hypothesis Testing
  • Test of a Proportion
  • Test of Two Proportions
• Regression Analysis - Added multiple regression analysis. First columns are X, last column is Y.

Data Transformation Tools

• Unstack by label and subgroup

Pull down menu and error messages translated to various foreign languages.

Help files and user guide translated to various foreign languages.

Compatibility with Excel 2007

• Completely rewritten in VBA to support Excel 97-2007 including the new "ribbon" interface.
• Added Option of Choosing Between a Classic 2003 menu for Excel 2007 - to ease the transition to the new ribbon
• Install file now identifies multiple versions of Excel on your PC and asks which version you want to load the QI Macros on.

New and Enhanced Macros

• Cusum enhancements - added Upper and Lower Cusum lines
• Dot Plot
• EWMA Chart Macro
• Histogram Macro:
  • added Sigma calculation
  • added back # of bars prompt
• Levey Jennings Chart Macro
• Moving Average Chart
• Multivariate Analysis
  • Hotelling T2 Chart Macro
  • Scatter Plot Matrix
• p chart - capped the sigma lines and UCL to 100%. This function was requested by healthcare customers tracking JCAHO measures.
• Run Chart - added choice between average or median
• XmedianR chart
• Enhanced all variable charts - to enable charts to handle cells with blank data
• Hidden Rows and Columns - in the data selection were used in chart macros in previous versions. This change enables them to be omitted from the chart.

New Control Chart Menu Options

• Ability to select stability rules from standard rule sets (Montgomery, Juran, AIAG, Western Electric)
• Ability to show/hide 1-2 Sigma LInes

New and Enhanced Templates

• Cp Cpk template - with one sided spec limits
• Cusum Template
• Failure Prevention Analysis (FPA) template
• g chart template
• Gage R&R Template - added NDC (Number of Distinct categories) and Anova R&R using spec tolerance
• Moving Average Template
• Probability Plot template - added Half Normal Probability Plot
• Value Stream Template - added symbols page

New Data Transformation Tools

• Data Transformation - Word Count
• Data Transformation - CrossTab PivotTable Wizard
• Box Cox, Restack, Get Sample, Paste Link Transpose

New Anova and Analysis Tools

• Data Normality Test

QI Macros Help file - descriptions and instructions for using each tool

Created uninstall.exe file to more easily uninstall the software or 30 day evaluation copy

Corrected bug in box and whisker formula (QI Macros 2007 version only).

Corrected run time error when some International versions closed Excel.

Performance Enhancements

• Efficiency Upgrade to QI Macros to speed up starting Excel. Reduced number of macro files from 19 to 1.
• Performance enhancement - consolidated stability analysis code for all control charts.
• Performance enhancement - speed up XmR chart macro.
• Added Version Information

Enhancements to Macros:

• Upgraded Control Chart Wizard to work with split columns of data.
• Histogram enhancements:
  • Allow more than 50 classes
  • Enhanced # of bars calculation in Histogram.
  • Removed rounding from histograms
• Fixed comma-decimal point problem for international users in Germany and Poland.
• Added LinkTranspose Macro to allow paste-link and transposition of data. Excel won't do this.

Anova and Analysis Tools:

Fixed chi-square test calculation.

New Templates:

• Scatter Plot Template
• Youden Plot Template
• Value Stream Mapping Template

Enhancements to Existing Templates:

• Added links to training documentation on website for all templates.
• Update PPAP Forms to 4th Edition and 4th edition errorata sheet published by AIAG.
• Update FMEA template to 4th Edition
• Gage R&R deleted acceptability % in cell C44 since it is no longer needed.
• Enhanced Balanced Scorecard Template

Converted to Windows 32-bit installer to prevent installation problems in Windows XP.

New Control Chart Wizard
Just select your data, click on the Control Chart Wizard and it will analyze your data and choose the best control chart for you.

Enhancements to Macros
Added sigma estimator (SIGMAave/c4) for subgroup sizes > 10 to:

• Histogram macro
• Frequency histogram
• XbarS template

New Templates

• Added XMedianR chart to the macros.
• Added ROC Curve Templates
• Added Time Tracking Template
• Upgraded p and u charts for AIAG SPC 2nd

Enhancements to Templates

• GageR&R - added Analytic Attribute Method
• Maintenance enhancements to Histogram and Frequency Histogram to allow blank data fields
• Maintenance enhancements to XmR, GageR&R and other templates
  Maintenance enhancements to PPAP and other templates
• Maintenance enhancements to Normal Probability Plot
• Fixed p & u charts for long file names

Anova and Analysis Tools

• Added enhanced descriptive statistics to the Anova tools.
• Added 1 sample t test and additional descriptive statistics to Anova and Analysis tools.
• Added non-parametric test (not normally distributed) analysis templates for:
  • 1-sample sign test
  • Sign Test
  • Friedman
  • Kruskal-Wallis
  • Kolmogorov-Smirnov
  • Mann-Whitney
  • Spearman
  • Wilcoxon
• Fixed Sample Size Calculator

New Control Chart Capabilities:

• Show process changes (stair-step limits) on control chart templates and charts created with macros
• Delete points on a control chart and change the UCL/LCL calculations.

Histogram Macro

• Upgraded histograms to allow users to add data without redrawing the chart
• Fixed number of decimals bug
• Fixed number of bars bug

Gage R&R Template

• Fixed UCL/LCL display problem
• Added and p values to the GageR&R Template

New Chart Templates:

• Pareto chart template
• EWMA control chart template
• Target Run Chart (target line and run)
• Target XmR Chart (target and XmR)
• Levey Jennings Chart template.
• Short Run SPC templates for XbarR, XmR, c, np, p, u charts.

Added Z scores and p values to these templates:

• Probability Plot
• Histogram
• XmR
• XbarR
• XbarS

New Templates:

• PPAP templates for AIAG PPAP Third Edition
• Project Charter
• Stakeholder Analysis matrix
• Speedometer chart
• Quality costs worksheet for prevention, appraisal, and failure costs
• SIPOC Diagram
• Balanced Scorecard Tree and Metrics
• ROI Calculator using lifetime value of the customer, defect rates, and other key indicators to calculate ROI or improvements.
• Lean manufacturing (Takt Time and NVA)
• Upgraded Gantt Chart

Regression Analysis

• Allow for multiple regression. (One column for Y, multiple columns for X)
• Changed Regression Analysis to match data order of the Scatter diagram.

Office 2003 compatibility

Added ability to rerun Stability Analysis on Control Charts.

Added Sample Size calculator using confidence levels, limits and standard deviation.

Added Anova, Regression, t-Test, and other statistics for hypothesis testing.

Added tolerance calculations to the GageR&R template (QS 9000 MSA Version 3).

Added histogram, probability plot, and scatter plot to XmR, XbarR, and XbarS templates.

Added Gantt Chart

Upgrade for Windows 2000 bug that causes QI Macros to appear on the toolbar twice.

Automated adding data to existing control charts

Multiple Control Limits for comparing several sets of data in the c, np, p, u, XmR, XbarR and XbarS charts

Added Run Chart macro

Probability Plot Template for analyzing distributions

Gentable macro added to convert matricies of any size to any other size

GageR&R upgrade with bias, linearity, and Anova

International Version Available for all languages.

Excel XP compatibility upgrade

Cusum Chart

Stability Analysis added to control charts

Box and Whisker Chart

QI Macros Training CD-ROM

InstallWizard simplies installation

Design of Experiments L4, L8, L16

Gage R&R template

Multivari Chart

Control charts: Added 1,2 sigma lines for stability analysis

Scatter Chart: Added Trend line

XbarS chart added

Histogram: added normal curve

Excel 2000 compatibility upgrade

Excel 97 Upgrade

XmR Trend chart added

Histogram Cp, Cpk, Pp, Ppk