[Cmpl] Fwd: CMPL help

[Steglich, Mike]

Hallo  Alexander,



You use the parameter flag_pod[i], which is defined in Excel and the 
SolverStudio data editor, but you have forgotten to specify the entire array 
in the %data entry:



%data : podr set, shop set, reg_fl set, check[podr,shop], flag_sh[shop], 
reg_cap[reg_fl],  rank[podr], res[podr], checked[podr,shop], 
flag_pod[reg_fl]



I miss in this constraint  a variable. You only compare parameters.

supplies {i in reg_fl: flag_pod[i] <= reg_cap[i];}



Thanks,





Mike



Von: Cmpl [mailto:cmpl-bounces at coin-or.org] Im Auftrag von Alexander 
Buldyaev
Gesendet: Samstag, 23. Dezember 2017 19:31
An: cmpl at list.coin-or.org
Betreff: [Cmpl] Fwd: CMPL help



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:









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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.coin-or.org/pipermail/cmpl/attachments/20171228/19f0aed4/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 216091 bytes
Desc: not available
URL: <http://list.coin-or.org/pipermail/cmpl/attachments/20171228/19f0aed4/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 131451 bytes
Desc: not available
URL: <http://list.coin-or.org/pipermail/cmpl/attachments/20171228/19f0aed4/attachment-0003.png>