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

Register Now!
Home Brew Forums > Home Brewing Beer > General Techniques > Temp Correction Formula for Hydrometer

Reply
 
Thread Tools
Old 06-29-2006, 12:11 PM   #11
jcarson83
 
jcarson83's Avatar
Recipes 
 
Jun 2006
Springfield, MO
Posts: 928
Liked 15 Times on 10 Posts


http://http://www.hbd.org/brewery/li...mCorr0992.html

Theres where I got the formula if anyone is interested.

 
Reply With Quote
Old 06-29-2006, 01:50 PM   #12
Spyderturbo
Recipes 
 
Jun 2006
Camp Hill, PA
Posts: 48

You have the wrong formula. Here is the correct one:

C = ((1.313454 - (0.132674*F) + (0.00205779 * F^2) - (0.000002627634 * F^2)))

Where F = Temperature in degrees Fahrenheit.

C = Correction

So,

CG = C + (SG * 0.001)

Where,

CG = Specific Gravity corrected for temperature

C = Correction from above forumla

SG = Specific Gravity before temperature correction.

Here it is for everone using Degrees Centigrade:

C = ((1.313454 - (0.132674 * ((C * 1.8) + 32)) + (0.00205779 * (((C * 1.8) + 32))^2)) - (0.111112627634 * (((C * 1.8) + 32))^3)))

Then continue with the formula above formula for CG

If you would like to use Excel for this, do the following:

Degrees F calculation

1) Use Cell B3 as your temperature (F) input.
2) Use Cell B5 as your SG input
3) Paste the following into Cell B7:

=1.313454 - (0.132674*B3) +( 0.002057793*(B3^2)) - (0.000002627634*(B3^3))

Paste the following into Cell B9:

=B5+(B7*0.001)

Cell B9 will contain your temperature corrected SG



For people using degrees centigrade, change the formula pasted into Cell B7 to the following:


=1.313454-(0.132674*((B3*1.8)+32))+(0.002057793*(((B3*1.8)+3 2)^2))-(0.000002627634*(((B3*1.8)+32)^3))


I'm sure that I could have reduced the formula down to something "prettier", but I really didn't feel like wasting time doing that. Besides, isn't that what's so nice about using Excel.

Cheers!

Disclaimer = It is possible that I made a transposition error when transferring this from Excel, so please check the Excel results against a table before using it.
__________________
Primary: Nothing
Secondary: Spiced Holiday Ale
Bottles: Generic Wheat Beer, Franziskaner Clone
Next: Caramel Cream Ale


 
Reply With Quote
Old 12-29-2006, 12:35 AM   #13
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


Damn thanks man I was looking forever for this formula for my excel sheet. Thanks dude
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 04-12-2009, 06:34 PM   #14
TipsyDragon
Recipes 
 
Mar 2009
California
Posts: 2,607
Liked 24 Times on 22 Posts


i believe the original formula was supposed to be

Correction = 1.313454 - 0.132674*T + 2.057793e-3*T^2 - 2.627634e-6*T^3

but this assumes a hydrometer that is calibrated to 59F. if your hydrometer is calibrated to a different temp like 68F then i don't think this formula will not work. I've been looking for a formula that can be used for any calibration temp but so far haven't had much luck.

 
Reply With Quote
Old 09-04-2009, 02:20 PM   #15
gracho
Recipes 
 
Mar 2009
San Marcos,Texas
Posts: 20

Quote:
Originally Posted by TipsyDragon View Post
i believe the original formula was supposed to be

Correction = 1.313454 - 0.132674*T + 2.057793e-3*T^2 - 2.627634e-6*T^3

but this assumes a hydrometer that is calibrated to 59F. if your hydrometer is calibrated to a different temp like 68F then i don't think this formula will not work. I've been looking for a formula that can be used for any calibration temp but so far haven't had much luck.

This is exactly the problem I am running in to. I am trying to create a set of calculators for mobile devices, phones and such. I have a few already working but can not seem to find the formula for the hydrometer that can be adjusted to different calibrations temps.

If there is any body out there better at math than I am they might be able to modify the above formula to include the calibration temp variable.
__________________
Prost,


Gracho
_____________________________________________
Time Flies Like An Arrow and Fruit Flies Like Bananas

 
Reply With Quote
Old 09-07-2009, 09:40 PM   #16
kyral210
Recipes 
 
Sep 2009
Loughborough (UK), Leicestershire
Posts: 22

Thanks for the formulae. However, there is a problem!

Old fashioned hydrometers are calaborated at 15C, but modern ones are collaborated at 20C. The equation given before is for 15C hydrometers. What makes it worse is that nowhere on line says which the string of numbers mean, or where they come from, so I can't develop my own 20C equation.


 
Reply With Quote
Old 11-18-2009, 12:00 AM   #17
Guido
Recipes 
 
Nov 2009
Minnesota
Posts: 1
Liked 1 Times on 1 Posts


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

barrooze Likes This 
Reply With Quote
Old 11-18-2009, 11:09 AM   #18
kyral210
Recipes 
 
Sep 2009
Loughborough (UK), Leicestershire
Posts: 22

I am thinking of building an open source home brewing and wine making calculator. What do you think?

 
Reply With Quote
Old 11-18-2009, 02:37 PM   #19
Brewiz
 
Brewiz's Avatar
Recipes 
 
May 2005
Stockbridge, Ga
Posts: 954
Liked 4 Times on 2 Posts


Here Check this out. Link
__________________
Do you ever see a motorcycle in front of Therapist's Office???
Insert Name Here Brew Club

 
Reply With Quote
Old 03-08-2010, 08:51 PM   #20
Beerbrothas
Recipes 
 
Mar 2010
Worcester, MA
Posts: 52


That Beer Recipator link is awesome thanks

 
Reply With Quote


Reply
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