Search

How do you all determine which numbers PB vs MM?Reply
I disagree. Hot numbers are prone to become cold, and cold to hot. Take the daily for example, as that is related to the image below, which isn't showing up using the Insert Image function for some reason. It is especially helpful to use a daily that goes back a long way to have the most data. Plot a countif() for whatever backperiod you like, whether that be the last 10 or 1000 draws, doesn't matter. You'll need 10 countif()'s for the numbers 0 through 9. Apply conditional formatting to the cou
May 21, 2016, 8:34 am - GoogilyMoogily - Jackpot Games Forum

[Request] Animated graph of all PB numbers drawn in current matrix
In this request, row one starts with the PB drawing on Jan 18, 2012. There have been 387 drawings at the current matrix. I'm requesting a macro pro to create an animation or gif of each draw as a graph showing the accumulated total of each number drawn. The first frame shows the numbers in rows 1:1, including 6, 29, 34, 44 and 50. The : isn't ratio, it's excel speak. The second frame shows the sum of (or countif in excel) all numbers drawn in rows 1:2, including 12, 24, 43, 44 and 45, thus showi
Oct 2, 2015, 8:53 am - GoogilyMoogily - Jackpot Games Forum

Excel Formulas for PB, and some Q's
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 examp
Jun 27, 2003, 2:06 pm - hypersoniq - Jackpot Games Forum

I have developed a method to play Jackpot Games.Reply
I use the following excel formula to convert a round of drawings into singles, twos,threes,... (see table 9 in the book). =CONCATENATE(0,0,COUNTIF($K$5:$O$10,$K5)) Below is an illustrated example of how i convert the first 6 drawings of a round. 5/6/2018 5 8 10 30 32 001 002 004 002 001 5/5/2018 10 11 13 23 34 004 002 001 001 003 5/4/2018 6 14 27 28 34 001 001 002 001 003 5/3/2018 4 25 27 31 34 001 001 002 001 003 5/2/2018 9 10 11 19 35 001 004 002 001 002
Jul 6, 2018, 10:52 pm - pavizlo$ - Jackpot Games Forum

A gif of the last 765 Cash 4 Life drawsReply
thanks do a COUNTIF(range,criteria) apply a color scale conditional format (blue=min=cold, white=50% percentile, red=max=hot) shrink the text to font size 1 since you can't conditionally format text, only the cell background same short column width for all columns screenshot easy enough to set up once then copy down a row of results per drawing lots of cells to calculate and conditional format tho it is the image that convinces me that in any non-pseudo random draw, the e
Apr 10, 2021, 8:18 am - GoogilyMoogily - Jackpot Games Forum

Who Can Do This Kind Of Chart/analyzer for JP games ?Reply
I think most programmers want to be hired. Some programmers just like programming. I guess you could say I built or programmed my own lottery program in excel. I dont use much of the fancy VBA stuff, as I dont know it yet but I use a lot of countif functions. Thanks for the website idea I will check it out. The only thing that scares me is giving out the holy grail to somebody who has not themselves thought of it. I am sure some sophisticated programmers such as RL, and JimWr
Jan 24, 2014, 9:44 pm - LottoBoner - Jackpot Games Forum

NY Sweet MillionsReply
using above...there are some interesting choices... first a power number pair...possibly.... 3 4 fib skips...0 1 another power number pair.................18 38 fib skips...1 0 just to let you know my birthday is the nineteenth so usind Kenneth Dickerssuns...lucky day scenario...i am actively hunting number 19... If you dont know KD was a columnist for new yorks publication Lotto News/Lotto Stats, and passed earlier this year. He was big on Kirlian photography. Best pairs wit
Apr 16, 2012, 6:12 pm - LottoBoner - Jackpot Games Forum