Welcome Guest
You last visited May 24, 2017, 1:50 pm
All times shown are
Eastern Time (GMT-5:00)

# lottery formula

Topic closed. 16 replies. Last post 14 years ago by Bug.

 Page 1 of 2

United States
Member #1959
August 1, 2003
42 Posts
Offline
 Posted: August 1, 2003, 5:02 am - IP Logged
Hi,

I've been lurking for a while and have been entertained & educated by the postings.

Please can someone help me with the following: I am looking for an Excel formula that will generate a list of all possible triple combinations of a 49 number draw.

Secondly if someone can provide a formula that would enable me to determine the frequency of repetitive triple combinations in my lottery data.

I have a lottery table with all lottery results in (Columns B:G), 300 rows.

I would appreciate any help you can give me.

SHT.

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: August 2, 2003, 2:04 pm - IP Logged

If you happen to find one that narrows dow the powerball (just the powerball)... please forward that along, I'd be happy with that ;-)

During the last 2 weeks of may and the first week of june, I won almost \$150 (in smaller hits) on the good ol' PB... now I have some tix for tonight's draw, but only \$10 left of "their" money... I'm gonna have to use my own again soon :-(

Playing more than one ticket per game is betting against yourself.

United States
Member #788
October 15, 2002
471 Posts
Offline
 Posted: August 2, 2003, 4:17 pm - IP Logged

I wrote some code in C++ to test the Maryland lottery data for the most repetitive match 3 combo's and match 4 combo's. Out of 1631 draws that I had in my file at the time, there was one match 3 combo matching in 8 of the 1631 draws. There were three match 4 combo's in the 1631 draws. Not very meaningful data in my opinion.

I am not sure if this is the same problem you are undertaking? I am not sure what can be accomplished in Excel, as I don't know much about it. If I remember correctly there are 20 distinct match 3 combos in a winning lotto draw with 6 numbers. So the task gets big pretty quickly.

mid-Ohio
United States
Member #9
March 24, 2001
20041 Posts
Offline
 Posted: August 2, 2003, 5:27 pm - IP Logged

SHTh,

There are 18424 possible combinations of threes in a 49 number field.  If you have the formular for coming up with the 13983816 combinations of sixes then modiy it for three.  To find the frequency of match 3's, you can use an odds calculation which will be pretty close to the real answer you get by checking each file record with the total file.  I don't use excel and don't have a copy of it, but I have a routine(program) that I wrote in GWBasic that works for me.  The same routines are in most lottery software which you can download for a free trial period.

RJOh

Virginia
United States
Member #1712
June 20, 2003
1549 Posts
Offline
 Posted: August 2, 2003, 6:44 pm - IP Logged

Hey gang...

Just want to try my new Avatar out and see if it is working.

Ken

Virginia
United States
Member #1712
June 20, 2003
1549 Posts
Offline
 Posted: August 2, 2003, 6:45 pm - IP Logged

Hey gang...

I can see it didn't make it for some reason...

Ken

Virginia
United States
Member #1712
June 20, 2003
1549 Posts
Offline
 Posted: August 2, 2003, 7:02 pm - IP Logged

Hey gang...

Just checking once again to see if my Avatar is working...

Ken

United States
Member #1959
August 1, 2003
42 Posts
Offline
 Posted: August 3, 2003, 7:41 am - IP Logged

Thank you for your responses so far.

RJOh wrote:

If you have the formular for coming up with the 13983816 combinations of sixes then modiy it for three.

I have devised other excel lotto formulae but I do not know how to generate all 6 number combinations so your suggestion is redundant. (Please note I do not wish to to generate all 6 combinations).

SHT.

mid-Ohio
United States
Member #9
March 24, 2001
20041 Posts
Offline
 Posted: August 3, 2003, 10:20 am - IP Logged

In GWBasic the following routine will print out all the combinbinations of sixes for a 649 lottery.  Someone once posted a similar routine for Excel. In GWBasic, eliminating N4,N5 and N6 and other small changes will print out all the combinations of threes for a 649 game.  I was thinking that the same thing was true in Excel. I might have been wrong.  I don't recall the post that had the Excel formular, but it's back a while.

10 HN=49:REM HN=size of number file
20 FOR N1=1 TO HN-5
30 FOR N2=N1+1 TO HN-4
40 FOR N3=N2+1 TO HN-3
50 FOR N4=N3+1 TO HN-2
60 FOR N5=N4+1 TO HN-1
70 FOR N6=N5+1 TO HN
80 H=H+1:PRINT H;". ";N1;N2;N3;N4;N5;N6;"      "
90 NEXT N6
100 NEXT N5
110 NEXT N4
120 NEXT N3
130 NEXT N2
140 NEXT N1

Sorry if I appeared redundant.  Good luck to you.
RJOh

Cleveland,Oh
United States
Member #1856
July 16, 2003
531 Posts
Offline
 Posted: August 3, 2003, 11:23 am - IP Logged
Quote: Originally posted by SHTh on August 01, 2003

Hi,

I've been lurking for a while and have been entertained & educated by the postings.

Please can someone help me with the following: I am looking for an Excel formula that will generate a list of all possible triple combinations of a 49 number draw.

Secondly if someone can provide a formula that would enable me to determine the frequency of repetitive triple combinations in my lottery data.

I have a lottery table with all lottery results in (Columns B:G), 300 rows.

I would appreciate any help you can give me.

SHT.

APARENTLY YOU DID NOT UNDERSTSND MY RESPONCE!

MY PROGRAM HAS THAT CAPABILITY BUT IT WON'T HELP OTHER THAN

SHOW YOU HOW MANY 3/4/5 CAME IN ON THE 6/49!

light on my feet
United States
Member #356
May 20, 2002
2744 Posts
Offline
 Posted: August 3, 2003, 1:26 pm - IP Logged

kbcherokee,

nice av

"i am .........."meant to"

P.S.,  that RJoH  is a stand up guy.  thanks,  vision

until further notice,  it's  france everyday

United States
Member #1959
August 1, 2003
42 Posts
Offline
 Posted: August 4, 2003, 3:34 am - IP Logged
-- Previous Private Message --
Sent By : MrSteel01
Sent : August 02, 2003 at 8:06am

I'LL GIVE SOME INSITE!

YOU NEED ABOUT 1,000 DRAWS +-

SUMS ARE VERY IMPORTANT LOW/HIGH 56/239 OHIO

SEQUENCIAL ORDER 1 THRU 10 COME IN THE MOST 75/80% A \$10 BET CARD!

QROUPS 1-9 10-19 20-29 30-39 49-49

ODDS MORE THAN EVEN

I COULD GO ON!

I DOWN LOADED A 5 DIGIT FROM GEORGIA HUNDREDS STARTED WITH A 1.

MAY BE UOU YOU SHOULD START THEIR! 500,000 TO ONE!

NO 6 DIGIT EVER REPEATED IT SELF BUT THEIRS A LOT OF 5/6

-------------------------------------------------------------------------------------

Is this even English??

I can be forgiven for not understanding that the above tedious, incomplete, misspelled, rambling message was hawking a lotto program. I can suggest a dozen ways that touting a lotto program can be more succinctly put!

APPARENTLY YOU DID NOT UNDERSTAND MY ORIGINAL POST.

Mr. Steel under no circumstances will I be interested in your lotto program.

SHTh.

United States
Member #1959
August 1, 2003
42 Posts
Offline
 Posted: August 9, 2003, 4:30 am - IP Logged

Bump

Virginia
United States
Member #1712
June 20, 2003
1549 Posts
Offline
 Posted: August 9, 2003, 10:58 am - IP Logged

Visiondude:

Thank you for the nice compliment on the Avatar.

Chief

May the warm winds of heaven blow softly upon your house. May  the Great Spirit bless all who enter there. May your mocassins make happy tracks in many snows. And may the rainbow always touch your shoulder.

United States
Member #788
October 15, 2002
471 Posts
Offline
 Posted: August 10, 2003, 6:00 am - IP Logged

I am not sure how loops work in you programming language, or if excel has loops? Maybe you would have to import the file. In pseudo Java it would look like this.

for(int i = 1; i <= 49; i++)

slot1 = i;

for(int j = i +1; j <= 49; j++)

slot2 =j;

for(int k = j + 1; k <= 49; k++)

slot3 = k;

System.out.println(slot1 + " " slot2 + " " slot3);

 Page 1 of 2