QI Macros

Improvement Insights Blog

Posts tagged "QI Macros"

Use Excel for Flowcharts and Value Stream Maps Not Visio

Did you know you can draw fishbone diagrams, flowcharts, value stream maps and more without Visio? You can do all that and more right within Excel, and those can be viewed by others who don’t have Visio. Here’s how:

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“I was at the Colorado Lean Network Conference and I was demoing how you can do Value Stream Maps and other things right in Microsoft Excel. The guy looking at it said, “I… I don’t have to use Vizio anymore?”

Posted by Jay Arthur in Improvement Insights.

Lean Six Sigma Startup

Ever wondered if there might be a better way to start a Lean Six Sigma initiative? There is. Here’s Why:

Download my free ebook, Agile Process Innovation-Hacking Lean Six Sigma for Results.



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

“Back in 2011, Eric Ries launched a book called “The Lean Startup” which was about how to start a startup business, basically. There were some rules behind it, but one of his rules was to have a “Minimum Viable Product”… Minimum Viable Product. Now, in 1997 when I launched QI Macros, it was a Minimum Viable Product but now it’s grown into all kinds of things.

Posted by Jay Arthur in Improvement Insights.

Do You Hate Math and Statistics?

Over half the population hates math and statistics. How do we help them embrace the tools of quality?

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“Do you love math and statistics? Maybe not. Half the population does not like math and statistics. That’s one of the reasons I created QI Macros: to automate all that math and statistics so they don’t need to know that. They just get charts or graphs or analysis, right? I don’t want people frustrated by math and statistics.

Posted by Jay Arthur in Improvement Insights.

Save the Turkeys!

What do you do about an ammonia spill in a monstrous freezer filled with turkeys and chicken? I used the QI Macros Stat Wizard to save $3,000,000 in frozen poultry. Here’s how:

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“Last year, I had an opportunity to work with a company that handles frozen poultry: turkeys, chickens, things of that nature. They had had an ammonia spill inside one of these big, huge freezers where they keep stuff.

Posted by Jay Arthur in Improvement Insights.

11/11/25 Healthcare Data Analytics Webinar

Over 160 people signed up for this webinar, with Jay Arthur demonstrating how to implement Healthcare Data Analytics to save time, save money, and (most importantly) save lives.



Books that Jay may have mentioned in the video:

You can view a short two-page illustrated guide to the Zero Harm – Trillion Dollar Prescription by clicking HERE.

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

Waterfall or Agile Lean Six Sigma?

Most companies follow the waterfall method of implementing Lean Six Sigma. An Agile approach will deliver results more quickly and help ensure success.

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“I also wrote books on software engineering; I grew up in the world of software engineering. I actually worked at Bell Laboratories, and the model at the time of software development was called the ‘Waterfall’ model. You start with requirements, and design and code and test, and eventually you deliver a project.

Posted by Jay Arthur in Improvement Insights.

Lessons from ANCC Magnet Conference 2025

The ANCC Magnet Conference 2025 brought together 13,000 nurses seeking to transform healthcare using evidence-based practice (EBP). After a decade of tracking the tools used in Magnet improvement posters, I can tell you that they are still using antiquated tools that won’t get healthcare to Zero Harm and Hassle-free Healthcare. Here’s why:

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“I’m here at the American Nursing Association’s Magnet conference in Atlanta 2025. It’s October, and once again I went through all of the posters; 90% of the charts are line, bar, and pie charts.

Posted by Jay Arthur in Improvement Insights.

The High Cost of Not Buying Six Sigma Software

Trainers often use trial versions of QI Macros to train their students. That comes with a huge cost. Here’s Why:

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“I have found that a lot of training companies and universities and [others], when they teach Lean and Six Sigma they want to use our 30-day trial to train people. I have to ask you a question: Maybe you think you’re saving money, or you’re saving the patient money, or [saving] the student money, or you’re saving something, or you’re keeping your cost lower so you don’t look like an more expensive training [option] so you get more business… I don’t know what it is, but what’s the cost of NOT buying that software for that student?

Posted by Jay Arthur in Improvement Insights.

Stop Using Excel Spaghetti Charts

Stop Using Excel Spaghetti Charts. Start using Smart Performance Charts (SPC). Here’s how:

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“I was recently in a presentation, and a person was putting up line charts and there were multiple lines on each chart. I know charts and I was still having trouble following the presentation. This person acted like everybody in the room was getting everything that he said. Nonsense.

“Nobody wants to read your ‘spaghetti chart.’

Posted by Jay Arthur in Improvement Insights.

The 4-50 for Emission Testing

Denver requires emission testing for cars over a certain age. But it may not be necessary. Here’s why:

Download my free ebook, Agile Process Innovation – Hacking Lean Six Sigma for Results.



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

“I live in Denver, Colorado. You know, we used to get in the winter… we’d call it ‘the brown cloud,’ right? So they decided that we had to test every car every few years just to try and do emission testing and figure out which ones were polluting. But there was a guy here that invented a little tool that could detect cars that are polluting as they drive by.

Posted by Jay Arthur in Improvement Insights.