Spreadsheet School DFS Blog

Do better research faster for daily fantasy with Spreadsheets

Should you Fade the Top players when there's a potential blowout?

When researching lineups, I hear a lot of people talking about not having much exposure to the top studs on days when they could be blowing out their opponent. Their logic is that when their team is up by a lot, they will sit them. That is good reasoning and it could be true. So what I am...

READ MORE

How to split apart Draftkings Positions into multiple cells

Here is a video I made showing how to split apart cells into multiple cells in a spreadsheet for daily fantasy purposes. I use the Draftkings position as an example. When you download their salary export, you will get positions like PG/SG. That makes it tough for you to use in your research...

READ MORE

Finding Standard Deviation to Determine Risk of players using Spreadsheets

In this video I show you how to use advanced spreadsheet formulas to determine how risky a player is. We determine his standard deviation of scoring to see if there's a wide range or narrow range of scoring. Here is the Excel spreadsheet to download which will help you follow along: ...

READ MORE

Using solver for an NHL hockey Optimal Lineup

In this video I show you how to get an optimal lineup in daily fantasy sports for NHL hockey. I show you the complete setup and the solver constraints that you need to set up.

READ MORE

Vlookup verse Index Match for pulling data for Daily Fantasy sports

In this video I show the difference between using the VLookup function and the more advanced Index-Match functions to pull data from another sheet. I use daily fantasy sports examples.

READ MORE

How to Activate the solver add in

In this video I show the steps you need to take to activate the Solver Add in.

READ MORE

Using Solver to come up with the Flex or Utility spot

In this video I use a baseball example to show how you can set up your spreadsheet to run an optimal lineup that includes a flex spot or a utility spot. Draftkings uses them a lot.

READ MORE

Using Excel Solver for NFL Optimal Lineups

In this video I show you how to come up with optimal lineups with using the Excel Solver Add in.

READ MORE

Using Solver for NBA Basketball Optimal Lineups

In this video I show you how to use Solver to come up with Optimal Lineups for NBA basketball. It is very similar to the baseball and football videos I made, just with the basketball references.

READ MORE

How to Summarize your Solver Results

In this video I show you how to summarize your Solver results. When you run lineups using Solver, you just get a bunch of 0's and 1's. I show you how to pull in name and team and salary to get a easier to read results. Check out the video below:

READ MORE