I want to know how to import load profiles into GAMS using data in excel sheet
Talal Alharbi
It is easy to do. You just need to type this code as follow
parameter LP(i,t) your loads profiles
$call gdxxrw "filename".xls par=qd rng='sheetnumber'!A19:Y33 rdim=1 cdim=1
$gdxin filename.gdx
$load qd
$gdxin
display qd ;
I just give you an example you can change the data above based on your file name parameters name and the range dimension in excel sheet and the dimensions that you have
2 votes
2 thanks
Talal Alharbi
There is another way that can save time while running your GAMS model.
- First you define the parameter that you want.
- Then you can call .xls file defining the range and the sheet as well the name of the excel file. Also, you will define the name of the output file that has .inc at the end. you just need to do this only once .
- Then you can comment the code because the load profile will be save as LP.inc in directory.
- Example:
Table LP(i,t) your loads profiles
$call =xls2gms r=P1!a1:b2 i=profiles.xlsx o=LP.inc ( this can be commented after the irst run)
$include LP.inc
2 votes
1 thanks
- Badges
- Science topic
More Mohamed Atef Kamel's questions See All
Similar questions and discussions