Could anyone test

[Anastasius]

Awesome bigbroben
Will look when at pic

Does it appear that hotter numbers have more chance of double up than colder? Or all numbers evenly chance of double up?

[Anastasius]

bigbro ben can u explain your graph what average means etc please

[Anastasius]

Does this rank multiple numbers the same rank

[Bigbroben]

Does this rank multiple numbers the same rank

No it gives them different ranks.  Same number of hits is the first condition, spins since last hits is the second.

Here is a new file where you see the nrs sorted by their rank as the spins go by.

Enjoy!

[Steve]

Whats the point on ranking them if the odds of them spinning next are no different to any other number?

[Bigbroben]

There is no point.

I just love coding Excel and learning new functions.

But there would be a point if it is used to check for biased wheel.
Or just another way of sorting them out.  Like shuffling Legos and replacing them differently in the box.