Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 2nd September 2008, 08:52 AM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Question 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
Reply With Quote
  #2  
Old 2nd September 2008, 09:49 AM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

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.
Reply With Quote
  #3  
Old 2nd September 2008, 09:53 AM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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
Reply With Quote
  #4  
Old 2nd September 2008, 10:02 AM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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.
Reply With Quote
  #5  
Old 2nd September 2008, 04:35 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

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

Last edited by Crackone : 2nd September 2008 at 04:38 PM.
Reply With Quote
  #6  
Old 2nd September 2008, 04:42 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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
Reply With Quote
  #7  
Old 2nd September 2008, 05:08 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Quote:
Originally Posted by Twodogs
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
You should be able to rerate but that would depend on how the spreadsheet was set up.
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).
Reply With Quote
  #8  
Old 2nd September 2008, 05:37 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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

Last edited by Twodogs : 2nd September 2008 at 05:56 PM.
Reply With Quote
  #9  
Old 2nd September 2008, 05:54 PM
Crackone Crackone is offline
Member
 
Join Date: Apr 2006
Posts: 368
Default

Quote:
Originally Posted by 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.
Last idea for me, you could drag the last six lines up to the rest, then rerate using the auto fill.
Reply With Quote
  #10  
Old 2nd September 2008, 05:57 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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

Last edited by Twodogs : 2nd September 2008 at 06:03 PM.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 05:36 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655