Running time/speed/distance in Excel

Discussion in 'Health and Fitness' started by Tartan_Terrier, Jan 18, 2007.

Welcome to the Army Rumour Service, ARRSE

The UK's largest and busiest UNofficial military website.

The heart of the site is the forum area, including:

  1. I've been mucking about with Microsoft Excel, and made a spreadsheet you can use to record your running times and distance. Perhaps some of you may find it of some use.

    If you type in the distance, minutes, and seconds it took, it'll work out how long it took you to run a km, and a mile.

    It'll also give your average speed in kph, and mph, as well as giving your average speed for the month, and total time and distance.

    It's the first time I've used Excel, so some of you can probably do better.
    Please feel free to offer advice and/or constructive criticism.

    I've had problems with Yahoo Briefcase, so I've got it attached here.

    Regards
    T_T
     

    Attached Files:

  2. How about creating a monthly line graph so you can see your monthly progress?

    I tried to do that a while ago but soon gave up because...well because I'd rather watch telly than arrse about in Excel.

    :oops:
     
  3. Btw, your link doesn't work.
     
  4. If it comes up a blank, try hitting refresh, it should work then.

    Anyone else having problems with it?
     
  5. yeah...all I get is this...........
     

    Attached Files:

  6. i don't need a spreadsheet.

    0 miles - 0 mins - 0 secs - 0 - 0 - 0kph - 0mph - ave 0 - total time 0 - total distance 0

    but then, i am in a wheelchair :)
     
  7. Polar heart rate monitors used to have a HRM that would direct link to a home PC with a similar programme. What ******* use that info. is to anyone I don't know.
     

  8. I nearly pissed myself!! Nice one!
     
  9. Still doesn't work for me mucker. Im on Firefox.
     
  10. I'm on IE6, and it's not working here either
     
  11. Still not working.