[Cmpl] Reading an Excel table into CMLP-Coliop4

[H RC]

Any possibility to include ODBC driver reading capabilities in CMLP-Coliop4?



It would be great to have something like the following n-tuple loading
(from GLPK), “Ways” is the name of a sheet in the excel file
“DataModel_PlanB3.xls”, the sheet has headings PRODUCT, ORIGIN, DESTINATION
& MEAN with data from within previously read sets P,D and M, the data are
under the COST and CMAX headings:



param datamodel, symbolic := 'DataModel_PlanB3.xls';



param CAP{p in P,i in D, j in D, m in M} default  0;



param CT{p in P,i in D, j in D, m in M} default 999 ;



set field4 dimen 4;

table MD IN 'ODBC'

  'DRIVER={Microsoft Excel Driver (*.xls)};dbq='& datamodel

  'SELECT * FROM [Ways$]' :

field4 <- [PRODUCT, ORIGIN, DESTINATION, MEAN], CT ~ COST, CAP ~ CMAX;



Also CLP (ver. CLP-1.16.11) is not included as a solver, but seems to be 1
order of magnitude better than CBC (according to Mittelmann) and the most
reliable and fast open source LP optimizer; are you considering including
CLP for LPs?



Best regards,



Humberto Ramírez C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.coin-or.org/pipermail/cmpl/attachments/20181205/cfb34c85/attachment.html>