Author Topic: Setting up a water profile from city data  (Read 5512 times)

Offline Stingray

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 4
  • BeerSmith 3 Rocks!
Setting up a water profile from city data
« on: October 31, 2012, 04:07:04 PM »
I have a quick question concerning setting up a new water profile in comparison to the locations already loaded into BeerSmith.  What are the units used in your location profiles - they are parts per million but I don't know as what.  My city water analysis expresses the calcium, magnesium, chloride, etc. in ppm as CaCO3.  You can also express it as ppm of other equivalents.  This can make a big difference in the numbers and making comparison to your location profiles.

Do you have any more information on the locations profiles units in BeerSmith?
« Last Edit: October 31, 2012, 06:26:29 PM by Stingray »

Offline factory

  • BeerSmith Master Brewer
  • ****
  • Posts: 75
  • The Factory Alewerks
Re: Setting up a water profile from city data
« Reply #1 on: November 05, 2012, 11:23:25 AM »
I'm sure that someone will correct me on this, but from what I recall many resources you find show mg/L the same as ppm, but its not exactly true.

Pure water at standard temperature and pressure has a density of 1 kg/L, therefore:

mg/L = mg/kg = ppm

I used this online calculator: http://www.unitconversion.org/concentration-solution/milligrams-per-liter-to-parts-per-million-ppm-conversion.html

It really is so close as to be a direct conversion, so you can almost disregard the calculation and do a direct conversion.

Hope this helps.

Fermenter 1: Lite American Lager (first lager!)
Fermenter 2: empty
Keg 1: Bell's Two Hearted Ale Clone
Keg 2: Factory Punkin Awesome!

Offline Stingray

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 4
  • BeerSmith 3 Rocks!
Re: Setting up a water profile from city data
« Reply #2 on: November 05, 2012, 06:59:48 PM »
factory - thanks for your response.  I probably need to clarify my question a bit. 

All of the mineral values in the water profile are in ppm.  I'm wondering if all of these are using a common weight basis. 

On most water reports, for example, calcium is reported in terms of "calcium as CaCO3."  The value reported is the weight of CaCO3 that is chemically equivalent to the amount of calcium present.  In my water report, many of the other minerals are also stated in terms of "CaCO3"   I'm wondering if alkalinity and the other minerals in BeerSmith, are all expressed in terms of CaCO3. 

I want to make sure the values for my local water are entered in the same common weight basis as the other locations found in BeerSmith.

Offline factory

  • BeerSmith Master Brewer
  • ****
  • Posts: 75
  • The Factory Alewerks
Re: Setting up a water profile from city data
« Reply #3 on: November 06, 2012, 08:31:09 AM »
Stingray,
I'm sorry that I didn't fully understand your initial question.  I'm not overly smart when it comes to chemistry, I'm completely self-taught.  Your question is very interesting to me, and I feel that now I need to look at my own water profile again.  It did find a paper online that describes what I think that you are saying.  The paper has to do with raising fish, but I still think that the basis of water hardness vs. alkalinity is described pretty well.  It also describes the contributions of various minerals expressed in terms of CaCO3.

http://www.ca.uky.edu/wkrec/Hardness.pdf

Again, I realize now that I'm probably not the right guy to answer this for you, but I can hope that I've at least pointed you towards something useful.
Fermenter 1: Lite American Lager (first lager!)
Fermenter 2: empty
Keg 1: Bell's Two Hearted Ale Clone
Keg 2: Factory Punkin Awesome!

Offline tom_hampton

  • BeerSmith Grandmaster Brewer
  • *****
  • Posts: 929
  • BeerSmith 2 Rocks!
    • Tom's Miata Racing Blog
Re: Setting up a water profile from city data
« Reply #4 on: November 06, 2012, 11:09:24 AM »
Beersmith deals in "ppm as the ion", aka pure ppm...rather than as equivalent weights...as do most other brewing references.  So, you will need to convert your "ppm as CaCO3" to ppm by multiplying by the ratio of equivalent weights (ION/CaCO3). 

See here: http://www.howtobrew.com/section3/chapter15-1.html  (bottom of the page, section Water Hardness, Alkalinity, and milliEquivalents)  for necessary tables, and formulas.




R.I.P.:Belgian Blonde
On Tap: Apfelwein, Kolsch(v2), Pumpkin Ale, Belgian Specialty 
Aging/Storing: Coffee Porter, Chocolate Porter, Flanders Red, English Barlywine
Fermenting: Maggie's Altbier
Next Up: PtE(1.1), Belgian Dubbel?

Working thru all BCS recipes

Offline Stingray

  • BeerSmith Apprentice Brewer
  • **
  • Posts: 4
  • BeerSmith 3 Rocks!
Re: Setting up a water profile from city data
« Reply #5 on: November 06, 2012, 06:07:40 PM »
Awesome - I had landed on Palmer's table several times searching for information on this topic, but never found anything defining BeerSmith's setup -  "ppm as the ion" vs equivalent weights. I'm going to assume it's the same for all of the minerals.

Thanks for the help!!!
« Last Edit: November 06, 2012, 07:44:29 PM by Stingray »