Coldbreak Brewing HERMS Giveaway!

HomeBrewSupply AMCYL Brew Kettle Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet
Reply
 
Thread Tools
Old 01-15-2010, 04:29 AM   #131
GilaMinumBeer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
GilaMinumBeer's Avatar
Recipes 
 
Join Date: Jan 2008
Posts: 52,136
Liked 5840 Times on 5079 Posts
Likes Given: 80

Default

Okay. The spreadsheet as is adjusts based on 33%HCl (Hydrochloric Acid) or 88%C3H603 (Lactic Acid) and adjust RA accordingly.

BUT, I use a 75% H3PO4 (Phosphoric Acid). What do I need to change in the formulas to calculate this addition properly? Or, to just add H3PO4 as an option of the acids?


GilaMinumBeer is offline
 
Reply With Quote
Old 01-15-2010, 12:26 PM   #132
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 993
Liked 72 Times on 43 Posts
Likes Given: 2

Default

Quote:
Originally Posted by GilaMinumBeer View Post
Okay. The spreadsheet as is adjusts based on 33%HCl (Hydrochloric Acid) or 88%C3H603 (Lactic Acid) and adjust RA accordingly.

BUT, I use a 75% H3PO4 (Phosphoric Acid). What do I need to change in the formulas to calculate this addition properly? Or, to just add H3PO4 as an option of the acids?
Palmer's spreadsheet instructions say this:

"I do not recommend the use of Phosphoric Acid because it removes calcium from the water as well, and changes the water profile that you are trying to adjust. The amount of calcium removed is complex and I donít have a feedback loop in the spreadsheet to accommodate the effect."

I may have to avoid this one as well. However if you want to dig up some more info on the subject and it turns out to be not too complicated, I could possibly incorporate it.


__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com
-TH- is offline
 
Reply With Quote
Old 01-15-2010, 02:13 PM   #133
GilaMinumBeer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
GilaMinumBeer's Avatar
Recipes 
 
Join Date: Jan 2008
Posts: 52,136
Liked 5840 Times on 5079 Posts
Likes Given: 80

Default

Quote:
Originally Posted by -TH- View Post
Palmer's spreadsheet instructions say this:

"I do not recommend the use of Phosphoric Acid because it removes calcium from the water as well, and changes the water profile that you are trying to adjust. The amount of calcium removed is complex and I donít have a feedback loop in the spreadsheet to accommodate the effect."

I may have to avoid this one as well. However if you want to dig up some more info on the subject and it turns out to be not too complicated, I could possibly incorporate it.
Yeah. My problem is that my starting pH is so base that the amount of Lactic or Citric Acid I need to balance it results in a sour twinge to the water.

Thought about HCl but, too many here were too adamant about Phosphoric and I had troubles finding a good product for brewing. So, I settled on a gallon of the ole' H3PO4. I can always add Calcium.
GilaMinumBeer is offline
 
Reply With Quote
Old 01-16-2010, 04:26 PM   #134
hopvine
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2009
Location: Holland, MI
Posts: 264
Liked 5 Times on 5 Posts

Default

I'm starting with RO water. The Bicarbonate and Alkalinity levels of the water are both 0, however depending on whether I have Bicarbonate or Alkalinity selected in my "Starting Water Profile", my Residual Alkalinity changes drastically (from 87 with Bicarbonate set to zero, to 129 with Alkalinity set to zero). Why does this change? Which value should I believe?
hopvine is offline
 
Reply With Quote
Old 01-18-2010, 01:02 PM   #135
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 993
Liked 72 Times on 43 Posts
Likes Given: 2

Default

Thank you hopvine! There was indeed a calculation error. I have fixed it now so please re-download and try again.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com
-TH- is offline
 
Reply With Quote
Old 01-18-2010, 04:25 PM   #136
RonRock
Always Ready
HBT_LIFETIMESUPPORTER.png
Feedback Score: 1 reviews
 
RonRock's Avatar
Recipes 
 
Join Date: Jul 2008
Location: Underwood, Iowa
Posts: 1,324
Liked 8 Times on 8 Posts
Likes Given: 3

Default

Quote:
Originally Posted by -TH- View Post
Thank you hopvine! There was indeed a calculation error. I have fixed it now so please re-download and try again.

Does this effect all users of the spreadsheet? Should we update?
RonRock is online now
 
Reply With Quote
Old 01-18-2010, 04:27 PM   #137
ShortSnoutBrewing
Kwanesum Chinook Illahee
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
ShortSnoutBrewing's Avatar
Recipes 
 
Join Date: Oct 2007
Location: Portland, OR
Posts: 3,266
Liked 17 Times on 16 Posts
Likes Given: 1

Default

Uh oh...brewed a batch this weekend starting with RO water and this spread sheet....
ShortSnoutBrewing is offline
 
Reply With Quote
Old 01-18-2010, 04:58 PM   #138
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 993
Liked 72 Times on 43 Posts
Likes Given: 2

Default

Quote:
Originally Posted by RonRock View Post
Does this effect all users of the spreadsheet? Should we update?
I would recommend all users update. The spreadsheet was miscalculating the alkalinity of the salt additions if you had "Alkalinity from CaCO3" checked in the starting water. If you had "Bicarbonate" selected (the default), there was no error.
__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com
-TH- is offline
 
Reply With Quote
Old 01-19-2010, 08:50 AM   #139
gxm
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2008
Location: Portland, OR
Posts: 556
Liked 7 Times on 6 Posts
Likes Given: 1

Default

Thanks for the spreadsheet, TH. This makes much more sense to me than the nomographs
gxm is offline
 
Reply With Quote
Old 01-21-2010, 07:21 PM   #140
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 993
Liked 72 Times on 43 Posts
Likes Given: 2

Default

1-21-10: I re-wrote the instructions and changed the labels & colors of some of the fields to make things a little easier to understand for first-time users. But those of you who already use it might want to check it out too. If not, at least make sure you are at Version 1.6 or higher because there was a bug in previous versions.


__________________
TH

Builds, etc: E-Brewery | Pneumatic Bottle Capper | Fermentation Chamber | Stirplate | Bottle Cabinet
Water Spreadsheet: www.EZWaterCalculator.com
-TH- is offline
 
Reply With Quote
Reply


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 01:12 PM
water adjustment positiverpr Recipes/Ingredients 2 10-14-2008 03:09 PM


Forum Jump

Newest Threads

LATEST SPONSOR DEALS