Page 1 of 1

Formula for calculating avg/500m

Posted: August 26th, 2007, 7:49 am
by prossi
can anyone share the formula for this calculation
thanks

Re: Formula for calculating avg/500m

Posted: August 26th, 2007, 9:35 am
by PaulS
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

Posted: August 27th, 2007, 5:38 am
by prossi
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

Posted: August 27th, 2007, 11:44 am
by PaulS
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?

Posted: August 27th, 2007, 3:31 pm
by tbartman
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).

Posted: August 27th, 2007, 4:07 pm
by Rafael
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.