thereddiamanthe and 1 Guest are viewing this topic.

#### Kattila

• 1000+ posts member!
• 1085
• Rated: +36
##### Help with an excel tracker
May 22, 10:42 AM 2020
Hi , i need help to improve this tracker.
Tracks 4 systems , 6 numbers based  each , but i need to track
also the positions between same group of numbers , so  until
8 positions if possible and for each system.

EX:

Reveal (click to show/hide)

#### Azim

• 1000+ posts member!
• 1095
• Any gambling scenerio is beatable!!!
• Rated: +36
##### Re: Help with an excel tracker
May 22, 11:42 AM 2020
you have s1 and s2 and s3 and s4   add the lines under there to what you want for as far as you want to go...

After go to the column s1 and change this in the formula...

=IF(\$A5="","",VLOOKUP(\$A5,Sheet2!\$A\$1:\$E\$38,2,0))
blue -> chnage it to the start of the column.
red ->change it to the last row and column.

Not sure if i understood your help..
With right tools and good money management, any gambling activity can produce a steady income.

#### Kattila

• 1000+ posts member!
• 1085
• Rated: +36
##### Re: Help with an excel tracker
May 22, 11:58 AM 2020
Thanks Azim that you try to help me, but  i have no idea how to do it.
Basically i need one column  right side of each system , which track/show the positions
between same group (see example in reveal ).

#### Azim

• 1000+ posts member!
• 1095
• Any gambling scenerio is beatable!!!
• Rated: +36
##### Re: Help with an excel tracker
May 22, 12:15 PM 2020
I hope this is right.

With right tools and good money management, any gambling activity can produce a steady income.

#### Kattila

• 1000+ posts member!
• 1085
• Rated: +36
##### Re: Help with an excel tracker
May 22, 01:28 PM 2020
Do not work for now.

#### Bigbroben

• 1500+ posts member!
• 1521
• Member
• Rated: +157
##### Re: Help with an excel tracker
May 22, 09:43 PM 2020
Hi Kattila,

Here is something for you.

I wasn't sure if you liked the position to be stopped at the 6 groups or according to the amount of spins since la st hit on group.

Anyway,  here is a quick tracker of what I believe you requested.  Rough, no fancy display but hey!

Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

#### Kattila

• 1000+ posts member!
• 1085
• Rated: +36
##### Re: Help with an excel tracker
May 23, 08:24 AM 2020
Hi  Bigbroben,
Please look again at the first post /reveal , it s about the position/distance between the same
group.

Example:

4234  .....here pos  3 ( from 4.....to  4)
55......here pos 1 ( from 5 to 5 )
626.....here  pos 2 ( from 6 to 6 )
25462.....here pos 4 ( from 2  to 2 )
341613....here pos 5 ( from 3 to 3 )
but also  pos 2 (from 1 to 1 ).

234262....here pos 3 ( from 2 to 2) but
also pos 5 ( from first 2 to last 2)
so hit pos 3 and  pos 5

#### Bigbroben

• 1500+ posts member!
• 1521
• Member
• Rated: +157
##### Re: Help with an excel tracker
May 23, 08:17 PM 2020
Hi Kattila,

try this one then.  Should be good.  It only tracks the position since last hit.
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

#### Kattila

• 1000+ posts member!
• 1085
• Rated: +36
##### Re: Help with an excel tracker
May 24, 03:54 PM 2020
Hi BBB,
Only S1 works fine , the other 3 not, but no worries, i know it's not easy work.
Thanks anyway .

#### Bigbroben

• 1500+ posts member!
• 1521
• Member
• Rated: +157
##### Re: Help with an excel tracker
May 25, 08:00 AM 2020
Hi,

Yeah, little mistake.  Corrected in this version;
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

#### Kattila

• 1000+ posts member!
• 1085
• Rated: +36
##### Re: Help with an excel tracker
May 25, 08:47 AM 2020
Many thanks  B.

### Similar Topics

###### Excel Tracker HELP

Started by Kattila on Roulette Software

35 Replies
5939 Views
Last post: Jul 16, 08:44 AM 2018
by
Bigbroben
###### Excel Tracker

Started by buju on Main Roulette Board

7 Replies
2585 Views
Last post: Dec 17, 05:14 PM 2014
by
RouletteGhost
###### Excel Tracker for ECs / D/C/ Lines

Started by Kattila on General Discussion

0 Replies
1219 Views
Last post: Aug 30, 05:56 AM 2012
by
Kattila
###### Dozens tracker in excel

Started by kingsroulette on Coding for Roulette

5 Replies
2344 Views
Last post: Jan 25, 12:22 PM 2014
by
kingsroulette

Popular pages: