Tuesday, June 17, 2014

Brewing Water Calculator: MpH Water Calculator v2.0

So I have finally gotten around to updating my brewing water calculator; the current incarnation is MpH Water Calculator v2.0.  You may notice an increase in the number of sheets within the Excel workbook.  The goal of this increase is to make the calculator simpler to use.  Hopefully I've succeeded.  An instruction sheet leads things off.  You will likely find it helpful to refer to these instructions when first beginning to use the calculator.  Perhaps the biggest change is the water profiles sheet, which should be helpful as you design your water.  I've also added a sheet with BJCP style info, just for reference purposes.

As usual, feedback is welcome.  Cheers and Happy Brewing!

EDIT:  Here is a link to an .xls version for those using older versions of Excel:  MpH Water Calculator v2.0.xls.

5 comments:

  1. Might could you make an .xls version available?
    Thx.

    ReplyDelete
    Replies
    1. Done. The link has been added to the end of the above post.

      Delete
  2. Some fantastic work you have done here, I found reading your two papers on this topic very interesting and it's good to see them implemented in a spreadsheet!

    If I could suggest one very minor tweak - for the amount of acid added on the Mash pH page, you have labeled the units (ml / oz). It took me a slight amount of head scratching and number checking to realise this should be read as ml or oz, and indeed the extra spaces put in are now glowingly evident! But, to save someone perhaps the same issue, changing this unit label to (ml or oz) may be clearer.

    Keep up the good work !

    ReplyDelete
    Replies
    1. I see how this can be confusing. Thanks for the feedback. I'll come up with something a bit more clear. I'm glad you have found the papers and spreadsheet interesting and/or useful. Happy Brewing!

      Delete