Ordering possible numbers?Previous TopicNext Topic

Hello all,

Does anyone know how to take "possible" numbers and order them into draw lines? I'm using a Pick 3 table in the example below:

Example A
3    0    8
3    6    4
3    6    4
8    9    1

Example B
0, 1, 3       
0, 1, 4       
0, 1, 6       
0, 1, 8       
0, 1, 9       
1, 3, 4   
etc. until all combinations are printed.

Is there a way to have the program take 1 of each of the numbers from Example A (without duplicating any numbers) and combine them into separate lines for ticket purchases as in Example B?

Thanks for any assistance

Using all the digits, 0, 1, 3, 4, 6, 8, 9, you'll have 35 combinations with 3 different digits (singles). If you want to include the doubles, add another 42 combos. You can use the Lottery Combinations Generator by putting "3" in the numbers of set, "1" in the minimum number and "7" in the maximum number but it shows the combinations using the digits 1 - 7.

There is a wheel generator on Lottery Director that allows you to use specific digits but you must use "10" for the "0".

Morning Stack47,

I have formulas that come up with the numbers for each draw. I was attempting to create a macro/script that would place these numbers into a format for ease of use. Therefore, I'm not looking for wheels or generators, etc., but a specific macro/script to do the deed. I've figured out how to sort the table of numbers, but, I haven't figured out how to have the program place the numbers into an order using each of the nuumbers in a given line.

Example:

3 numbers, or 4 numbers, or 5 numbers, or 6 numbers to a line, etc.

Thanks for the reply, but, I'm still attempting to figure it out.

Are you asking how to create only six-way box numbers from the numbers in table A?

Would 134 make the list but 314 be excluded?

Hello time*treat,

What I'm attempting to figure out is how to take my Example A numbers and order them into my Example B by using a macro/script whereby the macro/script uses all of the numbers from the Example A table once per combination. I've seen print outs of possible number combinations before, and am attempting to do the same thing with my numbers. My Example B is just a start, there would be several more lines when it finished printing. I'd like to do this for all of the games I track making it easier to prepare tickets.

Thanks for asking.

http://www.lotterypost.com/blog/14556

On Sheet1:

Start with 3,0,8 in row 1, cols 1~3

3,6,4 in row 2, cols 1~3

and so on.... the macro does the rest.

I have what you need and more. I am new to this forum and cannot paste the image, so if you can reply privately, I have your answer.

Hello time*treat,

Wow. Cool.

Now, what program is this created in? Is it Excel or Lotus123?

Thank you very much.

It's a vba macro for Excel.

Thank you, be back to you with the results.

Afternoon time*treat,

It took me a little bit of time to figure of what I needed to do within the Excel program, but it's in and working great. This will save a ton of time in ticket preparations for Pick 3 games when you've got more than 3 possible numbers to play.

I've also taken some time to understand how you created the sub and can see how it could be expanded for Pick 4, 5, or 6 drawn number games.

Have you ever done anything like this for a game with 2 input ranges, such as Mega Millions or Powerball? That would be fantastic. Talk about saving time...

Just what I was attempting to figure out. Thank you very much again.

I haven't done anything with the MM & PB games. A few of us kicked around some ideas, way back, but couldn't seem to come up with a way/system to select the bonus number with any better success than random.

Now, if you just want to take a group of self-selected bonus numbers and match them up with every possible combination of a main group of numbers, that's a matter of adding a couple more for-next loops, changing the output ranges, etc..

I have several different ways of coming up with what I consider "Possible Numbers" for a game. I have formulas that then put them all together into a table. Your Pick 3 Simple Builder will save me a lot of time. Once I modify it for the other games (Pick 4, 5, or 6 type games), it'll make it much faster to get things done.

As for Bonus ball games:

Exampe "A" - Possible White Balls

48    29     4    51    24
45    33     4    48    29
48    45    49    56    51
48    12    53    52    46
53    56    39    20    33

Example "B" - Possible Bonus Balls

36
27
39
36

Example "C" - Combined Possible Print Out

4, 12, 20, 24, 29 - 27
4, 12, 20, 24, 33 - 27
4, 12, 20, 24, 39 - 27
4, 12, 20, 24, 45 - 27
4, 12, 20, 24, 46 - 27
4, 12, 20, 24, 48 - 27

Looking at what the Simple Builder does, I don't see how to add the Possible Bonus Balls to the sub and have them still work out correctly. You describe what's needed as fairly simple to accomplish. If you have the time, Thank you. It'd be great.

Well, the Simple Builder is only checking P3 @ 1,000 combinations and with a little work could be expanded to handle P4 @ 10,000 combinations, but going to P5 & JP games requires a different level of modification. I'd call it a re-write.

Once you're ready to jump up to PB & MM, you're in 175 million combination territory. That will require a Far More Complex Builder.

If you do a search for lexicographic, you'll find vb code threads that relate to jackpot type games. That should give you an idea of what would be involved. The good thing is you won't have to build it up from scratch, you just have to understand the macros and be able to customize them to fit your needs.

time*treat,

I think I'm missing something... Looking at the code, I was under the belief that the sub took the available numbers and placed only those numbers in order. Are you saying that the system takes the code and creates the entire list of ordered numbers in it's memory, then only prints the number combinations from the numbers in the table?

As for lexicographic, I'd not heard of this before. I need to research this so that I can have an attempt at understanding...

Thank you again, you've inadvertently broadened my horizons.