Water Adjustment Spreadsheets

Mashing, fly sparging, batch sparging, dry hopping, late additions. Have an idea you want to bounce or stop by and share your experiences here.

Moderator: Post Moderators

Post Reply
User avatar
lexuschris
Posts: 2105
Joined: Sat Apr 25, 2009 7:08 pm
Location: Corona del Mar, CA
Contact:

Water Adjustment Spreadsheets

Post by lexuschris »

Hey all,

At the meeting this month, we got on a short discussion about water adjustments. Somebody (I think it was oc_eric) mentioned the Palmer spreadsheet, which can be a little daunting to start out with. I had found the attached 'EZ Water Adjustments.xls' on http://www.homebrewtalk.com a ways back, and have been using it exclusively. If your prone to try out water adjustments, this may be a decent way to get started...
EZ_water_adjustment.xls
(44.5 KiB) Downloaded 270 times
Enjoy! :happybeer:
--LexusChris
"A woman drove me to drink, and I hadn't even the courtesy to thank her." – W.C. Fields
User avatar
BrewMasterBrad
Pro Brewer
Posts: 3326
Joined: Thu Feb 09, 2006 12:31 pm
Location: Skyland Ale Works, Corona, CA
Contact:

Re: Water Adjustment Spreadsheets

Post by BrewMasterBrad »

I used to use Palmer's spreadsheet. The first step is getting your water tested at Ward Labs so you have a starting point for the spreadsheet. After using the spreadsheet for a while, I got a pretty good feel for making additions of gypsum, chalk, calcium chloride, etc. Now I just do it by feel, but I developed that feel by using the spreadsheet for almost a year. When I talked to Palmer about using the spreadsheet, he readily admitted that it is kind of a best guess type of thing anyway without doing a complete pH analysis on each batch.
I saw a werewolf drinking a pina colada down at Trader Vic's
User avatar
ScottK
Posts: 383
Joined: Sun Mar 15, 2009 11:18 pm
Location: Whittier, CA

Re: Water Adjustment Spreadsheets

Post by ScottK »

When getting your water tested at Ward Labs, do you want to test your straight tap water, or water that has run through your filter? My guess would be after you have filtered it, but then you might run into the issue of the filtered water changing if you needed to replace your filter or bought a new one, etc. How are you guys doing it?
I have not yet begun to defile myself.
User avatar
lexuschris
Posts: 2105
Joined: Sat Apr 25, 2009 7:08 pm
Location: Corona del Mar, CA
Contact:

Re: Water Adjustment Spreadsheets

Post by lexuschris »

I'm sure some folks do it differently, but I tested my cold tap water. Not the hot, because that goes through the water heater. I use my base water numbers from that sample.

Granted, some water districts will take more or less from some water sources over different parts of the year, so it very well could be a moving target. However, I believe (hope) that the differences are (on the whole) pretty small in comparison to the additions I might be making.

Usually, I am just using the additions for Relative Alkalinity, to help target a healthy mash pH. But in the case of my porter, and english browns, I wanted more hardness for mouthfeel. So I upped my chalk for the boil.

I have not tried to match a particular locale's numbers. I am really just tuning for a good RA and chloride ratio. And I usually try to find combos that ultimately mean smaller additions in total... just to be on the safe side...

--LexusChris
"A woman drove me to drink, and I hadn't even the courtesy to thank her." – W.C. Fields
User avatar
BrewMasterBrad
Pro Brewer
Posts: 3326
Joined: Thu Feb 09, 2006 12:31 pm
Location: Skyland Ale Works, Corona, CA
Contact:

Re: Water Adjustment Spreadsheets

Post by BrewMasterBrad »

I'm with Chris on this one since I am just trying to hit somewhere close to my target RA.

Scott, when I tested my water, I ran it through my carbon filter so it would be the same water that I brew with. The carbon filter, to the best of my knowledge, does not remove particulates and minerals, it only removes chlorine.
I saw a werewolf drinking a pina colada down at Trader Vic's
User avatar
ScottK
Posts: 383
Joined: Sun Mar 15, 2009 11:18 pm
Location: Whittier, CA

Re: Water Adjustment Spreadsheets

Post by ScottK »

Great. Good to know, thanks. I've had water issues in the past, which the filter has solved, but I'd like to look more into the issue.
I have not yet begun to defile myself.
floyd
Posts: 18
Joined: Thu Jul 16, 2009 6:02 pm

Re: Water Adjustment Spreadsheets

Post by floyd »

what do you guys think of this little web app?
http://www.bonniebluebrew.com/brewcalc/water.php

seemed pretty cool to me. my water is really hard so i've switched to using RO water and adding all my salts.
User avatar
brahn
Site Admin
Posts: 1799
Joined: Wed May 31, 2006 5:12 pm
Location: Tustin, CA
Contact:

Re: Water Adjustment Spreadsheets

Post by brahn »

That's a great way to go floyd, a lot of breweries start with RO water and build it up themselves. The downsides are that it's more expensive to buy RO water and with home RO units you would typically have to collect your water over several days.
Post Reply