Formula for calculating avg/500m

Look here first for answers to common questions
Locked
prossi
Paddler
Posts: 2
Joined: August 26th, 2007, 7:43 am

Formula for calculating avg/500m

Post by prossi » August 26th, 2007, 7:49 am

can anyone share the formula for this calculation
thanks

User avatar
PaulS
10k Poster
Posts: 1212
Joined: March 16th, 2006, 12:07 pm
Location: Washington State, USA
Contact:

Re: Formula for calculating avg/500m

Post by PaulS » August 26th, 2007, 9:35 am

prossi wrote:can anyone share the formula for this calculation
thanks
Total Time / (Total Distance/500m)

i.e. 20 minutes / (5000m/500m) = 2:00/500m
Erg on,
Paul Smith
www.ps-sport.net Your source for Useful Rowing Accessories and Training Assistance.
"If you don't want to know the answer, don't ask me the question."

prossi
Paddler
Posts: 2
Joined: August 26th, 2007, 7:43 am

Post by prossi » August 27th, 2007, 5:38 am

Thanks Paul...Thats what I thought When I use Concept2 online log...these are the calculation results

5,000M 24:34.0 (2:27.4)
5,000M 25:39.4 (2:33.9)

Any ideas?
Thanks

User avatar
PaulS
10k Poster
Posts: 1212
Joined: March 16th, 2006, 12:07 pm
Location: Washington State, USA
Contact:

Post by PaulS » August 27th, 2007, 11:44 am

prossi wrote:Thanks Paul...Thats what I thought When I use Concept2 online log...these are the calculation results

5,000M 24:34.0 (2:27.4)
5,000M 25:39.4 (2:33.9)

Any ideas?
Thanks
Those appear to be correct (second one is 2:33.94, but rounded dow). Does it seem incorrect to you for some reason?
Erg on,
Paul Smith
www.ps-sport.net Your source for Useful Rowing Accessories and Training Assistance.
"If you don't want to know the answer, don't ask me the question."

User avatar
tbartman
1k Poster
Posts: 160
Joined: November 17th, 2006, 11:31 am
Location: Cincinnati, OH

Post by tbartman » August 27th, 2007, 3:31 pm

prossi,

Remember, there aren't 100 seconds in a minute, so don't make the mistake of trying to move the decimal over in the minutes:seconds (i.e. 25:00 divided by ten isn't 2:50).
[img]http://www.c2ctc.com/sigs/img1225814673.png[/img]

User avatar
Rafael
Paddler
Posts: 11
Joined: March 17th, 2007, 5:22 pm
Location: Providence, RI
Contact:

Post by Rafael » August 27th, 2007, 4:07 pm

Yes, you got be aware of minutes and seconds. Better to put everything in seconds. Say the duration of the row is M minutes and S seconds, and the distance D in meters, the average seconds per 500 meters can be found with this formula:

AVG (in seconds) = 500 (60M+S) / D

For example, 5000 meters in 22:15.8

M = 22
S = 15.8
D = 5000

AVG = 500 * (60*22+15.8) / 5000 = 133.58 seconds

To convert this result back to minutes and seconds easily, just note that this is more than 120 seconds, which is 2 minutes, just take the difference with 120 and you get the seconds: 133.58 - 120 = 13.58, so it's 2:13.58 or 2:13.6 rounding to the nearest 10th of a second.

Note that when using the formula above you have, first, to do the multiplication 60*M, then add S and just then multiply by 500 and divide by D. In other words, do the following with a regular calculator:

60 * M + S * 500 / D

With a RPN calculator, i.e., for all of you HP fans:

60 M * S + 500 * D /

Regards,

Rafael.

Locked