Ferret's Game Trading Book V01: A spreadsheet I created to help me keep up with my game trading

Do you have a garbage memory and are sick of looking up the same games over and over, only to discover that you've already seen them and you didn't want to trade for them the first 76 times?

I first started this spreadsheet as a place to list the games that I don't want, when considering a trade on SteamTrades. I found that, when looking through someone else's trading inventory, so that I could propose a trade, I would end up looking at the same games that I had the last time I tried to propose a trade. My memory sucks, so I needed a way to mark them as a "no" so that I could spend my time looking at the games I hadn't already ruled out once, twice, or ten times before.

From there, it became more complicated. I figured, why not go ahead and list what I have, and make a page to search what I have against their wishlist? And then I decided to make a third sheet for tracking my attempts at shopping my own inventory around.

I found a few scripts that would compare my wishlist to their "Haves," but not only was there no option to blacklist, but traders sometimes format their "Haves" in ways that the scripts can't parse, whereas, for the most part, I can simply copy and paste as plain text to my spreadsheets. These scripts were also useless when people simply had a link to their wishlist in their "Wants."

Compare2Steam can be useful, but only as a tool to see if you have something that is on their Steam wishlist, or if any of their stuff matches your wishlist. My spreadsheet allows me to plug in any number of more specific lists, and Compare2Steam can't return a "No" value, only a "Not Yes," when trying to pick my wants out of someone else's list or tradables. On my sheet, games that I know I don't want are automatically labeled "No," and games I haven't decided yet show a "NA." From there, I can sort the table, copy and paste all the NAs, and turn them in to yeses or nos, for any time they come up in the future. Compare2Steam can also be painfully slow at times.

Barter.vg is cool, but not everyone is on it and it can be buggy and slow.

Anyway, here it is. If you find any value in it, please let me know. You can either download it, or create a copy in your own Google Docs for you to modify. Obviously, all of the data within is mine and should be changed to reflect your own. I'd suggest starting by removing all of the games that I have already said "yes" or "no" to and pasting your own wishlist there, along with a bunch of yeses.

The formulas in the sheet are currently set up to handle up to 7000 rows. It will take some time to load, since the formulas have to go all the way to row 7000 in each column, on each sheet, so be patient if it looks broken at first. I can easily make a shorter or longer (!?) version if your device just says nope. Or, if it's just too slow for you, you can just highlight and delete any number of bottom rows, assuming you're not planning to input that many games.

https://docs.google.com/spreadsheets/d/1N5CzZuyP9anbBt3DwAbQcrkzaqKc66PUWr_h2MNr6pY