QI Macros Blog by Jay Arthur
Blog

Latest "QI Macros" Posts

*Latest webinar: 11/6/19 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 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 Excel, QI Macros, Webinar.

Control Charts for KPIs

Several attendees told me they had ripped out their line charts and started using Control Charts for their KPIs. Here’s why:



 

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

“We were out at the National Association for Healthcare Quality conference; I was speaking and we were exhibiting there. After I spoke, I had a couple people come up to me who said they’d seen me at the previous year’s convention talking about how to improve things and how line [charts] and bar charts can be harming patients and they said, “You know, I went back to my hospital and we ripped out all of our line charts and we put in control charts for all of our key process indicators.

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

*Next Free QI Macros Live Webinar: 12/17/19 at 1:00 p.m. MST

Register for the upcoming FREE QI Macros Live Webinar, happening Tuesday, December 17th, 2019 at 1:00 p.m. MST.

Learn more about it in the video below, and register at THIS link.

What:  FREE QI Macros – Lean Six Sigma SPC Software for Excel Webinar.

When: Tuesday, December 17th, 2019 at 1:00 p.m. MST

Where:  Join online from wherever you are.

How:  Register for the webinar HERE.

Posted by Jay Arthur in Excel, QI Macros, Webinar.

How Six Sigma SPC Software Design Can Slash the Learning Curve

How you design software can slash the learning curve. Did you design it for college students studying statistics or a business man or woman who just wants to achieve a result with minimal time, effort and training?



“Hi, Jay Arthur with the QI Macros [software]. I wanted to talk to you today about Six Sigma SPC software.

“Now, there’s some big dogs out there, and if you look at them real closely, you’ll see they were designed by professors in the statistical department who wanted to create software to train students in statistics. It has every nook and cranny and option and tweak and everything that you can possibly do to teach people statistics, and fill up curriculums that’ll last an entire semester to focus on different things that you could do to tweak all these little statistics.

Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog, QI Macros, Statistics.

9/10/19 QI Macros Webinar

More than 35 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 versions 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 “Find Tool” search feature or the automated Value Stream Map), you may need to purchase an upgrade to bring your QI Macros to the current version.

Posted by Jay Arthur in Excel, QI Macros, Webinar.

Agile Lean Six Sigma Yellow Belt Training for Results

21st Century Quality is changing how companies implement Lean Six Sigma. Here’s how:



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

“Over the last couple of years I’ve been going all of the Quality conferences, and I’ve seen some presentations that I think point us in a useful direction in terms of how to go about implementing Quality and getting results more quickly, and to accelerate, to develop some exponential growth in terms of how we achieve these results.

“About a year and a half ago I was at the Lean Six Sigma conference in Phoenix , and I saw Christus Health, and they talked about how they started out trying to do the traditional “Big Sigma Black Belt / Green Belt” whole thing, but they weren’t getting any results.

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

Where are the Quality Tools at ASQ WCQI?

Having reviewed the quality tool usage in posters at ASQ WCQI, I have to ask: Where are the Quality Tools?



“Hi, this is Jay Arthur, author of “Lean Six Sigma for Hospitals” and the QI Macros [software].

“I was at the ASQ World conference and I looked at the team posters – you know, the improvement posters that were located in the exhibit hall. Surprisingly, out of all of all these little posters that were out there were there only two control charts, there were about five fishbone [diagrams], maybe one Pareto chart, but most the rest of it was line and bar charts.

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

Matrix Diagram Magic

Matrix diagrams are one of the most common tools in Six Sigma. Once you learn how one works, you know how to use all of the others!



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

“One of the tools that I think people don’t think about too much are Matrix Diagrams. A matrix diagram is essentially anything divided up into rows and columns. Now, these can be as simple as an action plan, it might be how you put all your countermeasures and prioritize them, so there might be some column for prioritizing things in some sort of fashion.

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

Hacking Lean Six Sigma Training

In the early 1990s, I took a control chart class that lasted five days. We learned decision trees and how to calculate control chart formulas with a calculator. I knew that the phone company would never tolerate five-day trainings for 70,000 employees and I knew that few of our employees would tolerate calculating these formulas manually. The only way to remove this barrier was to automate it. Here’s how I did it.

Let’s stop teaching people things they don’t need to know. It’s waste. When I automated everything, it shortened the training and increased retention and results. You can too.



“Hi, I’m Jay Arthur.

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

Jay is the Fourth Horse of Statistics

Everyone thinks I’m a statistician by trade, but nothing could be further from the truth. Here’s my journey.



“Hi, this is Jay Arthur, author of “Lean Six Sigma Demystified” and the QI Macros [software]. I’m here in Maui Kaanapali Villas in Maui.

“One of the things that I want you to think about is because I wrote the QI Macros, everybody thinks I’m a statistician or something, but… the truth is a little bit further from that.

“Suzuki the Zen master had a story of four horses: One ran easily, one you had to flog it a little bit, one he had to flog a little more, and the fourth one you had to flog a lot to get it to move.

Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog, QI Macros, Statistics.