[imanflash]

i work with 9 axis cnc (using for gold cutting) with sinumerik (840d) controler.
our cam program is ARTCAM & exported Gcode file only support 3axis .
i usually add some gcodes handly to this file. but its not possible always ( in larg files ).
i tried solving this problem by importing files to Excel program by inserting new columns & some functions in excel.
but the values is not configured in same column .for example in 4th column we have usually x parameters . but in some lines other values for example y parameters is in 4th column too.
in a other word icant do what i want with excel.
what can i do? with excel program or others to solving problem.
& to adding new values for A,B,C axis ?
do U know the program that based on excel ?

[Kiwi]

Can you give an example of your code before and after adding the ABC.
Also advise how the ABC is determined.

[imanflash]

yes. an example:

G54
G74 C0
G90 G0 X0 Y0 Z1 F2000
G90 G1 A45 B-28 F700
G90 G1 B27 C-10 F2000
G90 G1 Z-0.1 F720
G90 G1 X10 A90 F2000
.....

THE VALUES FOR B & A MAY BE WRITEN ANY WHERE..
A IS HEAHD 1 ( ROTATE 360 DEGREE)
B IS WORK HOLDER( ROTATE 60 DEGREE)
C IS ROTORY AXIS ( SHAFT AXIS )

[Guldberg]

You can have excel parse the expression so you get a column with each axis

[Kiwi]

If unable to import/parse the code to columns.

Open with Excel and number each line.
Use sort and move the code to the relative columns in large blocks.
Resort back to numerical order.

.....THE VALUES FOR B & A MAY BE WRITEN ANY WHERE..

Not sure if possible to write a macro if the ABC can be anywhere.

[mirciulica]

It is possible to use macro for EXCEL. You must generated 1 command in 1 cell and then you can transform in text to import in mach3 programs. Mirciulica