spreadsheets

[Broughtonblue]

as an overweight 44 year old, coming back to cycling after a year, i would like to keep track of rides, time, distance, calories and weight loss, in a spreadsheat/graph type of thing, unfortunately as a computer numpty i have no idea how to go about creating one, my question is this, do any of you use similar and would be willing to share your spreadsheet/graphs, or can anyone point me in the direction of something similar on t'internet?
i do have excel on my computer.
thanks in advance
kev

 

[Strick]

This is something I considered doing too. But sadly decided that even if i did manage to get my head around it, then i would probably forget to input the data!
Good look with it though, it would be great to look back and see your improvements.

 

[Tyres23]

Buy a bryton half the price of a garmin and does all you want and tracks your routes as well so u can time for improvements

 

[rsvdaz]

www.mapmyride.com

you can plot a route with times and it will even work out elevation

 

[Sittingduck]

Hi

Give My Cylcling Log a go. Free to register & use. The link provided takes you to the Cyclechat group on there... come and join us!


Cheers,
SD

 

[jowwy]

Use myfitnesspal you can even log what you eat then too. Its helped me lose just over 4 stone. As well as cycling.

 

[tango_kid]

if any of you have an android phone, download the micaoch app (adidas) it uses the gps in your phone to monitor your progress and comes with alsorts of great little tools!! Also linked to internet so it uploads your data for proper web analysis

 

[bicyclos]

I have been using a spreadsheet type log for a small number of years now which I designed for my needs which has expanded over the years. If you would like a copy pm me and I will send you a blank log. I use excel 2003 on XP operating system. so any programe before that version my sheet will not work. I also have another sheet that a fellow cyclist designed which is as good (better) does the same thing.

Regards

Leon

 

[CopperCyclist]

Another one for ya: www.bikejournal.com

 

[MrHappyCyclist]

This is a screenshot of my spreadsheet. Nothing fancy, but does the job. You can have it if you want.

 

[gaz]

This is a screenshot of my spreadsheet. Nothing fancy, but does the job. You can have it if you want.
[attachment=5028:CyclingSpreadsheet.png]

WHERE ARE THE COLUMN HEADINGS!

 

[MrHappyCyclist]

WHERE ARE THE COLUMN HEADINGS!

In row 1.

 

[calibanzwei]

This is a screenshot of my spreadsheet. Nothing fancy, but does the job. You can have it if you want.
[attachment=5028:CyclingSpreadsheet.png]

OpenOffice. Sweet

 

[gaz]

In row 1.

so what is column b? and is the whole of column e fuel cost?

 

[MrHappyCyclist]

so what is column b? and is the whole of column e fuel cost?

Column B is distances (since the start if the year). Column C is distances on my new bike. Yes, the whole of column E is fuel cost (had I done the distance in my car). Rows 6 and 8 are year sub-totals (for all columns). Row 4 is Total since September 2010.

Also, Fuel rate is MPG, Fuel cost rate is £/litre, and CO2 rate is kg/gallon.

Sorry it's not perfect; I only built it for myself. I've not been well, you know. I'll try to do better in future.