Welcome Guest
The time is now 9:45 am
You last visited July 24, 2017, 9:05 am
All times shown are
Eastern Time (GMT-5:00)

Powerball Excel Sheet available for d/l

Published:

Last Edited: January 8, 2006, 3:01 pm

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

Entry #107