Welcome Guest
You last visited April 29, 2017, 11:21 am
All times shown are
Eastern Time (GMT-5:00)

# v-track

Topic closed. 36 replies. Last post 1 year ago by SergeM.

 Page 2 of 3

What is v-track?

 BS! [ 6 ] [20.69%] I lost 50% cash on my bets! [ 2 ] [6.90%] I didn't win anything! [ 1 ] [3.45%] I don't know how to use it! [ 11 ] [37.93%] Other: put a message [ 9 ] [31.03%] Total Valid Votes [ 29 ] Discarded Votes [ 6 ]
From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
499 Posts
Offline
 Posted: February 20, 2016, 1:33 am - IP Logged
 Number v-Trac Mod 5 Odd-Even Low-High Range Low-Mid-High n =MOD(n, 5) + 1 =MOD(n, 5) =MOD(n, 2) =INT(n / 5) =INT(n / 2) =INT((n + 1) / 4) 0 1 0 0 0 0 0 1 2 1 1 0 0 0 2 3 2 0 0 1 0 3 4 3 1 0 1 1 4 5 4 0 0 2 1 5 1 0 1 1 2 1 6 2 1 0 1 3 1 7 3 2 1 1 3 2 8 4 3 0 1 4 2 9 5 4 1 1 4 2

What is the excel formula for if 333 = "Tri", 889 = "dbl", 123, ="sgl", etc.

Thanks!

Go Broncos!

california
United States
Member #69202
January 6, 2009
2729 Posts
Offline
 Posted: March 6, 2016, 3:38 pm - IP Logged

Vtrac: Best System of All Time!

I agreee

nlsa Scisclo

Pennsylvania
United States
Member #2218
September 1, 2003
5464 Posts
Offline
 Posted: March 6, 2016, 6:27 pm - IP Logged

What is the excel formula for if 333 = "Tri", 889 = "dbl", 123, ="sgl", etc.

Thanks!

Enter your 3 digit set in cell A1  example 889

Format the cell 000

B1 enter this formula

=VALUE(CONCATENATE(MOD(MID(TEXT(\$A1,"000"),1,1),5)+1,MOD(MID(TEXT(\$A1,"000"),2,1),5)+1,MOD(MID(TEXT(\$A1,"000"),3,1),5)+1))

From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
499 Posts
Offline
 Posted: March 9, 2016, 12:10 am - IP Logged

Enter your 3 digit set in cell A1  example 889

Format the cell 000

B1 enter this formula

=VALUE(CONCATENATE(MOD(MID(TEXT(\$A1,"000"),1,1),5)+1,MOD(MID(TEXT(\$A1,"000"),2,1),5)+1,MOD(MID(TEXT(\$A1,"000"),3,1),5)+1))

Thanks! The formula below also works!

=CHOOSE(MAX(INDEX(COUNTIF(K2:M2,K2:M2),)),"S","D","T")

Go Broncos!

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
6065 Posts
Online
 Posted: March 9, 2016, 8:54 am - IP Logged

Thanks! The formula below also works!

=CHOOSE(MAX(INDEX(COUNTIF(K2:M2,K2:M2),)),"S","D","T")

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: March 9, 2016, 8:56 am - IP Logged

If you think of V Track as Adding 5 to a Number and then eliminating the 1 (first digit in the 2 digit sums), You can then change the add number to say 3.  Then you have a 3 Track or III Track is you wish.

Has anyone else looked at it this way and tried to use it?  Just wondering if there is any advice on weather to pursue it?

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: March 9, 2016, 2:08 pm - IP Logged

If you think of V Track as Adding 5 to a Number and then eliminating the 1 (first digit in the 2 digit sums), You can then change the add number to say 3.  Then you have a 3 Track or III Track is you wish.

Has anyone else looked at it this way and tried to use it?  Just wondering if there is any advice on weather to pursue it?

You propose to overlap the groups.
Keep out the sums and define the digit.

(0,5,?)
(1,6,?)
...
(4,9,?)

If you are still with pen and paper.

This is balanced:

0:012
1:234
2:456
3:678
4:890

It would be better, but isn't v-track.

A tri-track:

0:012
1:345
2:678
3:9
Problem with 3 as the rest is 1.

To improve v-track, change to groups of 2 digits and dump v-track:

0:01
1:12
2:23
...
.:90

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: March 9, 2016, 2:34 pm - IP Logged

 3    Mirrors 1 2 3 4 5 6 7 8 9 4 5 6 7 8 9 0 1 2
Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: March 9, 2016, 2:36 pm - IP Logged

I forgot 0 = 3

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: March 9, 2016, 2:36 pm - IP Logged

Delta with digit % 10

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: March 9, 2016, 2:38 pm - IP Logged

Delta with digit % 10

I have not heard those terms before.  Can you explain?

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: March 9, 2016, 2:41 pm - IP Logged

JavaScript Arithmetic Operators

Arithmetic operators are used to perform arithmetic on numbers (literals or variables).

OperatorDescription
-Subtraction
*Multiplication
/Division
%Modulus
++Increment
--Decrement
From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
499 Posts
Offline
 Posted: March 9, 2016, 2:44 pm - IP Logged

Bob,

I did double checked my excel sheet and it does work! Check your inbox for my excel worksheet with all the formulas! Thanks!

Go Broncos!

Lincoln, California
United States
Member #167130
June 27, 2015
256 Posts
Offline
 Posted: March 9, 2016, 2:46 pm - IP Logged

JavaScript Arithmetic Operators

Arithmetic operators are used to perform arithmetic on numbers (literals or variables).

OperatorDescription
-Subtraction
*Multiplication
/Division
%Modulus
++Increment
--Decrement

I guess I used + to add 3;  I am just curious about using the numbers the same way you would use v-track or mirrors.

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: March 9, 2016, 2:48 pm - IP Logged

I guess I used + to add 3;  I am just curious about using the numbers the same way you would use v-track or mirrors.

It isn't v-track as you cannot replace the digit anymore.

document.writeln('');
for(a = 0; a < 10; a++)
{
document.writeln(a, (a+3)%10);
}