We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Whenever I download a list of horses I'm interested in from the site I use, I'm presented with a spreadsheet that looks like this.......
Let me say at the outset, one of the column headers is misleading because these are not 'system' horses in the accepted sense but horses that meet certain criteria and at this stage are only potential back/lay selections. The 'slot' column is simply a numerical identifier for each set of criteria.
What I intend doing is to add an extra column named 'points' and then to copy and paste a VLOOKUP table in to the spreadsheet to convert the 'slot' number to a points value, something along the lines of.......
I'm OK up to this point but need help with the next part.
As there's every chance that several horses will appear in more than one slot (there are actually a good few more than the six slots I've shown), I would like to be able, after sorting the data in to track and race_time order, to total the points value(s) for each horse and then display them in descending order.
Any suggestion as to how I could achieve this would be appreciated.
Thanks.
| slot | systemname | horse_name | race_time | track | odds_numerical |
| 2 | B | Shutupandrive | 16:20:00 | Wolverhampton | 20 |
| 3 | C | Lacdoudal (FR) | 15:00:00 | Cheltenham | 7.5 |
| 3 | C | Fantasy Gladiator | 15:15:00 | Lingfield | 8 |
| 3 | C | Overquest | 15:25:00 | Newcastle | 4.5 |
| 3 | C | Sheilas Castle | 15:45:00 | Lingfield | 4.5 |
| 3 | C | Time For Rupert (IRE) | 16:05:00 | Cheltenham | 1.88 |
| 3 | C | Reve de Sivola (FR) | 16:05:00 | Cheltenham | 2.75 |
| 3 | C | Rjeef (IRE) | 19:50:00 | Wolverhampton | 4 |
| 4 | D | Salient | 15:15:00 | Lingfield | 25 |
| 4 | D | Prince Of Thebes (IRE) | 15:15:00 | Lingfield | 10 |
| 4 | D | Ocarina (FR) | 15:25:00 | Newcastle | 4 |
| 4 | D | Pitkin | 16:20:00 | Wolverhampton | 1.63 |
| 4 | D | Only A Game (IRE) | 17:20:00 | Wolverhampton | 14 |
| 4 | D | Fastnet Storm (IRE) | 19:50:00 | Wolverhampton | 8 |
| 5 | E | La Concorde (FR) | 14:05:00 | Lingfield | 1.5 |
| 5 | E | Primrose Time | 14:15:00 | Newcastle | 1.25 |
| 5 | E | Taurakina | 17:20:00 | Wolverhampton | 1.38 |
| 5 | E | Celani | 18:20:00 | Wolverhampton | 1.5 |
| 5 | E | Realisation (USA) | 18:50:00 | Wolverhampton | 1.5 |
| 6 | F | Quattrocento (FR) | 13:15:00 | Cheltenham | 5 |
| 6 | F | Theatrical Moment (USA) | 13:15:00 | Cheltenham | 7.5 |
| 6 | F | Rustarix (FR) | 13:15:00 | Cheltenham | 12 |
| 6 | F | Knowhere (IRE) | 13:15:00 | Cheltenham | 6 |
| 6 | F | Tramantano | 14:25:00 | Cheltenham | 0 |
| 6 | F | Perce Rock | 14:25:00 | Cheltenham | 25 |
| 6 | F | Bianca De Medici | 15:15:00 | Lingfield | 6 |
| 6 | F | Tarvini (IRE) | 15:35:00 | Cheltenham | 33 |
| 6 | F | Max Bygraves | 15:35:00 | Cheltenham | 14 |
| 6 | F | Mickmacmagoole (IRE) | 15:35:00 | Cheltenham | 25 |
| 6 | F | Rhum (FR) | 15:35:00 | Cheltenham | 14 |
| 6 | F | Realisation (USA) | 18:50:00 | Wolverhampton | 1.5 |
| 6 | F | Sarah Park (IRE) | 19:50:00 | Wolverhampton | 12 |
| 6 | F | Fastnet Storm (IRE) | 19:50:00 | Wolverhampton | 8 |
Let me say at the outset, one of the column headers is misleading because these are not 'system' horses in the accepted sense but horses that meet certain criteria and at this stage are only potential back/lay selections. The 'slot' column is simply a numerical identifier for each set of criteria.
What I intend doing is to add an extra column named 'points' and then to copy and paste a VLOOKUP table in to the spreadsheet to convert the 'slot' number to a points value, something along the lines of.......
| slot | points |
| 2 | -4 |
| 3 | 7 |
| 4 | -1 |
| 5 | 8 |
| 6 | 10 |
I'm OK up to this point but need help with the next part.
As there's every chance that several horses will appear in more than one slot (there are actually a good few more than the six slots I've shown), I would like to be able, after sorting the data in to track and race_time order, to total the points value(s) for each horse and then display them in descending order.
Any suggestion as to how I could achieve this would be appreciated.
Thanks.
Show More
Hi top2rated
Not positive of what you require but my guess would go like this ~
First select your total data area then in the name box type datum then press enter
In a column next to your points uses SUMPRODUCT(....) (because there is no SUMIFS in open office)to get the sum total points for each horse.
In another column use a different SUMPRODUCT(....)+1 ~ that ranks your points for each race/time/slot/points
Go to the name box click datum which will highlight all your data
Then do a sort on the resulting rank column in descending order then sort once more for the race.
The last three steps could be accomplished by one click of a macro.
If I knew exactly what columns you use for what and the start and finish cells of your data I could write the SUMPRODUCT
formulas for you and also the macro. If your data is open ended instead of the using the name box you would define the name "datum" dynamically with Offset....Count Offset in name manager.
Not positive of what you require but my guess would go like this ~
First select your total data area then in the name box type datum then press enter
In a column next to your points uses SUMPRODUCT(....) (because there is no SUMIFS in open office)to get the sum total points for each horse.
In another column use a different SUMPRODUCT(....)+1 ~ that ranks your points for each race/time/slot/points
Go to the name box click datum which will highlight all your data
Then do a sort on the resulting rank column in descending order then sort once more for the race.
The last three steps could be accomplished by one click of a macro.
If I knew exactly what columns you use for what and the start and finish cells of your data I could write the SUMPRODUCT
formulas for you and also the macro. If your data is open ended instead of the using the name box you would define the name "datum" dynamically with Offset....Count Offset in name manager.
In fact a macro could do it all for you including putting in the vlookup.
After doing your download it would mean just running the macro which would take only a second to do it all.
After doing your download it would mean just running the macro which would take only a second to do it all.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539