Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
Developing Binary Variables
I think I have this but I can 't get the Sumproduct to work This gives me the correct answer if I have already determined Yield effects of salt Here Yield is a combination of production*Income already Profit = Sumproduct (Area, Yield) - Sumproduct(Area,Costs) Sumproduct(Area, Costs) = cost to produce Sumproduct (Area, Yield) = return from production What I need to do is alter the return from production to include the salt impact within the function Yield = Basic Yield - Threshold Impact * (Salt-Threshold)*Y Where Salt = level of salt in water Threshold = salt level required to affect yield Threshold Impact = impact of salt Y = Dummy Binary Variable, which I then add as a constraint But I have no idea how to put this into a Sumproduct formula to use in Solver. Sumproduct(Area, ?????) Any suggestions would be greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using solver with function with multiple outputs | Excel Worksheet Functions | |||
More time questions and IF function problem | Excel Worksheet Functions | |||
Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
Protecting a sheet that includes a solver function | Excel Worksheet Functions | |||
Protecting a sheet that includes a solver function | Excel Worksheet Functions |