QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

Management By Control Chart

My career was dipped in various management methods such as MBO and MBWA. Recently I read a new term: Management by Spreadsheet (MBS). Maybe there’s a better way.

“When I was working at the phone company we had a variety of management fads. I think first there was MBO, or “Management By Objectives.” Of course, that assumed that you know what your objectives were. We had MBWA, “Management By Wandering Around,” so the management team was wandering around all the time and just getting in our way. Recently I saw a different phraseology and I kind of liked it: MBS, which stands for “Management By Spreadsheet.”

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

1/9/20 QI Macros Webinar

More than 50 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 new features introduced in recent releases 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 Templates Wizard, the Fixed Limit indicator or the automated Process Change Wizard), 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.

2020 New Year’s Resolution Part 2 – Improve

Many people take Six Sigma classes but only do one project. “One and Done” as it’s known in the trade. Make a resolution to start making improvements every month! Here are my suggestions.

“Hi, I’m Jay Arthur. It’s 2020, and last week I suggested that you go out and learn one new tool in the QI Macros every month. Now I’m also going to suggest that you set a New Year’s Resolution to make one improvement a month as well.

“Set a goal to do one improvement every month and by the end of the year, you’ll have made 12 improvements and dramatically reduced the amount of waste and rework and lost time and overtime and everything else that is involved in your world, right?

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

2020 New Years Resolution Part 1 – Learn One Tool Per Month

Many people tell us that they have QI Macros, but they don’t know how to use it. Make a resolution to learn how! Here are my suggestions.

“Hi, I’m Jay Arthur and… it’s 2020. How did that happen? A new year; a new decade. Seems like just yesterday everybody was worried about Y2K. Somebody out there is thinking, “What’s Y2K?” That was a thing that happened back in the year 2000… you probably forgot all about it, but I’ve been at this for over twenty years now in the software field around Quality Improvement, so I’ve seen a lot of things.

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

12/17/19 QI Macros Webinar

More than 100 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 new features introduced in recent releases 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 Templates Wizard or the automated Process Change Wizard), 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.

Agile Process Innovation Case Studies

What do Christus Health, Novartis and Underwriters Laboratories have in common? In the last few years they’ve rediscovered the essence of Agile Lean Six Sigma. Here’s How:

“Every year we go out to these conferences and trade shows and exhibit the QI Macros, and I get a chance to go see some of the presentations that people are doing. About two years ago I started to notice an interesting trend, and so I got some observations out of this whole thing.

“So about two years ago, I was at the Lean Six Sigma conference in Phoenix and Christus Health was presenting about their quality journey.

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

Control Charts for KPIs

Several attendees told me they had ripped out their line charts and started using Control Charts for their KPIs. Here’s why:

“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and the QI Macros [software].

“We were out at the National Association for Healthcare Quality conference; I was speaking and we were exhibiting there. After I spoke, I had a couple people come up to me who said they’d seen me at the previous year’s convention talking about how to improve things and how line [charts] and bar charts can be harming patients and they said, “You know, I went back to my hospital and we ripped out all of our line charts and we put in control charts for all of our key process indicators.

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

10/15/19 QI Macros Webinar

More than 50 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 new features introduced in recent releases 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 Process Change Wizard), 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.

How Six Sigma SPC Software Design Can Slash the Learning Curve

How you design software can slash the learning curve. Did you design it for college students studying statistics or a business man or woman who just wants to achieve a result with minimal time, effort and training?

“Hi, Jay Arthur with the QI Macros [software]. I wanted to talk to you today about Six Sigma SPC software.

“Now, there’s some big dogs out there, and if you look at them real closely, you’ll see they were designed by professors in the statistical department who wanted to create software to train students in statistics. It has every nook and cranny and option and tweak and everything that you can possibly do to teach people statistics, and fill up curriculums that’ll last an entire semester to focus on different things that you could do to tweak all these little statistics.

Posted by Jay Arthur in Improvement Insights, QI Macros, Statistics.

9/10/19 QI Macros Webinar

More than 35 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 new features introduced in recent versions 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.