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.       :thumbsup:


Share via delicious Share via digg Share via facebook Share via linkedin Share via reddit Share via stumble Share via twitter

 

Popular pages: