Okay, so I was messing around with this “PL ratings” thing today, and I figured I’d share my little adventure. It wasn’t super complicated, but it had a few steps that might be useful for someone else trying to do the same thing.
First, I needed to actually get my hands on some data. I mean, you can’t rate something if you don’t have anything to rate, right? So, I spent some time gathering all the info. In my case I use data from Premier League, I have a list about their full name, short name, rating score and the position from table. Let’s say I had a table.
Getting Started: The Data
The structure data that i have:
- Full Name
- Short Name
- Rating Score
- Position
I put everything into a simple spreadsheet to keep it organized. This made it way easier to work with later on.
The Process
Once I had my data, I started playing around to find a formula. There are a lot of different methods. Initially, I wanted to do the manual calculation first and see if it worked before automating it, since I didn’t find any resources that clearly explain how to make the formula.
After experimenting for a while, I finally found a formula that suited my data:
I took the Rating Score and then multiplied by their Position. To avoid the bias from the result (since the best position is 1, and it’s lower than 20) I have to swap the position, The Top Position (1) become (20), and then (2) become (19), so on.
So for example, if Man City has a Rating Score of 9.2 and is in position 1, I swapped the position to 20. Then, I did this:
9.2 20 = 184
Then, I did the same thing to the other teams.
The Results
After all that, I had my ratings! It wasn’t rocket science, I know, but it felt good to go from having nothing to having a system, no matter how simple. And hey, maybe this will save someone else a bit of time if they’re trying to do something similar.
