QI Macros Blog by Jay Arthur
Blog

Latest "QI Macros" Posts

QI Macros Data Mining Wizard Demonstration

The Data Mining Wizard is one of the most powerful tools in QI Macros.

Watch this short video to as Jay demonstrates how easy it is to let the software analyze your data and automatically jumpstart your Quality Improvement projects:

Download a FREE 30 day trial at the link below and see for yourself how easy it is to use this powerful, affordable Quality Improvement tool: https://www.qimacros.com/trial/30-day/

Posted by Jay Arthur in Data Mining, QI Macros.

10/21/20 Healthcare Zero Harm / Trillion Dollar Prescription Webinar

Over 50 people signed up for this webinar, with Jay Arthur demonstrating how to achieve both the goal of “zero harm” as well as IHI’s goal of cutting healthcare waste by 50% by 2025.



https://www.qimacros.com/pdf/Zero-Harm-Trillion-Dollar-Prescription.pdf

  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. Send an email to support@qimacros.com and we can help, for instance in generating a quote to upgrade all the users at your organization or just guiding you through the purchasing process.

Posted by Jay Arthur in healthcare, QI Macros.

Accelerating Software Quality Using the 4-50 Rule

Leaders, managers and programmers sometimes get frustrated with software systems and try to rewrite them. This usually fails. It is possible to use Six Sigma and the 4-50 rule to find and fix the few code modules that have the most bugs and require the most enhancements. This delivers software quality without the high cost and risk. Here’s how:



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

“Today I want to talk to you about software. Now, some of you may work in software, some of you may use software… (If you have a phone, you’re using software) There’s lots of software around, and sometimes there’s bugs and stuff like that, and sometimes we’re enhancing things.

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

QI Macros for Healthcare

You don’t practice medicine the way they did 100 years ago.
Why are you implementing Quality Improvement strategies from 100 years ago?

21st Century Quality Improvement needs to be accelerated; fast, responsive and effective. QI Macros for Excel is the easiest to learn, the easiest to use, and the most affordable SPC software to implement across your entire organization.

Watch this short video to see how easy it is to accelerate your Quality Improvement:



Download a FREE 30 day trial at the link below and see for yourself how easy it is to use this powerful, affordable Quality Improvement tool:
https://www.qimacros.com/trial/30-day/

Posted by Jay Arthur in QI Macros.

COVID-19 Cases by Type of Facility

The New York Times published a list of cases by facility. I tweaked it to get Pareto Charts of the biggest problems. Nursing homes and rehab facilities were 64% of the total, then prisons and food processing (e.g., beef, pork, poultry, etc.).

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

The Cost of Lean Six Sigma Training

Traditional Lean Six Sigma Training takes weeks when it’s possible to train people and get results in one day. Here’s why it costs so much to train people using last century strategies:

“I want to talk to you about the economics of a Six Sigma class.  All right, so as much as I hate pie charts, I’m going to use one to demonstrate this.  Let’s say you have a classroom and let’s say you have 20 odd people or something go in there.  Now, I can tell you in advance every class is filled with three types of people:  Prisoners, Vacationers and Learners. 

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

How to 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.

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.

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.

How Long Should Lean Six Sigma Projects Take?

Should a project take 4-16 months or 4-16 hours? Should you measure projects with a calendar or a stopwatch? I think the answer is obvious, but here’s my take on it.

“Hi, I’m Jay Arthur. Every year, we exhibit at lots of conferences with QI Macros so I get to go to presentations by all kinds of folks. Now, last year I saw a presentation by some consultants who said they’d done some research into how long Six Sigma projects take. They found Six Sigma projects take anywhere from four months to 16 months.

“I [thought], “What? How’s that possible?” That makes no sense to me, because I’ve done multimillion-dollar projects in between 4 and 16 hours.

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