A
aferguson3
I am trying to come up with a formula on excel and any help would be
much appreciated.
There are 4 columns titled: Player Name, Player Position, Projected
Points, Player Salary.
I have a total of 121 players that consist of Center, Forward and Guard
positions. Each player has a position, projected points value, and
salary value.
I need to know all possible 8 player combinations (lineups) that have
the highest projected point value with a total salary under $100,000.
The 8 player lineup will consist of 2 guards, 2 forwards, 2 centers and
the final 2 can be any of the 3 (utility).
Any help is much appreciated
much appreciated.
There are 4 columns titled: Player Name, Player Position, Projected
Points, Player Salary.
I have a total of 121 players that consist of Center, Forward and Guard
positions. Each player has a position, projected points value, and
salary value.
I need to know all possible 8 player combinations (lineups) that have
the highest projected point value with a total salary under $100,000.
The 8 player lineup will consist of 2 guards, 2 forwards, 2 centers and
the final 2 can be any of the 3 (utility).
Any help is much appreciated