Master Spreadsheet! (Category Scoring)

1 August 2018

You’ve just stumbled upon the holy grail of fantasy stats – a master spreadsheet of all PL stats from last season that allows you to fully-customize and tailor to your league’s scoring. Use this wisely and you’ll have a huge leg up on the competition.

How to Use This Spreadsheet

First, download the spreadsheet here.

  1. On the first tab customize the scoring for your league by turning ON/OFF  the categories your league uses. Then select the weighted value for each category. (Generally this will be “1” for each category except goals, which is weighted “2” by default.)
  2. Click on the second tab – “fVals – Overall”. There you will see a ranked list of all players in the league, with their fVal (“fantasy value”).
  3. For a more detailed breakdown of each player’s contribution, you can check the tab “fVals – Categories” and see each individual fVal in every category.
  4. The fVals are based solely on last year’s stats, so while it’s incredibly useful to see this data, bear in mind that it’s just a big picture of the season as a whole. Some players started hot and faded, while others missed large chunks of the season, which negatively affects their fVal.

fVal – What Is It?

fVal stands for “fantasy value” and it is an aggregated data point that indicates a players’ overall fantasy contribution. It’s essentially the player’s averaged z-score across all of your league’s scoring categories.

An fVal of “1” means the player is one standard deviation away from the median of the player pool, which was limited to players who played more than 50% of the available minutes last season.

Just because a player has a negative fVal does not mean that they will hurt your team – it simply means they’re not in the top 50% of all players. Defenders’ z-scores tend to be lower, simply because they do not score or create many goals, and therefore their fVal will suffer.

Goalkeepers’ fVals are calculated vis-a-vis the rest of the goalkeepers, as it would not be very meaningful to judge their goal scoring contribution in relation to forwards.

TL;DR

Higher z-score = good. 😉