Search found 6 matches

by Job
5 years ago
Forum: Modeling
Topic: Solving the division by zero problem
Replies: 2
Views: 2694

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.
by Job
6 years ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 19246

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
;
by Job
6 years ago
Forum: Syntax
Topic: Excel to gams
Replies: 2
Views: 3148

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...
by Job
6 years ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 19246

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...
by Job
6 years ago
Forum: Syntax
Topic: Writing results to Excel
Replies: 2
Views: 3033

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.
by Job
6 years ago
Forum: Syntax
Topic: Writing results to Excel
Replies: 2
Views: 3033

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?