If it was not random, then you would make a lot of money if someone made this macro for you. I had thought about doing that sort of thing in the past. The idea for not random would be that as balls get picked more frequently, it is likely that one or more of those would turn up again. Of course if the ball or balls are replaced at some point, the frequency will likely drop or increase. Someone knows how often balls are replaced. My guess is that they replace all balls periodically.
If you want help with that sort of thing, you should make the file with the history of past results and attach that file. I don't know if this forum prohibits this sort of post or not.
I have helped people refine random pick5 with powerball. e.g.
Quote:
R1 R2 R3 R4 R5 PB
11 21 31 41 57 14
03 14 25 51 53 10
17 32 42 45 55 10
|
History:
Quote:
DrawDate WB1 WB2 WB3 WB4 WB5 PB PP tf
1/18/2017 41 9 58 40 53 12 2 FALSE
1/14/2017 55 69 23 64 59 13 5 FALSE
1/11/2017 1 16 13 43 3 24 2 FALSE
1/7/2017 37 63 12 24 3 10 2 FALSE
1/4/2017 17 16 42 41 29 4 3 FALSE
|
pp=powerplay, tf=True if a ball is same as powerball. For 20 years, there was a 9% chance that tf=True.
I think that I would trust my random picks over the random picks at the lotto machines. I only get a PB pick when it gets over 200 million. I mean, what can one do with a measly 199 million?
08-09-2019, 05:50 PM
Similar Threads
Excel VBA interprets numeric values from worksheet formatted as General in several ways
Windows 10 
Office 2016
Hybrid Mode