Day - Evening - Num - a - b - c - d - ab - ac - ad - ba - bc - bd - ca - cb - cd - da - db - dc - v1 - v2 - v3 - v4
Sat - 2/26 - 6246 - 6 - 2 - 4 - 6 - 62 - 62 - 66 - 26 - 24 - 26 - 46 - 42 - 46 - 66 - 62 - 64 - 2 - 3 - 5 - 2
Fri - 2/25 - 3310 - 3 - 3 - 1 - 0 - 33 - 33 - 30 - 33 - 31 - 30 - 13 - 13 - 10 - 03 - 03 - 01 - 4 - 4 - 2 - 1
a = position 1 [ =SUM(1*(LEFT(C2,1))) ]
b = position 2 [ =SUM(1*(MID(C2,2,1))) ]
c = position 3 [ =SUM(1*(MID(C2,3,1))) ]
d = position 4 [ =SUM(1*(MID(C2,4,1))) ]
ab thru dc = all possible pair position [ =CONCATENATE(D2,E2) ]
v1 thru v4 = V-Trac value [ =IF((OR(D2=0,D2=5)),1,IF((OR(D2=1,D2=6)),2,IF((OR(D2=2,D2=7)),3,IF((OR(D2=3,D2=8)),4,IF((OR(D2=4,D2=9)),5,""))))) ]
V1 = 0 or 5
V2 = 1 or 6
V3 = 2 or 7
V4 = 3 or 8
V5 = 4 or 9
The OR statement allows multiple tests without exceeding the number of if statements allowed within Excel.
V-Trac Hot, Due & Cold Numbers
Evening | Midday | Both Games
2 - 1 - 4 - 2 | 1 - 4 - 1 - 4 | 1 - 1 - 1 - 2 (1st position V-Trac - Hot)
7 - 6 - 9 - 7 | 6 - 9 - 6 - 9 | 6 - 6 - 6 - 7 (2nd position V-Trac - Hot)
5 - 5 - 8 - 9 | 5 - 5 - 5 - 6 | 9 - 9 - 9 - 5 (2nd position V-Trac - Due)
0 - 0 - 3 - 4 | 0 - 0 - 0 - 1 | 4 - 4 - 4 - 0 (1st position V-Trac - Due)
6 - 9 - 6 - 6 | 7 - 8 - 9 - 8 | 5 - 8 - 5 - 8 (2nd position V-Trac - Cold)
1 - 4 - 1 - 1 | 2 - 3 - 4 - 3 | 0 - 3 - 0 - 3 (1st position V-Trac - Cold)
For 1st position V-Trac [ =IF(B37=1,0,IF(B37=2,1,IF(B37=3,2,IF(B37=4,3,4)))) ]
For 2nd position V-Trac [ =IF(B37=1,5,IF(B37=2,6,IF(B37=3,7,IF(B37=4,8,9)))) ]
Evening - - -
V - 90 - 60 - 15 <=== Games
3 - 20 - 13 - 5
5 - 13 - 8 - 4
1 - 28 - 20 - 2
4 - 19 - 12 - 2
2 - 10 - 7 - 2
^
|= V-Trac Number
I do a sort based on 15, 60 & 90 days (in that order).
I also do a count and sort for all numbers based on position, then compare the number positions (see my 4x4 grid) and create a grid showing only the numbers that show up under both the 4x4 grid and the V-trac grid. A few of the prior games test is showing that this system has potential.
Would be nice to hear some input if anyone else uses a similiar system.
Sir Metro