Archive for the ‘Software’ Category

Concurrent-user licensing or not concurrent-user licensing? That is the question!

August 17, 2010

Last year we deployed a new licensing option for all three of our major software applications. Up until that point, our customers licensed the software on a “per-computer” basis, meaning every computer terminal being used to run the program required its own unique license. As the software industry shifted towards enterprise and network licensing options, we received a steady stream of requests for more flexible “roaming” licenses. Thus, the concurrent-user license was born.

A concurrent-user license allows an organization to install our software on an unlimited number of computers on the same network, giving them the freedom to put these applications into the hands of any/all of their employees without the cost and hassle of managing individual licenses. The only restriction in the concurrent model is the number of people who can access the program simultaneously; when the sixth person attempts to log into a five-user license, they will get a message saying that the server is full.

We still offer the per-computer licenses, but the concurrent-user licenses have been steadily growing in popularity since they were launched.  Consequently, I routinely find myself answering the question “Should I switch to a concurrent-user license?”  My response is always the same:  “It depends.”

The value of a concurrent-user license versus the traditional per-computer license depends heavily on what sort of traffic to the program is anticipated. If you expect infrequent and fairly brief access from many computer terminals, a concurrent-user license would meet your needs for a fraction of what it would cost to license all of those terminals individually. On the other hand, if you have only a few terminals that need near-constant access to the program, it would likely be more cost effective to invest in per-computer licenses. In both scenarios, both licensing options could be applied to grant the required access, but selecting the appropriate license would save a pretty penny.

Please feel free to contact your account representative if you have questions about your specific application or contact me via e-mail at davids@pqsystems.com. We would be happy to discuss different licensing options with you.

Like control charts? Wait ‘til you see this video…

April 15, 2010

If you’ve forgotten what control charts are and why they’re important, this three-minute video will remind you how this critical tool can help you demonstrate proof of quality performance, whether you produce a service or a product.

In a heartbeat, you’ll understand the difference between special cause variation and common cause variation—and you’ll learn what to do about it and how data speaks to you about managing your processes.

You may want to show this short, just-released, snappy video to your boss:

http://www.youtube.com/pqsystems

The difference between run charts and control charts

December 3, 2009

Steve Daum

A customer recently asked one of our support representatives the following questions: What is the difference between a run chart and a control chart? And when should I use one vs. the other? These are great questions because they allow us to highlight some of the benefits of control charts.

When you create any chart, you are typically trying to answer a question. For example, you might be asking, “Has my process improved?” or, “Has my process gotten worse?”  You might be asking, “How is the process running today compared to yesterday?” Before you decide on using a run chart or a control chart, consider the type of question you want to answer.

(more…)

An improved improvement chart

October 22, 2009

Matt Savage

If you have worked with count charts with large denominators, you have probably seen control limits that seem too narrow to be of much value. The p-chart is one of the attributes charts with this flaw.

A p-chart counts two things: 1) the number of non-conforming items (the numerator) and 2) the number of items inspected (the denominator). If you look at the glass half-full rather than half-empty, you might count the number of conforming items (rather than non-conforming). In either case, when the denominator is large, a problem may be present.

Consider the following chart which shows a p-chart from a plastic shopping bag manufacturer.

This chart measures the percent of plastic bags that failed a particular test. The bag manufacturer averages about 20,000 bags inspected in each sample and about 600 failures. As you can tell by looking at this chart, the limits seem too tight to be useful. The control limits are considered to be overly-dispersed.

(more…)

The PQ Systems Knowledgebase

October 6, 2009

Steve Daum

Did you know that PQ Systems maintains a robust knowledge base online? It is a repository of common problems and solutions related to using our software and practicing continuous quality improvement. If you are an SQCpack, CHARTrunner, or GAGEpack user, you might just find a solution to your problem here:

http://www.pqsystems.com/kb/activekb/

In a recently-added article, Craig Newland, addresses how to count or group data that has been accumulated during certain periods of time. If you use CHARTrunner, visit: http://www.pqsystems.com/kb/activekb/questions/543/CR%3A+Data+grouping+tardiness to learn how to group your data to make your control chart analysis more telling.

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…)