Anyone else use Excel to capture the details of their past and present beer collection? Anyone else love doing so? If you're an Excel lover, maybe you share the same sentiment; thought I'd start a thread about it. Please only post here if you actually document your beer collection in some way, as this may not be applicable to many who pick up a fresh 4-6pk and that is all that is in their fridge. Maybe I'm an organization freak and I feel like I'm a little crazy talking about this, but I have spoken to a few other people who keep their entire collection, past and present, in an Excel file. For me, it has been the best way to manage and sort on a large beer collection. I feel that it best captures all of the attributes and customizations that I really need in keeping track of and listing details of every single beer that I own. Some of the data or actions that I find particularly useful are: 1) Knowing how many of each beer vintage I have left 2) Sorting and filtering on important attributes, such as: Region - to better look-up trade-able beer ABV - to decide how much alcohol I'm in the mood for Size - do I want a 12, 16, or 22oz today? Style - to filter on what style I'm in the mood for Marking potentially trade-able beers vs will only consume or share with friends Price - what I paid and how much something is worth (for trade and personal reference) Purchase date, bottled date Calculated recommended Ready/Drinking date Drank/consumed date - so that I know when I drank something for review purposes BA, Untappd, and personal ratings! - very important for choosing the right can or bottle Estimated calories - for deciding which beers I can handle calorie-wise that day Comments, for reference purposes (who gave it to me, where I picked it up, thoughts on the beer, etc.) 3) From all of this data, in another sheet, creating pivot charts and tables or look-ups of how many beers are ready to drink, how much I paid for everything, how much everything is worth, and how many beers I have at any given time (is my collection going up or down) 4) Documenting completed trades for reference purposes Just to be clear, I don't do this solely for organization purposes; I actually love creating and updating Excel spreadsheets in my job and at home, and especially when I bring home some new beer. I also love looking up a beer in my list to decide on what the "right" beer is for the night. I'm sure there are more of you, so I suppose this thread could go a few different ways, and could just be a general discussion. Some potential topics include - What details do you like to document in you Excel sheet? If you don't use Excel, or just BA or Untappd to maintain your collection, what do you use to maintain a large collection? Any rants, raves, or questions/tips about putting your beers in Excel spreadsheets I'm looking forward to the discussion!