|Posted: January 27, 2006, 8:17 pm - IP Logged|
Are you after a graph?
I have a "grid" for numbers
it spans 55 columns 1-55 in the cells from left to right
as it stands now, I can enter a powerball drawing into a set of cells, and on the grid... white balls are indicated by yellow highlighting, powerball is indicated in red highlighting, and the "coincident match" (powerball is same as a white ball) turns the cell inthe grid black w/ white text.
this is basically an entirely automatic way to produce the late kbcherokee's excel "bell curve". (he did it by hand)
I will be creating named ranges to handle WB1-WB5 and PB, what I want is the ability to read the numbers from the results array, then connect the corresponding points in the "grid" with different colored lines.
I had an old sheet where I did this by hand for a few hundred draws, tedious work to be sure, but of all the systems, it seemed to have the best potential. I let the sheet get behind because of the tedious update procedure (I had 1 sheet for each position WB1 thru PB and another that had all of them on it). I would like to re-visit the "bell curve" concept, only this time spend more of my time on interpretation rather than updating.
drawing lines by hand is a bit sloppy, and "snap to grid" attempts to connectitto a cell border line, no good for the project at hand. I am hoping to find a way to calculate the x,y coordinates of the cell center and connect the points with lines using a macro or vba code.
I have done this for PB data in AutoCAD, but that lacks the spreadsheet features needed (and it was also tedious). What I have gained from the AutoCAD experiment is a trig formula for excel that looks at the last 2 draws and calculates the resultant angle based on their grid position.
for any 2 consecutive draws (positional, i.e. WB1 to WB1)...
A.) LSV (line slope vector) this is the approach pattern, either SW, S or SE. Southwest (SW) represents the first number being lower than the second... South (S) is a repeat number... SouthEast (SE) is the first number being larger than the second...
B.) Length of line (how long is the line in "grid units"?
C.) Angle of deviation from Horizontal
South = 90 degrees
East = 0 (SE=+)
West = 0 (SW=-)
D.) Angle of deviation from Vertical
South = zero degrees
East = 90 degrees
West = -90 degrees
I have no real idea where I am going with this just yet, but I would like to be able to see the lines corresponding to the data I am looking at. I am basically trying to move outside the traditional lottery system box and employ some trig and maybe calculus to the data to see what emerges (other than chaos). My end goal will be to take the bell curve idea and refine and tweak it into a more accurate number picker (chief used the bell curve in MM challenges)
any help appreciated ;-)
Playing more than one ticket per game is betting against yourself.