Kegconnection Complete Starter Kit and More Giveaway!


Home Brew Forums > Home Brewing Beer > Brew Science > EZ Water Adjustment spreadsheet

Reply
 
LinkBack Thread Tools
Old 01-15-2010, 03:29 AM   #131
GilaMinumBeer
In yo' garage, steelin' yo parts.
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
GilaMinumBeer's Avatar
Recipes 
 
Join Date: Jan 2008
Location: Oblivion
Posts: 47,031
Liked 4628 Times on 4311 Posts
Likes Given: 57

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 Quick reply to this message
Old 01-15-2010, 11:26 AM   #132
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 969
Liked 57 Times on 33 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- is offline
 
Reply With Quote Quick reply to this message
Old 01-15-2010, 01:13 PM   #133
GilaMinumBeer
In yo' garage, steelin' yo parts.
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
GilaMinumBeer's Avatar
Recipes 
 
Join Date: Jan 2008
Location: Oblivion
Posts: 47,031
Liked 4628 Times on 4311 Posts
Likes Given: 57

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 Quick reply to this message
Old 01-16-2010, 03: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 Quick reply to this message
Old 01-18-2010, 12:02 PM   #135
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 969
Liked 57 Times on 33 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- is offline
 
Reply With Quote Quick reply to this message
Old 01-18-2010, 03: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,317
Liked 7 Times on 7 Posts
Likes Given: 2

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 offline
 
Reply With Quote Quick reply to this message
Old 01-18-2010, 03: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 12 Times on 11 Posts
Likes Given: 1

Default

Uh oh...brewed a batch this weekend starting with RO water and this spread sheet....

__________________
www.facebook.com/shortsnoutbrewing
www.twitter.com/ShortSnoutBrew
www.shortsnoutbrewing.com
ShortSnoutBrewing is offline
 
Reply With Quote Quick reply to this message
Old 01-18-2010, 03:58 PM   #138
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 969
Liked 57 Times on 33 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 | Fermentation Chamber | Concrete-Roller Mill | Stirplate | Bottle Cabinet | Pneumatic Bottle Capper
Resources: www.EZWaterCalculator.com
-TH- is offline
 
Reply With Quote Quick reply to this message
Old 01-19-2010, 07:50 AM   #139
gxm
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2008
Location: Portland, OR
Posts: 556
Liked 6 Times on 5 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 Quick reply to this message
Old 01-21-2010, 06:21 PM   #140
-TH-
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Zeeland, Michigan
Posts: 969
Liked 57 Times on 33 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 | Fermentation Chamber | Concrete-Roller Mill | Stirplate | Bottle Cabinet | Pneumatic Bottle Capper
Resources: www.EZWaterCalculator.com
-TH- 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