Excel Formulas for PB, and some Q's

Reply #3

CASH Only — Fri, 27 Jun 2003 18:29:31 GMT

H:I was being sarcastic about Stupid-6.

Reply #2

hypersoniq — Fri, 27 Jun 2003 18:15:05 GMT

Don't know... I haven't really even played the lottery on any regular basis until PA got in on Powerball.

Reply #1

CASH Only — Fri, 27 Jun 2003 18:09:13 GMT

H:I suppose it could never work for Super-6...

Excel Formulas for PB, and some Q's

hypersoniq — Fri, 27 Jun 2003 18:06:55 GMT

Here are some simple Excel formulas to apply up-down, Decade, and Even-Odd transforms to Powerball DataFormula for Up-Down...=IF(C2<C3, U ,IF(C2=C3, x , D ))Formula for Decades...=IF(C2>49,6,IF(C2>39,5,IF(C2>29,4,IF(C2>19,3,IF(C2>9,2,1)))))Formula for Even-Odd...=IF((C2/2)-(INT(C2*0.5))=0, E , O )***NOTE, Replace E O D U with 1 0 1 0 to be able to use further analysisCounting times a number was drawn...1. number 1 to 53 down a column, using the first cell for a label (for example column AD)2. en... [ More ]