Upgrade to QI Macros 2020

• Unstack Matrix to List now includes zeros in data output
• Scrolling Dashboard added to XmR Dashboard Template
• Product Family Matrix Form added to Value Stream Map
• Regression Test asks if Y Value is first or last column in your data set
• Two-Sample t-Test: Toggle order results between first and last columns
• Locate any Data Point in your Excel spreadsheet

• Remember and Apply Custom Chart Format added
• Weighted Pareto Chart Template added
• Quadrant Bubble Template and Quadrant Bubble Macro added
• Quadrant Scatter Template and Quadrant Scatter Macro added
• Added Multipliers to p Charts and u Charts - changes rate levels of y-axis values
• Added data labels to points in the Scatter Diagram Template and Quadrant Scatter Template
• Toggle between p Chart and p' Chart, and u Chart and u' Chart
• Updated centerlines to dashes, when the Fix Control Limits function is used
• Updated format of data points, in control charts, from squares to dots

Highlights

FMEA 5th Edition Template added (AIAG & VDA FMEA 1st Edition)
"Analysis Summary Worksheet" and Histogram output added to the Data Mining Wizard
Find QI Macros Tools functionality added
Process Change Wizard added
Histogram Dashboard added to XmR and XbarR Dashboard

• FMEA 5th Edition Template added (AIAG & VDA FMEA 1st Edition)
• Find QI Macros Tools functionality updated
• Number Count Wizard added
• QI Macros Quick Lesson added for expedited customer training

• Paynter Chart Template added
• Enhancements to the XbarR and XbarS subgroup recognition; accepts varying sample sizes
• Run Chart may be quickly converted to an XmR chart for comparison
• Effect divisor added to DOE L8 and L16 Taguchi templates

• "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
Control Chart 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)
• Control Chart 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 - Bow Tie 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

Fix Control Limits added to Control Charts
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' Chart (p Prime), and Laney u' Chart (u Prime) are now also accessible from the Control Chart macro menu, in addition to the existing templates
• Fix Control Limits functionality added to QI Macros Chart Tools

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 Chart 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 Sigma Estimator for Cp and Cpk. Sbar/c4 and Rbar/d2 can still be used by changing the Sigma Estimator field.
• Added Standard Work template for Lean

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

• 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

Enhancement Archives