Welcome Guest
You last visited January 16, 2017, 7:51 am
All times shown are
Eastern Time (GMT-5:00)

# Building multi-tiered wheels on Excel

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

 Page 1 of 2
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.

Egos don't count.

Dedicated to the memory of Big Loooser

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.

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.

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

Jack

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

Egos don't count.

Dedicated to the memory of Big Loooser

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

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

ALL IN!

New Jersey
United States
Member #17843
June 28, 2005
50955 Posts
Offline
 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

mid-Ohio
United States
Member #9
March 24, 2001
19891 Posts
Online
 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 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 ticket *

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.

Egos don't count.

Dedicated to the memory of Big Loooser

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.

Egos don't count.

Dedicated to the memory of Big Loooser

mid-Ohio
United States
Member #9
March 24, 2001
19891 Posts
Online
 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 ticket *

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.

Egos don't count.

Dedicated to the memory of Big Loooser

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

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.

Egos don't count.

Dedicated to the memory of Big Loooser

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.

Egos don't count.

Dedicated to the memory of Big Loooser

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 National Daily Play Match 4 05-09-15-16-19-20-23 03-09-16-17-20-23-24 \$10 Rip Snorter UK National Daily Play Match 4 03-05-09-15-20-22-23 03-09-16-17-20-23-24 \$10 Rip Snorter UK National Daily Play Match 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.

Egos don't count.

Dedicated to the memory of Big Loooser

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 Snorter UK National Thunderball 1 + 1 04-08-16-19-33, Thunderball: 08 08-09-12-15-18, Thunderball: 08 \$9 Rip Snorter UK National Thunderball 1 + 1 04-08-19-23-31, Thunderball: 08 08-09-12-15-18, Thunderball: 08 \$9 Rip Snorter UK National Thunderball 1 + 1 08-19-31-33-34, Thunderball: 08 08-09-12-15-18, Thunderball: 08 \$9 Rip Snorter UK National Thunderball 1 + 1 04-08-16-19-33, Thunderball: 08 08-09-12-15-18, Thunderball: 08 \$9 Rip Snorter UK National Thunderball 1 + 1 08-16-19-31-34, Thunderball: 08 08-09-12-15-18, Thunderball: 08 \$9 Rip Snorter UK National Thunderball 1 + 1 08-23-31-33-34, Thunderball: 08 08-09-12-15-18, Thunderball: 08 \$9 Rip Snorter UK National Thunderball 1 + 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.