excel formula help

[ulsteroptom]

is there a formula that can be created to calculate the pocket distance between spins, with the highest distance between spins to be shown no higher than 18, not fussed about cw or ccw, just distance being less than or equal to 18.

ie
19
30 dist 12
6 dist 5
1 dist 13
34 dist 14
29 dist 16
etc

can this be done, or is it too complicated
any help would be appreciated
thanks

[Nickmsi]

Hello . . .

We already have done this in Excel but I am not sure if we have a confidential agreement which would prevent us from releasing the sheet.  I will advise when I find out.

Thanks

Nick

[ulsteroptom]

thanks Nick

would be great if you could, pain to do this manually, working on something just now, will share if any reasonable results from it

[ulsteroptom]

well not quite manually
using IGNATUS avg dist program to give me just the pocket distances (thanks for that one mate), which i am plugging into excel,  but even that is tedious when testing over a few hundred spins

[Nickmsi]

Hi Mate . . .

I sent you a PM.

Thanks

Nick