Using 6/49 Vtracs to make playable Combinations

[Icewynd]

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?

Yes, I am struggling too.

But, it seems that the idea is to concentrate on the center -- 02-23 and make all combinations of 4 =COMBIN(22,4) = 7,315, then add 01-08 to the front end of the 4 digit combo and 17-24 to the rear. Another question that needs to be addressed is whether or not to allow repeaters as we add the front and back ends. The Vtrac system does include repeats, so I would vote for that option, although this will increase the final number of combinations.

Then, I think we need to work on filters to reduce the 7,315.

Also, it is very important to keep in mind that these are Vtracs which will greatly expand the number of combinations when we start assigning real numbers to them.

 

[PAB]

Jack,

You have confused me with your last post, AGAIN!

Icewynd,

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.

I have just run my adapted program with the parameters of...

Position 1 is <= 08
Position 5 is <= 17
Position 6 is >= 18

...and it gives me total combinations of 42,434.
Is that what you meant???

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.

 

[PAB]

Hi Icewynd,

But, it seems that the idea is to concentrate on the center -- 02-23 and make all combinations of 4 =COMBIN(22,4) = 7,315, then add 01-08 to the front end of the 4 digit combo and 17-24 to the rear.

Something like this???

Option Explicit
Option Base 1

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

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("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

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.

 

[PAB]

Hi Icewynd,

But, it seems that the idea is to concentrate on the center -- 02-23 and make all combinations of 4 =COMBIN(22,4) = 7,315, then add 01-08 to the front end of the 4 digit combo and 17-24 to the rear.

FORGET the previous code.

I have re-written the code using 01 to 08 as the FIRST digit for position ONE and 17 to 24 as the LAST digit for position SIX with the numbers 02 to 23 as the CENTRE numbers for positions 2 to 5. Is this CORRECT???

Can you please confirm that using the parameters that you have listed above that the total combinations will be 118,608.
If so, I will post the amended code.

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, icewynd, perfect, well you took the idea, of course if it is expected vtrac line, we will have 12 numbers on each line to deploy the vtrac, but still is far better predict, pab hello, you have lever into account that in the example = pairs extremes
* 08xxxx19 the center court must stay within the limits 08-18, then where is xxxx, can not for example 07 or 20, then when building the macro has to do this detail,
* Another example = 05 xxxx 21 blocks from the center has to have the limit of 06 a20
Then the center court can not have less than the number 1 and number of the pair can not
* Having the largest number that 2nd number of the pair, macro view this has

 

[Icewynd]

I have re-written the code using 01 to 08 as the FIRST digit for position ONE and 17 to 24 as the LAST digit for position SIX with the numbers 02 to 23 as the CENTRE numbers for positions 2 to 5. Is this CORRECT???

Yes, this is CORRECT .

Can you please confirm that using the parameters that you have listed above that the total combinations will be 118,608.

Not sure how you get to 118,608. It sounds right, given that the total number of possible combinations is 134,596.

 

[jack]

hello, pab, when you get the idea will be good, that
* 4 groups of 6 numbers, is central to the blocks,
4 Issues tirndo do in a group, is the basic filter, then we use your stats to filter, that is why the courts have conbinaçoes be 100%, which then uses filters

 

[jack]

Hello, ice, example 05 06 08 15 17 19, if the pair of extremes is 06 and 17, this training is wrong because the 05 can not be less than the 1st number of the pair and 19 can not be higher than 2 º number of pair this type of combination is wrong!! ok

 

[jack]

Hello, icewynd, we focus on the central blocks, you can separate the endings, the last digit of 0-9 blocks? And see how many combinations are possible?
example =
0012
0013
other
4459 ....
Always remembering that it is up to 24, so that the first digit of 0,1,2, does not enter the study,
It's kind of karnaugt map to see the endings of the central blocks, this filter is powerful
* For the central blocks, the pab knows!

 

[Icewynd]

OK, as per Jack's comments, the situation seems to be as follows:

Form all possible 4 digit combinations using Vtracs 02-23.

Pair each of these with the front/back pairs 01-08/17-24 with the condition that the front digit must be lower than the first digit of the four-digit center combination and the back digit must be higher than the last digit of the four-digit center combination.

Am I there yet?

 

[jack]

yes, ice, is this, the court must stay inside the pair of ends
ice and pabb, imagane a graph of the two ends, the court
*must be at the center,
Hello, pab, when it separates the last digit of the central blocks have 1.366
*Combinations of the last digit 0-9 of the central blocks 100% of any
*Draw, then reducing the icewynd, f ICOI when it comes endings
*Or last digit in 1366 = 100% clear after missing the initial digit of 0,1,2 vai
*Below all formations of the last digit of the central block =
0 0 0 0
0 0 0 1
0 0 0 2
0 0 0 3
0 0 0 4
5 0 0 0
0 0 0 6
0 0 0 7
0 0 0 8
0 0 9 0
0 0 1 1
0 0 1 2
1 0 0 3
0 1 0 4
0 0 1 5
0 0 1 6
1 7 0 0
1 8 0 0
0 9 1 0
0 0 2 2
0 0 3 2
0 0 2 4
0 0 2 5
0 2 0 6
0 0 2 7
0 0 2 8
0 0 2 9
0 3 0 3
0 0 3 4
0 0 3 5
0 0 3 6
0 0 3 7
8 0 0 3
0 9 3 0
0 0 4 4
0 0 4 5
4 0 0 6
4 7 0 0
4 8 0 0
0 4 0 9
0 5 0 5
0 0 5 6
0 0 5 7
8 5 0 0
0 9 5 0
6 0 0 6
6 0 0 7
8 0 0 6
6 9 0 0
7 0 0 7
0 0 8 7
0 9 7 0
0 0 8 8
0 8 9 0
0 9 9 0
0 1 1 1
1 0 1 2
0 1 1 3
0 1 1 4
0 1 1 5
1 1 0 6
1 0 1 7
0 1 1 8
0 1 1 9
0 1 2 2
0 1 2 3
0 1 2 4
0 1 2 5
0 1 2 6
0 1 2 7
0 1 2 8
0 1 2 9
0 1 3 3
0 1 3 4
3 1 0 5
0 1 3 6
0 1 3 7
0 1 3 8
0 1 3 9
0 1 4 4
0 1 4 5
0 1 4 6
0 1 4 7
0 1 4 8
1 4 0 9
0 1 5 5
1 0 5 6
0 1 5 7
0 1 5 8
0 9 1 5
1 6 0 6
1 6 7 0
0 1 6 8
1 6 9 0
1 0 7 7
1 0 7 8
0 1 7 9
0 1 8 8
8 9 0 1
0 9 1 9
0 2 2 2
2 2 0 3
2 2 0 4
2 2 0 5
2 2 0 6
0 2 2 7
8 2 0 2
0 2 2 9
0 2 3 3
4 2 0 3
0 2 5 3
0 2 3 6
7 0 3 2
8 2 0 3
0 9 3 2
0 2 4 4
0 2 4 5
0 2 4 6
0 2 4 7
8 0 2 4
2 4 9 0
2 5 0 5
2 0 5 6
0 2 5 7
0 2 5 8
0 2 5 9
0 6 2 6
2 7 0 6
6 0 2 8
0 2 6 9
0 2 7 7
0 2 7 8
0 2 7 9
0 8 2 8
0 2 8 9
0 9 2 9
0 3 3 3
0 3 3 4
3 0 5 3
3 3 0 6
0 3 3 7
3 8 3 0
0 9 3 3
0 3 4 4
4 3 0 5
0 3 4 6
0 3 4 7
4 8 0 3
4 9 0 3
3 5 0 5
5 0 3 6
0 3 5 7
8 0 3 5
3 0 5 9
6 0 3 6
7 0 3 6
0 6 3 8
9 0 3 6
3 7 7 0
0 3 8 7
0 9 3 7
3 8 8 0
0 9 3 8
0 9 3 9
0 4 4 4
0 4 5 4
6 0 4 4
0 4 4 7
8 0 4 4
4 4 0 9
4 5 0 5
0 4 5 6
0 5 4 7
4 8 0 5
0 4 5 9
0 4 6 6
4 7 0 6
0 4 6 8
6 9 0 4
0 4 7 7
0 4 7 8
4 9 7 0
0 4 8 8
0 8 9 4
9 4 0 9
0 5 5 5
5 0 5 6
0 5 5 7
8 5 5 0
0 5 9 5
6 0 5 6
0 5 6 7
0 6 8 5
6 9 0 5
0 5 7 7
0 5 8 7
0 5 7 9
0 8 5 8
0 9 8 5
0 5 9 9
0 6 6 6
0 6 7 6
0 6 8 6
6 9 0 6
0 6 7 7
0 6 7 8
0 6 7 9
0 6 8 8
0 9 6 8
0 9 9 6
0 7 7 7
0 7 7 8
0 7 7 9
0 8 7 8
7 8 9 0
0 7 9 9
0 8 8 8
0 8 8 9
0 8 9 9
0 8 9 9
0 9 9 9
1 0 9 8
1 1 1 1
1 1 1 2
1 1 1 3
1 1 1 4
1 1 1 5
1 1 1 6
1 1 1 7
1 1 1 8
1 1 1 9
2 1 1 2
1 1 2 3
1 1 2 4
1 5 1 2
2 1 1 6
1 1 2 7
1 1 2 8
1 1 2 9
1 1 3 3
1 1 3 4
1 3 5 1
1 1 3 6
1 1 3 7
1 1 3 8
1 1 3 9
1 1 4 4
1 1 4 5
1 1 4 6
1 4 7 1
1 1 4 8
1 1 4 9
1 5 1 5
1 1 5 6
1 1 5 7
1 1 5 8
5 1 1 9
1 6 1 6
1 7 6 1
1 1 6 8
6 1 1 9
1 7 7 1
1 1 7 8
1 1 7 9
1 8 1 8
8 1 1 9
9 1 1 9
1 2 2 2
1 2 2 3
1 2 2 4
1 2 2 5
1 2 2 6
1 2 2 7
1 2 2 8
1 2 2 9
1 2 3 3
1 2 3 4
1 2 3 5
1 2 3 6
1 2 3 7
1 2 3 8
1 2 3 9
1 2 4 4
1 2 4 5
1 2 4 6
1 2 4 7
1 2 4 8
1 2 4 9
5 5 1 2
1 5 2 6
1 2 5 7
1 2 8 5
1 9 2 5
1 6 2 6
1 6 2 7
1 2 6 8
1 6 2 9
1 2 7 7
1 2 7 8
1 2 7 9
1 2 8 8
1 2 8 9
1 9 2 9
1 3 3 3
1 3 3 4
1 3 5 3
1 3 3 6
1 3 3 7
1 3 3 8
9 1 3 3
1 3 4 4
1 3 4 5
1 3 4 6
1 3 4 7
1 3 4 8
1 3 4 9
1 3 5 5
1 3 5 6
1 3 5 7
1 3 5 8
1 3 5 9
1 3 6 6
1 3 7 6
1 6 3 8
1 3 6 9
1 3 7 7
1 3 7 8
1 3 7 9
3 1 8 8
1 8 3 9
1 3 9 9
4 1 4 4
1 4 5 4
1 4 4 6
1 4 4 7
1 4 4 8
1 4 4 9
1 5 4 5
1 4 5 6
1 5 4 7
1 4 8 5
1 5 4 9
1 4 6 6
1 4 7 6
1 4 6 8
6 9 1 4
1 4 7 7
1 4 7 8
1 4 7 9
1 4 8 8
1 8 4 9
1 9 9 4
1 5 5 5
1 5 5 6
1 5 5 7
1 5 5 8
1 5 9 5
6 1 5 6
1 5 6 7
1 5 6 8
6 9 1 5
1 5 7 7
1 5 7 8
1 5 7 9
1 8 5 8
1 9 8 5
1 5 9 9
1 6 6 6
1 6 7 6
1 6 8 6
1 6 6 9
1 6 7 7
1 6 7 8
1 6 7 9
1 6 8 8
1 9 6 8
1 9 9 6
1 7 7 7
1 7 7 8
1 7 7 9
1 7 8 8
1 7 8 9
1 9 9 7
1 8 8 8
1 8 8 9
1 9 9 8
1 9 9 8
1 9 9 9
2 0 9 8
2 1 9 8
2 2 2 2
2 2 2 3
2 2 2 4
2 2 5 2
6 2 2 2
2 7 2 2
2 2 2 8
2 2 2 9
2 2 3 3
2 2 3 4
2 2 5 3
2 2 3 6
2 2 3 7
2 8 2 3
2 2 3 9
2 2 4 4
2 2 4 5
2 2 4 6
2 2 4 7
2 2 4 8
2 2 4 9
2 2 5 5
2 5 2 6
2 2 5 7
2 2 8 5
2 2 5 9
2 2 6 6
2 2 7 6
2 2 6 8
2 6 2 9
2 2 7 7
2 2 7 8
2 2 7 9
2 2 8 8
2 8 2 9
2 2 9 9
2 3 3 3
2 3 3 4
3 5 2 3
2 3 3 6
2 7 3 3
3 8 2 3
2 3 3 9
2 3 4 4
2 3 4 5
2 3 4 6
2 3 4 7
2 3 4 8
2 3 4 9
2 3 5 5
2 3 5 6
2 3 5 7
2 3 5 8
2 3 5 9
2 3 6 6
2 3 6 7
2 6 3 8
2 3 6 9
3 2 7 7
2 3 7 8
2 3 7 9
2 3 8 8
2 8 3 9
2 9 3 9
2 4 4 4
2 4 4 5
2 4 6 4
2 4 4 7
4 4 8 2
2 4 4 9
2 5 4 5
2 4 5 6
2 5 4 7
2 4 5 8
2 5 4 9
2 4 6 6
2 4 6 7
2 4 6 8
6 9 2 4
4 2 7 7
2 4 7 8
2 4 7 9
2 4 8 8
2 4 8 9
2 4 9 9
2 5 5 5
2 5 5 6
2 5 5 7
2 5 5 8
2 5 5 9
2 5 6 6
2 5 6 7
8 5 2 6
2 5 6 9
5 2 7 7
2 5 7 8
2 5 7 9
2 8 5 8
5 8 2 9
2 5 9 9
2 6 6 6
6 2 7 6
2 6 8 6
2 6 6 9
2 6 7 7
2 6 7 8
2 6 7 9
2 6 8 8
2 9 6 8
6 9 2 9
2 7 7 7
2 7 7 8
2 7 7 9
2 7 8 8
2 7 8 9
2 7 9 9
2 8 8 8
2 8 8 9
2 8 9 9
2 9 9 8
2 9 9 9
0 9 3 8
3 1 0 0
1 8 3 9
2 0 3 0
8 3 2 9
3 0 3 0
3 3 3 3
3 3 4 3
3 3 3 5
3 3 3 6
3 7 3 3
3 3 3 8
3 3 3 9
3 3 4 4
3 3 4 5
3 3 4 6
4 7 3 3
3 8 4 3
3 3 4 9
3 3 5 5
3 5 3 6
3 3 5 7
8 5 3 3
3 5 9 3
3 6 3 6
3 3 7 6
3 6 3 8
3 3 6 9
3 3 7 7
3 3 8 7
3 3 7 9
3 3 8 8
3 8 3 9
3 3 9 9
4 3 0 0
4 3 4 4
3 4 5 4
3 4 4 6
3 4 4 7
3 4 4 8
9 3 4 4
3 4 5 5
3 4 5 6
3 4 5 7
3 4 5 8
3 4 5 9
3 4 6 6
3 4 6 7
3 4 6 8
3 4 6 9
4 3 7 7
3 4 7 8
3 4 7 9
3 4 8 8
3 4 8 9
3 9 4 9
3 5 0 0
3 5 5 5
3 5 5 6
3 5 5 7
3 5 5 8
3 5 9 5
3 6 5 6
3 5 6 7
5 6 3 8
5 6 3 9
3 7 5 7
3 8 5 7
3 5 7 9
3 8 5 8
3 9 8 5
3 5 9 9
0 0 3 6
0 1 3 6
3 6 6 6
6 3 7 6
3 8 6 6
3 6 6 9
3 6 7 7
3 6 7 8
3 6 7 9
3 8 8 6
3 9 6 8
3 6 9 9
3 7 0 0
3 7 0 1
3 7 7 7
3 7 7 8
3 7 7 9
3 7 8 8
3 7 8 9
3 7 9 9
3 8 0 0
3 8 0 1
3 8 8 8
3 8 8 9
3 8 9 9
3 0 9 0
3 9 0 1
3 9 9 8
3 9 9 9
4 0 0 0
4 0 0 1
4 0 0 2
4 0 0 4
4 0 0 5
4 0 0 6
4 7 0 0
4 8 0 0
4 0 9 0
4 1 0 1
4 0 1 2
1 3 4 0
0 1 4 4
4 0 1 5
1 6 4 0
0 1 4 7
0 1 4 8
1 4 0 9
4 2 2 0
4 2 0 3
4 0 2 4
4 2 0 5
0 2 4 6
0 2 4 7
8 0 2 4
2 4 9 0
4 1 9 0
2 4 9 0
4 3 0 3
4 3 0 4
4 3 0 5
4 3 0 6
4 3 0 7
4 3 0 8
4 9 0 3
4 4 3 0
4 4 4 0

 

[jack]

4 4 4 4
5 4 4 4
4 4 4 6
4 4 4 7
4 4 4 8
4 4 4 9
5 4 4 0
4 5 4 5
4 5 6 4
4 4 5 7
4 4 5 8
4 4 5 9
4 4 6 0
4 4 6 6
4 6 4 7
4 4 6 8
4 4 6 9
4 7 4 0
4 7 4 7
4 4 7 8
4 7 4 9
4 4 8 0
4 8 4 8
4 8 4 9
4 4 0 9
4 9 4 9
4 5 0 5
4 5 0 6
4 5 0 7
4 5 0 8
5 4 0 9
5 5 4 5
4 5 6 5
4 5 5 7
4 5 5 8
9 5 5 4
4 5 6 6
4 5 6 7
4 5 6 8
4 5 6 9
4 5 7 7
4 5 7 8
4 5 7 9
4 8 5 8
4 5 8 9
4 5 9 9
4 6 0 6
4 6 0 7
4 6 0 8
6 4 0 9
4 6 6 6
4 6 7 6
4 6 8 6
4 6 9 6
4 6 7 7
4 6 7 8
4 6 7 9
4 6 8 8
4 9 6 8
4 6 9 9
4 7 0 7
4 7 0 8
7 4 0 9
4 7 7 7
4 7 7 8
4 7 7 9
4 7 8 8
4 7 8 9
4 7 9 9
4 8 0 8
8 4 0 9
4 8 1 1
4 8 8 8
4 8 8 9
4 8 9 9
9 4 0 9
4 1 1 9
4 9 9 9
5 0 0 0
5 0 0 1
5 0 0 2
0 5 0 5
5 0 0 6
5 0 0 7
8 5 0 0
0 9 5 0
5 1 0 1
5 0 1 2
5 1 0 3
5 1 0 5
1 0 5 6
0 1 5 7
5 1 0 8
0 9 1 5
5 0 2 2
5 2 0 3
2 5 0 5
5 2 0 6
0 2 5 7
5 8 2 0
5 0 2 9
3 0 5 3
3 5 0 5
5 0 3 6
3 0 5 7
8 5 0 3
5 0 3 9
5 0 5 5
5 0 5 6
0 5 5 7
8 5 5 0
5 0 5 9
6 0 5 6
0 5 6 7
0 6 8 5
6 9 0 5
5 0 7 7
5 0 7 8
5 9 7 0
0 8 5 8
0 8 9 5
5 9 9 0
5 1 1 1
5 1 1 2
5 1 1 3
5 1 1 4
1 5 1 5
5 1 1 6
5 1 7 1
5 1 8 1
5 1 1 9
2 5 1 2
3 5 1 2
5 1 2 4
5 2 1 4
2 5 1 5
1 5 2 6
1 5 2 7
5 1 8 2
1 9 2 5
5 3 2 1
3 1 5 3
5 4 1 3
5 8 4 9
3 1 5 5
5 5 5 5
5 5 5 6
5 5 5 7
5 5 5 8
9 5 5 5
5 5 6 6
5 6 5 7
5 5 6 8
5 5 6 9
5 5 7 7
5 7 8 5
5 5 7 9
5 8 5 8
5 9 8 5
5 5 9 9
6 1 5 3
5 6 6 6
6 5 6 7
5 6 8 6
6 9 5 6
5 6 7 7
5 6 7 8
5 6 7 9
5 6 8 8
5 6 8 9
5 6 9 9
1 3 5 7
5 7 1 4
5 7 7 7
5 7 7 8
7 5 7 9
5 7 8 8
5 7 8 9
5 9 7 9
1 3 5 8
5 8 1 4
8 5 5 1
8 8 5 8
8 9 8 5
5 8 9 9
1 3 5 9
5 9 1 4
5 9 1 5
5 9 1 6
5 9 7 1
5 9 8 1
5 9 9 1
5 9 9 9
6 0 0 0
6 0 0 1
6 0 0 2
6 0 0 6
6 0 0 7
6 0 0 8
6 9 0 0
1 1 0 6
6 0 1 2
6 1 0 6
6 7 0 1
6 0 8 1
6 9 1 0
6 0 2 2
6 0 3 2
6 2 0 6
6 0 2 7
6 0 2 8
6 0 2 9
6 0 3 3
6 0 3 6
6 0 3 7
0 6 3 8
9 0 3 6
6 0 6 6
6 0 6 7
6 0 6 8
6 9 0 6
6 0 7 7
6 0 8 7
0 6 7 9
6 0 8 8
6 8 9 0
6 9 9 0
6 1 1 1
6 1 1 2
6 1 1 3
1 1 4 6
6 1 1 6
1 7 6 1
6 1 1 8
6 1 1 9
6 1 2 2
6 1 2 3
1 2 4 6
6 1 2 6
6 1 2 7
6 1 2 8
6 1 2 9
6 1 3 3
6 1 3 4
6 1 3 6
3 7 6 1
1 6 3 8
1 3 6 9
6 1 4 4
6 1 5 4
1 6 4 6
6 1 4 7
6 1 4 8
6 9 1 4
6 1 5 5
6 1 5 6
6 1 5 7
6 1 5 8
1 6 6 6
1 6 7 6
1 6 8 6
6 9 1 6
1 6 7 7
1 6 7 8
1 6 7 9
1 6 8 8
6 9 1 8
6 9 1 9
6 2 2 2
2 2 3 6
2 4 6 2
6 2 2 5
6 6 2 2
6 2 2 7
6 2 2 8
6 9 2 2
6 2 3 3
6 3 2 4
6 4 2 3
6 5 2 3
6 6 2 3
6 6 6 6
6 6 7 6
6 6 8 6
6 6 6 9
6 6 7 7
6 6 7 8
6 6 7 9
6 6 8 8
6 9 6 8
6 6 9 9
6 7 2 3
6 7 4 2
6 7 7 7
6 7 7 8
7 6 7 9
6 7 8 8
6 7 8 9
6 9 9 7
6 8 2 3
2 4 6 8
8 5 2 6
6 8 8 8
6 8 9 8
6 8 9 9
6 9 2 3
6 9 2 4
6 9 2 5
6 9 2 6
6 9 2 7
6 9 2 8
6 9 2 9
6 9 9 9
7 0 0 0
1 7 0 0
7 0 0 2
7 0 0 7
7 0 0 8
0 9 7 0
7 1 0 1
7 0 1 2
1 7 7 0
7 1 0 8
7 1 9 0
7 0 2 2
7 0 3 2
0 2 7 7
7 0 2 8
7 0 2 9
0 7 3 3
3 7 7 0
7 0 3 8
3 9 7 0
7 0 7 7
7 0 7 8
7 0 7 9
0 8 7 8
7 8 9 0
7 9 9 0
7 1 1 1
7 1 1 2
7 1 1 3
7 1 1 4
7 1 7 1
7 1 1 8
7 1 1 9
7 1 2 2
7 1 2 3
7 2 1 4
1 2 7 7
1 7 2 8
1 7 2 9
1 7 3 3
1 3 4 7
7 1 3 7
1 7 3 8
7 1 3 9
7 1 4 4
7 1 4 7
1 4 7 8
1 4 7 9
7 5 5 1
7 1 5 7
7 1 5 8
1 7 7 7
1 7 7 8
1 7 7 9
7 1 8 8
1 7 8 9
1 9 9 7
2 7 2 2
7 2 2 3
2 2 4 7
7 2 2 5
7 7 2 2
7 2 2 8
7 2 2 9
2 7 3 3
7 2 3 4
7 2 3 5
7 2 3 7
7 8 2 3
7 2 3 9
7 2 4 4
7 2 5 4
7 2 4 7
7 4 8 2
7 2 4 9
7 5 2 5
2 5 6 7
7 2 5 7
7 2 5 8
2 5 7 9
7 6 2 6
2 6 7 7
2 6 7 8
7 2 7 7
7 2 7 8
7 7 2 9
2 8 8 7
2 7 8 9
7 2 9 9
3 7 3 3
4 7 3 3
5 7 3 3
3 3 7 6
7 7 3 3
7 3 3 8
7 3 3 9
7 3 4 4
3 4 5 7
7 3 4 6
7 3 4 7
7 3 8 4
7 3 9 4
7 4 9 3
7 5 5 3
5 3 7 6
7 5 3 7
7 5 3 8
3 5 7 9
6 3 7 6
7 6 3 7
7 6 3 8
7 6 3 9
7 7 3 7
3 7 7 8
7 7 3 9
7 7 7 7
7 7 7 8
7 7 7 9
8 7 7 8
7 7 8 9
7 7 9 9
8 3 8 7
7 8 3 9
7 8 8 8
7 8 8 9
7 8 9 9
7 9 3 9
7 9 9 9
8 0 0 0
8 0 0 1
8 0 0 2
8 0 0 3
8 0 0 4
8 0 0 8
8 0 9 0
8 0 1 1
8 0 1 2
8 1 0 3
8 0 1 4
8 0 8 1
8 9 0 1
8 2 0 2
8 2 0 3
8 0 2 4
8 0 2 8
8 0 2 9
8 0 3 3
8 0 3 4
8 3 0 8
8 3 9 0
8 0 4 4
8 0 4 5
8 0 8 8
8 8 0 9
0 8 9 9
8 1 1 1
8 1 1 2
8 1 1 3
1 8 1 8
8 1 1 9
8 1 2 2
8 2 1 3
8 1 2 4
8 1 2 8
8 1 2 9
8 1 3 3
8 1 3 4
8 1 3 8
1 8 3 9
8 1 4 4
8 1 4 8
1 8 4 9
1 8 5 8
1 8 8 8
8 1 8 9
8 1 9 9
8 2 2 2
2 8 2 3
8 2 2 4
8 5 2 2
8 2 2 8
8 2 2 9
3 8 2 3
8 2 3 4
8 5 2 3
8 2 3 8
8 3 2 9
4 4 8 2
8 2 4 5
8 4 8 2
9 4 8 2
5 2 8 5
8 5 2 8
8 5 2 9
2 8 6 6
8 6 2 8
2 8 8 8
8 2 8 9
2 8 9 9
8 3 3 3
3 8 4 3
8 5 3 3
8 3 3 6
8 3 3 8
8 3 3 9
8 3 4 4
8 3 4 5
8 3 4 6
8 3 8 4
8 3 4 9
8 3 5 5
8 3 5 6
3 8 5 8
8 3 5 9
3 8 6 6
8 6 3 8
8 3 6 9
8 3 8 8
3 8 8 9
8 3 9 9
4 8 0 6
8 0 4 7
8 4 4 4
8 4 4 5
8 4 4 6
4 8 4 7
4 8 4 8
8 4 4 9
8 5 4 5
8 4 5 6
8 4 5 7
4 8 5 8
4 8 6 6
4 6 7 8
8 4 6 8
8 6 4 9
4 7 7 8
8 4 7 8
8 4 7 9
8 8 4 0
4 8 8 8
8 4 8 9
8 4 0 9
8 4 9 9
8 5 0 0
8 5 1 0
8 5 8 4
8 6 4 0
6 8 9 4
8 7 4 0
8 7 5 0
8 8 0 5
8 8 8 8
8 8 8 9
8 8 9 9
0 9 8 5
8 9 4 5
5 9 8 5
8 9 9 8
8 9 9 9
9 0 0 0
0 9 1 0
0 0 2 9
0 9 3 0
4 0 9 0
9 0 0 5
9 0 9 0
0 9 1 1
9 0 1 2
0 9 1 3
0 9 1 4
0 9 1 5
0 9 1 9
9 2 0 2
9 0 3 2
9 0 2 4
9 0 2 5
9 0 2 9
0 9 3 3
4 9 0 3
9 0 3 5
9 0 9 3
9 0 4 4
9 0 4 5
6 9 0 4
9 0 4 7
9 4 0 9
9 5 0 5
6 9 0 5
0 9 5 7
5 9 9 0
9 9 9 0
1 1 1 9
9 1 1 2
9 1 1 3
9 1 1 4
9 1 1 5
9 1 1 9
9 1 2 2
9 1 2 3
1 2 4 9
1 9 2 5
1 9 2 9
9 1 3 3
1 3 9 4
9 1 3 5
9 1 3 9
9 1 4 4
9 4 1 5
9 1 9 4
9 5 1 5
6 9 1 5
1 5 7 9
1 9 8 5
9 1 5 9
1 9 9 9
9 2 2 2
9 2 2 3
9 2 2 4
9 2 2 5
2 9 2 9
9 2 3 3
9 4 2 3
9 2 5 3
9 3 2 9
9 4 2 4
9 2 5 4
9 2 4 9
9 2 5 5
9 5 2 9
6 9 2 0
2 9 9 9
9 0 3 6
9 3 3 3
9 3 3 4
9 3 3 5
9 3 3 6
3 9 3 9
9 3 4 4
9 3 4 5
6 9 3 4
3 9 4 9
9 3 5 5
9 3 5 6
3 5 9 9
6 9 3 6
9 3 6 9
3 9 9 9
9 4 4 4
9 4 4 5
9 4 4 6
9 4 4 7
9 4 4 9
9 5 5 4
9 4 5 6
9 5 4 7
9 4 9 5
9 6 4 6
4 6 7 9
9 6 4 9
9 4 7 7
9 4 7 9
4 9 9 9
9 5 5 5
5 9 5 6
9 5 5 7
9 5 9 5
9 6 5 6
9 6 5 7
5 9 6 8
9 5 9 6
9 5 7 7
5 7 8 9
5 9 7 9
5 9 8 8
9 9 8 5
5 9 9 9
9 6 0 0
1 6 9 0
9 6 0 6
9 6 0 7
0 9 6 8
6 9 0 9
6 9 1 1
6 9 1 2
6 9 1 3
9 6 4 1
9 6 1 6
9 7 6 1
1 9 6 8
6 9 1 9
9 7 6 1
9 7 6 6
9 7 7 6
9 8 6 1
9 8 6 6
6 7 8 9
8 9 6 8
8 9 9 6
9 9 2 6
6 9 9 6
6 9 9 7
6 9 9 9
9 9 9 9

 

[jack]

hello, ice! you have the latest three draws from 49/6?
have separate power blocks, you noticed that when the court, after the 4 vtrac converted the court have 8 to choose four numbers, very good

 

[Icewynd]

Last 3 draws from Ontario 49:

11/14/2012 3,10,21,22,28,42 B=9 Vtracs: 3,3,10,17,21,22 B=9

11/17/2012 4,21,22,23,26,32 B=27 Vtracs: 1,4,7,21,22,23 B=2

11/21/2012 3,4,18,24,40,46 B=42 Vtracs: 3,4,15,18,21,24 B=17

Not sure what you mean by "seperate power blocks" Jack.

 

[PAB]

Icewynd,

Yes, this is CORRECT .
Not sure how you get to 118,608. It sounds right, given that the total number of possible combinations is 134,596.

I am going to post the code that I thought was correct below.
It doesn't have anything to do with the 134,596 combinations as such because as you quite rightly said the Centre numbers are C(22,4) which equates to 7,315 combinations. Then the added parameters extends this to 118,608 combinations.

Jack,

I am going to leave this thread because of the reasons below:-

Firstly, because you are STILL multi posting.
Secondly, because of the following...

Hello, icewynd, perfect, well you took the idea, of course if it is expected vtrac line, we will have 12 numbers on each line to deploy the vtrac, but still is far better predict, pab hello, you have lever into account that in the example = pairs extremes
* 08xxxx19 the center court must stay within the limits 08-18, then where is xxxx, can not for example 07 or 20, then when building the macro has to do this detail,
* Another example = 05 xxxx 21 blocks from the center has to have the limit of 06 a20
Then the center court can not have less than the number 1 and number of the pair can not
* Having the largest number that 2nd number of the pair, macro view this has

hello, pab, when you get the idea will be good, that
* 4 groups of 6 numbers, is central to the blocks,
4 Issues tirndo do in a group, is the basic filter, then we use your stats to filter, that is why the courts have conbinaçoes be 100%, which then uses filters

Hello, ice, example 05 06 08 15 17 19, if the pair of extremes is 06 and 17, this training is wrong because the 05 can not be less than the 1st number of the pair and 19 can not be higher than 2 º number of pair this type of combination is wrong!! ok

Hello, icewynd, we focus on the central blocks, you can separate the endings, the last digit of 0-9 blocks? And see how many combinations are possible?
example =
0012
0013
other
4459 ....
Always remembering that it is up to 24, so that the first digit of 0,1,2, does not enter the study,
It's kind of karnaugt map to see the endings of the central blocks, this filter is powerful
* For the central blocks, the pab knows!

...AND the last post is TOTALLY UNNECESSARY.

This is what I have tried to explain in a previous post.
You continually post one after the other changing the criteria.

If you look at the above, one minute you are talking about 12 numbers on each line to deploy the vtrac, the next you are talking about 4 groups of 6 numbers, and then you are talking about the last digit of 0-9 blocks.

I am sorry but I have totally lost interest because I have tried to explain about the multiple posts and trying to keep some sort of continuity.
My comments have obviously gone amiss.

Therefore, I will NOT participate in this particular thread from now on.

Icewynd,

Here is the code that I said I would post that I finally thought was needed:-

Option Explicit
Option Base 1

Const MinA As Integer = 1
Const MaxF As Integer = 24

Dim A As Integer, B As Integer, C As Integer, D As Integer, E As Integer, F As Integer

Sub Min_Max_Centre_PAB()
Dim Start As Double
Start = Timer
Dim Count As Long
With Application
.ScreenUpdating = False: .Calculation = xlCalculationManual: .DisplayAlerts = False
End With
Range("A:A").Delete
Range("A1").Select
Count = 0
For A = MinA To MaxF - 5
For B = A + 1 To MaxF - 4
For C = B + 1 To MaxF - 3
For D = C + 1 To MaxF - 2
For E = D + 1 To MaxF - 1
For F = E + 1 To MaxF
If A <= 8 And B >= 2 And E <= 23 And F >= 17 Then
Count = Count + 1
ActiveCell.Value = Format(A, "00") & "-" _
& Format(B, "00") & "-" _
& Format(C, "00") & "-" _
& Format(D, "00") & "-" _
& Format(E, "00") & "-" _
& Format(F, "00")
ActiveCell.Offset(1, 0).Select
End If
Next F
Next E
Next D
Next C
Next B
Next A
ActiveCell.Offset(1, 0) = "Process Time: " & _
Format(((Timer - Start) / 24 / 60 / 60), "hh:mm:ss") & " Seconds"
Range("A1").Select
With Application
.DisplayAlerts = True: .Calculation = xlCalculationAutomatic: .ScreenUpdating = True
End With
End Sub

I am going to put my time into the Vtrac thread that Icewynd and I have been working on for a while now.
Good luck Jack.

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, ice, center court
03,10,17,21
04,07,21,22
04,15,18,21
Over the three central blocks
The last digit endings po =
3,0,7,1
4,7,1,2
4,5,8,1
This three formations are the endings of the central court,
* This has to be within three of the previous post 1366
* Ice when the separation has separate blocks centras of all drawings and then separate the last digit as well, because let's break down the last digit of blocks in 4 positions
1,2,3 1,2,4 1,3,4 2,3,4
Here dismembered the last digit in suits digits, then filter like a pick3, nte we're talking about the endings of the central blocks. After breaking up in suits are in total four possible positions 1,2,3 1,2,4 1,3,4 2,3,4 =
* In order to use systems and filters like pick3 at each position ok

 

[jack]

Hello, pab, perhaps the difficulty of understanding for the cause of language
About the 12 numbers is that when it provides a vtrac has 12 numbers
Only this! Groups of 4 for 6 are the filter pattern, we are trying to build a good system, of course it will be difficult, the icewynd, understood this well, then other
Members of the forum can help, or if anyone reading this forum
Want to help, please feel free to join!
where the gilles this!!

 

[jack]

Hello, very good ice pab's work, the problem is the language and how quickly the post is placed. But you get good content, this last macro was perfect after 3 or 4 attempts (very little we have achieved the result) of 118,608, ie a reduction of 15.988 compared to the total of 134.596, but the courts have uch filter to see these
* 4 groups of 6 numbers, terminations, sum of delays, developments of
* Suits of last digt, etc .... with patience and some revisions are going well

 

[jack]

Hello, I do not understand why ice pab the left!!, About 4 groups is to apply
* The filters, using the standard, and also the terminations filter blocks
* Central, terminations and filter by groups, ice may not be able to excel
* Faer every project, you need a solft?

 

[Icewynd]

Jack,

I am sorry but I have totally lost interest because I have tried to explain about the multiple posts and trying to keep some sort of continuity.
My comments have obviously gone amiss.

Therefore, I will NOT participate in this particular thread from now on.

Sorry to lose your input here, Mate. But, believe me, I understand completely!