QI Tools Software

Wed, 12/30/2015 - 16:16 -- johnshutze

Which software programs are you using to create things such as control charts, run charts, fishbones, etc.?

We were using QI Macros for Excel that will auto-populate various charts. We just upgraded to Microsoft Office 2016 and QI Macros is currently not compatible with Office 2016.

Thanks!

John

up
0 users have voted.

Grace Gorenflo's picture
Submitted by Grace Gorenflo on

Hi John,

I'm not computer savvy enough to know whether this will work, but I just googled "control chart template" and found several different sites that offer free downloads of Excel templates.  I can't really speak to any of them, other than to say that ASQ is a reputable organization and I was able to open and manipulate their template.  Might these help, or does the macro problem persist?

Grace

up
0 users have voted.

Submitted by bryn.manzella@j... on

Although I am using QI Macros now, in the past while working in quality in the tertiary care system, I used SQCPack.  SQCPack was developed as engineering software and is relatively expensive, but was easy to use and offered a lot of control chart options.

up
0 users have voted.

Bryn Manzella, MPH
Director of Quality Improvement
Jefferson County Department of Health
1400 6th Avenue South
Birmingham, AL 35233
205-930-1578
bryn.manzella@jcdh.org

Submitted by johnshutze on

Thanks for the input. I've tested the ASQ templates, which work okay. The company that produces SQCPack(PQ Systems), is sending me a dvd for a free trial run. Again, thanks for your help!

up
0 users have voted.

Submitted by gkroberts on

Hi John, I have used Microsoft Vizio to create charts easily and successfully, but my favorite would be using Piktochart (piktochart.com). This requires a membership of $40/year but it is well worth it. It provides unique and visually appealing charts/graphics/handouts that can be downloaded as PDFs or JPEGs, and is easy-to-use once you get used to it. I use this hand-in-hand with Prezi for presentations to make QI even more fun.

I have not tried the QI macros for Excel but I can see that it would be better for more complex and multiple charts. I'll try this next time. Thanks!

up
0 users have voted.

Gurleen Roberts, MPH
Director of Quality Management
Cobb & Douglas Public Health
Marietta, GA
gurleen.roberts@dph.ga.gov