Formula

Reply #4

SergeM — Fri, 05 Jun 2015 21:29:07 GMT

Write all combinations on paper. Strike through every second combination. Simulate a winning situation. Calculate the payout.

Reply #3

JADELottery — Fri, 05 Jun 2015 19:40:06 GMT

Oops, correct http links.

http://www.jadexcode.com/files/Excel/CombinatorialIndex.xls

http://www.jadexcode.com/files/Excel/CombinatorialIndex.xlsm

Reply #2

garyo1954 — Fri, 05 Jun 2015 16:06:21 GMT

You have 37 combinations that meet your straight combination criteria.

1, 2, 3, 4, 5, 6

2, 3, 4, 5, 6, 7

3, 4, 5, 6, 7, 8

4, 5, 6, 7, 8, 9

5, 6, 7, 8, 9, 10

6, 7, 8, 9, 10, 11

7, 8, 9, 10, 11, 12

8, 9, 10, 11, 12, 13

9, 10, 11, 12, 13, 14

10, 11, 12, 13, 14, 15

11, 12, 13, 14, 15, 16

12, 13, 14, 15, 16, 17

13, 14, 15, 16, 17, 18

14, 15, 16, 17, 18, 19

15, 16, 17, 18, 19, 20

16, 17, 18, 19, 20, 21

17, 18, 19, 20, 21, 22

18, 19, 20, 21, 22... [ More ]

Reply #1

JADELottery — Fri, 05 Jun 2015 15:47:03 GMT

What you might need is a way to convert a combination to an index number and back.

We have a Macro Excel sheet with a function for converting any combination to an index number and one for the reverse operation.

For Excel 2003 and above

http://www.jadexcode.com/Excel/CombinatorialIndex.xls

ftp://www.jadexcode.com/Excel/CombinatorialIndex.xls

For Excel 2007 and above

http://www.jadexcode.com/Excel/CombinatorialIndex.xlsm

ftp://www.jadexcode.com/Excel/CombinatorialIndex.xls... [ More ]

Formula

godlike00 — Fri, 05 Jun 2015 09:40:19 GMT

Hello lottery mathematician. Could you help me on a formula where I can remove the number of combination for straight combination in Lotto

For example in a 6/42 Lotto game which has a Total Combinations of 5,245,786

If you eliminate 1,2,3,4,5,6 combination the total combinations would be 5,245,785

My purpose is to reduce the number of combination

Thank you very much