GAMS World Forum

Thanks for your reply! I'm new in the world of GAMS so it gets sometimes a bit hard for me. I guess my problem with creating a GDX is the error "there were at least 10 duplicate entries for symbol x". Is there an option to solve this?
Thank you really much for you help.

Hi! I´m trying to import data from excel to GAMS. Sets t "Zeit" /1*200 Parameters x (t) y (t) z (t) $onecho>gdxxrw Data-x-y-z.xlsx set=t rng=Tabelle5!E2:E201 cdim=0 rdim=1 par=x rng=Tabelle5!A2:A201 cdim=0 rdim=1 par=y rng=Tabelle5!B2:B201 cdim=0 rdim=1 par=z rng=Tabelle5!C2:C201 cdim=0 rd...

Hi Fred,
thanks for your reply! That's gonna be the problem. I´m using MacOS. Is there an equivalent command for MacOS?

TheBebbo

Hi guys! I want to import data from excel to GAMS. So I tried to define a GTX data but it doesn't work out and I can't find the problem. Set t "time" /1*5/; Parameter C(t); $call gdxxrw.exe example.xlsx par=t rng=tabelle2!A1:A5 Rdim=1 $GDXIN example.gdx $LOAD C $GDXIN Display C; example.xl...

It works! Thank you so much

Hi! in the following i present you what I wanna do and what my problem is 1 Set t time /1*5/ ; 2 Parameters C(t) ExampleP1_time_t / 1 33, 2 24, 3 90, 4 12, 5 43/ F(t) ExampleP2_time_t / 1 4, 2 8, 3 10, 4 6, 5 8/; Variable G objective function; Positive Variable R(t) ExampeV1 B(t) ExampleV2 Equation ...