multiple parameters from XLSX to GDX - ERROR 492 - symbol not in GDX

Archive of Gamsworld Google Group
Post Reply
Archiver
User
User
Posts: 7876
Joined: 1 year ago

multiple parameters from XLSX to GDX - ERROR 492 - symbol not in GDX

Post by Archiver » 2 years ago


Hit there,

I have the following code sequence:


1) This is a textfile I stored as "input.txt"

$onecho > taskin.txt
dset=t rng=import!a2:a35041 rdim=1
par=xDA rng=import!b2:b35041 rdim=1
par=cBApos rng=import!G2:G35041 rdim=1

$offecho


2) This is the GAMS Code which is supposed to create a GDX File for the parameters cBApos and xDA:

$call gdxxrw.exe INPUT_DETERMENISTIC.xlsx @input.txt

$GDXIN Test1.gdx

set t /1*35042/ ;

$load t

display t;

parameters
cBApos(t) costs for gas and CO2 positive xval
xDA(t) sold amount in the day ahead market (MWh)


$load cBApos xDA

$GDXIN




I receive the Error CODE 492 - Symbol not in GDX

Can someone help out? Do I need first to define something in the GDX file?

Stefan

--
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

Archiver
User
User
Posts: 7876
Joined: 1 year ago

Re: multiple parameters from XLSX to GDX - ERROR 492 - symbol not in GDX

Post by Archiver » 2 years ago


Stefan,

The call to gdxxrw generates INPUT_DETERMENISTIC.gdx not Test1.gdx

--Paul

On Fri, Mar 25, 2016 at 12:03 PM, Stefan Kermer wrote:

Hit there,

I have the following code sequence:


1) This is a textfile I stored as "input.txt"

$onecho > taskin.txt
dset=t rng=import!a2:a35041 rdim=1
par=xDA rng=import!b2:b35041 rdim=1
par=cBApos rng=import!G2:G35041 rdim=1

$offecho


2) This is the GAMS Code which is supposed to create a GDX File for the parameters cBApos and xDA:

$call gdxxrw.exe INPUT_DETERMENISTIC.xlsx @input.txt

$GDXIN Test1.gdx

set t /1*35042/ ;

$load t

display t;

parameters
cBApos(t) costs for gas and CO2 positive xval
xDA(t) sold amount in the day ahead market (MWh)


$load cBApos xDA

$GDXIN




I receive the Error CODE 492 - Symbol not in GDX

Can someone help out? Do I need first to define something in the GDX file?

Stefan

--
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.




--
Paul van der Eijk
GAMS Development Corporation
Tel : (202) 342-0180 Fax : (202) 342-0181
Email: pvandereijk@gams.com
Web : http://www.gams.com

--
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at https://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

Post Reply