each of the location has some attributes: density, FD,S price, and income
The only way I know how to import these is using this format
for example for density and FDS:
Code: Select all
parameter density(i,d), FDS(i,f); *$call GDXXRW.exe filename.xlsx par=density rng=sheet1!a1:b12 trace=2 rdim=1 cdim=0 *$GDXIN filename.gdx *$LOAD density *$GDXIN *$call GDXXRW.exe filename.xlsx par=density rng=sheet1!c1:d12 trace=2 rdim=1 cdim=0 *$GDXIN filename.gdx *$LOAD density *$GDXIN
This is the file. The actual data set in the one on the right. However, as I don't know a better way, I use something like the left ones (I copy every location columns near the desired coulmn to match indicies). However, this is not a good practice I guess. And I think there would be a better way to easily import pameters while having correct indicies.
How to import every columns in the spreadsheet? I'd like to have a parameter d(location, density) = value that occurs in associated cell, likewise for other parameters.