The solver will always spit out the lineup with the highest projected fantasy points (optimal lineup). One thing you can do once you generate the optimal lineup is to save that lineup's score (i.e., 295.159) and subtract a small number from it like 0.001, resulting in a new constraint of 295.158. This new constraint could be added to the solver as a maximum allowed projected fantasy points to generate a new unique team. As you generate the second lineup, again subtract 0.001, rerun the solver, and repeat until you have the desired number of lineups. There are a lot of excel forums where people could help guide you in the right direction.
We all appreciate your time and expertise in this video...some items... sometimes you speak to fast to follow...as noted below your photo is blocking some formulas...maybe you could download the complete file here so we can follow all data input...Thanks Bob
It appears you took each player only at their first listed position - is that so? This doesn't account for the multi-position eligibility, which would drastically change the possible outcomes. You would need a to account for the fact the De'Angelo Russell can be played at either PG or SG. You have him only eligible at PG.
On the final step and its giving me"Solver encountered an error value in the Objective Cell or a constraint cell. One of the cells in the worksheet became an error value when Solver tried certain values for the Variable cells"
Is doing all this to develop your own optimizer that much more profitable than using a paid one like roto or fantasy cruncher? at teh end of the day if your own projections are not good then the opto wont get a good lineup right? i want to build a solver but use weighted projections from multiple sites, how would that work?
I seem to get the #VALUE error when entering the function for opponents cell. Any ideas on how to fix? I have already checked for blank spaces and deleted them all but that did not fix the problem
Kind of a waste of time. You don’t explain your formulas hardly at all. Your head is in front of them anyway. And you’ve already done it so we can’t see you enter them
Anything that representative of DvP is useless for nba it’s so much noise in who defends who and pos vs pos SF guards PG and SG often and there is no true C anymore and rarely true PF
This is awesome. My two favorite things - Excel and sports.
Hi Riley, Great Video as Usual. Any chance you could show how to create multiple Line Ups with the projections using Solver? Thanks
The solver will always spit out the lineup with the highest projected fantasy points (optimal lineup). One thing you can do once you generate the optimal lineup is to save that lineup's score (i.e., 295.159) and subtract a small number from it like 0.001, resulting in a new constraint of 295.158. This new constraint could be added to the solver as a maximum allowed projected fantasy points to generate a new unique team. As you generate the second lineup, again subtract 0.001, rerun the solver, and repeat until you have the desired number of lineups. There are a lot of excel forums where people could help guide you in the right direction.
We all appreciate your time and expertise in this video...some items... sometimes you speak to fast to follow...as noted below your photo is blocking some formulas...maybe you could download the complete file here so we can follow all data input...Thanks Bob
Could you make an update on how to optimize lineups since fanduel has update the positioning eg PG/SG
It appears you took each player only at their first listed position - is that so? This doesn't account for the multi-position eligibility, which would drastically change the possible outcomes. You would need a to account for the fact the De'Angelo Russell can be played at either PG or SG. You have him only eligible at PG.
Great video Riley, is there anyway to get the full formulas for the ID Column & for the bottom matrix where the selected players show?
Great stuff! Do you have any suggestions on limiting players on the same team? What if I wanted spread out my risk and take only one player per team?
Can you please help me with updating my sheet. It’s already built, but I need help updating
On the final step and its giving me"Solver encountered an error value in the Objective Cell or a constraint cell. One of the cells in the worksheet became an error value when Solver tried certain values for the Variable cells"
Is doing all this to develop your own optimizer that much more profitable than using a paid one like roto or fantasy cruncher? at teh end of the day if your own projections are not good then the opto wont get a good lineup right?
i want to build a solver but use weighted projections from multiple sites, how would that work?
Hi Riley, enjoy your videos. Is there a way to contact you for a specific question on a formula?
I seem to get the #VALUE error when entering the function for opponents cell. Any ideas on how to fix? I have already checked for blank spaces and deleted them all but that did not fix the problem
Your head is hiding the formulas.
Can you repost this and move your face video? Its blocking the formulas
Kind of a waste of time. You don’t explain your formulas hardly at all. Your head is in front of them anyway. And you’ve already done it so we can’t see you enter them
I agree with this guy. I was following all the way until you set up your optimal lineup.
Anything that representative of DvP is useless for nba it’s so much noise in who defends who and pos vs pos SF guards PG and SG often and there is no true C anymore and rarely true PF
dude id pay money for a copy of this