Lean Six Sigma Moneybelt - Page 34 of 60

Improvement Insights Blog

Latest Posts

Colorado COVID-19 Cases and Deaths in Control Charts

While most COVID-19 charts show cumulative cases and deaths, I wondered what would happen if we turned the cumulative data into a daily data and plotted it as a control chart. It is possible to use c or XmR charts for this purpose. Process changes chosen based on runs and trends in the data.

co covid cases c chart

Daily new cases still unstable, but hovering around 339/day. Cases began to rise 3/18. Potentially leveling off 3/26. the date of state “stay-at-home” order.

  co covid cases c chart

Daily deaths still unstable, but hovering around 12/day. Deaths began rising 3/21, but appear to be stabilizing.  Significant spike on 4/2, root cause unknown.

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

4/9/20 QI Macros Webinar

More than 40 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.

IHI Trillion Dollar Checkbook Webinar, 3 of 3

Webinar 3 of 3: April 8, 2020 More than 40 people signed up for this webinar, with Jay Arthur first doing an overview on the IHI’s goal, and then going into more detail and highlighting examples on how implementing Agile Lean Six Sigma can speed an organization’s improvement process and better sustain results.



Posted by Jay Arthur in Agile Lean Six Sigma, Data Mining, Healthcare, Webinar.

Work ON your business, not IN it.

COVID-19 has slowed business for much of the nation. Here’s how you can make use of the time:

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

“I don’t know about you, but with this COVID virus thing going around, business has slowed a little bit, but that’s great! That gives us an opportunity to start to focus and work ON our business, not IN our business. Now is the time to start to find ways to simplify, streamline, optimize everything that you do so that when things come back on you’ll be ready for it and you’ll be faster, better, cheaper than you ever were before.

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

An improvement project, delivered…


pizza-4457006_640 560x371.jpg

I can’t recall a time when I’ve done so many improvement projects in such a short time.

In just three short weeks, I’ve rearranged my kitchen to a more efficient layout that saves steps when I’m preparing a meal (after creating a spaghetti diagram of the food preparation process), I’ve reorganized the spices located on the rack on the counter as well as in the cupboard (moving away from a strict alphabetization plan to a two-tiered system based on usage, where the most-used spices are stored in the rack on the counter and the less-frequently-used spices are stored in the cupboard).

Posted by Jay Arthur in QI Macros Monthly Newsletters.

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.

What do we do? Do what you do.

These are uncertain times. What’s the best way (both psychologically and as a group) to get though this? By you continuing to do what you do, whether it’s writing, coding, or continuing to improve the quality of the processes around you.

(And just to be clear, when I say, “Go out and do what you do,” I don’t mean to literally “go out” if you don’t have to… it’s just an expression. Please continue to take whatever steps are necessary to keep yourself and the people around you safe.)

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

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