lottery formula

Reply #16

Bug — Sun, 10 Aug 2003 11:19:27 GMT

I dont' believe it does. It produces only 18424 numbers.

Reply #15

smd173 — Sun, 10 Aug 2003 10:48:13 GMT

Bug,But your loops in psuedo java could potentially allow for the same number to be drawn in multiple slots. You'd need to add another loop to compare the numbers drawn and have it draw again if they were the same.

Reply #14

Bug — Sun, 10 Aug 2003 10:00:49 GMT

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

Reply #13

kbcherokee — Sat, 09 Aug 2003 14:58:11 GMT

Visiondude:Thank you for the nice compliment on the Avatar.Chief

Reply #12

SHTh — Sat, 09 Aug 2003 08:30:17 GMT

Bump

Reply #11

SHTh — Mon, 04 Aug 2003 07:34:45 GMT

-- Previous Private Message --Sent By : MrSteel01Sent : 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 OHIOSEQUENCIAL ORDER 1 THRU 10 COME IN THE MOST 75/80% A $10 BET CARD!QROUPS 1-9 10-19 20-29 30-39 49-49ODDS MORE THAN EVENI 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

Reply #10

visiondude — Sun, 03 Aug 2003 17:26:55 GMT

kbcherokee,nice av

Reply #9

MrSteel01 — Sun, 03 Aug 2003 15:23:31 GMT

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

Reply #8

RJOh — Sun, 03 Aug 2003 14:20:10 GMT

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 file20 FOR N1=1 TO HN-530 FOR N2=N1+1 TO... [ More ]

Reply #7

SHTh — Sun, 03 Aug 2003 11:41:19 GMT

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.

Reply #6

kbcherokee — Sat, 02 Aug 2003 23:02:57 GMT

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

Reply #5

kbcherokee — Sat, 02 Aug 2003 22:45:19 GMT

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

Reply #4

kbcherokee — Sat, 02 Aug 2003 22:44:36 GMT

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

Reply #3

RJOh — Sat, 02 Aug 2003 21:27:18 GMT

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

Reply #2

Bug — Sat, 02 Aug 2003 20:17:18 GMT

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

Reply #1

hypersoniq — Sat, 02 Aug 2003 18:04:50 GMT

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

lottery formula

SHTh — Fri, 01 Aug 2003 09:02:09 GMT

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