Help Reading Water Reports

(That's water to the rest of us!) Beer is about 95% water, so if you want to discuss water treatment, filtering etc this is the place to do it!
barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 5:09 pm

I'm sorry but I don't understand. Should I subtract 5.5 from 13.7 and put the result into the co3 cell along with the 5.5 in the calcium?

Dave S
Even further under the Table
Posts: 2514
Joined: Sun Apr 01, 2012 5:38 pm
Location: Wirral, Merseyside

Re: Help Reading Water Reports

Post by Dave S » Wed Dec 04, 2013 5:19 pm

barry44 wrote:I'm sorry but I don't understand. Should I subtract 5.5 from 13.7 and put the result into the co3 cell along with the 5.5 in the calcium?
Yes, that's what it looks like from your figures. The calcium content of your total alkalinity (CACO3) is 0.4. So 0.6 of the total is carbonate. i.e. 13.7 x 0.4 = 5.48, (5.5), so carbonate = 13.7 x 0.6 = 8.22. Or 13.7 - 5.48 = 8.22
Best wishes

Dave

barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 5:21 pm

And thats me? Perfect!! Thanks very much. Now I need to figure out how to reduce my alkalinity in the mash.

Dave S
Even further under the Table
Posts: 2514
Joined: Sun Apr 01, 2012 5:38 pm
Location: Wirral, Merseyside

Re: Help Reading Water Reports

Post by Dave S » Wed Dec 04, 2013 5:24 pm

barry44 wrote:And thats me? Perfect!! Thanks very much. Now I need to figure out how to reduce my alkalinity in the mash.
I don't think you need to :) In fact you will need to increase it. For a pale ale it should around the 30 mark. You can increase it with baking soda. For darker ales it should be more like 100 - 110. For your sparge water I'd leave it alone.
Best wishes

Dave

barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 5:33 pm

Is that the bicarbonate value?

barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 5:43 pm

As shown on tab 3?

Dave S
Even further under the Table
Posts: 2514
Joined: Sun Apr 01, 2012 5:38 pm
Location: Wirral, Merseyside

Re: Help Reading Water Reports

Post by Dave S » Wed Dec 04, 2013 7:38 pm

barry44 wrote:Is that the bicarbonate value?
Is what the bicarbonate value? It starts getting a bit grey for me also if delving too deeply. I don't worry about bicarbonate, the spreadsheet calculates that automatically. I just know not to use both. You can calculate one from the other, but if you stick with CACO3 there's no need to think about HCO3.
Best wishes

Dave

barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 7:44 pm

is the bicarbonate value the one that i want to put up to around 30?

apologies if i am asking too much, many thanks for all your assistance so far.

Dave S
Even further under the Table
Posts: 2514
Joined: Sun Apr 01, 2012 5:38 pm
Location: Wirral, Merseyside

Re: Help Reading Water Reports

Post by Dave S » Wed Dec 04, 2013 8:15 pm

barry44 wrote:is the bicarbonate value the one that i want to put up to around 30?

apologies if i am asking too much, many thanks for all your assistance so far.
No, forget about bicarbonate, just concentrate on alkalinity. It's that that you want to adjust. You will see it change in the third from right most column in the finished water profile row. That is what you want to be in the range 30-50.
Best wishes

Dave

killer
Lost in an Alcoholic Haze
Posts: 578
Joined: Thu Feb 16, 2012 2:02 am
Location: Paris

Re: Help Reading Water Reports

Post by killer » Wed Dec 04, 2013 8:25 pm

Hi Barry

Carbonate (CO3) and Bicarbonate (HCO3) are basically the same thing and interconvert based on the pH of the water. It is often reported as CO3 but at the pH we work at is mostly present as Bicarbonate. So though you input your figures as Carbonate the spreadsheet looks at it as Bicarbonate. On page 3 of the spreadsheet you should try to match the suggested profiles (You don't have to by the way, some people think the profiles are more geared towards american flavours - but it is a good starting point).

You can play around with tweaking salt/ acid quantities to match your modified profile to the suggested profile. The Bicarbonate figure is really just a suggestion - there is no correct figure - its only really important in how it effects the mash pH - which is much more important - if you have a good predicted mash pH I wouldn't worry too much about the bicarbonate figure.

barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 11:14 pm

Many thanks once again gents. I love this site.

I had a play around with boosting my calcium a little and I see that it has dropped my ph, on tab 4, to 5.5 based on treating the mash water.

I assume that I add the salts to the grain for this?

It also mentions sparge water additions, I assume it is as simple as adding the salts to the sparge water as it heats?

barry44

Re: Help Reading Water Reports

Post by barry44 » Wed Dec 04, 2013 11:38 pm

Dave S wrote:
barry44 wrote:is the bicarbonate value the one that i want to put up to around 30?

apologies if i am asking too much, many thanks for all your assistance so far.
No, forget about bicarbonate, just concentrate on alkalinity. It's that that you want to adjust. You will see it change in the third from right most column in the finished water profile row. That is what you want to be in the range 30-50.
Perfect.

Thanks

User avatar
orlando
So far gone I'm on the way back again!
Posts: 7197
Joined: Thu Nov 17, 2011 3:22 pm
Location: North Norfolk: Nearest breweries All Day Brewery, Salle. Panther, Reepham. Yetman's, Holt

Re: Help Reading Water Reports

Post by orlando » Thu Dec 05, 2013 8:46 am

barry44 wrote: I assume that I add the salts to the grain for this?

It also mentions sparge water additions, I assume it is as simple as adding the salts to the sparge water as it heats?
The author advocates adding salts to the liquour to ensure a proper mix. Same applies to sparge water so yes. There has often been comment on why not treat all the water in one go, why bother to split into mash & sparge. The answer to this is it depends on what your starting water profile is and what style of beer you are trying to make with it. For example you may not need to alter your water for the mash at all but you will nearly always have to reduce the alkalinity of your sparge water if you live in a hard water area.
I am "The Little Red Brooster"

Fermenting:
Conditioning:
Drinking: Southwold Again,

Up Next: John Barleycorn (Barley Wine)
Planning: Winter drinking Beer

barry44

Re: Help Reading Water Reports

Post by barry44 » Mon Dec 16, 2013 9:59 pm

Gents, with regard to the sparge acidification page. Can you advise what I enter as my water alkalinity at the top of the page? Would it be 13.7?

AnthonyUK

Re: Help Reading Water Reports

Post by AnthonyUK » Mon Dec 16, 2013 11:07 pm

barry44 wrote:Gents, with regard to the sparge acidification page. Can you advise what I enter as my water alkalinity at the top of the page? Would it be 13.7?
It's extremely unlikely with 14 being the absolute maximum. How did you arrive at this?

Post Reply