Metal Bike Commuter


Using Excel to Track Mileage

Posted in bike commute by metaljaybird on July 10, 2008
Tags: ,

Ok, so I am growing lazy and not posting my weekly totals. I think I realize most are not interested in those stats. On average, my round trip commute is 12 miles per day. So, the math is easy from there. But since I have occasions where I only half commute or skip a day all together, I feel it is necessary to log my mileage by day with some notes, etc.

For a few months, I had a basic Excel spreadsheet and did the math using my calculator to get my weekly and monthly totals. This became annoying. I knew about formulas in Excel, but since I am a systems specialist I don’t really focus on all the details available in Excel. I found through a simple google search an easy way to set yourself up logging your miles. Mine works like a charm, and now I don’t even have to do the math mentally.


http://bikehacks.com/bike-mileage-fun-with-microsoft-excel/

Anyway, I tried an alternate route earlier this week on the way home. Man, was that tough. There’s this road called Union Hill that runs through Parsippany just past Greystone Park. Man, that hill almost gave me a heart attack. I first started tackling the road with determination figuring it would eventually flatten out. After what seemed like hours (probably minutes) I finally gave up. With my legs screaming and my breath wheezing I did what I always hate doing. I walked the bike up. And up. And up.

The ride back down was exhilarating though. Unfortunately, I was still trying to catch my breath so I coasted it down. I came to a road called Hill Road that supposedly crosses Route 10. It doesn’t. The map I was using must have been old. I wasn’t about to cross a bunch of lanes of high speed traffic, hop a jersey barrier just to save time. Back on Mt. Pleasant Road, I figured I would try my luck and see where it goes. Well, a few miles later, it too came to a part of Route 10 caged in by jersey barriers. Back up (hill) Mt. Pleasant. I finally found a road called Opekaki (I think) took this across 10 onto Franklin (no barriers!) and headed towards home.

When I get home, my wife comes bearing news that our car has been hit. Another reason why I hate cars. She is fine, but the doors will need to be replaced. I guess the person that hit her thought it would be easier to try driving through her car rather than waiting 5 seconds for my wife (who had the right of way) to drive past. Darn, and I just dropped over 800 dollars to fix the clutch finally getting it back on the road.

Oh well, I just hope the other insurance company does not give us any hassles. There is no question that my wife was not at fault at all.

Advertisements

5 Responses to 'Using Excel to Track Mileage'

Subscribe to comments with RSS or TrackBack to 'Using Excel to Track Mileage'.

  1. digitaldame said,

    Ok, now I see what you were talking about in the comment at my blog. Yes, when I get around to doing the bike commute, it’ll be 12 miles each way, thus 24 miles a day. Right now I’m just doing the recreational riding on the weekend. I hadn’t thought of keeping track of how far I ride, I wish I had. I have no idea how many miles I have on my bike now!

  2. metaljaybird said,

    Well, you can estimate what you previously rode, and track what you do now. I find logging my mileage helps me to stay focused. If I see low mileage on some days, I’ll take a longer route one day to try and round it all out.


  3. […] “There’s this road called Union Hill that runs through Parsippany just past Greystone Park. Man, that hill almost gave me a heart attack. I first started tackling the road with determination figuring it would eventually flatten out. After what seemed like hours (probably minutes) I finally gave up“ […]


  4. Hey, I found your blog in a new directory of blogs. I dont know how your blog came up, must have been a typo, anyway cool blog, I bookmarked you. 🙂

    I’m Out! 🙂


  5. gfrevenge account

    Using Excel to Track Mileage | Metal Bike Commuter


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: