Ss Brewing Technologies Giveaway!

Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet
Reply
 
LinkBack Thread Tools
Old 09-03-2009, 04:29 PM   #1
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 977
Liked 59 Times on 35 Posts
Likes Given: 2

Default EZ Water Adjustment spreadsheet

Go here to download the spreadsheet:
www.EZWaterCalculator.com
Version 1.7 (2-26-10)

Instructions:

Step 1: Enter your starting water profile, mash & sparge volumes, and dilution rate (if any).

Step 2: Examine the results.

1) Residual Alkalinity (RA) - See if the corresponding color range (SRM) matches the beer you are brewing. If not, the RA will need to be adjusted in order for the mash to be at the proper pH.
2) Chloride to Sulfate Ratio - Determine if this needs to be adjusted in order to match the style/flavor of your beer.
3) Individual Mineral Levels - Take note of which mineral levels need to be adjusted in order to fall within the recommended ranges shown. Alternatively you can try to match these levels to a particular region or other set of guidelines.
Step 3: Modify the results by making salt additions. The goal here is to get: 1) The RA to coincide with your recipe color, 2) The chloride to sulfate ratio to a desired flavored profile, and 3) The individual mineral levels to within recommended ranges.

Notes:

Add mash salts directly to the mash. Add sparge salts directly to the boil (not the sparge). You may choose not to add certain salts to the sparge water in order to keep some minerals lower in the total water (sodium for example). In this case, simply uncheck the appropriate box.

For an excellent video series about adjusting water using this spreadsheet (courtesy Bobby M), go here: Water Modification Videos, TH's Spreadsheet

For more information about how this works and why, I highly recommend reading John Palmer's entire chapter on water found here:
http://www.howtobrew.com/section3/chapter15.html

Source: The recommended mineral ranges, RA to SRM recommendations, and Cl to SO4 ratio recommendations are all based on John Palmer's RA spreadsheet and pH nomograph.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

Last edited by -TH-; 02-27-2010 at 01:12 AM. Reason: Version update
-TH- is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 04:40 PM   #2
EuBrew
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Columbus, OH
Posts: 491
Liked 4 Times on 3 Posts
Likes Given: 1

Default

So far this seems much easier to manage. One question, my water report does not have bicarbonate listed. It has total alkalinity (CACO3), Noncarbonate hardness (CACO3), and total hardness (CACO3). Which of these values do I plug into the bicarbonate level?

__________________
Primary 1: empty
Primary 2: empty
Primary 3: still at LHBS waiting for me to purchase
Secondary 1: empty
Secondary 2: empty
Secondary 3: empty

Kegged: New Belgium Ranger IPA Clone attempt #1
Bottled Southern Tier Pumking Clone

Planned: EdWort's haus pale ale
CBC Bodhi IPA



I may be naive but I make up for that with inexperience!!
EuBrew is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 04:44 PM   #3
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 977
Liked 59 Times on 35 Posts
Likes Given: 2

Default

Quote:
Originally Posted by EuBrew View Post
So far this seems much easier to manage. One question, my water report does not have bicarbonate listed. It has total alkalinity (CACO3), Noncarbonate hardness (CACO3), and total hardness (CACO3). Which of these values do I plug into the bicarbonate level?
Alkalinity. I'll note that on the spreadsheet.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com
-TH- is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 04:46 PM   #4
EuBrew
Feedback Score: 0 reviews
Recipes 
 
Join Date: Apr 2009
Location: Columbus, OH
Posts: 491
Liked 4 Times on 3 Posts
Likes Given: 1

Default

great resource, thanks for the work!!

__________________
Primary 1: empty
Primary 2: empty
Primary 3: still at LHBS waiting for me to purchase
Secondary 1: empty
Secondary 2: empty
Secondary 3: empty

Kegged: New Belgium Ranger IPA Clone attempt #1
Bottled Southern Tier Pumking Clone

Planned: EdWort's haus pale ale
CBC Bodhi IPA



I may be naive but I make up for that with inexperience!!
EuBrew is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 06:09 PM   #5
Schnitzengiggle
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2009
Location: Tucson, AZ
Posts: 2,664
Liked 29 Times on 22 Posts
Likes Given: 16

Default

Sweet spreadsheet, much more simplified than Palmer's. Nicely done!

__________________
follow me @ Broken Glass Brewery

Okham's Razor - simplest explanation is usually the correct one.

My DIY Kegerator - My DIY Fermentation Chamber - My DIY Portable Pump Box
Schnitzengiggle is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 06:11 PM   #6
The Pol
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2007
Posts: 11,616
Liked 54 Times on 51 Posts

Default

I use Brewater 3.0... it is fully automatic

It only asks for your starting water profile...

Then asks for your target water profile (it has a library of just about any profile you can imagine)

Once you select your target, you let it compute your salt additions itself. No trial and error... it will give you the salt amounts in grams or in tsp.

The only thing you have to do is tell it your starting water profile, then choose one of the many target water profiles... bam, it is done. I am personally not a big fan of slide rule type calculators.

Nice work though.

__________________

Last edited by The Pol; 09-03-2009 at 06:17 PM.
The Pol is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 06:55 PM   #7
wildwest450
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2007
Posts: 9,099
Liked 165 Times on 150 Posts
Likes Given: 4

Default

Quote:
Originally Posted by The Pol View Post
I use Brewater 3.0... it is fully automatic
It won't run in Vista.
__________________
wildwest450 is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 07:17 PM   #8
SpanishCastleAle
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2009
Location: Central Florida
Posts: 4,384
Liked 29 Times on 29 Posts

Default

Quote:
Originally Posted by -TH- View Post
Alkalinity. I'll note that on the spreadsheet.
But the Bicarbonate number and the CaCO3 number are not the same. Close but not the same number. I've never even tried a conversion between them so I don't know what it is.
__________________
Early brewers were primarily women, mostly because it was deemed a woman's job. Mesopotamian men, of some 3,800 years ago, were obviously complete assclowns and had yet to realize the pleasure of brewing beer.- Beer Advocate
SpanishCastleAle is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 07:24 PM   #9
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 977
Liked 59 Times on 35 Posts
Likes Given: 2

Default

Quote:
Originally Posted by SpanishCastleAle View Post
But the Bicarbonate number and the CaCO3 number are not the same. Close but not the same number. I've never even tried a conversion between them so I don't know what it is.
This is what I had noted on the spreadsheet:
Bicarbonate (HCO3) = Alkalinity
as CaCO3 x 60 / 52

It was a little unclear because of the text wrap not to mention it should have been 61 / 50.

Now it shows:
Bicarbonate (HCO3) = Alkalinity as CaCO3 x 1.22
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com

Last edited by -TH-; 09-03-2009 at 07:30 PM.
-TH- is offline
 
Reply With Quote Quick reply to this message
Old 09-03-2009, 07:52 PM   #10
Saccharomyces
Be good to your yeast...
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Saccharomyces's Avatar
Recipes 
 
Join Date: Jun 2008
Location: Pflugerville, Texas
Posts: 5,444
Liked 80 Times on 52 Posts
Likes Given: 2

Default

Quote:
Originally Posted by SpanishCastleAle View Post
But the Bicarbonate number and the CaCO3 number are not the same. Close but not the same number. I've never even tried a conversion between them so I don't know what it is.
The conversion depends on many factors, so the best bet is to get it straight from the report.

If you don't have your alkalinity, but you have total hardness, using the total hardness number is probably close enough. We are making beer, not atomic weapons.
__________________
[How to Calculate Mash Efficiency | Do I Need a Yeast Starter? | My Ghetto Fermentation Chamber | Twitter | 6 Gal. HDPE Fermenters | Slanting Yeast | No Sparge Brewing]

Quote:
Originally Posted by Soperbrew
big brother only monitors facebook and untappd
Saccharomyces is offline
 
Reply With Quote Quick reply to this message
Reply



Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Water Modification Videos, TH's Spreadsheet Bobby_M Brew Science 234 08-22-2011 03:44 PM
First try at water adjustment carp Brew Science 5 10-14-2009 12:32 AM
Water Adjustment? jgardner6 General Beer Discussion 5 08-11-2009 02:33 AM
Devising water recipes using Palmer's spreadsheet SpanishCastleAle General Techniques 0 02-22-2009 12:12 PM
water adjustment positiverpr Recipes/Ingredients 2 10-14-2008 03:09 PM