Help with importing 3d Excel array

GAMS
1

Hi all,

I’m struggling to import the 3D array in the attached excel sheet into GAMS. I want to use each column (cap,L,bi,om,D,act) as a separate parameter in my model, with the first two columns being the (i,j), so I was trying to call each of these individually using the following:


$CALL GDXXRW modelinputs.xls par=L rng=Adata!A1:B62, D1:D62 Cdim=2 Rdim=1
parameter cap(i,j) ;
$gdxin modelinputs.gdx
$load cap
display cap

I’m getting a Error 492 - Symbol not in GDX.

I know i’m way off. I can do it perfectly fine using a 2d array for other parameters. Been at it all day and you guys are my last resort…

Any help greatly appreciated!

Cheers,

Stevie

–
modelinputs1.xlsx (11.5 KB)

2

Your excel file has the extension xlsx not xls
Renger

sent from my iPad

Am 20.07.2014 um 20:10 schrieb “Stevie Lochran” :

Hi all,

I’m struggling to import the 3D array in the attached excel sheet into GAMS. I want to use each column (cap,L,bi,om,D,act) as a separate parameter in my model, with the first two columns being the (i,j), so I was trying to call each of these individually using the following:

$CALL GDXXRW modelinputs.xls par=L rng=Adata!A1:B62, D1:D62 Cdim=2 Rdim=1
parameter cap(i,j) ;
$gdxin modelinputs.gdx
$load cap
display cap

I’m getting a Error 492 - Symbol not in GDX.

I know i’m way off. I can do it perfectly fine using a 2d array for other parameters. Been at it all day and you guys are my last resort…

Any help greatly appreciated!

Cheers,

Stevie

–
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 http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

–
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 http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.