breakdown water analysis

wateranalysis

UPDATED 11/2/11


Water is crucial to making great beer. Why is Dublin water excellent for stouts? Why does Burton make great pale ales? It’s all about the water baby. To help me learn water adjustments and to satisfy my geek-out requirements, I built a water analysis tool. Fundamentally, it is built on top of the excellent spreadsheet from John Palmer with powerful pH analysis from Braukaiser (seriously, go read this guy’s white paper right now, good stuff). Not only does it combine a bunch of great analytical tools, I also built macro’s that automatically solve for the required salt additions to reach a target water profile (in a somewhat unoptimized nonetheless effective way right now).
COMMENTS ENCOURAGED!


Give it a shot for yourself: WaterAnalysis_V2.0


Please note at this time this spreadsheet’s macros will ONLY function in MS Excel 2007. Sorry open sourcers, I feel your pain.




This entry was posted on Monday, April 19th, 2010 at 8:09 pm and is filed under musings, references. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “breakdown water analysis”

  1. Chris says:

    Andy, this is awesome. I’m looking forward to getting home from work and messing around with it some. I don’t do a lot of water adjustment generally, but I’ve committed myself to really try to wrap my head around water chemistry for brewing. This is going to help.

    I’ll give you some feedback after I’ve put it to action.

    I should check out your site more often. Good stuff.

    May 18th, 2010 at 7:02 pm


Leave a Reply

designed and authored by andy farley