Building multi-tiered wheels on Excel

Reply #18

Rip Snorter — Thu, 27 Jul 2006 01:34:54 GMT

Thanks cssenior:

I just went there and it appears it might help a lot. Thanks much.

Gracias,

Jack

Reply #17

CSenior — Thu, 27 Jul 2006 01:26:04 GMT

Jack~ Sorry I missed this post earlier... Here is a link to a tool that will help you clean up your harddrive in a snap by deleting all of your temp files. This tool actually reclaimed 150MB of my harddrive space and the best part is the program is free

Reply #16

Rip Snorter — Thu, 27 Jul 2006 00:52:00 GMT

Thanks csenior:

Those hits today on Pennsylvania and Delaware Win for Life are a direct result of the 'gearbox' approach (tiered wheels) to wheeling numbers.

Delaware's more proof it needs refining and honing down, but it's also good support for the notion it's a good track.

Gracias,

Jack

Reply #15

CSenior — Wed, 26 Jul 2006 23:03:23 GMT

Rip~ You are doing great work! Thanks for sharing

Reply #14

Rip Snorter — Wed, 26 Jul 2006 22:56:03 GMT

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... [ More ]

Reply #13

Rip Snorter — Wed, 26 Jul 2006 22:21:58 GMT

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... [ More ]

Reply #12

Rip Snorter — Wed, 26 Jul 2006 18:20:40 GMT

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.... [ More ]

Reply #11

Rip Snorter — Wed, 26 Jul 2006 18:02:36 GMT

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

Reply #10

Rip Snorter — Wed, 26 Jul 2006 18:00:27 GMT

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

Reply #9

RJOh — Wed, 26 Jul 2006 17:56:17 GMT

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.

Reply #8

Rip Snorter — Wed, 26 Jul 2006 17:48:18 GMT

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

2... [ More ]

Reply #7

Rip Snorter — Wed, 26 Jul 2006 17:42:41 GMT

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... [ More ]

Reply #6

RJOh — Wed, 26 Jul 2006 17:34:11 GMT

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 numbe... [ More ]

Reply #5

Raven62 — Wed, 26 Jul 2006 17:20:05 GMT

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

Reply #4

undress — Wed, 26 Jul 2006 16:58:52 GMT

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

Reply #3

lottaloot — Wed, 26 Jul 2006 16:55:15 GMT

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

Reply #2

Rip Snorter — Wed, 26 Jul 2006 16:26:43 GMT

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... [ More ]

Reply #1

GASMETERGUY — Wed, 26 Jul 2006 16:14:43 GMT

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.

Building multi-tiered wheels on Excel

Rip Snorter — Wed, 26 Jul 2006 15:55:17 GMT

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