[Ch...] Posted September 17, 2019 Share Posted September 17, 2019 Guys, Who here has an easy way to output just the out of tolerance measurements to a table file? I still need the original .chr table file to save. What I want is an additional table file to save to a location with just the out of tolerance measurements. I do have PCM. Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/ Share on other sites More sharing options...
[Br...] Posted September 17, 2019 Share Posted September 17, 2019 I think you can create another printout that only reports out of tolerance. Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99502 Share on other sites More sharing options...
[Ch...] Posted September 18, 2019 Author Share Posted September 18, 2019 I like that but does anyone know how to get that into a text or excel file? Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99504 Share on other sites More sharing options...
[Ch...] Posted September 18, 2019 Author Share Posted September 18, 2019 Bump Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99506 Share on other sites More sharing options...
[Br...] Posted September 18, 2019 Share Posted September 18, 2019 Ah, sorry I didn't notice you wanted it only for the table file. You can create your own excel report. Just make a copy of the defult Calypso excel report, then add some VBA code to eliminate any characteristics that are in tolerance. Go to Resources>Define Printout. Select the Default Printout/Warning limit tab, and click the folder icon next "Excel report". this should take you to the folder location for the Calypso excel report. Go to that folder, and make a copy of the characteristic report. Add macros to delete rows that contain passing results. Now go back to the Define printout window, and when you select the folder icon next to the Excel report option, select your new excel report you created. Now when hit the run button for your measurement plan, you should now see the "excel printout" option available. check the box and run your measurement plan. Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99508 Share on other sites More sharing options...
[Ch...] Posted September 18, 2019 Author Share Posted September 18, 2019 We have success!!!. One more question. How to I change what folder my it saves to? It didn't work when I changed the default printout under Name for Output files Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99510 Share on other sites More sharing options...
[Ch...] Posted September 18, 2019 Author Share Posted September 18, 2019 I think I'm just going to use a batch file to fetch it from my default results folder. Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99512 Share on other sites More sharing options...
[Br...] Posted September 18, 2019 Share Posted September 18, 2019 Please sign in to view this quote. Yeah I'm really not sure if that can be changed. You also could add to your VBA code to save as into a specific folder. But the Batch file will work just as well. Link to comment https://qualityforum.zeiss.com/topic/17732-table-file-of-out-of-tolerance-measurements-only/#findComment-99514 Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in