Search found 3 matches

by Newcomer
2 years ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 5741

Re: excel to gams

Oh I am sorry, I forgot to adjust the table before sending it to you. I already changed A2 to A1 in my program. I just tried to solve my problem on a different computer and it worked after I changed trace=3 to trace= 4 . I guess it is a problem with our server. But still thank you very much for your...
by Newcomer
2 years ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 5741

Re: excel to gams

Thanks for your quick response. Unfortunately, now I get the Error 649 - Domain violation.

I double checked the domain and I have no Idea what is wrong here.
Daten-TSP.xlsx
This is my Excel sheet
(9.78 KiB) Downloaded 103 times
by Newcomer
2 years ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 5741

Re: excel to gams

Hey, I have a similar problem. I used the following codes to create a gdx file and then to import the file into GAMS: set i column lables /i1*i6/ j row labels /j1*j6/; Parameter d(i,j) distance in km; $call GDXXRW.exe Daten-TSP.xlsx trace=3 par=d rng=Tabelle1!A2 rdim=1 cdim=1 $GDXIN Daten-TSP.gdx $L...