Ordering possible numbers?

Reply #16

KnuckleHead — Thu, 19 Jan 2012 04:20:28 GMT

time*treat,

Thank you for the explanation.

As for writing this stuff in your sleep , I'm already doing that. Sometimes their terrible nightmares though... Not having very much experience at writing code, I come up with different ideas to do the things in code that I'd normally do with keystrokes. It's a learning thing. If I can automate my keystrokes to simply clicking a button and having the sub do the work, then I've learned something new and am able to use some of it for the next projec... [ More ]

Reply #15

time*treat — Thu, 19 Jan 2012 03:29:05 GMT

What is happening here is that each number is given a status of active or inactive, based on if it is in Group A.

A count-up is given from 000 to 999 (although 789 would work just as well)

The count value is broken down into its 3 component digits.

These digits are checked to see if they are

a) low to high

b) unequal from each other and

c) all among the active numbers

Checking each combo is not the most efficient way to do things, but is the simplest to code and understand.

Reply #14

KnuckleHead — Thu, 19 Jan 2012 01:51:45 GMT

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

Reply #13

time*treat — Wed, 18 Jan 2012 23:54:39 GMT

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

Reply #12

KnuckleHead — Wed, 18 Jan 2012 23:17:28 GMT

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

Reply #11

time*treat — Wed, 18 Jan 2012 22:51:23 GMT

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

Reply #10

KnuckleHead — Wed, 18 Jan 2012 22:12:12 GMT

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

Reply #9

KnuckleHead — Wed, 18 Jan 2012 20:15:07 GMT

Thank you, be back to you with the results.

Reply #8

time*treat — Wed, 18 Jan 2012 19:47:47 GMT

It's a vba macro for Excel.

Reply #7

KnuckleHead — Wed, 18 Jan 2012 19:44:18 GMT

Hello time*treat,

Wow. Cool.

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

Thank you very much.

Reply #6

d1nonly — Wed, 18 Jan 2012 16:08:37 GMT

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.

Reply #5

time*treat — Wed, 18 Jan 2012 02:39:04 GMT

https://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.

Reply #4

KnuckleHead — Mon, 16 Jan 2012 22:14:24 GMT

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

Reply #3

time*treat — Mon, 16 Jan 2012 22:04:21 GMT

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

Reply #2

KnuckleHead — Mon, 16 Jan 2012 18:11:19 GMT

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

Reply #1

Stack47 — Mon, 16 Jan 2012 17:58:47 GMT

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 .

Ordering possible numbers?

KnuckleHead — Sun, 15 Jan 2012 22:34:21 GMT

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