Originally posted by: 1S7T_Rajeev_Namboothiri

Hi,

I have a CPLEX model built in Excel using the Developer Edition of CPLEX. I need to send this model to a client who need to execute the same model with new data. Which CPLEX license should the client purchase and install? Please note that the client doesn't need to build CPLEX models, and only need to execute the already built model in Excel.

Thanks,

Raj

Hi,

I think the client needs to buy CPLEX deployment edition licenses.

Have you used the CPLEX Optimizer Excel plug-in or OPL to build the model ?

regards

Originally posted by: 1S7T_Rajeev_Namboothiri

Thanks for the info, Alex!

I am using the Excel plug-in. Is that available with deployment edition license? Or does the model need to be in OPL for deployment license ?

-Raj

Hi,

the excel plugin is in the deployment version.

I just wanted to make you aware of what is written in the documentation at

IBM ILOG CPLEX Optimization Studio V12.6.0 > Introducing IBM ILOG CPLEX Optimization Studio V12.6.0 > Previous release notes and OPL migration guide > CPLEX previous versions > Release notes for CPLEX Optimizers V12.5 > Conversion notes for all users

Excel connector deprecated

regards

Originally posted by: 1S7T_Rajeev_Namboothiri

Thanks Alex. That was useful information!

I understand that we can read from Excel and write to Excel using OPL. But is it possible to invoke an OPL model within Excel itself, without opening OPL IDE? What I am looking for is a solution where my client just need to open the data in an excel file, optimize within excel itself and have the output written back to the same file.

Hi

yes that is possible and you have an example at

http://www-01.ibm.com/support/knowledgecenter/SSSA5P_12.2.0/ilog.odms.ide.help/Content/Optimization/Documentation/OPL_Studio/_pubskel/globals/eclipse_and_xplatform/ps_opl1092.html

regards