Search found 14 matches
- 5 years ago
- Forum: Modeling
- Topic: Possible problems with MIP-CPLEX
- Replies: 3
- Views: 4057
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 tha...
- 5 years ago
- Forum: Modeling
- Topic: Possible problems with MIP-CPLEX
- Replies: 3
- Views: 4057
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...
- 5 years ago
- Forum: Syntax
- Topic: searching string in set
- Replies: 11
- Views: 10885
Re: searching string in set
Thanks Michael, this was very helpful!
- 5 years ago
- Forum: Syntax
- Topic: searching string in set
- Replies: 11
- Views: 10885
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!
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!
- 5 years ago
- Forum: Syntax
- Topic: .inc files
- Replies: 13
- Views: 18222
Re: .inc files
Thanks Michael, works like a charm!
- 5 years ago
- Forum: Syntax
- Topic: .inc files
- Replies: 13
- Views: 18222
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=...
- 5 years ago
- Forum: Syntax
- Topic: .inc files
- Replies: 13
- Views: 18222
Re: .inc files
Hi Renger,
Thanks for your help.
Attached the .xlsx file and the gams code.
Thanks for your help.
Attached the .xlsx file and the gams code.
- 5 years ago
- Forum: Syntax
- Topic: .inc files
- Replies: 13
- Views: 18222
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 cdi...
- 5 years ago
- Forum: Tools
- Topic: GDXXRW - writing to excel - no header
- Replies: 3
- Views: 4614
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.
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.
- 5 years ago
- Forum: Tools
- Topic: GDXXRW - writing to excel - no header
- Replies: 3
- Views: 4614
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...