On 12/5/20 2:11 PM, Manuel Castro wrote:
Hi all,
First, I would like to thank you for the constant support as you have
always addressed my questions very promptly.
Second, I would like to ask you a question as I am really stuck on this one.
I have defined the following in the code:
set LoadsCount;
set PeriodsCount;
param LoadPowerProfile{i in LoadsCount, j in PeriodsCount};
For the sake of discussion let's assume that "LoadsCount" is 1..100 and
"PeriodsCount" is 1..8760 (i.e. hourly values through the year).
I now want to fill in my array "LoadPowerProfile" with values. For that
I have the following table in CSV (of course this is a stylized table
just for you to understand what I am up to).
With the GLPK you cannot read cross-tabulated CSV files.
You should create a table where you have separate columns for load,
hour, value.
Load,Hour,Value
1,0,3.4
1,1,5.7
...
100,8760,6.7
Best regards
Heinrich
Load
1
2
(…)
8760
Load1
11.98
62.51
99.69
Load2
86.39
59.50
25.89
(...)
Load100
67.98
98.71
31.19
How do I read the yellow shaded area into my "LoadPowerProfile" array? I
would be thankful if you could give me an example of the statement i
should use to read this into "LoadPowerProfile" array.
Many thanks in advance for all your support.
Kind regards,
Manuel.
