ACBF Beer Spreadsheet

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

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

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

  2. Auror

    Auror Jan 1, 2010 Massachusetts
    Beer Trader

    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

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

    Good suggestion! It's in there now.
     
  4. Auror

    Auror Jan 1, 2010 Massachusetts
    Beer Trader

    Now I make my own copy, apply Filter Reviews > 0, then I've got my hit list!
     
  5. benbking

    benbking Dec 11, 2009 Rhode Island
    Beer Trader

    I'm almost speechless.
     
    YogiBeer likes this.
  6. Thads324

    Thads324 Jan 21, 2010 Connecticut

    Outstanding! I'm going to use this at the saturday fest to keep track of my consumption. Thanks!
     
  7. pjs234

    pjs234 Jun 29, 2008 Connecticut

    Wow, thanks! You just saved me a ton of research. This is very cool
     
  8. hopley

    hopley Feb 24, 2010 Massachusetts
    Fest Crew Beer 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)
     
  9. judzillah

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

    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

    jdauria Sep 15, 2010 Massachusetts

    You beat me too it! Made a spreadsheet also as I did last year too! Good job!
     
  11. guezarka

    guezarka Jan 27, 2009 Massachusetts

    Nice work!
     
  12. judzillah

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

    Oops, I'd forgotten the most important column, ABV :) I've updated to include it, enjoy!
     
    msondel likes this.
  13. ziggyzoggy

    ziggyzoggy Apr 30, 2013 Ohio

    Really nice work! :cool:
     
  14. fearfactory

    fearfactory Aug 12, 2012 Massachusetts
    Beer Trader

  15. darkerpower

    darkerpower Oct 15, 2008 Connecticut

    you sir are a hero
     
  16. pcsnyder

    pcsnyder May 2, 2011 Pennsylvania

  17. dawatts

    dawatts Dec 27, 2006 Massachusetts

    Thank you very much Judzilla. cheers.
     
  18. JSBILK

    JSBILK Apr 6, 2013 Massachusetts
    Beer Trader

    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

    DanSails Oct 3, 2012 Massachusetts
    Beer Trader

    Fantastic work! When they post Brewery booth location, that would be a sweet add...
     
  20. Auror

    Auror Jan 1, 2010 Massachusetts
    Beer Trader

  21. judzillah

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

    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

    cincysig Sep 15, 2010 Connecticut
    Beer Trader

    Brilliant!
     
  23. TriggerFingers

    TriggerFingers Apr 29, 2012 California
    Beer Trader

    My wife loves data...this will make her happier than actually tasting the beer! LOL thanks!
     
  24. 2beerdogs

    2beerdogs Jan 31, 2005 California
    Subscriber Beer Trader

    Damn. That's a lot of work! Now, more than before, I wanna go.
     
  25. mmcgrath

    mmcgrath Mar 3, 2003 Massachusetts
    Subscriber

    sent.
     
  26. mdemaso

    mdemaso May 30, 2012 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

    wreck Apr 17, 2006 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

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

    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

    judzillah Jan 27, 2005 Massachusetts
    Beer Trader

    Thanks! The sheet has been updated with the table locations now.
     
  30. SixBitsKyle

    SixBitsKyle Jan 29, 2013 Massachusetts

    I'm having issues with the doc opening this AM? Anyone else?
     
  31. JSBILK

    JSBILK Apr 6, 2013 Massachusetts
    Beer Trader

    Just printed it, See everyone there!
     
  32. pjs234

    pjs234 Jun 29, 2008 Connecticut

    I have it saved in excel. I could email it to you. BM with email if you want it.
     
  33. PackieMcHopHead

    PackieMcHopHead Oct 1, 2009 Massachusetts
    Beer Trader

    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

    ktblue22 Feb 15, 2013 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.
  • Extreme Beer FestĀ® Cometh

    February 3-4, 2017. Boston, Mass. Limited tickets available. Prepare for epicness.

    Learn More
  • Free Trial Subscription

    Reside in the US? Interested in a free 1-month trial subscription to the print edition of BeerAdvocate magazine?

    Yes! Sign Me Up!