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 MachineN64 Stat MachineHere'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!
|
Awesome! Thanks for making this. Just finished plugging in my games.  -HM
|
|
Unfortunately the filters did not come through when I saved it as excel. 
|
|
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.
|
|
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.
|
