Kegconnection Complete Starter Kit and More Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Calculator 2.0

Reply
 
LinkBack Thread Tools
Old 09-27-2011, 04:55 AM   #151
weiht
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2009
Location: singapore
Posts: 18
Default

With all the talk about the ph variance between the spreadsheet n the measured at room temperature, I think it's like measuring ibu where it's abt adapting the calculation into ur process, kinda like using rager or tinseth and use it as a guide to give u an idea if what ur shooting for...

I think the spreadsheet is great, and the estimated ph calculations based on the malt bill is a excellent tool, one would be ignorant to think it wld be 100% accurate, but it's superb for giving me an idea of the ph it would be and the ballpark figure of salt additions I would need. I tried a few calculators and I find this to work best for me, simple and clear

__________________
weiht is offline
 
Reply With Quote Quick reply to this message
Old 09-27-2011, 10:29 AM   #152
deanocamino
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2011
Location: fairmont, wv
Posts: 8
Default

I have a question kind of pertaining to this spreadsheet and the subject. When I brought the spread sheet to another brewers attention. And said that after testing my results compared to the sheet, and it was accurate. He then stated that it did not account for water ph adjustment. I am assuming that he ment adjusting the waters profile to a certain place before mashing.

Why would you want to do that anyway if your biggest concern is the ph of the mash and making sure that it can handle all those different malts?

Unless you wanted to take you water compare it to palmers spread sheet make additions and then see were your ph is after you dough in. And then make more adjustments. That just seems like more work to me.

However I could be wrong on all accounts and be totally confused as I have only used the spread sheet once. So does someone want to hook a brother up with some info???

__________________
deanocamino is offline
 
Reply With Quote Quick reply to this message
Old 09-27-2011, 12:49 PM   #153
ajdelange
Senior Member
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 5,690
Liked 541 Times on 444 Posts
Likes Given: 15

Default

Quote:
Originally Posted by weiht View Post
With all the talk about the ph variance between the spreadsheet n the measured at room temperature, I think it's like measuring ibu where it's abt adapting the calculation into ur process, kinda like using rager or tinseth and use it as a guide to give u an idea if what ur shooting for...
That's exactly what it is like. In all the cases mentioned a simple mathematical model has been developed which enables one to predict, with variable accuracy, respectively beer bitterness and mash pH. Rager and Tinseth represent 2 different models and each of the spreadsheets/calculators has its own model. Some of the models are better than others. But it is not enough to have the model. You must have good values for the parameters which the models require.

There is one big difference between the IBU and mash pH situations. Few brewers can check on the accuracy of an IBU prediction whereas it is simple to do so with the pH models. This enables you to apply "english" to the spreadsheet or calculator based on your experience with it. E.g. - it may tend to predict pH's that are a 0.1 low for Pils and be just on for British ales.

Quote:
Originally Posted by weiht View Post
I think the spreadsheet is great, and the estimated ph calculations based on the malt bill is a excellent tool, one would be ignorant to think it wld be 100% accurate, but it's superb for giving me an idea of the ph it would be and the ballpark figure of salt additions I would need.
If only everyone understood that!
__________________
ajdelange is offline
 
Reply With Quote Quick reply to this message
Old 09-27-2011, 01:42 PM   #154
DSmith
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2011
Location: Robbinsdale, MN
Posts: 771
Liked 60 Times on 50 Posts
Likes Given: 11

Default

On the topic of the EZ Water spreadsheet. Lactic acid additions seem to be applied to the mash volume only. Is this this way to do it for batch sparging?

I plan on making up all the water at once (keeping the final concentrations the same for mash and sparge water), but adding the lactic acid to the entire mash + sparge water doesn't seem to be what the consistent with the math within the spreadsheet...

__________________
DSmith is offline
 
Reply With Quote Quick reply to this message
Old 09-27-2011, 01:55 PM   #155
remilard
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2008
Location: Kansas City
Posts: 3,655
Liked 38 Times on 37 Posts

Default

Quote:
Originally Posted by DSmith View Post
On the topic of the EZ Water spreadsheet. Lactic acid additions seem to be applied to the mash volume only. Is this this way to do it for batch sparging?

I plan on making up all the water at once (keeping the final concentrations the same for mash and sparge water), but adding the lactic acid to the entire mash + sparge water doesn't seem to be what the consistent with the math within the spreadsheet...
The spreadsheet models mash pH, and sparge water composition does not affect mash pH. As such, it makes perfect sense that the spreadsheet does not contemplate sparge water adjustment. That said, if you need to add acid to your mash water it would be prudent to add it to sparge water as well.
__________________
remilard is offline
 
Reply With Quote Quick reply to this message
Old 09-27-2011, 04:44 PM   #156
mabrungard
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2011
Location: Carmel, IN
Posts: 2,665
Liked 177 Times on 155 Posts
Likes Given: 24

Default

Quote:
Originally Posted by DSmith View Post
On the topic of the EZ Water spreadsheet. Lactic acid additions seem to be applied to the mash volume only. Is this this way to do it for batch sparging?

I plan on making up all the water at once (keeping the final concentrations the same for mash and sparge water), but adding the lactic acid to the entire mash + sparge water doesn't seem to be what the consistent with the math within the spreadsheet...
The requirements for mash water and sparge water are not always the same. Sparge water should always have low alkalinity, mash water does not always have to have low alkalinity. EZ Water is properly focused on mash water adjustments.
__________________

Martin B
Carmel, IN
BJCP National
Foam Blowers of Indiana (FBI)

Brewing Water Information at:
https://sites.google.com/site/brunwater/

Like Bru'n Water on Facebook for occasional discussions on brewing water and Bru'n Water

mabrungard is offline
 
Reply With Quote Quick reply to this message
Old 09-29-2011, 02:06 PM   #157
deanocamino
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2011
Location: fairmont, wv
Posts: 8
Default

for those of you that use the ez calculator. According to palmers nomograph my water is best used for something around 10 srm. In making a stout I was thinking of using the nomograph to figure out what additions I need to make to get my "base" water profile to the appropriate levels for the given style.

Then enter that base into the "base water section" in the calculator and make addjust ments with additions from there.

Does this not make sence or do you think it is overkill????

__________________
deanocamino is offline
 
Reply With Quote Quick reply to this message
Old 09-29-2011, 09:35 PM   #158
ajdelange
Senior Member
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 5,690
Liked 541 Times on 444 Posts
Likes Given: 15

Default

Unless dramatic changes have been made to that spreadsheet plugging in stout color will result in a calculated RA which is absurdly high. Implementing such an RA will result in a mash pH that is way too high with the result that the beer will be dull, flat, lifeless. If your water is decent you should be able to make a stout with it without treatment unless you use inordinate amounts of black/roast/crystal malt. It is therefore best that mash pH be checked with a pH meter at dough-in.

There is a correlation between beer color and the RA of the water with which it is made. There is a correlation between the performance of the DJIA and the length of girls' skirts. I wouldn't invest based on fashion and I wouldn't set brewing water parameters based on color.

__________________
ajdelange is offline
 
Reply With Quote Quick reply to this message
Old 03-21-2014, 01:06 PM   #159
Glot
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2013
Location: Rockhampton, Queensland
Posts: 5
Default pH

I have a very basic question I could not find the answer to. As grains etc alter pH, how does the calculator know what the initial water pH was?

__________________
Glot is offline
 
Reply With Quote Quick reply to this message
Old 03-21-2014, 01:57 PM   #160
ajdelange
Senior Member
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 5,690
Liked 541 Times on 444 Posts
Likes Given: 15

Default

It doesn't and, to an almost unbelievable extent it doesn't need to. The object is to model the proton deficit of the water and most of the information about that is contained in the alkalinity number alone. For precise work the water pH does need to be considered but for the approximate/empirical models used in most spreadsheets the alkalinity alone suffices.

__________________
ajdelange is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
North Penn Water Authority (Montgomery Co., PA) Water Report lebshiff21 Brew Science 11 04-30-2014 10:13 PM
IPA water recipe - adjusting high bicarbonate water conpewter Brew Science 19 10-01-2010 05:29 PM
Water quality, what to do....Hard water and high pH. BroadStreetBrewery Brew Science 9 09-11-2010 04:12 AM
Water adjustment - Austin, TX water chloramines pale ale anastasis Brew Science 4 04-02-2010 05:31 PM
Tucson, AZ water profile results from water dept. herbler Brew Science 40 02-02-2010 04:31 PM