Upgrade to QI Macros 2019

• "Analysis Summary Worksheet" and Histogram output added to the Data Mining Wizard
• Process Change Wizard added: Automated Show Process Change when Trend or Runs identified in the data.
• Conditional Formatting for Risk Priority Number (RPN) added to the FMEA Template (FMEA/DFMEA/MFMEA/PFMEA) - automatically updates to signify your RPN level of Green, Yellow or Red.
• Type 3 Gage R&R template added
• CAGE and Kano Models added to the Voice of the Customer Matrix
• Show/Hide Confidence Interval (CI) and Prediction Interval (PI) added to the Regression tool and Scatter Diagrams.
• C, P, U Dashboard, Levey Jennings Dashboard, and XbarR Dashboards now include a "Refresh Charts w/ Control Chart Rules" macro button.
• Histogram Dashboard added to XbarR Dashboard
• Register your QI Macros license to receive free technical support and Monthly Tips

• Switchable Scatter Plot allows you to swap X and Y values
• Out-of-control points now highlighted on the data sheet - not just on the chart
• Updated MSA 4th Gage R&R Template output
• XmR Dashboard now includes a "Refresh Charts w/ Control Chart Rules" macro button.

Highlights

Automated Value Stream Map
Functional and visual revamp of all templates
Template Wizard
Searchable "QI Macros Tools" function

• New QI Macros menu icons for ease of access
• Find QI Macros Tools added to help menu
• Ability to switch between QI Macros Full Menu or a reduced Wizard Menu (October 2018-February 2019 releases only)
• Template Wizard will select the appropriate fill-in-the-blank template for your data set
• POLCA Diagram

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