Search found 6 matches
- 5 years ago
- Forum: Modeling
- Topic: Solving the division by zero problem
- Replies: 2
- Views: 2766
Re: Solving the division by zero problem
You can use manual means of dealing with the problem by ensuring that no variable is absolute zero, like making them 0.0000001.
- 6 years ago
- Forum: Syntax
- Topic: excel to gams
- Replies: 12
- Views: 20469
Re: excel to gams
The codes below turns all my data into "1.000". Please help.
$CALL GDXXRW.EXE Nigeria_data.xlsx par=tyyz rng=sheet2!a1..k10
$GDXIN Nigeria_data.gdx
$LOADDC tyyz
$GDXIN
;
$CALL GDXXRW.EXE Nigeria_data.xlsx par=tyyz rng=sheet2!a1..k10
$GDXIN Nigeria_data.gdx
$LOADDC tyyz
$GDXIN
;
- 6 years ago
- Forum: Syntax
- Topic: Excel to gams
- Replies: 2
- Views: 3256
Re: Excel to gams
This is my codes to transfer data from excel to GAMS. The code works well but the data display is "TRUE" for all cells and when the variables are called the data turns to "1.000" all. Some of the data are actually "1.000", but not all. Please what can I do. I need urgen...
- 6 years ago
- Forum: Syntax
- Topic: excel to gams
- Replies: 12
- Views: 20469
Re: excel to gams
I have similar issues with gdx. First the codes below worked well but changed all the values for set tyyz imported to 1.000, what went wrong? $CALL GDXXRW.EXE Nigeria_data.xlsx par=SAM rng=sheet1!c3..ca79 par=tyyz rng=sheet2!a1..k10 * Open the GDX, import the SAM parameter, close the GDX file $GDXIN...
- 6 years ago
- Forum: Syntax
- Topic: Writing results to Excel
- Replies: 2
- Views: 3131
Re: Writing results to Excel
Okay, thanks. But I tried it without success. Eventually this worked:
Parameter
result9b(*,*) Results reporting
;
result9b(sec,secc) =IOZ(sec,secc);
i.e. passing the sets dimensions to each side.
Parameter
result9b(*,*) Results reporting
;
result9b(sec,secc) =IOZ(sec,secc);
i.e. passing the sets dimensions to each side.
- 6 years ago
- Forum: Syntax
- Topic: Writing results to Excel
- Replies: 2
- Views: 3131
Writing results to Excel
I declared a set as IOZ(sec,secc) and sent the results of an analysis to it. The results display well on the screen but I get error 148 when I tried to create a file with this command Parameter result9(*,*) Results reporting ; result9("IOZ") =IOZ; Can any one help?