Working really well, one question

[stevemoulton]

Hi

Just wanted to check in and say that I found this yesterday and in about an hour I had every Cheltenham race since 2010 in a sqlite database and I'm having great fun messing around with the data.
Just one thing I wanted to ask about, it looks like you are using some algorithm to approximate the times of all horses (except the winner) as bizarrely this information still isn't made available in racing. Could you give me a brief rundown of how the algorithm works?

Thanks again
Steve

[joenano]

"Distances are calculated on the elapsed time between each horse and then a scale known as the Lengths per Second Scale (Lps) is used dependent upon whether it is Flat or Jumps racing, the type of surface in use at the all-weather fixtures and the official going description issued on the day. The Scales used vary from four to five Lps for Jumps racing and from five to six Lps on the Flat."

https://www.britishhorseracing.com/wp-content/uploads/2014/04/Lengths-Per-Second-Scale-Tables-2019.pdf

The algorithm is just reversing this.

[stevemoulton]

Thanks!