[gradys]

^^^^
Just realized: spreadsheet? Your Excel problem is solved, then?

And which spreadsheet are you using?  The one in Brewer's Friend that wants 30 samples?!

FYI: You can also determine Refractometer Correction Factor online here: https://www.homebrewmap.com/en/tools/calculators/refractometer-correction-factor

[klickitat jim]

Yeast suspension effect posted in a new thread under general topics

[Robert]

Trusting Novotný enough that I'm doing current batch without bothering with hydrometers.  Just checked mid fermentation, and OP's calculator with Novotný shows gravity exactly where it always is at this point with this beer. 

[klickitat jim]

Awesome

[Big Monk]

Trusting Novotný enough that I'm doing current batch without bothering with hydrometers.  Just checked mid fermentation, and OP's calculator with Novotný shows gravity exactly where it always is at this point with this beer.

I added the novotny equations to the Terrill sheet and will be tracking from now on. I have a suspicion that the Terrill equations are more accurate at higher levels of attenuation.

[Robert]

Trusting Novotný enough that I'm doing current batch without bothering with hydrometers.  Just checked mid fermentation, and OP's calculator with Novotný shows gravity exactly where it always is at this point with this beer.

I added the novotny equations to the Terrill sheet and will be tracking from now on. I have a suspicion that the Terrill equations are more accurate at higher levels of attenuation.

Could be, I'll look forward to your reporting on that.  Since I don't need to know when to spund,  I'm really just checking midway and at the end of fermentation to make sure there hasn't been some irregularity that would indicate the need to get a fresh culture of yeast.  So consistency is more important to me than accuracy.

[Robert]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

[Big Monk]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Terrill New Cubic or New Linear? New cubic tracks a bit higher than New Linear.

What was the O.G.?

[dmtaylor]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Are you very confident in your correction factor?  Did you check calibration of both the hydro and refract in plain cool water before measuring?

[Robert]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Are you very confident in your correction factor?  Did you check calibration of both the hydro and refract in plain cool water before measuring?

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Terrill New Cubic or New Linear? New cubic tracks a bit higher than New Linear.

What was the O.G.?

OG 12.7°P, whatever Terill is in th OP's calculator, yes, yes, and yes to Dave's questions.  I've had one other sample (fully fermented, different batch of same beer) give identical results.

At this point I have no problem with using a hydrometer at racking if I want a good FG.   I see no inaccuracy on wort, so the refractometer I will use to simplify brew day.  And I'll only have one reading, FG, to convert to (my preferred) Plato.

[Big Monk]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Are you very confident in your correction factor?  Did you check calibration of both the hydro and refract in plain cool water before measuring?

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Terrill New Cubic or New Linear? New cubic tracks a bit higher than New Linear.

What was the O.G.?

OG 12.7°P, whatever Terill is in th OP's calculator, yes, yes, and yes to Dave's questions.  I've had one other sample (fully fermented, different batch of same beer) give identical results.

At this point I have no problem with using a hydrometer at racking if I want a good FG.   I see no inaccuracy on wort, so the refractometer I will use to simplify brew day.  And I'll only have one reading, FG, to convert to (my preferred) Plato.

The OP calculator uses Terrill New Linear. New Cubic actually tracks closer to what you saw @ 1.0116

[Robert]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Are you very confident in your correction factor?  Did you check calibration of both the hydro and refract in plain cool water before measuring?

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Terrill New Cubic or New Linear? New cubic tracks a bit higher than New Linear.

What was the O.G.?

OG 12.7°P, whatever Terill is in th OP's calculator, yes, yes, and yes to Dave's questions.  I've had one other sample (fully fermented, different batch of same beer) give identical results.

At this point I have no problem with using a hydrometer at racking if I want a good FG.   I see no inaccuracy on wort, so the refractometer I will use to simplify brew day.  And I'll only have one reading, FG, to convert to (my preferred) Plato.

The OP calculator uses Terrill New Linear. New Cubic actually tracks closer to what you saw @ 1.0116

Thanks, that is probably within the margin-of-eyeballing-hydrometer-in-carbonated-beer error;  what calculator uses that new cubic?

[Big Monk]

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Are you very confident in your correction factor?  Did you check calibration of both the hydro and refract in plain cool water before measuring?

^^^^^

Just took a sample of a fully fermented beer. Hydrometer: 1.012. Terill: 1.010. Novotný: 1.008.  Maybe I'll use refractometer on brew day, but maybe neither correction is really accurate on fermenting/fermented beer.  Look forward to more data.

Terrill New Cubic or New Linear? New cubic tracks a bit higher than New Linear.

What was the O.G.?

OG 12.7°P, whatever Terill is in th OP's calculator, yes, yes, and yes to Dave's questions.  I've had one other sample (fully fermented, different batch of same beer) give identical results.

At this point I have no problem with using a hydrometer at racking if I want a good FG.   I see no inaccuracy on wort, so the refractometer I will use to simplify brew day.  And I'll only have one reading, FG, to convert to (my preferred) Plato.

The OP calculator uses Terrill New Linear. New Cubic actually tracks closer to what you saw @ 1.0116

Thanks, that is probably within the margin-of-eyeballing-hydrometer-in-carbonated-beer error;  what calculator uses that new cubic?

Sean Terrill's Excel sheet uses it.

[Robert]

Thanks, Big Monk, I'm looking at that right now.

[Big Monk]

Thanks, Big Monk, I'm looking at that right now.

I just PM'd you my sheet that I modified. It is expanded to include the Novotny equations as well and reworks some of the Attenuation and Alcohol calcs as well to more accurate versions.