hexagon logo
Register Sign in
  • Replies 10 replies
  • Subscribers 222 subscribers
  • Views 186 views
  • Users 0 members are here
Options
Related

Customizing Excel sheets

1_PLAYER_9
I am trying to output the data into an excel sheet but there are a few things that i need to make it work for what i am trying to do. We run three parts per hour and we have about 15 measurements per part. How can i create an excel sheet that will have left column as the dimension id, then the measured values for each dimensions on the second column and continues for every part there after.

3/22/2016 6:00A 3/22/2016 7:00A 3/22/2016 8:00A 3/22/2016 9:00A 3/22/2016 10:00A ETC…
HEIGHT A 0.153 0.155 0.156 0.154 0.153 ETC…
HEIGHT B 2.65 2.66 2.64 2.6 2.63 ETC…
HEIGHT C 1.35 1.36 1.33 1.35 1.33 ETC…
DIAMETER A 0.296 0.302 0.301 0.299 0.264 ETC…
DIAMETER B 0.034 0.034 0.036 0.033 0.033 ETC…
DIAMETER C 0.0296 0.024 0.026 0.025 0.024 ETC…

PLEASE HELP....
Parents
  • The easiest way is to automate from Excel - instead of PC-DMIS pushing data into Excel without knowing where to put it, you let Excel pull data from PC-DMIS and put it in the right place. We (Hexagon Metrology Nordic AB, Sweden) have made an Excel sheet that does what you want, but I don't know if we sell (or are allowed to sell) overseas... Check with marketing.se@hexagonmetrology.com if you're interested.

    The VBA in Excel is very like PC-DMIS Basic, so if you have a Basic script exporting the data you want, it should be quite easy to use almost the same code in Exel instead, just adding code for putting it in the right cell.
Reply
  • The easiest way is to automate from Excel - instead of PC-DMIS pushing data into Excel without knowing where to put it, you let Excel pull data from PC-DMIS and put it in the right place. We (Hexagon Metrology Nordic AB, Sweden) have made an Excel sheet that does what you want, but I don't know if we sell (or are allowed to sell) overseas... Check with marketing.se@hexagonmetrology.com if you're interested.

    The VBA in Excel is very like PC-DMIS Basic, so if you have a Basic script exporting the data you want, it should be quite easy to use almost the same code in Exel instead, just adding code for putting it in the right cell.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement