Dear Paul!

How we can execute/Run the .gms file in GAMS IDE using Command prompt and GAMS IDE should not open?.

Are this possible? I never used before but I sow You could.

All the best! andre

02.09.2011, 17:35, “Paul Van der Eijk” :

The next step would be to create a new spreadsheet and a single call to reproduce the problem and put this in a zip file. If attachments are not allowed in this forum, you can mail the file to me: xpauly@gams.com (remove the x and y)

–Paul

On Thu, Sep 1, 2011 at 3:40 PM, N DeForest wrote:

`Thanks for the response, though I don't think that is the source of the problem. I understand what you are saying, the cell references indicate the parameters are one-dimensional (i.e. only from A to B), yet I define them as having 2 dimensions (Cdim=1, Rdim=1). This just arises previous versions of the code I am working with. Some sets got reduced to 1 element only. So in a neater version of the code, these could be represented as 1-d parameters. But in its present form, ParameterA might look like: ParameterA Value Option1 0 Option2 1 Option3 0 This work-around was the case for several parameters in working versions of the code, so it doesn't look like it's causing the problems. Additionally, the parameters I am having trouble with (duplicate entries errors) are all proper 2-dimensional arrays. I'm sorry if I didn't convey that well in my original post, I tried to distill it down as best I could and thus reduced it down to a couple generic statements. In reality, I'm trying to read in about 35 parameters, and the ones I am having trouble with don't necessarily correspond to the ones listed above. On Sep 1, 7:45 am, Paul Van der Eijk wrote: > Looks like the range for parameter A is incorrect: > Par=ParameterA rng=Sheet1!A7:B14 Rdim=1 Cdim=1 > > Should it go to the C column by chance? Like > Par=ParameterA rng=Sheet1!A7:C14 Rdim=1 Cdim=1 > > --Paul > > > > > > > > > > On Wed, Aug 31, 2011 at 8:31 PM, N DeForest wrote: > > Hello, > > > I am having some trouble using GDXXRW to read some values from a > > spreadsheet. I want to emphasize that I have a previous version of > > this code that functions correctly. However, when I shift values > > around/add new parameters to my spreadsheet (and update the cell > > reference accordingly), I receive errors along the lines of: > > > **** There were 12 duplicate entries for symbol ParameterA > > 1: January,0 > > 2: February,0 > > 3: March,0 > > 4: April,0 > > 5: May,0 > > 6: May,0 > > 7: June,0 > > 8: June,0 > > 9: July,0 > > 10: July,0 > > Remaining entries skipped > > > Where ParameterA has a row index and a column index, and the zero > > values shown above appear to be the values of the last element of the > > column index (i.e. the values in the far left column of Parameter A in > > the spreadsheet -- not sure this matters) It's also weird that the > > error above lists some months twice, when the spreadsheet only > > contains one instance of each. > > > Furthermore, the parameters that produce errors are not the ones that > > have been added or edited. All the syntax is the same for previous > > functional version. Only when I add or change locations do I encounter > > this problem. > > > Here's a simplified example of the routine I am using here: > > > $onecho > GDXInput.txt > > Par=ParameterA rng=Sheet1!A7:B14 Rdim=1 Cdim=1 > > Par=ParameterB rng=Sheet1!A17:B26 Rdim=1 Cdim=1 > > Par=ParameterC rng=Sheet1!A29:B31 Rdim=1 Cdim=1 > > Par=ParameterD rng=Sheet1!A34:B42 Rdim=1 Cdim=1 > > $offecho > > > $CALL GDXXRW Input=C:\folder\gdxlink.xlsx @GDXInput.txt > > $gdxin gdxlink.gdx > > > Where gdxlink.xlsx is the spreadsheet with the parameter values and > > all the cell references in the instruction file GDXInput.txt are > > confirmed correct. > > > After I get one or several of the errors as described above, I get > > "Output gdx file deleted" then errors on the line calling gdxin, > > because the file it needs does not exist. > > > I see that the only other mention of this problem on the board uses > > merged cells. To clarify, I have no merged cells in the spreadsheet I > > am reading from. > > > Frankly I have no idea how to proceed. Any advice would be greatly > > appreciated. Thanks > > > -- > > "gamsworld" group. > > To post to this group, send email to <gamsworld@googlegroups.com>. > > To unsubscribe from this group, send email to > > <gamsworld+unsubscribe@googlegroups.com>. > > For more options, visit this group at > >http://groups.google.com/group/gamsworld?hl=en. > > -- > Paul van der Eijk > GAMS Development Corporation > Tel : (202) 342-0180 Fax : (202) 342-0181 > Email: pvandere...@gams.com > Web :http://www.gams.com -- To post to this group, send email to <gamsworld@googlegroups.com>. To unsubscribe from this group, send email to <gamsworld+unsubscribe@googlegroups.com>. For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.`

–

Paul van der Eijk

GAMS Development Corporation

Tel : (202) 342-0180 Fax : (202) 342-0181

Email: pvandereijk@gams.com

Web : http://www.gams.com–

To post to this group, send email to gamsworld@googlegroups.com.

To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.

–

With kindly regards!

Andre Savitsky

E-mail:andresavit@yandex.ru

andre_savit@yahoo.com

–

To post to this group, send email to gamsworld@googlegroups.com.

To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.