Upgrade to QI Macros 2018

• Customizable Control Chart Dashboards (Add additional charts to an existing dashboard.)
• Histogram added to XbarR Dashboard
• ZmR Control Chart
• Job Safety Analysis added to the Hazard Analysis Template
• Love Bug Diagram added to the Fishbone Template

• Automated value stream map

• Improved visual performance of control chart templates

Highlights

  Data Mining Wizard 2.0 (Feb 2017)  
Increased robustness with multiple paretos and fishbone diagrams

Streamlined installation and chart creation
Embedded tutorial for new users

• Improved visibility and accessibility to QI Macros chart menu functions

• Streamlined installation process

• DOE templates now contain an effects plot
• Bland-Altman Plot added to Scatter Chart template

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

Highlights

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

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

Highlights

  Compatible with Excel 2016 for Mac and PC (Oct 2015)  

  New toolbars for Excel 2016 for Mac (Oct 2015)  

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

Highlights

  Automated Ishikawa Fishbone Diagram - Jan 2014  

  New menu layout - June 2014  

• 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
  

Highlights

Watch Video Highlighting 2013 Enhancements

• 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
  

Enhancement Archives