Search found 7 matches
- 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.
- 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 ...
- 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.
Could you please check it again.
- 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)$...
- 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...
- 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...
- 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...