[jimpdx]

So about three years ago I started entering lots of competitions and wanted a way to track all my scores, upcoming deadlines, links to comp websites, etc. I built a Google Sheet that a number of our homebrew club (Oregon Brew Crew) members use and I realized that I never posted it to AHA.



Each entry (name/style) is listed as a column with upcoming competitions listed down the left (plus location and number of bottles required). Place a "X" for each entry you plan on submitting or a "B" to highlight beers you still need to bottle I like to link the name of the competition to the comp website. Input the event date and deadline. Column C will calculate the number of days you have until the deadline. I erase the deadline cell once I have shipped or dropped off my entries. Once scores come back, just enter the final number and it will average all the scores at the bottom and color-code according to BJCP score ranges (Fair, Good, Very Good, Excellent, etc).

This is a free template that anyone with a Google Account can access and use. Go to File -> Make A Copy, then look for it at http://drive.google.com under "My Drive". Feel free to use it and shoot me an email if you have any questions or comments!

Click here to view the template

[dmtaylor]

Stolen/copied.  Thanks!  This is right up my alley.  I've already done something very similar but your spreadsheet does it even better, so thanks for sharing.

[theDarkSide]

Thanks for sharing.  I think I'm going to add a column to mine to display "brew date", calculating back from the due date the number of weeks a particular style is at it's peak.

[udubdawg]

Cool, thank you!




 

[jimpdx]

Thanks for sharing.  I think I'm going to add a column to mine to display "brew date", calculating back from the due date the number of weeks a particular style is at it's peak.

Yes customize it to your heart's content. I have added other things like fees, club points earned, etc. I hope to be able to feed competitions directly into the sheet from BJCP XML feed. Going to ask Jamil about that tonight since he built the BJCP integration for AHA's comp calendar.