Home »
Blog » QI Macros » Page 14
Improvement Insights Blog
Latest "QI Macros" Posts
More than 60 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.
Continue Reading "3/10/20 QI Macros Webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
Sometimes you’ll hear people say that software isn’t necessary for Quality Improvement. Let me demonstrate how much time you’re wasting if you create ONE Pareto chart by hand, instead of using software.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and the QI Macros [software].
“If you’ve listened to any of my Insight videos or seen me present at conferences or [had me] train you in a workshop, you know that I don’t believe you can do Quality Improvement without software. We have to stop doing Quality Improvement the 20th century manual, slow way. We have to start doing it the 21st century way, and we have to start doing it quickly.
Continue Reading "Making Pareto Charts by Hand?"
Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights, QI Macros.
At the ASQ Lean Six Sigma Conference in Phoenix this week, Katie Castree with Accumen presented an excellent improvement story about reducing over-collection of blood tubes in a hospital. Here’s the story:
Baseline: 317 extra tubes of blood collected every day (115,705/year)

93% of tubes were not used (clinicians thought it was much higher and resisted changing)

Most of the unused tubes were collected in the Emergency Department (focus on the ED, not the entire hospital).

After the countermeasure (not collecting tubes unnecessarily), extra tubes dropped from 317 per day to 118 per day saving $12,335/year and 0.27 FTEs. Over time, extra tubes dropped to only 84 per day, a 74% reduction.
Continue Reading "Reducing Blood Sample Over-Collection"
Posted by Jay Arthur in Agile Lean Six Sigma, Healthcare, Jay Arthur Blog, QI Macros, Six Sigma.
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.
Continue Reading "2/11/20 QI Macros Webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
How big is your Fix-it Factory?
“I talked to a contractor at a building site and he told me, “I get paid to do it the first time, but I don’t get paid to do it the second time (to rework things),” so he’s very much focused on doing it right the first time.
“I think we’d all say that, but if you look at most companies, they all have a giant Fix-it Factory, fixing this, that and the other thing. Those people are being paid to fix things that shouldn’t have been broken to begin with. Or to trash the things they can’t fix.
Continue Reading "I Only Get Paid to Do It the First Time"
Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights, Lean, QI Macros.
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.”
Continue Reading "Management By Control Chart"
Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights, Lean, QI Macros, Six Sigma.
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.
Continue Reading "1/9/20 QI Macros Webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
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?
Continue Reading "2020 New Year’s Resolution Part 2 – Improve"
Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma.
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.
Continue Reading "2020 New Years Resolution Part 1 – Learn One Tool Per Month"
Posted by Jay Arthur in Improvement Insights, Lean, QI Macros, Six Sigma.
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.
Continue Reading "12/17/19 QI Macros Webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.