Would you like to know the expected duration of each race, in seconds? To use in Excel with Cymatic, for example when building an automated strategy to place a bet near the end of the race.
If so, here is formula that might be what you need:
- Code: Select all
=IF(ISERROR(FIND("2m4f", $A$2) )=FALSE, 324, IF(ISERROR(FIND("3m1f", $A$2))=FALSE, 381, IF(ISERROR(FIND("2m1f", $A$2) )=FALSE, 258, IF(ISERROR(FIND("2m3f", $A$2) )=FALSE, 282, IF(ISERROR(FIND("2m6f", $A$2) )=FALSE, 355, IF(ISERROR(FIND("2m2f", $A$2) )=FALSE, 263, IF(ISERROR(FIND("1m6f", $A$2) )=FALSE, 212, IF(ISERROR(FIND("1m3f", $A$2) )=FALSE, 135, IF(ISERROR(FIND("2m5f", $A$2) )=FALSE, 326, IF(ISERROR(FIND("2m7f", $A$2) )=FALSE, 354, IF(ISERROR(FIND("1m4f", $A$2) )=FALSE, 142, IF(ISERROR(FIND("1m2f", $A$2) )=FALSE, 125, IF(ISERROR(FIND("1m5f", $A$2) )=FALSE, 189, IF(ISERROR(FIND("1m1f", $A$2) )=FALSE, 102, IF(ISERROR(FIND("3m3f", $A$2) )=FALSE, 419, IF(ISERROR(FIND("3m7f", $A$2) )=FALSE, 389, IF(ISERROR(FIND("3m4f", $A$2) )=FALSE, 467, IF(ISERROR(FIND("3m2f", $A$2) )=FALSE, 393, IF(ISERROR(FIND("3m5f", $A$2) )=FALSE, 476, IF(ISERROR(FIND("3m6f", $A$2) )=FALSE, 450, IF(ISERROR(FIND("4m1f", $A$2) )=FALSE, 523, IF(ISERROR(FIND("4m3f", $A$2) )=FALSE, 520, IF(ISERROR(FIND("1m7f", $A$2) )=FALSE, 228, IF(ISERROR(FIND("4m2f", $A$2) )=FALSE, 546, IF(ISERROR(FIND("5f", $A$2) )=FALSE, 55, IF(ISERROR(FIND("6f", $A$2) )=FALSE, 61, IF(ISERROR(FIND("7f", $A$2) )=FALSE, 79, IF(ISERROR(FIND("4m", $A$2) )=FALSE, 497, IF(ISERROR(FIND("3m", $A$2) )=FALSE, 360, IF(ISERROR(FIND("2m", $A$2) )=FALSE, 228, IF(ISERROR(FIND("1m", $A$2) )=FALSE, 91, 0)))))))))))))))))))))))))))))))
Put this formula somewhere in your spreadsheet in a cell that wont be overwritten by incoming Cymatic data. For example to the right of all the columns with data or command results.
The formula will display the expected race duration, in seconds, based on the length of the race which is usually included in the cell A2. If for any reason the race length is not included in the data that Cymatic displays in cell A2, then the formula will display 0 instead of a predicted duration.
I got the race duration estimates from another site, but haven't checked them. I think they are probably meant to represent statistical average durations for each known race length.
I presume that they are average durations for flat races across all weather conditions.
Using this formula might be quicker and more efficient in Excel than searching a table of race duration data with a VLOOKUP function.
Kind regards,
Gavin
