Wednesday, January 30, 2013

GAMS to OpenOpt too scary?

›
http://forum.openopt.org/viewtopic.php?id=579 : “This works though I'm worried it might look too scary to my students coming from G...

GAMS/VBScript Tool to view DBF table structure

›
When receiving DBF files I usually look at the structure by loading it into Excel. In this case I received DBF files that were much too larg...
Monday, January 28, 2013

Reading a CSV file

›
This is a difficult CSV file to read using using the GAMS tool GDXXRW: "BARID","BASIN","CAND...

SQL Server and PIVOT/UNPIVOT

›
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx I think the syntax is somewhat confusing, but this thing can be handy. ...
Sunday, January 27, 2013

GAMS sameas problem

›
I tried a construct that looks like the following code: sets    cell5m    cell5m_sp...
Monday, January 21, 2013

GAMS/GDX cannot read scalar from compressed GDX file

›
I encountered a problem when reading a scalar from a compressed GDX file: GDXIN   C:\projects\ulrike - ifpri\gdx\spam...
Friday, January 18, 2013

Excel 1 million row limit

›
Excel 7 (and later) has limit of 1,048,576 rows (before version 7 this limit was 65,536 rows). When using COM automation (using Excel from a...

Book: Complementarity Modeling in Energy Markets

›
http://www.amazon.com/Complementarity-Modeling-International-Operations-Management/dp/1441961224 Looks interesting.
1 comment:
Wednesday, January 16, 2013

Loading large data set into GAMS GDX file

›
For a project we convert data from a humongous table with 23 million records stored in a remote SQL Server database (global spatial grid w...
Sunday, January 13, 2013

C vs javascript

›
The difference between standard C compiled GLPK and the Javascript version seems to be a factor 10. As one could expect the solution path is...
3 comments: