D
Denise
St M(Lean)/M(Med.)/M(High) Veg Frt Mlk Fat
GOALS CALS PERCENT
CAR: 1,000 50.0%
PRO: 400 20.0%
FAT: 600 30.0%
Total: 2,000 100%
1 exchange 80 45 75 100 25 60 100 45
Calories
Carbohydrates combine Starch [65 of the 80 calories], Veg [20 of the 25
calories], Fruit [all 60 calories], Milk [38 of the 100 calories], (B,F,G,H)
Protein combines Starch [15 of the 80 calories], Meat [40% of the total
meat calories are Protein (C10-E10)], Veg [5 of the 25 calories], Milk [27 of
the 100 calories] & Fruit (C-E & H)
Fat combines Meat [60% of the total meat calories are Fat (C10-E10)] & Milk
[35 of the 100 calories] & Fat [all 45 calories] (C-E, H & I)
The original version of this worksheet is laid out so that a client
or our staff Dietician can choose the number exchanges in day (Starch-Fat)
and the sheet will calculate the calories and the percentage for
Carbs./Protein & Fat.
Our dietician has asked me to make it work inversely so that she can insert
total calories for the client - she wants the sheet to then calculate the
number of exchanges based on a fixed 50% Carbs/20% Protein and 30% Fat
I'm not skilled enough to express these formulas or clear as to whether
there are too many variables for it to work.
Thank you for your help!
GOALS CALS PERCENT
CAR: 1,000 50.0%
PRO: 400 20.0%
FAT: 600 30.0%
Total: 2,000 100%
1 exchange 80 45 75 100 25 60 100 45
Calories
Carbohydrates combine Starch [65 of the 80 calories], Veg [20 of the 25
calories], Fruit [all 60 calories], Milk [38 of the 100 calories], (B,F,G,H)
Protein combines Starch [15 of the 80 calories], Meat [40% of the total
meat calories are Protein (C10-E10)], Veg [5 of the 25 calories], Milk [27 of
the 100 calories] & Fruit (C-E & H)
Fat combines Meat [60% of the total meat calories are Fat (C10-E10)] & Milk
[35 of the 100 calories] & Fat [all 45 calories] (C-E, H & I)
The original version of this worksheet is laid out so that a client
or our staff Dietician can choose the number exchanges in day (Starch-Fat)
and the sheet will calculate the calories and the percentage for
Carbs./Protein & Fat.
Our dietician has asked me to make it work inversely so that she can insert
total calories for the client - she wants the sheet to then calculate the
number of exchanges based on a fixed 50% Carbs/20% Protein and 30% Fat
I'm not skilled enough to express these formulas or clear as to whether
there are too many variables for it to work.
Thank you for your help!