I have a 4-dimensional data in Excel as follows.
Row 1: Set a with 2 elements, /'Refinery 1','Refinery 2'/
Row 2: Set b with 2 elements, /'Pipeline','Rail'/
Column 1: Set q with 2 elements, /'Warehouse 1','Warehouse 2'/
Column 2: Set r with 3 elements, /'Petroleum','Diesel', 'Jet Fuel'/.
My data looks like this in Excel.
I try to import the data from Excel to GAMS by the following code.
sets a first row entries
b second row entries
q first column entries
r second column entries
$CALL GDXXRW.EXE i=Try1.xlsx o=Try1.gdx set=a rng=Sheet1!A3:A6 rdim=1 set=b rng=Sheet1!B3:B6 rdim=1 set=q rng=Sheet1!C1:H1 cdim=1 set=r rng=Sheet1!C2:H2 cdim=1 par=data3 rng=Sheet1!A1:F6 Rdim=2 Cdim=2
$GDXIN Try1.gdx $LOAD a,b,q,r,data3 $GDXIN
It shall produce the resulting parameter, i.e data3 as 24 elements (2x2x2x3), But it only shows 16 elements, due to some problems and ignores other elements.
The resulting GDX looks like this!
Any help will be highly appreciated. Thanks!