Popular Pages

Page 8 of 19 FirstFirst ... 67891018 ... LastLast
Results 71 to 80 of 186

Thread: My HCG Diet Tracker Spreadsheet

  1. #71
    Soon to be Teacher BellaXero's Avatar
    Join Date
    Jun 2011
    Location
    Miami
    R/P/M
    R2/P2/SubHHCG
    Posts
    483
    Blog Entries
    3
    Quote Originally Posted by Racquel View Post
    Hello Everyone,

    I wanted to share with you this amazing tool (monstrosity of a spreadsheet) that i created (obsessed) over. I am hoping that it helps you all out on your HCG journey.

    This spreadsheet logs:
    1.) Your daily intake and outgo. It counts your calories and has a place to record your daily dose amounts and even rate your hunger.

    2.) Tracks your weight progress, average losses, total losses and graphs it!

    3.) Measurement tracker for almost everything you would want to measure! (heads out of the gutter!) It shows you total inches lost and also totals specific areas so you can see the overall or total on a specific area.

    I hope you all enjoy it as much as i did while creating it! (yup, total nerd)

    If you have questions or need tweaks please PM me.

    (Spreadsheet in Signature)

    TIPS:
    How to refresh the pivot table on the food log to get your calories to total:
    Excel 2003 instructions
    Excel 2007 / 2010 instructions
    Can i just say... THANK YOU!

    I would really not have been able to do this successfully without this spreadsheet..

    Im a total techie and i was trying to create my own spreadsheet (because keeping written journals was just not going to happen!) and i stumbled across yours and was like woah.. this is PERFECT! this has really motivated me, the graphs and everything and its really helped me track what is effecting my body in what ways, thanks so much for creating this!
    -Xer0
    "We all make choices, but in the end our choices make us" - Andrew Ryan
    "Happiness is when what you think, what you say, and what you do are in harmony." -Mahatma Gandhi



    R1 SW- 164.3 LDW 144.3

    R2 SW - 151.5
    LDW - 136.5 (-15.1)!
    Today - 138.4 (1.9 above >.<)

  2. #72
    Member nico55's Avatar
    Join Date
    Jul 2011
    Location
    League City TX
    R/P/M
    R1/P2/HhCG
    Posts
    40
    Blog Entries
    2
    This is awesome, just one question tho. Is there a way to change serving size? I cant figure it out. This morning I had a small orange and the only thing I can get to come up is large?

  3. #73
    Junior Member
    Join Date
    Jul 2011
    Location
    Seattle Area, WA
    R/P/M
    R1P3D3
    Posts
    18
    Incredible tool and I so appreciate you sharing this! I work for MS so I live in spreadsheets nearly every day. Truely impressive! 1000 thank yous!

  4. #74
    Member
    Join Date
    Jun 2011
    Location
    Little Island in BC
    R/P/M
    R3/P2/Rx HCG SQ
    Posts
    47
    Wow - I love me some spreadsheet goodness, very impressive & thank you!
    I bow to the excel-lent goddess

  5. #75
    Junior Member
    Join Date
    Jul 2011
    Location
    Buckeye, Arizona, United States
    Posts
    15
    Hi, I need a little help here. On the "Daily Calorie Intake" my "Date" is correct, my "Calorie Intake" adds up, BUT my "Calories Left" is not working. It keeps saying "#REF!" What am I doing wrong??? Can someone help me out here (BTW THIS IS THE MOST AMAZING SPREAD SHEET I HAVE EVER SEEN!!! I WILL USE IT DAILY!!! Today was day 4 of my 1st round on hCG) Thanks

  6. #76
    Junior Member
    Join Date
    Jul 2011
    Location
    Copperopolis, California, United States
    R/P/M
    R1, P2, SL
    Posts
    1
    Wow! Thank you for this spreadsheet! It's very helpful

  7. #77
    Member filarks's Avatar
    Join Date
    Jul 2011
    Location
    TEXAS
    R/P/M
    R1/vlcd14/inj
    Posts
    66
    You can download open office and use the calc program and it will open it. When it is time to save you can save in several different formats. That's what I use.
    Keith

  8. #78
    I too am not only new to this diet but new to using a spread sheet in this fashion. I'm pretty good with Excel(self taught) but have not used Pivot tables. The issue I'm having using Excel 2010 is the calories left won't populate and the date column will not sort correctly oldest to newest or vice versa. Should this table expand on its own as you add dates? If so mine is not doing this. Little help?

    All my issues aside this spread sheet took some time, I thank you for sharing it.

  9. #79
    Senior Member Racquel's Avatar
    Join Date
    Mar 2011
    Location
    Orange County, CA
    R/P/M
    R1/P2/RX SL
    Posts
    485
    Blog Entries
    44
    Hi

    Everyone please make sure you are using the most recent worksheet. I made it a little more clear. If you continue having trouble please PM me. I will do by best to help each o you but I don't come on the thread that often.

    Thanks!
    DietTracker Spreadsheet
    Start 174.2
    vlcd1 171.4 (-2.8)
    vlcd2 168.7 (-2.8)
    vlcd3 166.6 (-2.1)
    vlcd6 165.4 (-1.2)
    TOTAL. (-8.9)

  10. #80
    Member Hoya's Avatar
    Join Date
    Sep 2010
    Location
    Parker, Colorado
    R/P/M
    R1/P2/HHCG Drops
    Posts
    53
    You are a rock star, Racquel!!! You and my hubby would get along great (not too great, though ). He also can make Excel sing!!! Thanks so much!!


    Kristen
    R1/P2/HHCG
    VLCD 1: 189.8
    VLCD 2: 188
    VLCD 3: 185.2
    VLCD 4: 184.6
    VLCD 5: 184.2
    VLCD 6: 184.2
    VLCD 7: 182.8
    VLCD 8: 182.4
    VLCD 9: 182.8 (sleep?)
    VLCD 10: 182.8
    VLCD 11: 182.8
    VLCD 12: 183.2
    VLCD 13: 181.2
    VLCD 14: 179.8
    VLCD 15: 180.2 (serious cheat)
    VLCD 16: 181.4
    VLCD 17: 180.2
    VLVD 18: 179.6
    VLCD 19: 179.0
    VLCD 20: 178.0

Page 8 of 19 FirstFirst ... 67891018 ... LastLast

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
  •