EPTSo on a car ride home I was thinking about making a spreadsheet for the FPL. I'm just an regular FPL participant, usually ranking around 500 - 1500 every time. But this time, I wanted to ingratiate the try-hardness in my soul. I actually sat down and looked the lineups.
The most important parts of a successful FPL, as far as I know are:
1. Price
2. Appearance in lineups
3. Skill Level of the player (which should be reflected on the price and appearance most of the time)
And so, I recorded all the prices, appearances (at least for week 1), and the Aligulac rating for each player. Now, Aligulac isn't perfect, but I personally think its a fair estimate for the caliber for each player. And so I finished the spreadsheet, but I'm only in high school, and my amateur skills as a high school student should tell you that I'm not proficient in Google Spreadsheets. And its evident when you see it.
As most FPLers would dream, what if there was a rating system for the Proleague participants? I'm far from being the most experienced person to create a sufficient rating system, but my tryhard soul willed me to. I already had the data down, and I didn't have anything in particular to do on this Saturday afternoon.
There is only logic, and a little bit of trial and error behind some excel formulas. I took about 10 players, all with varying Aligulac ratings, costs, and lineup appearances, and...used trial and error.
I came up with: (Aligulac Rating/1.05^cost)(1.15^lineup)
I won't bother explaining it. I do weight lineup appearances a lot more than the rating and the cost. Because the maximum lineup appearances possible is 2, the rating system is far from sufficient. A player like Reality is definitely not 5th best out of all 80 or so participants in Proleague. But if you don't get placed in the lineup, you can't get points. And if you can't get points, you're not worth choosing.
But someone can be placed in the lineup, and lose every time right? Yep. Which is why I should probably base it on Proleague wins, but I don't have anything to base that on.
As time goes on, the ratings will make more sense. I know the ratings aren't valid, but its worth a shot.
https://docs.google.com/spreadsheets/d/1ujP3QoaP9PfUftpJ1DtJaUHv4j9TylRYWv7z-cWd6IQ/edit#gid=2073440359
+ Show Spoiler +
make your own copy if you'd like to edit
![[image loading]](http://i.imgur.com/CtHsyKi.png)
If anyone can come up with a legitimate FPL formula hmu and we'll rule together.
Suggestions, let me know.
I'll probably update the lineup appearances and pricing every week, if I'm not too lazy.
Edit: I made two different sheets for teams with 1 appearance and 2 appearances since it seems to solve the immediate problem
