Adjusting race times for Masters rowers

Following up our article about Adjusting Erg Scores for Masters Athletes, we got a reply from Lewin who shared a spreadsheet by RowPro with a calculation for a 2000m race giving handicap in seconds and a per meter factor.
This means if your race is a different distance you can easily work out the adjustment for your situation.

Many thanks, Lewin.

Download the Master Rowers age adjustment factor

3 thoughts on “Adjusting race times for Masters rowers

  1. David Harralson says:

    Very interesting spreadsheet.

    This came up awhile ago, when we had erg trials for our Masters rowers. At 73, my splits were slower than some of the younger, heavier rowers, and I commented on this to our coach. Knowing I was a geek, he looked at me and said “spreadsheet”. So, I did one.

    It will take every integer age between 12 and 100+, exact distances of 500, 1,000, 2,000, 5,000, and 10,000 meters (it will interpolate for other distances) and athlete weight and will handicap the raw time to any age. This way all rowers in a club will have a common handicap time. Or for grade school rowers, it can predict what time they could row when they get out of high school.

    For clubs, it has a member sheet so each member’s age and weight need to be entered only once.

    It also has sheets for time rowed in singles (M/F) doubles (M/F/X), pairs (M/F), quads (M/F/X), and eights(M/F,X) for all the distances. The time rowed for each boat class is also handicapped for age and expressed in equivalent erg split times. So, the rower can row a piece in their boat and see how that compares with their erg time. Slower means they should concentrate on form, faster means they are an efficient rower. Or you can enter a time from the Masters World Championships and see what erg time to aim for to possibly be competitive.

    It has a sheet for all the boats in a club so that times in an entry level boat are fairly compared with those set in a racing boat.

    All the basic data is entered in cells in the spreadsheet, so if you do not like something, it can be changed. Every input is fully documented, so a reasonably computer literate person can take advantage of the results presented by the spreadsheet. This barely touches on its possibilities. The number obsessed rower, coach,or director can immerse themselves in its possibilities.

  2. Rebecca Caroe says:

    David, would you be willing to share this spreadsheet with our readers? Send it to becky at rowperfect dot co dot Uk and we’ll publish it!

    Thanks for adding your experiences to the communal knowledge base.

  3. David Scoins says:

    If you are a runner, this is found easily be researching ‘age-grading’. These tables express your effort as a percentage of the world record speed (not time), adjusted for age according to the decay curve now fairly well established and available for rowers above.
    So you can then adjust your own results to compensate for age and express this as a percentage. That then allows you to see your times or results in terms which are independent of age decay, which, as an older runner, is one of the few things keeping me pounding away on the roads. The clock on its own is far too depressing.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.