QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

Automating Decision Trees to Collapse The Control Chart Learning Curve

Words like “variable” and “attribute” confuse new students of quality improvement. But they need to know that to choose the right control chart using a decision tree don’t they? Not if you automate chart selection for them. Here’s how I did it:



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

“I don’t know about the rest of you, but I got started back in 1990, and that’s when I learned about control charts. Then I started trying to teach people about control charts… guess what? You start talking about ‘variable’ and ‘attribute’ and ‘sample sizes’ and you can watch everybody’s eyes slowly glaze over; it’s just fascinating to watch.

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

1/18/22 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 to generate a quote to upgrade all the users at your organization or by just guiding you through the purchasing process.

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

1/11/22 QI Macros Webinar

Over 70 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by attendees. 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 Improvement Project Wizard 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.

You Don’t Need to Know Statistics to Do Statistical Process Control (SPC)

People think you have to know statistics to do Statistical Process Control (SPC). Not true, here’s why.



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

“I’ve noticed that whenever I say the phrase “Statistical Process Control,” people start to freak out. It’s unnecessary because guess what? You don’t need to know statistics to do Statistical Process Control.

“Shewhart was a statistician, he figured out how to calculate the variances and… how to calculate the upper and lower control limits and what that all means. Then Nelson expanded all of that stuff, so the statisticians did the statistical part.

Posted by Jay Arthur in Improvement Insights, QI Macros.

Be A Process Doctor

Medical doctors (M.D.) help people heal. In Lean Six Sigma, we help companies heal. Be a Process Doctor(P.D.).



“Medical doctors diagnose and then treat patients. I think of myself as a Process Doctor: a P.D.; not an M.D., a P.D. I work with companies and I try and figure out why their systems are not working the way they ought to and remove blockages to speed things up. You know, get the electrical systems working better. It’s the same idea. So I think you and I are all Process Doctors.

“Now, I think the metaphor about this is great because we’re in the helping profession and we help things get better and stay better; stay healthy, just like a medical doctor.

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

12/14/21 Healthcare Zero Harm / Trillion Dollar Prescription Webinar

Over 70 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 to generate a quote to upgrade all the users at your organization or by just guiding you through the purchasing process.

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

My Apple Tree Reminded Me About Low-Hanging Fruit

My apple tree had hundreds of apples this year. I invited people to pick some and leave some. Soon, all of the low-hanging fruit was picked, but there were still hundreds of apples in the three. Maybe you need a fruit picker to get to the rest of the fruit in your company.



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

“We have an apple tree in our front yard (I think it’s Jonathan apples), and this year in an unusual fit of luck, we got a giant crop. I bet we had a thousand apples on that tree.

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

12/7/21 QI Macros Webinar

Over 100 people signed up for this webinar, with Jay Arthur demonstrating some of the software’s most frequently used tools and answering questions asked by attendees.

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 Improvement Project Wizard 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.

Use Technology to Lock In Quality Improvements

People are error prone. If you want to lock in improvements, use your existing technology to mistake-proof the change. Here’s how:



“I was working with one group of folks in a hospital, and they were complaining about the fact that the doctors were doing these electronic medical records, but they couldn’t get them to complete all the forms and all the fields that were needed to be able to bill the insurance company for the services provided. I was listening to them talk, and they were talking about how they were going to try and train the doctors to do all these things and do all this stuff, and I said, “Wait.

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

Trying to Save Money on Software Can Kill Your Six Sigma Results

Consultants and trainers keep trying to save money on Six Sigma software while charging a small fortune for training. Without tools to to the job, all of this training is wasted and improvement projects will fail to sustain results. Are you trying to save a few dollars on software or maximize the results from Six Sigma?



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

“I’ve been eternally frustrated over the last 20-something years because Six Sigma trainers and [others] will go out and train companies, spend weeks training people in a company, but then not give them the software to do the job.

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