Page 1 of 1

502 and 510 error

Posted: Fri Nov 15, 2013 9:02 pm
by Archiver



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.

Re: 502 and 510 error

Posted: Fri Nov 15, 2013 10:41 pm
by Archiver

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.


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

Re: 502 and 510 error

Posted: Fri Nov 15, 2013 11:19 pm
by Archiver

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 .

--

Re: 502 and 510 error

Posted: Fri Nov 15, 2013 11:21 pm
by Archiver

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.




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

Re: 502 and 510 error

Posted: Sun Nov 17, 2013 5:51 pm
by Archiver


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+...@googlegroups.com.
To post to this group, send email to gams...@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.




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

Re: 502 and 510 error

Posted: Wed Mar 17, 2021 4:41 pm
by farima
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? :roll: :(
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 ;

Re: 502 and 510 error

Posted: Thu Mar 18, 2021 8:00 am
by bussieck
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