I just got the results from my water analysis. So I put the values into the Water Profile and my Alkalinity from BTP is lower than from the lab. Which is correct?
Ca = 45
Mg = 24
Na = 7
SO4 = 16
Cl = 9
HCO3 = 198
Hardness = 213
Alkalinity = 173 (lab) 162.4 (BTP)
Thanks,
Water Profile - Alkalinity value difference
Water Profile - Alkalinity value difference
Bob
PC: I7-3770S CPU, Windows 8.1 Pro 64-bit, 12 GB RAM, 1 TB HDD, 1920x1080 HD touchscreen
PC: I7-3770S CPU, Windows 8.1 Pro 64-bit, 12 GB RAM, 1 TB HDD, 1920x1080 HD touchscreen
- billvelek
- Imperial Stout
- Posts: 801
- Joined: Fri Mar 05, 2004 9:44 am
- Location: Arkansas, USA
- Contact:
My screen shows different hardness, too.
I just entered your list of minerals, and my BTP screen shows a "Hardness" of 211 rather than the 213 that you have listed. Is your figure from the lab, or has BTP somehow generated a different number for you than for me?
Also, when I changed the alkalinity field in my water chemistry screen to match the lab value, the only mineral that it changed in order to compensate was HCO3. I'm no chemist and so I have absolutely no idea, but I want to verify that that is correct. Just want to be sure that if there is a bug here, as per the lab report, that we find out everything that is affected.
Cheers.
Bill Velek
Also, when I changed the alkalinity field in my water chemistry screen to match the lab value, the only mineral that it changed in order to compensate was HCO3. I'm no chemist and so I have absolutely no idea, but I want to verify that that is correct. Just want to be sure that if there is a bug here, as per the lab report, that we find out everything that is affected.
Cheers.
Bill Velek
Visit www.tinyurl.com/bvelek - portal to my brewing sites: 3,100+ members on 'Grow-Hops', and 1,350+ brewers on my 'BrewingEquip' group.
Running BTP v1.5.3 on WinXP 2005 SP3 w/AMD Athlon 64@3800+, 1GigRam, Res 1024x768
Running BTP v1.5.3 on WinXP 2005 SP3 w/AMD Athlon 64@3800+, 1GigRam, Res 1024x768
Water analysis
All of the values listed with the exception of one Alkalinity are from Ward Labs in Nebraska. I also had the BTP calculated Hardness value of 211. I wish I had another lab report from a different water source to compare the BTP values with. I think this would be very helpful in determining what we're seeing. I guessing it's likely calculation rounding errors but they seem to be a little big. I'd have to see the calculations to be sure. I'm not a chemist either.
Bob
PC: I7-3770S CPU, Windows 8.1 Pro 64-bit, 12 GB RAM, 1 TB HDD, 1920x1080 HD touchscreen
PC: I7-3770S CPU, Windows 8.1 Pro 64-bit, 12 GB RAM, 1 TB HDD, 1920x1080 HD touchscreen
I'm no chemist, I'm a biochemist, which means I know as little as possible about chemistry , but my suspicion is that what you're seeing is something like assay error and rounding error.
Basically each of the assays performed to determine the individual values have a built in error range, +/- some %. Since BTP takes the individual measurements and calculates the alkalinity, it is subject to the cumulative error from each measurement. The testing lab titrates the alkalinity as an independent value, with it's own error, but not subject on the cumulative errors. Depending on how chance makes the results fall, things can average out to the same result, or tend to skew things in one direction.
I suspect there may also be some difficulty getting a good measure of HCO3 as it is affected by the equilibrium of dissolved gas and might fluctuate a bit.
Either way, I think you might be seeing evidence that your alkalinity probably isn't exactly 162, nor 171, but more like 166+/-3% (which really is good precision, 5% being more common in real world samples, so 162+/- 5.5% could easily be true, though I suspect that error is conservative given a single sample, and is probably closer to 10%.)
Also, other compunds can affect alkalinity, other than the ones mentioned and inluded in BTP's calculations, though usually minor, it might be enough to explain the difference between measured alkalinity and calculated alkalinity.
For these reasons, I think I would take the directly measured alkalinity as the most reliable data point, as CJ suggested, adjust the HCO3 as Bill points out, and remember that the target alkalinity for a given SRM is a range and you should target the middle of that range to account for error.
Sorry to be so wordy.
Basically each of the assays performed to determine the individual values have a built in error range, +/- some %. Since BTP takes the individual measurements and calculates the alkalinity, it is subject to the cumulative error from each measurement. The testing lab titrates the alkalinity as an independent value, with it's own error, but not subject on the cumulative errors. Depending on how chance makes the results fall, things can average out to the same result, or tend to skew things in one direction.
I suspect there may also be some difficulty getting a good measure of HCO3 as it is affected by the equilibrium of dissolved gas and might fluctuate a bit.
Either way, I think you might be seeing evidence that your alkalinity probably isn't exactly 162, nor 171, but more like 166+/-3% (which really is good precision, 5% being more common in real world samples, so 162+/- 5.5% could easily be true, though I suspect that error is conservative given a single sample, and is probably closer to 10%.)
Also, other compunds can affect alkalinity, other than the ones mentioned and inluded in BTP's calculations, though usually minor, it might be enough to explain the difference between measured alkalinity and calculated alkalinity.
For these reasons, I think I would take the directly measured alkalinity as the most reliable data point, as CJ suggested, adjust the HCO3 as Bill points out, and remember that the target alkalinity for a given SRM is a range and you should target the middle of that range to account for error.
Sorry to be so wordy.
Last edited by slothrob on Thu Feb 15, 2007 1:07 pm, edited 2 times in total.
BTP v2.0.* Windows XP
Agreed
A little less wordy , I agree. Since I'm really only concerned about being in a general pH range I think the numbers are likely to be close enough. Afterall this is homebrewing and not some large scale commercial brewery where I need to squeeze out every possible fraction of efficiency.
Thanks everyone.
Thanks everyone.
Bob
PC: I7-3770S CPU, Windows 8.1 Pro 64-bit, 12 GB RAM, 1 TB HDD, 1920x1080 HD touchscreen
PC: I7-3770S CPU, Windows 8.1 Pro 64-bit, 12 GB RAM, 1 TB HDD, 1920x1080 HD touchscreen
- billvelek
- Imperial Stout
- Posts: 801
- Joined: Fri Mar 05, 2004 9:44 am
- Location: Arkansas, USA
- Contact:
Re: Water analysis
Anyway, hardness values of 211 versus 213 seem to be very close to me; would it make any detectable difference?Bob wrote:Snip ...I also had the BTP calculated Hardness value of 211. ... snip
By the way, since your post I have focused a lot of my attention on water chemistry today, and posted a rather long message in the 'bugs' thread. At the same time -- and I hope Jeff reads this -- I happened upon a thread in rec.crafts.brewing about water chemistry, and one of the posts suggested this as a solution for a brewer with a particular water analysis: "I would treat a ten-gallon batch by adding one-half teaspoon of pickling lime and one tablespoon (2.8tsp) calcium chloride and one-half teaspoon powdered chalk, ...", so if those are legitimate additions, I think it would be useful for BTP database to include "pickling lime" and "powdered chalk", too.
Just a thought.
Cheers.
Bill Velek
Visit www.tinyurl.com/bvelek - portal to my brewing sites: 3,100+ members on 'Grow-Hops', and 1,350+ brewers on my 'BrewingEquip' group.
Running BTP v1.5.3 on WinXP 2005 SP3 w/AMD Athlon 64@3800+, 1GigRam, Res 1024x768
Running BTP v1.5.3 on WinXP 2005 SP3 w/AMD Athlon 64@3800+, 1GigRam, Res 1024x768
- billvelek
- Imperial Stout
- Posts: 801
- Joined: Fri Mar 05, 2004 9:44 am
- Location: Arkansas, USA
- Contact:
I googled it and ...
Pickling Lime is calcium hydroxide and Lye is Sodium Hydroxide.
Don't know if that is correct or not, but looks like several websites agree on that.
Once again, I would like to stress how convenient it would be to have both the chemical names and common layman's terms together in the browser; that's because in posts on different forums, one or the other are just as easily used.
Cheers.
Bill Velek
Don't know if that is correct or not, but looks like several websites agree on that.
Once again, I would like to stress how convenient it would be to have both the chemical names and common layman's terms together in the browser; that's because in posts on different forums, one or the other are just as easily used.
Cheers.
Bill Velek
Visit www.tinyurl.com/bvelek - portal to my brewing sites: 3,100+ members on 'Grow-Hops', and 1,350+ brewers on my 'BrewingEquip' group.
Running BTP v1.5.3 on WinXP 2005 SP3 w/AMD Athlon 64@3800+, 1GigRam, Res 1024x768
Running BTP v1.5.3 on WinXP 2005 SP3 w/AMD Athlon 64@3800+, 1GigRam, Res 1024x768