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

enjoy