can anyone share the formula for this calculation
thanks
Formula for calculating avg/500m
- PaulS
- 10k Poster
- Posts: 1212
- Joined: March 16th, 2006, 12:07 pm
- Location: Washington State, USA
- Contact:
Re: Formula for calculating avg/500m
Total Time / (Total Distance/500m)prossi wrote:can anyone share the formula for this calculation
thanks
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."
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."
- PaulS
- 10k Poster
- Posts: 1212
- Joined: March 16th, 2006, 12:07 pm
- Location: Washington State, USA
- Contact:
Those appear to be correct (second one is 2:33.94, but rounded dow). Does it seem incorrect to you for some reason?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
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."
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."
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.
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.