• Please visit and share your knowledge at our sister communities:
  • If you have not, please join our official Homebrewing Facebook Group!

    Homebrewing Facebook Group

Bru'n water help

Homebrew Talk

Help Support Homebrew Talk:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
The A(pH) + B(pH) + C + D(pH) = 0 model is going to give you the best pH predictions provided that you feed it good data which really goes without saying. Simplified models in which the pH is computed as the average pHdi, the weighted average pHdi (best when weighted by a1 and mass; not quite as good if weighted by malt mass only) corrected by acid/base estimates of other mash components divided by estimated buffering capacity of the mash will give reasonable answers but not ones as good as those from the full model (A(pH) + B(pH) + C + D(pH) = 0). The extent of the sacrificed accuracy depends on how many of the simplifications/approximations are put into place in order to get the linearized result. Thus someone who wants to put together a spread sheet or calculator has a choice as to where between solving A(pH) + B(pH) + C + D(pH) = 0 iteratively for pH and pH ≈ ∑mi*pHdi/∑mi - (B +C + D)/a*∑mi he wants to be e.g. pH ≈ ∑a1*mi*pHdi/∑AI*mi - (B +C + D)/∑Ai*mi will give a better answer than pH ≈ ∑mi*pHdi/∑mi - (B +C + D)/a*∑mi .

I have always found the Brewers Friend calculator to give answers closest to those obtained by solving A(pH) + B(pH) + C + D(pH) = 0. This is in part because it is clear that Kai understands the chemistry. According to his 2009 paper we had apparently discussed prediction mash pH prior to then and I vaguely remember such discussions in which I recall I was pretty negative suggesting that the only way to do the problem was to use malt titratable acidity and I didn't think it was going to be possible to account for lot-to-lot, season-to-season etc. variations. I still think that's a problem. I had, even before that time period done a handful of malt titrations but was unaware that malt doesn't hold still while you titrate it. It just boggles my mind to think that this was 20 years ago!

In any case Kai went ahead and did titrations on a pretty good sized ensemble measuring both pHDi and an average value for a which his calculator apparently uses to predict mash pH shift from specialty malts. It is, thus, not surprising that his results resemble mine closely especially since when I don't have values for a1, a2 and a3 I'll estimate a1 from his titration data.

Other spreadsheets seem to take a more empirical approach which, while I have no direct knowledge, seem to typically start with a mash pH for base malt based on type or color and then compute shifts relative to that based on alkalinity (or bicarbonate content) of the water, the colors of high kilned malts or similar considerations and the strengths of added acids or bases. I do seem to recall that Martin commented somewhere that BW was based on Kai's work but I don't have any more information than that.

Ken Schwartz (KennyEddy) I haven't heard a peep from in 20 years. He told me that I wasn't nearly as crabby in person as he thought I would be from my postings so keep that in mind when you read my stuff!
 
The A(pH) + B(pH) + C + D(pH) = 0 model is going to give you the best pH predictions provided that you feed it good data which really goes without saying. Simplified models in which the pH is computed as the average pHdi, the weighted average pHdi (best when weighted by a1 and mass; not quite as good if weighted by malt mass only) corrected by acid/base estimates of other mash components divided by estimated buffering capacity of the mash will give reasonable answers but not ones as good as those from the full model (A(pH) + B(pH) + C + D(pH) = 0). The extent of the sacrificed accuracy depends on how many of the simplifications/approximations are put into place in order to get the linearized result. Thus someone who wants to put together a spread sheet or calculator has a choice as to where between solving A(pH) + B(pH) + C + D(pH) = 0 iteratively for pH and pH ≈ ∑mi*pHdi/∑mi - (B +C + D)/a*∑mi he wants to be e.g. pH ≈ ∑a1*mi*pHdi/∑AI*mi - (B +C + D)/∑Ai*mi will give a better answer than pH ≈ ∑mi*pHdi/∑mi - (B +C + D)/a*∑mi .

I have always found the Brewers Friend calculator to give answers closest to those obtained by solving A(pH) + B(pH) + C + D(pH) = 0. This is in part because it is clear that Kai understands the chemistry. According to his 2009 paper we had apparently discussed prediction mash pH prior to then and I vaguely remember such discussions in which I recall I was pretty negative suggesting that the only way to do the problem was to use malt titratable acidity and I didn't think it was going to be possible to account for lot-to-lot, season-to-season etc. variations. I still think that's a problem. I had, even before that time period done a handful of malt titrations but was unaware that malt doesn't hold still while you titrate it. It just boggles my mind to think that this was 20 years ago!

In any case Kai went ahead and did titrations on a pretty good sized ensemble measuring both pHDi and an average value for a which his calculator apparently uses to predict mash pH shift from specialty malts. It is, thus, not surprising that his results resemble mine closely especially since when I don't have values for a1, a2 and a3 I'll estimate a1 from his titration data.

Other spreadsheets seem to take a more empirical approach which, while I have no direct knowledge, seem to typically start with a mash pH for base malt based on type or color and then compute shifts relative to that based on alkalinity (or bicarbonate content) of the water, the colors of high kilned malts or similar considerations and the strengths of added acids or bases. I do seem to recall that Martin commented somewhere that BW was based on Kai's work but I don't have any more information than that.

Ken Schwartz (KennyEddy) I haven't heard a peep from in 20 years. He told me that I wasn't nearly as crabby in person as he thought I would be from my postings so keep that in mind when you read my stuff!


The one thing I thought might be useful in our discussion (sorry to the OP for hijacking the thread) is a bit of history...

When I rejoined at the German Brewing Forum I started modifying my brewing spreadsheet, which had a very simple and very useful water calculator built in (taking advantage of my recipe section for inputs), to account for sodium metabisulfite, the pH drop people were seeing, as well as the sodium and sulfate contributions from it. I started collaborating with The Beerery then and I joked that I would get the spreadsheet to a point where he could ditch Beersmith and Brun Water. That eventually happened.

The first major mod we did was to include the old "color override" hack from Brun Water as a dedicated user input for all the base Malts. You could essentially bypass the lovibond rating used for calculating beer color and input a value that account for different lots of the Weyermann Malts we were using. It worked well and we started seeing better results after that. Much closer to estimations.

Around this time we made 2 very major modifications that, in my opinion, really changed the sheet for the better and moved us even closer to the estimations we were getting: 1.) We implemented the DI pH user inputs and reworked the pH calculation and 2.) We incorporated the biological acidification calculations, allowing the use of Sauergut with the sheet.

This was all in service to the main spreadsheet, which is a total brewing software type deal, and we chose to make these changes, even in light of the fact that there are more detailed, robust calcs out there, because they were simple and the gains (better estimation, etc.) were huge. That is not to say I won't immediately implement new things when I get a hold of them. Your suggestion for a weighted average on the DI pH has already been incorporated and I also implemented a Sauermalz calc based off of Kai's original "Kaiser Water Calculator". The point is this: I don't think out sheet is perfect. I'll make a change at the drop of a hat if it will get us better predictions.

Th next step for me is incorporating a more full proof Sauermalz calc based on some of your posts a few pages back.

As for you being crabby, I'll say I've experienced worse!
 
An update from my collaborators brewery today:

I implemented a new calculation for Sauermalz based on Kai's "Kaiser Water Spreadsheet". I needed to set the acid % at 4.5 to match Weyermanns 1%/0.1 Δ pH so I had my collaborator go with that.

He targeted 5.4 and came in at 5.31 on both batches. So essentially he would have to increase the acid % even more to get 5.4.
 
An update from my collaborators brewery today:

I implemented a new calculation for Sauermalz based on Kai's "Kaiser Water Spreadsheet". I needed to set the acid % at 4.5 to match Weyermanns 1%/0.1 Δ pH so I had my collaborator go with that.

He targeted 5.4 and came in at 5.31 on both batches. So essentially he would have to increase the acid % even more to get 5.4.

if he already overshot on the acid, wouldn't he need to decrease the acid percentage?
 
if he already overshot on the acid, wouldn't he need to decrease the acid percentage?

No. It's a bit counterintuitive but as the acid percentage or strength modifier (depending on what is driving how powerful the Sauermalz is) goes up, you will have to use less Sauermalz.

In this case, he was shooting for 5.4 and overshot, meaning we assumed the Sauermalz was weaker than it was. If we now increase the acid %, we would have to use less Sauermalz and would move closer to target.
 

Latest posts

Back
Top