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
  • Thank you, I will continue working with it and post again once i have come up with a program. Excuse me, I have to S,S,S before I go back to the grind called "WORK."


    sss?? wtf.

    To write a code for a family of parts using variables, it requires some high level programming. If you not comfortable with variables and logic statements, I would advise to look into mark sets, which will allow you to only measure features you want, per selection.

    Or do it the simple way (my way), I create 1 program, then I simply do Save As, and modify it, and so on for the rest of the programs. I don't like to complicate things unless I absolutely have to.
Reply
  • Thank you, I will continue working with it and post again once i have come up with a program. Excuse me, I have to S,S,S before I go back to the grind called "WORK."


    sss?? wtf.

    To write a code for a family of parts using variables, it requires some high level programming. If you not comfortable with variables and logic statements, I would advise to look into mark sets, which will allow you to only measure features you want, per selection.

    Or do it the simple way (my way), I create 1 program, then I simply do Save As, and modify it, and so on for the rest of the programs. I don't like to complicate things unless I absolutely have to.
Children
No Data