QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

COVID-19 Paramedic Dashboard 2020

One of our QI Macros users offered to share his dashboard of paramedic response during the Seattle area response to COVID-19. His team transported the first COVID patient in America. As you can see, turnaround times (TAT) at the hospital averaged 30 minutes and temperatures spiked in transported patients.

covid paramedic dashboard 2020

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

How Crisis Affects U.S. Healthcare Workers

Back in 2002, thousands of miles from New York City, I worked with a hospital in Oregon. I was amazed to find that they had staffing data from 9/11 about the up and down for that month. As you can see in this X Chart, absenteeism (understaffing) was lower for each of the four following days, 9/12-15, and then recovered. I have noticed this pattern with COVID-19 as well: a week of paralysis followed by a return to normal. Unfortunately, healthcare workers haven’t had the luxury of downtime when dealing with the new crisis.
2001 hospital staffing downturn

So don’t be surprised if crisis and uncertainty cause you or someone you know to hit the pause button.

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

The Economy is Sick

If you’ve ever been sick, you know that the only thing you can do is wait it out. Here’s what we’re going to have to do:

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

“I know all of you have had some sort of cold or flu or been sick for a while. The day before Thanksgiving in 2014, I had this really heavy cough that came from the darkest recesses of my lungs and I said, “That’s not good.” Then I felt a little worse on Thursday, and on Friday I was diagnosed as having the flu.

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

Learn Data Analysis for Problem Solving

Out of Work? Need a job? Want to become indispensable to your employer?

Learn the data analysis skills for problem solving (a.k.a. Lean Six Sigma). Do it now. It’s Free!

Click here to get started: www.lssyb.com

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

“I don’t know about you, but right now, I’m staying home because of the directives around COVID-19. I know there’s a lot of people out there who have been displaced and are out of work, and now might be a good time to learn a new skill. I can tell you: being able to do some data analysis that results in problem solving is a skill that every, every, every business wants.

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

3/10/20 QI Macros Webinar

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.

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

Making Pareto Charts by Hand?

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.

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

Reducing Blood Sample Over-Collection

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)

extrat tubes baseline

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

not used percentage

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

extrat tubes pareto

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.

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

2/11/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.

I Only Get Paid to Do It the First Time

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.

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

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.