Search found 55 matches

by Jarenka
1 day ago
Forum: Syntax
Topic: How to execute many "programs" at one time?
Replies: 5
Views: 97

Re: How to execute many "programs" at one time?

Hi,

Thank you!

I have created a *bat file called run.bat in a simple text editor.
But when I want to run it (by clicking on it) it does not come anything.

Here below is a code in it.
I think I am doing something wrong. It seems to be too simple for me!

Irena
Capture.JPG
by Jarenka
6 days ago
Forum: Syntax
Topic: How to execute many "programs" at one time?
Replies: 5
Views: 97

Re: How to execute many "programs" at one time?

The most important think is to receive *gdx file with all parameters for each specified section. Usually, I start with running LINE1A_Data and create *gdx file (with the same name usually). Then I run LINE1A_Incomes.gms and create *.gdx file again. And so on ... The point is to run each section inde...
by Jarenka
6 days ago
Forum: Syntax
Topic: How to execute many "programs" at one time?
Replies: 5
Views: 97

How to execute many "programs" at one time?

Dear, I have a couple of sections (see in the attachment, all LINE ...), which I would like to run at one time, not separately as I do it now. Each section contains parameters that might repeat in another section, but not necessary. How to do it in GAMS? My point is to run each of them and create *g...
by Jarenka
1 month ago
Forum: Syntax
Topic: Decimal option in gdx-otput file
Replies: 2
Views: 157

Re: Decimal option in gdx-otput file

Thank you for your answer!!
by Jarenka
1 month ago
Forum: Syntax
Topic: Decimal option in gdx-otput file
Replies: 2
Views: 157

Decimal option in gdx-otput file

Dear, I have not found a similar topic or discussion about gdx-view, so I am creating a new one. I would like to know how I can set up an option that suppresses number of decimals in gdx-file, for example to two. Currently, I have a something like this - see the attached file. gdx-output-employment....
by Jarenka
3 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 909

Re: Structuring of Excel output-file in GAMS

Thank you very much for your help!

Best
Jarenka
by Jarenka
3 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 909

Re: Structuring of Excel output-file in GAMS

Yes, I have already used gdxdump for csv-files and then open them in Access database.

So you mean that txt-files are not a good option as an export file for GAMS, right?

Best,
Jarenka
by Jarenka
3 months ago
Forum: Syntax
Topic: Error: overflow in + operation (addop)
Replies: 3
Views: 232

Re: Error: overflow in + operation (addop)

Hi, it seems that the result of the assignment statement is > 1E300 which causes an overflow. Are you sure that you need such large numbers. And are you sure that you found the right line in your code? With include files this can be tricky, so I suggest to check the line number in the echo print of...
by Jarenka
3 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 909

Re: Structuring of Excel output-file in GAMS

Hi,

I succeeded with Access database, finally. Over 15 mln. rows.
I have no experience in Access. Is it possible to do summations or PivotTable-kind of analysis?

Do you know also, whether there is a possibility to export directly to a txt-file from gdx-file or a csv-file?

Best
Jarenka
by Jarenka
3 months ago
Forum: Syntax
Topic: Structuring of Excel output-file in GAMS
Replies: 26
Views: 909

Re: Structuring of Excel output-file in GAMS

I have found "Data Query" in Excel 2016, see attachment (it did not succeed).
It stopped at around 10,000,000 rows.

I will try with Access, and others.

Thank YOU FOR YOUR HELP !!!