tag:blogger.com,1999:blog-593563533834706486.post7370436003681816830..comments2024-03-28T10:35:10.453-04:00Comments on Yet Another Math Programming Consultant: Excel Solver Model conversionErwin Kalvelagenhttp://www.blogger.com/profile/09496091402502236997noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-593563533834706486.post-68096139552829385772009-04-30T10:07:00.000-04:002009-04-30T10:07:00.000-04:00This was a relatively small nonlinear problem so I...This was a relatively small nonlinear problem so I did it largely by hand (used some tools to analyze the spreadsheet and some tools to extract the data in GAMS format). I am involved in another project where we translate a very large spreadsheet with a partial equilibrium model (system of nonlinear equations). This is done with tools where we parse and analyze the formulas and generate GAMS code automatically.<br /><br />I believe Frontline systems provides tools to export an MPS file. <br /><br />In my case I wanted to have a clean, maintainable GAMS model so an MPS file was not appropriate (besides that the model was very nonlinear).Erwin Kalvelagenhttps://www.blogger.com/profile/09496091402502236997noreply@blogger.comtag:blogger.com,1999:blog-593563533834706486.post-53704264971656735272009-04-30T08:40:00.000-04:002009-04-30T08:40:00.000-04:00Erwin,
What was your approach to the conversion?...Erwin, <br /><br />What was your approach to the conversion? Did you "build" the model based on the spreadsheet formulas or is there an automated way of doing it? <br /><br />Can the Solver build a MPS file for export of linear models?<br /><br />Thank you, <br />JoaoMNhttps://www.blogger.com/profile/12517811540934786352noreply@blogger.com