Surely
average speed = distance/((seconds+(minutes*60)+(hours*60*60))/3600)
by using number of seconds * 1.665 you are introducing an error, it may only
be 1% error but that greater than the error in the original question which I
believe was 0.85%.
-----------
LeeG
-----------
"TJ" <[email hidden]> wrote in message
news:[email hidden]...
My computer does feature a dist timer as you mention which does stop within
a second or two whenever the bike becomes stationary so I dont think that
this this is an issue.
I really don't see why it isn't calculating the Average Speed from it's own
figures in the same way I am ?
I'm using excel to calculate the A/Spd by simply dividing the Distance
covered by the time taken to cover it.
(Because a minute is only 60 secs and excel works in Decimal I multiply the
seconds by 1.665).
The entire result is then multiplied by 60 to give the MPH.
e.g.
This mornings Distance / Time was 5.00 miles in 15m 06s
The 6 seconds are multiplied by 1.665 (.06 * 1.665) to give .10 this is
done to give the base 10 representation of the number for the calculation
so
( 5.00miles / 15.1 ) * 60 = 19.08 Mph
I'm sure i'm right - Aren't I ?
when I use other test data in my formula i.e. miles 10.5, Dist 10.3 10.5
miles in 10 mins 30 seconds for example the result is 60mph as expected.
Even if I skip the corrective adjustment I mention the result is still only
19.92 yet the Sigma BC1200 is reporting the average speed this morning as
20.12 Mph
TJ
"TJ" <[email hidden]> wrote in message
news:[email hidden]...
Quoted message said:Maybe I am missing something or is the computer really getting it wrong.
I have a SigmaSport BC1200 comp which is seemingly recording my average
speeds incorrectly.
example 5.03 Miles in 19m47s returns an Average Speed of 15.39 Mph
My own calcs make this 15.26 Mph
If the comp is right can someone explain why ?
Thanks
TJ
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004