Search found 7 matches

by Abich1414.
1 year ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 3570

Re: Importing big Excel file to GAMS

Thank you very much Micheal it worked now.
by Abich1414.
1 year ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 3570

Re: Importing big Excel file to GAMS

Dear Micheal, the problem happened when I tried to add one more parameter(trade). I ran the following command but the AVEt and AVEnt value become the same while the trade value didn't loaded and just took the value of the AVEnt. I have attached the GDX file for reference. Thanks a lot for your kind ...
by Abich1414.
1 year ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 3570

Re: Importing big Excel file to GAMS

Dear Micheal I appreciate your kind response and I am able to get the GDX file now. But the values of AVE and AVEnt has become the same in the gdx file(it seems it uploaded the AVE value for both the AVE and AVEnt and didn't loaded the the AVEnt value).
Could you please check it again.
by Abich1414.
1 year ago
Forum: Syntax
Topic: set already undercontrol
Replies: 1
Views: 2105

set already undercontrol

Dear GAMS familly, I want to run the following command,but it says set is already under control. I know the problem comes as the indexes I use for SUM in the first overlaps the one I used in the second. But don't know how to fix it. I appreciate if you help me. AAVEt(i,r,s) =SUM((i_org,r_org,s_org)$...
by Abich1414.
1 year ago
Forum: Syntax
Topic: Command to aggregate parameters
Replies: 2
Views: 2327

Re: Command to aggregate parameters

Dear Micheal, Thank you for your dedicated response to GAMS users and sorry for not sharing my attempt. Please have a look at the following code. The problem I faced is the newly created parameter WAAVEt(i,r,s) is not displayed in the GDX file. Here is, the command I used to create the new parameter...
by Abich1414.
1 year ago
Forum: Syntax
Topic: Command to aggregate parameters
Replies: 2
Views: 2327

Command to aggregate parameters

Dear Micheal and GAMS family, I am trying to calculate the aggregated weighted average of parameters of the aggregated regions. But I failed to do that. it is very urgent. Could you please help me?. I have attached the file below and i am grateful if you could help me. I have 3 parameters (AVEt,AVEn...
by Abich1414.
1 year ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 3570

Importing big Excel file to GAMS

Dear GAMS world Family, I was trying to import the file from excel to GAMS. But the value of the parameters are not displayed in the GDX file. Could you help me please where the problem is and how to fix it. Thanks I used the following code. $call GDXXRW AVE.xlsx par=AVEt,AVEnt rng=AVE_technical_GTA...