Softpedia >Windows >Office tools >Other Office Tools >QI Macros >  Changelog

QI Macros Changelog

What's new in QI Macros 2024.04

Apr 2, 2024
  • 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.

New in QI Macros 2024.01 (Dec 29, 2023)

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

New in QI Macros 2023.10 (Sep 28, 2023)

  • Multinomial Logistic Regression.
  • Binomial Logistic Regression.
  • Bollinger Bands Chart.
  • Insert Table without Formatting.

New in QI Macros 2023.07 (Jun 30, 2023)

  • What's new in QI Macros 2023.07:
  • 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.

New in QI Macros 2023.04 (Apr 7, 2023)

  • New Charts, Templates and Tools
  • New Features to Save You Time
  • Updates to be consistent with industry standards like the AIAG, Joint Commission on Healthcare, IHI etc.
  • Updates to remain compatible with the latest Microsoft Windows and Excel updates
  • 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.

New in QI Macros 2023.01 (Jan 5, 2023)

  • 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 Regression output - requires a minimum of 4 columns of data and a maximum of 8 columns of data.

New in QI Macros 2022.10 (Oct 6, 2022)

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

New in QI Macros 2022.07 (Jul 10, 2022)

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

New in QI Macros 2022.04 (Apr 2, 2022)

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

New in QI Macros 2021.10 (Oct 3, 2021)

  • Revamped Delete Point functionality

New in QI Macros 2021.7 (Aug 18, 2021)

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

New in QI Macros 2021.1 (Jan 5, 2021)

  • Stack Columns with Blank Rows functionality added to the Restacking tool.
  • XbarS 500 Skyline and XmedianS 500 templates added to the XbarS template package.

New in QI Macros 2020.10 (Oct 2, 2020)

  • Filter/Unfilter Chart functionality added

New in QI Macros 2020.07 (Jul 8, 2020)

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

New in QI Macros 2020.01 (Jan 1, 2020)

  • Remember and Apply Custom Chart Format added
  • Weighted Pareto Chart Template
  • Quadrant Bubble Template and Macro added
  • Quadrant Scatter Template and Macro added

New in QI Macros 2018 (Jan 18, 2018)

  • New Charts, Templates and Tools
  • New Features to Save You Time
  • Updates to be consistent with industry standards like the AIAG, Joint Commission on Healthcare and IHI
  • Updates to remain compatible with the latest Microsoft Windows and Excel updates

New in QI Macros 2017.10 (Oct 18, 2017)

  • Improved visibility and accessibility to the QI Macros chart menu functions

New in QI Macros 2017.07 (Sep 24, 2017)

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

New in QI Macros 2016.09 (Sep 21, 2016)

  • Pass - Fail Cp Cpk calculator added to Capability Templates.

New in QI Macros 2016.08 (Sep 21, 2016)

  • Fever Chart added to Diagrams.
  • Frequency Polygon added to Compare 2 Histograms template.

New in QI Macros 2016.07 (Sep 21, 2016)

  • Test data is now accessible from the QI Macros help menu.

New in QI Macros 2016.05 (Sep 21, 2016)

  • Added OEE template to the Rolled Throughput Yield Calculator.

New in QI Macros 2016.02 (Sep 21, 2016)

  • Data Mining Wizard creates a pivot table of data, and generates an XmR chart and defect Paretos.
  • Legged 5 Whys Template.
  • Short Run Control Chart templates consolidated in one file.

New in QI Macros 2015.11 (Sep 21, 2016)

  • Sample Size Calculator expanded; separate calculators for attribute data and variable data.

New in QI Macros 2015.10 (Sep 21, 2016)

  • Compatible with Excel 2016 for Mac and PC.

New in QI Macros 2015.09 (Sep 21, 2016)

  • Expanded Gantt Chart to accommodate more data.

New in QI Macros 2015.05 (Sep 21, 2016)

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

New in QI Macros 2015.02 (Feb 24, 2015)

  • Added Descriptive Statistics Histogram under Capability Charts

New in QI Macros 2015.01 (Feb 24, 2015)

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

New in QI Macros 2014.10 (Feb 24, 2015)

  • Histogram Weibull Template now handles censored data (parts that didn't fail)

New in QI Macros 2014.09 (Feb 24, 2015)

  • Added Taguchi Loss and Cp Cpk PPM worksheets to DPMO Calculator

New in QI Macros 2014.08 (Feb 24, 2015)

  • 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

New in QI Macros 2014.07 (Feb 24, 2015)

  • Wheeler Moving Average & Range template
  • 3D Histogram Comparison Chart

New in QI Macros 2014.06 (Feb 24, 2015)

  • Control Chart templates automatically copy down formulas to accommodate additional data
  • New menu layout