Advertise on Bikeforums.net



User Tag List

Results 1 to 11 of 11
  1. #1
    Senior Member
    Join Date
    Jun 2005
    Posts
    776
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There is a saying that if you remember the '70s you were not there and one of the many things I don't remember is math. Since my computer doesn't average speed does anybody have a formula that lets me enter milage and time to get an average or does anyone know where I can find a chart.

    For example, Tuesday we did 20 miles in 1hr, 36 minutes and today we did the same 20 miles in 1hr and 15 minutes. How does an aged brain do the math?

    LastPlace

  2. #2
    I need more cowbell. Digital Gee's Avatar
    Join Date
    Jun 2005
    Location
    Reno, Nevada
    My Bikes
    2012 Masi Evoluzione, 2009 Specialized Globe Vienna 2
    Posts
    7,894
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The first time, you rode an average of 12.5 mph. The second, you rode an average of 16. In the first instance, you rode 1.6 hours (36 minutes = .6 of an hour), and in the second run, you rode 1.25 hours. Divide both by 20 miles and you'll get these results.

    And avoid appearing on NPR's Whatdya Know, with Michael Feldman, because you will get the question wrong if the category is Things You Should Have Learned in School. :-)
    Visit my blog! The Leadership Almanac
    2012 Masi Evoluzione
    2009 Specialized Globe Vienna 2

    Proud member of the original Club Tombay

  3. #3
    Burnt Orange Blood Longhorn's Avatar
    Join Date
    Apr 2005
    Location
    Dripping Springs, Texas
    My Bikes
    Trek 7200, Lashout Electric Bike, Raleigh Talon
    Posts
    825
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The formula is Distance = Rate*Time. So you can divide the distance by the time (in hours, since you want miles per hour) to solve for the rate.

    (Just a generalization of the calculators that Digital Gee did for you. I teach math so I couldn't resist. )

  4. #4
    Senior Member JavaMan's Avatar
    Join Date
    Sep 2004
    Location
    Southern California
    My Bikes
    2013 KHS Flite 747
    Posts
    1,068
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This spreadsheet may be easier for you to use.
    JavaMan!
    Faster than a speeding moped!
    More powerful than the Santa Ana winds!
    Able to bunny-hop railroad tracks in a single bound!

  5. #5
    Life is good RonH's Avatar
    Join Date
    Jan 2001
    Location
    Between Crystal River and Hernando, Florida, 6 miles west of the Withlacoochee Trail
    My Bikes
    I've had several since 1999 but have settled on my beloved 2001 Litespeed Tuscany and my latest, a 2013 Cannondale CAAD 10.
    Posts
    13,719
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Example: time = 2 hours and 17 minutes. distance = 38.6 miles

    First convert the hours (2 hours) to minutes by multiplying them by --> 60. 2x60=120

    Then add the minutes (17 minutes) to that number. --> 120+17=137

    Now divide by 60 to get the decimal equivalent. --> 137/60=2.283

    Now divide the miles (38.6 miles) by the time (2.283). --> 38.6/2.283=16.9 mph
    My bikes: 2001 Litespeed Tuscany---
    2013 Cannondale CAAD 10 2 "Racing Edition"--The bike shop owner said it's toast after the car-bike accident. R.I.P.
    * * 2014 or 2015 CAAD 10 3 coming soon. Decision time. * *

    Life is like a 10-speed bicycle. Most of us have gears we never use. ~ Charles Schultz

  6. #6
    Senior Member
    Join Date
    Jun 2005
    Posts
    776
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks folks. It's all coming back to me.....at least I think so.

    LastPlace

  7. #7
    Senior Member Garfield Cat's Avatar
    Join Date
    Oct 2004
    Location
    Huntington Beach, CA
    My Bikes
    Cervelo Prodigy
    Posts
    5,098
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The easiest thing to do is to buy a new cyclometer. They're relatively inexpensive for the low end models and you should be able to get the average speed feature with it. Today is Father's day and maybe you'll get one today. If not, whatever you get, exchange it for a new cyclometer.

  8. #8
    Senior Member
    Join Date
    Jun 2005
    Posts
    776
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Garfield,
    Thanks for the reply. I have had a basic Sigma for the last year but it did not have an
    average speed function. Last night I put on my TOPEAK Panoram V12 and so far so good,
    and yes it does have an average speed function. Eighteen miles at 11.8 mph. Nice easy
    ride.

    LastPlace

  9. #9
    Newbie Extraordinaire
    Join Date
    Jul 2004
    Location
    Just outside San Fransicsco
    My Bikes
    Trek 1000
    Posts
    556
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Let me introduce you to the google calculator, which is perfect for doing math with various units. If you want to know your average speed, go to www.google.com and type in "20 miles / 96 minutes in mph" and hit enter. Click this link to see what it looks like:

    http://www.google.com/search?hl=en&l...ph&btnG=Search

    - Warren

  10. #10
    Junior Member
    Join Date
    Jun 2005
    Location
    ohio
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, google calculator is the way to go.
    "20 miles / 1 hour 36 minutes in mph" also works.
    "15 mph in feet per second" = 22 feet per second
    "1 3/8 inches in mm" = 34.925 mm

  11. #11
    Senior Member
    Join Date
    Jun 2005
    Posts
    776
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the help. I bought a Panoram v12 and it does all the math for me, i.e.
    it averages speed but thanks again.

    LastPlace

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •