ACBF Beer Spreadsheet

Discussion in 'New England' started by judzillah, May 12, 2013.

Thread Status:
Not open for further replies.
Page 1 of 2
  1. judzillah

    judzillah Devotee (303) Jan 27, 2005 Massachusetts

    #1 judzillah, May 12, 2013
    cbeer88, defaultroute, JSBILK and 11 others like this.
  2. Auror

    Auror Pooh-Bah (1,641) Jan 1, 2010 Massachusetts
    Pooh-Bah

    Awesome work! This is like something I would have done. A suggestion: add rAvg in there. The "/100" scores are tied heavily into the number of reviews, so knowing the actual average can be more useful in many circumstances.
     
    #2 Auror, May 12, 2013
    kemoarps likes this.
  3. judzillah

    judzillah Devotee (303) Jan 27, 2005 Massachusetts

    Good suggestion! It's in there now.
     
    #3 judzillah, May 12, 2013
  4. Auror

    Auror Pooh-Bah (1,641) Jan 1, 2010 Massachusetts
    Pooh-Bah

    Now I make my own copy, apply Filter Reviews > 0, then I've got my hit list!
     
    #4 Auror, May 12, 2013
  5. benbking

    benbking Initiate (0) Dec 11, 2009 Rhode Island

    I'm almost speechless.
     
    #5 benbking, May 13, 2013
    YogiBeer likes this.
  6. Thads324

    Thads324 Initiate (0) Jan 21, 2010 Connecticut

    Outstanding! I'm going to use this at the saturday fest to keep track of my consumption. Thanks!
     
    #6 Thads324, May 13, 2013
  7. pjs234

    pjs234 Maven (1,453) Jun 29, 2008 Connecticut

    Wow, thanks! You just saved me a ton of research. This is very cool
     
    #7 pjs234, May 13, 2013
  8. hopley

    hopley Pooh-Bah (2,912) Feb 24, 2010 Massachusetts
    Society Pooh-Bah Trader

    Excellent, well done! Thanks! Do you know if there's a way of creating a similar spreadsheet for all the beers people have tried on BA? (i.e. like a one click excel sheet for all my beers)
     
    #8 hopley, May 13, 2013
  9. judzillah

    judzillah Devotee (303) Jan 27, 2005 Massachusetts

    Glad others are finding it useful! Something similar should be possible for your beer reviews, it's just a simple (and bad) python script that I hacked together. Although the beer rating page has a nice summary table view already. But if you'd like, I'm happy to share my little script with you offline.
     
    #9 judzillah, May 13, 2013
  10. jdauria

    jdauria Initiate (0) Sep 15, 2010 Massachusetts

    You beat me too it! Made a spreadsheet also as I did last year too! Good job!
     
    #10 jdauria, May 13, 2013
  11. guezarka

    guezarka Initiate (0) Jan 27, 2009 Massachusetts

    Nice work!
     
    #11 guezarka, May 13, 2013
  12. judzillah

    judzillah Devotee (303) Jan 27, 2005 Massachusetts

    Oops, I'd forgotten the most important column, ABV :slight_smile: I've updated to include it, enjoy!
     
    #12 judzillah, May 15, 2013
    msondel likes this.
  13. ziggyzoggy

    ziggyzoggy Initiate (0) Apr 30, 2013 Ohio

    Really nice work! :sunglasses:
     
    #13 ziggyzoggy, May 15, 2013
  14. fearfactory

    fearfactory Initiate (0) Aug 12, 2012 Massachusetts

    Bravo!
     
    #14 fearfactory, May 15, 2013
  15. darkerpower

    darkerpower Initiate (0) Oct 15, 2008 Connecticut

    you sir are a hero
     
    #15 darkerpower, May 15, 2013
  16. pcsnyder

    pcsnyder Zealot (677) May 2, 2011 Pennsylvania

    Nice one! :slight_smile:
     
    #16 pcsnyder, May 15, 2013
  17. dawatts

    dawatts Initiate (0) Dec 27, 2006 Massachusetts

    Thank you very much Judzilla. cheers.
     
    #17 dawatts, May 20, 2013
  18. JSBILK

    JSBILK Initiate (0) Apr 6, 2013 Massachusetts

    Great spreadsheet! This will be my first year, I'm hoping I can hit all my pre selected beers, and the lines won't be too long.
     
    #18 JSBILK, May 20, 2013
  19. DanSails

    DanSails Crusader (411) Oct 3, 2012 Massachusetts

    Fantastic work! When they post Brewery booth location, that would be a sweet add...
     
    #19 DanSails, May 28, 2013
  20. Auror

    Auror Pooh-Bah (1,641) Jan 1, 2010 Massachusetts
    Pooh-Bah

    #20 Auror, May 28, 2013
Page 1 of 2
Thread Status:
Not open for further replies.