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 protected]> wrote in message
news:
[email protected]...
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 protected]> wrote in message
news:
[email protected]...
> 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