|
Updating rating columns after scratchings
Each Saturday I concentrate on the 5 metro meetings and I use different columns within excel with ratings from 1 up to however many horses in the race. Example like the average prizemoney order. After scratchings I find it time consuming reordering the column ratings. Is there a way to do this automatically without changing the tab order of the horses in each race. I have the five meetings on one sheet so if it could be done to all five meetings at once that would be even better.
Thanks in advance Twodogs |
I'ld like to help, but without seeing a sample of what you got, is hard.
I don't understand why you can't just clear the contents of the scratched horse. And if it stuffs up your Formulas, then alter the Formula to begin with an IF Statement. |
Moeee
Clearing the contents is the easy part. There are no formulas in the sheet itself other than the one I use for scratchings but is unrelated to the rating data. What I want to do is you start of with say the average prizemoney ratings 1 through to 10 but you have 2 scratchings so the ratings now should be 1 through 8. I have six columns of data that I want to be able to rerate after scratchings. Cheers Twodogs |
1 3 1 1 1 1
9 7 2 2 2 6 5 4 7 5 5 8 7 9 4 3 3 4 2 1 5 4 4 2 4 5 8 6 6 3 10 11 6 10 7 10 8 6 10 9 10 11 3 2 11 8 9 7 11 10 12 11 12 9 12 12 9 12 11 12 The Data looks like this in six columns and this is just one race. The cap being the scratched horse. Of course the data is columns unlike the way it is shown here. |
Twodogs deleting the line (row) should fix it, not just whats in the row. Record a macro you could run to rerate after deleting the line
Cheers |
Sorry Crackone
I have no idea when it comes to Macros!! I do want to keep the number of runners in the same so deleting the line isn't at present an option. Could it be rerated if the is data relating to the scratched horses was deleted and left blank? Twodogs |
Quote:
As Moeee said it is hard without seeing. Do you have the meetings across the spreadsheet or down? How do you rate the horses (manually). |
The meetings go down the page so all columns are constant down the page.
Manually I just look at which horses are scratched and renumber the ratings in order from 1 up so to speak. Twodogs |
Quote:
|
Thanks for trying Crackone
Yes I tried that this morning but it is slow but it does do the job so to speak. It maybe the only way to do it but thought it worth asking around to see if it could automated somehow. Cheers Twodogs |
So in your example of 12 runners, would every rating number that was above the scratching become 1 less?
In the 1st column the scratching was rated 6. Would all those above 6 rated become 1 less than they were before the scratching? And in the 2nd column it was rated 8. would all those in that column above 8 become 1 less? If that is so, In the example, what is actually in the cells of Number 1 1st row where you have 1 3 1 1 1 1 ? If there ain't no Formula then how did those numbers appear in the cells? |
Hi Moeee,
The data comes from a CSV download from a rating site (Best I don't mention who) They do updates of their PDF file after scratchings but not the CSV file. So if the horse scratched rated 6 every horse rated above 6 would reduce by 1. I paste the csv file contents into my own spreadsheet with formulas to extract what I require. I could email you a sample of the file if that helps? Twodogs |
Thanks for your help guys!
I will try another forum where I can give more details which might help getting an answer. Cheers Twodogs |
Good Luck with it twodogs.
But I tell you what. Whatever time you save after you get it sorted, you are still gonna spend the gained time doing more Punting stuff. I thought I could gain 20 minutes when I eventually found a shortgut but I just used the gained time to twiddle and tweak even more. And I'M STILL LOSING just the same :) |
So very true Moeee,
For all the quicker ways we find to do things the more likely we are to find other distractions. Cheers Twodogs |
| All times are GMT +10. The time now is 05:45 PM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.