Here’s follow the solution (aimms) to the challenge Port in a Storm (puzzleor).

We need to create the sets docks and groups.

The distances, given in the spreadsheet:

Tip: in the definition, we can fill the matrix with the values.

Another tip: it is easy to exchange indexes. Make sure it does not happen.

The variable has range integer in dimensions (g,d)

Contraints: max docks and the minimum we have to distribute from the groups

Next, the mathematical programming.

We’re minimizing.

FO is the sum of variables times distances.

In the main execution, we write solve port (name of the mathematical programming);

Type F6 to run:

Result is FO = 31, the same as in the excel.

Note that the assignment is different from excel – in this case there’s more than one solution.

The zip file here contains the formulation. And here, the Excel solver version.

Below transcribed the full formulation.

MAIN MODEL Main_Port_in_a_storm

DECLARATION SECTION

SET:

   identifier   :  Docks

   subset of    :  Integers

   index        :  d

   definition   :  {1..3} ;



SET:

   identifier   :  Groups

   subset of    :  Integers

   index        :  g

   definition   :  {1..3} ;



PARAMETER:

   identifier   :  distances

   index domain :  (g,d)

   definition   :  data { ( 1, 1 ) : 1,  ( 1, 2 ) : 3,  ( 1, 3 ) : 2,  ( 2, 1 ) : 2,  ( 2, 2 ) : 2,  ( 2, 3 ) : 1,  ( 3, 1 ) : 3,  ( 3, 2 ) : 2,  ( 3, 3 ) : 1 } ;



PARAMETER:

   identifier   :  max_docks

   index domain :  d

   definition   :  data { 1 : 4,  2 : 7,  3 : 9 } ;



PARAMETER:

   identifier   :  min_groups

   index domain :  (g)

   definition   :  data { 1 : 8,  2 : 5,  3 : 7 } ;



VARIABLE:

   identifier   :  aloc

   index domain :  (g,d)

   range        :  integer ;



VARIABLE:

   identifier   :  fo

   range        :  free

   definition   :  sum((g,d),aloc(g, d)*distances(g, d)) ;



CONSTRAINT:

   identifier   :  c_docks

   index domain :  d

   definition   :  sum(g, aloc(g,d))<=max_docks(d) ;



CONSTRAINT:

   identifier   :  c_groups

   index domain :  (g)

   definition   :  sum(d, aloc(g,d))>=min_groups(g) ;



MATHEMATICAL PROGRAM:

   identifier   :  Port

   objective    :  fo

   direction    :  minimize

   constraints  :  AllConstraints

   variables    :  AllVariables

   type         :  Automatic ;

ENDSECTION ;

PROCEDURE

identifier :  MainInitialization

ENDPROCEDURE ;

PROCEDURE

identifier :  MainExecution

body       : 

  solve port;

ENDPROCEDURE ;

PROCEDURE

identifier :  MainTermination

body       : 

  return DataManagementExit();

ENDPROCEDURE ;

ENDMODEL Main_Port_in_a_storm ;

Ideias técnicas com uma pitada de filosofia:

https://ideiasesquecidas.com/