Palmer Spreadsheet Error

After reviewing a water profile created by a brewer using Palmer’s Spreadsheet, I found a very serious error that must be corrected.

The bicarbonate concentration calculated from the addition of chalk is in error.  It appears that the calculation is actually giving the carbonate concentration instead of the bicarbonate concentration.  Since carbonate cannot exist at typical mash pH, it must be converted to the bicarbonate form.  That means that the carbonate concentration should be multiplied by 2.033.  This also means that the alkalinity calculated for the chalk addition in the spreadsheet is also in error and should be multiplied by 2.033.

Another significant error in the spreadsheet is the residual alkalinity that the spreadsheet recommends based on the beer color.  It is far too aggressive and recommends far too high a RA value to the brewer.  There are no water profiles from the historic brewing centers with a RA higher than about 180.  This spreadsheet will frequently point a brewer to recommended RA values of 300 to 400.  That is extremely excessive and leads to soda water beers.  A more appropriate correlation between RA and SRM is as follows:  RA = SRM x 4.5.  And given that correlation, the maximum RA a brewer should ever use is about 200.

Until the revised spreadsheet is issued, I recommend that brewers refrain from using this program.

Martin,

You seem to be stumbling onto a lot of things that I have stumbled upon as well, which I like. I noticed the same when I calculated the ion balance of the water profiles created with that spreadsheet. However, I set out to test this in a mash pH experiment and found that while the spreadsheet seems to be incorrect the predicted pH change is correct. Eventually, after many more experiments, I came to the conclusion that undissolved chalk has an inexplicably odd behavior when it comes to adjusting mash pH.

Check out these links:

You may also want to give my water spreadsheet a try: http://braukaiser.com/documents/Kaiser_water_calculator.xls It handles undissolved chalk similar to what Palmer does but it also supports dissolving chalk.

I do agree. For some reason John found that roasted malts are more acidic per unit of color than crystal malts. I found that the opposite is true and as a result you need  far less alkalinity in dark beers than previously thought. Unfortunately John did not publish how he arrived at his SRM->RA formula.

Kai

I love this forum :slight_smile:

+1

Martin or Kai, have you contacted John with your concerns?

I had. But at the time he didn’t show much interest or had time to spend on this. He also didn’t show much interest when I mentioned this to him at the conference.

I don’t really need his input on this. Most of John’s work is based on A.J. deLange’s stuff anyway and I had e-mail conversations with A.J. about this. He can’t explain this observation either.

I think we need to get more brewers like Martin to question why the addition of 100 ppm CaCO3 doesn’t raise the water’s alkalinity (not residual alkalinity) by 100 ppm as CaCO3. Maye more brewers will adopt the spreadsheet I have. With some more data about undissolved chalk and its effects on the mash pH I could even put in a curve that determined the “apparent” RA increase that comes from undissolved chalk. This would make the relation between chalk and pH more apparent.

Kai

It’s too bad that John didn’t have time to deal with this.  Many brewers use his spreadsheet and accept is as “gospel”.  In that case, it needs to be accurate.  I’m glad we have people like Martin and you questioning things and trying to explain them.

I started pushing my water spreadsheet before I went on my brewing hiatus and haven’t picked up that effort. After all the question is not so much the RA that is calculated by the spreadsheet but it is “can you brew better beer with a more accurate spreadsheet”. John does recommend to limit the RA to 250 ppm and there is also a lot of leeway when it comes to the correct RA for a given beer. In addition to that he also doesn’t account for mash thickness.

Maybe Martin and other brewer’s interest motivates me to write the next version of my water spreadsheet which will take more grist information into account. I do have a lot of the data necessary for that. Ideally this work should be incorporated into a commonly used tool like BeerSmith.

I also think that you can add all your salts to the mash and don’t add any to the sparge water.

Kai

THIS!

I’d love to have a Grand Unified Theory of Brew Salt Additions hammered out that takes mash thickness, temperature, grist composition and accurately predicts pH, RA, and so forth.  I’d love to see it incorporated into BeerSmith along with better instructions for data entry as well as for brewing (e.g., Kai’s recommendation to add all the salts directly to the mash, not the HLT or the Sparge Water).

Martin, thank you for looking into it, as well.  Everytime you post something about water chemistry, believe me, I pay attention. Your expertise is evident–it takes me a few reads and re-reads to “get it.”)  Thanks for your input.  Perhaps a collaboration with you, Kai, and A.J. and any others who are interested (e.g., those who design and run BeerSmith) is in order.

Couldn’t agree more.  I also feel like it puts a little pressure on us that “sort of get it” to ask intelligent questions so that the information can trickle down through us to those who “don’t get it”.

One of the great things I have noticed about many of the complicated topics lately is that they have been working down from the complicated theory, to the simplified synopsus, and finally to must have take aways as the conversation evolves.  There’s a little something for everyone…

Keep up the good work everybody!

Being able to predict mash pH, or just about anything that could be predicted in brewing, is very much a home brewer thing. There seems to be little data available from the commercial brewing worlds and our understanding of mash pH is largely based on research done before WWII.

Over the time I have come to the conclusion that we may want to change the way mash pH adjustment is taught to home brewers. Let’s even forget about water profiles for a moment and see the mash pH problem as changing the pH of a pH buffer. The buffer is malt and its has a natural pH of ~5.75 in distilled water. What raises the pH are:

  • bicarbonate/carbonates
  • hydroxide (bases)

What lowers the pH are

  • mailard products in the malt
  • acids
  • Ca and Mg

You quantify the amount of all of these substances, calculate the balance  and use that to predict the pH change of the mash. There will be inaccuracies that come from the fact that malt is not a simple buffer substance but that it is a mix of pH buffering substances.

The notion of the water’s residual alkalinity is useful to estimate how suitable a given water is for a given type of beer but I don’t think that we should use it to actually predict mash pH.

I have done a number of experiments already and am currently working on experiments where I add known amounts of salts and acids to small mash sampled to see how their pH reacts. And again, chalk was the odd one. In some of the experiments the mash pH didn’t change at all after I added chalk.

Kai

That’s exactly what I do.

Same here. :)  Glad to have it validated by a water expert.

If you are using R/O or other soft water all that is going to happen is that your pre-boil pH is going to be identical or closer to your mash pH since the sparge water is not bringing in any additional minerals that could change the pH. It only dilutes the solution which tends to have little effect in well buffered systems.

Having the pre-boil pH close to the mash pH isn’t a bad thing. They both have about the same optimal pH range.

Kai

Cool, my water is pretty soft.  Not Plzen soft, but soft.  Ca 15, Mg 7.

I do the same but I figured since I was batch sparging it didn’t really matter because the sparge water was only in the tun for a short period of time. Can’t say if it makes a difference with fly sparging though.

Also,  I have been using Palmer’s spreadsheet for a while & found that if I adjust my water on the high end of the Estimated RA for lighter beers (<15 SRM) and on the lower end of the Estimated RA for darker beers (25+ SRM and never exceeding RA of 180) my beer turns out better. Might just be coincidence though.  Cheers!!!

Yes, I think you are fine.

Just as a clarification. Don’t confuse hardness with alkalinity. Alkalinity is a measure of the water’s bicarbonate/carbonate content while hardness is a measure of its Ca and Mg content. Granted, most hard waters also end up being fairly alkaline and most soft waters tend to be low in alkalinity. Waters that don’t follow this rule are the ones that have lots of Sulfate and/or Chloride. They can be hard (lots of Ca + Mg) but have low alkalinity (little HCO3). On the other side are soda alkaline waters which are characterized by high sodium and bicarbonate content. Those water’s are soft, in fact this is the kind of water that comes out of a water softener, but still alkaline.

Kai

I use Kai’s spreadsheet.  Don’t you all want to be cool like me and use it too?  :wink:

I add salts to the mash and sometimes to the boil, and just use acid to adjust sparge water.

Never had the need for a spreadsheet, though.  Wouldn’t brew without a pH meter, however.  Or at least with having used one enough in the common brewing situations to understand what causes my target mash pH to be hit.

A spreadsheet is a model.  Models may or may not accurately represent reality.  They may have unstated assumptions that don’t fit the circumstance you are in.  Using them without some form of validation is just shooting in the dark.

What would be the purpose of bypassing salt additions to the mash and putting the salts in the boil?
What does it accomplish?