I am building a diet worksheet as per the following and am trying to optimize the way Solver calculates an answer, or ask here if indeed Solver can...
Givens
- a specific total daily food Calorie intake i.e. 1000 Calories
- a specific macronutrient split as determined by user
i.e.
protein: established by grams/kg lean bodyweight
fat: 10% of total Calories
Cho: remainder
I want Solver to apportion the Calories for each macronutrient between a variety of sub groups (red cells). i.e.
CHOs: Cups of fibrous, starch, simple
Protein: Cups of either legumes, flesh, dairy
Fat: tspns of Oil
However, each food sub group has various levels of ALL macronutrients. This complicates Solver's attempts to calculate portions to, say, meet the total protein requirement, because each change to protein simultaneously varies the fat and cho contribution.
Anyway, constraints are also used in that there are minimum and maximum values for each of the portions (grey cells).
I have messed with Solver and its options for a few days now, and am dissatisfied with the outcome.
If anyone is interested in helping, I can PM you a url to download a copy of the spreadsheet....
TIA
Winston
Givens
- a specific total daily food Calorie intake i.e. 1000 Calories
- a specific macronutrient split as determined by user
i.e.
protein: established by grams/kg lean bodyweight
fat: 10% of total Calories
Cho: remainder
I want Solver to apportion the Calories for each macronutrient between a variety of sub groups (red cells). i.e.
CHOs: Cups of fibrous, starch, simple
Protein: Cups of either legumes, flesh, dairy
Fat: tspns of Oil
However, each food sub group has various levels of ALL macronutrients. This complicates Solver's attempts to calculate portions to, say, meet the total protein requirement, because each change to protein simultaneously varies the fat and cho contribution.
Anyway, constraints are also used in that there are minimum and maximum values for each of the portions (grey cells).
I have messed with Solver and its options for a few days now, and am dissatisfied with the outcome.
If anyone is interested in helping, I can PM you a url to download a copy of the spreadsheet....
TIA
Winston
Last edited: