Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Calculation

Options
  • 26-07-2011 8:06pm
    #1
    GT_TDI_150
    Registered Users Posts: 10,917 ✭✭✭✭


    Hey,

    I have the distance I cycle and the time it takes me to cover the distance.

    how do I get my (avg) speed?

    s=d/t seems to be the formula, but for my parameters 22.2km/00:52:45

    I'm getting 606:eek:


Comments

  • Options
    #2
    Alanstrainor
    Moderators, Motoring & Transport Moderators Posts: 23,157 Mod ✭✭✭✭Alanstrainor


    I get 25.5km/h roughly...


  • Options
    #3
    Jawgap
    Closed Accounts Posts: 20,297 ✭✭✭✭Jawgap


    GT_TDI_150 wrote: »
    Hey,

    I have the distance I cycle and the time it takes me to cover the distance.

    how do I get my (avg) speed?

    s=d/t seems to be the formula, but for my parameters 22.2km/00:52:45

    I'm getting 606:eek:

    Your speed is just over 25 km/h

    52:45 = 0.8792 hrs

    Speed = 22.2/0.8792 = 25.25 km/h


  • Options
    #4
    Alanstrainor
    Moderators, Motoring & Transport Moderators Posts: 23,157 Mod ✭✭✭✭Alanstrainor


    Jawgap wrote: »
    Your speed is just over 25 km/h

    52:45 = 0.8792 hrs

    Speed = 22.2/0.8792 = 25.25 km/h

    Yup that's how i got my figure.


  • Options
    #5
    GT_TDI_150
    Registered Users Posts: 10,917 ✭✭✭✭GT_TDI_150


    Jawgap wrote: »
    Your speed is just over 25 km/h

    52:45 = 0.8792 hrs

    Speed = 22.2/0.8792 = 25.25 km/h

    thanks, how did you get to that figure?


  • Options
    #6
    Alanstrainor
    Moderators, Motoring & Transport Moderators Posts: 23,157 Mod ✭✭✭✭Alanstrainor


    GT_TDI_150 wrote: »
    thanks, how did you get to that figure?

    52.45/60

    You want to find it in terms of hours, so 52.45 is .87 of an hour


  • Advertisement
  • Options
    #7
    Jawgap
    Closed Accounts Posts: 20,297 ✭✭✭✭Jawgap


    52mins and 45 seconds = 52.75mins = 52.75/60 = 0.8792hrs:)


  • Options
    #8
    Jawgap
    Closed Accounts Posts: 20,297 ✭✭✭✭Jawgap


    Alanstrainor wrote: »
    52.45/60

    You want to find it in terms of hours, so 52.45 is .87 of an hour

    FAIL!!!!

    Although there's only 0.3 in it........


  • Options
    #9
    Alanstrainor
    Moderators, Motoring & Transport Moderators Posts: 23,157 Mod ✭✭✭✭Alanstrainor


    Jawgap wrote: »
    FAIL!!!!

    Although there's only 0.3 in it........

    Bastard:P


  • Options
    #10
    chakattack
    Registered Users Posts: 1,315 ✭✭✭chakattack


    I thought this might be about Sean Kelly's commentating on Eurosport :)


  • Options
    #11
    thebouldwhacker
    Registered Users Posts: 3,565 ✭✭✭thebouldwhacker


    Or just use THIS


  • Advertisement
  • Options
    #12
    GT_TDI_150
    Registered Users Posts: 10,917 ✭✭✭✭GT_TDI_150


    thanks lads, I keep track of all my food intake/excersise/... on an spread sheet and wanted to add the avg speed


  • Options
    #13
    andy69
    Registered Users Posts: 661 ✭✭✭andy69


    if u are using OpenOffice (or even Excel) to record your training, you could use this formula to calculate the average speeds...

    =B1/(A1*24)

    This is where the distance is in Cell B1 and the Time is in Cell A1

    So, to enter times, just format the cell for 'time' (right click) and pick the '13:47:46' format. As an example then for a 100km spin you can enter:
    02:55:00 as your time
    100 as your distance
    the average speed then would be 34.29 km/h

    hth,
    andy


  • Options
    #14
    Jawgap
    Closed Accounts Posts: 20,297 ✭✭✭✭Jawgap


    Websites.........spreadsheets...........does anyone (apart from Mark Renshaw) use their head in cycling any more?


  • Options
    #15
    Pherekydes
    Registered Users Posts: 16,115 ✭✭✭✭Pherekydes


    Jawgap wrote: »
    Websites.........spreadsheets...........does anyone (apart from Mark Renshaw) use their head in cycling any more?

    No. Helmets are compulsory.


  • Options
    #16
    GT_TDI_150
    Registered Users Posts: 10,917 ✭✭✭✭GT_TDI_150


    Jawgap wrote: »
    Websites.........spreadsheets...........does anyone (apart from Mark Renshaw) use their head in cycling any more?

    it's for historical purposes, so I can go back and track my improvement


  • Options
    #17
    magicbastarder
    Moderators, Category Moderators, Arts Moderators, Sports Moderators Posts: 48,482 CMod ✭✭✭✭magicbastarder


    you realise you're responding to a ten year old thread?
    the OP is (by my calculations) 2.2 million km away by now, assuming he kept up that speed.


  • Options
    #18
    fat bloke
    Registered Users Posts: 5,822 ✭✭✭fat bloke


    I hope you weren't basing your calorie intake on cycling at 600kph...
    I'd like to see those Garmin numbers :D


  • Options
    #19
    dastardly00
    Registered Users Posts: 13,319 ✭✭✭✭dastardly00


    chakattack wrote: »
    I thought this might be about Sean Kelly's commentating on Eurosport :)

    ^^^
    This post may be a decade old but it's still applicable :)


Advertisement