[Cmpl] Fwd: CMPL help

[Mike Steglich]

Hello Alexander,

We will be back on this mailing list after Christmas.

Thanks,

Mike

> Am 23.12.2017 um 19:31 schrieb Alexander Buldyaev <alexbuldyaev at gmail.com>:
> 
> Dear colleagues,
> First of all I want to thank creators  for the CMPL Solver for Excel.
> 
> I try to solve one problem which solution in OpenSolver takes several hours.
> I realized small version of the problem in CMPL, however I found that one constraint does not work:
> I need to control capacity constraints by the sum of several cells in Excel, so as  I understand CMPL can not control the change of excel cell which are written by formula.
> 
> The case study:
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 107353 bytes
Desc: not available
URL: <http://list.coin-or.org/pipermail/cmpl/attachments/20171223/02620a26/attachment-0002.png>
-------------- next part --------------
> 
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 17868 bytes
Desc: not available
URL: <http://list.coin-or.org/pipermail/cmpl/attachments/20171223/02620a26/attachment-0003.png>
-------------- next part --------------
> 
> 
> So, can you say me whether It is possible to realize such constraint with Excel formula changed parameter?
> If there is not enough information, I attach xlsm file.
> 
> Thank you in advance!!!
> 
> Best wishes,
> Alexander Buldyaev
> 
> 
> <Copy of CMPL Examples.xlsm>
> _______________________________________________
> Cmpl mailing list
> Cmpl at list.coin-or.org
> https://list.coin-or.org/mailman/listinfo/cmpl