Spreadsheet School DFS Blog

Use spreadsheets for DFS research

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

How to use Excel solver to create an optimal baseball lineup

In this video I explain how to use Excel Solver to get an optimal lineup for Baseball. Solver is a tool in Excel that crunches numbers and comes up with an optimal lineup. We can input a bunch of players with projected score and salary and Excel will give us an optimal lineup which we would...

READ MORE