Happy HolidaySs Giveaway - Winners Re-Re-Re-Re-Drawn - 24 hours to Claim!

Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Calculator 3.0
Reply
 
LinkBack Thread Tools
Old 08-05-2011, 03:05 PM   #1
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 981
Liked 62 Times on 37 Posts
Likes Given: 2

Default EZ Water Calculator 3.0

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

v3.0 calculates mash pH differently now (using distilled water mash ph's of each grain in the grain bill among other things) and I think you'll find it considerably more accurate in predicting mash PH.

Also it has been rearranged a bit including separate sections for "adjust mash ph down" and "adjust mash ph up".

Also adjustment with slaked lime has been added.

Here's a screen shot:

__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com
-TH- is offline
2
People Like This 
Reply With Quote Quick reply to this message
Old 08-05-2011, 04:21 PM   #2
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 166 Times on 151 Posts
Likes Given: 4

Default

Nice work TH, i'm a big fan of the simplicity of these calculators.

_

__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 08-05-2011, 05:40 PM   #3
millstone
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2007
Location: In front of my computer in Hammond IN
Posts: 171
Liked 2 Times on 2 Posts
Likes Given: 4

Default

+1 on being a big fan... keeps getting better and remains simple to use

thanks,
tom

__________________
millstone is offline
 
Reply With Quote Quick reply to this message
Old 08-05-2011, 07:36 PM   #4
bsdx
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
bsdx's Avatar
Recipes 
 
Join Date: Apr 2010
Location: Perry, Michigan
Posts: 355
Liked 15 Times on 8 Posts
Likes Given: 2

Default

I plugged a previously brewed and measured really dark imperial stout into it and it was way more accurate, thanks! TH 2.0 predicted 4.73, TH 3.0 predicted 5.75, and measured was 5.62.

__________________
bsdx is offline
 
Reply With Quote Quick reply to this message
Old 08-05-2011, 08:53 PM   #5
MNDan
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Minnetonka, MN
Posts: 345
Liked 15 Times on 11 Posts
Likes Given: 8

Default

And thanks for putting in the pH recommended range w/ temp info - this looks great! Can't wait to try it!

__________________
MNDan is offline
 
Reply With Quote Quick reply to this message
Old 08-05-2011, 09:09 PM   #6
datamike
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2007
Posts: 105
Liked 2 Times on 2 Posts
Likes Given: 1

Default

Looks good!

I plugged a few recipes in and surprisingly, your calculator is quite close to the actual readings - generally within .05.

How about a field for phosphoric acid in the next revision?

Michael

__________________
datamike is offline
DeltaRage Likes This 
Reply With Quote Quick reply to this message
Old 08-05-2011, 09:13 PM   #7
mcaple1
Registered User
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2011
Location: Falcon, CO
Posts: 892
Liked 13 Times on 13 Posts

Default

subscribed

__________________
mcaple1 is offline
 
Reply With Quote Quick reply to this message
Old 08-10-2011, 02:35 AM   #8
CPooley4
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Cottage Grove, Wisconsin
Posts: 393
Liked 14 Times on 8 Posts

Default

TH - If I'm seeing the calculations properly it looks like you are using the distilled water mash pH of the crystal malts rather than the acidity as recommended in Kai's paper (I could be reading Kai's paper incorrectly though). Though utilizing the distilled water pH would seem to make perfect sense to me. Any thoughts on that?

Also, the distilled water pH for your calculator comes up as 4.92 for crystal 60 rather than 4.66 reported in Kai's paper. Did you do some separate experimentations to come up with your values as well?

Any thoughts on what to use for Aromatic, Brown Malt, Honey Malt, Victory, etc...? Essentially many of the specialty malts not listed specifically on your spreadsheet. Should we be using Base - Other?

Sorry for all the questions. Love the new look. I'm incorporating it into my brew workbook with some minor adjustments. Looking forward to working with it.

cp

__________________
CP's Brew Workbook

If you're considering buying brewing software do yourself a favor and download my Brew Chart/Workbook first. You may not need to spend that money.

I like beer math!
CPooley4 is offline
 
Reply With Quote Quick reply to this message
Old 08-10-2011, 12:56 PM   #9
ajdelange
Senior Member
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 6,351
Liked 657 Times on 544 Posts
Likes Given: 19

Default

Quote:
Originally Posted by CPooley4 View Post
TH - If I'm seeing the calculations properly it looks like you are using the distilled water mash pH of the crystal malts rather than the acidity as recommended in Kai's paper
Acidity could be used and I have proposed taking it one step further i.e. modeling the details of the acidity as a function of pH (finding a set of pK's which fit the titration curve for each malt) but in this case it appears that a simple linear combination of DI pH's serves quite well and is certainly much simpler both in terms of the math in the spreadsheet and the amount of lab work that would need to be done to get the input data. A single pH reading on a distilled water mash is much, much less involved than doing a titration and finding pK's that fit the titration. Even if the pK's were handed to you you would have to use iterative techniques to find the mash pH in the spreadsheet.

It should be clear that if malt A has a DI pH of 7.6 and malt B has a DI pH of 7.5 that a 1;1 blend of these 2 would have a pH somewhere in between but the fact that it seems to fall half way in between implying that a linear model is useful is a pleasant surprise!
__________________
ajdelange is offline
 
Reply With Quote Quick reply to this message
Old 08-10-2011, 01:06 PM   #10
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 981
Liked 62 Times on 37 Posts
Likes Given: 2

Default

Hey Cory,
Sorry I didn't get back to your PM. I'll respond here instead...

Quote:
Originally Posted by CPooley4 View Post
TH - If I'm seeing the calculations properly it looks like you are using the distilled water mash pH of the crystal malts rather than the acidity as recommended in Kai's paper (I could be reading Kai's paper incorrectly though). Though utilizing the distilled water pH would seem to make perfect sense to me. Any thoughts on that?
You are correct. As AJ says in the above post (and I'm paraphrasing), the KISS method actually works quite well here.

Quote:
Originally Posted by CPooley4 View Post
Also, the distilled water pH for your calculator comes up as 4.92 for crystal 60 rather than 4.66 reported in Kai's paper. Did you do some separate experimentations to come up with your values as well?
I did my own linear regression on his crystal data. His test result of c60 was a bit of an outlier.

Quote:
Originally Posted by CPooley4 View Post
Any thoughts on what to use for Aromatic, Brown Malt, Honey Malt, Victory, etc...? Essentially many of the specialty malts not listed specifically on your spreadsheet. Should we be using Base - Other?
I've been using 3.0 for a few months now and I use Northern Brewer's printed catalog to find what catagory a malt falls into, i.e. base, caramel, or roasted/toasted. You could also use their website: http://www.northernbrewer.com/brewin...ts/grain-malts (categories are listed in box on left). This has worked very well for me. Obviously I would love to lab-test every malt from every maltster, but until then...
Quote:
Originally Posted by CPooley4 View Post
Sorry for all the questions. Love the new look. I'm incorporating it into my brew workbook with some minor adjustments. Looking forward to working with it.
No problem. Thanks. Have at it! Great!
__________________
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
EZ Water Calculator 2.0 -TH- Brew Science 159 03-21-2014 02:57 PM
EZ Water Calculator ? smuth10 Brew Science 22 04-26-2011 08:33 PM
Updated water calculator Kaiser Brew Science 3 03-26-2011 08:05 PM
EZ Water Calculator 2.0 and Batch Size VikeMan Brew Science 8 03-08-2011 03:23 PM
Question on EZ Water Calculator 2.0 adromo Brew Science 2 02-12-2011 05:40 PM



Newest Threads

LATEST SPONSOR DEALS