However, as a data centric person I like to hoard data in the event it may be useful someday. And maybe it has. I show in this instructable how I record the data in MsExcel and of some of my simple analysis methods.
The Disclaimer. I am not a health professional. I don't even consider myself a health nut. I'm just a guy who likes to analyze data and go outside and play. I do not clam that any of this stuff will help you get thinner, stronger, or smell better. It may get you motivated to play with Excel. It may motivate you to get out more often, Use at your own risk!
Step 1: Collect Data
I just enter the data my HRM provided, Average, max, min heart rate calories burned and exercise time. I used to enter the 'time in zone' category but gave up as I was always above my zone and sometimes I didn't set the zone right. Actually I don't really use the zone feature as during my workouts (mountain biking, skiing, etc.) I can't be looking at my watch to see what zone I'm in.
In Excel I have one page devoted only to data.
The first row are my data headers. This can be locked from the Excel menu "Windows->Freeze Panes" to lock the panes at the grid point you have selected. If the panes are frozen in the wrong spot, just use "Windows->Unfreeze Panes".
I calculate 'Calories/hour" with the excel formula "=E2/(F2+G2/60)" where 'E' is the column for "calories, 'F' is hours and 'G' is minutes. I copy and paste older and similar workouts to save some typing.
My 'perceived effort' is purely subjective but usually correlates with "calories/hr" . I like to categorize my workouts with 'Type' and I also include a short description too.
Step 2: What I Do With the Data
Mostly I find out that I'm getting old and slowing down! (But, I don't need an Excel analysis to tell me that!)
I use another page just for plots.
Copy and paste the data from the Data page.
Use the Chart Wizard to select the X-Y plot with the date as the x-axis and a corresponding data column as the y-axis. Excel automatically knows how to plot the date formats.
In this plot I use show my Average heart rate over the years. The line is a linear regression (or simply a mathematically defined line that bests fits all my data).
Select the chart, use the menu "Chart-> Add Trendline" and select the linear option.
From this I can see that my average heart rate is slowing down over the years.
Step 3: More Plots
It seems pretty steady over the years. There are a few high value data points which I think are due to problems with the HRM strap. It loosens some times, and a way high max rate means I have to tighten it. Sometimes I don't workout so hard, hence the few lower values.
From this data I see that my max heart rate is about 175. It doesn't seem to have lowered as I got older. The standard equation to find your max heart rate is 220 - age. But this data shows a flat max heart rate, although this is only 5 years or so.
Step 4: Calories/hour
Am I slowing down? Getting lazier? More efficient?
Step 5: Using Type of Excercise
But I show here which of my exercises are most intense based on the average calories/hour for each exercise type. Running seems to be the hardest for me and of course walking is the easiest.
Step 6: Conclusion
Perhaps someone with more exercise expertise can suggest another way to look at the data.
As I said, this is just for me. I don't think I have put out any 'bad' advise out there.