Welcome Guest
Log In | Register )
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
PrintE-mailLink
Avatar
Thread Starter
bgonçalves
Brasil
Member #92560
June 9, 2010
3277 Posts
Offline

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

    Avatar
    Norton, Ohio
    United States
    Member #194179
    December 3, 2018
    348 Posts
    Offline

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

    yes

      Avatar

      Belgium
      Member #214858
      April 17, 2021
      663 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?

        Avatar

        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:

        1271829
        14111226
        119343537
        2451827
        213273738
        37182235
        312192733
        411132635
        57181922
        528333438
        2226282937

        For a Fistful of Dollars – Per un pugno di dollari

          Avatar

          Belgium
          Member #214858
          April 17, 2021
          663 Posts
          Offline

          Or, if you have wheel templates from somewhere, you use those.

          Above, number 3 shouldn't be in the wheel. You don't mind! :)

            Avatar
            Thread Starter
            bgonçalves
            Brasil
            Member #92560
            June 9, 2010
            3277 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

              Avatar

              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:

              1271829
              14111226
              119343537
              2451827
              213273738
              37182235
              312192733
              411132635
              57181922
              528333438
              2226282937
              17263738

              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

                JeetKuneDoLotto's avatar - cK0gcqX
                Flat Earth
                United States
                Member #161360
                November 27, 2014
                291 Posts
                Offline

                yes

                what??  How??

                  AllenB's avatar - Cowboy Crix-yellow.jpg
                  Lincoln, California
                  United States
                  Member #167122
                  June 27, 2015
                  1068 Posts
                  Offline

                  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.

                    Avatar

                    Belgium
                    Member #214858
                    April 17, 2021
                    663 Posts
                    Offline

                    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. ...

                      Avatar

                      Belgium
                      Member #214858
                      April 17, 2021
                      663 Posts
                      Offline

                      What 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

                        Avatar
                        Norton, Ohio
                        United States
                        Member #194179
                        December 3, 2018
                        348 Posts
                        Offline

                        what??  How??

                        It's possible. I dont have the HOW, though. I'm currently stuck on my own projects.