Archive for the ‘Software’ Category

How much did your SPC software cost?

September 10, 2009

Steve Daum

Your first response to this question might be to quote the retail price paid for your SPC software. This would be a factual answer. Fast forward and imagine answering the question after using the software for six months or a year. Would your answer be different?

When evaluating SPC software there are many considerations; price is just one of these. Many other factors will contribute to the full cost of ownership. For example, the software will have to be installed, maintained, and supported. Users will have to be trained. Questions about the software will have to be answered – not just how to use it – but how to apply it in your system.

One of the largest costs might be described as the “make it work in my world” cost. Software designers often have a vision of how work progresses through a system. This vision might or might not align with the way work flows through your organization. I have seen software with impressive feature lists fail to be used – because the workflows just can’t be wedged into the way a firm actually gets work done. A good relationship with an experienced vendor support group can make a big difference – but if the workflows are misaligned – this can prove to be expensive.

Consider also the “manageability” cost. For example, you install the software for several users. They like it, they find it easy use, and they begin using it. However, they each take their own implementation journey. After a few months, important data, and analysis might be strewn about across your network somewhat haphazardly. How will this be managed? Once again, the feature list and price might look impressive – but the long term manageability might increase the real cost of ownership way beyond your initial impression.

It can be difficult to select any software and SPC software is no exception. If you find yourself in this situation, look beyond the initial price and feature list. Take a holistic view. Think about work flows and the long term feasibility of deploying the software and continuing to get knowledgeable support from a reputable vendor. In the end, the retail price might be the least of your worries.

How many charts can you track?

August 21, 2009

Steve Daum

Most of our customers use charts as part of their work. Depending on their job, they may review charts every hour, day, week, or at some other interval. Creating and reviewing these charts is almost never a primary job. Instead, the charts are used as decision support tools; they support the primary job and help a user make better decisions.

Different types of charts have different usage patterns. For example, when looking at a chart of sales, the usage pattern is something like this:

  1. View the chart
  2. Ask this question: Are we on target, above target, or below target?
  3. Depending on the answer, take appropriate action to move towards the desired outcome.
  4. At some later date, repeat.

Statistical process control (SPC) charts have a similar usage pattern with a narrower focus. For example, you might chart the wait time between a customer posting an order and receiving an order acknowledgement.

(more…)

Tips for designing your quality improvement spreadsheets

August 4, 2009

Steve Daum

Among our healthcare customers we find substantial use of Microsoft Excel. A recent survey of CHARTrunner customers found that 68% of them use data in Excel to produce their SPC charts and other analysis related to quality improvement. Excel is powerful and flexible and well suited to this job. However, this power can lead to complicated worksheets that are difficult to use and even more difficult to maintain. Once designed and deployed, a spreadsheet template may be in use for several years. Who will be around to debug an error or correct a formula that is discovered a year later?

To improve the situation requires well designed spreadsheets. Today, spreadsheets are so easy to setup and start to use – that we tend to gloss over using a design process to get started. Here are some tips to think about as you design your next quality improvement spreadsheet:

  1. Decide the primary purpose of the spreadsheet
  2. Make the primary purpose easy to accomplish
  3. Use the simplest possible sheet that accomplishes the purpose
  4. Don’t create future work for yourself
  5. Keep the data “pure”
  6. Be consistent among your sheets
  7. Favor traditional arrangements over weird arrangements
  8. Use a “notes” worksheet to document complex sheets

For a more detailed look at these tips see the following article in the PQ Systems knowledge base:

http://www.pqsystems.com/kb/activekb/questions/541/Excel+tips

Summarizing control chart data with queries

July 6, 2009

Steve Daum

It may seem arcane to some folks – but I enjoy a good query challenge. Recently, a customer needed help with a query to aggregate raw data into a useful form for charting. Since I’ve helped several customer do almost the same thing, I decided to write a short article for our Knowledge Base. Here is the link:

http://www.pqsystems.com/kb/activekb/questions/540/A+simple+query+pattern+for+summarizing+raw+data

If you want to chart data where several rows get summarized for each data point – this article contains example SQL queries. These make good patterns for solving a large class of data summery problems. Don’t let the SQL queries intimidate you – it is pretty simple once you see a few examples. The article includes a download containing example data and example CHARTrunner charts.

Happy querying!

Software short: Adding some style to your charts in CHARTrunner

June 10, 2009

Scott Johnson

Every now and then I’m complimented on the way my charts look.  I’m not going to give myself all the credit. I mainly give the credit to the CHARTrunner and its designers.  Each month, I create a chart for our monthly newsletter, Quality eLine. I have found myself utilizing CHARTrunner’s chart style options more and more.  I would like to go through some of the advantages that I have found.

A few benefits of chart styles include:

  1. Helps produce consistent charts each time they are drawn;
  2. Allows you to assign fonts to different areas on the chart;
  3. Has many options for color management;
  4. Provides options for other various styles like line styles and data marker styles;
  5. Properly used, it can make charts easier to read;
  6. And there is no limit to the number of styles (each one is a file ending in .csc).

(more…)

Thanks for responding!

June 1, 2009

Steve Daum

We recently surveyed some of our CHARTrunner users. Each time we do this, I am amazed at the diversity among our charting software users. CHARTrunner has found a home in so many different industries. If you responded to the survey, thank you. Your input is invaluable. It helps us to prioritize and plan for future product improvements.

For many years PQ has taken pride that our customers drive the next set of enhancements to our software products. Recently, we began an effort to shorten this feedback cycle. The idea is to get customer input earlier and more often during a project. To this end, we are having many reviews of progress throughout a project. Additionally, we are making daily builds of functioning, if incomplete, new versions as enhancements are added. It is important that we get feedback from non-software developers who have a stake in the project outcome. This means not only sales staff, tech support analysts, and the management team–but most importantly customers.

If you did not have a chance to respond to our survey or if you are interested in providing feedback on early product releases, feel free to drop me an email (steved@pqsystems.com). We would love to hear your suggestions and evaluations of early software builds.

Steve

CHARTrunner-m: Your SPC watchdog

May 20, 2009

Introducing CHARTrunner-m: Your SPC watchdog

April 30, 2009

Steve Daum

Software developers at PQ often get opportunities to talk to customers. This might happen during a gnarly tech support call or it might be part of a pre-sales question and answer session. It is not unusual that good ideas for improving our software surface during these calls.

Over the last several years we began to notice a pattern in many of these conversations. The customer would start by saying something like this:

I keep track of over 150 charts…

I have so many control charts…

It takes so long to review all my control charts…

These conversations and other market research lead PQ to last week’s release of a new product named CHARTrunner-m.

CHARTrunner-m takes a fresh look at the human workflow of using SPC control charts. We had the thought that software should allow you to deploy control charts more widely and for more quality metrics without significant increases in your costs or effort.

The thinking for CHARTrunner-m has incubated among our staff for a long time. It has been rewarding and interesting to be part of the team that brought this to market. Please take a moment to learn more about CHARTrunner-m by watching this short video. In the coming weeks we’ll point you to more information where you can learn the benefits of this innovative approach to SPC.

Software short: Automatic emailing in the new GAGEpack 8.5

April 24, 2009

Scott Johnson

Last month we released GAGEpack 8.5 that includes a new software utility GAGEmail. GAGEmail is a separate application that improves the way automated emails are sent.

  • 24/7 email alerts (emails even with GAGEpack is closed)
  • IT folks can manage this as they do other applications that run as a service
  • GAGEmail can run on a separate PC, so the GAGEpack PC can be shutdown and users still get alerts
  • Automated emails will not affect the performance of GAGEpack

GAGEmail also makes email options from GAGEpack more versatile. Here are a few options that before now, were not possible:

Control charts for monthly presentations

April 13, 2009

Matt Savage

I recently returned from training a hospital that has been using CHARTrunner for a number of months. One individual, I’ll call her Rita, presents her quality improvement charts every month in a quality meeting with her managers. She has 22 charts and wanted an easier way to automate the process of getting ready for this monthly presentation.

Her current process is to display the chart, copy it to the Windows Clipboard, go to PowerPoint, paste the chart, resize the chart, and then repeat this for all of her charts. I feel Rita’s pain. The process is time consuming and error-prone.

The good news is that there is an easier way! We automated this process to the point that Rita never needs to launch CHARTrunner. Instead she clicks on a desktop icon each month that launches a command line parameter to update her 22 charts in her PowerPoint presentation. Two clicks accomplishes what previously took her 2 full days. The custom application we developed for Rita saves her 2 days of work each month! I have set this up for many organizations, and I’d like the opportunity to do the same for you.

If you are interested in learning more about a system that automates the process of getting ready for your recurring meetings, let’s talk.


Follow

Get every new post delivered to your Inbox.