View Single Post
Old 09-05-05 | 08:31 AM
  #13  
rickkko's Avatar
rickkko
TREK 2300 owner
 
Joined: Jul 2005
Posts: 392
Likes: 0
From: Sandy Eggo CA

Bikes: '04 Trek 2300, '77 Panasonic Touring Deluxe

Originally Posted by lamagy
... help in designing up a spreadsheet on excel....
Here's a format I use that might give you some ideas.

I create a workbook file with a page (worksheet) for each month.

I also have a summary page that rolls up some of the information into averages and summations.

I track the data whether I'm out pleasure riding (usually w/o HRM) or doing my workout rides. For me, collecting and logging the data is about as enjoyable as the ride.

I also liberally use the "Insert Comment" feature of Excel to annotate any information that might apply to a particular value in a specific cell.

Monthy worksheet view:



Summary page/worksheet:



Good luck!
..rickko..
rickkko is offline  
Reply