Ok, so I think I remember how to do it. Let me know if you have any problems accessing.
I am not sure how proficient you are with Excel - this doesn't require that much proficiency - just a little working knowledge. Here is an explanation...
Tab 1 - Food List
- The Food List is the first tab. I'm sure our food selections are different (I'm not very adventurous in my eating habits am rather picky so not a lot of variety in my diet - for non-packaged items, I use the categories as either Protein, Vegetable or Fat - this doesn't matter for the formulas, just how it sorts so do whatever makes the most sense to you) so add any foods to the list that are not already there so you can reference them in your journal. I started with as comprehensive of a list as I could find with IP and alternatives as I use this for 2 purposes - my food journal/macronutrient tracking but also to do comparisons between IP and alternatives when making food choices.
- To add items to the food list, do the following: 1) add entry at the end of the list. Click on the Item # at the top to find the next item number to use (for example, there are 331 items in the list so if you add the next, you should note it as 332). The reason this is not in chronological order is because when you sort it, it is set to sort by Category and then Product so I get all bars together in the list for example. Or, you could just sort by item # and use the filter when you want to look up the item # for a bar - your choice - I have just described the way I have it set right now. 2) If you choose to sort the way I do, after you add entries, select row 1 to all the rows & columns that have data and then Click on the Home menu and choose Sort & Filter sub-menu option and select Custom Sort - it is already set the way I describe and then click ok to get it to re-sort by Category and then Product.
Journal Entries
- Once your food items are added, you are ready to use the journal. This keeps track of a 2 week time period. Each day is a separate tab. The green section in each day is all you need to fill out - the item # that references your food that you had/will have and then scroll over to the other green section and enter how many servings of that item you had - the food item and nutritional information will all update accordingly once you enter those 2 things.
Further note, by default, this has my entries in it. If you want to remove them, then just delete what is in Green for each day. Once you fill the info out, all the formulas will reference accordingly. Be careful to only delete from the Green sections in the daily journal tabs; otherwise, you will be deleting formulas.
Weekly Summary
3 - There is a weekly summary at the end that gives you a summary of the 2 weeks by day and by week. This is automatically done for you depending upon what is entered in the 14 tabs representing the daily food journal (except the dates for week 1 - you need to enter/change those for each time period). I print this weekly summary out and take with me to my appointments in addition to daily entries.
This section is all formulas so be careful not to delete cells as you'll be deleting the formula. If a value isn't right, it is because the corresponding daily journal entry is incorrect so change it at the source.
Alternative Guidelines (and other Notes)
4 - Just a notes reminder for me about alternatives, etc so I have easy access to this info when using the journal (vs coming back to forum to look it up).
One other note on the food list - I have a column called Verified. Because I started with someone's existing list, I added this column to note whether I personally verified the nutritional info (as indicated by a 'y' in this column). If I didn't, then the info could be inaccurate or incomplete so if you use any of those items, you will want to verify/complete this info. Some of the IP products I don't use but I have the item listed to remind myself to get the nutritional info for the product.
Don't alter tab names in the workbook as the formula references will get goofed up.
What do I do when 2 weeks are up?
As I noted, the journal was designed for two weeks. You can do a "save as" on the Excel File by dating it for the span of 2 weeks that it covers so that it will make a copy and you will have multiple Excel files for each date range.
Hopefully that isn't too hard to follow. Let me know if something wasn't clear or if you have additional questions.
https://drive.google.com/file/d/0B7J...ew?usp=sharing