Could you add the ability to sort gages by what procedure or templates have been applied to the gages? Ive spent a ton of time writing procedures and templates and linking the gages to them, now I am curious as to what gages are left without a procedure or template assigned to it. Ideally this would be on the ‘GAGES’ tab.
I suppose the long road, and I stress the ‘LONG’ part, would be to put the procedure name in a custom field, but you can’t tell what Template was applied from the gage page. Only way to know -as far as I can tell- is to check each template for that gage in the links. That said doing that to 700+ gages might be the tiniest bit time consuming. I can only imagine if we had 2000 or more gages, a guy would be sitting in front of a computer for weeks doing that.
I know you can look at which gages have been assigned to a procedure…not sure about templates. I set up a custom field that I basically put a check box on once a gage has all of its information inputted. I have 2000+ gages in the system…good times
This doesn’t accomplish what you want but it’s the closest I know how to get. When viewing the Procedures tab you can run the “Procedure with Associated Gages” canned report and export to Excel file. (There’s no similar canned report for gage templates in v8.8.4). With a little Excel wizardry you could compare the list of associated gages against a list of all your gages and find which ones don’t appear in both lists.
I think the difficulty in sorting gages by Procedure is that a gage could have more than one procedure linked to it. This is probably a job for your SQL guy who knows how to use tools outside GAGEtrak to run a query like this.
I like your checkbox idea. I was contemplating copy pasting the procedure name into custom field 1, but the checkbox thing would function the same. We have the ISO audit at the end of this month, and last 2 years we took hits on Gagetrak, so I’m in overkill mode trying to get all of basically everything in order. Many years of bad habits by myself and those who came before me. They trained me so I did as I was shown to do. Add to that about 7 years of very lax ISO auditors. Then 3 years ago we got a new lady, who’s side gig is a Sgt in the military. She’s tough, but thorough.
I hadn’t considered the canned reports. Until recently GT was on an older laptop with the processing speed of a Speak-n-Spell. When I tried to get it set up to automatically send the calibrations due reports to myself and the QC manager, it said “danger to manifold”. GT people looked at it and said you need mo’ powah’. Just got a new laptop and could investigate more of the available options under the hood of GT.
Stupid stuff. She found a gage on the floor that was marked inactive in our system, we had an incorrect reference standard applied to the bas flatness check of a height gage, stuff like that. Year before was all of our outsourced calibrations had dates that didn’t match the certs they mail, they had the date we entered them, not the date on the cert that it was done on.
I had a similar situation. I was new to the company and inherited several GAGEtrak issues that had been identified during the previous audit but were never fully corrected or updated. As a result, many of those issues became repeat findings during this year’s audit and were elevated to major findings.
To address the problem systematically, I created an Excel-based tool that pulls data directly from the GAGEtrak SQL database. This allows me to analyze the gage data, identify missing or incomplete information, track corrections, and monitor the overall health of our calibration system. Still have lots of work but now I can see where I am.
