Matt Jarvis
Yearling
Hi all,
Just looking for some help/advice on a project I'm working on involving the Winning Distance markets.
I've got individual spreadsheets for each track for every race they've held since the start of 2010 to the end of 2016.
In this spreadsheet, it has the following info (Date , Distance , Going , RCode , Type , Class , Name , Winning Distance).
What I want to do is to create something whereby I will enter the course name, going for the day, Distance, Class, RCode & Type and it will bring me back the average winning distance for that set criteria. I would also like it to highlight any anomalies where the winning distance exceeds a maximum tolerance.
I've attached an example spreadsheet containing the data for Plumpton.
Any help would be greatly appreciated.
Thanks
Matt
Just looking for some help/advice on a project I'm working on involving the Winning Distance markets.
I've got individual spreadsheets for each track for every race they've held since the start of 2010 to the end of 2016.
In this spreadsheet, it has the following info (Date , Distance , Going , RCode , Type , Class , Name , Winning Distance).
What I want to do is to create something whereby I will enter the course name, going for the day, Distance, Class, RCode & Type and it will bring me back the average winning distance for that set criteria. I would also like it to highlight any anomalies where the winning distance exceeds a maximum tolerance.
I've attached an example spreadsheet containing the data for Plumpton.
Any help would be greatly appreciated.
Thanks
Matt