Food Details.
Hi
On your Food sheet, sheet 8, set up a matrix as follows
Carbs Protein
Chicken
Beef
Pork
Bread
With as many parameters as you are going to measure going across the
page, and as many foods as you wish down the page. Express all values as
nutrients per 100 grams
InsertNameDefineName Nutrients Refers to . =Sheet8$A$1:$F$100
or whatever is the range of your data.
Group the other 7 sheets by selecting the first, holding down shift as
you select the 7th.
On one sheet set up as follows
Product Quantity Carbs Protein
Chicken
Bread
In cell C2
=B2/100*VLOOKUP($A2,Nutrients,column(A:A),0)
copy across the row for as many columns as required and down for as many
rows as required.
As the sheets are grouped, the data and formulae will be copied to all.
Click on Sheet8 to ungroup them.
--
Regards
Roger Govier
"the-jackal" wrote in message
...
OK. I am going to start weight training and need to set up the
following.
I have 8 sheets (1 for each day) and another sheet with the food I
like
to eat. Each food has details such as. Protein, Fat, Carbs etc. What I
would like to do is add on say Wednesday what I am going to eat for
that day and then for spreadsheet to work out my total Protein, carb
and fat intake for that day using the info on page 8.
So if for example I have 75gms Chicken breast on page 8 and I put
Chicken in page 4 (Wednesday) twice, it will work out my Total intake
of Protein, Carbs etc.
Thanks in advance
Carl
--
the-jackal
|