Home » Support » Upgrade Information

QI Macros Upgrade Information

Upgrade to QI Macros 2013

Each month we take customer feedback and industry updates and enhance the QI Macros. Updates include:

New Charts, Templates and Tools
New Features to Save You Time
Updates to be consistent with industry standards like the AIAG, Joint Commission on Healthcare and IHI
Updates to remain compatible with the latest Microsoft Windows and Excel updates

If you have not upgraded in a while, see our list of enhancements below to see what you've been missing.

Compatibility with Windows 7/8 and
Excel 2010, 2013, Office 365

Windows XP, Excel 32-bit: If you have QI Macros 2007-2010 and upgrade to Excel 2010, you're existing version of the QI Macros should work.

Windows 7/8: You must upgrade to use VBA7 and Microsoft recomments 32-bit Excel.
The QI Macros support Excel 2010, 2013 and Office 365 in Windows 7/8.

Excel 64-bit: You must upgrade to use VBA7 and 64-bit Excel.

Click here for a complete list of QI Macros versions and their compatibility with Windows, OSX and Excel

Are You Eligible for an Upgrade?

QI Macros Purchase Date	Upgrade or New License?
2007 or later	Eligible for Upgrade Discount - Buy Now
2006 or earlier	Must purchase a new license - Buy Now

How do I check my version date?

Are You Eligible for An Upgrade or Do You Need to Buy a New License?

If your QI Macros were purchased on or after 1/1/2007 you are eligible for an upgrade.
If your QI Macros were purchased in 2006 or earlier, you must purchase a new version of the QI Macros to receive all of the latest functionality and compatibility with Excel 2007.

Check your version date:

Starting in 2007, QI Macros menus show the year you purchased (e.g. QI Macros 2010.)
If your menu just says "QI Macros," then your version was purchased in 2006 or earlier.
Or click on the QI Macros Menu and select "About the QI Macros" to see your version's year and month. 2009.05 means your copy was purchased in May 2009:
If your QI Macros came on a floppy disk, then they are at least 5 years old and you will need to purchase a new license to receive the latest functionality.

2007 or Later: Purchase an Upgrade

Do you already own QI Macros for Excel? UPGRADE your old copy of the QI Macros to the latest version to take advantage of time saving features and new functionality.

QI Macros Upgrade - One License per Computer - $99

QI Macros Upgrade History

QI Macros Version #	Description of Enhancements
2013.01 released in January. 2013	New: Histogram with Weibull Analysis
2012.12 released in December. 2012	New: Capability Pack Macro - X Chart - R/S Chart - Histogram with Cp and Cpk - Probability Plot - Values Plot - Capability Plot Capability Pack Templates - XmR Five Pack - XbarR Six Pack - XbarS Six Pack
2012.08 released in August. 2012	Stability Analysis Tools - Green Up/Green Down to show "good" out of control points - Show/Hide Rules to show rule numbers violated - Clear Stability to clear red points and lines. Excel Charts - 3D Bar and Column Charts - Stacked Bar and Column Charts - Area Chart - Bubble Chart - Donut Chart - Stock Chart
2012.06 released in June. 2012	New: XbarR, XbarS, XMedianR, CUSUM and EWMA now accept one column of data and restack to 2-25 samples per subgroup.
2012.03-5 released in Mar-May. 2012	Maintenance Miscellaneous improvements to chart menu and other routines.
2012.02 released in Feb. 2012	New: F Test and t Test Templates
2012.01 released in Jan 2012	New: Type 1 Gage R&R Funnel Plot template Added residuals and probability calculations to regression analysis.
2011.10 released in Oct. 2011	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
2011.09 released in Sept. 2011	New: Delta Chart Template Various performance enhancements
2011.06 released in June 2011	New: Westgard Rules added to Control Chart Rules for Levey Jennings Charts.
2011.05 released in May 2011	New: Skyline limits added to XbarR and XbarS charts.
2011.04 released in April 2011	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
2011.03 released in March 2011	New: Chart Wizard that automatically decides what charts to run based on the data selected.
2011.02 released in February 2011	New: XmR Dashboard - added Precontrol Charts XbarR Dashboard with Precontrol Charts (new)
2011.01 released in January 2011	New: Lean Six Sigma "Money Belt" Training
2010.12 released in December 2010	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.
2010.11 released in November 2010	Enhancements: Statistics Wizard Automatically runs appropriate statistics: ANOVA, F test, t test, Levene's test, Chi-Squared and regression based on the data selected.
2010.10 released in October 2010	Enhancements: Stem and Leaf Plot template
2010.09 released in September 2010	Enhancements: Mind Mapping template
2010.08 released in August 2010	Enhancements: 8D Report template M Chart template Yamazumi Chart template
2010.07 released in July 2010	Enhancements: MSA 4th Edition
2010.06 released in June 2010	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.
2010.05 released in May 2010	Enhancements: Enhanced Pareto chart to show up to three colors on top three main "bars" if pareto pattern exists.
2010.04 released in April 2010	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.
2010.03 released in March 2010	Enhancements: I-MR-R Chart (hybrid XbarR and XmR chart that shows within subgroup (R) and between subgroup (MR) variation. Cause Effect Matrix Template
2010.02 released in February 2010	Enhancements: Box and Whisker shows all outlier points
2010.01 released in January 2010	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
2009	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
2008	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.
2007	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.
2006	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 error data 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
2005	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 Gage R&R - added Analytic Attribute Method Maintenance enhancements to Histogram and Frequency Histogram to allow blank data fields Maintenance enhancements to XmR, Gage R&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
2004	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 Gage R&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.
2003	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 Gage R&R template (QS 9000 MSA Version 3). Added histogram, probability plot, and scatter plot to XmR, XbarR, and XbarS templates. Added Gantt Chart
2002	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 Gen table macro added to convert matrices of any size to any other size Gage R&R upgrade with bias, linearity, and Anova International Version Available for all languages.
2001	Excel XP compatibility upgrade Cusum Chart Stability Analysis added to control charts Box and Whisker Chart QI Macros Training CD-ROM
2000	InstallWizard simplifies installation Design of Experiments L4, L8, L16 Gage R&R template Multivari Chart Control charts: Added 1,2 sigma lines for stability analysis
1999	Scatter Chart: Added Trend line XbarS chart added Histogram: added normal curve
1998	Excel 2000 compatibility upgrade Excel 97 Upgrade XmR Trend chart added Histogram Cp, Cpk, Pp, Ppk

Find out more about the QI Macros For Excel SPC Software

QI Macros Upgrade Information

Upgrade to QI Macros 2013