The Old Forum Water Calculator

Discussion in 'Grain, Hops, Yeast & Water' started by MyQul, Nov 6, 2015.

  1. Nov 6, 2015 #1

    MyQul

    MyQul

    MyQul

    Chairman of the Bored Moderator

    Joined:
    Aug 7, 2013
    Messages:
    12,861
    Likes Received:
    4,501
    Location:
    Royal Hamlet of Peckham. London.
    clibit, ManseMasher and TheRedDarren like this.
  2. Nov 6, 2015 #2

    ManseMasher

    ManseMasher

    ManseMasher

    Guest

    Joined:
    Nov 29, 2014
    Messages:
    487
    Likes Received:
    351
    Well, I know which one I prefer. Thanks for finding it MyQul.
     
    MyQul likes this.
  3. Nov 6, 2015 #3

    clibit

    clibit

    clibit

    Senior Member

    Joined:
    Jun 2, 2013
    Messages:
    760
    Likes Received:
    262
    Location:
    Old Trafford
    The old ones are the best. :thumb:
     
    MyQul likes this.
  4. Nov 6, 2015 #4

    MyQul

    MyQul

    MyQul

    Chairman of the Bored Moderator

    Joined:
    Aug 7, 2013
    Messages:
    12,861
    Likes Received:
    4,501
    Location:
    Royal Hamlet of Peckham. London.
    I like it for it's simplicity
     
  5. Nov 12, 2015 #5

    Wicks

    Wicks

    Wicks

    Junior Member

    Joined:
    Aug 25, 2015
    Messages:
    28
    Likes Received:
    12
    Location:
    Essex
    I tried the water treatment calc with the example given on the Brupaks page but the figures for CRS come out quite different.

    http://brupaks.com/water%20treatment.htm

    Example given...
    CaC03 is 195 p.p.m
    target range of 30-50 p.p.m
    to reduce the alkalinity by 160 p.p.m. CRS should be added at a rate of 0.87ml
    So for 30 litres of liquor, 30 x 0.87 = 26ml of CRS.

    Put these same figures in the water treatment calc and I get 49.3ml CRS?
     
  6. Nov 12, 2015 #6

    clibit

    clibit

    clibit

    Senior Member

    Joined:
    Jun 2, 2013
    Messages:
    760
    Likes Received:
    262
    Location:
    Old Trafford
    Mirsultankhan's yer man. :thumb:

    He'll explain in a bit!
     
  7. Nov 12, 2015 #7

    TartanSpecial

    TartanSpecial

    TartanSpecial

    Regular. Supporting Member

    Joined:
    Dec 28, 2013
    Messages:
    974
    Likes Received:
    358
    I've just tried the old calculator...it is much easier to use than others and the results come out very similar to what Murphy and Son's recommended for different beer types after testing my water...so I'll be using this from now on.
     
  8. Nov 12, 2015 #8

    TartanSpecial

    TartanSpecial

    TartanSpecial

    Regular. Supporting Member

    Joined:
    Dec 28, 2013
    Messages:
    974
    Likes Received:
    358
    You need to put the 195ppm in the 'alkalinity as CaCO3' box in the calculator, not in the 'Carbonate CO3' box. Put it in the Alkalinity as CaCO3 box and it calculated out at 27.0ml for 30ltrs which is similar to 26ml in Brupaks example
     
    Wicks likes this.
  9. Nov 12, 2015 #9

    TartanSpecial

    TartanSpecial

    TartanSpecial

    Regular. Supporting Member

    Joined:
    Dec 28, 2013
    Messages:
    974
    Likes Received:
    358
    typo 27.9ml CRS
     
  10. Nov 13, 2015 #10

    Wicks

    Wicks

    Wicks

    Junior Member

    Joined:
    Aug 25, 2015
    Messages:
    28
    Likes Received:
    12
    Location:
    Essex
    Thanks TartanSpecial, makes sense now
     
  11. Nov 13, 2015 #11

    mirsultankhan

    mirsultankhan

    mirsultankhan

    Regular.

    Joined:
    Dec 3, 2014
    Messages:
    529
    Likes Received:
    95
    Location:
    Glasgow
    Yes HCO3 is the measurement for the bicarbonates (hardness) and CaCO3 the measurement for alkalinity (buffering capacity)

    Hardness
    Chemically, hardness is often defined as the sum of polyvalent cation concentrations dissolved in the water. The most common polyvalent cations in fresh water are calcium and magnesium.

    Alkalinity
    Alkalinity is a measure of the acid-neutralizing capacity of water. Alkalinity is usually reported as equivalents of calcium carbonate (CaCO3).

    What is the long suffering home-brewer to make of this? It appears to me and please correct me if I am wrong that hardness represents the total dissolved salts in water and that alkalinity is how much our water can resist change (normally acidic change). Naturally there is a symbiotic relationship between the two. As far as I can tell hardness is not really a problem, its the carbonates that are dissolved in the water that reduces our waters ability to resist change thats the problem. (spit ding!) Neutralize or get rid of them! That is why we can boil the water to get rid of some of the carbonates or we can treat our water with an acidic solution (like CRS) to weaken or neutralize the waters ability to resist change.


    Rather interestingly I was reading yesterday that Guinness used to add some sour beer to their famous brew to give it that 'Guinness twang' now they use lactic acid. German brewers add lactic acid to Munich malt and add that to reduce the alkalinity of the mash (acid malt) I think this would be an excellent addition because you typically only need about 1-2 percent (20-100g) to really effect the Mash and bring it down to an acceptable level.


    If anyone is interested I can put your water data and your target profile data into various software and we can compare the results. I really like the old forum calculator, its simple and gives instant results treating the mash and sparge separately. It has its limitations though in that it does not take the grain bill into consideration and some of the additions are a little excessive in comparison to other estimates. If it works for you though, do it! :D
     
    TartanSpecial and MyQul like this.
  12. Nov 13, 2015 #12

    TartanSpecial

    TartanSpecial

    TartanSpecial

    Regular. Supporting Member

    Joined:
    Dec 28, 2013
    Messages:
    974
    Likes Received:
    358
    good point on impact of grain bill. Roasted malts are acid, so I guess that's the reason you need to add less CRS (basis the calculator) for a generic stout/porter because the assumed roast malts in the recipe will be helping neutralize some of the alkalinity.
     
    mirsultankhan likes this.
  13. Nov 13, 2015 #13

    mirsultankhan

    mirsultankhan

    mirsultankhan

    Regular.

    Joined:
    Dec 3, 2014
    Messages:
    529
    Likes Received:
    95
    Location:
    Glasgow
    Yes, taking for example GW's Guinness Extra stout recipe on page 226, adding 445g of roasted barley adds 1.7 Meq/l of acidity to the mash. From what I can tell this equates to about .3 Ph which is quite considerable if we are aiming for a fairly narrow range between 5.2 and 5.6. so for example if I leave out the roasted barley my Ph gets pushed out of range from 5.6 to 5.9, gulp! 'Ol Arty Guinness certainly knew what he was doing! :D
     
  14. Nov 13, 2015 #14

    MyQul

    MyQul

    MyQul

    Chairman of the Bored Moderator

    Joined:
    Aug 7, 2013
    Messages:
    12,861
    Likes Received:
    4,501
    Location:
    Royal Hamlet of Peckham. London.
    Nice post MSK, especially the explantion between hardness and Alkalinity as that is definately a big elephant trap waiting to ensnare the novice water treament -er (that not even a word is it :lol:)

    No matter how hard you try and deny it, YOU are a definately the forum expert on water treatment ;) :thumb:
     
    mirsultankhan likes this.
  15. Nov 13, 2015 #15

    mirsultankhan

    mirsultankhan

    mirsultankhan

    Regular.

    Joined:
    Dec 3, 2014
    Messages:
    529
    Likes Received:
    95
    Location:
    Glasgow
    Haha you are very kind however the real experts are those guys like Martin Brungard that actually know and understand the chemistry. :grin:

    I have today purchased a set of scales for measuring salts to 0.1g, some lactic acid in liquid form for the sparge as required, some acid malt for the mash as required, lets see if it makes any difference.:drunk:
     
  16. Nov 14, 2015 #16

    trueblue

    trueblue

    trueblue

    Well-Known Member

    Joined:
    Jul 25, 2015
    Messages:
    248
    Likes Received:
    117
    Location:
    NULL
    Just tried this calculator and to be honest not really impressed. It tells me to use both Gypsum and epsom salts a practice I stopped doing about 15 years ago after having my water analysed by a specialized lab and showing my results to my late father in law a chemist working in the brewing industry. One comment he made was after working 30 years in brewing he has never found any water in the UK that needed add magnesium. Only CRS! what about sulpuric and hydrochloric.
     
  17. Nov 14, 2015 #17

    mirsultankhan

    mirsultankhan

    mirsultankhan

    Regular.

    Joined:
    Dec 3, 2014
    Messages:
    529
    Likes Received:
    95
    Location:
    Glasgow
    The calculator is what it is. The primary concern for any home brewer is to reduce carbonate if you need to and increase calcium again if you need to. The calculator does that. Personally I don't need any CRS because my water is ultra soft at 25ppm.

    Magnesium is for the sake of yeast but your late father in law is correct, its not critical.

    Gypsum and Epsom will help reduce the alkalinity of the water critical for ensuring a good mash Ph. If you do not think that it is suitable for you there are of course other calculators that you could try. If you post your water analysis and your target profile we could compare results.

    As a home brewer do we really want to be handling sulphuric and hydrochloric acid? I don't think so, lactic acid is available and so is acid malt.
     
  18. Nov 15, 2015 #18

    trueblue

    trueblue

    trueblue

    Well-Known Member

    Joined:
    Jul 25, 2015
    Messages:
    248
    Likes Received:
    117
    Location:
    NULL
    Handling acids is not hard, all you need is common sense. CRS and AMS are both blends of the 2 acids but will alter other minerals. Using sulphuric for pale beers and hydrochloric for dark beers is a much better option. AMS is made by Murhpy's, my FIL was very wary of that company. He said their testing was poor and some of the acids they sold were calculated wrong so I would be cautious with their products.
     
    TartanSpecial likes this.
  19. Nov 15, 2015 #19

    mirsultankhan

    mirsultankhan

    mirsultankhan

    Regular.

    Joined:
    Dec 3, 2014
    Messages:
    529
    Likes Received:
    95
    Location:
    Glasgow
    Aha! as I suspected, CRS/AMS does not actually remove carbonates it simply neutralizes them, is it not the case? One must note the difference between boiling and using CRS. Boiling will remove carbonates AND calcium whereas using CRS simply neutralise's the carbonates by adding an acidic solution and leaves the calcium. I don't use any CRS/AMS. All i need is 0.7ml of lactic acid to bring my sparge water to a PH of 6 and 20-50g of acid malt to bring the Mash to between 5.3 and 5.6 ph Problem solved, panic over.
     
  20. Nov 15, 2015 #20

    TartanSpecial

    TartanSpecial

    TartanSpecial

    Regular. Supporting Member

    Joined:
    Dec 28, 2013
    Messages:
    974
    Likes Received:
    358
    I think the CRS/AMS does remove the carbonates since the acid neutralisation process converts bi-carbonate to water and CO2. I double checked Murphy's data sheet: Time should be allowed to release the carbon dioxide
    produced by the neutralisation of excess carbonate
     
    Tony540 likes this.

Share This Page