When you are using Solver to pick lineups for Mixed Martial Arts (MMA), it is only looking at projected points. Two people who face eachother may have similar projected points, but the person that wins will score more points. So when you pick lineups, you may not want to have both people who face eachother in the same lineup.
Example File: lineup
To do this, it really only takes a few steps. What we will basically do is look at the the person who is projected for less points per dollar and make their projection 0. So this way Solver won’t pick up both people in a match.
First, copy in your draftkings Salary into a spreadsheet.
Next, add a column and use the formula =Projected Points/Price . In our example below we used : =E2/C2
Copy that down and then sort from high to low.
Next, we will add a column in col H called Count. What this is going to do is to look at all the cells above this row in Column D and look for a match. This would mean that this person’s opponent has a higher points per dollar ratio.
To do this, go to cell H3 and enter the formula: =COUNTIF(D$2:D2,D3) What this does is look at the range D$2 to D2 and counts how many times the value in D3 appears, which is the match.
Copy this formula down. We need to put a dollar sign in front of the first 2 in the range so it always stays at D$2. When we copy this down to cell H4, we would then get the formula: =COUNTIF(D$2:D3,D4) This one is looking in D2 and D3 and counting how many times D4 shows up.
Next, in col I we make a column called “New Projection”. Here we look at column H and if they are the higher ranked person, we use their projection and if they are the lower ranked person, we make their projection 0.
To do this, in cell I3 we put the formula: =IF(H3=1,0,E3) This is looking at H3 and if it equals 1, then that means they are the lower ranked person and we should use a 0 for their projection. Otherwise, then use their projection.
So now we have created a new column of projections which we would then need to use for the rest of your Solver solution. I won’t go over that, but you can learn how to use Solver for DFS at
Then when the next week comes, you just need to add the new Draftkings Salary file and then sort from high to low in column G for Proj/$.