New December - March Exercise Log

[emily_in_nc]

A goal really isn't required, I THINK it should be fine if you don't set one. I will keep an eye on it and see, will change the formula if needed.

This is the same basic spreadsheet we've used for the last 3 years or so but I see what you had in mind. If I can make it work without requiring a lot of scrolling for the user then I'm open to trying a new approach.

No problem -- I am not trying to be difficult, really. ;-) I should take it as a challenge to set up my own personal spreadsheet to accumulate my monthly totals. I have never had to do much with spreadsheets, but it can't be rocket science, right?!

[Crankin]

It's a challenge for me to use the spreadsheet! Just click tab key... don't care what is there, I like seeing the cummulative totals, but do whatever the majority wants.

[Catrin]

Emily - I can't seem to come up with a format that appears far more complicated than this one, especially with a cell for every day for 4 months. Doesn't matter how I split it up, once you get a couple people in it the size of the spreadsheet gets large fast I want you to be able to use this however, so feel free to let me know if there is some other way that I can edit your portion of the spreadsheet to make it easier for you to use as I want it to be helpful..

The secret to this format is just remembering to visit the spreadsheet the day of your activity and add your hours to the existing total for the month. You can either do the math in your head OR set up a formula (something like =5+3+2+4+111) just remember the last character in the formula must be a number, not a plus sign, which enables you to enter every day's activity time for the month in one cell.

[ny biker]

I can't even figure out how to save it.

Would this include outdoor bike rides?

[Catrin]

No saving required, it's automatic. Just enter your goal (if you wish) and time. You can include whatever activity you would like to include, that's entirely up to you!

[emily_in_nc]

Thanks, Catrin! The only way I can think of to make it work is to have a tab leading to a separate sheet with daily tallies for each participant, which would then be rolled up onto on one master page for all participants at the end of the month. This sounds like the kind of stuff my managers would do when I was working would set up (one tab per project and then one master page for all projects, something like that). But it is not a big deal at all, and I am fine with what you have there, really!

NY, I can't imagine why not. This is supposed to be for ALL exercise activities, right? Outdoor, indoor, whatever. In fact, since I'll be in Florida, I expect the majority of my fitness time will be outdoor bike rides. Sure hope so, anyway!