Welcome to BeerAdvocate!

Looking to talk, rate or trade beer? Join today by creating your free account.

Dismiss Notice
Curious about recent updates to the site and app? Check the Announcements forum for updates.
Dismiss Notice
Love Belgian Beer?

Join us Sep 17 in Portland, Maine for Return of the Belgian Beer Fest, featuring hundreds of authentic Belgian beers and Belgian-inspired offerings.

Tickets + more: beeradvocate.com/belgian

ACBF Beer Spreadsheet

Discussion in 'BeerAdvocate Events' started by judzillah, May 12, 2013.

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

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    Massachusetts
  2. Auror

    Beer Trader

    Joined:
    Jan 1, 2010
    Posts:
    1,306
    Likes Received:
    1,070
    Location:
    Massachusetts
    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.
     
    kemoarps likes this.
  3. judzillah

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    Massachusetts
    Good suggestion! It's in there now.
     
  4. Auror

    Beer Trader

    Joined:
    Jan 1, 2010
    Posts:
    1,306
    Likes Received:
    1,070
    Location:
    Massachusetts
    Now I make my own copy, apply Filter Reviews > 0, then I've got my hit list!
     
  5. benbking

    Beer Trader

    Joined:
    Dec 11, 2009
    Posts:
    666
    Likes Received:
    448
    Location:
    Rhode Island
    I'm almost speechless.
     
    YogiBeer likes this.
  6. Thads324

    Joined:
    Jan 21, 2010
    Posts:
    274
    Likes Received:
    188
    Location:
    Connecticut
    Outstanding! I'm going to use this at the saturday fest to keep track of my consumption. Thanks!
     
  7. pjs234

    Joined:
    Jun 29, 2008
    Posts:
    1,049
    Likes Received:
    2,795
    Location:
    Connecticut
    Wow, thanks! You just saved me a ton of research. This is very cool
     
  8. hopley

    Fest Crew Beer Trader

    Joined:
    Feb 24, 2010
    Posts:
    271
    Likes Received:
    252
    Location:
    Massachusetts
    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)
     
  9. judzillah

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    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.
     
  10. jdauria

    Joined:
    Sep 15, 2010
    Posts:
    138
    Likes Received:
    21
    Location:
    Massachusetts
    You beat me too it! Made a spreadsheet also as I did last year too! Good job!
     
  11. guezarka

    Joined:
    Jan 27, 2009
    Posts:
    21
    Likes Received:
    12
    Location:
    Massachusetts
    Nice work!
     
  12. judzillah

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    Massachusetts
    Oops, I'd forgotten the most important column, ABV :) I've updated to include it, enjoy!
     
    msondel likes this.
  13. ziggyzoggy

    Joined:
    Apr 30, 2013
    Posts:
    116
    Likes Received:
    126
    Location:
    Ohio
    Really nice work! :cool:
     
  14. fearfactory

    Subscriber Beer Trader

    Joined:
    Aug 12, 2012
    Posts:
    751
    Likes Received:
    1,078
    Location:
    Massachusetts
  15. darkerpower

    Joined:
    Oct 15, 2008
    Posts:
    35
    Likes Received:
    10
    Location:
    Connecticut
    you sir are a hero
     
  16. pcsnyder

    Joined:
    May 2, 2011
    Posts:
    159
    Likes Received:
    185
    Location:
    Pennsylvania
  17. dawatts

    Joined:
    Dec 27, 2006
    Posts:
    336
    Likes Received:
    487
    Location:
    Massachusetts
    Thank you very much Judzilla. cheers.
     
  18. JSBILK

    Beer Trader

    Joined:
    Apr 6, 2013
    Posts:
    26
    Likes Received:
    42
    Location:
    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.
     
  19. DanSails

    Beer Trader

    Joined:
    Oct 3, 2012
    Posts:
    96
    Likes Received:
    826
    Location:
    Massachusetts
    Fantastic work! When they post Brewery booth location, that would be a sweet add...
     
  20. Auror

    Beer Trader

    Joined:
    Jan 1, 2010
    Posts:
    1,306
    Likes Received:
    1,070
    Location:
    Massachusetts
  21. judzillah

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    Massachusetts
    I ran my script again and updated the sheet. It looks like there were a few changes to the list since last time.

    That's a great idea, but I'm sure as heck not going to do that by hand, and I don't see an easy way to script it. If somebody has that info in an easier to parse form than that PDF though I'd be happy to add it.
     
  22. cincysig

    Beer Trader

    Joined:
    Sep 15, 2010
    Posts:
    123
    Likes Received:
    107
    Location:
    Connecticut
    Brilliant!
     
  23. TriggerFingers

    Beer Trader

    Joined:
    Apr 29, 2012
    Posts:
    611
    Likes Received:
    652
    Location:
    California
    My wife loves data...this will make her happier than actually tasting the beer! LOL thanks!
     
  24. 2beerdogs

    Beer Trader

    Joined:
    Jan 31, 2005
    Posts:
    3,024
    Likes Received:
    9,108
    Location:
    California
    Damn. That's a lot of work! Now, more than before, I wanna go.
     
  25. mmcgrath

    Joined:
    Mar 3, 2003
    Posts:
    272
    Likes Received:
    129
    Location:
    Massachusetts
    sent.
     
  26. mdemaso

    Joined:
    May 30, 2012
    Posts:
    1
    Likes Received:
    0
    Location:
    Massachusetts
    Hey I made a quick site that helps me track the same thing. It even lets you know what your BAC is for the speed of your drinking and the ABV of the beers you are having. Pretty handy stuff for those trying to keep it toned down. It also lets you "like" beers (in no way does it use facebook) so you can track your favorites through out the night.

    There are no ads. I'm hosting it all just for my own personal use and I decided to open it up to all. Last year I made a similar site with less functionality and me and my group of friends found it helpful the next day to see what beers we really liked.

    Cheers: http://brewedsoftware.com/acbf/
     
  27. wreck

    Joined:
    Apr 17, 2006
    Posts:
    3
    Likes Received:
    0
    Location:
    Massachusetts
    That spreadsheet is excellent. I made a sheet myself but it was not nearly as comprehensive. Where did you get access to the source data?
     
  28. judzillah

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    Massachusetts
    Nothing magic. The page with the beer list for the festival has links to the profile page for each beer. I just parsed the info from there.
     
  29. judzillah

    Beer Trader

    Joined:
    Jan 27, 2005
    Posts:
    12
    Likes Received:
    19
    Location:
    Massachusetts
    Thanks! The sheet has been updated with the table locations now.
     
  30. SixBitsKyle

    Joined:
    Jan 29, 2013
    Posts:
    38
    Likes Received:
    22
    Location:
    Massachusetts
    I'm having issues with the doc opening this AM? Anyone else?
     
  31. JSBILK

    Beer Trader

    Joined:
    Apr 6, 2013
    Posts:
    26
    Likes Received:
    42
    Location:
    Massachusetts
    Just printed it, See everyone there!
     
  32. pjs234

    Joined:
    Jun 29, 2008
    Posts:
    1,049
    Likes Received:
    2,795
    Location:
    Connecticut
    I have it saved in excel. I could email it to you. BM with email if you want it.
     
  33. PackieMcHopHead

    Beer Trader

    Joined:
    Oct 1, 2009
    Posts:
    60
    Likes Received:
    41
    Location:
    Massachusetts
    This is amazing. So glad I found this before the session tonight. You sir are a saint. Makes it so much easier to have a good hunting session.

    By any chance are you going to The Festival? ;)
     
  34. ktblue22

    Joined:
    Feb 15, 2013
    Posts:
    71
    Likes Received:
    123
    Location:
    Vermont
    I'm so so so excited!!!! I've never been to a beer fest before - can't wait!!
     
Thread Status:
Not open for further replies.
  • About Us

    Your go-to website for beer (since 1996), publishers of BeerAdvocate magazine (since 2006) and hosts of world-class beer events (since 2003). Respect Beer.
  • Return of the Belgian Beer Fest

    BeerAdvocate Brings its All-Belgian Fest to Portland, Maine on September 17, 2016. Tickets are on sale now.

    Learn More
  • Get the Mag

    Become a BeerAdvocate magazine print subscriber today.

    Subscribe