All-Time Beer Festival Winners Sortable Spreadsheet

Discussion in 'Beer Talk' started by JFrankParnell, Nov 1, 2014.

Thread Status:
Not open for further replies.
  1. JFrankParnell

    JFrankParnell Devotee (337) Apr 19, 2009 Washington

    Update to previous listing. I have gone whole hog on data, and here for your enjoyment are the all time GABF and WBC winners in sortable spreadsheets, and for the true geeks, I have created the mother of all spreadsheets by combining the two. They can be found here:

    All-Time GABF Winners:
    https://docs.google.com/spreadsheets/d/1ZI0FuZEkHl8utnB0xhtSfg-OuTS5E6MXxigbtB-ObeA/edit?usp=sharing

    All-Time WBC Winners:
    https://docs.google.com/spreadsheets/d/1fTPPrWwm-3JeeK9HnEhTLi_Fxk8qclGNScjB4Y3y9E0/edit?usp=sharing

    All-Time Combined Winners:
    https://docs.google.com/spreadsheets/d/1X2zGPjDAb0_XBIa_KLBn6ALEQszbES5jzMiJbyhDhVw/edit?usp=sharing

    Enjoy
     
    MNAle, sharpski, Knobs303 and 6 others like this.
  2. Knobs303

    Knobs303 Initiate (0) Nov 8, 2013 Colorado

    Good Job on That. A nice resource to have handy.
     
  3. BucketBoy

    BucketBoy Zealot (649) May 6, 2008 Pennsylvania

    Nice! Using the filter to switch sorting based on brewery or year is particularly helpful. Thanks for doing this!
     
  4. JFrankParnell

    JFrankParnell Devotee (337) Apr 19, 2009 Washington

    I have put most continuing efforts into the combined sheet. This sheet is sorted as follows: Country, State, Brewery, Beer Name, Medal, Year. I have also colored the medals. Now it is pretty easy to find a beer by brewery and area, and then look across to see how many medals it won, and when it last won.
     
  5. JFrankParnell

    JFrankParnell Devotee (337) Apr 19, 2009 Washington

    I have started combining brewers on the combined list. This is the one that will be updated regularly. I would ask that if you see a brewer in your area that has been bought up or combined with another brewer, let me know and I will update them. I have tried to do this for ones I know. For instance, Hart Brewing becoming Pyramid and buying up Portland Brewing. This should be reflected, so that the current brewery is listed.
     
Thread Status:
Not open for further replies.