Upgrade to QI Macros 2023

• Multinomial Logistic Regression added to our Logistic Regression macro found in our collection of Statistical Tools.
• Binomial Logistic Regression added to our Logistic Regression macro found in our collection of Statistical Tools.
• Bollinger Bands Chart added to our collection of Control Chart macros.
• Insert Table without Formatting added to our collection of Restacking tools.

• MANOVA One-Way macro added to our collection of Statistical Tools.
• 30-60-90 Day Action Plan added to the Action Plan template.
• RACI template added to the SWOT template.
• Driver Matrix has been added to the Tree Matrix template.
• Tolerance Limits added to the "Descriptive Statistics – Normality Test" macro.
• All Center Lines for Control Chart macro-output are now dashed, instead of solid.
• A North Star Metric can be created using the CTQ Tree Diagram template.
• A Titration Curve Chart can be created using the Scatter Diagram.
• Action Priority Table added to the AP for DFMEA PFMEA report in the FMEA 5th template.

• XmR multiple column option added to the XmR Chart macro.
If more than (1) column of data is selected and the XmR macro is run, output will automatically create multiple XmR Charts.


• Binomial Capability Analysis and Poisson Capability Analysis added to the Capability Templates functionality.
• One Way ANOVA and Two Way ANOVA outputs now include Values Plots instead of Box and Whisker Plots.
• The Box and Whisker macro-output now automatically adds the Median value to each box.

• Historical Variation added to AIAG MSA 4th Gage R&R template.
• Replace Zeros with Blanks macro added to Restacking functionality.
• Variance Inflation Factor (VIF) output added to Multiple Regression output - requires a minimum of 4 columns of data and a maximum of 8 columns of data.

Highlights

• Included a "Remove" option to the Process Change and Ghost Point functionality.
• Random Sample Generator added to Restacking Tools.
• Variance-Test: one-sample added to Statistical Tools.

• AutoCorrelation added to Statistical Tools.
• XmR Autocorrelated added to Control Charts.
• Logistic Regression (Binary) added to Statistical Tools.
• "Healthcare Self-Paced Workshop" and "Manufacturing Self-Paced Workshop" added to the "QI Macros Help" section of the software.
• Step Plots added to the Standard Work Service and Standard Work Operation Time templates. This helps provide end users with a visual representation of the total amount of time for all used Work Elements.
• An Equivalence Plot added to the Equivalence (TOST) Test output, while the Box & Whisker plot has been removed. A Box & Whisker plot can be a bit confusing and unnecessary since we utilize a Values Plot to visually represent the end user's data.
• Values Plots added to all two-sample t-Tests outputs, and to the z-Test output. This provides end users with a cleaner and easier way to understand the visual representation of their data.
• Friedman Test added to the Stat Templates drop-down menu.

• Show/Hide Rule Numbers now provides end user with Control Chart Rule descriptions.
• 5.15 Constant option added to Gage R&R MSA 4th, Gage R&R 30-Parts, and Gage R&R Type 3 templates.
• Honest Gage R&R output added to Gage R&R MSA 4th and Gage R&R 30-Parts templates.
• Mood's Median Test added to our list of Non-Parametric Statistical templates.
• Turtle Diagram added to the Hazard Analysis template.
• Revamped Process Change and Fixed Control Limits functionality to the I-MR-R Rolling template.
• Null Hypothesis verbiage updated to:
  - Cannot Reject Null Hypothesis/Reject Null Hypothesis
  - Means or Variances are not Different/Means or Variances are Different

• Automated Value Stream Map template updated to now allow up to 108 Steps/Processes.
• Revamped Process Change and Fixed Control Limits functionality to c, np, p, u, XbarR, and XmR Rolling templates.
• ANCOVA template test added to ANOVA tests.
• Effect Size and Cohen's d Calculators added to tTest Equal Variances, tTest Unequal Variances, and tTest Paired Two Sample templates.

Highlights

• Revamped Delete Point functionality.

• The QI Macros Control Chart Wizard now provides end users with a Control Chart Template in their wizard output.
  
  This is intended to provide the option to use a template, should end users have ongoing projects and wish to continually add data to their Control Charts.

• Show Process Change and Fix Control Limit functionality now available within c, np, p and u Dashboards.
• Miscellaneous updates made to Improvement Project Wizard.
• Updated code in XbarS 500 Skyline and XmedianS 500 templates that now allow Stability Analysis, Fix Control Limit and Show Process Change functionality.
• Updated Gage R&R MSA 4th 30 Part and Type 3 templates to include Box & Whisker output.
• Updated calculation prompts in ANOVA Two Factor with Replication and without Replication.

• XmR Multi-Column Chart: When multiple columns of data are selected, and the XmR (Individuals) macro is run, multiple data series are plotted on a single chart.
• Stack Columns with Blank Rows functionality added to the Restacking tool.
• XbarS 500 Skyline and XmedianS 500 templates added to the XbarS template package.
• Data Mining Wizard renamed and packaged as "Improvement Project Wizard."

Highlights

• Filter/Unfilter Chart functionality added

• Revisions to FMEA 5th Edition Templates (AIAG & VDA FMEA 1st Edition)
• Reset Skyline Limits functionality added

• 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 ("Select Data for Point")

• 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 XbarR and XmR 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 and XmR 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

Enhancement Archives