Ha ha yer Excel will do that to you.

I have the FVRatings 2012 Update one that was uploaded on 2nd February 2012

I can send it to you if you want? I might have some ideas for your program also.

What does FV mean?

FV - Forum Version because i had to make changes so it worked for other versions of excel but have updated now.

I made the changes to the program last night not exactly the way i would like, but will have to do for now.

I had a look at a couple races and most times there was only 1 barrier trial that would effect things unless you were betting on 2yo races and such but this program works best for better performed horses.

I have set it up if the fitness or the form sections see a barrier trial then for that run they will get rated at the worst possible level, for fitness they will be rated at running 100 days ago, since i can't account on how they were run this is the best option.

For the lengths beaten it will be set at 10.

The main difference is the class factor, if the last run was a trial it will look at the run before that to take the class rating from, if they had 2 trials this will just be to bad.

Maybe down the track i will find a better option.

I have made some changes to this sheet and it should work with all versions of excel, just follow the instructions sheet.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Forgot to add file.

Attached Files

Consensus Ratings 2012.xlsm (7.29 MB, 363 views)

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

don't use that last sheet it is incorrect oen.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Ok here is the file, i forgot to save a portion before that's why it was wrong.

Attached Files

Consensus Ratings 2012.xlsm (7.32 MB, 366 views)

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

I made a small update to the program but won't upload a new one i will just tell you what to do.

On the "MainSheet" in cell Y31 replace the formula with this.

=IF($S$16="","",IF(ISNA(VLOOKUP(U31,$U$18:$X$21,4,FALSE)),"",VLOOKUP(U31,$U$18:$X$21,4,FALSE)))
Then click the bottom right corner of the cell and drag it down to Y38

What it does is pick up on the 4th place horse and puts in a zero just so you know the selection on the results page.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

Thanks Shaun, that works

As with all my sheets they are a work in progress so if i make any significant changes i will post the sheet on the forum.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________