Author Topic: Spreadsheet of the number of games officiated by every referee in the PL since 1992  (Read 41 times)

0 Members and 0 Guests are viewing this topic.

bmb

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,676
  • Gender: Female
  • Causing mischief & mayhem!!
  • Location: Somewhere between Poole & Budapest!
    • View Profile
    • Hungarian Football
Affy_Moose has a spreadsheet available of the number of games officiated by every referee in the PL since 1992

https://docs.google.com/spreadsheets/d/e/2PACX-1vSN5jQUaboqHQxqooJSsx7lEJrIoo-rbM_G6S4ejvPf3WyzPZz9hBPFrB5zzrTFn1Q-Obzxj3iIFXZo/pubhtml

Quoted post below explains the context & ensures that the credit for the work goes to the right person, Affy_Moose - not me!

If it helps, I have a spreadsheet of the number of games officiated by every referee in the PL since 1992? Easy to deduce from that when officials first/last officiated.

Also have red/yellow cards as well for each season.

If the spreadsheet is online pop a link to it in the Trivia & humour section & I'll sticky it in there, if you would like to of course.  If I sticky it in here then Flip gets his broom out and tidies up after me adding a bunch of sticky threads!

*Just don't tell him I said that or he'll sweep me into the naughty corner again!

Morning @bmb

That's the link now live (just needed to tidy it up, and make sure it was published in a way that didn't include my details).

https://docs.google.com/spreadsheets/d/e/2PACX-1vSN5jQUaboqHQxqooJSsx7lEJrIoo-rbM_G6S4ejvPf3WyzPZz9hBPFrB5zzrTFn1Q-Obzxj3iIFXZo/pubhtml

I used this data to create a few videos on Youtube on referee stats (previously shared here).  If you copy it over to the Trivia section, I'll update with those links too.

The data is presented in a simple table.  That allows it to be pivoted easily into a format that suits for the user's purpose (I can provide some basic guidance if anyone is less familiar with spreadsheets).



« Last Edit: Mon 06 Dec 2021 11:47 by bmb »
HajrŠ LilŠk. Csak a Kispest. HajrŠ Magyarok! HajrŠ jŠtťkvezetői csapat! Soha ne add fel

Share on Facebook Share on Twitter


Affy_Moose

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Thanks for posting this.

I'll keep the spreadsheet up to date (updated each season).  In time, I may try to update with other leagues as well. 

If anyone is interested, the data is visualized in these videos:

- The referees with the most games officiated since 1992:

https://www.youtube.com/watch?v=dFYVrTOlaOY

- The referees with the most cautions since 1992:

 https://www.youtube.com/watch?v=baQR-OzVLq4

- The referees with the most red cards since 1992:

https://www.youtube.com/watch?v=C8DSTcVOq5I

Feel free to DM me with any questions on the data collection, or arranging it into a format that is more useful.

Source: PremierLeague.com

edited just to tidy up how the videos are showing, bmb
« Last Edit: Mon 06 Dec 2021 14:06 by bmb »