Using Spreadsheets to Track and Improve Fermentations

During a busy brew day, it can be a challenge to keep track of what’s going on with current fermentations in the cellar. Sometimes, we don’t notice that they have a slow or stalled fermentation until it’s too late to do something about it. In most cases, the next step is to dump the batch and start again—an unfortunate waste of product, time, and money.

However, being able to keep track of your fermentations and predict issues before they arise can potentially save a batch. Even if you’re already collecting daily gravity and pH readings, it can be challenging to see whether a particular batch is right on target with other batches you’ve brewed or whether it is acting as an outlier.

Here, I’ll outline how you can use Microsoft Excel or a similar program, such as Google Sheets, to create a simple spreadsheet for tracking fermentations. This will let you use your daily gravity and pH readings to visualize your fermentation data and make the proper recipe or ingredient alterations.

How Spreadsheets Can Improve Fermentations