CHP2 : Optimize combined heat and power generation in Excel, using vba API (gamsx, opt and gdx)
In this example GAMS runs only in the background. We use the vba version of the
GDX API to write a GDX file from data defined in the spreadsheet. With the
option object API we set several GAMS options from vba and solve the model using
the gamsx API out of vba. At the end the solution is written into the workbook
using the GDX vba API again.
Files: CHP2.gms chp2.xls
<![CDATA[
$Title Combined Heat and Power Generation
$Ontext
In this example GAMS runs only in the background. We use the vba version of the
GDX API to write a GDX file from data defined in the spreadsheet. With the
option object API we set several GAMS options from vba and solve the model using
the gamsx API out of vba. At the end the solution is written into the workbook
using the GDX vba API again.
$Offtext
$call "start chp2.xls"
]]></plaintext></body></div>