Welcome guest, is this your first visit? Click the "Create Account" button now to join.

To disable ads, please log-in.

Shop at TeamEstrogen.com for women's cycling apparel.

Results 1 to 15 of 37

Hybrid View

  1. #1
    Join Date
    Nov 2009
    Posts
    10,889
    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.
    Last edited by Catrin; 12-01-2013 at 05:28 PM.

  2. #2
    Join Date
    Jul 2011
    Posts
    247
    I'm in with a goal of 60 hours. Owlie, that is my stretch goal.

  3. #3
    Join Date
    Apr 2009
    Location
    Tucson, AZ
    Posts
    4,632
    Quote Originally Posted by Catrin View Post
    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...
    At least I don't leave slime trails.
    http://wholecog.wordpress.com/

    2009 Giant Avail 3 |Specialized Jett 143

    2013 Charge Filter Apex| Specialized Jett 143
    1996(?) Giant Iguana 630|Specialized Riva


    Saving for the next one...

  4. #4
    Join Date
    Dec 2005
    Location
    New Jersey
    Posts
    1,940
    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.

  5. #5
    Join Date
    Jul 2011
    Posts
    247
    Catrin,

    Thanks for starting this. I spent an hour on the spin bike today and didn't quit after 32 minutes just so I could post a full hour on the spreadsheet. Hey, whatever works, right?

  6. #6
    Join Date
    Nov 2009
    Posts
    10,889
    Whatever it takes - I did this for me as much as for other members

  7. #7
    Join Date
    Mar 2008
    Posts
    2,698
    My goal is 6 hours a week, which may be a reach now that I've cancelled my gym membership. I'm not exactly off with a bang either.

    Thanks for putting this together, Catrin

  8. #8
    Join Date
    Nov 2009
    Posts
    10,889
    I've edited the spreadsheet to make it more clear that you just need to enter your hours in the monthly column. The cumulative column is a formula field that will do the rest of the math for you. I've also added a couple of columns to the right to allow for a separate goal if desired. I've decided that I want to track my mobility/correctives work separately from my exercise. I didn't add monthly columns for this so there is no formula, but I DID add a formula column to the right that will sum both your regular and "other" totals together.

    Have fun!

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •