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.
Search found 64 matches
- 4 years ago
- Forum: Syntax
- Topic: Structuring of Excel output-file in GAMS
- Replies: 26
- Views: 14551
- 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
I tried your code first and seems I have a problem with gdx-file. See attachment:
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
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
- 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
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
- 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...
- 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?
Concerning *csv files. Does it work in GAMS Studio?
- 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...
- 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...
- 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.
This is something that I also tried.
And I didn't get any Excel output file.
See the attachment.
- 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...