EZ Water Calculator 2.0 - Page 3 - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Calculator 2.0

Reply
 
Thread Tools
Old 09-16-2010, 06:02 AM   #21
martinworswick
Recipes 
 
Sep 2008
southernlakes,new zealand
Posts: 285
Liked 3 Times on 3 Posts


thank you very much, i may try a bit of headscratching tinkering to see if i can convert it to metric-any suggestions appreciated, working in carpentry doesn't really require office software skills!

 
Reply With Quote
Old 09-16-2010, 06:54 AM   #22
soGGy
Recipes 
 
Aug 2009
Boulder Co
Posts: 30

Thanks for the work

 
Reply With Quote
Old 09-16-2010, 01:29 PM   #23
adam01
Recipes 
 
Aug 2010
Lucas, Tx
Posts: 413
Liked 10 Times on 8 Posts


The water report lists 'Hardness' as 55 (average). This is probably what you are looking
for.

 
Reply With Quote
Old 09-16-2010, 01:51 PM   #24
DrawTap88
Recipes 
 
Jan 2010
Joliet, IL
Posts: 1,066
Liked 9 Times on 9 Posts


Thank you. Thank you. Thank you.
__________________
Fermenting: Nothing
Secondary: Nothing
Bottled: Oatmeal Porter, Double Chocolate Chipotle Porter
Kegged: IPA, Red Rye

 
Reply With Quote
Old 09-16-2010, 04:53 PM   #25
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 9,015
Liked 1400 Times on 1067 Posts


Quote:
Originally Posted by adam01 View Post
The water report lists 'Hardness' as 55 (average). This is probably what you are looking
for.
No, he said alkalinity or bicarbonate neither of which is listed. Also he specifically said Bear Gulch which has an average hardness of 170. The 55 number is for the SFPUC district.

You may be confusing "carbonate hardness" with hardness. Carbonate "hardness" is the term Europeans sometimes use to describe alkalinity. In this case it means the part of the hardness which is paired with bicarbonate i.e. the alkalinity (at pH < 8.3). Here, the carbonate hardness, usually called "temporary hardness" in the US, is about 170 with the rest of the 189 being being "permanent hardness" (paired with sulfate and chloride). If there is no chloride or sulfate (or other anion) then alkalinity and hardness are the same.

And yes, I did say 50 last night but that was because, like the big dummy I can sometimes be, I didn't notice that the "as sulfur" check box on my spreadsheet was selected. The total alkalinity for these data would be about 189. I'll go back and correct yesterday's post.

 
Reply With Quote
Old 09-16-2010, 05:59 PM   #26
maida7
Recipes 
 
Nov 2009
Asheville, NC
Posts: 2,827
Liked 48 Times on 41 Posts


That is so Awesome! I can't wait to use it on my next batch! Thanks so much for your contributions to the community. You should get free beer everywhere you go.

 
Reply With Quote
Old 09-16-2010, 07:01 PM   #27
thorongil
Recipes 
 
Aug 2007
Buckeye, Arizona
Posts: 229
Liked 4 Times on 2 Posts


Why were the regional profiles removed? Doesn't that help us target the product we are shooting for? Other than that, I love the changes (and the work-around for Excel for Mac).

 
Reply With Quote
Old 09-16-2010, 08:52 PM   #28
RonRock
Always Ready
HBT_LIFETIMESUPPORTER.png
 
RonRock's Avatar
Recipes 
 
Jul 2008
Underwood, Iowa
Posts: 1,264
Liked 8 Times on 8 Posts


Quote:
Originally Posted by thorongil View Post
Why were the regional profiles removed? Doesn't that help us target the product we are shooting for.

Second that.

 
Reply With Quote
Old 09-17-2010, 01:34 AM   #29
-TH-
Recipes 
 
Oct 2008
Zeeland, Michigan
Posts: 903
Liked 90 Times on 53 Posts


Quote:
Originally Posted by thorongil View Post
Why were the regional profiles removed? Doesn't that help us target the product we are shooting for? ...
IMO the target we are shooting for is #1 getting pH right and #2 getting ions within preferred ranges (not necessarily matching a historical profile). I understand there might be a few hard core folks out there who really want to match regions - thats why I put it on v1.0 (it was by request). However, after I did that, so many people got the wrong idea thinking they HAD to match region profile. It created way more confusion that what it was worth. With v2.0 I figure if someone is bent on matching a profile, they can still do that by finding the values on their own and matching them by comparison. They should be aware however that to match the profile exactly might be difficult to get right and might require a lot of salts/acids - in which case the resulting water might not end up a perfect match due to factors outside the realm of this spreadsheet. Also, I've read (can't remember source) that the well-known breweries in these regions most likely adjust their water now anyway so attempting to match the published profiles is somewhat pointless.

Hope you can use it anyway

Cheers
__________________
TH

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

 
Reply With Quote
Old 09-17-2010, 02:00 AM   #30
thorongil
Recipes 
 
Aug 2007
Buckeye, Arizona
Posts: 229
Liked 4 Times on 2 Posts


That all makes good sense, and I will absolutely use the spreadsheet - it is a great tool for which I thank you. I'll just continue to compare to the regional ratios and RA to stay in the ballpark.

 
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