Search found 639 matches

by Renger
4 years ago
Forum: Tools
Topic: Import Data From Excel to GAMS Using xls2gms
Replies: 1
Views: 2653

Re: Import Data From Excel to GAMS Using xls2gms

Hi
It is hard to see where the problem is, as you either supplied the code you used nor the include file.
Please read the guidelines before posting.
CHeers
Renger
by Renger
4 years ago
Forum: Syntax
Topic: declare equation over dynamic multidimensional set
Replies: 5
Views: 10443

Re: declare equation over dynamic multidimensional set

Hi Anna

You are on the right track:

Code: Select all

Eq_Land_demand_q(i,j,m)$ijm(i,j,m)..        q(i,j,m) =e= (FullInc(i,j,m))/r(i) ;
Cheers
Renger
by Renger
4 years ago
Forum: Syntax
Topic: Loop for objective function
Replies: 34
Views: 314211

Re: Loop for objective function

GAMS tells you that the dimension 115 costfinal(t) .. zf(t) =e= z/(AED(t)*10*4380); **** $148 148 Dimension different - The symbol is referenced with more/less indices as declared You defined z over t (i.e. z(t)). For optimization you can't have multiple functions to optimize. If you want to solve t...
by Renger
4 years ago
Forum: Modeling
Topic: division by 0
Replies: 9
Views: 5055

Re: division by 0

Hi The only thing I can think of (but this is not my field of expertise) that somewhere in your model you also relate CU and CA (something like CU = q*CA and this conflicts with the two equations defining CU and CA (one being d times and the other 1-d times CR). Or you relate X(t) with those variabl...
by Renger
4 years ago
Forum: Syntax
Topic: Display variables
Replies: 3
Views: 2447

Re: Display variables

Hi Nikou

Sorry, my misunderstanding. No, using display this is not possible.
Cheers
Renger
by Renger
4 years ago
Forum: Solvers
Topic: Empty data statements error
Replies: 1
Views: 2577

Re: Empty data statements error

Hi
It is hard to say what is wrong with your data without the model and data file itself. But perhaps you can take a look at this page where the error is explained.
Cheers
Renger
by Renger
4 years ago
Forum: Syntax
Topic: Display variables
Replies: 3
Views: 2447

Re: Display variables

Hi
I think that when you study the documentation on the PUT command, you will be able to do that yourself.
Cheers
Renger
by Renger
4 years ago
Forum: Modeling
Topic: division by 0
Replies: 9
Views: 5055

Re: division by 0

Hi If you set a lower bound of 1, the variable is not allowed to be below 1. It is a constraint. To avoid division by zero, you have to set the starting value (e.g. X.L and not X.LO). GAMS uses the level for a variable as a starting point, the final value can be different. If you set X.LO = 1, it ta...
by Renger
4 years ago
Forum: Syntax
Topic: Looping over Different Excel Sheets
Replies: 15
Views: 10724

Re: Looping over Different Excel Sheets

Hi

Sorry, I can't be of any help here. Perhaps you could search for ideas in this forum.

Renger

PS. If you add the option CheckDate at the end of your gdxxrw command, it checks if the excel file changed, if not, it doesn't read the data and saves you time.
by Renger
4 years ago
Forum: Modeling
Topic: division by 0
Replies: 9
Views: 5055

Re: division by 0

Hi
You can set any level you want for this variable, as long as it solves.
Your second problem formulation doesn't solve (it is infeasible). Perhaps some of your constraints do now allow for an optimal solution.
Cheers
Renger