QI Macros Enhancements - What Are You Missing?

• Audit Plan Template added to our Planning & PM Tools.
• Modified Z-Score Template added to our Outlier Tests.
• Transfer Function added to the Full Factorial, Fractional Factorial 8-run, and Fractional Factorial 16-run DOE templates.
• Calculated Percentiles added to the Descriptive Statistics and Data Transformations outputs.
• A "Simplified A3 Report" added to the A3 Report Template.
• R-Squared and R-Squared Adjusted outputs added to the ANOVA Single Factor output, along with all DOE Templates (except for Taguchi L9).

Highlights

• Nested Gage R&R template added to the MSA 4th Gage R&R.
• Taguchi L9 and L12 templates added to the Design of Experiments.
• "Find QI Macros Sample Data" functionality added.
• Fleiss' Kappa Statistics outputs added to the Attribute Gage Worksheet.
• Enhancements made to the Gantt Template.
• Updated outputs made to the KANO Model template.
• "Convert to Percent" macro added to select p Chart and u Chart templates.

• Johnson Transformation added to Statistical Tools.
• Crow-AMSAA added to Statistical Tools.
• Change-color macro added to the Gantt Template.
• Anderson Darling Normality Test added to the XmR & XbarR Capability Suites.

Highlights

• Deming Orthogonal Regression option added to Statistical Tools.
• "Expanded" template option added to Lean Scorecard.
• Improvements made to Process Change Wizard code.

• LogNormal Data Transformation added to Statistical Tools.
• Histograms, Box Plots, Confidence Intervals, Tolerance Limits, and Probability Plots added to the Box Cox and Yeo-Johnson Data Transformation outputs.
• "Select Chart Point from Data Cells" functionality added to all Control Chart outputs.
• Updates made to the Process Change Wizard.
• Updates made to all Rolling Templates and Rolling Dashboard Templates.
• 2024 Uncertainty worksheet and Decision Risk template added to the Uncertainty Template.

• Add UCL-CL-LCL Labels to a Point macro added to Chart Menu options.
• APQP 3rd Edition and Control Plan 1st Edition templates added to APQP and Control Plan 2nd Edition templates.
• Dixon's Q Test added to Statistical Templates.
• Grubbs' Outlier Test added to Statistical Templates.
• Equivalence (TOST) Test - Paired Data added to Statistical Tools.
• Nelson Rule for Moving Range (XmR Charts) Toggle On/Off added to Control Chart Rules.
• Values/Variation Plot will now ask end users to group data by Columns or Rows.

• Contour Plots added to the DOE (Design of Experiments) Full Factorial, Fractional Factorial 8-Run, and Fractional Factorial 16-Run templates.
• Heijunka Board template added to the "Lean Takt Time - NVA" template.
• Weighted Risk Matrix template added to the "Hazard Analysis - Bow Tie Risk Assessment" template.
• 5S Scorecard and 5S Cleaning Assessment templates added to the "Lean Scorecard" template.
• Variation Plot added to the Values Plot macro output.
• Descriptive Statistics enhancement added to the Stat Wizard when 3+ columns of data are selected.

Highlights

• 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 Plot 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 and Whisker Plot has been removed. A Box and 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 t-Test Equal Variances, t-Test Unequal Variances, and t-Test Paired Two Sample templates.

Enhancement Archives