Spike Brewing 12.5 Conical Fermenter Giveaway - Enter Now!

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

Reply
 
LinkBack Thread Tools
Old 09-15-2010, 03:54 PM   #1
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 975
Liked 59 Times on 35 Posts
Likes Given: 2

Default EZ Water Calculator 2.0

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/effect_of_water_and_grist_on_mash_pH.pdf
and here:
http://braukaiser.com/wiki/index.php/Beer_color,_alkalinity_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
-TH- is offline
CBK Likes This 
Reply With Quote Quick reply to this message
Old 09-15-2010, 03:58 PM   #2
jmo88
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2008
Location: Seattle
Posts: 1,401
Liked 18 Times on 14 Posts
Likes Given: 9

Default

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 (~):}
jmo88 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 04:14 PM   #3
Bobby_M
Vendor and Brewer
HBT_SPONSOR.png
Vendor Ads 
Feedback Score: 2 reviews
 
Bobby_M's Avatar
Recipes 
 
Join Date: Aug 2006
Location: Whitehouse Station, NJ
Posts: 21,906
Liked 940 Times on 626 Posts
Likes Given: 28

Default

You freakin animal.

__________________
BrewHardware.com
Sightglass, Refractometer, Ball Valve, Weldless bulkhead, Thermometer, Decals, Stainless Steel Fittings, Compression Fittings, Camlock Quick Disconnects, Scale, RIMS tube, Plate Chiller, Chugger Pump, Super Clear Silicone Tubing, and more!

New Stuff?
Bobby_M is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 04:25 PM   #4
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 164 Times on 149 Posts
Likes Given: 4

Default

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

__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 04:59 PM   #5
Douglefish
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2008
Posts: 239
Liked 1 Times on 1 Posts
Likes Given: 1

Default

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.

__________________
Douglefish is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 05:01 PM   #6
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 164 Times on 149 Posts
Likes Given: 4

Default

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.
__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 05:10 PM   #7
Douglefish
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2008
Posts: 239
Liked 1 Times on 1 Posts
Likes Given: 1

Default

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

__________________
Douglefish is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 05:24 PM   #8
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 164 Times on 149 Posts
Likes Given: 4

Default

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

__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 05:25 PM   #9
adam01
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: Lucas, Tx
Posts: 343
Liked 3 Times on 3 Posts

Default

Any chance for a tsp size addition conversion ?

__________________
adam01 is offline
 
Reply With Quote Quick reply to this message
Old 09-15-2010, 05:35 PM   #10
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 975
Liked 59 Times on 35 Posts
Likes Given: 2

Default

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
-TH- is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
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 04:31 PM