Thank you.
How could I then pass the values in the table you suggest into the array
LoadPowerProfile{i in LoadsCount, j in PeriodsCount}
---- On Sat, 05 Dec 2020 13:54:55 +0000 Heinrich Schuchardt
<xypron.g...@gmx.de> wrote ----
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.
>
