Solver - to determine macronutrient portions

winstonw

Board Regular
Joined
Jan 17, 2008
Messages
156
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....



n.jpg


TIA
Winston
 
Last edited:

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,137,120
Messages
5,679,723
Members
419,853
Latest member
hc9587

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top