Search found 64 matches

by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Yes. I corrected the code. There are no errors.
But the problems appears when I want to look at results.csv file. It shows only 1,048,576 rows (I increased dimensions in test-parameter) and no more.
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Hi Renger,

I tried your code first and seems I have a problem with gdx-file. See attachment:

Jarenka
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Hi Renger,

1,000,000 rows is not a problem. The problem with csv starts when I have over 1,048,576 rows.
Can you try to extend you test-parameter to have over 1,048,576 rows?

Jarenka
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Hi Renger,

Yes, it works with a few lines for CSV-format.
So if I understand it correctly, csv-format has also limited number of rows. Right?

Jarenka
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Hi again, I have tried to open a *csv file with following commend (trying with different option with delimiter): $call gdxdump csv_output.gdx output=Employment_qaeg.csv delim=comma symb=qaegT format=csv And I always receive an uncompleted csv-file with error - see attachment. Do I do something wrong...
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Thank you Renger,

Concerning *csv files. Does it work in GAMS Studio?
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Hi Renger, It has 758,609 x 19 = 14,413,571 rows (in .gdx file). It seems that no matter what, it automatically transforms the gdx-file into Excel file with 758,609 rows and 24 columns (5 dimensions + 19 years). Where did you find this number? This is good information to know, because we are working...
by Jarenka
4 years ago
Forum: Syntax
Topic: Error: overflow in + operation (addop)
Replies: 12
Views: 9950

Error: overflow in + operation (addop)

Dear, I posted a question in archive here: https://forum.gamsworld.org/viewtopic.php?f=13&t=8650&p=25722#p25722 I have a problem with solving the overflow in an equation that contains just summation over three dimensions. I need this variable, because it is used in the model. Do you have any...
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Re: Structuring of Excel output-file in GAMS

Hi Renger,

This is something that I also tried.
And I didn't get any Excel output file.
See the attachment.
by Jarenka
4 years ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 14551

Structuring of Excel output-file in GAMS

Dear, I refer to this post: https://forum.gamsworld.org/viewtopic.php?f=2&t=10904 I have a problem with structure of Excel file - output file with variables having many dimensions. I added as recommended: rdim=5 cdim=1 . My code looks like that in the attachment. Parameter "qabg" is si...