Welcome Guest
Log In | Register )
You last visited January 18, 2017, 7:04 am
All times shown are
Eastern Time (GMT-5:00)

V-Trac & Ga Cash 4

Topic closed. Posted 12 years ago. No replies.

Page 1 of 1
PrintE-mailLink
SirMetro's avatar - center
East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
Posted: February 27, 2005, 5:00 pm - IP Logged

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