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
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
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.
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?
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 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
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"
16 Comments
Your head is hiding the formulas.
Can you repost this and move your face video? Its blocking the formulas
Hi Riley, Great Video as Usual. Any chance you could show how to create multiple Line Ups with the projections using Solver? Thanks
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
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
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.
Hi Riley, enjoy your videos. Is there a way to contact you for a specific question on a formula?
This is awesome. My two favorite things – Excel and sports.
Great video Riley, is there anyway to get the full formulas for the ID Column & for the bottom matrix where the selected players show?
Could you make an update on how to optimize lineups since fanduel has update the positioning eg PG/SG
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?
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
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?
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
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"