QI Macros Blog by Jay Arthur

Improvement Insights Blog

Latest "QI Macros" Posts

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.

Harness the Power of Excel Formulas

Few spreadsheets use the power of Excel formulas, which is like using a Ferrari as a push cart. Excel formulas are power tools for improvement. Here’s how to access them in QI Macros.



“A few years back, I went to an Excelapalooza conference (yes there is such a thing), and the keynote speaker was kind of the head developer for Excel, and she was talking about how Microsoft keeps track of what people do. I was stunned to recognize that only 5% (that’s five out of a hundred) Excel spreadsheets have any sort of formula in them, even division or multiplication or something simple like that.

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

10/12/21 QI Macros webinar

Over 60 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, 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.

Doubt the Default Solution

All too often, improvement teams fail to question the default approach to doing business. They come up with countermeasures that simply parrot the status quo. I recently saw a TED talk on creativity. The presenter said: Doubt the Default. Sage advice. Here’s why:



“I saw an interesting TED talk this weekend. The professor was talking about creativity, and he used a phrase that I kind of liked. It’s “doubt the default.” Doubt the default. So whatever you’re doing right now is the default; doubt the default.

“Steve Jobs said “Hmm… you know, I don’t like these little tape cassette recorders.

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