#### jcarson83

##### Well-Known Member

=1.313454-0.132674*t+2.057793*2.71828-3*t*2-2.627634*2.71828-6*t*3

- Thread starter jcarson83
- Start date

=1.313454-0.132674*t+2.057793*2.71828-3*t*2-2.627634*2.71828-6*t*3

/I think I finally beat HB99 with the smart a$$ comment.

- Thread Starter
- #5

Thanks but I'm trying to put it in a spreadsheet so I need the equation. But it doesn't matter because my hydrometer only goes down to .99 which means I can only test wort at about 120F anyway. Though the correction isn't that big so I guess I could get pretty close at 170F.

Maybe you just typed the wrong thing, but that should be:jcarson83 said:

=1.313454-0.132674*t+2.057793*2.71828-3*t*2-2.627634*2.71828-6*t*3

=1.313454-0.132674*t+2.057793*2.71828-3*t^2-2.627634*2.71828-6*t^3

where ^ means "to the power of"

Other than that, I really have no idea what the above means. What is t? Do you add the above result to what you actually read? I don't get it...

- Thread Starter
- #8

t is Temperature. Yes you add the result to your reading. As the wort increases in temp it becomes less dense so unless it is cooler than 59F the result will be a positive number. The longer equation is supposed to allow you to correct results at higher temperatures.

I have a maths degree, and I find something a bit strange about the two formulae. Are you sure that the 't' you use isn't measured from some temperature other than zero in one or both of the formulae?

The reason I ask is that it doesn't make sense to have completely different numbers in a formula that is supposed to be accurate to higher temps. The first few terms should be the same; it should just have some higher-order terms (terms proportional to t^4, t^5 etc.)

In fact, looking back at your original formula, it seems really strange as written. Perhaps try typing it out again? For example

-2.627634*2.71828-6*t^3 to me means:

-(2.627634*2.71828) - (6*t^3)

That seems weird. Why aren't all the constant terms just incorporated together?

- Joined
- Feb 1, 2005

- Messages
- 19,580

- Reaction score
- 1,197

- Location
- I-80, Exit 27 (near the Quad Cities)

Ya got me there BS! Too much math in this post to get interested...I just add +1 or +2 and I'm done. Can't see all the fuss about large formula's when it's not necessary.Brewsmith said:

/I think I finally beat HB99 with the smart a$$ comment.

My chemistry is simple too! H2O is water and K9P comes from a dog.

Electronics? A Transistor is a nun who had a sex change...

Keep It Simple Smarta$$!!

- Thread Starter
- #11

http://http://www.hbd.org/brewery/library/HydromCorr0992.html

Theres where I got the formula if anyone is interested.

Theres where I got the formula if anyone is interested.

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

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)+32)^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.

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

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.

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.

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.

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

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

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

That Beer Recipator link is awesome thanks

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

Thanks for the formula Guido. Here is the same formula adjusted for temperate in Celsius:

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".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))`

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

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

- Joined
- Apr 14, 2016

- Messages
- 1

- Reaction score
- 0

2.71828 is the mathematical constantThat seems weird. Why aren't all the constant terms just incorporated together?

I guess they aren't combined for clarity.

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

- Joined
- Apr 25, 2020

- Messages
- 1

- Reaction score
- 0

Thank you so much for this. I didn't even consider that the exponents were getting formatted out when I was translating this formula. This was driving me nuts!

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".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))`

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

These hydrometers are laboratory grade and have an internal thermometer that give a correction factor of plus of minus tenth of degrees Plato. I just put the hydrometer in the beer, measure the gravity, and add or subtract the correction factor. I have measured beers accurately at up to 90 degrees F. Quick and easy, no math calculations necessary, I like quick and easy! I know that some online homebrew supply houses have SG hydrometers that have a correction thermometer in them that does the same thing, but they are not very accurate, from my experience. The ones I have are calibrated to an accuracy of less than 0.1 degrees Plato.

- Replies
- 3

- Views
- 114