Page 12 of 15 FirstFirst ... 21011121314 ... LastLast
Results 111 to 120 of 148

Thread: My HCG Diet Tracker Spreadsheet

  1. February 16th, 2012, 03:52 PM #111
    steveb
    steveb is offline
    Junior Member
    Join Date
    Feb 2012
    Posts
    1
    Your spreadsheet is great I have tweaked the sheet to work in metic as I live in australia and we use kilograms if anyone would like it email me.

    begleyst@yahoo.com
    Reply With Quote Reply With Quote
  3. February 18th, 2012, 09:20 PM #112
    Dragonlady
    Dragonlady is offline
    Member
    Join Date
    Feb 2011
    Location
    St. Louis
    R/P/M
    R5P2 injections, RxHCG
    Posts
    58
    This looks great but I can't get it to download . I am no good on the computer. Any help out there to tell me what I am doing wrong? Thanks
    Reply With Quote Reply With Quote
  4. February 19th, 2012, 07:31 AM #113
    mitchy1121
    mitchy1121 is offline
    Junior Member
    Join Date
    Feb 2012
    R/P/M
    week 2 hcg injections
    Posts
    13
    I use a calorie counter on my phone and love it..
    Reply With Quote Reply With Quote
  5. February 23rd, 2012, 05:54 AM #114
    Emcee
    Emcee is offline
    Senior Member Emcee's Avatar
    Join Date
    Feb 2012
    Location
    Central Florida
    R/P/M
    Started R1P3 3/18
    Posts
    141
    Anyone having luck refreshing the pivot table? Once I do it it clears out her dates, but it won't recognize the dates I put in??? Any advice would be helpful.

    Thanks!
    Em
    Reply With Quote Reply With Quote
  6. February 23rd, 2012, 10:48 AM #115
    Want-to-lose
    Want-to-lose is offline
    Senior Member
    Join Date
    Feb 2012
    R/P/M
    R1/P3/hHCG patches
    Posts
    146
    I'm having the same problem as Emcee with the pivot table.
    Only regret the things that you don't do; do what you want to! -Melanie C


    Reply With Quote Reply With Quote
  7. February 25th, 2012, 01:52 PM #116
    Want-to-lose
    Want-to-lose is offline
    Senior Member
    Join Date
    Feb 2012
    R/P/M
    R1/P3/hHCG patches
    Posts
    146
    I figured it out Emcee. In order to refresh the table with your new numbers (and dates), clear the "date" filter in the pivot table (right click, then select "clear filter"). Once you do that everything will show up (the 4/25 dates and the "blank" date). Then refresh the table, your new numbers (and "blank") should now show up. You can unclick "blank" from the "date" filter options to hide it.

    hth
    Only regret the things that you don't do; do what you want to! -Melanie C


    Reply With Quote Reply With Quote
  8. February 26th, 2012, 12:56 AM #117
    Dmor770
    Dmor770 is offline
    Junior Member
    Join Date
    Jan 2012
    Posts
    4
    Excellent Worksheet!
    I was attempting to change the worksheet to 23 day, however I am unable to unlock. My excel 2010 is asking for a password. Please help. This is R1D1 for me.
    Reply With Quote Reply With Quote
  9. February 28th, 2012, 06:14 AM #118
    Emcee
    Emcee is offline
    Senior Member Emcee's Avatar
    Join Date
    Feb 2012
    Location
    Central Florida
    R/P/M
    Started R1P3 3/18
    Posts
    141
    Quote Originally Posted by Want-to-lose View Post
    I figured it out Emcee. In order to refresh the table with your new numbers (and dates), clear the "date" filter in the pivot table (right click, then select "clear filter"). Once you do that everything will show up (the 4/25 dates and the "blank" date). Then refresh the table, your new numbers (and "blank") should now show up. You can unclick "blank" from the "date" filter options to hide it.

    hth
    Awesome!! But I think I'm still doing something wrong. What cell are you in when you right click because I don't get that option. I'm in MS Excel 2011 for Mac.

    THANKS!!
    Reply With Quote Reply With Quote
  10. February 28th, 2012, 09:32 AM #119
    Want-to-lose
    Want-to-lose is offline
    Senior Member
    Join Date
    Feb 2012
    R/P/M
    R1/P3/hHCG patches
    Posts
    146
    Quote Originally Posted by Emcee View Post
    Awesome!! But I think I'm still doing something wrong. What cell are you in when you right click because I don't get that option. I'm in MS Excel 2011 for Mac.

    THANKS!!
    In the pivot table, in the cell that has "date" as its title

    looks like the symbol circled in the image below. If you click on that (not right click) you will get the filter options. You can also right click on the cell with "date" and get the options. I haven't tried this in the mac version (as the mac excel on my laptop is acting up) but it should work1439-2.jpg
    Only regret the things that you don't do; do what you want to! -Melanie C


    Reply With Quote Reply With Quote
  11. February 28th, 2012, 09:46 AM #120
    Emcee
    Emcee is offline
    Senior Member Emcee's Avatar
    Join Date
    Feb 2012
    Location
    Central Florida
    R/P/M
    Started R1P3 3/18
    Posts
    141
    Quote Originally Posted by Want-to-lose View Post
    In the pivot table, in the cell that has "date" as its title

    looks like the symbol circled in the image below. If you click on that (not right click) you will get the filter options. You can also right click on the cell with "date" and get the options. I haven't tried this in the mac version (as the mac excel on my laptop is acting up) but it should work1439-2.jpg
    That did it!!! I was in the wrong cell - suhweet! Thanks SOO much!
    Em

    Oh - wait, addition to post...so every time I want to update the pivot table I have to hit refresh? I add a new entry and it doesn't see it until I refresh. Is that correct or should it be feeding directly into the table once I add a new line and date?
    Last edited by Emcee; February 28th, 2012 at 10:02 AM. Reason: added addl question
    Reply With Quote Reply With Quote
Page 12 of 15 FirstFirst ... 21011121314 ... LastLast
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules