Converting Miles/Furlongs to Furlongs

Example spreadsheets and comments on example spreadsheets.
Post Reply
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Had some formulas hidden away that I forgot all about until recently. If you want to sort your data by distance you might find them handy.

Works 99% of the time but because of some Betfair inconsistencies, you'll get the odd discrepancies.(Out of 830 rows I can only see 3)

Row 122 ( 1m6 NHF), which calculates to only 8f,
Row 830 Where the distance is 'Grand National' (that the year it was void maybe?)
Row 831 which is just 'PA Stks'
You do not have the required permissions to view the files attached to this post.
dm1900
Posts: 71
Joined: Sun Jan 15, 2017 10:02 pm

I don't get why this is so complicated, 1m = 8f
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Re-post the sheet showing your calculations.
Post Reply

Return to “Bet Angel - Example spreadsheets”