Fantasy Premier League statistics

Gameweek 3 – FPL dataset with Google Sheet attached

Hi guys, here we go again!

It’s my weekly article (Gameweek dataset) before each gameweek of Fantasy Premier League. It’s the most important one, it’s a base for most of my further conclusions & selections.


How to read this google sheet?

As always right after gameweek I provide you updated dataset with basic data which I hope will be useful for upcoming weeks in Fantasy Premier League. Here’s the key how to cope with it:

FIXTURES – it’s a summary (aggregated sum) of upcoming fixtures difficulty for each team for next 3 gameweeks and for next 5 gameweeks. The difficulty of an opponent is calculated based on: PL table rank, previous 4 gameweeks (form), home or away games, team value and also my own FPL index for each team.

xG [expected goal] – it’s a summary (aggregated sum) of expected goals that will be scored by a team in upcoming 3 or 5 games. The number is calculated based on: xG of a team, xGA of next opponents, home or away game. There are always two values: 1st based on FROM (previous 4 games) and 2nd based on season TOTAL

xGA [expected goals against] – it’s a summary (aggregated sum) of expected goals against the team – that will be scored by opponents in upcoming 3 or 5 games. The number is calculated based on: xGA of a team, xG of all opponents, home or away game. There are always two values: 1st based on FROM (previous 4 games) and 2nd based on season TOTAL


Upcoming fixtures difficulty (next 5 gameweeks):

Eye catchers (best upcoming fixtures):

Wolves
Fulham
Chelsea
West Brom
Burnley
Spurs

Los miserables (worst upcoming fixtures):

West Ham
Arsenal
Newcastle
Leeds
Manchester United
Sheffield United

Here is a link to open this google sheet in a new window [click]

Google spreadsheets:

Below you will find a rank of teams from best to worst in each category (fixtures, xG, xGA):

This spreadsheet presents the same data as the previous one, but shows the specific numbers behind each rank position:

And below you will find predicted results for each game in upcoming gameweek. Remember it’s only a prediction based on historical data. Some events like an early red card can destroy the whole sense of analytics (like it was at St. Marys when Southampton lost 9-0 with Leicester in 2019/20).

Here is a link to open this google sheet in a new window [click]


Join FPL community on Facebook – Join my Facebook group

If you want discuss about FPL with other fans just join our group on Facebook [click]. This group is different than the other, there is no spam and your Facebook wall won’t be full of FPL posts – I promise!

If you like my job and it’s useful for you please share this content on Social Media (buttons below).

Good luck everyone!

18 comments on “Gameweek 3 – FPL dataset with Google Sheet attached

  1. Pingback: The great trio - FPL selections for Gameweek 3 - FPL Analyst

  2. mobile legends hack skin

    Have you ever considered writing an ebook or guest authoring on other
    sites? I have a blog based upon on the same subjects you discuss and would love to have you share some stories/information. I know my audience would enjoy your work.
    If you are even remotely interested, feel free
    to shoot me an email.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *