Amiibo Card Collection/Trade Tracker

Shock

Bunny Enthusiast
Joined
Nov 14, 2021
Posts
27
Bells
99
User Title Color Change (Seashells)
Hey everyone,

I hope this is the right place for this, as I couldn't figure out a better spot. I don't really consider myself an artist in the traditional sense, but I do feel a sort of creative love for expressing myself and engaging with things I love by tinkering and building various things of a more technical nature. At the risk of sounding pretentious, my own "mediums" would probably be scripting, code, and weird little projects like this one. 😄

In that vein, I made a Google Sheets spreadsheet that allows you to track your collection, what you're trading, and what you're looking to get in trades with some spiffy lookup magic-based automation to boot ;)

Link: Amiibo Card Collection/Trade Tracker - Google Sheets

To use it, simply go to File -> Make A Copy. This will create your very own copy on your own Google account's storage/Drive, which you can then fill out and customize as you wish.

More Details
It's split into two sheets:
Collection Tracker is a detailed list of every AC Amiibo card released, with check boxes to mark a card as "Collected" (ie you own that card), "For Trade," or "Seeking," plus a column to select how many of a card you have for trade.
Trade Tracker contains two tables for what you have available for trade and what you're looking for, automagically filled based on the checkboxes and whatnot in Columns I-K of the Collection Tracker, plus a section for trade notes.

Images:
The Collection Tracker features images for each card. Series 1-4 + Welcome Amiibo are hyperlinked from Nintendo's own AC Amiibo Card catalog, while Series 5, Sanrio, and Promo images were all scraped from various Wikis and other websites, then uploaded to Google Drive and inserted via hyperlink. You can view the largest available resolution of each image by mousing over it, then clicking the thumbnail or filename in the bubble that pops up.

Collection Tracker (Fresh):
1637332205995.png


Trade Tracker (Fresh):
1637332275741.png


Collection Tracker (In use)
1637332358612.png


Trade Tracker (Automatically populated with Isabelle and Tom Nook in the For Trade/Looking For tables respectively, as specified using columns I-K of the Collection Tracker)
1637332464450.png

I haven't migrated my own collection over to it yet, but if/when I do it will be on another copy of this sheet so that the link shared here can serve as a "vanilla" version others can copy for their own use, tweak to their hearts' content, etc. I'm a big FOSS nerd, you see. ;)

I hope this proves handy for some of you! This is a first draft of sorts, so please feel free to share feedback on how I can improve it. I'd also simply adore the opportunity to see what some of my fellow tinkerers might come up with as far as modified/remixed versions go. ❤
 
Back
Top