Docstoc

LP

Document Sample
LP Powered By Docstoc
					Fill out player data per sheet first and solve the LP problem (model is already completed in Solver per sheet)

Formation     Cumulative amount of submissions
5-4-1                                             2730
5-3-2                                             2894
4-5-1                                             2774
4-4-2                                             2961
4-3-3                                             2934
3-5-2                                             2996
3-4-3                                             3001
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     1
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     0
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     0
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     0
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     1
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           2730

    Used Budget
                   41       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 5 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=5)
                            #Midfielders = 4 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=4)
                            #Forwards = 1 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=1)


    #Goalkeepers        1
    #Defenders          5
    #Midfielders        4
    #Forwards           1




1




2
0




1




2




2
0




0




0
0




0




0




0
0




0




0




0
0
           5-4-1 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     1
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     0
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     0
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     0
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     1
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           2894

    Used Budget
                   43       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 5 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=5)
                            #Midfielders = 3 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=3)
                            #Forwards = 2 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=2)


    #Goalkeepers        1
    #Defenders          5
    #Midfielders        3
    #Forwards           2




1




2
0




1




3




1
0




0




0
0




0




0




0
0




0




0




0
0
           5-3-2 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     0
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     1
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     1
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     0
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     1
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           2774

    Used Budget
                   42       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 4 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=4)
                            #Midfielders = 5 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=5)
                            #Forwards = 1 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=1)


    #Goalkeepers        1
    #Defenders          4
    #Midfielders        5
    #Forwards           1




0




3
0




1




2




2
0




0




0
0




0




0




0
0




0




0




0
0
           4-5-1 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     1
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     0
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     0
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     0
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     1
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     1
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           2961

    Used Budget
                   43       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 4 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=4)
                            #Midfielders = 4 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=4)
                            #Forwards = 2 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=2)


    #Goalkeepers        1
    #Defenders          4
    #Midfielders        4
    #Forwards           2




0




2
0




1




3




2
0




0




0
0




0




0




0
0




0




0




0
0
           4-4-2 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     1
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     0
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     0
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     1
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     1
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     0
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           2934

    Used Budget
                   43       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 4 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=4)
                            #Midfielders = 3 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=3)
                            #Forwards = 3 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=3)


    #Goalkeepers        1
    #Defenders          4
    #Midfielders        3
    #Forwards           3




1




3
0




1




3




0
0




0




0
0




0




0




0
0




0




0




0
0
           4-3-3 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     0
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     1
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     1
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     0
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     1
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     0
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     1
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           2996

    Used Budget
                   43       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 3 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=3)
                            #Midfielders = 5 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=5)
                            #Forwards = 2 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=2)


    #Goalkeepers        1
    #Defenders          3
    #Midfielders        5
    #Forwards           2




0




3
0




1




3




1
0




0




0
0




0




0




0
0




0




0




0
0
           3-5-2 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)
Team 1         Videoton
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Bozovic               4                           134                                     1
Defender 1     Andic                 4                           136                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Elek A.               4                           231                                     1
Midfielder 2   Sandor Gy.            5                           221                                     0
Midfielder 3                                                                                             0
Forward 1      Andre Alves           5                           448                                     1
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 2         Gyor
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Stevanovic            5                           101                                     0
Defender 1     Volgyi                3                           138                                     0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1                                                                                                0
Forward 2                                                                                                0
Forward 3                                                                                                0

Team 3         Kecskemét
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Ribanszki             3                            95                                     0
Defender 1     Balogh B.             3                           210                                     1
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1   Foxi                  3                           352                                     1
Midfielder 2                                                                                             0
Midfielder 3                                                                                             0
Forward 1      Tokoli                4                           187                                     1
Forward 2      Litsingi              3                           118                                     0
Forward 3                                                                                                0

Team 4         Haladas
Position       Name          Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper     Rozsa                 3                            69                                     0
Defender 1                                                                                               0
Defender 2                                                                                               0
Defender 3                                                                                               0
Midfielder 1                                                                                             0
Midfielder 2                                                                                             0
Midfielder 3                                                                                              0
Forward 1                                                                                                 0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 5         Zalaegerszeg
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Miljatovic             3                           238                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Kamber                 3                           173                                     0
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Rajcomar               3                           149                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 6         Debrecen
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Simac                  4                           194                                     1
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Czvitkovics            5                           433                                     1
Midfielder 2   Bodi                   4                           121                                     0
Midfielder 3                                                                                              0
Forward 1      Coulibaly              5                           369                                     1
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 7         Ferencvaros
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Csizmadia              4                           147                                     0
Defender 2                                                                                                0
Defender 3                                                                                                0
Midfielder 1   Schembri               3                           205                                     1
Midfielder 2                                                                                              0
Midfielder 3                                                                                              0
Forward 1      Heinz                  4                            94                                     0
Forward 2                                                                                                 0
Forward 3                                                                                                 0

Team 8         Vasas
Position       Name           Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                                0
Defender 1     Gaspar           3                           105                                     0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 9         Siofok
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1   Tusori           2                           117                                     0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 10
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                                           0

Team 11
Position       Name     Value       Amount of submissions         0 = do not choose 1 = do choose
Goalkeeper                                                                                          0
Defender 1                                                                                          0
Defender 2                                                                                          0
Defender 3                                                                                          0
Midfielder 1                                                                                        0
Midfielder 2                                                                                        0
Midfielder 3                                                                                        0
Forward 1                                                                                           0
Forward 2                                                                                           0
Forward 3                                                                               0

Team 12
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 13
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 14
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 15
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 16
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 17
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 18
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0

Team 19
Position       Name   Value   Amount of submissions   0 = do not choose 1 = do choose
Goalkeeper                                                                              0
Defender 1                                                                              0
Defender 2                                                                              0
Defender 3                                                                              0
Midfielder 1                                                                            0
Midfielder 2                                                                            0
Midfielder 3                                                                            0
Forward 1                                                                               0
Forward 2                                                                               0
Forward 3                                                                               0
    Total budget            Cumulative amount of submissions
                   43           3001

    Used Budget
                   43       Objective function
                            Maximize cumulative amount of submissions (Cell I2 which is SUMPRODUCT(D:D;E:E)

                            Subject to constraints
                            Variable cells in column E = binary
                            Total value <= 43 or 45 (differs per competition!) (SUMPRODUCT(C:C;E:E)<=G2)
                            #Players per team <= 3 (SUM(E3:E12)<=3, SUM(E16:25)<=3 … SUM(E250:259)<=3)
                            #Goalkeepers = 1 (E3+E16….+E250=1)
3                           #Defenders = 3 (SUM(E4:E6+SUM(E17:E19)….+SUM(E251:253)=3)
                            #Midfielders = 4 (SUM(E7:E9+SUM(E20:E22)….+SUM(254:256)=4)
                            #Forwards = 3 (SUM(E10:E12+SUM(E23:E25)….+SUM(257:259=3)


    #Goalkeepers        1
    #Defenders          3
    #Midfielders        4
    #Forwards           3




0




3
0




1




3




1
0




0




0
0




0




0




0
0




0




0




0
0
           3-4-3 formation




ch is SUMPRODUCT(D:D;E:E))




RODUCT(C:C;E:E)<=G2)
=3 … SUM(E250:259)<=3)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:4/25/2011
language:English
pages:92