Temp Correction Formula for Hydrometer - Page 3 - Home Brew Forums

 Home Brew Forums > Temp Correction Formula for Hydrometer

04-11-2010, 10:07 PM   #21
abstractsins
Recipes

Feb 2010
Philly
Posts: 6

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.

04-19-2010, 05:37 PM   #22
Heffewizeass
Recipes

Apr 2010
Posts: 1

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```

10-08-2012, 11:25 PM   #23
EdgeBrew
Recipes

Apr 2012
Victoria, Australia
Posts: 48
Liked 4 Times on 4 Posts

Quote:
 Originally Posted by Guido 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))`

12-29-2012, 08:52 AM   #24
ummagumma
Recipes

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

04-17-2016, 05:11 PM   #25
hylianryan
Recipes

Apr 2016
Posts: 1

Quote:
 Originally Posted by Shambolic That seems weird. Why aren't all the constant terms just incorporated together?
2.71828 is the mathematical constant e.

I guess they aren't combined for clarity.

EDIT: Ignore this, I didn't see there was more than one page... oops!