Multiple Indexing issue

GAMS
1

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+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.

2

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

–
Paper_2_index_trial_v1.gms (557 Bytes)
RegPosdata_Enbridge.xlsx (73 KB)
RegNegdata_Enbridge.xlsx (69.7 KB)

3

hi azadeh i figured out the issue i was not writing “table” when i was declaring the parameter. Thankfully i had your codes from back when you were using my laptop and i looked at them.

Thanks a lot for the help.

On Wed, Jun 10, 2015 at 11:31 AM, Ushnik Mukherjee wrote:

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

–
You received this message because you are subscribed to a topic in the Google Groups “gamsworld” group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/gamsworld/VvjOrawtzeQ/unsubscribe.
To unsubscribe from this group and all its topics, 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.

\

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.

4

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: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] On Behalf Of Ushnik Mukherjee
Sent: Mittwoch, 10. Juni 2015 17:31
To: gamsworld@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+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.

–
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.

5

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.