Upgrade and Enhancement Archives

Highlights

Data Mining Wizard (Feb 2016)
Creates a pivot table of data, and generates an XmR Chart and defect Paretos

New and Enhanced Chart Macros

• Cpk Confidence Intervals added to Histogram macro data calculations output worksheet
• Data Mining Wizard creates a pivot table of data, and generates an XmR chart and defect Paretos

New and Enhanced Chart Templates

• 3 Legged 5 Whys Template
• Fever Chart added to Diagrams
• Frequency Polygon added to Compare 2 Histograms Template
• Added OEE Template to the Rolled Throughput Yield Calculator
• Added filtering option to p Chart and u Chart Templates
• Pass - Fail Cp Cpk Calculator (Attribute Cp Cpk Calculator) added to Capability Templates
• Short Run Control Chart templates consolidated in one file

New and Enhanced Statistical Tools

• t-Test enhancement
• Test of Proportion update

New and Enhanced Functionality

• Enhanced stability analysis to accommodate filtered blank rows in data
• Test data is now accessible from QI Macros help menu

Compatibility with:

• Excel 2016 for PC and Mac (October 2015 release)

New and Enhanced Chart Macros

• Added Descriptive Statistics under Histograms & Capability drop-down menu

New and Enhanced Chart Templates

• Expanded Gantt Chart to accommodate more data
• Sample Size Calculator expanded; separate calculators for attribute data and variable data
• Added Standard Work template for Lean

New and Enhanced Statistical Tools

• Upgraded all statistical functions to include redeveloped statistical functions (e.g., FINV is now F.INV) included in Excel 2010 and 2013. Excel 2003-2007 still use the previous functions

New and Enhanced Functionality

• Made Pooled Standard Deviation the default Sigma Estimator for Cp and Cpk. Sbar/c4 and Rbar/d2 can still be used by changing the Sigma Estimator field.

New and Enhanced Chart Macros

• Box and Whisker Plot added to Anova Single Factor
• 3D Histogram Comparison Chart
• Time Value Map

New and Enhanced Chart Templates

• Automated Ishikawa Fishbone Diagram
• Fishbone expanded to accommodate 5 why's
• Histogram Weibull Template now handles censored data (parts that didn't fail).
• Added Taguchi Loss and Cp Cpk PPM worksheets to DPMO Calculator.
• EOQ Calculator (Economic Order Quantity)
• New Levey Jennings Dashboard
• Control Chart templates automatically copy down formulas to accommodate additional data.
• Wheeler Moving Average & Range template

New and Enhanced Statistical Tools

• Equivalence Test
• Post Hoc (ANOVA1)
• Scatter Plots added to Regression Analysis

New and Enhanced Functionality

• New menu layout
• Moving Average and Range template

Watch Video Highlighting 2013 Enhancements

Compatibility with:

• Excel 2013
• Windows 8

New and Enhanced Chart Macros

• Fixed Limit Control Chart
• Histogram with Weibull Analysis
• Enhancements to Histogram with Weibull Analysis to use MLE

New and Enhanced Chart Templates

• Bow Tie Risk Assessment
• Defect Tracking Template
• Histogram Weibull Template
• Kaplan-Meier Step Plot Template
• Added zero-based AQL to Sample Size tools
• Enhancement to Sample Size Calculator to add power calculation
• TRIZ Template
• Expanded Yamazumi Chart Template

New and Enhanced Statistical Tools

• Chi Squared Test added individual Chi-sq values
• Descriptive Statistics now tell you whether your data is normal or non-normal.

New and Enhanced Functionality

• Added range calculation to Histogram and Frequency Histogram
• Remember and Apply Chart Formats

New and Enhanced Chart Macros

• Capability Suite Macro Creates these Six Charts
  - X Chart
  - R/S Chart
  - Histogram with Cp and Cpk
  - Probability Plot
  - Values Plot
  - Capability Plot
• New 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.
• XbarR, XbarS, XMedianR, CUSUM and EWMA now accept one column of data and restack to 2-25 samples per subgroup.
• Excel Charts
  - 3D Bar and Column Charts
  - Stacked Bar and Column Charts
  - Area Chart
  - Bubble Chart
  - Donut Chart
  - Stock Chart

New and Enhanced Chart Templates

• Histogram Template to Compare Two Histograms Side by Side
• Capability Suite Templates
  - XmR Five Pack
  - XbarR Six Pack
  - XbarS Six Pack
• Type 1 Gage R&R
• Funnel Plot template

New and Enhanced Statistical Tools

• F Test and t Test Templates
• Added residuals and probability calculations to regression analysis

New and Enhanced Chart Macros

• Chart Wizard that automatically decides what charts to run based on the data selected.
• Add Target Line, Spec Limits etc to Chart using the QI Macros chart menu.
• Added ability to toggle between showing and hiding sigma lines on a control chart using the QI Macros chart menu.
• Ability to refresh stability analysis after adding new data to control chart dashboards.
• XmR Dashboard - added Precontrol Charts
• XbarR Dashboard with Precontrol Charts (new)
• Values Plot to analyze variation of individual points.
• Westgard Rules added to Control Chart Rules for Levey Jennings Charts.
• Skyline limits added to XbarR and XbarS charts.

New and Enhanced Templates

• Delta Chart Template

New Training Resources

• Lean Six Sigma "Money Belt" Training
• QI Macros You Tube Channel

Compatibility with:

• Macintosh 2011
• Excel 2010 in 32-bit and 64-bit versions
• Excel 2010 Microsoft "Click to Run" installations

New and Enhanced Statistical Tools

• Statistics Wizard - Automatically runs appropriate statistics: ANOVA, F test, t test, Levene's test, Chi-Squared and regression based on the data selected.
• Rewrote Anova and Analysis tools to be independent of Excel's Data analysis Toolpak. This should prevent translation conflicts with International Versions of Excel.
• 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.

New and Enhanced Chart Macros

• Pareto Chart will pivot a column of text, dates or numbers and draw a pareto chart of the result.
• Pareto Chart will produce multiple charts from multiple columns of data.
• Pareto chart shows up to three colors on top three main "bars" if pareto pattern exists (>20%).
• Box and Whisker Plot shows all outlier points
• Histogram: Added ability to run charts on time formatted data and added Cr and Skewness to metrics.
• I-MR-R Chart (hybrid XbarR and XmR chart that shows within subgroup (R) and between subgroup (MR) variation.
• Levey Jennings 10-20-30% control chart

New and Enhanced Templates

• Added instructions sheet to control chart templates.
• 8D Report template
• Cause Effect Matrix Template
• Cpk Template - added True Position and MMC True Position
• Gage R&R Updates for MSA 4th Edition
• M Chart template
• Mind Mapping template
• Added new Laney p' Chart (p Prime) and Laney u' Chart (u Prime) templates per request from healthcare community.
• Stem and Leaf Plot template
• XmR Hi Lo Chart template (XmR Hi-Lo Chart)
• Yamazumi Chart template

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 Charts, Column Charts, Combination Chart of bar + line or line + column.
• 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.

Statistical 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 and Whisker Plot - 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
• Uncertainty Template
• 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 Chart 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 Mining and Analysis Tools

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

New Anova and Analysis Tools

• Data Normality Test

QI Macros Help - 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 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

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

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.

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

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.

Excel XP compatibility upgrade

Cusum Chart

Stability Analysis added to control charts

Box and Whisker Plot

QI Macros Training CD-ROM

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

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