New Giveaway - Wort Monster Conical Fermenter!

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




Reply
 
LinkBack Thread Tools Display Modes
Old 01-04-2013, 01:45 PM   #321
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 113 Times on 71 Posts
Likes Given: 4

Default

Quote:
Originally Posted by andycr View Post
Love this tool, thanks so much for it!

Biscuit malt is also counted as a roasted/toasted malt, right? If so, how far off will the calculations be since it's such a lower L rating (25L) than something like roasted malt (500L)? I suppose it's in the same class as Munich (toasted malt) which has it's own row in the drop-down, but it's so much darker (8L vs around 25L).

Thanks!
Only count roasted malts with a color rating higher than 50 L as roasted malts. Below that their acidity seems to follow that of base or crystal malts.

In the end you only have to guess the %roasted color in increments of 25% anyway.

Kai


Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 01-09-2013, 04:29 PM   #322
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 966
Liked 56 Times on 33 Posts
Likes Given: 2

Default

I have a question for those of you who are using lactic acid to adjust your mash pH. I noticed that I had put a 2x multiplier in my calculation on the spreadsheet for its affect on RA/mash pH. For the life of me I can't remember why I put that in there and I don't see anything in my notes. I think I am going to take this out for the next minor revision but before I do I would appreciate any feedback from those of you who use the spreadsheet and do lactic acid additions.

Thanks!



-TH- is offline
 
Reply With Quote Quick reply to this message
Old 01-09-2013, 05:03 PM   #323
solavirtus
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2010
Location: Ann Arbor, Michigan
Posts: 222
Liked 3 Times on 3 Posts

Default

Maybe because you were adding the lactic acid to both mash and sparge water? I realized I wasn't adding enough at first because I was adding salts and acid to my total water, but I think the acid calculation is for the mash water only.

__________________
solavirtus is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2013, 03:55 PM   #324
DeltaRage
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2012
Posts: 12
Likes Given: 1

Default

Quote:
Originally Posted by -TH- View Post
I have a question for those of you who are using lactic acid to adjust your mash pH. I noticed that I had put a 2x multiplier in my calculation on the spreadsheet for its affect on RA/mash pH. For the life of me I can't remember why I put that in there and I don't see anything in my notes. I think I am going to take this out for the next minor revision but before I do I would appreciate any feedback from those of you who use the spreadsheet and do lactic acid additions.

Thanks!
You mean that the effect of lactic acid is 2x its expected effect? Adding 1ml of lactic in the spreadsheet seems to change the predicted mash pH by -0.075. Does this mean that the rule of thumb of -0.1 is an overestimate?

The spreadsheet is great! Thanks for putting the work into it!

I'm guessing that this request has been made before, but a phosphoric acid addition calculator would be great.
__________________
DeltaRage is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2013, 10:04 PM   #325
DeltaRage
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2012
Posts: 12
Likes Given: 1

Default

I'm trying to determine the alkalinity of my water to input into the EZ spreadsheet, but I don't know what value in my water report is equivalent to "Bicarbonate (HCO3 ppm)" or "Alkalinity (CaCO3 ppm)". The relevant part of my water report reads as follows:

Alkalinity mg/L: 88
Hardness (as CaCO) mg/L: 124
pH: 7.7
Colour T.C.U.: 1
Conductivity μmhos/cm: 341
TOC mg/L: 1.8
Total Solids mg/L: 197

In the report, the "Hardness (as CaCO)" v. "Alkalinity" confuses me. Thanks for the help.

__________________
DeltaRage is offline
 
Reply With Quote Quick reply to this message
Old 01-12-2013, 05:35 AM   #326
ajdelange
Senior Member
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 5,208
Liked 452 Times on 371 Posts
Likes Given: 13

Default

Alkalinity and hardness are both reported as mg/L as CaCO3. Your alkalinity is 88.

__________________
ajdelange is offline
 
Reply With Quote Quick reply to this message
Old 01-12-2013, 02:20 PM   #327
atreid
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2011
Location: Montreal, Quebec
Posts: 318
Liked 45 Times on 37 Posts
Likes Given: 17

Default

Because the density of water is 1 g/ml, unit conversion calculations are resulting in:

1 mg/L = 1 ppm

If you ever come across some other heavier or lighter fluid like alcohol, this approximation is no longer true... mg/L is more thorough because it's always right, but both units are vastly used for water...

__________________
atreid is offline
 
Reply With Quote Quick reply to this message
Old 01-16-2013, 05:33 AM   #328
kshuler
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
kshuler's Avatar
Recipes 
 
Join Date: Mar 2010
Location: Seattle, WA
Posts: 275
Liked 4 Times on 4 Posts
Likes Given: 2

Default

Thanks for doing this!

__________________
Quote:
Originally Posted by Beer_Maker View Post
Light travels faster than sound. This is why some people appear bright until you hear them speak.
You can't reason someone out of a position they didn't reason themselves into.

-------------------------------------------
http://www.bokehtests.com
http://web.mac.com/kshuler/Site/Welcome.html
kshuler is offline
 
Reply With Quote Quick reply to this message
Old 01-22-2013, 08:31 PM   #329
deezy
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
deezy's Avatar
Recipes 
 
Join Date: Jan 2010
Location: Jefferson, GA
Posts: 210
Liked 1 Times on 1 Posts

Default

Great thread - I just received my wardlabs report and was trying to wrap my head around water additions. Feel pretty good about it now; ready to give this a shot. To anyone who may be new to water calculations, download the spreadsheet and read this entire thread...yes all 33+ pages. Cheers -TH- and HBT

__________________
deezy is offline
 
Reply With Quote Quick reply to this message
Old 01-27-2013, 12:50 PM   #330
JLem
naturally selected
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
JLem's Avatar
Recipes 
 
Join Date: Jan 2009
Location: Attleboro, MA
Posts: 3,637
Liked 168 Times on 148 Posts
Likes Given: 4

Default

Quote:
Originally Posted by -TH- View Post
Quote:
Originally Posted by kal View Post
TH, can you make that small change to the spreadsheet and change "sparge water" to "boil"?

I get emails every day from people who think taht sparge water additions need to go in their sparge water instead of the boil. Your v1 spreadsheet used to indicate this but v3 does not.

If I had a nickel for every time I told someone this, I'd have a lots of nickels to donate to you.

Kal
done deal. version 3.0.2 is now available.

btw I hope to be going electric in the near future and I must say you have got quite a resource over there at theelectricbrewery.com...
Is this the only change in v3.0.2? I have customized my v3.0.0 and don't really want to deal with doing it again with a new version unless there is a calculation change. Thank! (and...did I miss anything importatn in v3.0.1?)


__________________
My Hombrewing Blog

My Beer Cellar
JLem is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
EZ Water Calculator 2.0 -TH- Brew Science 159 03-21-2014 01:57 PM
EZ Water Calculator ? smuth10 Brew Science 22 04-26-2011 07:33 PM
Updated water calculator Kaiser Brew Science 3 03-26-2011 07:05 PM
EZ Water Calculator 2.0 and Batch Size VikeMan Brew Science 8 03-08-2011 02:23 PM
Question on EZ Water Calculator 2.0 adromo Brew Science 2 02-12-2011 04:40 PM