I'm going to use excel to help with my class and weight ratings. My problem is working out the formula for the following.

CLASS RATING-BEATEN MARGIN+WEIGHT=RATING

The headings for my spreadsheet are:

Name of Horse...Jockey...Class Rating...Beaten Margin...Weight...Rating.

Love Street......J. Bloggs....56.................4.9................56 .5....

Benny

If your headings are in row 1 and your data starts in row 2.....

In cell F2 (your rating column) type in =(C2-D2)+E2

Copy this cell and paste it all the way down the column, as far as you have data.

HTH.

__________________
RaceCensus - powerful system testing software.
Now with over 413,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/01/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

I forgot. CR-BM*1.5+wt-lim wt=Rating.

Benny

Not sure if this is what you want Benny

Attached Files

Benny.xls (13.5 KB, 608 views)

It's a starting point.

Name of Horse...CR...BM...Wt Carr...Limit Wt...Rating.

Now the formula I came up with is

=(c3-d3*1.5)+e3-f3

Now how do I set it up so that I don't have to enter the formula each time. I tried copy and paste but it didn't work. I must be doing something wrong.

Benny

Send me the file and I will sort it out retireme@mailup.net I'll also put some comment so you know how I did it. It's the best I can offer...

Your right except you have to subtract the weight carried from the limit weight.

Benny

No Probs

Hi Benny,

I'm not trying to be rude, but I hope you're not going to bet a lot of money based on your spreadsheet at this early stage. It's easy to make a small mistake with a formula that ************s up the whole sheet, and if you're just starting out with the software (as you obviously are) I would suggest constant checking with pen and paper before you are confident of the results.

Monkeyinjapan

While on the subject could somebody please help me with the following problem.

In a spreadsheet in cell A1 I have a figure, in cell A2 I want to divide the figure in A1 by 11.5 and then round up or round down the answer to the nearest .25
for example 52.4322 i want to become 52.5 52.8976 I want to become 53 52.2134 I want to become 52.25 ecetera . could some body please supply the formula I need for A2 or does the rounding need to be done in the next cell ?

Thanks