Welcome Guest
Log In | Register )
You last visited November 21, 2017, 12:10 pm
All times shown are
Eastern Time (GMT-5:00)

Building multi-tiered wheels on Excel

Topic closed. 18 replies. Last post 11 years ago by Rip Snorter.

Page 1 of 2
PrintE-mailLink
Avatar
Thread Starter
New Mexico
United States
Member #12305
March 10, 2005
2984 Posts
Offline
Posted: July 26, 2006, 11:55 am - IP Logged

I've been playing around with this to create nuts-and-bolts methods of doing it for some while.

Maybe it's no mystery to the rest of you, but to me it's been an eye opener what a difference it makes.

Anyone interested in discussing methods for doing this and why a person might wish to do so?

J

Absorb the good, ignore the bad, weigh the ugly.

It's about number behavior.

Egos don't count.

 

Dedicated to the memory of Big Loooser

 

    Avatar
    NASHVILLE, TENN
    United States
    Member #33372
    February 20, 2006
    1044 Posts
    Offline
    Posted: July 26, 2006, 12:14 pm - IP Logged

    I've been playing around with this to create nuts-and-bolts methods of doing it for some while.

    Maybe it's no mystery to the rest of you, but to me it's been an eye opener what a difference it makes.

    Anyone interested in discussing methods for doing this and why a person might wish to do so?

    J

    Sorry, Rip, but I have no clue as to what you mean.  Please define "multi-tiered" and please give me an example of what you are trying to accomplish.

    I am taking a few weeks off from "Cracking the Code" and need something else lottory related to occupy my time.

      Avatar
      Thread Starter
      New Mexico
      United States
      Member #12305
      March 10, 2005
      2984 Posts
      Offline
      Posted: July 26, 2006, 12:26 pm - IP Logged

      Sorry, Rip, but I have no clue as to what you mean.  Please define "multi-tiered" and please give me an example of what you are trying to accomplish.

      I am taking a few weeks off from "Cracking the Code" and need something else lottory related to occupy my time.

      Suppose you have a series of numbers with what you consider to be varying levels of probability for hitting on a given draw.  I

       Highest tier:

      If there's more of them than a single number, a key wheel won't suffice to get them into the most positions possible within the wheel.

      On the other hand, maybe there aren't enough to justify a full wheel for those considered most probable for hitting.

       Second tier:

       But also suppose you have another series of numbers you don't wish to have interrupt the occurance of the first set within your wheels, but you still think there's a strong probability of them hitting, not necessarily with one another, but rather with one or more of the first set.

      Third tier: 

       Now, say there's also half-a dozen numbers you see as having a high probability of hitting out of the corner of your eye, blind-siding you.  You don't want them to push out the Tier 1 and Tier 2 numbers, but you still want them in the mix, at least after the others are all covered every which way.

       That's what I'm talking about.

      Likely it's not something anyone else would want or need.

      Jack

      Absorb the good, ignore the bad, weigh the ugly.

      It's about number behavior.

      Egos don't count.

       

      Dedicated to the memory of Big Loooser

       

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: July 26, 2006, 12:55 pm - IP Logged

        Sounds complex.  But interesting!  What functions are you using? Or do you use a specific vba code?

        Is this something that can be done as a platinum member using the deflate feature to an extent?

        L ttaL   T

          undress's avatar - Lottery-061.jpg
          roseville, MI
          United States
          Member #5980
          July 30, 2004
          18205 Posts
          Offline
          Posted: July 26, 2006, 12:58 pm - IP Logged

          sounds very intersesting, do you have some program doing this that you are willing to share....for a test.....

          Mad ALL IN!Mad

            Raven62's avatar - binary
            New Jersey
            United States
            Member #17843
            June 28, 2005
            69663 Posts
            Online
            Posted: July 26, 2006, 1:20 pm - IP Logged

            Sounds interesting! How one arrives at which numbers are in the 3-Tiers is really interesting.

            Without an example I'm guessing you mean something like this:

            Tier-1
            25789

            Tier-2
            03678

            Tier-3
            12357

              RJOh's avatar - chipmunk
              mid-Ohio
              United States
              Member #9
              March 24, 2001
              20147 Posts
              Offline
              Posted: July 26, 2006, 1:34 pm - IP Logged

              CoverMaster allows you to build multi-tiered wheels.  For example, you can make a 7 number wheel with a guarantee of 4if5 and include it in a 10 number wheel with a guarantee of 3if5 and include them both in a 15 number wheel with a guarantee of 2if5, that way if 5 of the winning numbers are from the top seven numbers on your list you'll match 4 or at worst if they from the bottom five you'll match 2.  Be prepared to have you computer tied up for a while if you're working with more than 15 numbers or more than 3 tiers and want your wheel optimized to the smallest size.

              *CoverMaster can be downloaded at Lotto-Logix
              ** CoverMaster is designed to work with 3-7 digit numbers, I have experimented with pick3/4 by looking at them as 01 02 03 and 04 rather than 123&4. 

               * you don't need to buy more tickets, just buy a winning one * 
                 
                            Evil Looking       

                Avatar
                Thread Starter
                New Mexico
                United States
                Member #12305
                March 10, 2005
                2984 Posts
                Offline
                Posted: July 26, 2006, 1:42 pm - IP Logged

                Sounds complex.  But interesting!  What functions are you using? Or do you use a specific vba code?

                Is this something that can be done as a platinum member using the deflate feature to an extent?

                 Not too complicated, aside from getting around to doing it.  Once you get the hang of it it goes fairly quickly.  If I'm using any 'functions' I'm not aware of it.  I just color code the numbers in each tier so's I'm not getting duplicate numbers.

                For instance, Tier 1:

                 

                31

                33

                14

                 

                 

                31

                33

                31

                14

                14

                33

                Tier 2:

                4

                8

                21

                34

                21

                34

                21

                4

                34

                8

                34

                4

                4

                8

                 Tier 3

                22

                39

                16

                23

                21

                19

                22

                39

                22

                16

                22

                23

                22

                21

                22

                19

                16

                39

                16

                23

                16

                21

                16

                19

                16

                39

                 

                and so on

                31

                33

                21

                34

                16

                31

                14

                21

                4

                19

                14

                33

                34

                8

                23

                Just walkng the entire thing down the line

                That sort of thing.

                J

                Absorb the good, ignore the bad, weigh the ugly.

                It's about number behavior.

                Egos don't count.

                 

                Dedicated to the memory of Big Loooser

                 

                  Avatar
                  Thread Starter
                  New Mexico
                  United States
                  Member #12305
                  March 10, 2005
                  2984 Posts
                  Offline
                  Posted: July 26, 2006, 1:48 pm - IP Logged

                   A pick 6 wheel coming off Excel might look something like this:

                   

                  21

                  34

                  33

                  14

                  16

                  23

                  21

                  4

                  14

                  35

                  16

                  19

                  34

                  8

                  33

                  35

                  23

                  19

                  34

                  4

                  14

                  40

                  16

                  23

                  4

                  8

                  33

                  40

                  16

                  19

                  21

                  34

                  40

                  41

                  23

                  19

                  21

                  4

                  33

                  41

                  16

                  23

                  34

                  8

                  14

                  41

                  16

                  19

                  34

                  4

                  33

                  41

                  23

                  19

                  4

                  8

                  14

                  41

                  16

                  23

                  21

                  34

                  33

                  41

                  16

                  19

                  21

                  4

                  33

                  14

                  23

                  19

                  34

                  8

                  14

                  35

                  16

                  23

                  34

                  4

                  33

                  35

                  16

                  19

                  4

                  8

                  14

                  40

                  23

                  19

                  Absorb the good, ignore the bad, weigh the ugly.

                  It's about number behavior.

                  Egos don't count.

                   

                  Dedicated to the memory of Big Loooser

                   

                    RJOh's avatar - chipmunk
                    mid-Ohio
                    United States
                    Member #9
                    March 24, 2001
                    20147 Posts
                    Offline
                    Posted: July 26, 2006, 1:56 pm - IP Logged

                    In my example using CoverMaster, positions 1-7 is the top tier, 8-10 second tier and 11-15 is the bottom tier.  You put your best picks in positions 1-7 and your worst in positions 11-15 of the wheel.  You're not working with the actual numbers until you swap them with the positions in the wheel.

                     * you don't need to buy more tickets, just buy a winning one * 
                       
                                  Evil Looking       

                      Avatar
                      Thread Starter
                      New Mexico
                      United States
                      Member #12305
                      March 10, 2005
                      2984 Posts
                      Offline
                      Posted: July 26, 2006, 2:00 pm - IP Logged

                      sounds very intersesting, do you have some program doing this that you are willing to share....for a test.....

                      I test it every day on the predictions board, trying out different methods for doing it with my picks.

                      This just happens to be what I'm using now.

                      J

                      Absorb the good, ignore the bad, weigh the ugly.

                      It's about number behavior.

                      Egos don't count.

                       

                      Dedicated to the memory of Big Loooser

                       

                        Avatar
                        Thread Starter
                        New Mexico
                        United States
                        Member #12305
                        March 10, 2005
                        2984 Posts
                        Offline
                        Posted: July 26, 2006, 2:02 pm - IP Logged

                        CoverMaster allows you to build multi-tiered wheels.  For example, you can make a 7 number wheel with a guarantee of 4if5 and include it in a 10 number wheel with a guarantee of 3if5 and include them both in a 15 number wheel with a guarantee of 2if5, that way if 5 of the winning numbers are from the top seven numbers on your list you'll match 4 or at worst if they from the bottom five you'll match 2.  Be prepared to have you computer tied up for a while if you're working with more than 15 numbers or more than 3 tiers and want your wheel optimized to the smallest size.

                        *CoverMaster can be downloaded at Lotto-Logix
                        ** CoverMaster is designed to work with 3-7 digit numbers, I have experimented with pick3/4 by looking at them as 01 02 03 and 04 rather than 123&4. 

                        Thanks for the tip.

                        At the moment I've got about $2.95 worth of room on my hard drive.... can't even think about downloading more software.

                        But if that's the way this ought to be done, maybe sometime I'll figure out how to get more room on here and give it a shot.

                        Gracias,

                        Jack

                        Absorb the good, ignore the bad, weigh the ugly.

                        It's about number behavior.

                        Egos don't count.

                         

                        Dedicated to the memory of Big Loooser

                         

                          Avatar
                          Thread Starter
                          New Mexico
                          United States
                          Member #12305
                          March 10, 2005
                          2984 Posts
                          Offline
                          Posted: July 26, 2006, 2:20 pm - IP Logged

                          Sounds interesting! How one arrives at which numbers are in the 3-Tiers is really interesting.

                          Without an example I'm guessing you mean something like this:

                          Tier-1
                          25789

                          Tier-2
                          03678

                          Tier-3
                          12357

                          I suppose we all have different methods of arriving at our picks, and deciding what's most probable, what's least and so on.  I've described my particular methods on other threads.

                          But this was just a homespun, computer-dunce method of getting outside the wheel-box.  I wanted a wider variety of options than I could get at the wheel generator page, and RickG gave me the idea on a thread somewhere of 'mixing wheels'.

                          That's what got me started trying to find easy ways of doing it on Excel.  This one's sort of a 'wheels within wheels' concept, I suppose.

                          Sort of reminds me of a gearbox on a tractor.  All different sized wheels turning inside.

                          Jack

                          Absorb the good, ignore the bad, weigh the ugly.

                          It's about number behavior.

                          Egos don't count.

                           

                          Dedicated to the memory of Big Loooser

                           

                            Avatar
                            Thread Starter
                            New Mexico
                            United States
                            Member #12305
                            March 10, 2005
                            2984 Posts
                            Offline
                            Posted: July 26, 2006, 6:21 pm - IP Logged

                            The weakness to this, or any wheeling system other than a full one is the space it leaves between the  picks.  For instance, the UK Daily draws 7 numbers.  I'm still trying to work out a decent approach to 7 number draws.  These 4 of 7 hits would have been 6 of 7 if I'd done a better job of evaluating the probabilities of the numbers, or a better job of wheeling the ones I felt strongly about.

                             

                             

                            Rip Snorter UK NationalDaily PlayMatch 4  05-09-15-16-19-20-23  03-09-16-17-20-23-24 $10
                            Rip Snorter UK NationalDaily PlayMatch 4  03-05-09-15-20-22-23  03-09-16-17-20-23-24$10
                            Rip Snorter UK NationalDaily PlayMatch 4  05-09-15-16-19-20-24  03-09-16-17-20-23-24$10

                             

                             This pick is a demonstration, it seems to me, of the potential help tiered wheels can (could have) be (been).  I've learned a bit since this one was posted, so I think I might be able to improve it by mistakes noted because of this draw.

                            Absorb the good, ignore the bad, weigh the ugly.

                            It's about number behavior.

                            Egos don't count.

                             

                            Dedicated to the memory of Big Loooser

                             

                              Avatar
                              Thread Starter
                              New Mexico
                              United States
                              Member #12305
                              March 10, 2005
                              2984 Posts
                              Offline
                              Posted: July 26, 2006, 6:56 pm - IP Logged

                              This one was built today for the T-Ball draw.  As you can see, I only picked correctly on one number, plus the Thunderball.  But as it happened, hitting that one number repeatedly and having several high-tier numbers for the Thunderball allowed the draw to pay off in imaginary dollars more than the cost of imaginary wagers. 

                               

                               

                              Rip SnorterUK NationalThunderball1 + 1 04-08-16-19-33, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9
                              Rip SnorterUK NationalThunderball1 + 1 04-08-19-23-31, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9
                              Rip SnorterUK NationalThunderball1 + 1 08-19-31-33-34, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9
                              Rip SnorterUK NationalThunderball1 + 1 04-08-16-19-33, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9
                              Rip SnorterUK NationalThunderball1 + 1 08-16-19-31-34, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9
                              Rip SnorterUK NationalThunderball1 + 1 08-23-31-33-34, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9
                              Rip SnorterUK NationalThunderball1 + 1 08-16-19-33-34, Thunderball: 08  08-09-12-15-18, Thunderball: 08$9

                              Absorb the good, ignore the bad, weigh the ugly.

                              It's about number behavior.

                              Egos don't count.

                               

                              Dedicated to the memory of Big Loooser