hexagon logo

Code to pull Theo, Target, and Dimension nominals from PC-DMIS

I'm looking at developing a vba script in Excel to pull the theo, target, and dimension nominal values and generate a worksheet showing them. I would then apply conditional formatting to highlight the Target and Theo values that do not match the nominal values in the dimension statement. We have hundreds of CMM Programs that have been used and modified over many years and versions of PC-DMIS. I have been manually auditing data and finding points here and there where the T does not correlate with the XYZ coordinate deviations. I have found many auto vector features where the target and theo do not match the nominal in the dimension. A script that actually grabbed all the nominal, including the ijk vectors would be very useful to identify these issues. The operator would need to then verify the feature and correct the nominal that was deemed incorrect. Maybe there is such a tool within PC-DMIS to check for this. If that is the case, maybe one of the Guru's on here can point me to it. I am not a PC-DMIS user myself, so I cannot poke around in PC-DMIS to look for such a tool, but I work very closely with a group that does offline programming.
Parents
  • Not necessarily - the target values may have changed when the feature is so off that the CMM can't find it/hits it too early and the user/operator ansers "yes" to the question "update target values..." after measuring the feature.


    That is true also, but is again indicative of someone who needs training. If it is across the board throughout their programs, either the parts they make are consistently garbage, or a programmer/operator has no idea what they're doing. IMHO.

    I would never answer yes to update the hit targets or a feature, just because it happened to be out on 1 part (or even a full run).
Reply
  • Not necessarily - the target values may have changed when the feature is so off that the CMM can't find it/hits it too early and the user/operator ansers "yes" to the question "update target values..." after measuring the feature.


    That is true also, but is again indicative of someone who needs training. If it is across the board throughout their programs, either the parts they make are consistently garbage, or a programmer/operator has no idea what they're doing. IMHO.

    I would never answer yes to update the hit targets or a feature, just because it happened to be out on 1 part (or even a full run).
Children
No Data