Using 6/49 Vtracs to make playable Combinations

[Icewynd]

This thread is to address ideas raised by Jack on the Vtracs for 6/49 thread.

Jack proposes that the Vtrac field of 24 can be broken into 3 sets of 8 Vtracs: 01-08, 09-16 and 17-24. Then the lower and higher Vtrac groups could be combined to make the lowest and highest Vtracs of a playable combination -- L,x,x,x,x,H.

For example:
01-17
01-18
01-19
01-20
01-21
01-22
01-23
01-24
02-17
.
.
.
08-17
08-18
08-19
08-20
08-21
08-22
08-23
08-24

The remaining Vtracs would be the "center court", ie. the pool of numbers from which the central 4 digits of the combination would be drawn.

Using the ON49 Vtracs database, Icewynd found that combinations with these starting and ending Vtracs represent 86% of the Vtrac combinations.

Further, by converting the lower Vtrac to only the lower number of its pair (e.g. Vtracs 01-08 convert to numbers 01-08) and converting the higher Vtrac to the higher number of its pair (e.g. Vtracs 17-24 convert to numbers 42-49), 45% of the actual draw combinations are captured by this approach.

This would seem to show promise as a method of constructing combinations, however the challenge is determining which 4-digit combination to use as the center numbers of the combination.

 

[jack]

Hello, ice, perfect, good job 86% is very good increase from 01 to 09 and 15 to 24, to 95% probably will, but this is for've calmly, we have to focus on the court
Central and use filters to reduce, you can see the delays in each of the vertical position, and terminations, we can see the sum of the trasos endings, or if the ve to each trasos
Number and amount of course does not enter the final draw because we do not have delays, remembering
That the study of the blocks center, is starting the 2nd, 3rd 4th 5th position, the 1st and 6th place are the extremes, are pairs of tips, is placed after, alias, the blocks central daram evidence, that which seram peers and vice versa, eg in the center court we have 4 pairs
The pair of extreme provalmente is odd, or see the pair that came with numca with the center court, study or see the mirror, for the pair of edges with the center court,
Note that a center court numca will start with 01 and end with 49, these two numbers, 01 and 49, only exists in pairs of extremes, 01 xxxx 49, so on center court
Or sector of the 2 nd, 3 rd, 4 th 5 th, is the same thing, remember when vai nomtar bets
In headings, then we have the limits 02-23 (vtrac) to see the blocks are 7.315,
In 100% success forever, but this court in vtrac, 02,03,04 05 or 20,21,22,23
These formations and other formations very hard to leave, there are plenty filters to filter the center court, right now as we confront the peer group with the group of blocks
Central, where a group will give clues forecasting another group ok

 

[PAB]

Hi Icewynd,

I think that this is the right way to go by splitting the threads.
I would just like to point out that responses should ONLY be posted that apply to the topic being discussed for the individual thread otherwise this will totally negate the structure and outcome of the individual thread.

I noticed Icewynd thay you used a different set of criteria to what was initially set by Jack with regard to the Upper limit. You have used 17 to 24 as the example where as Jack was using 16 to 24. Because of this fact I thought I would write a Macro that you could change to test the different scenarios as required.

Basically, Grp1 are the numbers from 1 to 8, Grp2 are the numbers from 16 to 24, and Grp3 are the numbers 9 to 15. I have written the Macro so you can change any of the criteria to what parameters you want to use. By this I mean changing the Const Min & Max Variables. Obviously the output will be:-

(1) Lower limit number first.
(2) Upper limit number second.
(3) The other FOUR Vtracs.

Here is the code:-

Option Explicit
Option Base 1

Const Min1 As Integer = 1
Const Max1 As Integer = 8
Const Min2 As Integer = 16
Const Max2 As Integer = 24
Const Min3 As Integer = 9
Const Max3 As Integer = 15

Sub Pairs_PAB()
Dim Grp1 As Integer
Dim Grp2 As Integer
Dim Grp3A As Integer, Grp3B As Integer, Grp3C As Integer, Grp3D As Integer
Dim Count As Long
With Application
.ScreenUpdating = False: .Calculation = xlCalculationManual: .DisplayAlerts = False
End With
Range("A:A").ClearContents
Range("A1").Select
Count = 0
For Grp1 = Min1 To Max1
For Grp2 = Min2 To Max2
For Grp3A = Min3 To Max3 - 3
For Grp3B = Grp3A + 1 To Max3 - 2
For Grp3C = Grp3B + 1 To Max3 - 1
For Grp3D = Grp3C + 1 To Max3
Count = Count + 1
ActiveCell.Value = Format(Grp1, "00") & "-" _
& Format(Grp2, "00") & "-" _
& Format(Grp3A, "00") & "-" _
& Format(Grp3B, "00") & "-" _
& Format(Grp3C, "00") & "-" _
& Format(Grp3D, "00")
ActiveCell.Offset(1, 0).Select
Next Grp3D
Next Grp3C
Next Grp3B
Next Grp3A
Next Grp2
Next Grp1
Range("A1").Select
With Application
.DisplayAlerts = True: .Calculation = xlCalculationAutomatic: .ScreenUpdating = True
End With
End Sub

I think we can safely leave Jack to test the different scenarios he was talking about and post post back the results in THIS thread.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, pab, just a clarification and remediation, the group of central blocks 100% of raffles, vai = 02-23 blocks are Possible 7315 and not 2520, here is the error, can not
Starting at 09-15, can invade the central blocks Within this limit 02-23 and not 09-15, pab, the bet will start or finish numca with 01 is 24, here is the perfect fix, 100% of the sweepstakes court falls in 7315 are 02-23 blocks, this parameter
From 09 to 15 was to etudo is very narrow in the central belt, can Eliminate this value from 09 to 15 the correct value is 02-23 = 7315, Which Ensures 100% of raffle ok

 

[jack]

pab, the bet of center court as'll never get finished by 01 and by 24, note that I'm talking about the center court

 

[jack]

hello, pab can make the macro only change where the limit has to change 09 15 02 to 23 are 7.315 instead of 2520

 

[jack]

Hello, ice, and pab within the 4 groups with 6 numbers have the following pattern
A group is zero or an vtrac another group has two or more vtrav
In central blocks we use this filter, let's enjoy this pattern
Ok, so how do not know what we do in group 4 issues in each
Edition take im group 6, there is another pattern in which one group has at Miminho
Two vtrac 100% then 6x2 = 15 hitting the fourth group of which has two vtrac
As a minimum, we have 15 pairs of vtrac group, as we did not know which group
We do in 4 editions. Then TEMSO these two extremes of the group numbers 4 to 6
One group of zero or one vtrac in another group has two or more vtrc 100% will use this filter powerful as the basic pattern, where a central block can be a basis for choosing the pair or pairs may give indications of the extremes , court after filtered = example, just match pairs that have not come out with peers is vice versa,
After seeing the pairs match the block that has not left yet, the sum of the delays of the center court is also good filter

 

[Icewynd]

Jack,

As PAB said in her post, you can change the min & max values to whatever numbers you wish, to test different ideas.

For example:

Option Explicit
Option Base 1

Const Min1 As Integer = 1
Const Max1 As Integer = 8
Const Min2 As Integer = 16
Const Max2 As Integer = 24
Const Min3 As Integer = 9
Const Max3 As Integer = 15

Can be changed to:

Option Explicit
Option Base 1

Const Min1 As Integer = 1
Const Max1 As Integer = 8
Const Min2 As Integer = 16
Const Max2 As Integer = 24
Const Min3 As Integer = 2
Const Max3 As Integer = 23

Sub Pairs_PAB()

 

[jack]

Hello, ice, doing like this in the post above wrong, because the blocks from the center is
What vai 02-23 give 7.315, and macro pab's a very high value, the value for the blocks central not exceed 7.315 ok, on to position the macro the number of 16 th 24 has to be in always in 6th position, we to work with the 7.315, which is 100% of the sweepstakes, or am I wrong?

 

[jack]

Hello, pab the numbers 16-24 must be in 6th position, and numbers 01 to 08 must be in 1st position, the blocks centras d total of 7.315 in 100% of the sweepstakes, or order does not matter?

 

[jack]

Hello, pab right then if this value of 526.680, in 87% of pairings,
* Sejaem every 10 or sweepstakes if hit nearly 9 draws, is very good,
* Because decreased from 13 million to 526.680 in 87% of pairings,
A reduction of nearly 12 million and a half, very good, it is clear that in vtrac
* But it is a big reduction!!

 

[PAB]

Icewynd,

As PAB said in her post...

WRONG SEX MATE.

Jack,

Your continuous multiple posts one after the other don't help those who are following the threads you post in. It makes it very hard to follow what you are trying to say or the logic behind it. I noticed this also with the thread with Ramrock.
May I suggest that you think about what you want to say and do the tests that will back this up and put it in a single post. That way it will make it easier and clearer for everyone to follow.

Hello, pab right then if this value of 526.680, in 87% of pairings,
* Sejaem every 10 or sweepstakes if hit nearly 9 draws, is very good,
* Because decreased from 13 million to 526,680 in 87% of pairings,
A reduction of nearly 12 million and a half, very good, it is clear that in vtrac
* But it is a big reduction!!

This is impossible in a C(24,6) Lotto because there is a maximum of 134,596 combinations.
I think what has happened is you have used the WRONG parameters.
I think you have used...

Const Min1 As Integer = 1
Const Max1 As Integer = 8
Const Min2 As Integer = 16
Const Max2 As Integer = 24
Const Min3 As Integer = 2
Const Max3 As Integer = 23

...which is WRONG because you will get the same number repeated in a combination.
See line number 524,861 from the outputed code.
The parameters set to the above do indeed give 526,680 combinations but is WRONG because of what I just posted above.

You said...

Hello, pab the numbers 16-24 must be in 6th position, and numbers 01 to 08 must be in 1st position, the blocks centras d total of 7,315 in 100% of the sweepstakes, or order does not matter?

...which produces 2,520 combinations, so I don't know where you get 7,315 from???
The numbers 01 to 08 can ONLY appear in position ONE and NO other position, likewise, the numbers 16 to 24 can ONLY appear in position SIX and NO other position, and the numbers 09 to 23 can ONLY appear in position TWO, THREE, FOUR & FIVE and NO other positions.
Work out the combinations yourself using the COMBIN function in Excel and you will see that the total will be 2,520.

There needs to be some sort of continuity here or nothing will get resolved.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, pab, I agree!!, You are in the process of discovering the best use, no
* It has the formula ready, the correct sequence, we need to see which responds better, most of the time, it's these setbacks, ideas, in order to have the best proposal
Forecasting, because of 13 million, is not easy to find the best way! You can make a macro
* Putting 02-23 blocks in central

 

[jack]

Hello, just have this error, there are repetitions when the macro is 02-23, pab
You are correct macro to not repeat numbers in six linhase
example
08 02 06 07 08 16 08 = no repeat can not, it is correct, the rest is going well

 

[jack]

Pab forget this group 09 through 16, you can ignore this group to give 100% of sweepstakes
The central blocks have to start with 02 and end with 23, only this error is corrected in time
We are doing well the 7.315 blocks from downtown, dao in 100% of any one sorteoos
Range 09-15, was very limited, but this 02-23 is 100% of the draws, because it is a block numca center court will start or finish with 01 for 24. Why is the Centre Court, it is easy to understand this, we make the total 100% of the central block and then filter

 

[PAB]

Hi Jack,

* Putting 02-23 blocks in central

Yes, using the parameters...

Const Min1 As Integer = 1
Const Max1 As Integer = 1
Const Min2 As Integer = 24
Const Max2 As Integer = 24
Const Min3 As Integer = 2
Const Max3 As Integer = 23

...does give 7,315 combinations, I see what you were getting at now!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, pab, ok congratulations! But we have a small problem, a result can start with 08 and end with 16, believes the courts are not there, we need to see this,
* Another example of a draw = 05-18, the blocks are on the edge 06-17.
It's just understand this part, and we're doing well, you know how to differentiate the possibilities of central blocks and pairs of extremes

 

[Icewynd]

Icewynd,


WRONG SEX MATE.

Sincere apologies for giving you an inadvertent sex change! Somewhere in my (admittedly foggy) memory I thought someone had referred to you as Pam. My bad!

I get the idea that what Jack wants to do is create all 134,596 combinations and then filter out any combo where the lowest digit is greater than 8 and the final digit is less than 17. So the center four digits would be allowed to cover the range 2-23.

 

[PAB]

Hi Icewynd,

Sincere apologies for giving you an inadvertent sex change! Somewhere in my (admittedly foggy) memory I thought someone had referred to you as Pam. My bad!

No worries MATE!

I get the idea that what Jack wants to do is create all 134,596 combinations and then filter out any combo where the lowest digit is greater than 8 and the final digit is less than 17. So the center four digits would be allowed to cover the range 2-23.

If this is the idea I will adapt the Macro accordingly, at the moment I am unsure exactly what is what, if you get my drift?

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, this is going to have to change macro pab whichever icewynd speak, for we have The Following situation, we have 7315 blocks 02-23 in central and 100% of the pairs have estremos
** (Smaller and larger each draw) 01-08 and 16 to 24 in 86% of pairings, is joining this without repetitions