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!