Over 50 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.
Improvement Insights Blog
Latest "Jay Arthur Blog" Posts
My childhood doctor did it all. Now I almost never see a doctor. Are You Doing Black or Green Belt work, or “No Belt” work?
“When I was growing up as a kid, our family doctor, Dr. Pierce (and what an unfortunate name)… anyway, Dr. Pierce was actually a MASH 4077 kind of a doctor, right? He was he was in Korea [where] they were doing meatball surgery. But back in the 50s, he’d come in and take your temperature, check your pulse, and he would give you the shots and anything else that was there: write the prescriptions out long hand and rip them off a pad and hand them to you.
Jay Arthur was the featured speaker for the 12/16/20 ASQ Philadelphia Section Web Meeting. His topic was “Turning Data Into Dollars with Microsoft Excel: Big Profits from Small Data.” You may view the video of Jay’s webinar below:
If you’re interested in learning more about QI Macros for Excel (the software Jay wrote and developed), click HERE and view the demo video in the yellow box. You may also sign up for a free 30 day trial of the software by filling out the form on that page next to the video, or by signing up at THIS link.
If you’re interested in learning more about Jay’s ideas on Agile Lean Six Sigma, you can download a free brief summary of Jay’s ideas in his “Agile Lean Six Sigma Manifesto,” available at THIS link.
People still seem to be confused about what kind of Quality Improvement chart to use. Here’s the short and simple answer:
If you’re a registered NAHQ Next 2020 attendee, you can view Jay Arthur’s showcase until October 31, 2020.
1. Click on the link below.
2. Click on the NAHQ Next top banner to log in. It will take you to the page below. Log in with your name and email address:
3. Once you’re logged in, visit the On-Demand Sessions and scroll to the very bottom to view Jay’s session, “Zero Harm and the Trillion Dollar Prescription.”
The New York Times published a list of cases by facility. I tweaked it to get Pareto Charts of the biggest problems. Nursing homes and rehab facilities were 64% of the total, then prisons and food processing (e.g., beef, pork, poultry, etc.).
This is a fun thing we did last week. While Watching the movie “Forrest Gump,” Jay heard this song and had the idea that this song is particularly applicable to our current situation. Several of the people that work for QI Macros are musicians, so we tried to do something fun while we’re working remotely. This was recorded in 4 separate homes and then assembled and arranged by Nicholas. We hope you enjoy it:
People over age 55 account for 92% of COVID-19 Deaths (data from CDC). Sweden is using similar data to leave the country open for most citizens while asking seniors to stay at home. How do we reopen the economy? Self-quarantine seniors; let everyone else get back to work.
Here’s the 2019-2020 Influenza (i.e., Flu) deaths. Again, seniors are 83.5% of deaths. The flu death rate is about 1 per 1,000. COVID-19 death rate is 1-2 per 100, perhaps lower in people under the age of 55 and higher for those over age 55.
Countermeasure: Self-quarantining seniors will help flatten the curve and prevent overwhelming healthcare.
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.
One of our QI Macros users offered to share his dashboard of paramedic response during the Seattle area response to COVID-19. His team transported the first COVID patient in America. As you can see, turnaround times (TAT) at the hospital averaged 30 minutes and temperatures spiked in transported patients.