Welcome Guest
You last visited September 23, 2021, 6:48 am
All times shown are
Eastern Time (GMT-5:00)

# wheels with limited amount of numbers from previous draws!! is it possible to build in excel?

Topic closed. 11 replies. Last post 2 months ago by Cmoore50.

 Page 1 of 1
 dr sanThread StarterbgonÃ§alvesBrasilMember #92560June 9, 20103277 PostsOffline June 18, 2021, 12:33 pm⮟wheels with limited amount of numbers from previous draws!! is it possible to build in excel?
 Cmoore50Norton, OhioUnited StatesMember #194179December 3, 2018348 PostsOffline June 18, 2021, 1:04 pmQuote: Originally posted by dr san on June 18, 2021wheels with limited amount of numbers from previous draws!! is it possible to build in excel?yes
 SpelerBelgiumMember #214858April 17, 2021663 PostsOffline June 18, 2021, 2:09 pmYou 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?

Belgium
Member #214858
April 17, 2021
663 Posts
Offline

Some real time.

FA5 CA USA

5 drawings, F : N[]

[3] 29
[2] 1 7 38
[1] 2 4 5 11 12 13 18 19 22 26 27 28 33 34 35 37

Create full wheel.

Combinations count: 20349

Let's say that you do 100 trials. You might get with 2/5 coverage:

 1 2 7 18 29 1 4 11 12 26 1 19 34 35 37 2 4 5 18 27 2 13 27 37 38 3 7 18 22 35 3 12 19 27 33 4 11 13 26 35 5 7 18 19 22 5 28 33 34 38 22 26 28 29 37

For a Fistful of Dollars – Per un pugno di dollari

 SpelerBelgiumMember #214858April 17, 2021663 PostsOffline June 18, 2021, 2:29 pmOr, if you have wheel templates from somewhere, you use those.Above, number 3 shouldn't be in the wheel. You don't mind! :)
 dr sanThread StarterbgonÃ§alvesBrasilMember #92560June 9, 20103277 PostsOffline June 19, 2021, 4:36 amalmost 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

Belgium
Member #214858
April 17, 2021
663 Posts
Offline

Some real time.

FA5 CA USA

5 drawings, F : N[]

[3] 29
[2] 1 7 38
[1] 2 4 5 11 12 13 18 19 22 26 27 28 33 34 35 37

Create full wheel.

Combinations count: 20349

Let's say that you do 100 trials. You might get with 2/5 coverage:

 1 2 7 18 29 1 4 11 12 26 1 19 34 35 37 2 4 5 18 27 2 13 27 37 38 3 7 18 22 35 3 12 19 27 33 4 11 13 26 35 5 7 18 19 22 5 28 33 34 38 22 26 28 29 37
 1 7 26 37 38

Several 2/5's.

Combinations: 11
0 2
1 4
2 5

We wouldn't want to post a 5/5. :)

For a Fistful of Dollars – Per un pugno di dollari

 JeetKuneDoLottoFlat EarthUnited StatesMember #161360November 27, 2014291 PostsOffline July 19, 2021, 3:04 pmQuote: Originally posted by Cmoore50 on June 18, 2021yeswhat??  How??
 AllenBLincoln, CaliforniaUnited StatesMember #167122June 27, 20151068 PostsOffline July 19, 2021, 7:18 pmQuote: Originally posted by JeetKuneDoLotto on July 19, 2021what??  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.
 SpelerBelgiumMember #214858April 17, 2021663 PostsOffline July 22, 2021, 8:19 amQuote: Originally posted by AllenB on July 19, 2021With 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. ...
 SpelerBelgiumMember #214858April 17, 2021663 PostsOffline July 22, 2021, 8:22 amWhat can save you game? Right, the right picks. It was proposed that system users would get free anything in the casinos as they wouldn't win anyway.For a Fistful of Dollars – Per un pugno di dollari
 Cmoore50Norton, OhioUnited StatesMember #194179December 3, 2018348 PostsOffline July 22, 2021, 10:31 amQuote: Originally posted by JeetKuneDoLotto on July 19, 2021what??  How??It's possible. I dont have the HOW, though. I'm currently stuck on my own projects.

 Page 1 of 1