Combinations count

Reply #7

frenchie — Mon, 05 Jul 2010 20:42:45 GMT

Hi JADELottery,

Thank you for the link, I would never came up with thoses formulas,I tried with the fisrt post you gave me and was able to do the first and second column but after that, the third wasn't working properly ?? so I stoped, I don't have your level in formula knowledge or VBA etc..., I get thoses ideas and then ask for the formula or VBA code to someone when it become to complicated for me, so you will see more of me asking for help.

In a previous post call Combinations by numb... [ More ]

Reply #6

JADELottery — Mon, 05 Jul 2010 15:20:06 GMT

You can download an Excel file at the following ftp and http sites.

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

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

Reply #5

frenchie — Mon, 05 Jul 2010 06:05:43 GMT

Hi JADELottery,

I tried to put together your combinatorial distribition with your info but with no success, can you, if possible send me the excel file with the formulas in the cells ?

Thank you. Serge.

Reply #4

frenchie — Mon, 05 Jul 2010 01:04:03 GMT

Thank you RJoh for the explanations... Serge.

Reply #3

RJOh — Mon, 05 Jul 2010 00:55:01 GMT

First you have to know the size of the combinations and the size of the number pool because the larger the combination and number pool, the more combinations that will be generated.

The potion of the chart you're showing looks like it's for combinations of 5 for a pool of 56 numbers.

If 1 is in the first position then there are 4/55 combinations left = 341055

If 2 is in the first position then there are 4/54 combinations left = 316251 and etc.

Since 2 is the lowest number that can b... [ More ]

Reply #2

frenchie — Mon, 05 Jul 2010 00:43:54 GMT

Thanks again, JADELottery.

I realy appreciate it.

Reply #1

JADELottery — Mon, 05 Jul 2010 00:35:39 GMT

https://www.lotterypost.com/thread/144425

Combinations count

frenchie — Sun, 04 Jul 2010 23:55:18 GMT

Hi everyone,

and happy 4th of july to all.

Question : Does anyone know how to calculate how many combinations a number by positions will generate ?

for exemple :

Number 1 as 1st position generate 341 055 combinations.

Number 15 as 1st position generate 101 270 combinations.

Number 26 as 3rd position generate 130 500 combinations.

Etc...

See below part of the chart

Thank you .... Serge.