Let's get some content up in here!!

I got tired of jumping between different Survivor season rankings, so I compiled five lists I found online- Purple Rock, Slant Magazine, Collider, BuzzFeed, and EW into a spreadsheet.

Then, I averaged them to create a combined ranking.

Next, I pulled IMDB episode ratings for every season and calculated an average episode rating per season for a different ranked list.

Finally, I put everything into a spreadsheet with color scales for fun visualization.

I'm testing a FOSS spreadsheet editor (not mine), but I can't seem to make the file protected while still allowing filtering/sorting:
47 Survivor Seasons Ranked, online via cryptpad

^^Having url issues where the + is getting converted and breaking the link

Here’s the file itself:
47 Survivor Seasons Ranked

I wonder if there is a way to do this episode by episode to see which players people enjoyed the most. Would be ~20x as much work if you did by hand but if you automated it, would be cool to see that based on the episode & season ratings and who is left each episode

The IMDb part had some automation but the other sources were by hand.
I could probably do similar for episodes.

Ah I was looking up sources for episode ratings and came across this:
https://episodehive.com/tv-shows/survivor-2000