Hey all, I did a thing again!
The title should say "Josh breaks down every Game of the Year pick EXCEPT FOR 1998
(and regrets every second of it)"
This project was a fucking albatross if I've ever seen an albatross in my life. It took about a week longer than I thought it would and got to the point where I was spending 3 hours of my work day (for about 5 days) on it just trying to get the damn thing done.
Honestly though, while it's neat to look at (check the link to the excel file I've included). I'm still not entirely sure if all this data actually means anything. I was trying to use the editors picks as sort of a public/expert opinion poll in order to say something about the greater population as a whole. And, while I THINK there is something in the numbers that speaks to how diverse RPG's have become (and their migration towards handhelds AND Square Enix losing its strangle holdon the industry) and how that's probably a really good thing, I don't necessarily know if those conclusions are easily drawn from what I ended up putting together. Though I suppose it's "relevant" since it's about that time those in charge of this place churned out another edition of the feature that initially drew me to this site about 10 years ago.So What's in the Spreed Sheet?
1) A master list of every single Game of the Year Pick ever made on this website (except for the wonky 1998 list), complete with who developed and published said game, as well as what system it can be played on. 831 in total. Yes, this took forever to type out.
2) A console generation by console generation break-down of all of the Picks (5th, 6th, 7th, and 8th). It is my assumption, that the cutoffs between console generations are well established (5th = PSX and Saturn, 6th = DC, 7th = Wii, 8th = WiiU). Things get a little more squirrelly when dealing with handhelds and PC's because the "generations" tend to overlap (and there are none with PC's). I ended up just picking an arbitrary (playstation related) date for when to switch generations with PC's. Making distinctions between generations is important because of stuff like Square leaving Nintendo. Duh.
At the bottom of all the console lists are a running list of all games/developers/publishers who got more than 3 mentions in that particular generation. Because of the varying numbers of editors that made picks each year, these lists are not perfect. I was thinking about making an algorithm similar to the one used by baseball to determine E.R.A so that all games/publishers/developers could be judged on equal footing. Something like number of times picked per 5 picks, would seem appropriate, but I sort of ran out of steam before I got to the part where I ran those kinds of numbers. So take the numbers that do show up with a grain of salt.
3) And this might be the most interesting to some (the editors themselves, maybe), In an attempt to determine if any of RPGFans editors had certain tendencies I separated their picks individually. You had to be around for 3 years in order to qualify (1 is an example, 2 is a coincidence, 3 is a trend... as it were).
4) I'm sick of looking at this goddamn excel file, so here it is https://www.dropbox.com/s/xzgs1pr3zsemvxe/Game%20of%20the%20Year%20Project.xlsx?dl=0
note: There is no way to acceptably put a project of this scope onto the forums without hours and hours of formatting. I promise the file above is not a virus.