Andrew0605
New Member
- Joined
- Oct 6, 2015
- Messages
- 7
For my statistics class, my term project is determining whether statistics can actually help predict sports. I had read a few articles regarding this so I thought I would see if I could use excel to help. I need to build a function that can optimize multiple lineups for me. I actually need to build two separate ones. I have been studying about Solver but I am not sure it can do more than one optimal lineup. I have also been reading about building a matrix but I am not sure if I am on the right track.
I have two spreadsheets that shows the data I need to optimize and the format I need to get it into. Is there some way that I can attach those spreadsheets here? They are actually pretty simple and I am pretty sure it would be much easier to see the data.
Basically, I have five categories of players. They will range between 5-40 players per category. I have their cost, their projected points and then want to build the top 100 lineups, subject to some constraints. The constraints include the number of times to use a player, how many players from each category and total cost for the entire team.
Thank you so much for your help. This is so much more work than I had thought and my due date is fast approaching.
I have two spreadsheets that shows the data I need to optimize and the format I need to get it into. Is there some way that I can attach those spreadsheets here? They are actually pretty simple and I am pretty sure it would be much easier to see the data.
Basically, I have five categories of players. They will range between 5-40 players per category. I have their cost, their projected points and then want to build the top 100 lineups, subject to some constraints. The constraints include the number of times to use a player, how many players from each category and total cost for the entire team.
Thank you so much for your help. This is so much more work than I had thought and my due date is fast approaching.
