Playing 100 to 150 lineups in a tournament is one good strategy to win a GPP tournament in daily fantasy. However, getting those lineups can take an incredibly long time. If you do them one by one, it will take you all day. If you use an optimizer, that could sometimes work, but you might not get the range of players you want.
Optimizers will choose players by finding the best projections based on salary. So you may get 90% exposure to certain players just because of their higher projection. While you like them as an option, you might want to limit exposure to 50% of something.
So a third option to getting these bulk lineups is to create a spreadsheet which will give you lineups based on the percentage use you choose.
For example, you may want an even split of 33% for three different centers.
In this tutorial, I am going to show you step by step on how to create a spreadsheet to generate bulk lineups for Golf or MMA. I am using these as examples as they don’t have specific positions, so it makes the tutorial easier to understand.
Step 1. Download the salary export from Draftkings Golf lineups. Click on the tournament and then go to “Export to CSV” at the bottom. Copy and paste the data into columns C to H in your spreadsheet.
Step 2 Make Column B the column where you enter in your percentage of use. Since we have to choose 6 golfers, we should make the total of percentages equal about 600. (6 players times 100% each)
Step 3 In cell I1, enter a formula to sum up the total of column B. This way you know when close to 600. The formula would be =SUM(B:B)
Step 4 Sort columns B through H by Percentage used (Col B). Hilight columns B to H and then go to Data, then Sort and sort by column B descending (Z to A)
Step 5 In column A, we need to add a running total column, to sum up column B.
To do this, put a 1 into cell A2. Then in A3 put the formula =A2+B2. So it adds the prior running total plus the previous percent used. Then in cell A4, put =A3+B3.
Step 6 In columns K to P, you will create your lineups. You will need to setup a formula to pick a random number and then choose one of your golfers with a VLOOKUP.
You will use the formula: =VLOOKUP(RANDBETWEEN(1,$I$1),$A:H,4,TRUE)
What this formula will do is a VLOOKUP which is going to pull a random number between 1 and cell $I$1, which is 601. Then it is going to look for that number in column A and pull in the 4th column which is column D or player name.
You need to be sure to use TRUE at the end of the vlookup so it doesn’t look for an exact match. It looks to find that random number in the range of numbers in column A.
For example, if the random number is 80, will look to the largest number which is less than the random number so it will find 66, which will pull Michael Kim.
Then copy that formula down 5000 to 10000 rows, so you have that many random lineups based on your percentages chosen.
Step 7 Add a column to check if there are duplicates in the lineup. If there ae, we know not to look at that lineup.
In column Q make a column called Dupes and in Q2 enter this formula:
What this formula is doing is checking each player in the lineup against each other to see if any of them equal.
For example in the first row, we see L2 = O2 so in Q2, we get “Y” yo show up. If there were no duplicates, it would show “” which is a blank cell.
Step 8 Add in the Salaries for each player with a VLOOKUP in columns R through W.
We need to add up the total salary to make sure it stays under the site limit of 50,000.
So we use the following formula:
This is looking up each player name in columns K to P and looking in your csv salary export from the site in columns D and E. Then it pulls column 2 with an exact match.
We copy this formula for all 6 players and all the way down to the final row of lineups. Then in column X you sum up the 6 player’s salaries.
Step 9 Add another column to check if it is a good lineup.
What you need to do is in column Y, add an IF statement to check to make sure both these things occur: 1. There are no duplicate players and 2. The salary is 50,000 or less.
We accomplish that with the following formula:
This checks if cell X2, the sum of our salaries is 50000 or less and checks if Q2 is blank. If it says Y for duplicates, then we don’t want those.
So if both those conditions occur, we put a Y in there.
In the above example, we don’t get a good lineup until row 7, where you see a Y in Y7. That’s why we make so many lineups, since many will be ineligible.
Step 10 Use Columns AA to AF to only show the good lineups.
Now that we have a column (Y) which tells us if the lineup qualifies, then we need to only show those good lineups.
We can do that with another IF statement. In columns AA to AF, use the following formula:
This checks is column Y is equal to “Y”. If it is, then its a good lineup and we show cell K2, which is the player we chose. If it is not, then we show a blank.
Copy this over and all the way down. Then it will only show those lineups that qualify as under 50,000 salary and no duplicates.
Then make a column at the end to show their salary if it qualifies or a 0 if it doesn’t.
Step 11 Copy and paste special columns AA to AG to a new sheet. Then sort descending by salary. Then you will have all lineups that qualify. Then scroll down to row 151 and delete all the lineups below it.
Note: Sorting Descending will give you rosters close to max salary however, that may throw the percentages you chose off a bit. If you want to go strictly on the percentages you chose, then don’t sort.
This will leave you with 150 lineups, and all ready to upload into Draftkings.
The percentage of players used will be somewhat close to the percentage you chose. It will not be 100% accurate as it depends on if you have a wide enough range of salaries. But the more range of players salaries you choose, the closer the percentage used will be to what you chose.
Good luck with your lineups!