If
you have not upgraded in a while, see our list of enhancements below to see what
you've been missing.
Microsoft's
changes for Excel 2010, 2007 (and Excel 2003 SP3) will prevent QI Macros 2006 and earlier
versions from working. With the release of Excel 2007 SP2, many IT departments
are deciding it's safe to upgrade, but they haven't factored addins like the QI
Macros or PDFMaker into the upgrade. Don't lose your functionality, buy the latest
version now!
QI Macros Version # |
Description of Enhancements |
2012.01
released in Jan 2012
|
New:
|
2011.10
released in Oct 2011
|
New:
|
2011.09
released in Sept 2011
|
New:
|
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:
|
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:
|
| 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:
|
| 2010.09 released in September 2010 |
Enhancements:
|
2010.08 released in August 2010 |
Enhancements:
|
2010.07 released in July 2010 |
Enhancements:
|
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
|
2009
|
Compatibility with Excel 2007 SP2
Improvements to prevent conflicts with other addins.
New and Enhanced Macros
New and Enhanced Templates
Anova and Analysis Tools
Data Transformation Tools
|
2008
|
New and Enhanced Macros:
New Control Chart Menu Options
New and Enhanced Templates
Anova and Analysis Tools
Data Transformation Tools
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
New and Enhanced Macros
New Control Chart Menu Options
New and Enhanced Templates
New Data Transformation Tools
New Anova and Analysis Tools
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:
Anova and Analysis Tools:
Fixed chi-square test calculation.
New Templates:
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
|
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
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
|
2004
|
New Control Chart Capabilities:
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
New Chart Templates:
Added Z scores and p values to these templates:
- Probability Plot
- Histogram
- XmR
- XbarR
- XbarS
New Templates:
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 GageR&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
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. |
2001
|
Excel XP compatibility upgrade
Cusum Chart
Stability Analysis added to control charts
Box and Whisker Chart
QI Macros Training CD-ROM |
2000
|
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 |
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 |