Create a Beer Gravity Curve In Excel

Updated: Jun 9, 2020

Please share this post and go to our website to get a free copy of our

"Guide to Fermentation Analysis" when you subscribe!

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.

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.

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)

  • Style

  • Brew Date

  • 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:

  • Sample Date

  • Day of Fermentation

  • Fermenter Temp

  • Sample Temp

  • Hydrometer Reading

  • Adjusted Gravity

  • Lower FG

  • Upper FG

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 "Add"

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 the Brewer's 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.

Using the "Predict Final Gravity" function in the Brewer's Calculator , enter the OG and attenuation range. The calculated range is the Lower and Upper FG values. Enter these into the table.

Now we'll add the FG range to the chart.

Click the line in the chart. It should highlight the associated data. Now click "Select Data"

Click "Add"

Click in the first field, and then click the "Lower FG" heading

Click in the Series X-Values field, and then select the cells under "Day of Fermentation"

Click in the Series Y-Values field, and then select the cells under "Lower FG"

Repeat the process for "Upper FG". This should give you the estimated final range for this batch based off the OG and the yeast attenuation values.

Everything works - so now you can format it! Make it easy to read and understand.

This should get you on your way to simple brewing analytics. Now put this to good use, and be sure to check out our other article on Determining If Your Beer Is Done Fermenting

Also! Check out our article in Brulosophy!

Please share this post and go to our website to get a free copy of our Guide to Fermentation Analysis when you subscribe!

Follow us on Facebook and Instagram @arithmech

Cheers Y’all!

Arithmech Analytics

New Orleans, LA

  • Facebook Social Icon
  • Instagram Social Icon