Search found 7 matches

by Abich1414.
2 years ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 4074

Re: Importing big Excel file to GAMS

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

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.
2 years ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 4074

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.
2 years ago
Forum: Syntax
Topic: set already undercontrol
Replies: 1
Views: 2244

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.
2 years ago
Forum: Syntax
Topic: Command to aggregate parameters
Replies: 2
Views: 2495

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.
2 years ago
Forum: Syntax
Topic: Command to aggregate parameters
Replies: 2
Views: 2495

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.
2 years ago
Forum: Syntax
Topic: Importing big Excel file to GAMS
Replies: 6
Views: 4074

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...