It is currently Sat May 25, 2013 8:30 am

All times are UTC - 8 hours





Post new topic Reply to topic  [ 122 posts ]  Go to page 1, 2, 3, 4, 5 ... 16  Next
Author Message
 Post subject: Version 2.0 of Palmer's Residual Alkalinity Spreadsheets
PostPosted: Mon Apr 07, 2008 3:56 pm 
User avatar
 WWW  Profile

Joined: Thu Oct 26, 2006 12:50 pm
Posts: 29
Location: SoCal
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.


Top
 

 Post subject:
PostPosted: Mon Apr 07, 2008 5:03 pm 
User avatar
 WWW  Profile

Joined: Wed Mar 08, 2006 6:37 pm
Posts: 1951
Location: Nokomis, Florida, USA
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: raspberry merlot, loquat wine, bock, Bugeater's ORCA
Secondary: Cube Pale Ale
Primary: nothing!
http://bubrew.org


Top
 

 Post subject:
PostPosted: Mon Apr 07, 2008 9:08 pm 
User avatar
 WWW  Profile

Joined: Thu Oct 26, 2006 12:50 pm
Posts: 29
Location: SoCal
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.


Top
 

 Post subject:
PostPosted: Tue Apr 08, 2008 3:08 pm 
User avatar
 WWW  Profile

Joined: Thu Oct 26, 2006 12:50 pm
Posts: 29
Location: SoCal
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.


Top
 

 Post subject:
PostPosted: Tue Apr 08, 2008 3:52 pm 
Global Moderator
User avatar
 WWW  Profile

Joined: Sat Aug 11, 2007 1:43 pm
Posts: 5471
Location: Fredericksburg, Texas
Medals: 1
Drunk of the Week (1)
I'm waiting for 2.4. . . :lol:

_________________
"Mash, I made you my bitch!" -Tasty


Top
 

 Post subject:
PostPosted: Wed Apr 09, 2008 7:24 pm 
User avatar
 WWW  Profile

Joined: Wed Mar 08, 2006 6:37 pm
Posts: 1951
Location: Nokomis, Florida, USA
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: raspberry merlot, loquat wine, bock, Bugeater's ORCA
Secondary: Cube Pale Ale
Primary: nothing!
http://bubrew.org


Top
 

 Post subject:
PostPosted: Thu Apr 10, 2008 2:02 pm 
User avatar
 WWW  Profile

Joined: Thu Oct 26, 2006 12:50 pm
Posts: 29
Location: SoCal
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.


Top
 

 Post subject:
PostPosted: Thu Apr 10, 2008 4:10 pm 
 Profile

Joined: Sat Jun 25, 2005 7:37 am
Posts: 1060
Location: Waynesville, MO
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


Top
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 122 posts ]  Go to page 1, 2, 3, 4, 5 ... 16  Next

All times are UTC - 8 hours



Who is online

Users browsing this forum: Google [Bot]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

Powered by phpBB © 2009 phpBB Group