Learn how to Build Bulk Lineups in a Spreadsheet withOUT Solver
Build Lineups Fast in Excel or Google Sheets based on projections
...IF you are someone who likes to play multiple lineups....
...IF you are someone who pays for a lineup optimizer every month...
...If you are someone who likes to look at many possible lineups before choosing theirs...
Then this video course is probably for you!
Building lineups for daily fantasy takes time. You can use a lineup optimizer but those can be expensive and sometimes not user friendly or customizable.
I created a lineup optimizer spreadsheet tool which does NOT use Solver. Just a bunch of formulas!
This tool can create hundred and even thousands of lineups in 10 seconds!
So I created this video course teaching others how they can set it up for themselves. This is 20 short modules walking you through each step.
You can do this whole course in about an hour and have your own lineup optimizer tool!
This course uses Fanduel as the example but it can just as easily be applied to Draftkings. The techniques I teach let you use it for any sport and any fantasy website. You just need to customize the position columns and salary constraints.
**This course is just one section of my full course Spreadsheet School DFS.
What Comes with this Course:
- One hour of videos broken out into 20 bite sized video chunks of 1 to 5 minutes each
- Top Priority Email Support from myself on questions you may get while going through this course.
- The example spreadsheet I used during the videos so you can follow along better
Who is this course for?
- People who want to do their own research to find lineups but want to speed up their process
- People who don't want to use the "expert" picks that they are force fed
- People who enjoy working with data to do their research
- People who want to use past historical data to predict future outcomes
- People who want to advance their knowledge of spreadsheets to improve their odds of winning at daily fantasy
- People who want to save time in their research that they can spend with their family or hobbies.
Who this course is not for:
- People who want to push a button for their lineups and not do any research
- People who expect to win their first Million at daily fantasy without putting in effort
Get started now!
I m writing to thank you. First of I had no knowledge of excel before I started dfs, I looked around for tools that would help me win. That's when I learned about optimizers, then I found out they have a monthly subscription. So I looked around and found your video on how to make an optimizer is the easiest to follow and understand out there. The knowledge you shared has also helped at work that I'm now proficient at excel to make spreadsheets that have greatly increased my productivity.
StartIntroduction - Running Bulk Lineups without Solver (2:20)
StartStep 1-Copying in the Fanduel Salary export (1:11)
StartStep 2- Add in Player info (1:50)
StartStep 3 - Calculate Projected points per Dollar (2:22)
StartStep 4 - Rank each position based on Pts/$ (4:09)
StartStep 5 - Create a Player Pool of the top players (7:37)
StartStep 6 - Randomly Choose Players (3:45)
StartStep 7 - Add in Salary columns for each player (1:52)
StartStep 8 - Add in Projected points for each position (1:49)
StartStep 9 - Add in formula to check for Duplicate Lineups (3:49)
StartStep 10 - Add in length of player names to a new column (2:34)
StartStep 11 - Display only Valid Lineups (3:57)
StartStep 12 - Copy down all the Lineups (2:24)
StartStep 13 - Copy and Paste Special the Final Lineups (1:05)
StartStep 14 - Sort the lineups (1:11)
StartStep 15 - Remove Duplicate Lineups (1:17)
StartStep 16 - Delete rows for lineups you don't want to keep (0:43)
StartStep 17 - Delete all rows on Lineups tab except for top row (2:11)
StartStep 18 - Make a csv lineup Tab (2:46)
StartStep 19 - Find actual Player's used percentage (2:14)
StartStep 20 - Editing the Macro and running it & assigning it to a button (3:20)
StartExcluding Players from your Lineups (0:59)
StartHow to set Salary Minimum from your Lineups (3:20)
StartWhat to do if you get low Lineup Salaries (3:57)
StartHow to Check Team's Player Limits (5:53)
StartHow to Stack a Team (6:42)
StartDraftkings' Dual Positions (6:14)
StartLock Players into Lineups (6:05)
StartHow to Account for FLEX spot (2:56)
Frequently Asked Questions
I was already somewhat proficient with excel as i had taken it back in school but Joe's videos took me to a whole new level and really made me fall in love with spreadsheets and ive been building and tweaking them for a couple of years. Ive been building for pga, nfl, nba and mlb for the most part but really only update the one for mlb and pga on a regular basis. Ive gone from manually cutting and pasting data to making most everything automated (i have to update the FD and DK dats manually daily but the stats auto download which saves me hours daily). At any rate, thank you joe!! - Robby H
Thank you very much for this course. I've learned more so much about spreadsheets that I now have my own projection system. It's helped me to win money in my last few days of NBA games!
I have used Excel spreadsheets for almost 20 years to analyze data and have incorporated that into the world of Daily Fantasy sports. I have created spreadsheet tools for the last 5 years that over 4000 people have used . I also have a Youtube channel where I post some helpful videos and it has over 300,000 views.
This is my 3rd video course I have create around Excel spreadsheets. The first was a course called Master Excel Functions to teach people how to use Excel Formulas and functions. The second was a video course http://www.spreadsheetSchoolDFS.com which teaches people like you how to do better research for daily fantasy much faster.
I am married and have two kids where I spend most of my time. But I love helping people learn Excel and I hope you give me the chance to teach you!