Search found 4 matches

by pradeep2431
5 years ago
Forum: Syntax
Topic: Error in creating GDX File from Excel Data
Replies: 2
Views: 6573

Re: Error in creating GDX File from Excel Data

Dear Bussieck,

Thank you very much for your polite answer with nice explanation.
I am just a beginner in GAMS and will definitely look for the error log file in future for primary resolution.

Thanks a lot!
Regards
Pradeep
by pradeep2431
5 years ago
Forum: Syntax
Topic: Error in creating GDX File from Excel Data
Replies: 2
Views: 6573

Error in creating GDX File from Excel Data

Hello Experts, I have a 3-dimensional data in Excel, which looks as follows. (Excel is also attached) Capture.JPG I try to import the data from Excel to GAMS by creating a GDX file by the following code. Sets S 'SupplierS' K 'Scenarios' M 'Plants' Parameters q11 (S,K,M) 'Transportation cost from sup...
by pradeep2431
5 years ago
Forum: Modeling
Topic: Error in reading 4 dimensional data from EXCEL to GAMS
Replies: 2
Views: 4318

Re: Error in reading 4 dimensional data from EXCEL to GAMS

Dear Fred,

Thanks a ton!
It works perfectly.
by pradeep2431
5 years ago
Forum: Modeling
Topic: Error in reading 4 dimensional data from EXCEL to GAMS
Replies: 2
Views: 4318

Error in reading 4 dimensional data from EXCEL to GAMS

Hello Experts, I have a 4-dimensional data in Excel as follows. 1. Row 1: Set a with 2 elements, /'Refinery 1','Refinery 2'/ 2. Row 2: Set b with 2 elements, /'Pipeline','Rail'/ 3. Column 1: Set q with 2 elements, /'Warehouse 1','Warehouse 2'/ 4. Column 2: Set r with 3 elements, /'Petroleum','Diesel...