I have a question for you excel experts.

Reply #18

SergeM — Sat, 16 Feb 2013 01:23:23 GMT

What do you mean

Reply #17

LottoBoner — Fri, 15 Feb 2013 20:48:49 GMT

A code for skips would have more meaning.

Reply #16

SergeM — Mon, 04 Feb 2013 18:44:51 GMT

I didn't publish the settings and the game. The function can be used for any lotto type game.

No result of a special 6/49 will apply for another 6/49.

https://www.lotterypost.com/thread/250656/2911269

Reply #15

RJOh — Mon, 04 Feb 2013 14:40:39 GMT

Your results might have more meaning if you mention the game used to develop them. Those results can't apply to every 6/49 game.

Reply #14

RJOh — Sun, 03 Feb 2013 23:50:41 GMT

For the Ohio Classic Lotto the follow in part of the list for two number combinations and all 1176 possible combinations of twos have come up aleast twice.

21-22 = 17

22-24 = 16

09-10 = 15

09-13 = 15

35-37 = 15

47-48 = 15

03-04 = 14

18-21 = 14

37-40 = 14

42-43 = 14

46-47 = 14

10-12 = 13

13-14 = 13

17-18 = 13

18-19 = 13

22-31 = 13

24-27 = 13

39-40 = 13

46-48 = 13

02-04 = 12

06-07 = 12

06-13 = 12

08-09 = 12

Reply #13

SergeM — Sun, 03 Feb 2013 22:28:11 GMT

An Excel version:

The most frequent couples

01-02 47

02-24 45

01-24 43

01-19 43

01-09 42

01-07 42

01-20 40

01-11 40

02-08 40

01-03 40

01-18 39

01-08 39

01-05 38

02-18 37

01-17 37

02-19 36

02-09 36

08-24 36

13-20 36

Reply #12

RJOh — Sun, 03 Feb 2013 19:41:45 GMT

I did that for combinations of fours in the Ohio Classic Lotto which is a 6/49 game that has had 945 drawings. As of its last drawing, 13,723 of the possible 211,876 combinations of fours had come up so far. The following is part of a list of those combinations.

06-22-29-38 = 4

16-34-42-49 = 3

16-26-37-47 = 3

12-14-29-36 = 3

09-13-21-32 = 3

07-23-25-28 = 3

17-36-46-48 = 3

06-30-31-39 = 3

18-19-24-38 = 3

06-10-28-42 = 3

03-07-29-40 = 3

01-09-40-46 = 2

01-12

Reply #11

mathhead — Fri, 01 Feb 2013 05:12:00 GMT

I wrote: I assume that by quad , you mean numbers in the same teen . For example, any four of 1 through 9, or any four of 10 through 19, etc. Right?

Wrong! After some research, I see that you probably mean any 4 numbers.

Sorry for the lengthly misdirection previously. However, perhaps it will be useful to someone else in the future.

We really cannot use Excel formulas per se to count the frequency of quads appearing in historical drawings. At the very least, it would require a very lar... [ More ]

Reply #10

SergeM — Thu, 31 Jan 2013 19:50:10 GMT

On my own I found several ways to program combinations. It is all experimental. I will translate my VBA codes to java and to other like VB later.

Reply #9

RJOh — Thu, 31 Jan 2013 19:12:06 GMT

Just wondering why you waited until after I suggested a simple solution that could be done using any computer language,perhaps even Small Basic which Microsoft offers freely.

Reply #8

SergeM — Thu, 31 Jan 2013 00:29:30 GMT

Why?

Technically this is better done in C, C++ or other I think. This is not typical Excel stuff.

I used the function for several posts on LP and nothing else.

Reply #7

RJOh — Wed, 30 Jan 2013 21:46:21 GMT

It not surprising you've already written a similar program and had no use for it. Has anyone at LP ever had an idea that you hadn't tried already and found useless

Reply #6

mathhead — Wed, 30 Jan 2013 19:57:18 GMT

I wrote: I could develop them for the 6/49 game. However, some of them might be too complex to include as text here.

Actually, for the 6/49 game, the formulas are less complex because there is only one short teen -- the 1-through-9 group.

MrJackpot: I want to put together a formula that takes say a 6/49 lotto and point out say I want to find the most occuring quads, it finds them and show how many times each occurs. Also I'd like to break it down to show triads and pairs, and maybe even g... [ More ]

Reply #5

SergeM — Wed, 30 Jan 2013 19:22:54 GMT

I wrote a similar program in VBA but have no use for it. It isn't really the type of job for Excel.

Reply #4

mathhead — Wed, 30 Jan 2013 09:00:37 GMT

I assume that by quad , you mean numbers in the same teen . For example, any four of 1 through 9, or any four of 10 through 19, etc. Right?

For a particular quad, the following is the number of 6-tuples that contain that quad:

(a) For 1 through 9:

=COMBIN(49-9,2)

(b) For each of the other teens (e.g. 10 through 19)

=COMBIN(49-10,2)

Of course, 49-9 and 49-10 can be simplified. I write the formulas that way to show their derivation.

If you meant to ask: how many of the COMBIN

Reply #3

RJOh — Mon, 28 Jan 2013 19:49:41 GMT

Program #1 turn combination 1-2-3-4-5-6 into 20 groups. (20 groups per combinations)

1-2-3 1-2-4 1-2-5 1-2-6 1-3-4 1-3-5 1-3-6 1-4-5 1-4-6 1-5-6

2-3-4 2-3-5 2-3-6 2-4-5 2-4-6 2-5-6

3-4-5 3-4-6 3-5-6

4-5-6

Sort all the groups by their numbers using the sort command

Program #2 record the different number groups and their size.

Reply #2

RJOh — Mon, 28 Jan 2013 18:08:52 GMT

I did that by writing two simple programs.

Reply #1

SergeM — Mon, 21 Jan 2013 18:49:55 GMT

Buy a program

I have a question for you excel experts.

MrJackpot — Thu, 17 Jan 2013 18:39:31 GMT

I want to put together a formula that takes say a 6/49 lotto and point out say I want to find the most occuring quads, it finds them and show how many times each occurs. Also I'd like to break it down to show triads and pairs, and maybe even groups of 5 that may even occur. Thanks in advance.