Welcome Guest
You last visited December 3, 2016, 6:52 pm
All times shown are
Eastern Time (GMT-5:00)

Help with "Possible" numbers formula.

Topic closed. 18 replies. Last post 7 years ago by winsumloosesum.

 Page 1 of 2

United States
Member #73037
April 3, 2009
147 Posts
Offline
 Posted: April 17, 2010, 10:57 am - IP Logged

Morning again all,

This is 2nd question that I've been burning up gray matter over.

Has anyone been able to construct a formula or write code that could look at a table of numbers, disregard any multiple numbers, then place the numbers into "ticket" formats (depending on the number of picks) using all of the number combinations?

Example of a Pick 6 table:
42    52    48    40    32    54
52    48    42    39    54    49
42    40    47    39    31    27
19    17    42    24    31    16
26    22     7     31    52    16

Based on my tables, I've had several numbers show up in a single drawing, but never on the same line.

Again, thanks for any thoughts or assistance with this idea.

The only DUMB question is the one question you DID NOT ask...

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: April 18, 2010, 7:24 pm - IP Logged

Morning again all,

This is 2nd question that I've been burning up gray matter over.

Has anyone been able to construct a formula or write code that could look at a table of numbers, disregard any multiple numbers, then place the numbers into "ticket" formats (depending on the number of picks) using all of the number combinations?

Example of a Pick 6 table:
42    52    48    40    32    54
52    48    42    39    54    49
42    40    47    39    31    27
19    17    42    24    31    16
26    22     7     31    52    16

Based on my tables, I've had several numbers show up in a single drawing, but never on the same line.

Again, thanks for any thoughts or assistance with this idea.

Not sure if this is what you needed.

1.  Pick 5

2.  Pick 6

http://www.box.net/shared/yxpc42hvek

There is only 1 Tab in each of the 2 Excel files.

There are Steps in each of the Tabs.

The Pick 6 is what you really need so I created a Pick 6 Table just like you posted above.  I entered all the values in the "Pick 6 Table" and sorted and removed all duplicate values.

If you follow the Steps you will be able to run all the combinations based on the number of digits you have after all the duplicates have been removed.

The only thing is that when you run the last step to generate combinations it may take about 30 seconds to calculate based on the number of digits to wheel into combinations.

The other issue is that any combinations over 65,000 will result in an "Alert Box".  Due to the limitations with Excel 2002 you will not be able to generate more than 65,000 combinations.

Hope this helps!!

Let me know if you have any questions.

Good Luck!

United States
Member #73037
April 3, 2009
147 Posts
Offline
 Posted: April 19, 2010, 12:26 pm - IP Logged

Morning winsumloosesum,

Thank you. I did a PM to you regarding the files.

The only DUMB question is the one question you DID NOT ask...

CA
United States
Member #84266
December 26, 2009
410 Posts
Offline
 Posted: April 21, 2010, 4:56 am - IP Logged

Is it possible to generate a complete list of combinations of X numbers from range y-z using your file?

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: April 21, 2010, 7:55 am - IP Logged

Is it possible to generate a complete list of combinations of X numbers from range y-z using your file?

You can enter any number of digits.  The limit is that the list can't go over 65,000 combinations (Excel 2002). Use either the Pick 5 or Pick 6 Excel file and enter your numbers in the Table.  Just follow the steps in the Tab.

This is actually a decent wheeling file because you can enter the digits you want to wheel.

Houston
United States
Member #62319
June 24, 2008
242 Posts
Offline
 Posted: April 22, 2010, 5:56 pm - IP Logged

To the OP,

Let me test my method against your math.

I never did a Pick 3,4 or 5. Give me the last 10 plays of your state's Pick 3 or 4 game. Line it up with the latest being at the bottom and the previous numbers at the top ( a descending order).

Only post the first 9 plays of the Pick 3 or 4 games and I will predict the 10th play in a matter of minutes and tell me how I did.

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: April 22, 2010, 6:19 pm - IP Logged

To the OP,

Let me test my method against your math.

I never did a Pick 3,4 or 5. Give me the last 10 plays of your state's Pick 3 or 4 game. Line it up with the latest being at the bottom and the previous numbers at the top ( a descending order).

Only post the first 9 plays of the Pick 3 or 4 games and I will predict the 10th play in a matter of minutes and tell me how I did.

Cool.

Here ya go

545 046 274 737 732 787 438 792 063
new york
United States
Member #52681
June 4, 2007
2216 Posts
Offline
 Posted: April 22, 2010, 6:25 pm - IP Logged

i think you should read spirit blog she tell how to pick your pick3

trust and belive

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: April 22, 2010, 6:32 pm - IP Logged

i think you should read spirit blog she tell how to pick your pick3

Are you referring to Spirit2010 blog?

Houston
United States
Member #62319
June 24, 2008
242 Posts
Offline
 Posted: April 22, 2010, 6:37 pm - IP Logged

Cool.

Here ya go

545 046 274 737 732 787 438 792 063

Actually I need more than 10 numbers. I found the patterns and sequence but couldn't complete it because of a lack of numbers.

However, for the next (the 10th play), the last number of the 3 number will be  either a 5 or 8 ( if the numbers are big numbers from 5 to9).

I.E.: X X 5

or

X X 8

Tell me if I'm right.

I would probably need 20 to 30 numbers to get a complete read and a full grip on the pattern/sequence.

Texas
United States
Member #86154
January 30, 2010
1648 Posts
Offline
 Posted: April 22, 2010, 6:38 pm - IP Logged

To the OP,

Let me test my method against your math.

I never did a Pick 3,4 or 5. Give me the last 10 plays of your state's Pick 3 or 4 game. Line it up with the latest being at the bottom and the previous numbers at the top ( a descending order).

Only post the first 9 plays of the Pick 3 or 4 games and I will predict the 10th play in a matter of minutes and tell me how I did.

'Tank, I'd be curious to kow why you've never "did" a Pick game before. In my opinion, a person needs to know at least a reasonable amount about "working" these games before jumping into the Major Leagues. Don't you know that it's easier to match numbers here, more consistently, and make some money for your efforts if carefully executed?

I mean, (3) numbers with MM pays really nothing as opposed the same (3) numbers in Pick 3 will net around \$40-\$50...maybe more depending on how it's played. Pick 3 will pay you...MM won't, unless you net 5+0 or all of them. Think about this when you have time...

Nothing wrong with wanting the big money but, gotta know how to make a little money first. My .02.

L.L.

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: April 22, 2010, 6:40 pm - IP Logged

Actually I need more than 10 numbers. I found the patterns and sequence but couldn't complete it because of a lack of numbers.

However, for the next (the 10th play), the last number of the 3 number will be  either a 5 or 8 ( if the numbers are big numbers from 5 to9).

I.E.: X X 5

or

X X 8

Tell me if I'm right.

I would probably need 20 to 30 numbers to get a complete read and a full grip on the pattern/sequence.

You are correct the last digit is an 8.  The 10th draw was 888

Florida
United States
Member #66575
October 30, 2008
3549 Posts
Offline
 Posted: April 22, 2010, 6:52 pm - IP Logged

Heres last 20 combo's

want to give it a try ?

These are Eve only  or do you need combined draws ?

 619 780 399 818 864 013 090 315 342 901 642 867 556 128 913 722 438 802 389 890 824 779 ThanksCarliG
Houston
United States
Member #62319
June 24, 2008
242 Posts
Offline
 Posted: April 22, 2010, 6:59 pm - IP Logged

Heres last 20 combo's

want to give it a try ?

These are Eve only  or do you need combined draws ?

 619 780 399 818 864 013 090 315 342 901 642 867 556 128 913 722 438 802 389 890 824 779 ThanksCarliG

I don't want to keep predicting for people. I just wanted to see how my method fares against it. However, I only test the last column of the number and my method produced :

XX5

or

XX7

or

XX8

If it's a smaller number, it's definitely

1XX

Tell me if I'm right. If I'm wrong it's because I didn't institute the full scope of the method. I kind did it off the head. Tell me anwyay....?

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Online
 Posted: April 22, 2010, 7:02 pm - IP Logged

I don't want to keep predicting for people. I just wanted to see how my method fares against it. However, I only test the last column of the number and my method produced :

XX5

or

XX7

or

XX8

If it's a smaller number, it's definitely

1XX

Tell me if I'm right. If I'm wrong it's because I didn't institute the full scope of the method. I kind did it off the head. Tell me anwyay....?

Next winning combo was 8-3-2

 Page 1 of 2