Date

Build

Revision

Added the ability to show only the last "N" points on a variables control chart; added the ability to use dates for the X axis of a scatter diagram; added the ability to run one factor nested designs in ANOVA; fixed issue with reverse labels on variability chart in ANOVA; fixed Excel 2007 issue with labeling first point on scatter diagram.

Added the ability for a user to call the updating chart routine using VBA code and bypassing the input box to select the chart to update (click here for details); fixed an international issue with scaling of charts; fixed an issue with the 12 run Plackett-Burman experiemental designs.

Three major additions/changes: 1) added waterfall chart (in Six Sigma Tools, Cause and Effect); 2) enhanced descriptive statistics to include analysis of multiple data sets with the addition of dot plot and multiple histograms; 3) removed the DPMO (defects per million opportunities) from the process capability statistics box - this value included the 1.5 sigma shift; have replaced DPMO with PPM (parts per million) above USL, PPM below LSL, and total PPM both for the within capabilities (based on the estimated standard deviation) and the overall capabilities (based on the calculated standard deviation); no longer is the 1.5 sigma shift included.

In Excel 2007, it is possible for a chart to be truncated on the right-hand side when a person views a chart produced by another person in a different country. This build includes a method to fix truncated charts.

Added option to include subgroup average line on the variability chart in ANOVA; ehanced the ability to make subgroups from one column of data by allowing the option to pull additional columns of information with the subgroups.

Expanded ANOVA greatly; 1 to 5 factors, crossed, nested or mixed designs, random/fixed factors, variability chart (option to color code by factor level), components of variance, expected mean squares, F calculation information, control chart rollup.

Speeded up the ability of the program to check for out of control points if there are missing data points; also corrected an issue that would occur if the first chart made in a workbook was deleted; caused some ranges to be used incorrectly on charts.

Added the ability to set the alpha value to remove the interaction term in ANOVA Gage R&R; the default value is 0.25. The build also addresses several issues with sizing the X-mR chart when specifications are added the chart.

Microsoft released Service Pack 2 for Office 2007. This release fixed a problem Excel 2007 had with autosizing text boxes. We had built a method to get around this; however, now this method generated a problem with building the stat boxes on the histogram and process capability charts. This service pack also affected the code to put values on the control limits. These issues have been fixed with this release.

Fixed an error that was created in the last build that occurred when users tried to update a X-mR (individuals) chart with the option of placing the X and mR charts on the same worksheet.

04/01/09

4.0.0.4

Added within/between control charts: Xbar-mR-R and Xbar-mR-s; this generates three charts: Xbar: the subgroup averages chart with the control limits based on the range between consecutive subgroup averages; mR - the moving range chart; R or s chart: the within subgroup variation chart (either based on the within subgroup range or within subgroup standard deviation).

03/04/09

4.0.0.3

Added nested Gage R&R

03/04/09

4.0.0.3

Added variance components charts to Gage R&R average method and ANOVA analysis including splitting out the operator*part interaction

03/3/09

4.0.0.3

Added the option to shade the histogram and plot the average with the process capability chart

03/04/09

4.0.0.3

Revised the Box and Whisker chart to plot the actual outliers and set the whiskers to be 1.5 times the inner quartiles

12/28/08

4.0.0.2

Added the option to add USL and/or LSL to the individuals control chart (X-mR)

12/15/08

4.0.0.1

Initial release of version 4.0