Hello Renger,
Thank you so much. It’s working fine now.
\
Regards,
Debasmita Panda
​​
On Fri, Oct 9, 2015 at 12:55 PM, Renger van Nieuwkoop wrote:
Hi
The elements of the sets are missing in your excel sheet. Your sheet should look like this:
T1 T2 …
S1 6.7 1.3
S2 2.3 …
The range would then be a1:y6
Cheers
Renger
Von: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] Im Auftrag von Debasmita Panda
Gesendet: Freitag, 9. Oktober 2015 08:48
An: gamsworld@googlegroups.com
Betreff: Re: unable to find the reason for domain violation Error
Please find the attached .xlsx file here.
​Thanks​
\
Debasmita
On Fri, Oct 9, 2015 at 12:06 PM, Renger van Nieuwkoop wrote:
Hi Desbasmita
You are correct, Just send the excel file.
Cheers
Renger
Von: gamsworld@googlegroups.com [mailto:gamsworld@googlegroups.com] Im Auftrag von pandadebasmita4@gmail.com
Gesendet: Donnerstag, 8. Oktober 2015 19:49
An: gamsworld
Betreff: Re: unable to find the reason for domain violation Error
Hello,
Thanks for your prompt reply.
As I understand, in gams declaring r = a1:x5, have 5 rows and 24 columns. My excel sheet contains the same size matrix.
In sets declaration T is the column numbering with 24 entries and S is the row numbering with 5 entries.
Calling conts(S,T), should show error free matrix. I have also tried calling with changed rows and column. Its showing the same error.
Then where from the error is coming ?
Please correct me if I am wrong.
Thanks
Debasmita
On Thursday, 8 October 2015 18:41:15 UTC+5:30, Renger van Nieuwkoop wrote:
Hi
It looks like you lie the dimension of conts is not consistent with the excel table.
Conts is defined over (S,T) and I assume that you have in your excel table T as rows, and S as columns (because this is how you defined the range).
Cheers
Renger
Von: gams...@googlegroups.com [mailto:gams...@googlegroups.com] Im Auftrag von pandade...@gmail.com
Gesendet: Donnerstag, 8. Oktober 2015 14:21
An: gamsworld
Betreff: unable to find the reason for domain violation Error
Dear all,
Need your help!
I am unable to find the reason for following error.
sets
T ‘trading interval in hours’ /t1*t24/
S ‘number of contracts’ /s1*s5/
;
$onecho > price.txt
i=%system.fp%price.xlsx
r=a1:x5
o=dat.inc
$offecho
$call =xls2gms @price.txt
table conts(S,T) ‘contract prices’
$include dat.inc
;
display conts;
Its showing Error 170 domain violation for each element in the 5*24 matrix.
\
Thanks
\
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.
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.