QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

Have Your Processes Turned Into Frankenprocesses?

Here’s how to deal with the creature you’ve created.

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

Tell a Friend About QI Macros

If you appreciate how much QI Macros helps you, please tell a friend about the software! Why? Honestly, it’s because we we want to live in a world where more things are done right the FIRST time. Can you imagine:

  • … a world where you don’t have to check your takeout order at the restaurant because it’s correct every single time?
  • … a healthcare system where an incorrect diagnosis happens only once every 2,000,000 patients?
  • … buying a car and knowing that the chance of any defect on the car in the first 10 years is one in 5,000,000?

That’s a world where Quality Improvement is embraced and celebrated.

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

10/9/18 QI Macros Webinar

Over 90 people signed up for this webinar, with Jay Arthur demonstrating how to use some of the useful features of QI Macros, as well as some of the brand new features introduced in the October 2018 version of the software.

Some attendees were familiar with the software and already use it, some had only 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 and comments 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 “Find Tool” search feature or 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.

Run Charts vs Control Charts

Run charts used to be a bridge to control charts. You no longer need to build a bridge. Just start with Control Charts.

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

Excellence Imperative

20th Century quality was about manufacturing. (Old school)

21st Century quality is about services. (New school)

What we need now is a fresh approach to Lean Six Sigma for the 21st Century. I call it Agile Process Innovation.

Download my free Agile Process Innovation ebook from https://www.qimacros.com/pdf/Agile-Lean-Six-Sigma.pdf.

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

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.