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.
These are just sporadic and most likely operator errors. I want to create a script that will retrieve Theo and Target for all features and the nominal for all dims and generate an Excel Worksheet showing all the XYZ and ijk values for each. Then I will use conditional formatting to shade the values in the Target and Dims that are not equal to the values for the Theo. This will make it easy for the operator to see where there are differences. They would need to then review these and determine if the difference is intended, a feature that is so far from nominal that the target had to be different, or if they are errors.
These are just sporadic and most likely operator errors. I want to create a script that will retrieve Theo and Target for all features and the nominal for all dims and generate an Excel Worksheet showing all the XYZ and ijk values for each. Then I will use conditional formatting to shade the values in the Target and Dims that are not equal to the values for the Theo. This will make it easy for the operator to see where there are differences. They would need to then review these and determine if the difference is intended, a feature that is so far from nominal that the target had to be different, or if they are errors.
