HBT 2015 Big Giveaway - Enter Now

Huge Supporting Membership Discounts - 20% Off

 Home Brew Forums > Temp Correction Formula for Hydrometer
04-11-2010, 10:07 PM   #21
abstractsins
Feedback Score: 0 reviews
Recipes

Join Date: Feb 2010
Location: Philly
Posts: 6
 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.

__________________

04-19-2010, 05:37 PM   #22
Heffewizeass
Feedback Score: 0 reviews
Recipes

Join Date: Apr 2010
Posts: 1
 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```
__________________

10-08-2012, 11:25 PM   #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

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, 07:52 AM   #24
ummagumma
Feedback Score: 0 reviews
Recipes

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

__________________