TUTORIAL: Draftkings NFL Lineup Optimizer and Projection for Google Sheets! Part 1 HD

My latest video series for DFS! This video series will help you create your very own NFL optimizer to project the days best lineup for you! Good luck everyone! Post your winnings in the comments below! Link to Part 2: https://www.youtube.com/edit?o=U&video_id=5b9pZLUu9I8 Watch me on Twitch : Twitch.tv/Urue_ Add Ons: OpenSolver - https://chrome.google.com/webstore/detail/opensolver/hfikolkpdcamjmmpoamebnahmiinpbfm?hl=en FORMULAS: D2: =IFERROR(vlookup("*"&B2&"*",Projections!$A$2:$H,8,false),0) F2: =IF($E2="QB",$A2*1,IF(OR($E2="RB",$E2="WR",$E2="TE",$E2="DST"),"","")) G2: =IF($E2="RB",$A2*1,IF(OR($E2="QB",$E2="WR",$E2="TE",$E2="DST"),"","")) H2: =IF($E2="WR",$A2*1,IF(OR($E2="QB",$E2="RB",$E2="TE",$E2="DST"),"","")) I2: =IF($E2="TE",$A2*1,IF(OR($E2="QB",$E2="WR",$E2="RB",$E2="DST"),"","")) J2: =IF($E2="DST",$A2*1,IF(OR($E2="QB",$E2="WR",$E2="TE",$E2="RB"),"","")) K2: =IF(OR($E2="RB",$E2="WR",$E2="TE"),$A2*1,IF(OR($E2="DST",$E2="QB"),"","")) A701: =SUM(A2:A696) C701: =SUMPRODUCT($A$2:$A$695,$C$2:$C$695) D701: =SUMPRODUCT($A$2:$A$695,$D$2:$D$695)