separate the last digit from the 5 positions after converting to vtrac

[jack]

separate the last digit from the 5 positions after converting to vtrac
the vtrac possible at 100% are from the red list
then macro you will see which vtrac are drawn the most on a graph and see the delays but those that are drawn the most, it is important to see the vtrac that were drawn most often
https://www.mediafire.com/file/lkcipwv3t1y4w74/vtrac+5+posi_oes.xlsx/file

 

[Winalot2007]

Here you go Jack:
https://u.pcloud.link/publink/show?code=XZA5YgVZum8GShg7hU0yBP3bjk7CvHE1sT0y

 

[Winalot2007]

You can use a custom draw range for "Hit" by going to cells AH3 & AH4.
Cell AH3 is set to 1 which represents the 1st most current drawing.
Cell AH4 is set to the total number of games which is currently 2740 drawings

You can change the value in cell AH4 to any value between 1 and the largest value in Cell AH2.
So for example, if you want to see the total hits for the last 30 drawings, change Cell AH4 to 30.

 

[jack]

ok Winalot2007, conglatulations, thank you