On Thursday, November 14, 2013 10:34:17 PM UTC+3:30, Ela wrote:
hi dear my friends
i write a gams model but it has two errors that i do not recognize them , please help me .
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
Hi
Please attach your GAMS code
On Fri, Nov 15, 2013 at 10:32 PM, Ela wrote:
On Thursday, November 14, 2013 10:34:17 PM UTC+3:30, Ela wrote:
hi dear my friends
i write a gams model but it has two errors that i do not recognize them , please help me .
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
Hi
Some of your mistakes:
1- if you use an excel file in .xls file you have to save it ins workbook 97-2003 format!
2- in use of "GDXIN Workbook.xls" shouldn't write path for excel file(E:\Data.xls). because the .gdx file will save in gams directory.
3- Statements which contain must use in first column.
4-in excel file u must row and column’s name as it defines in gams.
5-range of data which is introduced to gams must contain both data and indeces.
and …
On Sat, Nov 16, 2013 at 12:11 AM, A.R. Bahari wrote:
Hi
Please attach your GAMS code
On Fri, Nov 15, 2013 at 10:32 PM, Ela wrote:
On Thursday, November 14, 2013 10:34:17 PM UTC+3:30, Ela wrote:
hi dear my friends
i write a gams model but it has two errors that i do not recognize them , please help me .
–
data.xls (25 KB)
Revised.gms (2.41 KB)
Hi
Some of your mistakes:
1- if you use an excel file in .xls format you have to save it ins workbook 97-2003 format!
2- in use of "GDXIN Workbook.xls" shouldn't write path for excel file(E:\Data.xls). because the .gdx file will save in gams directory.
3- Statements which contain must are used in first column.
4-in excel file u must use row and column’s name as it defines in gams.
5-range of data which is introduced to gams must contain both data and indices.
and …
On Sat, Nov 16, 2013 at 12:49 AM, A.R. Bahari wrote:
Hi
Some of your mistakes:
1- if you use an excel file in .xls file you have to save it ins workbook 97-2003 format!
2- in use of "GDXIN Workbook.xls" shouldn't write path for excel file(E:\Data.xls). because the .gdx file will save in gams directory.
3- Statements which contain must use in first column.
4-in excel file u must row and column’s name as it defines in gams.
5-range of data which is introduced to gams must contain both data and indeces.
and …
On Sat, Nov 16, 2013 at 12:11 AM, A.R. Bahari wrote:
Hi
Please attach your GAMS code
On Fri, Nov 15, 2013 at 10:32 PM, Ela wrote:
On Thursday, November 14, 2013 10:34:17 PM UTC+3:30, Ela wrote:
hi dear my friends
i write a gams model but it has two errors that i do not recognize them , please help me .
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
Dear Alireza
I thanks so much of you , i learned new things about GAMS .
good luck.
On Saturday, November 16, 2013 12:51:14 AM UTC+3:30, Alireza Bahari wrote:
Hi
Some of your mistakes:
1- if you use an excel file in .xls format you have to save it ins workbook 97-2003 format!
2- in use of "GDXIN Workbook.xls" shouldn't write path for excel file(E:\Data.xls). because the .gdx file will save in gams directory.
3- Statements which contain must are used in first column.
4-in excel file u must use row and column’s name as it defines in gams.
5-range of data which is introduced to gams must contain both data and indices.
and …
On Sat, Nov 16, 2013 at 12:49 AM, A.R. Bahari wrote:
Hi
Some of your mistakes:
1- if you use an excel file in .xls file you have to save it ins workbook 97-2003 format!
2- in use of "GDXIN Workbook.xls" shouldn't write path for excel file(E:\Data.xls). because the .gdx file will save in gams directory.
3- Statements which contain must use in first column.
4-in excel file u must row and column’s name as it defines in gams.
5-range of data which is introduced to gams must contain both data and indeces.
and …
On Sat, Nov 16, 2013 at 12:11 AM, A.R. Bahari wrote:
Hi
Please attach your GAMS code
On Fri, Nov 15, 2013 at 10:32 PM, Ela wrote:
On Thursday, November 14, 2013 10:34:17 PM UTC+3:30, Ela wrote:
hi dear my friends
i write a gams model but it has two errors that i do not recognize them , please help me .
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
Hello everyone,
I faced with a problem. I want to call some data from Excel, and i did it for some of my parameters in this model using same excel file. however, now i faced with a problem for calling this parameter (error 502 and 510), could you please help me? 
the part of y code is pasted there
tnx a lot
parameter TCS(f,l,i,t) ;
$call gdxxrw.exe data.xlsx par=TCS rng=sheet6!A1:BK32 rdim=2 cdim=1
$gdxin data.gdx
$load TCS
$gdxin
display TCS ;
It’s hard to help without being able to reproduce a problem, but in this case one problem is obvious: The gdxxrw ask for a 3 dimensional parameter (rdim+cdim=2+1=3) while your GAMS parameter has 4 dimensions: f,l,i,t. That can’t work.
-Michael