Search found 14 matches

by ferrib
2 years ago
Forum: Modeling
Topic: Possible problems with MIP-CPLEX
Replies: 3
Views: 1620

Re: Possible problems with MIP-CPLEX

Hi Fred, Thanks a lot for your input. I will need to take a look at the "feasopt" (i will try to learn from https://www.gams.com/latest/gamslib_ml/libhtml/gamslib_feasopt1.html ) and "iis" as you suggest. I had stumbled upon the "intvarup" issue before and made sure that is not the problem. But befo...
by ferrib
2 years ago
Forum: Modeling
Topic: Possible problems with MIP-CPLEX
Replies: 3
Views: 1620

Possible problems with MIP-CPLEX

Hi, I am coding a Mixed Integer Programming, to be solved with CPLEX. This is a market clearing problem, and objective function is to minimize costs. Apologize me, i cannot post the code, but hopefully with some hints, based on your experience, you might be able to form an opinion and help me. 1 - I...
by ferrib
2 years ago
Forum: Syntax
Topic: searching string in set
Replies: 11
Views: 3600

Re: searching string in set

Thanks Michael, this was very helpful!
by ferrib
2 years ago
Forum: Syntax
Topic: searching string in set
Replies: 11
Views: 3600

searching string in set

Hi all,

Let's suppose i have a set X = \y1 y2 y3 ... z1 z2\ and a variable w(X) = \y1 10, y2 20, y3 30, ... , z1 40, z2 50\
Is there an easy way of summing the values for all the elements of w(X) that have the string "y" in their name?

Thanks in advance!
by ferrib
2 years ago
Forum: Syntax
Topic: .inc files
Replies: 13
Views: 9610

Re: .inc files

Thanks Michael, works like a charm!
by ferrib
2 years ago
Forum: Syntax
Topic: .inc files
Replies: 13
Views: 9610

Re: .inc files

Hi Renger, I checked the log and you are right CheckDate is working. I guess it is me who is using GDX in a wrong way. If i input many parameters using similar code will end up only saving the last parameter on GDX: Set g; $call gdxxrw.exe i=input.xlsx set=g rng=Bid_EN_price_gen_sell!a2 rdim=1 cdim=...
by ferrib
2 years ago
Forum: Syntax
Topic: .inc files
Replies: 13
Views: 9610

Re: .inc files

Hi Renger,

Thanks for your help.

Attached the .xlsx file and the gams code.
by ferrib
2 years ago
Forum: Syntax
Topic: .inc files
Replies: 13
Views: 9610

Re: .inc files

Hi again, Just ressurrecting this topic to see if any of you can provide an example with the CheckDate option. I can't make it work. Let's say my example for loading data is as follows, where should i place my "checkdate"? Set d; $call gdxxrw.exe i=input.xlsx set=d rng=Sheet1!c2 rdim=1 cdim=0 $gdxin...
by ferrib
2 years ago
Forum: Tools
Topic: GDXXRW - writing to excel - no header
Replies: 3
Views: 2090

Re: GDXXRW - writing to excel - no header

Hi Renger and thanks for the feedback.

That would be just a matter of organizing the data straight from GAMS to the "right" place in the spreadsheet in order to make it easier for tables, plots and so on. But i can just upload stuff there and use referencing instead.
by ferrib
2 years ago
Forum: Tools
Topic: GDXXRW - writing to excel - no header
Replies: 3
Views: 2090

GDXXRW - writing to excel - no header

Hello, I am trying to write my variables results (.L) without printing the header (corresponding to the sets). Let's say i have x(t) with t from 1 to 24, and in excel i only want the x(t) values to be written, but what i get with GDXXRW is that i get the headers 1, 2, ... 24 printed. i tried with cd...