Hopwise Brewery

Adventures in Cleaning and Sanitizing

I'm a big fan of tracking all of my brewing activity in a log book. And rather than just print out the recipe and stick it in the log, I try to track what actually happened, instead of what the recipe says should have happened. Frequently the two are quite different.

There are a few free brew log templates on the net. I've tried Randy Mosher's from Radical Brewing. I've tried files put together by helpful brewers on various forums. But I've always had a couple problems. First, they don't really track information the way I want to track it. And second, they just don't look very good.

So I made my own:Brewing Log
(click the image to download a pdf)

Although it's a PDF on this site, I created it using almost nothing but HTML and CSS. The two temperature tracking charts are the only exceptions, they are images generated Google's Chart Tools. And because they are generated, I can't quite get them to look exactly the way I want.

It's not perfect, but it's a good starting point. If you want to use it, and you don't mind having the wrong brewery name at the top, feel free.

Updated 10/20/10: New version increases the line height, adds a section for notes and gravity checks and tweaks the layout of the Boil/Whirlpool sections.

Updated 11/16/10: Better grids on the fermentation- and mash-tracking charts. Moved the Gravity/Efficiency section below the mash-tracking chart.

Updated 1/17/11: Expanded to two pages. I removed the whirlpool section because I never used it. Whirlpooling is a process that doesn't really change batch to batch, so there's no reason to track it in the log. Added sections for Aeration/Oxygenation, Forced Fermentation testing, Fermentation notes and Packaging. Where the log tracks expected and actual values, I've added a | in the field to demarcate the two values.

Updated 2/14/11: New logo, which won't matter to anyone but me. Added a section for Apparent Degree of Fermentation (ADF). Added a water-loss worksheet that's probably too elaborate and weird. The goal is to have a place where I can see how much water I'll need and how much beer I'll end up with.


2 Responses to Brewing Log

  1. Brian says:


    Hey Ian, great form! I think this is going to be really useful. I have a question about two of the fields though. I don’t recognize the acronyms PPG (in Grist) or ADF (in Fermentation). What do these stand for?

    Thanks!


    • Ian says:


      PPG is actually wrong, it should read PPPG. But for some reason every one always says PPG. It stands for Parts per Pound Per Gallon. It’s usually written as 1.0XX.

      ADF stands for “Apparent Degree of Fermentation”. It’s a measurement of of how much of your original gravity has been converted into alcohol. It’s calculated by (OG-FG)/FG. So if I had a beer that started at 1.100 and ended at 1.020, my ADF would be (100-20)/100, or 80%. It’s also sometimes called Apparent Attenuation.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>