Version 2.0 of Palmer's Residual Alkalinity Spreadsheets

Mon Apr 07, 2008 3:56 pm

In a fit of tax time procrastination, I have updated my residual alkalinity spreadsheets on my webpage, http://howtobrew.com/section3/chapter15-3.html
Version 2.0 improves the user interface and adds (gasp) instructions! :omg:
It also (unfortunately) fixes several small errors I was unaware of until Dave Louw and Soren Tygesen pointed them out. Thanks!
The new version also incorporates dilution with distilled water.
Have at it and I hope it is helpful.
Good Brewing,
John
There are Rules, there are Guidelines, and then there is Understanding.
But sometimes it's more fun to just wing it.
User avatar
howtobrew
 
Posts: 32
Joined: Thu Oct 26, 2006 12:50 pm
Location: SoCal

Mon Apr 07, 2008 5:03 pm

Thanks very much for that, John. That version 1.0 spreadsheet has been a great help in dialing in my beers over the last year or so. Now I'll have to get to work moving my little personalizations (collection of water profiles and such) from the old version over to the new one!

That spreadsheet and the nomograph are well worth the price of the book, in case there is some brewer out there under a rock who does not have one yet.
What's on tap: Cream Ale, Imperial Blonde
Secondary: British Amber,
Primary: APA
http://bubrew.org
User avatar
DannyW
 
Posts: 1953
Joined: Wed Mar 08, 2006 6:37 pm
Location: Nokomis, Florida, USA

Mon Apr 07, 2008 9:08 pm

Doh!
Error in dilution caught by Danny Williams. And typos by Hullabrew.
Version 2.1 now up.
John
There are Rules, there are Guidelines, and then there is Understanding.
But sometimes it's more fun to just wing it.
User avatar
howtobrew
 
Posts: 32
Joined: Thu Oct 26, 2006 12:50 pm
Location: SoCal

Tue Apr 08, 2008 3:08 pm

Version 2.2 is now up!
Fixed a couple cell references in the sparge water acidification that I had previously missed, but I think this is truly correct now.
Thanks Everyone for finding these.
Good Brewing,
John
There are Rules, there are Guidelines, and then there is Understanding.
But sometimes it's more fun to just wing it.
User avatar
howtobrew
 
Posts: 32
Joined: Thu Oct 26, 2006 12:50 pm
Location: SoCal

Tue Apr 08, 2008 3:52 pm

I'm waiting for 2.4. . . :lol:
"Mash, I made you my bitch!" -Tasty
User avatar
Dirk McLargeHuge
Global Moderator
 
Posts: 5715
Joined: Sat Aug 11, 2007 1:43 pm
Location: Fredericksburg, Texas

Wed Apr 09, 2008 7:24 pm

One of the primary inputs to this sheet is the expected SRM of the recipe. I plug my recipe in to StrangeBrew or ProMash and it gives me a number. I plug that number in to the spreadsheet and go on my merry way.

I just realized tonight, though, that the color changes drastically based on the gravity of the recipe and I suspect that the water calcs should not change.

For instance, if I were to mash some pale malt with 1.2qt/lb for a Scottish 60/- I would have an SRM of about 3. If I mash the same malt with the same ratio of water but make a barleywine, the color calculates out to around 10. That's a pretty big swing, and it seems to me the water adjustments should be proportionally the same for both of these.

So which SRM is the right one to use for these calculations?
What's on tap: Cream Ale, Imperial Blonde
Secondary: British Amber,
Primary: APA
http://bubrew.org
User avatar
DannyW
 
Posts: 1953
Joined: Wed Mar 08, 2006 6:37 pm
Location: Nokomis, Florida, USA

Thu Apr 10, 2008 2:02 pm

Remember, this spreadsheet is all about arm waving. You use the Color of the final beer to estimate how much alkalinity is required for the mash pH. Stronger beers of the same color would have more aciidity and therefore coul tolerate a higher RA, than a weaker beer.
I use the Morey calculation for color btw.
Using the weighted average of Lovibond of the malts is not recommended because of the way that SRM is actually measured. Dark beers have to be heavily diluted to allow light to pass thru them for the spectrophotometric test. Again, I use the Morey method. I guess I should have mentioned that in the Instructions...
John
There are Rules, there are Guidelines, and then there is Understanding.
But sometimes it's more fun to just wing it.
User avatar
howtobrew
 
Posts: 32
Joined: Thu Oct 26, 2006 12:50 pm
Location: SoCal

Thu Apr 10, 2008 4:10 pm

howtobrew wrote:Remember, this spreadsheet is all about arm waving. You use the Color of the final beer to estimate how much alkalinity is required for the mash pH. Stronger beers of the same color would have more aciidity and therefore coul tolerate a higher RA, than a weaker beer.
I use the Morey calculation for color btw.
Using the weighted average of Lovibond of the malts is not recommended because of the way that SRM is actually measured. Dark beers have to be heavily diluted to allow light to pass thru them for the spectrophotometric test. Again, I use the Morey method. I guess I should have mentioned that in the Instructions...
John



Wow! :shock: :shock:


Personally, I use the wankelman calcualtions for this.

:shock:
Three out of four people make up 75% of the worlds population.

Sean's Brewery & House of Ill Repute
seanhagerty
 
Posts: 1061
Joined: Sat Jun 25, 2005 7:37 am
Location: Waynesville, MO

Next

Return to All Grain Brewing

Who is online

Users browsing this forum: No registered users

A BIT ABOUT US

The Brewing Network is a multimedia resource for brewers and beer lovers. Since 2005, we have been the leader in craft beer entertainment and information with live beer radio, podcasts, video, events and more.