Hi , i need help with my tracker.
Tracks right now dozens, columns, double streets, streets, splits.
What i need if possible track for each from above the positions between same group
of numbers ( for ex. 2132 is pos 3 between group 2, other 62346 is pos 4 between gr 6)
For doz and col it s ok positions 1,2,3,4
For DS ....1,2,3,4,5,6
For streets ......1,2,3,4,5,6,7,8,9
For splits..........1,2,3,4,5,6,7,8,9,10,11,12
Example double streets
DS Position
3
6
1
5
6 3
6 1, 4
1 4
2
1 2, 6
3
3 1
1 3,5
Only last gap between same group or you want also the previous gap(s)?
Yes also the previous gap(s) , Thanks BBB
Here!
Did not add previous gaps yet, but this is a start...
P.S.: I normally change ''0'' for ''37'', since 0 is a common part of Ecxel conditions .
Will work on previous gaps as soon as I find time.
Kattila,
I hope you'll be able to use the tracker. When working on your file, I think your Excel version did not allow more than 9 or 10 conditions in one formula, mine allows much more, so I transferred. Hope it is compatible!
You right , doesn t work for me , old version. I need supose last version of Excel ?
Can be sent by email and instal(rar file) in my laptop ? Or buy from internet ?
I think I'll just modify the formula in cells and see if it's ok.
Later!
Ok , thanks
I tried also with ofice 2016 but still don t work. Can not track the positions /gaps.
How many previous gaps do you want?
With 3 i have enough ....
Sure?
It's 10000$ per gap...
>:D
You will be rich then, now i go to the bank....want via paypal, bank transfer.... ;D
He's what we'll do:
put the 10k on red.
Split 50-50 if win.
Working on Kattila's first, between family tasks, then you're next.
PM or here for description.
Here Kattila,
you better enjoy this, câliss, it was time consuming!
All infos brought clear and clean in Sheet1. Doz, column, DS, Street, Splits, their actual gaps on the hit and the 2 previous ones.
Should work with your Excel version, I used the same file. Had to Zip it, was too large, 9mb. Hope you have a zip program.
If you will, send a PM giving me a hint on how you plan to use this info in the file!
P.S. Use nr.37 instead of 0 when entering nrs in sheet1 column b
Quote from: Bigbroben on Jun 15, 10:37 PM 2018
Here Kattila,
you better enjoy this, câliss, it was time consuming!
All infos brought clear and clean in Sheet1. Doz, column, DS, Street, Splits, their actual gaps on the hit and the 2 previous ones.
Should work with your Excel version, I used the same file. Had to Zip it, was too large, 9mb. Hope you have a zip program.
If you will, send a PM giving me a hint on how you plan to use this info in the file!
P.S. Use nr.37 instead of 0 when entering nrs in sheet1 column b
Do you think you could do one for numbers? Spin distances from when last hit?
One for clockwise and one for anti clockwise up to last 9 numbers?
Quote from: Bigbroben on Jun 15, 10:37 PM 2018
Here Kattila,
you better enjoy this, câliss, it was time consuming!
All infos brought clear and clean in Sheet1. Doz, column, DS, Street, Splits, their actual gaps on the hit and the 2 previous ones.
Should work with your Excel version, I used the same file. Had to Zip it, was too large, 9mb. Hope you have a zip program.
If you will, send a PM giving me a hint on how you plan to use this info in the file!
P.S. Use nr.37 instead of 0 when entering nrs in sheet1 column b
Thanks BBB, works great.
Quote from: 6th-sense on Jun 16, 03:28 AM 2018
Do you think you could do one for numbers? Spin distances from when last hit?
One for clockwise and one for anti clockwise up to last 9 numbers?
I have one for gaps between nrs, this is what you mean? Ex: 13, 0, 5, 36, 4, 13. Would be a gap of 5.
Clock-anticlock: what do you mean?
The distance between each numbers on the wheel anti clockwise is when the dealer spins the opposite way so the distance will be the other way round
ok,
not this weekend, got stuff to do.
Passion also wanted something?
Quote from: Bigbroben on Jun 16, 07:23 AM 2018
ok,
not this weekend, got stuff to do.
Passion also wanted something?
Thanku your a star
Ok 6th,
I'm back. So, I can do you a files that tells the spin gap between a repeating nr, can also include the distance cw and ccw between consecutive spins, american and european wheel.
Anything else?
yes 15 non-hit on average to hit in spins 11-40, Engerland Engerland Engerland , Engerland
Quote from: 6th-sense on Jun 16, 03:28 AM 2018
Do you think you could do one for numbers? Spin distances from when last hit?
One for clockwise and one for anti clockwise up to last 9 numbers?
6th,
here you go. Have a look!
Tell me if you need more.
link:s://getyarn.io/yarn-clip/d42cba00-694a-4ff7-bcb9-48faf016199a
P.S.:
0 should be written as 37, and 00 as 38.
THAnku so much for this..I wish I could have done it but I have no coding experience
Quote from: 6th-sense on Jun 19, 06:47 AM 2018
Thanks so much for this..I wish I could have done it but I have no coding experience
Nor did I until a few months ago. It's not that hard with Excel.
Is it what you wanted or you need more other stuff?
Notto, you asked something?
Here, Passion, what you've asked.
Tracking last 8 red, black, odd, even, high, low.
If repeat in the last 8 of category, still counting last 8 in order.
Enjoy!
Can you find Waldo?
(link:://:.pichost.org/images/2018/06/20/temp_314912.jpg) (link:://:.pichost.org/image/2t0Rs)
Ah?
I did not know you wanted it private...
Anyway, I do not know how to attach a file in a PM, I think it cannot be done.
I included zero in red, high and even.
Enjoy!
P.S.: Did you find Waldo?
(link:://:.pichost.org/images/2018/06/20/temp_383043.png) (link:://:.pichost.org/image/2ta5g)
Here he is!
Passion,
I bet this is what you meant? Tracking last 8 of each EC on a auto-display?
See attached.
Negocios, deal,business:
tell me how you plan on betting in accordance with the infos given by the tracker and I'll send it to you.
Bitte schön.
Anastasius,
here.
This file is set for 1000 nrs.
It will track how many different nrs appeared in the last 18 spins and then in the following 19 spins.
So if you want to know how many new nrs appear when 18 in 18, look at the proper line. You'll find the times it happened, the min, max, average and median of the new nrs appearing in the next 19 spins.
(link:://:.pichost.org/images/2018/06/26/temp_507702.png) (link:://:.pichost.org/image/2eIzd)
Enter nrs in column A, enter 0 as 37.
Now column A is filled with excel random.
In sheet3, results of 20k random nrs.
P.S.: can you find Waldo?
(link:://:.pichost.org/images/2018/06/26/temp_621161.jpg) (link:://:.pichost.org/image/2emxU)
Another little tool for everyone!
This one will simply put in an ordinal order the nrs that came out.
(link:://:.pichost.org/images/2018/07/15/temp_961321.png) (link:://:.pichost.org/image/2NVMi)
Has the dynamic option: it will only show the ordinal values at the new spin, to make the reading easier and allow a smaller window if using the file in parallel with other windows:
(link:://:.pichost.org/images/2018/07/15/temp_901006.png) (link:://:.pichost.org/image/2NXLA)
It also tracks the ordinal gaps when a repeater arrives:
(link:://:.pichost.org/images/2018/07/15/temp_281964.png) (link:://:.pichost.org/image/2Navs)
P.S.: can you find Waldo?
(link:://:.pichost.org/images/2018/07/15/temp_575447.jpg) (link:://:.pichost.org/image/2Nd67)
Hi Bigbroben,
You do very good work and hard work.
I would like to suggest you to learn Mathematica to be more flexible in programming.
Buy yourself a Raspberry Pi (~40â,¬). Mathematica is shipped with other software for free.
Quote from: Herby on Jul 16, 02:15 AM 2018
Buy yourself a Raspberry Pi (~40â,¬). Mathematica is shipped with other software for free.
Huh, no, I grow raspberries, don't need to buy them to make pie. Thanks anyway...
*********************
I' ll have a look...
Just tell me if you found Waldo, ok?
Quote from: Bigbroben on Jun 18, 07:19 PM 2018
6th,
here you go. Have a look!
Tell me if you need more.
nolinkss://getyarn.io/yarn-clip/d42cba00-694a-4ff7-bcb9-48faf016199a
calculator is on here POLUVOLO