Friday, February 14, 2014

Excel modeling

When translating an Excel spreadsheet model using Solver into a GAMS model, I came across a construct like:
image
This can be modeled as a linear condition:
image
One disadvantage of using Excel as a modeling vehicle (a major one in my opinion) is that it does not really allow you to think about the model formulation. The formulas are hidden behind cells and the model structure is largely lost. Even easy model reformulations will escape attention.