I want to be able to use a spreadsheet to make some changes in the g code my cam program is outputting. I am fairly handy with a spreadsheet, so I would like to use one to do the programming, unless someone knows of something better.
I have included some images of what I want to do, to make it easier to understand.
Step one - g code
Step two - insert spaces in code
Step three - import into spreadsheet
I know how to do these three steps, so that I end up with what is shown in the images.
Step four - I want to sort the data in step three into the appropriate columns, as shown.
Step five - I want to fill in the blank fields with the value of the field above it.
I want to use the math formula capabilities of a spreadsheet to average the value of certain Z values to smooth out the Z portion of the tool path. The cam software is giving me a lot of up and down values, along a steep sidewall, that are effecting the quality of my cut for a mold I am making. If I average those z values, I will end up with a smooth transition, as the tool moves along the sidewall.