Diet Planner

jchappj · 07-28-2007, 08:04 AM

If you are familiar with MS Excell please check out the spreadsheet I made and let me know your thoughts. You can download it HERE. It doesn't contain any viruses or the like but please use you antivirus software to scan it before opening. I would rather not have anyone accusing me of crashing their computer! Once you figure out how to use it you can set up your diet for the entire week and it will automatically tell you your total nutrients and percentages of each.
To use:
Copy the entire item's line from the 'Foods' page, then insert into the appropriate column on the day/meal you are planning. As you add items the spreadsheet updates the numbers for you. The food bank is pretty bare right now. You can add your own foods to the list, just keep in the same formatt. I've added a few things just so you can see how it works.
If you aren't that familiar with excell I suggest keeping a copy of the original 'just in case' and using another to play around with. Not sure this will help you guys but I tend to eat pretty much the same things so getting the food bank up to speed shouldn't be that big of a deal. It's an easy way to see if you are on track with your nutritional goals.
What do you think?
jchappj

ruprecht · 03-13-2008, 04:58 PM

This is a great Spreadsheet. But it would be perfect if 1 of you excel gurus can make it so that there is a drop down menu under each meal so that the each preset foods or meals in the food database can be instantly selected and all values of that food/meal could be transferred.

For example say its Tuesday and I want to input my 1st meal which was 2 whole eggs, 1 cup oatmeal, and 3/4 cup milk. The values for each of these food have already been recorded in the food database section as well as the values of the combo of these foods as it is a standard breakfast for me.

So to input these values it would be extremely easy if I can just type the number that demarcates the food or meal. So assume that the corresponding number for the entire meal above is A59, then in the daily menu typing A59 would transfer the description for this meal as well as its corresponding Macros. Alternatively a drop down menu where any food or meal from the database can be selected.

Hopefully someone with some Excel experience can do this??

captaincaberman · 03-13-2008, 08:56 PM

Quote:

Originally Posted by ruprecht

This is a great Spreadsheet. But it would be perfect if 1 of you excel gurus can make it so that there is a drop down menu under each meal so that the each preset foods or meals in the food database can be instantly selected and all values of that food/meal could be transferred.

For example say its Tuesday and I want to input my 1st meal which was 2 whole eggs, 1 cup oatmeal, and 3/4 cup milk. The values for each of these food have already been recorded in the food database section as well as the values of the combo of these foods as it is a standard breakfast for me.

So to input these values it would be extremely easy if I can just type the number that demarcates the food or meal. So assume that the corresponding number for the entire meal above is A59, then in the daily menu typing A59 would transfer the description for this meal as well as its corresponding Macros. Alternatively a drop down menu where any food or meal from the database can be selected.

Hopefully someone with some Excel experience can do this??

Try this
FitDay - Free Weight Loss and Diet Journal

I like the spreadsheet too.

Biggly · 03-13-2008, 10:37 PM

Quote:

it would be perfect if 1 of you excel gurus can make it so that there is a drop down menu under each meal so that the each preset foods or meals in the food database can be instantly selected and all values of that food/meal could be transferred

My Biggly does that

Enter your items then save that slot as a "Fav meal". Then just enter it later from your saved meal list.

B.

ruprecht · 03-16-2008, 05:51 PM

Bump for someone with some excel know-how who can add my suggestion. Much appreciated.

Biggly · 03-16-2008, 07:43 PM

How much were you thinking of paying?

B.

ruprecht · 03-16-2008, 08:03 PM

No offense Biggle - I'm sure your software is great. But I'm looking for something like this very basic spreadsheet. I can actually use it quite well as is but it would be easier if someone can add the feature I suggested. And since I am flat broke this is really up my alley!

07-28-2007, 08:04 AM	#1
jchappj I Don't Feel Tardy! Elite Member Join Date: Apr 2007 Location: USA Posts: 624 Photos: 6	Diet Planner If you are familiar with MS Excell please check out the spreadsheet I made and let me know your thoughts. You can download it HERE. It doesn't contain any viruses or the like but please use you antivirus software to scan it before opening. I would rather not have anyone accusing me of crashing their computer! Once you figure out how to use it you can set up your diet for the entire week and it will automatically tell you your total nutrients and percentages of each. To use: Copy the entire item's line from the 'Foods' page, then insert into the appropriate column on the day/meal you are planning. As you add items the spreadsheet updates the numbers for you. The food bank is pretty bare right now. You can add your own foods to the list, just keep in the same formatt. I've added a few things just so you can see how it works. If you aren't that familiar with excell I suggest keeping a copy of the original 'just in case' and using another to play around with. Not sure this will help you guys but I tend to eat pretty much the same things so getting the food bank up to speed shouldn't be that big of a deal. It's an easy way to see if you are on track with your nutritional goals. What do you think? jchappj Peace!

03-16-2008, 07:43 PM	#6
Biggly Nerd Join Date: Dec 2007 Location: Borneo Posts: 567	How much were you thinking of paying? B. Biggly Bodybuilding Software Food Data Rep Calc

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

03-13-2008, 04:58 PM	#2
ruprecht Registered User Join Date: Mar 2008 Location: georgia Posts: 3	This is a great Spreadsheet. But it would be perfect if 1 of you excel gurus can make it so that there is a drop down menu under each meal so that the each preset foods or meals in the food database can be instantly selected and all values of that food/meal could be transferred. For example say its Tuesday and I want to input my 1st meal which was 2 whole eggs, 1 cup oatmeal, and 3/4 cup milk. The values for each of these food have already been recorded in the food database section as well as the values of the combo of these foods as it is a standard breakfast for me. So to input these values it would be extremely easy if I can just type the number that demarcates the food or meal. So assume that the corresponding number for the entire meal above is A59, then in the daily menu typing A59 would transfer the description for this meal as well as its corresponding Macros. Alternatively a drop down menu where any food or meal from the database can be selected. Hopefully someone with some Excel experience can do this??

03-16-2008, 05:51 PM	#5
ruprecht Registered User Join Date: Mar 2008 Location: georgia Posts: 3	Bump for someone with some excel know-how who can add my suggestion. Much appreciated.

03-16-2008, 08:03 PM	#7
ruprecht Registered User Join Date: Mar 2008 Location: georgia Posts: 3	No offense Biggle - I'm sure your software is great. But I'm looking for something like this very basic spreadsheet. I can actually use it quite well as is but it would be easier if someone can add the feature I suggested. And since I am flat broke this is really up my alley!