Invader's Game Blog

Posted on Jan 4th 2013 at 04:34:24 PM by (InvadErGII)
Posted under Statistics, NES, N64

A little while ago, I made a blog post called NES Collecting By The Numbers, where I explored NES collecting as sorted by rarity. This was to assist in narrowing down my missing titles by how easy it would be to find them, which has been a HUGE help.

I recently decided to go for a complete N64 set and figured this would be a good tool for that as well. I made a similar tool for N64 stuff, and added more formulas so it can calculate more information automatically. I'm happy with the results, so I've set up base versions of these files as shared Google docs so you can do this yourself! You'll need to make a duplicate copy of these on your Google Drive to edit it. Here are the links:

NES Stat Machine

N64 Stat Machine

Here's how it works. Each spreadsheet has 2 tabs: one called 'Totals' and one called 'Game List'. The former spits out all the numbers based on what games you have. To indicate those, all you need to do is go the 'Game List' tab and put the word 'Yes' in the 'Owned?' column next to each game. Once it's done, go back to the 'Totals' tab and you'll see something like this:



You can also use filters in the 'Game List' tab to see which games of a certain rarity you're missing:



Seriously, how have I never picked up All-Pro Basketball? Oh well.

Anyway, that's about all there is to it. I'm interested in making more of these for different systems (assuming there's a generally agreeable checklist with rarities on it), and to expand the stats to sort by other things (such as year, publisher, etc.) Stay tuned for more updates, and feel free to leave suggestions!


                                                                                                                                                                                                                                               
This is InvadErGII's Blog.
View Profile | RSS
I keep a Tumblr blog where I write about a bunch of things. Here, I'm crossposting my various writings on gaming.
Blog Navigation
Browse Bloggers | My Blog
Hot Entries
Hot Community Entries
Site content Copyright © rfgeneration.com unless otherwise noted. Oh, and keep it on channel three.