1) Generate combination numbers for lottery with 25 balls and 15 drawn. The code is to generate all combinations of 10 numbers based randomly on the 15 previous winning numbers, thus =COMBIN(15,10 = 3003 combinations. That is, out of 25 numbers I will exclude 10 and generate combinations for a pool of 15 numbers (these 15 numbers will be known -- manually input).
2) Generate combination numbers for a set of 9 numbers (out of the 10 previously excluded in item 1) with an expectation of combining 5: =COMBIN(9,5), which equals 126 combinations. The 10 numbers that were left out in item 1) will now be randomly drawn, though with one number excluded, to produce combinations for 5 numbers drawn.
3. Then combine 1) and 2). That is, each combination from 1) will form a new combination with numbers from 2) for a total of 378.378 combinations (tickets): 3003 * 126.
I am able to create scenarios 1) and 2) separately on this webpage [url removed, login to view], but still need to create item 3). I need a system that combines the two combinations and do further analysis to filter out low probability combinations.
I also found this formula that creates matrix combinations for lottery [url removed, login to view] But I don´t know any programming.
My program is to aid in playing the Lotofacil in Brazil.