Upgrade to QI Macros 2017

• Added MODAPTS Excel template for time and motion analysis
• Added XbarR real time template
• Added Bullet Graph template

• Eliminated chart title prompting to increase speed of chart creation
• QI Macros Chart Menu: Change Titles option added to simplify editing chart and axis titles
• QI Macros Chart Menu: Options added for quickly moving charts to a new Excel sheet, or for copying them to a PowerPoint or Word document

• Data Mining Wizard 2.0 will create entire improvement projects from PivotTable-like data.
• Interactive QI Macros tutorial added to the help menu

• The g Chart, t Chart, Laney p Prime Chart, and Laney u Prime Chart are now also accessible from the Control Chart macro menu, in addition to the existing templates.

• Enhanced stability analysis to accommodate filtered blank rows in data

• t test enhancement
• proportion test update

• Added filtering option to p and u chart templates

• Pass - Fail Cp Cpk calculator added to Capability Templates

• Fever Chart added to Diagrams
• Frequency Polygon added to Compare 2 Histograms template

• Test data is now accessible from the QI Macros help menu

• Added OEE template to the Rolled Throughput Yield Calculator

• Data Mining Wizard creates a pivot table of data, and generates an XmR chart and defect Paretos.
• 3 Legged 5 Whys Template
• Short Run Control Chart templates consolidated in one file
• Cpk Confidence Intervals added to Histogram macro data calculations output worksheet

• Sample Size Calculator expanded; separate calculators for attribute data and variable data.

• Compatible with Excel 2016 for Mac and PC.
• New toolbars for Excel 2016 for Mac.

• Expanded Gantt Chart to accommodate more data.

• Made Pooled Standard Deviation the default estimator for Cp and Cpk. Sbar/c4 and Rbar/d2 can still be used by changing the estimator field.
• Added Standard Work template for Lean.

• Added Descriptive Statistics Histogram under Capability Charts.

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

• Histogram Weibull Template now handles censored data (parts that didn't fail).

• Added Taguchi Loss and Cp Cpk PPM worksheets to DPMO Calculator.

• New Levey Jennings Dashboard
• Box and Whisker charts added to Anova Single Factor
• Scatter Plots added to Regression Analysis
• Fishbone expanded to accommodate 5 why's

• Wheeler Moving Average & Range template
• 3D Histogram Comparison Chart

• Control Chart templates automatically copy down formulas to accommodate additional data.
• New menu layout

• Time Value Map

• Equivalence Test
  

• Post Hoc (ANOVA1)
  

• Moving Average and Range template
  

• EOQ Calculator (Economic Order Quantity)
  

• Automated Ishikawa Fishbone Diagram
  

• Fixed Limit Control Chart Macro
• Defect Tracking Template
• TRIZ Template
• Remember and Apply Chart Formats
• Enhancement to Sample Size Calculator to add power calculation
  

• Added range calculation to Histogram and Frequency Histogram
• Added zero-based AQL to Sample Size tools
  

• Enhancements to Histogram with Weibull Analysis to use MLE
• Histogram Weibull Template
• Chi Squared Test added individual Chi-sq values
• Expanded Yamazumi Chart Template
  

• Bow Tie Risk Assessment
• Kaplan-Meier Step Plot Template
• Descriptive Statistics now tell you whether your data is normal or non-normal
• Histogram with Weibull Analysis
  

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 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 p prime chart and u prime chart templates per request from healthcare community.
• Stem and Leaf Plot template
• 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

Upgrade Archives