Bru'n Water - Strange results in ver. 2.12

(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: Bru'n Water - Strange results in ver. 2.12

Post by barry44 » Thu Nov 13, 2014 12:45 pm

wallybrew,

my water profile is as follows:

Hi all,

ive just received revised information from Scottish Water regarding the supply to the house, the hardness has went up slightly for the report last year.

To this end, i want to see if i am entering the information correctly into Bru n water.

The information received was as follows:

The water in your area is soft. Please find below, readings supplied by our Public Health Team:

Expressed as Calcium Mg/l 6.1
Expressed as Calcium Carbonate Mg/ 15.3
Expressed as Calcium Millimoles 0.2
Expressed as French 1.5
Expressed as English 1.1
Expressed as German 0.9

I also received a fact sheet that allowed me to add the various other minerals to the sheet.

My Water Report Input worksheet now looks like this:

Calcium - 6.1
Magnesium - 3.7 (used multiplier as per sheet)
Sodium - 3.9 (from report)
Potassium - 0 (none reported)
Iron - 0 (minimal amount reported)
Bicarbonate - 18.5 (used multiplier as per sheet)
Carbonate - 9.2 (used multiplier as per sheet)
Sulphate - 8.1 (from report)
Chloride - 5.9 (from report)
Nitrate - 1 (from report)
Nitrite - 0 (from report)
Fluoride - 0 (from report)

This gives me a Cation/Anion difference of 0.18.

if you pm your email address, ill send over the spreadsheet.

WallyBrew
Hollow Legs
Posts: 473
Joined: Sat Jan 05, 2008 11:30 pm
Location: Surrey

Re: Bru'n Water - Strange results in ver. 2.12

Post by WallyBrew » Thu Nov 13, 2014 1:14 pm

I think you want barneey's email address as "being a supporter" he has at least two versions of Bru'n Water.

You cannot do what you have done with your report. The 6.1 calcium refers to hardness and has been reported in various ways. This 6.1 is the sum of calcium + (magnesium x 40 / 24) and expressed as calcium. So you do not know how much you have of either. What you have done is enter that 6.1 as calcium and then taken this value and expressed it as magnesium which means you have entered the same value twice albeit in different forms. You could have a guess and call calcium 4 leaving 2.1 which you then express as magnesium, hence you would then have 4.0 Ca and 1.26 Mg.

Likewise your bicarbonate is incorrect because you do not know the alkalinity, you only know hardness as CaCO3 which is not the same thing.

barry44

Re: Bru'n Water - Strange results in ver. 2.12

Post by barry44 » Thu Nov 13, 2014 6:47 pm

Thanks wallybrew, this is mind boggling.

barry44

Re: Bru'n Water - Strange results in ver. 2.12

Post by barry44 » Thu Nov 13, 2014 7:25 pm

Wallybrew, there is a calculator in bru n water that gives you a Bicarbonate value from the calcium carbonate value.

This is where i get the 18.5 from

WallyBrew
Hollow Legs
Posts: 473
Joined: Sat Jan 05, 2008 11:30 pm
Location: Surrey

Re: Bru'n Water - Strange results in ver. 2.12

Post by WallyBrew » Thu Nov 13, 2014 7:30 pm

barry44 wrote:Wallybrew, there is a calculator in bru n water that gives you a Bicarbonate value from the calcium carbonate value.

This is where i get the 18.5 from
But……… your calcium carbonate figure is a hardness figure not an alkalinity one. Your alkalinity is likely to be less than 18.5 as HCO3

barry44

Re: Bru'n Water - Strange results in ver. 2.12

Post by barry44 » Thu Nov 13, 2014 8:12 pm

You've lost me!! I am but a humble electrical engineer!!!

I think I'll be sending you some water soon.

Post Reply