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.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies