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
  • There are multiple way to export to Excel and there are a multitude of threads on this subject.

    You can either run a script, use PCD2Excel, or export as a CSV.

    I tried looking everywhere for ways to customize Excel sheet but was unable to, thats really why i am asking. I have played with the options in the excel sheet output menu but still nothing. I wasnt able to get anywhere thats why i am asking. Can anyone point me in the right direction?
Reply
  • There are multiple way to export to Excel and there are a multitude of threads on this subject.

    You can either run a script, use PCD2Excel, or export as a CSV.

    I tried looking everywhere for ways to customize Excel sheet but was unable to, thats really why i am asking. I have played with the options in the excel sheet output menu but still nothing. I wasnt able to get anywhere thats why i am asking. Can anyone point me in the right direction?
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement