Football Analytics - The Spreadsheet

Discussion in 'Bulletin Board' started by MDG, Aug 28, 2024.

  1. MDG

    MDG Well-Known Member

    Joined:
    Jul 21, 2005
    Messages:
    5,675
    Likes Received:
    4,215
    Trophy Points:
    113
    Location:
    Darton
    Home Page:
    Style:
    Barnsley (full width)
    So working in analytics myself, decided to learn more about football analytical models to identify players.

    I've put together some parameters and then plugged in the dataset from a European division, ranked somewhere between EFL League 1 and the EFL Championship.

    League I selected was the Slovakian top tier (Nike Liga).

    Anyway with various parameters, I've found us a new CF haha.

    Zan Medved, 25 yr old Slovenian. Currently playing for FC Kosice.

    I've included various parameters into the model including things like age group, height, strike rate, approx market value (debatable how accurate this mv source is), no long term injuries, plus others.

    My analytical model will be very primitive in comparison to many of the mature ones clubs use, but I've just used this project to develop my knowledge with python etc.

    So yep BFC should defo buy this lad and tear the division a new one. :eek::D
     
    wakeyred, Kiz and WatfordRed like this.
  2. Dys

    Dyson Well-Known Member

    Joined:
    Jul 13, 2005
    Messages:
    14,096
    Likes Received:
    3,817
    Trophy Points:
    113
    Location:
    Tarn centre
    Home Page:
    Style:
    Barnsley (full width)
    =INDEXMATCH(Good,At,Football,<25years,value<100k,wages("lessthannowt")
     
    MDG, WatfordRed and matthirst9 like this.
  3. Tyke_67

    Tyke_67 Well-Known Member

    Joined:
    May 31, 2013
    Messages:
    14,885
    Likes Received:
    20,510
    Trophy Points:
    113
    Style:
    Barnsley (full width)
    {+(Does_he_know_the_difference_between_Barnsley_and_Burnley):}
     
    MDG and WatfordRed like this.
  4. Wat

    WatfordRed Well-Known Member

    Joined:
    Feb 2, 2013
    Messages:
    1,108
    Likes Received:
    871
    Trophy Points:
    113
    Style:
    Barnsley
    Not quite the same (but i guess somewhat similar) :D

    In 2017, I woke up one day and decided i could be a football scout. Signed up for a free Wyscout subscription. Spent the evening looking through lots of footage of random european players.

    Stumbled upon 22 year old Cyriel Dessers playing in Holland for NAC Breda - scored 22 in 36 for them. Think at the time his market value was around £350-500k.

    I proceeded to message him on twitter asking him if he'd move to England as he'd be a perfect striker for us (he never did get back in touch). :D

    29 now and looks like hes had an okish career and not the worst goalscoring record.

    2016–2017 NAC Breda 36 (22)
    2017–2019 FC Utrecht 40 (12)
    2019–2020 Heracles Almelo 26 (15)
    2020–2022 Genk 38 (10)
    2021–2022Feyenoord (loan) 27 (9)
    2022–2023 Cremonese 26 (6)
    2023– Rangers 38 (19)

    Looks he's had a few transfers since 2017 for 3-4 million too. Probably would have done a job for us :p
     
  5. Jay

    Jay Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    42,587
    Likes Received:
    30,409
    Trophy Points:
    113
    Location:
    On Sofa
    Style:
    Barnsley
    CASE
    WHEN [At_Football] = 'Good' AND [Cheap_As_Chips] = 'true' AND [Agent] = 'Negligent' THEN 'Sormaz'
    WHEN [At_Football] = 'N/A' AND 'Will_Sponsor_Owt' = 'true' THEN 'Flatman'
    ELSE 'JAQ'
    END
     
    Last edited: Aug 28, 2024
    MDG likes this.

Share This Page