At the end of my ride on the Dry Creek Bike Trail in Modesto, I have a friendly conversation with a dad and two boys getting ready to ride.
“Do you keep track of your miles?” the dad asks.
He inquires, “What do you use?”
“Paper and a pencil,” I respond.
He looks at me as if he’s never heard of these ancient items.
“What do you use?”
Yes, I know there are many other more technical methods, like Strava, Map My Ride, Garmin, and apps for iphones. Some riders calculate their annual mileage using the basics for free on the bikejournal.com.
Three years later, I still use the same method. Where else can I note, “Way to go girl!!!” “Finished 40 mile Blossom Trail Ride!! Woo hoo!” “Two minutes faster.” “Stopped at Cold Stone for chocolate lava meltdown.” “Fed ducks today.” “Took photos at pumpkin patch.” Yes, the paper and pencil method works fine for me.
Periodically I tear off pages from my 5” x 7” spiral bound notepad and enter the data into my Excel spread sheet titled Bike Ride Log. I’m actually not the only one to use this method. I discovered a number of riders on roadbikereview.com who also use Excel.
I enter the date, day of week, location or route, mileage, average MPH, maximum speed, ride time, and notes. The notes column helps me remember milestones and special times on my rides. Or not so special times, “April 5, 2016 Bike Accident. Truck backed up on me.”
With the New Year, I finish entering my data from October through December. Not a huge number of entries to make. For the first time, I add the total annual mileage I rode in 2016. I was so surprised that my total was 608 miles.
Curious, I did likewise for 2013, 2014, and 2015. With the increase in miles, I wondered how many times I rode my bike each year. So I added them as well. I made a table so I could see my progress.
|# of Rides||42||46||62||82|
I’m pretty proud of my miles and that I’m riding my bike more often. I appreciate each of you who encourage me in my riding endeavors, ride with me on SCBC (Stanislaus County Bike Club) rides, and those I meet along the way.
Today’s paper and pencil entry: Jan. 14, 2017, Sat.; MJC bike routes; 11.5 mi; 9.6 ave.; 14.6 max. 41-43 degrees. Feet cold. Chocolate lava meltdown @ Cold Stone.