hydrometer temp correction
Re: hydrometer temp correction
I've done my own brew calculator in MS Excel and Iv'e used
=IF(B1>1.2,B1+(0.000009*B2*B2+0.000235*B2-0.005475),IF(B1>1.099,B1+(0.000012*B2*B2+0.000016*B2-0.00288),B1+(0.00000359*B2*B2+0.00006971*B2-0.00151687)))
If you were to use the top left hand corner of Ms Excel, the 3 left boxes (A1,2 & 3)would read, from top to bottom, Hydrometer reading, Temperature and corrected gravity. To the right of them in boxes B1,2 & 3 you would have for example 1.044, 26C & the formula.
It would be worth checking it against another formula. It wouldn't be the first time I've gone wrong with Excel.
=IF(B1>1.2,B1+(0.000009*B2*B2+0.000235*B2-0.005475),IF(B1>1.099,B1+(0.000012*B2*B2+0.000016*B2-0.00288),B1+(0.00000359*B2*B2+0.00006971*B2-0.00151687)))
If you were to use the top left hand corner of Ms Excel, the 3 left boxes (A1,2 & 3)would read, from top to bottom, Hydrometer reading, Temperature and corrected gravity. To the right of them in boxes B1,2 & 3 you would have for example 1.044, 26C & the formula.
It would be worth checking it against another formula. It wouldn't be the first time I've gone wrong with Excel.
Re: hydrometer temp correction
Thanks for the work boys. Great job and I've taken a copy.
Thanks,
Dave.
Thanks,
Dave.
- Blackaddler
- Under the Table
- Posts: 1326
- Joined: Thu Jun 11, 2009 9:28 am
- Location: Addlestein, Surrey
Re: hydrometer temp correction
That's the formula that I recently started using. It seems to work well, although I have a 60F hydrometer, so have to adjust accordingly.mac wrote:I've done my own brew calculator in MS Excel and Iv'e used
=IF(B1>1.2,B1+(0.000009*B2*B2+0.000235*B2-0.005475),IF(B1>1.099,B1+(0.000012*B2*B2+0.000016*B2-0.00288),B1+(0.00000359*B2*B2+0.00006971*B2-0.00151687)))
Re: hydrometer temp correction
That's the formula that I recently started using. It seems to work well, although I have a 60F hydrometer, so have to adjust accordingly.[/quote]
That got me thinking about my old hydrometer, which doesn't say whether it's for 60 F or 20 C (or if it did the markings are long gone). Anyway, re-calibrated it in 20 C water and got bang on 1000, so at least I know my ABV figures are accurate.
Was it 60 F in the past because that was considered room temperature in the days of no central heating and frost on the inside of the bedroom window?
That got me thinking about my old hydrometer, which doesn't say whether it's for 60 F or 20 C (or if it did the markings are long gone). Anyway, re-calibrated it in 20 C water and got bang on 1000, so at least I know my ABV figures are accurate.
Was it 60 F in the past because that was considered room temperature in the days of no central heating and frost on the inside of the bedroom window?
Re: hydrometer temp correction
How do I know what temp. my hydrometer is calibrated at??????
Re: hydrometer temp correction
Do what I did above. Drop it in water at 20C and hope it reads 1000.
Should be distilled water but tap-water is good enough for government work.
Should be distilled water but tap-water is good enough for government work.
- Blackaddler
- Under the Table
- Posts: 1326
- Joined: Thu Jun 11, 2009 9:28 am
- Location: Addlestein, Surrey
Re: hydrometer temp correction
Easier to use one of the temperature correction tables, like this or look here.jannypan wrote:Am i right in reading this then ... say my sparged wort is coming out about 70ish degrees and i'm getting a reading of 1005 i should be adding 20 or so points and reading it as 1025 say?
The above [70C corrected to 20C] would read 1.025.
-
- CBA Prizewinner 2010
- Posts: 7874
- Joined: Sun Nov 30, 2008 9:06 pm
- Location: Keighley, West Yorkshire
- Contact:
Re: hydrometer temp correction
On this subject, has anyone got a pre-formatted 20c hydrometer correction table with Plus & Minus values for specific readings?
cheers
cheers
Re: hydrometer temp correction
It is in the back of BYOBRA...but wouldn't like to breach copyright
-
- CBA Prizewinner 2010
- Posts: 7874
- Joined: Sun Nov 30, 2008 9:06 pm
- Location: Keighley, West Yorkshire
- Contact:
Re: hydrometer temp correction
wow!!! you are like amazing! I'll just leave the book in the garage
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: hydrometer temp correction
It's also in John Palmer's How To Brew but the correction only goes up to 49 c.greenxpaddy wrote:It is in the back of BYOBRA...but wouldn't like to breach copyright
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
- orlando
- So far gone I'm on the way back again!
- Posts: 7197
- Joined: Thu Nov 17, 2011 3:22 pm
- Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt
Re: hydrometer temp correction
Hi Guys,
Being a bit new I've been looking for resources that give me a number of calculators in one place rather than having multiple URL's bookmarked. I haven't seen any one post this site but I think it is pretty good and offers a few things I haven't seen anywhere else either. The calorie counter showing how much you consume each pint was a little worrying
http://www.beermath.com/metric/index.html
Being a bit new I've been looking for resources that give me a number of calculators in one place rather than having multiple URL's bookmarked. I haven't seen any one post this site but I think it is pretty good and offers a few things I haven't seen anywhere else either. The calorie counter showing how much you consume each pint was a little worrying
http://www.beermath.com/metric/index.html
I am "The Little Red Brooster"
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Fermenting:
Conditioning:
Drinking: Southwold Again,
Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer
Re: hydrometer temp correction
Anyone know if there is a max temp that can be corrected? Just that I took a reading of 1.028 at 66C which my calculator (BrewMate) gives 1.047 but when it was down to 20C I measured it at 1.040. Quite a difference?! I see some calculators don't go this high - perhaps for a reason?
P.S. I started a thread in the All Grain section before seeing this thread. Verdict seems to be to not expect accuracy particular at temperatures as high as this.
P.S. I started a thread in the All Grain section before seeing this thread. Verdict seems to be to not expect accuracy particular at temperatures as high as this.