converter lottery 49/6 em pick3

jack

Member
Hello, need help of how to create a macro that makes the following = is for a 6/49 lottery, sum the three pairs and so convert a pick3 example = 12, 15, 25, 29, 36, 45 smaller 11.15 pair sum = 26 = 8Par = largest 36.15 = 51 = 6 and the central pair = 25.29 = 54 = 9, forming the pick3, 6 8, 9 = 869A macro will separate the three peers and add and put like a pick3Tudo I have to hit the 6/49. Is a pick3 (000 to 999) (thousand numbers) Clear after we have to convert for the couple. ok. Thank you
 

Icewynd

Member
Sorry Jack, I'm not getting this. Could you provide an example, starting with the 6/49 result and forming the pairs?

Thanks.
 

jack

Member
Hello, it's easy for a lottery 49/6, you must first separate into three pairs
Example = 12,15,25,28,36,45
So we have 1 pair (the smaller pair) 12.15
We have the 2nd pair (central pair) 25.28
We have 0 3rd pair (larger pair) 36.45
We must add
1 pair 12.15 = 27 2 +7 = sum 9
2nd pair 25,28 = 53 5 +3 adds 8
3rd pair 36.45 = 81 8 +1 = sum 9
Formed a hundred or pick3 = 989
Good ice, after making all pairs 1 to 20 (even smaller)
15-35 (central pair) 30-49 (even greater)
Do all couples in their sectors and then dismembering and add to form pick3
And do statistics, paramentros (limits) of the 3 pairs can change, so now
This has got to hit the lottery 49/6 are the three sums of pairs (like a pick3) then 13 minhoes went 1000mil, calro then have to convert! What part do not you understand?
 

jack

Member
Hello, need of some? M to make the macro sum ​​of pairs,
* To estat? Stice, because it seems that the sums that form the pick3 s? For the broad band
* Very good, ie No derives much the 000-999, on the contrary keeps a track,
* So need to pick up the registration of sweepstakes and separate the 3 pairs and see the pattern
 

jack

Member
hello icewynd
=SE(ÉCÉL.VAZIA(A7);"nodata";SE(SE(SOMA(G7:J7)>9;DIREITA(SOMA(G7:J7);1)*1+ESQUERDA(SOMA(G7:J7);1)*1;SOMA(G7:J7))>9;DIREITA(SE(SOMA(G7:J7)>9;DIREITA(SOMA(G7:J7);1)*1+ESQUERDA(SOMA(G7:J7);1)*1;SOMA(G7:J7));1)*1+
 

jack

Member
Hello, you noticed that ice does not have a zero sum both the 1st pair as the 2nd and 3rd pair has no zero in the formation of vlar pick3, ie taking all the thousand possible pick3 with zero example = 120,420,820,045 ....... . ie is no more or one thousand (1000) must fall to 800
* Have to see without the zero, this formula right! Giving the values ​​of the sum in the central range between 000-999
Fanstantico ice, which changes over the sum of the numbers 6 together, is now
* Do you have a reference to the sum because ests in 3 parts (three pairs)
 

jack

Member
Hello, within formations (pick3) I noticed that, what training only pairs
Example = 642 862 ......
Odd = 153.579 ...
* And with zero 120.012 480 ..... good, or not in training,
* Ie the total of one million, we get a 300-400 training
* Mixed = example = 129, 459, .... where we have even and odd,
This pattern is at 85% of the time, ie of 13 million (49/6) down to a
* 400 formations, clear after we convert the sums,
** Very good!! How we may use your vtrac it??
 

Sidebar

Top