Solver is a very powerful tool in Excel to come up with optimal results when you have many variables to take into account. One such issue I ran across recently was in trying to create a perfect lineup for my fantasy football team. I have salaries and projected scores along with salary and position constraints.
So I made this video below on how to use Solver to do that. You do not need to understand football. It is universal. This video will help explain how to set up your spreadsheet to use solver, how to set up constraints in solver and how to get results.
Download sample file here: http://optimizelineups.com/wp-content/uploads/2015/11/Sample-file-on-using-Solver.xlsx