Excel Spread Sheet Training Log
#1
Don't Taunt Happyfunball
Thread Starter
Join Date: Aug 2002
Location: Northern Virginia
Posts: 589
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Excel Spread Sheet Training Log
Does anyone have a training log set up in excel with formulas that they would be willing to email me? Thanks
__________________
There can be only one.
There can be only one.
#2
hehe...He said "member"
Join Date: Aug 2002
Location: Fort Lauderdale, FLA
Posts: 630
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
I have one that I set up to track my training schedule for the MS150.
You, and all, are welcome to DL it and adapt it if it's what you are looking for...
You, and all, are welcome to DL it and adapt it if it's what you are looking for...
__________________
Sometimes you just let the rabbits run, but sometimes you gotta let the dogs run.
Sometimes you just let the rabbits run, but sometimes you gotta let the dogs run.
#3
Don't Taunt Happyfunball
Thread Starter
Join Date: Aug 2002
Location: Northern Virginia
Posts: 589
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Thanks Chip. I need a backup system if Bike Pro Log never comes back up.
__________________
There can be only one.
There can be only one.
#4
Bike for life.
Join Date: Apr 2003
Location: The Silver Comet Trail
Posts: 370
Bikes: KHS Alite 1000 mtb, Bianchi Celeste Campione, all Campy
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
I use a MSExcell format. I copy and paste it to a MS Word document, then save it as HTML, and then view as html source code, and then copy and paste it to my web page as an html document. Its really easy. You can see it at my web page, listed in the sig file. I am going to take a look at the one I just downloaded from this post. - Best
#6
Don't Taunt Happyfunball
Thread Starter
Join Date: Aug 2002
Location: Northern Virginia
Posts: 589
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Originally posted by nvrqut100
cyclochica, are you racing in the northern Va area?
cyclochica, are you racing in the northern Va area?
__________________
There can be only one.
There can be only one.
#7
Senior Member
Join Date: Oct 2002
Location: Somerset, KY -- near Lake Cumberland
Posts: 757
Bikes: 1980 Univega; 1985 Ross; 1994 Trek 1400 -- all road bikes
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Using Excel for a bike log is a great idea. Wonder why I didn't think of it. I used Bike Prolog, but since they've been off the net, I've been using a pad and pencil. Excel makes much more sense. I use Excel for my family's budget, and it has worked great. Now, for the first time in my life, I know where all my money goes (wine, women, bikes). I like the way Excel keeps a running total of everything. Bike Prolog was great, but if they're not consistently up and running, it's of no use to me.
__________________
"I am a true laborer. I earn that I eat, get that I wear, owe no man hate, envy no man's happiness, glad of other men's good, content with my harm." As You Like It, Act 3, Scene 2. Shakespeare.
"Deep down, I'm pretty superficial." Ava Gardner.
"I am a true laborer. I earn that I eat, get that I wear, owe no man hate, envy no man's happiness, glad of other men's good, content with my harm." As You Like It, Act 3, Scene 2. Shakespeare.
"Deep down, I'm pretty superficial." Ava Gardner.
#8
www.activebody.org
Join Date: Apr 2002
Location: Madison, WI
Posts: 221
Bikes: Airborne Zepp 2003, Co-Motion Tandem, Trek 8000 mtn bike (commuter), Klein Attitude Comp
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Check out www.activebody.org... very easy to use and does most of what bikeprolog does/did
and it's free...
and it will not go away (cause I use it for my own training).
Cheers,
Clint
and it's free...
and it will not go away (cause I use it for my own training).
Cheers,
Clint
#9
Newbie
Join Date: Jun 2003
Posts: 4
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
try www.crosstrack.com they have a free version that seems to capture most everything...
#10
www.activebody.org
Join Date: Apr 2002
Location: Madison, WI
Posts: 221
Bikes: Airborne Zepp 2003, Co-Motion Tandem, Trek 8000 mtn bike (commuter), Klein Attitude Comp
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
#11
Member
Join Date: Aug 2002
Location: Memphis
Posts: 44
Bikes: Trek 2300
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Cyclochica & Trmcgeehan,
If you are still looking for a simple excel spreadsheet to collect riding and running data see if the attached one works for you.
I've been using it for about a year and it works ok for me as a method to collect data such as distance, time, heart rate and keeps track of cummulative miles, calculates MPH, weekly averages, etc.
(I had to delete some of the charting functions to get the size down below 102kb so the charts don't work)
The cells are not protected so be sure and only enter data in the yellow cells.
If you improve on it just be sure to repost the revised version.
Jim
If you are still looking for a simple excel spreadsheet to collect riding and running data see if the attached one works for you.
I've been using it for about a year and it works ok for me as a method to collect data such as distance, time, heart rate and keeps track of cummulative miles, calculates MPH, weekly averages, etc.
(I had to delete some of the charting functions to get the size down below 102kb so the charts don't work)
The cells are not protected so be sure and only enter data in the yellow cells.
If you improve on it just be sure to repost the revised version.
Jim
__________________
"A desk is a dangerous place from which to view the world." - John le Carre
"What we hope ever to do with ease we must learn first to do with diligence." - Samuel Johnson
"A desk is a dangerous place from which to view the world." - John le Carre
"What we hope ever to do with ease we must learn first to do with diligence." - Samuel Johnson
#12
On Your Right
Join Date: Mar 2003
Location: Warner Robins, GA
Posts: 1,422
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
memphisjim: would you mind emailing me the full version. Thanks!
Zack
Zack
__________________
"You never fail, you simply produce results. Learn from these" - Anonymous
"You never fail, you simply produce results. Learn from these" - Anonymous
#13
Member
Join Date: Aug 2002
Location: Memphis
Posts: 44
Bikes: Trek 2300
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Zack,
I've received a few PM's with some questions and suggestions.
What type of additional info do you want to keep track of? Time, Distance, Average, Weekly Average, Cummulative, etc. and for activities other than riding? such as running and swimming, etc. Also what types of charts, graphs and summaries?
Let me know and I'll try and include your suggestions.
Jim
I've received a few PM's with some questions and suggestions.
What type of additional info do you want to keep track of? Time, Distance, Average, Weekly Average, Cummulative, etc. and for activities other than riding? such as running and swimming, etc. Also what types of charts, graphs and summaries?
Let me know and I'll try and include your suggestions.
Jim
__________________
"A desk is a dangerous place from which to view the world." - John le Carre
"What we hope ever to do with ease we must learn first to do with diligence." - Samuel Johnson
"A desk is a dangerous place from which to view the world." - John le Carre
"What we hope ever to do with ease we must learn first to do with diligence." - Samuel Johnson
#14
On Your Right
Join Date: Mar 2003
Location: Warner Robins, GA
Posts: 1,422
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Jim,
I'm interested in cycling only. Add all the features you want - I'll just skip the ones I don't need
Zack
I'm interested in cycling only. Add all the features you want - I'll just skip the ones I don't need
Zack
__________________
"You never fail, you simply produce results. Learn from these" - Anonymous
"You never fail, you simply produce results. Learn from these" - Anonymous
#15
Don't Taunt Happyfunball
Thread Starter
Join Date: Aug 2002
Location: Northern Virginia
Posts: 589
Bikes: 2005 Kona Jake the Snake, Fuji Club SE
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Thanks for all the suggestions.
Memphisjim, the chart looks great. Thanks so much.
Memphisjim, the chart looks great. Thanks so much.
__________________
There can be only one.
There can be only one.
#16
Senior Member
Join Date: May 2003
Location: Delaware
Posts: 369
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 4 Times
in
1 Post
I have a nice spreadsheet developed on Excel 2000 but don't have the zip utility to post through the forum. It includes a data entry sheet, multiple chart sheets, and sheets that are used in data manipulation to create the charts available. Updating data is done via a macro which is invoked by holding the 'ctrl' key down and pressing 'w'. It updates all charts, saves the file and returns user to last data entered. Only data entry required is miles and minutes. One down side, it is year 2003 specific, however, using it from one year to another would only result in some shifting of data from week to week or month to month on the charts. Bar graphs include: Cumulative Miles, Weekly Miles, Monthly Miles, Average distance/ride/month, and Average MPH per month.
#18
Senior Member
Join Date: Oct 2002
Location: Newnan, GA
Posts: 402
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
A good log from cyclingforum.com
Cycling ChartLogTTF Workbook
Longtime forum member and contributor JayPee has created a Microsoft Excel spreadsheet analysis tool for reviewing cycling data.
JayPee's ChartLogTTF Workbook has received a fairly thorough review and workout over the last 6 weeks so it should work without major flaws. He will provide support for it - not only as constructed, but for any updates as may be needed. In addition, he will assist FORUM MEMBERS in making reasonable custom modifications if needed.
https://www.cyclingforum.com/features/cdata.htm
Cycling ChartLogTTF Workbook
Longtime forum member and contributor JayPee has created a Microsoft Excel spreadsheet analysis tool for reviewing cycling data.
JayPee's ChartLogTTF Workbook has received a fairly thorough review and workout over the last 6 weeks so it should work without major flaws. He will provide support for it - not only as constructed, but for any updates as may be needed. In addition, he will assist FORUM MEMBERS in making reasonable custom modifications if needed.
https://www.cyclingforum.com/features/cdata.htm
Last edited by Bobatin; 06-20-03 at 03:37 AM.
#19
Bike for life.
Join Date: Apr 2003
Location: The Silver Comet Trail
Posts: 370
Bikes: KHS Alite 1000 mtb, Bianchi Celeste Campione, all Campy
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
memphisjim,
That is a phenominal chart that you offered. I enjoyed the MS 150, I tweaked it some, but this one that you came up with is really fabulous. Thanks!
That is a phenominal chart that you offered. I enjoyed the MS 150, I tweaked it some, but this one that you came up with is really fabulous. Thanks!
#20
Carpe Diem
Join Date: Sep 2006
Location: MABRA
Posts: 13,149
Bikes: 2007 CAAD9; 2014 CAADX; PedalForce CG1
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 1 Time
in
1 Post
This is a GREAT spreadsheet!!!
__________________
"When you are chewing the bars at the business end of a 90 mile road race you really dont care what gear you have hanging from your bike so long as it works."
ΛΧΑ ΔΞ179 - 15% off your first Hammer Nutrition order!
"When you are chewing the bars at the business end of a 90 mile road race you really dont care what gear you have hanging from your bike so long as it works."
ΛΧΑ ΔΞ179 - 15% off your first Hammer Nutrition order!
#21
BloomBikeShop.com
If you're still looking for more, I have at least one version on my site.
https://coachlevi.com/articles/traininglog.htm
https://coachlevi.com/articles/traininglogsystem.htm
https://coachlevi.com/articles/traininglog.htm
https://coachlevi.com/articles/traininglogsystem.htm