Building multi-tiered wheels on ExcelPrev Topic Next Topic

Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 11:55 am

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
GASMETERGUY

NASHVILLE, TENN
United States
Member #33,371
February 20, 2006
1,044 Posts
Offline

Jul 26, 2006, 12:14 pm

Quote: Originally posted by Rip Snorter on Jul 26, 2006
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.
Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 12:26 pm

Quote: Originally posted by GASMETERGUY on Jul 26, 2006
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

Redford/MI
United States
Member #3,396
January 18, 2004
4,867 Posts
Offline

Jul 26, 2006, 12:55 pm

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

100

Royal Oak, MI
United States
Member #5,980
July 30, 2004
18,636 Posts
Offline

Jul 26, 2006, 12:58 pm

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

ALL IN!
Raven62

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Jul 26, 2006, 1:20 pm

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

100

mid-Ohio
United States
Member #9
March 24, 2001
20,272 Posts
Offline

Jul 26, 2006, 1:34 pm

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 every combination, just the winning ones *
Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 1:42 pm

Quote: Originally posted by lottaloot on Jul 26, 2006
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
Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 1:48 pm

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

100

mid-Ohio
United States
Member #9
March 24, 2001
20,272 Posts
Offline

Jul 26, 2006, 1:56 pm

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 every combination, just the winning ones *
Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 2:00 pm

Quote: Originally posted by undress on Jul 26, 2006
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
Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 2:02 pm

Quote: Originally posted by RJOh on Jul 26, 2006
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
Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 2:20 pm

Quote: Originally posted by Raven62 on Jul 26, 2006
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

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 6:21 pm

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.

It's about number behavior.

Egos don't count.

Dedicated to the memory of Big Loooser

Rip Snorter

New Mexico
United States
Member #12,305
March 10, 2005
2,984 Posts
Offline

Jul 26, 2006, 6:56 pm

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.

It's about number behavior.

Egos don't count.

Dedicated to the memory of Big Loooser

New Topic New Poll

Subscribe to this topic

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

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

Building multi-tiered wheels on ExcelPrev TopicNext Topic

Building multi-tiered wheels on ExcelPrev Topic Next Topic

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