Search found 6 matches

by Job
7 months ago
Forum: Modeling
Topic: Solving the division by zero problem
Replies: 2
Views: 347

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
1 year ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 5697

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
1 year ago
Forum: Syntax
Topic: Excel to gams
Replies: 2
Views: 815

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 urgent help to continue with my pro...
by Job
2 years ago
Forum: Syntax
Topic: excel to gams
Replies: 12
Views: 5697

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
2 years ago
Forum: Syntax
Topic: Writing results to Excel
Replies: 2
Views: 923

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
2 years ago
Forum: Syntax
Topic: Writing results to Excel
Replies: 2
Views: 923

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?