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 entriesparameter data3(a,b,q,r);$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 $GDXINdisplay data3;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!

Question

I have a 4-dimensional data in Excel as follows.Row 1: Set a with 2 elements, /&#039;Refinery 1&#039;,&#039;Refinery 2&#039;/Row 2: Set b with 2 elements, /&#039;Pipeline&#039;,&#039;Rail&#039;/Column 1: Set q with 2 elements, /&#039;Warehouse 1&#039;,&#039;Warehouse 2&#039;/Column 2: Set r with 3 elements, /&#039;Petroleum&#039;,&#039;Diesel&#039;, &#039;Jet Fuel&#039;/.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 entriesparameter data3(a,b,q,r);$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 $GDXINdisplay data3;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!

reflam2kfnr · Accepted Answer

This is not a question about mathematics, so this forum is not really appropriate.But to answer your question, easier is:sets  a  first row entries      b  second row entries      q  first column entries      r  second column entriesparameter data3(a,b,q,r);$CALL GDXXRW.EXE i=Try1.xlsx par=data3 rng=A1 Rdim=2 Cdim=2 trace=2$GDXIN Try1.gdx$LOAD a

I have a 4-dimensional data in Excel as follows. Row 1: Set a with 2 elements, /'Refinery 1','Refin

Answered question

Answer & Explanation

New Questions in Pre-Algebra