generate 60 formations, but filtered from a minimum of zero and a maximum of 2 numbers from each of the trios in the list

[jack]

generate 60 formations, but filtered from a minimum of zero and a maximum of 2 numbers from each of the trios in the list,
example=if in the formation of 15 numbers you have a complete trio in the list you cannot. the macro has delete, the limit is for each triplet is zero to two numbers
the number of lines generated can be 60 but can be more or less
https://www.mediafire.com/file/z7meacfnqf5kg89/60+formacoes+filtradas.xlsx/file

 

[jack]

frank , here is an example of an official draw where there is not even a complete trio of the 90 list
01 02 03 04 05 10 11 12 14 15 17 18 19 20 22
it's this sweepstakes that has to be the pattern of not having a complete trio
already in this other example of official draw
02 05 06 07 08 10 12 13 15 17 19 21 23 24 25
in this one we have 32 triplets with three numbers, this type doesn't work because it's enough to have a complete triplet is already out of the standard, it has to be lines with no triplet with complete, the condition is zero to two numbers

 

[Frank]

Please don’t mention my name, I have not got the slightest idea what on EARTH you are rambling on about. Trio ?? 90 list ?? Formation of 15 numbers ?? Your spreadsheet is utterly USELESS. There is NOTHING useful on it to explain your nonsense. Stop wasting my time.

 

[jack]

there are two types of draws in yellow is where the standard of no maximum 2 numbers and at least zero is accepted, in blue we have several trios with the
three numbers will not be accepted, the macro has to generate lines of 15 numbers based on the list of 90 triples of at least zero and maximum of two numbers, every line of 15 numbers generated cannot have even a complete triplet
https://www.mediafire.com/file/1oq9q4eqspn6e9l/dois+tipos+de+sorteios.xlsx/file

 

[Frank]

Unintelligible nonsense. What planet are you on? I’m OUT.

 

[jack]

pense franco, obrigado por ver o post, a cada 5 a 6 sorteios da lotofacil 25/15, 15 números são sorteados, mas dentro não tem nem um trio completo,
objetivo gerar formações de 15 números, mas não ter trios da lista de 90 na linha de sorteio, é uma espécie de filtro de trios, trios terá que ter no mínimo zero no máximo 2 dois números, se tiver o três números de um trios não aceitam, talvez a tradução não te faça entender o objetivo

 

[jack]

sorry there was an error here there are 60 formations and not 90

 

[Frank]

We are a long way apart in understanding the objective. A common sense interpretation of that alphabet spaghetti is that you want to generate all 3,268,760 possible formations of 15 numbers numbered from 1 to 25. You wish each of those combinations of 15 to be compared with the list of 90 triples to see if the line of 15 numbers contains any of the triples in the list of 90 you supplied. If it does then reject that line of 15. If it contains none of the triples or contains 1 or 2 of the 3 numbers in one (or more) of the triples then write that line as its OK.
However, doing that means 3,268,760 X 90 complex comparisons = 294,188,400 complex comparisons. Where are you getting 60 formations from ?
Running my PC for nearly an hour only got through about 300,000 comparisons and about 10% of those lines , about 30,000 satisfy your test! I don't own a Quantum computer, but if you know anyone who has one, I suggest you ask them to do it.

Thats how far apart we are in inderstanding what you want doing. Why are you unable to articulate in CLEAR terms exactly what process would give rise to only 60 formations ? Like I said, you are a time waster!

 

[jack]

hello, you are correct, in the link below I got all the formations in 100% of the 3 million of the lotofacil (25-15) they gave 172,804, in the registration of the draw so far the pattern of not having a complete trio of 90 (there are 90 and not 60) we have around 127 to 130 draws that comply with this criterion, the goal now is to be able to filter, after separating these 127-130 formations from previous draws, to filter with the 172,804, of not playing 13,14,15 from the previous draw , of course this strategy has to be crossed with other strategies, like the repetition of 8,9,10 from the last draw, doubts?

 

[jack]

in the link file we have the 172. 804 of the 3 million this is 100% in which there is not even a trio with three of the numbers, which has happened so far around 130 times, but inside this file you need to filter a lot, you have formations that have up to 10 sequences type 02 03 04 05 06 07 08 09 10, ten is not enough. is a minimum of two maximum 7 numbers in sequences, then there are formations that the 1st number starts with 10 is not good will we be able to reach a 10% of these 172,804 to play you can create other filters for the previous draws along with not playing with 13,14,15 of the previous ones but in the 130 or 127, these are draws that have been drawn so far, of course later I will cross with other strategies, like the pairs / odds, repeated from the previous draw, etc.
arquivo 172804=https://www.mediafire.com/file/9kw1zy8rh0oznb3/planilia+para+172,804.xlsx/file

 

[Frank]

Which proves what a time waster you are. You had already had someone else do all that number crunching, but never mentioned that to me. You’d better go back to them to do the rest. Goodbye.

 

[jack]

it's not true, this was filtered, but no one helped, and doing the rest doesn't work