Input more 1-D parameters from excel

GAMS
1

Hi community,

I have a problem about read input data from excel. I want to read all parameters from excel. I attached 2 picture in the post. One of them now, how I read (there is no problem, I can do it) and other one is what I want. I am looking forward to your helps. Thank you!

Set
i "The index of orders";

Parameter
f(i) "size of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
p(i) "a unit production time of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
d(i) "due date of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;
c(i) "production type of order i" /
$call =xls2gms r=a1:b5 i=data.xls o=pard.inc
$include pard.inc
/;

The image explain current situation;
I want.png
and this one is what i want to do;
now.png

2

Don’t use xls2gms. It’s a tool on its way out. Use gdxxrw :

set i; parameter f(i<), p(i), d(i), c(i);
$call.checkErrorLevel gdxxrw i=data.xls o=data.gdx par=f rng=a2 rdim=1 par=p rng=c2 rdim=1 par=d rng=e2 rdim=1 par=c rng=g2 rdim=1
$gdxin data
$load f p d c

-Michael

3

Thank you for your help, I will try!