Excel Solver ?

Question

Hi Everyone!

Looking for help involving excel solver when creating lineups for DFS (Daily Fantasy Sports) purposes. I currently have everything set up correctly with lineups being generated no problem. The issue I have run into now is that excel does not know to only pick up to 4 players max from each team. Depending on when I run the solver, I could have 4 teams or 16 teams to choose from.

How do I set up a constraint so solver can recognize and choose players accordingly? Below are 2 images to see what I am working with. The first is a snapshot of my excel file and the second is a snapshot of my constraints.

Any help would be greatly appreciated. Thanks!

Answer 1

Thanks for your help!! It definitely makes sense what your saying but when I attempt to add the constraint, I get the below message..What am I doing wrong??

Answer 2

I need to have a look on your workbook to provide you the solution specific to your problem.

Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

You can upload from Onedrive application on your computer.

If you don't have this application,

1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
2. Click Upload in the top OR drag and drop the file here.
3. After uploading, right click the file and choose share.
4. Optional but recommended - Uncheck the Allow Editing
5. Click Get a Link.
6. Copy the link and paste the link here.