Fantasy Premier League Tips: Player Value Comparison Spreadsheet

Need Help Picking Players For Gameweek 1 in FPL? Our Own ‘Player Value’ Stat Can Help

headache_man_1
The selection process for our teams can often give us a headache

 

My Player Value Stat Explained…

Picking players at the beginning of each season is always difficult and at times, can be a little stressful if we’re honest with ourselves.

A large majority of us will obsess over our teams, chopping and changing all the way to the gameweek 1 deadline (draft number 162 going in the bin)… One stat I feel that can help make those decisions easier, is ‘Player Value’ – but not as you know it.

Whilst it may make sense, I believe the ‘Player Value’ figure on the official website (points per million: calculated simply by taking the total points and dividing it by the price) doesn’t really represent ‘Player Value’ – it doesn’t take the varying prices paid by FPL managers over the course of a season, average games played or average points per game (PPG) of the players, into account.

It literally just tells you how many points that player will give you per every 1 million you spend, which to me, doesn’t incorporate all the facets that you need to determine whether a player is good value for money or not.

My ‘Player Value’ figure is calculated with these additional bits of information in mind;

                Player Value = PPG divided by median price multiplied by 100

For example; PPM would calculate Groß (28.8) and Milivojevic (28.2) as being better value than Sterling (26.6).

Sterling scored 65 more points than Groß and 85 more points than Milivojevic, playing 4 less games than Groß and 5 less than Milivojevic. Sterling’s PPG (7.98) was also far superior in comparison to Groß (5.04) and Milivojevic (4.21) despite being only £3m to £3.5m more expensive.

By any stretch of the imagination, I’m not pretending like this is an exact science and that my ‘Player Value’ figure is absolute – I just wanted to provide the fantasy football community with another indicator that may help make a difficult selection process a little easier. Points per million is a perfectly acceptable view of ‘Player Value’, but I feel my formula gives a more realistic and representative view of it.

The Spreadsheet

So, I’ve gathered the various stats from the official Fantasy Premier League website of the top 5 goalkeepers, the top 10 defenders, top 15 midfielders and top 10 forwards from last season and calculated a ‘Player Value’ figure using the data I collated.

I’ve also added in the new player prices for the new season to see how the new prices will affect value, if they achieved the same points and stats as they did last year, as a comparative tool.

Hit the link below to see what it looks like and to download yourself a copy >> copy-of-player-value-comparison-fpl

 

Or if you’d prefer, here are the screenshot images:

Top 15 midfielders and top 10 forwards from last year

Screen Shot 2018-07-22 at 08.39.48

Top 5 GKs and top 10 DEFs from last year

Screen Shot 2018-07-22 at 08.40.04

 

keep-calm-and-thanks-for-reading-7

One thought on “Fantasy Premier League Tips: Player Value Comparison Spreadsheet

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: