EZ Water Calculator 2.0 - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Calculator 2.0

Reply
 
Thread Tools
Old 09-15-2010, 03:54 PM   #1
-TH-
 
-TH-'s Avatar
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 910
Liked 95 Times on 54 Posts



EZ Water Calculator 2.0 is now available:
http://www.ezwatercalculator.com/

The spreadsheet now calculates the estimated mash pH rather than using Palmer's RA/SRM correlation. The pH is calculated using water profile data, SRM, amount of roasted malt, and mash thickness. Calculations are based on Kai's extensive mash water pH experiments, seen here:
http://braukaiser.com/documents/effe...on_mash_pH.pdf
and here:
http://braukaiser.com/wiki/index.php...ty_and_mash_pH

Version 2.0 also allows for addition of acidulated malt (Sauermalz).

Less focus is placed on the chloride to sulfate ratio, although it is still there.

Regional water profiles (i.e. Burton, etc.) have been removed.

Some disclaimers have been added - including one about the addition of chalk.

Here's a screenshot:
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

CBK Likes This 
Reply With Quote
Old 09-15-2010, 03:58 PM   #2
jmo88
 
jmo88's Avatar
Recipes 
 
Sep 2008
Seattle
Posts: 1,380
Liked 25 Times on 16 Posts


Nice! Thanks for all the hard work and keeping the spreadsheet up with current research. Looking forward to using this!

.... Any chance of uploading an html version. My Excel 2008 for Mac doesn't like the radial buttons for alkalinity and bicarbonate. This was the case in the last version too, so I always used the html version, which worked for selecting alkalinity.
__________________
(~):} Just a little Furthur (~):}

 
Reply With Quote
Old 09-15-2010, 04:14 PM   #3
Bobby_M
Vendor and Brewer
HBT_SPONSOR.png
 
Bobby_M's Avatar
Recipes 
 
Aug 2006
Whitehouse Station, NJ
Posts: 23,330
Liked 1765 Times on 1122 Posts


You freakin animal.
__________________
Welcome to BrewHardware.com. I love you.
New Stirplates are IN!
Chugger Pumps, Pump Kits, Camlocks, Sightglasses, Clear USA made Silicone Tubing, RIMS, Electric Install Parts, etc.

 
Reply With Quote
Old 09-15-2010, 04:25 PM   #4
wildwest450
Registered User
Recipes 
 
Dec 2007
Posts: 9,043
Liked 173 Times on 158 Posts


Sweet! Are crystal malts roasted? Or does that just apply to black patent and roasted barley?

 
Reply With Quote
Old 09-15-2010, 04:59 PM   #5
Douglefish
Recipes 
 
Dec 2008
Posts: 244
Liked 1 Times on 1 Posts


I always assumed that Crystal malts were not roasted (which contribute more acidity) and that roasted malts (Roasted Barley, chocolate, black patent) contributed less acidity. Is this true?

Also, how does munich and vienna play into this spreadsheet? When using Kai's spreadsheet I considered them to be roasted specialty malts.

 
Reply With Quote
Old 09-15-2010, 05:01 PM   #6
wildwest450
Registered User
Recipes 
 
Dec 2007
Posts: 9,043
Liked 173 Times on 158 Posts


Quote:
Originally Posted by aarondrich View Post
I always assumed that Crystal malts were not roasted (which contribute more acidity) and that roasted malts (Roasted Barley, chocolate, black patent) contributed less acidity. Is this true?

Also, how does munich and vienna play into this spreadsheet? When using Kai's spreadsheet I considered them to be roasted specialty malts.
I put munich in as a base grain, I hope that's right? Always more to learn.

 
Reply With Quote
Old 09-15-2010, 05:10 PM   #7
Douglefish
Recipes 
 
Dec 2008
Posts: 244
Liked 1 Times on 1 Posts


Ok, since we started it how about Aromatic? I'm assuming this is roasted?

 
Reply With Quote
Old 09-15-2010, 05:24 PM   #8
wildwest450
Registered User
Recipes 
 
Dec 2007
Posts: 9,043
Liked 173 Times on 158 Posts


The "specialty" grain heading is what throws me off, aren't all specialty grains roasted, at least to a point?

 
Reply With Quote
Old 09-15-2010, 05:25 PM   #9
adam01
Recipes 
 
Aug 2010
Lucas, Tx
Posts: 417
Liked 10 Times on 8 Posts


Any chance for a tsp size addition conversion ?

 
Reply With Quote
Old 09-15-2010, 05:35 PM   #10
-TH-
 
-TH-'s Avatar
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 910
Liked 95 Times on 54 Posts


here's the chart from Kai's paper:


Munich and Vienna are in the base malt grouping.

I think I will change the heading "specialty" malts to be "crystal - type" malts
and maybe list examples somewhere.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
North Penn Water Authority (Montgomery Co., PA) Water Report lebshiff21 Brew Science 11 04-30-2014 10:13 PM
IPA water recipe - adjusting high bicarbonate water conpewter Brew Science 19 10-01-2010 05:29 PM
Water quality, what to do....Hard water and high pH. BroadStreetBrewery Brew Science 9 09-11-2010 04:12 AM
Water adjustment - Austin, TX water chloramines pale ale anastasis Brew Science 4 04-02-2010 05:31 PM
Tucson, AZ water profile results from water dept. herbler Brew Science 40 02-02-2010 05:31 PM


Forum Jump