The MLB Excel Optimizer

PC ONLY. DOES NOT WORK ON A MAC.

 
 

Please note

This version of the MLB Excel Optimizer only works on a PC (Windows, Ubuntu, Linux). The mac version will be coming soon. 

Installation

  1. Click the Download Button above and install the DF Sports Gods MLB Optimizer. You must have the PC version of Microsoft Excel installed on your computer.
  2. Click on the verification email and set your password.
 

 

Using the Excel Optimizer

1. Select "Get Started" on the main page

2. Enter your email you used when you signed up

 

To pull all data needed for algorithm click “Refresh Today’s Data”. After all data is downloaded, you can filter players which you would like to use based on team or injury status. To exclude players from some team select “No” in “Include” column. To eliminate players which have injury tag, set “Eliminate injury level” field to the level of injury which is not acceptable for your players to be in a lineups. Available injury levels are: “Out”, “Doubtful”, “Questionable” and “Probable” respectively So, if you select “Doubtful” level all players which have injury tag “Out” and “Doubtful” level will be removed.

Now, after you set filters for players, click on “Transfer Players” button to move all players to sheets for player analysis and lineups generating.

Batter Analysis Sheet

Based on a bat hand and pitcher throw hand stats, projection and salary we generate sheet where you can see all important stats for batter vs pitcher. Color coding is making easier to notice good and bad matchups for players:

Pitcher Analysis Sheet

Similar to “Batter analysis sheet” we are offering matchup analysis for pitchers. Opponent batter stats are batting stats of opponent team:

Multi Lineups Sheet

This is the sheet where you can generate your lineups. On this sheet you can set few options:

  • Number of lineups to generate
  • The variance between lineups – the higher the value you set the higher variance the lineups will be. If you set variance to 0 you will get lineup with a lot of overlapping players, but they will still be different
  • Force/Exclude players – force player you want in every lineup, or exclude player which you do not want in your lineups
  • Stack players for some team – set team from which you want to stack players. Also, you should set number of players which should be taken for stacking from that team.

Fanduel/Drafktings Lineups Sheets

In these sheets you will get your generated lineups. You will notice that cell for player name is colored in some color, it means that player has some injury status assigned.
Also, if you want to export your lineups you can click on “Export to csv” and lineups will be exported in same folder as MLB_SpreadsheetTool_2017.xlsam.