HBT 2014 Big Giveaway - 4/10 Re-Draw Winners Posted!

Home Brew Forums > Home Brewing Beer > General Techniques > Creating spreadsheet to track fermentation data




Reply
 
LinkBack Thread Tools Display Modes
Old 08-15-2013, 08:32 PM   #1
keiljansen
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2012
Location: Durham, NC
Posts: 6
Likes Given: 1

Default Creating spreadsheet to track fermentation data

I've created a google spreadsheet that I've been using to track my fermentations. It tracks SG compared to time elapsed, which makes it easier for me to compare multiple fermentations with the same yeast. It also calculates the SG points/hour that the fermentation has averaged. This is to help me identify if there are predictable places in fermentation where the pace slows, so I can manipulate other variables to try and keep fermentation steady.

I'm not that great with spreadsheets, so I'd love some help on tweaking this so it's perfect.

Notes & problems:

1. Sometimes I enter a data point when I change the temp, but don't take a gravity reading. Some of the calculations on this spreadsheet don't like that, but I need to keep that function.

2. I have two fermenters that I keep in the same chamber, so I keep data on both in one spreadsheet.

Here's the link so you all can see it:

https://docs.google.com/spreadsheet/ccc?key=0An4jQ6L4z8pBdFNFSzU3cXkwdkt3ckZyMjV1SU5CV UE#gid=0



__________________
keiljansen is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hops Data Spreadsheet stamandster Recipes/Ingredients 3 10-30-2012 02:35 AM
Most Important Data To Track nalidixic General Beer Discussion 13 04-25-2012 05:51 AM
Fermentation Temperature data anengineer Brew Science 10 02-15-2012 01:00 PM
Is my fermentation on track? WhoDey78 Beginners Beer Brewing Forum 12 05-31-2011 04:30 PM
Yeast Fermentation Data RukusDM Cider Forum 5 10-30-2010 04:49 PM