Gaming Forums > General Gaming

The Great(?) Video Game Spreadsheet Project: Year 32 Challenge!

(1/3) > >>

Evan_B:
Current Weighted Top Twenty (as of 9/11/2023):

* VVVVVV (4.47)
* Roller Coaster Tycoon 2 (4.42)
* Crawl (4.36)
* Zelda: Tears of the Kingdom (4.30)
* The Swapper (4.28)
* Inscryption (4.25)
* Roller Coaster Tycoon (4.23)
* Dandara (4.21)
* Mr. Driller Drill Land (4.21)
* Super Smash Bros. Ultimate (4.19)
* ARMS (4.19)
* Skwish (4.17)
* UNSIGHTED (4.17)
* Tetris Effect Connected (4.16)
* Kirby's Air Ride (4.15)
* Pick Pack Pup (4.12)
* Toree 2 (4.12)
* Toree 3D (4.12)
* Paper Mario TTYD (4.11)
* Lucah: Born of a Dream (4.10)I've heard talk of these forums being unused. Of Discord emerging as the clear victor over old message boards. Well, I'm here to say that, without old message boards, we wouldn't have places to post unhinged rants like the one I'm about to engage in. You might argue I could toss this over onto r/gaming. I say, yeah, I guess I could. But it feels more at home here.

Having spent the last few years writing for a video game website, I had the privilege of playing a bunch of review copies of games, some of which I probably never would have picked up with my own money. This also led to me playing a bit fast and loose with the money I was saving not-buying those review copy games. Long story short, I generated a healthy backlog. One large enough to likely last me the rest of my days. This is concerning to me, seeing as I know the slow march of time will mean new games will be released in the future that I might want to play.

So, I decided to spend an entire year foregoing new video game purchases, starting on my birthday. We're several days in now, and I'm turning back to my backlog and making sure I give games their proper due over the next year, in the hopes of clearing things out and learning to appreciate what I've got, rather than what society insists I need.

But what does this have to do with spreadsheets? Well, I'm glad you asked. Since I delved into making weird inventories of what I own, I also started doing a bit of ranking of games. This got a bit messy, but it adds another layer of satisfaction when I beat a game, or put a game down for completion. Some games I end up bouncing off, and as a result, they might appear played, but not beaten on my spreadsheet. I can live with that.

How does one rank video games? Well, you're asking a mentally unwell person that question, so you better expect the unexpected answer. I should mention, I actually have two spreadsheets, one for all video games, the other strictly for RPGs, as they are the lion's share of the games I've played in my lifetime, and my personal ranking of RPGs involves evaluating some genre staples and finding trends that don't necessarily align with my overall video game ranking criteria. In any case, I broke down my rankings into six categories, each possessing a scale from 1-5:

GAMEPLAY: An admittedly nebulous label, this seeks to evaluate the breadth and complexity of the overall gameplay experience. Games that rely largely on a single type of mechanic or possess gimmicky, unpolished gameplay elements score low in this category, while more complex games with a variety of gameplay types or well-explored gameplay concepts score higher.
CONTROLS: Essentially, whether or not a game possesses tight and thoughtfully considered control schemes, as well as whether or not controls are customizable. This factors in the notion of developers making player control deliberately difficult or otherwise.
ART: Largely pertaining to visual aesthetics, this is a sterile way of evaluating art, but does have a bit of subjective reasoning. Game art that lacks consistency across elements or comes across as generic or serviceable score lower, with higher scoring games possessing strong aesthetics- not necessarily lifelike visuals.
SOUND DESIGN: Again, a sterile way of evaluating music at its lower rankings, but becoming more subjective on the higher end of the scale. It's music and sound design as a whole.
PACING: This one is contentious, for sure. I love RPGs, but I know for a fact that many of them are not good about respecting the player's time... or being disrespectful in service of presenting a more grand adventure. Do the narrative/gameplay/novelties of the experience seem intentionally spaced out for player enjoyment or appreciation?

Now, the finer requirements for scoring high and low in these categories are more of a toss-up, and while I've tried to be very objective in delineating them, ultimately, each one caps out at a 5 amounting to "standout for the genre." No matter how hard I try, stripping these numerical values of an interpretative aspect feels impossible. However, I have slightly modified things to another extent: weighting values based on my personal preferences. The distribution is as follows:
CONTROLS: 16%
MUSIC: 19%
ART: 19%
GAMEPLAY: 24%
PACING: 18%
STORY/WRITING: 5%

This is not to say I think art and music comprise 38% of an overall game experience, but I do value them more than control options and strong pacing. The latter category is something I think we, as consumers, have a complicated relationship with, though you'll find that my top 20 has a number of very brisk experiences. As for writing, you might find it surprising that I value it so little. In short, I think most video game writing is pretty bad, with occasional bursts of originality and appropriate flair. Some of the best video games I have played have pretty minimal writing, so this category is more about whether the writing is appropriate for the project, and how generic or unpolished the final product appears to be.
In any case, here are some curious notes, as the spreadsheet does go beyond just weighted and unweighted averages: (This list curated on 9/4/2023, subject to change in a year)

* My admittedly meager Steam library and PC games are very underrepresented on this list, which is something I hope to update in the near future. I'm missing a number of classics like Roller Coaster Tycoon, Age of Empires, and Starcraft, to name a few.
* Either I'm a nice guy or my ranking criteria are far too lenient, but a whopping 336 games out of the currently-listed 494 are rated a 3.00 or higher, unweighted. In contrast, my weighted preferences put 309 out of 494 at a 3.00 or above.
* For more precision, 37 games score a 4 or higher.
* There is a range of 22 unique average scores out of 495 games. There is a range of 208 unique average weighted scores, though this number is impacted by the amount of unique calculations factoring in weighted percentages. I will need to streamline this calculation in the future.
* 11 games have, in my opinion, a 5 out of 5 Control Scheme.
* 40 games have 5 out of 5 Sound Design.
* 48 games have 5 out of 5 Art/Aesthetics.
* 3 games have 5 out of 5 Gameplay. Yikes! They are: Mr. Driller Drill Land, Hand of Fate 2, and Tears of the Kingdom.
* 28 games have 5 out of 5 Pacing.
* 12 games have 5 out of 5 Writing.
* The top three averages on the sheet are 3.17 (67), 2.83 (61), and 3.33 (54).All of these notes are based on weighted averages:

* The top three most frequently recurring genres in my top 20 are platformers (5) and party/competitive games (5), and Role Playing Games (3).
* The lowest rated game I loved was Dokapon Kingdom (2.61). See, I enjoy average games!
* The highest rated game I liked was Dandara, which I think demands a replay for re-evaluation. I do really enjoy the ideas in Dandara but there were a couple of instances where I was a bit underwhelmed. The lowest rated game I liked was Metroid: Other M (2.16).
* I have a category of preference called "meh," and the highest and lowest games rated in this category are Prince of Persia: The Sands of Time (3.61) and Sonic Heroes (2.03), respectively.
* The highest rated game I disliked was Crypt of the Necrodancer (3.65). I totally get what the game is trying to do but I think mastering its systems requires a single-minded obsession and a punishing reaction time. The lowest rated game I disliked was The Atla Archives (1.67). A recent release, I can't forgive its poor design, but I do know that it is an early effort from an ambitious and green developer.
* The highest rated game that I hated was Arc of Alchemist (2.61). Kind of shocked it even got that. The lowest rated game is Witch and Hero (1.65). This is a very mean ranking and is entirely based on buyer's remorse.Here's the kicker. There's a backlog sheet on here, as well, and it contains a whopping 156 games. Some are near finished, but I don't feel confident enough adding them to the ranking sheet. 82 of these games remain literally unplayed, while the other 74 have been started or are in some progress. I need to sink a comfortable amount of time into a roguelike before I feel I can properly add it to the ranking sheet. Some of the near-finished games require a second look before adding them to the ranking sheet- I do not personally feel I need to complete a game to add it to the ranking sheet.

I do not know how I got to this point of having such a disgustingly large backlog, but I want to claw my way out of it, one way or another. I understand that having a bunch of RPGs and multiplayer/endless games in my backlog won't help that battle, but it is one I am committed to tackling, at least for the next calendar year.

If you have any questions, concerns, or comments, feel free to leave them here. May the gods have mercy on me.

M.K.Ultra:
This is very interesting to me. It occurred to me to use a holistic rubric for evaluating the quality of any game a few years ago. I did envision something similar but I was always too busy to actually carry it to fruition. I did have music, art, and controls on my list as well. Pacing was not one I had thought of so that is neat, and certainly a factor that affect the enjoyment of the game. I almost feel like you would want to use a different distribution for different genres but perhaps that would disrupt the whole idea. Any plans to perhaps share you actual .csv file for others to take a closer look?

So the current top twenty are the twenty highest rated games that you have played? What exactly is on your backlog, could we get a sneak peak of some of the 156?

Khushrenada:
I'm loving that Kirby's Air Ride is the highest rated GameCube game. Take that, Mario Kart! Even higher than the great TTYD. And ARMS! No one talks about ARMS anymore on the Switch. Splatoon got two releases on Switch while ARMS is left behind. That 2015 - 2018 when Nintendo seemed to be getting creative with game ideas and franchises.

Evan_B(iscotti) does have a Backloggery page though I'm not sure how up-to-date it is. It only shows 105 total unfinished games. I'm not sure if he'd be alright with me posting the link to it or not so to err on the side of privacy, I'll wait to see what he says after reading this post.

Evan_B:

--- Quote from: M.K.Ultra on September 05, 2023, 10:29:18 AM ---So the current top twenty are the twenty highest rated games that you have played? What exactly is on your backlog, could we get a sneak peak of some of the 156?

--- End quote ---
So the list at the top of the thread is my current weighted top 20. When you do unweighted ranking, some games move around, and some games sneak into the top 20 that definitely deserve to be there. Weirdly enough, it feels more like the list is more biased when it's unweighted... in any case, here it is:

* VVVVVV
* The Swapper
* Inscryption
* Crawl
* Zelda: Tears of the Kingdom
* UNSIGHTED
* Paper Mario TTYD
* Pikmin 3
* Vagrant Story
* The Last Story
* A Short Hike
* Dandara
* Super Smash Bros. Ultimate
* ARMS
* Kirby's Air Ride
* Toree 2
* Toree 3D
* Lucah: Born of a Dream
* Scram Kitty and his Buddy on Rails
* Donkey Kong Tropical Freeze…I’ll be honest, I kind of feel bad about Toree 2 and 3D taking up two spots on the list. But I also kinda don’t. EDIT: Also of note is how Mr. Driller drops out of the top 20 completely when not weighted.

Regarding your comments on genre... I at least have an RPG-exclusive spreadsheet, which does have some other crazy categorizations. As for the .csv, it looks like a trainwreck when I try exporting it, so I can only offer a .pdf. It as my backlog page on it, as well: PDF view

--- Quote from: Khushrenada on September 05, 2023, 04:44:22 PM ---I'm loving that Kirby's Air Ride is the highest rated GameCube game. Take that, Mario Kart! Even higher than the great TTYD. And ARMS! No one talks about ARMS anymore on the Switch. Splatoon got two releases on Switch while ARMS is left behind. That 2015 - 2018 when Nintendo seemed to be getting creative with game ideas and franchises.

Evan_B(iscotti) does have a Backloggery page though I'm not sure how up-to-date it is. It only shows 105 total unfinished games. I'm not sure if he'd be alright with me posting the link to it or not so to err on the side of privacy, I'll wait to see what he says after reading this post.

--- End quote ---
Thanks for keeping me honest. Though I've added a number of games to my backloggery over the past year(s), I haven't really kept up with managing it, so the status of many games listed there are not up-to-date. I am switching over to this weird spreadsheet instead, so you can use the link above.

And yes, while ARMS was very much laughed at for its gimmicky premise and shallow features out of the gate, the game has a lot of variety to it, great aesthetics, and excellent control options and mapping. I can't believe I think so highly of it, but I do. As a reminder, the ranking system here, as holistic as it tries to be, is still horribly biased towards my tastes.

Evan_B:
Week 2: Current Weighted Top Twenty (as of 9/11/2023):
VVVVVV (4.47)
Roller Coaster Tycoon 2 (4.42)
Crawl (4.36)
Zelda: Tears of the Kingdom (4.30)
The Swapper (4.28)
Inscryption (4.25)
Roller Coaster Tycoon (4.23)
Dandara (4.21)
Mr. Driller Drill Land (4.21)
Super Smash Bros. Ultimate (4.19)
ARMS (4.19)
Skwish (4.17)
UNSIGHTED (4.17)
Tetris Effect Connected (4.16)
Kirby's Air Ride (4.15)
Pick Pack Pup (4.12)
Toree 2 (4.12)
Toree 3D (4.12)
Paper Mario TTYD (4.11)
Lucah: Born of a Dream (4.10)
I figured I'd post new rankings each week I update the sheet. I added a few oldies to the mix (mostly PC games) as well as my Playdate catalogue, which did a bit of a rankings upset.

...I also added more games to my backlog, which means now there are 175. Whoopee.

The new games that I've played (Pikmin 4, Trigger Witch, and Nova 111) haven't made it into the top rankings... yet. I still need to sink a bit more time into Nova 111 to see if I think its pacing is stellar. As far as strategy/puzzle games go, though, I'm pretty confident in rating it highly. Pikmin 4 was not an enjoyable experience, I found it simplistic and slow-paced, with the new modes not offering well-constructed challenge and the control options a huge letdown. The game feels like a big step back from Pikmin 3. Trigger Witch is adorable and stupid, but gets by on its gratuitous violence and dynamic soundtrack.

Playdate games are a bit tough, in terms of visuals and sound design. It's such a feature-light system that when developers push its 1-bit visuals, it really sells the charm of the console and the product. But are the sound and art standout for the genre, or for the system? That's what I often mull over, which ends up settling the ranking. Anyway, Skwish and Pick Pack Pup are excellently-paced, pocket-sized offerings that are well-worth experiencing, and I'm glad to see them up on the top of the list.

If anything, it has proven to me that, despite my love for extra-meaty RPGs, a punchy, succinct experience often burrows into my brain and gives me warm and fuzzy feelings. I'm pretty pleased with how the top 20 looks right now, which at least leaves room for some old favorites while acknowledging the blossoming modern gaming scene.

Navigation

[0] Message Index

[#] Next page