I'm trying to create the optimum lineup for a fantasy football league given specific point projections and estimated costs. I'm trying to have excel choose 1 quarterback from a list, 1 running back, 2 wide receivers, and 1 tight end. Each positional column has associated costs and projected points with them. The idea is to choose the 1 quarterback, 1 running back, 2 wide receivers, and 1 tight end that totals THE MOST projected points given a specific estimated TOTAL COST threshold.
For example:
Quarterback (choose 1)
Player 1 250pts $50
Player 2 200pts $40
Player 3 150pts $30
Player 4 140 pts $10
Running back (choose 1)
Player 1 160pts $55
Player 2 140pts $45
Player 3 125 pts $30
Player 4 115 pts $10
Wide receiver (choose 2)
Player 1 300 pts $30
Player 2 200 pts $20
Player 3 100 pts $10
Player 4 75 pts $5
Tight end (choose 1)
Player 1 100 pts $20
Player 2 75 pts $15
Player 3 50 pts $10
Player 4 40 pts $5
Based on the above example I want to know how to make excel choose 1 player out of the quarterback column, 1 player from running back, 2 players from wide reciever, and 1 from tight end, that will have the most COMBINED points while costing less than a given threshold ($165) given their associated prices.
For example:
Quarterback (choose 1)
Player 1 250pts $50
Player 2 200pts $40
Player 3 150pts $30
Player 4 140 pts $10
Running back (choose 1)
Player 1 160pts $55
Player 2 140pts $45
Player 3 125 pts $30
Player 4 115 pts $10
Wide receiver (choose 2)
Player 1 300 pts $30
Player 2 200 pts $20
Player 3 100 pts $10
Player 4 75 pts $5
Tight end (choose 1)
Player 1 100 pts $20
Player 2 75 pts $15
Player 3 50 pts $10
Player 4 40 pts $5
Based on the above example I want to know how to make excel choose 1 player out of the quarterback column, 1 player from running back, 2 players from wide reciever, and 1 from tight end, that will have the most COMBINED points while costing less than a given threshold ($165) given their associated prices.
Last edited:
