| October 2008 |
QI Macros and templates
Enhancements:
|
| September 2008 |
QI Macros and templates
Enhancements:
- APQP 2nd edition updates of control plan, check list and checksheet
- Control chart wizard - comma/decimal fix for International versions
of Excel
|
| August 2008 |
QI Macros and templates
Enhancements:
|
| June 2008 |
QI Macros and templates
Enhancements:
|
| May 2008 |
QI Macros and templates
Enhancements:
|
| March 2008 |
QI Macros and templates
Enhancements:
- Show Process Change - allows more than one change per chart.
- PPAP - added input sheet for data common to all forms such as
part name, part number etc.
- Pull down menu and error messages translated to various foreign
languages.
|
| February 2008 |
QI Macros and templates
Enhancements:
- Macros - chart sheet name is automatically populated to match
the chart title
- Help files and user guide translated to various foreign
languages.
|
| January 2008 |
QI Macros and templates
Enhancements:
- Regression Analysis - Added multiple regression analysis. First
columns are X, last column is Y.
- Box Whisker chart - allows negative values now
|
| December 2007 |
QI Macros and templates
Enhancements:
- 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.
- Probability Plot template - added Half Normal Probability Plot
|
| November 2007 |
QI Macros and templates
Enhancements:
|
| October 2007 |
QI Macros and templates
Enhancements:
|
| September 2007 |
QI Macros and templates
Enhancements:
- All variable charts - update to enable charts to handle cells
with blank data
|
| August 2007 |
QI Macros and templates
Added:
Created uninstall.exe file to more easily uninstall the software
or 30 day evaluation copy
|
| July 2007 |
QI Macros and templates
Added:
Classic 2003 menu for Excel 2007
users - to ease the transition to the new 2007 ribbon
Install file now identifies multiple versions of Excel on your
PC and asks which version you want to load the QI Macros on.
|
| June 2007 |
QI Macros and templates
Added:
Multivariate Analysis
QI Macros Help
file - descriptions and instructions for using each tool
|
| May 2007 |
QI Macros and templates-
Added:
Corrected bug in box and whisker formula (QI Macros 2007 version
only).
|
| April 2007 |
QI Macros and templates-
Added:
Corrected run time error when some International versions closed
Excel.
|
| February 2007 |
QI Macros, templates and menu-
Completely rewritten in VBA to support Excel 97-2007 including the
new "ribbon" interface.
Added:
|
| October 2006 |
QI Macros -
Histogram enhancement - allow more than 50 classes.
Performance enhancement - speed up XmR chart macro.
|
| September 2006 |
QI Macros and templates-
Updated PPAP Forms per 4th edition errorata sheet published by AIAG.
Gage R&R deleted acceptability % in cell C44 since it is no longer
needed.
Performance enhancement - consolidated stability analysis code for
all control charts.
|
| August 2006 |
QI Macros -
Fixed comma-decimal point problem for international users in Germany.
Enhanced # of bars calculation in Histogram.
Fixed chi-squared calculation.
|
| July 2006 |
QI Macros and templates-
Upgraded Balanced Scorecard
Template
Fixed comma-decimal point problem for international users in Poland.
Added LinkTranspose
Macro to allow paste-link and transposition of data. Excel won't
do this.
|
| June 2006 |
QI Macros templates-
Added Scatter and Youden Plot templates
|
| May 2006 |
QI Macros -
Upgraded Histogram macro
|
| April 2006 |
QI Macros templates-
Upgraded PPAP and FMEA
templates to 4th Edition
|
| March 2006 |
QI Macros -
Upgraded Control Chart Wizard to work with split columns of data.
|
| February 2006 |
QI Macros -
Efficiency Upgrade to QI Macros to speed up starting Excel. Reduced
number of macro files from 19 to 1.
Upgraded templates and added links to training documentation on
website.
|
| January 2006 |
QI Macros -
Added Value Stream Mapping Template
Added Version Information
Removed rounding from histograms
|
| December 2005 |
QI Macros -
Fixed Sample Size Calculator
Fixed p & u charts for long file names
|
| November 2005 |
QI Macros - Control Chart Wizard
Don't know what control chart to choose? That's why we added the
Control Chart Wizard. Just
select your data, click on the
Control Chart Wizard and it will analyze your data and choose
the best chart based on your data's sample size and integer or decimal
format.
|
| October 2005 |
QI Macros and Templates
Added XMedianR chart to the
macros.
Upgraded p and u charts for AIAG SPC 2nd
Added ROC Curve Templates
|
| September 2005 |
QI Macros Templates
Added Time Tracking Template
|
| August 2005 |
QI Macros and Templates
Added enhanced descriptive statistics to the Anova tools.
|
| July 2005 |
QI Macros and Templates
Maintenance enhancements to Normal Probability Plot
Added 1 sample t test and additional descriptive statistics to
Anova and Analysis tools.
GageR&R
- added Analytic Attribute Method
|
| May 2005 |
QI Macros and Templates
Maintenance enhancements to Histogram and Frequency Histogram to
allow blank data fields
|
| April 2005 |
QI Macros and Templates
Maintenance enhancements to XmR, GageR&R
and other templates
|
| March 2005 |
QI Macros and Templates
Maintenance enhancements to PPAP and other templates
Converted to Windows 32-bit installer to prevent installation problems
in Windows XP.
|
| February 2005 |
QI Macros and Templates
Added non-parametric (not normally distributed) analysis templates
for:
- 1-sample sign test
- Sign Test
- Friedman
- Kruskal-Wallis
- Kolmogorov-Smirnov
- Mann-Whitney
- Spearman
- Wilcoxon
|
| January 2005 |
QI Macros and Templates
Added sigma estimator (SIGMAave/c4) for subgroup sizes > 10 to:
- Histogram macro
- Frequency histogram
- XbarS template
|
| December 2004 |
QI Templates
Added PPAP templates for AIAG PPAP Third Edition
- Appearance Approval Request
- Supplier Checklist/Approval
- Supplier Request for Engineering Approval
- Interim Recovery Worksheet
- Engineering Source Approval
- Part Submission Warrant
- Production Part Approval - Dimensional Results
- Production Part Approval - Material Test Results
- Production Part Approval - Performance Test Results
- Design Matrix
- Bulk Material Interim Approval
Fixed GageR&R UCL/LCL display problem.
|
| November 2004 |
QI Templates
Added ROI Calculator using lifetime value of the customer, defect
rates, and other key indicators to calculate ROI for improvements.
|
| October 2004 |
QI Templates
Added Levey Jennings Chart template.
|
| September 2004 |
QI Templates
Added Short Run XbarR, XmR, c, np, p, u chart templates.
Fixed Regression tool to allow for multiple regression. (One column
for Y, multiple columns for X).
|
| August 2004 |
QI Templates
Added and p values to the GageR&R
Template
Lean manufacturing (Takt Time and NVA)
Fixed number of decimals bug in Histogram macro.
|
| June 2004 |
QI Templates
Added Z scores and p values to these templates:
- Probability Plot
- Histogram
- XmR
- XbarR
- XbarS
Fixed number of bars bug in Histogram.
Changed Regression Analysis to match data order of the Scatter diagram. |
| May 2004 |
Added the following templates:
|
| April 2004 |
Added the following templates:
|
| March 2004 |
Added the following capabilities:
|
| February 2004 |
Added the following templates:
- Pareto chart
- Run and XmR charts with target lines
- Speedometer chart
- Quality costs worksheet for prevention, appraisal, and failure
costs
|
| January 2004 |
- Added SIPOC worksheet and u
- Upgraded histograms to allow users to add data without redrawing
the chart
|
| October 2003 |
Added ability to rerun
Stability Analysis on Control Charts.
Added Gantt Chart
Note: Current version of QI Macros have been tested with Office
2003 and work perfectly.
|
| May 2003 |
Added Sample Size calculator
using confidence levels, limits and standard deviation.
|
| Apr. 2003 |
Added Anova, Regression,
t-Test, and other statistics
for hypothesis testing.
Added tolerance calculations to the GageR&R template (QS 9000
MSA Version 3).
|
| Mar. 2003 |
Added histogram, probability
plot, and scatter plot to XmR, XbarR, and XbarS templates.
|
| Dec. 2002 |
Automated adding data
to existing control charts
|
| Oct.. 2002 |
Upgrade for Windows 2000 bug that causes QI Macros to appear on
the toolbar twice.
|
| Sept. 2002 |
International Version Available for all languages.
|
| Aug. 2002 |
Added Run Chart macro
|
| July 2002 |
Multiple
Control Limits for comparing several sets of data in the c, np,
p, u, XmR, XbarR and XbarS charts |
| June 2002 |
Gentable macro added to convert matricies of any size
to any other size |
| March 2002 |
Probability Plot Template for analyzing distributions |
| January 2002 |
GageR&R upgrade with bias, linearity, and Anova |
| Sept. 2001 |
Cusum Chart |
| August 2001 |
Stability Analysis
added to control charts |
| June 2001 |
Box and Whisker Chart
|
| May 2001 |
Excel XP compatibility upgrade |
| March 2001 |
QI Macros Training CD-ROM |
| November 2000 |
Design
of Experiments L4, L8, L16 |
| May 2000 |
Gage
R&R template |
| April 2000 |
Multivari Chart |
| March 2000 |
InstallWizard simplies installation |
| February 2000 |
Control charts: Added 1,2 sigma lines for stability
analysis |
| December 1999 |
Scatter Chart: Added Trend line |
| August 1999 |
XbarS chart added |
| |
Histogram: added normal curve |
| December 1998 |
Excel 2000 compatibility upgrade |
| October 1998 |
XmR Trend chart added |
| May 1998 |
Histogram Cp, Cpk, Pp, Ppk |
| March 1998 |
Excel 97 Upgrade |
view cart · contact 
view cart | contact