Reply With QuoteWhat an amazing tool! I'll definitely be using it when I start pretty soon! Thank you!
My HCG Diet Tracker Spreadsheet 
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
Last edited by Racquel; May 3rd, 2011 at 06:22 AM.
What an amazing tool! I'll definitely be using it when I start pretty soon! Thank you!
Pooh, I only have Works not real Excel, it won't work.
you can open it with open office, its a free program try it here. http://www.openoffice.org/
This Diet Tracker is great! Thanks for sharing.
Racquel,
Awesome Spreadsheet!
Quick input, A couple of the R1Food items for Week2 do not have the correct VLOOKUP values, they start at A4 instead of A2.
It could not find my Apple this morning.
Fixed mine so it is no biggie, just thought you might want to know before you get other questions about why it can't find items.
Again, this is impressive. I work on spreadsheets and know how much of a pain it is to get all the formulas correct.
Gary
Round 3 LIW 177.4 - Total pounds lost this round 27.4
WOW! Thanks -- this is great. You obviously rule the world of Excel.
janet
Thanks Gary!
shoot i hate when that stuff happens.
Fixing today will upload with revised one shortly.
darnit
Girl,Originally Posted by Racquel
I LOVE IT.
Quite Impressive. Stop beating yourself up.
I hate to say this but I am probably going to take a shot at adding a couple of foods like broccoli and other types of fish that I eat to get a better idea where I am at during P3.
This will be a very big help
Gary
Round 3 LIW 177.4 - Total pounds lost this round 27.4
The spreadsheet isn't opening for me at all.
Posting Permissions
Bookmarks