Maximise total team score but limited with team value

[Banjaxed]

Hi,

I'm using a dataset of football player scores to try find the highest scoring combinations of players at varying maximum values. Each player has an assigned ID, position, value and score.

I have only been able to return the 1st, 2nd, 3rd etc. highest scores per position so far. Ultimately I would like to be able to change the team value and the best team for that value be calculated.

I have the following columns:
[TABLE="width: 316"]
<tbody>[TR]
[TD="class: xl64, width: 77"]Player ID[/TD]
[TD="class: xl64, width: 61"]Position[/TD]
[TD="class: xl65, width: 94"] Cost Today [/TD]
[TD="class: xl64, width: 84"]Total Points[/TD]
[/TR]
</tbody>[/TABLE]

And I would like to be able to state
GK
DEF
DEF
DEF
MID
MID
MID
MID
FWD
FWD
FWD
and have the player ID returned for the players who maximise the team score for a stated maximum team value.

Basically I want to maximise the team score within the constraints of total team value and the given positions.

Any help would be greatly appreciated!
C

 

[Banjaxed]

Has anyone got any ideas how to go about this?