CHP

	[ Home \| Support \| Sales \| Solvers \| Documentation \| Model Libraries \| Search \| Contact Us ]

CHP : Optimize combined heat and power generation in Excel, using vba API (gamsx and opt) and GDXXRW

In this example GAMS runs only in the background. We use gdxxrw to write a GDX
file from data defined in the spreadsheet. With the vba version of 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 a user defined
workbook using gdxxrw again.

Files: CHP.gms chp.xls

$Title Combined Heat and Power Generation $Ontext In this example GAMS runs only in the background. We use gdxxrw to write a GDX file from data defined in the spreadsheet. With the vba version of 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 a user defined workbook using gdxxrw again. $Offtext $call "start chp.xls"