The home of intelligent horse racing discussion
The home of intelligent horse racing discussion

Ratings

Home › Forums › Archive Topics › Systems › Ratings

Viewing 9 posts - 18 through 26 (of 26 total)
1 2
  • Author
    Posts
  • December 29, 2010 at 09:05 #334115
    manchester
    Member
    • Total Posts 43

    Today’s Ratings :D

    https://spreadsheets.google.com/ccc?key … 14QG#gid=0

    December 29, 2010 at 11:03 #334123
    discretedata
    Participant
    • Total Posts 219

    I’ve just downloaded your ratings spreadsheet for yesterday, 28 December, and I’ve discovered a problem. Let me explain.

    I had a closer look at the spreadsheet by ‘showing’ the hidden columns containing the data that is used to produce the rating for each horse.

    The problem, and there were 31 horses yesterday whose rating was wrongly calculated, lies in column L and the formula for awarding 10 additional points if the horse is a Course Winner as identified in Column E with the letter ‘X’.

    The formula in cell L5,


    In effect you’re awarding Course Winners no extra points at all.

    I’ve also checked the first spreadsheet you posted a link to and the same flaw is present. Therefore, assuming this anomaly has gone unchecked until now, all the ratings for Course Winners, in all of the spreadsheets you’ve published, have been inaccurate.

    Sorry to be the bearer of bad news but at least it’s a problem that’s easily resolved.

    All the best.

    December 29, 2010 at 12:24 #334138
    manchester
    Member
    • Total Posts 43

    :( Thanks DD

    I will take a look into that, it could be a flaw as you say :?

    Thanks for pointing that out

    Manchester

    December 29, 2010 at 12:38 #334145
    manchester
    Member
    • Total Posts 43

    ———-STOP PRESS ——————–

    Double at Newbury with changing the cells :o

    December 31, 2010 at 06:46 #334378
    manchester
    Member
    • Total Posts 43

    I am away for a week or so from today, so no ratings until then

    All the very best to you all 8)

    January 5, 2011 at 10:15 #334813
    Avatar photoTheBluesBrother
    Participant
    • Total Posts 1089

    The problem, and there were 31 horses yesterday whose rating was wrongly calculated, lies in column L and the formula for awarding 10 additional points if the horse is a Course Winner as identified in Column E with the letter ‘X’.

    The formula in cell L5,


    In effect you’re awarding Course Winners no extra points at all.

    I have checked the datasheets for the 16.12.10 and the 28.12.10 and cannot see a problem as all the course winners are being awarded the correct points.

    I found that the formula in the

    bot

    used by manchester worked whether it had a lowercase or uppercase ‘X’ 8)

    January 6, 2011 at 10:14 #334867
    manchester
    Member
    • Total Posts 43

    The formula has been checked and is ok as is, my excel is not what it should be tbh

    Anyway here are today’s ratings
    https://spreadsheets0.google.com/ccc?ke … jacD#gid=0

    January 7, 2011 at 06:26 #334933
    manchester
    Member
    • Total Posts 43

    Today’s ratings
    :D
    https://spreadsheets0.google.com/ccc?ke … _64N#gid=0

    January 8, 2011 at 06:23 #335071
    manchester
    Member
    • Total Posts 43

    No Ratings today

  • Author
    Posts
Viewing 9 posts - 18 through 26 (of 26 total)
1 2
  • You must be logged in to reply to this topic.