|
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 |
| All times are GMT +10. The time now is 06:54 AM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.