QI Macros – Page 24 – Lean Six Sigma Moneybelt

Improvement Insights Blog

Posts tagged "QI Macros"

Root Cause Analysis in the Time of COVID-19

That's root cause analysis: What are the common patterns? Where's the Pareto principle?

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

Let’s Work Together

This is a fun thing we did last week. While Watching the movie “Forrest Gump,” Jay heard this song and had the idea that this song is particularly applicable to our current situation. Several of the people that work for QI Macros are musicians, so we tried to do something fun while we’re working remotely. This was recorded in 4 separate homes and then assembled and arranged by Nicholas. We hope you enjoy it:

Posted by Jay Arthur in Jay Arthur Blog.

FOLB – Fear of Looking Bad

Humans, by nature, have a fear of looking bad (FOLB). And we have a fear of looking stupid (FOLS). These are slowing COVID-19 response and quality improvement. Here’s why:

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

“You’ve all probably all heard some of these acronyms that are running around like FOMO: Fear Of Missing Out. Well, I wanted to introduce you to a couple more that I’d like you to consider. FOLB: Fear Of Looking Bad.

“Now when I’ve gone out to work with companies in consulting roles, some of these managers think, “I’m supposed to be in charge of fixing everything.

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

5/14/20 QI Macros Webinar

Over 120 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.

Stop Projecting the Past Into the Future

If COVID-19 has taught us anything, it’s that we can’t keep doing things the same old way. The status quo isn’t working for us anymore. We have to stop projecting the past (the way we’ve always done it) into the future. The future doesn’t have to be an endless rerun of the past.

“Hi, I’m Jay Arthur, author of “Agile Process Innovation” and QI Macros [software]. Here’s my Improvement Insight for this week: Stop projecting your past into your future.

“Way too many people do this, right? We start thinking, “Well, we’ve always done it that way so we have to always do it that way.”

Posted by Jay Arthur in Improvement Insights.

Create a COVID-19 Control Chart Using QI Macros

Control charts offer a promising way to analyze COVID-19 Data. Learn where to get the data, how to mine it and how to chart it in this video.

Posted by Jay Arthur in Ask Jay, Data Mining, QI Macros, Six Sigma.

U.S. Deaths by Age Group as of 4/24/2020

People over age 55 account for 92% of COVID-19 Deaths (data from CDC). Sweden is using similar data to leave the country open for most citizens while asking seniors to stay at home. How do we reopen the economy? Self-quarantine seniors; let everyone else get back to work.

us covid deaths by age group 65 plus

Here’s the 2019-2020 Influenza (i.e., Flu) deaths. Again, seniors are 83.5% of deaths. The flu death rate is about 1 per 1,000. COVID-19 death rate is 1-2 per 100, perhaps lower in people under the age of 55 and higher for those over age 55.

Countermeasure: Self-quarantining seniors will help flatten the curve and prevent overwhelming healthcare.

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

Lean Response to COVID-19

We know that Lean can collapse cycle time by 75% or more. Here’s what that means for COVID-19:

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

“If you’ve ever done any Lean projects, you know pretty much if the process is this long {gestures}, with Value Stream Mapping and Spaghetti Diagramming, you can collapse that by maybe 75%, 80%, 90%. You can actually reduce the cycle time for almost anything and do it easily.

“One of the things that is creating optimism for me is that a few years ago I worked with an aerospace manufacturing company, and typically to get a Request For Proposal through, it was 1.9 years for any new part.

Posted by Jay Arthur in Healthcare, Improvement Insights, Lean.

Colorado Deaths by Age Group

Since 90% of deaths are among those over 60, perhaps the best countermeasure is to require those of us over 60 (me for example) to stay home. Most of us are retired anyway. Let others go back to work.

Approximately 51% of Colorado hospitalizations involve people 60-80+, 75% of people over 50. Another reason to ask seniors like myself to stay at home even as the economy reopens. This will help reduce the load on hospitals.

Posted by Jay Arthur in QI Macros, Six Sigma.

Cholera and COVID-19 Hot Spot Detection and Quarantine

There are COVID-19 hot spots and cold spots. How do we keep the cold spots open and detect and quarantine warming spots? Maybe statistical process control can help.

  denver covid case rate

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

“Back in the mid 1800s there was a cholera outbreak in London, and John Snow (not of Game of Thrones, but Dr. John Snow) said, “I think there’s a pattern here.” He went out and figured out that everybody who had cholera was getting water from the Broad Street pump. Back then, there was no indoor running water so you had to take your pail, go out to the pump and get your water for your home or your business or your restaurant.

Posted by Jay Arthur in Improvement Insights, Six Sigma.