NFL Fantasy best projections with salary cap HELP

Originally Posted by HerryMarkowitz

Welcome to forum...
Instead of explaining all you want to do start asking specific question with example excel file...

I don't know very much about excel. Just basic formulas so I'm not sure what specifics to ask.

anyone? any help would be appreciated...

yeah basically using it for fanduel... i would have a master list of players, i could have it split up in different tables based on their position or list all players together...i will input their projected points and salaries...no formula would be needed to create a projection...the tricky part is pulling the correct number of players from each position while staying under the total salary cap...ive been doin some research for acouple days now, i thought i was getting somewhere but trying to get the best possible outcome of projected points based on salary cap is killing me! haha....

thanks for wanting to help..

http://www.2mugsff.com/content/findi...-lineup-week-1

what this guy has done is exactly what i want to do! haha

this is also exactly what i want to do, but i want to input my own projections...

http://www.rotowire.com/daily/nfl/optimizer.htm

after 24 hours i completed what i needed to do....self taught, how about that lol...thanks for no help from here..just kiddin...if anyone would like to see my masterpiece let me know!

it averages projected points from 3 sources and calculates the best possible combination for a FanDuel starting lineup while staying under the $60,000 salary cap...has an injury update, exclude option...very very customizeable..i love it

hey lbofbb, (or anyone else who would like to help)

I'm working on something similar and could use some help. I'm not looking for the tool to optimize a lineup, but to give me every combination of rosters that are <=$60,000 based on a player pool of "x". I'm thinking the solver tool is what I need to use, but so far haven't had any luck.

Here's the data set I'm testing with.

Peyton Manning QB $10,200
Philip Rivers QB $9,100
Jay Cutler QB $8,500
Marshawn Lynch RB $9,200
Matt Forte RB $9,000
Giovani Bernard RB $8,700
Le'Veon Bell RB $8,600
Alshon Jeffery WR $7,700
Roddy White WR $7,200
Steve Smith WR $7,200
Julian Edelman WR $7,200
Desean Jackson WR $7,100
Wes Welker WR $6,800
Kendall Wright WR $6,700
Keenan Allen WR $6,700
Anquan Boldin WR $6,300
Larry Fitzgerald WR $6,300
Owen Daniels TE $5,300
Zach Ertz TE $5,200
Scott Chandler TE $5,000
Mychal Rivera TE $4,700
San Diego Chargers DEF $5,600
Arizona Cardinals DEF $5,300
Denver Broncos DEF $5,000
Detroit Lions DEF $5,000
Justin Tucker K $5,300
Phil Dawson K $5,300

Need 1 of each QB, TE, K, DEF
Need 2 of RB
Need 3 of WR

Hi pmdvert

Perhaps a solver model like this?

Alf

Hi, I would like to see what you did if you dont mind. rph16 at yahoo.

Thanks!

Not sure who you are asking for what information. Would you care to explain a bit more.

Alf

Alf - in your file, how did you get the solver to highlight the solution?

Sorry about the delay but I've had problems accessing the forum the last days.

To highlight the solution I've used "Conditional Formating". To see the rules I set up select one cell in the range B2:B201 and then click on "Conditional Formating" (home tab) and then click on "Manage Rules". Then you will see how the rules for the different colors are set up.

Alf