Happy HolidaySs Giveaway - Last Sponsor Giveaway of the Year!

Come Enter the BrewDeals/FastFerment Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > Use of Palmer's spreadsheet
Reply
 
LinkBack Thread Tools
Old 02-17-2011, 05:23 PM   #1
bbeckett
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2010
Location: West Des Moines, Iowa
Posts: 8
Default Use of Palmer's spreadsheet

I am attempting to use Palmer's spreadsheet to calculate water quality adjustments and want to make sure I am interpreting the results/adjusting properly. I am brewing a Belgian Wit, and therefore looking for a more "balanced" profile. I am targeting an SRM of 3 (2-4 per BCBJ style guidlines), and will have a mash with 8 lbs of total grain and ~15qts of water.

Calcium 26
Magnesium 18
Alkalinity as CaCO3 72
Sodium 170
Chloride 83
Sulfate 310
pH 9.2

I believe to achieve my target I will need to add approx 5 grams of calcium chloride. I was wondering if this is too much chloride in the end? However, Palmer notes the chloride to sulfate ratio to be important, given the high sulfate level of the water supply, maybe the additional chloride is appropriate.

All thoughts are greatly appreciated, thank you in advance.

__________________
bbeckett is offline
 
Reply With Quote Quick reply to this message
Old 02-17-2011, 05:52 PM   #2
remilard
Feedback Score: 0 reviews
Recipes 
 
Join Date: Nov 2008
Location: Kansas City
Posts: 3,655
Liked 39 Times on 38 Posts

Default

Most people who have written original work about water (and I say original because a lot of what is written for US homebrewers has uncritically copied niche English ideas) do not hold that the ratio of sulfate to chloride is important. Most believe the absolute levels are important.

If I were you I would be diluting with low ion water (eg RO) to lower the sulfate (and sodium) and not think about adding more to that water.

Also note that you'll need acid to lower the mash pH with that water (almost any water) for an all or mostly Pilsner malt beer. If you are making a belgian wit there are a lot of reasons to make the source of acid lactic. 3% of the grist as sauermalz would be an easy way to get it and get you in the right ballpark pH wise.

__________________
remilard is offline
 
Reply With Quote Quick reply to this message
Old 02-17-2011, 10:29 PM   #3
bbeckett
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2010
Location: West Des Moines, Iowa
Posts: 8
Default

That is exactly what I was looking for. Much appreciated!

__________________
bbeckett 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
EZ Water Adjustment spreadsheet -TH- Brew Science 194 04-01-2012 06:13 AM
Question regarding TH's spreadsheet CPooley4 Brew Science 7 06-22-2010 10:54 PM
Braukaiser Spreadsheet CritterBitter Brew Science 1 05-26-2010 01:28 AM
Does TH's SpreadSheet Dilution Inc. Sparge? Netflyer Brew Science 3 02-26-2010 06:28 PM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 09:26 PM



Newest Threads

LATEST SPONSOR DEALS