Home »
Blog » QI Macros
Improvement Insights Blog
Posts tagged "QI Macros"
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.
Continue Reading "Harness the Power of Excel Formulas"
Posted by Jay Arthur in Excel, Improvement Insights, QI Macros.
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.
Continue Reading "*Latest webinar: 10/12/21 QI Macros webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
At an Agile Lean Six Sigma workshop I did for ASQ Phoenix, one participant asked me if I’d applied Six Sigma to Bitcoin. While I haven’t, my insightful answer surprised me and the participant.
“Last week I was doing a presentation, a nightly webinar on Agile Lean and Six Sigma for the ASQ section in Phoenix, and if your section wants me to do a one hour whatever for your section meeting I’m happy to do it. But anyway, in this section meeting we broke out into some work rooms and one gentleman asked me, “Well,” he asked. “Have you ever worked with Bitcoin?”
Continue Reading "Bucks or Bitcoin?"
Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights.
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.
Continue Reading "Doubt the Default Solution"
Posted by Jay Arthur in Data Mining, Improvement Insights, QI Macros.
Big Sigma wastes time and money. You can make a lot of progress in just two hours a week. Here’s how.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma for Hospitals” and QI Macros [software].
“One of the things that’s irritated me for a long time is the whole Six Sigma idea (I call it “big sigma”) where it’s like, “We have to do it wall-to-wall, floor-to-ceiling; everybody has to be on a Six Sigma project.”
“That’s wrong, okay? A very little portion of your business is broken – not the whole enchilada, right? So you can spend a lot of time trying to fix things out there in various places and never get to the few things that really are key to moving the business.
Continue Reading "The Two-hour Improvement Week to Maximize Results"
Posted by Jay Arthur in Agile Lean Six Sigma, Improvement Insights.
You don’t have to fix everything, just the one thing out of 25 that causes over half the waste, rework and lost profit.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“I’ve talked to you about Pareto’s rule before, but I continue to come back to this time and time again: 20% of what you’re doing is producing 80% of the waste, rework, lost profit, [lost] productivity, patient harm… whatever it is. But within that 20% that Pareto rule still applies, which means that only 4% of what you’re doing is producing over half the mistakes and errors.
Continue Reading "Drill Down to the 4-50 Rule to Get Results"
Posted by Jay Arthur in Agile Lean Six Sigma, Data Mining, Improvement Insights, QI Macros.
Over 40 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.
Continue Reading "9/14/21 QI Macros webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
Do you use data to discover problems and innovative solutions? Or do you use data to confirm what you already believe and think you know? This is called confirmation bias.
“Hi, I’m Jay Arthur, author of “Lean Six Sigma Demystified” and QI Macros [software].
“So in Quality Improvement we’re asked to pledge allegiance to science and evidence. A lot of people do that, but very often they get trapped because they like data that supports what they believe about how things work, and they don’t like data that contradicts what they believe. Does this make sense?
“So are you one of those people who selectively goes out and says, “Hey, this data supports me.
Continue Reading "Do You Use Data Selectively?"
Posted by Jay Arthur in Data Mining, Improvement Insights.
Do you and your team ever get stuck trying to figure out how to fix the root cause of problems? There’s a methodology for that. It’s called TRIZ – the Theory of Innovative Problem Solving. Here’s how it works.
Hi, I’m Jay Arthur, author of Lean Six Sigma Demystified,Lean Six Sigma for Hospitals and QI Macros [software].
You know, when I worked with teams I found sometimes they were very good at figuring out [and] getting to the root cause, but then they struggled with How can we fix that? It’s like they get stuck in their old ways of thinking about how things work.
Continue Reading "TRIZ for Innovative Countermeasures"
Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog.
Over 75 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.
Continue Reading "8/10/21 QI Macros webinar"
Posted by Jay Arthur in Data Mining, Excel, QI Macros, Webinar.
