Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Training & Nutrition Learn how to develop a training schedule that's good for you. What should you eat and drink on your ride? Learn everything you need to know about training and nutrition here.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 05-22-07, 01:47 PM   #1
zabouth
Junior Member
Thread Starter
 
Join Date: May 2007
Location: Widnes UK
Bikes: Scott Yecora 2005
Posts: 11
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Excel Riding log

I decide to make a excel spreadsheets so I can keep track of how far I ride and my average speed in mph to see if it gose up over time. The spreadsheet has 12 tabs one for each month.
I am posting it here to see if anyone will find it useful. If you do I will take advice and add what I can to it.

I am thinking of adding a calorie calculator but not sure what to base it on distance or time l tryed both and got a big descepancy between the 2 reults they gave

There is few minor bugs in it at the moment

1. You have to enter your time in min not hours because excel dose not work tell with times.

2. If you cycle for more than 24 hours in a month the total time in hours counter will reset because it tihnks its a 24 hour clock if anyone knows how to get round this please post it here.

3. Every month has 31 days because I copyed and pasted and can not be bothered correcting it.

all feedback welcome good or bad.

the file is in excel 97-2003 format as not that many people are useing 2007 yet and you can't buy it

http://rimmer.incognitus.net/~zabouth/bike.xls

Last edited by zabouth; 05-22-07 at 01:52 PM.
zabouth is offline   Reply With Quote
Old 05-22-07, 06:19 PM   #2
znomit
Zoom zoom zoom zoom bonk
 
znomit's Avatar
 
Join Date: Sep 2006
Location: New Zealand
Bikes: Giant Defy Composite,Trek 1.7c, Specy Hardrock, Nishiki SL1, Jamis Commuter
Posts: 3,318
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 5 Post(s)
To convert h.min to min use this.
cell C213 has ride time in hrs and min eg 1.23 is 1 hour 23 minutes
will output 83 (for 83 minutes)

=60*INT(C213)+100*(C213-(INT(C213)))

I did not open the xls file as it has macros I cannot disable.
znomit is offline   Reply With Quote
Old 05-22-07, 07:16 PM   #3
wolfpack 
Rawwrrrrrrrrr!
 
wolfpack's Avatar
 
Join Date: Jan 2006
Location: Clayton, NC
Bikes: 2009 Specialized Ruby Sworks SL w/SRAM Red; 2006 Fuji Team RC; 2008 Felt F1x; 1980's Lotus Excelle; Mangusta FG/SS; Rossin (yet to be built up)
Posts: 2,728
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
cyclistats FTW.

http://www.cyclistats.com/index.htm
__________________
wolfpackcycles
skiffrun: Enjoy the ride. Ride for the enjoyment.
wolfpack is offline   Reply With Quote
Old 05-22-07, 07:36 PM   #4
Machka 
Long Distance Cyclist
 
Machka's Avatar
 
Join Date: Jan 2003
Location: I ride where the thylacine roamed!
Bikes: Lots
Posts: 46,020
Mentioned: 16 Post(s)
Tagged: 0 Thread(s)
Quoted: 234 Post(s)
I also have an Excel spreadsheet which I've been using since the mid-1990s. It is set up a bit differently than yours ... with lots of formulas, but no macros.

I also use bikejournal.
Machka is offline   Reply With Quote
Old 05-22-07, 08:00 PM   #5
zabouth
Junior Member
Thread Starter
 
Join Date: May 2007
Location: Widnes UK
Bikes: Scott Yecora 2005
Posts: 11
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
hmm that's strange there should not be any macros but the file was made in office 2007 so god knows and as i work as a systems administrator i know how bad macros can be

ps thakns znomit fot the formula will take a loot at that tommrow

Last edited by zabouth; 05-22-07 at 08:34 PM.
zabouth is offline   Reply With Quote
Old 05-29-07, 09:30 AM   #6
mlh122
Senior Member
 
mlh122's Avatar
 
Join Date: Mar 2005
Location: NW
Bikes: Trek 4500
Posts: 881
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
That is wierd. Mine mentioned macros and I told it to go ahead (I live life on the edge ) and went in and it doesn't show any macros, maybe I just got a virus but yeah the sheet looks nice, i might make graphs and stuff for it, maybe some conditional formatting so it highlights stuff based on performance.
mlh122 is offline   Reply With Quote
Old 05-29-07, 04:24 PM   #7
umd
Banned
 
umd's Avatar
 
Join Date: Sep 2005
Location: Santa Barbara, CA
Bikes: Specialized Tarmac SL2, Specialized Tarmac SL, Giant TCR Composite, Specialized StumpJumper Expert HT
Posts: 28,387
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Quote:
Originally Posted by zabouth
I decide to make a excel spreadsheets so I can keep track of how far I ride and my average speed in mph to see if it gose up over time.
Average speed is pretty meaningless for comparing your performance unless you always do the same rides. My average for the third week of may was almost 1mph slower than the previous week, but I did almost twice as much climbing...

Quote:
Originally Posted by zabouth
the file is in excel 97-2003 format as not that many people are useing 2007 yet and you can't buy it
While I won't argue with you about how many people are using it, I don't know why you think you can't buy it...
umd is offline   Reply With Quote
Old 05-29-07, 07:59 PM   #8
SSIndyRider
Senior Member
 
Join Date: Sep 2006
Location: Indiana
Bikes:
Posts: 204
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
For fun and motivation, my spreadsheet has all the data in one sheet then uses formulas to calculate the mileage for each month by looking at the date and adding them for each month, which is displayed on a second sheet. It also totals all and calculates the % of the total annual goal mileage I've set. A 3rd sheet displays the monthly data in a bar graph format for quick reference and the motivation to watch the graph grow.

The total time doesn't have any problems with 24 hour settings if you convert the time to a decimal number. I round to nearest 5 second increment: 1:22:15 = 82.25 min. I can give you the formulas for each of these, including converting the time back to hours/minutes if you like. No need to post all that for just the sake of it unless someone wants it - just PM me and I can send details in a response or on the board for others to use too.
SSIndyRider is offline   Reply With Quote
Old 05-30-07, 09:40 PM   #9
Murrays
Mad Town Biker
 
Murrays's Avatar
 
Join Date: Jun 2004
Bikes:
Posts: 974
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
The key to time in excel is understanding that 1 = 24 hours (1 hour = 1/24, a year equals 365, etc.) Enter your time as h:mm:ss and change the cell formating to display it as hours, minutes and seconds.

I'd be happy to send you a copy of my ride log spreadsheet which dates back to 1989 and has over 61k miles logged Some features:

>A macro for entering rides that has a drop down box for previous routes with mileage, bike ridden and date.

>One tab for this years rides with totals by month and week.

>One tab for previous years with personal bests for mileage by month.

>Last tab is a chart tracking miles of all years since '89 (I'm currently at a personal best for mileage to date...unemployment has it's advantages )

-murray
Murrays is offline   Reply With Quote
Old 05-31-07, 09:46 AM   #10
bentnail
Been around
 
bentnail's Avatar
 
Join Date: Jan 2007
Bikes: Recumbent
Posts: 71
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I've been futzing around with excel and not doing very good.

Murray yours sounds like just the the ticket

Would you mind sending me a copy of it?
bentnail is offline   Reply With Quote
Old 05-31-07, 10:16 AM   #11
Turboem1
Banned.
 
Turboem1's Avatar
 
Join Date: Aug 2006
Location: Long Island
Bikes: Lemond Reno
Posts: 883
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I use the one TomStormcrowe made and adjusted it a little for me.

http://the-amazing-shrinking-man.goo...9fYLhbjYKpNOgg
Turboem1 is offline   Reply With Quote
Old 06-02-07, 10:28 PM   #12
paul6911
Member
 
Join Date: Dec 2006
Bikes:
Posts: 30
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I like Google Docs with charts.

I just put this one together. I will improve on it.

http://spreadsheets0.google.com/ccc?...ng0rYhiAOdyiJA
paul6911 is offline   Reply With Quote
Old 06-04-07, 07:19 AM   #13
group105
Master of the Obvious
 
Join Date: May 2007
Location: Muncie, Indiana
Bikes: Fuji
Posts: 456
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
I use mapmyrun.com
group105 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 10:05 AM.