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:

[img width=609 height=224]http://i.imgur.com/jgtZe.png[/img]

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

[img width=700 height=117]http://i.imgur.com/Z1Q1V.png[/img]

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!


Permalink | Comments [10] | Digg This Article |


Recent Entries
In Which I Describe Pizza Tower at an Exhaustingly Long Length (7/31/2024)
Remasters, Remakes, Rereleases, and Remembering the Past (3/30/2024)
The Top 5 Survival Horror Games for the Sega Dreamcast (2/20/2024)
Trombone Champ Is a Good Game (12/30/2023)
Thoughts on the Nintendo Switch OLED Model (11/21/2023)


Comments
 
Awesome!  Thanks for making this.  Just finished plugging in my games. Cheesy  -HM
 
Unfortunately the filters did not come through when I saved it as excel. Sad
 
I've never understood why certain aspects of Google Docs/Excel aren't cross compatible despite being so similar - filters is definitely one of them.

If you haven't already, you can re-do the filters in Excel by clicking on the little arrow between 'A' and '1' and then clicking on Sort & Filter -> Filter in the home menu (in newer version of Office it's on the right side).
 
Ha, All Pro Basketball is currently the first game on my list alphabetically.  But there are TONS of NES games I don't have.  Thanks for making this very useful tracker!!
 
Neat idea!  Your N64 list is missing Bottom of the 9th, though.
 
@blcklblskt Bottom of the 9th is in there, its just under MLB Bottom of the 9th, I noticed that too.
 
I see it now.  Thanks Wempster!
 
Funny you mentioned it, but I saw All-Pro Basketball and Quattro Arcade at the flea market this morning. Thought about just grabbing them and sending them your way, but the guy wanted too much for their going rate. Sad
 
Hey there,

If your interested in making a stat sheet for PS2 Iam almost finished compiling a NTSC PS2 list. I can update with rarity as well. Let me know via DM.
 
This is awesome! Haha Just plugged in all my NES titles now plugging in my N64 Stuff.  I think I might start using google docs more.

 Login or register to comment
It appears as though you are not a member of our site, or are not logged in.
It appears as though you can not comment currently. Becoming able to comment though is easy! All you need to do is register for the site! Not only will you be able to access any other site features including the forum and collection tools. If you are a registered user and just need to login then you can do so here.

Comment! It's easy, thoughtful, and who knows you might just enjoy it!
                                                                                                                                                                                                                                               
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.