QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

QI Macros Version 2018.10

We’re excited! From adding Menu Icons to make things easier to find (and easier to add to your Excel Quick Access Toolbar), to adding a Search function to answer those “Where is that one chart…” questions, to the Control Chart Template Wizard… we think this is the most powerful, easiest to use version of QI Macros that there is.

This version is compatible with:

  • PC operating systems Windows 10, Windows 8.1, Windows 7
  • PCs running Excel 365, Excel 2019, Excel 2016, Excel 2013 and Excel 2010
  • Mac operating systems Mojave (MacOS 10.14), High Sierra(MacOS 10.13), Sierra (MacOS 10.12), El Capitan (MacOS 10.11) or Yosemite (MacOS 10.10)
  • Mac machines running Excel for Mac 365 or Excel for Mac 2016

 

If you’d like to upgrade to QI Macros 2018.10, you can purchase a new license by clicking HERE.

Posted by Jay Arthur in Jay Arthur Blog, QI Macros.

9/13/18 QI Macros Webinar

Almost 100 people signed up for this webinar, with Jay Arthur demonstrating some of the more useful features of QI Macros.

Some of the attendees were familiar with the software and already use it, some had not yet begun to use it; all were interested in learning new ways that QI Macros can help them with their Agile Lean Six Sigma and Quality Improvement efforts. (You can hear him answering questions typed in by webinar attendees.)



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

Electrical Outages Improvement Story

Jeremy Singer-Vine publishes a Data Is Plural newsletter about available data sets. I took the U.S. & Canada power outage data from 2018 and used it with QI Macros Data Mining Wizard to create an improvement project.

I used a g Chart of time between power outages. Averaging a little over 3 days between outages.

days between power outages

Then, the Data Mining Wizard found the most common cause of outages to be weather. But look at number two: operations. That’s something that could be fixed. Vandalism could also be prevented.

power outages by event

Next, where are outages most likely to occur:

power outages by region

And what month? Readiness months: March-July.

Posted by Jay Arthur in Data Mining, Jay Arthur Blog, QI Macros, Six Sigma.

Building Rapport with Improvement Teams – Step 3

A district level manager was hopping mad about something. I decided to see if I could use pacing and leading to calm her down and get back to solving the problem to meet her needs.

Posted by Jay Arthur in Healthcare, Improvement Insights, Lean, Manufacturing, QI Macros, Service, Six Sigma.

Building Rapport with Improvement Teams – Step 2

My boss sent me to talk to a cranky manager about a software project he wanted to do. Here’s how I used non-verbal rapport to connect with him in 30-60 seconds.

Posted by Jay Arthur in Healthcare, Improvement Insights, Lean, Manufacturing, QI Macros, Service, Six Sigma.

Hassle America – Bethenny Frankel

The September, 2018 Money magazine article about Bethenny Frankel opens with a rant about Postmates. Frankel ordered a muffin, bagel with cream cheese and a coffee for delivery. The muffin and bagel made it, but without cream cheese or coffee.

Welcome to Hassle America where even simple things seem to be impossible.

We order lunch once a week at the office, but hardly a week goes by without some problem. Last week, Grubhub cancelled our order without telling us. Some weeks the chicken salad comes without chicken. Some weeks we’re missing a dish that was ordered.

Welcome to Hassle America.

Posted by Jay Arthur in QI Macros, Six Sigma.

Mistake-Proofing With Video Learning

I recently had to do some home repairs. It’s amazing what you can learn in a 3-minute video and how much time it will save you. The same is true of Lean Six Sigma. Save yourself time and rework. Learn the easy way.

Sign up for my weekly insight videos at: https://www.qimacros.com/free-resources/newsletter/

mistake proof video learning image

Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma.

8/14/18 QI Macros Webinar

Another great webinar where Jay Arthur shows some of the capabilities of QI Macros to a group of folks who signed up and attended.

Some were familiar with the software and already use it, and some had not yet begun to use it; all were interested in learning new ways that QI Macros can help them with their Quality Improvement efforts. (You can hear him answering questions typed in by webinar attendees.)



If you saw a feature demonstrated in the webinar that might have been added to QI Macros after the version you’re using (for instance, the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.

Mythical Man Month – Conceptual Integrity

Designing a product or service requires conceptual integrity. Here’s how I did it.

Posted by Jay Arthur in Improvement Insights, QI Macros.

Building Rapport with Improvement Teams – Step 5

How can we use the same language as our team members to develop rapport and accelerate the team’s success?

Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma.