Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > General Techniques > Temp Correction Formula for Hydrometer
Reply
 
LinkBack Thread Tools
Old 04-11-2010, 11:07 PM   #21
abstractsins
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2010
Location: Philly
Posts: 6
Default graphing calculator

Thanks for the formula! I'm adopting various homebrew equations into my TI-86 graphing calculator so I don't always have to be by a computer.

__________________
abstractsins is offline
 
Reply With Quote Quick reply to this message
Old 04-19-2010, 06:37 PM   #22
Heffewizeass
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2010
Location: Reno, Nevada
Posts: 1
Default For the Visual Basic inclined:

Code:
Function sgRatio(Temp As Double) As Double
    sgRatio = 1.00130346 - 0.000134722124 * Temp + 0.00000204052596 * Temp ^ 2 - 2.32820948E-09 * Temp ^ 3
End Function

Function corSG(SG As Double, Temp As Double, CalT As Double) As Double
    corSG = SG * (sgRatio(Temp) / sgRatio(CalT))
End Function
__________________
Heffewizeass is offline
 
Reply With Quote Quick reply to this message
Old 10-09-2012, 12:25 AM   #23
EdgeBrew
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2012
Location: Victoria, Australia
Posts: 49
Liked 4 Times on 4 Posts
Likes Given: 2

Default

Quote:
Originally Posted by Guido View Post
I found a formula that will do hydrometer corrections no matter what your hydrometer is calibrated for. Mine, which is about 20 year old, is pegged to 70 degrees instead of the more standard 59 degrees.

This is the formula for Microsoft Excel:
Code:
=A1*((1.00130346-0.000134722124*A2+0.00000204052596*A2^2-0.00000000232820948*A2^3)/(1.00130346-0.000134722124*A3+0.00000204052596*A3^2-0.00000000232820948*A3^3))
Easily, the longest formula I've EVER typed into a spreadsheet. At least it works. I've tested the results against hydrometer correction charts in "How to Brew", "Brewing Quality Beers", and "Brewing Lager Beer".

There are some assumptions you will need to know for that formula to make any sense. Do this:
1) Create a new spreadsheet.
2) Cell A1 will hold your measured Specific Gravity reading. Type in 1.050 for testing purposes.
3) Cell A2 will hold your measured temperature. Type in 120 (I'm assuming Fahrenheit) for testing purposes.
4) Cell A3 will hold your hydrometer's calibration temperature. Mine is 70, but you can type in 59 since that's probably what yours is.
5) Copy and paste the above formula into cell A4.

If you used the values, 1.050 (measured s.g.), 120 (measured temp), and 59 (calibration), then you should see 1.0610 for your calibrated specific gravity reading.

I'm building a spreadsheet to help me plan my beers and I'm willing to give it away for free if anyone can tell me how to post it to this Forum.

Cheers,
Guido
Thanks for the formula Guido. Here is the same formula adjusted for temperate in Celsius:
Code:
=A2*((1.00130346-0.000134722124*((B2* 9/5)+32)+0.00000204052596*((B2* 9/5)+32)^2-0.00000000232820948*((B2* 9/5)+32)^3)/(1.00130346-0.000134722124*((C2* 9/5)+32)+0.00000204052596*((C2* 9/5)+32)^2-0.00000000232820948*((C2* 9/5)+32)^3))
__________________
EdgeBrew is offline
 
Reply With Quote Quick reply to this message
Old 12-29-2012, 08:52 AM   #24
ummagumma
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2012
Posts: 1
Default

Hey guys thanks for putting me on the right path but after punching all this data into a spreadsheet it seems to work with 5 and 10 degrees over (celcius... come on America we believe you can catch up lol) but 5 and 10 under it doesnt change the reading at all (which it should) im happy to give it out freely and let anyone alter it as long as they let me have a copy of the updated version, unfortunately i have nothing old enough to produce an xml spread sheet so i have converted it to an xls (close as i can get) and thrown it on the net for anyone with the link which is Brewing details.xml feel free to use it anyone

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



Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hydrometer correction...is the Brew Your Own website correct? Q2XL Beginners Beer Brewing Forum 15 04-30-2009 03:27 AM
Hydrometer correction factor steelerguy Equipment/Sanitation 4 04-02-2009 12:12 AM
70 hydrometer correction table egurney Equipment/Sanitation 2 02-10-2009 05:46 PM
hyDrometer temperature correction tables? beergears Beginners Beer Brewing Forum 4 11-01-2007 08:27 PM
SG Temp Correction formula LS_Grimmy Extract Brewing 1 12-13-2006 11:45 PM



Newest Threads

LATEST SPONSOR DEALS