GAMS World Forum

Hi Jody, hi Renger, recently I'm facing nearly the same problem like Jody about two years ago. I've written a loop which looks like this: loop(instance, load_sum(t) = input(t,instance); Solve Quartiersspeicher using LP minimize Ctotal; PVtest(instance)=PVOpt.l; SoCtest(instance)=SoCOpt.l+EPS; Speich...

Thanks for your advice, it works very well!

Hi,
thanks for your support, the two dimensional set works fine.

Is there any possibility to include the two dimensional set from an Excel spreadsheet? The reading in of an one dimensional set is no problem but I could not find something about a set with more than one dimension.

Kind regards

Dear Community, currently I'm writing my master-thesis using GAMS. I would now like to combine different load-profiles from an Excel-Sheet in order to investigate the impact of the sum of the different load profiles on the scaling of the PV-plant and the Energy-Storage. The following extract shows t...