Author Topic: Water Report  (Read 1935 times)

Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Water Report
« on: January 18, 2010, 03:00:45 PM »
Wohoooo!  Just got it!!   ;D

Now... I'm new to this so I don't really know what to make of it yet.  Here is the report.  Suprisingly the sulfates are low so I don't know why I'm getting such harsh and dry bittering?
pH: 7.8
Na: 6
K: <1
Ca: 50
Mg: 18
Total Hardness CaC03: 200
N03-N: <.1 (SAFE)
S04-S: 5
Cl: 6
C03: <1
HC03: 221
Total Alkalinity CaC03: 181

So... what the hell is this telling me?   :D   ???
« Last Edit: January 18, 2010, 06:01:20 PM by dean »

Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Re: Water Report
« Reply #1 on: January 18, 2010, 03:02:49 PM »
Maybe "harsh" is the wrong word... overpowering may be more correct.

Online Kaiser

  • Global Moderator
  • Senior Brewmaster
  • *****
  • Posts: 1797
  • Imperial Brewing Geek
    • View Profile
    • braukaiser.com
Re: Water Report
« Reply #2 on: January 18, 2010, 09:01:44 PM »
Suprisingly the sulfates are low so I don't know why I'm getting such harsh and dry bittering?

I don't think its the sulfates. Its your alkalinity. You have fairly alkaline water and light beers don't have enough acidity in the grist to lower your mash pH into the 5.4 - 5.6 range. As a result your boil pH is high and you extract more and harsher bitterness from the hops.

There are a number of options you have:

dillution + gypsum and or calcium chloride
lactic acid addition + gypsum and or calcium chloride

You can also reduce the alkalinity by adding some more calcium and boiling your water. As you may have already noticed in cooking this precipitates chalk. If you let that chalk settle and decant the clear water you'll have lower alkalinity water. But that takes a lot of additional energy. An alternative is the use of slacked lime (a.k.a pickling lime) but that is a rather advanced process that I don't want to get into now.

Kai

Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Re: Water Report
« Reply #3 on: January 19, 2010, 05:26:44 AM »
Thanks Kai.  :)  

I'm kinda confused on putting in either the CaC03 from the HC03 or the total hardness? on Palmer's spreadsheet, it asks for the source water in step 2 and again later from the total alkalinity?   Am I reading that right?

I went to your site Kai but I couldn't find the water calculator, did you remove it?

« Last Edit: January 19, 2010, 05:54:29 AM by dean »

Offline hokerer

  • I spend way too much time on the AHA forum
  • ********
  • Posts: 2634
  • Manassas, VA
    • View Profile
Re: Water Report
« Reply #4 on: January 19, 2010, 07:23:15 AM »
I went to your site Kai but I couldn't find the water calculator, did you remove it?

It's still there...

http://braukaiser.com/documents/Kaiser_water_calculator.xls
Joe

Online Kaiser

  • Global Moderator
  • Senior Brewmaster
  • *****
  • Posts: 1797
  • Imperial Brewing Geek
    • View Profile
    • braukaiser.com
Re: Water Report
« Reply #5 on: January 19, 2010, 09:41:17 AM »
I'm kinda confused on putting in either the CaC03 from the HC03 or the total hardness? on Palmer's spreadsheet, it asks for the source water in step 2 and again later from the total alkalinity?   Am I reading that right?

I think I need to clean up that confusion in the instructions. What we brewers need to know is Alkalinity: the water’s ability to neutralize acid. If the water report gives that it should be entered. If Alkalinity is not given it can be calculated from bicarbonate by making the assumption that the water pH is lower than ~8.5. That’s why a lot of spreadsheets allow for entering bicarbonates (HCO3-). While Alkalinity and hardness have the same unit (ppm as CaCO3) they are not necessarily the same.


Quote
I went to your site Kai but I couldn't find the water calculator, did you remove it?

Yes, I renamed it since water_calculator.xls was a bit too generic. But I should have updated all the links as well.
« Last Edit: January 19, 2010, 02:09:47 PM by Kaiser »

Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Re: Water Report
« Reply #6 on: January 19, 2010, 01:00:39 PM »
I've been playing with J.Palmer's spreadsheet and after reading your last post, Kai, I'm supposing I should enter the total alkalinity CaC03 ppm where I had been entering the the bicarbonate HC03 ppm in the section it asked.  I understand that JP's program will work either way as long as I select which one I want to use and input the correct ppm profile for whichever one is selected.  But it appears to change the adjusted profile if I go from one to the other without changing any of the other inputs.

When I give the program an SRM value and have my water profile it tells me I need additional water hardness, should I try to add that much more so the adjusted profile has that much in addition to what it started with?  I've messed with it quite a bit and the more I do it the more I understand it but I also like the KISS approach so I went with lactic acid alone and it adjusted the profile enough to where its balanced but I'm afraid I won't get as much aroma or flavor from the hops with such low S04 or will it only effect the character of the bitterness?  I followed the link to your spreadsheet program but I can't input anything, its protected so its read only.  Do I have to register and log on or something?

Sorry to be a pain.   :-[ 

Offline hokerer

  • I spend way too much time on the AHA forum
  • ********
  • Posts: 2634
  • Manassas, VA
    • View Profile
Re: Water Report
« Reply #7 on: January 19, 2010, 01:45:47 PM »
I followed the link to your spreadsheet program but I can't input anything, its protected so its read only.  Do I have to register and log on or something?

You do understand that you can only enter things into the cells that are "grey", right?  The "yellow" cells are the results of calculations and are protected.
Joe

Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Re: Water Report
« Reply #8 on: January 19, 2010, 02:13:25 PM »

You do understand that you can only enter things into the cells that are "grey", right?  The "yellow" cells are the results of calculations and are protected.

Arghhh!  I was trying it backwards, its the yellow on JP's spreadsheet so you know I didn't "READ" the little table at the top.   ::)   :D  Thanks!   ;D

Online Kaiser

  • Global Moderator
  • Senior Brewmaster
  • *****
  • Posts: 1797
  • Imperial Brewing Geek
    • View Profile
    • braukaiser.com
Re: Water Report
« Reply #9 on: January 19, 2010, 02:16:35 PM »
I followed the link to your spreadsheet program but I can't input anything, its protected so its read only.  Do I have to register and log on or something?

You do understand that you can only enter things into the cells that are "grey", right?  The "yellow" cells are the results of calculations and are protected.

Yes it's protected so you don't change anything that doesn't need changing. You can also un-protect it if you want.

Note that John and I use different algorithms for calculating the necessary residual alkalinity based on the beer color.

What beer color are you going for?

Kai


Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Re: Water Report
« Reply #10 on: January 19, 2010, 02:40:02 PM »
I'm just playing with them now but I think I'm going to do two different batches, one with an SRM of about 7 to 10 and one with an SRM of about 3 to 6.  I'd like to do a pilsen sometime soon I'm thinking 80% distilled water.  I am getting sooo tired of dark beer.   :D

How do I input for using lactic acid... I see it says % of water, I plugged in 1 just to see what it would do but I didn't see anything change.  I'll mess with it some more, I'm going to have to learn more about the metric system.  I think this might help get me motivated again.   ;D

Online Kaiser

  • Global Moderator
  • Senior Brewmaster
  • *****
  • Posts: 1797
  • Imperial Brewing Geek
    • View Profile
    • braukaiser.com
Re: Water Report
« Reply #11 on: January 19, 2010, 03:01:20 PM »
I took the liberty to fill in the numbers for your water, set the units to lb and gal and made an assumption about the amount of water and grain you’ll be using.

http://braukaiser.com/documents/misc_forum/Kaiser_water_calculator_for_dean.xls

When you enter lactic acid (88% or acid malt) as % of water the water treatment becomes independent from the actual water volume which might be helpful.

I assumed 10lb of grain and a strike water volume of 4 gal. This gives a mash thickness of 1.6 qt/lb. To estimate the mash pH the spread sheet needs to know the mash thickness in addition to the beer color and residual alkalinity.

Once you enter the beer color you get a mash pH estimate. That estimate should be between 5.3 and 5.6. To make a 5 SRM beer with your water I can add 1% of the water’s weight as acid malt. This drops the residual alkalinity to -190 ppm CaCO3 and gives a mash pH estimate of 5.3. I also added 100 ppm gypsum to boost your calcium and sulfate levels.

If you want to dilute the water with distilled or RO water, enter the percentage of your tap water into E18. If you choose 50/50 enter 50%. Now cut back on the acid malt and lower it to 0.8% of the water weight. That gives you about the same mash pH.

Kai


Offline dean

  • Brewmaster
  • *****
  • Posts: 922
  • Me and Hayden, my newest grandson.
    • View Profile
Re: Water Report
« Reply #12 on: January 20, 2010, 11:52:54 AM »
Thanks Kai!   :)   I spent a couple of hours yesterday and last night messing with all of the calculators too.  I've been calling the pharmacies and health food stores... nobody carries any of these minerals in their pure form that is food grade.  Everything is cut with something, magnesium, talc, phosphorus, etc.  So I'm going to order some online.  I have a couple of minerals now I just need to see which ones I have, I know I have lactic acid, epsom salt and I think I have calcium chloride but it may be calcium carbonate so I have to look to be sure.  It amazed me that none of the pharmacies carry gypsum.  When I was a kid the pharmacys were old school and stocked all sorts of mineral salts etc.  I guess I'll order some acid malt while I'm at it.   :)

Thanks again!   ;D

Offline uisgue

  • Cellarman
  • **
  • Posts: 77
    • View Profile
    • Symposia Brew Corps
Re: Water Report
« Reply #13 on: January 31, 2010, 10:15:03 AM »
Reading this thread, I am wondering if my water is too alkaline also.  Last spring I moved a couple of hundred miles and now have different water.  I have noticed a pronounced harshness to the bitterness in the batches I have done here.  I have never fiddled with the water chemistry before, but I have some Gypsum on hand.  I am thinking that I could add a few grams (10 gallon batches) and see if it helps.  I have no numbers to work with.  I would be trying to work bass-ackwards from the symptoms.  Plausible?
Thanks, Doug
Doug Hickey
Crescent City, CA
Symposia Brew Corps

Online denny

  • Administrator
  • I must live here
  • *****
  • Posts: 11659
  • Noti OR [1991.4, 287.6deg] AR
    • View Profile
    • Dennybrew
Re: Water Report
« Reply #14 on: January 31, 2010, 10:27:25 AM »
Difficult, Doug.  I'd recommend spending $16.50 and getting test W-6 from Ward Labs.  Check it out at wardlab.com .  That way, you aren't shooting in the dark.
Life begins at 60.....1.060, that is!

www.dennybrew.com

The best, sharpest, funniest, weirdest and most knowledgable minds in home brewing contribute on the AHA forum. - Alewyfe