hexagon logo

incorporating excel to make part programs

Hello everyone. I would like to know if it is possible to use excel (or some program like it) to help quickly write a program to measure cylindrical parts. The parts consist of 9 ODs and IDs that are concentric to one another. Most of the parts I need to measure are somewhat like this and I aim to write the programs as quick as possible in off-line mode. Quickly because my time-frame is limited and off-line because I have a lot of distractions at the office that doesn't help me get focused on completing the programs. So, does anyone have any suggestions to offer me? I have developed simple excel sheets to give me points in the past to help me write programs, but that involves a lot of manual editing of X,Y,Z,I,J,Ks. My initial thought was to find a way to incorporate excel or use copy and paste with pattern. I have used copy and paste with pattern with some success and I have not been able to figure out how to incorporate excel. Can someone 'point me in the right direction' so I can get closer to my goal? Thank you for your time and I would appreciate to hear any ideas that I can 'mull' over. Have a great day! By the way, I do have access to IGS and STP files.
Parents
  • It really depends on what you're doing an how similar they are.

    You can easily(ish) read in from a text file and input those values into PC-Dmis - it's called parametric programming.

    I'll post a simple example of the usage in PC-Dmis in a bit (program running right now) - although I'm not reading from a text file it will give you a feel for things.

    Also you don't need to go as far as calculating hits xyz's and ijk's, you just feed the diameter / location into an auto feature and it will adjust the hits for you.
Reply
  • It really depends on what you're doing an how similar they are.

    You can easily(ish) read in from a text file and input those values into PC-Dmis - it's called parametric programming.

    I'll post a simple example of the usage in PC-Dmis in a bit (program running right now) - although I'm not reading from a text file it will give you a feel for things.

    Also you don't need to go as far as calculating hits xyz's and ijk's, you just feed the diameter / location into an auto feature and it will adjust the hits for you.
Children
No Data