Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn how to Build Bulk Lineups in a Spreadsheet withOUT Solver
Introduction and Downloads
Introduction and Downloads
How to create Bulk Lineups withOUT Solver
Introduction - Running Bulk Lineups without Solver (2:20)
Step 1-Copying in the Fanduel Salary export (1:11)
Step 2- Add in Player info (1:50)
Step 3 - Calculate Projected points per Dollar (2:22)
Step 4 - Rank each position based on Pts/$ (4:09)
Step 5 - Create a Player Pool of the top players (7:37)
Step 6 - Randomly Choose Players (3:45)
Step 7 - Add in Salary columns for each player (1:52)
Step 8 - Add in Projected points for each position (1:49)
Step 9 - Add in formula to check for Duplicate Lineups (3:49)
Step 10 - Add in length of player names to a new column (2:34)
Step 11 - Display only Valid Lineups (3:57)
Step 12 - Copy down all the Lineups (2:24)
Step 13 - Copy and Paste Special the Final Lineups (1:05)
Step 14 - Sort the lineups (1:11)
Step 15 - Remove Duplicate Lineups (1:17)
Step 16 - Delete rows for lineups you don't want to keep (0:43)
Step 17 - Delete all rows on Lineups tab except for top row (2:11)
Step 18 - Make a csv lineup Tab (2:46)
Step 19 - Find actual Player's used percentage (2:14)
Step 20 - Editing the Macro and running it & assigning it to a button (3:20)
Extra- Optional Steps
Excluding Players from your Lineups (0:59)
How to set Salary Minimum from your Lineups (3:20)
What to do if you get low Lineup Salaries (3:57)
How to Check Team's Player Limits (5:53)
How to Stack a Team (6:42)
Draftkings' Dual Positions (6:14)
Lock Players into Lineups (6:05)
How to Account for FLEX spot (2:56)
Teach online with
Step 7 - Add in Salary columns for each player
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock