Inactive Pivot App

Responding to breaking news about inactive players is crucial to NBA DFS strategy. Figuring out the role changes and beneficiaries of inactives is one of the best ways to unlock value at low- and mid-price levels. While the primary beneficiaries are often the inactive players' backups who are thrust into a starting role, sometimes the value of these role changes can be murky, as ball-handling duties shift, and opposing defenses adjust their defensive focus. We wanted to create an app that objectively explores the re-distribution of fantasy production vacated players who are ruled out on any given night.

App User Guide

  1. Team input: Select team for inactive response evaluation. You can do so by selecting the desired team from the dropdown menu or by typing the desired team's abbreviation and selecting from the dropdown menu.
  2. Player input: Once the desired team is selected, the player input box will populate with players from that team. Select the inactive player(s) you would like to pivot off of; you can select a single or multiple players. When multiple players are selected, the "w/o Inactive" columns will show stats when both players are inactive, not when either player is inactive.
  3. Site input: Select site scoring scheme to compare players over. DraftKings or FanDuel only, can't select multiple.
  4. Columns input: In this input, you can define the statistics that you would like to compare for active players. For each column selected, the output will show a column of active players' fantasy production when the player(s) specified in (2) are active and when they are inactive. The columns "UsgM" and "TSA" are not fantasy counting stats, they are measures of players' offensive usage. "UsgM" is "usage minutes", it is the product of a player's minutes played and their usage rate (which is the percentage of on-court possessions a player takes a shot or records a turnover or assist); "TSA" is "true shots attempted", it is a weighted combination of two-pointers, three-pointers, and free throws a player takes; "Offensive" columns are fantasy points derived from points, three-pointers (DK only), assists, and turnovers; "Defensive" columns are fantasy points derived from blocks, steals, and rebounds; neither "Offensive" nor "Defensive" include the DK double-double or triple-double bonuses. The columns input is defaulted to "Total" fantasy points and games played with and without the player(s) selected in (2).
  5. Comparison type input: In the output, after the columns defined in (4) are displayed, the app calculates and creates column(s) of the difference in active player production and/or usage with and without the player(s) specified in (2). You can view this difference in one of two ways. The default is to view this difference as the raw difference ("Diff."). However, when comparing relative benefit for players of significantly different price points, it might be more informative to compare players marginal production relative to their to their initial production. By selecting "% Diff", these difference columns will display active players production as a percent increase or decrease relative to their production level when player(s) in input (2) are active.
  6. Raw data download button: Clicking this button downloads a .csv file called "ASA Inactive Responder.csv"; this file can be opened in Microsoft Excel. The file contains box score data and game information for all players and games of the team specified in input (2). An additional "Active/Inactive" column shows whether or not the specified players were active or inactive for the game defined in each row.
  7. Columns output: These are the columns that are defined in input (4). The first column in each set is the per-game average (quantity for "Games") of the statistic when the player(s) identified in input (2) are active, the second column when inactive.
  8. Difference column output: Based on difference type specified in input (5), this column displays the difference in fantasy production and/or usage when specified players are active and inactive. In the example above, note the blue arrow next to the column name; every column is sortable, allowing you to find the player with the largest difference in fantasy production or usage when specified players are inactive.