Hi Renger,

Thank you (Danke) so much. This helps a lot.

Regards

Ushnik

On Wednesday, 10 June 2015 13:41:32 UTC-4, Renger van Nieuwkoop wrote:

Hi Ushnik

The correct code for importing this data is (you are importing a table):

table RegPos_signal(h,s)

$call =xls2gms r=sheet2!A2:C3 i=RegPosdata_Enbridge.xlsx o=“parRegPos_signal.inc”

$include parRegPos_signal.inc

Hope this helps

Renger

From: gams...@googlegroups.com [mailto:gams...@googlegroups.com] On Behalf Of Ushnik Mukherjee

Sent: Mittwoch, 10. Juni 2015 17:31

To: gams...@googlegroups.com

Subject: Re: Multiple Indexing issue

I tried a more simple version of the problem that i described in my earlier post. So, again i have hours and seconds as two indices. In this case i try to read the parameters RegPos_signal(h,s) and RegNeg_signal(h,s) for only one hour. Since the signal is sent every two seconds that is why i have the seconds index varying from 1 to 1800.

When i try running the attached program i keep getting error 338, error 610, error 148 and error 170. I would really appreciate it if anyone who tries running the attached program and gives me a clue about where i am going wrong.

Best Regards

Ushnik

On Friday, 5 June 2015 02:26:47 UTC-4, Ushnik Mukherjee wrote:

Hello everyone,

While trying to enter a parameter file which has a matrix dimension of 168x1800, i keep getting ‘error 148: Dimension different - The symbol is referenced with more/less indices as declared.’ This error is followed by error 334 and then error 98. The first dimension that is ‘168’ denotes the hours and the second dimension ‘1800’ denotes the number of 2 second intervals in an hour.

Here is what i wrote to read the file from an excel sheet:

Reg_signal(h,s) “Regulation Signal”

/

$call =xls2gms r=sheet1!A2:BQG170 i=RegData_Enbridge.xlsx o=“parReg_signal.inc”

$include parReg_signal.inc

/,

\

- h denotes hours and s denotes the 2 second interval

In the code itself i also have variables that only have an hour index assoiciated with them. I try to sum over all the 2 second intervals in an hour a few times. Below is one of those summation equations:

PositiveReg(h) =e= sum(s, RegPos(h,s));

I was wondering what should i be trying differently to get rid of the error messages and also whether my summation equation is correct?

I would greatly appreciate any helpful feedback

Sincerely

## Ushnik

\

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+...@googlegroups.com.

To post to this group, send email to gams...@googlegroups.com.

Visit this group at http://groups.google.com/group/gamsworld.

For more options, visit https://groups.google.com/d/optout.

–

To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.

To post to this group, send email to gamsworld@googlegroups.com.

Visit this group at http://groups.google.com/group/gamsworld.

For more options, visit https://groups.google.com/d/optout.