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

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

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

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

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

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

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

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