Updated: Jun 7
When I started homebrewing, I casually wrote down various values throughout the brewing process, and I found fermentation data to be one of the most interesting.
I created simple X-Y charts out of my numbers and graphed the gravity values as the beer fermented. What results is a pretty "curve" or line chart that can tell you loads about your beer, the yeast, and your process - and even help you to detect problems.
JUMP TO SECTION:
Check out Keg Punk. Software that helps
you manage taps, track keg inventory, and more.
WHAT ARE GRAVITY CURVES?
Tracking changes in gravity during fermentation is one of the easiest and most insightful ways you can improve your beer from batch to batch. Gravity curves (I also call them fermentation curves) are simply the visual representation of changes in specific gravity readings of beer in the fermenter. Enough with the lingo - it's a chart, plain and simple.
While you can create these gravity curves with paper and pencil, I recommend using the power of computers - and Excel is a great starting tool to do it with. Below is a step-by-step guide to creating gravity curves from your fermentation data in Excel. While Excel has far more processing and formatting capabilities that what's described, this article is just to get you started.
STEP-BY-STEP GUIDE TO CREATE A GRAVITY CURVE
Open Excel and start a blank workbook.
Save the file - I saved it as "GravityCurve".
At the bottom of the page, change the name of the sheet to "Gravity Curve", and add a main title at the top.
Under the main title, add a "Batch Info" section. This should include
Beer Name (The name of the recipe)
Batch Name (I like to name batches as "Beer Name" + Brew Date, for example "Far Out - 12Dec19")
Now add the headings for the table we're making. From left to right, the headings should be:
Day of Fermentation
Highlight the headings. Under Insert, click "Table". In the pop-up, select "My Table Has Headers". Click "OK".
Now let's create a chart. In Insert, click the symbol for "Scatter With Straight Lines and Markers"
Click "Select Data"
Click in the first field, and then click in the empty space next to "Batch Name". This will name the chart after the batch name.
Click in the Series X-Values field and select the cells under "Day of Fermentation".
Click in the Series Y-Values field and select the cells under "Adjusted Gravity"
When entering data, use a gravity adjustment calculator to get an adjusted gravity reading. Otherwise, your values may be inaccurate.
In order to get the Lower and Upper FG values, you first need the attenuation range of the yeast strain you are using. For this example, we're using Wyeast 1056. From the manufacturer's website, we can easily find the range.
Now calculate the predicted final gravity range:
OG = 1.050
Attenuation range => 73 - 77
Lower Attenuation = .73
Upper Attenuation = .77
Upper FG = [(OG - 1) x (1 - Lower Attenuation)] + 1
Upper FG = [(1.050 - 1) x (1 - .73)] + 1
Upper FG = 1.013
Lower FG = [(OG - 1) x (1 - Upper Attenuation)] + 1