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:
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:
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!
