Easy enough to count the quantity a number hits within a given sample range, then invert(1) that result to flip the hot and cold values you have determined.
I am strictly talking about the number of times a number hits. Nothing here about how many draws ago.
=randbetween(1,6) will generate a random roll of the dice
600 cells of that randbetween formula results are shown in the chart below.
Next, we add 1, because all numbers can appear. Exclude none.
Next, we take that max value (114) and subtract the number of times the die landed on that number, (N) or column 2.
My method never excludes a number, in this case number 5. It can hit and should not be excluded.
600 Random die rolls |
(N)umber of times each die side appears |
+1 |
Max of 114 minus the (N)umber |
1 |
91 |
92 |
23 |
2 |
98 |
99 |
16 |
3 |
105 |
106 |
9 |
4 |
101 |
102 |
13 |
5 |
113 |
114 |
1 |
6 |
92 |
93 |
22 |
The sum of the 4th column 23+16+9+13+1+22=84
Now you can do a =randbetween(1,84) to generate a new range for a dice face. If the random number is 1 thru 23, it's a 1. If the random number is a 24 to 40, it's a 2. Nine more in the range will give you a 3. The max number is the sum of 84 and an 84 would be a 6.
There are Excel formulas to simplify the counting of the sum process. It's not fun done manually.
(1)There are countless ways to invert. This is just one example.
Another way to invert the rolls is about the number 100, which makes sense. A 91 turns into a 109. A 98 turns into a 102. A 100 stays 100. Etc.
---
How to wheel dice?
From the example above, you may want to only use hot dice (3,4,5) or wheel the cold dice (1,2,6)
Get dice right to the point where your selected hot or cold picks are better than 1 in 6, then expand your system to a larger lotto.
---
I have provided you with some math to perform one method.
With your very many questions, what have you learned?
Please share one of your methods that you have learned.