Thanks SteveT not sure if anyone's used it yet with no racing on , but you can download historical results from HRB, and build up I reckon maybe a years worth of data on the one sheet, then if you have any database skills at all you can pull of the days runners from HRB and get all the ratings for all the runners, if I get time I might create a simple little database to do that and post it up especially if anyone is likely to use it, handy as well that you can put in your own standard times.Hi O Outlander
What a great little tool you have made there and i'm sure it will be a great help to many
Hi Cashelman i can’t think of anything to add to the instructions, is there are particular stage you are finding a problem?Good Morning, looks a great little tool but for us techno phobes any chance of some more detailed instructions please
Not at my PC but BX was working fine when I tested it you must have a rogue value for one of the rows in BW, what date of data did you input. HRB has little faults with the total distance Z column sometimes returning SH or HD instead of numeric , I thought I had covered this with a workaround something in the data you have obviously I must have missed something else.Hi O Outlander
It looks like column BX has an incorrect formula
View attachment 83609
=1+SUMPRODUCT(($BD$2:$BD$20000=BD547)*($BW$2:$BW$20000>BW547))
I’m only guessing here but it could be you have highlighted the formulae and double clicked to copy them down, unfortunately when I was creating the sheet I had a lot if data on the sheet, so double clicking means you will get formulae in cells below your HRB data, I think this is causing the error , try dragging the formulae down to match the amount of data you have or just deleting and excess formulae below your data.Hi O Outlander
It looks like column BX has an incorrect formula
View attachment 83609
=1+SUMPRODUCT(($BD$2:$BD$20000=BD547)*($BW$2:$BW$20000>BW547))
Yes to be honest I forgot Dundalk , but you can add any course and standards to the STANDARDS worksheet , as long as you always sort the course and distance description into A-Z orderI think my issue I chose a day when there was racing at Dundalk
Believe me SteveT my skills are very limited I have no idea of advanced filters or pivot tables, I just wanted to create something that could be done in seconds and it’s quite basic really.O Outlander i have a few years hrb data that i will have a go with myself but i think it will be a very handy tool for anyone especially those of us with limited excel skills and the added database would be a handy tool as well. I have an excel database myself it's just a basic one but spending my free time looking at ways to improve it and just added an advanced filter to it and experimenting with a couple of pivot tables.