Spike Brewing Giveaway - New v3 Kettle

Home Brew Forums > Home Brewing Beer > General Techniques > Temp Correction Formula for Hydrometer
Thread Tools
Old 04-11-2010, 10:07 PM   #21
Feedback Score: 0 reviews
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
Old 04-19-2010, 05:37 PM   #22
Feedback Score: 0 reviews
Join Date: Apr 2010
Location: Reno, Nevada
Posts: 1
Default For the Visual Basic inclined:

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
Old 10-08-2012, 11:25 PM   #23
Feedback Score: 0 reviews
Join Date: Apr 2012
Location: Victoria, Australia
Posts: 48
Liked 4 Times on 4 Posts
Likes Given: 2


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

Thanks for the formula Guido. Here is the same formula adjusted for temperate in Celsius:
=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
Old 12-29-2012, 08:52 AM   #24
Feedback Score: 0 reviews
Join Date: Dec 2012
Posts: 1

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

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 02:27 AM
Hydrometer correction factor steelerguy Equipment/Sanitation 4 04-01-2009 11:12 PM
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 07:27 PM
SG Temp Correction formula LS_Grimmy Extract Brewing 1 12-13-2006 11:45 PM

Forum Jump