I’m thinking about a New Avatar. Mad Magazine is the source of the Graphics with some cropping and Text additions in Power Point. Depending on how this goes, I might have to try to change the Crows into Crickets.
The Title is Random vs Random. I borrowed the Graphics from Spy vs Spy.
You all know I Excel. I use the Program. Any reference to achievement is another question. The idea is to pit the Randbetween Function in Excel against the Randomness of the Lottery. The simplest version of this for Fantasy 5 (5/39) would be 5 Cells, each with a Randbetween Formula. Draw Order would use the same formula in each cell. Numerical Order Changes the Between Values for Each function ie, you can’t get a 36,37,38 or 39 in Position 1 and so on to you cant get a 1,2,3 or 4 in Position 5. You can set the output by adding Rows of the Function or Calc and copy the Results to get the number of combinations you want.
Filtering Data usually morphs into Selecting a Series of 0,1,2,3 in almost every System mining historical data. I have most of my Systems using only 1,2,3 as options. Without going into the source of the digits, I have set up 6-7 Groups that can be defined by a (5/39 Example) 5 Digit series of 1,2,3 that can be summarized as a 3 Digit code that counts the 1,2,3.
The Battle is between getting the Correct Value (1, 2 or 3) in the correct order multiple times (6-7) to define a set of numbers that will include the winner.
Description
|
P1
|
P2
|
P3
|
P4
|
P5
|
Filter 1
|
1
|
1
|
2
|
3
|
3
|
Filter 1
|
2
|
1
|
2
|
1
|
3
|
Filter 1
|
1
|
1
|
2
|
2
|
3
|
Filter 1
|
1
|
3
|
2
|
1
|
1
|
Filter 1
|
3
|
2
|
1
|
1
|
1
|
Filter 1
|
2
|
2
|
3
|
3
|
3
|
When all Filters are Active, there are 35 “Guesses” Required. You can mine the Data using you logic or you could place the function “=Randbetween(1,3)” in Each Cell. Chances are Huge that not all of the Values will be Right. You can Recover (maybe) by deciding how many correct answers you have in each column or you can do a Randbetween(1,7) at the bottom.
How many are Correct?
|
3
|
4
|
3
|
5
|
6
|
Below is an Example of the Output for My 7 Filters Run as My Side of Random.
|
Correct
|
4
|
4
|
4
|
5
|
4
|
|
|
|
N1 List (3)
|
N2 List (4)
|
N3 List (8)
|
N4 List (2)
|
N5 List (4)
|
|
|
1
|
09
|
01
|
10
|
24
|
30
|
|
|
2
|
19
|
03
|
12
|
27
|
33
|
|
|
3
|
23
|
07
|
20
|
|
36
|
|
|
4
|
|
11
|
21
|
|
39
|
|
|
5
|
|
|
23
|
|
|
|
|
6
|
|
|
26
|
|
|
|
|
7
|
|
|
30
|
|
|
|
|
8
|
|
|
32
|
|
|
|
|
9
|
|
|
|
|
|
|
|
10
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I am not saying this is any good. But it is a lot easier on my Brain letting Excel do the Guessing for me.