My training log - 'tis now huge with a wealth of useless and irrelevant infomation - it's GREAT

A subset of said training log - the ride to school with my son and then my return each day. It's a 25km round trip with a heavy collection of hills. More to the point, I do the same trip every day (well ... most days), and so can compare my trips.

I thought it would be neat to have a graph showing, for each trip, the time, ave speed, ave HR and calories. It'd be neater still to have all these on the same graph so all you can see where changes are - oh, my ave speed was 20 km/hr faster but my HR went through the roof and is it possible to burn that many calories?

Problem, well, it's proving to be a problem for me because I don't really know what I'm doing with Excel. I can create a chart with these four things plotted, but the scale of the y axis assumes that every series being plotted is using the same units. When you consider that I'm trying to track changes in time of a minute or so, changes in speed of one km/hr or so, on a graph with a scale that incorporates the calorie burn of 1,000, you wind up being unable to see the changes in the lower figures.

Is it possible (and if so, HOW), to have a single chart, that has four series running across it, but have each series plotted to it's own units?

And just to scare myself and my son, and work out why the northwards run is so darned tiring, I fed the route into bikely. Here's the profile for the run from Home to School. It's public streets until the Expressway, then we follow a bikey until the end of the Expressway, then a main road to school. Of course, the lad then gets off his bike and goes in to talk to his ratbag mates whereas I have to turn round and do the rotten thing in reverse.

This profile runs along the Expressway heading north. We've always wondered why we find that northwards run harder than the southerly run - well, this shows why. The hill I call Expressway Hill, is the southerly run up to that crest - it's long. The northerly approach to that crest is shorter but steeper - there are a few downwards runs that don't show clearly at this scale - these allow you to rest and build up momentum but the individual climbs are pretty steep.

So that's half of my morning 25km run ('cause I turn round and come back along it). No wonder I'm a bit spacey when I get home

Red uphill, green downhill

Richard

Last edited by europa on Thu May 17, 2007 4:56 pm, edited 1 time in total.

Just been poking around on the Admin board - Christopher's got email turned off so I'm guessing I'm seeing it because of my higher level of priviledges. Dat's cool. Check your PM's ... in a minute or so after I've sent it of course

europa wrote:My training log - 'tis now huge with a wealth of useless and irrelevant infomation - it's GREAT

A subset of said training log - the ride to school with my son and then my return each day. It's a 25km round trip with a heavy collection of hills. More to the point, I do the same trip every day (well ... most days), and so can compare my trips.

I thought it would be neat to have a graph showing, for each trip, the time, ave speed, ave HR and calories. It'd be neater still to have all these on the same graph so all you can see where changes are - oh, my ave speed was 20 km/hr faster but my HR went through the roof and is it possible to burn that many calories?

Problem, well, it's proving to be a problem for me because I don't really know what I'm doing with Excel. I can create a chart with these four things plotted, but the scale of the y axis assumes that every series being plotted is using the same units. When you consider that I'm trying to track changes in time of a minute or so, changes in speed of one km/hr or so, on a graph with a scale that incorporates the calorie burn of 1,000, you wind up being unable to see the changes in the lower figures.

Is it possible (and if so, HOW), to have a single chart, that has four series running across it, but have each series plotted to it's own units?

Richard

So a thread about your training log and there's no link to it. What time is the chashers war on everything on?

I'm about halfway through making a Access database to record all my log data.
Even adding in a maintenance log that will track maintenance events and when my next maintenance is due based on km ridden or time - whichever comes first.

Then comes the graphs......

Boy, you'de think I'd have had enough of this stuff after 8 hours at work.

You can have Access - it's given me too many ulcers over the years, though once again, I've tried to teach myself. It definitely comes under the heading of 'if you can do it, you're either a professional, nuts or both'

Typical Microsoft, all of the good old stuff has been replaced by good (and sometimes not-so-good) new stuff, which means re-learning all that I've forgotten over the past 10 years or so.

Oh, I'm not a professional, so I guess I'm just nuts.

Don't you hate so called up grades!

I use an Access DB to run my store for second purchases/sales and general sales and I wrote a VB front end to make data entry easy, to connect to my suppliers excel order forms and to allow capturing pictures of suspicious characters. The cops loved it.

Tuco, I use a little code, but mainly the front end stuff provided by Access.

I have to admit that Access 2007 is leaps and bounds ahead when it comes to creating new forms, tabels etc than Access '03 ever was. My main gripe is trying to find where all the database tools are now hidden.

I guess it just a case of having an open mind to a new format.

Oh, the other thing is that '07 uses a totally new file format, that '03 doesn't support. Bummer.

Who is online

About the Australian Cycling Forums

The largest cycling discussion forum in Australia for all things bike; from new riders to seasoned bike nuts, the Australian Cycling Forums are a welcoming community where you can ask questions and talk about the type of bikes and cycling topics you like.