Help with Solver - Modified an existing solver and broke it

[ncknick43]

If anyone could help me I would greatly appreciate it. I have attempted to modify a solver by adjusting values needed, however I think I am throwing it off by asking for values that span multiple constrained areas but do not overlap.

I have attached the sheet I am working on. I am trying to optimize a fantasy NBA lineup while setting my own "values per player" However, the new format allows for not just one per position but also 3 additional that span all guards, all forwards, and then all players entirely and for obvious reasons a player cannot repeat.

Daily Fantasy Cheat Sheet 1 - Basketball.xlsx

Thank you ahead of time for any help.

[Brendan_Floyde]

This might help.

http://www.excelforum.com/excel-form...ml#post3555165

[ncknick43]

Thank you, I used this to create the original but I'm afraid my attempts to modify the sheet to suit my new wants have been unsuccessful

[Brendan_Floyde]

What are the new criteria? and set it out slow as I'm not au fait with basketball! . It was 1 C , and 2 from PF / PG / SF / SG so nine in total , salary less than $60K. From your sheet I can see salary has to be less than $50K but i'm not clear on the positions - looks like 1 C / 2 pf / 2 pg / 2 sf / 2sg / and then one extra from any group so total 10 but your sheet totals to 8 so i'm a bit confused. is their an OR statement in their somewhere?

[ncknick43]

Thanks again for the quick response. The sheet I was modifying is the Optimal Lineup YTD. What I need to extrapolate if a lineup of

• 1 PG
• 1 SG
• 1 PF
• 1 SF
• 1 C
• 1 Guard of any kind
• 1 forward of any kind
• 1 additional from all available as a "Utility"

The selections must total a salary below $50k while producing the maximum number of points based on the Proj column

Again, thank you for your help. I am fairly decent with excel but this one is perplexing me

[Brendan_Floyde]

Check out the attached............

[ncknick43]

This is very close but is allowing too many of a certain position. Also I tried to expand the selection to include 35 options at each position, and renamed cell references but cannot change the binary reference in the solver.

This is the sheet I'm working on with today's available players listed.

[Brendan_Floyde]

I'll add in the 35 rows later (can't upload at work) - you've changed the logic hence your issues.

Logic is (from post #5) ...
PG - Min 1 Max 3 (1 PG + 1 extra guard + 1 utility)
SG - Min 1 Max 3 (1 SG + 1 extra Guard + 1 utility)
SG + PG is a max of 4
SF - Min 1 Max 3 (1 PG + 1 extra forward+ 1 utility)
PF - Min 1 Max 3 (1 PG + 1 extra forward+ 1 utility)
SF + PF is a max of 4
C Min 1 Mac 2 (1 C + 1 Utility)
Total has to be 8


Not sure what logic is on your file - doesn't seem to tie up with post #5.

[Brendan_Floyde]

now with 35 lines per player type