Excel Diet sheet setup

[StRoNg_WoN]

What up guys?

Hey guys.. what's up?

I'm trying to make this spread sheet a little more user friendly...

Currently it looks like this:

http://www.elitefitness.com/gallery/showphoto.php?photo=36161&cat=500&page=1

The idea is... that when you change the quantity, it auto re-calculates everything to the right in the respective row...

Example:

--------------------Protein----Carbs----Fat

1 scoop(s) of protein 30 2 0


Now if I were to change the Quantity to 2 scoops:

--------------------Protein----Carbs----Fat

2 scoop(s) of protein 60 4 0


The way I did that is by using this formula for each cell:

=30*A20


30 = (the amount of protein in 1 scoop)
A20 = Quantity Cell

Now the problem is, I would like to somehow or other be able to pick the food I want to use from this data sheet:

http://www.elitefitness.com/gallery/showphoto.php?photo=36160&cat=500&page=1

From there... I'd like to have the cells auto populate with the correct data amounts. From there, be able to change the quantity, and have it reflect the new numbers all automatically, rather then having to copy paste the data into new cells, then go back and manually change them to =(current value)*(Quantity).

Does this makes sense, and how can I do this? I want to keep the cell quantity fomula intact, while being able to select different foods.

As well, if someone else already has this setup.... I'd LOVE a copy... lol

 

[pintoca]

What up guys?

Hey guys.. what's up?

I'm trying to make this spread sheet a little more user friendly...

Currently it looks like this:

http://www.elitefitness.com/gallery/showphoto.php?photo=36161&cat=500&page=1

The idea is... that when you change the quantity, it auto re-calculates everything to the right in the respective row...

Example:

--------------------Protein----Carbs----Fat

1 scoop(s) of protein 30 2 0


Now if I were to change the Quantity to 2 scoops:

--------------------Protein----Carbs----Fat

2 scoop(s) of protein 60 4 0


The way I did that is by using this formula for each cell:

=30*A20


30 = (the amount of protein in 1 scoop)
A20 = Quantity Cell

Now the problem is, I would like to somehow or other be able to pick the food I want to use from this data sheet:

http://www.elitefitness.com/gallery/showphoto.php?photo=36160&cat=500&page=1

From there... I'd like to have the cells auto populate with the correct data amounts. From there, be able to change the quantity, and have it reflect the new numbers all automatically, rather then having to copy paste the data into new cells, then go back and manually change them to =(current value)*(Quantity).

Does this makes sense, and how can I do this? I want to keep the cell quantity fomula intact, while being able to select different foods.

As well, if someone else already has this setup.... I'd LOVE a copy... lol

I use something similar: One table has a list of foods with their values, the other tables simply go back and reference the list (it provides a pull-down lists of foods), you add the quantity and zas! you have the values according to the quantity.

I wrote in a mixture of spanish/german though, lol. Still wanna a copy?

 

[StRoNg_WoN]

Eeeesh... I'll pass... lol I did however figure this sorta out... I'd like to refine the list to groups (Protein, Carbs, Fats, Fruits, Veg, Supplements,) etc.. then based on that, create another pulldown with ONLY the listings required...

This is what I have so far if anyone wants to use it... Also does anyone have a LONG ASS list of foods in Excel format with there Macros? lol

Hmmm it isn't allowing me to attach the .zip file... hang on

 

[StRoNg_WoN]

DietSheet

 

[sd27bb]

DietSheet

wow this thing is awesome, how do you set this up? is there a book or a site i can go to to learn to set that up? Please let me know, thanks

 

[StRoNg_WoN]

Ummm... naw... I just did a search on the net for the Vlook up Command and a buncha other shit... and just kinda learned on my own...

Thanks though... I hope you find it handy...

 

[sd27bb]

Ummm... naw... I just did a search on the net for the Vlook up Command and a buncha other shit... and just kinda learned on my own...

Thanks though... I hope you find it handy...

hey, where are all the food values stored? where is the array?

 

[Kabeetz]

Why not just use fitday.com it's free and easy?

 

[StRoNg_WoN]

They're on a hidden sheet... just unhide it...

Ummm... also... I like fitday.. but this is something that was needed by someone at the gym... he didn't like the way fitday grouped all your food into one big list... I don't either really... I like the look of 'meals' better...