Softpedia >Mac >Business >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 29, 2023)

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

New in QI Macros 2023.07 (Jun 30, 2023)

  • 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 6, 2023)

  • 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 3, 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 - requies 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 1, 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 5, 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 2022.01 (Jan 21, 2022)

  • Automated Value Stream Map: https://www.qimacros.com/quality-tools/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: https://www.qimacros.com/control-chart/control-chart-rolling-templates/ .
  • ANCOVA template test added to ANOVA tests.
  • Cohen's D Calculation added to tTest Equal Variances, tTest Unequal Variances, and tTest Paired Two Sample templates.

New in QI Macros 2021.10 (Oct 7, 2021)

  • Revamped Delete Point functionality

New in QI Macros 2021.07 (Jul 2, 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.04 (Apr 2, 2021)

  • Version currently available - list of enhancements coming soon!

New in QI Macros 2021.01 (Feb 16, 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 (Feb 16, 2021)

  • Filter/Unfilter Chart functionality added

New in QI Macros 2020.07 (Feb 16, 2021)

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

New in QI Macros 2020.01 (Feb 16, 2021)

  • 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 (Feb 16, 2021)

  • 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 (Feb 16, 2021)

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

New in QI Macros 2017.07 (Feb 16, 2021)

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

New in QI Macros 2016.09 (Feb 16, 2021)

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

New in QI Macros 2016.08 (Sep 19, 2016)

  • Excel 2016, Office 365 compatible
  • Data Mining Wizard creates a pivot table, generates an XmR chart and defect Paretos
  • 3 Legged 5 Whys Template, Short Run Control Charts
  • Enhanced Gantt Chart
  • Sample Size Calculator
  • Pooled Standard Deviation now the default estimator for Cp Cpk

New in QI Macros 2015.09 (Sep 7, 2015)

  • Expanded Gantt Chart to accommodate more data.

New in QI Macros 2015.05 (May 19, 2015)

  • 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 3, 2015)

  • Added Descriptive Statistics Histogram under Capability Charts

New in QI Macros 2015.01 (Jan 6, 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 (Oct 9, 2014)

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

New in QI Macros 2014.09 (Oct 9, 2014)

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

New in QI Macros 2014.08 (Aug 14, 2014)

  • 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