Home

Need help with Solver or a better option

KevinZ
New Contributor

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.

1 Reply
See if =Subtotal(… can be used, as it gives you totals (Avg/Max/Min/Sum etc) based on filtered records. If not, see if Pivot Tables will help. Both could be linked to other tabs.