I put up a powerball sheet on my page
important... IT DOESN"T DO ANYTHING YET, it uses data all the way back to 1997 and it's small in size
the only "pick" it even attempts to make is the raw result of FORECAST
there are 4 sheets...
Worksheet 1. Draw Data
column A = draw date
columns B-F = white ball draw data SORTED (WS1-WS5)
column G = powerball
column H-L = white ball draw data DRAW ORDER (WD1-WD5)
column I = day of the week (wed./sat.)
column J = draw number
old draws are at the top, add new draws to the bottom...
Worksheet 2. Frequency
column A = number (1/55 covers PB 1-42 also)
column B = total count (how many times appeared in the game whether PB or WB)
column C-G = sort order freq.. how many times each number hit in each position (SORT ORDER)
column H = powerball frequency
column I-M = draw order freq..
row 58 contains the largest number of each column, this is for conditional formatting to allow the highest one to be highlighted.
Worksheet 3. Statistics
a look at some statistics for the game history
Worksheet 4. Cash Value Calculator
enter the data requested in the green cells (MUSL advertised cash value), see what you can actually expect if taking the cash value
don't know what else it's good for at this point, but it might be a good start for something...
uses formulas extended to row 2000 for fast recalcs (no need for F9 in this one), after row 2000 on history sheet, formulas will need to be changed... that's a LONG way off