I am not sure if this can be done in solver or if there is something better to use.
I am querying a large data set of golf stats from multiple excel spreadsheet into 1 combined stats spreadsheet for fantasy golf. Now that I have that, I want to analyze the data to get the bet options. Below is my info.
My objective - Maximum Score. I have 2 different custom scores I am looking at, I will decide on which one to use after analysis
Item to Change - Golfers. Can be either the name, identifier or combo
Constraints
Must chose only 6 golfers
Max $ spent
Min $ spent
Number of Lineups to create - 1 to XXX
I will be choosing a subset of X number of golfers from X number of entries (i.e. 45 of 150) for consideration
I would also like to set a maximum number of times to use each (i.e. Golfer A max 6 times, Golfer B max 3, etc.)
When solved, I would like the results on a separate tab in separate cells:
G1, G2, G3, G4, G5, G6, Total Score, Total Cost.
Any help is greatly appreciated.
