Software tip: Creating a wild card filter in GAGEpack gage calibration software

Scott JohnsonMany people are surprised when they see GAGEpack’s Search and Replace function in action. This is a powerful feature that I think most every GAGEpack user could use. But, use this feature with caution, as ALL gages can be modified.

First, let’s suppose you name all of your gages with a 3-digit code for department. In this example, we will say your gage numbers in the plating department start out with the letters ‘PLT’. Next, we assume you are interested in using the group field to record the department the gage is assigned to.

Continue reading

Software tip: Charting time data on a control chart

Matt SavageRecently I was given an Excel file that contained some data for the time it took to complete a task. The data had a column that listed the “time” and the data was in time-of-day format. I wanted to make a control chart showing how long, in minutes & seconds, a task took. Unfortunately, Excel categorized this as a Date/Time field, which can not be easily charted. Since the column listed the time the task took in hours:minutes:seconds, I needed a way to convert this to a number that I could chart on a control chart.

Continue reading