Happy HolidaySs Giveaway - Winners Re-Re-Drawn - 24 hours to Claim!

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 06-29-2006, 01:11 PM   #11
jcarson83
Feedback Score: 0 reviews
 
jcarson83's Avatar
Recipes 
 
Join Date: Jun 2006
Location: Springfield, MO
Posts: 942
Liked 15 Times on 10 Posts

Default

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

Theres where I got the formula if anyone is interested.
__________________
jcarson83 is offline
 
Reply With Quote Quick reply to this message
Old 06-29-2006, 02:50 PM   #12
Spyderturbo
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jun 2006
Location: Camp Hill, PA
Posts: 48
Default

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


Spyderturbo is offline
 
Reply With Quote Quick reply to this message
Old 12-29-2006, 12:35 AM   #13
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default

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

__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 04-12-2009, 07:34 PM   #14
TipsyDragon
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2009
Location: California
Posts: 2,607
Liked 22 Times on 20 Posts

Default

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.

__________________
TipsyDragon is offline
 
Reply With Quote Quick reply to this message
Old 09-04-2009, 03:20 PM   #15
gracho
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2009
Location: San Marcos,Texas
Posts: 17
Default

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

gracho is offline
 
Reply With Quote Quick reply to this message
Old 09-07-2009, 10:40 PM   #16
kyral210
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2009
Location: Loughborough (UK), Leicestershire
Posts: 22
Default

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

Old fashioned hydrometers are calaborated at 15°C, but modern ones are collaborated at 20°C. The equation given before is for 15°C 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 20°C equation.

__________________
kyral210 is offline
 
Reply With Quote Quick reply to this message
Old 11-18-2009, 12:00 AM   #17
Guido
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2009
Location: Minnesota
Posts: 1
Liked 1 Times on 1 Posts

Default Hydrometer Correction for a Spreadsheet

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
__________________
Guido is offline
barrooze Likes This 
Reply With Quote Quick reply to this message
Old 11-18-2009, 11:09 AM   #18
kyral210
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2009
Location: Loughborough (UK), Leicestershire
Posts: 22
Default

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

__________________
kyral210 is offline
 
Reply With Quote Quick reply to this message
Old 11-18-2009, 02:37 PM   #19
Brewiz
Feedback Score: 0 reviews
 
Brewiz's Avatar
Recipes 
 
Join Date: May 2005
Location: Stockbridge, Ga
Posts: 964
Liked 3 Times on 2 Posts

Default

Here Check this out. Link

__________________
Do you ever see a motorcycle in front of Therapist's Office???
Insert Name Here Brew Club
Brewiz is offline
 
Reply With Quote Quick reply to this message
Old 03-08-2010, 08:51 PM   #20
Beerbrothas
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2010
Location: Worcester, MA
Posts: 49
Likes Given: 1

Default Good link

That Beer Recipator link is awesome thanks

__________________
Beerbrothas 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