Excel
Blog

Posts tagged "Excel"

*Latest webinar: 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 Webinar.

9/10/20 QI Macros Webinar

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

8/11/2020 QI Macros Webinar

Over 80 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, 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 Webinar.

Why Are People Using Line and Bar Charts, not Control Charts?

If you look at improvement project posters at quality conferences around the country, you’ll find that almost everyone is using Excel line and bar charts. Even after decades of Six Sigma training and association membership. What’s the hold up? Here’s my take:

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

“Every year I look at lots of improvement posters and I keep wondering, “Why isn’t anyone using the tools of Quality?” Control charts, Pareto charts, histograms… Most of them are just using plain old Excel line and bar charts. Now it might be because they don’t know about the power and beauty and how easy it can be now to do Control charts, Pareto charts and fishbones.

Posted by Jay Arthur in Improvement Insights.

7/7/2020 QI Macros Webinar

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

6/9/20 QI Macros Webinar

Over 140 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, 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 Webinar.

5/14/20 QI Macros Webinar

Over 120 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, 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 Webinar.

Colorado COVID-19 Cases and Deaths in Control Charts

While most COVID-19 charts show cumulative cases and deaths, I wondered what would happen if we turned the cumulative data into a daily data and plotted it as a control chart. It is possible to use c or XmR charts for this purpose. Process changes chosen based on runs and trends in the data.

Daily new cases still unstable, but hovering around 339/day. Cases began to rise 3/18. Potentially leveling off 3/26. the date of state “stay-at-home” order.

 

Daily deaths still unstable, but hovering around 12/day. Deaths began rising 3/21, but appear to be stabilizing.  Significant spike on 4/2, root cause unknown.

Posted by Jay Arthur in Jay Arthur Blog.

4/9/20 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, 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.

3/10/20 QI Macros Webinar

More than 60 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, 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 Webinar.