Upgrade to QI Macros 2010

Month

Description of Enhancements

Enhancements:

• I-MR-R Chart (hybrid XbarR and XmR chart that shows within subgroup (R) and between subgroup (MR) variation.
• Cause Effect Matrix Template

Enhancements:

• Box and Whisker shows all outlier points

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

Enhancements:

• Levene's Test for Variation of normal and non-normal data
• USL/LSL added to XmR Dashboard template

Enhancements:

• Rolled Throughput Yield Calculator

Enhancements:

• Right-Click (shortcut) Chart Menu added

Enhancements:

• Tornado (Paired Bar) Chart
• Excel Charts: Bar and Column Charts

Enhancements:

• Toyota's A3 Report for Problem Solving.
• Rolling c, np, p, u, XmR, XbarR templates

Enhancements:

• Breyfogle's 30,000 foot level control chart for Integrated Enterprise Excellence (IEE).
• Improvements to prevent conflicts with other addins.

Enhancements:

• Levey Jennings Template update to use 10-20-30% limits.

Enhancements:

• Upgrade for Excel 2007 SP2
• Added new Healthcare rules to control chart rule options per request of IHI faculty

Enhancements:

• Upgraded XmR, XbarR, XbarS, XMedianR to put both the X and R charts on the data sheet.
• Changed Stability Analysis to show out of control points as a diamond so that they will look different on black and white printers.

Enhancements:

• New Automated Control Chart Dashboards for c, p, u, np and XmR charts
• Added Tukey Quick Test to Nonparametric tests under Anova and Analysis tools
• Added subgroup size prompt to histogram and frequency histogram macro.

Enhancements:

• New Chart - XmR with Median R instead of Average R
• Data Transformation Tools - Added Unstack Matrix function
• 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

Enhancements:

• Multivari chart - Enhanced macro to do "multivariate" analysis of multiple columns of labels and create multivari and stdev charts
• DPMO Six Sigma Calculator - Added DPMO Calculator Template to Planning Tools
• Project Management Tools: added
  • Earned Value Management Formulas Template
  • Work Breakdown Structure Template

Enhancements:

• Proportions Hypothesis Testing Templates
  • Test of a Proportion
  • Test of Two Proportions
• Descriptive Statistics: added box plot and confidence limits
• t chart (Time Between Rare Events) template
• FMEA Template - Added Machinery FMEAs per SAE J1739

Enhancements:

• QI Macros chart menu additions
  • Ghost Point - Remove point from calculations but keep it on the chart
  • Add text Box to Point

Enhancements:

• APQP 2nd edition updates of control plan, check list and checksheet
• Control chart wizard - comma/decimal fix for International versions of Excel

Enhancements:

• FMEA 4th Edition - added new templates and checklists
• Tornado chart template

Enhancements:

• Added p chart and u chart format options (skyline vs wavy)
• Unstack by label and subgroup

Enhancements:

• Analysis of Means (ANOM) Chart

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.

Enhancements:

• Macros - chart sheet name is automatically populated to match the chart title
• Help files and user guide translated to various foreign languages.

Enhancements:

• Regression Analysis - Added multiple regression analysis. First columns are X, last column is Y.
• Box Whisker chart - allows negative values now

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

Enhancements:

• p chart - capped the sigma lines and UCL to 100%. This function was requested by healthcare customers tracking JCAHO measures.
• Gage R&R Template - added NDC (Number of Distinct categories) and Anova R&R using spec tolerance

Enhancements:

• Cp Cpk Template - now allows one sided spec limits
• Value Stream Template - added symbols page

Enhancements:

• All variable charts - to enable charts to handle cells with blank data

Added:

• Data Normality Test
• Levey Jennings Chart Macro
• Histogram Macro:
  • added Sigma calculation
  • added back # of bars prompt

Created uninstall.exe file to more easily uninstall the software or 30 day evaluation copy

Added:

• Dot Plot
• Run Chart - added choice between average or median

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.

Added:

Multivariate Analysis

• Hotelling T2 Chart Macro
• Matrix Plot Diagram

QI Macros Help file - descriptions and instructions for using each tool

Added:

• g chart template
• Data Transformation - Word Count
• Data Transformation - CrossTab
• Failure Prevention Analysis (FPA) template

Corrected bug in box and whisker formula (QI Macros 2007 version only).

Added:

• EWMA Chart Macro
• Cp Cpk template

Corrected run time error when some International versions closed Excel.

QI Macros, templates and menu-
Completely rewritten in VBA to support Excel 97-2007 including the new "ribbon" interface.
Added:

• Moving Average Chart
• Moving Average Template
• Cusum Template
• Cusum enhancements - added Upper and Lower Cusum lines
• XmedianR chart
• All stability rules and the ability to select from standard rule sets (Montgomery, Juran, AIAG, Western Electric)
• Ability to show/hide 1-2 Sigma LInes
• Data Transformation Tools - Box Cox, Restack, Get Sample, Paste Link Transpose

QI Macros -
Histogram enhancement - allow more than 50 classes.
Performance enhancement - speed up XmR chart macro.

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.

QI Macros -
Fixed comma-decimal point problem for international users in Germany.
Enhanced # of bars calculation in Histogram.
Fixed chi-square test calculation.

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.

QI Macros templates-
Added Scatter and Youden Plot templates

QI Macros -
Upgraded Histogram macro

QI Macros templates-
Upgraded PPAP Forms and FMEA template to 4th Edition

QI Macros -
Upgraded Control Chart Wizard to work with split columns of data.

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.

QI Macros -
Added Value Stream Mapping Template
Added Version Information
Removed rounding from histograms

QI Macros -
Fixed Sample Size Calculator
Fixed p & u charts for long file names

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.

QI Macros and Templates
Added XMedianR chart to the macros.
Upgraded p and u charts for AIAG SPC 2nd

Added ROC Curve Templates

QI Macros Templates
Added Time Tracking Template

QI Macros and Templates
Added enhanced descriptive statistics to the Anova tools.

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

QI Macros and Templates
Maintenance enhancements to Histogram and Frequency Histogram to allow blank data fields

QI Macros and Templates
Maintenance enhancements to XmR, GageR&R and other templates

QI Macros and Templates
Maintenance enhancements to PPAP and other templates

Converted to Windows 32-bit installer to prevent installation problems in Windows XP.

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
  

QI Macros and Templates
Added sigma estimator (SIGMAave/c4) for subgroup sizes > 10 to:

• Histogram macro
• Frequency histogram
• XbarS template

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.

QI Templates
Added ROI Calculator using lifetime value of the customer, defect rates, and other key indicators to calculate ROI for improvements.

QI Templates
Added Levey Jennings Chart template.

QI Templates
Added Short Run SPC templates for XbarR, XmR, c, np, p, u charts.

Fixed Regression tool to allow for multiple regression. (One column for Y, multiple columns for X).

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.

• Probability Plot
• Histogram
• XmR
• XbarR
• XbarS

• Target Run Chart (target line and run)
• Target XmR Chart (target and XmR)
• Project Charter
• Stakeholder Analysis matrix
• Balanced Scorecard Tree and Metrics
• Upgraded Gantt Chart

• EWMA control chart

• 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.

• Pareto chart
• Run and XmR charts with target lines
• Speedometer chart
• Quality costs worksheet for prevention, appraisal, and failure costs

• Added SIPOC worksheet and u
• Upgraded histograms to allow users to add data without redrawing the chart

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.

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.

Automated adding data to existing control charts

Upgrade for Windows 2000 bug that causes QI Macros to appear on the toolbar twice.

International Version Available for all languages.

Added Run Chart macro

Box and Whisker Chart