Showing posts with label Outdoors. Show all posts
Showing posts with label Outdoors. Show all posts

Monday, February 18, 2008

Bicycling and spreadsheets meet in Seattle

I've posted a few examples of bicycle riders who have somehow utilized spreadsheets to track and share their rides. Here's another one I cam across that made me want to do the same myself. It's got a nice chart at the top which shows the pattern of ride length over time. This rider's log has become a permanent link on the right pane of his blog, entitled "my cycling log", which has two tabs, one for last year and one for this yar.

Site:Cycling in Seattle
Page/Post:Seattle to North Bend & Back (100 miles)
Spreadsheet:My Cycling Log: Rides 2008
(be sure to click on the "rides2007 tab too!)

Saturday, January 26, 2008

Freediving Competition Results

Freediving is certainly not a mainstream sport - but, like other sports, it brings competition, which of course, leads to online spreadsheets of competitive results (what else could Freediving have in common with, say, Ice Hockey, except for the involvement of H2O ;). The Shark-Freediving blog is where I found this one, and it's a worth example of a competitive sports results spreadsheet. That Blog also had some incredible video and great information about the sport.

Site:Shark FreeDiving Blog
Page/Post:First Day's Results - Preparing for the next day
Spreadsheet:FreeDiving Results

Friday, January 4, 2008

Logging your Biking and Commuting Miles

Noah from the Commute by Bike blog (and his own KC Bike Commuting blog) has posted a very useful Bike Log spreadsheet which he plans to use to track all his biking miles in 2008. It's clear that this spreadsheet is useful, as he had a whole year of experience using his 2007 spreadsheet to learn what needed to change - so the 2008 version is sure to be a hit. As he says in his comment reply to other readers (who are also suggesting he check out bikejournal.com and other specific sites), "Google Spreadsheets lets you update from anywhere as well as collaborating with others, including revision control. It would be trivial to keep an online team spreadsheet for all of the bike commuters you know in town, or anything of the sort".

Site:Commute By Bike blog and KC Bike Commuting blog
Page/Post:Keep Track of your Riding
Spreadsheet #1:2007 Bike Log Spreadsheet (this one is fully loaded with 2007 data)
Spreadsheet #2:2008 Bike Log Spreadsheet (this one is improved, but almost empty, as he has just begun to use it in 2008)
Get Your Own Blank Copy by Clicking Here (note, each click on this link will give you another copy in your google docs list)

Note: That "get your own copy" link above is a google spreadsheet version of the excel file posted by Noah on the Commute by Bike blog - which I've imported to give people more direct access. I only made one change to that file: I added a link back to the author's blog within the summary sheet. You can see a preview of it here: http://spreadsheets.google.com/ccc?key=pO3Ze62OAU2HnHswCF-NCDw&hl=en

Friday, November 30, 2007

Bike Race Results

In their own words: "Bike Monkey is a growing advocacy group in Sonoma County that aims to utilize cycling as a means of benefiting the community in a variety of ways."... They used a spreadsheet to show the results of a bike race, which looks lke a good template for other bikers out there.

Site:Bike Monkey
Page/Post:Blog posts in November
Spreadsheet:Lake Sonoma Bike Race Results

Wednesday, November 14, 2007

Hiking & Camping Gear List

A Pacific Northwest Trail enthusiast posted this very well formatted hiking gear list as a spreadsheet. It's categorized (e.g. clothing, cooking, first aid, sleeping, etc) and it summarizes the weight of the items - which is critical for hikers.

Site: Pacific Northwest Trail Forums
Page/Post: PNT o7 Trail Report
Spreadsheet: Pacific Northwest Trail Gear List