Optimization problem with variables exceeds the limit of 200
Sir,
I am Ph. D. student at Mahatma Phule Krishi Vidyapeeth, Rahuri, Maharashtra, India. I am working on Optimization of reservoir sizing using daily inflow data, losses, release /demand and spills. I have formulated the problem with daily storage as S1 to S170, daily spills as Sp1 to Sp170 and daily release as r1 to r170. In all there are 510 variables. When I put this problem using excel solver, I get the message every time as "Too many adjustable cells". Kindly therefore suggest suitable version of Excel solver to sovle this Linear Programming Problem.
Thanking you,
Yours faithfully
(G. L. Chunale)
Daily Farm Optimization 1991.xlsx
-
I also need suggestions on how to penalize the spill in objective function as Min (K+M*SUM(Spill t), where spill at any time t, and M is any arbitrary large constant
Daily Farm Optimization 1991.xlsx0 -
The standard Excel Solver(2010 Office) has a variable limit of 200 and constraint limit of 100. Since you are around 500 variables, then a recommend option for you would be to purchase(or at least 'trial') our Premium Solver Pro software package which has extended limits of 2000 for variables and constraints. You can find out more information by visiting www.solver.com and more specificly this product info page. http://www.solver.com/premium-solver-pro
0
Please sign in to leave a comment.
Comments
3 comments