I gathered 25 sources' rankings of their favorite indie games and combined all of the lists to create a more accurate measurement of "the best."
I gathered 25 sources' rankings of their favorite indie games and combined all of the lists to create a more accurate measurement of "the best." These sources ranged from Steam's Top 250 by user rating to just single YouTuber tier lists of their personal 50 favorites. I used rank-based voting here to assign each game's list position with a "point" value (where #100 on the list gets 1 point, and #1 on the list gets 100 points) for all sources. In spreadsheet 1 (Indies Votes), we just have the raw data in Columns B-Z and the point values in column A. In spreadsheet 2, we have a formula =QUERY(FLATTEN('Indies Votes'!B4:Z103),"SELECT Col1,COUNT(Col1) where Col1 is not null group by Col1")  to grab the unique titles and count how many times they appear across all lists as well as the formula =SUMPRODUCT(IF('Indies Votes'!B$4:Z$103=A2,'Indies Votes'!A$4:A$103))  to count how many points each title gets. Across the 25 lists, there are a total of 553 Game Titles, and a total of 1617 total votes, all inputted by hand thanks my lonely life lol