[To...] Posted February 13, 2023 Share Posted February 13, 2023 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 Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/ Share on other sites More sharing options...
[De...] Posted February 13, 2023 Share Posted February 13, 2023 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. Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/#findComment-38606 Share on other sites More sharing options...
[Jo...] Posted February 13, 2023 Share Posted February 13, 2023 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. Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/#findComment-38608 Share on other sites More sharing options...
[Br...] Posted February 13, 2023 Share Posted February 13, 2023 HI Tom, Unfortunately, without PCM or Batch file, there is no way to achieve your request. Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/#findComment-38610 Share on other sites More sharing options...
[No...] Posted February 14, 2023 Share Posted February 14, 2023 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. Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/#findComment-38612 Share on other sites More sharing options...
[Ma...] Posted February 14, 2023 Share Posted February 14, 2023 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. Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/#findComment-38614 Share on other sites More sharing options...
[To...] Posted February 14, 2023 Author Share Posted February 14, 2023 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. Link to comment https://qualityforum.zeiss.com/topic/8606-custom-output-without-pcm/#findComment-38616 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