Some of you might find this useful.

I like to edit parts and machine tokens in the spreadsheet and usually have to rely on trial and error to get the orientation correct so I made this thing.

Enter your panels Width, Length, and Machine Points here:

The graph will update to show the panels LENGTH, WIDTH, ORIENTATION, and MACHINE POINT:

Then you can paste a PLINE token in from cell F5 here:

(paste values so you don't overwrite formatting)

You'll see the graph updates with the vectors from the pasted PLINE token.

Now you can select PLINE or CUTOUT from cell F5

If you have PLINE selected it will convert the pasted PLINE points into a VECTOR formula.

If your pasted PLINE makes up a rectangular shape, you can select CUTOUT in cell F5 to convert it to a CUTOUT token. This is handy for when you've drawn a pocket route in the 2D parts editor since they come in as PLINES and CUTOUTS are easier to maintain.

You can select X ORIGIN and Y ORIGIN to modify the token to use PANEL_LENGTH and PANEL_WIDTH as origin points instead of 0,0

To get this into the MV spreadsheet, copy the cells you need from ROW 6.

Then paste VALUES into the MV spreadsheet, keep the pasted cells highlighted, then do a CTRL+H (replace) to find and replace the ' character, and replace it with nothing (runs into problems if i leave the ' character out).

--OR--

You can create a PLINE token in the VECTOR CREATOR section. Just type your X and Y values, and give it a depth, and it will spit out a vector formula.

The graph will present a live representation of your X and Y positions as you enter them.

You can use PANEL_LENGTH and PANEL_WIDTH in this section to make a parametric vector.

To get that data in MV, copy the contents of the cell below FULL VECTOR

Once again paste VALUES into the MV spreadsheet, and then do a find and replace of the ' character, and replace it with nothing.

When I get more time I'd like to add:

      -ability to add in defined names when using the VECTOR CREATOR

      -make the graph present a bit better (was thrown together a bit hastily)

      -add more machine tokens (BORE would be especially handy)

**I had to make it a macro enabled spreadsheet to use the EVALUATE feature to convert a text string of math into an excel readable formula:

I would have much preferred to just use excel formulas so if anyone knows a way around this please let me know!**

Cheers,