GAMS World Forum

Tanks for your time and your help.

It helped a lot.

Thank you for the explanation. Actually I would like to either use gdxxrw or PandasExcelReader with GAMS connect, but my tables in Excel are already formated in a way, that the importing tool should consider the content of a spreadsheet as Text. Examples: table3.png table1.png table2.png Than ranges...

I'm trying to exclude equation e1(i) from a model at compilation time. The value the exclusion depends on is written in an Excel-file. See example: * Definitions set i /i1/; scalar pEnable /0/; variable obj; equation e1(i), e2(i); $inlineCom { } * Mathematical Formulation e1(i){$pEnable}.. obj =e= 0...

Thank you so much for your help. Now another question popped up. I wanted to exclude the equations at compile time to check how much faster the compile time gets. Problem is, I also have ex post calculations after the model is solved. This includes the dual value of equations like that: set i /i1/; ...

In very large models, does it make a performance difference if I squeeze out the equation at combile time set i /i1/; e1(i).. obj =e= 0; e2(i).. obj =e= 0; model m / all -e1 /; solve m min obj using lp; or do it that way? set i /i1/; scalar pEnable /0/; e1(i)$pEnable.. obj =e= 0; e2(i).. obj =e= 0; ...

Thank you very much Michael.

This clearifies my question (and gives a good tip).

Hey, in my model I have a few equations that are turned on or off by parameters like: eTest$[pEnable].. sum[a, vGeneration(a)] =l= sum[a, pDemand(a)] ; So this equation only gets activated, when pEnable is set to 1 (or anything other than 0). In the .lst file, some of the equations that are turned o...