#1 Roulette Forum & Message Board | www.RouletteForum.cc

IT & Software => Coding for Roulette => Topic started by: ulsteroptom on Apr 13, 06:02 PM 2013

Title: excel formula help
Post by: ulsteroptom on Apr 13, 06:02 PM 2013
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
Title: Re: excel formula help
Post by: Nickmsi on Apr 13, 06:08 PM 2013
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
Title: Re: excel formula help
Post by: ulsteroptom on Apr 13, 06:14 PM 2013
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
Title: Re: excel formula help
Post by: ulsteroptom on Apr 13, 06:18 PM 2013
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
Title: Re: excel formula help
Post by: Nickmsi on Apr 13, 09:11 PM 2013
Hi Mate . . .

I sent you a PM.

Thanks

Nick