Search found 2 matches
- 7 years ago
- Forum: Solvers
- Topic: Maximize One Variable While Minimizing Another?
- Replies: 1
- Views: 3663
Re: Maximize One Variable While Minimizing Another?
I was able to get Excel to solve for multiple variables by: -- Standardizing all the data -- Setting the single variable the Excel solver can explicitly maximize, to a cell containing the formula "=Earnings-((Cost+Distance+Time)/3)" That worked. I imagine this is as easy (or more likely ev...
- 7 years ago
- Forum: Solvers
- Topic: Maximize One Variable While Minimizing Another?
- Replies: 1
- Views: 3663
Maximize One Variable While Minimizing Another?
The Solver that comes with Excel can only minimize or maximize a single variable. I have a data set where I need to maximize revenue while minimizing cost and distance. Is it possible to do this in GAMS?
Thanks in advance any info.
Thanks in advance any info.