Creating blank dimensions in Excel report

[[Gr...]]

Hoping someone knows a good trick to help do this. When doing FAIR's and PPA reports we have to transfer our data out of the Excel Characteristics report and into various customer Excel spread sheets. What I have been working on is typing into the characteristics in Calypso the dimension ID (sequential numbers some with letter suffix) for example 10 or 10 a, 10 b, 10c. This is followed by the exact description on the print including the tolerance. I do this for the entire part, even things that are measures later or with a different instrument.
So my problem is trying to find a way to leave the dimensions that I am not measuring in that set up blank in the results area. This will allow us to cut and paste the entire list of characteristics and results then fill in the items measured in other ways or even a different CMM setup. We often do 5 parts and so can you imagine you have 5 parts with say 60 dimensions but they are not sequential out of Excel Calypso. A real cut and paste nightmare. I have a few tricks but I thought one of you fine folks might have some better ones. Currently I take one random hit and use it for all the non-included items in the report. Your thoughts are appreciated.

Thanks in advance,

[[Ro...]]

1, Short answer, yeah i think you're asking too much for calypso to dump your info into a customer supplied program with everything setup ready to be cut & pasted just so.
2, Longer answer, you can do a lot with PCM to output a custom excel result just the way you like it, but everything will be in column A, including your dim description & tolerance & result, and the excel sheet will have no formatting or template of any kind.
3, I think it could possibly take longer to generate this report than it would take to get your 5 pieces up and running. We use these reports because in the long run we output them into a specific folder where they are grabbed and eaten by WinSPC. if it was just 5 pieces we wouldn't do it. But say 20 dims per part and 13 pieces C=0 or even 100% final audit, and yeah it really is worth the time to program for output.

Do you have PCM? (.....and there it is)

Capture987654.JPG