2013-2014 Exercise Challenge

[Catrin]

I've completed the spreadsheet for the 2013-2014 TE Member general exercise challenge and posted it here. Anyone who has the link can participate and add/edit their own record. Hopefully it is straightforward, I provided a column for each month so you can track your monthly hours of exercise, along with a cumulative and an "hours left" column at the end. I copied the formulas down for the first 29 records, it is an easy thing to copy the formula down for more records of needed. Just enter you name, desired start date, and the total number of exercise hours you would like to shoot for from 12/1 (or whenever you start) until March 1.

If someone sees how to make the spreadsheet better please feel free to make edits, especially if you would like to add anything it. To be clear, this is for whatever you would like it to be - cycling related only or more general exercise. For me it will be general exercise, I want to get 6-7 hours a week - which is just a little more than my norm. I would like to bump it up just a bit this winter.

We could also use this thread to discuss our efforts if we like

[Owlie]

I added a stretch goal. I don't think I'll manage it, but we'll see.

Started out with about an hour this morning on a bike ride with DBF and his parents.

[Crankin]

I'm wondering how to denote partial hours... like today I did 45 minutes of treadmill hill walking and strength/stretches. I'm assuming .5, .7, etc. Catrin, maybe my poor math skills are showing, but if you want to do 6 hours a week, that's 12X6==72. You really want to do 165 hours??? I put down 100, knowing that some weeks, I'll do more, but it might be closer to 70.

[Catrin]

Crankin - I've no idea how I came up with 165, I knocked it down to 100. I can't blame it on a typo either, I was counting weeks on my calendar and probably put the wrong # in my calculator. It's been a busy day but thanks for pointing this out. Your question was a good one, I hadn't thought about that. I changed the display to show 2 decimal points and added .75 to your December column as a test. The cumulative field is a formula - you CAN calculate that manually if you wish - but it will also add the numbers entered in the 3 monthly columns if you wish.


Owlie, I don't see the stretch goal - did you want that in a separate column? If you do and it isn't working for you let me know and I will take care of it.

[roo4]

I'm in with a goal of 60 hours. Owlie, that is my stretch goal.

[Owlie]

Crankin - I've no idea how I came up with 165, I knocked it down to 100. I can't blame it on a typo either, I was counting weeks on my calendar and probably put the wrong # in my calculator. It's been a busy day but thanks for pointing this out. Your question was a good one, I hadn't thought about that. I changed the display to show 2 decimal points and added .75 to your December column as a test. The cumulative field is a formula - you CAN calculate that manually if you wish - but it will also add the numbers entered in the 3 monthly columns if you wish.


Owlie, I don't see the stretch goal - did you want that in a separate column? If you do and it isn't working for you let me know and I will take care of it.

That was what I originally put in. I edited it to a more realistic number and put the stretch one off to the side. Now to figure out how to do this...

[rocknrollgirl]

I am in! I usually do between 7-8 hours in a normal non-training week, so I went for 100 hours as my goal. This will be fun.