Welcome Guest
The time is now 1:22 am
You last visited January 18, 2017, 12:48 am
All times shown are
Eastern Time (GMT-5:00)

# Next step... raw data gathering

Published:

Last Edited: November 6, 2005, 10:49 am

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))

Entry #69

1.
Comment by Rip Snorter - November 6, 2005, 10:49 am
Interesting stuff. Thanks for sharing it.
Jack
2.
Comment by hypersoniq - November 6, 2005, 8:58 pm
in the above D3 is the vector, either SE(southeast) S(south, a repeat number) or SW(southwest)
E3 is the magnitude, or length of the line in whole units (obtain by subtracting the larger of the numbers from the smaller... e.g. PB 17 then PB 23, magnitude = 6

F3 is the result of the first formula

You must be a Lottery Post member to post comments to a Blog.