Tuesday, March 29, 2016

Brewing Water Calculator: MpH Water Calculator v3.0

Yes, here it is (drum roll, please), the long awaited update to my brewing-water calculator:  MpH Water Calculator v3.0.

The most significant changes are found on the Water Tab.  You can now enter ions for two water sources that you might mix for either mash or sparge water.  Typically one source is a municipal water supply while the other is RO or distilled, but the two sources can be from any two different water supplies.  In addition, the entries for the ions reflect the order that ions are reported in a typical water report from Ward Labs.  

I've also added BJCP 2015 style data, just for convenience.

The underlying model used to estimate mash pH is the same as previous versions of the calculator.  I'm currently working on a more fundamental (i.e., less phenomenological) model for the calculations.  With any luck this model will be implemented later this year.

As always, if you have any questions, use the comment section of this blog.  Cheers!


  1. Thanks again for this very convenient tool.

  2. Thanks for sharing- working through it now!

  3. This comment has been removed by a blog administrator.

  4. I am trying as an exercise to come up with the calculations for acid additions (interests me as a environmental engineer student). When determining how much mEq/mg provided by phosphoric acid your spreadsheet is basically 98mg/mEq, I was using 98mg/3mEq in error. Is 98mg/mEq because phosphoric acid will not fully protonate all three protons at the pH expected of a mash (only protonate once from H3PO4 -> H2PO4- + H+?)

    Crazy question

  5. Matthew, that is exactly correct.