Dear Gams-Users,

iÂ´m looking for a solution to the mentioned issue. I tried several versions of if-statements, the latest is written below.

Atm iÂ´m getting the Error message: “Uncontrolled set entered as constant”. I have no idea why though… .can someone solve the knot in my mind?

And if someone has a solution or different idea for the problem i would really appreciate your hints!

Thanks a lot!

Parameters

binBHKW_1fx(t) “exceltab. binaervar.”;

binary variables

bin_BHKW_1(t) “BHKW an (1) aus (0)”;

$onecho > BHKW1bin_data.txt

par=binBHKW_1fx rng=BHKW_1!D1:E11 Cdim=1

$offecho

$call GDXXRW.EXE “\fs-2.uni-due.de\sfsoscha\Eigene Dateien\gamsdir\projdir\Gams_IN.xlsx” @BHKW1bin_data.txt

$GDXIN Gams_IN.gdx

$load binBHKW_1fx

$GDXIN

*=== Fix variables to values from Excel file

if( (binBHKW_1fx(t) = 0) or (binBHKW_1fx(t) = 1), bin_BHKW_1.FX(t) = binBHKW_1fx(t); else bin_BHKW_1.FX(t) = na; );

–

To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/daRVP7bjq_gJ.

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.