draw to draw lines have now been done, also an excel sheet has been created that lists date, draw number, powerball number, vector (SW/S/SE), magnitude (length), line angle with respect to horizontal & line angle with respect to vertical.

rather than go through the rigors of hand-dimensioning each individual line, I cooked up 2 excel formulae to do that for me... using trig (arctangent) and learned something about excel... all excel trig functions operate in Radians, not Degrees, which is what I wanted... but functions exist that convert, also multiplying by (180/pi) does the conversion quicker.

I hand-dimensioned about 20 test points to be sure the excel data is valid and gels with the CAD data... it does. but this is just draw to draw for now, there is more that I will need to gather, but I need to bone up on some more trig to figure out what.

for those hardy souls still playing the home game, the excel formulae look like this...

for H Angle (Horizontal sweep)

=IF(D3="SE",(ATAN(1/E3)*180/PI()),IF(D3="SW",(-1*(ATAN(1/E3)*180/PI())),0))

for V Angle (Vertical Sweep * note the easier formula that is derived from the H Angle)

=IF(D3="SE",90-F3,IF(D3="SW",(-90-F3),0))