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.
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.
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.