Custom Output without PCM

[[To...]]

Looking for a solution to generate a single row report for a potential new customer currently using PC-DMIS. I know this can be done using PCM but are there any other ideas out there?

Column #
1a Part Name (A or N)
1b TOF is text to trigger data collection software
2 Serial Number
3 X value of feature 1
4 Y value of feature 1
5 Z value of feature 2
6 Not important
7 average space point distance from a group of space points (not from features 1 o 2)

The Y value is a positive number when on the CMM but the part is flipped 180° about the X axis in the machine so a positive value needs to be reported as a negative and vice versa.

Customer wants the letter "u" in the format in column 7.

Also interested knowing the best solution for outputting the Y value according to the above criteria.

Screenshot 2023-02-13 105100.jpg

[[De...]]

In a past life, I used the Excel output to do what you're looking for. Create a copy of the FeatChar.xlt file with a name to reflect your plan. Point Calypso to this new workbook and allow to populate. Create a second worksheet with the format required by customer and use basic excel functions to populate second worksheet from first. Then save the workbook without data on the first sheet generated by Calypso.

With a little VBA in the background, we were able to generate and auto-populate a second workbook for capability, and a third workbook for monthly production output graphs as well.

[[Jo...]]

Please sign in to view this quote.

Maybe a custom report/table to export? The table doesn't have to be viewable on the report. May have to transpose row to column afterwards, I'm not really practiced in that.

[[Br...]]

HI Tom,

Unfortunately, without PCM or Batch file, there is no way to achieve your request.

[[No...]]

With enough brainpower you may be able to concatenate a string with all needed content purely by using formulas (just a guess), but I don't know how to write it to a file without PCM.
Maybe Excel will be the only way.

[[Ma...]]

Please sign in to view this quote.

I think i had success with saving file without PCM, but i don't want to dig, try and post solution without knowing what and how to get evaluation, values and needed format.

[[To...]]

Please sign in to view this quote.

Fortunately, the customer is already heavy into excel manipulation so this may be the best solution. Thanks Dean.