Help creating an optimizing formula

B

brianfarm6767

So what I would like to do is creat a formula, function, or some kind o
program that runs in excel that I can use to optomize a set of values.
would like to use this in many situations, one of which would be to tr
it out in daily fantasy sports leagues to see if using the best possibl
lineups would actually result in wins. What I need this function to d
is take a value (Cost) with regards to the limit I can not go ove
(Salary Cap) and create the best lineup under that (Salary Cap) wit
regards to score. I want it to compare all the players costs with thei
projected outputs and create the best lineup under the salary cap that
can produce. I am just interested if you take away the human side o
selecting favorite players will you do better by just going straigt b
the stats. Any help would be appreciated. Attached is the data I have t
go by

+-------------------------------------------------------------------
|Filename: Untitled.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=725
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex formula 0
Iteration Macro 3
Fantasy Football & Excel VBA 6
Custom Autonumber with Prefix and Category Grouping 3
Needs help combining functions. 3
Multiply with Vlookup value from another Worksheet 0
Adding another if statement to an index formula 0
need help with creating a formula which checks more than 40 cells 1

Top