Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline
You build your full set of combinations with those numbers and you run your sub coverage(params()). Maybe you can do it with js too. I didn't do that one, but why not, a small set and let it do the same. How much can it take?
You might do this in Excel with functions, filtering or other. You proposed to use the random function in cells. ... Now you're asking?
bgonçalves Brasil
Member #92,560
June 9, 2010
3,778 Posts
Offline
almost there.example the macro generate from maximum year to numbers from previous draws of an 80/5 game
after generating the wheel or rather generating together with 20 numbers, then the macro will generate games on the wheel and filtering by the previous minimum and maximum limit draws
California United States
Member #167,122
June 27, 2015
1,634 Posts
Offline
Quote: Originally posted by JeetKuneDoLotto on Jul 19, 2021
what?? How??
With a great deal of time and effort.
There are probably many ways to do it and some sophisticated formulas that I do not know, but My Fifth Wheel is based on a an Option to put up to 10 Numbers in each position. I Try to keep the Output under 30,000 Combinations which is accomplished by limiting a couple of positions to 3 or 4 Numbers.
My Fifth Wheel uses a list of codes to fill each position in the Box. A Number can be placed in more than 1 Position which results in some invalid combinations. The hardest part of the Wheel set up was eliminating these null combinations. It took me quite a while to "stumble" on an "Indirect" Function and address calculation to put the combinations together. I seems to work well so long as I keep the Inventory of Numbers in Each position to around 5 numbers each.
Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline
Quote: Originally posted by AllenB on Jul 19, 2021
With a great deal of time and effort.
There are probably many ways to do it and some sophisticated formulas that I do not know, but My Fifth Wheel is based on a an Option to put up to 10 Numbers in each position. I Try to keep the Output under 30,000 Combinations which is accomplished by limiting a couple of positions to 3 or 4 Numbers.
My Fifth Wheel uses a list of codes to fill each position in the Box. A Number can be placed in more than 1 Position which results in some invalid combinations. The hardest part of the Wheel set up was eliminating these null combinations. It took me quite a while to "stumble" on an "Indirect" Function and address calculation to put the combinations together. I seems to work well so long as I keep the Inventory of Numbers in Each position to around 5 numbers each.
Mostly proposed systems are based on number groups using mathematical formulas avoiding the true all ways.
If you want to make a wheel ..., stop, what is a wheel? You mean like with coverage? If you do not accept filtering then you you go for the standard commercial wheels sold here and there, if not able to use templates from free wheels that you can find on internet.
What is it what you want the moment that you have your ideas in the head? Or are you on one tool, I think so, so you stop thinking, you are using. ...
If Excel can do wheeling with coverage? Yes, you first generate your full set, and then you apply your logic to make the set small with the given coverage(s). Eventually your knowledge is weak and your chosen program slow or cannot do much, not the same.
For the positional, it is filtering by positions, the other way was, like I said, building. To technical for you, you still are in the basic math. ...