21.63 Miles!!
Written by Michael on June 4th, 2005I saw the doc and she gave me the go ahead to pummel my body as I pleased. In fact, she said it would me good to give myself a really good hour long or so workout to see how my lungs handled it. It took me quite a bit longer than an hour to cover that distance. Like an hour and 27 minutes. Not cool. Oh well, starting from scratch three days into June can’t be so bad can it? Yes, yes Michael, it can.
5
AM
Hey Michael, check out Kiersten’s website. Brian and I finally found a new house and there are some pictures of the new house on Kiersten’s website!
5
PM
Congrats Kell! I thought you guys were building but this house looks sweet enough not to build new.
11
PM
So…. this is rather non-sequitor to your post, but it’s the only way I can contact you. I found your mph.js script quite useful in calculating my average speed – something my CatEye cycling computer can do, but I wanted to do in Excel. You mentioned that you weren’t able to do it in Excel..so, being a cyclist and a computer dork, the following spreadsheet will track what your looking for (email if you want the file):
A2 – Day of the week (Monday – Friday)
B2 – Date (6/10/2005, etc.)
C2 – Minutes you rode.
D2 – Miles you rode
E2 – 1 or 0 (1 if you rode that day, 0 if you didn’t… this prevents a divide by zero error on days you don’t ride)
F2 – Enter the following formula:
=IF(E2=1,(60*D2)/C2,0)
G2 – NOTES section for documenting which route you took, if you got hit by a car, etc.
Now you too can bring spreadsheet you normally only deal with at work into your once peaceful home.
11
PM
Wow, thanks Bill, this works beautifully!!